/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Question::find()->where(['list_id' => $params['list_id']]); // add conditions that should always apply here $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } // grid filtering conditions $query->andFilterWhere(['id' => $this->id]); $query->andFilterWhere(['like', 'type', $this->type])->andFilterWhere(['like', 'quest_text', $this->quest_text]); return $dataProvider; }
/** * @inheritdoc */ public function rules() { return [[['type', 'quest_text', 'list_id'], 'required'], [['type'], 'string', 'max' => 50], [['ordering'], 'number'], [['quest_text'], 'string', 'max' => 1000], [['visible_condition'], 'string', 'max' => 1000], [['visible_condition_value'], 'string', 'max' => 100], [['visible_condition_value'], 'required', 'when' => function ($model) { if (!$model->visible_condition) { return false; } $linkedQuestion = Question::findOne($model->visible_condition); if (!$linkedQuestion) { throw new \NotFoundHttpException(); } switch ($linkedQuestion->type) { case 'select_one': case 'select_multiple': case 'radio': case 'checkbox': return true; case 'text': default: return false; } }, 'whenClient' => 'function(){return false;}']]; }
public function getQuestion() { return $this->hasOne(Question::className(), ['id' => 'question_id']); }
?> <?php echo $form->field($model, 'ordering')->textInput(['type' => 'number']); ?> <?php echo $form->field($model, 'quest_text')->textArea(['maxlength' => true]); ?> <div id="visible_condition_block" class="panel panel-default"> <div class="panel-heading"><h4><i class="glyphicon glyphicon-eye-open"></i> Условие видимости</h4></div> <div class="panel-body"> <div class="col-md-6 col-sm-10"> <?php $query = Question::find()->where(['list_id' => $list_id]); $query->andWhere(['<>', 'type', 'text']); // Если вопрос изменяется, то исключим его из выбора вопроса, связаного условием if ($model->id) { $query->andWhere(['<>', 'id', $model->id]); } $questionsInList = ArrayHelper::map($query->all(), 'id', 'quest_text'); ?> <?php echo $form->field($model, "visible_condition")->dropDownList($questionsInList, ['prompt' => 'Нет']); ?> </div> <div class="col-md-6 col-sm-10"> <?php echo $form->field($model, 'visible_condition_value')->hiddenInput(['maxlength' => true]); ?>
/** * Finds the Question model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Question the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Question::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
/** * Updates an existing QuestionList model. * If update is successful, the browser will be redirected to the 'view' page. * @param integer $id * @return mixed */ public function actionUpdate($id) { $modelQuestionList = $this->findModel($id); $modelsQuestion = $modelQuestionList->questions; $modelsAnswerVariant = []; $oldAnswerVariants = []; if (!empty($modelsQuestion)) { foreach ($modelsQuestion as $indexQuestion => $modelQuestion) { $answerVariants = $modelQuestion->answerVariants; $modelsAnswerVariant[$indexQuestion] = $answerVariants; $oldAnswerVariants = ArrayHelper::merge(ArrayHelper::index($answerVariants, 'id'), $oldAnswerVariants); } } if ($modelQuestionList->load(Yii::$app->request->post())) { $oldQuestionIDs = ArrayHelper::map($modelsQuestion, 'id', 'id'); $modelsQuestion = []; $postQuestionData = Yii::$app->request->post()['Question']; if ($postQuestionData) { foreach ($postQuestionData as $q) { $question = new Question(); if ($q['id']) { $actualIds[$q['id']] = $q['id']; $question->id = $q['id']; } $modelsQuestion[] = $question; } } Model::loadMultiple($modelsQuestion, Yii::$app->request->post()); $deletedQuestionIDs = array_diff($oldQuestionIDs, array_filter(ArrayHelper::map($modelsQuestion, 'id', 'id'))); $valid = $modelQuestionList->validate(); $valid = Model::validateMultiple($modelsQuestion) && $valid; $answerVariantsIDs = []; $postAnswersData = Yii::$app->request->post()['AnswerVariant']; if (isset($postAnswersData[0])) { foreach ($postAnswersData as $indexQuestion => $answerVariants) { $answerVariantsIDs = ArrayHelper::merge($answerVariantsIDs, array_filter(ArrayHelper::getColumn($answerVariants, 'id'))); foreach ($answerVariants as $indexAnswerVariant => $answerVariant) { if (!$answerVariant['answer']) { continue; } $data['AnswerVariant'] = $answerVariant; $modelAnswerVariant = isset($answerVariant['id']) && isset($oldAnswerVariants[$answerVariant['id']]) ? $oldAnswerVariants[$answerVariant['id']] : new AnswerVariant(); $modelAnswerVariant->load($data); $modelsAnswerVariant[$indexQuestion][$indexAnswerVariant] = $modelAnswerVariant; $valid = $modelAnswerVariant->validate(); } } } $oldAnswerVariantsIDs = ArrayHelper::getColumn($oldAnswerVariants, 'id'); $deletedAnswerVariantsIDs = array_diff($oldAnswerVariantsIDs, $answerVariantsIDs); if ($valid) { $transaction = \Yii::$app->db->beginTransaction(); try { if ($flag = $modelQuestionList->save(false)) { if (!empty($deletedAnswerVariantsIDs)) { AnswerVariant::deleteAll(['id' => $deletedAnswerVariantsIDs]); } if (!empty($deletedQuestionIDs)) { foreach ($deletedQuestionIDs as $q_id) { Question::findOne($q_id)->unlink('questionLists', $modelQuestionList); Question::findOne($q_id)->delete(); } } foreach ($modelsQuestion as $indexQuestion => $modelQuestion) { if ($modelQuestion->id) { $model = Question::findOne($modelQuestion->id); $data = $modelQuestion->toArray(); if ($model) { $model->attributes = $data; $modelQuestion = $model; } } if (!($flag = $modelQuestion->save())) { $transaction->rollBack(); break; } if (isset($modelsAnswerVariant[$indexQuestion]) && is_array($modelsAnswerVariant[$indexQuestion])) { foreach ($modelsAnswerVariant[$indexQuestion] as $indexAnswerVariant => $modelAnswerVariant) { if ($modelsQuestion[$indexQuestion]->type !== 'select_one') { $modelAnswerVariant->delete(); } else { $modelAnswerVariant->question_id = $modelQuestion->id; if (!($flag = $modelAnswerVariant->save(false))) { break; } } } } if (!$actualIds[$modelQuestion->id]) { $modelQuestion->link('questionLists', $modelQuestionList); } } } if ($flag) { $transaction->commit(); return $this->redirect(['view', 'id' => $modelQuestionList->id]); } } catch (Exception $e) { $transaction->rollBack(); } } } return $this->render('update', ['modelQuestionList' => $modelQuestionList, 'modelsQuestion' => empty($modelsQuestion) ? [new Question()] : $modelsQuestion, 'modelsAnswerVariant' => empty($modelsAnswerVariant) ? [[new AnswerVariant()]] : $modelsAnswerVariant]); }
public function getQuestions() { return $this->hasMany(Question::className(), ['list_id' => 'id'])->orderBy(['questionlist_question.ordering' => SORT_ASC]); }
protected function getAllAnswerVariantsGroupByQuestionId($question_list_id) { $result = []; $modelQuestionList = Question::findAll(['list_id' => $question_list_id]); $ids = array_values(ArrayHelper::map($modelQuestionList, 'id', 'id')); $answerVariants = AnswerVariant::findAll(['question_id' => $ids]); foreach ($answerVariants as $answerVariant) { $result[$answerVariant->question_id][$answerVariant->id] = $answerVariant; } return $result; }