ilExAssignment Class Reference

Exercise assignment. More...

Collaboration diagram for ilExAssignment:

Public Member Functions
	__construct ($a_id=0)
	Constructor. More...
	setId ($a_val)
	Set assignment id. More...
	getId ()
	Get assignment id. More...
	setExerciseId ($a_val)
	Set exercise id. More...
	getExerciseId ()
	Get exercise id. More...
	setStartTime ($a_val)
	Set start time (timestamp) More...
	getStartTime ()
	Get start time (timestamp) More...
	setDeadline ($a_val)
	Set deadline (timestamp) More...
	getDeadline ()
	Get deadline (timestamp) More...
	setInstruction ($a_val)
	Set instruction. More...
	getInstruction ()
	Get instruction. More...
	setTitle ($a_val)
	Set title. More...
	getTitle ()
	Get title. More...
	setMandatory ($a_val)
	Set mandatory. More...
	getMandatory ()
	Get mandatory. More...
	setOrderNr ($a_val)
	Set order nr. More...
	getOrderNr ()
	Get order nr. More...
	setType ($a_value)
	Set type. More...
	getType ()
	Get type. More...
	isValidType ($a_value)
	Is given type valid? More...
	setPeerReview ($a_value)
	Toggle peer review. More...
	getPeerReview ()
	Get peer review status. More...
	setPeerReviewMin ($a_value)
	Set peer review minimum. More...
	getPeerReviewMin ()
	Get peer review minimum. More...
	setPeerReviewDeadline ($a_val)
	Set peer review deadline (timestamp) More...
	getPeerReviewDeadline ()
	Get peer review deadline (timestamp) More...
	setFeedbackFile ($a_value)
	Set (global) feedback file. More...
	getFeedbackFile ()
	Get (global) feedback file. More...
	setFeedbackCron ($a_value)
	Toggle (global) feedback file cron. More...
	hasFeedbackCron ()
	Get (global) feedback file cron status. More...
	read ()
	Read from db. More...
	save ()
	Save assignment. More...
	update ()
	Update. More...
	delete ()
	Delete assignment. More...
	deleteFeedbackFile ()
	handleFeedbackFileUpload (array $a_file)
	getFeedbackFilePath ()
	cloneAssignmentsOfExercise ($a_old_exc_id, $a_new_exc_id)
	Clone assignments of exercise. More...
	saveAssOrderOfExercise ($a_ex_id, $a_order)
	Save ordering of all assignments of an exercise. More...
	orderAssByDeadline ($a_ex_id)
	Order assignments by deadline date. More...
	countMandatory ($a_ex_id)
	Order assignments by deadline date. More...
	lookupCommentForUser ($a_ass_id, $a_user_id)
	Lookup comment for the user. More...
	updateCommentForUser ($a_ass_id, $a_user_id, $a_value)
	Update comment. More...
	lookupMarkOfUser ($a_ass_id, $a_user_id)
	Lookup user mark. More...
	updateMarkOfUser ($a_ass_id, $a_user_id, $a_value)
	Update mark. More...
	lookupStatusOfUser ($a_ass_id, $a_user_id)
	was: getStatusByMember More...
	updateStatusOfUser ($a_ass_id, $a_user_id, $a_status)
	was: setStatusForMember($a_member_id,$a_status) More...
	updateStatusTimeOfUser ($a_ass_id, $a_user_id)
	was: updateStatusTimeForMember($a_user_id) More...
	lookupStatusSentOfUser ($a_ass_id, $a_user_id)
	was: getStatusSentByMember($a_member_id) More...
	updateStatusSentForUser ($a_ass_id, $a_user_id, $a_status)
	was: setStatusSentForMember($a_member_id,$a_status) More...
	lookupStatusReturnedOfUser ($a_ass_id, $a_user_id)
	was: getStatusReturnedByMember($a_member_id) More...
	updateStatusReturnedForUser ($a_ass_id, $a_user_id, $a_status)
	was: setStatusReturnedForMember($a_member_id,$a_status) More...
	lookupStatusFeedbackOfUser ($a_ass_id, $a_user_id)
	was: getStatusFeedbackByMember($a_member_id) More...
	updateStatusFeedbackForUser ($a_ass_id, $a_user_id, $a_status)
	was: setStatusFeedbackForMember($a_member_id,$a_status) More...
	lookupNoticeOfUser ($a_ass_id, $a_user_id)
	was: getNoticeByMember($a_member_id) More...
	hasReturned ($a_ass_id, $a_user_id)
	was: hasReturned($a_member_id) More...
	getAllDeliveredFiles ($a_exc_id, $a_ass_id)
	was: getAllDeliveredFiles() More...
	getDeliveredFiles ($a_exc_id, $a_ass_id, $a_user_id, $a_filter_empty_filename=false)
	was: getDeliveredFiles($a_member_id) More...
	deleteDeliveredFiles ($a_exc_id, $a_ass_id, $file_id_array, $a_user_id)
	was: deleteDeliveredFiles($file_id_array, $a_member_id) More...
	deliverReturnedFiles ($a_exc_id, $a_ass_id, $a_user_id, $a_only_new=false, $a_peer_review_mask_filename=false)
	was: deliverReturnedFiles($a_member_id, $a_only_new = false) More...
	updateTutorDownloadTime ($a_exc_id, $a_ass_id, $a_user_id)
	was: updateTutorDownloadTime($member_id) More...
	downloadSelectedFiles ($a_exc_id, $a_ass_id, $a_user_id, $array_file_id)
	was: downloadSelectedFiles($array_file_id,$a_user_id)? More...
	downloadSingleFile ($a_exc_id, $a_ass_id, $a_user_id, $filename, $filetitle)
	was: downloadSingleFile($filename, $filetitle) More...
	downloadMultipleFiles ($a_exc_id, $a_ass_id, $array_filenames, $a_user_id, $a_multi_user=false)
	was: downloadMultipleFiles($array_filenames, $pathname, $a_member_id = 0) More...
	downloadAllDeliveredFiles ($a_exc_id, $a_ass_id, $members)
	Download all submitted files of an assignment (all user) More...
	updateNoticeForUser ($a_ass_id, $a_user_id, $a_notice)
	was: setNoticeForMember($a_member_id,$a_notice) More...
	_getReturned ($a_ass_id)
	was: _getReturned($a_obj_id) More...
	getMemberListData ($a_exc_id, $a_ass_id)
	get member list data More...
	uploadAssignmentFiles ($a_files)
	Upload assignment files (from creation form) More...
	getTeamId ($a_user_id, $a_create_on_demand=false)
	Get team id for member id. More...
	getTeamMembers ($a_team_id)
	Get members of assignment team. More...
	getMembersOfAllTeams ()
	Get members for all teams of assignment. More...
	addTeamMember ($a_team_id, $a_user_id, $a_exc_ref_id)
	Add new member to team. More...
	removeTeamMember ($a_team_id, $a_user_id, $a_exc_ref_id)
	Remove member from team. More...
	sendNotification ($a_exc_ref_id, $a_user_id, $a_action)
	Send notification about team status. More...
	getPeerReviewsByGiver ($a_user_id)
	getPeerReviewsByPeerId ($a_user_id, $a_only_valid=false)
	getAllPeerReviews ()
	hasPeerReviewAccess ($a_peer_id)
	updatePeerReviewTimestamp ($a_peer_id)
	updatePeerReviewComment ($a_peer_id, $a_comment)
	sendFeedbackNotifications ($a_ass_id)
	sendMultiFeedbackStructureFile ()
	Create member status record for a new assignment for all participants. More...
	uploadMultiFeedbackFile ($a_file)
	Upload multi feedback file. More...
	getMultiFeedbackFiles ($a_user_id=0)
	Get multi feedback files (of uploader) More...
	clearMultiFeedbackDirectory ()
	Clear multi feedback directory. More...
	saveMultiFeedbackFiles ($a_files)
	Save multi feedback files. More...

Static Public Member Functions
static	getAssignmentDataOfExercise ($a_exc_id)
	Get assignments data of an exercise in an array. More...
static	getFiles ($a_exc_id, $a_ass_id)
	Get files. More...
static	lookupMaxOrderNrForEx ($a_exc_id)
	Select the maximum order nr for an exercise. More...
static	lookupAssignmentOnline ($a_ass_id)
	Check if assignment is online. More...
static	lookupTitle ($a_id)
	Lookup title. More...
static	lookupType ($a_id)
	Lookup type. More...
static	lookupSentTimeOfUser ($a_ass_id, $a_user_id)
	Get time when exercise has been sent per e-mail to user. More...
static	lookupFeedbackTimeOfUser ($a_ass_id, $a_user_id)
	Get time when feedback mail has been sent. More...
static	lookupStatusTimeOfUser ($a_ass_id, $a_user_id)
	Get status time. More...
static	deleteAllDeliveredFilesOfUser ($a_exc_id, $a_user_id)
	Delete all delivered files of user. More...
static	getLastSubmission ($a_ass_id, $a_user_id)
	Get the date of the last submission of a user for the assignment. More...
static	lookupAnyExerciseSent ($a_exc_id, $a_ass_id)
	Check whether exercise has been sent to any student per mail. More...
static	lookupUpdatedSubmission ($ass_id, $member_id)
	Check whether student has upload new files after tutor has set the exercise to another than notgraded. More...
static	lookupNewFiles ($ass_id, $member_id)
	Check how much files have been uploaded by the learner after the last download of the tutor. More...
static	createNewUserRecords ($a_user_id, $a_exc_id)
	Create member status record for a new participant for all assignments. More...
static	createNewAssignmentRecords ($a_ass_id, $a_exc)
	Create member status record for a new assignment for all participants. More...
static	getTeamMembersByAssignmentId ($a_ass_id, $a_user_id)
	Find team members by assignment and team member. More...
static	getTeamIdByAssignment ($a_ass_id, $a_user_id)
	Find team by assignment. More...
static	getAssignmentTeamMap ($a_ass_id)
	Get team structure for assignment. More...
static	writeTeamLog ($a_team_id, $a_action, $a_details=null)
	Add entry to team log. More...
static	getTeamLog ($a_team_id)
	Get all log entries for team. More...
static	getDownloadedFilesInfoForTableGUIS ($a_parent_obj, $a_exercise_id, $a_ass_type, $a_ass_id, $a_user_id, $a_parent_cmd=null)
static	countGivenFeedback ($a_ass_id)
static	getNumberOfMissingFeedbacks ($a_ass_id, $a_min)
static	getPendingFeedbackNotifications ()

Data Fields
const	TYPE_UPLOAD = 1
const	TYPE_BLOG = 2
const	TYPE_PORTFOLIO = 3
const	TYPE_UPLOAD_TEAM = 4
const	TYPE_TEXT = 5
const	TEAM_LOG_CREATE_TEAM = 1
const	TEAM_LOG_ADD_MEMBER = 2
const	TEAM_LOG_REMOVE_MEMBER = 3
const	TEAM_LOG_ADD_FILE = 4
const	TEAM_LOG_REMOVE_FILE = 5

Protected Member Functions
	initPeerReviews ()

Protected Attributes
	$id
	$exc_id
	$type
	$start_time
	$deadline
	$instruction
	$title
	$mandatory
	$order_nr
	$peer
	$peer_min
	$peer_dl
	$feedback_file
	$feedback_cron

Private Member Functions
	lookupAssMemberField ($a_ass_id, $a_user_id, $a_field)
	Lookup a field value of ass/member table. More...
	updateAssMemberField ($a_ass_id, $a_user_id, $a_field, $a_value, $a_type)
	Update a field value of ass/member table. More...

Static Private Member Functions
static	lookup ($a_id, $a_field)
	Private lookup. More...

Detailed Description

Exercise assignment.

Author

Alex Killing alex..nosp@m.kill.nosp@m.ing@g.nosp@m.mx.d.nosp@m.e

Version

$Id$

Definition at line 11 of file class.ilExAssignment.php.

Constructor & Destructor Documentation

__construct()

ilExAssignment::__construct

(

$a_id = 0

)

Constructor.

Definition at line 43 of file class.ilExAssignment.php.

References read(), setId(), and setType().

        {
                $this->setType(self::TYPE_UPLOAD);
                
                if ($a_id > 0)
                {
                        $this->setId($a_id);
                        $this->read();
                }
        }

Here is the call graph for this function:

Member Function Documentation

_getReturned()

ilExAssignment::_getReturned

(

$a_ass_id

)

was: _getReturned($a_obj_id)

Definition at line 1718 of file class.ilExAssignment.php.

References $query, $res, and $row.

        {
                global $ilDB;

                $query = "SELECT DISTINCT(usr_id) as ud FROM exc_mem_ass_status ".
                        "WHERE ass_id = ".$ilDB->quote($a_ass_id, "integer")." ".
                        "AND returned = 1";

                $res = $ilDB->query($query);
                while($row = $ilDB->fetchObject($res))
                {
                        $usr_ids[] = $row->ud;
                }

                return $usr_ids ? $usr_ids : array();
        }

addTeamMember()

ilExAssignment::addTeamMember	(		$a_team_id,
			$a_user_id,
			$a_exc_ref_id
	)

Add new member to team.

Parameters

int	$a_team_id
int	$a_user_id
int	$a_exc_ref_id

Definition at line 2065 of file class.ilExAssignment.php.

References ilObjUser\_lookupFullname(), getId(), getTeamMembers(), and sendNotification().

        {
                global $ilDB;
                
                $members = $this->getTeamMembers($a_team_id);
                if(!in_array($a_user_id, $members))
                {
                        $fields = array("id" => array("integer", $a_team_id),
                                "ass_id" => array("integer", $this->getId()),
                                "user_id" => array("integer", $a_user_id));                     
                        $ilDB->insert("il_exc_team", $fields);          
                        
                        $this->sendNotification($a_exc_ref_id, $a_user_id, "add");
                        
                        self::writeTeamLog($a_team_id, self::TEAM_LOG_ADD_MEMBER, 
                                ilObjUser::_lookupFullname($a_user_id));
                }                                                                       
        }

Here is the call graph for this function:

clearMultiFeedbackDirectory()

ilExAssignment::clearMultiFeedbackDirectory

(

)

Clear multi feedback directory.

Parameters

array

Returns

Definition at line 2918 of file class.ilExAssignment.php.

References $ilUser, $lng, ilUtil\delDir(), getExerciseId(), and getId().

Referenced by saveMultiFeedbackFiles().

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

Here is the call graph for this function:

Here is the caller graph for this function:

cloneAssignmentsOfExercise()

ilExAssignment::cloneAssignmentsOfExercise	(		$a_old_exc_id,
			$a_new_exc_id
	)

Clone assignments of exercise.

Parameters

Definition at line 546 of file class.ilExAssignment.php.

References $d, ilFSStorageExercise\create(), getAssignmentDataOfExercise(), and ilUtil\rCopy().

Referenced by ilObjExercise\cloneObject().

        {
                $ass_data = ilExAssignment::getAssignmentDataOfExercise($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["title"]);
                        $new_ass->setDeadline($d["deadline"]);
                        $new_ass->setInstruction($d["instruction"]);
                        $new_ass->setMandatory($d["mandatory"]);
                        $new_ass->setOrderNr($d["order_val"]);
                        $new_ass->setStartTime($d["start_time"]);
                        $new_ass->setType($d["type"]);
                        $new_ass->setPeerReview($d["peer"]);
                        $new_ass->setPeerReviewMin($d["peer_min"]);
                        $new_ass->setPeerReviewDeadline($d["peer_dl"]);
                        $new_ass->setFeedbackFile($d["fb_file"]);
                        $new_ass->setFeedbackCron($d["fb_cron"]);
                        $new_ass->save();
                        
                        // clone assignment files
                        include_once("./Modules/Exercise/classes/class.ilFSStorageExercise.php");
                        $old_storage = new ilFSStorageExercise($a_old_exc_id, (int) $d["id"]);
                        $new_storage = new ilFSStorageExercise($a_new_exc_id, (int) $new_ass->getId());
                        $new_storage->create();
                        
                        if (is_dir($old_storage->getPath()))
                        {
                                ilUtil::rCopy($old_storage->getPath(), $new_storage->getPath());
                        }
                }
        }

