game-box/application/allwin/controller/Order.php

<?php
/**
 * @copyright   Copyright (c) 2017 https://www.sapixx.com All rights reserved.
 * @license     Licensed (http://www.apache.org/licenses/LICENSE-2.0).
 * @author      pillar<ltmn@qq.com>
 * 订单管理
 */
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);
    }    
}