PHP JModelList::getListQuery方法代码示例

 public function getListQuery()
 {
     $query = parent::getListQuery();
     $query->select('*');
     $query->from('#__jmm_canned_queries');
     $published = $this->getState('filter.published');
     if ($published == '') {
         $query->where('published IN(1,0)');
     } else {
         if ($published != '*') {
             $published = (int) $published;
             $query->where("published='{$published}'");
         }
     }
     $search = $this->getState('filter.search');
     $database = $this->getState('filter.database');
     if ($database != '') {
         $query->where("dbname='{$database}'");
     }
     $db = $this->getDbo();
     if (!empty($search)) {
         $search = '%' . $db->getEscaped($search, true) . '%';
         $field_searches = "(title LIKE '{$search}' OR dbname LIKE '{$search}' OR query LIKE '{$search}')";
         $query->where($field_searches);
     }
     $orderCol = $this->getState('list.ordering');
     $orderDirn = $this->getState('list.direction');
     if (isset($orderCol)) {
         $query->order($db->getEscaped($orderCol . ' ' . $orderDirn));
     } else {
         $query->order('id desc');
     }
     return $query;
 }

 public function getListQuery()
 {
     $tbl = JRequest::getString('tbl', '#__users');
     $query = parent::getListQuery();
     $query->select('*');
     $query->from($tbl);
     $search = $this->getState('filter.search');
     //$db = $this -> getDbo();
     $this->_db = JMMCommon::getDBInstance();
     /*
     if (!empty($search)) {
     $search = '%' . $db -> getEscaped($search, true) . '%';
     $fileds = JMMCommon::getCloumnsFromTable($tbl);
     $searchflString = implode(" LIKE '$search' OR ", $fileds);
     $field_searches = "($searchflString)";
     $query -> where($field_searches);
     }
     */
     $filter_order = JRequest::getString('filter_order', null);
     $filter_order_Dir = JRequest::getString('filter_order_Dir', null);
     if (!empty($filter_order) && !empty($filter_order_Dir)) {
         $query->order($filter_order . ' ' . $filter_order_Dir);
     }
     return $query;
 }

 /**
  * Build an SQL query to load the list data.
  *
  * @return    JDatabaseQuery
  *
  * @since    1.6
  */
 protected function getListQuery()
 {
     // Create a new query object.
     $db = JFactory::getDbo();
     $query = parent::getListQuery();
     $query->select(array('l.lang_code', 'l.published', 'l.title', 'l.image', 'tr.state', 'SUM(tr.word_counter) AS word_count', 'lc.comment'))->from('#__languages AS l')->leftJoin('#__neno_language_external_translators_comments AS lc ON l.lang_code = lc.language')->leftJoin('#__neno_content_element_translations AS tr ON tr.language = l.lang_code')->where('l.lang_code <> ' . $db->quote(NenoSettings::get('source_language')))->group(array('l.lang_code', 'tr.state'))->order('lang_code');
     return $query;
 }

 function getListQuery()
 {
     $db = $this->getDbo();
     $query = parent::getListQuery();
     $input = JFactory::getApplication()->input->getInt('trieda_id', 0);
     $query->select('id, meno ,priezvisko')->from('#__absolventi_ziaci')->where('trieda' . ' = ' . $input);
     return $query;
 }

 public function getListQuery()
 {
     $query = parent::getListQuery();
     //$db = $this->getDbo();
     //$query = $db->getQuery(true);
     $query->select('titel, artist');
     $query->from('#__pa_videolesson')->order('antal_visningar DESC');
     return $query;
 }

 /**
  * The List Query
  * params used when loaded from modules
  */
 function getListQuery($catids = null, $order = null, $limit = null)
 {
     // db helper
     $db = $this->_db;
     // params
     $app = JFactory::getApplication();
     $menu = $app->getMenu();
     $active = $menu->getActive() ? $menu->getActive() : $menu->getDefault();
     $params = $menu->getParams($active->id);
     // query
     $query = parent::getListQuery();
     $query->select('a.*')->from('#__jkit_items AS a')->where('a.state = 1');
     $query->select('c.title AS category')->leftJoin('#__categories AS c ON c.id = a.catid');
     $query->select('u.title AS user, u.alias AS user_alias')->leftJoin('#__jkit_users AS u ON u.id = a.user_id');
     // category
     $catids = $catids ? $catids : $params->get('categories');
     $categories = implode(',', (array) $catids);
     $query->where("a.catid IN ({$categories})");
     // tag view?
     $tag = $this->getTag();
     if ($tag) {
         $query->leftJoin('#__jkit_tags_item AS t ON t.item_id = a.id');
         $query->where("t.tag_id = {$tag->id}");
     }
     // archive view?
     $archive = $this->getArchive();
     if ($archive) {
         $start = $db->quote($archive->start);
         $end = $db->quote($archive->end);
         $query->where("a.created >= {$start}");
         $query->where("a.created <= {$end}");
     }
     // author view?
     $author = $this->getAuthor();
     if ($author) {
         $query->where("a.user_id = {$author->id}");
     }
     // ordering
     $order = $order ? $order : $params->get('order', 'new');
     if ($order == 'new') {
         $ordering = 'a.created DESC';
     } elseif ($order == 'old') {
         $ordering = 'a.created ASC';
     } elseif ($order == 'asc') {
         $ordering = 'a.ordering ASC';
     } elseif ($order == 'desc') {
         $ordering = 'a.ordering DESC';
     }
     $this->setState('list.ordering', $ordering);
     $this->setState('list.direction', '');
     $query->order($ordering);
     // limit
     $limit = $limit ? $limit : $params->get('leading') + $params->get('primary') + $params->get('secondary');
     $this->setState('list.limit', $limit);
     return $query;
 }

 /**
  * Build an SQL query to load the list data.
  *
  * @return    JDatabaseQuery
  *
  * @since    1.6
  */
 protected function getListQuery()
 {
     // Create a new query object.
     $db = JFactory::getDbo();
     $query = parent::getListQuery();
     $query->select('a.*')->from('#__neno_settings AS a')->where(array('a.setting_key NOT LIKE ' . $db->quote('%installation%'), 'a.setting_key NOT LIKE ' . $db->quote('%setup%'), 'a.setting_key NOT LIKE ' . $db->quote('%discovering%')));
     // Add the list ordering clause.
     $orderCol = $this->state->get('list.ordering');
     $orderDirection = $this->state->get('list.direction');
     if ($orderCol && $orderDirection) {
         $query->order($db->escape($orderCol . ' ' . $orderDirection));
     }
     return $query;
 }

 /**
  * Get the master query for retrieving a list of comment subject to the model state.
  *
  * @return  JDatabaseQuery
  *
  */
 protected function getListQuery()
 {
     $query = parent::getListQuery();
     // Select the required fields from the table.
     $query->select($this->getState('list.select', 'a.id, a.content_id, a.visitor_name, a.state, ' . 'a.visitor_email, a.visitor_comments, a.created'));
     $query->from('#__mjcomments AS a');
     // Join over the article.
     $query->select('c.title AS content_title, c.alias AS content_alias, c.catid AS content_category, c.language AS content_language')->join('LEFT', '#__content AS c ON c.id = a.content_id');
     // Filter by a single article.
     $contentId = $this->getState('filter.content_id');
     if (is_numeric($contentId)) {
         $query->where('a.content_id = ' . (int) $contentId);
     }
     // Filter by published state
     $published = $this->getState('filter.published');
     if (is_numeric($published)) {
         $query->where('a.state = ' . (int) $published);
     }
     // Add the list ordering clause.
     $query->order($this->getState('list.ordering', 'a.created') . ' ' . $this->getState('list.direction', 'DESC'));
     return $query;
 }

 function getListQuery()
 {
     $query = parent::getListQuery();
     $query->select('tr.id, tr.rok_nastupu, tr.rok_vystupu, tr.trieda, uc.meno, uc.priezvisko, tr.tablo_url')->from('#__absolventi_triedy as tr')->join('INNER', '#__absolventi_ucitelia as uc ON tr.triedny = uc.id')->order($this->getState('list.ordering', 'default_sort_column') . ' ' . $this->getState('list.direction', 'ASC'));
     return $query;
 }

 public function getListQuery()
 {
     $query = parent::getListQuery();
     $query->select('id')->from('jos_dbtest');
     return $query;
 }

 /**
  * Build an SQL query to load the list data.
  *
  * @return    JDatabaseQuery
  *
  * @since    1.6
  */
 protected function getListQuery()
 {
     $query = parent::getListQuery();
     $query->select(array('SUM(word_counter) AS words', 'trtm.translation_method_id', 'l.title_native', 'l.image', 'language'))->from('#__neno_content_element_translations AS tr')->innerJoin('#__neno_content_element_translation_x_translation_methods AS trtm ON trtm.translation_id = tr.id')->innerJoin('#__neno_translation_methods AS tm ON trtm.translation_method_id = tm.id')->leftJoin('#__languages AS l ON tr.language = l.lang_code')->where(array('state = ' . NenoContentElementTranslation::NOT_TRANSLATED_STATE, 'NOT EXISTS (SELECT 1 FROM #__neno_jobs_x_translations AS jt WHERE tr.id = jt.translation_id)', 'tm.pricing_per_word <> 0', 'trtm.ordering = 1'))->group(array('trtm.translation_method_id', 'language'));
     return $query;
 }

 function getListQuery()
 {
     $query = parent::getListQuery();
     $query->select('id, meno ,priezvisko')->from('#__absolventi_ucitelia')->order($this->getState('list.ordering', 'default_sort_column') . ' ' . $this->getState('list.direction', 'ASC'));
     return $query;
 }

 /**
  * Build an SQL query to load the list data.
  *
  * @return    JDatabaseQuery
  *
  * @since    1.6
  */
 protected function getListQuery()
 {
     $db = JFactory::getDbo();
     $workingLanguage = NenoHelper::getWorkingLanguage();
     // Create a new query object.
     $dbStrings = parent::getListQuery();
     $languageFileStrings = parent::getListQuery();
     $dbStrings->select(array('tr1.*', 'f.field_name AS `key`', 't.table_name AS element_name', 'g1.group_name AS `group`', 'CHAR_LENGTH(tr1.string) AS characters'))->from('`#__neno_content_element_translations` AS tr1')->innerJoin('`#__neno_content_element_fields` AS f ON tr1.content_id = f.id')->innerJoin('`#__neno_content_element_tables` AS t ON t.id = f.table_id')->innerJoin('`#__neno_content_element_groups` AS g1 ON t.group_id = g1.id ')->where(array('tr1.language = ' . $db->quote($workingLanguage), 'tr1.content_type = ' . $db->quote('db_string'), 'f.translate = 1'))->group(array('HEX(tr1.string)', 'tr1.state'))->order('tr1.id');
     $languageFileStrings->select(array('tr2.*', 'ls.constant AS `key`', 'lf.filename AS element_name', 'g2.group_name AS `group`', 'CHAR_LENGTH(tr2.string) AS characters'))->from('`#__neno_content_element_translations` AS tr2')->innerJoin('`#__neno_content_element_language_strings` AS ls ON tr2.content_id = ls.id')->innerJoin('`#__neno_content_element_language_files` AS lf ON lf.id = ls.languagefile_id')->innerJoin('`#__neno_content_element_groups` AS g2 ON lf.group_id = g2.id ')->where(array('tr2.language = ' . $db->quote($workingLanguage), 'tr2.content_type = ' . $db->quote('lang_string')))->group(array('HEX(tr2.string)', 'tr2.state'))->order('tr2.id');
     $queryWhereDb = array();
     /* @var $groups array */
     $groups = $this->getState('filter.group_id', array());
     /* @var $element array */
     $element = $this->getState('filter.element', array());
     /* @var $field array */
     $field = $this->getState('filter.field', array());
     /* @var $file array */
     $file = $this->getState('filter.files', array());
     $groupIdAdded = false;
     if (!is_array($groups)) {
         $groups = array($groups);
     }
     if (!empty($groups) && !in_array('none', $groups)) {
         $queryWhereDb[] = 't.group_id IN (' . implode(', ', $groups) . ')';
         $languageFileStrings->where('lf.group_id IN (' . implode(', ', $groups) . ')');
     }
     if (!empty($element)) {
         if ($groupIdAdded === false) {
             $languageFileStrings->select('g2.id AS group_id');
             $dbStrings->select('g1.id AS group_id');
             $groupIdAdded = true;
         }
         $queryWhereDb[] = 't.id IN (' . implode(', ', $element) . ')';
         // Do not show any strings for this language file
         if (empty($file)) {
             $languageFileStrings->where('lf.id = 0');
         }
     }
     if (!empty($field)) {
         if ($groupIdAdded === false) {
             $languageFileStrings->select('g2.id AS group_id');
             $dbStrings->select('g1.id AS group_id');
         }
         // Do not show any strings for this language file
         if (empty($file)) {
             $languageFileStrings->where('lf.id = 0');
         }
         $queryWhereDb[] = 'f.id IN (' . implode(', ', $field) . ')';
     }
     if (!empty($file)) {
         $languageFileStrings->where('lf.id IN (' . implode(',', $file) . ')');
         if (empty($field) && empty($element)) {
             $queryWhereDb[] = 'f.id = 0 AND t.id = 0';
         }
     }
     if (count($queryWhereDb)) {
         $dbStrings->where('(' . implode(' OR ', $queryWhereDb) . ')');
     }
     $method = (array) $this->getState('filter.translator_type', array());
     if (!empty($method) && !in_array('none', $method)) {
         $dbStrings->where('tr_x_tm1.translation_method_id IN ("' . implode('", "', $method) . '")')->leftJoin('`#__neno_content_element_translation_x_translation_methods` AS tr_x_tm1 ON tr1.id = tr_x_tm1.translation_id');
         $languageFileStrings->where('tr_x_tm2.translation_method_id IN ("' . implode('", "', $method) . '")')->leftJoin('`#__neno_content_element_translation_x_translation_methods` AS tr_x_tm2 ON tr2.id = tr_x_tm2.translation_id');
     }
     $status = (array) $this->getState('filter.translation_status', array());
     if (!empty($status) && $status[0] !== '' && !in_array('none', $status)) {
         $dbStrings->where('tr1.state IN (' . implode(', ', $status) . ')');
         $languageFileStrings->where('tr2.state IN (' . implode(', ', $status) . ')');
     }
     // Hide empty strings if the user wants to do that
     if (NenoSettings::get('hide_empty_strings', true)) {
         $dbStrings->where('tr1.original_text <> ' . $db->quote(''));
         $languageFileStrings->where('tr2.original_text <> ' . $db->quote(''));
     }
     $query = parent::getListQuery();
     $query->select('DISTINCT *')->from('((' . (string) $dbStrings . ') UNION (' . (string) $languageFileStrings . ')) AS a')->group('id');
     $search = $this->getState('filter.search');
     if (!empty($search)) {
         $search = $db->quote('%' . $search . '%');
         $query->where('(a.original_text LIKE ' . $search . ' OR a.string LIKE ' . $search . ')');
     }
     // Add the list ordering clause.
     $orderCol = $this->state->get('list.ordering');
     $orderDirection = $this->state->get('list.direction');
     if ($orderCol && $orderDirection) {
         $query->order($db->escape($orderCol . ' ' . $orderDirection));
     }
     return $query;
 }