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