mall/modules/client/models/v1/admin/OrderListForm.php

<?php
/**
 * 重庆赤晓店信息科技有限公司
 * https://www.chixiaodian.com
 * Copyright (c) 2023 赤店商城 All rights reserved.
 */
namespace app\modules\client\models\v1\admin;

use app\constants\OptionSetting;
use app\models\common\admin\order\CommonOrderSearch;
use app\models\Express;
use app\models\Option;
use app\models\Order;
use app\models\OrderDetail;
use app\models\OrderRefund;
use app\models\Shop;
use app\models\User;
use yii\base\Model;
use yii\db\Query;
use yii\helpers\Json;

class OrderListForm extends Model
{
    public $store_id;
    public $user_id;
    public $keyword;
    public $status;
    public $limit;

    public $is_offline;
    public $clerk_id;
    public $parent_id;
    public $shop_id;

    public $dateStart;
    public $dateEnd;
    public $express_type;
    public $keywordType;

    public $fields;
    public $type;
    public $mch_id;
    public $flag; // 是否导出


    /**
     * @var 所属平台
     */
    public $platform;//所属平台

    /**
     * @var 获取默写城市的订单 例如：["\u5357\u5b81","\u4e0a\u6d77"]
     */
    public $shop_list;
    public $order_id;

    public function rules()
    {
        return [
            [['keyword', 'flag'], 'trim'],
            [['status', 'limit', 'user_id', 'is_offline', 'clerk_id', 'shop_id', 'keywordType', 'platform'], 'integer'],
            [['status',], 'default', 'value' => -1],
            [['dateStart', 'dateEnd', 'express_type'], 'trim'],
            [['fields', 'shop_list'], 'safe']
        ];
    }

