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;
     }
 }
Example #2
0
 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);
             }
         }
     }
 }
Example #3
0
 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;
 }
Example #4
0
<?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]);
 }
Example #6
0
 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'));
     }
 }
Example #7
0
$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'));
?>
Example #8
0
 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;
 }
Example #9
0
 /**
  * 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'));
     }
 }
Example #10
0
<?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])) {
Example #11
0
 /**
  * @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.');
     }
 }
Example #13
0
 /**
  * @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']);
 }