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

<?php
/**
 * 重庆赤晓店信息科技有限公司
 * https://www.chixiaodian.com
 * Copyright (c) 2023 赤店商城 All rights reserved.
 */
/*
 * @Author: your name
 * @Date: 2021-03-02 09:50:20
 * @LastEditTime: 2021-05-17 17:17:15
 * @LastEditors: Please set LastEditors
 * @Description: In User Settings Edit
 * @FilePath: \admin_php\modules\client\models\v1\admin\IndexForm.php
 */


namespace app\modules\client\models\v1\admin;

use app\models\Goods;
use app\models\Mch;
use app\models\Order;
use app\models\OrderRefund;
use app\models\Shop;
use yii\base\Model;

/**
 * @property \app\models\Store $store;
 */
class IndexForm extends Model
{
    public $store_id;

    // 首页订单统计
    public function orderNum()
    {
        $query = Order::find()->alias('o')->where([
            'o.store_id' => $this->store_id,
            'o.mch_id' => 0,
            'o.is_recycle' => Order::IS_DELETE_FALSE,
            'o.is_delete' => Order::IS_DELETE_FALSE
        ]);
        // 待付款订单
        $query_1 = clone $query;
        $order_1 = $query_1->andWhere([
            'o.is_pay' => Order::IS_PAY_FALSE
        ])->count();
        // 待发货订单
        $query_2 = clone $query;
        $order_2 = $query_2->andWhere([
            'o.is_pay' => Order::IS_PAY_TRUE,
            'o.trade_status' => Order::ORDER_FLOW_NO_SEND,
        ])->andWhere(['or', ['o.is_pay' => Order::IS_PAY_TRUE], ['o.pay_type' => Order::PAY_TYPE_COD]])->count();

        $order_3 = OrderRefund::find()->alias('or')
        ->leftJoin(['o' => Order::tableName()], 'o.id=or.order_id')
        ->where(['or.store_id' => $this->store_id, 'or.is_delete' => Order::IS_DELETE_FALSE, 'o.mch_id' => 0,
            'o.is_show' => Order::IS_SHOW_TRUE,'or.status' => OrderRefund::STATUS_IN])->count();
        return [
            'code' => 0,
            'data' => [
                'order_1' => $order_1,
                'order_2' => $order_2,
                'order_3' => $order_3
            ]
        ];
    }

    // 商品统计
    public function goodsNum()
    {
        $query = Goods::find()
        ->where([
            'is_delete' => 0,
            'store_id' => $this->store_id,
            'mch_id' => 0
        ]);
        $query_1 = clone $query;
        $goods_1 = $query_1->andWhere([
            'status' => 1
        ])->count();
        
        $query_0 = clone $query;
        $goods_0 = $query_0->andWhere([
            'status' => 0
        ])->count();
        return [
            'code' => 0,
            'data' => [
                'goods_0' => $goods_0,
                'goods_1' => $goods_1
            ]
        ];
    }

    // 商户统计
    public function mchNum()
    {
        $query = Mch::find()
        ->where([
            'store_id' => $this->store_id,
            'is_delete' => 0
        ])->andWhere([
            '>',
            'user_id',
            0
        ]);
        // 待审核
        $query_0 = clone $query;
        $mch_0 = $query_0->andWhere([
            'review_status' => 0
        ])->count();
        // 通过
        $query_1 = clone $query;
        $mch_1 = $query_1->andWhere([
            'review_status' => 1
        ])->count();

        // 自提点
        $shop_num = Shop::find()
        ->where([
            'store_id' => $this->store_id,
            'is_delete' => 0
        ])->andWhere([
            '>',
            'user_id',
            0
        ])->count();
        return [
            'code' => 0,
            'data' => [
                'mch_0' => $mch_0,
                'mch_1' => $mch_1,
                'shop_num' => $shop_num
            ]
        ];
    }
}