function index()
{
$this->getView()->addStylesheetURL('assets/stylesheets/sorting.css');
$customer_id = \Yoda\Request::getInt('customer_id');
$did_number = \Yoda\Request::getString('did_number');
$from_date = \Yoda\Request::getString('from_date');
$to_date = \Yoda\Request::getString('to_date');
$order = \Yoda\Request::getString('order', 'duration');
$direction = \Yoda\Request::getString('direction', 'ASC');
$pagination = new Pagination();
$pagination->setLimit(10);
$pagination->setPage(\Yoda\Request::getInt('page', 1));
$pagination->setLink('index.php?controller=call_history&did_number=' . $did_number . '&customer_id=' . $customer_id . '&from_date=' . $from_date . '&to_date=' . $to_date);
$cdr = new Didww\API2\CDRCollection();
$cdr->setCustomerId($customer_id);
$cdr->setDidNumber($did_number);
$cdr->setFromDate($from_date);
$cdr->setToDate($to_date);
$cdr->setOrderBy($order);
$cdr->setOrderDir(strtoupper($direction));
$cdr->setLimit($pagination->getLimit());
$cdr->setOffset($pagination->getOffset());
$cdrs = $cdr->getList();
$total = $cdr->getTotal();
$pagination->setTotal($total);
$this->getView()->setProperties(['view' => $this->getView(), 'cdrs' => $cdrs, 'customer_id' => $customer_id, 'did_number' => $did_number, 'from_date' => $from_date, 'to_date' => $to_date, 'pagination' => $pagination, 'order' => $order, 'direction' => $direction, 'total' => $total])->display();
}
private function listPublicGroups($offset)
{
$sql = "SELECT * FROM groups WHERE active=1 AND type <> 'private' ";
require_once FRAMEWORK_PATH . 'lib/pagination/pagination.class.php';
$pagination = new Pagination($this->registry);
$pagination->setQuery($sql);
$pagination->setOffset($offset);
$pagination->setLimit(20);
$pagination->setMethod('cache');
$pagination->generatePagination();
if ($pagination->getNumRowsPage() == 0) {
$this->registry->getObject('template')->buildFromTemplates('header.tpl.php', 'groups/no-public.tpl.php', 'footer.tpl.php');
} else {
$this->registry->getObject('template')->buildFromTemplates('header.tpl.php', 'groups/public.tpl.php', 'footer.tpl.php');
$this->registry->getObject('template')->getPage()->addTag('groups', array('SQL', $pagination->getCache()));
$this->registry->getObject('template')->getPage()->addTag('page_number', $pagination->getCurrentPage());
$this->registry->getObject('template')->getPage()->addTag('num_pages', $pagination->getNumPages());
if ($pagination->isFirst()) {
$this->registry->getObject('template')->getPage()->addTag('first', '');
$this->registry->getObject('template')->getPage()->addTag('previous', '');
} else {
$this->registry->getObject('template')->getPage()->addTag('first', "<a href='groups/'>First page</a>");
$this->registry->getObject('template')->getPage()->addTag('previous', "<a href='groups/" . ($pagination->getCurrentPage() - 2) . "'>Previous page</a>");
}
if ($pagination->isLast()) {
$this->registry->getObject('template')->getPage()->addTag('next', '');
$this->registry->getObject('template')->getPage()->addTag('last', '');
} else {
$this->registry->getObject('template')->getPage()->addTag('first', "<a href='groups/" . $pagination->getCurrentPage() . "'>Next page</a>");
$this->registry->getObject('template')->getPage()->addTag('previous', "<a href='groups/" . ($pagination->getNumPages() - 1) . "'>Last page</a>");
}
}
}
public function getMany()
{
$req = $this->bcms->request();
$items = \ORM::for_table($this->tableName);
if ($req->get('group')) {
$group = $req->get('group');
$items = $items->where_in('group', $group);
$this->bcms->view()->appendData(array('currentGroup' => $group));
}
// Search
$query = $req->get('query');
if ($query) {
$items = $items->where_like('email', "%{$query}%");
$this->bcms->view()->appendData(array('query' => $query));
}
// Ordering
if ($req->get('order_by')) {
$orderBy = $req->get('order_by');
$items = $items->order_by_asc($orderBy);
$this->bcms->view()->appendData(array('order_by' => $orderBy));
} else {
$items = $items->order_by_desc('date_created');
}
$items = $items->left_outer_join('b_users_profiles', array($this->tableName . '.id', '=', 'b_users_profiles.user_id'));
//Pagination
$pagination = new Pagination($this->bcms);
$pagination->setLimit($this->perPage);
$pagination->setCount($items->count());
$items = $items->limit($this->perPage)->offset($pagination->start);
$items = $items->find_array();
if (!$items) {
return false;
}
return $items;
}
function index()
{
$this->getView()->addStylesheetURL('assets/stylesheets/sorting.css');
$customer_id = \Yoda\Request::getInt('customer_id');
$destination = \Yoda\Request::getString('destination');
$source = \Yoda\Request::getString('source');
$success = \Yoda\Request::getString('success', '');
$from_date = \Yoda\Request::getString('from_date');
$to_date = \Yoda\Request::getString('to_date');
$order = \Yoda\Request::getString('order', 'destination');
$direction = \Yoda\Request::getString('direction', 'ASC');
$pagination = new Pagination();
$pagination->setLimit(10);
$pagination->setPage(\Yoda\Request::getInt('page', 1));
$pagination->setLink('index.php?controller=sms&customer_id=' . $customer_id . '&destination=' . $destination . '&source=' . $source . '&success=' . $success . '&from_date=' . $from_date . '&to_date=' . $to_date);
$sms = new Didww\API2\SMSCollection();
$sms->setCustomerId($customer_id);
$sms->setDestination($destination);
$sms->setSource($source);
if ($success !== '') {
$sms->setSuccess($success);
}
$sms->setFromDate($from_date);
$sms->setToDate($to_date);
$sms->setOrderBy($order);
$sms->setOrderDir(strtoupper($direction));
$sms->setLimit($pagination->getLimit());
$sms->setOffset($pagination->getOffset());
$sms_log = $sms->getList();
$total = $sms->getTotal();
$pagination->setTotal($total);
$this->getView()->setProperties(['view' => $this->getView(), 'sms_log' => $sms_log, 'customer_id' => $customer_id, 'destination' => $destination, 'source' => $source, 'success' => $success, 'from_date' => $from_date, 'to_date' => $to_date, 'pagination' => $pagination, 'order' => $order, 'direction' => $direction, 'total' => $total])->display();
}
/**
* Search for members based on their name
* @param String $filter name
* @param int $offset the offset
* @return Object pagination object
*/
public function filterMembersByName($filter = '', $offset = 0)
{
$filter = $this->registry->getObject('db')->sanitizeData(urldecode($filter));
require_once FRAMEWORK_PATH . 'lib/pagination/pagination.class.php';
$paginatedMembers = new Pagination($this->registry);
$paginatedMembers->setLimit(25);
$paginatedMembers->setOffset($offset);
$query = "SELECT u.ID, u.username, p.name, p.dino_name, p.dino_gender, p.dino_breed FROM users u, profile p WHERE p.user_id=u.ID AND u.active=1 AND u.banned=0 AND u.deleted=0 AND p.name LIKE'%" . $filter . "%' ORDER BY p.name ASC";
$paginatedMembers->setQuery($query);
$paginatedMembers->setMethod('cache');
$paginatedMembers->generatePagination();
return $paginatedMembers;
}
<?php
include 'admin_header.php';
$view = new View();
$user = new User();
$pagination = new Pagination();
// get the actual pagenumber (for pagination)
if (isset($_GET['page'])) {
$page = intval($_GET['page']);
} else {
$page = 1;
}
// config pagination class
$pagination->setTable('users');
$pagination->setPageLink('users.php');
$pagination->setLimit(10);
$pagination->setPage($page);
$pagination->setTotal();
$pagination->setPages();
$pagination->setOffset();
// get the users data as array (for view)
$users = $pagination->getData();
?>
<!-- content wrapper -->
<div class="container-full">
<!-- page row -->
<div class="row">
<!-- sidebar -->
<!-- content wrapper -->
<div class="row-fluid">
<?php
//$view->showProducts($category);
if (isset($_GET['page'])) {
$page = intval($_GET['page']);
} else {
$page = 1;
}
$pagination = new Pagination();
$pagination->setTable('products');
if ($category != null) {
$pagination->setCategory($category);
}
$pagination->setLimit($config->shop_articlepp);
$pagination->setPage($page);
//$pagination->setCategory('books');
$pagination->setTotal();
$pagination->setPages();
$pagination->setOffset();
$products = $pagination->getData();
$view->showProducts($products);
?>
</div> <!-- /.content wrapper -->
<!-- pagination -->
<div class="row text-center">
<div class="col-lg-12">
<?php
include "./pagination.php";
$iLimit = 10;
$iPage = isset($_GET['page']) ? $_GET['page'] : 1;
$iStart = $iLimit * $iPage - $iLimit;
$oPaginate = new Pagination();
$aNames = $oPaginate->getNames($iStart, $iLimit);
$oPaginate->setCount($aNames['count']);
$oPaginate->setRange(3);
$oPaginate->setLimit($iLimit);
$oPaginate->setCurrentPage($iPage);
if ($aNames['count'] > 0) {
foreach ($aNames['names'] as $r) {
echo $r['name'] . '<br>';
}
}
echo $oPaginate->create();
