assessment/classes/class.assMarkSchema.php

Go to the documentation of this file.

<?php
 /*
   +----------------------------------------------------------------------------+
   | ILIAS open source                                                          |
   +----------------------------------------------------------------------------+
   | Copyright (c) 1998-2001 ILIAS open source, University of Cologne           |
   |                                                                            |
   | This program is free software; you can redistribute it and/or              |
   | modify it under the terms of the GNU General Public License                |
   | as published by the Free Software Foundation; either version 2             |
   | of the License, or (at your option) any later version.                     |
   |                                                                            |
   | This program is distributed in the hope that it will be useful,            |
   | but WITHOUT ANY WARRANTY; without even the implied warranty of             |
   | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the              |
   | GNU General Public License for more details.                               |
   |                                                                            |
   | You should have received a copy of the GNU General Public License          |
   | along with this program; if not, write to the Free Software                |
   | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. | 
   +----------------------------------------------------------------------------+
*/

require_once "./assessment/classes/class.assMark.php";
require_once "./assessment/classes/class.ilObjTest.php";

class ASS_MarkSchema {
  var $mark_steps;

  function ASS_MarkSchema() 
  {
    $this->mark_steps = array();
  }

  function create_simple_schema(
    $txt_failed_short = "failed", 
    $txt_failed_official = "failed", 
    $percentage_failed = 0,
                $failed_passed = 0,
    $txt_passed_short = "passed",
    $txt_passed_official = "passed",
    $percentage_passed = 50,
                $passed_passed = 1
  )
  {
    $this->flush();
    $this->add_mark_step($txt_failed_short, $txt_failed_official, $percentage_failed, $failed_passed);
    $this->add_mark_step($txt_passed_short, $txt_passed_official, $percentage_passed, $passed_passed);
  }

  function add_mark_step(
    $txt_short = "", 
    $txt_official = "", 
    $percentage = 0,
                $passed = 0
  )
  {
    $mark = new ASS_Mark($txt_short, $txt_official, $percentage, $passed);
    array_push($this->mark_steps, $mark);
  }

  function saveToDb($test_id)
  {
                global $ilias, $lng;
                $db =& $ilias->db->db;

                $oldmarks = array();
                if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                {
                        $query = sprintf("SELECT * FROM tst_mark WHERE test_fi = %s ORDER BY minimum_level",
                                $db->quote($test_id)
                        );
                        $result = $db->query($query);
                        if ($result->numRows())
                        {
                                while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
                                {
                                        $oldmarks[$row["minimum_level"]] = $row;
                                }
                        }
                }
                
    if (!$test_id) return;
    // Delete all entries
    $query = sprintf("DELETE FROM tst_mark WHERE test_fi = %s",
      $db->quote($test_id)
    );
    $result = $db->query($query);
    if (count($this->mark_steps) == 0) return;
    
    // Write new datasets
    foreach ($this->mark_steps as $key => $value) 
                {
      $query = sprintf("INSERT INTO tst_mark (mark_id, test_fi, short_name, official_name, minimum_level, passed, TIMESTAMP) VALUES (NULL, %s, %s, %s, %s, %s, NULL)",
        $db->quote($test_id),
        $db->quote($value->get_short_name()), 
        $db->quote($value->get_official_name()), 
        $db->quote($value->get_minimum_level()),
        $db->quote(sprintf("%d", $value->get_passed()))
      );
      $result = $db->query($query);
      if ($result == DB_OK) {
      }
    }
                if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                {
                        $query = sprintf("SELECT * FROM tst_mark WHERE test_fi = %s ORDER BY minimum_level",
                                $db->quote($test_id)
                        );
                        $result = $db->query($query);
                        $newmarks = array();
                        if ($result->numRows())
                        {
                                while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
                                {
                                        $newmarks[$row["minimum_level"]] = $row;
                                }
                        }
                        foreach ($oldmarks as $level => $row)
                        {
                                if (array_key_exists($level, $newmarks))
                                {
                                        $difffields = array();
                                        foreach ($row as $key => $value)
                                        {
                                                if (strcmp($value, $newmarks[$level][$key]) != 0)
                                                {
                                                        switch ($key)
                                                        {
                                                                case "mark_id":
                                                                case "TIMESTAMP":
                                                                        break;
                                                                default:
                                                                        array_push($difffields, "$key: $value => " .$newmarks[$level][$key]); 
                                                                        break;
                                                        }
                                                }
                                        }
                                        if (count($difffields))
                                        {
                                                $this->logAction($test_id, $lng->txt("log_mark_changed") . ": " . join($difffields, ", "));
                                        }
                                }
                                else
                                {
                                        $this->logAction($test_id, $lng->txt("log_mark_removed") . ": " . 
                                                $lng->txt("tst_mark_minimum_level") . " = " . $row["minimum_level"] . ", " .
                                                $lng->txt("tst_mark_short_form") . " = " . $row["short_name"] . ", " .
                                                $lng->txt("tst_mark_official_form") . " = " . $row["official_name"] . ", " .
                                                $lng->txt("tst_mark_passed") . " = " . $row["passed"]);
                                }
                        }
                        foreach ($newmarks as $level => $row)
                        {
                                if (!array_key_exists($level, $oldmarks))
                                {
                                        $this->logAction($test_id, $lng->txt("log_mark_added") . ": " . 
                                                $lng->txt("tst_mark_minimum_level") . " = " . $row["minimum_level"] . ", " .
                                                $lng->txt("tst_mark_short_form") . " = " . $row["short_name"] . ", " .
                                                $lng->txt("tst_mark_official_form") . " = " . $row["official_name"] . ", " .
                                                $lng->txt("tst_mark_passed") . " = " . $row["passed"]);
                                }
                        }
                }
  }