Here is the call graph for this function:

Here is the caller graph for this function:

countGivenFeedback()

static ilExAssignment::countGivenFeedback (   $a_ass_id )

static

Definition at line 2631 of file class.ilExAssignment.php.

References $ilUser, $row, and ilRating\getRatingForUserAndObject().

Referenced by ilExAssignmentListTextTableGUI\__construct().

        {
                global $ilDB, $ilUser;
                
                $cnt = 0;
                
                include_once './Services/Rating/classes/class.ilRating.php';
                
                $set = $ilDB->query("SELECT *".
                        " FROM exc_assignment_peer".
                        " WHERE ass_id = ".$ilDB->quote($a_ass_id, "integer").
                        " AND giver_id = ".$ilDB->quote($ilUser->getId(), "integer"));                  
                while($row = $ilDB->fetchAssoc($set))
                {
                        if(trim($row["pcomment"]))
                        {
                                $cnt++;
                        }
                        else
                        {
                                $mark = (int)round(ilRating::getRatingForUserAndObject($a_ass_id, 
                                        "ass", $row["peer_id"], "peer", $row["giver_id"]));
                                if($mark)
                                {
                                        $cnt++;
                                }
                        }
                }
                
                return $cnt;
        }

Here is the call graph for this function:

Here is the caller graph for this function:

countMandatory()

ilExAssignment::countMandatory

(

$a_ex_id

)

Order assignments by deadline date.

Definition at line 706 of file class.ilExAssignment.php.

Referenced by ilObjExerciseGUI\initEditCustomForm().

        {
                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"];
        }

Here is the caller graph for this function:

createNewAssignmentRecords()

static ilExAssignment::createNewAssignmentRecords (   $a_ass_id,   $a_exc  )

static

Create member status record for a new assignment for all participants.

Definition at line 1938 of file class.ilExAssignment.php.

Referenced by save().

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

Here is the caller graph for this function:

createNewUserRecords()

static ilExAssignment::createNewUserRecords (   $a_user_id,   $a_exc_id  )

static

Create member status record for a new participant for all assignments.

Definition at line 1918 of file class.ilExAssignment.php.

References getAssignmentDataOfExercise().

Referenced by ilExerciseMembers\assignMember().

        {
                global $ilDB;
                
                $ass_data = ilExAssignment::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")
                                ));
                }
        }

Here is the call graph for this function:

Here is the caller graph for this function:

delete()

ilExAssignment::delete

(

)

Delete assignment.

Definition at line 456 of file class.ilExAssignment.php.

References deleteFeedbackFile(), and getExerciseId().

        {
                global $ilDB;
                
                $this->deleteFeedbackFile();
                
                $ilDB->manipulate("DELETE FROM exc_assignment WHERE ".
                        " id = ".$ilDB->quote($this->getId(), "integer")
                        );
                $exc = new ilObjExercise($this->getExerciseId(), false);
                $exc->updateAllUsersStatus();
        }

Here is the call graph for this function:

deleteAllDeliveredFilesOfUser()

static ilExAssignment::deleteAllDeliveredFilesOfUser (   $a_exc_id,   $a_user_id  )

static

Delete all delivered files of user.

Parameters

int	$a_exc_id	excercise id
int	$a_user_id	user id

Definition at line 1163 of file class.ilExAssignment.php.

References $d, and $filename.

Referenced by ilObjExercise\deleteAllDeliveredFilesOfUser().

        {
                global $ilDB;
                
                include_once("./Modules/Exercise/classes/class.ilFSStorageExercise.php");
                
                $delete_ids = array();
                
                // get the files and...
                $set = $ilDB->query("SELECT * FROM exc_returned ".
                        " WHERE obj_id = ".$ilDB->quote($a_exc_id, "integer").
                        " AND user_id = ".$ilDB->quote($a_user_id, "integer")
                        );
                while ($rec = $ilDB->fetchAssoc($set))
                {
                        $ass = new self($rec["ass_id"]);
                        if($ass->getType() == self::TYPE_UPLOAD_TEAM)
                        {
                                // switch upload to other team member
                                $team = self::getTeamMembersByAssignmentId($ass->getId(), $a_user_id);
                                if(sizeof($team) > 1)
                                {
                                        $new_owner = array_pop($team);
                                        while($new_owner == $a_user_id && sizeof($team))
                                        {
                                                $new_owner = array_pop($team);
                                        }                                       
                                        
                                        $ilDB->manipulate("UPDATE exc_returned".
                                                " SET user_id = ".$ilDB->quote($new_owner, "integer").
                                                " WHERE returned_id = ".$ilDB->quote($rec["returned_id"], "integer")
                                                );      
                                        
                                        // no need to delete
                                        continue;
                                }
                        }
                        
                        $delete_ids[] = $rec["returned_id"];
                                                                        
                        $fs = new ilFSStorageExercise($a_exc_id, $rec["ass_id"]);
                        
                        // ...delete files
                        $filename = $fs->getAbsoluteSubmissionPath().
                                "/".$a_user_id."/".basename($rec["filename"]);
                        if (is_file($filename))
                        {
                                unlink($filename);
                        }
                }
                
                // delete exc_returned records
                if($delete_ids)
                {
                        $ilDB->manipulate("DELETE FROM exc_returned".
                                " WHERE ".$ilDB->in("returned_id", $delete_ids, "", "integer"));
                }
                
                // delete il_exc_team records
                $ass_ids = array();
                foreach(self::getAssignmentDataOfExercise($a_exc_id) as $item)
                {
                        self::updateStatusOfUser($item["id"], $a_user_id, "notgraded"); // #14900
                        
                        $ass_ids[] = $item["id"];
                }               
                if($ass_ids)
                {
                        $ilDB->manipulate($d = "DELETE FROM il_exc_team WHERE ".
                                "user_id = ".$ilDB->quote($a_user_id, "integer").
                                " AND ".$ilDB->in("ass_id", $ass_ids, "", "integer")
                                );
                }
        }

Here is the caller graph for this function:

deleteDeliveredFiles()

ilExAssignment::deleteDeliveredFiles	(		$a_exc_id,
			$a_ass_id,
			$file_id_array,
			$a_user_id
	)

was: deleteDeliveredFiles($file_id_array, $a_member_id)

Definition at line 1095 of file class.ilExAssignment.php.

References $filename, $result, $row, TEAM_LOG_REMOVE_FILE, and writeTeamLog().

Referenced by ilObjExercise\deleteDeliveredFiles(), and ilObjExerciseGUI\removeExistingSubmissions().

        {
                global $ilDB;
                
                include_once("./Modules/Exercise/classes/class.ilFSStorageExercise.php");
                $fs = new ilFSStorageExercise($a_exc_id, $a_ass_id);

                if (count($file_id_array))
                {                                       
                        $team_id = self::getTeamIdByAssignment($a_ass_id, $a_user_id);
                        if($team_id)
                        {
                                // #11733
                                $user_ids = self::getTeamMembersByAssignmentId($a_ass_id, $a_user_id);                  
                                if(!$user_ids)
                                {
                                        return;
                                }
                        }
                        else
                        {
                                $user_ids = array($a_user_id);
                        }
                
                        $result = $ilDB->query("SELECT * FROM exc_returned".
                                " WHERE ".$ilDB->in("returned_id", $file_id_array, false, "integer").
                                " AND ".$ilDB->in("user_id", $user_ids, "", "integer"));        
                        
                        if ($ilDB->numRows($result))
                        {
                                $result_array = array();
                                while ($row = $ilDB->fetchAssoc($result))
                                {
                                        $row["timestamp"] = $row["ts"];
                                        array_push($result_array, $row);
                                }
                                
                                // delete the entries in the database
                                $ilDB->manipulate("DELETE FROM exc_returned".
                                        " WHERE ".$ilDB->in("returned_id", $file_id_array, false, "integer").
                                        " AND ".$ilDB->in("user_id", $user_ids, "", "integer"));

                                // delete the files
                                foreach ($result_array as $key => $value)
                                {
                                        if($value["filename"])
                                        {
                                                if($team_id)
                                                {
                                                        ilExAssignment::writeTeamLog($team_id, 
                                                                ilExAssignment::TEAM_LOG_REMOVE_FILE, $value["filetitle"]);
                                                }
                                                
                                                $filename = $fs->getAbsoluteSubmissionPath().
                                                        "/".$value["user_id"]."/".basename($value["filename"]);
                                                unlink($filename);
                                        }
                                }
                        }
                }
        }

Here is the call graph for this function:

Here is the caller graph for this function:

deleteFeedbackFile()

ilExAssignment::deleteFeedbackFile

(

)

Definition at line 469 of file class.ilExAssignment.php.

References $path, ilUtil\delDir(), getExerciseId(), and getId().

Referenced by delete().

        {
                include_once("./Modules/Exercise/classes/class.ilFSStorageExercise.php");
                $storage = new ilFSStorageExercise($this->getExerciseId(), $this->getId());
                $path = $storage->getGlobalFeedbackPath();
                ilUtil::delDir($path);                          
        }       

Here is the call graph for this function:

Here is the caller graph for this function:

deliverReturnedFiles()

ilExAssignment::deliverReturnedFiles	(		$a_exc_id,
			$a_ass_id,
			$a_user_id,
			$a_only_new = false,
			$a_peer_review_mask_filename = false
	)

was: deliverReturnedFiles($a_member_id, $a_only_new = false)

Definition at line 1242 of file class.ilExAssignment.php.

References $ilUser, $query, $result, $row, ilObjUser\_lookupName(), ilObject\_lookupTitle(), downloadMultipleFiles(), downloadSingleFile(), and updateTutorDownloadTime().

Referenced by ilObjExerciseGUI\downloadNewReturnedObject(), and ilObjExerciseGUI\downloadReturnedObject().

        {
                global $ilUser, $ilDB;
                
                // #11000 / #11785
                $is_team = true;
                $user_ids = self::getTeamMembersByAssignmentId($a_ass_id, $a_user_id);
                if(!$user_ids)
                {
                        $is_team = false;
                        $user_ids = array($a_user_id);                  
                }               
                
                // get last download time
                $and_str = "";
                if ($a_only_new)
                {
                        $q = "SELECT download_time FROM exc_usr_tutor WHERE ".
                                " ass_id = ".$ilDB->quote($a_ass_id, "integer")." AND ".
                                $ilDB->in("usr_id", $user_ids, "", "integer")." AND ".
                                " tutor_id = ".$ilDB->quote($ilUser->getId(), "integer");
                        $lu_set = $ilDB->query($q);
                        if ($lu_rec = $ilDB->fetchAssoc($lu_set))
                        {
                                if ($lu_rec["download_time"] > 0)
                                {
                                        $and_str = " AND ts > ".$ilDB->quote($lu_rec["download_time"], "timestamp");
                                }
                        }
                }

                foreach($user_ids as $user_id)
                {
                        ilExAssignment::updateTutorDownloadTime($a_exc_id, $a_ass_id, $user_id);
                }
                
                if($a_peer_review_mask_filename)
                {
                        // process peer review sequence id
                        $peer_id = null;
                        foreach($this->ass->getPeerReviewsByGiver($ilUser->getId()) as $idx => $item)
                        {
                                if($item["peer_id"] == $a_user_id)
                                {
                                        $peer_id = $idx+1;
                                        break;
                                }
                        }
                }

                $query = "SELECT * FROM exc_returned".
                        " WHERE ass_id = ".$ilDB->quote($a_ass_id, "integer").
                        " AND ".$ilDB->in("user_id", $user_ids, "", "integer").
                        $and_str;
                
                $result = $ilDB->query($query);
                $count = $ilDB->numRows($result);
                if ($count == 1)
                {
                        $row = $ilDB->fetchAssoc($result);
                        
                        switch(self::lookupType($a_ass_id))
                        {
                                case self::TYPE_BLOG:
                                case self::TYPE_PORTFOLIO:
                                        $row["filetitle"] = ilObjUser::_lookupName($row["user_id"]);
                                        $row["filetitle"] = ilObject::_lookupTitle($a_exc_id)." - ".
                                                self::lookupTitle($a_ass_id)." - ".
                                                $row["filetitle"]["firstname"]." ".
                                                $row["filetitle"]["lastname"]." (".
                                                $row["filetitle"]["login"].").zip";
                                        break;

                                default:
                                        break;
                        }               
                        
                        if($a_peer_review_mask_filename)
                        {
                                $suffix = array_pop(explode(".", $row["filetitle"]));
                                $row["filetitle"] = self::lookupTitle($a_ass_id)."_peer".$peer_id.".".$suffix;                                                  
                        }
                        
                        ilExAssignment::downloadSingleFile($a_exc_id, $a_ass_id, $row["user_id"],
                                $row["filename"], $row["filetitle"]);
                }
                else if ($count > 0)
                {
                        $array_files = array();
                        $seq = 0;
                        while ($row = $ilDB->fetchAssoc($result))
                        {                               
                                $src = basename($row["filename"]);                              
                                if($a_peer_review_mask_filename)
                                {                                                                       
                                        $suffix = array_pop(explode(".", $src));
                                        $tgt = self::lookupTitle($a_ass_id)."_peer".$peer_id.
                                                "_".(++$seq).".".$suffix;                               
                                        
                                        $array_files[$row["user_id"]][] = array($src, $tgt);
                                }
                                else
                                {
                                        $array_files[$row["user_id"]][] = $src;
                                }                               
                        }                       
                        ilExAssignment::downloadMultipleFiles($a_exc_id, $a_ass_id, $array_files, 
                                ($is_team ? null : $a_user_id), $is_team);
                }
                else
                {
                        return false;
                }

                return true;
        }

Here is the call graph for this function:

Here is the caller graph for this function:

downloadAllDeliveredFiles()

ilExAssignment::downloadAllDeliveredFiles	(		$a_exc_id,
			$a_ass_id,
			$members
	)

Download all submitted files of an assignment (all user)

Parameters

$members

array of user names, key is user id

Definition at line 1559 of file class.ilExAssignment.php.

References $id, $lng, ilObjUser\_lookupName(), ilUtil\delDir(), ilUtil\deliverFile(), ilUtil\dirsize(), ilUtil\escapeShellArg(), ilUtil\getASCIIFilename(), ilUtil\ilTempnam(), lookupTitle(), ilUtil\makeDir(), TYPE_BLOG, TYPE_PORTFOLIO, and ilUtil\unzip().

