Exercise assignment member status. More...

Collaboration diagram for ilExAssignmentMemberStatus:

Public Member Functions
	__construct ($a_ass_id, $a_user_id)

	setNotice ($a_value)

	getNotice ()

	setReturned ($a_value)

	getReturned ()

	setSolved ($a_value)

	getSolved ()

	getStatusTime ()

	setSent ($a_value)

	getSent ()

	getSentTime ()

	setFeedback ($a_value)

	getFeedback ()

	getFeedbackTime ()

	setStatus ($a_value)

	getStatus ()

	setMark ($a_value)

	getMark ()

	setComment ($a_value)

	getComment ()

	update ()

	getStatusIcon ()

Static Public Member Functions
static	lookupAnyExerciseSent ($a_ass_id)
	Check whether exercise has been sent to any student per mail. More...

Protected Member Functions
	setStatusTime ($a_value)

	setSentTime ($a_value)

	setFeedbackTime ($a_value)

	read ()

	getFields ()

	postUpdateReturned ()

	postUpdateStatus ()

Protected Attributes
	$db

	$ass_id

	$user_id

	$notice

	$returned

	$solved

	$sent

	$sent_time

	$feedback

	$feedback_time

	$status = "notgraded"

	$status_time

	$mark

	$comment

	$db_exists

	$returned_update

	$status_update

Detailed Description

Exercise assignment member status.

Author: Jörg Lützenkirchen luetz.nosp@m.enki.nosp@m.rchen.nosp@m.@lei.nosp@m.fos.c.nosp@m.om

Definition at line 10 of file class.ilExAssignmentMemberStatus.php.

Constructor & Destructor Documentation

◆ __construct()

ilExAssignmentMemberStatus::__construct	(	$a_ass_id,
		$a_user_id
	)

Definition at line 34 of file class.ilExAssignmentMemberStatus.php.

References $DIC, and read().

     {
         global $DIC;
 
         $this->db = $DIC->database();
         $this->ass_id = $a_ass_id;
         $this->user_id = $a_user_id;
         
         $this->read();
     }

Here is the call graph for this function:

Member Function Documentation

◆ getComment()

ilExAssignmentMemberStatus::getComment ( )

Definition at line 167 of file class.ilExAssignmentMemberStatus.php.

References $comment.

Referenced by getFields().

     {
         return $this->comment;
     }

Here is the caller graph for this function:

◆ getFeedback()

ilExAssignmentMemberStatus::getFeedback ( )

Definition at line 120 of file class.ilExAssignmentMemberStatus.php.

References $feedback.

Referenced by getFields().

     {
         return $this->feedback;
     }

Here is the caller graph for this function:

◆ getFeedbackTime()

ilExAssignmentMemberStatus::getFeedbackTime ( )

Definition at line 130 of file class.ilExAssignmentMemberStatus.php.

References $feedback_time.

Referenced by getFields().

     {
         return $this->feedback_time;
     }

Here is the caller graph for this function:

◆ getFields()

ilExAssignmentMemberStatus::getFields ( )

protected

Definition at line 198 of file class.ilExAssignmentMemberStatus.php.

References getComment(), getFeedback(), getFeedbackTime(), getMark(), getNotice(), getReturned(), getSent(), getSentTime(), getSolved(), getStatus(), and getStatusTime().

