public static function postWithProperty($property, $with_url = false)
{
$row = PostProperty::prepare()->where(PostLang::getField('enabled'), 1)->where(PostProperty::getField('key'), $property)->remember(SettingsModel::one('cachelife'))->first();
if ($row && $with_url) {
$row['url'] = Post::getFullURI($row->id);
}
return $row ? $row : false;
}
public function getlist()
{
\User::onlyHas('jobrequest-view');
$jqgrid = new jQgrid(\JobRequestModel::getTableName());
echo $jqgrid->populate(function ($start, $limit) {
return \JobRequestModel::join(PostLang::getTableName(), \PostLang::getField('post_id'), '=', \JobRequestModel::getField('post_id'))->where(\PostLang::getField('lang_id'), \WebAPL\Language::getId())->select(\JobRequestModel::getField('id'), \PostLang::getField('title'), \JobRequestModel::getField('name'), \JobRequestModel::getField('cv_path'), \JobRequestModel::getField('date_created'))->skip($start)->take($limit)->orderBy(\JobRequestModel::getField('date_created'), 'desc')->get();
});
}
public function soclist()
{
\User::onlyHas('socialc-view');
$pages = \Post::join(\PostLang::getTableName(), \PostLang::getField('post_id'), '=', \Post::getField('id'))->where(\PostLang::getField('lang_id'), \WebAPL\Language::getId())->where(\Post::getField('taxonomy_id'), 1)->orderBy(\PostLang::getField('title'), 'desc')->get();
$page_list = array();
$page_json = array();
foreach ($pages as $page) {
$page_list[] = "{$page->post_id}:{$page->title}";
$page_json[$page->post_id] = $page->title;
}
$data['pagesString'] = implode(';', $page_list);
$data['pagesJson'] = json_encode($page_json);
$this->layout->content = Template::moduleView($this->module_name, 'views.list', $data);
return $this->layout;
}
public function postAlltrash()
{
User::onlyHas('feedpost-view');
$jqgrid = new jQgrid(Post::getTableName());
$jqgrid->use_populate_count = true;
return $jqgrid->populate(function ($start, $limit) {
$list = Post::prepareAll()->select(Post::getField('id'), PostLang::getField('title'), Post::getField('created_at'), Post::getField('views'))->where(Post::getField('taxonomy_id'), $this->taxonomy->id)->where(Post::getField('is_trash'), 1);
if ($limit) {
$list = $list->skip($start)->take($limit);
}
return $list->get($list);
});
}
public static function findExistsDates($feed_id)
{
$posts = Post::prepareQuery(2)->join(FeedPost::getTableName(), Post::getField("id"), '=', FeedPost::getField("post_id"))->where(FeedPost::getField("feed_id"), $feed_id)->where(PostLang::getField('enabled'), 1)->where(Post::getField('is_trash'), 0)->orderBy(DB::raw("DATE(" . Post::getField('created_at') . ")"), 'asc')->select(DB::raw("DATE(" . Post::getField('created_at') . ") as data"))->remember(SettingsModel::one('cachelife'))->get();
$dates = ['years' => [], 'months' => []];
foreach ($posts as $post) {
$tmst = strtotime($post->data);
$y = (int) date("Y", $tmst);
$m = (int) date("m", $tmst);
$d = (int) date("d", $tmst);
$dates['years'][$y] = $y;
if (isset($dates['months'][$y])) {
if (isset($dates['months'][$y][$m])) {
$dates['months'][$y][$m]++;
} else {
$dates['months'][$y][$m] = 1;
}
} else {
$dates['months'][$y] = [$m => 1];
}
}
return $dates;
}
