Pagenate::showing PHP代码示例

示例#1

0

显示文件

文件： slaplans.inc.php 项目： ed00m/osTicket-1.8

if ($order_column && strpos($order_column, ',')) {
    $order_column = str_replace(',', " {$order},", $order_column);
}
$x = $sort . '_sort';
${$x} = ' class="' . strtolower($order) . '" ';
$order_by = "{$order_column} {$order} ";
$total = db_count('SELECT count(*) FROM ' . SLA_TABLE . ' sla ');
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, PAGE_LIMIT);
$pageNav->setURL('slas.php', $qstr . '&sort=' . urlencode($_REQUEST['sort']) . '&order=' . urlencode($_REQUEST['order']));
//Ok..lets roll...create the actual query
$qstr .= '&order=' . ($order == 'DESC' ? 'ASC' : 'DESC');
$query = "{$sql} ORDER BY {$order_by} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
$res = db_query($query);
if ($res && ($num = db_num_rows($res))) {
    $showing = $pageNav->showing() . ' SLA plans';
} else {
    $showing = 'No SLA plans found!';
}
?>

<div style="width:700px;padding-top:5px; float:left;">
 <h2>Service Level Agreements</h2>
</div>
<div style="float:right;text-align:right;padding-top:5px;padding-right:5px;">
 <b><a href="slas.php?a=add" class="Icon newsla">Add New SLA Plan</a></b></div>
<div class="clear"></div>
<form action="slas.php" method="POST" name="slas">
 <?php 
csrf_token();
?>

示例#2

0

显示文件

文件： syslogs.inc.php 项目： KingsleyGU/osticket

$$x=' class="'.strtolower($order).'" ';
$order_by="$order_column $order ";

$qselect = 'SELECT log.* ';
$qfrom=' FROM '.SYSLOG_TABLE.' log ';
$total=db_count("SELECT count(*) $qfrom $qwhere");
$page = ($_GET['p'] && is_numeric($_GET['p']))?$_GET['p']:1;
//pagenate
$pageNav=new Pagenate($total, $page, PAGE_LIMIT);
$pageNav->setURL('logs.php',$qs);
$qs += array('order' => ($order=='DESC' ? 'ASC' : 'DESC'));
$qstr = '&amp;'. Http::build_query($qs);
$query="$qselect $qfrom $qwhere ORDER BY $order_by LIMIT ".$pageNav->getStart().",".$pageNav->getLimit();
$res=db_query($query);
if($res && ($num=db_num_rows($res)))
    $showing=$pageNav->showing().' '.$title;
else
    $showing=__('No logs found!');
?>

<h2><?php echo __('System Logs');?>
    &nbsp;<i class="help-tip icon-question-sign" href="#system_logs"></i>
</h2>
<div id='filter' >
 <form action="logs.php" method="get">
    <div style="padding-left:2px;">
        <b><?php echo __('Date Span'); ?></b>&nbsp;<i class="help-tip icon-question-sign" href="#date_span"></i>
        <?php echo __('Between'); ?>:
        <input class="dp" id="sd" size=15 name="startDate" value="<?php echo Format::htmlchars($_REQUEST['startDate']); ?>" autocomplete=OFF>
        &nbsp;&nbsp;
        <input class="dp" id="ed" size=15 name="endDate" value="<?php echo Format::htmlchars($_REQUEST['endDate']); ?>" autocomplete=OFF>

示例#3

0

显示文件

文件： cannedresponses.inc.php 项目： gizur/osticket

}
$x = $sort . '_sort';
${$x} = ' class="' . strtolower($order) . '" ';
$order_by = "{$order_column} {$order} ";
$total = db_count('SELECT count(*) FROM ' . CANNED_TABLE . ' canned ');
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, PAGE_LIMIT);
$qstr = '&amp;' . Http::build_query($qs);
$qs += array('sort' => $_REQUEST['sort'], 'order' => $_REQUEST['order']);
$pageNav->setURL('canned.php', $qs);
//Ok..lets roll...create the actual query
$qstr .= '&order=' . ($order == 'DESC' ? 'ASC' : 'DESC');
$query = "{$sql} GROUP BY canned.canned_id ORDER BY {$order_by} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
$res = db_query($query);
if ($res && ($num = db_num_rows($res))) {
    $showing = $pageNav->showing() . ' ' . _N('premade response', 'premade responses', $total);
} else {
    $showing = __('No premade responses found!');
}
?>
<div class="pull-left" style="width:700px;padding-top:5px;">
 <h2><?php 
echo __('Canned Responses');
?>
</h2>
 </div>
<div class="pull-right flush-right" style="padding-top:5px;padding-right:5px;">
    <b><a href="canned.php?a=add" class="Icon newReply"><?php 
echo __('Add New Response');
?>
</a></b></div>

示例#4

0

显示文件

文件： dynamic-lists.inc.php 项目： dmiguel92/osTicket-1.8

?>
</h2>
</div>
<div class="pull-right flush-right" style="padding-top:5px;padding-right:5px;">
 <b><a href="lists.php?a=add" class="Icon list-add"><?php 
echo __('Add New Custom List');
?>
</a></b></div>
<div class="clear"></div>

<?php 
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$count = DynamicList::objects()->count();
$pageNav = new Pagenate($count, $page, PAGE_LIMIT);
$pageNav->setURL('lists.php');
$showing = $pageNav->showing() . ' ' . _N('custom list', 'custom lists', $count);
?>
<form action="lists.php" method="POST" name="lists">
<?php 
csrf_token();
?>
<input type="hidden" name="do" value="mass_process" >
<input type="hidden" id="action" name="a" value="" >
<table class="list" border="0" cellspacing="1" cellpadding="0" width="940">
    <caption>Custom Lists</caption>
    <thead>
        <tr>
            <th width="7">&nbsp;</th>
            <th><?php 
