class.ilExAssignment.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */

class ilExAssignment
{
        const TYPE_UPLOAD = 1;
        const TYPE_BLOG = 2;
        const TYPE_PORTFOLIO = 3;
        const TYPE_UPLOAD_TEAM = 4;
        const TYPE_TEXT = 5;
        
        const FEEDBACK_DATE_DEADLINE = 1;
        const FEEDBACK_DATE_SUBMISSION = 2;
        
        const PEER_REVIEW_VALID_NONE = 1;
        const PEER_REVIEW_VALID_ONE = 2;
        const PEER_REVIEW_VALID_ALL = 3;
        
        protected $id;
        protected $exc_id;
        protected $type;
        protected $start_time;
        protected $deadline;
        protected $deadline2;
        protected $instruction;
        protected $title;
        protected $mandatory;
        protected $order_nr;
        protected $peer;
        protected $peer_min;
        protected $peer_unlock;
        protected $peer_dl;
        protected $peer_valid;
        protected $peer_file;
        protected $peer_personal;
        protected $peer_char;
        protected $peer_text;
        protected $peer_rating;
        protected $peer_crit_cat;
        protected $feedback_file;
        protected $feedback_cron;
        protected $feedback_date;
        protected $team_tutor = false;
        protected $max_file;
        
        protected $member_status = array(); // [array]
        
        function __construct($a_id = 0)
        {
                $this->setType(self::TYPE_UPLOAD);
                $this->setFeedbackDate(self::FEEDBACK_DATE_DEADLINE);
                
                if ($a_id > 0)
                {
                        $this->setId($a_id);
                        $this->read();
                }
        }
                        
        public static function getInstancesByExercise($a_exc_id)
        {
                global $ilDB;
                
                $set = $ilDB->query("SELECT * FROM exc_assignment ".
                        " WHERE exc_id = ".$ilDB->quote($a_exc_id, "integer").
                        " ORDER BY order_nr ASC");
                $data = array();

                $order_val = 10;
                while ($rec = $ilDB->fetchAssoc($set))
                {
                        // ???
                        $rec["order_val"] = $order_val;
                        
                        $ass = new self();
                        $ass->initFromDB($rec);
                        $data[] = $ass;
                        
                        $order_val += 10;
                }
                
                return $data;
        }
        
        public function hasTeam()
        {
                return $this->type == self::TYPE_UPLOAD_TEAM;
        }
        
        function setId($a_val)
        {
                $this->id = $a_val;
        }
        
        function getId()
        {
                return $this->id;
        }

        function setExerciseId($a_val)
        {
                $this->exc_id = $a_val;
        }
        
        function getExerciseId()
        {
                return $this->exc_id;
        }
        
        function setStartTime($a_val)
        {
                $this->start_time = $a_val;
        }
        
        function getStartTime()
        {
                return $this->start_time;
        }

        function setDeadline($a_val)
        {
                $this->deadline = $a_val;
        }
        
        function getDeadline()
        {
                return $this->deadline;
        }
        
        function getPersonalDeadline($a_user_id)
        {
                global $ilDB;
                
                $is_team = false;
                if($this->getType() == self::TYPE_UPLOAD_TEAM)
                {
                        include_once("./Modules/Exercise/classes/class.ilExAssignmentTeam.php");
                        $team_id = ilExAssignmentTeam::getTeamId($this->getId(), $a_user_id);
                        if(!$team_id)
                        {
                                // #0021043
                                $this->getDeadline();
                        }
                        $a_user_id = $team_id;
                        $is_team = true;
                }
                
                $set = $ilDB->query("SELECT tstamp FROM exc_idl".
                        " WHERE ass_id = ".$ilDB->quote($this->getId(), "integer").
                        " AND member_id = ".$ilDB->quote($a_user_id, "integer").
                        " AND is_team = ".$ilDB->quote($is_team, "integer"));
                $row = $ilDB->fetchAssoc($set);
                
                // use assignment deadline if no direct personal
                return max($row["tstamp"], $this->getDeadline());
        }
        
        protected function getLastPersonalDeadline()
        {
                global $ilDB;
                
                $set = $ilDB->query("SELECT MAX(tstamp) FROM exc_idl".
                        " WHERE ass_id = ".$ilDB->quote($this->getId(), "integer"));
                $row = $ilDB->fetchAssoc($set);
                return $row["tstamp"];
        }
        
        function setExtendedDeadline($a_val)
        {
                if($a_val !== null)
                {
                        $a_val = (int)$a_val;
                }
                $this->deadline2 = $a_val;
        }
        
        function getExtendedDeadline()
        {
                return $this->deadline2;
        }

        function setInstruction($a_val)
        {
                $this->instruction = $a_val;
        }
        
        function getInstruction()
        {
                return $this->instruction;
        }

        function setTitle($a_val)
        {
                $this->title = $a_val;
        }
        
        function getTitle()
        {
                return $this->title;
        }

        function setMandatory($a_val)
        {
                $this->mandatory = $a_val;
        }
        
        function getMandatory()
        {
                return $this->mandatory;
        }

        function setOrderNr($a_val)
        {
                $this->order_nr = $a_val;
        }
        
        function getOrderNr()
        {
                return $this->order_nr;
        }
        
        function setType($a_value)
        {
                if($this->isValidType($a_value))
                {
                        $this->type = (int)$a_value;
                        
                        if($this->type == self::TYPE_UPLOAD_TEAM)
                        {
                                $this->setPeerReview(false);
                        }
                }
        }
        
        function getType()
        {
                return $this->type;
        }
        
        function isValidType($a_value)
        {
                if(in_array((int)$a_value, array(self::TYPE_UPLOAD, self::TYPE_BLOG, 
                        self::TYPE_PORTFOLIO, self::TYPE_UPLOAD_TEAM, self::TYPE_TEXT)))
                {
                        return true;
                }
                return false;
        }
        
        function setPeerReview($a_value)
        {
                $this->peer = (bool)$a_value;
        }
        
        function getPeerReview()
        {
                return (bool)$this->peer;
        }
        
        function setPeerReviewMin($a_value)
        {
                $this->peer_min = (int)$a_value;
        }
        
