Файловый менеджер

Файловый менеджер - Редактировать - /home/lmsyaran/public_html/j3/administrator/components/com_phocacart/models/phocacartsubmititems.php

Назад
<?php /* @package Joomla * @copyright Copyright (C) Open Source Matters. All rights reserved. * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php * @extension Phoca Extension * @copyright Copyright (C) Jan Pavelka www.phoca.cz * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL / defined( '_JEXEC' ) or die(); jimport( 'joomla.application.component.modellist' ); jimport( 'joomla.filesystem.folder' ); jimport( 'joomla.filesystem.file' ); class PhocaCartCpModelPhocaCartSubmititems extends JModelList { protected $option = 'com_phocacart'; public function __construct($config = array()) { if (empty($config['filter_fields'])) { $config['filter_fields'] = array( 'id', 'a.id', 'title', 'a.title', 'alias', 'a.alias', 'date_submit', 'a.date_submit', 'checked_out', 'a.checked_out', 'checked_out_time', 'a.checked_out_time', 'date_submit', 'a.date_submit', 'published','a.published', 'user_id','a.user_id', 'user_username' ); } parent::__construct($config); } protected function populateState($ordering = 'a.date_submit', $direction = 'DESC') { // Initialise variables. $app = JFactory::getApplication('administrator'); // Load the filter state. $search = $app->getUserStateFromRequest($this->context.'.filter.search', 'filter_search'); $this->setState('filter.search', $search); // $accessId = $app->getUserStateFromRequest($this->context.'.filter.access', 'filter_access', null, 'int'); // $this->setState('filter.access', $accessId); $state = $app->getUserStateFromRequest($this->context.'.filter.published', 'filter_published', '', 'string'); $this->setState('filter.published', $state); // $categoryId = $app->getUserStateFromRequest($this->context.'.filter.category_id', 'filter_category_id', null); // $this->setState('filter.category_id', $categoryId); // $language = $app->getUserStateFromRequest($this->context.'.filter.language', 'filter_language', ''); // $this->setState('filter.language', $language); // Load the parameters. $params = PhocacartUtils::getComponentParameters(); $this->setState('params', $params); // List state information. parent::populateState($ordering, $direction); // ASSOCIATION if (!empty($forcedLanguage)) { $this->setState('filter.language', $forcedLanguage); } } protected function getStoreId($id = '') { // Compile the store id. $id .= ':'.$this->getState('filter.search'); // $id .= ':'.$this->getState('filter.access'); $id .= ':'.$this->getState('filter.published'); // $id .= ':'.$this->getState('filter.category_id'); // $id .= ':'.$this->getState('filter.language'); $id .= ':'.$this->getState('filter.item_id'); return parent::getStoreId($id); } protected function getListQuery() { $paramsC = PhocacartUtils::getComponentParameters(); $search_matching_option_admin = $paramsC->get( 'search_matching_option_admin', 'exact' ); $db = $this->getDbo(); $query = $db->getQuery(true); $columns = 'DISTINCT a.id, a.title, a.published, a.checked_out, a.checked_out_time, a.alias, a.date_submit, a.ordering'; // GROUP BY not used //$groupsFull = $columns . ', ' .'a.tax_id, a.manufacturer_id, a.description, l.title, uc.name, ag.title'; //$groupsFast = 'a.id'; //$groups = PhocacartUtilsSettings::isFullGroupBy() ? $groupsFull : $groupsFast; $query->select($this->getState('list.select', $columns)); $query->from('`#__phocacart_submit_items` AS a'); $query->select('u.name AS user_name, u.username AS user_username'); $query->join('LEFT', '#__users AS u ON u.id=a.user_id'); // Join over the language $query->select('l.title AS language_title, l.image AS language_image'); $query->join('LEFT', '`#__languages` AS l ON l.lang_code = a.language'); // Join over the users for the checked out user. $query->select('uc.name AS editor'); $query->join('LEFT', '#__users AS uc ON uc.id=a.checked_out'); // Join over the asset groups. $query->select('ag.title AS access_level'); $query->join('LEFT', '#__viewlevels AS ag ON ag.id = a.access'); // Join over the categories. // They are more ways to get the info about categories // 1) GROUP BY + GROUP_CONCAT - slow, when only_full_group_by rule is used - much more slower than slow // 2) SUBQUERIES - faster even they look complicated // 3) SPECIFIC QUERY used in view: PhocacartCategoryMultiple::getCategoriesByProducts($idItems) (no loop used) DISTINCT needs to be used / * GROUP BY $query->select('GROUP_CONCAT(c.title) AS category_title, GROUP_CONCAT(c.id) AS category_id'); $query->join('LEFT', '#__phocacart_product_categories AS pc ON a.id = pc.product_id'); $query->join('LEFT', '#__phocacart_categories AS c ON c.id = pc.category_id'); * SUBQUERIES $query->select('(SELECT GROUP_CONCAT(c.id) FROM jos_phocacart_product_categories AS pc LEFT JOIN jos_phocacart_categories AS c ON c.id = pc.category_id WHERE a.id = pc.product_id) AS category_id'); $query->select('(SELECT GROUP_CONCAT(c.title) FROM jos_phocacart_product_categories AS pc LEFT JOIN jos_phocacart_categories AS c ON c.id = pc.category_id WHERE a.id = pc.product_id) AS category_title'); $query->select('(SELECT GROUP_CONCAT(c.id, ":", c.title) FROM jos_phocacart_product_categories AS pc LEFT JOIN jos_phocacart_categories AS c ON c.id = pc.category_id WHERE a.id = pc.product_id) AS category_title'); */ // Not used //$query->select("group_concat(c.id, '\|^\|', c.alias, '\|^\|', c.title SEPARATOR '\|~\|') as categories"); //$query->select('v.average AS ratingavg'); //$query->join('LEFT', '#__phocadownload_img_votes_statistics AS v ON v.imgid = a.id'); // Filter by access level. if ($access = $this->getState('filter.access')) { $query->where('a.access = '.(int) $access); } // Filter by published state. $published = $this->getState('filter.published'); if (is_numeric($published)) { $query->where('a.published = '.(int) $published); } else if ($published === '') { $query->where('(a.published IN (0, 1))'); } // When category is selected, we need to get info about selected category // When it is not selected, don't ask for it to make the query faster // pc.ordering is set as default ordering and it can be set (even igonered) even whey category not selected // is complicated but loads much faster $orderCol = $this->state->get('list.ordering', 'title'); $orderDirn = $this->state->get('list.direction', 'asc'); $categoryId = $this->getState('filter.category_id'); // Filter by category. if ($orderCol == 'pc.ordering' \|\| is_numeric($categoryId)) { // Ask only when really needed $query->select('pc.ordering'); $query->join('LEFT', '#__phocacart_product_categories AS pc ON a.id = pc.product_id'); $query->join('LEFT', '#__phocacart_categories AS c ON c.id = pc.category_id'); } if (is_numeric($categoryId)) { //$query->where('a.catid = ' . (int) $categoryId); $query->where('pc.category_id = ' . (int) $categoryId); } // Filter on the language. if ($language = $this->getState('filter.language')) { $query->where('a.language = ' . $db->quote($language)); } // Filter by search in title $search = $this->getState('filter.search'); if (!empty($search)) { if (stripos($search, 'id:') === 0) { $query->where('a.id = '.(int) substr($search, 3)); } else { $search = $db->Quote('%'.$db->escape($search, true).'%'); $query->where('( a.title LIKE '.$search.' OR a.alias LIKE '.$search.')'); } } $orderCol = $this->state->get('list.ordering', 'title'); $orderDirn = $this->state->get('list.direction', 'asc'); $query->order($db->escape($orderCol.' '.$orderDirn)); //echo nl2br(str_replace('#__', 'jos_', $query->__toString())); return $query; } } ?>

| ver. 1.4 | Github | . | PHP 8.1.33 | Генерация страницы: 0.07 | proxy | phpinfo | Настройка