* 订单管理 */ namespace app\allwin\controller; use app\allwin\controller\Common; use app\allwin\model\Order as orders; use think\facade\Request; use think\helper\Time; class Order extends Common{ public function initialize() { parent::initialize(); $this->assign('pathMaps', [['name'=>'买单帐单','url'=>url("order/index")]]); } /** * 应用管理首页 * @access public */ public function Index(int $state = 1){ $condition = []; $condition[] = ['member_miniapp_id','=',$this->member_miniapp_id]; $store_id = Request::param('store_id/d',''); $store_name = Request::param('store_name'); if($store_id){ $condition[] = ['store_id','=',$store_id]; } $time = Request::param('time/d',0); if($time){ switch ($time) { case 2: list($start, $end) = Time::yesterday(); break; case 30: list($start, $end) = Time::month(); break; case 60: list($start, $end) = Time::lastMonth(); break; default: list($start, $end) = Time::today(); break; } $condition[] = ['paid_time','>=',$start]; $condition[] = ['paid_time','<=',$end]; } $starttime = Request::param('starttime/s'); $endtime = Request::param('endtime/s'); if($starttime){ $condition[] = ['paid_time','>=',strtotime($starttime)]; } if($endtime){ $condition[] = ['paid_time','<=',strtotime($endtime)]; } $view['orders'] = Orders::where($condition)->where(['state' => $state ? 1: 0])->order('id desc')->paginate(20,false,['query'=> ['store_id'=>$store_id,'store_name'=>$store_name,'time' => $time,'starttime' => $starttime,'endtime' => $endtime]]); $view['order_num'] = Orders::where($condition)->where(['state' => 1])->count(); $view['user_amount'] = Orders::where($condition)->where(['state' => 1])->sum('user_amount'); $view['coupon_price'] = Orders::where($condition)->where(['state' => 1])->sum('coupon_price'); $view['platform_amount'] = Orders::where($condition)->where(['state' => 1])->sum('platform_amount'); $view['store_amount'] = Orders::where($condition)->where(['state' => 1])->sum('store_amount'); $view['order_amount'] = Orders::where($condition)->where(['state' => 1])->sum('order_amount'); $view['time'] = $time; $view['starttime'] = $starttime; $view['endtime'] = $endtime; $view['store_id'] = $store_id; $view['store_name'] = $store_name; return view()->assign($view); } }