        function getPeerReviewMin()
        {
                return (int)$this->peer_min;
        }
        
        function setPeerReviewSimpleUnlock($a_value)
        {
                $this->peer_unlock = (bool)$a_value;
        }
        
        function getPeerReviewSimpleUnlock()
        {
                return (bool)$this->peer_unlock;
        }
        
        function setPeerReviewDeadline($a_val)
        {
                $this->peer_dl = $a_val;
        }
        
        function getPeerReviewDeadline()
        {
                return $this->peer_dl;
        }
        
        function setPeerReviewValid($a_value)
        {
                $this->peer_valid = (int)$a_value;
        }
        
        function getPeerReviewValid()
        {
                return (int)$this->peer_valid;
        }
        
        function setPeerReviewRating($a_val)
        {
                $this->peer_rating = (bool)$a_val;
        }
        
        function hasPeerReviewRating()
        {
                return $this->peer_rating;
        }
        
        function setPeerReviewText($a_val)
        {
                $this->peer_text = (bool)$a_val;
        }
        
        function hasPeerReviewText()
        {
                return $this->peer_text;
        }
        
        function setPeerReviewFileUpload($a_val)
        {
                $this->peer_file = (bool)$a_val;
        }
        
        function hasPeerReviewFileUpload()
        {
                return $this->peer_file;
        }
        
        function setPeerReviewPersonalized($a_val)
        {
                $this->peer_personal = (bool)$a_val;
        }
        
        function hasPeerReviewPersonalized()
        {
                return $this->peer_personal;
        }       
        
        function setPeerReviewChars($a_value)
        {
                $a_value = (is_numeric($a_value) && (int)$a_value > 0)
                        ? (int)$a_value
                        : null;         
                $this->peer_char = $a_value;
        }
        
        function getPeerReviewChars()
        {
                return $this->peer_char;
        }
        
        function setPeerReviewCriteriaCatalogue($a_value)
        {
                $a_value = is_numeric($a_value)
                        ? (int)$a_value
                        : null;         
                $this->crit_cat = $a_value;
        }
        
        function getPeerReviewCriteriaCatalogue()
        {
                return $this->crit_cat;
        }
        
        function getPeerReviewCriteriaCatalogueItems()
        {
                include_once "Modules/Exercise/classes/class.ilExcCriteria.php";
                
                if($this->crit_cat)
                {                       
                        return ilExcCriteria::getInstancesByParentId($this->crit_cat);
                }
                else
                {
                        $res = array();
                        
                        if($this->peer_rating)
                        {
                                $res[] = ilExcCriteria::getInstanceByType("rating");
                        }
                        
                        if($this->peer_text)
                        {
                                $crit = ilExcCriteria::getInstanceByType("text");                               
                                if($this->peer_char)
                                {
                                        $crit->setMinChars($this->peer_char);
                                }
                                $res[] = $crit;
                        }
                        
                        if($this->peer_file)
                        {
                                $res[] = ilExcCriteria::getInstanceByType("file");
                        }
                        
                        return $res;
                }
        }
        
        function setFeedbackFile($a_value)
        {
                $this->feedback_file = (string)$a_value;
        }
        
        function getFeedbackFile()
        {
                return (string)$this->feedback_file;
        }
        
        function setFeedbackCron($a_value)
        {
                $this->feedback_cron = (string)$a_value;
        }
        
        function hasFeedbackCron()
        {
                return (bool)$this->feedback_cron;
        }
        
        function setFeedbackDate($a_value)
        {
                $this->feedback_date = (int)$a_value;
        }
        
        function getFeedbackDate()
        {
                return (int)$this->feedback_date;
        }
        
        function setTeamTutor($a_value)
        {
                $this->team_tutor = (bool)$a_value;
        }
        
        function getTeamTutor()
        {
                return $this->team_tutor;
        }
        
        function setMaxFile($a_value)
        {
                if($a_value !== null)
                {
                        $a_value = (int)$a_value;
                }
                $this->max_file = $a_value;
        }
        
        function getMaxFile()
        {
                return $this->max_file;
        }

        function read()
        {
                global $ilDB;
                
                $set = $ilDB->query("SELECT * FROM exc_assignment ".
                        " WHERE id = ".$ilDB->quote($this->getId(), "integer")
                        );
                $rec = $ilDB->fetchAssoc($set);
                
                // #16172 - might be deleted
                if(is_array($rec))
                {
                        $this->initFromDB($rec);                
                }
        }
        
        protected function initFromDB(array $a_set)
        {
                $this->setId($a_set["id"]);
                $this->setExerciseId($a_set["exc_id"]);
                $this->setDeadline($a_set["time_stamp"]);
                $this->setExtendedDeadline($a_set["deadline2"]);
                $this->setInstruction($a_set["instruction"]);
                $this->setTitle($a_set["title"]);
                $this->setStartTime($a_set["start_time"]);
                $this->setOrderNr($a_set["order_nr"]);
                $this->setMandatory($a_set["mandatory"]);
                $this->setType($a_set["type"]);
                $this->setPeerReview($a_set["peer"]);
                $this->setPeerReviewMin($a_set["peer_min"]);
                $this->setPeerReviewSimpleUnlock($a_set["peer_unlock"]);
                $this->setPeerReviewDeadline($a_set["peer_dl"]);
                $this->setPeerReviewValid($a_set["peer_valid"]);
                $this->setPeerReviewFileUpload($a_set["peer_file"]);
                $this->setPeerReviewPersonalized($a_set["peer_prsl"]);
                $this->setPeerReviewChars($a_set["peer_char"]);
                $this->setPeerReviewText($a_set["peer_text"]);
                $this->setPeerReviewRating($a_set["peer_rating"]);
                $this->setPeerReviewCriteriaCatalogue($a_set["peer_crit_cat"]);
                $this->setFeedbackFile($a_set["fb_file"]);
                $this->setFeedbackDate($a_set["fb_date"]);
                $this->setFeedbackCron($a_set["fb_cron"]);
                $this->setTeamTutor($a_set["team_tutor"]);
                $this->setMaxFile($a_set["max_file"]);          
        }
        
