Пример #1
0
 /**
  * Loads a assFormulaQuestion object from a database
  * @param integer $question_id A unique key which defines the question in the database
  */
 public function loadFromDb($question_id)
 {
     global $ilDB;
     $result = $ilDB->queryF("SELECT qpl_questions.* FROM qpl_questions WHERE question_id = %s", array('integer'), array($question_id));
     if ($result->numRows() == 1) {
         $data = $ilDB->fetchAssoc($result);
         $this->setId($question_id);
         $this->setTitle($data["title"]);
         $this->setComment($data["description"]);
         $this->setSuggestedSolution($data["solution_hint"]);
         $this->setOriginalId($data["original_id"]);
         $this->setObjId($data["obj_fi"]);
         $this->setAuthor($data["author"]);
         $this->setOwner($data["owner"]);
         try {
             $this->setAdditionalContentEditingMode($data['add_cont_edit_mode']);
         } catch (ilTestQuestionPoolException $e) {
         }
         $this->unitrepository = new ilUnitConfigurationRepository($question_id);
         include_once "./Services/RTE/classes/class.ilRTE.php";
         $this->setQuestion(ilRTE::_replaceMediaObjectImageSrc($data["question_text"], 1));
         $this->setEstimatedWorkingTime(substr($data["working_time"], 0, 2), substr($data["working_time"], 3, 2), substr($data["working_time"], 6, 2));
         // load variables
         $result = $ilDB->queryF("SELECT * FROM il_qpl_qst_fq_var WHERE question_fi = %s", array('integer'), array($question_id));
         if ($result->numRows() > 0) {
             while ($data = $ilDB->fetchAssoc($result)) {
                 $varObj = new assFormulaQuestionVariable($data["variable"], $data["range_min"], $data["range_max"], $this->getUnitrepository()->getUnit($data["unit_fi"]), $data["varprecision"], $data["intprecision"]);
                 $varObj->setRangeMinTxt($data['range_min_txt']);
                 $varObj->setRangeMaxTxt($data['range_max_txt']);
                 $this->addVariable($varObj);
             }
         }
         // load results
         $result = $ilDB->queryF("SELECT * FROM il_qpl_qst_fq_res WHERE question_fi = %s", array('integer'), array($question_id));
         if ($result->numRows() > 0) {
             while ($data = $ilDB->fetchAssoc($result)) {
                 $resObj = new assFormulaQuestionResult($data["result"], $data["range_min"], $data["range_max"], $data["tolerance"], $this->getUnitrepository()->getUnit($data["unit_fi"]), $data["formula"], $data["points"], $data["resprecision"], $data["rating_simple"], $data["rating_sign"], $data["rating_value"], $data["rating_unit"]);
                 $resObj->setResultType($data['result_type']);
                 $resObj->setRangeMinTxt($data['range_min_txt']);
                 $resObj->setRangeMaxTxt($data['range_max_txt']);
                 $this->addResult($resObj);
             }
         }
         // load result units
         $result = $ilDB->queryF("SELECT * FROM il_qpl_qst_fq_res_unit WHERE question_fi = %s", array('integer'), array($question_id));
         if ($result->numRows() > 0) {
             while ($data = $ilDB->fetchAssoc($result)) {
                 $unit = $this->getUnitrepository()->getUnit($data["unit_fi"]);
                 $resObj = $this->getResult($data["result"]);
                 $this->addResultUnit($resObj, $unit);
             }
         }
     }
     parent::loadFromDb($question_id);
 }
 /**
  * Evaluates a posted edit form and writes the form data in the question object
  * @return integer A positive value, if one of the required fields wasn't set, else 0
  */
 public function writePostData($always = false)
 {
     $hasErrors = !$always ? $this->editQuestion(true) : false;
     $checked = true;
     if (!$hasErrors) {
         $this->object->setTitle($_POST["title"]);
         $this->object->setAuthor($_POST["author"]);
         $this->object->setComment($_POST["comment"]);
         include_once "./Services/AdvancedEditing/classes/class.ilObjAdvancedEditing.php";
         $questiontext = ilUtil::stripOnlySlashes($_POST["question"]);
         $this->object->setQuestion($questiontext);
         $this->object->setEstimatedWorkingTime($_POST["Estimated"]["hh"], $_POST["Estimated"]["mm"], $_POST["Estimated"]["ss"]);
         $this->object->parseQuestionText();
         $found_vars = array();
         $found_results = array();
         foreach ($_POST as $key => $value) {
             if (preg_match("/^unit_(\\\$v\\d+)\$/", $key, $matches)) {
                 array_push($found_vars, $matches[1]);
             }
             if (preg_match("/^unit_(\\\$r\\d+)\$/", $key, $matches)) {
                 array_push($found_results, $matches[1]);
             }
         }
         //			if(!$this->object->checkForDuplicateVariables())
         //			{
         //
         //				$this->addErrorMessage($this->lng->txt("err_duplicate_variables"));
         //				$checked = FALSE;
         //			}
         if (!$this->object->checkForDuplicateResults()) {
             $this->addErrorMessage($this->lng->txt("err_duplicate_results"));
             $checked = FALSE;
         }
         foreach ($found_vars as $variable) {
             if ($this->object->getVariable($variable) != null) {
                 $varObj = new assFormulaQuestionVariable($variable, $_POST["range_min_{$variable}"], $_POST["range_max_{$variable}"], $this->object->getUnitrepository()->getUnit($_POST["unit_{$variable}"]), $_POST["precision_{$variable}"], $_POST["intprecision_{$variable}"]);
                 $varObj->setRangeMinTxt($_POST["range_min_{$variable}"]);
                 $varObj->setRangeMaxTxt($_POST["range_max_{$variable}"]);
                 $this->object->addVariable($varObj);
             }
         }
         $tmp_form_vars = array();
         $tmp_quest_vars = array();
         foreach ($found_results as $result) {
             $tmp_res_match = preg_match_all("/([\$][v][0-9]*)/", $_POST["formula_{$result}"], $form_vars);
             $tmp_form_vars = array_merge($tmp_form_vars, $form_vars[0]);
             $tmp_que_match = preg_match_all("/([\$][v][0-9]*)/", $_POST['question'], $quest_vars);
             $tmp_quest_vars = array_merge($tmp_quest_vars, $quest_vars[0]);
         }
         $result_has_undefined_vars = array_diff($tmp_form_vars, $found_vars);
         $question_has_unused_vars = array_diff($tmp_quest_vars, $tmp_form_vars);
         if (count($result_has_undefined_vars) > 0 || count($question_has_unused_vars) > 0) {
             $error_message = '';
             if (count($result_has_undefined_vars) > 0) {
                 $error_message .= $this->lng->txt("res_contains_undef_var") . '<br>';
             }
             if (count($question_has_unused_vars) > 0) {
                 $error_message .= $this->lng->txt("que_contains_unused_var");
             }
             $checked = false;
             if ($this->isSaveCommand()) {
                 ilUtil::sendFailure($error_message);
             }
         }
         foreach ($found_results as $result) {
             if (is_object($this->object->getUnitrepository()->getUnit($_POST["unit_{$result}"]))) {
                 $tmp_result_unit = $this->object->getUnitrepository()->getUnit($_POST["unit_{$result}"]);
             } else {
                 $tmp_result_unit = NULL;
             }
             if ($this->object->getResult($result) != null) {
                 $use_simple_rating = $_POST["rating_advanced_{$result}"] == 1 ? FALSE : TRUE;
                 $resObj = new assFormulaQuestionResult($result, $_POST["range_min_{$result}"], $_POST["range_max_{$result}"], $_POST["tolerance_{$result}"], $tmp_result_unit, $_POST["formula_{$result}"], $_POST["points_{$result}"], $_POST["precision_{$result}"], $use_simple_rating, $_POST["rating_advanced_{$result}"] == 1 ? $_POST["rating_sign_{$result}"] : "", $_POST["rating_advanced_{$result}"] == 1 ? $_POST["rating_value_{$result}"] : "", $_POST["rating_advanced_{$result}"] == 1 ? $_POST["rating_unit_{$result}"] : "", $_POST["result_type_{$result}"] != 0 ? $_POST["result_type_{$result}"] : 0);
                 $resObj->setRangeMinTxt($_POST["range_min_{$result}"]);
                 $resObj->setRangeMaxTxt($_POST["range_max_{$result}"]);
                 $this->object->addResult($resObj);
                 $this->object->addResultUnits($resObj, $_POST["units_{$result}"]);
             }
         }
         if ($checked == false) {
             return 1;
         } else {
             $this->resetSavedPreviewSession();
             return 0;
         }
     } else {
         return 1;
     }
 }