public function action_search() { $view = View::forge('customer/search/search'); $view->search = array(); $view->keyword = Input::get('search-keyword', ''); if (!empty($view->keyword)) { $custom_keyword = Input::vn_str_filter($view->keyword); $search_count = $search_article = Model_ArtCat::query()->related('ac2a')->where(DB::expr("content_search_no_mark LIKE '%{$custom_keyword}%'"))->or_where(DB::expr("title_search LIKE '%{$custom_keyword}%'"))->count(); $config = array('pagination_url' => Uri::base() . "search?search-keyword={$custom_keyword}", 'total_items' => $search_count, 'per_page' => 10, 'uri_segment' => 'page', 'num_links' => 3); $pag = Pagination::forge('paging_search', $config); $search_cat = Model_Categories::query()->where(DB::expr("name_search LIKE '%{$custom_keyword}%'"))->order_by('name_search')->get(); foreach ($search_cat as $s) { $parent = Model_Categories::find($s->parent_id); $view->search[] = array('title' => strip_tags($s->name), 'desc' => strip_tags($s->desc), 'link' => Uri::base() . "{$parent->slug}/{$s->slug}.html"); } $search_article = Model_ArtCat::query()->related('ac2a')->where(DB::expr("content_search_no_mark LIKE '%{$custom_keyword}%'"))->or_where(DB::expr("title_search LIKE '%{$custom_keyword}%'"))->order_by('ac2a.title_search')->rows_offset($pag->offset)->rows_limit($pag->per_page)->get(); foreach ($search_article as $s) { // highlight keyword $content = $this->highlight($s->ac2a->content_search, $custom_keyword); // get cat slug if (!empty($s->ac2c->parent_id)) { $parent_cat_slug = Model_Categories::find($s->ac2c->parent_id); $view->search[] = array('title' => strip_tags($s->ac2a->title), 'desc' => $content, 'link' => Uri::base() . "{$s->ac2c->slug}/{$s->ac2a->slug}.html", 'cat' => array('name' => strip_tags($s->ac2c->name), 'desc' => $s->ac2c->desc, 'link' => Uri::base() . "{$parent_cat_slug->slug}/{$s->ac2c->slug}.html")); } else { $view->search[] = array('title' => strip_tags($s->ac2a->title), 'desc' => $content, 'link' => Uri::base() . "{$s->ac2c->slug}/{$s->ac2a->slug}.html"); } } $view->pag = $pag; } $this->template = \View::forge('customer/search/template'); // data to display menu $this->template->cats = Model_Categories::get_cats_home($this->lang); $this->template->pepper_arts = Model_Article::pepper_artilces($this->lang); $this->template->title = __('common.search'); $this->add_css('search.css'); $this->template->content = $view; }
/** * Get Number of articles of a category * * params int $cat_id Category-ID * @return int Number of articles of a category * * @version 1.0 * @since 1.0 * @access public * @author Nguyen Van hiep * @author Dao Anh Minh */ public static function count_arts_in_cat($cat_id = '', $lang = '') { if (empty($cat_id)) { if (empty($lang)) { $count = Model_Article::query()->count(); } else { $count = Model_Article::query()->where('lang', $lang)->count(); } } else { if (empty($lang)) { $count = Model_ArtCat::query()->where('cat_id', $cat_id)->count(); } else { $count = Model_ArtCat::query()->related('ac2a')->where('cat_id', $cat_id)->where('ac2a.lang', $lang)->count(); } } return $count; }