        function save()
        {
                global $ilDB;
                
                if ($this->getOrderNr() == 0)
                {
                        $this->setOrderNr(
                                self::lookupMaxOrderNrForEx($this->getExerciseId())
                                + 10);
                }
                
                $next_id = $ilDB->nextId("exc_assignment");
                $ilDB->insert("exc_assignment", array(
                        "id" => array("integer", $next_id),
                        "exc_id" => array("integer", $this->getExerciseId()),
                        "time_stamp" => array("integer", $this->getDeadline()),
                        "deadline2" => array("integer", $this->getExtendedDeadline()),
                        "instruction" => array("clob", $this->getInstruction()),
                        "title" => array("text", $this->getTitle()),
                        "start_time" => array("integer", $this->getStartTime()),
                        "order_nr" => array("integer", $this->getOrderNr()),
                        "mandatory" => array("integer", $this->getMandatory()),
                        "type" => array("integer", $this->getType()),
                        "peer" => array("integer", $this->getPeerReview()),
                        "peer_min" => array("integer", $this->getPeerReviewMin()),
                        "peer_unlock" => array("integer", $this->getPeerReviewSimpleUnlock()),
                        "peer_dl" => array("integer", $this->getPeerReviewDeadline()),
                        "peer_valid" => array("integer", $this->getPeerReviewValid()),
                        "peer_file" => array("integer", $this->hasPeerReviewFileUpload()),
                        "peer_prsl" => array("integer", $this->hasPeerReviewPersonalized()),
                        "peer_char" => array("integer", $this->getPeerReviewChars()),
                        "peer_text" => array("integer", (int) $this->hasPeerReviewText()),
                        "peer_rating" => array("integer", (int) $this->hasPeerReviewRating()),
                        "peer_crit_cat" => array("integer", $this->getPeerReviewCriteriaCatalogue()),
                        "fb_file" => array("text", $this->getFeedbackFile()),
                        "fb_date" => array("integer", $this->getFeedbackDate()),
                        "fb_cron" => array("integer", $this->hasFeedbackCron()),
                        "team_tutor" => array("integer", $this->getTeamTutor()),
                        "max_file" => array("integer", $this->getMaxFile())
                        ));
                $this->setId($next_id);
                $exc = new ilObjExercise($this->getExerciseId(), false);
                $exc->updateAllUsersStatus();
                self::createNewAssignmentRecords($next_id, $exc);
                
                $this->handleCalendarEntries("create");
        }
        
        function update()
        {               
                global $ilDB;
                
                $ilDB->update("exc_assignment",
                        array(
                        "exc_id" => array("integer", $this->getExerciseId()),
                        "time_stamp" => array("integer", $this->getDeadline()),
                        "deadline2" => array("integer", $this->getExtendedDeadline()),
                        "instruction" => array("clob", $this->getInstruction()),
                        "title" => array("text", $this->getTitle()),
                        "start_time" => array("integer", $this->getStartTime()),
                        "order_nr" => array("integer", $this->getOrderNr()),
                        "mandatory" => array("integer", $this->getMandatory()),
                        "type" => array("integer", $this->getType()),
                        "peer" => array("integer", $this->getPeerReview()),
                        "peer_min" => array("integer", $this->getPeerReviewMin()),
                        "peer_unlock" => array("integer", $this->getPeerReviewSimpleUnlock()),
                        "peer_dl" => array("integer", $this->getPeerReviewDeadline()),
                        "peer_valid" => array("integer", $this->getPeerReviewValid()),
                        "peer_file" => array("integer", $this->hasPeerReviewFileUpload()),
                        "peer_prsl" => array("integer", $this->hasPeerReviewPersonalized()),
                        "peer_char" => array("integer", $this->getPeerReviewChars()),
                        "peer_text" => array("integer", (int) $this->hasPeerReviewText()),
                        "peer_rating" => array("integer", (int) $this->hasPeerReviewRating()),
                        "peer_crit_cat" => array("integer", $this->getPeerReviewCriteriaCatalogue()),
                        "fb_file" => array("text", $this->getFeedbackFile()),
                        "fb_date" => array("integer", $this->getFeedbackDate()),
                        "fb_cron" => array("integer", $this->hasFeedbackCron()),
                        "team_tutor" => array("integer", $this->getTeamTutor()),
                        "max_file" => array("integer", $this->getMaxFile())
                        ),
                        array(
                        "id" => array("integer", $this->getId()),
                        ));
                $exc = new ilObjExercise($this->getExerciseId(), false);
                $exc->updateAllUsersStatus();
                
                $this->handleCalendarEntries("update");
        }
        
        function delete()
        {
                global $ilDB;
                
                $this->deleteGlobalFeedbackFile();
                
                $ilDB->manipulate("DELETE FROM exc_assignment WHERE ".
                        " id = ".$ilDB->quote($this->getId(), "integer")
                        );
                $exc = new ilObjExercise($this->getExerciseId(), false);
                $exc->updateAllUsersStatus();
                
                $this->handleCalendarEntries("delete");
        }
        
        
        static function getAssignmentDataOfExercise($a_exc_id)
        {
                global $ilDB;
                
                // should be changed to self::getInstancesByExerciseId()
                
                $set = $ilDB->query("SELECT * FROM exc_assignment ".
                        " WHERE exc_id = ".$ilDB->quote($a_exc_id, "integer").
                        " ORDER BY order_nr ASC");
                $data = array();

                $order_val = 10;
                while ($rec = $ilDB->fetchAssoc($set))
                {
                        
                        $data[] = array(
                                "id" => $rec["id"],
                                "exc_id" => $rec["exc_id"],
                                "deadline" => $rec["time_stamp"],
                                "deadline2" => $rec["deadline2"],
                                "instruction" => $rec["instruction"],
                                "title" => $rec["title"],
                                "start_time" => $rec["start_time"],
                                "order_val" => $order_val,
                                "mandatory" => $rec["mandatory"],
                                "type" => $rec["type"],
                                "peer" => $rec["peer"],
                                "peer_min" => $rec["peer_min"],
                                "peer_dl" => $rec["peer_dl"],
                                "peer_file" => $rec["peer_file"],
                                "peer_prsl" => $rec["peer_prsl"],
                                "fb_file" => $rec["fb_file"],
                                "fb_date" => $rec["fb_date"],
                                "fb_cron" => $rec["fb_cron"],
                                );
                        $order_val += 10;
                }
                return $data;
        }
        
