PHP Base_model::get_lang_list方法代码示例

 /**
  * Get all the article_lang data + the page URL of the current language (page_url in the output array)
  *
  * @param	string	String to search
  * @return	array	Array of articles
  *
  */
 function get_articles($realm)
 {
     $realm = '\'%' . $realm . '%\'';
     $this->set_table('article');
     $this->set_lang_table('article_lang');
     $this->set_pk_name('id_article');
     $lang = Settings::get_lang();
     // Page_Article table
     $this->{$this->db_group}->select($this->parent_table . '.*', FALSE);
     $this->{$this->db_group}->join($this->parent_table, $this->parent_table . '.id_article = ' . $this->table . '.id_article', 'left');
     // Page table
     $this->{$this->db_group}->select('page.online');
     $this->{$this->db_group}->join($this->page_table, $this->page_table . '.id_page = ' . $this->parent_table . '.id_page', 'left');
     // Page lang table
     $this->{$this->db_group}->select('page_lang.lang');
     $this->{$this->db_group}->join($this->page_lang_table, $this->page_lang_table . '.id_page = ' . $this->page_table . '.id_page', 'left');
     // Menu table
     $this->{$this->db_group}->select('menu.id_menu, menu.name as menu_name');
     $this->{$this->db_group}->join($this->menu_table, $this->menu_table . '.id_menu = ' . $this->page_table . '.id_menu', 'left');
     // URL table : For Article's URL building
     $this->{$this->db_group}->select('url.path');
     $this->{$this->db_group}->join($this->url_table, $this->url_table . '.id_entity = ' . $this->table . '.id_article' . ' AND ' . $this->url_table . '.active=1 ' . ' AND ' . $this->url_table . '.lang = \'' . $lang . '\'', 'left');
     // Published filter
     $this->filter_on_published(self::$publish_filter, $lang);
     // Add the 'date' field to the query
     $this->{$this->db_group}->select('IF(article.logical_date !=0, article.logical_date, IF(article.publish_on !=0, article.publish_on, article.created )) AS date');
     // Search where
     $this->{$this->db_group}->where('(' . ' article_lang.title LIKE ' . $realm . ' OR article_lang.subtitle LIKE ' . $realm . ' OR article_lang.content LIKE ' . $realm . ')');
     $where = array("page.online" => 1, "article.indexed" => 1, "page_article.online" => 1, "page_article.main_parent" => 1, "article_lang.online" => 1, "article_lang.lang" => $lang, "page_lang.lang" => $lang);
     // Base_model->get_lang_list()
     $articles = parent::get_lang_list($where, $lang);
     return $articles;
 }

 function get_lang_list($where = false, $lang = NULL)
 {
     // Order by ordering field
     $this->{$this->db_group}->order_by($this->table . '.level', 'ASC');
     $this->{$this->db_group}->order_by($this->table . '.ordering', 'ASC');
     // Filter on published
     $this->filter_on_published(self::$publish_filter, $lang);
     return parent::get_lang_list($where, $lang);
 }

 /**
  * Returns list of extend fields, with extend_field data
  *
  */
 public function get_detailled_lang_list($where = array(), $lang = NULL)
 {
     $this->{$this->db_group}->select(self::$_EXTEND . '.name,' . self::$_EXTEND . '.type,' . self::$_EXTEND . '.description,' . self::$_EXTEND . '.ordering,' . self::$_EXTEND . '.value as default_value,' . self::$_EXTEND . '.main');
     $this->{$this->db_group}->join(self::$_EXTEND, self::$_EXTEND . '.id_extend_field = ' . $this->get_table() . '.id_extend_field', 'inner');
     $this->_join_to_extend_types();
     if (!is_null($lang)) {
         // Add extend_field label
         $this->{$this->db_group}->select(self::$_EXTEND_LANG . '.label');
         $this->{$this->db_group}->join(self::$_EXTEND_LANG, self::$_EXTEND_LANG . '.id_extend_field = ' . $this->get_table() . '.id_extend_field' . ' AND ' . self::$_EXTEND_LANG . '.lang = \'' . $lang . '\'', 'left');
         // Limit extend_fields to the asked lang
         $this->{$this->db_group}->where("(" . $this->get_table() . ".lang = '" . $lang . "' OR " . $this->get_table() . ".lang is NULL  OR " . $this->get_table() . ".lang =''" . ")");
     }
     return parent::get_lang_list($where);
 }

 /**
  * @param array $where
  * @param null  $lang
  * @param null  $filter
  *
  * @return array
  */
 public function get_lang_list($where = array(), $lang = NULL, $filter = NULL)
 {
     // Correction on $where['id_media']
     if (is_array($where) && isset($where['id_media'])) {
         $where[$this->table . '.id_media'] = $where['id_media'];
         unset($where['id_media']);
     }
     // Correction on all non declared parent tables
     foreach ($where as $key => $val) {
         if (!is_array($val) && strpos($val, 'id_media') === 0) {
             $val = $this->table . '.' . $val;
             $where[$key] = $val;
         }
     }
     if (!is_null($filter)) {
         $this->_set_filter($filter);
     }
     return parent::get_lang_list($where, $lang);
 }

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

 /**
  * @param	array 	$where
  * @param	string	[$lang]
  * @return	array
  */
 public function get_lang_list($where = array(), $lang = NULL)
 {
     $this->_join_to_extend_types();
     if (!isset($where['order_by'])) {
         $where['order_by'] = 'ordering ASC';
     }
     $list = parent::get_lang_list($where, $lang);
     return $list;
 }

 /** 
  * Get article list with lang data
  * Used by front-end to get the posts with lang data
  *
  * @param	array		$where
  * @param	string		$lang
  * @param	bool|string	$filter		SQL filter
  * @return	array					Array of articles
  */
 public function get_lang_list($where = array(), $lang = NULL, $filter = FALSE)
 {
     // Page_Article table
     $this->{$this->db_group}->select($this->parent_table . '.*', FALSE);
     $this->{$this->db_group}->select($this->parent_table . '.online as online_in_page', FALSE);
     $this->{$this->db_group}->join($this->parent_table, $this->parent_table . '.id_article = ' . $this->table . '.id_article', 'left');
     // Page table
     $this->{$this->db_group}->select('article_list_view, article_view');
     $this->{$this->db_group}->join($this->page_table, $this->page_table . '.id_page = ' . $this->parent_table . '.id_page', 'left');
     // Menu table
     $this->{$this->db_group}->select('menu.id_menu, menu.name as menu_name');
     $this->{$this->db_group}->join($this->menu_table, $this->menu_table . '.id_menu = ' . $this->page_table . '.id_menu', 'left');
     // Default ordering
     if (empty($where['order_by'])) {
         $where['order_by'] = $this->parent_table . '.ordering ASC';
     }
     // Correction on $where['id_page']
     if (is_array($where) && isset($where['id_page'])) {
         $where[$this->parent_table . '.id_page'] = $where['id_page'];
         unset($where['id_page']);
     }
     // Correction on $where['where_in']
     if (isset($where['where_in'])) {
         foreach ($where['where_in'] as $key => $value) {
             if ($key == 'id_page') {
                 $where['where_in'][$this->parent_table . '.id_page'] = $value;
                 unset($where['where_in']['id_page']);
             }
         }
     }
     // Published filter
     $this->filter_on_published(self::$publish_filter, $lang);
     // User's filter (tags)
     if ($filter !== FALSE) {
         $this->_set_filter($filter);
     }
     // Add the 'date' field to the query
     $this->{$this->db_group}->select('IF(article.logical_date !=0, article.logical_date, IF(article.publish_on !=0, article.publish_on, article.created )) AS date');
     // Add Type to query
     $this->{$this->db_group}->select($this->type_table . '.type, ' . $this->type_table . '.type_flag');
     $this->{$this->db_group}->join($this->type_table, $this->parent_table . '.id_type = ' . $this->type_table . '.id_type', 'left');
     // Base_model->get_lang_list()
     $articles = parent::get_lang_list($where, $lang);
     $this->add_categories($articles, $lang);
     $this->add_tags($articles);
     return $articles;
 }

 /**
  * @param	null|string	$where
  * @param	null|string	[$lang]	lang code
  * @return	array
  */
 public function get_lang_list($where = NULL, $lang = NULL)
 {
     // Order by ordering field
     $this->{$this->db_group}->order_by($this->table . '.level', 'ASC');
     $this->{$this->db_group}->order_by($this->table . '.ordering', 'ASC');
     // Filter on published
     $this->filter_on_published(self::$publish_filter, $lang);
     // Add Url to the request
     if ($lang == NULL) {
         $lang = Settings::get_lang('default');
     }
     // URL paths
     $this->{$this->db_group}->select('url.path, url.path_ids, url.full_path_ids');
     $this->{$this->db_group}->join($this->url_table . ' as url', $this->table . '.id_page = url.id_entity AND ' . '(' . "url.type = 'page' AND " . 'url.active = 1 AND ' . "url.lang = '" . $lang . "'" . ')', 'left');
     // Lang URL paths
     $this->{$this->db_group}->select("group_concat(url2.path separator ';') as url_paths");
     $this->{$this->db_group}->select("group_concat(url2.lang separator ';') as url_langs");
     $this->{$this->db_group}->join($this->url_table . ' as url2', $this->table . ".id_page = url2.id_entity AND " . '(' . "url2.type = 'page' AND " . 'url2.active = 1 ' . ')', 'left');
     $this->{$this->db_group}->group_by($this->table . '.id_page');
     return parent::get_lang_list($where, $lang);
 }