<?php



/**

  * Addresses tab for admin panel, AdminAddresses.php

  * @category admin

  *

  * @author PrestaShop <support@prestashop.com>

  * @copyright PrestaShop

  * @license http://www.opensource.org/licenses/osl-3.0.php Open-source licence 3.0

  * @version 1.0

  *

  */



include_once(PS_ADMIN_DIR.'/../classes/AdminTab.php');



class AdminAddresses extends AdminTab

{

	/** @var array countries list */

	private $countriesArray = array();



	/** @var array State list */

	private $stateList = array();

	

	public function __construct()

	{

	 	global $cookie;

	 	

	 	$this->table = 'address';

	 	$this->className = 'Address';

	 	$this->lang = false;

	 	$this->edit = true;

		$this->addressType = 'customer';

		

		if (!Tools::getValue('realedit'))

			$this->deleted = true;

		$this->_select = 'cl.`name` as country';

		$this->_join = 'LEFT JOIN `'._DB_PREFIX_.'country_lang` cl ON 

		(cl.`id_country` = a.`id_country` AND cl.`id_lang` = '.intval($cookie->id_lang).')';

		

		$countries = Country::getCountries(intval($cookie->id_lang));

		foreach ($countries AS $country)

			$this->countriesArray[$country['id_country']] = $country['name'];

		$this->stateList = State::getStates(intval($cookie->id_lang));

				

		$this->fieldsDisplay = array(

		'id_address' => array('title' => $this->l('ID'), 'align' => 'center', 'width' => 25),

		'firstname' => array('title' => $this->l('First name'), 'width' => 80),

		'lastname' => array('title' => $this->l('Last name'), 'width' => 100, 'filter_key' => 'a!name'),

		'address1' => array('title' => $this->l('Address'), 'width' => 200),

		'postcode' => array('title' => $this->l('Post/Zip code'), 'align' => 'right', 'width' => 50),

		'city' => array('title' => $this->l('City'), 'width' => 150),

		'country' => array('title' => $this->l('Country'), 'width' => 100, 'type' => 'select', 'select' => $this->countriesArray, 'filter_key' => 'cl!id_country'));



		parent::__construct();

	}

	

	public function postProcess()

	{

		if (isset($_POST['submitAdd'.$this->table]))

		{

			/* Transform e-mail in id_customer for parent processing */

			if ($this->addressType == 'customer')

			{

				if (Validate::isEmail(Tools::getValue('email')))

				{

					$customer = new Customer;

					$customer = $customer->getByemail(Tools::getValue('email'));

					if (Validate::isLoadedObject($customer))

						$_POST['id_customer'] = $customer->id;

					else

						$this->_errors[] = Tools::displayError('this e-mail address is not registered');

				}

				else

					$this->_errors[] = Tools::displayError('customer e-mail address is not valid');

			}

			

			// Check manufacturer selected

			elseif ($this->addressType == 'manufacturer')

			{

				$manufacturer = new Manufacturer(intval(Tools::getValue('id_manufacturer')));

				if (!Validate::isLoadedObject($manufacturer))

					$this->_errors[] = Tools::displayError('manufacturer selected is not valid');

			}



			/* If the selected country does not contain states */

			$id_state = intval(Tools::getValue('id_state'));

			if ($id_country = Tools::getValue('id_country') AND $country = new Country(intval($id_country)) AND !intval($country->contains_states) AND $id_state)

				$this->_errors[] = Tools::displayError('you have selected a state for a country that does not contain states');



			/* If the selected country contains states, then a state have to be selected */

			if (intval($country->contains_states) AND !$id_state)

				$this->_errors[] = Tools::displayError('an address which is located in a country containing states must have a state selected');



			/* If this address come from order's edition and is the same as the other one (invoice or delivery one)

			** we delete its id_address to force the creation of a new one */

			if (intval(Tools::getValue('id_order')))

			{

				$this->_redirect = false;

				if (isset($_POST['address_type']))

					$_POST['id_address'] = '';

			}

		}

		if (!sizeof($this->_errors))

			parent::postProcess();

			

		/* Reassignation of the order's new (invoice or delivery) address */

		$address_type = (intval(Tools::getValue('address_type')) == 2 ? 'invoice' : (intval(Tools::getValue('address_type')) == 1 ? 'delivery' : ''));

		if (isset($_POST['submitAdd'.$this->table]) AND ($id_order = intval(Tools::getValue('id_order'))) AND !sizeof($this->_errors) AND !empty($address_type))

		{

			if(!Db::getInstance()->Execute('UPDATE '._DB_PREFIX_.'orders SET `id_address_'.$address_type.'` = '.Db::getInstance()->Insert_ID().' WHERE `id_order` = '.$id_order))

				$this->_errors[] = Tools::displayError('an error occurred while linking this address to its order');

			else

				Tools::redirectAdmin(Tools::getValue('back').'&conf=4');

		}

	}

	

