mall/modules/client/models/v1/RcCommissionForm.php

<?php

/**
 * 重庆赤晓店信息科技有限公司
 * https://www.chixiaodian.com
 * Copyright (c) 2023 赤店商城 All rights reserved.
 */

namespace app\modules\client\models\v1;


use app\models\Goods;
use app\models\Md;
use app\models\Option;
use app\models\Order;
use app\models\OrderDetail;
use app\models\OrderRefund;
use app\models\OrderShare;
use app\models\SaasUser;
use app\models\UserShareMoney;
use yii\base\Model;
use yii\data\Pagination;
use yii\helpers\Json;
use app\models\User;
use app\models\Share;
use app\models\OrderPospal;
use app\models\RcCommissionLog;
use app\models\ReOrder;
use yii\helpers\VarDumper;

class RcCommissionForm extends Model
{
    public $yinbao = 0;
    public $user_id;
    public $user;
    public $type;
    public $store_id;
    public $share_setting;
    public $keyword;
    public $dateStart;
    public $page = 1;
    public $limit = 10;
    public $status;
    // public $page;
    // public $limit;

    public function rules()
    {
        return [];
    }

    public function search()
    {
        if (!$this->validate()) {
            return [
                'code' => 1,
                'msg' => $this->getErrorSummary(false)[0],
            ];
        }

        $query = RcCommissionLog::find()->alias('al')
            ->leftJoin(ReOrder::tableName() . 'o', 'o.id = al.order_id')
            ->where([
                'al.store_id' => get_store_id(),
                'al.parent_id' => get_user_id(),
            ]);

        if ($this->type > -1 && in_array($this->type, [1, 2])) {
            $query->andWhere(['al.log_type' => $this->type]);
        }
//        if ($this->status > -1 ) {
//            $query->andWhere(['o.is_pay' => $this->status == 1 ? 1 : ($this->status == 2 ? 1 : 0)]);
//        }
        $query->andWhere(['o.is_pay' => 1]);

        $count = $query->count();
        $pagination = new Pagination(['totalCount' => $count, 'page' => $this->page - 1, 'pageSize' => $this->limit]);
        $query->select('al.*, o.pay_price');
        $list = $query->limit($pagination->limit)->offset($pagination->offset)->orderBy('created_at DESC')->asArray()->all();

        foreach ($list as &$value) {
            $value['date'] = date('Y-m-d H:i:s', $value['created_at']);
            $value['content'] = $value['desc'];
            $value['user_info'] = User::find()->alias('u')
                ->leftJoin(['su' => SaasUser::tableName()], 'su.mobile = u.binding')
                ->where(['u.id' => $value['user_id']])->select('su.name, su.avatar')->asArray()->one() ?: [
                    'name' => '',
                    'avatar' => ''
                ];
        }
        // unset($value);

        return [
            'code' => 0,
            'msg' => 'success',
            'data' => [
                'list' => $list,
                'page'=>$this->page - 1,
               'pageSize'=> $this->limit,
                'row_count' => $count
            ]
        ];
    }
}