        static function cloneAssignmentsOfExercise($a_old_exc_id, $a_new_exc_id, array $a_crit_cat_map)
        {
                $ass_data = self::getInstancesByExercise($a_old_exc_id);
                foreach ($ass_data as $d)
                {                       
                        // clone assignment
                        $new_ass = new ilExAssignment();
                        $new_ass->setExerciseId($a_new_exc_id);
                        $new_ass->setTitle($d->getTitle());
                        $new_ass->setDeadline($d->getDeadline());
                        $new_ass->setExtendedDeadline($d->getExtendedDeadline());
                        $new_ass->setInstruction($d->getInstruction());
                        $new_ass->setMandatory($d->getMandatory());
                        $new_ass->setOrderNr($d->getOrderNr());
                        $new_ass->setStartTime($d->getStartTime());
                        $new_ass->setType($d->getType());
                        $new_ass->setPeerReview($d->getPeerReview());
                        $new_ass->setPeerReviewMin($d->getPeerReviewMin());
                        $new_ass->setPeerReviewDeadline($d->getPeerReviewDeadline());
                        $new_ass->setPeerReviewFileUpload($d->hasPeerReviewFileUpload());
                        $new_ass->setPeerReviewPersonalized($d->hasPeerReviewPersonalized());
                        $new_ass->setPeerReviewValid($d->getPeerReviewValid());
                        $new_ass->setPeerReviewChars($d->getPeerReviewChars());
                        $new_ass->setPeerReviewText($d->hasPeerReviewText());
                        $new_ass->setPeerReviewRating($d->hasPeerReviewRating());
                        $new_ass->setPeerReviewCriteriaCatalogue($d->getPeerReviewCriteriaCatalogue());
                        $new_ass->setPeerReviewSimpleUnlock($d->getPeerReviewSimpleUnlock());
                        $new_ass->setPeerReviewText($d->hasPeerReviewText());
                        $new_ass->setPeerReviewRating($d->hasPeerReviewRating());                       
                        $new_ass->setFeedbackFile($d->getFeedbackFile());
                        $new_ass->setFeedbackDate($d->getFeedbackDate());
                        $new_ass->setFeedbackCron($d->hasFeedbackCron()); // #16295
                        $new_ass->setTeamTutor($d->getTeamTutor());
                        $new_ass->setMaxFile($d->getMaxFile());
                        
                        // criteria catalogue(s)
                        if($d->getPeerReviewCriteriaCatalogue() &&
                                array_key_exists($d->getPeerReviewCriteriaCatalogue(), $a_crit_cat_map))
                        {
                                $new_ass->setPeerReviewCriteriaCatalogue($a_crit_cat_map[$d->getPeerReviewCriteriaCatalogue()]);
                        }                       
                        
                        $new_ass->save();
                        
                        include_once("./Modules/Exercise/classes/class.ilFSStorageExercise.php");
                        $old_storage = new ilFSStorageExercise($a_old_exc_id, (int) $d->getId());
                        $new_storage = new ilFSStorageExercise($a_new_exc_id, (int) $new_ass->getId());
                        $new_storage->create();
                        
                        // clone assignment files               
                        if (is_dir($old_storage->getPath()))
                        {
                                ilUtil::rCopy($old_storage->getPath(), $new_storage->getPath());
                        }
                        
                        // clone global feedback file                   
                        if (is_dir($old_storage->getGlobalFeedbackPath()))
                        {
                                ilUtil::rCopy($old_storage->getGlobalFeedbackPath(), $new_storage->getGlobalFeedbackPath());
                        }
                }
        }
        
        public function getFiles()
        {
                include_once("./Modules/Exercise/classes/class.ilFSStorageExercise.php");
                $storage = new ilFSStorageExercise($this->getExerciseId(), $this->getId());
                return $storage->getFiles();
        }
        
        static function lookupMaxOrderNrForEx($a_exc_id)
        {
                global $ilDB;
                
                $set = $ilDB->query("SELECT MAX(order_nr) mnr FROM exc_assignment ".
                        " WHERE exc_id = ".$ilDB->quote($a_exc_id, "integer")
                        );
                while ($rec = $ilDB->fetchAssoc($set))
                {
                        return (int) $rec["mnr"];
                }
                return 0;
        }
        
        public static function lookupAssignmentOnline($a_ass_id)
        {
                global $ilDB;
                
                $query = "SELECT id FROM exc_assignment ".
                        "WHERE start_time <= ".$ilDB->quote(time(),'integer').' '.
                        "AND time_stamp >= ".$ilDB->quote(time(),'integer').' '.
                        "AND id = ".$ilDB->quote($a_ass_id,'integer');
                $res = $ilDB->query($query);
                
                return $res->numRows() ? true : false;
        }

        public static function lookupExerciseId($a_ass_id)
        {
                global $DIC;

                $ilDB = $DIC->database();

                $query = "SELECT exc_id FROM exc_assignment ".
                        "WHERE id = ".$ilDB->quote($a_ass_id,'integer');
                $res = $ilDB->fetchAssoc($ilDB->query($query));

                return (int) $res["exc_id"];
        }

        private static function lookup($a_id, $a_field)
        {
                global $ilDB;
                
                $set = $ilDB->query("SELECT ".$a_field." FROM exc_assignment ".
                        " WHERE id = ".$ilDB->quote($a_id, "integer")
                        );

                $rec = $ilDB->fetchAssoc($set);

                return $rec[$a_field];
        }
        
        static function lookupTitle($a_id)
        {
                return self::lookup($a_id, "title");
        }
        
        static function lookupType($a_id)
        {
                return self::lookup($a_id, "type");
        }
        
