class.SurveyMetricQuestion.php

Go to the documentation of this file.

<?php

/* Copyright (c) 1998-2019 ILIAS open source, Extended GPL, see docs/LICENSE */

class SurveyMetricQuestion extends SurveyQuestion
{
    protected $db;

    const SUBTYPE_NON_RATIO = 3;
    const SUBTYPE_RATIO_NON_ABSOLUTE = 4;
    const SUBTYPE_RATIO_ABSOLUTE = 5;
    
    public $subtype;

    public $minimum;

    public $maximum;

    public function __construct($title = "", $description = "", $author = "", $questiontext = "", $owner = -1, $subtype = self::SUBTYPE_NON_RATIO)
    {
        global $DIC;

        $this->db = $DIC->database();
        parent::__construct($title, $description, $author, $questiontext, $owner);
        
        $this->subtype = $subtype;
        $this->minimum = "";
        $this->maximum = "";
    }
    
    public function setSubtype($subtype = self::SUBTYPE_NON_RATIO)
    {
        $this->subtype = $subtype;
    }

    public function setMinimum($minimum = 0)
    {
        if ($minimum !== null) {
            $minimum = (float) $minimum;
        }
        if (!$minimum) {
            $minimum = null;
        }
        $this->minimum = $minimum;
    }

    public function setMaximum($maximum = "")
    {
        if ($maximum !== null) {
            $maximum = (float) $maximum;
        }
        if (!$maximum) {
            $maximum = null;
        }
        $this->maximum = $maximum;
    }

    public function getSubtype()
    {
        return $this->subtype;
    }
    
    public function getMinimum()
    {
        if ((strlen($this->minimum) == 0) && ($this->getSubtype() > 3)) {
            $this->minimum = 0;
        }
        return (strlen($this->minimum)) ? $this->minimum : null;
    }
    
    public function getMaximum()
    {
        return (strlen($this->maximum)) ? $this->maximum : null;
    }
    
    public function getQuestionDataArray($id)
    {
        $ilDB = $this->db;
        
        $result = $ilDB->queryF(
            "SELECT svy_question.*, " . $this->getAdditionalTableName() . ".* FROM svy_question, " . $this->getAdditionalTableName() . " WHERE svy_question.question_id = %s AND svy_question.question_id = " . $this->getAdditionalTableName() . ".question_fi",
            array('integer'),
            array($id)
        );
        if ($result->numRows() == 1) {
            return $ilDB->fetchAssoc($result);
        } else {
            return array();
        }
    }
    
    public function loadFromDb($id)
    {
        $ilDB = $this->db;

        $result = $ilDB->queryF(
            "SELECT svy_question.*, " . $this->getAdditionalTableName() . ".* FROM svy_question LEFT JOIN " . $this->getAdditionalTableName() . " ON " . $this->getAdditionalTableName() . ".question_fi = svy_question.question_id WHERE svy_question.question_id = %s",
            array('integer'),
            array($id)
        );
        if ($result->numRows() == 1) {
            $data = $ilDB->fetchAssoc($result);
            $this->setId($data["question_id"]);
            $this->setTitle($data["title"]);
            $this->setDescription($data["description"]);
            $this->setObjId($data["obj_fi"]);
            $this->setAuthor($data["author"]);
            $this->setOwner($data["owner_fi"]);
            $this->label = $data['label'];
            $this->setQuestiontext(ilRTE::_replaceMediaObjectImageSrc($data["questiontext"], 1));
            $this->setObligatory($data["obligatory"]);
            $this->setComplete($data["complete"]);
            $this->setOriginalId($data["original_id"]);
            $this->setSubtype($data["subtype"]);

            $result = $ilDB->queryF(
                "SELECT svy_variable.* FROM svy_variable WHERE svy_variable.question_fi = %s",
                array('integer'),
                array($id)
            );
            if ($result->numRows() > 0) {
                if ($data = $ilDB->fetchAssoc($result)) {
                    $this->minimum = $data["value1"];
                    if (($data["value2"] < 0) or (strcmp($data["value2"], "") == 0)) {
                        $this->maximum = "";
                    } else {
                        $this->maximum = $data["value2"];
                    }
                }
            }
        }
        parent::loadFromDb($id);
    }

    public function isComplete()
    {
        if (
            strlen($this->getTitle()) &&
            strlen($this->getAuthor()) &&
            strlen($this->getQuestiontext())
        ) {
            return 1;
        } else {
            return 0;
        }
    }
    