  function loadFromDb($test_id)
  {
                global $ilias;
                $db =& $ilias->db->db;
                
    if (!$test_id) return;
    $query = sprintf("SELECT * FROM tst_mark WHERE test_fi = %s ORDER BY minimum_level",
      $db->quote($test_id)
    );

    $result = $db->query($query);
    if (strcmp(strtolower(get_class($result)), db_result) == 0) {
      while ($data = $result->fetchRow(DB_FETCHMODE_OBJECT)) {
        $this->add_mark_step($data->short_name, $data->official_name, $data->minimum_level, $data->passed);
      }
    }
  }
  
  function flush() {
    $this->mark_steps = array();
  }
  
  function sort() {
    function level_sort($a, $b) {
      if ($a->get_minimum_level() == $b->get_minimum_level()) {
        $res = strcmp($a->get_short_name(), $b->get_short_name());
        if ($res == 0) {
          return strcmp($a->get_official_name(), $b->get_official_name());
        } else {
          return $res;
        }
      }
      return ($a->get_minimum_level() < $b->get_minimum_level()) ? -1 : 1;
    }
    
    usort($this->mark_steps, 'level_sort');
  }
  
  function delete_mark_step($index = 0) {
    if ($index < 0) return;
    if (count($this->mark_steps) < 1) return;
    if ($index >= count($this->mark_steps)) return;
    unset($this->mark_steps[$index]);
    $this->mark_steps = array_values($this->mark_steps);
  }

  function delete_mark_steps($indexes) {
    foreach ($indexes as $key => $index) {
      if (!(($index < 0) or (count($this->mark_steps) < 1))) {
        unset($this->mark_steps[$index]);
      }
    }
    $this->mark_steps = array_values($this->mark_steps);
  }

  function get_matching_mark($percentage) {
    for ($i = count($this->mark_steps) - 1; $i >= 0; $i--) {
      if ($percentage >= $this->mark_steps[$i]->get_minimum_level()) {
        return $this->mark_steps[$i];
      }
    }
                return false;
  }
  
        function checkMarks()
        {
                $minimum_percentage = 100;
                $passed = 0;
    for ($i = 0; $i < count($this->mark_steps); $i++) {
                        if ($this->mark_steps[$i]->get_minimum_level() < $minimum_percentage)
                        {
                                $minimum_percentage = $this->mark_steps[$i]->get_minimum_level();
                        }
                        if ($this->mark_steps[$i]->get_passed())
                        {
                                $passed++;
                        }
    }
                if ($minimum_percentage != 0)
                {
                        return "min_percentage_ne_0";
                }
                if ($passed == 0)
                {
                        return "no_passed_mark";
                }
                return true;
        }

        function logAction($test_id, $logtext = "")
        {
                global $ilUser, $ilDB;

                $query = sprintf("INSERT INTO ass_log (ass_log_id, user_fi, obj_fi, logtext, question_fi, original_fi, TIMESTAMP) VALUES (NULL, %s, %s, %s, NULL, NULL, NULL)",
                        $ilDB->quote($ilUser->id . ""),
                        $ilDB->quote(ilObjTest::_getObjectIDFromTestID($test_id) . ""),
                        $ilDB->quote($logtext . "")
                );
                $result = $ilDB->query($query);
        }
}

?>