        function saveAssOrderOfExercise($a_ex_id, $a_order)
        {
                global $ilDB;
                
                $result_order = array();
                asort($a_order);
                $nr = 10;
                foreach ($a_order as $k => $v)
                {
                        // the check for exc_id is for security reasons. ass ids are unique.
                        $ilDB->manipulate($t = "UPDATE exc_assignment SET ".
                                " order_nr = ".$ilDB->quote($nr, "integer").
                                " WHERE id = ".$ilDB->quote((int) $k, "integer").
                                " AND exc_id = ".$ilDB->quote((int) $a_ex_id, "integer")
                                );
                        $nr+=10;
                }
        }
        
        static function orderAssByDeadline($a_ex_id)
        {
                global $ilDB;

                $set = $ilDB->query("SELECT id FROM exc_assignment ".
                        " WHERE exc_id = ".$ilDB->quote($a_ex_id, "integer").
                        " ORDER BY time_stamp ASC"
                        );
                $nr = 10;
                while ($rec  = $ilDB->fetchAssoc($set))
                {
                        $ilDB->manipulate("UPDATE exc_assignment SET ".
                                " order_nr = ".$ilDB->quote($nr, "integer").
                                " WHERE id = ".$ilDB->quote($rec["id"], "integer")
                                );
                        $nr += 10;
                }
        }

        static function countMandatory($a_ex_id)
        {
                global $ilDB;
                
                $set = $ilDB->query("SELECT count(*) cntm FROM exc_assignment ".
                        " WHERE exc_id = ".$ilDB->quote($a_ex_id, "integer").
                        " AND mandatory = ".$ilDB->quote(1, "integer")
                        );
                $rec = $ilDB->fetchAssoc($set);
                return $rec["cntm"];
        }


        static function lookupUpdatedSubmission($ass_id, $member_id)
        {
                global $ilDB, $lng;
                
                // team upload?
                $user_ids = self::getTeamMembersByAssignmentId($ass_id, $member_id);
                if(!$user_ids)
                {
                        $user_ids = array($member_id);
                }

                $q="SELECT exc_mem_ass_status.status_time, exc_returned.ts ".
                        "FROM exc_mem_ass_status, exc_returned ".
                        "WHERE exc_mem_ass_status.status_time < exc_returned.ts ".
                        "AND NOT exc_mem_ass_status.status_time IS NULL ".
                        "AND exc_returned.ass_id = exc_mem_ass_status.ass_id ".
                        "AND exc_returned.user_id = exc_mem_ass_status.usr_id ".
                        "AND exc_returned.ass_id=".$ilDB->quote($ass_id, "integer").
                        " AND ".$ilDB->in("exc_returned.user_id", $user_ids, "", "integer");

                $usr_set = $ilDB->query($q);

                $array = $ilDB->fetchAssoc($usr_set);

                if (count($array)==0)
                {
                        return 0;
                }
                else
                {
                        return 1;
                }

        }

        function getMemberListData()
        {
                global $ilDB;

                $mem = array();
                
                // first get list of members from member table
                $set = $ilDB->query("SELECT ud.usr_id, ud.lastname, ud.firstname, ud.login".
                        " FROM exc_members excm".
                        " JOIN usr_data ud ON (ud.usr_id = excm.usr_id)".
                        " WHERE excm.obj_id = ".$ilDB->quote($this->getExerciseId(), "integer"));
                while($rec = $ilDB->fetchAssoc($set))
                {                       
                        $mem[$rec["usr_id"]] =
                                array(
                                "name" => $rec["lastname"].", ".$rec["firstname"],
                                "login" => $rec["login"],
                                "usr_id" => $rec["usr_id"],
                                "lastname" => $rec["lastname"],
                                "firstname" => $rec["firstname"]
                                );                      
                }
                
                include_once "Modules/Exercise/classes/class.ilExSubmission.php";

                $q = "SELECT * FROM exc_mem_ass_status ".
                        "WHERE ass_id = ".$ilDB->quote($this->getId(), "integer");
                $set = $ilDB->query($q);
                while($rec = $ilDB->fetchAssoc($set))
                {
                        if (isset($mem[$rec["usr_id"]]))
                        {
                                $sub = new ilExSubmission($this, $rec["usr_id"]);
                                
                                $mem[$rec["usr_id"]]["sent_time"] = $rec["sent_time"];
                                $mem[$rec["usr_id"]]["submission"] = $sub->getLastSubmission();
                                $mem[$rec["usr_id"]]["status_time"] = $rec["status_time"];
                                $mem[$rec["usr_id"]]["feedback_time"] = $rec["feedback_time"];
                                $mem[$rec["usr_id"]]["notice"] = $rec["notice"];
                                $mem[$rec["usr_id"]]["status"] = $rec["status"];
                                $mem[$rec["usr_id"]]["mark"] = $rec["mark"];
                                $mem[$rec["usr_id"]]["comment"] = $rec["u_comment"];
                        }
                }
                return $mem;
        }
        
        static function createNewUserRecords($a_user_id, $a_exc_id)
        {
                global $ilDB;
                
                $ass_data = self::getAssignmentDataOfExercise($a_exc_id);
                foreach ($ass_data as $ass)
                {
//echo "-".$ass["id"]."-".$a_user_id."-";
                        $ilDB->replace("exc_mem_ass_status", array(
                                "ass_id" => array("integer", $ass["id"]),
                                "usr_id" => array("integer", $a_user_id)
                                ), array(
                                "status" => array("text", "notgraded")
                                ));
                }
        }
        
        static function createNewAssignmentRecords($a_ass_id, $a_exc)
        {
                global $ilDB;
                
                include_once("./Modules/Exercise/classes/class.ilExerciseMembers.php");
                $exmem = new ilExerciseMembers($a_exc);
                $mems = $exmem->getMembers();

                foreach ($mems as $mem)
                {
                        $ilDB->replace("exc_mem_ass_status", array(
                                "ass_id" => array("integer", $a_ass_id),
                                "usr_id" => array("integer", $mem)
                                ), array(
                                "status" => array("text", "notgraded")
                                ));
                }
        }

        function uploadAssignmentFiles($a_files)
        {
                include_once("./Modules/Exercise/classes/class.ilFSStorageExercise.php");
                $storage = new ilFSStorageExercise($this->getExerciseId(), $this->getId());
                $storage->create();
                $storage->uploadAssignmentFiles($a_files);
        }
        
        