echo __('List Name');
?>

示例#5

0

显示文件

文件： tickets.inc.php 项目： e-gob/chilesinpapeleo-soporte

$pagelimit = $_GET['limit'] ? $_GET['limit'] : PAGE_LIMIT;
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$qselect = 'SELECT ticket.ticket_id,ticket.ticketID,ticket.dept_id,isanswered,ispublic,subject,name ' . ',dept_name,status,source,priority_id,ticket.created,ticket.updated,staff.firstname,staff.lastname';
$qfrom = ' FROM (' . TICKET_TABLE . ' ticket' . ' LEFT JOIN ' . DEPT_TABLE . ' dept ON ticket.dept_id=dept.dept_id )' . ' LEFT JOIN ' . STAFF_TABLE . ' staff ON ticket.staff_id=staff.staff_id';
//Pagenation stuff....wish MYSQL could auto pagenate (something better than limit)
$total = db_count('SELECT count(*) ' . $qfrom . ' ' . $qwhere);
$pageNav = new Pagenate($total, $page, $pagelimit);
$pageNav->setURL('view.php', $qstr . '&sort=' . urlencode($_REQUEST['sort']) . '&order=' . urlencode($_REQUEST['order']));
//Ok..lets roll...create the actual query
$qselect .= ' ,count(attach_id) as attachments ';
$qfrom .= ' LEFT JOIN ' . TICKET_ATTACHMENT_TABLE . ' attach ON  ticket.ticket_id=attach.ticket_id ';
$qgroup = ' GROUP BY ticket.ticket_id';
$query = "{$qselect} {$qfrom} {$qwhere} {$qgroup} ORDER BY {$order_by} {$order} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
//echo $query;
$tickets_res = db_query($query);
$showing = db_num_rows($tickets_res) ? $pageNav->showing() : "";
$results_type = $status ? $ger_status . 'Tickets' : 'Tickets';
$negorder = $order == 'DESC' ? 'ASC' : 'DESC';
//Negate the sorting..
?>

<div class="page-header">
    <h1>Mis tickets</h1>
</div>
<div class="row">
    <?php 
if ($errors['err']) {
    ?>
        <p align="center" id="errormessage"><?php 
    echo $errors['err'];
    ?>

示例#6

0

显示文件

文件： helptopics.inc.php 项目： pkdevboxy/osTicket-1.7

if ($order_column && strpos($order_column, ',')) {
    $order_column = str_replace(',', " {$order},", $order_column);
}
$x = $sort . '_sort';
${$x} = ' class="' . strtolower($order) . '" ';
$order_by = "{$order_column} {$order} ";
$total = db_count('SELECT count(*) FROM ' . TOPIC_TABLE . ' topic ');
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, PAGE_LIMIT);
$pageNav->setURL('helptopics.php', $qstr . '&sort=' . urlencode($_REQUEST['sort']) . '&order=' . urlencode($_REQUEST['order']));
//Ok..lets roll...create the actual query
$qstr .= '&order=' . ($order == 'DESC' ? 'ASC' : 'DESC');
$query = "{$sql} GROUP BY topic.topic_id ORDER BY {$order_by} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
$res = db_query($query);
if ($res && ($num = db_num_rows($res))) {
    $showing = $pageNav->showing() . ' help topics';
} else {
    $showing = 'No help topic found!';
}
?>
<div style="width:700px;padding-top:5px; float:left;">
 <h2>Help Topics</h2>
 </div>
<div style="float:right;text-align:right;padding-top:5px;padding-right:5px;">
    <b><a href="helptopics.php?a=add" class="Icon newHelpTopic">Add New Help Topic</a></b></div>
<div class="clear"></div>
<form action="helptopics.php" method="POST" name="topics">
 <?php 
csrf_token();
?>
 <input type="hidden" name="do" value="mass_process" >

示例#7

0

显示文件

文件： categories.inc.php 项目： KingsleyGU/osticket

    $order_column=str_replace(','," $order,",$order_column);
}
$x=$sort.'_sort';
$$x=' class="'.strtolower($order).'" ';
$order_by="$order_column $order ";

$total=db_count('SELECT count(*) FROM '.FAQ_CATEGORY_TABLE.' cat ');
$page=($_GET['p'] && is_numeric($_GET['p']))?$_GET['p']:1;
$pageNav=new Pagenate($total, $page, PAGE_LIMIT);
$qs += array('sort' => $_REQUEST['sort'], 'order' => $_REQUEST['order']);
$pageNav->setURL('categories.php', $qs);
$qstr = '&amp;order='.($order=='DESC'?'ASC':'DESC');
$query="$sql GROUP BY cat.category_id ORDER BY $order_by LIMIT ".$pageNav->getStart().",".$pageNav->getLimit();
$res=db_query($query);
if($res && ($num=db_num_rows($res)))
    $showing=$pageNav->showing().' '.__('categories');
else
    $showing=__('No FAQ categories found!');

?>
<div class="pull-left" style="width:700px;padding-top:5px;">
 <h2><?php echo __('FAQ Categories');?></h2>
 </div>
<div class="pull-right flush-right" style="padding-top:5px;padding-right:5px;">
    <b><a href="categories.php?a=add" class="Icon newCategory"><?php echo __('Add New Category');?></a></b></div>
<div class="clear"></div>
<form action="categories.php" method="POST" name="cat">
 <?php csrf_token(); ?>
 <input type="hidden" name="do" value="mass_process" >
 <input type="hidden" id="action" name="a" value="" >
 <table class="list" border="0" cellspacing="1" cellpadding="0" width="940">

