public function count_all_lang_list($where = array()) { $this->{$this->db_group}->distinct(); $this->{$this->db_group}->join($this->lang_table, $this->lang_table . '.id_' . $this->table . ' = ' . $this->table . '.id_' . $this->table, 'inner'); $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}->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'); $nb = parent::count($where); return $nb; }
/** * @param array $where * * @return int */ public function count($where = array()) { unset($where['limit']); unset($where['offset']); $this->_join_role(); $nb = parent::count($where); return $nb; }