PHP Pagination::showPager方法代码示例

$data['province'] = Info::getProvince(false);
$data['complaintType'] = Info::getComplaintType('complaint_type', false);
$data['questionType'][1] = Info::getQuestionType(1, 'question_type', true);
$data['questionType'][2] = Info::getQuestionType(2, 'question_type', true);
$data['questionType'][3] = Info::getQuestionType(3, 'question_type', true);
$data['complaintLevel'] = Info::getComplaintLevel('complaint_level', false);
$data['bussLine'] = Info::getBussLine('buss_type', false);
// var_dump($data['bussLine']);
//导出excel下载
if ($_GET['download'] == 1) {
    $downloadStr = array_to_string($data);
    //var_dump($data);exit;
    Common::exportExcel($downloadStr, 'black_list');
    exit;
}
$page_html = Pagination::showPager("sp_analyze.php?" . $http_query, $page_no, PAGE_SIZE, $row_count);
$export_excel = "sp_analyze.php?download=1&" . $http_query;
// $page_html=Pagination::showPager("sp_analyze.php?class_name=$class_name&user_name=$user_name&start_date=$start_date&end_date=$end_date",$page_no,PAGE_SIZE,$row_count);
// $export_excel="sp_analyze.php?download=1&class_name=$class_name&user_name=$user_name&start_date=$start_date&end_date=$end_date";
Template::assign("error", $error);
Template::assign("_POST", $_POST);
Template::assign('_GET', $_GET);
Template::assign("data", $data);
Template::assign("param", $param);
Template::assign('page_html', $page_html);
Template::assign('export_excel', $export_excel);
// Template::assign("output" ,$output);
Template::display('complaint/sp_analyze.tpl');
//列表数据转化为字符串
function array_to_string($data)
{

$data['province'] = Info::getProvince(false);
$data['complaintType'] = Info::getComplaintType('complaint_type', false);
$data['questionType'][1] = Info::getQuestionType(1, 'question_type', true);
$data['questionType'][2] = Info::getQuestionType(2, 'question_type', true);
$data['questionType'][3] = Info::getQuestionType(3, 'question_type', true);
$data['complaintLevel'] = Info::getComplaintLevel('complaint_level', false);
$data['bussLine'] = Info::getBussLine('buss_type', false);
// var_dump($data['bussLine']);
//导出excel下载
if ($_GET['download'] == 1) {
    $downloadStr = array_to_string($data);
    //var_dump($data);exit;
    Common::exportExcel($downloadStr, 'black_list');
    exit;
}
$page_html = Pagination::showPager("custom_analyze.php?class_name={$class_name}&user_name={$user_name}&start_date={$start_date}&end_date={$end_date}", $page_no, PAGE_SIZE, $row_count);
$export_excel = "custom_analyze.php?download=1&class_name={$class_name}&user_name={$user_name}&start_date={$start_date}&end_date={$end_date}";
Template::assign("error", $error);
Template::assign("_POST", $_POST);
Template::assign('_GET', $_GET);
Template::assign("data", $data);
Template::assign("param", $param);
Template::assign('page_html', $page_html);
Template::assign('export_excel', $export_excel);
// Template::assign("output" ,$output);
Template::display('complaint/complaints_analyze.tpl');
//列表数据转化为字符串
function array_to_string($data)
{
    if (empty($data) || !isset($data['result']) || empty($data['result'])) {
        $dataStr = "没有符合您要求的数据！^_^";

$data['buss_class'] = Info::getProductType();
$data['province'] = Info::getProvince(false);
$data['complaintType'] = Info::getComplaintType('complaint_type', false);
$data['questionType'][1] = Info::getQuestionType(1, 'question_type', true);
$data['questionType'][2] = Info::getQuestionType(2, 'question_type', true);
$data['questionType'][3] = Info::getQuestionType(3, 'question_type', true);
$data['complaintLevel'] = Info::getComplaintLevel('complaint_level', false);
$data['bussType'] = Info::getBussLine('buss_type', true);
//导出excel下载
if ($_GET['download'] == 1) {
    $downloadStr = array_to_string($data);
    //var_dump($data);exit;
    Common::exportExcel($downloadStr, 'black_list');
    exit;
}
$page_html = Pagination::showPager("complaints_search.php?" . $http_query, $page_no, PAGE_SIZE, $row_count);
// $page_html=Pagination::showPager("complaints_search.php?class_name=$class_name&user_name=$user_name&start_date=$start_date&end_date=$end_date&case_id=$case_id&complaint_time=$complaint_time&dispute_phone=$dispute_phone&sp_corp_name=$sp_corp_name",$page_no,PAGE_SIZE,$row_count);
$export_excel = "complaints_search.php?download=1&" . $http_query;
Template::assign("error", $error);
Template::assign("_POST", $_POST);
Template::assign('_GET', $_GET);
Template::assign("data", $data);
Template::assign("param", $param);
Template::assign('page_html', $page_html);
Template::assign('export_excel', $export_excel);
// Template::assign("output" ,$output);
Template::display('complaint/complaints_search.tpl');
//列表数据转化为字符串
function array_to_string($data)
{
    if (empty($data) || !isset($data['result']) || empty($data['result'])) {

$page_no = $page_no < 1 ? 1 : $page_no;
if ($search) {
    $row_count = User::countSearch($user_group, $user_name) - 1;
    $total_page = $row_count % $page_size == 0 ? $row_count / $page_size : ceil($row_count / $page_size);
    $total_page = $total_page < 1 ? 1 : $total_page;
    $page_no = $page_no > $total_page ? $total_page : $page_no;
    $start = ($page_no - 1) * $page_size;
    $user_infos = User::search($user_group, $user_name, $start, $page_size);
} else {
    $row_count = User::count() - 1;
    $total_page = $row_count % $page_size == 0 ? $row_count / $page_size : ceil($row_count / $page_size);
    $total_page = $total_page < 1 ? 1 : $total_page;
    $page_no = $page_no > $total_page ? $total_page : $page_no;
    $start = ($page_no - 1) * $page_size;
    $user_infos = User::getAllUsers($start, $page_size);
    array_pop($user_infos);
}
$page_html = Pagination::showPager("user.php?user_group={$user_group}&user_name={$user_name}&search={$search}", $page_no, $page_size, $row_count);
//追加操作的确认层
$confirm_html = OSAdmin::renderJsConfirm("icon-pause,icon-play,icon-remove");
// 设置模板变量
$group_options = UserGroup::getGroupForOptions();
$group_options[0] = "全部";
ksort($group_options);
Template::assign('group_options', $group_options);
Template::assign('user_infos', $user_infos);
Template::assign('_GET', $_GET);
Template::assign('page_no', $page_no);
Template::assign('page_html', $page_html);
Template::assign('osadmin_action_confirm', $confirm_html);
Template::display('complaint/user.tpl');

        exit($res);
    }
} else {
    $topNMail = array();
    //邮箱地址
    $return = MailStatistics::getRecTopNMailCount($start_date, $end_date, $mail);
    $row_count = $return[0]['NUM'];
    //导出功能
    if ($command == 'export') {
        $header = array('MAIL_TO' => '接收邮件域名', 'MAIL_FROM_NUM' => '发送邮件用户数', 'MAIL_USER' => '接收邮件用户数', 'NUM' => '接收邮件数', 'PERC' => '邮件数占比(%)');
        $data = MailStatistics::getRecTopNMail($start_date, $end_date, $mail, 0, $row_count);
        $csv = new LibExportCsv($header, $data);
        $csv->export();
        exit;
    }
    $page_size = 10;
    $page_no = $page_no < 1 ? 1 : $page_no;
    $total_page = $row_count % $page_size == 0 ? $row_count / $page_size : ceil($row_count / $page_size);
    $total_page = $total_page < 1 ? 1 : $total_page;
    $page_no = $page_no > $total_page ? $total_page : $page_no;
    $start = ($page_no - 1) * $page_size;
    $topNMail = MailStatistics::getRecTopNMail($start_date, $end_date, $mail, $start, $page_size);
    foreach ($topNMail as &$item) {
        $item['PERC'] = floatval($item['PERC']);
    }
    $page_html = Pagination::showPager("recTopNMail.php?start_date={$start_date}&end_date={$end_date}", $page_no, 10, $row_count);
    Template::assign('topNMail', $topNMail);
    Template::assign('page_html', $page_html);
    Template::assign('_GET', $_GET);
    Template::display('netshow/mail/recTopNMail.tpl');
}

$_GET['game'] = empty($_GET['game']) ? 1 : intval($_GET['game']);
$_GET['start_date'] = empty($_GET['start_date']) ? date("Y-m-d", time() - 86400) : $_GET['start_date'];
$_GET['end_date'] = empty($_GET['end_date']) ? date("Y-m-d", time()) : $_GET['end_date'];
extract($_GET, EXTR_IF_EXISTS);
//START 数据库查询及分页数据
if ($start_date != '' && $end_date != '') {
    $return = NetMonitor::getSmallRatioCount($start_date, $end_date, $top, $game);
    $row_count = $return[0]['NUM'];
}
$page_size = PAGE_SIZE;
$page_no = intval($page_no);
$page_no = $page_no < 1 ? 1 : $page_no;
$total_page = $row_count % $page_size == 0 ? $row_count / $page_size : ceil($row_count / $page_size);
$total_page = $total_page < 1 ? 1 : $total_page;
$page_no = $page_no > $total_page ? $total_page : $page_no;
$start = ($page_no - 1) * $page_size;
//END
//$sys_logs = SysLog::getLogs($class_name,$user_name, $start,$page_size,$start_time,$end_time );
$sys_logs = NetMonitor::getSmallRatio($start_date, $end_date, $top, $start, $page_size, $game);
foreach ($sys_logs as &$item) {
    $item['USER_NUM'] = number_format($item['USER_NUM']);
}
// 显示分页栏
$page_html = Pagination::showPager("smallRatio.php?top={$top}&start_date={$start_date}&end_date={$end_date}&game={$game}", $page_no, PAGE_SIZE, $row_count);
Template::assign('page_no', $page_no);
Template::assign('page_size', PAGE_SIZE);
Template::assign('row_count', $row_count);
Template::assign('page_html', $page_html);
Template::assign('_GET', $_GET);
Template::assign('sys_logs', $sys_logs);
Template::display('netshow/smallRatio.tpl');

$data['province'] = Info::getProvince(false);
$data['complaintType'] = Info::getComplaintType('complaint_type', false);
$data['questionType'][1] = Info::getQuestionType(1, 'question_type', true);
$data['questionType'][2] = Info::getQuestionType(2, 'question_type', true);
$data['questionType'][3] = Info::getQuestionType(3, 'question_type', true);
$data['complaintLevel'] = Info::getComplaintLevel('complaint_level', false);
$data['bussLine'] = Info::getBussLine('buss_type', false);
// var_dump($data['bussLine']);
//导出excel下载
if ($_GET['download'] == 1) {
    $downloadStr = array_to_string($data);
    //var_dump($data);exit;
    Common::exportExcel($downloadStr, 'black_list');
    exit;
}
$page_html = Pagination::showPager("black_list.php?" . $http_query, $page_no, PAGE_SIZE, $row_count);
$export_excel = "black_list.php?download=1&" . $http_query;
// $page_html=Pagination::showPager("black_list.php?class_name=$class_name&user_name=$user_name&start_date=$start_date&end_date=$end_date",$page_no,PAGE_SIZE,$row_count);
Template::assign("error", $error);
Template::assign("_POST", $_POST);
Template::assign('_GET', $_GET);
Template::assign("data", $data);
Template::assign("param", $param);
Template::assign('page_html', $page_html);
Template::assign('export_excel', $export_excel);
// Template::assign("output" ,$output);
Template::display('complaint/black_list.tpl');
//列表数据转化为字符串
function array_to_string($data)
{
    if (empty($data) || !isset($data['result']) || empty($data['result'])) {

 * 账号活跃度统计
 */
require '../../include/init.inc.php';
$page_no = $page_no1 = $start_date = $end_date = $command = "";
$_GET['start_date'] = empty($_GET['start_date']) ? date("Y-m-d", time() - 86400) : $_GET['start_date'];
$_GET['end_date'] = empty($_GET['end_date']) ? date("Y-m-d", time() + 86400) : $_GET['end_date'];
$_GET['command'] = empty($_GET['command']) ? '' : $_GET['command'];
extract($_GET, EXTR_IF_EXISTS);
$unActivityUser = array();
//非活跃用户
$return = MailStatistics::getAccountUnActivityCount($start_date, $end_date);
$row_count = $return[0]['NUM'];
if ($command == 'export') {
    $header = array('RN' => 'ID', 'MAIL_ACCOUNT' => 'Mail帐号', 'LOGIN_NUM' => '登录次数', 'SENT_NUM' => '发送次数', 'RCVD_NUM' => '接收次数', 'REJECT_NUM' => '拒绝次数');
    $data = MailStatistics::getAccountUnActivity($start_date, $end_date, 0, $row_count);
    $csv = new LibExportCsv($header, $data);
    $csv->export();
    exit;
}
$page_size = 15;
$page_no = $page_no < 1 ? 1 : $page_no;
$total_page = $row_count % $page_size == 0 ? $row_count / $page_size : ceil($row_count / $page_size);
$total_page = $total_page < 1 ? 1 : $total_page;
$page_no = $page_no > $total_page ? $total_page : $page_no;
$start = ($page_no - 1) * $page_size;
$unActivityUser = MailStatistics::getAccountUnActivity($start_date, $end_date, $start, $page_size);
$page_html = Pagination::showPager("accountUnActivity.php?start_date={$start_date}&end_date={$end_date}", $page_no, 15, $row_count);
Template::assign('unActivityUser', $unActivityUser);
Template::assign('page_html', $page_html);
Template::assign('_GET', $_GET);
Template::display('netshow/mail/accountUnActivity.tpl');

$_GET['start_date'] = empty($_GET['start_date']) ? date("Y-m-d", time() - 86400) : $_GET['start_date'];
$_GET['end_date'] = empty($_GET['end_date']) ? date("Y-m-d", time() + 86400) : $_GET['end_date'];
$_GET['ajaxMethod'] = empty($_GET['ajaxMethod']) ? '' : $_GET['ajaxMethod'];
extract($_GET, EXTR_IF_EXISTS);
if (isset($_SERVER["HTTP_X_REQUESTED_WITH"]) && strtolower($_SERVER["HTTP_X_REQUESTED_WITH"]) == "xmlhttprequest") {
} else {
    $mail = array();
    //邮箱地址
    $return = MailStatistics::getQQmailAccountNotExistCount($start_date, $end_date);
    $row_count = $return[0]['NUM'];
    //导出功能
    if ($command == 'export') {
        $header = array('MAIL_TO' => '接收的邮件地址', 'NUM' => '发送的次数', 'FIRST_TIME' => '首次发送日期', 'LAST_TIME' => '最后发送日期', 'REP_DATE' => '统计时间');
        $data = MailStatistics::getQQmailAccountNotExist($start_date, $end_date, 0, $row_count);
        $csv = new LibExportCsv($header, $data);
        $csv->export();
        exit;
    }
    $page_size = 10;
    $page_no = $page_no < 1 ? 1 : $page_no;
    $total_page = $row_count % $page_size == 0 ? $row_count / $page_size : ceil($row_count / $page_size);
    $total_page = $total_page < 1 ? 1 : $total_page;
    $page_no = $page_no > $total_page ? $total_page : $page_no;
    $start = ($page_no - 1) * $page_size;
    $mail = MailStatistics::getQQmailAccountNotExist($start_date, $end_date, $start, $page_size);
    $page_html = Pagination::showPager("qqMailAccountNotExist.php?start_date={$start_date}&end_date={$end_date}", $page_no, $page_size, $row_count);
    Template::assign('mail', $mail);
    Template::assign('page_html', $page_html);
    Template::assign('_GET', $_GET);
    Template::display('netshow/mail/qqMailAccountNotExist.tpl');
}

<?php

/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2015/7/13
 * Time: 16:29
 * 登录失败TOP账号
 */
require '../../include/init.inc.php';
$page_no = $start_date = $end_date = $top = "";
$_GET['start_date'] = empty($_GET['start_date']) ? date("Y-m-d", time() - 86400) : $_GET['start_date'];
$_GET['end_date'] = empty($_GET['end_date']) ? date("Y-m-d", time() + 86400) : $_GET['end_date'];
$_GET['top'] = empty($_GET['top']) ? 5 : intval($_GET['top']);
extract($_GET, EXTR_IF_EXISTS);
$topAccounts = array();
$return = MailStatistics::getFailLoginTopAccountCount($start_date, $end_date, $top);
$row_count = $return[0]['NUM'];
$page_size = 15;
$page_no = $page_no < 1 ? 1 : $page_no;
$total_page = $row_count % $page_size == 0 ? $row_count / $page_size : ceil($row_count / $page_size);
$total_page = $total_page < 1 ? 1 : $total_page;
$page_no = $page_no > $total_page ? $total_page : $page_no;
$start = ($page_no - 1) * $page_size;
$topAccounts = MailStatistics::getFailLoginTopAccount($start_date, $end_date, $top, $start, $page_size);
$page_html = Pagination::showPager("failLoginTopAccount.php?start_date={$start_date}&end_date={$end_date}&top={$top}", $page_no, 15, $row_count);
Template::assign('topAccounts', $topAccounts);
Template::assign('page_html', $page_html);
Template::assign('_GET', $_GET);
Template::display('netshow/mail/failLoginTopAccount.tpl');

$page_no = !isset($_GET['page_no']) || intval($_GET['page_no']) < 1 ? 1 : intval($_GET['page_no']);
$start = ($page_no - 1) * $page_size;
if ($_GET['download'] == 1) {
    $data['result'] = Complaint::getUnicomBusinessSpList($param, $start, 0);
} else {
    $data['result'] = Complaint::getUnicomBusinessSpList($param, $start, $page_size);
}
$row_count = Complaint::getUnicomBusinessSpListCount($param);
//导出excel下载
if ($_GET['download'] == 1) {
    $downloadStr = array_to_string($data);
    //var_dump($data);exit;
    Common::exportExcel($downloadStr, 'unicom_business_sp_list');
    exit;
}
$page_html = Pagination::showPager("unicom_business_sp_list.php?" . $http_query, $page_no, PAGE_SIZE, $row_count);
$export_excel = "unicom_business_sp_list.php?download=1&" . $http_query;
// $page_html=Pagination::showPager("black_list.php?class_name=$class_name&user_name=$user_name&start_date=$start_date&end_date=$end_date",$page_no,PAGE_SIZE,$row_count);
Template::assign("error", $error);
Template::assign("_POST", $_POST);
Template::assign('_GET', $_GET);
Template::assign("data", $data);
Template::assign("param", $param);
Template::assign('page_html', $page_html);
Template::assign('export_excel', $export_excel);
$confirm_html = OSAdmin::renderJsConfirm("icon-remove");
Template::assign('osadmin_action_confirm', $confirm_html);
// Template::assign("output" ,$output);
Template::display('complaint/unicom_business_sp_list.tpl');
//列表数据转化为字符串
function array_to_string($data)

if (isset($_SERVER["HTTP_X_REQUESTED_WITH"]) && strtolower($_SERVER["HTTP_X_REQUESTED_WITH"]) == "xmlhttprequest") {
    if ($ajaxMethod == 'sendCommand') {
        if (!empty($logid)) {
            $logItem = DataAlarmLog::getReExecDataAlarmLogForId($logid);
            if (!empty($logItem['TASK_FILE']) && !empty($logItem['PARAMS'])) {
                DataAlarmLog::updateAlarmStatus($logid, 1, date('Y-m-d H:i:s', time()));
                $cmd = PHP_CGI . "  " . $_SERVER['DOCUMENT_ROOT'] . $logItem['TASK_FILE'] . "  " . $logItem['PARAMS'];
                exec($cmd);
            }
        }
    }
} else {
    $alarmLog = DataAlarmLog::getDataAlarmLogCount($taskname, $start_date, $end_date);
    $row_count = $alarmLog[0]['NUM'];
    $page_size = 5;
    $page_no = $page_no < 1 ? 1 : $page_no;
    $total_page = $row_count % $page_size == 0 ? $row_count / $page_size : ceil($row_count / $page_size);
    $total_page = $total_page < 1 ? 1 : $total_page;
    $page_no = $page_no > $total_page ? $total_page : $page_no;
    $start = ($page_no - 1) * $page_size;
    $alarmLog = DataAlarmLog::getDataAlarmLog($taskname, $start_date, $end_date, $start, $page_size);
    foreach ($alarmLog as &$item) {
        $status = $item['STATUS'];
    }
    $page_html = Pagination::showPager("splunkDataMonitor.php?start_date={$start_date}&end_date={$end_date}", $page_no, $page_size, $row_count);
    Template::assign('alarmLog', $alarmLog);
    Template::assign('taskname_list', $taskname_list);
    Template::assign('page_html', $page_html);
    Template::assign('_GET', $_GET);
    Template::display('netshow/splunkdata/splunkDataMonitor.tpl');
}

$start = ($page_no - 1) * $page_size;
$current_user_info = UserSession::getSessionInfo();
$user_group = $current_user_info['user_group'];
$current_user_id = $current_user_info['user_id'];
if ($method == 'del' && !empty($note_id)) {
    $note = QuickNote::getNoteById($note_id);
    //是超级管理员组的成员或者是quicknote的主人
    if ($user_group == 1 || $note['owner_id'] == $current_user_id) {
        $result = QuickNote::delNote($note_id);
        if ($result > 0) {
            SysLog::addLog(UserSession::getUserName(), 'DELETE', 'QuickNote', $note_id, json_encode($note));
            Common::exitWithSuccess('便签删除成功', 'panel/quicknotes.php');
        } else {
            OSAdmin::alert("error");
        }
    } else {
        OSAdmin::alert("error", ErrorMessage::QUICKNOTE_NOT_OWNER);
    }
}
$quicknotes = QuickNote::getNotes($start, $page_size);
$confirm_html = OSAdmin::renderJsConfirm("icon-remove");
$page_html = Pagination::showPager("", $page_no, PAGE_SIZE, $row_count);
Template::assign('page_no', $page_no);
Template::assign('page_size', PAGE_SIZE);
Template::assign('row_count', $row_count);
Template::assign('page_html', $page_html);
Template::assign('quicknotes', $quicknotes);
Template::assign('osadmin_action_confirm', $confirm_html);
Template::assign('user_group', $user_group);
Template::assign('current_user_id', $current_user_id);
Template::display('panel/quicknotes.tpl');

$start_date_time = strtotime($start_date);
$end_date_time = strtotime($end_date);
$start_date = date('Ymd H:i:s', $start_date_time);
$end_date = date('Ymd H:i:s', $end_date_time);
$tableName = 'SPLUNK_PING';
if ($chkType == 1) {
    $tableName = 'SPLUNK_PING_WW';
} else {
    if ($chkType == 2) {
        $tableName = 'SPLUNK_PING_IP500';
    }
}
$return = PacketLossRate::getLossRateAllCount($start_date, $end_date, $tableName);
$row_count = $return[0]['NUM'];
$page_size = 15;
$page_no = $page_no < 1 ? 1 : $page_no;
$total_page = $row_count % $page_size == 0 ? $row_count / $page_size : ceil($row_count / $page_size);
$total_page = $total_page < 1 ? 1 : $total_page;
$page_no = $page_no > $total_page ? $total_page : $page_no;
$start = ($page_no - 1) * $page_size;
$list = PacketLossRate::getLossRateAll($start_date, $end_date, $tableName, $start, $page_size);
foreach ($list as &$item) {
    $item['PING'] = number_format($item['PING']);
    $item['TIME_OUT'] = number_format($item['TIME_OUT'], 2);
    $item['TIME_JG'] = number_format($item['TIME_JG'], 2);
}
$page_html = Pagination::showPager("lossRateAllPc.php?start_date={$start_date}&end_date={$end_date}&chkType={$chkType}", $page_no, 15, $row_count);
Template::assign('list', $list);
Template::assign('page_html', $page_html);
Template::assign('_GET', $_GET);
Template::display('netshow/idc/lossRateAllPc.tpl');