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

        {
                $this->ass_id = $a_ass_id;
                $this->user_id = $a_user_id;
                
                $this->read();
        }

References read().

Here is the call graph for this function:

Member Function Documentation

◆ getComment()

ilExAssignmentMemberStatus::getComment ( )

Definition at line 164 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 115 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 125 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 196 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", $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 154 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 42 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 57 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 91 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 101 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 67 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 140 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 268 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 77 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 286 of file class.ilExAssignmentMemberStatus.php.

        {
                global $ilDB;
 
                $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 $ilDB.

Referenced by ilExerciseMemberTableGUI\__construct().

Here is the caller graph for this function:

◆ postUpdateReturned()

ilExAssignmentMemberStatus::postUpdateReturned ( )

protected

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

        {
                global $ilDB;
                
                // 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);
                }       
        }

References $ilDB, $row, 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 260 of file class.ilExAssignmentMemberStatus.php.

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

Referenced by update().

Here is the caller graph for this function:

◆ read()

ilExAssignmentMemberStatus::read ( )

protected

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

        {
                global $ilDB;
                
                $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 $ilDB, and $row.

Referenced by __construct().

Here is the caller graph for this function:

◆ setComment()

ilExAssignmentMemberStatus::setComment ( $a_value )

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

        {
                $this->comment = $a_value;
        }

◆ setFeedback()

ilExAssignmentMemberStatus::setFeedback ( $a_value )

Definition at line 106 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 120 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 145 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 37 of file class.ilExAssignmentMemberStatus.php.

        {
                $this->notice = $a_value;
        }

◆ setReturned()

ilExAssignmentMemberStatus::setReturned ( $a_value )

Definition at line 47 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 82 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 96 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 62 of file class.ilExAssignmentMemberStatus.php.

        {
                $this->solved = $a_value;
        }

◆ setStatus()

ilExAssignmentMemberStatus::setStatus ( $a_value )

Definition at line 130 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 72 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 213 of file class.ilExAssignmentMemberStatus.php.

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