public function renderList()
{
$this->_select = 'b.*';
$this->_join = 'INNER JOIN `' . _DB_PREFIX_ . 'carrier_lang` b ON a.id_carrier = b.id_carrier' . Shop::addSqlRestrictionOnLang('b') . ' AND b.id_lang = ' . $this->context->language->id . ' LEFT JOIN `' . _DB_PREFIX_ . 'carrier_tax_rules_group_shop` ctrgs ON (a.`id_carrier` = ctrgs.`id_carrier` AND ctrgs.id_shop=' . (int) $this->context->shop->id . ')';
$this->_use_found_rows = false;
return parent::renderList();
}
public function initRulesList($id_group)
{
$this->table = 'tax_rule';
$this->list_id = 'tax_rule';
$this->identifier = 'id_tax_rule';
$this->className = 'TaxRule';
$this->lang = false;
$this->list_simple_header = false;
$this->toolbar_btn = null;
$this->list_no_link = true;
$this->bulk_actions = array('delete' => array('text' => $this->l('Delete selected'), 'confirm' => $this->l('Delete selected items?'), 'icon' => 'icon-trash'));
$this->fields_list = array('country_name' => array('title' => $this->l('Country')), 'state_name' => array('title' => $this->l('State')), 'zipcode' => array('title' => $this->l('Zip/Postal code'), 'class' => 'fixed-width-md'), 'behavior' => array('title' => $this->l('Behavior')), 'rate' => array('title' => $this->l('Tax'), 'class' => 'fixed-width-sm'), 'description' => array('title' => $this->l('Description')));
$this->addRowAction('edit');
$this->addRowAction('delete');
$this->_select = '
c.`name` AS country_name,
s.`name` AS state_name,
CONCAT_WS(" - ", a.`zipcode_from`, a.`zipcode_to`) AS zipcode,
t.rate';
$this->_join = '
LEFT JOIN `' . _DB_PREFIX_ . 'country_lang` c
ON (a.`id_country` = c.`id_country` AND id_lang = ' . (int) $this->context->language->id . ')
LEFT JOIN `' . _DB_PREFIX_ . 'state` s
ON (a.`id_state` = s.`id_state`)
LEFT JOIN `' . _DB_PREFIX_ . 'tax` t
ON (a.`id_tax` = t.`id_tax`)';
$this->_where = 'AND `id_tax_rules_group` = ' . (int) $id_group;
$this->show_toolbar = false;
$this->tpl_list_vars = array('id_tax_rules_group' => (int) $id_group);
return parent::renderList();
}
public function renderList()
{
$this->tpl_list_vars['zones'] = Zone::getZones();
$this->tpl_list_vars['REQUEST_URI'] = $_SERVER['REQUEST_URI'];
$this->tpl_list_vars['POST'] = $_POST;
return parent::renderList();
}
public function renderList()
{
$this->addRowAction('view');
$this->addRowAction('delete');
$this->_select = '
CONCAT(c.`firstname`," ",c.`lastname`) as customer, cl.`name` as contact, l.`name` as language, group_concat(message) as messages,
(
SELECT IFNULL(CONCAT(LEFT(e.`firstname`, 1),". ",e.`lastname`), "--")
FROM `' . _DB_PREFIX_ . 'customer_message` cm2
INNER JOIN ' . _DB_PREFIX_ . 'employee e
ON e.`id_employee` = cm2.`id_employee`
WHERE cm2.id_employee > 0
AND cm2.`id_customer_thread` = a.`id_customer_thread`
ORDER BY cm2.`date_add` DESC LIMIT 1
) as employee';
$this->_join = '
LEFT JOIN `' . _DB_PREFIX_ . 'customer` c
ON c.`id_customer` = a.`id_customer`
LEFT JOIN `' . _DB_PREFIX_ . 'customer_message` cm
ON cm.`id_customer_thread` = a.`id_customer_thread`
LEFT JOIN `' . _DB_PREFIX_ . 'lang` l
ON l.`id_lang` = a.`id_lang`
LEFT JOIN `' . _DB_PREFIX_ . 'contact_lang` cl
ON (cl.`id_contact` = a.`id_contact` AND cl.`id_lang` = ' . (int) $this->context->language->id . ')';
$this->_group = 'GROUP BY cm.id_customer_thread';
$contacts = CustomerThread::getContacts();
$categories = Contact::getCategoriesContacts();
$params = array($this->l('Total threads') => $all = CustomerThread::getTotalCustomerThreads(), $this->l('Threads pending') => $pending = CustomerThread::getTotalCustomerThreads('status LIKE "%pending%"'), $this->l('Total number of customer messages') => CustomerMessage::getTotalCustomerMessages('id_employee = 0'), $this->l('Total number of employee messages') => CustomerMessage::getTotalCustomerMessages('id_employee != 0'), $this->l('Unread threads') => $unread = CustomerThread::getTotalCustomerThreads('status = "open"'), $this->l('Closed threads') => $all - ($unread + $pending));
$this->tpl_list_vars = array('contacts' => $contacts, 'categories' => $categories, 'params' => $params);
return parent::renderList();
}
public function renderList()
{
$this->addRowAction('edit');
$this->addRowAction('delete');
$this->_where = 'AND a.`deleted` = 0';
return parent::renderList();
}
public function renderList()
{
$this->displayInformation(' <b>' . $this->l('How do I create a new carrier?') . '</b>
<br />
<ul>
<li>' . $this->l('Click "Add New."') . '<br /></li>
<li>' . $this->l('Fill in the fields and click "Save."') . '</li>
<li>' . $this->l('You need to set a price range -- or weight range -- for which the new carrier will be available.') . ' ' . $this->l('Under the "Shipping" menu, click either "Price ranges" or "Weight ranges.".') . '
</li>
<li>' . $this->l('Click "Add New."') . '</li>
<li>' . $this->l('Select the name of the carrier before defining the price or weight range.') . ' ' . $this->l('For example, the carrier can be made available for a weight range between 0 and 5lbs. Another carrier can have a range between 5 and 10lbs.') . '
</li>
<li>' . $this->l('When you\'re done, click "Save."') . '</li>
<li>' . $this->l('Click on the "Shipping" menu.') . '</li>
<li>' . $this->l('You need to set the fees that will be applied for this carrier.') . ' ' . $this->l('At the bottom on the page -- in the "Fees" section -- select the name of the carrier.') . '
</li>
<li>' . $this->l('For each zone, enter a price and then click "Save."') . '</li>
<li>' . $this->l('You\'re all set! The new carrier will now be displayed to customers.') . '</li>
</ul>');
$this->_select = 'b.*';
$this->_join = 'LEFT JOIN `' . _DB_PREFIX_ . 'carrier_lang` b ON a.id_carrier = b.id_carrier' . Shop::addSqlRestrictionOnLang('b') . '
LEFT JOIN `' . _DB_PREFIX_ . 'carrier_tax_rules_group_shop` ctrgs ON (a.`id_carrier` = ctrgs.`id_carrier`
AND ctrgs.id_shop=' . (int) $this->context->shop->id . ')';
$this->_where = 'AND b.id_lang = ' . $this->context->language->id;
return parent::renderList();
}
/**
* AdminController::renderList() override
* @see AdminController::renderList()
*/
public function renderList()
{
$this->addRowAction('edit');
$this->addRowAction('delete');
$this->addRowAction('details');
return parent::renderList();
}
public function renderList()
{
$this->initToolbar();
$this->toolbar_btn['new']['href'] .= '&id_parent=' . (int) Tools::getValue('id_cms_category');
$this->initTabModuleList();
return parent::renderList();
}
/**
* AdminController::renderList() override
* @see AdminController::renderList()
*/
public function renderList()
{
// removes links on rows
$this->list_no_link = true;
// adds actions on rows
$this->addRowAction('edit');
$this->addRowAction('view');
$this->addRowAction('delete');
// query: select
$this->_select = '
reference,
name,
management_type,
CONCAT(e.lastname, \' \', e.firstname) as employee,
ad.phone as contact,
CONCAT(ad.city, \' - \', c.iso_code) as location';
// query: join
$this->_join = '
LEFT JOIN `' . _DB_PREFIX_ . 'employee` e ON (e.id_employee = a.id_employee)
LEFT JOIN `' . _DB_PREFIX_ . 'address` ad ON (ad.id_address = a.id_address)
LEFT JOIN `' . _DB_PREFIX_ . 'country` c ON (c.id_country = ad.id_country)';
$this->_use_found_rows = false;
// display help informations
$this->displayInformation($this->l('This interface allows you to manage your warehouses.') . '<br />');
$this->displayInformation($this->l('Before adding stock in your warehouses, you should check the default currency used.') . '<br />');
$this->displayInformation($this->l('You should also check the management type (according to the law in your country), the valuation currency and its associated carriers and shops.') . '<br />');
$this->displayInformation($this->l('You can also see detailed information about your stock, such as its overall value, the number of products and quantities stored, etc.'));
$this->displayInformation($this->l('Be careful! Products from different warehouses will need to be shipped in different packages.'));
return parent::renderList();
}
public function renderView()
{
if ($id = Tools::getValue('id_feature')) {
$this->setTypeValue();
$this->list_id = 'feature_value';
$this->position_identifier = 'id_feature_value';
$this->position_group_identifier = 'id_feature';
$this->lang = true;
// Action for list
$this->addRowAction('edit');
$this->addRowAction('delete');
if (!Validate::isLoadedObject($obj = new Feature((int) $id))) {
$this->errors[] = Tools::displayError('An error occurred while updating the status for an object.') . '
<b>' . $this->table . '</b> ' . Tools::displayError('(cannot load object)');
return;
}
$this->feature_name = $obj->name;
$this->toolbar_title = $this->feature_name[$this->context->employee->id_lang];
$this->fields_list = array('id_feature_value' => array('title' => $this->l('ID'), 'align' => 'center', 'class' => 'fixed-width-xs'), 'value' => array('title' => $this->l('Value')), 'position' => array('title' => $this->l('Position'), 'filter_key' => 'a!position', 'align' => 'center', 'class' => 'fixed-width-xs', 'position' => 'position'));
$this->_where = sprintf('AND `id_feature` = %d', (int) $id);
$this->_orderBy = 'position';
self::$currentIndex = self::$currentIndex . '&id_feature=' . (int) $id . '&viewfeature';
$this->processFilter();
return AdminController::renderList();
}
}
/**
* Render form
* @return string
*/
public function renderList()
{
$this->form = '
<div class="row">
<table class="table">
<thead>
<tr>
<th><span class="title_box ">Test</span></th>
<th><span class="title_box ">Test</span></th>
<th><span class="title_box ">Test</span></th>
</tr>
</thead>
<tbody>
</tbody>
</table>
</div>
<div class="row">
<div class="col-lg-12">
<a class="btn btn-default pull-right" href="' . Tools::safeOutput($_SERVER['REQUEST_URI']) . '&refresh=1&refreshType=1">
<i class="icon-refresh"></i> ' . $this->l('Refresh') . '
</a>
</div>
</div>';
$this->context->smarty->assign('form', $this->form);
$this->output .= $this->context->smarty->fetch($this->path . 'views/templates/admin/socialuserheaderadmin.tpl');
//$this->context->smarty->assign('current_url', '?controller=AdminXlsProductImport2&token='.Tools::getAdminTokenLite('AdminSocialUserProfile'));
return $this->output . parent::renderList();
}
public function renderList()
{
$this->_select = 'z.`name` AS zone';
$this->_join = 'LEFT JOIN `' . _DB_PREFIX_ . 'zone` z ON (z.`id_zone` = a.`id_zone`)';
$this->tpl_list_vars['zones'] = Zone::getZones();
return parent::renderList();
}
/**
* AdminController::renderList() override
* @see AdminController::renderList()
*/
public function renderList()
{
// sets actions
$this->addRowAction('details');
$this->addRowAction('addstock');
$this->addRowAction('removestock');
$this->addRowAction('transferstock');
// no link on list rows
$this->list_no_link = true;
// inits toolbar
$this->toolbar_btn = array();
// overrides query
$this->_select = 'a.id_product as id, COUNT(pa.id_product_attribute) as variations';
$this->_join = 'LEFT JOIN `' . _DB_PREFIX_ . 'product_attribute` pa ON (pa.id_product = a.id_product)' . Shop::addSqlAssociation('product_attribute', 'pa', false);
$this->_where = 'AND a.cache_is_pack = 0 AND a.is_virtual = 0';
$this->_group = 'GROUP BY a.id_product';
// displays informations
$this->displayInformation($this->l('This interface allows you to manage product stock and their variations.') . '<br />');
$this->displayInformation($this->l('Through this interface, you can increase and decrease product stock for an given warehouse.'));
$this->displayInformation($this->l('Furthermore, you can alter product quantities between warehouses, or within one warehouse.') . '<br />');
$this->displayInformation($this->l('If you want to increase quantities of multiple products at once, you can use the "Supply orders" page under the "Stock" menu.') . '<br />');
$this->displayInformation($this->l('Finally, you need to provide the quantity that you\'ll be adding:'));
$this->displayInformation($this->l('Usable for sale means that this quantity will be available in your shop(s),'));
$this->displayInformation($this->l('otherwise it will be considered reserved (i.e. for other purposes).'));
return parent::renderList();
}
public function renderView()
{
if ($id = Tools::getValue('id_attribute_group')) {
$this->table = 'attribute';
$this->className = 'Attribute';
$this->identifier = 'id_attribute';
$this->position_identifier = 'id_attribute';
$this->position_group_identifier = 'id_attribute_group';
$this->list_id = 'attribute_values';
$this->lang = true;
if (!Validate::isLoadedObject($obj = new AttributeGroup((int) $id))) {
$this->errors[] = Tools::displayError('An error occurred while updating the status for an object.') . ' <b>' . $this->table . '</b> ' . Tools::displayError('(cannot load object)');
return;
}
$this->attribute_name = $obj->name;
$this->fields_list = array('id_attribute' => array('title' => $this->l('ID'), 'align' => 'center', 'class' => 'fixed-width-xs'), 'name' => array('title' => $this->l('Value'), 'width' => 'auto', 'filter_key' => 'b!name'));
if ($obj->group_type == 'color') {
$this->fields_list['color'] = array('title' => $this->l('Color'), 'filter_key' => 'b!color');
}
$this->fields_list['position'] = array('title' => $this->l('Position'), 'filter_key' => 'a!position', 'position' => 'position', 'class' => 'fixed-width-md');
$this->addRowAction('edit');
$this->addRowAction('delete');
$this->_where = 'AND a.`id_attribute_group` = ' . (int) $id;
$this->_orderBy = 'position';
self::$currentIndex = self::$currentIndex . '&id_attribute_group=' . (int) $id . '&viewattribute_group';
$this->processFilter();
return parent::renderList();
}
}
public function renderList()
{
$this->addRowAction('edit');
$this->addRowAction('delete');
$this->displayWarning($this->l('When you delete a language, all related translations in the database will be deleted.'));
$this->displayInformation($this->l('Your .htaccess file must be writable.'));
return parent::renderList();
}
public function renderList()
{
$this->initToolbar();
if (isset($this->toolbar_btn['new'])) {
$this->toolbar_btn['new']['href'] .= '&id_parent=' . (int) Tools::getValue('id_cms_category');
}
return parent::renderList();
}
public function renderList()
{
$this->_group = 'GROUP BY a.`id_cms`';
//self::$currentIndex = self::$currentIndex.'&cms';
$this->position_group_identifier = (int) $this->id_cms_category;
$this->toolbar_title = $this->l('Pages in this category');
$this->toolbar_btn['new'] = array('href' => self::$currentIndex . '&add' . $this->table . '&id_cms_category=' . (int) $this->id_cms_category . '&token=' . $this->token, 'desc' => $this->l('Add new'));
return parent::renderList();
}
/**
* AdminController::renderList() override
* @see AdminController::renderList()
*/
public function renderList()
{
$this->addRowAction('edit');
$this->addRowAction('delete');
$this->addRowAction('details');
$this->_where = 'AND a.`id_parent` = 0';
$this->_orderBy = 'position';
return parent::renderList();
}
public function renderList()
{
$this->addRowAction('edit');
$this->addRowAction('delete');
$this->displayWarning($this->l('When you delete a language, all related translations in the database will be deleted.'));
if (!is_writable(_PS_ROOT_DIR_ . '/.htaccess') && Configuration::get('PS_REWRITING_SETTINGS')) {
$this->displayInformation($this->l('Your .htaccess file must be writable.'));
}
return parent::renderList();
}
public function renderList()
{
$this->_select = 'z.`name` AS zone';
$this->_join = 'LEFT JOIN `' . _DB_PREFIX_ . 'zone` z ON (z.`id_zone` = a.`id_zone`)';
$this->_use_found_rows = false;
$this->tpl_list_vars['zones'] = Zone::getZones();
$this->tpl_list_vars['REQUEST_URI'] = $_SERVER['REQUEST_URI'];
$this->tpl_list_vars['POST'] = $_POST;
return parent::renderList();
}
public function renderList()
{
$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` = ' . (int) $this->context->language->id . ')
LEFT JOIN `' . _DB_PREFIX_ . 'customer` c ON a.id_customer = c.id_customer
';
$this->_where = 'AND a.id_customer != 0 ' . Shop::addSqlRestriction(Shop::SHARE_CUSTOMER, 'c');
return parent::renderList();
}
/**
* AdminController::renderList() override
* @see AdminController::renderList()
*/
public function renderList()
{
$this->addRowAction('edit');
$this->addRowAction('delete');
$this->addRowAction('details');
$this->_defaultOrderBy = 'position';
// Added specific button in toolbar
$this->toolbar_btn['newAttributes'] = array('href' => self::$currentIndex . '&addfeature_value&token=' . $this->token, 'desc' => $this->l('Add new feature values'));
$this->toolbar_btn['new'] = array('href' => self::$currentIndex . '&addfeature&token=' . $this->token, 'desc' => $this->l('Add a new feature'));
return parent::renderList();
}
public function renderList()
{
$this->addRowActionSkipList('delete', array(1));
$this->addRowAction('edit');
$this->addRowAction('delete');
$this->_select = 's.name AS shop_name, CONCAT(\'http://\', a.domain, a.physical_uri, a.virtual_uri) AS url';
$this->_join = 'LEFT JOIN `' . _DB_PREFIX_ . 'shop` s ON (s.id_shop = a.id_shop)';
if ($id_shop = (int) Tools::getValue('id_shop')) {
$this->_where = 'AND a.id_shop = ' . $id_shop;
}
return parent::renderList();
}
public function renderList()
{
$this->addRowAction('edit');
$this->addRowAction('delete');
$this->_select = 'l.name as lang, COUNT(pt.id_product) as products';
$this->_join = '
LEFT JOIN `' . _DB_PREFIX_ . 'product_tag` pt
ON (a.`id_tag` = pt.`id_tag`)
LEFT JOIN `' . _DB_PREFIX_ . 'lang` l
ON (l.`id_lang` = a.`id_lang`)';
$this->_group = 'GROUP BY a.name, a.id_lang';
return parent::renderList();
}
public function renderList()
{
$this->_select = 'b.*';
$this->_join = 'INNER JOIN `' . _DB_PREFIX_ . 'carrier_lang` b ON a.id_carrier = b.id_carrier' . Shop::addSqlRestrictionOnLang('b') . ' AND b.id_lang = ' . (int) $this->context->language->id . ' LEFT JOIN `' . _DB_PREFIX_ . 'carrier_tax_rules_group_shop` ctrgs ON (a.`id_carrier` = ctrgs.`id_carrier` AND ctrgs.id_shop=' . (int) $this->context->shop->id . ')';
$this->_use_found_rows = false;
// Removes the Recommended modules button
unset($this->page_header_toolbar_btn['modules-list']);
// test if need to show header alert.
$sql = 'SELECT COUNT(1) FROM `' . _DB_PREFIX_ . 'carrier` WHERE deleted = 0 AND id_reference > 2';
$showHeaderAlert = Db::getInstance()->query($sql)->fetchColumn(0) == 0;
// Assign them in two steps! Because renderModulesList needs it before to be called.
$this->context->smarty->assign('panel_title', $this->trans('Use one of our recommended carrier modules', array(), 'Admin.Shipping.Feature'));
$this->context->smarty->assign(array('showHeaderAlert' => $showHeaderAlert, 'modules_list' => $this->renderModulesList('back-office,AdminCarriers,new')));
return parent::renderList();
}
public function renderList()
{
$this->addRowAction('edit');
$this->addRowAction('delete');
$cron_url = $this->getBaseURL() . 'modules/superabandonedcart/launch_campaings.php?secure_key=' . Configuration::get('SUPER_AC_SECURE_KEY');
$header = '<div class="alert alert-info">
<p> ' . $this->l('Don\'t forget to set cron task :') . ' </p>
<p><b> */30 * * * * wget -O /dev/null ' . $cron_url . '</b></p>
<br/>
<p><b>' . $this->l('All email send is also send to : ') . Configuration::get('PS_SHOP_EMAIL') . '</b></p>
</div>';
return $header . parent::renderList() . $this->renderHistoryList();
}
public function renderList()
{
if (isset($this->_filter) && trim($this->_filter) == '') {
$this->_filter = $this->original_filter;
}
$this->_group = 'GROUP BY a.`id_smart_blog_category`';
if (isset($this->toolbar_btn['new'])) {
$this->toolbar_btn['new']['href'] .= '&id_parent=' . (int) pSQL(Tools::getValue('id_smart_blog_category'));
}
$this->addRowAction('view');
$this->addRowAction('add');
$this->addRowAction('edit');
$this->addRowAction('delete');
return parent::renderList();
}
public function renderList()
{
// Set toolbar options
$this->display = null;
$this->initToolbar();
$this->addRowAction('edit');
$this->addRowAction('delete');
$this->_select = 'cl.`name` country, st.`name` state';
$this->_join = '
LEFT JOIN `' . _DB_PREFIX_ . 'country_lang` cl
ON (cl.`id_country` = a.`id_country`
AND cl.`id_lang` = ' . (int) $this->context->language->id . ')
LEFT JOIN `' . _DB_PREFIX_ . 'state` st
ON (st.`id_state` = a.`id_state`)';
return parent::renderList();
}
public function renderList()
{
// Display list Referrers:
$this->addRowAction('view');
$this->addRowAction('edit');
$this->addRowAction('delete');
$this->_select = 'SUM(sa.cache_visitors) AS cache_visitors, SUM(sa.cache_visits) AS cache_visits, SUM(sa.cache_pages) AS cache_pages,
SUM(sa.cache_registrations) AS cache_registrations, SUM(sa.cache_orders) AS cache_orders, SUM(sa.cache_sales) AS cache_sales,
IF(sa.cache_orders > 0, ROUND(sa.cache_sales/sa.cache_orders, 2), 0) as cart, (sa.cache_visits*click_fee) as fee0,
(sa.cache_orders*base_fee) as fee1, (sa.cache_sales*percent_fee/100) as fee2';
$this->_join = '
LEFT JOIN `' . _DB_PREFIX_ . 'referrer_shop` sa
ON (sa.' . $this->identifier . ' = a.' . $this->identifier . ' AND sa.id_shop IN (' . implode(', ', Shop::getContextListShopID()) . '))';
$this->_group = 'GROUP BY sa.id_referrer';
$this->tpl_list_vars = array('enable_calendar' => $this->enableCalendar(), 'calendar_form' => $this->displayCalendar(), 'settings_form' => $this->displaySettings());
return parent::renderList();
}
public function renderList()
{
// Set toolbar options
$this->display = null;
$this->initToolbar();
$this->displayWarning($this->l('When saving the query, only the "SELECT" SQL statement is allowed.'));
$this->displayInformation('
<strong>' . $this->l('How do I create a new SQL query?') . '</strong><br />
<ul>
<li>' . $this->l('Click "Add New".') . '</li>
<li>' . $this->l('Fill in the fields and click "Save".') . '</li>
<li>' . $this->l('You can then view the query results by clicking on the Edit action in the dropdown menu: ') . ' <i class="icon-pencil"></i></li>
<li>' . $this->l('You can also export the query results as a CSV file by clicking on the Export button: ') . ' <i class="icon-cloud-upload"></i></li>
</ul>');
$this->addRowAction('export');
$this->addRowAction('view');
$this->addRowAction('edit');
$this->addRowAction('delete');
return parent::renderList();
}