Gecko [ www.foryou-vip.com ]

Name	Size	Permission	Date
cache	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
controller	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
db	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
exception	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
helper	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
log	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
module	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
order	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
pdf	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
range	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
shop	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
stock	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
tax	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
tree	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
webservice	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
.htaccess	510 B	-rwxrwxrwx	2023-01-18 07:38
Address.php	16.32 KB	-rwxrwxrwx	2019-04-30 18:42
AddressFormat.php	22.17 KB	-rwxrwxrwx	2019-04-30 18:42
AdminTab.php	115.85 KB	-rwxrwxrwx	2019-04-30 18:42
Alias.php	4.41 KB	-rwxrwxrwx	2019-04-30 18:42
Attachment.php	6.57 KB	-rwxrwxrwx	2019-04-30 18:42
Attribute.php	12.62 KB	-rwxrwxrwx	2019-04-30 18:42
AttributeGroup.php	11.49 KB	-rwxrwxrwx	2019-04-30 18:42
Blowfish.php	21.79 KB	-rwxrwxrwx	2019-04-30 18:42
CMS.php	8.98 KB	-rwxrwxrwx	2019-04-30 18:42
CMSCategory.php	23.42 KB	-rwxrwxrwx	2019-04-30 18:42
CMSRole.php	1.61 KB	-rwxrwxrwx	2019-04-30 18:42
CSV.php	2.89 KB	-rwxrwxrwx	2019-04-30 18:42
Carrier.php	55.24 KB	-rwxrwxrwx	2019-04-30 18:42
Cart.php	167.24 KB	-rwxrwxrwx	2019-04-30 18:42
CartRule.php	70 KB	-rwxrwxrwx	2019-04-30 18:42
Category.php	68.83 KB	-rwxrwxrwx	2019-04-30 18:42
Chart.php	5.36 KB	-rwxrwxrwx	2019-04-30 18:42
Combination.php	11.54 KB	-rwxrwxrwx	2019-04-30 18:42
CompareProduct.php	5.06 KB	-rwxrwxrwx	2019-04-30 18:42
Configuration.php	22.73 KB	-rwxrwxrwx	2019-04-30 18:42
ConfigurationKPI.php	5.49 KB	-rwxrwxrwx	2019-04-30 18:42
ConfigurationTest.php	10.66 KB	-rwxrwxrwx	2019-04-30 18:42
Connection.php	9.69 KB	-rwxrwxrwx	2019-04-30 18:42
ConnectionsSource.php	5.02 KB	-rwxrwxrwx	2019-04-30 18:42
Contact.php	3.26 KB	-rwxrwxrwx	2019-04-30 18:42
Context.php	7.29 KB	-rwxrwxrwx	2019-04-30 18:42
ControllerFactory.php	2.16 KB	-rwxrwxrwx	2019-04-30 18:42
Cookie.php	13.04 KB	-rwxrwxrwx	2019-04-30 18:42
Country.php	14.07 KB	-rwxrwxrwx	2019-04-30 18:42
County.php	3.65 KB	-rwxrwxrwx	2019-04-30 18:42
Currency.php	15.33 KB	-rwxrwxrwx	2019-04-30 18:42
Customer.php	32.46 KB	-rwxrwxrwx	2019-04-30 18:42
CustomerMessage.php	4.33 KB	-rwxrwxrwx	2019-04-30 18:42
CustomerThread.php	8.04 KB	-rwxrwxrwx	2019-04-30 18:42
Customization.php	9.72 KB	-rwxrwxrwx	2019-04-30 18:42
CustomizationField.php	2.33 KB	-rwxrwxrwx	2019-04-30 18:42
DateRange.php	2.23 KB	-rwxrwxrwx	2019-04-30 18:42
Delivery.php	3.12 KB	-rwxrwxrwx	2019-04-30 18:42
Discount.php	8.97 KB	-rwxrwxrwx	2019-04-30 18:42
Dispatcher.php	36.2 KB	-rwxrwxrwx	2019-04-30 18:42
Employee.php	16.38 KB	-rwxrwxrwx	2019-04-30 18:42
Feature.php	10.6 KB	-rwxrwxrwx	2019-04-30 18:42
FeatureValue.php	6.66 KB	-rwxrwxrwx	2019-04-30 18:42
FileUploader.php	11.06 KB	-rwxrwxrwx	2019-04-30 18:42
Gender.php	2.25 KB	-rwxrwxrwx	2019-04-30 18:42
Group.php	12.98 KB	-rwxrwxrwx	2019-04-30 18:42
GroupReduction.php	9.33 KB	-rwxrwxrwx	2019-04-30 18:42
Guest.php	7.27 KB	-rwxrwxrwx	2019-04-30 18:42
Hook.php	30.84 KB	-rwxrwxrwx	2019-04-30 18:42
Image.php	27.35 KB	-rwxrwxrwx	2019-04-30 18:42
ImageManager.php	21.9 KB	-rwxrwxrwx	2019-04-30 18:42
ImageType.php	6.14 KB	-rwxrwxrwx	2019-04-30 18:42
Language.php	39.76 KB	-rwxrwxrwx	2019-04-30 18:42
Link.php	29.46 KB	-rwxrwxrwx	2019-04-30 18:42
LocalizationPack.php	19.08 KB	-rwxrwxrwx	2019-04-30 18:42
Mail.php	24.81 KB	-rwxrwxrwx	2019-04-30 18:42
Manufacturer.php	17.13 KB	-rwxrwxrwx	2019-04-30 18:42
Media.php	39.73 KB	-rwxrwxrwx	2019-04-30 18:42
Message.php	5.65 KB	-rwxrwxrwx	2019-04-30 18:42
Meta.php	17.5 KB	-rwxrwxrwx	2019-04-30 18:42
Notification.php	6.08 KB	-rwxrwxrwx	2019-04-30 18:42
ObjectModel.php	69.64 KB	-rwxrwxrwx	2019-04-30 18:42
Pack.php	17.82 KB	-rwxrwxrwx	2019-04-30 18:42
Page.php	4.2 KB	-rwxrwxrwx	2019-04-30 18:42
PaymentCC.php	2.49 KB	-rwxrwxrwx	2019-04-30 18:42
PaymentModule.php	53.64 KB	-rwxrwxrwx	2019-04-30 18:42
PrestaShopAutoload.php	8.31 KB	-rwxrwxrwx	2019-04-30 18:42
PrestaShopBackup.php	10.53 KB	-rwxrwxrwx	2019-04-30 18:42
PrestaShopCollection.php	20.43 KB	-rwxrwxrwx	2019-04-30 18:42
PrestaShopLogger.php	6.07 KB	-rwxrwxrwx	2019-04-30 18:42
Product.php	232.97 KB	-rwxrwxrwx	2019-04-30 18:42
ProductDownload.php	9.86 KB	-rwxrwxrwx	2019-04-30 18:42
ProductSale.php	11.37 KB	-rwxrwxrwx	2019-04-30 18:42
ProductSupplier.php	7.63 KB	-rwxrwxrwx	2019-04-30 18:42
Profile.php	5.19 KB	-rwxrwxrwx	2019-04-30 18:42
QuickAccess.php	2.58 KB	-rwxrwxrwx	2019-04-30 18:42
Referrer.php	16.19 KB	-rwxrwxrwx	2019-04-30 18:42
RequestSql.php	19.64 KB	-rwxrwxrwx	2019-04-30 18:42
Rijndael.php	4.88 KB	-rwxrwxrwx	2019-04-30 18:42
Risk.php	2.35 KB	-rwxrwxrwx	2019-04-30 18:42
Scene.php	9.85 KB	-rwxrwxrwx	2019-04-30 18:42
Search.php	38.85 KB	-rwxrwxrwx	2019-04-30 18:42
SearchEngine.php	2.57 KB	-rwxrwxrwx	2019-04-30 18:42
SmartyCacheResourceMysql.php	4.76 KB	-rwxrwxrwx	2019-04-30 18:42
SmartyCustom.php	12.28 KB	-rwxrwxrwx	2019-04-30 18:42
SpecificPrice.php	22.79 KB	-rwxrwxrwx	2019-04-30 18:42
SpecificPriceRule.php	13.64 KB	-rwxrwxrwx	2019-04-30 18:42
State.php	6.65 KB	-rwxrwxrwx	2019-04-30 18:42
Store.php	4.82 KB	-rwxrwxrwx	2019-04-30 18:42
Supplier.php	15.21 KB	-rwxrwxrwx	2019-04-30 18:42
Tab.php	19.1 KB	-rwxrwxrwx	2019-04-30 18:42
Tag.php	10.19 KB	-rwxrwxrwx	2019-04-30 18:42
Theme.php	12.58 KB	-rwxrwxrwx	2019-04-30 18:42
Tools.php	130.71 KB	-rwxrwxrwx	2019-04-30 18:42
Translate.php	11.48 KB	-rwxrwxrwx	2019-04-30 18:42
TranslatedConfiguration.php	3.99 KB	-rwxrwxrwx	2019-04-30 18:42
Upgrader.php	11.02 KB	-rwxrwxrwx	2019-04-30 18:42
Uploader.php	8.47 KB	-rwxrwxrwx	2019-04-30 18:42
Validate.php	31.72 KB	-rwxrwxrwx	2019-04-30 18:42
Zone.php	3.17 KB	-rwxrwxrwx	2019-04-30 18:42
index.php	29.14 KB	-rwxrwxrwx	2023-01-18 07:38