Referenced by ilObjExerciseGUI\downloadAllObject().

        {
                global $lng, $ilObjDataCache, $ilias;
                
                include_once "./Services/Utilities/classes/class.ilUtil.php";
                include_once("./Modules/Exercise/classes/class.ilFSStorageExercise.php");
                
                $storage = new ilFSStorageExercise($a_exc_id, $a_ass_id);
                $storage->create();
                
                ksort($members);
                //$savepath = $this->getExercisePath() . "/" . $this->obj_id . "/";
                $savepath = $storage->getAbsoluteSubmissionPath();
                $cdir = getcwd();


                // important check: if the directory does not exist
                // ILIAS stays in the current directory (echoing only a warning)
                // and the zip command below archives the whole ILIAS directory
                // (including the data directory) and sends a mega file to the user :-o
                if (!is_dir($savepath))
                {
                        return;
                }
                // Safe mode fix
//              chdir($this->getExercisePath());
                chdir($storage->getTempPath());
                $zip = PATH_TO_ZIP;

                // check first, if we have enough free disk space to copy all files to temporary directory
                $tmpdir = ilUtil::ilTempnam();
                ilUtil::makeDir($tmpdir);
                chdir($tmpdir);


                $dirsize = 0;
                foreach ($members as $id => $object) {
                        $directory = $savepath.DIRECTORY_SEPARATOR.$id;
                        $dirsize += ilUtil::dirsize($directory);
                }
                if ($dirsize > disk_free_space($tmpdir)) {
                        return -1;
                }
                
                $ass_type = self::lookupType($a_ass_id);

                // copy all member directories to the temporary folder
                // switch from id to member name and append the login if the member name is double
                // ensure that no illegal filenames will be created
                // remove timestamp from filename
                $cache = array();
                foreach ($members as $id => $user)
                {
                        $sourcedir = $savepath.DIRECTORY_SEPARATOR.$id;
                        if (!is_dir($sourcedir))
                                continue;
                        $userName = ilObjUser::_lookupName($id);
                        //$directory = ilUtil::getASCIIFilename(trim($userName["lastname"])."_".trim($userName["firstname"]));
                        $directory = ilUtil::getASCIIFilename(trim($userName["lastname"])."_".
                                trim($userName["firstname"])."_".trim($userName["login"])."_".$userName["user_id"]);
                        /*if (array_key_exists($directory, $cache))
                        {
                                // first try is to append the login;
                                $directory = ilUtil::getASCIIFilename($directory."_".trim(ilObjUser::_lookupLogin($id)));
                                if (array_key_exists($directory, $cache)) {
                                        // second and secure: append the user id as well.
                                        $directory .= "_".$id;
                                }
                        }*/

                        $cache[$directory] = $directory;
                        ilUtil::makeDir ($directory);
                        $sourcefiles = scandir($sourcedir);
                        $duplicates = array();
                        foreach ($sourcefiles as $sourcefile) {
                                if ($sourcefile == "." || $sourcefile == "..")
                                {
                                        continue;
                                }
                        
                                $targetfile = trim(basename($sourcefile));
                                $pos = strpos($targetfile, "_");
                                if ($pos !== false)
                                {                                               
                                        $targetfile= substr($targetfile, $pos + 1);
                                }
                                
                                // #14536 
                                if(array_key_exists($targetfile, $duplicates))
                                {
                                        $suffix = strrpos($targetfile, ".");                                            
                                        $targetfile = substr($targetfile, 0, $suffix).
                                                " (".(++$duplicates[$targetfile]).")".
                                                substr($targetfile, $suffix);                           
                                }
                                else
                                {
                                        $duplicates[$targetfile] = 1;
                                }                       
                                
                                $targetfile = $directory.DIRECTORY_SEPARATOR.$targetfile;
                                $sourcefile = $sourcedir.DIRECTORY_SEPARATOR.$sourcefile;

                                if (!copy ($sourcefile, $targetfile))
                                {
                                        //echo 'Could not copy '.$sourcefile.' to '.$targetfile;
                                        $ilias->raiseError('Could not copy '.basename($sourcefile)." to '".$targetfile."'.",
                                                $ilias->error_obj->MESSAGE);
                                }
                                else
                                {
                                        // preserve time stamp
                                        touch($targetfile, filectime($sourcefile));
                                        
                                        // blogs and portfolios are stored as zip and have to be unzipped
                                        if($ass_type == ilExAssignment::TYPE_PORTFOLIO || 
                                                $ass_type == ilExAssignment::TYPE_BLOG)
                                        {
                                                ilUtil::unzip($targetfile);
                                                unlink($targetfile);
                                        }                                       
                                }

                        }
                }

                $tmpfile = ilUtil::ilTempnam();
                $tmpzipfile = $tmpfile . ".zip";
                // Safe mode fix
                $zipcmd = $zip." -r ".ilUtil::escapeShellArg($tmpzipfile)." .";
                exec($zipcmd);
                ilUtil::delDir($tmpdir);

                $assTitle = ilExAssignment::lookupTitle($a_ass_id)."_".$a_ass_id;
                chdir($cdir);
                ilUtil::deliverFile($tmpzipfile, (strlen($assTitle) == 0
                        ? strtolower($lng->txt("exc_assignment"))
                        : $assTitle). ".zip", "", false, true);
        }

Here is the call graph for this function:

Here is the caller graph for this function:

downloadMultipleFiles()

ilExAssignment::downloadMultipleFiles	(		$a_exc_id,
			$a_ass_id,
			$array_filenames,
			$a_user_id,
			$a_multi_user = false
	)

was: downloadMultipleFiles($array_filenames, $pathname, $a_member_id = 0)

Definition at line 1461 of file class.ilExAssignment.php.

References $filename, ilObjUser\_lookupName(), ilUtil\delDir(), ilUtil\deliverFile(), ilUtil\escapeShellArg(), exit, ilUtil\getASCIIFilename(), ilUtil\ilTempnam(), lookupTitle(), and ilUtil\makeDir().

Referenced by deliverReturnedFiles(), and downloadSelectedFiles().

        {                               
                include_once("./Modules/Exercise/classes/class.ilFSStorageExercise.php");
                $fs = new ilFSStorageExercise($a_exc_id, $a_ass_id);
                
                require_once "./Services/Utilities/classes/class.ilUtil.php";
                $cdir = getcwd();

                $zip = PATH_TO_ZIP;
                $tmpdir = ilUtil::ilTempnam();
                $tmpfile = ilUtil::ilTempnam();
                $tmpzipfile = $tmpfile . ".zip";

                ilUtil::makeDir($tmpdir);
                chdir($tmpdir);

                $assTitle = ilExAssignment::lookupTitle($a_ass_id);
                $deliverFilename = str_replace(" ", "_", $assTitle);
                if ($a_user_id > 0 && !$a_multi_user)
                {
                        $userName = ilObjUser::_lookupName($a_user_id);
                        $deliverFilename .= "_".$userName["lastname"]."_".$userName["firstname"];
                }
                else
                {
                        $deliverFilename .= "_files";
                }
                $orgDeliverFilename = trim($deliverFilename);
                $deliverFilename = ilUtil::getASCIIFilename($orgDeliverFilename);
                ilUtil::makeDir($tmpdir."/".$deliverFilename);
                chdir($tmpdir."/".$deliverFilename);
                
                //copy all files to a temporary directory and remove them afterwards
                $parsed_files = $duplicates = array();
                foreach ($array_filenames as $user_id => $files)
                {
                        $pathname = $fs->getAbsoluteSubmissionPath()."/".$user_id;

                        foreach($files as $filename)
                        {
                                // peer review masked filenames, see deliverReturnedFiles()
                                if(is_array($filename))
                                {
                                        $newFilename = $filename[1];
                                        $filename = $filename[0];
                                }
                                else
                                {
                                        // remove timestamp
                                        $newFilename = trim($filename);
                                        $pos = strpos($newFilename , "_");
                                        if ($pos !== false)
                                        {                               
                                                $newFilename = substr($newFilename, $pos + 1);
                                        }
                                        // #11070
                                        $chkName = strtolower($newFilename);
                                        if(array_key_exists($chkName, $duplicates))
                                        {
                                                $suffix = strrpos($newFilename, ".");                                           
                                                $newFilename = substr($newFilename, 0, $suffix).
                                                        " (".(++$duplicates[$chkName]).")".
                                                        substr($newFilename, $suffix);
                                        }
                                        else
                                        {
                                                $duplicates[$chkName] = 1;
                                        }
                                }
                                $newFilename = $tmpdir.DIRECTORY_SEPARATOR.$deliverFilename.DIRECTORY_SEPARATOR.$newFilename;
                                // copy to temporal directory
                                $oldFilename =  $pathname.DIRECTORY_SEPARATOR.$filename;
                                if (!copy ($oldFilename, $newFilename))
                                {
                                        echo 'Could not copy '.$oldFilename.' to '.$newFilename;
                                }
                                touch($newFilename, filectime($oldFilename));
                                $parsed_files[] =  ilUtil::escapeShellArg($deliverFilename.DIRECTORY_SEPARATOR.basename($newFilename)); 
                        }
                }                               
                
                chdir($tmpdir);
                $zipcmd = $zip." ".ilUtil::escapeShellArg($tmpzipfile)." ".join($parsed_files, " ");

                exec($zipcmd);
                ilUtil::delDir($tmpdir);
                
                chdir($cdir);
                ilUtil::deliverFile($tmpzipfile, $orgDeliverFilename.".zip", "", false, true);
                exit;
        }

Here is the call graph for this function:

Here is the caller graph for this function:

downloadSelectedFiles()

ilExAssignment::downloadSelectedFiles	(		$a_exc_id,
			$a_ass_id,
			$a_user_id,
			$array_file_id
	)

was: downloadSelectedFiles($array_file_id,$a_user_id)?

Definition at line 1381 of file class.ilExAssignment.php.

References $result, $row, ilObjUser\_lookupName(), ilObject\_lookupTitle(), downloadMultipleFiles(), downloadSingleFile(), TYPE_BLOG, and TYPE_PORTFOLIO.

Referenced by ilObjExerciseGUI\downloadObject().

        {
                global $ilDB;
                
                if (count($array_file_id))
                {
                        //  #11785
                        $is_team = true;
                        $user_ids = self::getTeamMembersByAssignmentId($a_ass_id, $a_user_id);
                        if(!$user_ids)
                        {
                                $is_team = false;
                                $user_ids = array($a_user_id);
                        }               
                        
                        $result = $ilDB->query("SELECT * FROM exc_returned WHERE ".
                                $ilDB->in("returned_id", $array_file_id, false, "integer").
                                " AND ".$ilDB->in("user_id", $user_ids, "", "integer"));
                        if ($ilDB->numRows($result))
                        {
                                $array_found = array();
                                while ($row = $ilDB->fetchAssoc($result))
                                {
                                        $row["timestamp"] = $row["ts"];
                                        array_push($array_found, $row);
                                }
                                if (count($array_found) == 1)
                                {
                                        // blog/portfolio submission
                                        if(is_numeric($array_found[0]["filetitle"]))
                                        {                                               
                                                $ass = new ilExAssignment($array_found[0]["ass_id"]);
                                                if($ass->getType() == ilExAssignment::TYPE_BLOG || 
                                                        $ass->getType() == ilExAssignment::TYPE_PORTFOLIO)
                                                {
                                                        $user_data = ilObjUser::_lookupName($array_found[0]["user_id"]);
                                                        $array_found[0]["filetitle"] = ilObject::_lookupTitle($array_found[0]["obj_id"])." - ".
                                                                $ass->getTitle()." - ".
                                                                $user_data["firstname"]." ".
                                                                $user_data["lastname"]." (".
                                                                $user_data["login"].").zip";
                                                }
                                        }
                                        
                                        ilExAssignment::downloadSingleFile($a_exc_id, $a_ass_id, $array_found[0]["user_id"],
                                                $array_found[0]["filename"], $array_found[0]["filetitle"]);
                                }
                                else
                                {
                                        $filenames = array();
                                        foreach ($array_found as $value)
                                        {
                                                $filenames[$value["user_id"]][] = basename($value["filename"]);
                                        }
                                        ilExAssignment::downloadMultipleFiles($a_exc_id, $a_ass_id, 
                                                $filenames, ($is_team ? null : $a_user_id), $is_team);
                                }
                        }
                }
        }

Here is the call graph for this function:

Here is the caller graph for this function:

downloadSingleFile()

ilExAssignment::downloadSingleFile	(		$a_exc_id,
			$a_ass_id,
			$a_user_id,
			$filename,
			$filetitle
	)

was: downloadSingleFile($filename, $filetitle)

Definition at line 1445 of file class.ilExAssignment.php.

References $filename, and ilUtil\deliverFile().

Referenced by deliverReturnedFiles(), and downloadSelectedFiles().

        {
                include_once("./Modules/Exercise/classes/class.ilFSStorageExercise.php");
                $fs = new ilFSStorageExercise($a_exc_id, $a_ass_id);

                $filename = $fs->getAbsoluteSubmissionPath().
                        "/".$a_user_id."/".basename($filename);

                require_once "./Services/Utilities/classes/class.ilUtil.php";
                ilUtil::deliverFile($filename, $filetitle);
        }

Here is the call graph for this function:

Here is the caller graph for this function:

getAllDeliveredFiles()

ilExAssignment::getAllDeliveredFiles	(		$a_exc_id,
			$a_ass_id
	)

was: getAllDeliveredFiles()

Definition at line 1023 of file class.ilExAssignment.php.

References $query, $res, and $row.

Referenced by ilObjExerciseGUI\getAssignmentValues(), ilObjExerciseGUI\membersObject(), and ilExAssignmentListTextTableGUI\parse().

        {
                global $ilDB;
                
                include_once("./Modules/Exercise/classes/class.ilFSStorageExercise.php");
                $fs = new ilFSStorageExercise($a_exc_id, $a_ass_id);

                $query = "SELECT * FROM exc_returned WHERE ass_id = ".
                        $ilDB->quote($a_ass_id, "integer");

                $res = $ilDB->query($query);
                while($row = $ilDB->fetchAssoc($res))
                {
                        $row["timestamp"] = $row["ts"];
                        $row["filename"] = $fs->getAbsoluteSubmissionPath().
                                "/".$row["user_id"]."/".basename($row["filename"]);
                        $delivered[] = $row;
                }
                
                //$delivered = ilObjExercise::_fixFilenameArray($delivered);

                return $delivered ? $delivered : array();
        }

Here is the caller graph for this function:

getAllPeerReviews()

ilExAssignment::getAllPeerReviews

(

)

Definition at line 2567 of file class.ilExAssignment.php.

References $comment, $res, $row, getId(), and ilRating\getRatingForUserAndObject().

        {
                global $ilDB;
                
                $res = array();

                include_once './Services/Rating/classes/class.ilRating.php';
                
                $set = $ilDB->query("SELECT *".
                        " FROM exc_assignment_peer".
                        " WHERE ass_id = ".$ilDB->quote($this->getId(), "integer").
                        " ORDER BY peer_id");
                while($row = $ilDB->fetchAssoc($set))
                {
                        $rating = round(ilRating::getRatingForUserAndObject($this->getId(), 
                                        "ass", $row["peer_id"], "peer", $row["giver_id"]));             
                        
                        $comment = $row["pcomment"];
                        
                        if($comment || $rating)
                        {
                                $res[$row["peer_id"]][$row["giver_id"]] = array($comment, $rating);
                        }
                }                                               
                
                return $res;            
        }

Here is the call graph for this function:

getAssignmentDataOfExercise()

static ilExAssignment::getAssignmentDataOfExercise (   $a_exc_id )

static

Get assignments data of an exercise in an array.

Definition at line 506 of file class.ilExAssignment.php.

References $data.

Referenced by ilAssignmentsTableGUI\__construct(), ilExGradesTableGUI\__construct(), ilExParticipantTableGUI\__construct(), ilObjExerciseGUI\addMembersObject(), cloneAssignmentsOfExercise(), createNewUserRecords(), ilObjExercise\determinStatusOfUser(), ilObjExercise\exportGradesExcel(), ilExerciseXMLParser\ilExerciseXMLParser(), ilObjExerciseGUI\infoScreen(), ilObjExerciseGUI\membersObject(), ilObjExerciseGUI\showOverviewObject(), ilObjExerciseGUI\showParticipantObject(), and ilExerciseXMLWriter\start().

        {
                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))
                {
                        
                        $data[] = array(
                                "id" => $rec["id"],
                                "exc_id" => $rec["exc_id"],
                                "deadline" => $rec["time_stamp"],
                                "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"],
                                "fb_file" => $rec["fb_file"],
                                "fb_cron" => $rec["fb_cron"],
                                );
                        $order_val += 10;
                }
                return $data;
        }