示例#8

0

显示文件

文件： dynamic-forms.inc.php 项目： dmiguel92/osTicket-1.8

?>
</h2>
</div>
<div class="pull-right flush-right" style="padding-top:5px;padding-right:5px;">
<b><a href="forms.php?a=add" class="Icon form-add"><?php 
echo __('Add New Custom Form');
?>
</a></b></div>
<div class="clear"></div>

<?php 
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$count = DynamicForm::objects()->filter(array('type__in' => array('G')))->count();
$pageNav = new Pagenate($count, $page, PAGE_LIMIT);
$pageNav->setURL('forms.php');
$showing = $pageNav->showing() . ' ' . _N('form', 'forms', $count);
?>

<form action="forms.php" method="POST" name="forms">
<?php 
csrf_token();
?>
<input type="hidden" name="do" value="mass_process" >
<input type="hidden" id="action" name="a" value="" >
<table class="list" border="0" cellspacing="1" cellpadding="0" width="940">
    <thead>
        <tr>
            <th width="7">&nbsp;</th>
            <th><?php 
echo __('Built-in Forms');
?>

示例#9

0

显示文件

文件： templates.inc.php 项目： nicolap/osTicket-1.7

if ($order_column && strpos($order_column, ',')) {
    $order_column = str_replace(',', " {$order},", $order_column);
}
$x = $sort . '_sort';
${$x} = ' class="' . strtolower($order) . '" ';
$order_by = "{$order_column} {$order} ";
$total = db_count('SELECT count(*) FROM ' . EMAIL_TEMPLATE_TABLE . ' tpl ');
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, PAGE_LIMIT);
$pageNav->setURL('templates.php', $qstr . '&sort=' . urlencode($_REQUEST['sort']) . '&order=' . urlencode($_REQUEST['order']));
//Ok..lets roll...create the actual query
$qstr .= '&order=' . ($order == 'DESC' ? 'ASC' : 'DESC');
$query = "{$sql} GROUP BY tpl.tpl_id ORDER BY {$order_by} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
$res = db_query($query);
if ($res && ($num = db_num_rows($res))) {
    $showing = $pageNav->showing() . ' Templates';
} else {
    $showing = 'No templates found!';
}
?>

<div style="width:700;padding-top:5px; float:left;">
 <h2>Email Templates</h2>
</div>
<div style="float:right;text-align:right;padding-top:5px;padding-right:5px;">
 <b><a href="templates.php?a=add" class="Icon newEmailTemplate">Add New Template</a></b></div>
<div class="clear"></div>
<form action="templates.php" method="POST" name="tpls" onSubmit="return checkbox_checker(this,1,0);">
 <input type="hidden" name="do" value="mass_process" >
 <table class="list" border="0" cellspacing="1" cellpadding="0" width="940">
    <caption><?php

示例#10

0

显示文件

文件： pages.inc.php 项目： gizur/osticket

    $order_column = str_replace(',', " {$order},", $order_column);
}
$x = $sort . '_sort';
${$x} = ' class="' . strtolower($order) . '" ';
$order_by = "{$order_column} {$order} ";
$total = db_count('SELECT count(*) FROM ' . PAGE_TABLE . ' page ' . $where);
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, PAGE_LIMIT);
$qstr = '&amp;' . Http::build_query($qs);
$qs += array('sort' => $_REQUEST['sort'], 'order' => $_REQUEST['order']);
$pageNav->setURL('pages.php', $qs);
$qstr .= '&amp;order=' . ($order == 'DESC' ? 'ASC' : 'DESC');
$query = "{$sql} {$where} GROUP BY page.id ORDER BY {$order_by} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
$res = db_query($query);
if ($res && ($num = db_num_rows($res))) {
    $showing = $pageNav->showing() . _N('site page', 'site pages', $num);
} else {
    $showing = __('No pages found!');
}
?>

<div class="pull-left" style="width:700px;padding-top:5px;">
 <h2><?php 
echo __('Site Pages');
?>
    <i class="help-tip icon-question-sign" href="#site_pages"></i>
    </h2>
</div>
<div class="pull-right flush-right" style="padding-top:5px;padding-right:5px;">
 <b><a href="pages.php?a=add" class="Icon newPage"><?php 
echo __('Add New Page');

示例#11

0

显示文件

文件： plugins.inc.php 项目： ed00m/osTicket-1.8

<div style="width:700;padding-top:5px; float:left;">
 <h2>Currently Installed Plugins</h2>
</div>
<div style="float:right;text-align:right;padding-top:5px;padding-right:5px;">
 <b><a href="plugins.php?a=add" class="Icon form-add">Add New Plugin</a></b></div>
<div class="clear"></div>

<?php 
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$count = count($ost->plugins->allInstalled());
$pageNav = new Pagenate($count, $page, PAGE_LIMIT);
$pageNav->setURL('forms.php');
$showing = $pageNav->showing() . ' forms';
?>

<form action="plugins.php" method="POST" name="forms">
<?php 
csrf_token();
?>
<input type="hidden" name="do" value="mass_process" >
<input type="hidden" id="action" name="a" value="" >
<table class="list" border="0" cellspacing="1" cellpadding="0" width="940">
    <thead>
        <tr>
            <th width="7">&nbsp;</th>
            <th>Plugin Name</th>
            <th>Status</td>
            <th>Date Installed</th>
        </tr>
    </thead>
    <tbody>

示例#12

0

显示文件

