/**
* 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);
}
