* @copyright 2007-2014 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 AdminStatesControllerCore extends AdminController { public function __construct() { $this->bootstrap = true; $this->table = 'state'; $this->className = 'State'; $this->lang = false; $this->requiredDatabase = true; $this->addRowAction('edit'); $this->addRowAction('delete'); $this->context = Context::getContext(); if (!Tools::getValue('realedit')) $this->deleted = false; $this->bulk_actions = array( 'delete' => array('text' => $this->l('Delete selected'), 'confirm' => $this->l('Delete selected items?')), 'affectzone' => array('text' => $this->l('Affect a new zone')) ); $this->_select = 'z.`name` AS zone, cl.`name` AS country'; $this->_join = ' LEFT JOIN `'._DB_PREFIX_.'zone` z ON (z.`id_zone` = a.`id_zone`) LEFT JOIN `'._DB_PREFIX_.'country_lang` cl ON (cl.`id_country` = a.`id_country` AND cl.id_lang = '.(int)$this->context->language->id.')'; $countries_array = $zones_array = array(); $this->zones = Zone::getZones(); $this->countries = Country::getCountries($this->context->language->id, false, true, false); foreach ($this->zones as $zone) $zones_array[$zone['id_zone']] = $zone['name']; foreach ($this->countries as $country) $countries_array[$country['id_country']] = $country['name']; $this->fields_list = array( 'id_state' => array( 'title' => $this->l('ID'), 'align' => 'center', 'class' => 'fixed-width-xs' ), 'name' => array( 'title' => $this->l('Name'), 'filter_key' => 'a!name' ), 'iso_code' => array( 'title' => $this->l('ISO code'), 'align' => 'center', 'class' => 'fixed-width-xs' ), 'zone' => array( 'title' => $this->l('Zone'), 'type' => 'select', 'list' => $zones_array, 'filter_key' => 'z!id_zone', 'filter_type' => 'int', 'order_key' => 'zone' ), 'country' => array( 'title' => $this->l('Country'), 'type' => 'select', 'list' => $countries_array, 'filter_key' => 'cl!id_country', 'filter_type' => 'int', 'order_key' => 'country' ), 'active' => array( 'title' => $this->l('Enabled'), 'active' => 'status', 'filter_key' => 'a!active', 'align' => 'center', 'type' => 'bool', 'orderby' => false, 'class' => 'fixed-width-sm' ) ); parent::__construct(); } public function initPageHeaderToolbar() { if (empty($this->display)) $this->page_header_toolbar_btn['new_state'] = array( 'href' => self::$currentIndex.'&addstate&token='.$this->token, 'desc' => $this->l('Add new state', null, null, false), 'icon' => 'process-icon-new' ); parent::initPageHeaderToolbar(); } public function renderForm() { $this->fields_form = array( 'legend' => array( 'title' => $this->l('States'), 'icon' => 'icon-globe' ), 'input' => array( array( 'type' => 'text', 'label' => $this->l('Name'), 'name' => 'name', 'maxlength' => 32, 'required' => true, 'hint' => $this->l('Provide the State name to be display in addresses and on invoices.') ), array( 'type' => 'text', 'label' => $this->l('ISO code'), 'name' => 'iso_code', 'maxlength' => 7, 'required' => true, 'class' => 'uppercase', 'hint' => $this->l('1 to 4 letter ISO code.').' '.$this->l('You can prefix it with the country ISO code if needed.') ), array( 'type' => 'select', 'label' => $this->l('Country'), 'name' => 'id_country', 'required' => true, 'default_value' => (int)$this->context->country->id, 'options' => array( 'query' => Country::getCountries($this->context->language->id, false, true), 'id' => 'id_country', 'name' => 'name', ), 'hint' => $this->l('Country where the state is located.').' '.$this->l('Only the countries with the option "contains states" enabled are displayed.') ), array( 'type' => 'select', 'label' => $this->l('Zone'), 'name' => 'id_zone', 'required' => true, 'options' => array( 'query' => Zone::getZones(), 'id' => 'id_zone', 'name' => 'name' ), 'hint' => array( $this->l('Geographical region where this state is located.'), $this->l('Used for shipping') ) ), array( 'type' => 'switch', 'label' => $this->l('Status'), 'name' => 'active', 'required' => true, 'values' => array( array( 'id' => 'active_on', 'value' => 1, 'label' => ''.$this->l('Enabled').'' ), array( 'id' => 'active_off', 'value' => 0, 'label' => ''.$this->l('Disabled').'' ) ) ) ), 'submit' => array( 'title' => $this->l('Save'), ) ); return parent::renderForm(); } public function postProcess() { if (Tools::isSubmit($this->table.'Orderby') || Tools::isSubmit($this->table.'Orderway')) $this->filter = true; // Idiot-proof controls if (!Tools::getValue('id_'.$this->table)) { if (Validate::isStateIsoCode(Tools::getValue('iso_code')) && State::getIdByIso(Tools::getValue('iso_code'), Tools::getValue('id_country'))) $this->errors[] = Tools::displayError('This ISO code already exists. You cannot create two states with the same ISO code.'); } elseif (Validate::isStateIsoCode(Tools::getValue('iso_code'))) { $id_state = State::getIdByIso(Tools::getValue('iso_code'), Tools::getValue('id_country')); if ($id_state && $id_state != Tools::getValue('id_'.$this->table)) $this->errors[] = Tools::displayError('This ISO code already exists. You cannot create two states with the same ISO code.'); } /* Delete state */ if (Tools::isSubmit('delete'.$this->table)) { if ($this->tabAccess['delete'] === '1') { if (Validate::isLoadedObject($object = $this->loadObject())) { if (!$object->isUsed()) { if ($object->delete()) Tools::redirectAdmin(self::$currentIndex.'&conf=1&token='.(Tools::getValue('token') ? Tools::getValue('token') : $this->token)); $this->errors[] = Tools::displayError('An error occurred during deletion.'); } else $this->errors[] = Tools::displayError('This state was used in at least one address. It cannot be removed.'); } else $this->errors[] = Tools::displayError('An error occurred while deleting the object.').' '.$this->table.' '.Tools::displayError('(cannot load object)'); } else $this->errors[] = Tools::displayError('You do not have permission to delete this.'); } if (!count($this->errors)) parent::postProcess(); } protected function displayAjaxStates() { if ($this->tabAccess['view'] === '1') { $states = Db::getInstance()->executeS(' SELECT s.id_state, s.name FROM '._DB_PREFIX_.'state s LEFT JOIN '._DB_PREFIX_.'country c ON (s.`id_country` = c.`id_country`) WHERE s.id_country = '.(int)(Tools::getValue('id_country')).' AND s.active = 1 AND c.`contains_states` = 1 ORDER BY s.`name` ASC'); if (is_array($states) AND !empty($states)) { $list = ''; if ((bool)Tools::getValue('no_empty') != true) { $empty_value = (Tools::isSubmit('empty_value')) ? Tools::getValue('empty_value') : '-'; $list = ''."\n"; } foreach ($states AS $state) $list .= ''."\n"; } else $list = 'false'; die($list); } } }