        function sendMultiFeedbackStructureFile()
        {
                global $ilDB;
                
                
                // send and delete the zip file
                $deliverFilename = trim(str_replace(" ", "_", $this->getTitle()."_".$this->getId()));
                $deliverFilename = ilUtil::getASCIIFilename($deliverFilename);
                $deliverFilename = "multi_feedback_".$deliverFilename;

                $exc = new ilObjExercise($this->getExerciseId(), false);
                
                $cdir = getcwd();
                
                // create temporary directoy
                $tmpdir = ilUtil::ilTempnam();
                ilUtil::makeDir($tmpdir);
                $mfdir = $tmpdir."/".$deliverFilename;
                ilUtil::makeDir($mfdir);
                
                // create subfolders <lastname>_<firstname>_<id> for each participant
                include_once("./Modules/Exercise/classes/class.ilExerciseMembers.php");
                $exmem = new ilExerciseMembers($exc);
                $mems = $exmem->getMembers();

                foreach ($mems as $mem)
                {
                        $name = ilObjUser::_lookupName($mem);
                        $subdir = $name["lastname"]."_".$name["firstname"]."_".$name["login"]."_".$name["user_id"];
                        $subdir = ilUtil::getASCIIFilename($subdir);
                        ilUtil::makeDir($mfdir."/".$subdir);
                }
                
                // create the zip file
                chdir($tmpdir);
                $tmpzipfile = $tmpdir."/multi_feedback.zip";
                ilUtil::zip($tmpdir, $tmpzipfile, true);
                chdir($cdir);
                

                ilUtil::deliverFile($tmpzipfile, $deliverFilename.".zip", "", false, true);
        }
        
        function uploadMultiFeedbackFile($a_file)
        {
                global $lng, $ilUser;
                
                include_once("./Modules/Exercise/exceptions/class.ilExerciseException.php");
                if (!is_file($a_file["tmp_name"]))
                {
                        throw new ilExerciseException($lng->txt("exc_feedback_file_could_not_be_uploaded"));
                }
                
                include_once("./Modules/Exercise/classes/class.ilFSStorageExercise.php");
                $storage = new ilFSStorageExercise($this->getExerciseId(), $this->getId());
                $mfu = $storage->getMultiFeedbackUploadPath($ilUser->getId());
                ilUtil::delDir($mfu, true);
                ilUtil::moveUploadedFile($a_file["tmp_name"], "multi_feedback.zip", $mfu."/"."multi_feedback.zip");
                ilUtil::unzip($mfu."/multi_feedback.zip", true);
                $subdirs = ilUtil::getDir($mfu);
                $subdir = "notfound";
                foreach ($subdirs as $s => $j)
                {
                        if ($j["type"] == "dir" && substr($s, 0, 14) == "multi_feedback")
                        {
                                $subdir = $s;
                        }
                }

                if (!is_dir($mfu."/".$subdir))
                {
                        throw new ilExerciseException($lng->txt("exc_no_feedback_dir_found_in_zip"));
                }

                return true;
        }
        
        function getMultiFeedbackFiles($a_user_id = 0)
        {
                global $ilUser;
                
                if ($a_user_id == 0)
                {
                        $a_user_id = $ilUser->getId();
                }
                
                $mf_files = array();
                
                // get members
                $exc = new ilObjExercise($this->getExerciseId(), false);
                include_once("./Modules/Exercise/classes/class.ilExerciseMembers.php");
                $exmem = new ilExerciseMembers($exc);
                $mems = $exmem->getMembers();

                // read mf directory
                include_once("./Modules/Exercise/classes/class.ilFSStorageExercise.php");
                $storage = new ilFSStorageExercise($this->getExerciseId(), $this->getId());
                $mfu = $storage->getMultiFeedbackUploadPath($ilUser->getId());

                // get subdir that starts with multi_feedback
                $subdirs = ilUtil::getDir($mfu);
                $subdir = "notfound";
                foreach ($subdirs as $s => $j)
                {
                        if ($j["type"] == "dir" && substr($s, 0, 14) == "multi_feedback")
                        {
                                $subdir = $s;
                        }
                }
                
                $items = ilUtil::getDir($mfu."/".$subdir);
                foreach ($items as $k => $i)
                {
                        // check directory
                        if ($i["type"] == "dir" && !in_array($k, array(".", "..")))
                        {
                                // check if valid member id is given
                                $parts = explode("_", $i["entry"]);
                                $user_id = (int) $parts[count($parts) - 1];
                                if (in_array($user_id, $mems))
                                {
                                        // read dir of user
                                        $name = ilObjUser::_lookupName($user_id);
                                        $files = ilUtil::getDir($mfu."/".$subdir."/".$k);
                                        foreach ($files as $k2 => $f)
                                        {
                                                // append files to array
                                                if ($f["type"] == "file" && substr($k2, 0, 1) != ".")
                                                {
                                                        $mf_files[] = array(
                                                                "lastname" => $name["lastname"],
                                                                "firstname" => $name["firstname"],
                                                                "login" => $name["login"],
                                                                "user_id" => $name["user_id"],
                                                                "full_path" => $mfu."/".$subdir."/".$k."/".$k2,
                                                                "file" => $k2);
                                                }
                                        }
                                }
                        }
                }
                return $mf_files;
        }
        
        function clearMultiFeedbackDirectory()
        {
                global $lng, $ilUser;
                
                include_once("./Modules/Exercise/classes/class.ilFSStorageExercise.php");
                $storage = new ilFSStorageExercise($this->getExerciseId(), $this->getId());
                $mfu = $storage->getMultiFeedbackUploadPath($ilUser->getId());
                ilUtil::delDir($mfu);
        }
        