文件： syslogs.inc.php 项目： KingsleyGU/OSTicket-Reloaded

        $qstr .= '&endDate=' . urlencode($_REQUEST['endDate']);
    }
}
$qselect = 'SELECT log.* ';
$qfrom = ' FROM ' . SYSLOG_TABLE . ' log ';
//get log count based on the query so far..
$total = db_count("SELECT count(*) {$qfrom} {$qwhere}");
$pagelimit = 30;
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
//pagenate
$pageNav = new Pagenate($total, $page, $pagelimit, $trl);
$pageNav->setURL('admin.php', $qstr);
$query = "{$qselect} {$qfrom} {$qwhere} ORDER BY log.created DESC LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
//echo $query;
$result = db_query($query);
$showing = db_num_rows($resp) ? $pageNav->showing() : "";
?>
<div class="msg">System Logs</div>
<div id='filter' >
 <form action="admin.php?t=syslog" method="get">
    <input type="hidden" name="t" value="syslog" />
    <div style="padding-left:15px;">
        Date Span:
        &nbsp;From&nbsp;<input id="sd" size=15 name="startDate" value="<?php 
echo Format::htmlchars($_REQUEST['startDate']);
?>
" 
                onclick="event.cancelBubble=true;calendar(this);" autocomplete=OFF>
            <a href="#" onclick="event.cancelBubble=true;calendar(getObj('sd')); return false;"><img src='images/cal.png'border=0 alt=""></a>
            &nbsp;&nbsp; to &nbsp;&nbsp;
            <input id="ed" size=15 name="endDate" value="<?php

示例#13

0

显示文件

文件： staffmembers.inc.php 项目： CarlosAvilesMx/CarlosAviles.Mx

                     $sel=($_REQUEST['tid'] && $_REQUEST['tid']==$id)?'selected="selected"':'';
                     echo sprintf('<option value="%d" %s>%s (%s)</option>',$id,$sel,$name,$users);
                 }
             }
             ?>
        </select>
        &nbsp;&nbsp;
        <input type="submit" name="submit" value="<?php echo __('Apply');?>"/>
    </form>
 </div>
<div class="pull-right flush-right" style="padding-right:5px;"><b><a href="staff.php?a=add" class="Icon newstaff"><?php echo __('Add New Agent');?></a></b></div>
<div class="clear"></div>
<?php
$res=db_query($query);
if($res && ($num=db_num_rows($res)))
    $showing=$pageNav->showing() . ' ' . _N('agent', 'agents', $num);
else
    $showing=__('No agents found!');
?>
<form action="staff.php" method="POST" name="staff" >
 <?php csrf_token(); ?>
 <input type="hidden" name="do" value="mass_process" >
 <input type="hidden" id="action" name="a" value="" >
 <table class="list" border="0" cellspacing="1" cellpadding="0" width="940">
    <caption><?php echo $showing; ?></caption>
    <thead>
        <tr>
            <th width="7px">&nbsp;</th>
            <th width="200"><a <?php echo $name_sort; ?> href="staff.php?<?php echo $qstr; ?>&sort=name"><?php echo __('Name');?></a></th>
            <th width="100"><a <?php echo $username_sort; ?> href="staff.php?<?php echo $qstr; ?>&sort=username"><?php echo __('Username');?></a></th>
            <th width="100"><a  <?php echo $status_sort; ?> href="staff.php?<?php echo $qstr; ?>&sort=status"><?php echo __('Status');?></a></th>

示例#14

0

显示文件

文件： dynamic-list.inc.php 项目： ed00m/osTicket-1.8

    <?php 
}
?>
    </tbody>
</table>
</div>
<div id="items" class="tab_content" style="display:none">
    <table class="form_table" width="940" border="0" cellspacing="0" cellpadding="2">
    <thead>
    <?php 
if ($list) {
    $page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
    $count = $list->getItemCount();
    $pageNav = new Pagenate($count, $page, PAGE_LIMIT);
    $pageNav->setURL('dynamic-list.php', 'id=' . urlencode($_REQUEST['id']));
    $showing = $pageNav->showing() . ' list items';
    ?>
    <?php 
} else {
    $showing = 'Add a few initial items to the list';
}
?>
        <tr>
            <th colspan="5">
                <em><?php 
echo $showing;
?>
</em>
            </th>
        </tr>
        <tr>

示例#15

0

显示文件

文件： categories.inc.php 项目： pkdevboxy/osTicket-1.7

$order = $order ? $order : 'ASC';
if ($order_column && strpos($order_column, ',')) {
    $order_column = str_replace(',', " {$order},", $order_column);
}
$x = $sort . '_sort';
${$x} = ' class="' . strtolower($order) . '" ';
$order_by = "{$order_column} {$order} ";
$total = db_count('SELECT count(*) FROM ' . FAQ_CATEGORY_TABLE . ' cat ');
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, PAGE_LIMIT);
$pageNav->setURL('categories.php', $qstr . '&sort=' . urlencode($_REQUEST['sort']) . '&order=' . urlencode($_REQUEST['order']));
$qstr .= '&order=' . ($order == 'DESC' ? 'ASC' : 'DESC');
$query = "{$sql} GROUP BY cat.category_id ORDER BY {$order_by} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
$res = db_query($query);
if ($res && ($num = db_num_rows($res))) {
    $showing = $pageNav->showing() . ' categories';
} else {
    $showing = 'No FAQ categories found!';
}
?>
<div style="width:700px;padding-top:5px; float:left;">
 <h2>FAQ Categories</h2>
 </div>
<div style="float:right;text-align:right;padding-top:5px;padding-right:5px;">
    <b><a href="categories.php?a=add" class="Icon newCategory">Add New Category</a></b></div>
<div class="clear"></div>
<form action="categories.php" method="POST" name="cat">
 <?php 
