public function getAll($params = array()) { $columns = isset($params['columns']) ? $params['columns'] : array('*'); $sortColumn = isset($params['sort_column']) ? $params['sort_column'] : null; $sortDirection = isset($params['sort_direction']) ? $params['sort_direction'] : 'asc'; $pageIndex = isset($params['page_index']) ? $params['page_index'] : 1; $pageSize = isset($params['page_size']) ? $params['page_size'] : 10; $includes = isset($params['includes']) ? $params['includes'] : array(); $criteria = isset($params['criteria']) ? $params['criteria'] : array(); $query = TaxRate::with($includes); if ($sortColumn) { $query = $query->orderBy($sortColumn, $sortDirection); } foreach ($criteria as $value) { $op = isset($value['op']) ? $value['op'] : '='; $query = $query->where($value['column'], $op, $value['value']); } if (isset($params['page_index']) || isset($params['page_size'])) { Paginator::setCurrentPage($pageIndex); $items = $query->select($columns)->paginate($pageSize); } else { $items = $query->select($columns)->get(); } return $items; }
public function getAll($params = array(), $language_id) { //$columns = isset($params['columns']) ? $params['columns'] : array('*'); //$sort_column = isset($params['sort_column']) ? $params['sort_column'] : null; $sort_direction = isset($params['sort_direction']) ? $params['sort_direction'] : 'asc'; $page_index = isset($params['page_index']) ? $params['page_index'] : null; $page_size = isset($params['page_size']) ? $params['page_size'] : null; //$includes = isset($params['includes']) ? $params['includes'] : array(); //$criteria = isset($params['criteria']) ? $params['criteria'] : array(); $columns = ['payment_methods.*', 'payment_methods_descriptions.name']; $sort_column = "sort_order"; //basic query $query = PaymentMethod::leftJoin("payment_methods_descriptions", function ($join) use($language_id) { $join->on('payment_methods.id', '=', 'payment_methods_descriptions.payment_method_id'); $join->where('payment_methods_descriptions.language_id', '=', $language_id); })->orderBy($sort_column, $sort_direction); //pagination if (isset($page_index) || isset($page_size)) { Paginator::setCurrentPage($page_index); $items = $query->select($columns)->paginate($page_size); } else { $items = $query->select($columns)->get(); } return $items; }
public function getRepliesWithLimit($limit = 30) { // 默认显示最新的回复 if (is_null(\Input::get(\Paginator::getPageName()))) { $latest_page = ceil($this->reply_count / $limit); \Paginator::setCurrentPage($latest_page ?: 1); } return $this->replies()->orderBy('created_at', 'asc')->with('user')->paginate($limit); }
public function blog($page = 1) { $limit = 5; $offset = ($page - 1) * $limit; $posts = Post::take($limit)->skip($offset)->active()->orderBy('created_at', 'desc')->get(); Paginator::setBaseUrl(Config::get('app.url') . '/blog'); Paginator::setCurrentPage($page); $totalItems = Post::with('id')->active()->count(); $paginator = PrettyPaginator::make($posts->toArray(), $totalItems, $limit); return View::make('blog.blog', ['posts' => $posts, 'paginate' => $paginator]); }
public function all($page = 1) { $limit = 5; $offset = ($page - 1) * $limit; $articles = Article::take($limit)->skip($offset)->active()->orderBy('created_at', 'desc')->get(); Paginator::setBaseUrl(Config::get('app.url') . '/articles'); Paginator::setCurrentPage($page); $totalItems = Article::with('id')->active()->count(); $paginator = PrettyPaginator::make($articles->toArray(), $totalItems, $limit); return View::make('article/all', ['articles' => $articles, 'setting' => Config::get('setting'), 'paginate' => $paginator]); }
public function showCategory($link, $page = 1) { $limit = 9; $offset = ($page - 1) * $limit; $category = Category::where('link', '=', $link)->first(); $products = Product::categorized($category)->take($limit)->skip($offset)->active()->orderBy('created_at', 'desc')->get(); Paginator::setBaseUrl(asset("/category/{$link}")); Paginator::setCurrentPage($page); $totalItems = Product::categorized($category)->active()->count(); $paginator = PrettyPaginator::make($products->toArray(), $totalItems, $limit); return View::make('shop.category', ['category' => $category, 'products' => $products, 'setting' => Config::get('setting'), 'paginate' => $paginator]); }
/** * Search page, using google's. */ public function search() { $query = Purifier::clean(Input::get('q')); $limit = 20; $latest_page = Input::get('page') ?: 1; \Paginator::setCurrentPage($latest_page); $topics = $this->topic->where('title', 'like', '%' . $query . '%')->with('user', 'node', 'lastReplyUser')->paginate($limit); $nodes = Node::allLevelUp(); $links = Link::remember(1440)->get(); return View::make('topics.index', compact('topics', 'nodes', 'links')); //return Redirect::away('https://www.baidu.com/search?q=site:phphub.org ' . $query, 301); }
public function _list($page = 1, $searchString = null) { if (!empty($searchString)) { $roles = Role::where('ime', 'like', '%' . $searchString . '%')->orderBy('ime'); } else { $roles = Role::orderBy('ime'); } if ($page != 1) { Paginator::setCurrentPage($page); } $roles = $roles->paginate(10); $v = View::make('Role.list')->with('roles', $roles); if (Request::ajax()) { return $v->renderSections()['list']; } return $v; }
public function _list($page = 1, $searchString = null) { if (!empty($searchString)) { $cjenovnici = Cjenovnik::where('ime', 'like', '%' . $searchString . '%')->orderBy('ime'); } else { $cjenovnici = Cjenovnik::orderBy('ime'); } if ($page != 1) { Paginator::setCurrentPage($page); } $cjenovnici = $cjenovnici->paginate(10); $v = View::make('Cjenovnik.list')->with('cjenovnici', $cjenovnici); if (Request::ajax()) { return $v->renderSections()['list']; } return $v; }
public function _list($page = 1, $searchString = null) { if (!empty($searchString)) { $ucionice = Ucionica::where('naziv', 'like', '%' . $searchString . '%')->orderBy('naziv'); } else { $ucionice = Ucionica::orderBy('naziv'); } if ($page != 1) { Paginator::setCurrentPage($page); } $ucionice = $ucionice->paginate(10); $v = View::make('Ucionica.list')->with('ucionice', $ucionice); if (Request::ajax()) { return $v->renderSections()['list']; } return $v; }
public function getAll() { $sortColumn = Input::get('sortColumn'); $sortDirection = Input::get('sortDirection'); $pageIndex = Input::get('pageIndex'); $pageSize = Input::get('pageSize'); $includes = Input::get('includes'); $criteria = Input::get('criteria'); $result = array("sortColumn" => Input::get('sortColumn'), "sortDirection" => $sortDirection, "pageIndex" => $pageIndex, "pageSize" => $pageSize, "includes" => $includes, "criteria" => $criteria); if ($pageIndex == NULL) { $pageIndex = 1; } if ($pageSize == NULL) { $pageSize = 10; } Paginator::setCurrentPage($pageIndex); return Response::json(Product::paginate($pageSize)); }
function getList() { if (Request::ajax()) { $defaultField = Input::get('defaultField'); $defaultOrder = Input::get('defaultOrder'); $searchData = Input::get('searchData'); $showNumber = Input::get('showNumber'); $isReset = Input::get('isReset'); $this->data['defaultField'] = $defaultField; $this->data['defaultOrder'] = $defaultOrder; $this->data['defaultURL'] = $this->moduleURL; $this->data['showField'] = $this->model->getShowField(); if ($isReset == 1) { Paginator::setCurrentPage(1); } $this->data['items'] = $this->model->where('publisher_id', $this->getPublisher()->id)->get(); return View::make('ajaxShowList', $this->data); } }
/** * Handle Ajax list item of module */ function getList() { if (Request::ajax()) { $defaultField = "campaign." . Input::get('defaultField'); $defaultOrder = Input::get('defaultOrder'); $searchData = Input::get('searchData'); $showNumber = Input::get('showNumber'); $isReset = Input::get('isReset'); $this->data['defaultField'] = str_replace("campaign.", "", $defaultField); $this->data['defaultOrder'] = $defaultOrder; $this->data['defaultURL'] = $this->moduleURL; $this->data['showField'] = $this->model->getShowField(); if ($isReset == 1) { Paginator::setCurrentPage(1); } //pr($userCurrent,1); $this->data['lists'] = $this->model->getSearchCampaign($searchData)->select('campaign.*', 'category.name as cate_name', 'advertiser.name as name_advertiser', 'flight_website.publisher_base_cost')->where('flight_website.website_id', $this->getPublisher()->id)->orderBy($defaultField, $defaultOrder)->paginate($showNumber); return View::make('ajaxShowList', $this->data); } }
public static function createPagination($dataObject, $input) { //total rows $totalItems = count($dataObject->tableData); //array of rows $items = $dataObject->tableData; //display $perpage = 10; //if we go outside the range of links if ($input < 1 || $input > ceil($totalItems / $perpage)) { $input = 1; Paginator::setCurrentPage(1); } //offset for each page $offset = $input * $perpage - $perpage; //cut up the array for display $articles = array_slice($items, $offset, $perpage); //create the paginated data $paginator = Paginator::make($articles, $totalItems, $perpage); return $paginator; }
public function _list($page = 1, $searchString = null) { $djelatnici = User::with('role', 'role.permissions'); if (!empty($searchString)) { $djelatnici = $djelatnici->where('name', 'like', '%' . $searchString . '%'); } $djelatnici = $djelatnici->orderBy('name'); if ($page != 1) { Paginator::setCurrentPage($page); } $djelatnici = $djelatnici->paginate(10); $v = View::make('Djelatnik.list')->with('instruktori', $djelatnici); if (Request::ajax()) { return $v->renderSections()['list']; } return $v; }
$query->orderBy('created_at', 'desc'); }, ['fields', 'textfields'], true, true, true, 6); $blogs = DicLib::loadImages($blogs, ['image']); #Helper::tad($blogs); #dd($blogs); $current_page = Input::get('tab') == 'events' ? Input::get('page') : 1; Paginator::setCurrentPage($current_page); $events = Dic::valuesBySlug('events', function ($query) use($current_city) { $query->filter_by_field('city_id', '=', $current_city->id); $query->filter_by_field('date_start', '>=', date('Y-m-d')); $query->order_by_field('date_start', 'asc'); }, ['fields', 'textfields'], true, true, true, 1); $events = DicLib::loadImages($events, ['image']); #Helper::tad($events); #dd($events); Paginator::setCurrentPage(1); $current_tab = 'blog'; if (Input::get('tab') == 'events') { $current_tab = Input::get('tab'); } elseif (Input::get('tab') == 'social') { $current_tab = Input::get('tab'); } ?> @section('style') @stop @section('content')
/** * Get paginator * * @param int $page page number * @param int $itemsOnPage number of items on page * @return \Sokil\Mongo\Paginator */ public function paginate($page, $itemsOnPage = 30) { $paginator = new Paginator($this); return $paginator->setCurrentPage($page)->setItemsOnPage($itemsOnPage); }
$ccc = 1; $count = mysql_num_rows($result); if (1 + $recordsPerPage * ($pp - 1) > $count) { $pp = 1; } while ($row = mysql_fetch_array($result, MYSQL_NUM)) { if ($ccc >= 1 + $recordsPerPage * ($pp - 1) and $ccc <= $recordsPerPage * $pp) { $all[$ccc] = $row; $all[$ccc][4] = $ccc; } $ccc++; } // deg($all); $paginator = new Paginator($count); $paginator->setRecordsPerPage($recordsPerPage); $paginator->setCurrentPage($pp); $append .= " LIMIT " . $paginator->getLimit(); $_SESSION['admin_filters_stats']['filters']['count'] = $count; $templates = new Templates(); $templates_list = $templates->getAll(); // deg($templates_list); if (!$default_show) { $template_names_by_hash = array(); foreach ($templates_list as $s) { $template_names_by_hash[$s->hash] = $s->name; } $smarty->assign('template_names_by_hash', $template_names_by_hash); // deg($template_names_by_hash); } $smarty->assign('templateClass', $templates); $smarty->assign('templates', $templates_list);
public function getPage($page) { Paginator::setCurrentPage($page); return Image::paginate(9); }
function getListPublisherManager() { if (Request::ajax()) { $modelPublisher = new ApprovePublisherManagerModel(); $defaultField = Input::get('defaultField'); $defaultOrder = Input::get('defaultOrder'); $searchData = Input::get('searchData'); $showNumber = Input::get('showNumber'); $isReset = Input::get('isReset'); $this->data['defaultField'] = $defaultField; $this->data['defaultOrder'] = $defaultOrder; $this->data['defaultURL'] = $this->moduleURL; $this->data['showField'] = $modelPublisher->getShowField(); if ($isReset == 1) { Paginator::setCurrentPage(1); } $this->data['lists'] = ApprovePublisherManagerModel::Search($searchData, Config::get('backend.publisher_approved'))->orderBy($defaultField, $defaultOrder)->paginate($showNumber); return View::make('ajaxShowListPublisher', $this->data); } }
function getListUser() { if (Request::ajax()) { $this->user = new User(); $defaultField = 'users.' . Input::get('defaultField'); $defaultOrder = Input::get('defaultOrder'); $searchData = Input::get('searchData'); $showNumber = Input::get('showNumber'); $isReset = Input::get('isReset'); $this->data['defaultField'] = str_replace("users.", "", $defaultField); $this->data['defaultOrder'] = $defaultOrder; $this->data['defaultURL'] = $this->moduleURL; $this->data['showField'] = $this->user->getShowFieldUser(); if ($isReset == 1) { Paginator::setCurrentPage(1); } //get id group $idGroup = ['2', '4']; $this->data['lists'] = User::ShowListUser($searchData)->whereIn('groups.id', $idGroup)->orderBy($defaultField, $defaultOrder)->paginate($showNumber); return View::make('manager_user.ajaxShowList', $this->data); } }