        function saveMultiFeedbackFiles($a_files, ilObjExercise $a_exc)
        {                                       
                if($this->getExerciseId() != $a_exc->getId())
                {
                        return;
                }
                
                include_once("./Modules/Exercise/classes/class.ilFSStorageExercise.php");
                $fstorage = new ilFSStorageExercise($this->getExerciseId(), $this->getId());
                $fstorage->create();
                
                $team_map = array();
                
                $mf_files = $this->getMultiFeedbackFiles();
                foreach ($mf_files as $f)
                {                       
                        $user_id = $f["user_id"];
                        $file_path = $f["full_path"];                           
                        $file_name = $f["file"];
                        
                        // if checked in confirmation gui
                        if ($a_files[$user_id][md5($file_name)] != "")
                        {                       
                                $submission = new ilExSubmission($this, $user_id);
                                $feedback_id = $submission->getFeedbackId();
                                $noti_rec_ids = $submission->getUserIds();
                                
                                if ($feedback_id)
                                {
                                        $fb_path = $fstorage->getFeedbackPath($feedback_id);
                                        $target = $fb_path."/".$file_name;
                                        if (is_file($target))
                                        {
                                                unlink($target);
                                        }
                                        // rename file
                                        rename($file_path, $target);
                                                                                
                                        if ($noti_rec_ids)
                                        {                                               
                                                foreach($noti_rec_ids as $user_id)
                                                {
                                                        $member_status = $this->getMemberStatus($user_id);
                                                        $member_status->setFeedback(true);
                                                        $member_status->update();
                                                }       
                                                
                                                $a_exc->sendFeedbackFileNotification($file_name, $noti_rec_ids,
                                                        (int) $this->getId());
                                        }
                                }                               
                        }
                }
                
                $this->clearMultiFeedbackDirectory();
        }
        
        
        
        
        protected function handleCalendarEntries($a_event)
        {               
                global $ilAppEventHandler;
                
                $dl_id = $this->getId()."0";
                $fbdl_id = $this->getId()."1";
                
                $context_ids = array($dl_id, $fbdl_id);         
                $apps = array();
                
                if($a_event != "delete")
                {                                                                               
                        include_once "Services/Calendar/classes/class.ilCalendarAppointmentTemplate.php";
                        
                        if($this->getDeadline())
                        {                                       
                                $app = new ilCalendarAppointmentTemplate($dl_id);
                                $app->setTranslationType(IL_CAL_TRANSLATION_SYSTEM);
                                $app->setSubtitle("cal_exc_deadline");
                                $app->setTitle($this->getTitle());                              
                                $app->setFullday(false);
                                $app->setStart(new ilDateTime($this->getDeadline(), IL_CAL_UNIX));                      
                                
                                $apps[] = $app;
                        }

                        if($this->getPeerReview() &&
                                $this->getPeerReviewDeadline())
                        {
                                $app = new ilCalendarAppointmentTemplate($fbdl_id);
                                $app->setTranslationType(IL_CAL_TRANSLATION_SYSTEM);
                                $app->setSubtitle("cal_exc_peer_review_deadline");
                                $app->setTitle($this->getTitle());                              
                                $app->setFullday(false);
                                $app->setStart(new ilDateTime($this->getPeerReviewDeadline(), IL_CAL_UNIX));
                                
                                $apps[] = $app;
                        }               
                        
                }                       
                                
                include_once "Modules/Exercise/classes/class.ilObjExercise.php";
                $exc = new ilObjExercise($this->getExerciseId(), false);
                
                $ilAppEventHandler->raise('Modules/Exercise',
                        $a_event.'Assignment',
                        array(
                        'object' => $exc,
                        'obj_id' => $exc->getId(),                      
                        'context_ids' => $context_ids,
                        'appointments' => $apps));              
        }
        
        
        public static function getPendingFeedbackNotifications()
        {
                global $ilDB;
                
                $res = array();
                
                $set = $ilDB->query("SELECT id,fb_file FROM exc_assignment".
                        " WHERE fb_cron = ".$ilDB->quote(1, "integer").
                        " AND fb_date = ".$ilDB->quote(self::FEEDBACK_DATE_DEADLINE, "integer").
                        " AND time_stamp IS NOT NULL".
                        " AND time_stamp > ".$ilDB->quote(0, "integer").                        
                        " AND time_stamp < ".$ilDB->quote(time(), "integer").
                        " AND fb_cron_done = ".$ilDB->quote(0, "integer"));
                while($row = $ilDB->fetchAssoc($set))
                {
                        if(trim($row["fb_file"]))
                        {
                                $res[] = $row["id"];                    
                        }
                }               
        
                return $res;
        }
        
        public static function sendFeedbackNotifications($a_ass_id, $a_user_id = null)
        {
                global $ilDB;
                
                $ass = new self($a_ass_id);
                
                // valid assignment?
                if(!$ass->hasFeedbackCron() || !$ass->getFeedbackFile())
                {
                        return false;
                }               
                
                if(!$a_user_id)
                {
                        // already done?
                        $set = $ilDB->query("SELECT fb_cron_done".
                                " FROM exc_assignment".
                                " WHERE id = ".$ilDB->quote($a_ass_id, "integer"));
                        $row = $ilDB->fetchAssoc($set);
                        if($row["fb_cron_done"])
                        {
                                return false;
                        }
                }
                
                include_once "./Services/Notification/classes/class.ilSystemNotification.php";
                $ntf = new ilSystemNotification();
                $ntf->setLangModules(array("exc"));
                $ntf->setObjId($ass->getExerciseId());
                $ntf->setSubjectLangId("exc_feedback_notification_subject");
                $ntf->setIntroductionLangId("exc_feedback_notification_body");
                $ntf->addAdditionalInfo("exc_assignment", $ass->getTitle());
                $ntf->setGotoLangId("exc_feedback_notification_link");          
                $ntf->setReasonLangId("exc_feedback_notification_reason");      
                
                if(!$a_user_id)
                {
                        include_once "./Modules/Exercise/classes/class.ilExerciseMembers.php";
                        $ntf->sendMail(ilExerciseMembers::_getMembers($ass->getExerciseId()));
                                                
                        $ilDB->manipulate("UPDATE exc_assignment".
                                " SET fb_cron_done = ".$ilDB->quote(1, "integer").
                                " WHERE id = ".$ilDB->quote($a_ass_id, "integer"));
                }
                else
                {               
                        $ntf->sendMail(array($a_user_id));
                }
                
                return true;            
        }
        
        
        // status
        