Here is the caller graph for this function:

getAssignmentTeamMap()

static ilExAssignment::getAssignmentTeamMap (   $a_ass_id )

static

Get team structure for assignment.

Parameters

int

$a_ass_id

Returns

array

Definition at line 2169 of file class.ilExAssignment.php.

References $row.

Referenced by ilExerciseMemberTableGUI\__construct().

        {
                global $ilDB;
                
                $map = array();
                
                $sql = "SELECT * FROM il_exc_team".
                        " WHERE ass_id = ".$ilDB->quote($a_ass_id, "integer");
                $set = $ilDB->query($sql);
                while($row = $ilDB->fetchAssoc($set))
                {
                        $map[$row["user_id"]] = $row["id"];
                }
                
                return $map;
        }

Here is the caller graph for this function:

getDeadline()

ilExAssignment::getDeadline

(

)

Get deadline (timestamp)

Returns

int deadline (timestamp)

Definition at line 129 of file class.ilExAssignment.php.

References $deadline.

Referenced by initPeerReviews(), save(), and update().

        {
                return $this->deadline;
        }

Here is the caller graph for this function:

getDeliveredFiles()

ilExAssignment::getDeliveredFiles	(		$a_exc_id,
			$a_ass_id,
			$a_user_id,
			$a_filter_empty_filename = false
	)

was: getDeliveredFiles($a_member_id)

Definition at line 1050 of file class.ilExAssignment.php.

References $result, and $row.

Referenced by ilObjExerciseGUI\confirmDeleteDeliveredObject(), ilObjExerciseGUI\confirmRemoveTeamMemberObject(), ilObjExercise\deleteDeliveredFiles(), ilObjPortfolioGUI\downloadExcSubFile(), ilObjBlogGUI\downloadExcSubFile(), ilObjExerciseGUI\editAssignmentTextObject(), ilPublicSubmissionsTableGUI\fillRow(), ilExcDeliveredFilesTableGUI\getDeliveredFiles(), getDownloadedFilesInfoForTableGUIS(), ilObjPortfolioGUI\getExerciseInfo(), ilObjBlogGUI\getExerciseInfo(), ilExAssignmentGUI\getOverviewBody(), ilObjExerciseGUI\removeExistingSubmissions(), ilObjExerciseGUI\showAssignmentTextObject(), ilObjExerciseGUI\updateAssignmentTextObject(), and ilObjExercise\updateTextSubmission().

        {
                global $ilDB;
                
                $user_ids = self::getTeamMembersByAssignmentId($a_ass_id, $a_user_id);
                if(!$user_ids)
                {
                        $user_ids = array($a_user_id);
                }               

                include_once("./Modules/Exercise/classes/class.ilFSStorageExercise.php");
                $fs = new ilFSStorageExercise($a_exc_id, $a_ass_id);
                
                $result = $ilDB->query("SELECT * FROM exc_returned".
                        " WHERE ass_id = ".$ilDB->quote($a_ass_id, "integer").
                        " AND ".$ilDB->in("user_id", $user_ids, "", "integer"));
                
                $delivered_files = array();
                if ($ilDB->numRows($result))
                {
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                if($a_filter_empty_filename && !$row["filename"])
                                {
                                        continue;
                                }
                                $row["owner_id"] = $row["user_id"];
                                $row["timestamp"] = $row["ts"];
                                $row["timestamp14"] = substr($row["ts"], 0, 4).
                                        substr($row["ts"], 5, 2).substr($row["ts"], 8, 2).
                                        substr($row["ts"], 11, 2).substr($row["ts"], 14, 2).
                                        substr($row["ts"], 17, 2);
                                $row["filename"] = $fs->getAbsoluteSubmissionPath().
                                        "/".$row["user_id"]."/".basename($row["filename"]);
                                array_push($delivered_files, $row);
                        }
                }
                
                //$delivered_files = ilObjExercise::_fixFilenameArray($delivered_files);
                return $delivered_files;
        }

Here is the caller graph for this function:

getDownloadedFilesInfoForTableGUIS()

static ilExAssignment::getDownloadedFilesInfoForTableGUIS (   $a_parent_obj,   $a_exercise_id,   $a_ass_type,   $a_ass_id,   $a_user_id,   $a_parent_cmd = null  )

static

Definition at line 2261 of file class.ilExAssignment.php.

References $ilCtrl, $lng, $result, ilDatePresentation\formatDate(), getDeliveredFiles(), IL_CAL_DATETIME, lookupNewFiles(), lookupUpdatedSubmission(), TYPE_BLOG, TYPE_PORTFOLIO, TYPE_TEXT, TYPE_UPLOAD, and TYPE_UPLOAD_TEAM.

Referenced by ilExAssignmentPeerReviewTableGUI\fillRow(), ilExParticipantTableGUI\fillRow(), and ilExerciseMemberTableGUI\fillRow().

        {
                global $lng, $ilCtrl;
                
                $result = array();
                $result["files"]["count"] = "---";
                
                $ilCtrl->setParameter($a_parent_obj, "ass_id", $a_ass_id);
                
                // submission:
                // see if files have been resubmmited after solved
                $last_sub =     self::getLastSubmission($a_ass_id, $a_user_id);
                if ($last_sub)
                {
                        $last_sub = ilDatePresentation::formatDate(new ilDateTime($last_sub,IL_CAL_DATETIME));
                }
                else
                {
                        $last_sub = "---";
                }
                if (ilExAssignment::lookupUpdatedSubmission($a_ass_id, $a_user_id) == 1) 
                {
                        $last_sub = "<b>".$last_sub."</b>";
                }               
                $result["last_submission"]["txt"] = $lng->txt("exc_last_submission");
                $result["last_submission"]["value"] = $last_sub;
                
                // assignment type specific
                switch($a_ass_type)
                {                       
                        case ilExAssignment::TYPE_UPLOAD_TEAM:
                                // data is merged by team - see above
                                // fallthrough
                                
                        case ilExAssignment::TYPE_UPLOAD:
                                // nr of submitted files
                                $result["files"]["txt"] = $lng->txt("exc_files_returned");              
                                $sub_cnt = count(ilExAssignment::getDeliveredFiles($a_exercise_id, $a_ass_id, $a_user_id));
                                $new = ilExAssignment::lookupNewFiles($a_ass_id, $a_user_id);
                                if (count($new) > 0)
                                {
                                        $sub_cnt.= " ".sprintf($lng->txt("cnt_new"),count($new));
                                }
                                $result["files"]["count"] = $sub_cnt;

                                // download command
                                $ilCtrl->setParameter($a_parent_obj, "member_id", $a_user_id);
                                
                                if ($sub_cnt > 0)
                                {
                                        $result["files"]["download_url"] = 
                                                $ilCtrl->getLinkTarget($a_parent_obj, "downloadReturned");
                                                                        
                                        if (count($new) <= 0)
                                        {
                                                $result["files"]["download_txt"] = $lng->txt("exc_download_files");
                                        }
                                        else
                                        {
                                                $result["files"]["download_txt"] = $lng->txt("exc_download_all");
                                        }
                                        
                                        // download new files only
                                        if (count($new) > 0)
                                        {
                                                $result["files"]["download_new_url"] = 
                                                        $ilCtrl->getLinkTarget($a_parent_obj, "downloadNewReturned");
                                                
                                                $result["files"]["download_new_txt"] = $lng->txt("exc_download_new");                                           
                                        }
                                }
                                break;
                                
                        case ilExAssignment::TYPE_BLOG:                         
                                $result["files"]["txt"] =$lng->txt("exc_blog_returned");                                
                                $blogs = ilExAssignment::getDeliveredFiles($a_exercise_id, $a_ass_id, $a_user_id);
                                if($blogs)
                                {
                                        $blogs = array_pop($blogs);                                     
                                        if($blogs && substr($blogs["filename"], -1) != "/")
                                        {
                                                $result["files"]["count"] = 1;
                                                
                                                $ilCtrl->setParameter($a_parent_obj, "member_id", $a_user_id);
                                                $result["files"]["download_url"] = 
                                                        $ilCtrl->getLinkTarget($a_parent_obj, "downloadReturned");
                                                $ilCtrl->setParameter($a_parent_obj, "member_id", "");
                                                
                                                $result["files"]["download_txt"] = $lng->txt("exc_download_files");                                             
                                        }
                                }
                                break;
                                
                        case ilExAssignment::TYPE_PORTFOLIO:
                                $result["files"]["txt"] = $lng->txt("exc_portfolio_returned");                          
                                $portfolios = ilExAssignment::getDeliveredFiles($a_exercise_id, $a_ass_id, $a_user_id);
                                if($portfolios)
                                {
                                        $portfolios = array_pop($portfolios);                                                                   
                                        if($portfolios && substr($portfolios["filename"], -1) != "/")
                                        {       
                                                $result["files"]["count"] = 1;
                                                
                                                $ilCtrl->setParameter($a_parent_obj, "member_id", $a_user_id);
                                                $result["files"]["download_url"] = 
                                                        $ilCtrl->getLinkTarget($a_parent_obj, "downloadReturned");              
                                                $ilCtrl->setParameter($a_parent_obj, "member_id", "");
                                                
                                                $result["files"]["download_txt"] = $lng->txt("exc_download_files");                                             
                                        }
                                }
                                break;
                                
                        case ilExAssignment::TYPE_TEXT:
                                $result["files"]["txt"] = $lng->txt("exc_files_returned_text");
                                $files = ilExAssignment::getDeliveredFiles($a_exercise_id, $a_ass_id, $a_user_id);
                                if($files)
                                {
                                        $result["files"]["count"] = 1;
                                        
                                        $files = array_shift($files);
                                        if(trim($files["atext"]))
                                        {                                       
                                                // #11397
                                                if($a_parent_cmd)
                                                {
                                                        $ilCtrl->setParameter($a_parent_obj, "grd", (($a_parent_cmd == "members") ? 1 : 2));
                                                }
                                                $ilCtrl->setParameter($a_parent_obj, "member_id", $a_user_id);          
                                                $result["files"]["download_url"] =
                                                        $ilCtrl->getLinkTarget($a_parent_obj, "showAssignmentText");                                                                                            
                                                $ilCtrl->setParameter($a_parent_obj, "member_id", "");
                                                $ilCtrl->setParameter($a_parent_obj, "grd", "");
                                                
                                                $result["files"]["download_txt"] = $lng->txt("exc_text_assignment_show");                                               
                                        }
                                }
                                break;
                }
                
                return $result;
        }

Here is the call graph for this function:

Here is the caller graph for this function:

getExerciseId()

ilExAssignment::getExerciseId

(

)

Get exercise id.

Returns

int exercise id

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

References $exc_id.

Referenced by clearMultiFeedbackDirectory(), delete(), deleteFeedbackFile(), getFeedbackFilePath(), getMultiFeedbackFiles(), handleFeedbackFileUpload(), save(), saveMultiFeedbackFiles(), sendMultiFeedbackStructureFile(), update(), uploadAssignmentFiles(), and uploadMultiFeedbackFile().

        {
                return $this->exc_id;
        }

Here is the caller graph for this function:

getFeedbackFile()

ilExAssignment::getFeedbackFile

(

)

Get (global) feedback file.

Returns

int

Definition at line 333 of file class.ilExAssignment.php.

References $feedback_file.

Referenced by getFeedbackFilePath(), save(), and update().

        {
                return (string)$this->feedback_file;
        }

Here is the caller graph for this function:

getFeedbackFilePath()

ilExAssignment::getFeedbackFilePath

(

)

Definition at line 491 of file class.ilExAssignment.php.

References $file, $path, getExerciseId(), getFeedbackFile(), and getId().

        {
                $file = $this->getFeedbackFile();
                if($file)
                {
                        include_once("./Modules/Exercise/classes/class.ilFSStorageExercise.php");
                        $storage = new ilFSStorageExercise($this->getExerciseId(), $this->getId());
                        $path = $storage->getGlobalFeedbackPath();
                        return $path."/".$file;
                }
        }

Here is the call graph for this function:

getFiles()

static ilExAssignment::getFiles (   $a_exc_id,   $a_ass_id  )

static

Get files.

Definition at line 584 of file class.ilExAssignment.php.

Referenced by ilObjPortfolioGUI\downloadExcAssFile(), ilObjBlogGUI\downloadExcAssFile(), ilObjExerciseGUI\downloadFileObject(), ilObjPortfolioGUI\getExerciseInfo(), ilObjBlogGUI\getExerciseInfo(), and ilExAssignmentGUI\getOverviewBody().

        {
                include_once("./Modules/Exercise/classes/class.ilFSStorageExercise.php");
                $storage = new ilFSStorageExercise($a_exc_id, $a_ass_id);
                return $storage->getFiles();
        }

Here is the caller graph for this function:

getId()

ilExAssignment::getId

(

)

Get assignment id.

Returns

int assignment id

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

References $id.

Referenced by addTeamMember(), clearMultiFeedbackDirectory(), deleteFeedbackFile(), getAllPeerReviews(), getFeedbackFilePath(), getMembersOfAllTeams(), getMultiFeedbackFiles(), getPeerReviewsByGiver(), getPeerReviewsByPeerId(), getTeamId(), getTeamMembers(), handleFeedbackFileUpload(), hasPeerReviewAccess(), removeTeamMember(), saveMultiFeedbackFiles(), sendMultiFeedbackStructureFile(), update(), updatePeerReviewComment(), updatePeerReviewTimestamp(), uploadAssignmentFiles(), and uploadMultiFeedbackFile().

        {
                return $this->id;
        }

Here is the caller graph for this function:

getInstruction()

ilExAssignment::getInstruction

(

)

Get instruction.

Returns

string instruction

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

References $instruction.

Referenced by save(), and update().

        {
                return $this->instruction;
        }

Here is the caller graph for this function:

getLastSubmission()

static ilExAssignment::getLastSubmission (   $a_ass_id,   $a_user_id  )

static

Get the date of the last submission of a user for the assignment.

Parameters

int	Assignment ID
int	User ID

Returns

mixed false or mysql timestamp of last submission

Definition at line 1742 of file class.ilExAssignment.php.

References $lng, and ilUtil\getMySQLTimestamp().

Referenced by ilPublicSubmissionsTableGUI\fillRow(), getMemberListData(), and ilExAssignmentGUI\getOverviewBody().

        {
                global $ilDB, $lng;
                
                // team upload?
                $user_ids = self::getTeamMembersByAssignmentId($a_ass_id, $a_user_id);
                if(!$user_ids)
                {
                        $user_ids = array($a_user_id);
                }
                
                $ilDB->setLimit(1);

                $q = "SELECT obj_id,user_id,ts FROM exc_returned".
                        " WHERE ass_id = ".$ilDB->quote($a_ass_id, "integer").
                        " AND ".$ilDB->in("user_id", $user_ids, "", "integer").
                        " ORDER BY ts DESC";

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

                $array = $ilDB->fetchAssoc($usr_set);
                if ($array["ts"]==NULL)
                {
                        return false;
                }
                else
                {
                        return ilUtil::getMySQLTimestamp($array["ts"]);
                }
        }

Here is the call graph for this function:

Here is the caller graph for this function:

getMandatory()

ilExAssignment::getMandatory

(

)

Get mandatory.

Returns

int mandatory

Definition at line 189 of file class.ilExAssignment.php.

References $mandatory.

Referenced by ilObjExerciseGUI\initAssignmentTextForm(), save(), and update().

        {
                return $this->mandatory;
        }

Here is the caller graph for this function:

getMemberListData()

ilExAssignment::getMemberListData	(		$a_exc_id,
			$a_ass_id
	)

get member list data

Definition at line 1874 of file class.ilExAssignment.php.

References getLastSubmission().

