Inheritance diagram for ilObjExercise:

Collaboration diagram for ilObjExercise:

Public Member Functions
	ilObjExercise ($a_id=0, $a_call_by_reference=true)
	Constructor public. More...

	setDate ($a_hour, $a_minutes, $a_day, $a_month, $a_year)

	getTimestamp ()

	setTimestamp ($a_timestamp)

	setInstruction ($a_instruction)

	getInstruction ()

	setPassMode ($a_val)
	Set pass mode (all \| nr) More...

	getPassMode ()
	Get pass mode (all \| nr) More...

	setPassNr ($a_val)
	Set number of assignments that must be passed to pass the exercise. More...

	getPassNr ()
	Get number of assignments that must be passed to pass the exercise. More...

	setShowSubmissions ($a_val)
	Set whether submissions of learners should be shown to other learners after deadline. More...

	getShowSubmissions ()
	Get whether submissions of learners should be shown to other learners after deadline. More...

	checkDate ()

	deliverFile ($a_http_post_files, $a_ass_id, $user_id, $unzip=false)
	Save submitted file of user. More...

	addUploadedFile ($a_http_post_files, $unzipUploadedFile=false)
	Upload assigment files. More...

	deleteFiles ($a_files)

	saveData ()

	cloneObject ($a_target_id, $a_copy_id=0)
	Clone exercise (no member data) More...

	deleteDeliveredFiles ($a_exc_id, $a_ass_id, $file_id_array, $user_id)
	Deletes already delivered files. More...

	deliverReturnedFiles ($user_id)
	Delivers the returned files of an user. More...

	delete ()
	delete course and all related data More...

	notify ($a_event, $a_ref_id, $a_node_id, $a_params=0)
	notifys an object about an event occured Based on the event happend, each object may decide how it reacts. More...

	read ()

	update ()

	sendAssignment ($a_exc_id, $a_ass_id, $a_members)
	send exercise per mail to members More...

	_lookupStatusTime ($exc_id, $member_id)
	Get time when exercise has been set to solved. More...

	__formatBody ($a_ass_id)

	__formatSubject ($a_ass_title="")

	__formatRecipients ($a_members)

	_checkCondition ($a_exc_id, $a_operator, $a_value, $a_usr_id=0)

	processUploadedFile ($fileTmp, $storageMethod, $persistentErrorMessage, $a_ass_id)
	processes errorhandling etc for uploaded archive More...

	determinStatusOfUser ($a_user_id=0)
	Determine status of user. More...

	updateUserStatus ($a_user_id=0)
	Update exercise status of user. More...

	updateAllUsersStatus ()
	Update status of all users. More...

	exportGradesExcel ()
	Exports grades as excel. More...

	sendFeedbackFileNotification ($a_feedback_file, $a_user_id, $a_ass_id)
	Send feedback file notification to user. More...

	isCompletionBySubmissionEnabled ()
	Checks whether completion by submission is enabled or not. More...

	setCompletionBySubmission ($bool)
	Enabled/Disable completion by submission. More...

	handleSubmission ($ass_id)
	This method is called after an user submitted one or more files. More...

	addResourceObject ($a_wsp_id, $a_ass_id, $user_id, $a_text=null)
	Add personal resource to assigment. More...

	deleteResourceObject ($a_ass_id, $user_id, $a_returned_id)
	Remove personal resource to assigment. More...

	updateTextSubmission ($a_exc_id, $a_ass_id, $a_user_id, $a_text)
	Handle text assignment submissions. More...

	deleteAllDeliveredFilesOfUser ($a_user_id)
	Delete all delivered files of user. More...

	getCertificateVisibility ()
	Returns the visibility settings of the certificate. More...

	setCertificateVisibility ($a_value)
	Sets the visibility settings of the certificate. More...

	saveCertificateVisibility ($a_value)
	Saves the visibility settings of the certificate. More...

	hasUserCertificate ($a_user_id)
	Check if given user has certificate to show/download. More...

Public Member Functions inherited from ilObject
	ilObject ($a_id=0, $a_reference=true)
	Constructor public. More...

	withReferences ()
	determines wehter objects are referenced or not (got ref ids or not) More...

	read ($a_force_db=false)
	read object data from db into object More...

	getId ()
	get object id public More...

	setId ($a_id)
	set object id public More...

	setRefId ($a_id)
	set reference id public More...

	getRefId ()
	get reference id public More...

	getType ()
	get object type public More...

	setType ($a_type)
	set object type public More...

	getPresentationTitle ()
	get presentation title Normally same as title Overwritten for sessions More...

	getTitle ()
	get object title public More...

	getUntranslatedTitle ()
	get untranslated object title public More...

	setTitle ($a_title)
	set object title More...

	getDescription ()
	get object description More...

	setDescription ($a_desc)
	set object description More...

	getLongDescription ()
	get object long description (stored in object_description) More...

	getImportId ()
	get import id More...

	setImportId ($a_import_id)
	set import id More...

	getOwner ()
	get object owner More...

	getOwnerName ()

	_lookupOwnerName ($a_owner_id)
	lookup owner name for owner id More...

	setOwner ($a_owner)
	set object owner More...

	getCreateDate ()
	get create date public More...

	getLastUpdateDate ()
	get last update date public More...

	getDiskUsage ()
	Gets the disk usage of the object in bytes. More...

	setObjDataRecord ($a_record)
	set object_data record (note: this method should only be called from the ilObjectFactory class) More...

	create ()
	create More...

	update ()
	update object in db More...

	MDUpdateListener ($a_element)
	Meta data update listener. More...

	createMetaData ()
	create meta data entry More...

	updateMetaData ()
	update meta data entry More...

	deleteMetaData ()
	delete meta data entry More...

	updateOwner ()
	update owner of object in db More...

	_getIdForImportId ($a_import_id)
	get current object id for import id (static) More...

	_lookupOwner ($a_id)
	lookup object owner More...

	_lookupLastUpdate ($a_id, $a_as_string=false)
	lookup last update More...

	_getLastUpdateOfObjects ($a_objs)
	Get last update for a set of media objects. More...

	_setDeletedDate ($a_ref_id)
	only called in ilTree::saveSubTree More...

	_resetDeletedDate ($a_ref_id)
	only called in ilObjectGUI::insertSavedNodes More...

	_lookupDeletedDate ($a_ref_id)
	only called in ilObjectGUI::insertSavedNodes More...

	_writeTitle ($a_obj_id, $a_title)
	write title to db (static) More...

	_writeDescription ($a_obj_id, $a_desc)
	write description to db (static) More...

	_writeImportId ($a_obj_id, $a_import_id)
	write import id to db (static) More...

	_isInTrash ($a_ref_id)
	checks wether object is in trash More...

	_hasUntrashedReference ($a_obj_id)
	checks wether an object has at least one reference that is not in trash More...

	_getObjectsDataForType ($a_type, $a_omit_trash=false)
	get all objects of a certain type More...

	putInTree ($a_parent_ref)
	maybe this method should be in tree object!? More...

	setPermissions ($a_parent_ref)
	set permissions of object More...

	createReference ()
	creates reference for object More...

	countReferences ()
	count references of object More...

	delete ()
	delete object or referenced object (in the case of a referenced object, object data is only deleted if last reference is deleted) This function removes an object entirely from system!! More...

	initDefaultRoles ()
	init default roles settings Purpose of this function is to create a local role folder and local roles, that are needed depending on the object type If you want to setup default local roles you MUST overwrite this method in derived object classes (see ilObjForum for an example) public More...

	createRoleFolder ()
	creates a local role folder More...

	applyDidacticTemplate ($a_tpl_id)
	Apply template. More...

	notify ($a_event, $a_ref_id, $a_parent_non_rbac_id, $a_node_id, $a_params=0)
	notifys an object about an event occured Based on the event passed, each object may decide how it reacts. More...

	setRegisterMode ($a_bool)

	isUserRegistered ($a_user_id=0)

	requireRegistration ()

	getXMLZip ()

	getHTMLDirectory ()

	cloneObject ($a_target_id, $a_copy_id=0, $a_omit_tree=false)
	Clone object permissions, put in tree ... More...

	appendCopyInfo ($a_target_id, $a_copy_id)
	Prepend Copy info if object with same name exists in that container. More...

	cloneDependencies ($a_target_id, $a_copy_id)
	Clone object dependencies. More...

	cloneMetaData ($target_obj)
	Copy meta data. More...

	_lookupCreationDate ($a_id)
	Lookup creation date. More...

