qimall/addons/Pk/backend/controllers/FinancialController.php

<?php
/**
 * Created by PhpStorm.
 * User: wniu
 * Date: 2022/5/31
 * Time: 10:08 下午
 */

namespace addons\Pk\backend\controllers;

use addons\Pk\common\enums\PkEnum;
use addons\Pk\common\models\PkActivity;
use addons\Pk\common\models\PkOrder;
use common\enums\PayTypeEnum;
use common\enums\StatusEnum;
use common\models\user\User;

class FinancialController extends BaseController
{
    /**
     * 首页
     *
     * @return string
     */
    public function actionIndex()
    {

        $request = \Yii::$app->request;
        if ($request->isAjax) {
            $params = \Yii::$app->request->get();
            $params['mall_id'] = $this->mall_id;

            $params['limit'] = isset($params['limit']) ? $params['limit'] : 10;
            $params['page'] = isset($params['page']) ? $params['page'] : 1;


            $where[] = ['status' => StatusEnum::ENABLED];
            $where[] = ['mall_id' => $params['mall_id']];

            if (!empty($params['nickname'])) {
                $user_ids = User::find()->select("id")->where(['mall_id' => $this->mall_id])->andWhere(['like', 'nickname', $params['nickname'] . '%', false])->asArray()->column();
                if (empty($user_ids)) $this->success('查无此用户');
                $where[] = ['in', 'user_id', $user_ids];
            }
            if (!empty($params['activity_status'])) {
                $activity_ids = PkActivity::find()->select("id")->where(['mall_id' => $this->mall_id])->andWhere(['=', 'activity_status', $params['activity_status']])->asArray()->column();
                if (empty($activity_ids)) $this->success('查无活动');
                $where[] = ['in', 'activity_id', $activity_ids];
            }

            if (isset($params['is_pay']) && !empty($params['is_pay'])) {
                $where[] = ['is_pay' => $params['is_pay']];
            } else {
                $where[] = ['in', 'is_pay', [PkEnum::IS_PAY, PkEnum::PAY_RETURN]];
            }
            if (isset($params['order_no']) && $params['order_no'] != '') {
                $where[] = ['like', 'order_no', $params['order_no']];
            }


            if (isset($params['begin_time']) && $params['begin_time'] != '') {
                $where[] = ['>=', 'created_at', strtotime($params['begin_time'])];
            }

            if (isset($params['end_time']) && $params['end_time'] != '') {
                $where[] = ['<', 'created_at', strtotime($params['end_time'])];
            }

            $p_lists = array(
                'where' => $where,
                'order' => "id desc",
                'with' => ['user', 'activity'],
                'limit' => $params['limit'],
                'page' => $params['page'],
            );
            $data = PkOrder::listPage($p_lists, false, true);
            if (!empty($data['list'])) {
                foreach ($data['list'] as &$item) {
                    $item['created_at'] = date('Y-m-d H:i:s', $item['created_at']);
                }
            }
            $data['pay_type'] = PayTypeEnum::getMap();

            $this->success('成功', $data);
        }
        return $this->render('index', []);
    }
}