<?php

namespace app\common\model\branch;

use app\common\enum\order\OrderPayStatusEnum;
use app\common\model\BaseModel;
use app\shop\model\order\Order as OrderModel;
use app\shop\model\user\User as UserModel;
use app\shop\service\order\ExportService;

/**
 * 参与活动的下单记录模型
 * @property int $id
 * @property int $activity_id 活动id
 * @property int $order_id 订单id
 * @property int $app_id 小程序id
 * @property int $shop_supplier_id 商户id
 * @property string $create_time 创建时间
 * @property string $update_time 更新时间
 */
class ActivityOrder extends BaseModel
{
    protected $name = 'branch_activity_order';
    protected $pk = 'id';

    /**
     * 订单列表
     */
    public  function getList($params=[])
    {
        $order_model = new OrderModel();
        //搜索时间段
        if (isset($params['create_time']) && $params['create_time'] != '') {
            $params['start_time'] = strtotime(array_shift($params['create_time'])) ;
            $params['end_time'] = strtotime(array_pop($params['create_time']));
        }
        $list = $order_model->alias('order')
            ->join('user', 'user.user_id=order.user_id')
            ->with(['product' => ['image', 'refund'], 'user', 'supplier', 'advance','address','extractStore'])
            ->where('order.is_delete', '=', 0)
            ->where($this->transferDataType($params['dataType']))
            ->where('salesactivity_id','=',$params['activity_id'])
            ->when(isset($params['shop_supplier_id']) && $params['shop_supplier_id']!=='',function($query) use($params){
                $query->where('order.shop_supplier_id','=',$params['shop_supplier_id']);
            })
            ->when(isset($params['search']) && $params['search'],function($query) use($params){
                $query->where('user.user_id|user.nickName|user.mobile', 'like', '%' . $params['search'] . '%');
            })
            ->when(isset($params['style_id']) && $params['style_id']!=='',function($query) use($params){
                $query->where('order.delivery_type', '=', $params['style_id']);
            })
            ->when(isset($params['order_no']) && $params['order_no'],function($query) use($params){
                $query->where('order_no', 'like', '%' . trim($params['order_no']) . '%');
            })
            ->when(isset($params['start_time']) && empty($params['end_time']), function($query) use ($params) {
                $query->where('order.create_time', '>=', $params['start_time']);
            })
            ->when(isset($params['end_time']) && empty($params['start_time']), function($query) use ($params) {
                $query->where('order.create_time', '<=', $params['end_time']);
            })
            ->when(isset($params['end_time']) && !empty($params['start_time']), function($query) use ($params) {
                $query->whereBetween('order.create_time',[$params['start_time'],$params['end_time']]);
            })->field('order.*')->order('create_time desc')->paginate($params);

        if(!empty($list)){
            foreach ($list as &$v){
                $product = $v['product'];
                $product = $product->toArray();
                $v['product_price_total'] = array_sum(array_column($product, 'total_price'));
                if(!empty($v["user"]["referee_id"])){
                    $v["referee_user"] = UserModel::detail($v["user"]["referee_id"]);
                }
                $v["pay_time_text"] = empty($v["pay_time"]) ? '' : date("Y-m-d H:i:s",$v["pay_time"]);
                $v["receipt_time_text"] = empty($v["receipt_time"]) ? '' : date("Y-m-d H:i:s",$v["receipt_time"]);
                $v["auto_receipt_time_text"] = empty($v["auto_receipt_time"]) ? '' : date("Y-m-d H:i:s",$v["auto_receipt_time"]);
            }
        }

        return $list;
    }

    /**
     * 订单列表(全部)
     */
    public function getListAll($dataType, $params = [])
    {
        //搜索时间段
        if (isset($params['create_time']) && $params['create_time'] != '') {
            $params['start_time'] = array_shift($params['create_time']);
            $params['end_time'] = array_pop($params['create_time']);
        }
        $order_model = new OrderModel();
        $list = $order_model->alias('order')
            ->join('user', 'user.user_id=order.user_id')
            ->with(['product' => ['image', 'refund'], 'user', 'supplier', 'advance','address','extractStore'])
            ->where('order.is_delete', '=', 0)
            ->where('salesactivity_id','=',$params['activity_id'])
            ->when(isset($params['shop_supplier_id']) && $params['shop_supplier_id']!=='',function($query) use($params){
                $query->where('order.shop_supplier_id','=',$params['shop_supplier_id']);
            })
            ->when(isset($params['search']) && $params['search'],function($query) use($params){
                $query->where('user.user_id|user.nickName|user.mobile', 'like', '%' . $params['search'] . '%');
            })
            ->when(isset($params['style_id']) && $params['style_id']!=='',function($query) use($params){
                $query->where('order.delivery_type', '=', $params['style_id']);
            })
            ->when(isset($params['order_no']) && $params['order_no'],function($query) use($params){
                $query->where('order_no', 'like', '%' . trim($params['order_no']) . '%');
            })
            ->when(!empty($params['start_time']) && empty($params['end_time']), function($query) use ($params) {
                $query->where('order.create_time', '>=', $params['start_time']);
            })
            ->when(!empty($params['end_time']) && empty($params['start_time']), function($query) use ($params) {
                $query->where('order.create_time', '<=', $params['end_time']);
            })
            ->when(!empty($params['end_time']) && !empty($params['start_time']), function($query) use ($params) {
                $query->whereBetween('order.create_time',[$params['start_time'],$params['end_time']]);
            })->field('order.*')->select();
        if(!empty($list)){
            foreach ($list as &$v){
                if(!empty($v["user"]["referee_id"])){
                    $v["referee_user"] = UserModel::detail($v["user"]["referee_id"]);
                }
                $v["pay_time_text"] = empty($v["pay_time"]) ? '' : date("Y-m-d H:i:s",$v["pay_time"]);
                $v["receipt_time_text"] = empty($v["receipt_time"]) ? '' : date("Y-m-d H:i:s",$v["receipt_time"]);
                $v["auto_receipt_time_text"] = empty($v["auto_receipt_time"]) ? '' : date("Y-m-d H:i:s",$v["auto_receipt_time"]);
            }
        }
        return $list;
    }

    /**
     * 订单导出
     */
    public function exportList($dataType, $query)
    {
        // 获取订单列表
        $list = $this->getListAll($dataType, $query);
        // 导出excel文件
        return (new Exportservice)->orderList($list);
    }

    /**
     * 转义数据类型条件
     */
    private function transferDataType($dataType)
    {
        $filter = [];
        // 订单数据类型
        switch ($dataType) {
            case 'all':
                break;
            case 'payment';
                $filter['pay_status'] = OrderPayStatusEnum::PENDING;
                $filter['order_status'] = 10;
                break;
            case 'delivery';
                $filter['pay_status'] = OrderPayStatusEnum::SUCCESS;
                $filter['delivery_status'] = 10;
                $filter['order_status'] = 10;
                break;
            case 'received';
                $filter['pay_status'] = OrderPayStatusEnum::SUCCESS;
                $filter['delivery_status'] = 20;
                $filter['receipt_status'] = 10;
                $filter['order_status'] = 10;
                break;
            case 'comment';
                $filter['is_comment'] = 0;
                $filter['order_status'] = 30;
                break;
            case 'complete';
                //  $filter['is_comment'] = 1;
                $filter['order_status'] = 30;
                break;
            case 'cancel';
                $filter['order_status'] = 21;
                break;
            case 'close';
                $filter['order_status'] = 20;
                break;
        }
        return $filter;
    }

}