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.

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

References $DIC, and read().

Here is the call graph for this function:

Member Function Documentation

◆ getComment()

ilExAssignmentMemberStatus::getComment ( )

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

    {
        return $this->comment;
    }

References $comment.

Referenced by getFields().

Here is the caller graph for this function:

◆ getFeedback()

ilExAssignmentMemberStatus::getFeedback ( )

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

    {
        return $this->feedback;
    }

References $feedback.

Referenced by getFields().

Here is the caller graph for this function:

◆ getFeedbackTime()

ilExAssignmentMemberStatus::getFeedbackTime ( )

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

    {
        return $this->feedback_time;
    }

References $feedback_time.

Referenced by getFields().

Here is the caller graph for this function:

◆ getFields()

ilExAssignmentMemberStatus::getFields ( )

protected

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

    {
        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", (int) $this->getFeedback())
            ,"status" => array("text", $this->getStatus())
            ,"mark" => array("text", $this->getMark())
            ,"u_comment" => array("text", $this->getComment())
        );
    }

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

Referenced by update().

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.

    {
        return $this->mark;
    }

References $mark.

Referenced by getFields().

Here is the caller graph for this function:

◆ getNotice()

ilExAssignmentMemberStatus::getNotice ( )

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

    {
        return $this->notice;
    }

References $notice.

Referenced by getFields().

Here is the caller graph for this function:

◆ getReturned()

ilExAssignmentMemberStatus::getReturned ( )

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

    {
        return $this->returned;
    }

References $returned.

Referenced by getFields().

Here is the caller graph for this function:

◆ getSent()

ilExAssignmentMemberStatus::getSent ( )

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

    {
        return $this->sent;
    }

References $sent.

Referenced by getFields().

Here is the caller graph for this function:

◆ getSentTime()

ilExAssignmentMemberStatus::getSentTime ( )

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

    {
        return $this->sent_time;
    }

References $sent_time.

Referenced by getFields().

Here is the caller graph for this function:

◆ getSolved()

ilExAssignmentMemberStatus::getSolved ( )

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

    {
        return $this->solved;
    }

References $solved.

Referenced by getFields().

Here is the caller graph for this function:

◆ getStatus()

ilExAssignmentMemberStatus::getStatus ( )

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

    {
        return $this->status;
    }

References $status.

Referenced by getFields(), and getStatusIcon().

Here is the caller graph for this function:

◆ getStatusIcon()

ilExAssignmentMemberStatus::getStatusIcon ( )

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

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

References getStatus().

Here is the call graph for this function:

◆ getStatusTime()

ilExAssignmentMemberStatus::getStatusTime ( )

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

    {
        return $this->status_time;
    }

References $status_time.

Referenced by getFields().

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 279 of file class.ilExAssignmentMemberStatus.php.

    {
        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);
    }

References $DIC, and $ilDB.

◆ postUpdateReturned()

ilExAssignmentMemberStatus::postUpdateReturned ( )

protected

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

    {
        $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
            ilExAssignment::sendFeedbackNotifications($this->ass_id, $this->user_id);
        }
    }

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

Referenced by update().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ postUpdateStatus()

ilExAssignmentMemberStatus::postUpdateStatus ( )

protected

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

    {
        $ass = new ilExAssignment($this->ass_id);
        $exc = new ilObjExercise($ass->getExerciseId(), false);
        $exc->updateUserStatus($this->user_id);
    }

Referenced by update().

Here is the caller graph for this function:

◆ read()

ilExAssignmentMemberStatus::read ( )

protected

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

    {
        $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;
        }
    }

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

Referenced by __construct().

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.

    {
        $this->comment = $a_value;
    }

References comment().

Here is the call graph for this function:

◆ setFeedback()

ilExAssignmentMemberStatus::setFeedback ( $a_value )

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

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

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

Here is the call graph for this function:

◆ setFeedbackTime()

ilExAssignmentMemberStatus::setFeedbackTime ( $a_value )

protected

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

    {
        $this->feedback_time = $a_value;
    }

Referenced by setFeedback().

Here is the caller graph for this function:

◆ setMark()

ilExAssignmentMemberStatus::setMark ( $a_value )

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

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

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

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.

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

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

Here is the call graph for this function:

◆ setSentTime()

ilExAssignmentMemberStatus::setSentTime ( $a_value )

protected

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

    {
        $this->sent_time = $a_value;
    }

Referenced by setSent().

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.

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

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

Here is the call graph for this function:

◆ setStatusTime()

ilExAssignmentMemberStatus::setStatusTime ( $a_value )

protected

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

    {
        $this->status_time = $a_value;
    }

Referenced by setMark(), and setStatus().

Here is the caller graph for this function:

◆ update()

ilExAssignmentMemberStatus::update ( )

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

    {
        $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();
        }
    }