Static Public Member Functions
static	_fixFilename ($a_filename)
	This function fixes filenames. More...

static	_fixFilenameArray ($a_array)
	Iterates an associative array and fixes all fields with the key "filename" using the _fixFilename() method. More...

static	_lookupFinishedUserExercises ($a_user_id)
	Get all exercises for user. More...

static	lookupExerciseIdForReturnedId ($a_returned_id)

static	findUserFiles ($a_user_id, $a_filetitle)
	Check if given file was assigned. More...

Static Public Member Functions inherited from ilObject
static	_lookupObjIdByImportId ($a_import_id)

static	_getAllReferences ($a_id)
	get all reference ids of object More...

static	_lookupTitle ($a_id)
	lookup object title More...

static	_getIdsForTitle ($title, $type='', $partialmatch=false)

static	_lookupDescription ($a_id)
	lookup object description More...

static	_lookupObjId ($a_id)

static	setDeletedDates ($a_ref_ids)
	Set deleted date type $ilDB. More...

static	_lookupType ($a_id, $a_reference=false)
	lookup object type More...

static	_lookupObjectId ($a_ref_id)
	lookup object id More...

static	_exists ($a_id, $a_reference=false, $a_type=null)
	checks if an object exists in object_data More...

static	_getObjectsByType ($a_obj_type="", $a_owner="")
	Get objects by type. More...

static	_prepareCloneSelection ($a_ref_ids, $new_type, $show_path=true)
	Prepare copy wizard object selection. More...

static	_getIcon ($a_obj_id="", $a_size="big", $a_type="", $a_offline=false)
	Get icon for repository item. More...

static	collectDeletionDependencies (&$deps, $a_ref_id, $a_obj_id, $a_type, $a_depth=0)
	Collect deletion dependencies. More...

static	getDeletionDependencies ($a_obj_id)
	Get deletion dependencies. More...

static	getLongDescriptions (array $a_obj_ids)
	Get long description data. More...

static	getAllOwnedRepositoryObjects ($a_user_id)
	Get all ids of objects user owns. More...

static	hasAutoRating ($a_type, $a_ref_id)
	Check if auto rating is active for parent group/course. More...

Data Fields
	$file_obj

	$members_obj

	$files

	$timestamp

	$hour

	$minutes

	$day

	$month

	$year

	$instruction

	$certificate_visibility

Data Fields inherited from ilObject
const	TITLE_LENGTH = 255
	max length of object title More...

const	DESC_LENGTH = 128

	$ilias

	$lng

	$id

	$ref_id

	$type

	$title

	$untranslatedTitle

	$desc

	$long_desc

	$owner

	$create_date

	$last_update

	$import_id

	$register = false

	$referenced

	$objectList

	$max_title

	$max_desc

	$add_dots

	$obj_data_record
	object_data record More...

Protected Attributes
	$completion_by_submission = false

Detailed Description

Class ilObjExercise.

Author: Stefan Meyer meyer.nosp@m.@lei.nosp@m.fos.c.nosp@m.om; Michael Jansen mjans.nosp@m.en@d.nosp@m.ataba.nosp@m.y.de

Version: $Id$

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

Member Function Documentation

◆ __formatBody()

ilObjExercise::__formatBody ( $a_ass_id )

Definition at line 536 of file class.ilObjExercise.php.

References ilObject\$lng, ilFormat\formatDate(), and ilObject\getType().

Referenced by sendAssignment().

         {
                 global $lng;
 
                 $lng->loadLanguageModule("exc");
                 
                 include_once("./Modules/Exercise/classes/class.ilExAssignment.php");
                 $ass = new ilExAssignment($a_ass_id);
 
                 $body = $ass->getInstruction();
                 $body .= "\n\n";
                 if ($ass->getDeadline() == 0)
                 {
                         $body .= $lng->txt("exc_edit_until") . ": ".
                                 $lng->txt("exc_no_deadline_specified");
                 }
                 else
                 {
                         $body .= $lng->txt("exc_edit_until") . ": ".
                                 ilFormat::formatDate(date("Y-m-d H:i:s",$ass->getDeadline()), "datetime", true);
                 }
                 $body .= "\n\n";
                 $body .= ILIAS_HTTP_PATH.
                         "/goto.php?target=".
                         $this->getType().
                         "_".$this->getRefId()."&client_id=".CLIENT_ID;
 
                 return $body;
         }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ __formatRecipients()

ilObjExercise::__formatRecipients ( $a_members )

Definition at line 578 of file class.ilObjExercise.php.

References ilObjectFactory\getInstanceByObjId().

Referenced by sendAssignment().

         {
                 foreach($a_members as $member_id => $value)
                 {
                         $tmp_obj = ilObjectFactory::getInstanceByObjId($member_id);
                         $tmp_members[] = $tmp_obj->getLogin();
 
                         unset($tmp_obj);
                 }
 
                 return implode(',',$tmp_members ? $tmp_members : array());
         }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ __formatSubject()

ilObjExercise::__formatSubject ( $a_ass_title = "" )

Definition at line 566 of file class.ilObjExercise.php.

References ilObject\getTitle().

Referenced by sendAssignment().

         {
                 $subject = $this->getTitle();
                 
                 if ($a_ass_title != "")
                 {
                         $subject.= ": ".$a_ass_title;
                 }
 
                 return $subject;
         }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ _checkCondition()

ilObjExercise::_checkCondition	(	$a_exc_id,
		$a_operator,
		$a_value,
		$a_usr_id = `0`
	)

Definition at line 591 of file class.ilObjExercise.php.

References $ilUser, and ilExerciseMembers\_lookupStatus().

Referenced by ilConditionHandler\_checkCondition().

         {
                 global $ilUser;
                 
                 $a_usr_id = $a_usr_id ? $a_usr_id : $ilUser->getId();
 
                 switch($a_operator)
                 {
                         case 'passed':
                                 if (ilExerciseMembers::_lookupStatus($a_exc_id, $a_usr_id) == "passed")
                                 {
                                         return true;
                                 }
                                 else
                                 {
                                         return false;
                                 }
                                 break;
 
                         default:
                                 return true;
                 }
                 return true;
         }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ _fixFilename()

static ilObjExercise::_fixFilename ( $a_filename )

static

This function fixes filenames.

Prior to ILIAS 3.10.0 filenames have been stored with full path in exc_returned.filename, e.g. /opt/ilias/my_client/exercise/547/157/20070813113926_README.doc

Problems occur, if the server is moved from one location to another. We do the following: The filename will be parsed and if it contains the string "/exercise/" we truncate everything before "/exercise/" and replace it with the current CLIENT_DATA_DIR.

Definition at line 679 of file class.ilObjExercise.php.

Referenced by _fixFilenameArray().

         {
                 $ex_pos = strrpos($a_filename, "/exercise/");
                 if ($ex_pos > 0)
                 {
                         $a_filename = CLIENT_DATA_DIR.substr($a_filename, $ex_pos);
                 }
                 return $a_filename;
         }

Here is the caller graph for this function:

◆ _fixFilenameArray()

static ilObjExercise::_fixFilenameArray ( $a_array )

static

Iterates an associative array and fixes all fields with the key "filename" using the _fixFilename() method.

Definition at line 693 of file class.ilObjExercise.php.

References _fixFilename().

         {
                 if (is_array($a_array))
                 {
                         foreach ($a_array as $k => $v)
                         {
                                 if ($v["filename"] != "")
                                 {
                                         $a_array[$k]["filename"] = ilObjExercise::_fixFilename($a_array[$k]["filename"]);
                                 }
                         }
                 }
                 
                 return $a_array;
         }

Here is the call graph for this function:

◆ _lookupFinishedUserExercises()

static ilObjExercise::_lookupFinishedUserExercises ( $a_user_id )

static

Get all exercises for user.

Parameters

<type> $a_user_id

Returns: array (exercise id => passed)

Definition at line 1057 of file class.ilObjExercise.php.

