request; if ($retuest->isAjax && $retuest->isGet) { // 检查提交的参数 $get = $retuest->get(); $res = Yii::$app->services->validate->validate($get, [ [['page', 'limit', 'user_id', 'mobile'], 'integer'], [['start_at', 'end_at'], 'safe'], ]); if ($res === false) return $this->error(Yii::$app->services->validate->getErrorMessage()); $level_map = CloudStockLevel::getMap($this->mall_id); // 获取等级 $where = $list = []; $where[] = ['=', 'mall_id', $this->mall_id]; !empty($get['user_id']) && $where[] = ['=', 'user_id', $get['user_id']]; !empty($get['level']) && $where[] = ['=', 'level', $get['level']]; if (!empty($get['mobile'])) { $user_id = User::find()->select('id')->where(['mall_id' => $this->mall_id, 'mobile' => $get['mobile'], 'status' => StatusEnum::ENABLED])->scalar() ?? 0; if (empty($user_id)) $this->success('获取成功', compact('list', 'level_map')); $where[] = ['=', 'user_id', $user_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']; $order = 'id desc,created_at desc'; $params = array('where' => $where, 'order' => $order, 'with' => $with, 'limit' => $get['limit']); $list = CloudStockFillStatistics::listPage($params, false, true); if (empty($list)) return $this->error(CloudStockFillStatistics::getStaticError()); return $this->success('获取成功', compact('list', 'level_map')); } return $this->render($this->action->id); } }