Exemplos de código com Pagenate::getLimit em PHP

Exemplo n.º 1

0

Exibir arquivo

Arquivo: banlist.inc.php Projeto: nunomartins/osTicket-1.7

if ($_REQUEST['order'] && $orderWays[strtoupper($_REQUEST['order'])]) {
    $order = $orderWays[strtoupper($_REQUEST['order'])];
}
$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(DISTINCT rule.id) ' . $from . ' ' . $where);
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, PAGE_LIMIT);
$pageNav->setURL('banlist.php', $qstr . '&sort=' . urlencode($_REQUEST['sort']) . '&order=' . urlencode($_REQUEST['order']));
$qstr .= '&order=' . ($order == 'DESC' ? 'ASC' : 'DESC');
$query = "{$select} {$from} {$where} ORDER BY {$order_by} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
//echo $query;
?>
<h2>Banned Email Addresses</h2>
<div style="width:600; float:left;padding-top:5px;">
    <form action="banlist.php" method="GET" name="filter">
     <input type="hidden" name="a" value="filter" >
     <div>
       Query: <input name="q" type="text" size="20" value="<?php 
echo Format::htmlchars($_REQUEST['q']);
?>
">
        &nbsp;&nbsp;
        <input type="submit" name="submit" value="Search"/>
     </div>
    </form>

Exemplo n.º 2

0

Exibir arquivo

Arquivo: staffmembers.inc.php Projeto: ed00m/osTicket-1.8

    $order = $orderWays[strtoupper($_REQUEST['order'])];
}
$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(DISTINCT staff.staff_id) ' . $from . ' ' . $where);
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, PAGE_LIMIT);
$pageNav->setURL('staff.php', $qstr . '&sort=' . urlencode($_REQUEST['sort']) . '&order=' . urlencode($_REQUEST['order']));
//Ok..lets roll...create the actual query
$qstr .= '&order=' . ($order == 'DESC' ? 'ASC' : 'DESC');
$query = "{$select} {$from} {$where} GROUP BY staff.staff_id ORDER BY {$order_by} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
//echo $query;
?>
<h2>Staff Members</h2>
<div style="width:700px; float:left;">
    <form action="staff.php" method="GET" name="filter">
     <input type="hidden" name="a" value="filter" >
        <select name="did" id="did">
             <option value="0">&mdash; All Departments &mdash;</option>
             <?php 
$sql = 'SELECT dept.dept_id, dept.dept_name,count(staff.staff_id) as users  ' . 'FROM ' . DEPT_TABLE . ' dept ' . 'INNER JOIN ' . STAFF_TABLE . ' staff ON(staff.dept_id=dept.dept_id) ' . 'GROUP By dept.dept_id HAVING users>0 ORDER BY dept_name';
if (($res = db_query($sql)) && db_num_rows($res)) {
    while (list($id, $name, $users) = db_fetch_row($res)) {
        $sel = $_REQUEST['did'] && $_REQUEST['did'] == $id ? 'selected="selected"' : '';
        echo sprintf('<option value="%d" %s>%s (%s)</option>', $id, $sel, $name, $users);
    }

Exemplo n.º 3

0

Exibir arquivo

Arquivo: categories.inc.php Projeto: KingsleyGU/osticket

$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);
$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(); ?>

Exemplo n.º 4

0

Exibir arquivo

Arquivo: dynamic-lists.inc.php Projeto: dmiguel92/osTicket-1.8

echo __('List Name');
?>
</th>
            <th><?php 
echo __('Created');
?>
</th>
            <th><?php 
echo __('Last Updated');
?>
</th>
        </tr>
    </thead>
    <tbody>
    <?php 
foreach (DynamicList::objects()->order_by('-type', 'name')->limit($pageNav->getLimit())->offset($pageNav->getStart()) as $list) {
    $sel = false;
    if ($ids && in_array($form->get('id'), $ids)) {
        $sel = true;
    }
    ?>
        <tr>
            <td>
                <?php 
    if ($list->isDeleteable()) {
        ?>
                <input width="7" type="checkbox" class="ckb" name="ids[]"
                value="<?php 
        echo $list->getId();
        ?>
"

Exemplo n.º 5

0

Exibir arquivo

Arquivo: auditoria.php Projeto: jmangarret/ostickets

<?php 
require 'admin.inc.php';
require STAFFINC_DIR . 'header.inc.php';
$mysqli = new mysqli(DBHOST, DBUSER, DBPASS, DBNAME);
/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit;
}
//Inicio Billy 22/02/2016 Query para traer la cantidad total de registros de la tabla de auditoriavy se creo el objeto de la clase Pagenate
$query = "\tSELECT *\n\t\t\t\tFROM ost_auditoria_limite_credito";
$result = $mysqli->query($query);
$rowcount = mysqli_num_rows($result);
$pageNav = new Pagenate($rowcount, $_GET['p'], PAGE_LIMIT);
//Fin Billy 23/02/2016 Query para traer la cantidad total de registros de la tabla de auditoriavy se creo el objeto de la clase Pagenate
$query = "\tSELECT CONCAT( firstname,  ' ', lastname ) , c.name, a.total, a.disponible, a.date\n\t\t\t\tFROM ost_auditoria_limite_credito a\n\t\t\t\tINNER JOIN ost_staff b ON a.staff_id = b.staff_id\n\t\t\t\tINNER JOIN ost_organization c ON a.org_id = c.id \n\t\t\t\tORDER BY a.date DESC LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
//se agrego el limite para paginar los resultados
$result = $mysqli->query($query);
$rowcount = mysqli_num_rows($result);
//la variable $rowcount contiene el numero de registros obtenidos a partir de la sentencia sql
while ($row = $result->fetch_array()) {
    $rows[] = $row;
}
?>

<script type="text/javascript">
	$("#nav .inactive:eq(5) ul").remove();
	$("#nav .inactive:eq(5)").addClass("active");
	$("#nav .inactive:eq(5)").removeClass("inactive");

	$("#sub_nav").append('<li><a class="users active" href="auditoria.php" title="" id="subnav0">L&iacute;mite de Cr&eacute;dito</a></li>');

Exemplo n.º 6

0

Exibir arquivo

Arquivo: helptopics.inc.php Projeto: pkdevboxy/osTicket-1.7

    $order = $orderWays[strtoupper($_REQUEST['order'])];
}
$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 ' . 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

