Copyright (C) 2006 OrangeHRM Inc., http://www.orangehrm.com
OrangeHRM is free software; you can redistribute it and/or modify it under the terms of
the GNU General Public License as published by the Free Software Foundation; either
version 2 of the License, or (at your option) any later version.
OrangeHRM is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program;
if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
Boston, MA 02110-1301, USA
/** * Affiche la liste des écoles * Permet d'afficher une page avec la liste des écoles (page par défaut du module). */ function ecole_index() { global $pdo, $tpl; $pager = new SimplePager('user_types'); $pager->run($tpl); $tpl->display('ecole_index.tpl'); quit(); }
function event_archive() { global $tpl; $p = new SimplePager('events', 'WHERE `event_end` < NOW()'); $p->run($tpl); $tpl->display('event_index.tpl'); quit(); }
/** * Permet d'afficher la liste des bières * @global type $pdo * @global type $tpl */ function beers_index() { global $pdo, $tpl; if (isset($_POST['search'])) { header('location: ' . urldup(array('search' => $_POST['search']))); quit(); } $where = ''; if (isset($_GET['search'])) { $where = 'WHERE beer_name LIKE ? '; } $pager = new SimplePager('beers', $where . 'ORDER BY beer_name ASC', 'p', 20); if (isset($_GET['search'])) { $pager->bindValue(1, "%{$_GET['search']}%"); } $pager->run($tpl); display(); }
public function execute($request) { $head = sfYaml::load(sfConfig::get('sf_app_dir') . '/lib/list/seller_list.yml'); $sellerlist_headers = array($head['listSeller']['header1'], $head['listSeller']['header2'], $head['listSeller']['header3'], $head['listSeller']['header4']); $columns = 'id,name,address,tp_hp'; $recordsLimit = 5; //have to take from lists if (!$request->hasParameter('pageNo')) { $pageNo = 1; } else { $pageNo = $request->getParameter('pageNo', 1); } $pager = new SimplePager('Seller', $recordsLimit); $pager->setPage($pageNo); $pager->setNumResults($this->getSellerService()->countSellers()); $pager->init(); $offset = $pager->getOffset(); $offset = empty($offset) ? 0 : $offset; $paramHolder = new sfParameterHolder(); $paramHolder->set('columns', $columns); $paramHolder->set('offset', $offset); $paramHolder->set('limit', $recordsLimit); $sellerlist_data = $this->getSellerService()->getSellers($paramHolder); $listContainer = new ListContainer(); $listContainer->setListName('SellerList'); $listContainer->setListHeaders($sellerlist_headers); $listContainer->setListContent($sellerlist_data); $listContainer->setRowLink("seller/showSeller?id="); $listContainer->setPager($pager); $this->listcontainer = $listContainer; }
/** * Execute /../stock/listItem * * @param type $request */ public function execute($request) { $head = sfYaml::load(sfConfig::get('sf_app_dir') . '/lib/list/item_list.yml'); $itemlist_headers = array($head['listItem']['header1'], $head['listItem']['header2'], $head['listItem']['header3'], $head['listItem']['header6']); $columns = 'id,name,sales_unit_price,stock_available'; $recordsLimit = 5; //have to take from lists if (!$request->hasParameter('pageNo')) { $pageNo = 1; } else { $pageNo = $request->getParameter('pageNo', 1); } $pager = new SimplePager('Item', $recordsLimit); $pager->setPage($pageNo); $pager->setNumResults($this->getItemService()->countItems()); $pager->init(); $offset = $pager->getOffset(); $offset = empty($offset) ? 0 : $offset; $paramHolder = new sfParameterHolder(); $paramHolder->set('columns', $columns); $paramHolder->set('offset', $offset); $paramHolder->set('limit', $recordsLimit); $itemlist_data = $this->getItemService()->getItems($paramHolder); $listContainer = new ListContainer(); $listContainer->setListName('ItemList'); $listContainer->setListHeaders($itemlist_headers); $listContainer->setListContent($itemlist_data); $listContainer->setRowLink("stock/showItem?id="); $listContainer->setPager($pager); $this->listcontainer = $listContainer; }
/** * * @param sfRequest $request */ public function execute($request) { $this->setTemplateVariables(); $this->params = array(); foreach ($this->getVarHolder()->getAll() as $param => $val) { $this->params[$param] = $val; } $recordsLimit = self::$itemsPerPage; //sfConfig::get('app_items_per_page'); $pageNo = $request->getParameter('pageNo', 1); if (self::$pageNumber) { $pageNo = self::$pageNumber; } else { $pageNo = $request->getParameter('pageNo', 1); } $numberOfRecords = self::$numberOfRecords; //replace with the count of all the records(self::$listData instanceof Doctrine_Collection) ? self::$listData->count() : count(self::$listData); // TODO: Remove the dependancy of ORM here; Use a Countable interface and a Iterator interface $pager = new SimplePager($this->className, $recordsLimit); $pager->setPage($pageNo); $pager->setNumResults($numberOfRecords); $pager->init(); $offset = $pager->getOffset(); $offset = empty($offset) ? 0 : $offset; $this->offset = $offset; $this->pager = $pager; $this->recordLimit = $recordsLimit; $this->currentSortField = $request->getParameter('sortField', ''); $this->currentSortOrder = $request->getParameter('sortOrder', ''); $this->showGroupHeaders = self::$configurationFactory->showGroupHeaders(); $this->headerGroups = self::$configurationFactory->getHeaderGroups(); $this->columns = self::$configurationFactory->getHeaders(); $this->data = self::$listData; $this->className = self::$configurationFactory->getClassName(); $this->partial = self::$headerPartial; $this->footerPartial = self::$footerPartial; $this->listForm = empty(self::$listForm) ? new DefaultListForm(array(), array(), true) : self::$listForm; $this->applyRuntimeDefinitions(); $this->makePluginCalls(); }
/** * Permet d'afficher la liste des utilisateurs * @global type $pdo * @global type $tpl */ function user_index() { global $pdo, $tpl; if (isset($_POST['search'])) { header('location: ' . urldup(array('search' => $_POST['search']))); quit(); } $where = ''; if (isset($_GET['search'])) { $where = 'WHERE user_name LIKE ? ' . 'OR user_lastname LIKE ? ' . 'OR user_firstname LIKE ? ' . 'OR user_email LIKE ? '; } $pager = new SimplePager('users', $where . 'ORDER BY user_name ASC', 'p', 20); if (isset($_GET['search'])) { $pager->bindValue(1, "%{$_GET['search']}%"); $pager->bindValue(2, "%{$_GET['search']}%"); $pager->bindValue(3, "%{$_GET['search']}%"); $pager->bindValue(4, "%{$_GET['search']}%"); } $pager->run($tpl); $tpl->display('user_index.tpl'); quit(); }
if (!kleeja_check_form_key('adm_exts')) { kleeja_admin_err($lang['INVALID_FORM_KEY'], true, $lang['ERROR'], true, $action, 1); } } if (isset($_GET['add_new_ext'])) { if (!kleeja_check_form_key('adm_exts_new_ext')) { kleeja_admin_err($lang['INVALID_FORM_KEY'], true, $lang['ERROR'], true, $action, 1); } } //show exts $query = array('SELECT' => '*', 'FROM' => "{$dbprefix}exts"); $result_p = $SQL->build($query); //pager $nums_rows = $SQL->num_rows($result_p); $currentPage = isset($_GET['page']) ? intval($_GET['page']) : 1; $Pager = new SimplePager($perpage, $nums_rows, $currentPage); $start = $Pager->getStartRow(); $no_results = false; if ($nums_rows > 0) { $query['LIMIT'] = "{$start}, {$perpage}"; $result = $SQL->build($query); while ($row = $SQL->fetch_array($result)) { //make new lovely arrays !! $g_sz[$row['id']] = isset($_POST['gsz' . $row['id']]) ? $_POST['gsz' . $row['id']] : $row['gust_size']; $u_sz[$row['id']] = isset($_POST['usz' . $row['id']]) ? $_POST['usz' . $row['id']] : $row['user_size']; $arr[] = array('id' => $row['id'], 'name' => $row['ext'], 'group' => ch_g(false, $row['group_id'], true), 'g_size' => round($g_sz[$row['id']] / 1024), 'g_allow' => (int) $row['gust_allow'] ? true : false, 'u_size' => round($u_sz[$row['id']] / 1024), 'u_allow' => (int) $row['user_allow'] ? true : false, 'ug_allow' => $row['gust_allow'] && $row['user_allow'] ? true : false); } $SQL->freeresult($result_p); $SQL->freeresult($result); } else { $no_results = true;
$Issue = Input::Get('Issue', 'int', 0); $Language = Input::Get('Language', 'int', 0); $SectOffs = camp_session_get("SectOffs_" . $Pub . "_" . $Issue . "_" . $Language, 0); if ($SectOffs < 0) { $SectOffs = 0; } $ItemsPerPage = 15; if (!Input::IsValid()) { camp_html_display_error($translator->trans('Invalid input: $1', array('$1' => Input::GetErrorString())), $_SERVER['REQUEST_URI']); exit; } $publicationObj = new Publication($Pub); $issueObj = new Issue($Pub, $Language, $Issue); $allSections = Section::GetSections($Pub, $Issue, $Language, null, null, array('ORDER BY' => 'Number', 'LIMIT' => array('START' => $SectOffs, 'MAX_ROWS' => $ItemsPerPage)), true); $totalSections = Section::GetTotalSections($Pub, $Issue, $Language); $pager = new SimplePager($totalSections, $ItemsPerPage, "SectOffs_" . $Pub . "_" . $Issue . "_" . $Language, "index.php?Pub={$Pub}&Issue={$Issue}&Language={$Language}&"); $topArray = array('Pub' => $publicationObj, 'Issue' => $issueObj); camp_html_content_top($translator->trans('Section List'), $topArray); $controller->view->headTitle($translator->trans('Section List') . ' - Newscoop Admin', 'SET'); ?> <TABLE BORDER="0" CELLSPACING="0" CELLPADDING="1" class="action_buttons" style="padding-top: 5px;"> <TR> <TD><A HREF="/<?php echo $ADMIN; ?> /issues/?Pub=<?php p($Pub); ?> "><IMG SRC="<?php echo $Campsite["ADMIN_IMAGE_BASE_URL"]; ?>
($hook = kleeja_run_hook('begin_filecp')) ? eval($hook) : null; //run hook $stylee = 'filecp'; $titlee = $lang['FILECP']; $H_FORM_KEYS = kleeja_add_form_key('filecp'); //no logon before if (!$usrcp->name()) { kleeja_info($lang['PLACE_NO_YOU'], $lang['USER_PLACE']); } //te get files and update them !! $query = array('SELECT' => 'f.id ,f.name, f.real_filename, f.type, f.folder, f.size', 'FROM' => "{$dbprefix}files f", 'WHERE' => 'f.user='******'ORDER BY' => 'f.id DESC'); //pager $result_p = $SQL->build($query); $nums_rows = $SQL->num_rows($result_p); $currentPage = isset($_GET['page']) ? intval($_GET['page']) : 1; $Pager = new SimplePager($perpage, $nums_rows, $currentPage); $start = $Pager->getStartRow(); $linkgoto = $config['siteurl'] . ($config['mod_writer'] ? 'filecp' : 'ucp.php?go=filecp'); $page_nums = $Pager->print_nums($linkgoto); $action = "ucp.php?go=filecp&page={$currentPage}"; $total_pages = $Pager->getTotalPages(); //now, there is no result $no_results = false; if ($nums_rows != 0) { $query['LIMIT'] = "{$start}, {$perpage}"; ($hook = kleeja_run_hook('qr_select_files_in_filecp')) ? eval($hook) : null; //run hook $result = $SQL->build($query); $sizes = $num = 0; $i = $currentPage * $perpage - $perpage; while ($row = $SQL->fetch_array($result)) {
$f_poll_order = Input::Get('f_poll_order', 'string'); $f_poll_assigned = Input::Get('f_poll_assigned', 'string'); $constraints = array( 'language_id' => $f_language_id, 'publication_id' => $f_publication_id, 'issue_nr' => $f_issue_nr, 'section_nr' => $f_section_nr, 'article_nr' => $f_article_nr ); $polls = Poll::getPolls($constraints, $f_poll_assigned, $f_poll_offset, $f_poll_limit, $f_poll_order); $param_string = "f_poll_item=$f_poll_item&f_issue_nr=$f_issue_nr&f_language_id=$f_language_id&f_publication_id=$f_publication_id"; $pager_params = "?$param_string&f_poll_order=$f_poll_order&"; $pager = new SimplePager(Poll::countPolls($f_language_id), $f_poll_limit, "f_poll_offset", $pager_params, false); Poll::countPolls($f_language_id) ?> <tr> <td colspan="2" style="padding: 3px; background-color: #EEE; border-left: 1px solid #8baed1; border-right: 1px solid #8baed1;"> <?php echo $pager->render(); ?> </td> </tr> <tr> <td colspan="2" style="padding: 3px; background-color: #EEE; border-left: 1px solid #8baed1; border-right: 1px solid #8baed1;"> <TABLE BORDER="0" CELLSPACING="1" CELLPADDING="3" class="table_list" style="padding-top: 5px;" width="95%"> <?php $counter = 0;
$img_types = array('gif', 'jpg', 'png', 'bmp', 'jpeg', 'GIF', 'JPG', 'PNG', 'BMP', 'JPEG'); $query['WHERE'] = $query['WHERE'] . (empty($query['WHERE']) ? '' : ' AND ') . "f.type NOT IN ('" . implode("', '", $img_types) . "')"; } $query['ORDER BY'] .= isset($_REQUEST['order_way']) && (int) $_REQUEST['order_way'] == 1 ? ' ASC' : ' DESC'; $nums_rows = 0; if ($do_not_query_total_files) { $nums_rows = get_actual_stats('files'); } else { $result_p = $SQL->build($query); $n_fetch = $SQL->fetch_array($result_p); $nums_rows = $n_fetch['total_files']; $SQL->freeresult($result_p); } //pager $currentPage = isset($_GET['page']) ? intval($_GET['page']) : 1; $Pager = new SimplePager($perpage, $nums_rows, $currentPage); $start = $Pager->getStartRow(); $no_results = false; if ($nums_rows > 0) { $query['SELECT'] = 'f.*' . ((int) $config['user_system'] == 1 ? ', u.name AS username' : ''); $query['LIMIT'] = "{$start}, {$perpage}"; $result = $SQL->build($query); $sizes = false; $num = 0; #if Kleeja integtared we dont want make alot of queries $ids_and_names = array(); while ($row = $SQL->fetch_array($result)) { $userfile = $config['siteurl'] . ($config['mod_writer'] ? 'fileuser-' . $row['user'] . '.html' : 'ucp.php?go=fileuser&id=' . $row['user']); #for username in integrated user system if ($row['user'] != '-1' and (int) $config['user_system'] != 1) { if (!in_array($row['user'], $ids_and_names)) {
} //to get userdata!! $data_user = (int) $config['user_system'] == 1 ? $usrcp->get_data('name, show_my_filecp', $user_id) : array('name' => $usrcp->usernamebyid($user_id), 'show_my_filecp' => '1'); if (!$data_user['name']) { kleeja_err($lang['NOT_EXSIT_USER'], $lang['PLACE_NO_YOU']); } if (!$data_user['show_my_filecp'] && $usrcp->id() != $user_id && !user_can('enter_acp')) { kleeja_info($lang['USERFILE_CLOSED'], $lang['CLOSED_FEATURE']); } $query = array('SELECT' => 'f.id, f.name, f.real_filename, f.folder, f.type, f.uploads, f.time, f.size', 'FROM' => "{$dbprefix}files f", 'WHERE' => 'f.user='******'ORDER BY' => 'f.id DESC'); //pager $perpage = 16; $result_p = $SQL->build($query); $nums_rows = $SQL->num_rows($result_p); $currentPage = isset($_GET['page']) ? intval($_GET['page']) : 1; $Pager = new SimplePager($perpage, $nums_rows, $currentPage); $start = $Pager->getStartRow(); $your_fileuser = $config['siteurl'] . ($config['mod_writer'] ? 'fileuser-' . $usrcp->id() . '.html' : 'ucp.php?go=fileuser&id=' . $usrcp->id()); $total_pages = $Pager->getTotalPages(); $linkgoto = $config['siteurl'] . ($config['mod_writer'] ? 'fileuser-' . $user_id . '.html' : 'ucp.php?go=fileuser&id=' . $user_id); $page_nums = $Pager->print_nums(str_replace('.html', '', $linkgoto)); $no_results = true; if ((int) $config['user_system'] != 1 && $usrcp->id() != $user_id) { $data_user['name'] = $usrcp->usernamebyid($user_id); } $user_name = !$data_user['name'] ? false : $data_user['name']; #set page title $titlee = $lang['FILEUSER'] . ': ' . $user_name; #there is result ? show them if ($nums_rows != 0) { $no_results = false;
public function execute($request) { $request->setParameter('initialActionName', 'viewDirectory'); $isPaging = $request->getParameter('hdnAction') == 'search' ? 1 : $request->getParameter('pageNo', 1); $pageNumber = $isPaging; if (!empty($empNumber) && $this->getUser()->hasAttribute('pageNumber')) { $pageNumber = $this->getUser()->getAttribute('pageNumber'); } $noOfRecords = sfConfig::get('app_items_per_page'); $offset = $pageNumber >= 1 ? ($pageNumber - 1) * $noOfRecords : ($request->getParameter('pageNo', 1) - 1) * $noOfRecords; // Reset filters if requested to if ($request->hasParameter('reset')) { $this->setFilters(array()); $this->setSortParameter(array("field" => NULL, "order" => NULL)); $this->setPage(1); } $this->setForm(new EmployeeDirectorySearchForm($this->getFilters())); //handles post method if ($request->isMethod('post')) { $this->form->bind($request->getParameter($this->form->getName())); if ($this->form->isValid()) { if ($this->form->getValue('isSubmitted') == 'yes') { $this->setSortParameter(array("field" => NULL, "order" => NULL)); } $this->setFilters($this->form->getValues()); } else { $this->setFilters(array()); } $this->setPage(1); } //handles get method if ($request->isMethod('get')) { $sortParam = array("field" => $request->getParameter('sortField'), "order" => $request->getParameter('sortOrder')); $this->setSortParameter($sortParam); $this->setPage(1); } $filters = $this->getFilters(); if (isset($filters['emp_name']) && $filters['emp_name']['empName'] != __('Type for hints...')) { if (strpos($filters['emp_name']['empName'], __('Past Employee')) !== false) { $filters['termination'] = EmployeeSearchForm::WITH_TERMINATED; } $filters['employee_name'] = str_replace(' (' . __('Past Employee') . ')', '', $filters['emp_name']['empName']); } $this->filterApply = !empty($filters); $empList = $this->getEmployeeService()->getEmployeeIdList(); if (count($empList) > 0) { $filters['employee_id_list'] = $empList; $count = $this->getDirectoryService()->getSearchEmployeeCount($filters); $parameterHolder = new EmployeeSearchParameterHolder(); $parameterHolder->setOrderField($sortField); $parameterHolder->setOrderBy($sortOrder); $parameterHolder->setLimit($noOfRecords); $parameterHolder->setOffset($offset); $parameterHolder->setFilters($filters); $this->list = $this->getDirectoryService()->searchEmployees($parameterHolder); } else { $count = 0; $list = array(); } $recordsLimit = sfConfig::get('app_items_per_page'); //self::$itemsPerPage;// $pageNo = $request->getParameter('pageNo', 1); /* * if (self::$pageNumber) { $pageNo = self::$pageNumber; } else { */ //$pageNo = 1; //$request->getParameter('pageNo', 1); //} $numberOfRecords = $count; //replace with the count of all the records(self::$listData instanceof Doctrine_Collection) ? self::$listData->count() : count(self::$listData); // TODO: Remove the dependancy of ORM here; Use a Countable interface and a Iterator interface if ($recordsLimit < $numberOfRecords) { $this->isPaginated = TRUE; } $pager = new SimplePager($this->className, $recordsLimit); $pager->setPage($pageNo); $pager->setNumResults($numberOfRecords); $pager->init(); $offset = $pager->getOffset(); $offset = empty($offset) ? 0 : $offset; $this->offset = $offset; $this->pager = $pager; $this->recordLimit = $recordsLimit; //$this->currentSortField = $request->getParameter('sortField', ''); //$this->currentSortOrder = $request->getParameter('sortOrder', ''); }
if (isset($_GET['admin'])) { $admin = (int) $_GET['admin'] == 1 ? "AND admin = 1 " : ''; $is_search = true; $isn_search = false; $is_asearch = true; $query['WHERE'] = "name != '' {$admin}"; } } } $result = $SQL->build($query); $nums_rows = 0; $n_fetch = $SQL->fetch_array($result); $nums_rows = $n_fetch['total_users']; //pager $currentPage = isset($_GET['page']) ? intval($_GET['page']) : 1; $Pager = new SimplePager($perpage, $nums_rows, $currentPage); $start = $Pager->getStartRow(); $no_results = false; if ($nums_rows > 0) { $query['SELECT'] = '*'; $query['LIMIT'] = "{$start}, {$perpage}"; $result = $SQL->build($query); while ($row = $SQL->fetch_array($result)) { //make new lovely arrays !! $ids[$row['id']] = $row['id']; $name[$row['id']] = isset($_POST['nm_' . $row['id']]) ? $_POST['nm_' . $row['id']] : $row['name']; $mail[$row['id']] = isset($_POST['ml_' . $row['id']]) ? $_POST['ml_' . $row['id']] : $row['mail']; $pass[$row['id']] = isset($_POST['ps_' . $row['id']]) ? $_POST['ps_' . $row['id']] : ''; $admin[$row['id']] = $row['admin']; $del[$row['id']] = isset($_POST['del_' . $row['id']]) ? $_POST['del_' . $row['id']] : ''; $userfile = $config['siteurl'] . ($config['mod_writer'] ? 'fileuser-' . $row['id'] . '.html' : 'ucp.php?go=fileuser&id=' . $row['id']);
if (strpos($config['queue'], ':' . $current_smt . 'reports:') !== false) { kleeja_admin_err($lang['DELETE_PROCESS_IN_WORK'], true, $lang['ERROR'], true, basename(ADMIN_PATH) . '?cp=' . basename(__FILE__, '.php'), 1); } else { update_config('queue', $config['queue'] . ':' . $current_smt . 'reports:'); kleeja_admin_info($lang['DELETE_PROCESS_QUEUED'], true, '', true, basename(ADMIN_PATH) . '?cp=' . basename(__FILE__, '.php')); } } $query = array('SELECT' => '*', 'FROM' => "{$dbprefix}reports r", 'ORDER BY' => 'r.id DESC'); if ($current_smt == 'show_h24') { $query['WHERE'] = 'r.time > ' . intval(time() - 3600 * 24); } $result = $SQL->build($query); //pagination $nums_rows = $SQL->num_rows($result); $currentPage = isset($_GET['page']) ? intval($_GET['page']) : 1; $Pager = new SimplePager($perpage, $nums_rows, $currentPage); $start = $Pager->getStartRow(); $no_results = false; $del_nums = array(); if ($nums_rows > 0) { $query['LIMIT'] = "{$start}, {$perpage}"; $result = $SQL->build($query); while ($row = $SQL->fetch_array($result)) { //make new lovely arrays !! $arr[] = array('id' => $row['id'], 'name' => $row['name'], 'mail' => $row['mail'], 'url' => $row['url'], 'text' => $row['text'], 'human_time' => kleeja_date($row['time']), 'time' => kleeja_date($row['time'], false), 'ip' => $row['ip'], 'sent' => $row['id'] == $msg_sent, 'ip_finder' => 'http://www.ripe.net/whois?form_type=simple&full_query_string=&searchtext=' . htmlspecialchars($row['ip']) . '&do_search=Search'); $del[$row['id']] = isset($_POST['del_' . $row['id']]) ? $_POST['del_' . $row['id']] : ''; $sen[$row['id']] = isset($_POST['v_' . $row['id']]) ? $_POST['v_' . $row['id']] : ''; //when submit !! if (isset($_POST['submit'])) { if ($del[$row['id']]) { $del_nums[] = $row['id'];
private function addPagination(&$oQuery, $oTemplate) { $iPage = (int) (isset($_REQUEST[self::PAGINATION_PARAM]) ? $_REQUEST[self::PAGINATION_PARAM] : 1); $oPager = new SimplePager($oQuery, $iPage, $this->iEntriesPerPage); if (!$oPager->requiresPagination() || !$oTemplate->hasIdentifier('pagination')) { return; } // Basic page link without page number $sBasePageLink = LinkUtil::link(array_merge(FrontendManager::$CURRENT_NAVIGATION_ITEM->getLink(), array(self::PAGINATION_PARAM))); $oPager->setPageLinkBase($sBasePageLink); $oQuery = $oPager->getQuery(); $oPagerTemplate = $this->constructTemplate('pagination'); // All page links including current one $iTotalPages = $oPager->getTotalPageCount(); foreach ($oPager as $oPage) { if ($oPage->page === $iPage) { $oPageLink = TagWriter::quickTag('span', array(), $oPage->page); } else { $oPageLink = TagWriter::quickTag('a', array('title' => TranslationPeer::getString('pager.go_to_page', null, null, array('page_number' => $i)), 'href' => $oPage->link), $oPage->page); } $oPagerTemplate->replaceIdentifierMultiple('page_links', $oPageLink); } $oPagerTemplate->replaceIdentifier('previous_link', $oPager->getPreviousLink()); $oPagerTemplate->replaceIdentifier('next_link', $oPager->getNextLink()); $oTemplate->replaceIdentifier('pagination', $oPagerTemplate); return $oPager; }
/** * SimplePager, unlike the PEAR Pager class, is a pager made to work * with template-like layouts. The constructor sets up the variables * you need to render the links, and you can render them * however you like. There is a default render function for * reference. * * @param int $p_totalItems * Total number of items. * * @param int $p_itemsPerPage * Number of items to display per page. * * @param string $p_offsetVarName * The name of the REQUEST variable which holds the order number * of the first item on the selected page. * * @param string $p_baseUrl * The url to which we attach the offset variable name. * * @param boolean $p_useSessions * Set to TRUE if you want the offset item number to be stored in * the session so that the user will return to their previous * position in the pager when they leave the screen and come back * to it. */ public function SimplePager($p_totalItems, $p_itemsPerPage, $p_offsetVarName, $p_baseUrl, $p_useSessions = true, $p_width = 10) { global $_REQUEST; $this->m_urls["links"] = array(); if ($p_totalItems < 0) { $p_totalItems = 0; } if ($p_itemsPerPage < 1) { $p_itemsPerPage = 1; } // Get the current page number. if ($p_useSessions) { $this->m_offset = camp_session_get($p_offsetVarName, 0); } else { $this->m_offset = isset($_REQUEST[$p_offsetVarName]) ? $_REQUEST[$p_offsetVarName] : 0; } if ($this->m_offset < 0) { $this->m_offset = 0; } elseif ( ($this->m_offset) > $p_totalItems) { // If the offset is past the total number of items, // reset it. $this->m_offset = 0; if ($p_useSessions) { camp_session_set($p_offsetVarName, 0); } } // Only generate pager if there is more than one page of information. if ($p_totalItems > $p_itemsPerPage) { // Generate the offsets into the list. $remainder = $p_totalItems % $p_itemsPerPage; if ($remainder == 0) { $this->m_offsets = SimplePager::_range(0, $p_totalItems-1, $p_itemsPerPage); } else { $this->m_offsets = SimplePager::_range(0, $p_totalItems, $p_itemsPerPage); } $this->m_numPages = count($this->m_offsets); $this->m_selectedPageNumber = floor($this->m_offset/$p_itemsPerPage)+1; if ($p_width > $this->m_numPages) { $p_width = $this->m_numPages; } // Generate the numbered links if ($this->m_selectedPageNumber < ($p_width/2 + 1)) { $begin = 0; $end = $p_width; } else if ($this->m_selectedPageNumber > ($this->m_numPages - ($p_width/2))) { $begin = $this->m_numPages - $p_width; $end = $this->m_numPages; } else { $begin = $this->m_selectedPageNumber - ceil($p_width/2) - 1; $end = $this->m_selectedPageNumber + ceil($p_width/2); } for ($index = $begin; $index < $end; $index++) { $this->m_urls["links"][$index+1] = $p_baseUrl."$p_offsetVarName=".$this->m_offsets[$index]; } // Generate special links. if ($this->m_selectedPageNumber > 1) { $this->m_urls["first"] = $p_baseUrl."$p_offsetVarName=".$this->m_offsets[0]; $this->m_urls["previous"] = $p_baseUrl."$p_offsetVarName=".$this->m_offsets[max(0, $this->m_selectedPageNumber-2)]; } if ($this->m_selectedPageNumber > 10) { $this->m_urls["previous_10_pages"] = $p_baseUrl."$p_offsetVarName=".$this->m_offsets[max(0, $this->m_selectedPageNumber-11)]; } if ($this->m_selectedPageNumber > 100) { $this->m_urls["previous_100_pages"] = $p_baseUrl."$p_offsetVarName=".$this->m_offsets[max(0, $this->m_selectedPageNumber-101)]; } if ( ($this->m_numPages > $this->m_selectedPageNumber)) { $this->m_urls["next"] = $p_baseUrl."$p_offsetVarName=".$this->m_offsets[min($this->m_numPages-1, $this->m_selectedPageNumber)]; } if ( ($this->m_numPages - $this->m_selectedPageNumber) > 9) { $this->m_urls["next_10_pages"] = $p_baseUrl."$p_offsetVarName=".$this->m_offsets[min($this->m_numPages-1, $this->m_selectedPageNumber+9)]; } if ( ($this->m_numPages - $this->m_selectedPageNumber) > 99) { $this->m_urls["next_100_pages"] = $p_baseUrl."$p_offsetVarName=".$this->m_offsets[min($this->m_numPages-1, $this->m_selectedPageNumber+99)]; } if ( ($this->m_numPages > $this->m_selectedPageNumber)) { $this->m_urls["last"] = $p_baseUrl."$p_offsetVarName=".$this->m_offsets[$this->m_numPages-1]; } } } // constructor
$query['ORDER BY'] = "f." . $SQL->escape($_REQUEST['order_by']); } if (!isset($_GET['search'])) { //display files or display pics and files only in search $img_types = array('gif', 'jpg', 'png', 'bmp', 'jpeg', 'tif', 'tiff', 'GIF', 'JPG', 'PNG', 'BMP', 'JPEG', 'TIF', 'TIFF'); $query['WHERE'] = $query['WHERE'] . (empty($query['WHERE']) ? '' : ' AND ') . "f.type NOT IN ('" . implode("', '", $img_types) . "')"; } $query['ORDER BY'] .= isset($_REQUEST['order_way']) && (int) $_REQUEST['order_way'] == 1 ? ' ASC' : ' DESC'; $result_p = $SQL->build($query); $nums_rows = 0; $n_fetch = $SQL->fetch_array($result_p); $nums_rows = $n_fetch['total_files']; $SQL->freeresult($result_p); //pager $currentPage = isset($_GET['page']) ? intval($_GET['page']) : 1; $Pager = new SimplePager($perpage, $nums_rows, $currentPage); $start = $Pager->getStartRow(); $no_results = false; if ($nums_rows > 0) { $query['SELECT'] = 'f.*' . ((int) $config['user_system'] == 1 ? ', u.name AS username' : ''); $query['LIMIT'] = "{$start}, {$perpage}"; $result = $SQL->build($query); $sizes = false; $num = 0; #if Kleeja integtared we dont want make alot of queries $ids_and_names = array(); while ($row = $SQL->fetch_array($result)) { $userfile = $config['siteurl'] . ($config['mod_writer'] ? 'fileuser-' . $row['user'] . '.html' : 'ucp.php?go=fileuser&id=' . $row['user']); #for username in integrated user system if ($row['user'] != '-1' and (int) $config['user_system'] != 1) { if (!in_array($row['user'], $ids_and_names)) {
$f_log_page_offset = camp_session_get('f_log_page_offset', 0); if ($f_event_search_id == 0) { $f_event_search_id = null; } $events = Event::GetEvents(); if ($f_log_page_offset < 0) { $f_log_page_offset = 0; } $ItemsPerPage = 15; $logs = Log::GetLogs($f_event_search_id, array('LIMIT' => array('MAX_ROWS' => $ItemsPerPage, 'START' => $f_log_page_offset))); $numLogLines = Log::GetNumLogs($f_event_search_id); $pager = new SimplePager($numLogLines, $ItemsPerPage, "f_log_page_offset", "index.php?f_event_search_id=".urlencode($f_event_search_id)."&"); $crumbs = array(); $crumbs[] = array(getGS("Configure"), ""); $crumbs[] = array(getGS("Logs"), ""); echo camp_html_breadcrumbs($crumbs); ?> <p> <TABLE BORDER="0" CELLSPACING="0" CELLPADDING="0" class="action_buttons"> <TR> <TD ALIGN="RIGHT"> <FORM METHOD="GET" ACTION="index.php" NAME=""> <TABLE BORDER="0" CELLSPACING="0" CELLPADDING="1" class="search_dialog"> <TR> <TD><?php putGS('Event'); ?>:</TD>
$group_name = str_replace(array('{lang.ADMINS}', '{lang.USERS}', '{lang.GUESTS}'), array($lang['ADMINS'], $lang['USERS'], $lang['GUESTS']), $d_groups[$req_group]['data']['group_name']); $query['WHERE'] = "name != '' AND group_id = " . $req_group; } #show users (all) #show users (all) case 'users': $query['SELECT'] = 'COUNT(id) AS total_users'; $query['FROM'] = "{$dbprefix}users"; $query['ORDER BY'] = 'id ASC'; $result = $SQL->build($query); $nums_rows = 0; $n_fetch = $SQL->fetch_array($result); $nums_rows = $n_fetch['total_users']; //pagination $currentPage = isset($_GET['page']) ? intval($_GET['page']) : 1; $Pager = new SimplePager($perpage, $nums_rows, $currentPage); $start = $Pager->getStartRow(); $no_results = false; if ($nums_rows > 0) { $query['SELECT'] = 'id, name, founder, group_id, last_visit'; $query['LIMIT'] = "{$start}, {$perpage}"; $result = $SQL->build($query); while ($row = $SQL->fetch_array($result)) { $userfile = $config['siteurl'] . ($config['mod_writer'] ? 'fileuser-' . $row['id'] . '.html' : 'ucp.php?go=fileuser&id=' . $row['id']); $arr[] = array('id' => $row['id'], 'name' => $row['name'], 'userfile_link' => $userfile, 'delusrfile_link' => $row['founder'] && (int) $userinfo['founder'] == 0 ? false : basename(ADMIN_PATH) . '?cp=' . basename(__FILE__, '.php') . '&deleteuserfile=' . $row['id'] . (isset($_GET['page']) ? '&page=' . intval($_GET['page']) : ''), 'delusr_link' => $userinfo['id'] == $row['id'] || $row['founder'] && (int) $userinfo['founder'] == 0 ? false : basename(ADMIN_PATH) . '?cp=' . basename(__FILE__, '.php') . '&del_user='******'id'] . (isset($_GET['page']) ? '&page=' . intval($_GET['page']) : ''), 'editusr_link' => $row['founder'] && (int) $userinfo['founder'] == 0 ? false : basename(ADMIN_PATH) . '?cp=' . basename(__FILE__, '.php') . '&smt=edit_user&uid=' . $row['id'] . (isset($_GET['page']) ? '&page=' . intval($_GET['page']) : ''), 'founder' => (int) $row['founder'], 'last_visit' => empty($row['last_visit']) ? $lang['NOT_YET'] : kleeja_date($row['last_visit']), 'group' => str_replace(array('{lang.ADMINS}', '{lang.USERS}', '{lang.GUESTS}'), array($lang['ADMINS'], $lang['USERS'], $lang['GUESTS']), $d_groups[$row['group_id']]['data']['group_name'])); } $SQL->freeresult($result); } else { $no_results = true; } //pages