function tableTitle($title) { $sort = getSort(); $field = strtolower(str_replace(' ', '_', $title)); $page = getPageNumber(); $sortDir = getSortDir($field); $sortChar = !empty($sort) ? 1 : ''; return '<a href="?page=' . $page . '&sort=' . $field . '&sortDir=' . $sortDir . '">' . $title . '</a>'; }
public function listUsers() { //Variables $users = DB::table('user'); $sort = getSort(); $search = Input::get('search'); //Search if (!empty($search)) { $users = $users->where('first_name', 'LIKE', "%{$search}%")->orWhere('last_name', 'LIKE', "%{$search}%"); } //Sort if (!empty($sort)) { $users = $users->orderBy($sort, getSortDir()); } //Paginate $users = $users->paginate($this->pageSize); //Return ViewData return view('users', ['sort' => $sort, 'users' => $users, 'pageNum' => getPageNumber(), 'sortDir' => getSortDir(), 'detailsURL' => '/public/user-info/']); }
/** * Returns paging line. * * @param array $items list of items * * @return CTable */ function getPagingLine(&$items) { global $page; $config = select_config(); $searchLimit = ''; if ($config['search_limit'] < count($items)) { array_pop($items); $searchLimit = '+'; } $rowsPerPage = CWebUser::$data['rows_per_page']; $itemsCount = count($items); $pagesCount = $itemsCount > 0 ? ceil($itemsCount / $rowsPerPage) : 1; $currentPage = getPageNumber(); if ($currentPage < 1) { $currentPage = 1; } if ($itemsCount < ($currentPage - 1) * $rowsPerPage) { $currentPage = $pagesCount; } $start = ($currentPage - 1) * $rowsPerPage; CProfile::update('web.paging.lastpage', $page['file'], PROFILE_TYPE_STR); CProfile::update('web.paging.page', $currentPage, PROFILE_TYPE_INT); // trim array with items to contain items for current page $items = array_slice($items, $start, $rowsPerPage, true); // viewed pages (better to use not odd) $pagingNavRange = 11; $endPage = $currentPage + floor($pagingNavRange / 2); if ($endPage < $pagingNavRange) { $endPage = $pagingNavRange; } if ($endPage > $pagesCount) { $endPage = $pagesCount; } $startPage = $endPage > $pagingNavRange ? $endPage - $pagingNavRange + 1 : 1; $pageLine = array(); $table = null; if ($pagesCount > 1) { $url = CUrlFactory::getContextUrl(); if ($startPage > 1) { $url->setArgument('page', 1); $pageLine[] = new CLink('<< ' . _x('First', 'page navigation'), $url->getUrl(), null, null, true); $pageLine[] = ' '; } if ($currentPage > 1) { $url->setArgument('page', $currentPage - 1); $pageLine[] = new CLink('< ' . _x('Previous', 'page navigation'), $url->getUrl(), null, null, true); $pageLine[] = ' | '; } for ($p = $startPage; $p <= $pagesCount; $p++) { if ($p > $endPage) { break; } if ($p == $currentPage) { $pagespan = new CSpan($p, 'bold textcolorstyles'); } else { $url->setArgument('page', $p); $pagespan = new CLink($p, $url->getUrl(), null, null, true); } $pageLine[] = $pagespan; $pageLine[] = ' | '; } array_pop($pageLine); if ($currentPage < $pagesCount) { $pageLine[] = ' | '; $url->setArgument('page', $currentPage + 1); $pageLine[] = new CLink(_x('Next', 'page navigation') . ' >', $url->getUrl(), null, null, true); } if ($p < $pagesCount) { $pageLine[] = ' '; $url->setArgument('page', $pagesCount); $pageLine[] = new CLink(_x('Last', 'page navigation') . ' >>', $url->getUrl(), null, null, true); } $table = new CTable(null, 'paging'); $table->addRow(new CCol($pageLine)); } $viewFromPage = ($currentPage - 1) * $rowsPerPage + 1; $viewTillPage = $currentPage * $rowsPerPage; if ($viewTillPage > $itemsCount) { $viewTillPage = $itemsCount; } $pageView = array(); $pageView[] = _('Displaying') . SPACE; if ($itemsCount > 0) { $pageView[] = new CSpan($viewFromPage, 'info'); $pageView[] = SPACE . _('to') . SPACE; } $pageView[] = new CSpan($viewTillPage, 'info'); $pageView[] = SPACE . _('of') . SPACE; $pageView[] = new CSpan($itemsCount, 'info'); $pageView[] = $searchLimit; $pageView[] = SPACE . _('found'); $pageView = new CSpan($pageView); zbx_add_post_js('insertInElement("numrows", ' . zbx_jsvalue($pageView->toString()) . ', "div");'); return $table; }
$action = $_REQUEST["action"]; if ($action == "submit") { //$caselist=$_REQUEST["caselist"]; //$memberMgr->deleteCaseList($member["id"],$caselist); echo "RIGHT"; exit; } else { $doctorlist = $memberMgr->getOrderDoctor($member["id"]); $smarty->assign("doctorlist", $doctorlist); $doctor_id = $_REQUEST["doctor_id"]; $from = $_REQUEST["from"]; $to = $_REQUEST["to"]; $smarty->assign("doctor_id", $doctor_id); $smarty->assign("from", $from); $smarty->assign("to", $to); $currentpage = getPageNumber(); $bookinglist = $memberMgr->getBookingList($member["id"], $doctor_id, $from, $to, $currentpage); $list = array(); for ($i = 0; $i < 15; $i++) { $list[$i] = $bookinglist[$i]; } $smarty->assign("list", $list); $sum = $memberMgr->getBookingListPageCount($member["id"], $doctor_id, $from, $to); $smarty->assign("count", $sum); $smarty->assign("current_page", $currentpage); $smarty->assign("lastpage", $currentpage); $smarty->assign("page_arr", getPageNumberCodeArray($sum, $currentpage, 15)); $smarty->assign("list", $list); $smarty->assign("menuid", "booking"); $smarty->display(ROOT . '/templates/Member/bookinglist.html'); }
function MtreeParseRoute($segments) { global $mtconf, $listing_tasks, $listlisting_names; $vars = array(); $db =& JFactory::getDBO(); $end_segment = preg_replace('/:/', '-', end($segments), 1); for ($i = 0; $i < count($segments); $i++) { $segments[$i] = preg_replace('/:/', '-', $segments[$i], 1); } // Fix for listalpha=0. eg: http://<site>/directory/list-alpha/0.html if ($end_segment == '0') { $end_segment = $mtconf->get('sef_listalpha'); } switch ($end_segment) { case $mtconf->get('sef_details'): case eregi($mtconf->get('sef_reviews_page') . "[0-9]+", $end_segment) == true: // http://example.com/directory/arts/leonardo-da-vinci/details $isReviewsPage = eregi($mtconf->get('sef_reviews_page') . '[0-9]+', $end_segment); $path_names = array_slice($segments, 0, -1); $link_id = findLinkID($path_names); $vars['task'] = 'viewlink'; $vars['link_id'] = $link_id; if ($isReviewsPage) { // Get the page numner $pagenumber = substr($end_segment, strlen($mtconf->get('sef_reviews_page'))); $vars['limit'] = $mtconf->get('fe_num_of_reviews'); $vars['limitstart'] = $mtconf->get('fe_num_of_reviews') * ($pagenumber - 1); } break; case $mtconf->get('sef_mypage'): case count($segments) > 1 && $mtconf->get('sef_mypage') == $segments[count($segments) - 2]: $vars['task'] = 'mypage'; $pagenumber = getPageNumber($segments); if ($pagenumber > 0) { $vars['limit'] = $mtconf->get('fe_num_of_links'); $vars['limitstart'] = $mtconf->get('fe_num_of_links') * ($pagenumber - 1); } break; // List listing page // List listing page case count($segments) == 1 && array_key_exists($end_segment, $listlisting_names): case isset($segments[count($segments) - 2]) && (array_key_exists($segments[count($segments) - 2], $listlisting_names) || array_key_exists($segments[count($segments) - 1], $listlisting_names)) && $segments[count($segments) - 2] != $mtconf->get('sef_rss'): $last_segment = $end_segment; if (array_key_exists($last_segment, $listlisting_names)) { $type = $listlisting_names[$last_segment]; $offset = -1; } else { $type = $listlisting_names[$segments[count($segments) - 2]]; $offset = -2; } $vars['task'] = 'list' . $type; $page = getPageNumber($segments); $cat_id = findCatId(array_slice($segments, 0, $offset)); $vars['cat_id'] = $cat_id; if ($page > 0) { $vars['limit'] = $mtconf->get('fe_num_of_' . $type); $vars['limitstart'] = $mtconf->get('fe_num_of_' . $type) * ($page - 1); } break; case $mtconf->get('sef_advsearch'): $vars['task'] = 'advsearch'; break; case count($segments) == 3 && $mtconf->get('sef_advsearch2') == $segments[count($segments) - 3]: case count($segments) == 2 && $mtconf->get('sef_advsearch2') == $segments[count($segments) - 2]: if (count($segments) == 2) { $page = 1; $vars['limitstart'] = 0; $search_id = $end_segment; } else { $page = $end_segment; $vars['limitstart'] = $mtconf->get('fe_num_of_searchresults') * ($page - 1); $search_id = $segments[count($segments) - 2]; } $vars['task'] = 'advsearch2'; $vars['search_id'] = $search_id; $vars['limit'] = $mtconf->get('fe_num_of_searchresults'); break; case count($segments) > 3 && $mtconf->get('sef_searchby') == $segments[count($segments) - 4]: case count($segments) > 2 && $mtconf->get('sef_searchby') == $segments[count($segments) - 3]: if ($mtconf->get('sef_searchby') == $segments[count($segments) - 3]) { $page = 1; $vars['cf_id'] = findCfId($segments[count($segments) - 2]); $vars['value'] = $end_segment; $vars['cat_id'] = findCatId(array_slice($segments, 0, -3)); } else { $page = $end_segment; $vars['cf_id'] = findCfId($segments[count($segments) - 3]); $vars['value'] = $segments[count($segments) - 2]; $vars['cat_id'] = findCatId(array_slice($segments, 0, -4)); } $vars['task'] = 'searchby'; $vars['limit'] = $mtconf->get('fe_num_of_searchresults'); $vars['limitstart'] = $mtconf->get('fe_num_of_searchresults') * ($page - 1); break; case count($segments) > 2 && $mtconf->get('sef_search') == $segments[count($segments) - 3]: case count($segments) > 1 && $mtconf->get('sef_search') == $segments[count($segments) - 2]: if ($mtconf->get('sef_search') == $segments[count($segments) - 2]) { $page = 1; $cat_id = findCatId(array_slice($segments, 0, -2)); $vars['searchword'] = $end_segment; } else { $page = $end_segment; $cat_id = findCatId(array_slice($segments, 0, -3)); $vars['searchword'] = $segments[count($segments) - 2]; } $vars['task'] = 'search'; $vars['limit'] = $mtconf->get('fe_num_of_searchresults'); $vars['limitstart'] = $mtconf->get('fe_num_of_searchresults') * ($page - 1); $vars['cat_id'] = $cat_id; break; // No search string. eg: http://example.com/directory/search.html // No search string. eg: http://example.com/directory/search.html case count($segments) == 1 && $mtconf->get('sef_search') == $segments[count($segments) - 1]: $vars['searchword'] = ''; $vars['task'] = 'search'; $vars['limit'] = $mtconf->get('fe_num_of_searchresults'); $vars['limitstart'] = 0; $vars['cat_id'] = 0; break; case count($segments) > 1 && $mtconf->get('sef_listalpha') == $segments[count($segments) - 2]: case count($segments) > 2 && $mtconf->get('sef_listalpha') == $segments[count($segments) - 3]: if ($mtconf->get('sef_listalpha') == $segments[count($segments) - 2]) { $vars['cat_id'] = findCatId(array_slice($segments, 0, -2)); $vars['alpha'] = end($segments); $page = 1; } else { $vars['cat_id'] = findCatId(array_slice($segments, 0, -3)); $vars['alpha'] = $segments[count($segments) - 2]; $page = $segments[count($segments) - 1]; } $vars['task'] = 'listalpha'; if ($page > 0) { $vars['limit'] = $mtconf->get('fe_num_of_featured'); $vars['limitstart'] = $mtconf->get('fe_num_of_featured') * ($page - 1); } break; case count($segments) == 3 && in_array($segments[count($segments) - 3], array($mtconf->get('sef_owner'), $mtconf->get('sef_reviews'), $mtconf->get('sef_favourites'))) == true: case count($segments) == 2 && in_array($segments[count($segments) - 2], array($mtconf->get('sef_owner'), $mtconf->get('sef_reviews'), $mtconf->get('sef_favourites'))) == true: if (count($segments) == 2) { $task = $segments[count($segments) - 2]; $owner_username = $segments[count($segments) - 1]; } else { $task = $segments[count($segments) - 3]; $owner_username = $segments[count($segments) - 2]; } switch ($task) { case $mtconf->get('sef_owner'): $vars['task'] = 'viewowner'; break; case $mtconf->get('sef_reviews'): $vars['task'] = 'viewusersreview'; break; case $mtconf->get('sef_favourites'): $vars['task'] = 'viewusersfav'; break; } $owner_username = murldecode($owner_username); $db->setQuery("SELECT id FROM #__users WHERE username = "******" LIMIT 1"); $vars['user_id'] = $db->loadResult(); $page = $segments[count($segments) - 1]; if (!is_numeric($page)) { $page = 1; } if ($page > 0) { $vars['limit'] = $mtconf->get('fe_num_of_links'); $vars['limitstart'] = $mtconf->get('fe_num_of_links') * ($page - 1); } break; case count($segments) == 2 && $mtconf->get('sef_editlisting') == $segments[count($segments) - 2] && is_numeric($segments[count($segments) - 1]): $vars['task'] = 'editlisting'; $vars['link_id'] = $end_segment; break; case count($segments) == 2 && $mtconf->get('sef_image') == $segments[count($segments) - 2] && is_numeric($segments[count($segments) - 1]): $vars['task'] = 'viewimage'; $vars['img_id'] = $end_segment; break; case count($segments) == 2 && $mtconf->get('sef_replyreview') == $segments[count($segments) - 2]: $vars['task'] = 'replyreview'; $vars['rev_id'] = $end_segment; break; case count($segments) == 2 && $mtconf->get('sef_reportreview') == $segments[count($segments) - 2]: $vars['task'] = 'reportreview'; $vars['rev_id'] = $end_segment; break; // Listing's task - http://example.com/directory/Business/Mosets/listing_task // Listing's task - http://example.com/directory/Business/Mosets/listing_task case in_array($end_segment, $listing_tasks): $path_names = array_slice($segments, 0, -1); $link_id = findLinkID($path_names); $vars['task'] = array_search($end_segment, $listing_tasks); $vars['link_id'] = $link_id; break; case $mtconf->get('sef_addlisting'): case $mtconf->get('sef_addcategory'): if ($end_segment == $mtconf->get('sef_addlisting')) { $vars['task'] = 'addlisting'; } else { $vars['task'] = 'addcategory'; } $cat_id = findCatId(array_slice($segments, 0, -1)); $vars['cat_id'] = $cat_id; break; case count($segments) > 1 && $mtconf->get('sef_rss') == $segments[count($segments) - 2]: $vars['task'] = 'rss'; $vars['cat_id'] = findCatId(array_slice($segments, 0, -2)); if ($end_segment == 'new') { $vars['type'] = 'new'; } else { $vars['type'] = 'updated'; } break; default: // Find as category $pagepattern = $mtconf->get('sef_category_page') . "[0-9]+"; if (eregi($pagepattern, $end_segment)) { $cat_segments = $segments; array_pop($cat_segments); $cat_id = findCatId($cat_segments); } else { $cat_id = findCatId($segments); } if (!empty($cat_id)) { $vars['cat_id'] = $cat_id; } $vars['task'] = 'listcats'; $page = getPageNumber($segments); if ($page > 0) { $vars['limit'] = $mtconf->get('fe_num_of_links'); $vars['limitstart'] = $mtconf->get('fe_num_of_links') * ($page - 1); } // If no category is found, find as a listing if (empty($cat_id)) { $isReviewsPage = eregi($mtconf->get('sef_reviews_page') . '[0-9]+', $end_segment); $link_id = findLinkID($segments); $vars['task'] = 'viewlink'; $vars['link_id'] = $link_id; if ($isReviewsPage) { // Get the page numner $pagenumber = substr($end_segment, strlen($mtconf->get('sef_reviews_page'))); $vars['limit'] = $mtconf->get('fe_num_of_reviews'); $vars['limitstart'] = $mtconf->get('fe_num_of_reviews') * ($pagenumber - 1); } } break; } return $vars; }
<?php require_once '../park_logins.php'; require_once '../sql/db_connect.php'; require '../Input.php'; $errorsArray = []; function getPageNumber($dbc) { $query = $dbc->prepare('SELECT * FROM national_parks'); $query->execute(); $rowNumber = $query->rowCount(); return $rowNumber; } $rowNumber = getPageNumber($dbc); // var_dump(getPageNumber($dbc)); $maxPage = $rowNumber / 6; var_dump($maxPage); $maxPage = ceil($maxPage); var_dump($maxPage); //round make sure it rounds when decimals are entered into page=''. $page = Input::has('page') ? round(Input::get('page')) : 1; //this gets it to return back to start page when non numeric characters are entered or page <1 or >15. So it won't break. if (isset($_GET['page']) && ($_GET['page'] > $maxPage || $_GET['page'] < 1 || !is_numeric($_GET['page']))) { header('location: national_parks.php'); die; } $offset = ($page - 1) * 6; $selectAll = 'SELECT * FROM national_parks LIMIT 6 OFFSET ' . $offset; $stmt = $dbc->query($selectAll); $parks = $stmt->FetchAll(PDO::FETCH_ASSOC); function insertPark($dbc, $park)
/** * Returns paging line. * * @param array $items list of items * @param string $sortorder the order in which items are sorted ASC or DESC * @param CUrl $url URL object containing arguments and query * * @return CDiv */ function getPagingLine(&$items, $sortorder, CUrl $url) { global $page; $rowsPerPage = CWebUser::$data['rows_per_page']; $itemsCount = count($items); $pagesCount = $itemsCount > 0 ? ceil($itemsCount / $rowsPerPage) : 1; $currentPage = getPageNumber(); if ($currentPage < 1) { $currentPage = 1; } elseif ($currentPage > $pagesCount) { $currentPage = $pagesCount; } $start = ($currentPage - 1) * $rowsPerPage; $tags = []; if ($pagesCount > 1) { // For MVC pages $page is not set if (isset($page['file'])) { CProfile::update('web.paging.lastpage', $page['file'], PROFILE_TYPE_STR); CProfile::update('web.paging.page', $currentPage, PROFILE_TYPE_INT); } elseif (isset($_REQUEST['action'])) { CProfile::update('web.paging.lastpage', $_REQUEST['action'], PROFILE_TYPE_STR); CProfile::update('web.paging.page', $currentPage, PROFILE_TYPE_INT); } // viewed pages (better to use not odd) $pagingNavRange = 11; $endPage = $currentPage + floor($pagingNavRange / 2); if ($endPage < $pagingNavRange) { $endPage = $pagingNavRange; } if ($endPage > $pagesCount) { $endPage = $pagesCount; } $startPage = $endPage > $pagingNavRange ? $endPage - $pagingNavRange + 1 : 1; if ($startPage > 1) { $url->setArgument('page', 1); $tags[] = new CLink(_('First'), $url->getUrl()); } if ($currentPage > 1) { $url->setArgument('page', $currentPage - 1); $tags[] = new CLink((new CSpan())->addClass(ZBX_STYLE_ARROW_LEFT), $url->getUrl()); } for ($p = $startPage; $p <= $endPage; $p++) { $url->setArgument('page', $p); $link = new CLink($p, $url->getUrl()); if ($p == $currentPage) { $link->addClass(ZBX_STYLE_PAGING_SELECTED); } $tags[] = $link; } if ($currentPage < $pagesCount) { $url->setArgument('page', $currentPage + 1); $tags[] = new CLink((new CSpan())->addClass(ZBX_STYLE_ARROW_RIGHT), $url->getUrl()); } if ($p < $pagesCount) { $url->setArgument('page', $pagesCount); $tags[] = new CLink(_('Last'), $url->getUrl()); } } if ($pagesCount == 1) { $table_stats = _s('Displaying %1$s of %2$s found', $itemsCount, $itemsCount); } else { $config = select_config(); $end = $start + $rowsPerPage; if ($end > $itemsCount) { $end = $itemsCount; } $total = $itemsCount; if ($config['search_limit'] < $itemsCount) { if ($sortorder == ZBX_SORT_UP) { array_pop($items); } else { array_shift($items); } $total .= '+'; } $table_stats = _s('Displaying %1$s to %2$s of %3$s found', $start + 1, $end, $total); } // trim array with items to contain items for current page $items = array_slice($items, $start, $rowsPerPage, true); return (new CDiv())->addClass(ZBX_STYLE_TABLE_PAGING)->addItem((new CDiv())->addClass(ZBX_STYLE_PAGING_BTN_CONTAINER)->addItem($tags)->addItem((new CDiv())->addClass(ZBX_STYLE_TABLE_STATS)->addItem($table_stats))); }
} ?> </select> <input type = "submit" id = "searchSubmit"> </form> <br> <?php } ?> <?php if (isset($_GET['bookTitle']) || isset($_GET['bookAuthor']) || isset($_GET['category'])) { // External PHP require_once "Functions.php"; // Get the current page number $pageNo = getPageNumber(); // Set the title variable if (!empty($_GET['bookTitle'])) { $bookTitle = strtoupper(mysql_real_escape_string($_GET['bookTitle'])); echo "Title: " . $_GET['bookTitle']; } else { $bookTitle = ""; } // Set the author variable if (!empty($_GET['bookAuthor'])) { $bookAuthor = strtoupper(mysql_real_escape_string($_GET['bookAuthor'])); if (!empty($_GET['bookTitle'])) { echo " | "; } echo "Author: " . $_GET['bookAuthor']; } else {
$new_trigger['hosts'] = zbx_toHash($new_trigger['hosts'], 'hostid'); foreach ($old_trigger['hosts'] as $old_host) { $new_expression = triggerExpressionReplaceHost($new_trigger['expression'], $new_trigger['hosts'][$pageFilter->hostid]['host'], $old_host['host']); if ($old_expression === $new_expression) { CProfile::update('web.events.filter.triggerid', $new_trigger['triggerid'], PROFILE_TYPE_ID); $triggerId = $new_trigger['triggerid']; break 2; } } } } } } $eventsWidget = (new CWidget())->setTitle(_('Events')); // header $frmForm = (new CForm('get'))->addVar('stime', $stime, 'stime_csv')->addVar('period', $period, 'period_csv')->addVar('page', getPageNumber(), 'page_csv'); if (hasRequest('source')) { $frmForm->addVar('source', getRequest('source'), 'source_csv'); } if ($source == EVENT_SOURCE_TRIGGERS) { $frmForm->addVar('groupid', $pageFilter->groupid, 'groupid_csv'); $frmForm->addVar('hostid', $pageFilter->hostid, 'hostid_csv'); if ($triggerId) { $frmForm->addVar('triggerid', $triggerId, 'triggerid_csv'); } } $frmForm->addVar('fullscreen', getRequest('fullscreen')); $frmForm->addVar('stime', $stime); $frmForm->addVar('period', $period); $controls = new CList(); // add host and group filters to the form
} } $events_wdgt = new CWidget(); // header // allow CSV export button $frmForm = new CForm(); if (isset($_REQUEST['source'])) { $frmForm->addVar('source', $_REQUEST['source'], 'source_csv'); } if (isset($_REQUEST['stime'])) { $frmForm->addVar('stime', $_REQUEST['stime'], 'stime_csv'); } if (isset($_REQUEST['period'])) { $frmForm->addVar('period', $_REQUEST['period'], 'period_csv'); } $frmForm->addVar('page', getPageNumber(), 'page_csv'); if ($source == EVENT_SOURCE_TRIGGERS) { if ($_REQUEST['triggerid']) { $frmForm->addVar('triggerid', $_REQUEST['triggerid'], 'triggerid_csv'); } else { $frmForm->addVar('groupid', $_REQUEST['groupid'], 'groupid_csv'); $frmForm->addVar('hostid', $_REQUEST['hostid'], 'hostid_csv'); } } $frmForm->addItem(new CSubmit('csv_export', _('Export to CSV'))); $events_wdgt->addPageHeader(_('HISTORY OF EVENTS') . SPACE . '[' . zbx_date2str(_('d M Y H:i:s')) . ']', array($frmForm, SPACE, get_icon('fullscreen', array('fullscreen' => $_REQUEST['fullscreen'])))); $r_form = new CForm('get'); $r_form->addVar('fullscreen', $_REQUEST['fullscreen']); $r_form->addVar('stime', get_request('stime')); $r_form->addVar('period', get_request('period')); // add host and group filters to the form
/** * Created by PhpStorm. * User: master * Date: 2016/6/12 * Time: 9:36 */ require './includes/config.php'; require './includes/init.php'; require 'includes/lib_comment.php'; require './lang/' . $_SESSION['lang'] . '/comment.php'; $project = $_SESSION['project']; $option = $_POST['id_product']; $db->changeDB($project); $comments = showComments($option); $commentsPageNumber = getPageNumber(); $smarty->assign('project', $project); $smarty->assign('id_product', $option); $smarty->assign('comments', $comments); $smarty->assign('commentsNumber', $commentsPageNumber); $smarty->assign('lang', $_LANG); if (isMobile()) { $smarty->display("commentList_m.tpl"); } else { $smarty->display("commentList.tpl"); } function showComments($option = '') { $pageComments = $_POST['commentPage']; if (empty($pageComments)) { $pageComments = 1;
function getListOfArticles($app) { $response = ''; try { $clientObj = new CherwellSoap('api.wsdl'); $clientObj->login(getenv('user_id'), getenv('password')); $filter = getHttpQueryParams($app); if ($filter['searchBy'] === 'queryByPrompt' && !empty($filter['prompt'])) { $response = $clientObj->getQueryResultsUsingPromptInfo("Team", getenv('keyword_scope_owner'), getenv('keyword_stored_query_id_def'), getenv('keyword_bus_ob_id'), '<Inputs><Input InputId="Prompt">%' . $filter['prompt'] . '%</Input></Inputs>'); $xmlk = simplexml_load_string($response); if (count($xmlk->xpath('Record')) == 0) { $response = ''; } } else { $response = $clientObj->queryByFieldValue('KnowledgeArticle', $filter['queryName'], $filter['prompt']); } } catch (Exception $e) { var_dump($e->getMessage()); } if (!empty($response)) { $xml = simplexml_load_string($response); $pageNumber = getPageNumber($app, $xml); $ids = getRecordsForDisplay($xml, $pageNumber); $index = 0; $links = array(); foreach ($ids as $record) { if ($filter['searchBy'] === 'queryByPrompt' && !empty($filter['prompt'])) { $response = $clientObj->getBusinessObject('KnowledgeArticle', $record['RecId']); } else { $response = $clientObj->getBusinessObjectByPublicId('KnowledgeArticle', $record); } $xml1 = simplexml_load_string($response); $links[$index]['title'] = $xml1->FieldList->Field[19]; $links[$index]['id'] = $xml1->FieldList->Field[13]; $links[$index]['recId'] = $xml1->FieldList->Field[0]; $index++; } } else { $pageNumber = 1; $links = array(); } $app->view()->setData(array('base' => $app->base, 'currentPage' => $pageNumber, 'links' => $links, 'filter' => $filter)); $app->render("articles.html"); }