qimall/addons/RandomRedPacket/backend/controllers/RecordController.php

<?php

namespace addons\RandomRedPacket\backend\controllers;

use addons\RandomRedPacket\common\models\RandomRedPacket;
use addons\RandomRedPacket\common\models\RandomRedPacketRecord;
use addons\Rebate\backend\controllers\BaseController;
use common\enums\StatusEnum;
use common\models\user\User;
use Yii;
use common\controllers\AddonsController;
use yii\helpers\Json;

class RecordController extends BaseController
{
    public $enableCsrfValidation = false;
    /**
     * 活动列表
     * @Author: wu
     * @DateTime: 2023/2/17 0015 18:06
     * @Copyright: copyright (c) 2023 广东七件事集团
     * @return string|\yii\web\Response
     */
    public function actionIndex()
    {
        if (Yii::$app->request->isAjax) {
            if (Yii::$app->request->isPost) {
                $params = Yii::$app->request->post();
                // 检查提交的参数
                $res = Yii::$app->services->validate->validate($get,[
                    [['activities_number', 'reward_type'], 'integer'],
                    [['activities_name'], 'string'],
                ]);
                if($res === false) return $this->error(Yii::$app->services->validate->getErrorMessage());
                $filter = [];
                if(!empty($params['user_id'])){
                    $userQuery = User::find()->where(['mall_id'=>$this->mall_id]);
                    $search_user_ids = $userQuery->andWhere(['=', 'id', $params['user_id']])->select(['id'])->asArray()->all();
                    $search_user_ids  = array_column($search_user_ids, 'id');
                    if ($search_user_ids) {
                        $filter[] = ['uid' => $search_user_ids];
                    } else {
                        $filter[] = ['uid' => []];
                    }
                }
                $where = [];
                !empty($params['activities_number']) && $where[] = ['like', 'activities_number', $params['activities_number']];
                !empty($params['activities_name']) && $where[] = ['like', 'activities_name', $params['activities_name']];
                if(!empty($where)){
                    $select = 'id';
                    $params = compact('where','select');
                    $packet_data = RandomRedPacket::listPage($params);
                    $search_packet_ids  = array_column($packet_data['list'], 'id');

                    if ($search_packet_ids) {
                        $filter[] = ['packet_id' => $search_packet_ids];
                    } else {
                        $filter[] = ['packet_id' => []];
                    }
                }

                $where = array_merge([['mall_id' => $this->mall_id]], $filter);

                $params = [
                    'where' => $where,
                    'with' => ['user','randomRedPacket'],
                    'order' => 'id DESC',
                ];
                $list = RandomRedPacketRecord::listPage($params);

                $this->success('获取成功', ['list' => $list]);
            }
        } else {
            return $this->render($this->action->id);
        }
    }
}