        public function afterDeadline()
        {
                global $ilUser;
                                
                // :TODO: always current user?
                $idl = $this->getPersonalDeadline($ilUser->getId());
                
                // no deadline === true
                $deadline = max($this->deadline, $this->deadline2, $idl);
                return ($deadline - time() <= 0);
        }
        
        public function afterDeadlineStrict($a_include_personal = true)
        {
                // :TODO: this means that peer feedback, global feedback is available 
                // after LAST personal deadline
                // team management is currently ignoring personal deadlines
                $idl = (bool)$a_include_personal
                        ? $this->getLastPersonalDeadline()
                        : null;
                
                // no deadline === false
                $deadline = max($this->deadline, $this->deadline2, $idl);               
                
                // #18271 - afterDeadline() does not handle last personal deadline
                if($idl && $deadline == $idl)
                {
                        return ($deadline - time() <= 0);
                }
                
                return ($deadline > 0 && 
                        $this->afterDeadline());        
        }
        
        public function beforeDeadline()
        {
                // no deadline === true
                return !$this->afterDeadlineStrict();
        }
        
        public function notStartedYet()
        {
                return (time() - $this->start_time <= 0);
        }
        
        
        // 
        // FEEDBACK FILES
        // 
        
        public function getGlobalFeedbackFileStoragePath()
        {
                include_once("./Modules/Exercise/classes/class.ilFSStorageExercise.php");
                $storage = new ilFSStorageExercise($this->getExerciseId(), $this->getId());
                return $storage->getGlobalFeedbackPath();
        }
        
        function deleteGlobalFeedbackFile()
        {       
                ilUtil::delDir($this->getGlobalFeedbackFileStoragePath());                              
        }       
        
        function handleGlobalFeedbackFileUpload(array $a_file)
        {               
                $path = $this->getGlobalFeedbackFileStoragePath();
                ilUtil::delDir($path, true);
                if (ilUtil::moveUploadedFile($a_file["tmp_name"], $a_file["name"], $path."/".$a_file["name"]))
                {
                        $this->setFeedbackFile($a_file["name"]);                
                        return true;
                }
                return false;
        }
        
        function getGlobalFeedbackFilePath()
        {
                $file = $this->getFeedbackFile();
                if($file)
                {                       
                        $path = $this->getGlobalFeedbackFileStoragePath();
                        return $path."/".$file;
                }
        }

        public function getMemberStatus($a_user_id = null)
        {
                global $ilUser;
                
                if(!$a_user_id)
                {
                        $a_user_id = $ilUser->getId();
                }
                if(!array_key_exists($a_user_id, $this->member_status))
                {
                        include_once "Modules/Exercise/classes/class.ilExAssignmentMemberStatus.php";
                        $this->member_status[$a_user_id] = new ilExAssignmentMemberStatus($this->getId(), $a_user_id);
                }
                return $this->member_status[$a_user_id];
        }
        
        public function recalculateLateSubmissions()
        {
                global $ilDB;
                
                // see JF, 2015-05-11 
                                
                $ext_deadline = $this->getExtendedDeadline();
                
                include_once "Modules/Exercise/classes/class.ilExSubmission.php";
                foreach(ilExSubmission::getAllAssignmentFiles($this->exc_id, $this->getId()) as $file)
                {
                        $id = $file["returned_id"];
                        $uploaded = new ilDateTime($file["ts"], IL_CAL_DATETIME);
                        $uploaded = $uploaded->get(IL_CAL_UNIX);
                        
                        $deadline = $this->getPersonalDeadline($file["user_id"]);
                        $last_deadline = max($deadline, $this->getExtendedDeadline());
                        
                        $late = null;                   
                        
                        // upload is not late anymore 
                        if($file["late"] && 
                                (!$last_deadline ||
                                !$ext_deadline ||
                                $uploaded < $deadline))
                        {
                                $late = false;
                        }
                        // upload is now late 
                        else if(!$file["late"] &&
                                $ext_deadline &&
                                $deadline && 
                                $uploaded > $deadline)
                        {
                                $late = true;
                        }
                        else if($last_deadline && $uploaded > $last_deadline)
                        {
                                // do nothing, we do not remove submissions?
                        }
                        
                        if($late !== null)
                        {                               
                                $ilDB->manipulate("UPDATE exc_returned".
                                        " SET late = ".$ilDB->quote($late, "integer").
                                        " WHERE returned_id = ".$ilDB->quote($id, "integer"));
                        }
                }       
        }
        
        
        //
        // individual deadlines
        //
        
        public function setIndividualDeadline($id, ilDateTime $date)
        {
                global $ilDB;
                
                $is_team = false;
                if(!is_numeric($id))
                {
                        $id = substr($id, 1);
                        $is_team = true;
                }
                
                $ilDB->replace("exc_idl",
                        array(
                                "ass_id" => array("integer", $this->getId()),
                                "member_id" => array("integer", $id),
                                "is_team" => array("integer", $is_team)
                        ),
                        array(
                                "tstamp" => array("integer", $date->get(IL_CAL_UNIX))
                        )
                );
        }
        
        public function getIndividualDeadlines()
        {
                global $ilDB;
                
                $res = array();
                
                $set = $ilDB->query("SELECT * FROM exc_idl".
                        " WHERE ass_id = ".$ilDB->quote($this->getId(), "integer"));
                while($row = $ilDB->fetchAssoc($set))
                {
                        if($row["is_team"])
                        {
                                $row["member_id"] = "t".$row["member_id"];
                        }
                        
                        $res[$row["member_id"]] = $row["tstamp"];
                }
                
                return $res;
        }
        
        public function hasActiveIDl()
        {               
                return (bool)$this->getDeadline();
        }
        
        public function hasReadOnlyIDl()
        {
                if($this->getType() != ilExAssignment::TYPE_UPLOAD_TEAM &&
                        $this->getPeerReview())
                {               
                        // all deadlines are read-only if we have peer feedback
                        include_once "Modules/Exercise/classes/class.ilExPeerReview.php";
                        $peer_review = new ilExPeerReview($this);       
                        if($peer_review->hasPeerReviewGroups())
                        {
                                return true;
                        }
                }
                
                return false;           
        }
}

?>