csrf_token();
?>
 <input type="hidden" name="do" value="mass_process" >

示例#16

0

显示文件

文件： templates.inc.php 项目： gizur/osticket

    $order_column = str_replace(',', " {$order},", $order_column);
}
$x = $sort . '_sort';
${$x} = ' class="' . strtolower($order) . '" ';
$order_by = "{$order_column} {$order} ";
$total = db_count('SELECT count(*) FROM ' . EMAIL_TEMPLATE_GRP_TABLE . ' tpl ');
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, PAGE_LIMIT);
$qstr = '&amp;' . Http::build_query($qs);
$qs += array('sort' => $_REQUEST['sort'], 'order' => $_REQUEST['order']);
$pageNav->setURL('templates.php', $qs);
$qstr .= '&amp;order=' . ($order == 'DESC' ? 'ASC' : 'DESC');
$query = "{$sql} GROUP BY tpl.tpl_id ORDER BY {$order_by} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
$res = db_query($query);
if ($res && ($num = db_num_rows($res))) {
    $showing = $pageNav->showing() . ' ' . _N('template', 'templates', $num);
} else {
    $showing = __('No templates found!');
}
?>

<div class="pull-left" style="width:700px;padding-top:5px;">
 <h2><?php 
echo __('Email Template Sets');
?>
</h2>
</div>
<div class="pull-right flush-right" style="padding-top:5px;padding-right:5px;">
 <b><a href="templates.php?a=add" class="Icon newEmailTemplate"><?php 
echo __('Add New Template Set');
?>

示例#17

0

显示文件

文件： plugins.inc.php 项目： gizur/osticket

?>
</h2>
</div>
<div class="pull-right flush-right" style="padding-top:5px;padding-right:5px;">
 <b><a href="plugins.php?a=add" class="Icon form-add"><?php 
echo __('Add New Plugin');
?>
</a></b></div>
<div class="clear"></div>

<?php 
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$count = count($ost->plugins->allInstalled());
$pageNav = new Pagenate($count, $page, PAGE_LIMIT);
$pageNav->setURL('forms.php');
$showing = $pageNav->showing() . ' ' . _N('plugin', 'plugins', $count);
?>

<form action="plugins.php" method="POST" name="forms">
<?php 
csrf_token();
?>
<input type="hidden" name="do" value="mass_process" >
<input type="hidden" id="action" name="a" value="" >
<table class="list" border="0" cellspacing="1" cellpadding="0" width="940">
    <thead>
        <tr>
            <th width="7">&nbsp;</th>
            <th><?php 
echo __('Plugin Name');
?>

示例#18

0

显示文件

文件： emails.inc.php 项目： ryan1432/osTicket-1.7fork

$x = $sort . '_sort';
${$x} = ' class="' . strtolower($order) . '" ';
$order_by = "{$order_column} {$order} ";
$total = db_count('SELECT count(*) FROM ' . EMAIL_TABLE . ' email ');
$pagelimit = $thisstaff->getPageLimit();
$pagelimit = $pagelimit ? $pagelimit : PAGE_LIMIT;
//true default...if all fails.
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, $pagelimit);
$pageNav->setURL('emails.php', $qstr . '&sort=' . urlencode($_REQUEST['sort']) . '&order=' . urlencode($_REQUEST['order']));
//Ok..lets roll...create the actual query
$qstr .= '&order=' . ($order == 'DESC' ? 'ASC' : 'DESC');
$query = "{$sql} GROUP BY email.email_id ORDER BY {$order_by} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
$res = db_query($query);
if ($res && ($num = db_num_rows($res))) {
    $showing = $pageNav->showing() . ' emails';
} else {
    $showing = 'No emails found!';
}
?>
<div style="width:700;padding-top:5px; float:left;">
 <h2>Email Addresses</h2>
 </div>
<div style="float:right;text-align:right;padding-top:5px;padding-right:5px;">
    <b><a href="emails.php?a=add" class="Icon newEmail">Add New Email</a></b></div>
<div class="clear"></div>
<form action="emails.php" method="POST" name="emails" onSubmit="return checkbox_checker(this,1,0);">
 <input type="hidden" name="do" value="mass_process" >
 <table class="list" border="0" cellspacing="1" cellpadding="0" width="940">
    <caption><?php 
echo $showing;

示例#19

0

显示文件

文件： dynamic-list.inc.php 项目： dmiguel92/osTicket-1.8

    <?php 
}
?>
    </tbody>
</table>
</div>
<div id="items" class="tab_content" style="display:none">
    <table class="form_table" width="940" border="0" cellspacing="0" cellpadding="2">
    <thead>
    <?php 
if ($list) {
    $page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
    $count = $list->getNumItems();
    $pageNav = new Pagenate($count, $page, PAGE_LIMIT);
    $pageNav->setURL('list.php', array('id' => $list->getId()));
    $showing = $pageNav->showing() . ' ' . __('list items');
    ?>
    <?php 
} else {
    $showing = __('Add a few initial items to the list');
}
?>
        <tr>
            <th colspan="5">
                <em><?php 
echo $showing;
?>
</em>
            </th>
        </tr>
        <tr>

示例#20

0

显示文件

文件： emails.inc.php 项目： KingsleyGU/osticket

    $order_column=str_replace(','," $order,",$order_column);
}
$x=$sort.'_sort';
$$x=' class="'.strtolower($order).'" ';
$order_by="$order_column $order ";