References $row.

Referenced by ilExerciseVerificationTableGUI\getItems().

         {
                 global $ilDB;
 
                 $set = $ilDB->query("SELECT obj_id, status FROM exc_members".
                         " WHERE usr_id = ".$ilDB->quote($a_user_id, "integer").
                         " AND (status = ".$ilDB->quote("passed", "text").
                         " OR status = ".$ilDB->quote("failed", "text").")");
 
                 $all = array();
                 while($row = $ilDB->fetchAssoc($set))
                 {
                         $all[$row["obj_id"]] = ($row["status"] == "passed");
                 }
                 return $all;
         }

Here is the caller graph for this function:

◆ _lookupStatusTime()

ilObjExercise::_lookupStatusTime	(	$exc_id,
		$member_id
	)

Get time when exercise has been set to solved.

Definition at line 518 of file class.ilObjExercise.php.

References ilObject\$lng, and ilUtil\getMySQLTimestamp().

         {
 
                 global $ilDB, $lng;
 
                 $q = "SELECT * ".
                 "FROM exc_members ".
                 "WHERE obj_id= ".$ilDB->quote($exc_id, "integer").
                 " AND usr_id= ".$ilDB->quote($member_id, "integer");
 
                 $set = $ilDB->query($q);
                 if ($rec = $ilDB->fetchAssoc($set))
                 {
                         return ilUtil::getMySQLTimestamp($rec["status_time"]);
                 }
         }

Here is the call graph for this function:

◆ addResourceObject()

ilObjExercise::addResourceObject	(	$a_wsp_id,
		$a_ass_id,
		$user_id,
		$a_text = `null`
	)

Add personal resource to assigment.

Parameters

int	$a_wsp_id
int	$a_ass_id
int	$user_id
string	$a_text

Definition at line 1082 of file class.ilObjExercise.php.

References $query, ilExerciseMembers\_writeReturned(), ilObject\getId(), ilUtil\now(), and ilExAssignment\updateStatusReturnedForUser().

Referenced by updateTextSubmission().

         {
                 global $ilDB;
         
                 $next_id = $ilDB->nextId("exc_returned");
                 $query = sprintf("INSERT INTO exc_returned ".
                                                  "(returned_id, obj_id, user_id, filetitle, ass_id, ts, atext) ".
                                                  "VALUES (%s, %s, %s, %s, %s, %s, %s)",
                         $ilDB->quote($next_id, "integer"),
                         $ilDB->quote($this->getId(), "integer"),
                         $ilDB->quote($user_id, "integer"),
                         $ilDB->quote($a_wsp_id, "text"),
                         $ilDB->quote($a_ass_id, "integer"),
                         $ilDB->quote(ilUtil::now(), "timestamp"),
                         $ilDB->quote($a_text, "text")
                 );
                 $ilDB->manipulate($query);
                 if (!$this->members_obj->isAssigned($user_id))
                 {
                         $this->members_obj->assignMember($user_id);
                 }
                 // no submission (of blog/portfolio) yet (unless text assignment)
                 ilExAssignment::updateStatusReturnedForUser($a_ass_id, $user_id, (bool)$a_text);
                 ilExerciseMembers::_writeReturned($this->getId(), $user_id, (bool)$a_text);
                 
                 return $next_id;
         }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ addUploadedFile()

ilObjExercise::addUploadedFile	(	$a_http_post_files,
		$unzipUploadedFile = `false`
	)

Upload assigment files.

Definition at line 218 of file class.ilObjExercise.php.

References ilObject\$lng, and processUploadedFile().

         {
                 global $lng;
                 if ($unzipUploadedFile && preg_match("/zip/",   $a_http_post_files["type"]) == 1)
                 {
 
                         $this->processUploadedFile($a_http_post_files["tmp_name"], "storeUploadedFile", true);
                         return true;
                         
                         
                 }
                 else 
                 {
                         $this->file_obj->storeUploadedFile($a_http_post_files, true);
                         return true;
                 }
         }

Here is the call graph for this function:

◆ checkDate()

ilObjExercise::checkDate ( )

Definition at line 152 of file class.ilObjExercise.php.

         {
                 return  $this->hour == (int) date("H",$this->timestamp) and
                         $this->minutes == (int) date("i",$this->timestamp) and
                         $this->day == (int) date("d",$this->timestamp) and
                         $this->month == (int) date("m",$this->timestamp) and
                         $this->year == (int) date("Y",$this->timestamp);
 
         }

◆ cloneObject()

ilObjExercise::cloneObject	(	$a_target_id,
		$a_copy_id = `0`
	)

Clone exercise (no member data)

public

Parameters

int	target ref_id
int	copy id

Definition at line 271 of file class.ilObjExercise.php.

References ilExAssignment\cloneAssignmentsOfExercise(), ilObject\getId(), getInstruction(), getPassMode(), getPassNr(), getShowSubmissions(), getTimestamp(), and isCompletionBySubmissionEnabled().

         {
                 global $ilDB;
                 
                 // Copy settings
                 $new_obj = parent::cloneObject($a_target_id,$a_copy_id);
                 $new_obj->setInstruction($this->getInstruction());
                 $new_obj->setTimestamp($this->getTimestamp());
                 $new_obj->setPassMode($this->getPassMode());
                 $new_obj->saveData();
                 $new_obj->setPassNr($this->getPassNr());
                 $new_obj->setShowSubmissions($this->getShowSubmissions());
                 $new_obj->setCompletionBySubmission($this->isCompletionBySubmissionEnabled());
 
                 
                 $new_obj->update();
                 
                 // Copy assignments
                 include_once("./Modules/Exercise/classes/class.ilExAssignment.php");
                 ilExAssignment::cloneAssignmentsOfExercise($this->getId(), $new_obj->getId());
                 //$tmp_file_obj =& new ilFileDataExercise($this->getId());
                 //$tmp_file_obj->ilClone($new_obj->getId());
                 //unset($tmp_file_obj);
                 
                 // Copy learning progress settings
                 include_once('Services/Tracking/classes/class.ilLPObjSettings.php');
                 $obj_settings = new ilLPObjSettings($this->getId());
                 $obj_settings->cloneSettings($new_obj->getId());
                 unset($obj_settings);
                                 
                 return $new_obj;
         }

Here is the call graph for this function:

◆ delete()

ilObjExercise::delete ( )

delete course and all related data

public

Returns: boolean true if all object data were removed; false if only a references were removed

Definition at line 347 of file class.ilObjExercise.php.

References ilObject\getId(), ilNotification\removeForObject(), and ilNotification\TYPE_EXERCISE_SUBMISSION.

         {
                 global $ilDB;
 
                 // always call parent delete function first!!
                 if (!parent::delete())
                 {
                         return false;
                 }
                 // put here course specific stuff
                 $ilDB->manipulate("DELETE FROM exc_data ".
                         "WHERE obj_id = ".$ilDB->quote($this->getId(), "integer"));
 
                 //$this->ilias->db->query($query);
 
                 //$this->file_obj->delete();
                 //$this->members_obj->delete();
 
                 // remove all notifications
                 include_once "./Services/Notification/classes/class.ilNotification.php";
                 ilNotification::removeForObject(ilNotification::TYPE_EXERCISE_SUBMISSION, $this->getId());
 
                 return true;
         }

Here is the call graph for this function:

◆ deleteAllDeliveredFilesOfUser()

ilObjExercise::deleteAllDeliveredFilesOfUser ( $a_user_id )

Delete all delivered files of user.

Parameters

int $a_user_id user id

Definition at line 1193 of file class.ilObjExercise.php.

References ilExAssignment\deleteAllDeliveredFilesOfUser(), and ilObject\getId().

         {
                 include_once("./Modules/Exercise/classes/class.ilExAssignment.php");
                 ilExAssignment::deleteAllDeliveredFilesOfUser($this->getId(), $a_user_id);
         }

Here is the call graph for this function:

◆ deleteDeliveredFiles()

ilObjExercise::deleteDeliveredFiles	(	$a_exc_id,
		$a_ass_id,
		$file_id_array,
		$user_id
	)

Deletes already delivered files.

Parameters

array	$file_id_array	An array containing database ids of the delivered files
numeric	$user_id	The database id of the user public

