PHP Pager::offset方法代码示例

 private function get_results($all = false)
 {
     $archive = Database_Mongo::collection('discrepancies');
     $filters = array();
     if (Arr::get($_GET, 'ticket')) {
         $tickets = array();
         foreach (explode(',', $_GET['ticket']) as $ticket) {
             if (preg_match('/^T1W[0-9]{12}$/', $ticket)) {
                 $tickets[] = $ticket;
             } else {
                 $tickets[] = new MongoRegex('/.*' . $ticket . '.*/i');
             }
         }
         $filters['job_key']['$in'] = $tickets;
     }
     if (Arr::get($_GET, 'file')) {
         $filters['filename'] = $_GET['file'];
     }
     if (Arr::get($_GET, 'start')) {
         $start = strtotime($_GET['start']);
         $filters['update_time']['$gt'] = $start;
     }
     if (isset($filters['end'])) {
         $end = strtotime($_GET['end']);
         $filters['update_time']['$lt'] = $end;
     }
     $result = $archive->find($filters)->sort(array('update_time' => -1, 'job_key' => 1));
     if (!$all) {
         Pager::$count = $result->count();
         $result->skip(Pager::offset())->limit(Pager::limit());
     }
     $list = array();
     $ids = array();
     foreach ($result as $row) {
         $list[] = $row;
         $ids[$row['job_key']] = 1;
     }
     $result = Database_Mongo::collection('jobs')->find(array('_id' => array('$in' => array_keys($ids))));
     $jobs = array();
     foreach ($result as $job) {
         $jobs[$job['_id']] = Arr::get($job, 'data');
     }
     $items = array();
     foreach ($list as $row) {
         $row['data'] = array_intersect_key($row['data'], Columns::get_visible());
         $row['current'] = array();
         $row['discr'] = 1;
         foreach ($row['data'] as $key => $value) {
             $row['current'][$key] = Arr::path($jobs, array($row['job_key'], $key));
             if ($row['current'][$key] != $value['old_value']) {
                 $row['discr'] = 0;
             }
         }
         foreach (Columns::get_static() as $static => $show) {
             $row['static'][$static] = Arr::path($jobs, array($row['job_key'], $static));
         }
         $items[] = $row;
     }
     return $items;
 }

 public function action_index()
 {
     $id = strval(Arr::get($_GET, 'ticket'));
     if (!$id) {
         throw new HTTP_Exception_404('Not found');
     }
     $filter = array('_id' => $id);
     if (!Group::current('allow_assign')) {
         $filter['$or'] = array(array('companies' => intval(User::current('company_id'))), array('ex' => intval(User::current('company_id'))));
     }
     $job = Database_Mongo::collection('jobs')->findOne($filter);
     if (!$job) {
         throw new HTTP_Exception_404('Not found');
     }
     $filter = array('job_key' => $id);
     if (!Group::current('allow_assign')) {
         $filter['user_id'] = array('$in' => DB::select('id')->from('users')->where('company_id', '=', User::current('company_id'))->execute()->as_array(NULL, 'id'));
     }
     $result = Database_Mongo::collection('submissions')->find($filter)->sort(array('update_time' => -1));
     Pager::$count = $result->count(true);
     $result->limit(Pager::limit())->skip(Pager::offset());
     $submissions = array();
     $users = array();
     while ($row = $result->next()) {
         $users[$row['user_id']] = 1;
         $submissions[] = $row;
     }
     if ($users) {
         User::get(array_keys($users));
     }
     $companies = DB::select('id', 'name')->from('companies')->execute()->as_array('id', 'name');
     $view = View::factory('Jobs/Submissions');
     $view->bind('submissions', $submissions)->bind('companies', $companies)->bind('job', $job);
     $this->response->body($view);
 }

 public function action_index()
 {
     $id = strval(Arr::get($_GET, 'ticket'));
     if (!$id) {
         throw new HTTP_Exception_404('Not found');
     }
     Pager::$count = DB::select(DB::expr('COUNT(*) as cnt'))->from('assign_log')->where('job_id', '=', $id)->execute()->get('cnt');
     $result = DB::select()->from('assign_log')->where('job_id', '=', $id)->order_by('time', 'desc')->offset(Pager::offset())->limit(Pager::limit())->execute()->as_array();
     $users = array();
     foreach ($result as $row) {
         $users[$row['user_id']] = 1;
     }
     if ($users) {
         User::get(array_keys($users));
     }
     $companies = DB::select('id', 'name')->from('companies')->execute()->as_array('id', 'name');
     $types = DB::select('id', 'name')->from('job_types')->execute()->as_array('id', 'name');
     $view = View::factory('Jobs/Assign');
     $view->bind('list', $result)->bind('types', $types)->bind('companies', $companies);
     $this->response->body($view);
 }