Exemplo n.º 7

0

Exibir arquivo

Arquivo: emails.inc.php Projeto: KingsleyGU/osticket

$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 '.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;">

Exemplo n.º 8

0

Exibir arquivo

Arquivo: cannedresponses.inc.php Projeto: gizur/osticket

$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 ' . 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

Exemplo n.º 9

0

Exibir arquivo

Arquivo: dynamic-forms.inc.php Projeto: dmiguel92/osTicket-1.8

    <thead>
        <tr>
            <th width="7">&nbsp;</th>
            <th><?php 
echo __('Custom Forms');
?>
</th>
            <th><?php 
echo __('Last Updated');
?>
</th>
        </tr>
    </thead>
    <tbody>
    <?php 
foreach (DynamicForm::objects()->filter(array('type' => 'G'))->order_by('title')->limit($pageNav->getLimit())->offset($pageNav->getStart()) as $form) {
    $sel = false;
    if ($ids && in_array($form->get('id'), $ids)) {
        $sel = true;
    }
    ?>
        <tr>
            <td><?php 
    if ($form->isDeletable()) {
        ?>
                <input type="checkbox" class="ckb" name="ids[]" value="<?php 
        echo $form->get('id');
        ?>
"
                    <?php 
        echo $sel ? 'checked="checked"' : '';

Exemplo n.º 10

0

Exibir arquivo

Arquivo: emails.inc.php Projeto: ryan1432/osTicket-1.7fork

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_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" >

Exemplo n.º 11

0

Exibir arquivo

Arquivo: pages.inc.php Projeto: gizur/osticket

}
$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 ' . 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>

Exemplo n.º 12

0

Exibir arquivo

Arquivo: syslogs.inc.php Projeto: KingsleyGU/OSTicket-Reloaded

    }
    if ($endTime) {
        $qwhere .= ' AND created<=FROM_UNIXTIME(' . $endTime . ')';
        $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>

Exemplo n.º 13

0

Exibir arquivo

Arquivo: slaplans.inc.php Projeto: 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 '.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>

Exemplo n.º 14

0

Exibir arquivo

Arquivo: tickets_20150916.inc.php Projeto: jmangarret/ostickets

        //Joins needed for search
        $qfrom .= ' LEFT JOIN ' . TICKET_THREAD_TABLE . ' thread ON (' . 'ticket.ticket_id=thread.ticket_id AND thread.thread_type IN ("M","R"))';
    }
}
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');

Exemplo n.º 15

0

Exibir arquivo

Arquivo: filters.inc.php Projeto: nicolap/osTicket-1.7

    $order = $orderWays[strtoupper($_REQUEST['order'])];
}
$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 ' . 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);">

Exemplo n.º 16

0

Exibir arquivo

Arquivo: syslogs.inc.php Projeto: KingsleyGU/osticket

    $order_column=str_replace(','," $order,",$order_column);
}
$x=$sort.'_sort';
$$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'); ?>:

Exemplo n.º 17

0

Exibir arquivo

Arquivo: dynamic-lists.inc.php Projeto: KingsleyGU/osticket

<?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'); ?></th>
            <th><?php echo __('Created') ?></th>
            <th><?php echo __('Last Updated'); ?></th>
        </tr>
    </thead>
    <tbody>
    <?php foreach (DynamicList::objects()->order_by('-type', 'name')
                ->limit($pageNav->getLimit())
                ->offset($pageNav->getStart()) as $list) {
            $sel = false;
            if ($ids && in_array($form->get('id'),$ids))
                $sel = true; ?>
        <tr>
            <td>
                <?php
                if ($list->isDeleteable()) { ?>
                <input width="7" type="checkbox" class="ckb" name="ids[]"
                value="<?php echo $list->getId(); ?>"
                    <?php echo $sel?'checked="checked"':''; ?>>
                <?php
                } else {
                    echo '&nbsp;';
                }

Exemplo n.º 18

0

Exibir arquivo

Arquivo: users.tmpl.php Projeto: CarlosAvilesMx/CarlosAviles.Mx

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

$total=db_count('SELECT count(DISTINCT user.id) '.$from.' '.$where);
$page=($_GET['p'] && is_numeric($_GET['p']))?$_GET['p']:1;
$pageNav=new Pagenate($total,$page,PAGE_LIMIT);
$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>
    |

Exemplo n.º 19

0

Exibir arquivo

Arquivo: pages.inc.php Projeto: CarlosAvilesMx/CarlosAviles.Mx

$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 '.PAGE_TABLE.' page '.$where);
$page=($_GET['p'] && is_numeric($_GET['p']))?$_GET['p']:1;
$pageNav=new Pagenate($total, $page, PAGE_LIMIT);
$pageNav->setURL('pages.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 $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'); ?></a></b></div>

Exemplos de Pagenate::getLimit em PHP