public function actionIndex() { $levelList = Level::getAll(); $districtList = Train::$districtList; $data = ['levelList' => $levelList, 'districtList' => $districtList]; return $this->render('index', ['data' => $data]); }
public function actionIndex() { $levelList = Level::getAll(); $districtList = ['' => '请选择区域', '朝阳区' => '朝阳区', '东城区' => '东城区', '海淀区' => '海淀区', '西城区' => '西城区', '昌平区' => '昌平区']; $userCount = Users::getAllCount(); $coachA = Users::getCountUserByLevelId(2, 9); $coachB = Users::getCountUserByLevelId(3, 9); $coachC = Users::getCountUserByLevelId(4, 9); $coachD = Users::getCountUserByLevelId(5, 9); $coachE = Users::getCountUserByLevelId(6, 9); $coachF = Users::getCountUserByLevelId(7, 9); $newsList = News::getNewsByCategory(5, 12); $data = ['levelList' => $levelList, 'districtList' => $districtList, 'userCount' => $userCount, 'coachA' => $coachA, 'coachB' => $coachB, 'coachC' => $coachC, 'coachD' => $coachD, 'coachE' => $coachE, 'coachF' => $coachF, 'newsList' => $newsList]; return $this->render('index', ['data' => $data]); // return $this->render('build',['data' => $data]); }
<div class="activity-form"> <?php $form = ActiveForm::begin(); ?> <?php echo $form->field($model, 'name')->textInput(['style' => 'width:300px']); ?> <?php echo $form->field($model, 'category')->dropDownList(\app\models\ActivityCategory::getAll(), ['style' => 'width:300px']); ?> <?php echo $form->field($model, 'level_id')->dropDownList(ArrayHelper::map(\app\models\Level::getAll(), 'id', 'name'), ['style' => 'width:100px']); ?> <?php echo $form->field($model, 'recruit_count')->textInput(['style' => 'width:100px']); ?> <?php if ($model->isNewRecord) { ?> <?php echo $form->field($model, 'sign_up_begin_time')->widget(DatePicker::className(), ['dateFormat' => 'yyyy-MM-dd', 'options' => ['style' => '500px']]); ?> <?php echo $form->field($model, 'sign_up_end_time')->widget(DatePicker::className(), ['dateFormat' => 'yyyy-MM-dd', 'options' => ['style' => '500px']]);
public function actionIndex() { $keyword = Yii::$app->request->get('keyword', ''); $levelId = Yii::$app->request->get('level_id', ''); $district = Yii::$app->request->get('district', ''); $sex = Yii::$app->request->get('sex', ''); if (empty($keyword) && empty($levelId) && empty($district) && empty($sex)) { throw new ServerErrorHttpException('шп╖ш╛УхЕехЕ│щФохнЧя╝Б'); } $levelList = Level::getAll(); $districtList = Train::$districtList; $userName = ''; $certificateNumber = ''; $credentialsNumber = ''; if (preg_match("/^[- ]+\$/", $keyword)) { $userName = $keyword; } else { if (strlen($keyword) > 10) { $credentialsNumber = $keyword; } else { $certificateNumber = $keyword; } } $order = Yii::$app->request->get('order'); $query = Users::find()->from(Users::tableName() . ' u')->select("u.*,ui.account_location,ui.sex")->leftJoin(UsersLevel::tableName() . ' ul', ' u.id = ul.user_id')->leftJoin(UsersInfo::tableName() . ' ui', ' u.id = ui.user_id'); if (!empty($order)) { $query->orderBy($order); } $query->andFilterWhere(['!=', 'u.level_id', '1']); if (!empty($levelId)) { $query->andFilterWhere(['u.level_id' => $levelId]); } if (!empty($district)) { $query->andFilterWhere(['account_location' => $district]); } if (!empty($sex)) { $query->andFilterWhere(['sex' => $sex]); } if (!empty($userName)) { $query->andFilterWhere(['like', 'name', $userName]); } if (!empty($certificateNumber)) { $query->andFilterWhere(['like', 'certificate_number', $certificateNumber]); } if (!empty($credentialsNumber)) { $query->andFilterWhere(['like', 'credentials_number', $credentialsNumber]); } $pages = new Pagination(['totalCount' => $query->count(), 'pageSize' => 15]); $models = $query->offset($pages->offset)->limit($pages->limit)->all(); $result = []; if (!empty($models)) { foreach ($models as $key => $val) { $result[$key]['name'] = $val['username']; $result[$key]['photo'] = UsersInfo::getPhotoByUserId($val['id']); $result[$key]['birthday'] = UsersInfo::getBirthdayByUserId($val['id']); $result[$key]['level_id'] = $val['level_id']; $result[$key]['user_id'] = $val['id']; } } $data = ['models' => $result, 'pages' => $pages, 'count' => $query->count(), 'levelList' => $levelList, 'districtList' => $districtList, 'keyword' => empty($keyword) ? '' : $keyword, 'levelId' => empty($levelId) ? '' : $levelId, 'district' => empty($district) ? '' : $district, 'sex' => empty($sex) ? '' : $sex]; return $this->render('index', ['data' => $data]); }