$total=db_count('SELECT count(*) FROM '.EMAIL_TABLE.' email ');
$page=($_GET['p'] && is_numeric($_GET['p']))?$_GET['p']:1;
$pageNav=new Pagenate($total, $page, PAGE_LIMIT);
$qs += array('sort' => $_REQUEST['sort'], 'order' => $_REQUEST['order']);
$pageNav->setURL('emails.php', $qs);
$qstr = '&amp;order='.($order=='DESC' ? 'ASC' : 'DESC');
$query="$sql GROUP BY email.email_id ORDER BY $order_by LIMIT ".$pageNav->getStart().",".$pageNav->getLimit();
$res=db_query($query);
if($res && ($num=db_num_rows($res)))
    $showing=$pageNav->showing().' '.__('emails');
else
    $showing=__('No emails found!');

$def_dept_id = $cfg->getDefaultDeptId();
$def_dept_name = $cfg->getDefaultDept()->getName();
$def_priority = $cfg->getDefaultPriority()->getDesc();

?>
<div class="pull-left" style="width:700px;padding-top:5px;">
 <h2><?php echo __('Email Addresses');?></h2>
 </div>
<div class="pull-right flush-right" style="padding-top:5px;padding-right:5px;">
    <b><a href="emails.php?a=add" class="Icon newEmail"><?php echo __('Add New Email');?></a></b></div>
<div class="clear"></div>
<form action="emails.php" method="POST" name="emails">

示例#21

0

显示文件

文件： tickets.inc.php 项目： KingsleyGU/osticketLocal

       .' LEFT JOIN '.STAFF_TABLE.' staff ON (ticket.staff_id=staff.staff_id) '
       .' LEFT JOIN '.TEAM_TABLE.' team ON (ticket.team_id=team.team_id) '
       .' LEFT JOIN '.SLA_TABLE.' sla ON (ticket.sla_id=sla.id AND sla.isactive=1) '
       .' LEFT JOIN '.TOPIC_TABLE.' topic ON (ticket.topic_id=topic.topic_id) '
       .' LEFT JOIN '.TOPIC_TABLE.' ptopic ON (ptopic.topic_id=topic.topic_pid) '
       .' LEFT JOIN '.TABLE_PREFIX.'ticket__cdata cdata ON (cdata.ticket_id = ticket.ticket_id) '
       .' LEFT JOIN '.PRIORITY_TABLE.' pri ON (pri.priority_id = cdata.priority)';

TicketForm::ensureDynamicDataView();

$query="$qselect $qfrom $qwhere ORDER BY $order_by $order LIMIT ".$pageNav->getStart().",".$pageNav->getLimit();
//echo $query;
$hash = md5($query);
$_SESSION['search_'.$hash] = $query;
$res = db_query($query);
$showing=db_num_rows($res)? ' &mdash; '.$pageNav->showing():"";
if(!$results_type)
    $results_type = sprintf(__('%s Tickets' /* %s will be a status such as 'open' */),
        mb_convert_case($status, MB_CASE_TITLE));

if($search)
    $results_type.= ' ('.__('Search Results').')';

$negorder=$order=='DESC'?'ASC':'DESC'; //Negate the sorting..

// Fetch the results
$results = array();
while ($row = db_fetch_array($res)) {
    $results[$row['ticket_id']] = $row;
}

示例#22

0

显示文件

文件： tickets.inc.php 项目： majklovec/osticket-bootstrap-theme

        // Use the search engine to perform the search
        $tickets = $ost->searcher->find($q, $tickets);
    }
}
if ($settings['topic_id']) {
    $tickets = $tickets->filter(array('topic_id' => $settings['topic_id']));
}
TicketForm::ensureDynamicDataView();
$total = $tickets->count();
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, PAGE_LIMIT);
$qstr = '&amp;' . Http::build_query($qs);
$qs += array('sort' => $_REQUEST['sort'], 'order' => $_REQUEST['order']);
$pageNav->setURL('tickets.php', $qs);
$pageNav->paginate($tickets);
$showing = $total ? $pageNav->showing() : "";
if (!$results_type) {
    $results_type = ucfirst($status) . ' ' . __('Tickets');
}
$showing .= $status ? ' ' . $results_type : ' ' . __('All Tickets');
if ($search) {
    $showing = __('Search Results') . ": {$showing}";
}
$negorder = $order == '-' ? 'ASC' : 'DESC';
//Negate the sorting
$tickets->order_by($order . $order_by);
$tickets->values('ticket_id', 'number', 'created', 'isanswered', 'source', 'status_id', 'status__state', 'status__name', 'cdata__subject', 'dept_id', 'dept__name', 'dept__ispublic', 'user__default_email__address');
?>
<div class="container topheader"><div class="row">
<div class="search well">
<div class="flush-left">

示例#23

0

显示文件

文件： api.inc.php 项目： KingsleyGU/OSTicket-Reloaded

if ($_REQUEST['order']) {
    $order = $orderWays[$_REQUEST['order']];
}
$order_column = $order_column ? $order_column : 'ipaddr';
$order = $order ? $order : 'ASC';
$order_by = " ORDER BY {$order_column} {$order} ";
$total = db_count('SELECT count(*) ' . $from . ' ' . $where);
$pagelimit = 1000;
//No limit.
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, $pagelimit, $trl);
$pageNav->setURL('admin.php', $qstr . '&sort=' . urlencode($_REQUEST['sort']) . '&order=' . urlencode($_REQUEST['order']));
$query = "{$select} {$from} {$where} {$order_by}";
//echo $query;
$result = db_query($query);
$showing = db_num_rows($result) ? $pageNav->showing() : '';
$negorder = $order == 'DESC' ? 'ASC' : 'DESC';
//Negate the sorting..
$deletable = 0;
?>
<div class="msg">API Keys</div>
<hr>
<div><b><?php 
echo $showing;
?>
</b></div>
 <table width="100%" border="0" cellspacing=1 cellpadding=2>
   <form action="admin.php?t=api" method="POST" name="api" onSubmit="return checkbox_checker(document.forms['api'],1,0);">
   <input type=hidden name='t' value='api'>
   <input type=hidden name='do' value='mass_process'>
   <tr><td>