    public function search()
    {
        if (!$this->validate()) {
            return [
                'code' => 1,
                'msg' => $this->getErrorSummary(false)[0],
            ];
        }
        $query = Order::find()->alias('o')->where([
            'o.store_id' => $this->store_id
        ]);
        $query->andWhere(['o.mch_id' => 0]);
        
        $query->leftJoin(['u' => User::tableName()], 'u.id = o.user_id')
            ->leftJoin(['od' => OrderDetail::tableName()], 'od.order_id=o.id');

        switch ($this->status) {
            case 0:
                $query->andWhere(['o.is_delete' => Order::IS_DELETE_FALSE, 'is_pay' => Order::IS_PAY_FALSE]);
                break;
            case 1:
                $query->andWhere([
                    'o.trade_status' => Order::ORDER_FLOW_NO_SEND,
                    'o.is_delete' => Order::IS_DELETE_FALSE
                ])->andWhere(['or', ['o.is_pay' => Order::IS_PAY_TRUE], ['o.pay_type' => Order::PAY_TYPE_COD]]);
                break;
            case 2:
                $query->andWhere([
                    'o.trade_status' => Order::ORDER_FLOW_SEND,
                    'o.is_delete' => Order::IS_DELETE_FALSE
                ])->andWhere(['or', ['o.is_pay' => Order::IS_PAY_TRUE], ['o.pay_type' => Order::PAY_TYPE_COD]]);
                break;
            case 3:
                $query->andWhere([
                    'o.trade_status' => Order::ORDER_FLOW_CONFIRM,
                    'o.is_delete' => Order::IS_DELETE_FALSE
                ])->andWhere(['or', ['o.is_pay' => Order::IS_PAY_TRUE], ['o.pay_type' => Order::PAY_TYPE_COD]]);
                break;
            case 4:
                break;
            case 5:
                $query->andWhere(['or', ['o.trade_status' => Order::ORDER_FLOW_CANCEL],
                    ['o.is_delete' => Order::IS_DELETE_TRUE]]);
                break;
            case 6:
                $query->andWhere(['and',['o.apply_delete' => Order::ORDER_APPLY_DELETE], ['!=', 'o.trade_status', Order::ORDER_FLOW_CANCEL]]);
                break;
            default:
                if (empty($this->order_id)) {
                    $query->andWhere([
                        'o.is_delete' => Order::IS_DELETE_FALSE
                    ]);
                }
                break;
        }

        if (get_params('is_recycle')) {
            $query->andWhere([
                'o.is_recycle' => Order::IS_DELETE_TRUE
            ]);
        } else {
            $query->andWhere([
                'o.is_recycle' => Order::IS_DELETE_FALSE
            ]);
        }


        if ($this->order_id && $this->order_id > 0) {
            $query->andWhere(['o.id' => $this->order_id]);
        }
        // TODO:
        $commonOrderSearch = new CommonOrderSearch();
        $query = $commonOrderSearch->search($query, $this);
        $query = $commonOrderSearch->keyword($query, $this->keywordType, $this->keyword);

        if(!empty($this->shop_list)){
            $orWhere = ['or'];
            foreach ($this->shop_list as $val){
                $orWhere[] = ['like', 'o.address_data', "\"city\":\"{$val}"];
            }
            $query->andWhere($orWhere);
            unset($orWhere);
        }
        if ($this->platform !== null && $this->platform !== '') {
            $query->andWhere([
                'u.platform' => $this->platform
            ]);
        }

        $refundQuery1 = OrderRefund::find()->alias('or')
            ->select('or.status, or.order_id, or.created_at')
            ->where(['or.store_id' => $this->store_id, 'or.is_delete' => 0]);
        $refundQuery = (new Query())->from(['or' => $refundQuery1])->where('`or`.order_id=o.id')
            ->select('or.status')
            ->orderBy(['or.created_at' => SORT_DESC])
            ->limit(1);
        $query->orderBy('o.created_at DESC')
            ->select(['o.*', 'u.nickname','u.nickname as de_name', 'u.platform',
                'refund' => $refundQuery]);

        $pagination = pagination_make($query);
        $listArray = $pagination['list'];
        foreach ($listArray as $i => &$item) {
            $item['created_at'] = date('m/d H:i', $item['created_at']);
            $item['goods_list'] = $this->getOrderGoodsList($item['id']);
            $item['goods_num'] = 0;
            foreach($item['goods_list'] as $goods_num) {
                $item['goods_num'] += $goods_num['num'];
            }
            $item['clerk_name'] = User::findOne(Shop::findOne($item['shop_id'])->user_id)->nickname;
            if ($item['shop_id'] && $item['shop_id'] != 0) {
                $shop = Shop::find()->where(['store_id' => $this->store_id, 'id' => $item['shop_id']])->asArray()->one();
                $item['shop'] = $shop;
            }
            $item['integral'] = json_decode($item['integral'], true);

            if (isset($item['address_data'])) {
                $item['address_data'] = json_decode($item['address_data']);
            }
            $item['flag'] = 0;
        }
        return [
            'code' => 0,
            'msg' => 'success',
            'data' => [
                'data' => $listArray,
                'pageNo' => $pagination['pageNo'],
                'totalCount' => $pagination['totalCount'],
            ],
        ];
    }
    public function getOrderGoodsList($order_id)
    {
        $orderDetailList = OrderDetail::find()->alias('od')
            ->where([
                'od.is_delete' => 0,
                'od.order_id' => $order_id,
            ])->select(['od.num', 'od.total_price', 'od.attr', 'od.is_level', 'od.batch_price_tips', 'name' => 'od.goods_name','od.pic', 'od.goods_info'])->asArray()->all();
        foreach ($orderDetailList as &$item) {
            $item['attr_list'] = json_decode($item['attr'], true);
            $item['unit'] = Json::decode($item['goods_info'])['unit'];
        }

        return $orderDetailList;
    }

    /**
     * @return array
     */
    private function getExpressList()
    {
        $storeExpressList = Order::find()
            ->select('express')
            ->where([
                'AND',
                ['store_id' => $this->store_id],
                ['is_pay' => Order::IS_PAY_TRUE],
                ['in', 'trade_status', [Order::ORDER_FLOW_SEND, Order::ORDER_FLOW_CONFIRM]],
                ['!=', 'express', ''],
            ])->groupBy('express')->orderBy('send_time DESC')->limit(5)->asArray()->all();
        $expressLst = Express::getExpressList();
        $newStoreExpressList = [];
        foreach ($storeExpressList as $i => $item) {
            foreach ($expressLst as $value) {
                if ($value['name'] == $item['express']) {
                    $newStoreExpressList[] = $item['express'];
                    break;
                }
            }
        }

        $newPublicExpressList = [];
        foreach ($expressLst as $i => $item) {
            $newPublicExpressList[] = $item['name'];
        }

        return array_merge($newStoreExpressList, $newPublicExpressList);
    }

