public function postLists() { User::onlyHas('user-view'); $jqgrid = new jQgrid(User::getTableName()); return $jqgrid->populate(function ($start, $limit) { return User::select(User::getField('id'), User::getField('username'), User::getField('email'))->skip($start)->take($limit)->get(); }); }
public function postLangs() { User::onlyHas('lang-view'); $jqgrid = new jQgrid('apl_lang'); echo $jqgrid->populate(function ($start, $limit) { return DB::table('apl_lang')->get(); }); $this->layout = null; }
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); }); }