Rename

<?php
/**
 * 2007-2017 PrestaShop
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Open Software License (OSL 3.0)
 * that is bundled with this package in the file LICENSE.txt.
 * It is also available through the world-wide-web at this URL:
 * http://opensource.org/licenses/osl-3.0.php
 * If you did not receive a copy of the license and are unable to
 * obtain it through the world-wide-web, please send an email
 * to license@prestashop.com so we can send you a copy immediately.
 *
 * DISCLAIMER
 *
 * Do not edit or add to this file if you wish to upgrade PrestaShop to newer
 * versions in the future. If you wish to customize PrestaShop for your
 * needs please refer to http://www.prestashop.com for more information.
 *
 *  @author 	PrestaShop SA <contact@prestashop.com>
 *  @copyright  2007-2017 PrestaShop SA
 *  @license    http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)
 *  International Registered Trademark & Property of PrestaShop SA
 */

class AddressCore extends ObjectModel
{
    /** @var int Customer id which address belongs to */
    public $id_customer = null;

/** @var int Manufacturer id which address belongs to */
    public $id_manufacturer = null;

/** @var int Supplier id which address belongs to */
    public $id_supplier = null;

/**
     * @since 1.5.0
     * @var int Warehouse id which address belongs to
     */
    public $id_warehouse = null;

/** @var int Country id */
    public $id_country;

/** @var int State id */
    public $id_state;

/** @var string Country name */
    public $country;

/** @var string Alias (eg. Home, Work...) */
    public $alias;

/** @var string Company (optional) */
    public $company;

/** @var string Lastname */
    public $lastname;

/** @var string Firstname */
    public $firstname;

/** @var string Address first line */
    public $address1;

/** @var string Address second line (optional) */
    public $address2;

/** @var string Postal code */
    public $postcode;

/** @var string City */
    public $city;

/** @var string Any other useful information */
    public $other;

/** @var string Phone number */
    public $phone;

/** @var string Mobile phone number */
    public $phone_mobile;

/** @var string VAT number */
    public $vat_number;

/** @var string DNI number */
    public $dni;

/** @var string Object creation date */
    public $date_add;

/** @var string Object last modification date */
    public $date_upd;

/** @var bool True if address has been deleted (staying in database as deleted) */
    public $deleted = 0;

protected static $_idZones = array();
    protected static $_idCountries = array();

/**
     * @see ObjectModel::$definition
     */
    public static $definition = array(
        'table' => 'address',
        'primary' => 'id_address',
        'fields' => array(
            'id_customer' =>        array('type' => self::TYPE_INT, 'validate' => 'isNullOrUnsignedId', 'copy_post' => false),
            'id_manufacturer' =>    array('type' => self::TYPE_INT, 'validate' => 'isNullOrUnsignedId', 'copy_post' => false),
            'id_supplier' =>        array('type' => self::TYPE_INT, 'validate' => 'isNullOrUnsignedId', 'copy_post' => false),
            'id_warehouse' =>        array('type' => self::TYPE_INT, 'validate' => 'isNullOrUnsignedId', 'copy_post' => false),
            'id_country' =>        array('type' => self::TYPE_INT, 'validate' => 'isUnsignedId', 'required' => true),
            'id_state' =>            array('type' => self::TYPE_INT, 'validate' => 'isNullOrUnsignedId'),
            'alias' =>                array('type' => self::TYPE_STRING, 'validate' => 'isGenericName', 'required' => true, 'size' => 32),
            'company' =>            array('type' => self::TYPE_STRING, 'validate' => 'isGenericName', 'size' => 255),
            'lastname' =>            array('type' => self::TYPE_STRING, 'validate' => 'isName', 'required' => true, 'size' => 32),
            'firstname' =>            array('type' => self::TYPE_STRING, 'validate' => 'isName', 'required' => true, 'size' => 32),
            'vat_number' =>            array('type' => self::TYPE_STRING, 'validate' => 'isGenericName'),
            'address1' =>            array('type' => self::TYPE_STRING, 'validate' => 'isAddress', 'required' => true, 'size' => 128),
            'address2' =>            array('type' => self::TYPE_STRING, 'validate' => 'isAddress', 'size' => 128),
            'postcode' =>            array('type' => self::TYPE_STRING, 'validate' => 'isPostCode', 'size' => 12),
            'city' =>                array('type' => self::TYPE_STRING, 'validate' => 'isCityName', 'required' => true, 'size' => 64),
            'other' =>                array('type' => self::TYPE_STRING, 'validate' => 'isMessage', 'size' => 300),
            'phone' =>                array('type' => self::TYPE_STRING, 'validate' => 'isPhoneNumber', 'size' => 32),
            'phone_mobile' =>        array('type' => self::TYPE_STRING, 'validate' => 'isPhoneNumber', 'size' => 32),
            'dni' =>                array('type' => self::TYPE_STRING, 'validate' => 'isDniLite', 'size' => 16),
            'deleted' =>            array('type' => self::TYPE_BOOL, 'validate' => 'isBool', 'copy_post' => false),
            'date_add' =>            array('type' => self::TYPE_DATE, 'validate' => 'isDate', 'copy_post' => false),
            'date_upd' =>            array('type' => self::TYPE_DATE, 'validate' => 'isDate', 'copy_post' => false),
        ),
    );

protected $_includeVars = array('addressType' => 'table');
    protected $_includeContainer = false;

protected $webserviceParameters = array(
        'objectsNodeName' => 'addresses',
        'fields' => array(
            'id_customer' => array('xlink_resource'=> 'customers'),
            'id_manufacturer' => array('xlink_resource'=> 'manufacturers'),
            'id_supplier' => array('xlink_resource'=> 'suppliers'),
            'id_warehouse' => array('xlink_resource'=> 'warehouse'),
            'id_country' => array('xlink_resource'=> 'countries'),
            'id_state' => array('xlink_resource'=> 'states'),
        ),
    );

/**
     * Build an address
     *
     * @param int $id_address Existing address id in order to load object (optional)
     */
    public function __construct($id_address = null, $id_lang = null)
    {
        parent::__construct($id_address);

/* Get and cache address country name */
        if ($this->id) {
            $this->country = Country::getNameById($id_lang ? $id_lang : Configuration::get('PS_LANG_DEFAULT'), $this->id_country);
        }
    }

/**
     * @see ObjectModel::add()
     */
    public function add($autodate = true, $null_values = false)
    {
        if (!parent::add($autodate, $null_values)) {
            return false;
        }

if (Validate::isUnsignedId($this->id_customer)) {
            Customer::resetAddressCache($this->id_customer, $this->id);
        }
        return true;
    }

public function update($null_values = false)
    {
        // Empty related caches
        if (isset(self::$_idCountries[$this->id])) {
            unset(self::$_idCountries[$this->id]);
        }
        if (isset(self::$_idZones[$this->id])) {
            unset(self::$_idZones[$this->id]);
        }

if (Validate::isUnsignedId($this->id_customer)) {
            Customer::resetAddressCache($this->id_customer, $this->id);
        }

return parent::update($null_values);
    }

/**
     * @see ObjectModel::delete()
     */
    public function delete()
    {
        if (Validate::isUnsignedId($this->id_customer)) {
            Customer::resetAddressCache($this->id_customer, $this->id);
        }

if (!$this->isUsed()) {
            return parent::delete();
        } else {
            $this->deleted = true;
            return $this->update();
        }
    }

/**
    * Returns fields required for an address in an array hash
    * @return array hash values
    */
    public static function getFieldsValidate()
    {
        $tmp_addr = new Address();
        $out = $tmp_addr->fieldsValidate;

unset($tmp_addr);
        return $out;
    }

/**
     * @see ObjectModel::validateController()
     */
    public function validateController($htmlentities = true)
    {
        $errors = parent::validateController($htmlentities);
        if (!Configuration::get('VATNUMBER_MANAGEMENT') || !Configuration::get('VATNUMBER_CHECKING')) {
            return $errors;
        }
        include_once(_PS_MODULE_DIR_.'vatnumber/vatnumber.php');
        if (class_exists('VatNumber', false)) {
            return array_merge($errors, VatNumber::WebServiceCheck($this->vat_number));
        }
        return $errors;
    }
    /**
     * Get zone id for a given address
     *
     * @param int $id_address Address id for which we want to get zone id
     * @return int Zone id
     */
    public static function getZoneById($id_address)
    {
        if (!isset($id_address) || empty($id_address)) {
            return false;
        }

if (isset(self::$_idZones[$id_address])) {
            return self::$_idZones[$id_address];
        }

$id_zone = Hook::exec('actionGetIDZoneByAddressID', array('id_address' => $id_address));

if (is_numeric($id_zone)) {
            self::$_idZones[$id_address] = (int)$id_zone;
            return self::$_idZones[$id_address];
        }

$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->getRow('
			SELECT s.`id_zone` AS id_zone_state, c.`id_zone`
			FROM `'._DB_PREFIX_.'address` a
			LEFT JOIN `'._DB_PREFIX_.'country` c ON c.`id_country` = a.`id_country`
			LEFT JOIN `'._DB_PREFIX_.'state` s ON s.`id_state` = a.`id_state`
			WHERE a.`id_address` = '.(int)$id_address);

self::$_idZones[$id_address] = (int)((int)$result['id_zone_state'] ? $result['id_zone_state'] : $result['id_zone']);
        return self::$_idZones[$id_address];
    }

/**
     * Check if country is active for a given address
     *
     * @param int $id_address Address id for which we want to get country status
     * @return int Country status
     */
    public static function isCountryActiveById($id_address)
    {
        if (!isset($id_address) || empty($id_address)) {
            return false;
        }

$cache_id = 'Address::isCountryActiveById_'.(int)$id_address;
        if (!Cache::isStored($cache_id)) {
            $result = (bool)Db::getInstance(_PS_USE_SQL_SLAVE_)->getvalue('
			SELECT c.`active`
			FROM `'._DB_PREFIX_.'address` a
			LEFT JOIN `'._DB_PREFIX_.'country` c ON c.`id_country` = a.`id_country`
			WHERE a.`id_address` = '.(int)$id_address);
            Cache::store($cache_id, $result);
            return $result;
        }
        return Cache::retrieve($cache_id);
    }

/**
     * Check if address is used (at least one order placed)
     *
     * @return int Order count for this address
     */
    public function isUsed()
    {
        $result = (int)Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue('
		SELECT COUNT(`id_order`) AS used
		FROM `'._DB_PREFIX_.'orders`
		WHERE `id_address_delivery` = '.(int)$this->id.'
		OR `id_address_invoice` = '.(int)$this->id);

return $result > 0 ? (int)$result : false;
    }

public static function getCountryAndState($id_address)
    {
        if (isset(self::$_idCountries[$id_address])) {
            return self::$_idCountries[$id_address];
        }
        if ($id_address) {
            $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->getRow('
			SELECT `id_country`, `id_state`, `vat_number`, `postcode` FROM `'._DB_PREFIX_.'address`
			WHERE `id_address` = '.(int)$id_address);
        } else {
            $result = false;
        }
        self::$_idCountries[$id_address] = $result;
        return $result;
    }

/**
    * Specify if an address is already in base
    *
    * @param int $id_address Address id
    * @return bool
    */
    public static function addressExists($id_address)
    {
        $key = 'address_exists_'.(int)$id_address;
        if (!Cache::isStored($key)) {
            $id_address = Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue('SELECT `id_address` FROM '._DB_PREFIX_.'address a WHERE a.`id_address` = '.(int)$id_address);
            Cache::store($key, (bool)$id_address);
            return (bool)$id_address;
        }
        return Cache::retrieve($key);
    }

public static function getFirstCustomerAddressId($id_customer, $active = true)
    {
        if (!$id_customer) {
            return false;
        }
        $cache_id = 'Address::getFirstCustomerAddressId_'.(int)$id_customer.'-'.(bool)$active;
        if (!Cache::isStored($cache_id)) {
            $result = (int)Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue('
				SELECT `id_address`
				FROM `'._DB_PREFIX_.'address`
				WHERE `id_customer` = '.(int)$id_customer.' AND `deleted` = 0'.($active ? ' AND `active` = 1' : '')
            );
            Cache::store($cache_id, $result);
            return $result;
        }
        return Cache::retrieve($cache_id);
    }

/**
     * Initiliaze an address corresponding to the specified id address or if empty to the
     * default shop configuration
     *
     * @param int $id_address
     * @param bool $with_geoloc
     * @return Address address
     *
     * @throws PrestaShopException
     */
    public static function initialize($id_address = null, $with_geoloc = false)
    {
        $context = Context::getContext();
        $exists = (int)$id_address && (bool)Address::addressExists($id_address);
        if ($exists) {
            $context_hash = (int)$id_address;
        } elseif ($with_geoloc && isset($context->customer->geoloc_id_country)) {
            $context_hash = md5((int)$context->customer->geoloc_id_country.'-'.(int)$context->customer->id_state.'-'.
                                $context->customer->postcode);
        } else {
            $context_hash = md5((int)$context->country->id);
        }

$cache_id = 'Address::initialize_'.$context_hash;

if (!Cache::isStored($cache_id)) {
            // if an id_address has been specified retrieve the address
            if ($exists) {
                $address = new Address((int)$id_address);

if (!Validate::isLoadedObject($address)) {
                    throw new PrestaShopException('Invalid address #'.(int)$id_address);
                }
            } elseif ($with_geoloc && isset($context->customer->geoloc_id_country)) {
                $address             = new Address();
                $address->id_country = (int)$context->customer->geoloc_id_country;
                $address->id_state   = (int)$context->customer->id_state;
                $address->postcode   = $context->customer->postcode;
            } else {
                // set the default address
                $address             = new Address();
                $address->id_country = (int)$context->country->id;
                $address->id_state   = 0;
                $address->postcode   = 0;
            }
            Cache::store($cache_id, $address);
            return $address;
        }
        return Cache::retrieve($cache_id);
    }

/**
     * Returns id_address for a given id_supplier
     * @since 1.5.0
     * @param int $id_supplier
     * @return int $id_address
     */
    public static function getAddressIdBySupplierId($id_supplier)
    {
        $query = new DbQuery();
        $query->select('id_address');
        $query->from('address');
        $query->where('id_supplier = '.(int)$id_supplier);
        $query->where('deleted = 0');
        $query->where('id_customer = 0');
        $query->where('id_manufacturer = 0');
        $query->where('id_warehouse = 0');
        return Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($query);
    }

public static function aliasExist($alias, $id_address, $id_customer)
    {
        $query = new DbQuery();
        $query->select('count(*)');
        $query->from('address');
        $query->where('alias = \''.pSQL($alias).'\'');
        $query->where('id_address != '.(int)$id_address);
        $query->where('id_customer = '.(int)$id_customer);
        $query->where('deleted = 0');

return Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($query);
    }

public function getFieldsRequiredDB()
    {
        $this->cacheFieldsRequiredDatabase(false);
        if (isset(self::$fieldsRequiredDatabase['Address'])) {
            return self::$fieldsRequiredDatabase['Address'];
        }
        return array();
    }
}