    public function saveToDb($original_id = "")
    {
        $ilDB = $this->db;

        $affectedRows = parent::saveToDb($original_id);
        if ($affectedRows == 1) {
            $affectedRows = $ilDB->manipulateF(
                "DELETE FROM " . $this->getAdditionalTableName() . " WHERE question_fi = %s",
                array('integer'),
                array($this->getId())
            );
            $affectedRows = $ilDB->manipulateF(
                "INSERT INTO " . $this->getAdditionalTableName() . " (question_fi, subtype) VALUES (%s, %s)",
                array('integer', 'text'),
                array($this->getId(), $this->getSubType())
            );

            // saving material uris in the database
            $this->saveMaterial();
            
            // save categories
            $affectedRows = $ilDB->manipulateF(
                "DELETE FROM svy_variable WHERE question_fi = %s",
                array('integer'),
                array($this->getId())
            );

            if (preg_match("/[\D]/", $this->maximum) or (strcmp($this->maximum, "&infin;") == 0)) {
                $max = -1;
            } else {
                $max = $this->getMaximum();
            }
            $next_id = $ilDB->nextId('svy_variable');
            $affectedRows = $ilDB->manipulateF(
                "INSERT INTO svy_variable (variable_id, category_fi, question_fi, value1, value2, sequence, tstamp) VALUES (%s, %s, %s, %s, %s, %s, %s)",
                array('integer','integer','integer','float','float','integer','integer'),
                array($next_id, 0, $this->getId(), $this->getMinimum(), $max, 0, time())
            );
        }
    }
    
    public function toXML($a_include_header = true, $obligatory_state = "")
    {
        $a_xml_writer = new ilXmlWriter;
        $a_xml_writer->xmlHeader();
        $this->insertXML($a_xml_writer, $a_include_header, $obligatory_state);
        $xml = $a_xml_writer->xmlDumpMem(false);
        if (!$a_include_header) {
            $pos = strpos($xml, "?>");
            $xml = substr($xml, $pos + 2);
        }
        return $xml;
    }
    
    public function insertXML(&$a_xml_writer, $a_include_header = true)
    {
        $attrs = array(
            "id" => $this->getId(),
            "title" => $this->getTitle(),
            "type" => $this->getQuestiontype(),
            "subtype" => $this->getSubtype(),
            "obligatory" => $this->getObligatory()
        );
        $a_xml_writer->xmlStartTag("question", $attrs);
        
        $a_xml_writer->xmlElement("description", null, $this->getDescription());
        $a_xml_writer->xmlElement("author", null, $this->getAuthor());
        $a_xml_writer->xmlStartTag("questiontext");
        $this->addMaterialTag($a_xml_writer, $this->getQuestiontext());
        $a_xml_writer->xmlEndTag("questiontext");

        $a_xml_writer->xmlStartTag("responses");
        switch ($this->getSubtype()) {
            case 3:
                $attrs = array(
                    "id" => "0",
                    "format" => "double"
                );
                if (strlen($this->getMinimum())) {
                    $attrs["min"] = $this->getMinimum();
                }
                if (strlen($this->getMaximum())) {
                    $attrs["max"] = $this->getMaximum();
                }
                break;
            case 4:
                $attrs = array(
                    "id" => "0",
                    "format" => "double"
                );
                if (strlen($this->getMinimum())) {
                    $attrs["min"] = $this->getMinimum();
                }
                if (strlen($this->getMaximum())) {
                    $attrs["max"] = $this->getMaximum();
                }
                break;
            case 5:
                $attrs = array(
                    "id" => "0",
                    "format" => "integer"
                );
                if (strlen($this->getMinimum())) {
                    $attrs["min"] = $this->getMinimum();
                }
                if (strlen($this->getMaximum())) {
                    $attrs["max"] = $this->getMaximum();
                }
                break;
        }
        $a_xml_writer->xmlStartTag("response_num", $attrs);
        $a_xml_writer->xmlEndTag("response_num");

        $a_xml_writer->xmlEndTag("responses");

        if (count($this->material)) {
            if (preg_match("/il_(\d*?)_(\w+)_(\d+)/", $this->material["internal_link"], $matches)) {
                $attrs = array(
                    "label" => $this->material["title"]
                );
                $a_xml_writer->xmlStartTag("material", $attrs);
                $intlink = "il_" . IL_INST_ID . "_" . $matches[2] . "_" . $matches[3];
                if (strcmp($matches[1], "") != 0) {
                    $intlink = $this->material["internal_link"];
                }
                $a_xml_writer->xmlElement("mattext", null, $intlink);
                $a_xml_writer->xmlEndTag("material");
            }
        }
        
        $a_xml_writer->xmlEndTag("question");
    }