Referenced by ilPublicSubmissionsTableGUI\__construct(), and ilExerciseMemberTableGUI\__construct().

        {
                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($a_exc_id, "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"]
                                );                      
                }

                $q = "SELECT * FROM exc_mem_ass_status ".
                        "WHERE ass_id = ".$ilDB->quote($a_ass_id, "integer");
                $set = $ilDB->query($q);
                while($rec = $ilDB->fetchAssoc($set))
                {
                        if (isset($mem[$rec["usr_id"]]))
                        {
                                $mem[$rec["usr_id"]]["sent_time"] = $rec["sent_time"];
                                $mem[$rec["usr_id"]]["submission"] = ilExAssignment::getLastSubmission($a_ass_id, $rec["usr_id"]);
                                $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"];
                        }
                }
                return $mem;
        }

Here is the call graph for this function:

Here is the caller graph for this function:

getMembersOfAllTeams()

ilExAssignment::getMembersOfAllTeams

(

)

Get members for all teams of assignment.

Returns

array

Definition at line 2040 of file class.ilExAssignment.php.

References $row, and getId().

        {
                global $ilDB;
                
                $ids = array();
                
                $sql = "SELECT user_id".
                        " FROM il_exc_team".
                        " WHERE ass_id = ".$ilDB->quote($this->getId(), "integer");
                $set = $ilDB->query($sql);
                while($row = $ilDB->fetchAssoc($set))
                {
                        $ids[] = $row["user_id"];
                }
                
                return $ids;
        }

Here is the call graph for this function:

getMultiFeedbackFiles()

ilExAssignment::getMultiFeedbackFiles

(

$a_user_id = 0

)

Get multi feedback files (of uploader)

Parameters

int

$a_user_id

user id of uploader

Returns

array array of user files (keys: lastname, firstname, user_id, login, file)

Definition at line 2845 of file class.ilExAssignment.php.

References $ilUser, ilObjUser\_lookupName(), ilUtil\getDir(), getExerciseId(), and getId().

Referenced by saveMultiFeedbackFiles().

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

Here is the call graph for this function:

Here is the caller graph for this function:

getNumberOfMissingFeedbacks()

static ilExAssignment::getNumberOfMissingFeedbacks (   $a_ass_id,   $a_min  )

static

Definition at line 2663 of file class.ilExAssignment.php.

Referenced by ilObjExerciseGUI\editPeerReviewObject(), and ilExAssignmentGUI\getOverviewBody().

        {
                global $ilDB;
                
                // check if number of returned assignments is lower than assignment peer min
                $set = $ilDB->query("SELECT COUNT(DISTINCT(user_id)) cnt".
                        " FROM exc_returned".
                        " WHERE ass_id = ".$ilDB->quote($a_ass_id, "integer"));
                $cnt = $ilDB->fetchAssoc($set);
                $cnt = (int)$cnt["cnt"];
                
                // forever alone
                if($cnt < 2)
                {
                        return;
                }
                                
                $a_min = min($cnt-1, $a_min);
                                
                return max(0, $a_min-self::countGivenFeedback($a_ass_id));              
        }

Here is the caller graph for this function:

getOrderNr()

ilExAssignment::getOrderNr

(

)

Get order nr.

Returns

int order nr

Definition at line 209 of file class.ilExAssignment.php.

References $order_nr.

Referenced by save(), and update().

        {
                return $this->order_nr;
        }

Here is the caller graph for this function:

getPeerReview()

ilExAssignment::getPeerReview

(

)

Get peer review status.

Returns

bool

Definition at line 273 of file class.ilExAssignment.php.

References $peer.

Referenced by save(), and update().

        {
                return (bool)$this->peer;
        }

Here is the caller graph for this function:

getPeerReviewDeadline()

ilExAssignment::getPeerReviewDeadline

(

)

Get peer review deadline (timestamp)

Returns

int deadline (timestamp)

Definition at line 313 of file class.ilExAssignment.php.

References $peer_dl.

Referenced by save(), and update().

        {
                return $this->peer_dl;
        }

Here is the caller graph for this function:

getPeerReviewMin()

ilExAssignment::getPeerReviewMin

(

)

Get peer review minimum.

Returns

int

Definition at line 293 of file class.ilExAssignment.php.

References $peer_min.

Referenced by initPeerReviews(), save(), and update().

        {
                return (int)$this->peer_min;
        }

Here is the caller graph for this function:

getPeerReviewsByGiver()

ilExAssignment::getPeerReviewsByGiver

(

$a_user_id

)

Definition at line 2507 of file class.ilExAssignment.php.

References $res, $row, getId(), and initPeerReviews().

        {
                global $ilDB;
                
                $res = array();
                
                if($this->initPeerReviews())
                {                       
                        $set = $ilDB->query("SELECT *".
                                " FROM exc_assignment_peer".
                                " WHERE giver_id = ".$ilDB->quote($a_user_id, "integer").
                                " AND ass_id = ".$ilDB->quote($this->getId(), "integer").
                                " ORDER BY peer_id");
                        while($row = $ilDB->fetchAssoc($set))
                        {
                                $res[] = $row;
                        }
                }                               
                
                return $res;
        }

Here is the call graph for this function:

getPeerReviewsByPeerId()

ilExAssignment::getPeerReviewsByPeerId	(		$a_user_id,
			$a_only_valid = false
	)

Definition at line 2529 of file class.ilExAssignment.php.

References $res, $row, $valid, getId(), and ilRating\getRatingForUserAndObject().

        {
                global $ilDB;
                
                $res = array();
                
                include_once './Services/Rating/classes/class.ilRating.php';
                                        
                $set = $ilDB->query("SELECT *".
                        " FROM exc_assignment_peer".
                        " WHERE peer_id = ".$ilDB->quote($a_user_id, "integer").
                        " AND ass_id = ".$ilDB->quote($this->getId(), "integer").
                        " ORDER BY peer_id");
                while($row = $ilDB->fetchAssoc($set))
                {
                        $valid = true;
                        if($a_only_valid)
                        {
                                $valid = false;                 
                                if(trim($row["pcomment"]))
                                {
                                        $valid = true;
                                }
                                else
                                {
                                        $valid = (bool)round(ilRating::getRatingForUserAndObject($this->getId(), 
                                                "ass", $row["peer_id"], "peer", $row["giver_id"]));                             
                                }
                        }                       
                        if($valid)
                        {
                                $res[] = $row;
                        }
                }                                               
                
                return $res;
        }

Here is the call graph for this function:

getPendingFeedbackNotifications()

static ilExAssignment::getPendingFeedbackNotifications ( )

static

Definition at line 2685 of file class.ilExAssignment.php.

References $res, and $row.

