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