示例#24

0

显示文件

文件： filters.inc.php 项目： nicolap/osTicket-1.7

if ($order_column && strpos($order_column, ',')) {
    $order_column = str_replace(',', " {$order},", $order_column);
}
$x = $sort . '_sort';
${$x} = ' class="' . strtolower($order) . '" ';
$order_by = "{$order_column} {$order} ";
$total = db_count('SELECT count(*) FROM ' . EMAIL_FILTER_TABLE . ' filter ');
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, PAGE_LIMIT);
$pageNav->setURL('filters.php', $qstr . '&sort=' . urlencode($_REQUEST['sort']) . '&order=' . urlencode($_REQUEST['order']));
//Ok..lets roll...create the actual query
$qstr .= '&order=' . ($order == 'DESC' ? 'ASC' : 'DESC');
$query = "{$sql} ORDER BY {$order_by} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
$res = db_query($query);
if ($res && ($num = db_num_rows($res))) {
    $showing = $pageNav->showing() . ' filters';
} else {
    $showing = 'No filters found!';
}
?>

<div style="width:700;padding-top:5px; float:left;">
 <h2>Email Filters</h2>
</div>
<div style="float:right;text-align:right;padding-top:5px;padding-right:5px;">
 <b><a href="filters.php?a=add" class="Icon newEmailFilter">Add New Filter</a></b></div>
<div class="clear"></div>
<form action="filters.php" method="POST" name="filters" onSubmit="return checkbox_checker(this,1,0);">
 <input type="hidden" name="do" value="mass_process" >
 <table class="list" border="0" cellspacing="1" cellpadding="0" width="940">
    <caption><?php

示例#25

0

显示文件

文件： tickets_20150916.inc.php 项目： jmangarret/ostickets

}
TicketForm::ensureDynamicDataView();
$total = db_count('SELECT count(DISTINCT ticket.ticket_id) ' . $qfrom . ' ' . $qwhere);
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, PAGE_LIMIT);
$qstr = '&amp;' . Http::build_query($qs);
$qs += array('sort' => $_REQUEST['sort'], 'order' => $_REQUEST['order']);
$pageNav->setURL('tickets.php', $qs);
//more stuff...
$qselect .= ' ,count(attach_id) as attachments ';
$qfrom .= ' LEFT JOIN ' . TICKET_ATTACHMENT_TABLE . ' attach ON  ticket.ticket_id=attach.ticket_id ';
$qgroup = ' GROUP BY ticket.ticket_id';
$query = "{$qselect} {$qfrom} {$qwhere} {$qgroup} ORDER BY {$order_by} {$order} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
//echo $query;
$res = db_query($query);
$showing = $res && db_num_rows($res) ? $pageNav->showing() : "";
if (!$results_type) {
    $results_type = ucfirst($status) . ' Tickets';
}
$showing .= $status ? ' ' . $results_type : ' ' . __('All Tickets');
if ($search) {
    $showing = __('Search Results') . ": {$showing}";
}
$negorder = $order == 'DESC' ? 'ASC' : 'DESC';
//Negate the sorting
?>
<h1><?php 
echo __('Tickets');
?>
</h1>
<br>

示例#26

0

显示文件

文件： filters.inc.php 项目： KingsleyGU/OSTicket-Reloaded

}
$order_column = $order_column ? $order_column : 'added';
$order = $order ? $order : 'DESC';
$order_by = " ORDER BY {$order_column} {$order} ";
$total = db_count('SELECT count(*) ' . $from . ' ' . $where);
$pagelimit = $thisuser->getPageLimit();
$pagelimit = $pagelimit ? $pagelimit : PAGE_LIMIT;
//true default...if all fails.
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, $pagelimit, $trl);
$pageNav->setURL('admin.php', $qstr . '&sort=' . urlencode($_REQUEST['sort']) . '&order=' . urlencode($_REQUEST['order']));
//Ok..lets roll...create the actual query
$query = "{$select} {$from} {$where} {$order_by} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
//echo $query;
$banlist = db_query($query);
$showing = db_num_rows($banlist) ? $pageNav->showing() : '';
$result_type = $search ? 'Search Results' : 'Banned Email Addresses';
$negorder = $order == 'DESC' ? 'ASC' : 'DESC';
//Negate the sorting..
$showadd = $errors && $_POST['a'] == 'add' ? true : false;
?>
<div id='search' align="left"  style="display:<?php 
echo $showadd ? 'none' : 'block';
?>
;">
    <form action="admin.php?t=settings" method="GET" >
        <input type='hidden' name='t' value='banlist'>
        <input type='hidden' name='a' value='search'>
        Query:&nbsp;<input type="text" name="query" value="<?php 
echo Format::htmlchars($_REQUEST['query']);
?>

示例#27

0

显示文件

文件： cannedresponses.inc.php 项目： pkdevboxy/osTicket-1.7

