/** * Deletes an existing InfoCategory model. * If deletion is successful, the browser will be redirected to the 'index' page. * @param integer $id * @return mixed */ public function actionDelete($id) { $infoModel = Info::find()->andWhere(['category_id' => $id])->one(); if (null === $infoModel) { $this->findModel($id)->delete(); } else { Yii::$app->session->setFlash('alert', ['body' => \Yii::t('backend', 'Can not delete category #' . $id . '. It used in other table. Change category for info #' . $infoModel->id . ' before delete.'), 'options' => ['class' => 'alert-error']]); } return $this->redirect(['index']); }
public function actionSearch() { $request = Yii::$app->request; $type = $request->get("type"); $query = Yii::$app->session->getFlash('query'); if (!$type) { $type = $request->post("type"); $content = $request->post("content"); } else { $content = $request->get("content"); } if ($type || !$query) { switch ($type) { case 'userId': $query = Info::find()->where(['userId' => $content]); break; case 'date': $query = Info::find()->where(['between', 'createDate', date('Y-m-d H:i:s', strtotime($content)), date('Y-m-d H:i:s')]); break; case 'state': if ($content == 'record') { $query = Info::find()->where(['state' => Info::STATE_RECORD]); } elseif ($content == 'pass') { $query = Info::find()->where(['state' => Info::STATE_PASS]); } elseif ($content == 'refuse') { $query = Info::find()->where(['state' => Info::STATE_REFUSE]); } else { $query = Info::find(); } break; case 'IDCard': case 'cellphone': case 'realName': $query = Info::find()->where(['like', $type, $content]); break; default: $query = Info::find(); break; } } $pagination = new Pagination(['defaultPageSize' => Yii::$app->params['pageSize'], 'totalCount' => $query->count()]); $models = $query->offset($pagination->offset)->limit($pagination->limit)->orderBy(['createDate' => SORT_DESC])->all(); return $this->render('index', ['models' => $models, 'pages' => $pagination]); }
/** * Creates data provider instance with search query applied * @return ActiveDataProvider */ public function search($params) { $query = Info::find(); if (!\Yii::$app->user->can('administrator')) { $query->forDomain(); } $dataProvider = new ActiveDataProvider(['query' => $query]); if (!empty($params['mid'])) { $query->andFilterWhere(['model_id' => intval($params['mid'])]); } if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['{{info}}.id' => $this->id, '{{info}}.slug' => $this->slug, '{{info}}.author_id' => $this->author_id, '{{info}}.category_id' => $this->category_id, '{{info}}.model_id' => $this->model_id, '{{info}}.updater_id' => $this->updater_id, '{{info}}.status' => $this->status, '{{info}}.published_at' => $this->published_at, '{{info}}.created_at' => $this->created_at, '{{info}}.updated_at' => $this->updated_at, '{{info}}.domain_id' => $this->domain_id]); $query->andFilterWhere(['like', '{{info}}.slug', $this->slug])->andFilterWhere(['like', '{{info}}.title', $this->title])->andFilterWhere(['like', '{{info}}.description', $this->description])->andFilterWhere(['like', '{{info}}.weight', $this->weight])->andFilterWhere(['like', '{{info}}.body', $this->body])->andFilterWhere(['like', '{{info}}.before_body', $this->before_body])->andFilterWhere(['like', '{{info}}.after_body', $this->after_body])->andFilterWhere(['like', '{{info}}.on_scenario', $this->on_scenario]); if (!empty($params['InfoSearch']['cid'])) { $query->onlyModelCategory($params['InfoSearch']['cid']); } return $dataProvider; }
/** * Creates a new Info model. * If creation is successful, the browser will be redirected to the 'view' page. * @return mixed */ public function actionCreate() { foreach (Yii::$app->params['availableLocales'] as $key => $value) { $currentModel = Info::getLocaleInstance($key); $currentModel->locale = $key; if (Yii::$app->request->get('scenario')) { $currentModel->on_scenario = Yii::$app->request->get('scenario'); } $models[$key] = $currentModel; } //set data from default model if (Yii::$app->request->get('locale_group_id')) { $defaultDomainModels = Info::find()->andFilterWhere(['domain_id' => Yii::getAlias('@defaultDomainId'), 'locale_group_id' => Yii::$app->request->get('locale_group_id')])->all(); foreach ($defaultDomainModels as $key => $value) { if (!in_array($value->locale, array_keys(Yii::$app->params['availableLocales']))) { continue; } $models[$value->locale]->slug = $value->slug; $models[$value->locale]->title = $value->title; $models[$value->locale]->head = $value->head; $models[$value->locale]->body = $value->body; $models[$value->locale]->description = $value->description; $models[$value->locale]->before_body = $value->before_body; $models[$value->locale]->after_body = $value->after_body; } } $model = new MultiModel(['models' => $models]); if ($model->load(Yii::$app->request->post()) && Info::multiSave($model)) { return $this->redirect(['index', 'mid' => $model->getModel(Yii::$app->language)->model_id]); } else { switch (Yii::$app->request->get('scenario')) { case 'extend': $viewName = 'extend'; break; default: $viewName = 'create'; } return $this->render($viewName, ['model' => $model, 'categories' => InfoCategory::find()->active()->all(), 'domains' => array_combine(explode(',', Yii::getAlias('@frontendUrls')), explode(',', Yii::getAlias('@frontendUrls')))]); } }
/** * Creates data provider instance with search query applied * @return ActiveDataProvider */ public function search($params) { $query = Info::find(); if (!\Yii::$app->user->can('administrator')) { $query->forDomain(); } $dataProvider = new ActiveDataProvider(['query' => $query]); if (!empty($params['mid'])) { $query->andFilterWhere(['model_id' => intval($params['mid'])]); } if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['info.id' => $this->id, 'info.author_id' => $this->author_id, 'info.category_id' => $this->category_id, 'info.model_id' => $this->model_id, 'info.updater_id' => $this->updater_id, 'info.status' => $this->status, 'info.domain_id' => $this->domain_id]); if ($this->search_date_published != '') { $this->data_begin_published = strtotime($this->search_date_published); $this->data_end_published = strtotime($this->search_date_published) + 24 * 60 * 60; } $query->andFilterWhere(['like', 'info.slug', $this->slug])->andFilterWhere(['like', 'info.title', $this->title])->andFilterWhere(['like', 'info.description', $this->description])->andFilterWhere(['like', 'info.weight', $this->weight])->andFilterWhere(['like', 'info.body', $this->body])->andFilterWhere(['like', 'info.before_body', $this->before_body])->andFilterWhere(['like', 'info.after_body', $this->after_body])->andFilterWhere(['between', 'info.published_at', $this->data_begin_published, $this->data_end_published])->andFilterWhere(['like', 'info.on_scenario', $this->on_scenario]); if (!empty($params['InfoSearch']['cid'])) { $query->onlyModelCategory($params['InfoSearch']['cid']); } return $dataProvider; }
/** * @return \yii\db\ActiveQuery */ public function getFirstInfo() { return Info::find()->firstInfo($this->id, $this->domain_id); //return $this->hasOne(ModelCategory::className(), ['id' => 'category_id']); }
/** * Deletes an existing Model model. * If deletion is successful, the browser will be redirected to the 'index' page. * @param integer $id * @return mixed */ public function actionDelete($id) { //$this->findModel($id)->delete(); $infoModel = Info::find()->andWhere(['model_id' => $id])->one(); if (null === $infoModel) { $this->findModel($id)->delete(); } else { Yii::$app->session->setFlash('alert', ['body' => \Yii::t('backend', 'Can not delete model #' . $id . '. It used in other table. Delete info page #' . $infoModel->id . ' first.'), 'options' => ['class' => 'alert-error']]); } return $this->redirect(['index']); }
public function afterDelete() { $model = Info::find()->andWhere(['locale_group_id' => $this->locale_group_id, 'domain_id' => Yii::$app->user->identity->domain_id])->one(); if ($model) { $model->delete(); } return parent::afterDelete(); }
/** * 查询被拒绝的用户信息 * @param $userId * @return array|null|\common\models\Info */ public static function findRefusedByUserId($userId) { return Info::find()->where(['userId' => $userId, 'state' => Info::STATE_REFUSE])->one(); }