Referenced by ilExcCronFeedbackNotification\run().

        {
                global $ilDB;
                
                $res = array();
                
                $set = $ilDB->query("SELECT id,fb_file FROM exc_assignment".
                        " WHERE fb_cron = ".$ilDB->quote(1, "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;
        }

Here is the caller graph for this function:

getStartTime()

ilExAssignment::getStartTime

(

)

Get start time (timestamp)

Returns

int start time (timestamp)

Definition at line 109 of file class.ilExAssignment.php.

References $start_time.

Referenced by save(), and update().

        {
                return $this->start_time;
        }

Here is the caller graph for this function:

getTeamId()

ilExAssignment::getTeamId	(		$a_user_id,
			$a_create_on_demand = false
	)

Get team id for member id.

team will be created if no team yet

Parameters

int	$a_user_id
bool	$a_create_on_demand

Returns

int

Definition at line 1982 of file class.ilExAssignment.php.

References $id, $row, ilObjUser\_lookupFullname(), and getId().

Referenced by saveMultiFeedbackFiles().

        {
                global $ilDB;
                
                $sql = "SELECT id FROM il_exc_team".
                        " WHERE ass_id = ".$ilDB->quote($this->getId(), "integer").
                        " AND user_id = ".$ilDB->quote($a_user_id, "integer");
                $set = $ilDB->query($sql);
                $row = $ilDB->fetchAssoc($set);
                $id = $row["id"];
                
                if(!$id && $a_create_on_demand)
                {
                        $id = $ilDB->nextId("il_exc_team");
                        
                        $fields = array("id" => array("integer", $id),
                                "ass_id" => array("integer", $this->getId()),
                                "user_id" => array("integer", $a_user_id));                     
                        $ilDB->insert("il_exc_team", $fields);          
                        
                        self::writeTeamLog($id, self::TEAM_LOG_CREATE_TEAM);                                            
                        self::writeTeamLog($id, self::TEAM_LOG_ADD_MEMBER, 
                                ilObjUser::_lookupFullname($a_user_id));
                }
                
                return $id;
        }

Here is the call graph for this function:

Here is the caller graph for this function:

getTeamIdByAssignment()

static ilExAssignment::getTeamIdByAssignment (   $a_ass_id,   $a_user_id  )

static

Find team by assignment.

Parameters

int	$a_ass_id
int	$a_user_id

Returns

int

Definition at line 2143 of file class.ilExAssignment.php.

References $result, and $type.

Referenced by ilObjExercise\deliverFile(), and ilObjExerciseGUI\showTeamLogObject().

        {
                global $ilDB;
                
                $result = $ilDB->query("SELECT type".
                        " FROM exc_assignment".
                        " WHERE id = ".$ilDB->quote($a_ass_id, "integer"));
                $type = $ilDB->fetchAssoc($result);
                
                if($type["type"] == self::TYPE_UPLOAD_TEAM)
                {                       
                        $set = $ilDB->query("SELECT id".
                                " FROM il_exc_team".
                                " WHERE ass_id = ".$ilDB->quote($a_ass_id, "integer").
                                " AND user_id = ".$ilDB->quote($a_user_id, "integer"));
                        $team_id = $ilDB->fetchAssoc($set);
                        return $team_id["id"];
                }
        }

Here is the caller graph for this function:

getTeamLog()

static ilExAssignment::getTeamLog (   $a_team_id )

static

Get all log entries for team.

Parameters

int

$a_team_id

Returns

array

Definition at line 2214 of file class.ilExAssignment.php.

References $res, and $row.

Referenced by ilExAssignmentTeamLogTableGUI\getItems().

        {
                global $ilDB;
                
                $res = array();
                
                $sql = "SELECT * FROM il_exc_team_log".
                        " WHERE team_id = ".$ilDB->quote($a_team_id, "integer").
                        " ORDER BY tstamp DESC";
                $set = $ilDB->query($sql);
                while($row = $ilDB->fetchAssoc($set))
                {
                        $res[] = $row;
                }
                return $res;
        }                                       

Here is the caller graph for this function:

getTeamMembers()

ilExAssignment::getTeamMembers

(

$a_team_id

)

Get members of assignment team.

Parameters

int

$a_team_id

Returns

array

Definition at line 2016 of file class.ilExAssignment.php.

References $row, and getId().

Referenced by addTeamMember(), and saveMultiFeedbackFiles().

        {
                global $ilDB;
                
                $ids = array();
                
                $sql = "SELECT user_id".
                        " FROM il_exc_team".
                        " WHERE ass_id = ".$ilDB->quote($this->getId(), "integer").
                        " AND id = ".$ilDB->quote($a_team_id, "integer");
                $set = $ilDB->query($sql);
                while($row = $ilDB->fetchAssoc($set))
                {
                        $ids[] = $row["user_id"];
                }
                
                return $ids;
        }

Here is the call graph for this function:

Here is the caller graph for this function:

getTeamMembersByAssignmentId()

static ilExAssignment::getTeamMembersByAssignmentId (   $a_ass_id,   $a_user_id  )

static

Find team members by assignment and team member.

Parameters

int	$a_ass_id
int	$a_user_id

Returns

array

Definition at line 2114 of file class.ilExAssignment.php.

References $row.

Referenced by ilObjExerciseGUI\confirmDeassignMembersObject(), ilObjExercise\deleteDeliveredFiles(), ilObjExercise\deliverFile(), ilExParticipantTableGUI\fillRow(), ilExAssignmentGUI\getOverviewBody(), ilObjExercise\handleSubmission(), ilObjExerciseGUI\redirectFeedbackMailObject(), and ilObjExerciseGUI\sendMembersObject().

        {
                global $ilDB;
                
                $ids = array();
                
                $team_id = self::getTeamIdByAssignment($a_ass_id, $a_user_id);                  
                if($team_id)
                {
                        $set = $ilDB->query("SELECT user_id".
                                " FROM il_exc_team".
                                " WHERE ass_id = ".$ilDB->quote($a_ass_id, "integer").
                                " AND id = ". $ilDB->quote($team_id, "integer"));
                        while($row = $ilDB->fetchAssoc($set))
                        {
                                $ids[] = $row["user_id"];
                        }       
                }               
                
                return $ids;
        }

Here is the caller graph for this function:

getTitle()

ilExAssignment::getTitle

(

)

Get title.

Returns

string title

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

References $title.

Referenced by ilExAssignmentPeerReviewTableGUI\__construct(), ilObjExerciseGUI\initAssignmentTextForm(), save(), sendMultiFeedbackStructureFile(), sendNotification(), and update().

        {
                return $this->title;
        }

Here is the caller graph for this function:

getType()

ilExAssignment::getType

(

)

Get type.

Returns

int

Definition at line 237 of file class.ilExAssignment.php.

References $type.

Referenced by save(), saveMultiFeedbackFiles(), and update().

        {
                return $this->type;
        }

Here is the caller graph for this function:

handleFeedbackFileUpload()

ilExAssignment::handleFeedbackFileUpload

(

array

$a_file

)

Definition at line 477 of file class.ilExAssignment.php.

References $path, ilUtil\delDir(), getExerciseId(), getId(), and setFeedbackFile().

        {
                include_once("./Modules/Exercise/classes/class.ilFSStorageExercise.php");
                $storage = new ilFSStorageExercise($this->getExerciseId(), $this->getId());
                $path = $storage->getGlobalFeedbackPath();
                ilUtil::delDir($path, true);
                if(@move_uploaded_file($a_file["tmp_name"], $path."/".$a_file["name"]))
                {
                        $this->setFeedbackFile($a_file["name"]);                
                        return true;
                }
                return false;
        }

Here is the call graph for this function:

hasFeedbackCron()

ilExAssignment::hasFeedbackCron

(

)

Get (global) feedback file cron status.

Returns

int

Definition at line 353 of file class.ilExAssignment.php.

References $feedback_cron.

Referenced by save(), and update().

        {
                return (bool)$this->feedback_cron;
        }

Here is the caller graph for this function:

hasPeerReviewAccess()

ilExAssignment::hasPeerReviewAccess

(

$a_peer_id

)

Definition at line 2595 of file class.ilExAssignment.php.

References $ilUser, $row, and getId().

        {
                global $ilDB, $ilUser;
                
                $set = $ilDB->query("SELECT ass_id".
                        " FROM exc_assignment_peer".                    
                        " WHERE giver_id = ".$ilDB->quote($ilUser->getId(), "integer").
                        " AND peer_id = ".$ilDB->quote($a_peer_id, "integer").
                        " AND ass_id = ".$ilDB->quote($this->getId(), "integer"));
                $row = $ilDB->fetchAssoc($set);
                return (bool)$row["ass_id"];            
        }

Here is the call graph for this function:

hasReturned()

ilExAssignment::hasReturned	(		$a_ass_id,
			$a_user_id
	)

was: hasReturned($a_member_id)

Definition at line 1004 of file class.ilExAssignment.php.

References $result.

        {
                global $ilDB;
                
                $user_ids = self::getTeamMembersByAssignmentId($a_ass_id, $a_user_id);
                if(!$user_ids)
                {
                        $user_ids = array($a_user_id);
                }       
                
                $result = $ilDB->query("SELECT returned_id FROM exc_returned".
                        " WHERE ass_id = ".$ilDB->quote($a_ass_id, "integer").
                        " AND ".$ilDB->in("user_id", $user_ids, "", "integer"));
                return $ilDB->numRows($result);
        }

initPeerReviews()

ilExAssignment::initPeerReviews ( )

protected

Definition at line 2404 of file class.ilExAssignment.php.

References $row, getDeadline(), and getPeerReviewMin().

Referenced by getPeerReviewsByGiver().

        {
                global $ilDB;
                
                // only if assignment is through
                if(!$this->getDeadline() || $this->getDeadline() > time())
                {
                        return false;
                }
                
                $set = $ilDB->query("SELECT count(*) cnt".
                        " FROM exc_assignment_peer".
                        " WHERE ass_id = ".$ilDB->quote($this->getId(), "integer"));
                $cnt = $ilDB->fetchAssoc($set);
                if(!$cnt["cnt"])
                {
                        $user_ids = array();
                        $set = $ilDB->query("SELECT DISTINCT(user_id)".
                                " FROM exc_returned".
                                " WHERE ass_id = ".$ilDB->quote($this->getId(), "integer"));
                        while($row = $ilDB->fetchAssoc($set))
                        {
                                $user_ids[] = $row["user_id"];
                        }
                        
                        // forever alone
                        if(sizeof($user_ids) < 2)
                        {
                                return false;
                        }
                        
                        $rater_ids = $user_ids;
                        $matrix = array();

                        $max = min(sizeof($user_ids)-1, $this->getPeerReviewMin());                     
                        for($loop = 0; $loop < $max; $loop++)
                        {                               
                                $run_ids = array_combine($user_ids, $user_ids);
                                
                                foreach($rater_ids as $rater_id)
                                {
                                        $possible_peer_ids = $run_ids;
                                        
                                        // may not rate himself
                                        unset($possible_peer_ids[$rater_id]);
                                        
                                        // already has linked peers
                                        if(array_key_exists($rater_id, $matrix))
                                        {
                                                $possible_peer_ids = array_diff($possible_peer_ids, $matrix[$rater_id]);
                                        }
                                        
                                        // #15665 / #15883 
                                        if(!sizeof($possible_peer_ids))
                                        {
                                                // no more possible peers left?  start over with all valid users
                                                $run_ids = array_combine($user_ids, $user_ids);
                                                
                                                // see above
                                                $possible_peer_ids = $run_ids;
                                                
                                                // may not rate himself
                                                unset($possible_peer_ids[$rater_id]);

                                                // already has linked peers
                                                if(array_key_exists($rater_id, $matrix))
                                                {
                                                        $possible_peer_ids = array_diff($possible_peer_ids, $matrix[$rater_id]);
                                                }
                                        }
                                                
                                        // #14947 
                                        if(sizeof($possible_peer_ids))
                                        {
                                                $peer_id = array_rand($possible_peer_ids);
                                                if(!array_key_exists($rater_id, $matrix))
                                                {
                                                        $matrix[$rater_id] = array();                                                                                                                   
                                                }                                               
                                                $matrix[$rater_id][] = $peer_id;                                                
                                        }
                                        
                                        // remove peer_id from possible ids in this run
                                        unset($run_ids[$peer_id]);
                                }
                        }       
                        
                        foreach($matrix as $rater_id => $peer_ids)
                        {
                                foreach($peer_ids as $peer_id)
                                {
                                        $ilDB->manipulate("INSERT INTO exc_assignment_peer".
                                                " (ass_id, giver_id, peer_id)".
                                                " VALUES (".$ilDB->quote($this->getId(), "integer").
                                                ", ".$ilDB->quote($rater_id, "integer").
                                                ", ".$ilDB->quote($peer_id, "integer").")");                                    
                                }
                        }
                        
                }
                return true;
        }

Here is the call graph for this function:

Here is the caller graph for this function:

isValidType()

ilExAssignment::isValidType

(

$a_value

)

Is given type valid?

Parameters

int

$a_value

Returns

bool

Definition at line 248 of file class.ilExAssignment.php.

Referenced by setType().

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

Here is the caller graph for this function:

lookup()

static ilExAssignment::lookup (   $a_id,   $a_field  )

staticprivate

Private lookup.

Definition at line 630 of file class.ilExAssignment.php.

Referenced by lookupTitle(), and lookupType().

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

Here is the caller graph for this function:

lookupAnyExerciseSent()

static ilExAssignment::lookupAnyExerciseSent (   $a_exc_id,   $a_ass_id  )

static

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

Definition at line 1776 of file class.ilExAssignment.php.

Referenced by ilExerciseMemberTableGUI\__construct().

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

                if ($rec["cnt"] > 0)
                {
                        return true;
                }
                else
                {
                        return false;
                }
        }

Here is the caller graph for this function:

lookupAssignmentOnline()

static ilExAssignment::lookupAssignmentOnline (   $a_ass_id )

static

Check if assignment is online.

Parameters

int

$a_ass_id

Returns

bool

Definition at line 613 of file class.ilExAssignment.php.

References $query, and $res.

Referenced by ilObjExerciseSubItemListGUI\isAssignmentVisible().

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

Here is the caller graph for this function:

lookupAssMemberField()

ilExAssignment::lookupAssMemberField (   $a_ass_id,   $a_user_id,   $a_field  )

private

Lookup a field value of ass/member table.

Definition at line 725 of file class.ilExAssignment.php.

Referenced by lookupCommentForUser(), lookupFeedbackTimeOfUser(), lookupMarkOfUser(), lookupNoticeOfUser(), lookupSentTimeOfUser(), lookupStatusFeedbackOfUser(), lookupStatusOfUser(), lookupStatusReturnedOfUser(), lookupStatusSentOfUser(), and lookupStatusTimeOfUser().

        {
                global $ilDB;
                
                $set = $ilDB->query("SELECT ".$a_field." FROM exc_mem_ass_status ".
                        " WHERE ass_id = ".$ilDB->quote($a_ass_id, "integer").
                        " AND usr_id = ".$ilDB->quote($a_user_id, "integer")
                        );
                $rec  = $ilDB->fetchAssoc($set);
                
                return $rec[$a_field];
        }

Here is the caller graph for this function:

lookupCommentForUser()

ilExAssignment::lookupCommentForUser	(		$a_ass_id,
			$a_user_id
	)

Lookup comment for the user.

Definition at line 769 of file class.ilExAssignment.php.

References lookupAssMemberField().

Referenced by ilExerciseXMLWriter\attachMarking(), ilExParticipantTableGUI\fillRow(), ilExerciseMemberTableGUI\fillRow(), and ilExAssignmentGUI\getOverviewBody().

        {
                return ilExAssignment::lookupAssMemberField($a_ass_id, $a_user_id, "u_comment");
        }

Here is the call graph for this function:

Here is the caller graph for this function:

lookupFeedbackTimeOfUser()

static ilExAssignment::lookupFeedbackTimeOfUser (   $a_ass_id,   $a_user_id  )

static

Get time when feedback mail has been sent.

Definition at line 963 of file class.ilExAssignment.php.

References ilUtil\getMySQLTimestamp(), and lookupAssMemberField().

Referenced by ilExParticipantTableGUI\fillRow(), and ilExerciseMemberTableGUI\fillRow().

        {
                return ilUtil::getMySQLTimestamp(
                        ilExAssignment::lookupAssMemberField($a_ass_id, $a_user_id, "feedback_time"));
        }

Here is the call graph for this function:

Here is the caller graph for this function:

lookupMarkOfUser()

ilExAssignment::lookupMarkOfUser	(		$a_ass_id,
			$a_user_id
	)

Lookup user mark.

Definition at line 786 of file class.ilExAssignment.php.

References lookupAssMemberField().

Referenced by ilExerciseXMLWriter\attachMarking(), ilObjExercise\exportGradesExcel(), ilExGradesTableGUI\fillRow(), ilExParticipantTableGUI\fillRow(), ilExerciseMemberTableGUI\fillRow(), ilExAssignmentGUI\getOverviewBody(), and ilObjExerciseGUI\saveStatusObject().

        {
                return ilExAssignment::lookupAssMemberField($a_ass_id, $a_user_id, "mark");
        }

Here is the call graph for this function:

Here is the caller graph for this function:

lookupMaxOrderNrForEx()

static ilExAssignment::lookupMaxOrderNrForEx (   $a_exc_id )

static

Select the maximum order nr for an exercise.

Definition at line 594 of file class.ilExAssignment.php.

Referenced by save().

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

Here is the caller graph for this function:

lookupNewFiles()

static ilExAssignment::lookupNewFiles (   $ass_id,   $member_id  )

static

Check how much files have been uploaded by the learner after the last download of the tutor.

Definition at line 1840 of file class.ilExAssignment.php.

References $ilUser.

Referenced by getDownloadedFilesInfoForTableGUIS().

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

                $q = "SELECT exc_returned.returned_id AS id ".
                        "FROM exc_usr_tutor, exc_returned ".
                        "WHERE exc_returned.ass_id = exc_usr_tutor.ass_id ".
                        " AND exc_returned.user_id = exc_usr_tutor.usr_id ".
                        " AND exc_returned.ass_id = ".$ilDB->quote($ass_id, "integer").
                        " AND ".$ilDB->in("exc_returned.user_id", $user_ids, "", "integer").
                        " AND exc_usr_tutor.tutor_id = ".$ilDB->quote($ilUser->getId(), "integer").
                        " AND exc_usr_tutor.download_time < exc_returned.ts ";

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

                $new_up = array();
                while ($new_up_rec = $ilDB->fetchAssoc($new_up_set))
                {
                        $new_up[] = $new_up_rec["id"];
                }

                return $new_up;
        }

Here is the caller graph for this function:

lookupNoticeOfUser()

ilExAssignment::lookupNoticeOfUser	(		$a_ass_id,
			$a_user_id
	)

was: getNoticeByMember($a_member_id)

Definition at line 996 of file class.ilExAssignment.php.

References lookupAssMemberField().

Referenced by ilExerciseXMLWriter\attachMarking(), ilExParticipantTableGUI\fillRow(), and ilExerciseMemberTableGUI\fillRow().

        {
                return ilExAssignment::lookupAssMemberField($a_ass_id, $a_user_id, "notice");
        }

Here is the call graph for this function:

Here is the caller graph for this function:

lookupSentTimeOfUser()

static ilExAssignment::lookupSentTimeOfUser (   $a_ass_id,   $a_user_id  )

static

Get time when exercise has been sent per e-mail to user.

Definition at line 954 of file class.ilExAssignment.php.

References ilUtil\getMySQLTimestamp(), and lookupAssMemberField().

Referenced by ilExerciseMemberTableGUI\fillRow().

        {
                return ilUtil::getMySQLTimestamp(
                        ilExAssignment::lookupAssMemberField($a_ass_id, $a_user_id, "sent_time"));
        }

Here is the call graph for this function:

Here is the caller graph for this function:

lookupStatusFeedbackOfUser()

ilExAssignment::lookupStatusFeedbackOfUser	(		$a_ass_id,
			$a_user_id
	)

was: getStatusFeedbackByMember($a_member_id)

Definition at line 931 of file class.ilExAssignment.php.

References lookupAssMemberField().

        {
                return ilExAssignment::lookupAssMemberField($a_ass_id, $a_user_id, "feedback");
        }

Here is the call graph for this function:

lookupStatusOfUser()

ilExAssignment::lookupStatusOfUser	(		$a_ass_id,
			$a_user_id
	)

was: getStatusByMember

Definition at line 803 of file class.ilExAssignment.php.

References lookupAssMemberField().

Referenced by ilExerciseXMLWriter\attachMarking(), ilObjExercise\determinStatusOfUser(), ilObjExercise\exportGradesExcel(), ilExGradesTableGUI\fillRow(), ilExParticipantTableGUI\fillRow(), ilExerciseMemberTableGUI\fillRow(), ilExAssignmentGUI\getOverviewBody(), and ilExAssignmentGUI\getOverviewHeader().

        {
                $stat = ilExAssignment::lookupAssMemberField($a_ass_id, $a_user_id, "status");
                if ($stat == "")
                {
                        $stat = "notgraded";
                }
                return $stat;
        }

Here is the call graph for this function:

Here is the caller graph for this function:

lookupStatusReturnedOfUser()

ilExAssignment::lookupStatusReturnedOfUser	(		$a_ass_id,
			$a_user_id
	)

was: getStatusReturnedByMember($a_member_id)

Definition at line 894 of file class.ilExAssignment.php.

References lookupAssMemberField().

        {
                return ilExAssignment::lookupAssMemberField($a_ass_id, $a_user_id, "returned");
        }

Here is the call graph for this function:

lookupStatusSentOfUser()

ilExAssignment::lookupStatusSentOfUser	(		$a_ass_id,
			$a_user_id
	)

was: getStatusSentByMember($a_member_id)

Definition at line 857 of file class.ilExAssignment.php.

References lookupAssMemberField().

Referenced by ilExerciseMemberTableGUI\fillRow().

        {
                return ilExAssignment::lookupAssMemberField($a_ass_id, $a_user_id, "sent");
        }

Here is the call graph for this function:

Here is the caller graph for this function:

lookupStatusTimeOfUser()

static ilExAssignment::lookupStatusTimeOfUser (   $a_ass_id,   $a_user_id  )

static

Get status time.

Definition at line 972 of file class.ilExAssignment.php.

References ilUtil\getMySQLTimestamp(), and lookupAssMemberField().

Referenced by ilExParticipantTableGUI\fillRow(), and ilExerciseMemberTableGUI\fillRow().

        {
                return ilUtil::getMySQLTimestamp(
                        ilExAssignment::lookupAssMemberField($a_ass_id, $a_user_id, "status_time"));
        }

Here is the call graph for this function:

Here is the caller graph for this function:

lookupTitle()

static ilExAssignment::lookupTitle (   $a_id )

static

Lookup title.

Definition at line 646 of file class.ilExAssignment.php.

References lookup().

Referenced by ilPublicSubmissionsTableGUI\__construct(), ilExerciseMemberTableGUI\__construct(), ilObjExerciseGUI\confirmAssignmentsDeletionObject(), downloadAllDeliveredFiles(), downloadMultipleFiles(), ilObjExerciseGUI\executeCommand(), ilObjExerciseSubItemListGUI\getHTML(), ilObjExerciseGUI\initMultiFeedbackForm(), ilExerciseMailNotification\send(), ilObjExercise\sendAssignment(), and ilObjExerciseGUI\setAssignmentHeader().

        {
                return ilExAssignment::lookup($a_id, "title");
        }

Here is the call graph for this function:

Here is the caller graph for this function:

lookupType()

static ilExAssignment::lookupType (   $a_id )

static

Lookup type.

Definition at line 654 of file class.ilExAssignment.php.

References lookup().

Referenced by ilExerciseMemberTableGUI\__construct().

        {
                return ilExAssignment::lookup($a_id, "type");
        }

Here is the call graph for this function:

Here is the caller graph for this function:

lookupUpdatedSubmission()

static ilExAssignment::lookupUpdatedSubmission (   $ass_id,   $member_id  )

static

Check whether student has upload new files after tutor has set the exercise to another than notgraded.

Definition at line 1801 of file class.ilExAssignment.php.

References $lng.

Referenced by getDownloadedFilesInfoForTableGUIS().

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

        }

Here is the caller graph for this function:

orderAssByDeadline()

ilExAssignment::orderAssByDeadline

(

$a_ex_id

)

Order assignments by deadline date.

Definition at line 684 of file class.ilExAssignment.php.

Referenced by ilObjExerciseGUI\orderAssignmentsByDeadlineObject().

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

Here is the caller graph for this function:

read()

ilExAssignment::read

(

)

Read from db.

Definition at line 361 of file class.ilExAssignment.php.

