qimall/addons/Seed/backend/controllers/IndexController.php

<?php

namespace addons\Seed\backend\controllers;

use addons\Seed\common\enums\SeedEnum;
use addons\Seed\common\models\SeedLog;
use addons\Seed\common\models\SeedOrder;
use addons\Seed\common\models\SeedUser;
use common\enums\DownloadEnum;
use common\enums\StatusEnum;
use common\helpers\csv\CsvExportHelper;
use common\models\common\CapitalLog;
use common\models\user\User;
use Yii;
use common\controllers\AddonsController;

/**
 * 种子金控制器
 *
 * Class IndexController
 * @package addons\Seed\backend\controllers
 */
class IndexController extends BaseController
{
    public $enableCsrfValidation = false;
    /**
    * 用户种子金
    * @return string
    */
    public function actionUser()
    {
        $retuest = Yii::$app->request;
        if ($retuest->isAjax) {
            if ($retuest->isGet) {
                $get = Yii::$app->request->get();
                // 检查提交的参数
                $res = Yii::$app->services->validate->validate($get,[
                    [['user_id','mobile','page','limit'], 'integer'],
                ]);
                if($res === false) return $this->error(Yii::$app->services->validate->getErrorMessage());

                $where = $list = [];
                $where[] = ['=', 'mall_id', $this->mall_id];
                !empty($get['user_id']) && $where[] = ['=', 'user_id', $get['user_id']];
                $where[] = ['=', 'status', StatusEnum::ENABLED];

                // 根据搜索手机号查询用户id
                if (!empty($get['mobile'])) {
                    $user_id = User::find()->select("id")->where(['mall_id' => $this->mall_id,'mobile' => $get['mobile']])->asArray()->column();
                    if (empty($user_id)) $this->success('获取成功', $list);
                    $where[] = ['in', 'user_id', $user_id];
                }

                $with = ['user'];
                $select = "user_id,total_seed_num,total_seed_cost";
                $order = 'id desc,created_at desc';
                $params = array('where' => $where, 'select' => $select, 'order' => $order, 'with' => $with, 'limit' => $get['limit'] ?: 20);

                $list = SeedUser::listPage($params, false, true);
                $list['export_list'] = SeedUser::fieldsList();
                $this->success('获取成功', $list);
            }
            if ($retuest->isPost) {
                $post = $retuest->post();
                // 检查提交的参数
                $res = Yii::$app->services->validate->validate($post,[
                    [['user_id','mobile'], 'integer'],
                    [['fields'], 'safe'],
                ]);
                if($res === false) return $this->error(Yii::$app->services->validate->getErrorMessage());
                $filename = '种子金记录-' . date('YmdHis').'_'.rand(10000,99999);
                $post['mall_id'] = $this->mall_id;
                $res = CsvExportHelper::exportDownLoadCenter($this->mall_id,$filename,DownloadEnum::TYPE_ASSETS,SeedUser::class,'exportHandle',$post);
                if ($res === false) return $this->error('加入导出任务失败'.CsvExportHelper::getStaticError());
                return $this->success('添加导出任务成功，任务完成后请在下载中心进行下载！');
            }
        } else {
            return $this->render($this->action->id);
        }
    }


    /**
     * 种子金订单
     * @Author: lun
     * @DateTime: 2022/7/28 0028 10:10
     * @Copyright: copyright (c) 2021 广东七件事集团
     * @return mixed|string|void
     */
    public function actionOrder()
    {
        $retuest = Yii::$app->request;
        if ($retuest->isAjax) {
            if ($retuest->isGet) {
                $get = Yii::$app->request->get();

                // 检查提交的参数
                $res = Yii::$app->services->validate->validate($get,[
                    [['user_id','page','limit'], 'integer'],
                    [['order_no','start_at','end_at'], 'string'],
                ]);
                if($res === false) return $this->error(Yii::$app->services->validate->getErrorMessage());

                $where = $list = [];
                $where[] = ['=', 'mall_id', $this->mall_id];
                !empty($get['user_id']) && $where[] = ['=', 'user_id', $get['user_id']];
                !empty($get['order_no']) && $where[] = ['=', 'order_no', $get['order_no']];

                // 根据时间筛选
                if (!empty($get['start_at']) && !empty($get['end_at'])) {
                    $where[] = ['between', 'created_at', strtotime($get['start_at']), strtotime($get['end_at'])];
                }

                $where[] = ['=', 'status', StatusEnum::ENABLED];

                $with = ['user'];
                $select = "id,user_id,identity,order_id,event_pay,order_no,seed_num,basic_unit_price,unit_price,seed_cost,seed_status,created_at";
                $order = 'created_at desc';
                $params = array('where' => $where, 'select' => $select, 'order' => $order, 'with' => $with, 'limit' => $get['limit']);

                $list = SeedOrder::listPage($params, false, true);
                $seed_status_arr = SeedEnum::getSeedMap();// 获取种子金状态
                $this->success('获取成功', compact('list','seed_status_arr'));
            }
        } else {
            return $this->render($this->action->id);
        }
    }


    /**
     * 种子金变动明细
     * @Author: lun
     * @DateTime: 2022/7/28 0028 10:21
     * @Copyright: copyright (c) 2021 广东七件事集团
     * @return mixed|string|void
     */
    public function actionChangeLog()
    {
        $retuest = Yii::$app->request;
        if ($retuest->isAjax) {
            if ($retuest->isGet) {
                $get = Yii::$app->request->get();

                // 检查提交的参数
                $res = Yii::$app->services->validate->validate($get,[
                    [['seed_order_id','user_id'], 'integer'],
                    [['order_no','start_at','end_at'], 'string'],
                ]);
                if($res === false) return $this->error(Yii::$app->services->validate->getErrorMessage());

                $where = $list = [];
                $where[] = ['=', 'mall_id', $this->mall_id];
                !empty($get['user_id']) && $where[] = ['=', 'user_id', $get['user_id']];
                !empty($get['seed_order_id']) && $where[] = ['=', 'seed_order_id', $get['seed_order_id']];

                // 根据订单号筛选
                if (!empty($get['order_no'])) {
                    $order_id = SeedOrder::find()->select('order_id')->where(['order_no' => $get['order_no'], 'status' => StatusEnum::ENABLED])->scalar();
                    !empty($order_id) && $where[] = ['=', 'order_id', $order_id];
                }

                // 根据时间筛选
                if (!empty($get['start_at']) && !empty($get['end_at'])) {
                    $where[] = ['between', 'created_at', strtotime($get['start_at']), strtotime($get['end_at'])];
                }

                $where[] = ['=', 'status', StatusEnum::ENABLED];

                $with = ['user','seedOrder'];
                $order = 'created_at desc';
                $select = 'mall_id,user_id,order_id,event_pay,seed_num,seed_cost,change_unit_price,after_unit_price,desc,capital_type,created_at';
                $params = array('where' => $where, 'select' => $select, 'order' => $order, 'with' => $with, 'limit' => $get['limit']);

                $list = SeedLog::listPage($params, false, true);
                $seed_status_arr = SeedEnum::getChangeMap();// 获取种子金状态
                $this->success('获取成功', compact('list','seed_status_arr'));
            }
        } else {
            return $this->render($this->action->id);
        }
    }
}