<?php

/**
 * 发送成功列表
 * @author 潘洪学 panliu888@gmail.com
 * @create_date	2011-10
 */
include_once dirname(__FILE__) . DIRECTORY_SEPARATOR . 'init.php';
Passport::RequireLogin();
$task = new Task();
switch (strtolower($_GET['action'])) {
    case 'del':
        $task->UpdateStatus(Task::DELETE_OK, intval($_GET['id']), '已取消');
        break;
    case 'clear':
        $task->update(array('status' => Task::DELETE_OK, 'msg' => '被清空'), array('uid' => Passport::GetLoginUid(), 'status' => Task::OK));
        redirect('?');
        break;
}
$pager = new Pager($task->GetCount(Task::OK), 20);
$TEMPLATE['list'] = $task->GetList(Task::OK, $pager->offset());
$TEMPLATE['pager'] = $pager->render();
$TEMPLATE['title'] = '已发送';
$TEMPLATE['login_name'] = Passport::GetLoginName();
$TEMPLATE['nav']['list_ok'] = 'current';
$smarty = new Template();
echo $smarty->r('list_ok');

 private function get_results($hidden)
 {
     $filters = array();
     if (Arr::get($_GET, 'ticket')) {
         $filters['ticket'] = $_GET['ticket'];
     }
     if (Arr::get($_GET, 'file')) {
         $filters['file'] = $_GET['file'];
     }
     if (Arr::get($_GET, 'start')) {
         $filters['start'] = strtotime($_GET['start']);
     }
     if (Arr::get($_GET, 'end')) {
         $filters['end'] = strtotime($_GET['end']);
     }
     $count = DB::select(DB::expr("COUNT(id) as cnt"))->from('defects_archive');
     $result = DB::select()->from('defects_archive');
     if (isset($filters['ticket'])) {
         $count->where('Id', '=', $filters['ticket']);
         $result->where('Id', '=', $filters['ticket']);
     }
     if (isset($filters['file'])) {
         $count->where('filename', '=', $filters['file']);
         $result->where('filename', '=', $filters['file']);
     }
     if (isset($filters['start'])) {
         $count->where('update_time', '>', date('Y-m-d H:i:s', $filters['start']));
         $result->where('update_time', '>', date('Y-m-d H:i:s', $filters['start']));
     }
     if (isset($filters['end'])) {
         $count->where('update_time', '<', date('Y-m-d H:i:s', $filters['end']));
         $result->where('update_time', '<', date('Y-m-d H:i:s', $filters['end']));
     }
     if (Arr::get($_GET, 'action')) {
         $count->where('update_type', '=', $_GET['action']);
         $result->where('update_type', '=', $_GET['action']);
     }
     $count = $count->execute()->get('cnt');
     Pager::$count = $count;
     $result->offset(Pager::offset())->limit(Pager::limit())->order_by('Id', 'asc');
     $result = $result->execute()->as_array();
     $ids = array();
     foreach ($result as $id => $ticket) {
         if ($ticket['update_type'] == 2) {
             $ids[$ticket['Id']] = 1;
         }
     }
     if ($ids) {
         $res = DB::select('key', 'Id', 'update_time', 'update_type')->from('defects_archive')->where('Id', 'IN', array_keys($ids))->execute();
         $history = array();
         while ($row = $res->current()) {
             if (isset($history[$row['Id']])) {
                 $history[$row['Id']][] = $row;
             } else {
                 $history[$row['Id']] = array($row);
             }
             $res->next();
         }
         $ids = array();
         foreach ($result as $id => $ticket) {
             if ($ticket['update_type'] == 2 && isset($history[$ticket['Id']])) {
                 $max_date = 0;
                 $max_id = 0;
                 foreach ($history[$ticket['Id']] as $item) {
                     if ($item['update_type'] < 3) {
                         if ($item['update_time'] < $ticket['update_time'] && $item['update_time'] > $max_date) {
                             $max_date = $item['update_time'];
                             $max_id = $item['key'];
                         }
                     }
                 }
                 if ($max_id) {
                     $ids[$id] = $max_id;
                 }
             }
         }
         $res = DB::select()->from('defects_archive')->where('key', 'IN', array_values($ids))->execute()->as_array('key');
         foreach ($result as $id => $ticket) {
             if ($ticket['update_type'] == 2) {
                 $result[$id]['diff'] = array();
             }
         }
         foreach ($ids as $id => $key) {
             if (isset($res[$key])) {
                 $old = $res[$key];
                 $diff = array_diff_assoc($old, $result[$id]);
                 unset($diff['key']);
                 unset($diff['update_time']);
                 unset($diff['update_type']);
                 unset($diff['filename']);
                 $result[$id]['diff'] = array();
                 $result[$id]['hidden'] = array();
                 foreach ($diff as $key => $value) {
                     if (isset($hidden[$key])) {
                         $result[$id]['hidden'][$key] = $value;
                     } else {
                         $result[$id]['diff'][$key] = $value;
                     }
                 }
             }
//.........这里部分代码省略.........

 public function action_uploads()
 {
     $id = $this->request->param('id');
     Pager::$count = DB::select(DB::expr('COUNT(*) as cnt'))->from('upload_log')->where('job_id', '=', $id)->execute()->get('cnt');
     $result = DB::select()->from('upload_log')->where('job_id', '=', $id)->order_by('uploaded', 'desc')->offset(Pager::offset())->limit(Pager::limit())->execute()->as_array();
     $users = array();
     foreach ($result as $log) {
         $users[$log['user_id']] = 1;
     }
     User::get(array_keys($users));
     $companies = DB::select('id', 'name')->from('companies')->execute()->as_array('id', 'name');
     $view = View::factory('Jobs/UploadLog')->bind('logs', $result)->bind('companies', $companies);
     $this->response->body($view);
 }

//.........这里部分代码省略.........
     $list_values = array();
     foreach (Columns::get_search() as $key => $value) {
         if ($value == 2) {
             $list_values[$key] = $jobs->distinct('data.' . $key, $query ?: NULL) ?: array();
             if (substr(Columns::get_type($key), 0, 4) == 'enum') {
                 $list = array();
                 foreach ($list_values[$key] as $values) {
                     if ($values) {
                         $values = explode(', ', $values);
                         foreach ($values as $value) {
                             $list[$value] = 1;
                         }
                     } else {
                         $list[''] = 1;
                     }
                 }
                 $list_values[$key] = array_keys($list);
             }
             if ($list_values[$key]) {
                 sort($list_values[$key]);
             }
         }
     }
     Pager::$count = $jobs->count($query);
     $show = array('region' => 1, 'status' => 1, 'created' => 1, 'last_update' => 1, 'last_submit' => 1, 'assigned' => 1, 'companies' => 1, 'ex' => 1);
     foreach (Columns::$settings as $key => $value) {
         $show[$key] = 1;
     }
     foreach (Columns::get_search() as $column => $type) {
         $show['data.' . $column] = 1;
     }
     $result = $jobs->find($query, $show);
     $sort = Arr::get($_GET, 'sort');
     if (is_array($sort)) {
         $save = implode('|', $sort);
         DB::update('users')->set(array('default_sort' => $save))->where('id', '=', User::current('id'))->execute();
     } else {
         $sort = explode('|', User::current('default_sort') ?: '-update');
         $_GET['sort'] = $sort;
     }
     $sorting = array();
     foreach ($sort as $order) {
         $dir = substr($order, 0, 1) == '-' ? -1 : 1;
         $order = substr($order, 1);
         switch ($order) {
             case 'id':
                 $order = '_id';
                 break;
             case 'update':
                 $order = 'last_update';
                 break;
             case 'submit':
                 $order = 'last_submit';
                 break;
             case 'status':
                 $order = 'status';
                 break;
             case 'data-8':
                 $sorting['address'] = $dir;
                 $order = false;
                 break;
             default:
                 if (substr($order, 0, 5) == 'data-') {
                     $order = 'data.' . intval(substr($order, 5));
                 } else {
                     $order = false;
                 }
         }
         if ($order) {
             $sorting[$order] = $dir;
         }
     }
     $result->sort($sorting)->limit(Pager::limit())->skip(Pager::offset());
     $tickets = array();
     while ($row = $result->next()) {
         $tickets[] = $row;
     }
     $ids = array_column($tickets, '_id');
     $types = DB::select('id', 'name')->from('job_types')->execute()->as_array('id', 'name');
     $companies = DB::select('id', 'name')->from('companies')->execute()->as_array('id', 'name');
     if ($ids) {
         $attachments = DB::select('job_id', DB::expr('COUNT(*) as cnt'))->from('attachments')->where('job_id', 'IN', $ids)->and_where('uploaded', '>', 0)->and_where('folder', '<>', 'Signatures')->group_by('job_id')->execute()->as_array('job_id', 'cnt');
     } else {
         $attachments = array();
     }
     if (Group::current('allow_assign')) {
         $result = Database_Mongo::collection('submissions')->aggregate(array(array('$match' => array('job_key' => array('$in' => $ids), 'active' => 1)), array('$group' => array('_id' => '$job_key', 'count' => array('$sum' => 1)))));
         $submissions = array();
         foreach (Arr::get($result, 'result', array()) as $value) {
             $submissions[$value['_id']] = $value['count'];
         }
     }
     $result = Database_Mongo::collection('forms')->find(array(), array('_id' => 1, 'type' => 1, 'name' => 1));
     $forms = array();
     foreach ($result as $form) {
         $forms[$form['type']][strval($form['_id'])] = $form['name'];
     }
     $view = View::factory('Jobs/Search')->bind('reports', $reports)->bind('regions', $regions)->bind('columns', $columns)->bind('actions', $actions)->bind('tickets', $tickets)->bind('submissions', $submissions)->bind('attachments', $attachments)->bind('list_values', $list_values)->bind('types', $types)->bind('sort', $sort)->bind('companies', $companies)->bind('forms', $forms)->bind('query', $query);
     $this->response->body($view);
 }

 public function action_export()
 {
     if (!User::current('is_admin')) {
         throw new HTTP_Exception_403('Forbidden');
     }
     $projects = DB::select('id', DB::expr('CONCAT(`client_code`, \' \', name) as name'))->from('projects')->execute()->as_array('id', 'name');
     $suppliers = DB::select('id', 'name')->from('suppliers')->execute()->as_array('id', 'name');
     $companies = DB::select('id', 'name')->from('companies')->execute()->as_array('id', 'name');
     $prefixes = DB::select('id', 'prefix')->from('companies')->execute()->as_array('id', 'prefix');
     $items = DB::select('id', 'name')->from('items')->execute()->as_array('id', 'name');
     $count = DB::select(DB::expr('COUNT(*) as cnt'))->from('orders');
     $list = DB::select('id', 'company_id', 'user_id', 'address_id', 'supplier_id', 'project_id', 'total', 'created', 'last_update', 'instruction', 'delivery', 'final_items')->from('orders')->order_by('last_update', 'DESC');
     if (isset($_GET['all'])) {
         $list = $list->execute()->as_array();
     } else {
         Pager::$count = $count->execute()->get('cnt');
         $list = $list->offset(Pager::offset())->limit(Pager::limit())->execute()->as_array();
     }
     $users = array();
     $ids = array();
     foreach ($list as $item) {
         if (!$item['final_items']) {
             $ids[$item['id']] = 1;
         }
         $users[$item['user_id']] = 1;
     }
     if ($users) {
         User::get(array_keys($users));
     }
     $order_items = array();
     if ($ids) {
         $result = DB::select('order_id', 'item_id', 'qty')->from('order_items')->where('order_id', 'IN', array_keys($ids))->execute();
         foreach ($result as $item) {
             $order_items[$item['order_id']][$item['item_id']] = $item['qty'];
         }
     }
     $data = array(array('Order Number', 'Company', 'User', 'Supplier', 'Project', 'Items', 'Total', 'Created', 'Last Update'));
     foreach ($list as $order) {
         $items_list = array();
         if ($order['final_items']) {
             $values = json_decode($order['final_items'], true);
             foreach ($values as $item) {
                 $items_list[] = $item['qty'] . ' x ' . $item['name'];
             }
         } else {
             foreach (Arr::get($order_items, $order['id'], array()) as $key => $value) {
                 $items_list[] = $value . ' x ' . Arr::get($items, $key, 'Unknown');
             }
         }
         $data[] = array(Arr::get($prefixes, $order['company_id'], '') . str_pad($order['id'], 5, '0', STR_PAD_LEFT), Arr::get($companies, $order['company_id'], 0), User::get(Arr::get($order, 'user_id', User::current('id')), 'name') ?: User::get(Arr::get($order, 'user_id', User::current('id')), 'login'), Arr::get($suppliers, $order['supplier_id'], 0), Arr::get($projects, $order['project_id'], 0), implode("\n", $items_list), number_format($order['total'], 2), date('d-m-Y H:i', $order['created']), date('d-m-Y H:i', $order['last_update']));
     }
     $excel = new PHPExcel();
     $sheet = $excel->getActiveSheet();
     $sheet->setTitle('Purchase Orders');
     $sheet->fromArray($data, NULL, 'A1');
     $sheet->getStyleByColumnAndRow(0, 1, 8, 1)->getFont()->setBold(true);
     //die();
     $sheet->freezePane('A2');
     foreach (range('A', $sheet->getHighestDataColumn()) as $col) {
         $sheet->getColumnDimension($col)->setAutoSize(true);
     }
     $name = tempnam(sys_get_temp_dir(), 'excel');
     header('Content-type: application/xlsx');
     header('Content-disposition: filename="Purchase Orders.xlsx"');
     $writer = new PHPExcel_Writer_Excel2007($excel);
     $writer->save($name);
     readfile($name);
     unlink($name);
     die;
 }

 public function action_index()
 {
     $tables = DB::select()->from('reports')->execute()->as_array('id', 'name');
     $geo = false;
     $attachments = false;
     if ($_POST) {
         $id = intval(Arr::get($_POST, 'id'));
         if (!isset($tables[$id])) {
             throw new HTTP_Exception_404('Not found');
         }
         $query = array('report_id' => $id);
         if (!Group::current('show_all_jobs')) {
             $query['company'] = User::current('company_id');
         }
         $columns = DB::select('id', 'name', 'type', 'visible')->from('report_columns')->where('report_id', '=', $query['report_id'])->and_where('visible', '<>', 'hidden')->execute()->as_array('id');
         foreach ($columns as $column) {
             if (isset($_POST[$column['id']])) {
                 $key = $column['id'];
                 $type = $column['type'];
                 if (isset($_POST[$key]['from'])) {
                     $query[$key]['$gte'] = Columns::parse($_POST[$key]['from'], $type);
                 }
                 if (isset($_POST[$key]['to'])) {
                     $query[$key]['$lte'] = Columns::parse($_POST[$key]['to'], $type);
                 }
                 if (isset($_POST[$key]['value'])) {
                     $values = explode('|', $_POST[$key]['value']);
                     foreach ($values as $value) {
                         if ($value) {
                             $query[$key]['$in'][] = new MongoRegex('/' . $value . '/i');
                         }
                     }
                 }
             }
         }
         $query['expires'] = time() + 3600;
         Database_Mongo::collection('search')->insert($query);
         header('Content-type: application/json');
         die(json_encode(array('success' => true, 'id' => strval($query['_id']))));
     } elseif (Arr::get($_GET, 'id')) {
         $query = Database_Mongo::collection('search')->findOne(array('_id' => new MongoId($_GET['id'])));
         if (!$query) {
             $this->redirect('reports/forms');
         }
         $columns = DB::select('id', 'name', 'type', 'visible')->from('report_columns')->where('report_id', '=', $query['report_id'])->and_where('visible', '<>', 'hidden')->execute()->as_array('id');
         unset($query['_id']);
         unset($query['expires']);
         $result = Database_Mongo::collection('reports')->find($query);
         Pager::$count = $result->count();
         $result->skip(Pager::offset())->limit(Pager::limit());
         $reports = array();
         foreach ($result as $report) {
             $id = strval($report['_id']);
             $data = array('id' => $id, 'attachment' => Arr::get($report, 'attachment', 'Unknown file'), 'attachment_id' => Arr::get($report, 'attachment_id', 0), 'colors' => Arr::get($report, 'colors', array()));
             foreach ($columns as $key => $column) {
                 $data[$key] = Arr::get($report, $key, '');
             }
             if (isset($report['geo'])) {
                 $geo = true;
                 $data['geo'] = $report['geo'];
             }
             if (Arr::get($report, 'attachments')) {
                 $attachments = true;
                 $data['attachments'] = $report['attachments'];
             }
             $reports[$id] = $data;
         }
         if (isset($_GET['export'])) {
             $header = array('Name');
             foreach ($columns as $column) {
                 $header[] = $column['name'];
             }
             $data = array($header);
             $ids = isset($_GET['ids']) && !isset($_GET['all']) ? array_flip(explode(',', $_GET['ids'])) : array();
             foreach ($reports as $report) {
                 if (!$ids || isset($ids[$report['attachment_id']])) {
                     $row = array($report['attachment']);
                     foreach ($columns as $column) {
                         $row[] = Arr::get($report, $column['id']) ? Columns::output($report[$column['id']], $column['type'], true) : '';
                     }
                     $data[] = $row;
                 }
             }
             switch ($_GET['export']) {
                 case 'excel':
                     $excel = new PHPExcel();
                     $sheet = $excel->getActiveSheet();
                     $sheet->setTitle('Search Results');
                     $sheet->fromArray($data, NULL, 'A1');
                     foreach (range('A', $sheet->getHighestDataColumn()) as $col) {
                         $sheet->getColumnDimension($col)->setAutoSize(true);
                     }
                     $name = tempnam(sys_get_temp_dir(), 'excel');
                     header('Content-type: application/xlsx');
                     header('Content-disposition: filename="' . Arr::get($tables, $query['report_id'], 'Unknown') . '.xlsx"');
                     $writer = new PHPExcel_Writer_Excel2007($excel);
                     $writer->save($name);
                     readfile($name);
                     unlink($name);
                     break;
//.........这里部分代码省略.........