Definition at line 310 of file class.ilObjExercise.php.

References ilExAssignment\deleteDeliveredFiles(), ilExAssignment\getDeliveredFiles(), ilExAssignment\getTeamMembersByAssignmentId(), and ilExAssignment\updateStatusReturnedForUser().

Referenced by updateTextSubmission().

         {
                 ilExAssignment::deleteDeliveredFiles($a_exc_id, $a_ass_id, $file_id_array, $user_id);
 
                 // Finally update status 'returned' of member if no file exists
                 if(!count(ilExAssignment::getDeliveredFiles($a_exc_id, $a_ass_id, $user_id)))
                 {                       
                         // team upload?
                         $user_ids = ilExAssignment::getTeamMembersByAssignmentId($a_ass_id, $user_id);
                         if(!$user_ids)
                         {
                                 $user_ids = array($user_id);
                         }
                         
                         foreach($user_ids as $user_id)
                         {                       
                                 ilExAssignment::updateStatusReturnedForUser($a_ass_id, $user_id, 0);
                         }
                 }
         }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ deleteFiles()

ilObjExercise::deleteFiles ( $a_files )

Definition at line 235 of file class.ilObjExercise.php.

         {
                 $this->file_obj->unlinkFiles($a_files);
         }

◆ deleteResourceObject()

ilObjExercise::deleteResourceObject	(	$a_ass_id,
		$user_id,
		$a_returned_id
	)

Remove personal resource to assigment.

Parameters

int	$a_ass_id
int	$user_id
int	$a_returned_id

Definition at line 1117 of file class.ilObjExercise.php.

         {
                 global $ilDB;
                 
                 $ilDB->manipulate("DELETE FROM exc_returned".
                         " WHERE obj_id = ".$ilDB->quote($this->getId(), "integer").
                         " AND user_id = ".$ilDB->quote($user_id, "integer").
                         " AND ass_id = ".$ilDB->quote($a_ass_id, "integer").
                         " AND returned_id = ".$ilDB->quote($a_returned_id, "integer"));         
         }

◆ deliverFile()

ilObjExercise::deliverFile	(	$a_http_post_files,
		$a_ass_id,
		$user_id,
		$unzip = `false`
	)

Save submitted file of user.

Definition at line 165 of file class.ilObjExercise.php.

References $query, ilExerciseMembers\_writeReturned(), ilObject\getId(), ilExAssignment\getTeamIdByAssignment(), ilExAssignment\getTeamMembersByAssignmentId(), ilUtil\now(), ilExAssignment\TEAM_LOG_ADD_FILE, ilExAssignment\updateStatusReturnedForUser(), and ilExAssignment\writeTeamLog().

         {
                 global $ilDB;
                 
                 include_once("./Modules/Exercise/classes/class.ilFSStorageExercise.php");
                 $storage = new ilFSStorageExercise($this->getId(), $a_ass_id);
                 $deliver_result = $storage->deliverFile($a_http_post_files, $user_id, $unzip);
 //var_dump($deliver_result);
                 if ($deliver_result)
                 {
                         $next_id = $ilDB->nextId("exc_returned");
                         $query = sprintf("INSERT INTO exc_returned ".
                                                          "(returned_id, obj_id, user_id, filename, filetitle, mimetype, ts, ass_id) ".
                                                          "VALUES (%s, %s, %s, %s, %s, %s, %s, %s)",
                                 $ilDB->quote($next_id, "integer"),
                                 $ilDB->quote($this->getId(), "integer"),
                                 $ilDB->quote($user_id, "integer"),
                                 $ilDB->quote($deliver_result["fullname"], "text"),
                                 $ilDB->quote($a_http_post_files["name"], "text"),
                                 $ilDB->quote($deliver_result["mimetype"], "text"),
                                 $ilDB->quote(ilUtil::now(), "timestamp"),
                                 $ilDB->quote($a_ass_id, "integer")
                         );
                         $ilDB->manipulate($query);
                         
                         // team upload?
                         $user_ids = ilExAssignment::getTeamMembersByAssignmentId($a_ass_id, $user_id);
                         if(!$user_ids)
                         {
                                 $user_ids = array($user_id);
                         }
                         else
                         {                               
                                 $team_id = ilExAssignment::getTeamIdByAssignment($a_ass_id, $user_id);
                                 ilExAssignment::writeTeamLog($team_id, ilExAssignment::TEAM_LOG_ADD_FILE, $a_http_post_files["name"]);                  
                         }
                         
                         foreach($user_ids as $user_id)
                         {
                                 if (!$this->members_obj->isAssigned($user_id))
                                 {
                                         $this->members_obj->assignMember($user_id);
                                 }
                                 ilExAssignment::updateStatusReturnedForUser($a_ass_id, $user_id, 1);
                                 ilExerciseMembers::_writeReturned($this->getId(), $user_id, 1);
                         }
                 }
                 return true;
         }

Here is the call graph for this function:

◆ deliverReturnedFiles()

ilObjExercise::deliverReturnedFiles ( $user_id )

Delivers the returned files of an user.

Parameters

numeric $user_id The database id of the user public

Definition at line 336 of file class.ilObjExercise.php.

         {
                 require_once "./Services/Utilities/classes/class.ilUtil.php";
         }

◆ determinStatusOfUser()

ilObjExercise::determinStatusOfUser ( $a_user_id = 0 )

Determine status of user.

Definition at line 712 of file class.ilObjExercise.php.

References $ilUser, $ret, ilExAssignment\getAssignmentDataOfExercise(), ilObject\getId(), getPassMode(), getPassNr(), and ilExAssignment\lookupStatusOfUser().

Referenced by updateUserStatus().

         {
                 global $ilUser;
 
                 if ($a_user_id == 0)
                 {
                         $a_user_id = $ilUser->getId();
                 }
                 
                 include_once("./Modules/Exercise/classes/class.ilExAssignment.php");
                 $ass = ilExAssignment::getAssignmentDataOfExercise($this->getId());
                 
                 $passed_all_mandatory = true;
                 $failed_a_mandatory = false;
                 $cnt_passed = 0;
                 $cnt_notgraded = 0;
                 $passed_at_least_one = false;
                 
                 foreach ($ass as $a)
                 {
                         $stat = ilExAssignment::lookupStatusOfUser($a["id"], $a_user_id);
                         if ($a["mandatory"] && ($stat == "failed" || $stat == "notgraded"))
                         {
                                 $passed_all_mandatory = false;
                         }
                         if ($a["mandatory"] && ($stat == "failed"))
                         {
                                 $failed_a_mandatory = true;
                         }
                         if ($stat == "passed")
                         {
                                 $cnt_passed++;
                         }
                         if ($stat == "notgraded")
                         {
                                 $cnt_notgraded++;
                         }
                 }
                 
                 if (count($ass) == 0)
                 {
                         $passed_all_mandatory = false;
                 }
                 
                 if ($this->getPassMode() != "nr")
                 {
 //echo "5";
                         $overall_stat = "notgraded";
                         if ($failed_a_mandatory)
                         {
 //echo "6";
                                 $overall_stat = "failed";
                         }
                         else if ($passed_all_mandatory && $cnt_passed > 0)
                         {
 //echo "7";
                                 $overall_stat = "passed";
                         }
                 }
                 else
                 {
 //echo "8";
                         $min_nr = $this->getPassNr();
                         $overall_stat = "notgraded";
 //echo "*".$cnt_passed."*".$cnt_notgraded."*".$min_nr."*";
                         if ($failed_a_mandatory || ($cnt_passed + $cnt_notgraded < $min_nr))
                         {
 //echo "9";
                                 $overall_stat = "failed";
                         }
                         else if ($passed_all_mandatory && $cnt_passed >= $min_nr)
                         {
 //echo "A";
                                 $overall_stat = "passed";
                         }
                 }
                 
                 $ret =  array(
                         "overall_status" => $overall_stat,
                         "failed_a_mandatory" => $failed_a_mandatory);
 //echo "<br>p:".$cnt_passed.":ng:".$cnt_notgraded;
 //var_dump($ret);
                 return $ret;
         }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ exportGradesExcel()

ilObjExercise::exportGradesExcel ( )