    public function getEdit($order_id)
    {
        $order = Order::findOne([
            'store_id' => $this->store_id,
            'id' => $order_id
        ]);
        if (!$order) {
            return [
                'code' => 1,
                'msg' => '订单不存在',
            ];
        }
        $status = "";
        if ($order->is_pay == 0) {
            $status = '订单未付款';
        } elseif ($order->is_pay == 1 && $order->trade_status == Order::ORDER_FLOW_NO_SEND) {
            $status = '订单待发货';
        } elseif ($order->trade_status == Order::ORDER_FLOW_SEND) {
            $status = '订单已发货';
        } elseif ($order->trade_status == Order::ORDER_FLOW_CONFIRM) {
            $status = '订单已完成';
        }

        $goods_list = OrderDetail::find()->alias('od')
            ->where(['od.order_id' => $order->id, 'od.is_delete' => 0])->all();
        $num = 0;
        foreach ($goods_list as $i => $item) {
            $goods = Json::decode($item['goods_info']);
            $newItem = [];
            $newItem['goods_id'] = $item['goods_id'];
            $newItem['order_detail_id'] = $item['id'];
            $newItem['name'] = $item['goods_name'] ?: $goods['name'];
            $newItem['total_price'] = $item['total_price'];
            $newItem['num'] = $item['num'];
            $newItem['attr'] = json_decode($item['attr']);
            $num += intval($item['num']);
            $newItem['goods_pic'] = $item['pic'] ?: $goods['cover_pic'];
            $order_refund = OrderRefund::findOne([
                'order_detail_id' => $item['id'],
                'is_delete' => 0,
            ]);
            if ($order_refund) {
                $newItem['is_order_refund'] = 1;
            } else {
                $newItem['is_order_refund'] = 0;
            }
            if ($order->is_pay == 1 && $order->trade_status == Order::ORDER_FLOW_SEND) {
                $newItem['order_refund_enable'] = 1;
            } else {
                $newItem['order_refund_enable'] = 0;
            }
            if($item['is_level'] == 1 && ($order->discount && $order->discount < 10)){
                $newItem['is_level'] = 1;
            }
            $newList[] = $newItem;
        }
        $shop = null;
        if ($order->shop_id) {
            $shop = Shop::find()->select(['name', 'mobile', 'address', 'longitude', 'latitude'])->where(['store_id' => $this->store_id, 'id' => $order->shop_id])->asArray()->one();
        }
        if ($order->before_update_price) {
            if ($order->before_update_price < $order->pay_price) {
                $before_update = "加价";
                $money = $order->pay_price - $order->before_update_price;
            } else {
                $before_update = "优惠";
                $money = $order->before_update_price - $order->pay_price;
            }
        } else {
            $before_update = "";
            $money = "";
        }

        if(!$order->integral){
            $order->integral = 0;
        }
        return [
            'code' => 0,
            'msg' => 'success',
            'data' => [
                'express_list' => $this-> getExpressList(),
                'order' => [
                    'order_id' => $order->id,
                    'is_pay' => $order->is_pay,
                    'status' => $status,
                    'express' => $order->express,
                    'express_no' => $order->express_no,
                    'name' => $order->name,
                    'mobile' => $order->mobile,
                    'address' => $order->address,
                    'order_no' => $order->order_no,
                    'addtime' => date('Y-m-d H:i', $order->created_at),
                    'total_price' => doubleval(sprintf('%.2f', $order->total_price)),
                    'express_price' => doubleval(sprintf('%.2f', $order->express_price)),
                    'goods_total_price' => doubleval(sprintf('%.2f', doubleval($order->total_price) - doubleval($order->express_price))),
                    'coupon_sub_price' => isset($order->coupon_sub_price) ? $order->coupon_sub_price : 0,
                    'pay_price' => $order->pay_price,
                    'num' => $num,
                    'goods_list' => $newList,
                    'is_offline' => $order->is_offline,
                    'content' => $order->content ? $order->content : "",
                    'before_update' => $before_update,
                    'money' => $money,
                    'shop' => $shop,
                    'discount' => $order->discount,
                    'user_coupon_id' => $order->user_coupon_id,
                    'words' => $order->words,
                    'pay_type' => $order->pay_type,
                    'integral'=> json_decode($order->integral),
                    'type' => $order->type,
                    'nickname' => User::findOne($order->user_id)->nickname,
                    'trade_status' => $order->trade_status
                ]
            ],
        ];
    }
}