    public function getQuestionTypeID()
    {
        $ilDB = $this->db;
        $result = $ilDB->queryF(
            "SELECT questiontype_id FROM svy_qtype WHERE type_tag = %s",
            array('text'),
            array($this->getQuestionType())
        );
        $row = $ilDB->fetchAssoc($result);
        return $row["questiontype_id"];
    }

    public function getQuestionType()
    {
        return "SurveyMetricQuestion";
    }
    
    public function getAdditionalTableName()
    {
        return "svy_qst_metric";
    }
    
    public function &getWorkingDataFromUserInput($post_data)
    {
        $entered_value = $post_data[$this->getId() . "_metric_question"];
        $data = array();
        if (strlen($entered_value)) {
            array_push($data, array("value" => $entered_value));
        }
        return $data;
    }
    
    public function checkUserInput($post_data, $survey_id)
    {
        $entered_value = $post_data[$this->getId() . "_metric_question"];
        // replace german notation with international notation
        $entered_value = str_replace(",", ".", $entered_value);
        
        if ((!$this->getObligatory($survey_id)) && (strlen($entered_value) == 0)) {
            return "";
        }
        
        if (strlen($entered_value) == 0) {
            return $this->lng->txt("survey_question_obligatory");
        }
        
        if (strlen($this->getMinimum())) {
            if ($entered_value < $this->getMinimum()) {
                return $this->lng->txt("metric_question_out_of_bounds");
            }
        }

        if (strlen($this->getMaximum())) {
            if (($this->getMaximum() == 1) && ($this->getMaximum() < $this->getMinimum())) {
                // old &infty; values as maximum
            } else {
                if ($entered_value > $this->getMaximum()) {
                    return $this->lng->txt("metric_question_out_of_bounds");
                }
            }
        }

        if (!is_numeric($entered_value)) {
            return $this->lng->txt("metric_question_not_a_value");
        }

        if (($this->getSubType() == self::SUBTYPE_RATIO_ABSOLUTE) && (intval($entered_value) != doubleval($entered_value))) {
            return $this->lng->txt("metric_question_floating_point");
        }
        return "";
    }
    
    public function saveUserInput($post_data, $active_id, $a_return = false)
    {
        $ilDB = $this->db;
        
        $entered_value = $post_data[$this->getId() . "_metric_question"];
        
        // replace german notation with international notation
        $entered_value = str_replace(",", ".", $entered_value);
        
        if ($a_return) {
            return array(array("value" => $entered_value, "textanswer" => null));
        }
        if (strlen($entered_value) == 0) {
            return;
        }
        
        $next_id = $ilDB->nextId('svy_answer');
        #20216
        $fields = array();
        $fields['answer_id'] = array("integer", $next_id);
        $fields['question_fi'] = array("integer", $this->getId());
        $fields['active_fi'] = array("integer", $active_id);
        $fields['value'] = array("float", (strlen($entered_value)) ? $entered_value : null);
        $fields['textanswer'] = array("clob", null);
        $fields['tstamp'] = array("integer", time());

        $affectedRows = $ilDB->insert("svy_answer", $fields);
    }

    public function importResponses($a_data)
    {
        foreach ($a_data as $id => $data) {
            $this->setMinimum($data["min"]);
            $this->setMaximum($data["max"]);
        }
    }

    public function usableForPrecondition()
    {
        return true;
    }

    public function getAvailableRelations()
    {
        return array("<", "<=", "=", "<>", ">=", ">");
    }

    public function outPreconditionSelectValue(&$template)
    {
        $template->setCurrentBlock("textfield");
        $template->setVariable("TEXTFIELD_VALUE", "");
        $template->parseCurrentBlock();
    }
    
    public function getPreconditionSelectValue($default = "", $title, $variable)
    {
        $step3 = new ilNumberInputGUI($title, $variable);
        $step3->setValue($default);
        return $step3;
    }

    public function getMinMaxText()
    {
        $min = $this->getMinimum();
        $max = $this->getMaximum();
        if (strlen($min) && strlen($max)) {
            return "(" . $min . " " . strtolower($this->lng->txt("to")) . " " . $max . ")";
        } elseif (strlen($min)) {
            return "(&gt;= " . $min . ")";
        } elseif (strlen($max)) {
            return "(&lt;= " . $max . ")";
        } else {
            return "";
        }
    }
}