Exports grades as excel.

Definition at line 836 of file class.ilObjExercise.php.

References $d, $data, ilExcelUtils\_convert_text(), ilLPMarks\_lookupMark(), ilObjUser\_lookupName(), ilExerciseMembers\_lookupStatus(), ilUtil\deliverFile(), ilUtil\getASCIIFilename(), ilExAssignment\getAssignmentDataOfExercise(), ilObject\getId(), ilObject\getTitle(), ilUtil\ilTempnam(), ilExAssignment\lookupMarkOfUser(), ilExAssignment\lookupStatusOfUser(), and ilUtil\sortArray().

         {
                 include_once("./Modules/Exercise/classes/class.ilExAssignment.php");
                 $ass_data = ilExAssignment::getAssignmentDataOfExercise($this->getId());
                 
                 include_once "./Services/Excel/classes/class.ilExcelWriterAdapter.php";
                 $excelfile = ilUtil::ilTempnam();
                 $adapter = new ilExcelWriterAdapter($excelfile, FALSE);
                 $workbook = $adapter->getWorkbook();
                 $workbook->setVersion(8); // Use Excel97/2000 Format
                 include_once ("./Services/Excel/classes/class.ilExcelUtils.php");
                 
                 //
                 // status
                 //
                 $mainworksheet = $workbook->addWorksheet();
                 
                 // header row
                 $mainworksheet->writeString(0, 0, ilExcelUtils::_convert_text($this->lng->txt("name")));
                 $cnt = 1;
                 foreach ($ass_data as $ass)
                 {
                         $mainworksheet->writeString(0, $cnt, $cnt);
                         $cnt++;
                 }
                 $mainworksheet->writeString(0, $cnt, ilExcelUtils::_convert_text($this->lng->txt("exc_total_exc")));
                 
                 // data rows
                 $this->mem_obj = new ilExerciseMembers($this);
                 $getmems = $this->mem_obj->getMembers();
                 $mems = array();
                 foreach ($getmems as $user_id)
                 {
                         $mems[$user_id] = ilObjUser::_lookupName($user_id);
                 }
                 $mems = ilUtil::sortArray($mems, "lastname", "asc", false, true);
 
                 $data = array();
                 $row_cnt = 1;
                 foreach ($mems as $user_id => $d)
                 {
                         $col_cnt = 1;
 
                         // name
                         $mainworksheet->writeString($row_cnt, 0,
                                 ilExcelUtils::_convert_text($d["lastname"].", ".$d["firstname"]." [".$d["login"]."]"));
 
                         reset($ass_data);
 
                         foreach ($ass_data as $ass)
                         {
                                 $status = ilExAssignment::lookupStatusOfUser($ass["id"], $user_id);
                                 $mainworksheet->writeString($row_cnt, $col_cnt, ilExcelUtils::_convert_text($this->lng->txt("exc_".$status)));
                                 $col_cnt++;
                         }
                         
                         // total status
                         $status = ilExerciseMembers::_lookupStatus($this->getId(), $user_id);
                         $mainworksheet->writeString($row_cnt, $col_cnt, ilExcelUtils::_convert_text($this->lng->txt("exc_".$status)));
 
                         $row_cnt++;
                 }
                 
                 //
                 // mark
                 //
                 $worksheet2 = $workbook->addWorksheet();
                 
                 // header row
                 $worksheet2->writeString(0, 0, ilExcelUtils::_convert_text($this->lng->txt("name")));
                 $cnt = 1;
                 foreach ($ass_data as $ass)
                 {
                         $worksheet2->writeString(0, $cnt, $cnt);
                         $cnt++;
                 }
                 $worksheet2->writeString(0, $cnt, ilExcelUtils::_convert_text($this->lng->txt("exc_total_exc")));
                 
                 // data rows
                 $data = array();
                 $row_cnt = 1;
                 reset($mems);
                 foreach ($mems as $user_id => $d)
                 {
                         $col_cnt = 1;
                         $d = ilObjUser::_lookupName($user_id);
 
                         // name
                         $worksheet2->writeString($row_cnt, 0,
                                 ilExcelUtils::_convert_text($d["lastname"].", ".$d["firstname"]." [".$d["login"]."]"));
 
                         reset($ass_data);
 
                         foreach ($ass_data as $ass)
                         {
                                 $worksheet2->writeString($row_cnt, $col_cnt,
                                         ilExcelUtils::_convert_text(ilExAssignment::lookupMarkOfUser($ass["id"], $user_id)));
                                 $col_cnt++;
                         }
                         
                         // total mark
                         include_once 'Services/Tracking/classes/class.ilLPMarks.php';
                         $worksheet2->writeString($row_cnt, $col_cnt,
                                 ilExcelUtils::_convert_text(ilLPMarks::_lookupMark($user_id, $this->getId())));
 
                         $row_cnt++;
                 }
 
                 
                 $workbook->close();
                 $exc_name = ilUtil::getASCIIFilename(preg_replace("/\s/", "_", $this->getTitle()));
                 ilUtil::deliverFile($excelfile, $exc_name.".xls", "application/vnd.ms-excel");
         }

Here is the call graph for this function:

◆ findUserFiles()

static ilObjExercise::findUserFiles	(	$a_user_id,
		$a_filetitle
	)

static

Check if given file was assigned.

Parameters

int	$a_user_id
string	$a_filetitle

Definition at line 1205 of file class.ilObjExercise.php.

References $res, and $row.

Referenced by ilObjBlogGUI\render(), and ilObjPortfolioBaseGUI\view().

         {
                 global $ilDB;
                 
                 $set = $ilDB->query("SELECT obj_id, ass_id".
                         " FROM exc_returned".
                         " WHERE user_id = ".$ilDB->quote($a_user_id, "integer").
                         " AND filetitle = ".$ilDB->quote($a_filetitle, "text"));
                 $res = array();
                 while($row = $ilDB->fetchAssoc($set))
                 {
                         $res[$row["ass_id"]] = $row;
                 }
                 return $res;
         }

Here is the caller graph for this function:

◆ getCertificateVisibility()

ilObjExercise::getCertificateVisibility ( )

Returns the visibility settings of the certificate.

Returns: integer The value for the visibility settings (0 = always, 1 = only passed, 2 = never) public

Definition at line 1227 of file class.ilObjExercise.php.

Referenced by hasUserCertificate(), and saveData().

         {
                 return (strlen($this->certificate_visibility)) ? $this->certificate_visibility : 0;
         }

Here is the caller graph for this function:

◆ getInstruction()

ilObjExercise::getInstruction ( )

Definition at line 81 of file class.ilObjExercise.php.

References $instruction.

Referenced by cloneObject(), saveData(), and update().

         {
                 return $this->instruction;
         }

Here is the caller graph for this function:

◆ getPassMode()

ilObjExercise::getPassMode ( )

Get pass mode (all | nr)

Returns: string pass mode

Definition at line 101 of file class.ilObjExercise.php.

Referenced by cloneObject(), determinStatusOfUser(), saveData(), and update().

         {
                 return $this->pass_mode;
         }

Here is the caller graph for this function:

◆ getPassNr()

ilObjExercise::getPassNr ( )

Get number of assignments that must be passed to pass the exercise.

Returns: integer pass nr

Definition at line 121 of file class.ilObjExercise.php.

Referenced by cloneObject(), determinStatusOfUser(), saveData(), and update().

         {
                 return $this->pass_nr;
         }

Here is the caller graph for this function:

◆ getShowSubmissions()

ilObjExercise::getShowSubmissions ( )

Get whether submissions of learners should be shown to other learners after deadline.

Returns: integer show submissions

Definition at line 141 of file class.ilObjExercise.php.

Referenced by cloneObject(), saveData(), and update().

         {
                 return $this->show_submissions;
         }

Here is the caller graph for this function:

◆ getTimestamp()

ilObjExercise::getTimestamp ( )

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

References $timestamp.

Referenced by cloneObject(), saveData(), and update().

         {
                 return $this->timestamp;
         }

Here is the caller graph for this function:

◆ handleSubmission()

ilObjExercise::handleSubmission ( $ass_id )

This method is called after an user submitted one or more files.

