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