/** * Display a listing of the resource. * * @return Response */ public function index(Request $request, $id) { //总销售金额 $order = new Order(); $_data['sell_total_money'] = $order->newQuery()->whereRaw('`status`>?', array(1))->sum('total_money'); //总订单数 $_data['order_total_cnt'] = $order->newQuery()->count(); //总商品数 $product = new Product(); $_data['product_total_cnt'] = $product->newQuery()->count(); //总用户数 $user = new User(); $_data['user_total_cnt'] = $user->newQuery()->count(); $this->_week_start = $week_start = date("Y-m-d 00:00:00", strtotime("-" . (date("w") - 1) . " days")); //本周销售 $_data['sell_week_money'] = $order->newQuery()->whereRaw('created_at>= ? and `status`>?', array($week_start, 1))->sum('total_money'); //本周订单 $_data['order_week_cnt'] = $order->newQuery()->whereRaw('created_at>= ?', array($week_start))->count(); //本周商品 $_data['product_week_cnt'] = $product->newQuery()->whereRaw('created_at>= ?', array($week_start))->count(); //本周用户 $_data['user_week_cnt'] = $user->newQuery()->whereRaw('created_at>= ?', array($week_start))->count(); $this->_data = $_data; return $this->view('admin.dashboard'); }
public function index() { $order = new Order(); //查找今天订单数 $_data['today_cnt'] = $order->newQuery()->join('order_expresses', 'order_expresses.id', '=', 'orders.id', 'INNER')->whereIn('order_expresses.sid', $this->stores_ids)->whereRaw('date(orders.created_at) = ?', array(date("Y-m-d")))->count() ?: 0; //查找本月订单数 $_data['month_cnt'] = $order->newQuery()->join('order_expresses', 'order_expresses.id', '=', 'orders.id', 'INNER')->whereIn('order_expresses.sid', $this->stores_ids)->whereRaw('left(orders.created_at,7) = ?', array(date("Y-m")))->count() ?: 0; //查找今天收入 $_data['today_income'] = $order->newQuery()->join('order_expresses', 'order_expresses.id', '=', 'orders.id', 'INNER')->whereIn('order_expresses.sid', $this->stores_ids)->whereRaw('date(orders.created_at) = ? and `status`>1', array(date("Y-m-d")))->sum('total_money') ?: 0; //查找本月收入 $_data['month_income'] = $order->newQuery()->join('order_expresses', 'order_expresses.id', '=', 'orders.id', 'INNER')->whereIn('order_expresses.sid', $this->stores_ids)->whereRaw('left(orders.created_at,7) = ? and `status`>1', array(date("Y-m")))->sum('total_money') ?: 0; //最新5个订单 $_data['new_orders'] = $order->newQuery()->with('details')->join('order_expresses', 'order_expresses.id', '=', 'orders.id', 'INNER')->whereIn('order_expresses.sid', $this->stores_ids)->orderBy('orders.created_at', 'desc')->take(5)->get(); $this->_data = $_data; return $this->view('agent-backend.dashborad'); }
public function index() { $order = new Order(); //查找今天订单数 $_data['today_cnt'] = $order->newQuery()->where('fid', $this->factory->getKey())->whereRaw('date(created_at) = ?', array(date("Y-m-d")))->count(); //查找本月订单数 $_data['month_cnt'] = $order->newQuery()->where('fid', $this->factory->getKey())->whereRaw('left(created_at,7) = ?', array(date("Y-m")))->count(); //查找今天收入 $_data['today_income'] = $order->newQuery()->where('fid', $this->factory->getKey())->whereRaw('date(created_at) = ? and `status`>1', array(date("Y-m-d")))->sum('total_money'); //查找本月收入 $_data['month_income'] = $order->newQuery()->where('fid', $this->factory->getKey())->whereRaw('left(created_at,7) = ? and `status`>1', array(date("Y-m")))->sum('total_money'); //最新5个订单 $_data['new_orders'] = $order->newQuery()->with('details')->where('fid', $this->factory->getKey())->orderBy('created_at', 'desc')->take(5)->get(); $this->_data = $_data; return $this->view('factory-backend.dashborad'); }
public function data(Request $request) { $order = new Order(); $builder = $order->newQuery()->with(['order_express'])->where('fid', $this->factory->getKey()); $_builder = clone $builder; $total = $_builder->count(); unset($_builder); $data = $this->_getData($request, $builder); //dd($data); $data['recordsTotal'] = $total; $data['recordsFiltered'] = $data['total']; return $this->success('', FALSE, $data); }
public function data(Request $request) { $order = new Order(); $builder = $order->newQuery()->with(['order_express'])->join('order_expresses', 'order_expresses.id', '=', 'orders.id', 'INNER')->whereIn('order_expresses.sid', $this->stores_ids); $_builder = clone $builder; $total = $_builder->count(); unset($_builder); $data = $this->_getData($request, $builder); //dd($data); $data['recordsTotal'] = $total; $data['recordsFiltered'] = $data['total']; return $this->success('', FALSE, $data); }
public function export(Request $request) { $order = new Order(); $builder = $order->newQuery()->with('details'); $page = $request->input('page') ?: 0; $pagesize = $request->input('pagesize') ?: config('site.pagesize.export', 1000); $total = $this->_getCount($request, $builder); if (empty($page)) { $this->_of = $request->input('of'); $this->_table = $order->getTable(); $this->_total = $total; $this->_pagesize = $pagesize > $total ? $total : $pagesize; return $this->view('agent-backend.order.export'); } $data = $this->_getExport($request, $builder); return $this->success('', FALSE, $data); }