예제 #1
0
 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();
    }
예제 #3
0
 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();
    }
예제 #5
0
 public function renderList()
 {
     $this->addRowAction('edit');
     $this->addRowAction('delete');
     $this->_where = 'AND a.`deleted` = 0';
     return parent::renderList();
 }
예제 #6
0
    public function renderList()
    {
        $this->displayInformation('&nbsp;<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'] .= '&amp;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&amp;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();
     }
 }
예제 #15
0
 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();
 }
예제 #17
0
 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();
 }
예제 #18
0
 /**
  * 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();
 }
예제 #19
0
 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();
 }
예제 #20
0
 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();
    }
예제 #22
0
 /**
  * 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 . '&amp;addfeature_value&amp;token=' . $this->token, 'desc' => $this->l('Add new feature values'));
     $this->toolbar_btn['new'] = array('href' => self::$currentIndex . '&amp;addfeature&amp;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();
 }
예제 #24
0
    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();
    }
예제 #25
0
 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();
 }
예제 #28
0
    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();
    }
예제 #30
0
    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();
    }