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; }