156 lines
7.9 KiB
PHP
156 lines
7.9 KiB
PHP
<?php
|
|
/**
|
|
* 2007-2021 ETS-Soft
|
|
*
|
|
* NOTICE OF LICENSE
|
|
*
|
|
* This file is not open source! Each license that you purchased is only available for 1 wesite only.
|
|
* If you want to use this file on more websites (or projects), you need to purchase additional licenses.
|
|
* You are not allowed to redistribute, resell, lease, license, sub-license or offer our resources to any third party.
|
|
*
|
|
* 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 contact us for extra customization service at an affordable price
|
|
*
|
|
* @author ETS-Soft <etssoft.jsc@gmail.com>
|
|
* @copyright 2007-2021 ETS-Soft
|
|
* @license Valid for 1 website (or project) for each purchase of license
|
|
* International Registered Trademark & Property of ETS-Soft
|
|
*/
|
|
|
|
if (!defined('_PS_VERSION_'))
|
|
exit;
|
|
require_once(_PS_MODULE_DIR_ . 'ets_cfultimate/classes/ETS_CFU_Pagination.php');
|
|
|
|
class AdminContactFormUltimateContactFormController extends ModuleAdminController
|
|
{
|
|
public function __construct()
|
|
{
|
|
parent::__construct();
|
|
$this->bootstrap = true;
|
|
if (($conf = Tools::getValue('conf')) && !(isset($this->context->controller->_conf[$conf])) && $conf == 99) {
|
|
$this->context->controller->_conf[$conf] = $this->module->l('Imported successfully');
|
|
}
|
|
}
|
|
|
|
public function initContent()
|
|
{
|
|
$this->context->controller->addJqueryUI('ui.sortable');
|
|
parent::initContent();
|
|
if (Tools::getValue('action') == 'etsCfuUpdateContactFormOrdering' && $formcontact = Tools::getValue('formcontact')) {
|
|
$page = Tools::getValue('page', 1);
|
|
foreach ($formcontact as $key => $form) {
|
|
$position = $key + ($page - 1) * 20;
|
|
Db::getInstance()->execute('UPDATE ' . _DB_PREFIX_ . 'ets_cfu_contact SET position="' . (int)$position . '" WHERE id_contact=' . (int)$form);
|
|
}
|
|
die(
|
|
Tools::jsonEncode(
|
|
array(
|
|
'page' => $page,
|
|
)
|
|
)
|
|
);
|
|
}
|
|
}
|
|
|
|
public function renderList()
|
|
{
|
|
$filter = '';
|
|
$url_extra = '';
|
|
$values_submit = array();
|
|
if (Tools::getValue('id_contact')) {
|
|
$filter .= ' AND c.id_contact="' . (int)Tools::getValue('id_contact') . '"';
|
|
$url_extra .= '&id_contact=' . (int)Tools::getValue('id_contact');
|
|
$values_submit['id_contact'] = Tools::getValue('id_contact');
|
|
}
|
|
if (Tools::getValue('contact_title')) {
|
|
$filter .= ' AND cl.title like "' . pSQL(Tools::getValue('contact_title')) . '"';
|
|
$url_extra .= '&contact_title=' . Tools::getValue('contact_title');
|
|
$values_submit['contact_title'] = Tools::getValue('contact_title');
|
|
}
|
|
if (Tools::getValue('hook')) {
|
|
$filter .= ' AND c.hook like "%' . pSQL(Tools::getValue('hook')) . '%"';
|
|
$url_extra .= '&hook=' . Tools::getValue('hook');
|
|
$values_submit['hook'] = Tools::getValue('hook');
|
|
}
|
|
if (Tools::getValue('messageFilter_dateadd_from')) {
|
|
$filter .= ' AND c.date_add >="' . pSQL(Tools::getValue('messageFilter_dateadd_from')) . '"';
|
|
$url_extra .= '&messageFilter_dateadd_from=' . Tools::getValue('messageFilter_dateadd_from');
|
|
$values_submit['messageFilter_dateadd_from'] = Tools::getValue('messageFilter_dateadd_from');
|
|
}
|
|
if (Tools::getValue('messageFilter_dateadd_to')) {
|
|
$filter .= ' AND c.date_add <= "' . pSQL(Tools::getValue('messageFilter_dateadd_to')) . '"';
|
|
$url_extra .= '&messageFilter_dateadd_to=' . Tools::getValue('messageFilter_dateadd_to');
|
|
$values_submit['messageFilter_dateadd_to'] = Tools::getValue('messageFilter_dateadd_to');
|
|
}
|
|
if (Tools::getValue('save_message') != '') {
|
|
$filter .= ' AND c.save_message = "' . (int)Tools::getValue('save_message') . '"';
|
|
$url_extra .= '&save_message=' . Tools::getValue('save_message');
|
|
$values_submit['save_message'] = Tools::getValue('save_message');
|
|
}
|
|
if (Tools::getValue('active_contact') != '') {
|
|
$filter .= ' AND c.active = "' . (int)Tools::getValue('active_contact') . '"';
|
|
$url_extra .= '&active_contact=' . Tools::getValue('active_contact');
|
|
$values_submit['active_contact'] = Tools::getValue('active_contact');
|
|
}
|
|
if (Tools::getValue('sort') == 'id_contact')
|
|
$sort = 'c.id_contact';
|
|
else
|
|
$sort = Tools::getValue('sort', 'position');
|
|
$sort_type = Tools::getValue('sort_type', 'asc');
|
|
$total = $this->module->getContacts(false, $filter, 0, 0, true);
|
|
$limit = 20;
|
|
$page = Tools::getValue('page', 1);
|
|
$start = ($page - 1) * $limit;
|
|
$pagination = new ETS_CFU_Pagination();
|
|
$pagination->url = $this->context->link->getAdminLink('AdminContactFormUltimateContactForm', true) . $url_extra . '&page=_page_';
|
|
$pagination->limit = $limit;
|
|
$pagination->page = $page;
|
|
$pagination->total = $total;
|
|
$contacts = $this->module->getContacts(false, $filter, $start, $limit, false, $sort, $sort_type);
|
|
if ($contacts) {
|
|
foreach ($contacts as &$contact) {
|
|
$contact['hooks'] = explode(',', $contact['hook']);
|
|
if ($contact['enable_form_page'])
|
|
$contact['link'] = Ets_CfUltimate::getLinkContactForm($contact['id_contact']);
|
|
$contact['count_views'] = Db::getInstance()->getValue('SELECT COUNT(*) FROM ' . _DB_PREFIX_ . 'ets_cfu_log WHERE id_contact=' . (int)$contact['id_contact']);
|
|
$contact['count_message'] = Db::getInstance()->getValue('SELECT COUNT(*) FROM ' . _DB_PREFIX_ . 'ets_cfu_contact_message WHERE id_contact=' . (int)$contact['id_contact']);
|
|
}
|
|
}
|
|
$hooks = array(
|
|
'nav_top' => $this->module->l('Header - top navigation'),
|
|
'header' => $this->module->l('Header - main header'),
|
|
'displayTop' => $this->module->l('Top'),
|
|
'home' => $this->module->l('Home'),
|
|
'left_column' => $this->module->l('Left column'),
|
|
'footer' => $this->module->l('Footer'),
|
|
'right_column' => $this->module->l('Right column'),
|
|
'product_thumbs' => $this->module->l('Product page - below product image'),
|
|
'product_right' => $this->module->l('Product page - right column'),
|
|
'product_left' => $this->module->l('Product page - left column'),
|
|
'checkout_page' => $this->module->l('Checkout page'),
|
|
'register_page' => $this->module->l('Register page'),
|
|
'login_page' => $this->module->l('Login page'),
|
|
);
|
|
$this->context->smarty->assign(
|
|
array(
|
|
'ets_cfu_contacts' => $contacts,
|
|
'url_module' => $this->context->link->getAdminLink('AdminModules', true) . '&configure=' . $this->module->name . '&tab_module=' . $this->module->tab . '&module_name=' . $this->module->name,
|
|
'ets_cfu_pagination_text' => $pagination->render(),
|
|
'filter' => $filter,
|
|
'filter_params' => $url_extra,
|
|
'is_ps15' => version_compare(_PS_VERSION_, '1.6', '<') ? true : false,
|
|
'etsCfuOkImport' => Tools::getValue('etsCfuOkImport'),
|
|
'hooks' => $hooks,
|
|
'sort' => Tools::getValue('sort', 'position'),
|
|
'sort_type' => Tools::getValue('sort_type', 'asc'),
|
|
'_PS_JS_DIR_' => _PS_JS_DIR_,
|
|
'ETS_CFU_ENABLE_TMCE' => Configuration::get('ETS_CFU_ENABLE_TMCE'),
|
|
'showShortcodeHook' =>Configuration::get('ETS_CFU_ENABLE_HOOK_SHORTCODE')
|
|
)
|
|
);
|
|
return $this->module->display($this->module->getLocalPath(), 'list-contact.tpl');
|
|
}
|
|
} |