File: /home/petsclubcc/shop/controllers/admin/AdminCustomersController.php
<?php
/**
* 2007-2018 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:
* https://opensource.org/licenses/OSL-3.0
* 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-2018 PrestaShop SA
* @license https://opensource.org/licenses/OSL-3.0 Open Software License (OSL 3.0)
* International Registered Trademark & Property of PrestaShop SA
*/
/**
* @property Customer $object
*/
class AdminCustomersControllerCore extends AdminController
{
protected $delete_mode;
protected $_defaultOrderBy = 'date_add';
protected $_defaultOrderWay = 'DESC';
protected $can_add_customer = true;
protected static $meaning_status = array();
public function __construct()
{
$this->bootstrap = true;
$this->required_database = true;
$this->table = 'customer';
$this->className = 'Customer';
$this->lang = false;
$this->deleted = true;
$this->explicitSelect = true;
$this->allow_export = true;
parent::__construct();
$this->required_fields = array(
array(
'name' => 'optin',
'label' => $this->trans('Partner offers', array(), 'Admin.Orderscustomers.Feature'),
),
);
$this->addRowAction('edit');
$this->addRowAction('view');
$this->addRowAction('delete');
$this->bulk_actions = array(
'delete' => array(
'text' => $this->trans('Delete selected', array(), 'Admin.Notifications.Info'),
'confirm' => $this->trans('Delete selected items?', array(), 'Admin.Notifications.Info'),
'icon' => 'icon-trash',
),
);
$this->default_form_language = $this->context->language->id;
$titles_array = array();
$genders = Gender::getGenders($this->context->language->id);
foreach ($genders as $gender) {
/* @var Gender $gender */
$titles_array[$gender->id_gender] = $gender->name;
}
$this->_join = 'LEFT JOIN ' . _DB_PREFIX_ . 'gender_lang gl ON (a.id_gender = gl.id_gender AND gl.id_lang = ' . (int) $this->context->language->id . ')';
$this->_use_found_rows = false;
$this->fields_list = array(
'id_customer' => array(
'title' => $this->trans('ID', array(), 'Admin.Global'),
'align' => 'text-center',
'class' => 'fixed-width-xs',
),
'title' => array(
'title' => $this->trans('Social title', array(), 'Admin.Global'),
'filter_key' => 'a!id_gender',
'type' => 'select',
'list' => $titles_array,
'filter_type' => 'int',
'order_key' => 'gl!name',
),
'firstname' => array(
'title' => $this->trans('First name', array(), 'Admin.Global'),
'maxlength' => 30,
),
'lastname' => array(
'title' => $this->trans('Last name', array(), 'Admin.Global'),
'maxlength' => 30,
),
'email' => array(
'title' => $this->trans('Email address', array(), 'Admin.Global'),
'maxlength' => 50,
),
);
if (Configuration::get('PS_B2B_ENABLE')) {
$this->fields_list = array_merge($this->fields_list, array(
'company' => array(
'title' => $this->trans('Company', array(), 'Admin.Global'),
),
));
}
$this->fields_list = array_merge($this->fields_list, array(
'total_spent' => array(
'title' => $this->trans('Sales', array(), 'Admin.Global'),
'type' => 'price',
'search' => false,
'havingFilter' => true,
'align' => 'text-right',
'badge_success' => true,
),
'active' => array(
'title' => $this->trans('Enabled', array(), 'Admin.Global'),
'align' => 'text-center',
'active' => 'status',
'type' => 'bool',
'orderby' => false,
'filter_key' => 'a!active',
),
'newsletter' => array(
'title' => $this->trans('Newsletter', array(), 'Admin.Global'),
'align' => 'text-center',
'callback' => 'printNewsIcon',
),
'optin' => array(
'title' => $this->trans('Partner offers', array(), 'Admin.Orderscustomers.Feature'),
'align' => 'text-center',
'callback' => 'printOptinIcon',
),
'date_add' => array(
'title' => $this->trans('Registration', array(), 'Admin.Orderscustomers.Feature'),
'type' => 'date',
'align' => 'text-right',
),
'connect' => array(
'title' => $this->trans('Last visit', array(), 'Admin.Orderscustomers.Feature'),
'type' => 'datetime',
'search' => false,
'havingFilter' => true,
),
));
$this->shopLinkType = 'shop';
$this->shopShareDatas = Shop::SHARE_CUSTOMER;
$this->_select = '
a.date_add, gl.name as title, (
SELECT SUM(total_paid_real / conversion_rate)
FROM ' . _DB_PREFIX_ . 'orders o
WHERE o.id_customer = a.id_customer
' . Shop::addSqlRestriction(Shop::SHARE_ORDER, 'o') . '
AND o.valid = 1
) as total_spent, (
SELECT c.date_add FROM ' . _DB_PREFIX_ . 'guest g
LEFT JOIN ' . _DB_PREFIX_ . 'connections c ON c.id_guest = g.id_guest
WHERE g.id_customer = a.id_customer
ORDER BY c.date_add DESC
LIMIT 1
) as connect';
// Check if we can add a customer
if (Shop::isFeatureActive() && (Shop::getContext() == Shop::CONTEXT_ALL || Shop::getContext() == Shop::CONTEXT_GROUP)) {
$this->can_add_customer = false;
}
self::$meaning_status = array(
'open' => $this->trans('Open', array(), 'Admin.Orderscustomers.Feature'),
'closed' => $this->trans('Closed', array(), 'Admin.Orderscustomers.Feature'),
'pending1' => $this->trans('Pending 1', array(), 'Admin.Orderscustomers.Feature'),
'pending2' => $this->trans('Pending 2', array(), 'Admin.Orderscustomers.Feature'),
);
}
public function postProcess()
{
if (!$this->can_add_customer && $this->display == 'add') {
$this->redirect_after = $this->context->link->getAdminLink('AdminCustomers');
}
parent::postProcess();
}
public function initContent()
{
if ($this->action == 'select_delete') {
$this->context->smarty->assign(array(
'delete_form' => true,
'url_delete' => htmlentities($_SERVER['REQUEST_URI']),
'boxes' => $this->boxes,
));
}
if (!$this->can_add_customer && !$this->display) {
$this->informations[] = $this->trans('You have to select a shop if you want to create a customer.', array(), 'Admin.Orderscustomers.Notification');
}
parent::initContent();
}
public function initToolbar()
{
parent::initToolbar();
if (!$this->can_add_customer) {
unset($this->toolbar_btn['new']);
} elseif (!$this->display && $this->can_import) {
$this->toolbar_btn['import'] = array(
'href' => $this->context->link->getAdminLink('AdminImport', true) . '&import_type=customers',
'desc' => $this->trans('Import', array(), 'Admin.Actions'),
);
}
}
public function getList($id_lang, $orderBy = null, $orderWay = null, $start = 0, $limit = null, $id_lang_shop = null)
{
parent::getList($id_lang, $orderBy, $orderWay, $start, $limit, $id_lang_shop);
if ($this->_list) {
foreach ($this->_list as &$row) {
$row['badge_success'] = $row['total_spent'] > 0;
}
}
}
public function initToolbarTitle()
{
parent::initToolbarTitle();
switch ($this->display) {
case '':
case 'list':
array_pop($this->toolbar_title);
$this->toolbar_title[] = $this->trans('Manage your Customers', array(), 'Admin.Orderscustomers.Feature');
break;
case 'view':
/** @var Customer $customer */
if (($customer = $this->loadObject(true)) && Validate::isLoadedObject($customer)) {
array_pop($this->toolbar_title);
$this->toolbar_title[] = $this->trans('Information about customer %name%', array('%name%' => Tools::substr($customer->firstname, 0, 1) . '. ' . $customer->lastname), 'Admin.Orderscustomers.Feature');
}
break;
case 'add':
case 'edit':
array_pop($this->toolbar_title);
/** @var Customer $customer */
if (($customer = $this->loadObject(true)) && Validate::isLoadedObject($customer)) {
$this->toolbar_title[] = $this->trans('Editing customer %name%', array('%name%' => Tools::substr($customer->firstname, 0, 1) . '. ' . $customer->lastname), 'Admin.Orderscustomers.Feature');
} else {
$this->toolbar_title[] = $this->trans('Creating a new Customer', array(), 'Admin.Orderscustomers.Feature');
}
break;
}
array_pop($this->meta_title);
if (count($this->toolbar_title) > 0) {
$this->addMetaTitle($this->toolbar_title[count($this->toolbar_title) - 1]);
}
}
public function initPageHeaderToolbar()
{
if (empty($this->display) && $this->can_add_customer) {
$this->page_header_toolbar_btn['new_customer'] = array(
'href' => self::$currentIndex . '&addcustomer&token=' . $this->token,
'desc' => $this->trans('Add new customer', array(), 'Admin.Orderscustomers.Feature'),
'icon' => 'process-icon-new',
);
}
parent::initPageHeaderToolbar();
}
public function initProcess()
{
parent::initProcess();
if (Tools::isSubmit('submitGuestToCustomer') && $this->id_object) {
if ($this->access('edit')) {
$this->action = 'guest_to_customer';
} else {
$this->errors[] = $this->trans('You do not have permission to edit this.', array(), 'Admin.Notifications.Error');
}
} elseif (Tools::isSubmit('changeNewsletterVal') && $this->id_object) {
if ($this->access('edit')) {
$this->action = 'change_newsletter_val';
} else {
$this->errors[] = $this->trans('You do not have permission to edit this.', array(), 'Admin.Notifications.Error');
}
} elseif (Tools::isSubmit('changeOptinVal') && $this->id_object) {
if ($this->access('edit')) {
$this->action = 'change_optin_val';
} else {
$this->errors[] = $this->trans('You do not have permission to edit this.', array(), 'Admin.Notifications.Error');
}
}
// When deleting, first display a form to select the type of deletion
if ($this->action == 'delete' || $this->action == 'bulkdelete') {
if (Tools::getValue('deleteMode') == 'real' || Tools::getValue('deleteMode') == 'deleted') {
$this->delete_mode = Tools::getValue('deleteMode');
} else {
$this->action = 'select_delete';
}
}
}
public function renderList()
{
if ((Tools::isSubmit('submitBulkdelete' . $this->table) || Tools::isSubmit('delete' . $this->table)) && $this->access('delete')) {
$this->tpl_list_vars = array(
'delete_customer' => true,
'REQUEST_URI' => $_SERVER['REQUEST_URI'],
'POST' => $_POST,
);
}
return parent::renderList();
}
public function renderForm()
{
/** @var Customer $obj */
if (!($obj = $this->loadObject(true))) {
return;
}
$genders = Gender::getGenders();
$list_genders = array();
foreach ($genders as $key => $gender) {
/* @var Gender $gender */
$list_genders[$key]['id'] = 'gender_' . $gender->id;
$list_genders[$key]['value'] = $gender->id;
$list_genders[$key]['label'] = $gender->name;
}
$years = Tools::dateYears();
$months = Tools::dateMonths();
$days = Tools::dateDays();
$groups = Group::getGroups($this->default_form_language, true);
$this->fields_form = array(
'legend' => array(
'title' => $this->trans('Customer', array(), 'Admin.Global'),
'icon' => 'icon-user',
),
'input' => array(
array(
'type' => 'radio',
'label' => $this->trans('Social title', array(), 'Admin.Global'),
'name' => 'id_gender',
'required' => false,
'class' => 't',
'values' => $list_genders,
),
array(
'type' => 'text',
'label' => $this->trans('First name', array(), 'Admin.Global'),
'name' => 'firstname',
'required' => true,
'col' => '4',
'hint' => $this->trans('Invalid characters:', array(), 'Admin.Notifications.Info') . ' 0-9!<>,;?=+()@#"°{}_$%:',
),
array(
'type' => 'text',
'label' => $this->trans('Last name', array(), 'Admin.Global'),
'name' => 'lastname',
'required' => true,
'col' => '4',
'hint' => $this->trans('Invalid characters:', array(), 'Admin.Notifications.Info') . ' 0-9!<>,;?=+()@#"°{}_$%:',
),
array(
'type' => 'text',
'prefix' => '<i class="icon-envelope-o"></i>',
'label' => $this->trans('Email address', array(), 'Admin.Global'),
'name' => 'email',
'col' => '4',
'required' => true,
'autocomplete' => false,
),
array(
'type' => 'password',
'label' => $this->trans('Password', array(), 'Admin.Global'),
'name' => 'passwd',
'required' => ($obj->id ? false : true),
'col' => '4',
'hint' => ($obj->id ? $this->trans('Leave this field blank if there\'s no change.', array(), 'Admin.Orderscustomers.Help') :
$this->trans('Password should be at least %length% characters long.', array('%length%' => Validate::PASSWORD_LENGTH), 'Admin.Orderscustomers.Help')),
),
array(
'type' => 'birthday',
'label' => $this->trans('Birthday', array(), 'Admin.Orderscustomers.Feature'),
'name' => 'birthday',
'options' => array(
'days' => $days,
'months' => $months,
'years' => $years,
),
),
array(
'type' => 'switch',
'label' => $this->trans('Enabled', array(), 'Admin.Global'),
'name' => 'active',
'required' => false,
'class' => 't',
'is_bool' => true,
'values' => array(
array(
'id' => 'active_on',
'value' => 1,
'label' => $this->trans('Enabled', array(), 'Admin.Global'),
),
array(
'id' => 'active_off',
'value' => 0,
'label' => $this->trans('Disabled', array(), 'Admin.Global'),
),
),
'hint' => $this->trans('Enable or disable customer login.', array(), 'Admin.Orderscustomers.Help'),
),
array(
'type' => 'switch',
'label' => $this->trans('Partner offers', array(), 'Admin.Orderscustomers.Feature'),
'name' => 'optin',
'required' => false,
'class' => 't',
'is_bool' => true,
'values' => array(
array(
'id' => 'optin_on',
'value' => 1,
'label' => $this->trans('Enabled', array(), 'Admin.Global'),
),
array(
'id' => 'optin_off',
'value' => 0,
'label' => $this->trans('Disabled', array(), 'Admin.Global'),
),
),
'disabled' => (bool) !Configuration::get('PS_CUSTOMER_OPTIN'),
'hint' => $this->trans('This customer will receive your ads via email.', array(), 'Admin.Orderscustomers.Help'),
),
),
);
// if we add a customer via fancybox (ajax), it's a customer and he doesn't need to be added to the visitor and guest groups
if (Tools::isSubmit('addcustomer') && Tools::isSubmit('submitFormAjax')) {
$visitor_group = Configuration::get('PS_UNIDENTIFIED_GROUP');
$guest_group = Configuration::get('PS_GUEST_GROUP');
foreach ($groups as $key => $g) {
if (in_array($g['id_group'], array($visitor_group, $guest_group))) {
unset($groups[$key]);
}
}
}
$this->fields_form['input'] = array_merge(
$this->fields_form['input'],
array(
array(
'type' => 'group',
'label' => $this->trans('Group access', array(), 'Admin.Orderscustomers.Feature'),
'name' => 'groupBox',
'values' => $groups,
'required' => true,
'col' => '6',
'hint' => $this->trans('Select all the groups that you would like to apply to this customer.', array(), 'Admin.Orderscustomers.Help'),
),
array(
'type' => 'select',
'label' => $this->trans('Default customer group', array(), 'Admin.Orderscustomers.Feature'),
'name' => 'id_default_group',
'options' => array(
'query' => $groups,
'id' => 'id_group',
'name' => 'name',
),
'col' => '4',
'hint' => array(
$this->trans('This group will be the user\'s default group.', array(), 'Admin.Orderscustomers.Help'),
$this->trans('Only the discount for the selected group will be applied to this customer.', array(), 'Admin.Orderscustomers.Help'),
),
),
)
);
// if customer is a guest customer, password hasn't to be there
if ($obj->id && ($obj->is_guest && $obj->id_default_group == Configuration::get('PS_GUEST_GROUP'))) {
foreach ($this->fields_form['input'] as $k => $field) {
if ($field['type'] == 'password') {
array_splice($this->fields_form['input'], $k, 1);
}
}
}
if (Configuration::get('PS_B2B_ENABLE')) {
$risks = Risk::getRisks();
$list_risks = array();
foreach ($risks as $key => $risk) {
/* @var Risk $risk */
$list_risks[$key]['id_risk'] = (int) $risk->id;
$list_risks[$key]['name'] = $risk->name;
}
$this->fields_form['input'][] = array(
'type' => 'text',
'label' => $this->trans('Company', array(), 'Admin.Global'),
'name' => 'company',
);
$this->fields_form['input'][] = array(
'type' => 'text',
'label' => $this->trans('SIRET', array(), 'Admin.Orderscustomers.Feature'),
'name' => 'siret',
);
$this->fields_form['input'][] = array(
'type' => 'text',
'label' => $this->trans('APE', array(), 'Admin.Orderscustomers.Feature'),
'name' => 'ape',
);
$this->fields_form['input'][] = array(
'type' => 'text',
'label' => $this->trans('Website', array(), 'Admin.Orderscustomers.Feature'),
'name' => 'website',
);
$this->fields_form['input'][] = array(
'type' => 'text',
'label' => $this->trans('Allowed outstanding amount', array(), 'Admin.Orderscustomers.Feature'),
'name' => 'outstanding_allow_amount',
'hint' => $this->trans('Valid characters:', array(), 'Admin.Orderscustomers.Help') . ' 0-9',
'suffix' => $this->context->currency->sign,
);
$this->fields_form['input'][] = array(
'type' => 'text',
'label' => $this->trans('Maximum number of payment days', array(), 'Admin.Orderscustomers.Feature'),
'name' => 'max_payment_days',
'hint' => $this->trans('Valid characters:', array(), 'Admin.Orderscustomers.Help') . ' 0-9',
);
$this->fields_form['input'][] = array(
'type' => 'select',
'label' => $this->trans('Risk rating', array(), 'Admin.Orderscustomers.Feature'),
'name' => 'id_risk',
'required' => false,
'class' => 't',
'options' => array(
'query' => $list_risks,
'id' => 'id_risk',
'name' => 'name',
),
);
}
$this->fields_form['submit'] = array(
'title' => $this->trans('Save', array(), 'Admin.Actions'),
);
$birthday = explode('-', $this->getFieldValue($obj, 'birthday'));
$this->fields_value = array(
'years' => $this->getFieldValue($obj, 'birthday') ? $birthday[0] : 0,
'months' => $this->getFieldValue($obj, 'birthday') ? $birthday[1] : 0,
'days' => $this->getFieldValue($obj, 'birthday') ? $birthday[2] : 0,
);
// Added values of object Group
if (!Validate::isUnsignedId($obj->id)) {
$customer_groups = array();
} else {
$customer_groups = $obj->getGroups();
}
$customer_groups_ids = array();
if (is_array($customer_groups)) {
foreach ($customer_groups as $customer_group) {
$customer_groups_ids[] = $customer_group;
}
}
// if empty $carrier_groups_ids : object creation : we set the default groups
if (empty($customer_groups_ids)) {
$preselected = array(Configuration::get('PS_UNIDENTIFIED_GROUP'), Configuration::get('PS_GUEST_GROUP'), Configuration::get('PS_CUSTOMER_GROUP'));
$customer_groups_ids = array_merge($customer_groups_ids, $preselected);
}
foreach ($groups as $group) {
$this->fields_value['groupBox_' . $group['id_group']] =
Tools::getValue('groupBox_' . $group['id_group'], in_array($group['id_group'], $customer_groups_ids));
}
return parent::renderForm();
}
public function beforeAdd($customer)
{
$customer->id_shop = $this->context->shop->id;
}
public function renderKpis()
{
$time = time();
$kpis = array();
/* The data generation is located in AdminStatsControllerCore */
$helper = new HelperKpi();
$helper->id = 'box-gender';
$helper->icon = 'icon-male';
$helper->color = 'color1';
$helper->title = $this->trans('Customers', array(), 'Admin.Global');
$helper->subtitle = $this->trans('All Time', array(), 'Admin.Global');
if (ConfigurationKPI::get('CUSTOMER_MAIN_GENDER', $this->context->language->id) !== false) {
$helper->value = ConfigurationKPI::get('CUSTOMER_MAIN_GENDER', $this->context->language->id);
}
$helper->source = $this->context->link->getAdminLink('AdminStats') . '&ajax=1&action=getKpi&kpi=customer_main_gender';
$helper->refresh = (bool) (ConfigurationKPI::get('CUSTOMER_MAIN_GENDER_EXPIRE', $this->context->language->id) < $time);
$kpis[] = $helper->generate();
$helper = new HelperKpi();
$helper->id = 'box-age';
$helper->icon = 'icon-calendar';
$helper->color = 'color2';
$helper->title = $this->trans('Average Age', array(), 'Admin.Orderscustomers.Feature');
$helper->subtitle = $this->trans('All Time', array(), 'Admin.Global');
if (ConfigurationKPI::get('AVG_CUSTOMER_AGE', $this->context->language->id) !== false) {
$helper->value = ConfigurationKPI::get('AVG_CUSTOMER_AGE', $this->context->language->id);
}
$helper->source = $this->context->link->getAdminLink('AdminStats') . '&ajax=1&action=getKpi&kpi=avg_customer_age';
$helper->refresh = (bool) (ConfigurationKPI::get('AVG_CUSTOMER_AGE_EXPIRE', $this->context->language->id) < $time);
$kpis[] = $helper->generate();
$helper = new HelperKpi();
$helper->id = 'box-orders';
$helper->icon = 'icon-retweet';
$helper->color = 'color3';
$helper->title = $this->trans('Orders per Customer', array(), 'Admin.Orderscustomers.Feature');
$helper->subtitle = $this->trans('All Time', array(), 'Admin.Global');
if (ConfigurationKPI::get('ORDERS_PER_CUSTOMER') !== false) {
$helper->value = ConfigurationKPI::get('ORDERS_PER_CUSTOMER');
}
$helper->source = $this->context->link->getAdminLink('AdminStats') . '&ajax=1&action=getKpi&kpi=orders_per_customer';
$helper->refresh = (bool) (ConfigurationKPI::get('ORDERS_PER_CUSTOMER_EXPIRE') < $time);
$kpis[] = $helper->generate();
$helper = new HelperKpi();
$helper->id = 'box-newsletter';
$helper->icon = 'icon-envelope';
$helper->color = 'color4';
$helper->title = $this->trans('Newsletter Registrations', array(), 'Admin.Orderscustomers.Feature');
$helper->subtitle = $this->trans('All Time', array(), 'Admin.Global');
if (ConfigurationKPI::get('NEWSLETTER_REGISTRATIONS') !== false) {
$helper->value = ConfigurationKPI::get('NEWSLETTER_REGISTRATIONS');
}
$helper->source = $this->context->link->getAdminLink('AdminStats') . '&ajax=1&action=getKpi&kpi=newsletter_registrations';
$helper->refresh = (bool) (ConfigurationKPI::get('NEWSLETTER_REGISTRATIONS_EXPIRE') < $time);
$kpis[] = $helper->generate();
$helper = new HelperKpiRow();
$helper->kpis = $kpis;
return $helper->generate();
}
public function renderView()
{
/** @var Customer $customer */
if (!($customer = $this->loadObject())) {
return;
}
$this->context->customer = $customer;
$gender = new Gender($customer->id_gender, $this->context->language->id);
$gender_image = $gender->getImage();
$customer_stats = $customer->getStats();
$sql = 'SELECT SUM(total_paid_real) FROM ' . _DB_PREFIX_ . 'orders WHERE id_customer = ' . (int) $customer->id . ' AND valid = 1';
if ($total_customer = Db::getInstance()->getValue($sql)) {
$sql = 'SELECT SQL_CALC_FOUND_ROWS COUNT(*) FROM ' . _DB_PREFIX_ . 'orders WHERE valid = 1 AND id_customer != ' . (int) $customer->id . ' GROUP BY id_customer HAVING SUM(total_paid_real) > ' . (int) $total_customer;
Db::getInstance()->getValue($sql);
$count_better_customers = (int) Db::getInstance()->getValue('SELECT FOUND_ROWS()') + 1;
} else {
$count_better_customers = '-';
}
$orders = Order::getCustomerOrders($customer->id, true);
$total_orders = count($orders);
for ($i = 0; $i < $total_orders; ++$i) {
$orders[$i]['total_paid_real_not_formated'] = $orders[$i]['total_paid_real'];
$orders[$i]['total_paid_real'] = Tools::displayPrice($orders[$i]['total_paid_real'], new Currency((int) $orders[$i]['id_currency']));
}
$messages = CustomerThread::getCustomerMessages((int) $customer->id);
$total_messages = count($messages);
for ($i = 0; $i < $total_messages; ++$i) {
$messages[$i]['message'] = substr(strip_tags(html_entity_decode($messages[$i]['message'], ENT_NOQUOTES, 'UTF-8')), 0, 75);
$messages[$i]['date_add'] = Tools::displayDate($messages[$i]['date_add'], null, true);
if (isset(self::$meaning_status[$messages[$i]['status']])) {
$messages[$i]['status'] = self::$meaning_status[$messages[$i]['status']];
}
}
$groups = $customer->getGroups();
$total_groups = count($groups);
for ($i = 0; $i < $total_groups; ++$i) {
$group = new Group($groups[$i]);
$groups[$i] = array();
$groups[$i]['id_group'] = $group->id;
$groups[$i]['name'] = $group->name[$this->default_form_language];
}
$total_ok = 0;
$orders_ok = array();
$orders_ko = array();
foreach ($orders as $order) {
if (!isset($order['order_state'])) {
$order['order_state'] = $this->trans('There is no status defined for this order.', array(), 'Admin.Orderscustomers.Notification');
}
if ($order['valid']) {
$orders_ok[] = $order;
$total_ok += $order['total_paid_real_not_formated'] / $order['conversion_rate'];
} else {
$orders_ko[] = $order;
}
}
$products = $customer->getBoughtProducts();
$carts = Cart::getCustomerCarts($customer->id);
$total_carts = count($carts);
for ($i = 0; $i < $total_carts; ++$i) {
$cart = new Cart((int) $carts[$i]['id_cart']);
$this->context->cart = $cart;
$currency = new Currency((int) $carts[$i]['id_currency']);
$this->context->currency = $currency;
$summary = $cart->getSummaryDetails();
$carrier = new Carrier((int) $carts[$i]['id_carrier']);
$carts[$i]['id_cart'] = sprintf('%06d', $carts[$i]['id_cart']);
$carts[$i]['date_add'] = Tools::displayDate($carts[$i]['date_add'], null, true);
$carts[$i]['total_price'] = Tools::displayPrice($summary['total_price'], $currency);
$carts[$i]['name'] = $carrier->name;
}
$this->context->currency = Currency::getDefaultCurrency();
$sql = 'SELECT DISTINCT cp.id_product, c.id_cart, c.id_shop, cp.id_shop AS cp_id_shop
FROM ' . _DB_PREFIX_ . 'cart_product cp
JOIN ' . _DB_PREFIX_ . 'cart c ON (c.id_cart = cp.id_cart)
JOIN ' . _DB_PREFIX_ . 'product p ON (cp.id_product = p.id_product)
WHERE c.id_customer = ' . (int) $customer->id . '
AND NOT EXISTS (
SELECT 1
FROM ' . _DB_PREFIX_ . 'orders o
JOIN ' . _DB_PREFIX_ . 'order_detail od ON (o.id_order = od.id_order)
WHERE product_id = cp.id_product AND o.valid = 1 AND o.id_customer = ' . (int) $customer->id . '
)';
$interested = Db::getInstance()->executeS($sql);
$total_interested = count($interested);
for ($i = 0; $i < $total_interested; ++$i) {
$product = new Product($interested[$i]['id_product'], false, $this->default_form_language, $interested[$i]['id_shop']);
if (!Validate::isLoadedObject($product)) {
continue;
}
$interested[$i]['url'] = $this->context->link->getProductLink(
$product->id,
$product->link_rewrite,
Category::getLinkRewrite($product->id_category_default, $this->default_form_language),
null,
null,
$interested[$i]['cp_id_shop']
);
$interested[$i]['id'] = (int) $product->id;
$interested[$i]['name'] = Tools::htmlentitiesUTF8($product->name);
}
$emails = $customer->getLastEmails();
$connections = $customer->getLastConnections();
if (!is_array($connections)) {
$connections = array();
}
$total_connections = count($connections);
for ($i = 0; $i < $total_connections; ++$i) {
$connections[$i]['http_referer'] = $connections[$i]['http_referer'] ? preg_replace('/^www./', '', parse_url($connections[$i]['http_referer'], PHP_URL_HOST)) : $this->trans('Direct link', array(), 'Admin.Orderscustomers.Notification');
}
$referrers = Referrer::getReferrers($customer->id);
$total_referrers = count($referrers);
for ($i = 0; $i < $total_referrers; ++$i) {
$referrers[$i]['date_add'] = Tools::displayDate($referrers[$i]['date_add'], null, true);
}
$customerLanguage = new Language($customer->id_lang);
$shop = new Shop($customer->id_shop);
$this->tpl_view_vars = array(
'customer' => $customer,
'gender' => $gender,
'gender_image' => $gender_image,
// General information of the customer
'registration_date' => Tools::displayDate($customer->date_add, null, true),
'customer_stats' => $customer_stats,
'last_visit' => Tools::displayDate($customer_stats['last_visit'], null, true),
'count_better_customers' => $count_better_customers,
'shop_is_feature_active' => Shop::isFeatureActive(),
'name_shop' => $shop->name,
'customer_birthday' => Tools::displayDate($customer->birthday),
'last_update' => Tools::displayDate($customer->date_upd, null, true),
'customer_exists' => Customer::customerExists($customer->email),
'id_lang' => $customer->id_lang,
'customerLanguage' => $customerLanguage,
// Add a Private note
'customer_note' => Tools::htmlentitiesUTF8($customer->note),
// Messages
'messages' => $messages,
// Groups
'groups' => $groups,
// Orders
'orders' => $orders,
'orders_ok' => $orders_ok,
'orders_ko' => $orders_ko,
'total_ok' => Tools::displayPrice($total_ok, $this->context->currency->id),
// Products
'products' => $products,
// Addresses
'addresses' => $customer->getAddresses($this->default_form_language),
// Discounts
'discounts' => CartRule::getCustomerCartRules($this->default_form_language, $customer->id, false, false),
// Carts
'carts' => $carts,
// Interested
'interested' => $interested,
// Emails
'emails' => $emails,
// Connections
'connections' => $connections,
// Referrers
'referrers' => $referrers,
'show_toolbar' => true,
);
return parent::renderView();
}
public function processDelete()
{
$this->_setDeletedMode();
parent::processDelete();
}
protected function _setDeletedMode()
{
if ($this->delete_mode == 'real') {
$this->deleted = false;
} elseif ($this->delete_mode == 'deleted') {
$this->deleted = true;
} else {
$this->errors[] = $this->trans('Unknown delete mode:', array(), 'Admin.Orderscustomers.Notification') . ' ' . $this->deleted;
return;
}
}
protected function processBulkDelete()
{
$this->_setDeletedMode();
parent::processBulkDelete();
}
public function processAdd()
{
if (Tools::getValue('submitFormAjax')) {
$this->redirect_after = false;
}
// Check that the new email is not already in use
$customer_email = strval(Tools::getValue('email'));
$customer = new Customer();
if (Validate::isEmail($customer_email)) {
$customer->getByEmail($customer_email);
}
if ($customer->id) {
$this->errors[] = $this->trans('An account already exists for this email address:', array(), 'Admin.Orderscustomers.Notification') . ' ' . $customer_email;
$this->display = 'edit';
return $customer;
} elseif (trim(Tools::getValue('passwd')) == '') {
$this->validateRules();
$this->errors[] = $this->trans('Password cannot be empty.', array(), 'Admin.Orderscustomers.Notification');
$this->display = 'edit';
} elseif ($customer = parent::processAdd()) {
$this->context->smarty->assign('new_customer', $customer);
return $customer;
}
return false;
}
public function processUpdate()
{
if (Validate::isLoadedObject($this->object)) {
$customer_email = strval(Tools::getValue('email'));
// check if e-mail already used
if ($customer_email != $this->object->email) {
$customer = new Customer();
if (Validate::isEmail($customer_email)) {
$customer->getByEmail($customer_email);
}
if (($customer->id) && ($customer->id != (int) $this->object->id)) {
$this->errors[] = $this->trans('An account already exists for this email address:', array(), 'Admin.Orderscustomers.Notification') . ' ' . $customer_email;
}
}
return parent::processUpdate();
} else {
$this->errors[] = $this->trans('An error occurred while loading the object.', array(), 'Admin.Orderscustomers.Notification') . '
<b>' . $this->table . '</b> ' . $this->trans('(cannot load object)', array(), 'Admin.Orderscustomers.Notification');
}
}
public function processSave()
{
// Check that default group is selected
if (!is_array(Tools::getValue('groupBox')) || !in_array(Tools::getValue('id_default_group'), Tools::getValue('groupBox'))) {
$this->errors[] = $this->trans('A default customer group must be selected in group box.', array(), 'Admin.Orderscustomers.Notification');
}
// Check the requires fields which are settings in the BO
$customer = new Customer();
$this->errors = array_merge($this->errors, $customer->validateFieldsRequiredDatabase());
return parent::processSave();
}
protected function afterDelete($object, $old_id)
{
$customer = new Customer($old_id);
$addresses = $customer->getAddresses($this->default_form_language);
foreach ($addresses as $k => $v) {
$address = new Address($v['id_address']);
$address->id_customer = $object->id;
$address->save();
}
return true;
}
/**
* Transform a guest account into a registered customer account.
*/
public function processGuestToCustomer()
{
$customer = new Customer((int) Tools::getValue('id_customer'));
if (!Validate::isLoadedObject($customer)) {
$this->errors[] = $this->trans('This customer does not exist.', array(), 'Admin.Orderscustomers.Notification');
}
if (Customer::customerExists($customer->email)) {
$this->errors[] = $this->trans('This customer already exists as a non-guest.', array(), 'Admin.Orderscustomers.Notification');
} elseif ($customer->transformToCustomer(Tools::getValue('id_lang', $this->context->language->id))) {
if ($id_order = (int) Tools::getValue('id_order')) {
Tools::redirectAdmin($this->context->link->getAdminLink('AdminOrders') . '&id_order=' . $id_order . '&vieworder&conf=3');
} else {
Tools::redirectAdmin(self::$currentIndex . '&' . $this->identifier . '=' . $customer->id . '&viewcustomer&conf=3&token=' . $this->token);
}
} else {
$this->errors[] = $this->trans('An error occurred while updating customer information.', array(), 'Admin.Orderscustomers.Notification');
}
}
/**
* Toggle the newsletter flag.
*/
public function processChangeNewsletterVal()
{
$customer = new Customer($this->id_object);
if (!Validate::isLoadedObject($customer)) {
$this->errors[] = $this->trans('An error occurred while updating customer information.', array(), 'Admin.Orderscustomers.Notification');
}
$customer->newsletter = $customer->newsletter ? 0 : 1;
if (!$customer->update()) {
$this->errors[] = $this->trans('An error occurred while updating customer information.', array(), 'Admin.Orderscustomers.Notification');
}
Tools::redirectAdmin(self::$currentIndex . '&token=' . $this->token);
}
/**
* Toggle newsletter optin flag.
*/
public function processChangeOptinVal()
{
$customer = new Customer($this->id_object);
if (!Validate::isLoadedObject($customer)) {
$this->errors[] = $this->trans('An error occurred while updating customer information.', array(), 'Admin.Orderscustomers.Notification');
}
$customer->optin = $customer->optin ? 0 : 1;
if (!$customer->update()) {
$this->errors[] = $this->trans('An error occurred while updating customer information.', array(), 'Admin.Orderscustomers.Notification');
}
Tools::redirectAdmin(self::$currentIndex . '&token=' . $this->token);
}
public function printNewsIcon($value, $customer)
{
return '<a class="list-action-enable ' . ($value ? 'action-enabled' : 'action-disabled') . '" href="index.php?' . htmlspecialchars('tab=AdminCustomers&id_customer='
. (int) $customer['id_customer'] . '&changeNewsletterVal&token=' . Tools::getAdminTokenLite('AdminCustomers')) . '">
' . ($value ? '<i class="icon-check"></i>' : '<i class="icon-remove"></i>') .
'</a>';
}
public function printOptinIcon($value, $customer)
{
return '<a class="list-action-enable ' . ($value ? 'action-enabled' : 'action-disabled') . '" href="index.php?' . htmlspecialchars('tab=AdminCustomers&id_customer='
. (int) $customer['id_customer'] . '&changeOptinVal&token=' . Tools::getAdminTokenLite('AdminCustomers')) . '">
' . ($value ? '<i class="icon-check"></i>' : '<i class="icon-remove"></i>') .
'</a>';
}
/**
* @param string $token
* @param int $id
* @param string $name
*
* @return mixed
*/
public function displayDeleteLink($token, $id, $name = null)
{
$tpl = $this->createTemplate('helpers/list/list_action_delete.tpl');
$customer = new Customer($id);
$name = $customer->lastname . ' ' . $customer->firstname;
$name = '\n\n' . $this->trans('Name:', array(), 'Admin.Global') . ' ' . $name;
$tpl->assign(array(
'href' => self::$currentIndex . '&' . $this->identifier . '=' . $id . '&delete' . $this->table . '&token=' . ($token != null ? $token : $this->token),
'confirm' => $this->trans('Delete the selected item?', array(), 'Admin.Notifications.Info') . $name,
'action' => $this->trans('Delete', array(), 'Admin.Actions'),
'id' => $id,
));
return $tpl->fetch();
}
/**
* add to $this->content the result of Customer::SearchByName
* (encoded in json).
*/
public function ajaxProcessSearchCustomers()
{
$searches = explode(' ', Tools::getValue('customer_search'));
$customers = array();
$searches = array_unique($searches);
foreach ($searches as $search) {
if (!empty($search) && $results = Customer::searchByName($search, 50)) {
foreach ($results as $result) {
if ($result['active']) {
$result['fullname_and_email'] = $result['firstname'] . ' ' . $result['lastname'] . ' - ' . $result['email'];
$customers[$result['id_customer']] = $result;
}
}
}
}
if (count($customers) && Tools::getValue('sf2')) {
$to_return = $customers;
} elseif (count($customers) && !Tools::getValue('sf2')) {
$to_return = array(
'customers' => $customers,
'found' => true,
);
} else {
$to_return = Tools::getValue('sf2') ? array() : array('found' => false);
}
$this->content = json_encode($to_return);
}
/**
* Uodate the customer note.
*/
public function ajaxProcessUpdateCustomerNote()
{
if ($this->access('edit')) {
$note = Tools::htmlentitiesDecodeUTF8(Tools::getValue('note'));
$customer = new Customer((int) Tools::getValue('id_customer'));
if (!Validate::isLoadedObject($customer)) {
die('error:update');
}
if (!empty($note) && !Validate::isCleanHtml($note)) {
die('error:validation');
}
$customer->note = $note;
if (!$customer->update()) {
die('error:update');
}
die('ok');
}
}
}