private function generateDynamicAttributes($categoryId) { $questionsModel = MappingQuestions::find()->where(['category_id' => $categoryId])->all(); foreach ($questionsModel as $question) { $message = Yii::t('frontend', 'Please answer the question: "{question}"', ['question' => $question->title]); if ($question->fieldsTypes[0]->has_other_field && $question->has_other) { array_push($this->dynamicAttributesRules, [["other_{$question->id}"], MappingValidator::className(), 'skipOnEmpty' => true, 'message' => $message]); $this->dynamicAttributes[] = "other_{$question->id}"; $this->dynamicAttributesLabels["other_{$question->id}"] = $question->title . ' ' . Yii::t('frontend', 'other'); } array_push($this->dynamicAttributesRules, [["value_{$question->id}"], MappingValidator::className(), 'skipOnEmpty' => false, 'message' => $message]); $this->dynamicAttributes[] = "value_{$question->id}"; $this->dynamicAttributesLabels["value_{$question->id}"] = $question->title; } }
public function validateAttribute($model, $attribute) { $attributeArray = explode('_', $attribute); if (count($attributeArray) > 1) { list($value, $id) = $attributeArray; $questionModel = MappingQuestions::findOne(['id' => $id]); $attributesModel = MembersAttributes::findOne(['id' => $id]); if ($questionModel && $questionModel->is_required && empty($model->{$attribute})) { $message = "'{$questionModel->title}' " . Yii::t('errors', 'can not be empty!'); $this->addError($model, $attribute, $message); } else { if ($attributesModel && $attributesModel->is_required && empty($model->{$attribute})) { $message = "'{$attributesModel->label}' " . Yii::t('errors', 'can not be empty!'); $this->addError($model, $attribute, $message); } } } }
public function actionGetQuestionsList() { $id = Yii::$app->request->post('id', null); $optionsHtml = ''; if (!empty($id) && $id > 0) { $questions = MappingQuestions::find()->joinWith('fieldsTypes')->where(['category_id' => $id, 'fields_type.has_options' => 1]); if ($questions->count() > 0) { $questionsList = $questions->all(); $optionsHtml .= '<option>' . Yii::t('backend', 'Select Question') . '</option>'; foreach ($questionsList as $question) { $optionsHtml .= "<option value='" . $question->id . "'>" . $question->title . "</option>"; } } else { $optionsHtml .= "<option> - </option>"; } } echo $optionsHtml; }
<?php /* @var $this yii\web\View */ /* @var $form yii\bootstrap\ActiveForm */ /* @var $model \common\models\LoginForm */ use yii\helpers\Html; use yii\helpers\ArrayHelper; use yii\bootstrap\ActiveForm; use frontend\models\MembersQuestionsAnswers; use backend\models\MappingQuestionsToOptions; $this->registerJsFile(Yii::getAlias('@web/js/mapping.js'), ['depends' => ['yii\\web\\YiiAsset', 'yii\\bootstrap\\BootstrapAsset']]); $category = $steps['currentCategory']; $questionsAnswers = $steps['questionsAnswers']; $questionsModel = \backend\models\MappingQuestions::find()->where(['category_id' => $category['id'], 'is_active' => 1])->orderBy('order DESC')->with('fieldsTypes')->all(); $form = ActiveForm::begin(); ?> <?php echo $form->errorSummary($questionsAnswers); ?> <?php /* output all attributes related tot the mapping category */ $member_id = Yii::$app->getUser()->id; ?> <?php /* output all questions related tot the mapping category */ if (Yii::$app->request->post()) { $postData = Yii::$app->request->post(); }
/** * Deletes an existing MappingQuestionsToOptions model. * If deletion is successful, the browser will be redirected to the 'index' page. * @param integer $id * @return mixed */ public function actionDelete($id) { $option = $this->findModel($id); $question = MappingQuestions::findOne($option->question_id); $this->findModel($id)->delete(); return $this->redirect(['mapping-questions/update', 'cat_id' => $question->category_id, 'id' => $question->id]); }
public function actionMapping_old_171115() { if (!Yii::$app->user->isGuest) { $user = Yii::$app->getUser()->getIdentity(); //@TODO new logic to find out if there are answers /*$answers = MembersQuestionsAnswers::find(['member_id' => $user->id])->count(); if ($answers > 0) { $user->status = User::STATUS_ACTIVE; if ($user->save()) { return Yii::$app->response->redirect(array('members/index')); } else { Yii::$app->getSession()->setFlash('warning', Yii::t('errors', 'Can not update user status. Please contact system administrator')); } }*/ $settingsModel = GeneralSettings::findOne(['name' => 'mapping_page_id']); $pageModel = CmsPages::findOne(['id' => $settingsModel->value]); $categoryModel = MappingCategories::findOne(['id' => $pageModel->mapping_id]); $attributesModel = MembersAttributes::findAll(['id' => $categoryModel->attributes_id]); $questionsModel = MappingQuestions::find(['category_id' => $categoryModel->id])->with('fieldsTypes')->all(); $questionsAnswers = new MembersQuestionsAnswers($pageModel->category_id); $attributesAnswers = new MembersAttributesAnswers($categoryModel->attributes_id); if (Yii::$app->request->post()) { $mappingQuestionsSaved = false; $mappingAttributesSaved = false; if ($questionsAnswers->load(Yii::$app->request->post()) && $questionsAnswers->validate()) { foreach ($questionsAnswers->attributes as $attribute_id => $attribute) { $attributesArray = explode('_', $attribute_id); if (count($attributesArray) > 1) { list($name, $id) = $attributesArray; if (!($model = MembersQuestionsAnswers::findOne(['question_id' => $id, 'member_id' => Yii::$app->getUser()->id]))) { $model = new MembersQuestionsAnswers(); } $has_option = false; if ($questionsModel = MappingQuestions::findOne($id)) { $type_id = $questionsModel->type_id; $has_option = FieldsTypes::findOne($type_id)->has_options; } if ($has_option) { $model->value = ''; $model->option_id = ''; if ($optionsModel = MappingQuestionsToOptions::findOne($questionsAnswers->{$attribute_id})) { $model->value = $optionsModel->title; $model->option_id = $optionsModel->id; } } else { $model->value = $questionsAnswers->{$attribute_id}; } $model->question_id = $id; $model->member_id = Yii::$app->getUser()->id; $model->save(); } } $mappingQuestionsSaved = true; } if ($attributesAnswers->load(Yii::$app->request->post()) && $attributesAnswers->validate()) { foreach ($attributesAnswers->attributes as $attribute_id => $attribute) { $attributesArray = explode('_', $attribute_id); if (count($attributesArray) > 1) { list($name, $id) = $attributesArray; if (!($model = MembersAttributesAnswers::findOne(['attribute_id' => $id, 'member_id' => Yii::$app->getUser()->id]))) { $model = new MembersAttributesAnswers(); } $has_option = false; if ($questionsModel = MembersAttributes::findOne($id)) { $type_id = $questionsModel->type_id; $has_option = FieldsTypes::findOne($type_id)->has_options; $filedTypeTitle = FieldsTypes::findOne($type_id)->title; } if ($has_option) { $model->value = ''; $model->option_id = ''; if ($optionsModel = MembersAttributesToOptions::findOne($attributesAnswers->{$attribute_id})) { $model->value = $optionsModel->title; $model->option_id = $optionsModel->id; } } else { $model->value = $attributesAnswers->{$attribute_id}; if (isset($filedTypeTitle) && $filedTypeTitle == 'Date Picker') { //@TODO replace datepicker with some database constatnt value; $model->value = strtotime($attributesAnswers->{$attribute_id}); } } $model->attribute_id = $id; $model->member_id = Yii::$app->getUser()->id; $model->save(); } } $mappingAttributesSaved = true; } if ($mappingQuestionsSaved && $mappingAttributesSaved) { $user = Yii::$app->getUser()->getIdentity(); $user->status = User::STATUS_ACTIVE; if ($user->save()) { return Yii::$app->response->redirect(array('members')); } else { Yii::$app->getSession()->setFlash('warning', Yii::t('errors', 'Can not save mapping data. Please contact system administrator')); } } else { $categoryModel = MappingCategories::findOne(['id' => $pageModel->category_id]); $attributesModel = MembersAttributes::find(['id in ' => $categoryModel->attributes_id])->with('fieldsTypes')->all(); $questionsModel = MappingQuestions::find(['category_id' => $categoryModel->id])->with('fieldsTypes')->all(); return $this->render('mapping', ['questionsAnswers' => $questionsAnswers, 'attributesAnswers' => $attributesAnswers, 'pageModel' => $pageModel, 'categoryModel' => $categoryModel, 'questionsModel' => $questionsModel, 'attributesModel' => $attributesModel]); } } else { return $this->render('mapping', ['questionsAnswers' => $questionsAnswers, 'attributesAnswers' => $attributesAnswers, 'pageModel' => $pageModel, 'categoryModel' => $categoryModel, 'questionsModel' => $questionsModel, 'attributesModel' => $attributesModel]); } } else { return Yii::$app->response->redirect(array('site/login')); } }
$question_options = ['prompt' => Yii::t('backend', 'Select Question'), 'onchange' => '$.post("' . \yii\helpers\Url::to(['pdfs-rules/get-options-list']) . '",{"id" : $(this).val()}, function(data) { $("select#pdfsrules-options_id").html(data); })']; $answers_options = ['prompt' => Yii::t('backend', 'Select Answers'), 'multiple' => 'true', 'size' => 7]; $questions_condition['fields_type.has_options'] = 1; if (!empty($model->category_id)) { $category_options['options'] = [$model->category_id => ['Selected' => 'selected']]; $questions_condition['category_id'] = $model->category_id; $question_options['options'] = [$model->question_id => ['Selected' => 'selected']]; $answers_condition['question_id'] = $model->question_id; $answers_options['options'] = [$model->options_id => ['Selected' => 'selected']]; } $question_items = array(); $options_items = array(); if (!$model->isNewRecord) { $question_items = \yii\helpers\ArrayHelper::map(\backend\models\MappingQuestions::find()->joinWith('fieldsTypes')->where($questions_condition)->all(), 'id', 'title'); $options_items = \yii\helpers\ArrayHelper::map(\backend\models\MappingQuestionsToOptions::find()->where($answers_condition)->all(), 'id', 'title'); } ?> <?php echo $form->field($model, 'category_id')->dropDownList(\yii\helpers\ArrayHelper::map(\backend\models\MappingCategories::find()->all(), 'id', 'name'), $category_options)->label(Yii::t('backend', 'Select Categories')); ?> <?php echo $form->field($model, 'question_id')->dropDownList($question_items, $question_options)->label(Yii::t('backend', 'Select Question')); ?> <?php echo $form->field($model, 'options_id')->dropDownList($options_items, $answers_options)->label(Yii::t('backend', 'Select Answers')); ?>
public function checkCategoryAnswered($id) { $requiredQuestions = MappingQuestions::find()->where(['and', ['category_id' => $id, 'is_required' => 1, 'is_active' => 1]]); if ($requiredQuestions->count()) { foreach ($requiredQuestions->asArray()->all() as $question) { $answerExists = MembersQuestionsAnswers::find()->where(['question_id' => $question['id'], 'member_id' => Yii::$app->user->id])->exists(); if (!$answerExists) { return false; } } } return true; }
/** * Displays homepage. * * @return mixed */ public function actionIndex() { if (!Yii::$app->user->isGuest) { Yii::$app->MappingComponent->process(); $steps = Yii::$app->MappingComponent->getSteps(); if (empty($steps['view'])) { $user = Yii::$app->getUser()->getIdentity(); $user->status = User::STATUS_ACTIVE; if ($user->save()) { return Yii::$app->response->redirect(array('members/index')); } else { Yii::$app->getSession()->setFlash('warning', Yii::t('errors', 'Can not update user status. Please contact system administrator')); } } $settingsModel = GeneralSettings::findOne(['name' => 'mapping_page_id']); //$pageModel = CmsPages::findOne(['id' => $settingsModel->value]); return $this->render('mapping', ['steps' => $steps]); $user = Yii::$app->getUser()->getIdentity(); //@TODO new logic to find out if there are answers /*$answers = MembersQuestionsAnswers::find(['member_id' => $user->id])->count(); if ($answers > 0) { $user->status = User::STATUS_ACTIVE; if ($user->save()) { return Yii::$app->response->redirect(array('members/index')); } else { Yii::$app->getSession()->setFlash('warning', Yii::t('errors', 'Can not update user status. Please contact system administrator')); } }*/ if (Yii::$app->request->post()) { $mappingQuestionsSaved = false; if ($questionsAnswers->load(Yii::$app->request->post()) && $questionsAnswers->validate()) { foreach ($questionsAnswers->attributes as $attribute_id => $attribute) { $attributesArray = explode('_', $attribute_id); if (count($attributesArray) > 1) { list($name, $id) = $attributesArray; if (!($model = MembersQuestionsAnswers::findOne(['question_id' => $id, 'member_id' => Yii::$app->getUser()->id]))) { $model = new MembersQuestionsAnswers(); } $has_option = false; if ($questionsModel = MappingQuestions::findOne($id)) { $type_id = $questionsModel->type_id; $has_option = FieldsTypes::findOne($type_id)->has_options; } if ($has_option) { $model->value = ''; $model->option_id = ''; if ($optionsModel = MappingQuestionsToOptions::findOne($questionsAnswers->{$attribute_id})) { $model->value = $optionsModel->title; $model->option_id = $optionsModel->id; } } else { $model->value = $questionsAnswers->{$attribute_id}; } $model->question_id = $id; $model->member_id = Yii::$app->getUser()->id; $model->save(); } } $mappingQuestionsSaved = true; } if ($mappingQuestionsSaved) { $user = Yii::$app->getUser()->getIdentity(); //$user->status = User::STATUS_ACTIVE; if ($user->save()) { return Yii::$app->response->redirect(array('members')); } else { Yii::$app->getSession()->setFlash('warning', Yii::t('errors', 'Can not save mapping data. Please contact system administrator')); } } } //$categoryModel = MappingCategories::findOne(['id' => $pageModel->mapping_id]); $categoryModel = MappingCategories::find()->where(['is_active' => 1])->orderBy('sort_order')->all(); $questionsModel = \backend\models\MappingQuestions::find()->where(['category_id' => $category->id])->with('fieldsTypes')->all(); //$questionsModel = MappingQuestions::find()->where(['category_id' => $categoryModel->id])->with('fieldsTypes')->all(); return $this->render('mapping', ['questionsAnswers' => $questionsAnswers, 'pageModel' => $pageModel, 'categoryModel' => $categoryModel]); } else { return Yii::$app->response->redirect(array('site/login')); } }
<?php /* @var $this yii\web\View */ /* @var $form yii\bootstrap\ActiveForm */ /* @var $model \common\models\LoginForm */ use yii\helpers\Html; use yii\helpers\ArrayHelper; use yii\bootstrap\ActiveForm; use backend\models\MembersQuestionsAnswers; use backend\models\MappingQuestionsToOptions; ?> <?php $questionsModel = \backend\models\MappingQuestions::find()->where(['category_id' => $category->id, 'is_active' => 1])->with('fieldsTypes')->all(); $form = ActiveForm::begin(); ?> <?php //= $form->errorSummary($questionsAnswers); ?> <?php /* output all attributes related tot the mapping category */ $member_id = Yii::$app->getUser()->id; ?> <?php /* output all questions related tot the mapping category */ foreach ($questionsModel as $model) { $value = $option_id = ''; if ($answersModel = MembersQuestionsAnswers::findOne(['question_id' => $model->id, 'member_id' => $member_id])) {
/** * @return \yii\db\ActiveQuery */ public function getPdfQuestions() { return $this->hasOne(MappingQuestions::className(), ['id' => 'question_id']); }
/** * Finds the MappingQuestions model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return MappingQuestions the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = MappingQuestions::find()->where(['id' => $id])->multilingual()->one()) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
/** * @return \yii\db\ActiveQuery */ public function getQuestions() { return $this->hasMany(MappingQuestions::className(), ['category_id' => 'id']); }
/** * Deletes an existing MappingCategories model. * If deletion is successful, the browser will be redirected to the 'index' page. * @param integer $id * @return mixed */ public function actionDelete($id) { foreach (MappingQuestions::find()->where(['category_id' => $id])->all() as $question) { MappingQuestionsToOptions::deleteAll(['question_id' => $question->id]); $question->delete(); } $this->findModel($id)->delete(); return $this->redirect(['index']); }