/**
* Izgūst attēlojamo galeriju masīvu
*
* @return Array Galeriju masīvs
*/
private function getGaleries()
{
$this->skip = Input::get('skip', 0);
// šo prametru uzstāda no tikai AJAX pieprasījuma
$this->filt_source_id = Input::get('source_id', 0);
$this->filt_year = Input::get('year', 0);
$galeries = get_article_query()->where('is_active', '=', 1)->where('in_article_types.is_for_galeries', '=', 1)->where(function ($query) {
if ($this->source_id > 0) {
$query->where('in_articles.source_id', '=', $this->source_id);
}
if ($this->filt_source_id > 0) {
$query->where('in_articles.source_id', '=', $this->filt_source_id);
}
if ($this->filt_year > 0) {
$query->whereRaw('year(in_articles.publish_time) = ' . $this->filt_year);
}
})->orderBy('order_index', 'ASC')->orderBy('publish_time', 'DESC')->skip($this->skip)->take(Config::get('dx.gallery_publish_item_count'))->get();
return $galeries;
}
/**
* Izgūst ziņu rakstus.
* Portālā ziņas var būt dažādiem uzņēmumiem - katrs uzņēmums ir kā rakstu avots.
*
* @return Array Masīvs ar ziņām atbilstoši avotam
*/
private function getArticlesArray()
{
$articles = get_article_query()->where('in_articles.is_active', '=', 1)->where('in_articles.is_static', '=', 0)->where(function ($query) {
$query->where(function ($query) {
if ($this->source_id > 0) {
$query->whereExists(function ($query) {
$query->select(DB::raw(1))->from('in_tags_article')->whereRaw('in_tags_article.article_id = in_articles.id AND in_tags_article.tag_id=' . $this->tag_id);
})->orWhere('in_articles.source_id', '=', $this->source_id);
}
});
if ($this->type_id > 0) {
$query->where('in_articles.type_id', '=', $this->type_id);
}
})->orderBy('in_articles.order_index', 'ASC')->orderBy('in_articles.publish_time', 'DESC')->simplePaginate(Config::get('dx.feeds_page_rows_count'));
$this->prepareArticleTags($articles);
return $articles;
}
