public function lists()
 {
     $page = intval(Input::get('page', 1));
     $username = trim(Input::get('username', ''));
     $args = ['username' => $username];
     $model = new AdminModel();
     $count = $model->getCount($args);
     $rows = $model->getRows($page, $args);
     $page_size = Pagination::getPageSize($count);
     return View::make('admin.lists', ['rows' => $rows, 'page' => $page, 'page_size' => $page_size, 'params' => $args]);
 }
 public function lists()
 {
     $page = intval(Input::get('page', 1));
     $start_time = Input::get('start_time', '');
     $expire = Input::get('expire', '');
     $args = ['start_time' => $start_time, 'expire' => $expire];
     $model = new ActivityModel();
     $count = $model->getCount($args);
     $rows = $model->getRows($page, $args);
     $page_size = Pagination::getPageSize($count);
     return View::make('activity.lists', ['rows' => $rows, 'page' => $page, 'page_size' => $page_size, 'params' => $args]);
 }
 public function lists()
 {
     $page = intval(Input::get('page', 1));
     $class = intval(Input::get('class', 0));
     $sql = "SELECT t.*, ts.source FROM template as t LEFT JOIN template_source as ts ON ts.template_id = t.id WHERE ts.is_front=" . BaseORM::ENABLE;
     $sql1 = "SELECT count(*) as total FROM template as t WHERE 1";
     if (!empty($class)) {
         $sql .= ' AND t.class=' . $class;
         $sql1 .= ' AND t.class=' . $class;
     }
     $count = DB::select(DB::raw($sql1));
     $sql .= " ORDER BY t.id DESC LIMIT " . ($page - 1) * BaseORM::TAKE . "," . BaseORM::TAKE;
     $rows = DB::select(DB::raw($sql));
     $count = $count[0]->total;
     $page_size = Pagination::getPageSize($count, BaseORM::TAKE);
     //获得所有分类
     $classes = TemplateClassORM::all();
     array_ch_key('id', $classes);
     $format_classes = array_ch_key('id', $classes);
     return View::make('template.lists', ['rows' => $rows, 'page' => $page, 'page_size' => $page_size, 'classes' => $format_classes, 'params' => ['class' => $class]]);
 }
 public function lists()
 {
     $page = intval(Input::get('page', 1));
     $mobile = trim(Input::get('mobile', ''));
     $status = intval(Input::get('status', -1));
     $pay_status = intval(Input::get('pay_status', -1));
     $user_id = 0;
     if (!empty($mobile)) {
         $user = UserORM::whereMobile($mobile)->first();
         if (!empty($user)) {
             $user_id = $user->id;
         } else {
             Session::flash('error', '用户未找到');
             return Redirect::route('orderLists');
         }
     }
     $sql = "SELECT o.*, u.real_name, u.address, u.mobile FROM orders as o LEFT JOIN user as u ON u.id = o.user_id WHERE 1";
     $sql1 = "SELECT count(*) as total FROM orders as o WHERE 1";
     if (!empty($user_id)) {
         $sql .= " AND o.user_id = {$user_id}";
         $sql1 .= " AND o.user_id = {$user_id}";
     }
     if ($status != -1) {
         $sql .= " AND o.status = {$status}";
         $sql1 .= " AND o.status = {$status}";
     }
     if ($pay_status != -1) {
         $sql .= " AND o.pay_status = {$pay_status}";
         $sql1 .= " AND o.pay_status = {$pay_status}";
     }
     $count = DB::select(DB::raw($sql1));
     $sql .= " ORDER BY o.id DESC LIMIT " . ($page - 1) * BaseORM::TAKE . "," . BaseORM::TAKE;
     $rows = DB::select(DB::raw($sql));
     $count = $count[0]->total;
     $page_size = Pagination::getPageSize($count, BaseORM::TAKE);
     return View::make('order.lists', ['rows' => $rows, 'page' => $page, 'page_size' => $page_size, 'params' => ['mobile' => $mobile, 'status' => $status, 'pay_status' => $pay_status]]);
 }
 public function lists()
 {
     $page = intval(Input::get('page', 1));
     $mobile = trim(Input::get('mobile', ''));
     $class = intval(Input::get('class', 0));
     $search_user_id = 0;
     if (!empty($mobile)) {
         $user = UserORM::whereMobile($mobile)->first();
         if (empty($user)) {
             Session::flash('error', '用户未找到');
             return Redirect::route('albumLists');
         } else {
             $search_user_id = $user->id;
         }
     }
     $sql = "SELECT a.*, u.mobile, u.real_name, u.address FROM album as a LEFT JOIN user as u ON u.id = a.user_id WHERE 1";
     $sql1 = "SELECT count(*) as total FROM album as a WHERE 1";
     if (!empty($search_user_id)) {
         $sql .= " AND a.user_id = {$search_user_id}";
         $sql1 .= " AND a.user_id = {$search_user_id}";
     }
     if (!empty($class)) {
         $sql .= " AND a.class = {$class}";
         $sql1 .= " AND a.class = {$class}";
     }
     $count = DB::select(DB::raw($sql1));
     $sql .= " ORDER BY a.id DESC LIMIT " . ($page - 1) * BaseORM::TAKE . "," . BaseORM::TAKE;
     $rows = DB::select(DB::raw($sql));
     $count = $count[0]->total;
     $page_size = Pagination::getPageSize($count, BaseORM::TAKE);
     //获得所有分类
     $classes = TemplateClassORM::all();
     array_ch_key('id', $classes);
     $format_classes = array_ch_key('id', $classes);
     return View::make('album.lists', ['rows' => $rows, 'page' => $page, 'page_size' => $page_size, 'params' => ['mobile' => $mobile, 'class' => $class], 'classes' => $format_classes]);
 }
Example #6
0
 /**
  * Lists all schemata.
  */
 public function actionList()
 {
     // Create list for sideBar usage
     if ($this->request->getParam('sideBar')) {
         $schemata = array();
         foreach (Schema::model()->findAll() as $schema) {
             $schemata[] = $schema->SCHEMA_NAME;
         }
         $this->sendJSON($schemata);
     } else {
         $criteria = new CDbCriteria();
         // Pagination
         $pages = new Pagination(Schema::model()->count($criteria));
         $pages->setupPageSize('pageSize', 'schemata');
         $pages->applyLimit($criteria);
         $pages->route = '#schemata';
         // Sort
         $sort = new CSort('Schema');
         $sort->attributes = array('name' => 'SCHEMA_NAME', 'tableCount' => 'tableCount', 'collation' => 'DEFAULT_COLLATION_NAME');
         $sort->defaultOrder = 'SCHEMA_NAME ASC';
         $sort->route = '#schemata';
         $sort->applyOrder($criteria);
         $criteria->group = 'SCHEMA_NAME';
         $criteria->select = 'SCHEMA_NAME, DEFAULT_COLLATION_NAME, COUNT(*) AS tableCount';
         $schemaList = Schema::model()->with(array('tables' => array('select' => 'COUNT(tables.TABLE_NAME) AS tableCount')))->together()->findAll($criteria);
         $this->render('list', array('schemaList' => $schemaList, 'schemaCount' => $pages->getItemCount(), 'schemaCountThisPage' => min($pages->getPageSize(), $pages->getItemCount() - $pages->getCurrentPage() * $pages->getPageSize()), 'pages' => $pages, 'sort' => $sort));
     }
 }