It should handle the setting "Completion by Submission" and, if enabled, set the status of the current user to either 'passed' or 'notgraded'.

Parameters

integer public

Definition at line 1013 of file class.ilObjExercise.php.

References $ilUser, $res, ilExAssignment\getTeamMembersByAssignmentId(), isCompletionBySubmissionEnabled(), and ilExAssignment\updateStatusOfUser().

         {
                 global $ilUser, $ilDB;
 
                 if($this->isCompletionBySubmissionEnabled())
                 {
                         include_once 'Modules/Exercise/classes/class.ilExAssignment.php';       
                         
                         // #17673 - team upload?
                         $user_ids = ilExAssignment::getTeamMembersByAssignmentId($ass_id, $ilUser->getId());
                         if(!$user_ids)
                         {
                                 $user_ids = array($ilUser->getId());
                         }
                         
                         $res = $ilDB->query(
                                 'SELECT returned_id'.
                                 ' FROM exc_returned'.
                                 ' WHERE obj_id = '.$ilDB->quote($this->getId(), 'integer').
                                 ' AND ass_id = '.$ilDB->quote($ass_id, 'integer').
                                 ' AND '.$ilDB->in('user_id', $user_ids, '', 'integer')
                         );
         
                         if($ilDB->numRows($res))
                         {
                                 $status = 'passed';                             
                         }
                         else
                         {
                                 $status = 'notgraded';
                         }                               
                         foreach($user_ids as $user_id)
                         {
                                 ilExAssignment::updateStatusOfUser($ass_id, $user_id, $status);
                         }
                 }       
         }

Here is the call graph for this function:

◆ hasUserCertificate()

ilObjExercise::hasUserCertificate ( $a_user_id )

Check if given user has certificate to show/download.

Parameters

int $a_user_id

Returns: bool

Definition at line 1265 of file class.ilObjExercise.php.

References ilExerciseMembers\_lookupStatus(), getCertificateVisibility(), ilObject\getId(), ilCertificate\isActive(), and ilCertificate\isObjectActive().

         {
                 // show certificate?
                 include_once "Services/Certificate/classes/class.ilCertificate.php";
                 if(ilCertificate::isActive() && ilCertificate::isObjectActive($this->getId()))
                 {
                         $certificate_visible = $this->getCertificateVisibility();
                         // if not never
                         if($certificate_visible != 2)
                         {
                                 // if passed only
                                 include_once 'Modules/Exercise/classes/class.ilExerciseMembers.php';
                                 $status = ilExerciseMembers::_lookupStatus($this->getId(), $a_user_id);
                                 if($certificate_visible == 1 && $status == "passed")
                                 {
                                         return true;
                                 }
                                 // always (excluding notgraded)
                                 else if($certificate_visible == 0 && $status != "notgraded")
                                 {
                                         return true;
                                 }
                         }
                 }
                 return false;
         }

Here is the call graph for this function:

◆ ilObjExercise()

ilObjExercise::ilObjExercise	(	$a_id = `0`,
		$a_call_by_reference = `true`
	)

Constructor public.

Parameters

integer	reference_id or object_id
boolean	treat the id as reference_id (true) or object_id (false)

Definition at line 51 of file class.ilObjExercise.php.

References ilObject\ilObject(), and setPassMode().

         {
                 $this->setPassMode("all");
                 $this->type = "exc";
                 $this->ilObject($a_id,$a_call_by_reference);
         }

Here is the call graph for this function:

◆ isCompletionBySubmissionEnabled()

ilObjExercise::isCompletionBySubmissionEnabled ( )

Checks whether completion by submission is enabled or not.

Returns: boolean public

Definition at line 982 of file class.ilObjExercise.php.

References $completion_by_submission.

Referenced by cloneObject(), handleSubmission(), saveData(), and update().

         {
                 return $this->completion_by_submission;
         }

Here is the caller graph for this function:

◆ lookupExerciseIdForReturnedId()

static ilObjExercise::lookupExerciseIdForReturnedId ( $a_returned_id )

static

Definition at line 1177 of file class.ilObjExercise.php.

References $row.

Referenced by ilObjMediaObject\getParentObjectIdForUsage().

         {
                 global $ilDB;
                 
                 $set = $ilDB->query("SELECT obj_id".
                         " FROM exc_returned".
                         " WHERE returned_id = ".$ilDB->quote($a_returned_id, "integer"));
                 $row = $ilDB->fetchAssoc($set);
                 return (int)$row["obj_id"];             
         }

Here is the caller graph for this function:

◆ notify()

ilObjExercise::notify	(	$a_event,
		$a_ref_id,
		$a_node_id,
		$a_params = `0`
	)

notifys an object about an event occured Based on the event happend, each object may decide how it reacts.

public

Parameters

string	event
integer	reference id of object where the event occured
array	passes optional paramters if required

Returns: boolean

Definition at line 382 of file class.ilObjExercise.php.

         {
                 // object specific event handling
 
                 parent::notify($a_event,$a_ref_id,$a_node_id,$a_params);
         }

◆ processUploadedFile()

ilObjExercise::processUploadedFile	(	$fileTmp,
		$storageMethod,
		$persistentErrorMessage,
		$a_ass_id
	)

processes errorhandling etc for uploaded archive

Parameters

string	$tmpFile	path and filename to uploaded file
string	$storageMethod	deliverFile or storeUploadedFile
boolean	$persistentErrorMessage	Defines whether sendInfo will be persistent or not

Definition at line 622 of file class.ilObjExercise.php.

References $filename, $ilUser, ilObject\$lng, ilExerciseMembers\_writeReturned(), ilUtil\delDir(), ilObject\getId(), ilUtil\ilTempnam(), ilUtil\makeDir(), ilFileUtils\processZipFile(), ilFileUtils\recursive_dirscan(), ilUtil\sendFailure(), ilUtil\sendSuccess(), and ilFileUtils\utf8_encode().

Referenced by addUploadedFile().

         {
                 global $lng, $ilUser;
 
                 // Create unzip-directory
                 $newDir = ilUtil::ilTempnam();
                 ilUtil::makeDir($newDir);
 
                 include_once ("Services/Utilities/classes/class.ilFileUtils.php");
                 
                 try 
                 {
                         $processDone = ilFileUtils::processZipFile($newDir,$fileTmp, false);
                         ilFileUtils::recursive_dirscan($newDir, $filearray);                    
 
                         foreach ($filearray["file"] as $key => $filename)
                         {
                                 $a_http_post_files["name"] = ilFileUtils::utf8_encode($filename);
                                 $a_http_post_files["type"] = "other";
                                 $a_http_post_files["tmp_name"] = $filearray["path"][$key]."/".$filename;
                                 $a_http_post_files["error"] = 0;
                                 $a_http_post_files["size"] = filesize($filearray["path"][$key]."/".$filename);
 
                                 if ($storageMethod == "deliverFile")
                                 {
                                         $this->$storageMethod($a_http_post_files, $a_ass_id, $ilUser->id, true);
                                 }
                                 else if ($storageMethod == "storeUploadedFile")
                                 {
                                         $this->file_obj->$storageMethod($a_http_post_files, true, true);                                
                                 }
                         }
                         ilExerciseMembers::_writeReturned($this->getId(), $ilUser->id, 1);
                         ilUtil::sendSuccess($this->lng->txt("file_added"),$persistentErrorMessage);                                     
                 } 
                 catch (ilFileUtilsException $e) 
                 {
                         ilUtil::sendFailure($e->getMessage(), $persistentErrorMessage);
                 }
                 
 
                 ilUtil::delDir($newDir);
                 return $processDone;
 
         }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ read()

ilObjExercise::read ( )

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

