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]); }