PHP Base_model::get_list方法代码示例

 /**
  * Returns enhanced media list
  *
  * @param null  $where
  * @param array $filters
  * @param bool  $addon_data
  *
  * @return array
  */
 public function get_list($where = NULL, $filters = array(), $addon_data = TRUE)
 {
     // Pages
     $this->{$this->db_group}->select("group_concat(url.path separator ';') as page_paths");
     $this->{$this->db_group}->join('page_media', 'page_media.id_media = ' . $this->table . '.id_media', 'left');
     $this->{$this->db_group}->join('url', "url.id_entity = page_media.id_page AND url.type='page' and url.active=1 and url.lang='" . Settings::get_lang('default') . "'", 'left');
     // Articles
     $this->{$this->db_group}->select("group_concat(url2.path separator ';') as article_paths");
     $this->{$this->db_group}->join('article_media', 'article_media.id_media = ' . $this->table . '.id_media', 'left');
     $this->{$this->db_group}->join('url as url2', "url2.id_entity = article_media.id_article AND url2.type='article' and url2.active=1 and url2.lang='" . Settings::get_lang('default') . "'", 'left');
     // Filters
     if (in_array('alt_missing', $filters)) {
         $this->{$this->db_group}->join('media_lang', 'media_lang.id_media = ' . $this->table . '.id_media', 'left');
         $this->{$this->db_group}->where("(media_lang.alt is null or media_lang.alt='')");
     }
     if (in_array('used', $filters)) {
         $this->{$this->db_group}->where('(url.path is not null or url2.path is not null)');
     }
     if (in_array('not_used', $filters)) {
         $this->{$this->db_group}->where('(url.path is null and url2.path is null)');
     }
     $this->{$this->db_group}->group_by($this->table . '.id_media');
     $this->{$this->db_group}->order_by($this->table . '.id_media', 'DESC');
     $result = parent::get_list($where, $this->table);
     if ($addon_data) {
         $result = $this->_add_lang_data_to_media_list($result);
     }
     return $result;
 }

 /**
  * @param null $parent
  * @param null $id_parent
  *
  * @return array|void
  *
  */
 public function get_list($parent = NULL, $id_parent = NULL)
 {
     // Get tags from one parent
     if (!is_null($parent) && $this->table_exists($parent . '_tag')) {
         $this->{$this->db_group}->join($parent . '_tag', $parent . '_tag.id_tag = ' . $this->get_table() . '.id_tag and ' . $parent . '_tag.id_' . $parent . ' = ' . $id_parent, 'inner');
     }
     return parent::get_list(array('order_by' => 'tag_name ASC'));
 }

 public function get_panel_elements($id_company, $panel, $type = NULL)
 {
     $where = array('id_company' => $id_company, 'panel' => $panel, 'order_by' => 'ordering ASC');
     if (!is_null($type)) {
         $where['type'] = $type;
     }
     return parent::get_list($where);
 }

 public function get_list($params, $page = 0, $count = 20)
 {
     $this->load->model('problem_model');
     $comments = parent::get_list($params, $page, $count);
     foreach ($comments as &$comment) {
         $comment['author'] = $this->user_model->get(array('id' => $comment['owner_id']))['nickname'];
         $comment['problem_title'] = $this->problem_model->get(array('id' => $comment['problem_id']))['title'];
     }
     return $comments;
 }

 public function get_list($type, $page = 0, $count = 5)
 {
     $list = parent::get_list(array("s" => "", 'type' => $type), $page, $count);
     foreach ($list as $slide) {
         if (empty($slide['text'])) {
             break;
         }
         $slide['text'] = json_decode($slide['text']);
     }
     return $list;
 }

 /**
  * Get array of articles
  * 
  * For each article, set the article date.
  * The article date can be the creation date or the publish_on date if exists
  *
  * @access	public
  * @param 	array	An associative array
  * @return	array	Array of records
  *
  */
 function get_list($where = FALSE)
 {
     $data = array();
     $this->db->select($this->lang_table . '.*');
     $this->db->join($this->lang_table, $this->lang_table . '.id_' . $this->table . ' = ' . $this->table . '.id_' . $this->table, 'inner');
     $this->db->where($this->lang_table . '.lang', Settings::get_lang('default'));
     $data = parent::get_list($where);
     // Set the correct publish date
     foreach ($data as $key => $row) {
         $data[$key]['date'] = isDate($row['publish_on']) ? $row['publish_on'] : $row['created'];
     }
     return $data;
 }

 public function get_list($id, $page = 0, $count = 5, $isJson = false, $site = false)
 {
     $where = $id == "all" ? array() : array('id' => $id);
     $list = parent::get_list($where, $page, $count);
     foreach ($list as $key => $item) {
         if (!$isJson) {
             $list[$key]['tags'] = $this->tag_model->get_tag_list($item['tags']);
             $list[$key]['site'] = $this->get_site_by_json($item['site']);
             $list[$key]['steps'] = $this->get_step_by_json($item['steps']);
             // $list[$key]['chapters'] = $this->get_chapter_by_json($item['chapters']);
         } else {
             if ($site) {
                 $list[$key]['site'] = $this->get_site_by_json($item['site']);
             }
         }
     }
     return $list;
 }

 /**
  * Returns all medias linked to one extend field
  *
  * @param      $id_extend
  * @param      $parent
  * @param      $id_parent
  * @param null $lang
  *
  * @return array
  */
 public function get_extend_media_list($id_extend, $parent, $id_parent, $lang = NULL)
 {
     $data = array();
     self::$ci->load->model('extend_field_model', '', true);
     if (!$lang) {
         $lang = NULL;
     }
     $extend = self::$ci->extend_field_model->get_element_extend_field($id_extend, $parent, $id_parent, $lang);
     if (!empty($extend)) {
         $ids = strlen($extend['content']) > 0 ? explode(',', $extend['content']) : NULL;
         if (!empty($ids)) {
             $this->{$this->db_group}->select($this->get_table() . '.*', FALSE);
             $where = array('where_in' => array($this->get_table() . '.id_media' => $ids));
             // Separated from $where due to $escape set to FALSE
             $this->{$this->db_group}->order_by('field(' . $this->get_table() . '.id_media, ' . $extend['content'] . ')', '', FALSE);
             if (!is_null($lang)) {
                 $this->{$this->db_group}->select($this->get_lang_table() . '.*', FALSE);
                 $this->{$this->db_group}->join($this->get_lang_table(), $this->get_lang_table() . '.' . $this->get_pk_name() . '=' . $this->get_table() . '.' . $this->get_pk_name() . ' AND ' . $this->get_lang_table() . '.lang = \'' . $lang . '\'', 'left');
             }
             $data = parent::get_list($where, $this->get_table());
             $data = $this->_add_medias_infos($data);
         }
     }
     return $data;
 }

 function get_list($where = array())
 {
     $where['order_by'] = 'ordering ASC';
     return parent::get_list($where);
 }

 public function get_fund_list($page)
 {
     $list = parent::get_list(array('type <=' => '1'), $page, 20);
     foreach ($list as &$item) {
         $item['ctime'] = date("H:i:s", strtotime($item['ctime']));
         $item['tags'] = $this->tag_model->get_list_by_json($item['tags']);
     }
     return $list;
 }

 public function get_context_list($context, $id_context = NULL, $parent = NULL, $id_parent = NULL, $id_extend_field_type = NULL)
 {
     $where = array('order_by' => 'ordering ASC');
     if (!empty($parent)) {
         $where['parent'] = $parent;
     }
     if (!empty($id_parent)) {
         $where['id_parent'] = $id_parent;
     }
     // Extend Lang : Label
     $this->{$this->db_group}->select($this->get_lang_table() . '.label');
     $this->{$this->db_group}->join($this->get_lang_table(), $this->get_lang_table() . '.' . $this->get_pk_name() . ' = ' . $this->get_table() . '.' . $this->get_pk_name() . ' AND ' . $this->get_lang_table() . '.lang = \'' . Settings::get_lang('default') . '\'', 'left');
     // Add Extend Type info
     $this->_join_to_extend_types($id_extend_field_type);
     // Context
     $this->{$this->db_group}->select(self::$_CONTEXT_TABLE . '.context,' . self::$_CONTEXT_TABLE . '.id_context');
     $this->_join_to_context($context, $id_context);
     // Extend Definition List
     $list = parent::get_list($where);
     return $list;
 }

 /**
  * Returns all articles with all lang data
  *
  * @param	array	$where
  * @return	array
  */
 public function get_all_lang_list($where = array())
 {
     $data = array();
     $this->{$this->db_group}->select($this->lang_table . '.*');
     $this->{$this->db_group}->join($this->lang_table, $this->lang_table . '.id_' . $this->table . ' = ' . $this->table . '.id_' . $this->table, 'inner');
     // URLs
     $this->{$this->db_group}->select('url.canonical, url.path, url.path_ids, url.full_path_ids');
     $this->{$this->db_group}->join($this->url_table . ' as url', $this->table . '.id_article = url.id_entity AND ' . '(' . 'url.active = 1 AND ' . "url.type = 'article' AND " . 'url.lang = ' . $this->lang_table . '.lang' . ')', 'left');
     $this->{$this->db_group}->select("\r\n\t\t\tgroup_concat(page.id_page separator ';') as page_ids,\r\n\t\t\tpage_lang.title as page_title\r\n\t\t");
     $this->{$this->db_group}->join('page_article', $this->table . '.id_article = page_article.id_article', 'left');
     $this->{$this->db_group}->join('page', 'page.id_page = page_article.id_page', 'left');
     $this->{$this->db_group}->join('page_lang', 'page_lang.id_page = page.id_page AND article_lang.lang = page_lang.lang', 'left');
     $this->{$this->db_group}->group_by($this->table . '.id_article');
     $this->{$this->db_group}->group_by($this->lang_table . '.lang');
     $articles = parent::get_list($where);
     foreach ($articles as $article) {
         if (empty($data[$article['id_article']][$article['lang']])) {
             if (!isset($data[$article['id_article']])) {
                 $data[$article['id_article']] = array();
             }
             if ($article['lang'] == Settings::get_lang('default')) {
                 $data[$article['id_article']]['data'] = $article;
             }
             $data[$article['id_article']][$article['lang']] = $article;
         }
     }
     return $data;
 }

 private function _reorder($id_item_definition)
 {
     $cond = array('id_item_definition' => $id_item_definition, 'order_by' => 'ordering ASC, id_item DESC');
     $items = parent::get_list($cond);
     foreach ($items as $key => $item) {
         $this->{$this->db_group}->where($this->pk_name, $item['id_item'])->update($this->table, array('ordering' => $key + 1));
     }
 }

 /**
  * @param array $where
  *
  * @return array
  */
 public function get_list_with_role($where = array())
 {
     $this->_join_role();
     return parent::get_list($where);
 }

 public function get_list($params = array(), $page = 0, $count = 3)
 {
     return parent::get_list($params, $page, $count);
 }