/** * Displays the zone list */ function rows($result, $map, $reload_allowed, $page, $total_pages) { global $fmdb, $__FM_CONFIG; $all_num_rows = $num_rows = $fmdb->num_rows; $results = $fmdb->last_result; if (currentUserCan('reload_zones', $_SESSION['module'])) { $bulk_actions_list = array(__('Reload')); $checkbox[] = array('title' => '<input type="checkbox" class="tickall" onClick="toggle(this, \'domain_list[]\')" />', 'class' => 'header-tiny header-nosort'); } else { $checkbox = $bulk_actions_list = null; } if (!$result) { printf('<p id="table_edits" class="noresult" name="domains">%s</p>', __('There are no zones.')); } else { if (array_key_exists('attention', $_GET)) { $num_rows = $GLOBALS['zone_badge_counts'][$map]; $total_pages = ceil($num_rows / $_SESSION['user']['record_count']); if ($page > $total_pages) { $page = $total_pages; } } $start = $_SESSION['user']['record_count'] * ($page - 1); $end = $_SESSION['user']['record_count'] * $page > $num_rows ? $num_rows : $_SESSION['user']['record_count'] * $page; $classes = array_key_exists('attention', $_GET) ? null : ' grey'; $eye_attention = $GLOBALS['zone_badge_counts'][$map] ? '<i class="fa fa-eye fa-lg eye-attention' . $classes . '" title="' . __('Only view zones that need attention') . '"></i>' : null; $addl_blocks = array(@buildBulkActionMenu($bulk_actions_list, 'server_id_list'), $this->buildFilterMenu(), $eye_attention); $fmdb->num_rows = $num_rows; echo displayPagination($page, $total_pages, $addl_blocks); $table_info = array('class' => 'display_results sortable', 'id' => 'table_edits', 'name' => 'domains'); $title_array = array(array('title' => __('ID'), 'class' => 'header-small header-nosort'), array('title' => __('Domain'), 'rel' => 'domain_name'), array('title' => __('Type'), 'rel' => 'domain_type'), array('title' => __('Views'), 'class' => 'header-nosort'), array('title' => __('Records'), 'class' => 'header-small header-nosort')); $title_array[] = array('title' => __('Actions'), 'class' => 'header-actions header-nosort'); if (is_array($checkbox)) { $title_array = array_merge($checkbox, $title_array); } echo displayTableHeader($table_info, $title_array, 'zones'); $y = 0; for ($x = $start; $x < $all_num_rows; $x++) { if ($y == $_SESSION['user']['record_count']) { break; } if (array_key_exists('attention', $_GET)) { if (!$results[$x]->domain_clone_domain_id && $results[$x]->domain_type == 'master' && $results[$x]->domain_template == 'no' && (!getSOACount($results[$x]->domain_id) || !getNSCount($results[$x]->domain_id) || $results[$x]->domain_reload != 'no')) { $this->displayRow($results[$x], $map, $reload_allowed); $y++; } } else { $this->displayRow($results[$x], $map, $reload_allowed); $y++; } } echo "</tbody>\n</table>\n"; } }
$sort_direction = null; if (isset($_SESSION[$_SESSION['module']][$GLOBALS['path_parts']['filename']])) { extract($_SESSION[$_SESSION['module']][$GLOBALS['path_parts']['filename']], EXTR_OVERWRITE); } if (in_array($record_type, array('A', 'AAAA')) && $sort_field == 'record_value') { $ip_sort = true; } if (isset($search_query)) { $record_sql .= $search_query; } $result = basicGetList('fm_' . $__FM_CONFIG['fmDNS']['prefix'] . 'records', array($sort_field, 'record_name'), 'record_', $record_sql, null, $ip_sort, $sort_direction); $total_pages = ceil($fmdb->num_rows / $_SESSION['user']['record_count']); if ($page > $total_pages) { $page = $total_pages; } $pagination = displayPagination($page, $total_pages); $body .= $pagination . '<div class="overflow-container">' . $form; $record_rows = $fm_dns_records->rows($result, $record_type, $domain_id, $page); if (currentUserCan('manage_records', $_SESSION['module']) && $zone_access_allowed) { $body .= '<div class="existing-container">' . $record_rows; $body .= sprintf('</div><div class="new-container"> <a name="#manage"></a> <h2>%s</h2> %s <p><input type="submit" name="submit" value="%s" class="button" /></p> </form></div>' . "\n", __('Add Record'), $fm_dns_records->printRecordsForm($form_data, $action, $record_type, $domain_id), __('Validate')); } else { $body .= '<div class="existing-container no-bottom-margin">' . $record_rows; } } echo $body . '</div>' . "\n";
$page = isset($_GET['page']) ? (int) $_GET['page'] : -1; if ($page == 0 || $page == 1) { header('Location: ./'); } else { if ($page == -1) { $page = 0; } } // check if pagination is asked if (!empty($_GET['page'])) { checkPagination($page, $books->count()); $tpl->assign('book', $books->lastBooks(($page - 1) * PAGINATION)); } else { $tpl->assign('book', $books->lastBooks()); } $tpl->assign('pagination', displayPagination($page, $books->count())); $tpl->assign('page_title', !empty($page) ? 'Page ' . $page : ''); $tpl->assign('menu_links', Path::menu('home')); $tpl->assign('menu_links_admin', Path::menuAdmin('home')); $tpl->assign('token', getToken()); $tpl->draw('list'); exit; } // book asked if (!empty($_GET['book'])) { bookPage(); } // admin asked if (isset($_GET['admin'])) { administration(); }
function showPage($username = '', $accessLvl = '', $errors = '') { //page where user will select user to edit global $db; showHeader($username, $accessLvl); include 'connectToDB.php'; include 'pagination_functionality.php'; //include 'dump_all_page_contents.php'; if ($errors) { //show errors at top of page print '<h2 class = "error"> The following errors were encountered:</h2>'; print '<ul><li>'; print implode('</li><li>', $errors); print '</li></ul>'; } $query_dept = "SELECT dept_id FROM users WHERE user_id={$_SESSION['userid']}"; $result_dept = mysqli_query($db, $query_dept); $dept_row = mysqli_fetch_array($result_dept); $query_dept = "SELECT name FROM departments WHERE dept_id={$dept_row['dept_id']}"; $result_deptName = mysqli_query($db, $query_dept); $dept_rowName = mysqli_fetch_array($result_deptName); if ($accessLvl == 'U') { //is access is only at the user level, then must match the refunds pulled to display only the current users created refunds if ($dept_rowName['name'] == "Accounting") { if (isset($_GET['refund_id'])) { $query = "SELECT NG_enc_id, U.first_name, U.last_name, dt_request, status, dt_required, payable, \n\t\t\taddr_ln_1, addr_ln_2, city, state, zip, purpose, amount, status, comments, assigned_to,created_by,check_date,check_nbr \n\t\t\tFROM refund AS R \n\t\t\tINNER JOIN users AS U \n\t\t\tON R.created_by= U.user_id \n\t\t\tWHERE refund_id = '{$_GET['refund_id']}' \n\t\t\tAND (status='ACCOUNTING APPROVAL') \n\t\t\tAND assigned_to='{$_SESSION['userid']}' LIMIT " . $_SESSION['initialOffset'] . "," . $_SESSION['RowsPerPage']; } else { $query = "SELECT NG_enc_id, U.first_name, U.last_name, dt_request, status, dt_required, payable, \n\t\t\taddr_ln_1, addr_ln_2, city, state, zip, purpose, amount, status, comments, assigned_to,created_by,check_date,check_nbr \n\t\t\tFROM refund AS R INNER JOIN users AS U ON R.created_by= U.user_id WHERE refund_id = '{$_POST['refund_id']}' \n\t\t\tAND (status='ACCOUNTING APPROVAL') \n\t\t\tAND assigned_to='{$_SESSION['userid']}' LIMIT " . $_SESSION['initialOffset'] . "," . $_SESSION['RowsPerPage']; } } elseif ($dept_rowName['name'] == "Billing") { if (isset($_GET['refund_id'])) { $query = "SELECT NG_enc_id, U.first_name, U.last_name, dt_request, status, dt_required, payable, \n\t\t\taddr_ln_1, addr_ln_2, city, state, zip, purpose, amount, status, comments, assigned_to,created_by,check_date,check_nbr \n\t\t\tFROM refund AS R \n\t\t\tINNER JOIN users AS U \n\t\t\tON R.created_by= U.user_id \n\t\t\tWHERE refund_id = '{$_GET['refund_id']}' \n\t\t\tAND assigned_to='{$_SESSION['userid']}' LIMIT " . $_SESSION['initialOffset'] . "," . $_SESSION['RowsPerPage']; } else { $query = "SELECT NG_enc_id, U.first_name, U.last_name, dt_request, status, dt_required, payable, \n\t\t\taddr_ln_1, addr_ln_2, city, state, zip, purpose, amount, status, comments, assigned_to,created_by,check_date,check_nbr \n\t\t\tFROM refund AS R INNER JOIN users AS U ON R.created_by= U.user_id \n\t\t\tWHERE refund_id = '{$_POST['refund_id']}' \n\t\t\tAND assigned_to='{$_SESSION['userid']}' LIMIT " . $_SESSION['initialOffset'] . "," . $_SESSION['RowsPerPage']; } } if (!isset($_SESSION['order'])) { if ($dept_rowName['name'] == "Accounting") { $query = "SELECT NG_enc_id, U.first_name, U.last_name, dt_request,amount, status,refund_id, payable,assigned_to \n\t\t\t\t\tFROM refund AS R \n\t\t\t\t\tINNER JOIN \n\t\t\t\t\tusers AS U \n\t\t\t\t\tON R.created_by = U.user_id \n\t\t\t\t\tWHERE status !='deleted' AND status !='VOIDED' AND (status='ACCOUNTING APPROVAL') AND assigned_to='{$_SESSION['userid']}' \n\t\t\t\t\tORDER BY dt_request,U.last_name,status LIMIT " . $_SESSION['initialOffset'] . "," . $_SESSION['RowsPerPage']; } elseif ($dept_rowName['name'] == "Billing") { $query = "SELECT NG_enc_id, U.first_name, U.last_name, dt_request,amount, status,refund_id, payable,assigned_to \n\t\t\t\t\tFROM refund AS R \n\t\t\t\t\tINNER JOIN \n\t\t\t\t\tusers AS U \n\t\t\t\t\tON R.created_by = U.user_id \n\t\t\t\t\tWHERE status !='deleted' AND status !='VOIDED' AND (status='ACCOUNTING APPROVED' OR status='NEW') assigned_to='{$_SESSION['userid']}' \n\t\t\t\t\tORDER BY dt_request,U.last_name,status AND LIMIT " . $_SESSION['initialOffset'] . "," . $_SESSION['RowsPerPage']; } } else { if ($dept_rowName['name'] == "Accounting") { $query = "SELECT NG_enc_id, U.first_name, U.last_name, dt_request,amount, status,refund_id, payable,assigned_to \n\t\t\t\t\tFROM refund AS R \n\t\t\t\t\tINNER JOIN \n\t\t\t\t\tusers AS U \n\t\t\t\t\tON R.created_by = U.user_id \n\t\t\t\t\tWHERE status !='deleted' AND status !='VOIDED' AND (status='ACCOUNTING APPROVAL') AND assigned_to='{$_SESSION['userid']}' \n\t\t\t\t\tORDER BY " . $_SESSION['order'] . " LIMIT " . $_SESSION['initialOffset'] . "," . $_SESSION['RowsPerPage']; } elseif ($dept_rowName['name'] == "Billing") { $query = "SELECT NG_enc_id, U.first_name, U.last_name, dt_request,amount, status,refund_id, payable,assigned_to \n\t\t\t\t\tFROM refund AS R \n\t\t\t\t\tINNER JOIN \n\t\t\t\t\tusers AS U \n\t\t\t\t\tON R.created_by = U.user_id \n\t\t\t\t\tWHERE status !='deleted' AND status !='VOIDED' AND (status='ACCOUNTING APPROVED' OR status='NEW') AND assigned_to='{$_SESSION['userid']}' \n\t\t\t\t\tORDER BY " . $_SESSION['order'] . " LIMIT " . $_SESSION['initialOffset'] . "," . $_SESSION['RowsPerPage']; } } } else { //else access levels if (!isset($_SESSION['order'])) { if ($dept_rowName['name'] == "Accounting") { $query = "SELECT NG_enc_id, U.first_name, U.last_name, dt_request,amount, status,refund_id, payable,assigned_to,\n\t\t\t\t\taccounting_approval,billing_initial_approval,billing_final_approval,urgent \n\t\t\t\t\tFROM refund AS R \n\t\t\t\t\tINNER JOIN \n\t\t\t\t\tusers AS U \n\t\t\t\t\tON R.created_by = U.user_id \n\t\t\t\t\tWHERE status !='deleted' AND status !='VOIDED' AND (status='ACCOUNTING APPROVAL') AND assigned_to='{$_SESSION['userid']}' \n\t\t\t\t\tORDER BY dt_request,U.last_name,status LIMIT " . $_SESSION['initialOffset'] . "," . $_SESSION['RowsPerPage']; } elseif ($dept_rowName['name'] == "Billing") { $query = "SELECT NG_enc_id, U.first_name, U.last_name, dt_request,amount, status,refund_id, payable,assigned_to,\n\t\t\t\t\taccounting_approval,billing_initial_approval,billing_final_approval,urgent \n\t\t\t\t\tFROM refund AS R \n\t\t\t\t\tINNER JOIN \n\t\t\t\t\tusers AS U \n\t\t\t\t\tON R.created_by = U.user_id \n\t\t\t\t\tWHERE status !='deleted' AND status !='VOIDED' AND (status='ACCOUNTING APPROVED' OR status='NEW') AND assigned_to='{$_SESSION['userid']}' \n\t\t\t\t\tORDER BY dt_request,U.last_name,status LIMIT " . $_SESSION['initialOffset'] . "," . $_SESSION['RowsPerPage']; } } else { if ($dept_rowName['name'] == "Accounting") { $query = "SELECT NG_enc_id, U.first_name, U.last_name, dt_request,amount, status,refund_id, payable,assigned_to,\n\t\t\t\t\taccounting_approval,billing_initial_approval,billing_final_approval,urgent \t\t\t\n\t\t\t\t\tFROM refund AS R \n\t\t\t\t\tINNER JOIN \n\t\t\t\t\tusers AS U \n\t\t\t\t\tON R.created_by = U.user_id \n\t\t\t\t\tWHERE status !='deleted' AND status !='VOIDED' AND (status='ACCOUNTING APPROVAL') AND assigned_to='{$_SESSION['userid']}' \n\t\t\t\t\tORDER BY " . $_SESSION['order'] . " LIMIT " . $_SESSION['initialOffset'] . "," . $_SESSION['RowsPerPage']; } elseif ($dept_rowName['name'] == "Billing") { $query = "SELECT NG_enc_id, U.first_name, U.last_name, dt_request,amount, status,refund_id, payable,assigned_to,\n\t\t\t\t\taccounting_approval,billing_initial_approval,billing_final_approval,urgent \n\t\t\t\t\tFROM refund AS R \n\t\t\t\t\tINNER JOIN \n\t\t\t\t\tusers AS U \n\t\t\t\t\tON R.created_by = U.user_id \n\t\t\t\t\tWHERE status !='deleted' AND status !='VOIDED' and (status='ACCOUNTING APPROVED' OR status='NEW') AND assigned_to='{$_SESSION['userid']}' \n\t\t\t\t\tORDER BY dt_request,U.last_name,status LIMIT " . $_SESSION['initialOffset'] . "," . $_SESSION['RowsPerPage']; } } } echo 'new query <br>'; echo $query; echo '<br>'; $result = mysqli_query($db, $query); $arrayRefundUsers = array(); $queryUserIDs = "SELECT user_id, first_name, last_name FROM users"; $resultUserIDs = mysqli_query($db, $queryUserIDs); $ctr = 0; while ($row = mysqli_fetch_array($resultUserIDs)) { $arrayRefundUsers[$row['user_id']] = $row['first_name'] . ' ' . $row['last_name']; } $row = mysqli_fetch_array($result); print '<br /><br /><div align = "center"><b><h2>Assigned Refunds </h2></b>'; if (sizeof($row)) { ///////HEADINGS FROM THE REFUNDS PAGE////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// print '<div align = "center"><p>Refund Requests Currently Assigned to you: </p><br>'; print '<table border="1" cellpadding = "3"> <tr> <td><center><b><a href=' . $_SERVER['PHP_SELF'] . '?encounter_num=y>Encounter Number</a></b></center></td> <td><center><b><a href=' . $_SERVER['PHP_SELF'] . '?refund_id=y>Refund ID</a></b></center></td> <td><center><b><a href=' . $_SERVER['PHP_SELF'] . '?encounter_date=y>Date Requested</a></b></center></td> <td><center><b><a href=' . $_SERVER['PHP_SELF'] . '?urgent=y>Urgent</a></b></center></td> <td><center><b><a href=' . $_SERVER['PHP_SELF'] . '?requested_by=y>Requested By</a></b></center></td> <td><center><b><a href=' . $_SERVER['PHP_SELF'] . '?payable_order=y>Payable To</a></b></center></td> <td><center><b><a href=' . $_SERVER['PHP_SELF'] . '?amount_order=y>Amount</a></b></center></td> <td><center><b><a href=' . $_SERVER['PHP_SELF'] . '?status_order=y>Status</a></b></center></td> <td><center><b><a href=' . $_SERVER['PHP_SELF'] . '?status_order=y>Assigned To</a></b></center></td>'; ///////END HEADINGS FROM THE REFUNDS PAGE////////////////////?//////////////////////////////////////////////////////////////////////////////////////////////////////// /* <td><b><center>Actions</center></b></td> */ $result_display_ctr = 0; $current_date = date("Y-m-d H:i:s"); $result = mysqli_query($db, $query); while ($row = mysqli_fetch_array($result)) { $today_dt = $entered_dt = $interval = $refund_requested_by = $date_requested = $refund_assigned_to = $interval = ""; calculateInterval($row, $refund_requested_by, $date_requested, $today_dt, $entered_dt, $interval, $refund_assigned_to); $refund_assigned_to = ""; $queryUserIDs = "SELECT first_name, last_name FROM users WHERE user_id= '{$row['assigned_to']}'"; $resultUserIDs = mysqli_query($db, $queryUserIDs); while ($rowUserIds = mysqli_fetch_array($resultUserIDs)) { //build up the assigned to username $refund_assigned_to = $rowUserIds['first_name'] . ' ' . $rowUserIds['last_name']; } if ($result_display_ctr < $_SESSION['RowsPerPage']) { $result_display_ctr++; if ($row['urgent']) { print '<tr bgcolor=#EE0000 height=50>'; } elseif ($interval->days > 30 && $row['status'] != "COMPLETED") { print '<tr bgcolor=#FF69B4>'; } elseif ($interval->days >= 15 && $interval->days < 30 && $row['status'] != "COMPLETED") { print '<tr bgcolor=yellow>'; } elseif ($interval->days <= 1 && $row['status'] != "COMPLETED") { print '<tr bgcolor=#00BB00>'; } else { print '<tr>'; } //print '<tr> print '<td><a href="' . $_SERVER['PHP_SELF'] . '?refund_id=' . $row['refund_id'] . '&action=edit">' . $row['NG_enc_id'] . '</a></td> <td><a href="' . $_SERVER['PHP_SELF'] . '?refund_id=' . $row['refund_id'] . '&action=edit">' . $row['refund_id'] . '</a></td> <td>' . $row['dt_request'] . '</td> <td>' . ($row['urgent'] ? 'Yes' : 'No') . '</td> <td>' . $row['first_name'] . ' ' . $row['last_name'] . '</td> <td>' . $row['payable'] . '</td>'; print '<td>$ ' . $row['amount'] . '</td>'; if (!$row['accounting_approval'] && !$row['billing_initial_approval'] && !$row['billing_final_approval']) { print '<td>NEW</td>'; } elseif (!$row['accounting_approval'] && $row['billing_initial_approval']) { print '<td>ACCOUNTING APPROVAL</td>'; } elseif ($row['accounting_approval'] && $row['billing_initial_approval'] && !$row['billing_final_approval']) { print '<td>ACCOUNTING APPROVED</td>'; } elseif ($row['accounting_approval'] && $row['billing_initial_approval'] && $row['billing_final_approval']) { print '<td>ACCOUNTING VERIFIED</td>'; } elseif ($row['status'] == "REJECTED") { print '<td>REJECTED</td>'; } elseif ($row['status'] == "VOIDED") { print '<td>VOIDED</td>'; } print '<td>' . $refund_assigned_to . '</td>'; print '</td></tr>'; } instantiate_page_variables($row, $tempOrigStartPosition, $page, $URL_String_BACK, $URL_String_FORWARD); } print '</table></div>'; if (sizeof($row) > $_SESSION['RowsPerPage']) { //only conditionally display the pagination displayPagination($row, $tempOrigStartPosition, $URL_String_BACK, $URL_String_FORWARD); } } else { //end if they have refunds echo '<br><br>'; echo '<center><b> You currently have no refunds assigned to you! </b></center>'; } showFooter(); }
print '<td>COMPLETED</td>'; } elseif ($row['status'] == "REJECTED") { print '<td>REJECTED</td>'; } elseif ($row['status'] == "VOIDED") { print '<td>VOIDED</td>'; } elseif ($row['accounting_approval'] && !$row['billing_initial_approval'] && !$row['billing_final_approval']) { print '<td>ACCOUNTING APPROVED</td>'; } print '<td>' . $refund_assigned_to . '</td>'; print '</td></tr>'; } instantiate_page_variables($row, $tempOrigStartPosition, $page, $URL_String_BACK, $URL_String_FORWARD); } if ($currentRowSize > $_SESSION['RowsPerPage']) { //only conditionally display the pagination displayPagination($row, $tempOrigStartPosition, $URL_String_BACK, $URL_String_FORWARD); } } elseif (array_key_exists('userid', $_SESSION)) { //If user is logged in show page if (isset($_POST['_search_submit']) && $_POST['_search_submit'] != "" && $_POST['_search_submit'] != NULL) { showSearchPage($_SESSION['username'], $_SESSION['access']); $userIDSearched = ""; if (isset($_POST['refund_search_term']) && strpos($_POST['refund_search_term'], '_by')) { echo '<center> Please further specify by selecting a name from the drop down below: </center>'; echo '<br>'; $query_users = 'SELECT user_id, first_name, last_name FROM users'; $result_users = mysqli_query($db, $query_users); print <<<EDITUSERPAGE <center><h2 align="center">Search Refunds</h2> <a href="reports.php">Back to Refunds</a> <br/><br/>
/** * displayPages * * @param int $page * @param int $thread_id * * @return void */ function displayPages($page = 1, $thread_id = 0) { $thread_id = (int) $thread_id; if ($thread_id < 1) { $sql = "SELECT count(`id`) AS c \n FROM `fcms_board_threads`"; $row = $this->fcmsDatabase->getRow($sql); if ($row === false) { $this->fcmsError->displayError(); return; } $total_pages = ceil($row['c'] / 25); $url = 'messageboard.php'; } else { $sql = "SELECT count(`id`) AS c \n FROM `fcms_board_posts` \n WHERE `thread` = ?"; $row = $this->fcmsDatabase->getRow($sql, $thread_id); if ($row === false) { $this->fcmsError->displayError(); return; } $total_pages = ceil($row['c'] / 15); $url = 'messageboard.php?thread=' . $thread_id; } displayPagination($url, $page, $total_pages); }
<div class="listing-content"> <h3><?php echo $listing["company_name"]; ?> </h3> </div> </a> <?php } ?> </div> </div> <?php displayPagination($locationId, $sectionId, $categoryId, $pagination); ?> </div> </section> <section class="blog-preview"> <div class="wc cf"> <h1><?php _e('KÄLLABABY BLOG', 'kb'); ?> </h1> <p class="mini-desc"><?php _e('Read about what’s new and what’s hot', 'kb'); ?> </p>
/** * displayUserFamilyNews * * Prints the listing of family news for a given user. * * @param int $user * @param int $page * * @return void */ function displayUserFamilyNews($user, $page = 1) { $user = (int) $user; $from = $page * 5 - 5; // Get family news $sql = "SELECT n.`id`, n.`user`, n.`title`, n.`news`, n.`updated`, n.`created`, \n n.`external_type`, n.`external_id`\n FROM `fcms_news` AS n, `fcms_users` AS u\n WHERE n.`user` = ? \n AND n.`user` = u.`id` \n ORDER BY `updated` DESC \n LIMIT {$from}, 5"; $rows = $this->fcmsDatabase->getRows($sql, $user); if ($rows === false) { $this->fcmsError->displayError(); return; } if (count($rows) <= 0) { echo ' <div class="blank-state"> <h2>' . T_('Nothing to see here') . '</h2> <h3>' . T_('Currently no one has added any news') . '</h3> <h3>' . T_('Why don\'t you be the first to add news?') . '</a></h3> <ol> <li><a href="?addnews=yes">' . T_('Add Family News') . '</a></li> <li><a href="settings.php?view=familynews">' . T_('Import News from existing blog') . '</a></li> </ol> </div>'; return; } foreach ($rows as $row) { $this->displayNews($row); } // Display Pagination $sql = "SELECT COUNT(`id`) AS c \n FROM `fcms_news` \n WHERE `user` = ?"; $row = $this->fcmsDatabase->getRow($sql, $user); if ($row === false) { $this->fcmsError->displayError(); return; } $newscount = $row['c']; $total_pages = ceil($newscount / 5); displayPagination('familynews.php?getnews=' . $user, $page, $total_pages); }
$res .= "<tr>"; $res .= "<td colspan='9'><img src='images/warning.png'> "; if (trim($rs["crawl_status_message"]) != "") { $res .= "Last crawl status : " . $rs["crawl_status"] . " ("; $res .= wordwrap($rs["crawl_status_message"], 100, "\n", true) . ")"; } else { $res .= "Only one crawled page ! Check source settings (starting url, host and host aliases)"; } $res .= "<br>[<a href='log.php?id=" . $rs["id"] . "' title='Log' target='log'>See log file</a>]"; $res .= "</td>"; $res .= "</tr>"; } } $res .= "</table></center>"; if ($onepage != "1") { $res .= "<br /><center>" . displayPagination($RowCount, $sources_page_size, $start, $page) . "</center>"; } print $res; exit; } } if ($action == "displaysource") { $id = $_GET["id"]; if ($id == "") { print ""; exit; } $mg = mg_connect($config, "", "", ""); if ($mg) { $stmt = new mg_stmt_select($mg, "sources"); $query = array("id" => intval($id));
$response_elevate = $solr->elevate(preg_replace('/\\s+/', ' ', $q), $params); // use the original user query not updated query /* if ($response_elevate->getHttpStatus()==200) { $hits_elevate = $response_elevate->response->numFound; } */ $response = $solr->search($query, ($page - 1) * $item_per_page, $item_per_page, $params); if ($response->getHttpStatus() == 200) { $hits = $response->response->numFound; echo '<hr>'; echo 'Hits: ' . $hits; echo '<hr>'; if ($hits > 0) { // Display pagination echo displayPagination($hits, $item_per_page, $page, $fqstr) . '<br /><br />'; $res = ''; // Display elevated documents $elevated_ids = array(); if ($page == 1) { $teasers = get_object_vars($response_elevate->highlighting); foreach ($response_elevate->response->docs as $doc) { $elevated_ids[] = $doc->id; $res .= displayResultItem($doc, $teasers); } } // Display results list $teasers = get_object_vars($response->highlighting); foreach ($response->response->docs as $doc) { if (count($elevated_ids) > 0 && in_array($doc->id, $elevated_ids)) { continue;
/** * displayPages * * Function renamed in 2.0, needs to stay until old calls are updated. * * @deprecated deprecated since version 2.0 */ function displayPages($url, $cur_page, $total_pages) { displayPagination($url, $cur_page, $total_pages); }
/** * displayPrayers * * @return void */ function displayPrayers() { $this->displayHeader(array('jsOnload' => ' $(\'.delform input[type="submit"]\').click(function(e) { return confirmDeleteLink(this, "' . T_('Are you sure you want to DELETE this?') . '", e); });')); if (isset($_SESSION['success'])) { displayOkMessage(); unset($_SESSION['success']); } if (isset($_SESSION['delete_success'])) { displayOkMessage(T_('Prayer Concern Deleted Successfully')); unset($_SESSION['delete_success']); } if ($this->fcmsUser->access <= 5) { echo ' <div id="actions_menu"> <ul><li><a class="action" href="?addconcern=yes">' . T_('Add a Prayer Concern') . '</a></li></ul> </div>'; } $page = getPage(); $from = $page * 5 - 5; $sql = "SELECT p.`id`, `for`, `desc`, `user`, `date` \n FROM `fcms_prayers` AS p, `fcms_users` AS u \n WHERE u.`id` = p.`user` \n ORDER BY `date` DESC \n LIMIT {$from}, 5"; $rows = $this->fcmsDatabase->getRows($sql); if ($rows === false) { $this->fcmsError->displayError(); $this->displayFooter(); return; } if (count($rows) <= 0) { echo ' <div class="blank-state"> <h2>' . T_('Nothing to see here') . '</h2> <h3>' . T_('Currently no one has added any Prayer Concerns.') . '</h3> <h3><a href="?addconcern=yes">' . T_('Why don\'t you add a new Prayer Concern now?') . '</a></h3> </div>'; $this->displayFooter(); return; } foreach ($rows as $r) { $date = fixDate(T_('F j, Y, g:i a'), $this->fcmsUser->tzOffset, $r['date']); $displayname = getUserDisplayName($r['user']); echo ' <hr/> <h4>' . $date . '</h4> <div class="edit_delete">'; // Edit if ($this->fcmsUser->id == $r['user'] || $this->fcmsUser->access < 2) { echo ' <form method="post" action="prayers.php"> <input type="hidden" name="id" value="' . (int) $r['id'] . '"/> <input type="hidden" name="for" value="' . cleanOutput($r['for']) . '"/> <input type="hidden" name="desc" value="' . cleanOutput($r['desc']) . '"/> <input type="submit" name="editprayer" value="' . T_('Edit') . '" class="editbtn" title="' . T_('Edit this Prayer Concern') . '"/> </form>'; } // Delete if ($this->fcmsUser->access < 2) { echo ' <form class="delform" method="post" action="prayers.php"> <input type="hidden" name="id" value="' . (int) $r['id'] . '"/> <input type="submit" name="delprayer" value="' . T_('Delete') . '" class="delbtn" title="' . T_('Delete this Prayer Concern') . '"/> </form>'; } echo ' </div> <div class="for"> <b>' . sprintf(T_('%s asks that you please pray for...'), '<a href="profile.php?member=' . (int) $r['user'] . '">' . $displayname . '</a>') . '</b> <div>' . cleanOutput($r['for']) . '</div> </div> <div class="because"> <b>' . T_('Because...') . '</b> <div>' . parse($r['desc']) . '</div> </div> <div class="top"><a href="#top">' . T_('Back to Top') . '</a></div>'; } // Display Pagination $sql = "SELECT count(`id`) AS c \n FROM `fcms_prayers`"; $r = $this->fcmsDatabase->getRow($sql); if ($r === false) { $this->fcmsError->displayError(); $this->displayFooter(); return; } $prayercount = (int) $r['c']; $total_pages = ceil($prayercount / 5); displayPagination('prayers.php', $page, $total_pages); $this->displayFooter(); }
/** * showRecipeInCategory * * Displays up to 5 recipes for the given category and page. * * @param int $cat * @param int $page * @return void */ function showRecipeInCategory($cat, $page = 1) { $cat = (int) $cat; $page = (int) $page; $from = $page * 5 - 5; // Display Menu echo ' <div id="sections_menu"> <ul> <li><a href="recipes.php">' . T_('Recipe Categories') . '</a></li>'; if ($this->fcmsUser->access <= 5) { echo ' </ul> </div> <div id="actions_menu"> <ul> <li><a href="?addrecipe=yes&cat=' . $cat . '">' . T_('Add Recipe') . '</a></li>'; } echo ' </ul> </div>'; // Show Category Side Menu $this->showCategoryMenu(); echo ' <div id="maincolumn">'; // Get Recipes for this category $sql = "SELECT r.`id`, r.`name`, r.`category`, r.`thumbnail`, c.`name` AS category_name, r.`user`, r.`date`\n FROM `fcms_recipes` AS r, `fcms_category` AS c\n WHERE `category` = ?\n AND r.`category` = c.`id` \n ORDER BY `date` DESC \n LIMIT {$from}, 5"; $rows = $this->fcmsDatabase->getRows($sql, $cat); if ($rows === false) { $this->fcmsError->displayError(); return; } $categoryName = ''; // Display Recipes if (count($rows) > 0) { $displayed_category = false; $path = 'uploads/upimages/'; if (defined('UPLOADS')) { $path = 'file.php?u='; } foreach ($rows as $r) { // Category if (!$displayed_category) { $displayed_category = true; $categoryName = cleanOutput($r['category_name']); echo ' <h2>' . $categoryName . '</h2> <ul id="recipe-list">'; } $since = getHumanTimeSince(strtotime($r['date'])); echo ' <li> <a href="?category=' . $cat . '&id=' . (int) $r['id'] . '"> <span>' . T_('Click to view recipe') . '</span> <img src="' . URL_PREFIX . $path . basename($r['thumbnail']) . '"/> <b>' . cleanOutput($r['name']) . '</b> <i>' . $since . '</i> </a> </li>'; } echo ' </ul>'; // Display Pagination $sql = "SELECT count(`id`) AS c \n FROM `fcms_recipes` \n WHERE `category` = ?"; $r = $this->fcmsDatabase->getRow($sql, $cat); if ($r === false) { $this->fcmsError->displayError(); return; } $recipecount = $r['c']; $total_pages = ceil($recipecount / 5); displayPagination('recipes.php?category=' . $cat, $page, $total_pages); // No recipes for this category } else { echo ' <div class="info-alert"> <h2>' . $categoryName . '</h2> <p><i>' . T_('Currently no one has added any recipes to this category.') . '</i></p> <p><a href="?addrecipe=yes&cat=' . $cat . '">' . T_('Add a Recipe') . '</a></p> </div>'; } echo ' </div>'; }