if ($order_column && strpos($order_column, ',')) {
    $order_column = str_replace(',', " {$order},", $order_column);
}
$x = $sort . '_sort';
${$x} = ' class="' . strtolower($order) . '" ';
$order_by = "{$order_column} {$order} ";
$total = db_count('SELECT count(*) FROM ' . CANNED_TABLE . ' canned ');
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, PAGE_LIMIT);
$pageNav->setURL('canned.php', $qstr . '&sort=' . urlencode($_REQUEST['sort']) . '&order=' . urlencode($_REQUEST['order']));
//Ok..lets roll...create the actual query
$qstr .= '&order=' . ($order == 'DESC' ? 'ASC' : 'DESC');
$query = "{$sql} GROUP BY canned.canned_id ORDER BY {$order_by} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
$res = db_query($query);
if ($res && ($num = db_num_rows($res))) {
    $showing = $pageNav->showing() . ' premade responses';
} else {
    $showing = 'No premade responses found!';
}
?>
<div style="width:700px;padding-top:5px; float:left;">
 <h2>Canned Responses</h2>
 </div>
<div style="float:right;text-align:right;padding-top:5px;padding-right:5px;">
    <b><a href="canned.php?a=add" class="Icon newReply">Add New Response</a></b></div>
<div class="clear"></div>
<form action="canned.php" method="POST" name="canned">
 <?php 
csrf_token();
?>
 <input type="hidden" name="do" value="mass_process" >

示例#28

0

显示文件

文件： premade.inc.php 项目： amira147/omniphics

}
$order_column = $order_column ? $order_column : 'premade.title';
$order = $order ? $order : 'DESC';
$order_by = $search ? '' : " ORDER BY {$order_column} {$order} ";
$total = db_count('SELECT count(*) ' . $from . ' ' . $where);
$pagelimit = $thisuser->getPageLimit();
$pagelimit = $pagelimit ? $pagelimit : PAGE_LIMIT;
//true default...if all fails.
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, $pagelimit);
$pageNav->setURL('kb.php', $qstr . '&sort=' . urlencode($_REQUEST['sort']) . '&order=' . urlencode($_REQUEST['order']));
//Ok..lets roll...create the actual query
$query = "{$select} {$from} {$where} {$order_by} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
//echo $query;
$replies = db_query($query);
$showing = db_num_rows($replies) ? $pageNav->showing() : '';
$results_type = $search ? 'Search Results' : 'Premade/Canned Replies';
$negorder = $order == 'DESC' ? 'ASC' : 'DESC';
//Negate the sorting..
?>
<div>
    <?php 
if ($errors['err']) {
    ?>
        <p align="center" id="errormessage"><?php 
    echo $errors['err'];
    ?>
</p>
    <?php 
} elseif ($msg) {
    ?>

示例#29

0

显示文件

文件： users.tmpl.php 项目： CarlosAvilesMx/CarlosAviles.Mx

$pageNav->setURL('users.php',$qstr.'&sort='.urlencode($_REQUEST['sort']).'&order='.urlencode($_REQUEST['order']));
//Ok..lets roll...create the actual query
$qstr.='&order='.($order=='DESC'?'ASC':'DESC');

$select .= ', count(DISTINCT ticket.ticket_id) as tickets ';

$from .= ' LEFT JOIN '.TICKET_TABLE.' ticket ON (ticket.user_id = user.id) ';


$query="$select $from $where GROUP BY user.id ORDER BY $order_by LIMIT ".$pageNav->getStart().",".$pageNav->getLimit();
//echo $query;

$showing = $search ? __('Search Results').': ' : '';
$res = db_query($query);
if($res && ($num=db_num_rows($res)))
    $showing .= $pageNav->showing();
else
    $showing .= __("This organization doesn't have any users yet");

?>
<div style="width:700px;" class="pull-left"><b><?php echo $showing; ?></b></div>
<div class="pull-right flush-right" style="padding-right:5px;">
    <b><a href="#orgs/<?php echo $org->getId(); ?>/add-user" class="Icon newstaff add-user"
        ><?php echo __('Add User'); ?></a></b>
    |
    <b><a href="#orgs/<?php echo $org->getId(); ?>/import-users" class="add-user">
    <i class="icon-cloud-upload icon-large"></i>
    <?php echo __('Import'); ?></a></b>
</div>
<div class="clear"></div>
<br/>

示例#30

0

显示文件

文件： slaplans.inc.php 项目： KingsleyGU/osticket

$$x=' class="'.strtolower($order).'" ';
$order_by="$order_column $order ";

$total=db_count('SELECT count(*) FROM '.SLA_TABLE.' sla ');
$page=($_GET['p'] && is_numeric($_GET['p']))?$_GET['p']:1;
$pageNav=new Pagenate($total, $page, PAGE_LIMIT);
$qstr = '&amp;'. Http::build_query($qs);
$qs += array('sort' => $_REQUEST['sort'], 'order' => $_REQUEST['order']);

$pageNav->setURL('slas.php', $qs);
//Ok..lets roll...create the actual query
$qstr .= '&amp;order='.($order=='DESC' ? 'ASC' : 'DESC');
$query="$sql ORDER BY $order_by LIMIT ".$pageNav->getStart().",".$pageNav->getLimit();
$res=db_query($query);
if($res && ($num=db_num_rows($res)))
    $showing=$pageNav->showing().' '._N('SLA plan',
        'SLA plans' /* SLA is abbreviation for Service Level Agreement */,
        $total);
else
    $showing=__('No SLA plans found!' /* SLA is abbreviation for Service Level Agreement */);

?>

<div class="pull-left" style="width:700px;padding-top:5px;">
 <h2><?php echo __('Service Level Agreements');?></h2>
</div>
<div class="pull-right flush-right" style="padding-top:5px;padding-right:5px;">
 <b><a href="slas.php?a=add" class="Icon newsla"><?php echo __('Add New SLA Plan');?></a></b></div>
<div class="clear"></div>
<form action="slas.php" method="POST" name="slas">
 <?php csrf_token(); ?>

PHP Pagenate::showing示例