References $query, $res, $row, ilObject\getId(), setCertificateVisibility(), setCompletionBySubmission(), setInstruction(), setPassNr(), setShowSubmissions(), and setTimestamp().

         {
                 global $ilDB;
 
                 parent::read();
 
                 $query = "SELECT * FROM exc_data ".
                         "WHERE obj_id = ".$ilDB->quote($this->getId(), "integer");
 
                 $res = $ilDB->query($query);
                 while($row = $ilDB->fetchObject($res))
                 {
                         $this->setInstruction($row->instruction);
                         $this->setTimestamp($row->time_stamp);
                         $pm = ($row->pass_mode == "")
                                 ? "all"
                                 : $row->pass_mode;
                         $this->setPassMode($pm);
                         $this->setShowSubmissions($row->show_submissions);
                         if ($row->pass_mode == "nr")
                         {
                                 $this->setPassNr($row->pass_nr);
                         }
                         $this->setCompletionBySubmission($row->compl_by_submission == 1 ? true : false);
                         $this->setCertificateVisibility($row->certificate_visibility);
                 }
                 
                 $this->members_obj = new ilExerciseMembers($this);
 
                 // GET FILE ASSIGNED TO EXERCISE
 //              $this->file_obj = new ilFileDataExercise($this->getId());
 //              $this->files = $this->file_obj->getFiles();
 
                 return true;
         }

Here is the call graph for this function:

◆ saveCertificateVisibility()

ilObjExercise::saveCertificateVisibility ( $a_value )

Saves the visibility settings of the certificate.

Parameters

integer $a_value The value for the visibility settings (0 = always, 1 = only passed, 2 = never) private

Definition at line 1249 of file class.ilObjExercise.php.

References ilObject\getId().

         {
                 global $ilDB;
 
                 $affectedRows = $ilDB->manipulateF("UPDATE exc_data SET certificate_visibility = %s WHERE obj_id = %s",
                         array('integer', 'integer'),
                         array($a_value, $this->getId())
                 );
         }

Here is the call graph for this function:

◆ saveData()

ilObjExercise::saveData ( )

Definition at line 240 of file class.ilObjExercise.php.

References getCertificateVisibility(), ilObject\getId(), getInstruction(), getPassMode(), getPassNr(), getShowSubmissions(), getTimestamp(), and isCompletionBySubmissionEnabled().

         {
                 global $ilDB;
                 
                 // SAVE ONLY EXERCISE SPECIFIC DATA
                 /*$query = "INSERT INTO exc_data SET ".
                         "obj_id = ".$ilDB->quote($this->getId()).", ".
                         "instruction = ".$ilDB->quote($this->getInstruction()).", ".
                         "time_stamp = ".$ilDB->quote($this->getTimestamp());
                 $this->ilias->db->query($query);*/
 
                 $ilDB->insert("exc_data", array(
                         "obj_id" => array("integer", $this->getId()),
                         "instruction" => array("clob", $this->getInstruction()),
                         "time_stamp" => array("integer", $this->getTimestamp()),
                         "pass_mode" => array("text", $this->getPassMode()),
                         "pass_nr" => array("text", $this->getPassNr()),
                         "show_submissions" => array("integer", (int) $this->getShowSubmissions()),
                         'compl_by_submission' => array('integer', (int)$this->isCompletionBySubmissionEnabled()),
                         "certificate_visibility" => array("integer", (int)$this->getCertificateVisibility())
                         ));
                 return true;
         }

Here is the call graph for this function:

◆ sendAssignment()

ilObjExercise::sendAssignment	(	$a_exc_id,
		$a_ass_id,
		$a_members
	)

send exercise per mail to members

Definition at line 468 of file class.ilObjExercise.php.

References $_SESSION, $file, __formatBody(), __formatRecipients(), __formatSubject(), ilExAssignment\lookupTitle(), and ilExAssignment\updateStatusSentForUser().

         {
                 include_once("./Modules/Exercise/classes/class.ilExAssignment.php");
                 $ass_title = ilExAssignment::lookupTitle($a_ass_id);
 
                 include_once("./Modules/Exercise/classes/class.ilFSStorageExercise.php");
                 $storage = new ilFSStorageExercise($a_exc_id, $a_ass_id);
                 $files = $storage->getFiles();
 
                 if(count($files))
                 {
                         include_once "./Services/Mail/classes/class.ilFileDataMail.php";
 
                         $mfile_obj = new ilFileDataMail($_SESSION["AccountId"]);
                         foreach($files as $file)
                         {
                                 $mfile_obj->copyAttachmentFile($file["fullpath"], $file["name"]);
                                 $file_names[] = $file["name"];
                         }
                 }
                 
                 include_once "Services/Mail/classes/class.ilMail.php";
 
                 $tmp_mail_obj = new ilMail($_SESSION["AccountId"]);
                 $message = $tmp_mail_obj->sendMail(
                         $this->__formatRecipients($a_members),"","",
                         $this->__formatSubject($ass_title), $this->__formatBody($a_ass_id),
                         count($file_names) ? $file_names : array(),array("normal"));
 
                 unset($tmp_mail_obj);
 
                 if(count($file_names))
                 {
                         $mfile_obj->unlinkFiles($file_names);
                         unset($mfile_obj);
                 }
 
 
                 // SET STATUS SENT FOR ALL RECIPIENTS
                 foreach($a_members as $member_id => $value)
                 {
                         ilExAssignment::updateStatusSentForUser($a_ass_id, $member_id, 1);
                 }
 
                 return true;
         }

Here is the call graph for this function:

◆ sendFeedbackFileNotification()

ilObjExercise::sendFeedbackFileNotification	(	$a_feedback_file,
		$a_user_id,
		$a_ass_id
	)

Send feedback file notification to user.

Definition at line 953 of file class.ilObjExercise.php.

References ilObject\getId(), ilObject\getRefId(), and ilExerciseMailNotification\TYPE_FEEDBACK_FILE_ADDED.

         {
                 $user_ids = $a_user_id;
                 if(!is_array($user_ids))
                 {
                         $user_ids = array($user_ids);
                 }
                 
                 include_once("./Modules/Exercise/classes/class.ilExerciseMailNotification.php");
                 $not = new ilExerciseMailNotification();
                 $not->setType(ilExerciseMailNotification::TYPE_FEEDBACK_FILE_ADDED);
                 $not->setAssignmentId($a_ass_id);
                 $not->setObjId($this->getId());
                 if ($this->getRefId() > 0)
                 {
                         $not->setRefId($this->getRefId());
                 }
                 $not->setRecipients($user_ids);
                 $not->send();
         }

Here is the call graph for this function:

◆ setCertificateVisibility()

ilObjExercise::setCertificateVisibility ( $a_value )

Sets the visibility settings of the certificate.

Parameters

integer $a_value The value for the visibility settings (0 = always, 1 = only passed, 2 = never) public

Definition at line 1238 of file class.ilObjExercise.php.

Referenced by read().

         {
                 $this->certificate_visibility = $a_value;
         }

Here is the caller graph for this function:

◆ setCompletionBySubmission()

ilObjExercise::setCompletionBySubmission ( $bool )

Enabled/Disable completion by submission.

Parameters

boolean

Returns: ilObjExercise public

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

Referenced by read().

         {
                 $this->completion_by_submission = (bool)$bool;
                 
                 return $this;
         }

Here is the caller graph for this function:

◆ setDate()

ilObjExercise::setDate	(	$a_hour,
		$a_minutes,
		$a_day,
		$a_month,
		$a_year
	)

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

         {
                 $this->hour = (int) $a_hour;
                 $this->minutes = (int) $a_minutes;
                 $this->day = (int) $a_day;
                 $this->month = (int) $a_month;
                 $this->year = (int) $a_year;
                 $this->timestamp = mktime($this->hour,$this->minutes,0,$this->month,$this->day,$this->year);
                 return true;
         }

◆ setInstruction()

ilObjExercise::setInstruction ( $a_instruction )

Definition at line 77 of file class.ilObjExercise.php.

Referenced by read().

         {
                 $this->instruction = $a_instruction;
         }

Here is the caller graph for this function:

◆ setPassMode()

ilObjExercise::setPassMode ( $a_val )

Set pass mode (all | nr)

Parameters

string pass mode

Definition at line 91 of file class.ilObjExercise.php.

Referenced by ilObjExercise().

         {
                 $this->pass_mode = $a_val;
         }

Here is the caller graph for this function:

◆ setPassNr()

ilObjExercise::setPassNr ( $a_val )

Set number of assignments that must be passed to pass the exercise.

Parameters

integer pass nr

Definition at line 111 of file class.ilObjExercise.php.

Referenced by read().

         {
                 $this->pass_nr = $a_val;
         }

Here is the caller graph for this function:

