Пример #1
0
 /**
  * 获取调查问题
  * @param unknown $survey_id
  * @return multitype:
  */
 public function FindAllQuestionsOptions($survey_id)
 {
     $model_Question = new Question();
     $model_QuestionOptions = new QuestionOptions();
     $condition['table_id'] = $survey_id;
     $a_Question = $model_Question->find()->where($condition)->orderBy(['question_id' => SORT_ASC])->all();
     $a_QuestionOptions = $model_QuestionOptions->find()->where($condition)->orderBy(['question_id' => SORT_ASC, 'qo_id' => SORT_ASC])->all();
     $a_Question ? null : ($a_Question = []);
     $a_QuestionOptions ? null : ($a_QuestionOptions = []);
     $a_options = [];
     $question_total_count = 0;
     $question_total_score = 0;
     $question_total_min_score = 0;
     //没有问题就没有选项
     if (!isset($a_Question[0])) {
         $a_QuestionOptions = [];
     } else {
         foreach ($a_Question as $key => &$row) {
             $question_total_count++;
             //问题最大分数
             $question_max_score = 0;
             $question_min_score = null;
             foreach ($a_QuestionOptions as $key2 => &$row2) {
                 if ($row->question_id == $row2->question_id) {
                     $a_options[$key][] = $row2;
                     //获取问题最大得分
                     $question_max_score = max($row2->option_score, $question_max_score);
                     $question_min_score = $question_min_score == null ? $row2->option_score : min($question_min_score, $row2->option_score);
                     //                         echo $row2->option_score,'=',$question_total_score,'<br/>';
                 }
             }
             //设置问题总分数
             $question_total_score += $question_max_score;
             $question_total_min_score += $question_min_score;
             //                 isset($a_Question[$key]['options'][0])? null :$a_Question[$key]['options']=[];
         }
     }
     $data['questions'] = $a_Question;
     $data['options'] = $a_options;
     $data['question_total_count'] = $question_total_count;
     $data['question_total_score'] = $question_total_score;
     $data['question_total_min_score'] = $question_total_min_score;
     return $data;
 }
Пример #2
0
 /**
  * 删除
  */
 public function actionQuestionDelete($id, $page)
 {
     $id = intval($id);
     $page = intval($page);
     $this->layout = false;
     $id > 0 ? $model = Survey::findOne($id) : ($model = false);
     // 没有找到
     if (!$model || $model->uid != ZCommonSessionFun::get_user_id()) {
         if (!$model) {
             return $this->redirect(['my']);
         }
     }
     // 查找问题
     $questionData = $model->findOneQuestion($model->id, 1, $page - 1);
     // ZCommonFun::print_r_debug($questionData);
     // ZCommonFun::print_r_debug($questionData['question']);
     // ZCommonFun::print_r_debug($questionData['options']);
     if (isset($questionData['question']->question_id)) {
         $qustion_id = $questionData['question']->question_id;
         // 删除问题
         if ($questionData['question']->delete()) {
             // 删除选项
             $model_QuestionOptions = new QuestionOptions();
             $condition['question_id'] = $qustion_id;
             // 删除选项
             $model_QuestionOptions->deleteAll($condition);
         }
     }
     $model->is_publish = 0;
     $model->save();
     $this->redirect(['survey/step4_2_question', 'id' => $id]);
 }
Пример #3
0
 /**
  *  分数型测试问题
  * @param unknown $posts
  * @param unknown $id
  */
 public function step4_2_questionSave($posts, $id, $page)
 {
     $url = '';
     $error = '';
     if (isset($posts['label']['option-label'][0])) {
         //保存问题!empty($posts['label-name'] )
         if (isset($posts['label-name'])) {
             $transacation = Yii::$app->db->beginTransaction();
             try {
                 $question_id = isset($posts['qid']) ? $posts['qid'] : 0;
                 if ($question_id > 0) {
                     $model_Question = Question::findOne(['question_id' => $question_id]);
                     //不是当前测试的问题
                     if ($model_Question && $model_Question->table_id != $id) {
                         $model_Question = new Question();
                     }
                 } else {
                     $model_Question = new Question();
                 }
                 $model_Question->label = $posts['label-name'];
                 $model_Question->table_id = $id;
                 $model_Question->uid = ZCommonSessionFun::get_user_id();
                 $model_Question->update_time = date('Y-m-d H:i:s');
                 $save = 0;
                 $len = count($posts['label']['option-label']);
                 if ($model_Question->save()) {
                     $this->save_question = true;
                     foreach ($posts['label']['option-label'] as $key => $value) {
                         $qo_id = isset($posts['label']['qo-id'][$key]) ? intval($posts['label']['qo-id'][$key]) : 0;
                         //验证问题
                         if (empty($value)) {
                             //删除空选项
                             $model_QuestionOptions = $qo_id > 0 ? QuestionOptions::findOne($qo_id) : null;
                             //不是当前测试的选项
                             if ($model_QuestionOptions && $model_QuestionOptions->table_id != $id) {
                                 continue;
                             } else {
                                 if ($model_QuestionOptions) {
                                     $model_QuestionOptions->delete();
                                 }
                             }
                             continue;
                         }
                         if ($qo_id > 0) {
                             $model_QuestionOptions = QuestionOptions::findOne($qo_id);
                             //不是当前测试的选项
                             if ($model_QuestionOptions->table_id != $id) {
                                 continue;
                             }
                             $save++;
                         } else {
                             $model_QuestionOptions = new QuestionOptions();
                         }
                         $model_QuestionOptions->question_id = $model_Question->question_id;
                         $model_QuestionOptions->table_id = $id;
                         $model_QuestionOptions->uid = ZCommonSessionFun::get_user_id();
                         $model_QuestionOptions->option_label = $value;
                         $model_QuestionOptions->question_id = $model_Question->question_id;
                         $score = isset($posts['label']['option-score'][$key]) ? $posts['label']['option-score'][$key] : 1;
                         $score = (int) $score;
                         $model_QuestionOptions->option_score = $score;
                         if ($model_QuestionOptions->save()) {
                             $save++;
                         }
                     }
                     if ($save > 0 || !empty($posts['label-name'])) {
                         $error = '保存成功';
                         $is_commit = true;
                         $this->save_question = true;
                         $transacation->commit();
                     } else {
                         $this->save_question = false;
                         if ($model_Question && $model_Question->question_id > 0 && $model_Question->delete()) {
                             $error = '删除成功';
                             $is_commit = true;
                             $transacation->commit();
                         } else {
                             $error = '删除选项失败';
                             throw new \Exception('删除选项失败');
                         }
                     }
                 } else {
                     $this->save_question = false;
                     $error = '保存失败';
                     throw new \Exception($error);
                 }
             } catch (\Exception $e) {
                 if (isset($is_commit) && $is_commit === true) {
                 } else {
                     $transacation->rollBack();
                     $error = '事物异常';
                 }
                 $this->errorResulte = $error;
             }
         } else {
             $this->save_question = false;
             $error = '提交表单错误';
         }
         if (isset($posts['save-next'])) {
             //                ZCommonFun::print_r_debug($save);
             //                exit;
             return $url = ['step4_2_question', 'id' => $id, 'page' => $page];
         } else {
             return $url = ['step4_2', 'id' => $id];
         }
     }
 }