	public function getList($id_lang, $orderBy = NULL, $orderWay = NULL, $start = 0, $limit = NULL)

	{

	 	parent::getList($id_lang, $orderBy, $orderWay, $start, $limit);

		

		global $cookie;

		

	 	/* Manage default params values */

	 	if (empty($limit))

			$limit = ((!isset($cookie->{$this->table.'_pagination'})) ? $this->_pagination[0] : $limit = $cookie->{$this->table.'_pagination'});

			

	 	if (!Validate::isTableOrIdentifier($this->table))

	 		die('filter is corrupted');

	 	if (empty($orderBy))

			$orderBy = Tools::getValue($this->table.'Orderby', 'id_'.$this->table);

	 	if (empty($orderWay))

			$orderWay = Tools::getValue($this->table.'Orderway', 'ASC');

		$limit = intval(Tools::getValue('pagination', $limit));

		$cookie->{$this->table.'_pagination'} = $limit;

		

		/* Check params validity */

		if (!Validate::isOrderBy($orderBy) OR !Validate::isOrderWay($orderWay) 

			OR !is_numeric($start) OR !is_numeric($limit)

			OR !Validate::isUnsignedId($id_lang))

			die(Tools::displayError('get list params is not valid'));		

		

		/* Determine offset from current page */

		if ((isset($_POST['submitFilter'.$this->table]) OR 

		isset($_POST['submitFilter'.$this->table.'_x']) OR 

		isset($_POST['submitFilter'.$this->table.'_y'])) AND 

		!empty($_POST['submitFilter'.$this->table]) AND 

		is_numeric($_POST['submitFilter'.$this->table]))

			$start = intval($_POST['submitFilter'.$this->table] - 1) * $limit;



		/* Cache */

		$this->_lang = intval($id_lang);

		$this->_orderBy = $orderBy;

		$this->_orderWay = Tools::strtoupper($orderWay);

		

		/* SQL table : orders, but class name is Order */

		$sqlTable = $this->table == 'order' ? 'orders' : $this->table;

		

		/* Query in order to get results number */

		$queryTotal = Db::getInstance()->getRow('

		SELECT COUNT(a.`id_'.$this->table.'`) AS total

		FROM `'._DB_PREFIX_.$sqlTable.'` a

		'.($this->lang ? 'LEFT JOIN `'._DB_PREFIX_.$this->table.'_lang` b ON (b.`id_'.$this->table.'` = a.`id_'.$this->table.'` AND b.`id_lang` = '.intval($id_lang).')' : '').' 

		'.(isset($this->_join) ? $this->_join.' ' : '').'

		WHERE 1 '.(isset($this->_where) ? $this->_where.' ' : '').(($this->deleted OR $this->table == 'currency') ? 'AND a.`deleted` = 0 ' : '').$this->_filter.' 

		'.(isset($this->_group) ? $this->_group.' ' : '').'

		'.(isset($this->addressType) ? 'AND a.id_'.strval($this->addressType).' != 0' : ''));

		$this->_listTotal = intval($queryTotal['total']);



		/* Query in order to get results with all fields */

		$this->_list = Db::getInstance()->ExecuteS('

		SELECT a.*'.($this->lang ? ', b.*' : '').(isset($this->_select) ? ', '.$this->_select.' ' : '').' 

		FROM `'._DB_PREFIX_.$sqlTable.'` a 

		'.($this->lang ? 'LEFT JOIN `'._DB_PREFIX_.$this->table.'_lang` b ON (b.`id_'.$this->table.'` = a.`id_'.$this->table.'` AND b.`id_lang` = '.intval($id_lang).')' : '').' 

		'.(isset($this->_join) ? $this->_join.' ' : '').'

		WHERE 1 '.(isset($this->_where) ? $this->_where.' ' : '').(($this->deleted OR $this->table == 'currency') ? 'AND a.`deleted` = 0 ' : '').$this->_filter.' 

		'.(isset($this->_group) ? $this->_group.' ' : '').'

		'.(isset($this->addressType) ? 'AND a.id_'.strval($this->addressType).' != 0' : '').'

		ORDER BY '.(($orderBy == 'id_'.$this->table) ? 'a.' : '').'`'.pSQL($orderBy).'` '.pSQL($orderWay).' 

		LIMIT '.intval($start).','.intval($limit));

	}

	

	public function displayForm()

	{

		global $currentIndex;

		$obj = $this->loadObject(true);

		/* Get customer e-mail by id_customer */

		if ($obj->id AND !Tools::getValue('email'))

		{

			$customer = new Customer($obj->id_customer);

			$_POST['email'] = $customer->email;

		}

		

		echo '

		<form action="'.$currentIndex.'&submitAdd'.$this->table.'=1&token='.$this->token.'" method="post" class="width2">

		'.($obj->id ? '<input type="hidden" name="id_'.$this->table.'" value="'.intval($obj->id).'" />' : '').'

		'.(($id_order = intval(Tools::getValue('id_order'))) ? '<input type="hidden" name="id_order" value="'.intval($id_order).'" />' : '').'

		'.(($address_type = intval(Tools::getValue('address_type'))) ? '<input type="hidden" name="address_type" value="'.intval($address_type).'" />' : '').'

		'.(Tools::getValue('realedit') ? '<input type="hidden" name="realedit" value="1" />' : '').'

			<fieldset><legend><img src="../img/admin/contact.gif" />'.$this->l('Addresses').'</legend>';

		switch ($this->addressType)

		{

			case 'manufacturer':

				echo '<label>'.$this->l('Choose manufacturer:').'</label>

				<div class="margin-form">';

				$manufacturers = Manufacturer::getManufacturers();

				echo '<select name="id_manufacturer">';

				if (!sizeof($manufacturers))

					echo '<option value="0">'.$this->l('No manufacturer available').'&nbsp</option>';

				foreach ($manufacturers as $manufacturer)

					echo '<option value="'.$manufacturer['id_manufacturer'].'"'.($this->getFieldValue($obj, 'id_manufacturer') == $manufacturer['id_manufacturer'] ? ' selected="selected"' : '').'>'.$manufacturer['name'].'&nbsp</option>';

				echo	'</select>';

				echo '</div>';

				echo '<input type="hidden" name="alias" value="manufacturer">';

				break;

			case 'customer':

			default:

				echo	'<label>'.$this->l('Customer e-mail:').'</label>

				<div class="margin-form">

					<input type="text" size="33" name="email" value="'.htmlentities(Tools::getValue('email'), ENT_COMPAT, 'UTF-8').'" style="text-transform: lowercase;" /> <sup>*</sup>

				</div>

				<label>'.$this->l('Alias:').'</label>

				<div class="margin-form">

					<input type="text" size="33" name="alias" value="'.htmlentities($this->getFieldValue($obj, 'alias'), ENT_COMPAT, 'UTF-8').'" /> <sup>*</sup>

					<span class="hint" name="help_box">'.$this->l('Invalid characters:').' <>;=#{}<span class="hint-pointer">&nbsp;</span></span>

				</div>';

				break;

		}

				echo '<label>'.$this->l('Company:').'</label>

				<div class="margin-form">

					<input type="text" size="33" name="company" value="'.htmlentities($this->getFieldValue($obj, 'company'), ENT_COMPAT, 'UTF-8').'" />

					<span class="hint" name="help_box">'.$this->l('Invalid characters:').' <>;=#{}<span class="hint-pointer">&nbsp;</span></span>

				</div>

				<label>'.$this->l('Last name:').'</label>

				<div class="margin-form">

					<input type="text" size="33" name="lastname" value="'.htmlentities($this->getFieldValue($obj, 'lastname'), ENT_COMPAT, 'UTF-8').'" style="text-transform: uppercase;" /> <sup>*</sup>

					<span class="hint" name="help_box">'.$this->l('Invalid characters:').' 0-9!<>,;?=+()@#"�{}_$%:<span class="hint-pointer">&nbsp;</span></span>

				</div>

				<label>'.$this->l('First name:').'</label>

				<div class="margin-form">

					<input type="text" size="33" name="firstname" value="'.htmlentities($this->getFieldValue($obj, 'firstname'), ENT_COMPAT, 'UTF-8').'" /> <sup>*</sup>

					<span class="hint" name="help_box">'.$this->l('Invalid characters:').' 0-9!<>,;?=+()@#"�{}_$%:<span class="hint-pointer">&nbsp;</span></span>

				</div>

				<label>'.$this->l('Address:').'</label>

				<div class="margin-form">

					<input type="text" size="33" name="address1" value="'.htmlentities($this->getFieldValue($obj, 'address1'), ENT_COMPAT, 'UTF-8').'" /> <sup>*</sup>

				</div>

				<label>'.$this->l('Address').' (2):</label>

				<div class="margin-form">

					<input type="text" size="33" name="address2" value="'.htmlentities($this->getFieldValue($obj, 'address2'), ENT_COMPAT, 'UTF-8').'" />

				</div>

				<label>'.$this->l('Post/Zip code:').'</label>

				<div class="margin-form">

					<input type="text" size="33" name="postcode" value="'.htmlentities($this->getFieldValue($obj, 'postcode'), ENT_COMPAT, 'UTF-8').'" /> <sup>*</sup>

				</div>

				<label>'.$this->l('City:').'</label>

				<div class="margin-form">

					<input type="text" size="33" name="city" value="'.htmlentities($this->getFieldValue($obj, 'city'), ENT_COMPAT, 'UTF-8').'" style="text-transform: uppercase;" /> <sup>*</sup>

				</div>

				<label>'.$this->l('Country:').'</label>

				<div class="margin-form">

					<select name="id_country" />';

		foreach ($this->countriesArray AS $id_country => $name)

			echo '		<option value="'.$id_country.'"'.(($this->getFieldValue($obj, 'id_country') == $id_country) ? ' selected="selected"' : ((Configuration::get('PS_COUNTRY_DEFAULT')) == $id_country) ? ' selected="selected"' : '').'>'.$name.'</option>';

		echo '		</select> <sup>*</sup>

				</div>

				<label>'.$this->l('State:').'</label>

				<div class="margin-form">

					<select name="id_state" />

					<option value="0">-----------</option>';

		if ($this->stateList)

			foreach ($this->stateList AS $state)

				echo '	<option value="'.$state['id_state'].'"'.(($this->getFieldValue($obj, 'id_state') == $state['id_state']) ? ' selected="selected"' : '').'>'.$state['name'].'</option>';

		echo '		</select>

				</div>

				<label>'.$this->l('Home phone:').'</label>

				<div class="margin-form">

					<input type="text" size="33" name="phone" value="'.htmlentities($this->getFieldValue($obj, 'phone'), ENT_COMPAT, 'UTF-8').'" />

				</div>

				<label>'.$this->l('Mobile phone:').'</label>

				<div class="margin-form">

					<input type="text" size="33" name="phone_mobile" value="'.htmlentities($this->getFieldValue($obj, 'phone_mobile'), ENT_COMPAT, 'UTF-8').'" />

				</div>

				<label>'.$this->l('Other:').'</label>

				<div class="margin-form">

					<textarea name="other" cols="36" rows="4">'.htmlentities($this->getFieldValue($obj, 'other'), ENT_COMPAT, 'UTF-8').'</textarea>

					<span class="hint" name="help_box">'.$this->l('Forbidden characters:').' <>;=#{}<span class="hint-pointer">&nbsp;</span></span>

				</div>

				<div class="margin-form">

					<input type="submit" value="'.$this->l('   Save   ').'" name="submitAdd'.$this->table.'" class="button" />

				</div>

				<div class="small"><sup>*</sup> '.$this->l('Required field').'</div>

			</fieldset>

		</form>';

	}

}



?>