mall/plugins/scanCodePay/models/form/OrderListForm.php

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

use app\models\common\admin\order\CommonOrderSearch;
use app\models\DeliveryInfo;
use app\models\Express;
use app\models\Order;
use app\models\OrderDetail;
use app\models\OrderForm;
use app\models\OrderRefund;
use app\models\SaasUser;
use app\models\Shop;
use app\models\User;
use app\plugins\scanCodePay\models\ScanCodePaySetting;
use app\utils\Delivery\Delivery;
use app\utils\Export;
use app\utils\ExportList;
use yii\base\BaseObject;
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 $page;
    public $limit;

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

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

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

    public $supplier_id;
    public $supplier;

    public $md_id;


    /**
     * @var 所属平台
     */
    public $platform;//所属平台
    /**
     * @var bool 是否是配送员订单
     */
    public $is_delivery = false;//是否是配送员订单
    /**
     * @var bool 是否是配送员订单
     */
    public $is_same_city = false;//是否是配送员订单
    /**
     * @var 获取默写城市的订单 例如：["\u5357\u5b81","\u4e0a\u6d77"]
     */
    public $shop_list;
    public $order_id;

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

    public function search()
    {
        if (!$this->validate()) {
            return [
                'code' => 1,
                'msg' => $this->getErrorSummary(false)[0],
            ];
        }
        $query = \app\plugins\scanCodePay\models\Order::find()->alias('o')->where([
            'o.store_id' => $this->store_id
        ]);

        $query->leftJoin(['u' => User::tableName()], 'u.id = o.user_id')
            ->leftJoin(['su' => SaasUser::tableName()], 'su.mobile = u.binding');
        switch ($this->status) {
            case 0:
                $query->andWhere(['o.is_delete' => Order::IS_DELETE_FALSE, 'is_pay' => Order::IS_PAY_FALSE]);
                break;
            case 3:
                $query->andWhere([
                    'o.trade_status' => Order::ORDER_FLOW_CONFIRM,
                    'o.is_delete' => Order::IS_DELETE_FALSE,
                    'o.is_pay' => Order::IS_PAY_TRUE
                ]);
                break;
            default:
                if (empty($this->order_id)) {
                    $query->andWhere([
                        'o.is_delete' => Order::IS_DELETE_FALSE
                    ]);
                }
                break;
        }

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

        if ($this->dateStart) {
            $query->andWhere(['>=', 'o.created_at', strtotime($this->dateStart)]);
        }
        if ($this->dateEnd) {
            $query->andWhere(['<=', 'o.created_at', strtotime($this->dateEnd)]);
        }

        if ($this->md_id > 0) {
            $query->andWhere(['o.md_id' => $this->md_id]);
        } else {
            $query->andWhere(['o.md_id' => [0, -1]]);
        }

        if ($this->mch_id > 0) {
            $query->andWhere(['o.mch_id' => $this->mch_id]);
        } else {
            $query->andWhere(['o.mch_id' => [0, -1]]);
        }

        $query->orderBy('o.created_at DESC')
            ->select(['o.*', 'u.nickname as nickname','su.name as de_name', 'u.platform'])->groupBy('o.id');
        $pagination = pagination_make($query);
        $listArray = $pagination['list'];
        foreach ($listArray as &$order) {
            $order['created_at'] = date('Y-m-d H:i:s', $order['created_at']);
            if($order['user_id'] == 0){
                $order['nickname'] = "游客";
            }
        }

        return [
            'code' => 0,
            'msg' => 'success',
            'data' => [
                'data' => $listArray,
                'pageNo' => $pagination['pageNo'],
                'totalCount' => $pagination['totalCount'],
            ],
        ];
    }
}