* 订单管理 */ namespace app\ais\controller; use app\ais\controller\Common; use app\ais\model\AisOrder; 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'] = AisOrder::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'] = AisOrder::where($condition)->where(['state' => 1])->count(); $view['user_amount'] = AisOrder::where($condition)->where(['state' => 1])->sum('amount'); $view['order_amount'] = AisOrder::where($condition)->where(['state' => 1])->sum('price'); $view['coupon_price'] = money($view['user_amount'] - $view['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); } }