References setDeadline(), setExerciseId(), setFeedbackCron(), setFeedbackFile(), setInstruction(), setMandatory(), setOrderNr(), setPeerReview(), setPeerReviewDeadline(), setPeerReviewMin(), setStartTime(), setTitle(), and setType().

Referenced by __construct().

        {
                global $ilDB;
                
                $set = $ilDB->query("SELECT * FROM exc_assignment ".
                        " WHERE id = ".$ilDB->quote($this->getId(), "integer")
                        );
                while ($rec  = $ilDB->fetchAssoc($set))
                {
                        $this->setExerciseId($rec["exc_id"]);
                        $this->setDeadline($rec["time_stamp"]);
                        $this->setInstruction($rec["instruction"]);
                        $this->setTitle($rec["title"]);
                        $this->setStartTime($rec["start_time"]);
                        $this->setOrderNr($rec["order_nr"]);
                        $this->setMandatory($rec["mandatory"]);
                        $this->setType($rec["type"]);
                        $this->setPeerReview($rec["peer"]);
                        $this->setPeerReviewMin($rec["peer_min"]);
                        $this->setPeerReviewDeadline($rec["peer_dl"]);
                        $this->setFeedbackFile($rec["fb_file"]);
                        $this->setFeedbackCron($rec["fb_cron"]);
                }
        }

Here is the call graph for this function:

Here is the caller graph for this function:

removeTeamMember()

ilExAssignment::removeTeamMember	(		$a_team_id,
			$a_user_id,
			$a_exc_ref_id
	)

Remove member from team.

Parameters

int	$a_team_id
int	$a_user_id
int	$a_exc_ref_id

Definition at line 2091 of file class.ilExAssignment.php.

References ilObjUser\_lookupFullname(), getId(), and sendNotification().

        {
                global $ilDB;
                
                $sql = "DELETE FROM il_exc_team".
                        " WHERE ass_id = ".$ilDB->quote($this->getId(), "integer").
                        " AND id = ".$ilDB->quote($a_team_id, "integer").
                        " AND user_id = ".$ilDB->quote($a_user_id, "integer");                  
                $ilDB->manipulate($sql);                
        
                $this->sendNotification($a_exc_ref_id, $a_user_id, "rmv");
                
                self::writeTeamLog($a_team_id, self::TEAM_LOG_REMOVE_MEMBER, 
                        ilObjUser::_lookupFullname($a_user_id));
        }

Here is the call graph for this function:

save()

ilExAssignment::save

(

)

Save assignment.

Definition at line 389 of file class.ilExAssignment.php.

References createNewAssignmentRecords(), getDeadline(), getExerciseId(), getFeedbackFile(), getInstruction(), getMandatory(), getOrderNr(), getPeerReview(), getPeerReviewDeadline(), getPeerReviewMin(), getStartTime(), getTitle(), getType(), hasFeedbackCron(), lookupMaxOrderNrForEx(), setId(), and setOrderNr().

        {
                global $ilDB;
                
                if ($this->getOrderNr() == 0)
                {
                        $this->setOrderNr(
                                ilExAssignment::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()),
                        "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_dl" => array("integer", $this->getPeerReviewDeadline()),
                        "fb_file" => array("text", $this->getFeedbackFile()),
                        "fb_cron" => array("integer", $this->hasFeedbackCron()))
                        );
                $this->setId($next_id);
                $exc = new ilObjExercise($this->getExerciseId(), false);
                $exc->updateAllUsersStatus();
                ilExAssignment::createNewAssignmentRecords($next_id, $exc);
        }

Here is the call graph for this function:

saveAssOrderOfExercise()

ilExAssignment::saveAssOrderOfExercise	(		$a_ex_id,
			$a_order
	)

Save ordering of all assignments of an exercise.

Definition at line 662 of file class.ilExAssignment.php.

References $t.

Referenced by ilObjExerciseGUI\saveAssignmentOrderObject().

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

Here is the caller graph for this function:

saveMultiFeedbackFiles()

ilExAssignment::saveMultiFeedbackFiles

(

$a_files

)

Save multi feedback files.

Parameters

Definition at line 2934 of file class.ilExAssignment.php.

References clearMultiFeedbackDirectory(), getExerciseId(), getId(), getMultiFeedbackFiles(), getTeamId(), getTeamMembers(), getType(), and TYPE_UPLOAD_TEAM.

        {                               
                $exc = new ilObjExercise($this->getExerciseId(), false);
                
                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)] != "")
                        {                                               
                                // #14294 - team assignment
                                if ($this->getType() == ilExAssignment::TYPE_UPLOAD_TEAM)
                                {
                                        // just once for each user
                                        if (!array_key_exists($user_id, $team_map))
                                        {                                                                       
                                                $team_id = $this->getTeamId($user_id);
                                                $team_map[$user_id]["team_id"] = "t".$team_id;  

                                                $team_map[$user_id]["noti_rec_ids"] = array();
                                                foreach ($this->getTeamMembers($team_id) as $team_user_id)
                                                {                               
                                                        $team_map[$user_id]["noti_rec_ids"][] = $team_user_id;
                                                }                                                               
                                        }

                                        $feedback_id = $team_map[$user_id]["team_id"];
                                        $noti_rec_ids = $team_map[$user_id]["noti_rec_ids"];
                                }
                                else
                                {
                                        $feedback_id = $user_id;
                                        $noti_rec_ids = array($user_id);
                                }                       
                                
                                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)
                                {
                                        $exc->sendFeedbackFileNotification($file_name, $noti_rec_ids,
                                                (int) $this->getId());
                                }
                        }
                }
                
                $this->clearMultiFeedbackDirectory();
        }

Here is the call graph for this function:

sendFeedbackNotifications()

ilExAssignment::sendFeedbackNotifications

(

$a_ass_id

)

Definition at line 2708 of file class.ilExAssignment.php.

References $row, and ilExerciseMembers\_getMembers().

Referenced by ilExcCronFeedbackNotification\run().

        {
                global $ilDB;
                
                $ass = new self($a_ass_id);
                
                // valid assignment?
                if(!$ass->hasFeedbackCron() || !$ass->getFeedbackFile())
                {
                        return false;
                }               
                
                // 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");              
                
                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"));
                return true;            
        }

Here is the call graph for this function:

Here is the caller graph for this function:

sendMultiFeedbackStructureFile()

ilExAssignment::sendMultiFeedbackStructureFile

(

)

Create member status record for a new assignment for all participants.

Definition at line 2756 of file class.ilExAssignment.php.

References ilObjUser\_lookupName(), ilUtil\deliverFile(), ilUtil\getASCIIFilename(), getExerciseId(), getId(), getTitle(), ilUtil\ilTempnam(), ilUtil\makeDir(), and ilUtil\zip().

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

Here is the call graph for this function:

sendNotification()

ilExAssignment::sendNotification	(		$a_exc_ref_id,
			$a_user_id,
			$a_action
	)

Send notification about team status.

Parameters

int	$a_exc_ref_id
int	$a_user_id
string	$a_action

Definition at line 2238 of file class.ilExAssignment.php.

References $ilUser, and getTitle().

Referenced by addTeamMember(), and removeTeamMember().

        {
                global $ilUser;
                
                // no need to notify current user
                if($ilUser->getId() == $a_user_id)
                {
                        return;
                }               
                                
                include_once "./Services/Notification/classes/class.ilSystemNotification.php";
                $ntf = new ilSystemNotification();
                $ntf->setLangModules(array("exc"));
                $ntf->setRefId($a_exc_ref_id);
                $ntf->setChangedByUserId($ilUser->getId());
                $ntf->setSubjectLangId('exc_team_notification_subject_'.$a_action);
                $ntf->setIntroductionLangId('exc_team_notification_body_'.$a_action);
                $ntf->addAdditionalInfo("exc_assignment", $this->getTitle());   
                $ntf->setGotoLangId('exc_team_notification_link');                              
                $ntf->setReasonLangId('exc_team_notification_reason');                          
                $ntf->sendMail(array($a_user_id));              
        }

Here is the call graph for this function:

Here is the caller graph for this function:

setDeadline()

ilExAssignment::setDeadline

(

$a_val

)

Set deadline (timestamp)

Parameters

int	deadline (timestamp)

Definition at line 119 of file class.ilExAssignment.php.

Referenced by read().

        {
                $this->deadline = $a_val;
        }

Here is the caller graph for this function:

setExerciseId()

ilExAssignment::setExerciseId

(

$a_val

)

Set exercise id.

Parameters

int	exercise id

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

Referenced by read().

        {
                $this->exc_id = $a_val;
        }

Here is the caller graph for this function:

setFeedbackCron()

ilExAssignment::setFeedbackCron

(

$a_value

)

Toggle (global) feedback file cron.

Parameters

bool

$a_value

Definition at line 343 of file class.ilExAssignment.php.

Referenced by read().

        {
                $this->feedback_cron = (string)$a_value;
        }

Here is the caller graph for this function:

setFeedbackFile()

ilExAssignment::setFeedbackFile

(

$a_value

)

Set (global) feedback file.

Parameters

string

$a_value

Definition at line 323 of file class.ilExAssignment.php.

Referenced by handleFeedbackFileUpload(), and read().

        {
                $this->feedback_file = (string)$a_value;
        }

Here is the caller graph for this function:

setId()

ilExAssignment::setId

(

$a_val

)

Set assignment id.

Parameters

int	assignment id

Definition at line 59 of file class.ilExAssignment.php.

Referenced by __construct(), and save().

        {
                $this->id = $a_val;
        }

Here is the caller graph for this function:

setInstruction()

ilExAssignment::setInstruction

(

$a_val

)

Set instruction.

Parameters

string

instruction

Definition at line 139 of file class.ilExAssignment.php.

Referenced by read().

        {
                $this->instruction = $a_val;
        }

Here is the caller graph for this function:

setMandatory()

ilExAssignment::setMandatory

(

$a_val

)

Set mandatory.

Parameters

int

mandatory

Definition at line 179 of file class.ilExAssignment.php.

Referenced by read().

        {
                $this->mandatory = $a_val;
        }

Here is the caller graph for this function:

setOrderNr()

ilExAssignment::setOrderNr

(

$a_val

)

Set order nr.

Parameters

int

order nr

Definition at line 199 of file class.ilExAssignment.php.

Referenced by read(), and save().

        {
                $this->order_nr = $a_val;
        }

Here is the caller graph for this function:

setPeerReview()

ilExAssignment::setPeerReview

(

$a_value

)

Toggle peer review.

Parameters

bool

$a_value

Definition at line 263 of file class.ilExAssignment.php.

Referenced by read(), and setType().

        {
                $this->peer = (bool)$a_value;
        }

Here is the caller graph for this function:

setPeerReviewDeadline()

ilExAssignment::setPeerReviewDeadline

(

$a_val

)

Set peer review deadline (timestamp)

Parameters

int	deadline (timestamp)

Definition at line 303 of file class.ilExAssignment.php.

Referenced by read().

        {
                $this->peer_dl = $a_val;
        }

Here is the caller graph for this function:

setPeerReviewMin()

ilExAssignment::setPeerReviewMin

(

$a_value

)

Set peer review minimum.

Parameters

int

$a_value

Definition at line 283 of file class.ilExAssignment.php.

Referenced by read().

        {
                $this->peer_min = (int)$a_value;
        }

Here is the caller graph for this function:

setStartTime()

ilExAssignment::setStartTime

(

$a_val

)

Set start time (timestamp)

Parameters

int	start time (timestamp)

Definition at line 99 of file class.ilExAssignment.php.

Referenced by read().

        {
                $this->start_time = $a_val;
        }

Here is the caller graph for this function:

setTitle()

ilExAssignment::setTitle

(

$a_val

)

Set title.

Parameters

string

title

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

Referenced by read().

        {
                $this->title = $a_val;
        }

Here is the caller graph for this function:

setType()

ilExAssignment::setType

(

$a_value

)

Set type.

Parameters

int

$a_value

Definition at line 219 of file class.ilExAssignment.php.

References isValidType(), and setPeerReview().

Referenced by __construct(), and read().

        {
                if($this->isValidType($a_value))
                {
                        $this->type = (int)$a_value;
                        
                        if($this->type == self::TYPE_UPLOAD_TEAM)
                        {
                                $this->setPeerReview(false);
                        }
                }
        }

Here is the call graph for this function:

Here is the caller graph for this function:

update()

ilExAssignment::update

(

)

Update.

Definition at line 426 of file class.ilExAssignment.php.

References getDeadline(), getExerciseId(), getFeedbackFile(), getId(), getInstruction(), getMandatory(), getOrderNr(), getPeerReview(), getPeerReviewDeadline(), getPeerReviewMin(), getStartTime(), getTitle(), getType(), and hasFeedbackCron().

        {
                global $ilDB;
                
                $ilDB->update("exc_assignment",
                        array(
                        "exc_id" => array("integer", $this->getExerciseId()),
                        "time_stamp" => array("integer", $this->getDeadline()),
                        "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_dl" => array("integer", $this->getPeerReviewDeadline()),
                        "fb_file" => array("text", $this->getFeedbackFile()),
                        "fb_cron" => array("integer", $this->hasFeedbackCron())
                        ),
                        array(
                        "id" => array("integer", $this->getId()),
                        ));
                $exc = new ilObjExercise($this->getExerciseId(), false);
                $exc->updateAllUsersStatus();
        }

Here is the call graph for this function:

updateAssMemberField()

ilExAssignment::updateAssMemberField (   $a_ass_id,   $a_user_id,   $a_field,   $a_value,   $a_type  )

private

Update a field value of ass/member table.

Definition at line 741 of file class.ilExAssignment.php.

Referenced by updateCommentForUser(), updateMarkOfUser(), and updateStatusTimeOfUser().

        {
                global $ilDB;
                
                $ilDB->manipulate("UPDATE exc_mem_ass_status SET ".
                        " ".$a_field." = ".$ilDB->quote($a_value, $a_type).
                        " WHERE ass_id = ".$ilDB->quote($a_ass_id, "integer").
                        " AND usr_id = ".$ilDB->quote($a_user_id, "integer")
                        );
        }

Here is the caller graph for this function:

updateCommentForUser()

ilExAssignment::updateCommentForUser	(		$a_ass_id,
			$a_user_id,
			$a_value
	)

Update comment.

Definition at line 777 of file class.ilExAssignment.php.

References updateAssMemberField().

Referenced by ilObjExerciseGUI\saveStatusObject(), and ilExerciseXMLParser\updateMarking().

        {
                ilExAssignment::updateAssMemberField($a_ass_id, $a_user_id,
                        "u_comment", $a_value, "text");
        }

Here is the call graph for this function:

Here is the caller graph for this function:

updateMarkOfUser()

ilExAssignment::updateMarkOfUser	(		$a_ass_id,
			$a_user_id,
			$a_value
	)

Update mark.

Definition at line 794 of file class.ilExAssignment.php.

References updateAssMemberField().

Referenced by ilObjExerciseGUI\saveStatusObject(), and ilExerciseXMLParser\updateMarking().

        {
                ilExAssignment::updateAssMemberField($a_ass_id, $a_user_id,
                        "mark", $a_value, "text");
        }

Here is the call graph for this function:

Here is the caller graph for this function:

updateNoticeForUser()

ilExAssignment::updateNoticeForUser	(		$a_ass_id,
			$a_user_id,
			$a_notice
	)

was: setNoticeForMember($a_member_id,$a_notice)

Definition at line 1702 of file class.ilExAssignment.php.

References ilUtil\now().