◆ setShowSubmissions()

ilObjExercise::setShowSubmissions ( $a_val )

Set whether submissions of learners should be shown to other learners after deadline.

Parameters

boolean show submissions

Definition at line 131 of file class.ilObjExercise.php.

Referenced by read().

         {
                 $this->show_submissions = $a_val;
         }

Here is the caller graph for this function:

◆ setTimestamp()

ilObjExercise::setTimestamp ( $a_timestamp )

Definition at line 73 of file class.ilObjExercise.php.

Referenced by read().

         {
                 $this->timestamp = $a_timestamp;
         }

Here is the caller graph for this function:

◆ update()

ilObjExercise::update ( )

Definition at line 425 of file class.ilObjExercise.php.

References ilObject\getId(), getInstruction(), getPassMode(), getPassNr(), getShowSubmissions(), getTimestamp(), isCompletionBySubmissionEnabled(), and updateAllUsersStatus().

         {
                 global $ilDB;
 
                 parent::update();
 
                 /*$query = "UPDATE exc_data SET ".
                         "instruction = ".$ilDB->quote($this->getInstruction()).", ".
                         "time_stamp = ".$ilDB->quote($this->getTimestamp())." ".
                         "WHERE obj_id = ".$ilDB->quote($this->getId());
                 */
                 
                 if ($this->getPassMode() == "all")
                 {
                         $pass_nr = null;
                 }
                 else
                 {
                         $pass_nr = $this->getPassNr();
                 }
 
                 $ilDB->update("exc_data", array(
                         "instruction" => array("clob", $this->getInstruction()),
                         "time_stamp" => array("integer", $this->getTimestamp()),
                         "pass_mode" => array("text", $this->getPassMode()),
                         "pass_nr" => array("integer", $this->getPassNr()),
                         "show_submissions" => array("integer", (int) $this->getShowSubmissions()),
                         'compl_by_submission' => array('integer', (int)$this->isCompletionBySubmissionEnabled())
                         ), array(
                         "obj_id" => array("integer", $this->getId())
                         ));
 
                 $this->updateAllUsersStatus();
                 
                 //$res = $this->ilias->db->query($query);
 
                 #$this->members_obj->update();
                 return true;
         }

Here is the call graph for this function:

◆ updateAllUsersStatus()

ilObjExercise::updateAllUsersStatus ( )

Update status of all users.

Definition at line 819 of file class.ilObjExercise.php.

References updateUserStatus().

Referenced by update().

         {
                 if (!is_object($this->members_obj));
                 {
                         $this->members_obj = new ilExerciseMembers($this);
                 }
                 
                 $mems = $this->members_obj->getMembers();
                 foreach ($mems as $mem)
                 {
                         $this->updateUserStatus($mem);
                 }
         }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ updateTextSubmission()

ilObjExercise::updateTextSubmission	(	$a_exc_id,
		$a_ass_id,
		$a_user_id,
		$a_text
	)

Handle text assignment submissions.

Parameters

int	$a_exc_id
int	$a_ass_id
int	$a_user_id
string	$a_text

Returns: int

Definition at line 1137 of file class.ilObjExercise.php.

References ilObject\$id, addResourceObject(), deleteDeliveredFiles(), ilExAssignment\getDeliveredFiles(), and ilUtil\now().

         {
                 global $ilDB;
                 
                 $files = ilExAssignment::getDeliveredFiles($a_exc_id, $a_ass_id, $a_user_id);
                 
                 // no text = remove submission
                 if(!trim($a_text))
                 {
                         if($files)
                         {
                                 $files = array_shift($files);
                                 $id = $files["returned_id"];
                                 if($id)
                                 {
                                         $this->deleteDeliveredFiles($a_exc_id, $a_ass_id, array($id), $a_user_id);
                                         return;
                                 }
                         }
                 }
                                 
                 if(!$files)
                 {                       
                         return $this->addResourceObject("TEXT", $a_ass_id, $a_user_id, $a_text);
                 }
                 else
                 {
                         $files = array_shift($files);
                         $id = $files["returned_id"];
                         if($id)
                         {
                                 $ilDB->manipulate("UPDATE exc_returned".
                                         " SET atext = ".$ilDB->quote($a_text, "text").
                                         ", ts = ".$ilDB->quote(ilUtil::now(), "timestamp").
                                         " WHERE returned_id = ".$ilDB->quote($id, "integer"));
                                 return $id;
                         }
                 }
         }

Here is the call graph for this function:

◆ updateUserStatus()

ilObjExercise::updateUserStatus ( $a_user_id = 0 )

Update exercise status of user.

Definition at line 800 of file class.ilObjExercise.php.

References $ilUser, ilExerciseMembers\_writeStatus(), determinStatusOfUser(), and ilObject\getId().

Referenced by updateAllUsersStatus(), and ilExAssignment\updateStatusOfUser().

         {
                 global $ilUser;
                 
                 if ($a_user_id == 0)
                 {
                         $a_user_id = $ilUser->getId();
                 }
 
                 $st = $this->determinStatusOfUser($a_user_id);
 
                 include_once("./Modules/Exercise/classes/class.ilExerciseMembers.php");
                 ilExerciseMembers::_writeStatus($this->getId(), $a_user_id, 
                         $st["overall_status"]);
         }

Here is the call graph for this function:

Here is the caller graph for this function:

Field Documentation

◆ $certificate_visibility

ilObjExercise::$certificate_visibility

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

◆ $completion_by_submission

ilObjExercise::$completion_by_submission = false

protected

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

Referenced by isCompletionBySubmissionEnabled().

◆ $day

ilObjExercise::$day

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

◆ $file_obj

ilObjExercise::$file_obj

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

◆ $files

ilObjExercise::$files

Definition at line 24 of file class.ilObjExercise.php.

◆ $hour

ilObjExercise::$hour

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

◆ $instruction

ilObjExercise::$instruction

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

Referenced by getInstruction().

◆ $members_obj

ilObjExercise::$members_obj

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

◆ $minutes

ilObjExercise::$minutes

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

◆ $month

ilObjExercise::$month

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

◆ $timestamp

ilObjExercise::$timestamp

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

Referenced by getTimestamp().

◆ $year

ilObjExercise::$year

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

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

Modules/Exercise/classes/class.ilObjExercise.php

Public Member Functions

Static Public Member Functions

Data Fields

Protected Attributes

Detailed Description

Member Function Documentation

◆ __formatBody()

◆ __formatRecipients()

◆ __formatSubject()

◆ _checkCondition()

◆ _fixFilename()

◆ _fixFilenameArray()

◆ _lookupFinishedUserExercises()

◆ _lookupStatusTime()

◆ addResourceObject()

◆ addUploadedFile()

◆ checkDate()

◆ cloneObject()

◆ delete()

◆ deleteAllDeliveredFilesOfUser()

◆ deleteDeliveredFiles()

◆ deleteFiles()

◆ deleteResourceObject()

◆ deliverFile()

◆ deliverReturnedFiles()

◆ determinStatusOfUser()

◆ exportGradesExcel()

◆ findUserFiles()

◆ getCertificateVisibility()

◆ getInstruction()

◆ getPassMode()

◆ getPassNr()

◆ getShowSubmissions()

◆ getTimestamp()

◆ handleSubmission()

◆ hasUserCertificate()

◆ ilObjExercise()

◆ isCompletionBySubmissionEnabled()

◆ lookupExerciseIdForReturnedId()

◆ notify()

◆ processUploadedFile()

◆ read()

◆ saveCertificateVisibility()

◆ saveData()

◆ sendAssignment()

◆ sendFeedbackFileNotification()

◆ setCertificateVisibility()

◆ setCompletionBySubmission()

◆ setDate()

◆ setInstruction()

◆ setPassMode()

◆ setPassNr()

◆ setShowSubmissions()

◆ setTimestamp()

◆ update()

◆ updateAllUsersStatus()

◆ updateTextSubmission()

◆ updateUserStatus()

Field Documentation

◆ $certificate_visibility

◆ $completion_by_submission

◆ $day

◆ $file_obj

◆ $files

◆ $hour

◆ $instruction

◆ $members_obj

◆ $minutes

◆ $month

◆ $timestamp

◆ $year