* @copyright 2007-2012 PrestaShop SA * @version Release: $Revision: 16875 $ * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) * International Registered Trademark & Property of PrestaShop SA */ class AdminGroups extends AdminTab { public function __construct() { $this->table = 'group'; $this->className = 'Group'; $this->lang = true; $this->edit = true; $this->view = true; $this->delete = true; $this->_select = ' (SELECT COUNT(jcg.`id_customer`) FROM `'._DB_PREFIX_.'customer_group` jcg LEFT JOIN `'._DB_PREFIX_.'customer` jc ON (jc.`id_customer` = jcg.`id_customer`) WHERE jc.`deleted` != 1 AND jcg.`id_group` = a.`id_group`) AS nb '; $this->_group = 'GROUP BY a.id_group'; $this->_listSkipDelete = array(1); $this->fieldsDisplay = array( 'id_group' => array('title' => $this->l('ID'), 'align' => 'center', 'width' => 25), 'name' => array('title' => $this->l('Name'), 'width' => 80, 'filter_key' => 'b!name'), 'reduction' => array('title' => $this->l('Discount'), 'width' => 50, 'align' => 'right'), 'nb' => array('title' => $this->l('Members'), 'width' => 25, 'align' => 'center', 'filter_key' => 'nb', 'havingFilter' => true), 'date_add' => array('title' => $this->l('Creation date'), 'width' => 60, 'type' => 'date', 'align' => 'right')); parent::__construct(); } public function displayForm($isMainTab = true) { global $currentIndex, $cookie; parent::displayForm(); if (!($obj = $this->loadObject(true))) return; $groupReductions = $obj->id ? GroupReduction::getGroupReductions($obj->id, (int)($cookie->id_lang)) : array(); $categories = Category::getSimpleCategories((int)($cookie->id_lang)); echo '

'.($obj->id ? '' : '').'

'.$this->l('Customer group').' '.$this->l('Name:').'

'; foreach ($this->_languages as $language) echo '

^* '.$this->l('Invalid characters:').' 0-9!<>,;?=+()@#"�{}_$%:

'; $this->displayFlags($this->_languages, $this->_defaultFormLanguage, 'name', 'name'); $reduction = htmlentities($this->getFieldValue($obj, 'reduction'), ENT_COMPAT, 'UTF-8'); echo '

'.$this->l('Discount:').'

'.$this->l('%').'

'.$this->l('Will automatically apply this discount on ALL shop\'s products for this group\'s members.').'

'; if ($obj->id) { echo ' '.$this->l('Current category discount:').'

'; if ($groupReductions) { echo ''; foreach ($groupReductions AS $groupReduction) echo ' '; echo '

'.$this->l('Category').'	'.$this->l('Value').'	'.$this->l('Action').'
'.Tools::htmlentitiesUTF8($groupReduction['category_name']).'

'; } else echo $this->l('No discount'); echo '

'; } echo ' '.$this->l('Price display method:').'

'.$this->l('How to display prices on order summary for this customer group (tax included or excluded).').'

^* '.$this->l('Required field').'

'; if ($obj->id) { echo ' '; } } public function viewgroup() { global $cookie; $currentIndex = 'index.php?tab=AdminGroups'; if (!($obj = $this->loadObject(true))) return; $defaultLanguage = (int)(_PS_LANG_DEFAULT_); echo '

'.strval($obj->name[(int)($cookie->id_lang)]).'

'.$this->l('Discount:').' '.(float)($obj->reduction).$this->l('%').'

'; $this->fieldsDisplay = (array( 'ID' => array('title' => $this->l('ID')), 'sex' => array('title' => $this->l('Sex')), 'name' => array('title' => $this->l('Name')), 'e-mail' => array('title' => $this->l('e-mail')), 'birthdate' => array('title' => $this->l('Birth date')), 'register_date' => array('title' => $this->l('Registration date')), 'orders' => array('title' => $this->l('Orders')), 'status' => array('title' => $this->l('Status')), 'actions' => array('title' => $this->l('Actions')) )); if ($nbCustomers = $obj->getCustomers(true)) { echo '

'.$this->l('Customer members of this group').' ('.$nbCustomers.')

'; // Pagination Begin $customersPerPage = (Tools::getValue('customerPerPage') ? (int)Tools::getValue('customerPerPage') : 50); $totalPages = ceil($nbCustomers / $customersPerPage); $perPageOptions = array(20, 50, 100, 300); $customerPageIndex = (Tools::getValue('customerPageIndex') && Tools::getValue('customerPageIndex') <= $totalPages ? (int)Tools::getValue('customerPageIndex') : 1); $from = (Tools::getValue('customerPageIndex') ? ((int)$customerPageIndex - 1) * ((int)$customersPerPage) : 0); $customers = $obj->getCustomers(false, $from, $customersPerPage); echo '

'; if ($customerPageIndex > 1) { echo ' '; echo ' '; } echo 'Page / '.$totalPages; if ($customerPageIndex < $totalPages) { echo ' '; echo ' '; } echo ' | Display / '.$nbCustomers.' result(s)

'; // Pagination End echo ''; foreach ($this->fieldsDisplay AS $field) echo ''.$field['title'].''; echo ' '; $irow = 0; foreach ($customers AS $k => $customer) { $imgGender = $customer['id_gender'] == 1 ? ' '.$this->l('Male').'

' : ($customer['id_gender'] == 2 ? ' '.$this->l('Female').'

' : ''); echo ' '; } echo '

'.$customer['id_customer'].'

'.$imgGender.'

'.stripslashes($customer['lastname']).' '.stripslashes($customer['firstname']).'

'.stripslashes($customer['email']).'

'.Tools::displayDate($customer['birthday'], (int)($cookie->id_lang)).'

'.Tools::displayDate($customer['date_add'], (int)($cookie->id_lang)).'

'.Order::getCustomerNbOrders($customer['id_customer']).'

'; } else echo '

'.$this->l('No user in this group.').'

'; } public function postProcess() { global $currentIndex; $token = Tools::getValue('token') ? Tools::getValue('token') : $this->token; if (Tools::isSubmit('deleteGroupReduction')) { if ($this->tabAccess['delete'] === '1') { if (!$id_group_reduction = Tools::getValue('id_group_reduction')) $this->_errors[] = Tools::displayError('Invalid group reduction ID'); else { $groupReduction = new GroupReduction((int)($id_group_reduction)); if (!$groupReduction->delete()) $this->_errors[] = Tools::displayError('An error occurred while deleting the group reduction'); else Tools::redirectAdmin($currentIndex.'&update'.$this->table.'&id_group='.(int)(Tools::getValue('id_group')).'&conf=1&token='.$token); } } else $this->_errors[] = Tools::displayError('You do not have permission to delete here.'); } if (Tools::isSubmit('submitAddGroupReduction')) { if ($this->tabAccess['add'] === '1') { if (!($obj = $this->loadObject())) return; $groupReduction = new GroupReduction(); if (!$id_category = Tools::getValue('id_category') OR !Validate::isUnsignedId($id_category)) $this->_errors[] = Tools::displayError('Wrong category ID'); elseif (!$reduction = Tools::getValue('reductionByCategory') OR !Validate::isPrice($reduction)) $this->_errors[] = Tools::displayError('Invalid reduction (must be a percentage)'); elseif (Tools::getValue('reductionByCategory') > 100 OR Tools::getValue('reductionByCategory') < 0) $this->_errors[] = Tools::displayError('Reduction value is incorrect'); elseif (GroupReduction::doesExist((int)($obj->id), $id_category)) $this->_errors[] = Tools::displayError('A reduction already exists for this category.'); else { $groupReduction->id_category = (int)($id_category); $groupReduction->id_group = (int)($obj->id); $groupReduction->reduction = (float)($reduction) / 100; if (!$groupReduction->add()) $this->_errors[] = Tools::displayError('An error occurred while adding a category group reduction.'); else Tools::redirectAdmin($currentIndex.'&update'.$this->table.'&id_group='.(int)(Tools::getValue('id_group')).'&conf=3&token='.$this->token); } } else $this->_errors[] = Tools::displayError('You do not have permission to add here.'); } if (Tools::isSubmit('submitAddgroup')) { if ($this->tabAccess['add'] === '1') { if (Tools::getValue('reduction') > 100 OR Tools::getValue('reduction') < 0) $this->_errors[] = Tools::displayError('Reduction value is incorrect'); else { $id_group_reductions = Tools::getValue('gr_id_group_reduction'); $reductions = Tools::getValue('gr_reduction'); if ($id_group_reductions) { foreach ($id_group_reductions AS $key => $id_group_reduction) if (!Validate::isUnsignedId($id_group_reductions[$key]) OR !Validate::isPrice($reductions[$key])) $this->_errors[] = Tools::displayError('Invalid reduction (must be a percentage)'); elseif ($reductions[$key] > 100 OR $reductions[$key] < 0) $this->_errors[] = Tools::displayError('Reduction value is incorrect'); else { $groupReduction = new GroupReduction((int)($id_group_reductions[$key])); $groupReduction->reduction = $reductions[$key] / 100; if (!$groupReduction->update()) $this->_errors[] = Tools::displayError('Cannot update group reductions'); } } if (!sizeof($this->_errors)) parent::postProcess(); } } else $this->_errors[] = Tools::displayError('You do not have permission to add here.'); } elseif (isset($_GET['delete'.$this->table])) { if ($this->tabAccess['delete'] === '1') { if (Validate::isLoadedObject($object = $this->loadObject())) { if ($object->id == 1) $this->_errors[] = Tools::displayError('You cannot delete default group.'); else { if ($object->delete()) Tools::redirectAdmin($currentIndex.'&conf=1&token='.$token); $this->_errors[] = Tools::displayError('An error occurred during deletion.'); } } else $this->_errors[] = Tools::displayError('An error occurred while deleting object.').' '.$this->table.' '.Tools::displayError('(cannot load object)'); } else $this->_errors[] = Tools::displayError('You do not have permission to delete here.'); } else parent::postProcess(); } }