Referenced by ilObjExerciseGUI\saveStatusObject(), and ilExerciseXMLParser\updateMarking().

        {
                global $ilDB;
                
                // #12181
                $ilDB->manipulate("UPDATE exc_mem_ass_status".
                        " SET notice = ".$ilDB->quote($a_notice, "text").
                        ",status_time= ".$ilDB->quote(ilUtil::now(), "timestamp").
                        " WHERE ass_id = ".$ilDB->quote($a_ass_id, "integer").
                        " AND usr_id = ".$ilDB->quote($a_user_id, "integer").
                        " AND ".$ilDB->equalsNot("notice", $a_notice, "text", true));
        }

Here is the call graph for this function:

Here is the caller graph for this function:

updatePeerReviewComment()

ilExAssignment::updatePeerReviewComment	(		$a_peer_id,
			$a_comment
	)

Definition at line 2619 of file class.ilExAssignment.php.

References $ilUser, getId(), and ilUtil\now().

        {
                global $ilDB, $ilUser;
                
                $ilDB->manipulate("UPDATE exc_assignment_peer".
                        " SET tstamp = ".$ilDB->quote(ilUtil::now(), "timestamp").
                        ", pcomment  = ".$ilDB->quote($a_comment, "text").
                        " WHERE giver_id = ".$ilDB->quote($ilUser->getId(), "integer").
                        " AND peer_id = ".$ilDB->quote($a_peer_id, "integer").
                        " AND ass_id = ".$ilDB->quote($this->getId(), "integer"));
        }

Here is the call graph for this function:

updatePeerReviewTimestamp()

ilExAssignment::updatePeerReviewTimestamp

(

$a_peer_id

)

Definition at line 2608 of file class.ilExAssignment.php.

References $ilUser, getId(), and ilUtil\now().

        {
                global $ilDB, $ilUser;
                
                $ilDB->manipulate("UPDATE exc_assignment_peer".
                        " SET tstamp = ".$ilDB->quote(ilUtil::now(), "timestamp").
                        " WHERE giver_id = ".$ilDB->quote($ilUser->getId(), "integer").
                        " AND peer_id = ".$ilDB->quote($a_peer_id, "integer").
                        " AND ass_id = ".$ilDB->quote($this->getId(), "integer"));
        }

Here is the call graph for this function:

updateStatusFeedbackForUser()

ilExAssignment::updateStatusFeedbackForUser	(		$a_ass_id,
			$a_user_id,
			$a_status
	)

was: setStatusFeedbackForMember($a_member_id,$a_status)

Definition at line 939 of file class.ilExAssignment.php.

References ilUtil\now().

Referenced by ilObjExerciseGUI\redirectFeedbackMailObject().

        {
                global $ilDB;

                $ilDB->manipulateF("UPDATE exc_mem_ass_status ".
                        "SET feedback = %s, status_time= %s, feedback_time = %s ".
                        " WHERE ass_id = %s AND usr_id = %s",
                        array("integer", "timestamp", "timestamp", "integer", "integer"),
                        array((int) $a_status, ilUtil::now(), ($a_status ? ilUtil::now() : null),
                                $a_ass_id, $a_user_id));
        }

Here is the call graph for this function:

Here is the caller graph for this function:

updateStatusOfUser()

ilExAssignment::updateStatusOfUser	(		$a_ass_id,
			$a_user_id,
			$a_status
	)

was: setStatusForMember($a_member_id,$a_status)

Definition at line 816 of file class.ilExAssignment.php.

References ilUtil\now(), and ilObjExercise\updateUserStatus().

Referenced by ilObjExercise\handleSubmission(), ilObjExerciseGUI\saveStatusObject(), and ilExerciseXMLParser\updateMarking().

        {
                global $ilDB;

                $ilDB->manipulateF("UPDATE exc_mem_ass_status ".
                        "SET status = %s, status_time= %s ".
                        " WHERE ass_id = %s AND usr_id = %s AND status <> %s ",
                        array("text", "timestamp", "integer", "integer", "text"),
                        array($a_status, ilUtil::now(), $a_ass_id, $a_user_id, $a_status));
                
                $ass = new ilExAssignment($a_ass_id);
                $exc = new ilObjExercise($ass->getExerciseId(), false);
                $exc->updateUserStatus($a_user_id);
        }

Here is the call graph for this function:

Here is the caller graph for this function:

updateStatusReturnedForUser()

ilExAssignment::updateStatusReturnedForUser	(		$a_ass_id,
			$a_user_id,
			$a_status
	)

was: setStatusReturnedForMember($a_member_id,$a_status)

Definition at line 902 of file class.ilExAssignment.php.

References ilUtil\now().

Referenced by ilObjExercise\addResourceObject(), ilObjExerciseGUI\addTeamMemberActionObject(), ilObjExercise\deleteDeliveredFiles(), ilObjExercise\deliverFile(), and ilObjExerciseGUI\removeTeamMemberObject().

        {
                global $ilDB;

                $ilDB->manipulateF("UPDATE exc_mem_ass_status ".
                        "SET returned = %s, status_time= %s ".
                        " WHERE ass_id = %s AND usr_id = %s",
                        array("integer", "timestamp", "integer", "integer"),
                        array((int) $a_status, ilUtil::now(),
                                $a_ass_id, $a_user_id));
        }

Here is the call graph for this function:

Here is the caller graph for this function:

updateStatusSentForUser()

ilExAssignment::updateStatusSentForUser	(		$a_ass_id,
			$a_user_id,
			$a_status
	)

was: setStatusSentForMember($a_member_id,$a_status)

Definition at line 865 of file class.ilExAssignment.php.

References ilUtil\now().

Referenced by ilObjExercise\sendAssignment().

        {
                global $ilDB;

                $ilDB->manipulateF("UPDATE exc_mem_ass_status ".
                        "SET sent = %s, status_time= %s, sent_time = %s ".
                        " WHERE ass_id = %s AND usr_id = %s ",
                        array("integer", "timestamp", "timestamp", "integer", "integer"),
                        array((int) $a_status, ilUtil::now(), ($a_status ? ilUtil::now() : null),
                                $a_ass_id, $a_user_id));
        }

Here is the call graph for this function:

Here is the caller graph for this function:

updateStatusTimeOfUser()

ilExAssignment::updateStatusTimeOfUser	(		$a_ass_id,
			$a_user_id
	)

was: updateStatusTimeForMember($a_user_id)

Definition at line 834 of file class.ilExAssignment.php.

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

Referenced by ilObjExerciseGUI\saveStatusObject().

        {
                ilExAssignment::updateAssMemberField($a_ass_id, $a_user_id,
                        "status_time", ilUtil::now(), "timestamp");
        }

Here is the call graph for this function:

Here is the caller graph for this function:

updateTutorDownloadTime()

ilExAssignment::updateTutorDownloadTime	(		$a_exc_id,
			$a_ass_id,
			$a_user_id
	)

was: updateTutorDownloadTime($member_id)

Definition at line 1363 of file class.ilExAssignment.php.

References $ilUser, and ilUtil\now().

Referenced by deliverReturnedFiles(), and ilObjExerciseGUI\downloadAllObject().

        {
                global $ilUser, $ilDB;

                $ilDB->manipulateF("DELETE FROM exc_usr_tutor ".
                        "WHERE ass_id = %s AND usr_id = %s AND tutor_id = %s",
                        array("integer", "integer", "integer"),
                        array($a_ass_id, $a_user_id, $ilUser->getId()));

                $ilDB->manipulateF("INSERT INTO exc_usr_tutor (ass_id, obj_id, usr_id, tutor_id, download_time) VALUES ".
                        "(%s, %s, %s, %s, %s)",
                        array("integer", "integer", "integer", "integer", "timestamp"),
                        array($a_ass_id, $a_exc_id, $a_user_id, $ilUser->getId(), ilUtil::now()));
        }

Here is the call graph for this function:

Here is the caller graph for this function:

uploadAssignmentFiles()

ilExAssignment::uploadAssignmentFiles

(

$a_files

)

Upload assignment files (from creation form)

Definition at line 1961 of file class.ilExAssignment.php.

References getExerciseId(), and getId().

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

Here is the call graph for this function:

uploadMultiFeedbackFile()

ilExAssignment::uploadMultiFeedbackFile

(

$a_file

)

Upload multi feedback file.

Parameters

array

Returns

Definition at line 2805 of file class.ilExAssignment.php.

References $ilUser, $lng, ilUtil\delDir(), ilUtil\getDir(), getExerciseId(), getId(), ilUtil\moveUploadedFile(), and ilUtil\unzip().

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

Here is the call graph for this function:

writeTeamLog()

static ilExAssignment::writeTeamLog (   $a_team_id,   $a_action,   $a_details = null  )

static

Add entry to team log.

Parameters

int	$a_team_id
int	$a_action
string	$a_details

Definition at line 2193 of file class.ilExAssignment.php.

References $ilUser.

Referenced by deleteDeliveredFiles(), and ilObjExercise\deliverFile().

        {
                global $ilDB, $ilUser;
                
                $fields = array(
                        "team_id" => array("integer", $a_team_id),
                        "user_id" => array("integer", $ilUser->getId()),
                        "action" => array("integer", $a_action),
                        "details" => array("text", $a_details),
                        "tstamp" => array("integer", time())
                );
                
                $ilDB->insert("il_exc_team_log", $fields);
        }

Here is the caller graph for this function:

Field Documentation

$deadline

ilExAssignment::$deadline

protected

Definition at line 29 of file class.ilExAssignment.php.

Referenced by getDeadline().

$exc_id

ilExAssignment::$exc_id

protected

Definition at line 26 of file class.ilExAssignment.php.

Referenced by getExerciseId().

$feedback_cron

ilExAssignment::$feedback_cron

protected

Definition at line 38 of file class.ilExAssignment.php.

Referenced by hasFeedbackCron().

$feedback_file

ilExAssignment::$feedback_file

protected

Definition at line 37 of file class.ilExAssignment.php.

Referenced by getFeedbackFile().

$id

ilExAssignment::$id

protected

Definition at line 25 of file class.ilExAssignment.php.

Referenced by downloadAllDeliveredFiles(), getId(), and getTeamId().

$instruction

ilExAssignment::$instruction

protected

Definition at line 30 of file class.ilExAssignment.php.

Referenced by getInstruction().

$mandatory

ilExAssignment::$mandatory

protected

Definition at line 32 of file class.ilExAssignment.php.

Referenced by getMandatory().

$order_nr

ilExAssignment::$order_nr

protected

Definition at line 33 of file class.ilExAssignment.php.

Referenced by getOrderNr().

$peer

ilExAssignment::$peer

protected

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

Referenced by getPeerReview().

$peer_dl

ilExAssignment::$peer_dl

protected

Definition at line 36 of file class.ilExAssignment.php.

Referenced by getPeerReviewDeadline().

$peer_min

ilExAssignment::$peer_min

protected

Definition at line 35 of file class.ilExAssignment.php.

Referenced by getPeerReviewMin().

$start_time

ilExAssignment::$start_time

protected

Definition at line 28 of file class.ilExAssignment.php.

Referenced by getStartTime().

$title

ilExAssignment::$title

protected

Definition at line 31 of file class.ilExAssignment.php.

Referenced by getTitle().

$type

ilExAssignment::$type

protected

Definition at line 27 of file class.ilExAssignment.php.

Referenced by getTeamIdByAssignment(), and getType().

TEAM_LOG_ADD_FILE

const ilExAssignment::TEAM_LOG_ADD_FILE = 4

Definition at line 22 of file class.ilExAssignment.php.

Referenced by ilObjExercise\deliverFile(), and ilExAssignmentTeamLogTableGUI\getItems().

TEAM_LOG_ADD_MEMBER

const ilExAssignment::TEAM_LOG_ADD_MEMBER = 2

Definition at line 20 of file class.ilExAssignment.php.

Referenced by ilExAssignmentTeamLogTableGUI\getItems().

TEAM_LOG_CREATE_TEAM

const ilExAssignment::TEAM_LOG_CREATE_TEAM = 1

Definition at line 19 of file class.ilExAssignment.php.

Referenced by ilExAssignmentTeamLogTableGUI\getItems().

TEAM_LOG_REMOVE_FILE

const ilExAssignment::TEAM_LOG_REMOVE_FILE = 5

Definition at line 23 of file class.ilExAssignment.php.

Referenced by deleteDeliveredFiles(), and ilExAssignmentTeamLogTableGUI\getItems().

TEAM_LOG_REMOVE_MEMBER

const ilExAssignment::TEAM_LOG_REMOVE_MEMBER = 3

Definition at line 21 of file class.ilExAssignment.php.

Referenced by ilExAssignmentTeamLogTableGUI\getItems().

TYPE_BLOG

const ilExAssignment::TYPE_BLOG = 2

Definition at line 14 of file class.ilExAssignment.php.

Referenced by ilAssignmentsTableGUI\__construct(), downloadAllDeliveredFiles(), downloadSelectedFiles(), getDownloadedFilesInfoForTableGUIS(), ilExAssignmentGUI\getOverviewBody(), and ilObjExerciseGUI\initAssignmentForm().

TYPE_PORTFOLIO

const ilExAssignment::TYPE_PORTFOLIO = 3

Definition at line 15 of file class.ilExAssignment.php.

Referenced by ilAssignmentsTableGUI\__construct(), ilObjPortfolioGUI\createPortfolioFromTemplateProcess(), downloadAllDeliveredFiles(), downloadSelectedFiles(), getDownloadedFilesInfoForTableGUIS(), ilExAssignmentGUI\getOverviewBody(), and ilObjExerciseGUI\initAssignmentForm().

TYPE_TEXT

const ilExAssignment::TYPE_TEXT = 5

Definition at line 17 of file class.ilExAssignment.php.

Referenced by ilAssignmentsTableGUI\__construct(), ilObjExerciseGUI\editAssignmentTextObject(), getDownloadedFilesInfoForTableGUIS(), ilExAssignmentGUI\getOverviewBody(), ilObjExerciseGUI\initAssignmentForm(), ilObjExerciseGUI\listPublicSubmissionsObject(), ilObjExerciseGUI\listTextAssignmentObject(), ilObjExerciseGUI\membersObject(), ilObjExerciseGUI\showAssignmentTextObject(), and ilObjExerciseGUI\updateAssignmentTextObject().

TYPE_UPLOAD

const ilExAssignment::TYPE_UPLOAD = 1

Definition at line 13 of file class.ilExAssignment.php.

Referenced by ilAssignmentsTableGUI\__construct(), getDownloadedFilesInfoForTableGUIS(), ilExAssignmentGUI\getOverviewBody(), and ilObjExerciseGUI\initAssignmentForm().

TYPE_UPLOAD_TEAM

const ilExAssignment::TYPE_UPLOAD_TEAM = 4

Definition at line 16 of file class.ilExAssignment.php.

Referenced by ilExcDeliveredFilesTableGUI\__construct(), ilAssignmentsTableGUI\__construct(), ilExerciseMemberTableGUI\__construct(), ilObjExerciseGUI\addMembersObject(), ilObjExerciseGUI\confirmDeassignMembersObject(), ilObjExerciseGUI\downloadFeedbackFileObject(), ilObjExerciseGUI\executeCommand(), ilExcDeliveredFilesTableGUI\fillRow(), ilExParticipantTableGUI\fillRow(), ilExerciseMemberTableGUI\fillRow(), ilObjExerciseGUI\getAssignmentValues(), getDownloadedFilesInfoForTableGUIS(), ilExAssignmentGUI\getOverviewBody(), ilObjExerciseGUI\initAssignmentForm(), ilObjExerciseGUI\initTeamSubmission(), ilObjExerciseGUI\redirectFeedbackMailObject(), ilObjExerciseGUI\saveAssignmentObject(), saveMultiFeedbackFiles(), ilObjExerciseGUI\saveStatusObject(), ilObjExerciseGUI\sendMembersObject(), and ilObjExerciseGUI\updateAssignmentObject().

---

The documentation for this class was generated from the following file:

• Modules/Exercise/classes/class.ilExAssignment.php