Referenced by update().

     {
         return array(
             "notice" => array("text", $this->getNotice())
             ,"returned" => array("integer", $this->getReturned())
             ,"solved" => array("integer", $this->getSolved())
             ,"status_time" => array("timestamp", $this->getStatusTime())
             ,"sent" => array("integer", $this->getSent())
             ,"sent_time" => array("timestamp", $this->getSentTime())
             ,"feedback_time" => array("timestamp", $this->getFeedbackTime())
             ,"feedback" => array("integer", $this->getFeedback())
             ,"status" => array("text", $this->getStatus())
             ,"mark" => array("text", $this->getMark())
             ,"u_comment" => array("text", $this->getComment())
         );
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getMark()

ilExAssignmentMemberStatus::getMark ( )

Definition at line 157 of file class.ilExAssignmentMemberStatus.php.

References $mark.

Referenced by getFields().

     {
         return $this->mark;
     }

Here is the caller graph for this function:

◆ getNotice()

ilExAssignmentMemberStatus::getNotice ( )

Definition at line 50 of file class.ilExAssignmentMemberStatus.php.

References $notice.

Referenced by getFields().

     {
         return $this->notice;
     }

Here is the caller graph for this function:

◆ getReturned()

ilExAssignmentMemberStatus::getReturned ( )

Definition at line 64 of file class.ilExAssignmentMemberStatus.php.

References $returned.

Referenced by getFields().

     {
         return $this->returned;
     }

Here is the caller graph for this function:

◆ getSent()

ilExAssignmentMemberStatus::getSent ( )

Definition at line 97 of file class.ilExAssignmentMemberStatus.php.

References $sent.

Referenced by getFields().

     {
         return $this->sent;
     }

Here is the caller graph for this function:

◆ getSentTime()

ilExAssignmentMemberStatus::getSentTime ( )

Definition at line 107 of file class.ilExAssignmentMemberStatus.php.

References $sent_time.

Referenced by getFields().

     {
         return $this->sent_time;
     }

Here is the caller graph for this function:

◆ getSolved()

ilExAssignmentMemberStatus::getSolved ( )

Definition at line 74 of file class.ilExAssignmentMemberStatus.php.

References $solved.

Referenced by getFields().

     {
         return $this->solved;
     }

Here is the caller graph for this function:

◆ getStatus()

ilExAssignmentMemberStatus::getStatus ( )

Definition at line 144 of file class.ilExAssignmentMemberStatus.php.

References $status.

Referenced by ilExGradesTableGUI\fillRow(), getFields(), and getStatusIcon().

     {
         return $this->status;
     }

Here is the caller graph for this function:

◆ getStatusIcon()

ilExAssignmentMemberStatus::getStatusIcon ( )

Definition at line 264 of file class.ilExAssignmentMemberStatus.php.

References getStatus().

     {
         switch ($this->getStatus()) {
             case "passed":
                 return "scorm/passed.svg";
             
             case "failed":
                 return "scorm/failed.svg";
                 
             default:
                 return "scorm/not_attempted.svg";
         }
     }

Here is the call graph for this function:

◆ getStatusTime()

ilExAssignmentMemberStatus::getStatusTime ( )

Definition at line 84 of file class.ilExAssignmentMemberStatus.php.

References $status_time.

Referenced by getFields().

     {
         return $this->status_time;
     }

Here is the caller graph for this function:

◆ lookupAnyExerciseSent()

static ilExAssignmentMemberStatus::lookupAnyExerciseSent ( $a_ass_id )

static

Check whether exercise has been sent to any student per mail.

Definition at line 281 of file class.ilExAssignmentMemberStatus.php.

References $DIC, and $ilDB.

     {
         global $DIC;
 
         $ilDB = $DIC->database();
 
         $q = "SELECT count(*) AS cnt" .
             " FROM exc_mem_ass_status" .
             " WHERE NOT sent_time IS NULL" .
             " AND ass_id = " . $ilDB->quote($a_ass_id, "integer");
         $set = $ilDB->query($q);
         $rec = $ilDB->fetchAssoc($set);
         return ($rec["cnt"] > 0);
     }

◆ postUpdateReturned()

ilExAssignmentMemberStatus::postUpdateReturned ( )

protected

Definition at line 239 of file class.ilExAssignmentMemberStatus.php.

References $db, $ilDB, $row, ilExAssignment\FEEDBACK_DATE_SUBMISSION, and ilExAssignment\sendFeedbackNotifications().

Referenced by update().

     {
         $ilDB = $this->db;
         
         // first upload => notification on submission?
         $set = $ilDB->query("SELECT fb_cron, fb_date, fb_file" .
             " FROM exc_assignment" .
             " WHERE id = " . $ilDB->quote($this->ass_id, "integer"));
         $row = $ilDB->fetchAssoc($set);
         if ($row["fb_cron"] &&
             $row["fb_file"] &&
             $row["fb_date"] == ilExAssignment::FEEDBACK_DATE_SUBMISSION) { // #16200
             include_once "Modules/Exercise/classes/class.ilExAssignment.php";
             ilExAssignment::sendFeedbackNotifications($this->ass_id, $this->user_id);
         }
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ postUpdateStatus()

ilExAssignmentMemberStatus::postUpdateStatus ( )

protected

Definition at line 256 of file class.ilExAssignmentMemberStatus.php.

References ilObjExercise\updateUserStatus().

Referenced by update().

     {
         include_once "Modules/Exercise/classes/class.ilExAssignment.php";
         $ass = new ilExAssignment($this->ass_id);
         $exc = new ilObjExercise($ass->getExerciseId(), false);
         $exc->updateUserStatus($this->user_id);
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ read()

ilExAssignmentMemberStatus::read ( )

protected

Definition at line 172 of file class.ilExAssignmentMemberStatus.php.

References $db, $ilDB, $row, and comment().

Referenced by __construct().

     {
         $ilDB = $this->db;
         
         $set = $ilDB->query("SELECT * FROM exc_mem_ass_status" .
             " WHERE ass_id = " . $ilDB->quote($this->ass_id, "integer") .
             " AND usr_id = " . $ilDB->quote($this->user_id, "integer"));
         if ($ilDB->numRows($set)) {
             $row = $ilDB->fetchAssoc($set);
             
             // not using setters to circumvent any datetime-logic/-magic
             $this->notice = $row["notice"];
             $this->returned = $row["returned"];
             $this->solved = $row["solved"];
             $this->status_time = $row["status_time"];
             $this->sent = $row["sent"];
             $this->sent_time = $row["sent_time"];
             $this->feedback_time = $row["feedback_time"];
             $this->feedback = $row["feedback"];
             $this->status = $row["status"];
             $this->mark = $row["mark"];
             $this->comment = $row["u_comment"];
             $this->db_exists = true;
         }
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ setComment()

ilExAssignmentMemberStatus::setComment ( $a_value )

Definition at line 162 of file class.ilExAssignmentMemberStatus.php.

References comment().

     {
         $this->comment = $a_value;
     }

Here is the call graph for this function:

◆ setFeedback()

ilExAssignmentMemberStatus::setFeedback ( $a_value )

Definition at line 112 of file class.ilExAssignmentMemberStatus.php.

References ilUtil\now(), and setFeedbackTime().

     {
         if ($a_value != $this->sent) {
             $this->setFeedbackTime(ilUtil::now());
         }
         $this->feedback = $a_value;
     }

Here is the call graph for this function:

◆ setFeedbackTime()

ilExAssignmentMemberStatus::setFeedbackTime ( $a_value )

protected

Definition at line 125 of file class.ilExAssignmentMemberStatus.php.

Referenced by setFeedback().

     {
         $this->feedback_time = $a_value;
     }

Here is the caller graph for this function:

◆ setMark()

ilExAssignmentMemberStatus::setMark ( $a_value )

Definition at line 149 of file class.ilExAssignmentMemberStatus.php.

References ilUtil\now(), and setStatusTime().

     {
         if ($a_value != $this->mark) {
             $this->setStatusTime(ilUtil::now());
         }
         $this->mark = $a_value;
     }

Here is the call graph for this function:

◆ setNotice()

ilExAssignmentMemberStatus::setNotice ( $a_value )

Definition at line 45 of file class.ilExAssignmentMemberStatus.php.

     {
         $this->notice = $a_value;
     }

◆ setReturned()

ilExAssignmentMemberStatus::setReturned ( $a_value )

Definition at line 55 of file class.ilExAssignmentMemberStatus.php.

     {
         if ($a_value &&
             !$this->returned) {
             $this->returned_update = true;
         }
         $this->returned = $a_value;
     }

◆ setSent()

ilExAssignmentMemberStatus::setSent ( $a_value )

Definition at line 89 of file class.ilExAssignmentMemberStatus.php.

References ilUtil\now(), and setSentTime().

     {
         if ($a_value && $a_value != $this->sent) {
             $this->setSentTime(ilUtil::now());
         }
         $this->sent = $a_value;
     }

Here is the call graph for this function:

◆ setSentTime()

ilExAssignmentMemberStatus::setSentTime ( $a_value )

protected

Definition at line 102 of file class.ilExAssignmentMemberStatus.php.

Referenced by setSent().

     {
         $this->sent_time = $a_value;
     }

Here is the caller graph for this function:

◆ setSolved()

ilExAssignmentMemberStatus::setSolved ( $a_value )

Definition at line 69 of file class.ilExAssignmentMemberStatus.php.

     {
         $this->solved = $a_value;
     }

◆ setStatus()

ilExAssignmentMemberStatus::setStatus ( $a_value )

Definition at line 135 of file class.ilExAssignmentMemberStatus.php.

References ilUtil\now(), and setStatusTime().

     {
         if ($a_value != $this->status) {
             $this->setStatusTime(ilUtil::now());
             $this->status = $a_value;
             $this->status_update = true;
         }
     }

Here is the call graph for this function:

◆ setStatusTime()

ilExAssignmentMemberStatus::setStatusTime ( $a_value )

protected

Definition at line 79 of file class.ilExAssignmentMemberStatus.php.

Referenced by setMark(), and setStatus().

     {
         $this->status_time = $a_value;
     }

Here is the caller graph for this function:

◆ update()

ilExAssignmentMemberStatus::update ( )

Definition at line 215 of file class.ilExAssignmentMemberStatus.php.

References $db, $ilDB, $keys, getFields(), postUpdateReturned(), and postUpdateStatus().

     {
         $ilDB = $this->db;
         
         $keys = array(
             "ass_id" => array("integer", $this->ass_id)
             ,"usr_id" => array("integer", $this->user_id)
         );
         $fields = $this->getFields();
         if (!$this->db_exists) {
             $fields = array_merge($keys, $fields);
             $ilDB->insert("exc_mem_ass_status", $fields);
         } else {
             $ilDB->update("exc_mem_ass_status", $fields, $keys);
         }
         
         if ($this->returned_update) {
             $this->postUpdateReturned();
         }
         if ($this->status_update) {
             $this->postUpdateStatus();
         }
     }