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); } } }