Collaboration diagram for ilLOUserResults:

Public Member Functions
	__construct ($a_course_obj_id, $a_user_id)
	Constructor. More...

	delete ()
	Delete for user and course type $ilDB. More...

	saveObjectiveResult ($a_objective_id, $a_type, $a_status, $a_result_percentage, $a_limit_percentage, $a_tries, $a_is_final)
	Save objective result. More...

	getCompletedObjectiveIdsByType ($a_type)
	All completed objectives by type. More...

	getSuggestedObjectiveIds ()
	Get all objectives where the user failed the initial test. More...

	getCompletedObjectiveIds ()
	Get all objectives where the user completed the qualified test. More...

	getFailedObjectiveIds ($a_is_final=true)
	Get all objectives where the user failed the qualified test. More...

	getCourseResultsForUserPresentation ()
	Get all results for course and user. More...

Static Public Member Functions
static	lookupResult ($a_course_obj_id, $a_user_id, $a_objective_id, $a_tst_type)
	Lookup user result. More...

static	resetFinalByObjective ($a_objective_id)

static	deleteResultsForUser ($a_user_id)
	Delete all result entries for user. More...

static	deleteResultsForCourse ($a_course_id)
	Delete all result entries for course. More...

static	deleteResultsFromLP ($a_course_id, array $a_user_ids, $a_remove_initial, $a_remove_qualified, array $a_objective_ids)
	Delete all (qualified) result entries for course members. More...

static	getObjectiveStatusForLP ($a_user_id, $a_obj_id, array $a_objective_ids)

static	getSummarizedObjectiveStatusForLP ($a_obj_id, array $a_objective_ids, $a_user_id=null)

static	hasResults ($a_container_id, $a_user_id)

static	getCompletionsOfUser ($a_user_id, $a_from_ts, $a_to_ts)
	Get completed learning objectives for user and time frame. More...

Data Fields
const	TYPE_INITIAL = 1

const	TYPE_QUALIFIED = 2

const	STATUS_COMPLETED = 1

const	STATUS_FAILED = 2

Protected Member Functions
	findObjectiveIds ($a_type=null, $a_status=null, $a_is_final=null)
	Find objective ids by type and/or status. More...

Static Protected Member Functions
static	isValidType ($a_type)
	Is given type valid? More...

static	isValidStatus ($a_status)
	Is given status valid? More...

Protected Attributes
	$course_obj_id

	$user_id

Detailed Description

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

Constructor & Destructor Documentation

◆ __construct()

ilLOUserResults::__construct	(	$a_course_obj_id,
		$a_user_id
	)

Constructor.

Parameters

int	$a_course_obj_id
int	$a_user_id

Returns: ilLOUserResults

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

     {
         $this->course_obj_id = (int) $a_course_obj_id;
         $this->user_id = (int) $a_user_id;
     }

Member Function Documentation

◆ delete()

ilLOUserResults::delete ( )

Delete for user and course type $ilDB.

Definition at line 148 of file class.ilLOUserResults.php.

References $DIC, $ilDB, and $query.

Referenced by ilObjCourseGUI\resetObject().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         $query = 'DELETE FROM loc_user_results ' .
                 'WHERE course_id = ' . $ilDB->quote($this->course_obj_id) . ' ' .
                 'AND user_id = ' . $ilDB->quote($this->user_id);
         $ilDB->manipulate($query);
     }

Here is the caller graph for this function:

◆ deleteResultsForCourse()

static ilLOUserResults::deleteResultsForCourse ( $a_course_id )

static

Delete all result entries for course.

Parameters

int $a_course_id

Returns: bool

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

References $DIC, and $ilDB.

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         if (!(int) $a_course_id) {
             return false;
         }
         
         $ilDB->manipulate("DELETE FROM loc_user_results" .
             " WHERE course_id = " . $ilDB->quote($a_course_id, "integer"));
         return true;
     }

◆ deleteResultsForUser()

static ilLOUserResults::deleteResultsForUser ( $a_user_id )

static

Delete all result entries for user.

Parameters

int $a_user_id

Returns: bool

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

References $DIC, and $ilDB.

Referenced by ilObjCourse\_deleteUser().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         if (!(int) $a_user_id) {
             return false;
         }
         
         $ilDB->manipulate("DELETE FROM loc_user_results" .
             " WHERE user_id = " . $ilDB->quote($a_user_id, "integer"));
         return true;
     }

Here is the caller graph for this function:

◆ deleteResultsFromLP()

static ilLOUserResults::deleteResultsFromLP	(		$a_course_id,
		array	$a_user_ids,
			$a_remove_initial,
			$a_remove_qualified,
		array	$a_objective_ids
	)

static

Delete all (qualified) result entries for course members.

Parameters

int	$a_course_id
array	$a_user_ids
bool	$a_remove_initial
bool	$a_remove_qualified
array	$a_objective_ids

Returns: bool

Definition at line 170 of file class.ilLOUserResults.php.

References $DIC, and $ilDB.

Referenced by ilTestLP\resetCustomLPDataForUserIds().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         if (!(int) $a_course_id ||
             !sizeof($a_user_ids)) {
             return false;
         }
         
         $base_sql = "DELETE FROM loc_user_results" .
             " WHERE course_id = " . $ilDB->quote($a_course_id, "integer") .
             " AND " . $ilDB->in("user_id", $a_user_ids, "", "integer");
         
         if ((bool) $a_remove_initial) {
             $sql = $base_sql .
                 " AND type = " . $ilDB->quote(self::TYPE_INITIAL, "integer");
             $ilDB->manipulate($sql);
         }
         
         if ((bool) $a_remove_qualified) {
             $sql = $base_sql .
                 " AND type = " . $ilDB->quote(self::TYPE_QUALIFIED, "integer");
             $ilDB->manipulate($sql);
         }
         
         if (is_array($a_objective_ids)) {
             $sql = $base_sql .
                 " AND " . $ilDB->in("objective_id", $a_objective_ids, "", "integer");
             $ilDB->manipulate($sql);
         }
                 
         $ilDB->manipulate($sql);
         return true;
     }

Here is the caller graph for this function:

◆ findObjectiveIds()

ilLOUserResults::findObjectiveIds	(	$a_type = `null`,
		$a_status = `null`,
		$a_is_final = `null`
	)

protected

Find objective ids by type and/or status.

Parameters

int	$a_type
int	$a_status
bool	$a_is_final

Returns: array

Definition at line 258 of file class.ilLOUserResults.php.

References $a_type, $DIC, $ilDB, $res, $row, isValidStatus(), and isValidType().

Referenced by getCompletedObjectiveIds(), getCompletedObjectiveIdsByType(), getFailedObjectiveIds(), and getSuggestedObjectiveIds().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         $res = array();
         
         $sql = "SELECT objective_id" .
             " FROM loc_user_results" .
             " WHERE course_id = " . $ilDB->quote($this->course_obj_id, "integer") .
             " AND user_id = " . $ilDB->quote($this->user_id, "integer");
         
         if ($this->isValidType($a_type)) {
             $sql .= " AND type = " . $ilDB->quote($a_type, "integer");
         }
         if ($this->isValidStatus($a_status)) {
             $sql .= " AND status = " . $ilDB->quote($a_status, "integer");
         }
         if ($a_is_final !== null) {
             $sql .= " AND is_final = " . $ilDB->quote($a_is_final, "integer");
         }
         
         $set = $ilDB->query($sql);
         while ($row = $ilDB->fetchAssoc($set)) {
             $res[] = $row["objective_id"];
         }
         
         return $res;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getCompletedObjectiveIds()

ilLOUserResults::getCompletedObjectiveIds ( )

Get all objectives where the user completed the qualified test.

Returns: array objective-ids

Definition at line 314 of file class.ilLOUserResults.php.

References findObjectiveIds(), and ilLOSettings\getInstanceByObjId().

     {
         include_once './Modules/Course/classes/Objectives/class.ilLOSettings.php';
         $settings = ilLOSettings::getInstanceByObjId($this->course_obj_id);
         
         if (!$settings->isInitialTestQualifying() or !$settings->worksWithInitialTest()) {
             return $this->findObjectiveIds(self::TYPE_QUALIFIED, self::STATUS_COMPLETED);
         }
         
         // status of final final test overwrites initial qualified.
         if (
             $settings->isInitialTestQualifying() &&
             $settings->worksWithInitialTest()
         ) {
             $completed = array();
             $completed_candidates = array_unique(
                 array_merge(
                     $this->findObjectiveIds(self::TYPE_INITIAL, self::STATUS_COMPLETED),
                     $this->findObjectiveIds(self::TYPE_QUALIFIED, self::STATUS_COMPLETED)
                 )
             );
             $failed_final = (array) $this->findObjectiveIds(self::TYPE_QUALIFIED, self::STATUS_FAILED);
             
             foreach ($completed_candidates as $objective_completed) {
                 if (!in_array($objective_completed, $failed_final)) {
                     $completed[] = $objective_completed;
                 }
             }
             return $completed;
         }
     }

Here is the call graph for this function:

◆ getCompletedObjectiveIdsByType()

ilLOUserResults::getCompletedObjectiveIdsByType ( $a_type )

All completed objectives by type.

Parameters

type $a_type

Returns: type

Definition at line 294 of file class.ilLOUserResults.php.

References $a_type, and findObjectiveIds().

     {
         return $this->findObjectiveIds($a_type, self::STATUS_COMPLETED);
     }

Here is the call graph for this function:

◆ getCompletionsOfUser()

static ilLOUserResults::getCompletionsOfUser	(	$a_user_id,
		$a_from_ts,
		$a_to_ts
	)

static

Get completed learning objectives for user and time frame.

Parameters

int	$a_user_id
int	$a_from_ts
int	$a_to_ts

Returns: array

Definition at line 561 of file class.ilLOUserResults.php.

References $DIC, $ilDB, $res, and $row.

Referenced by ilCourseLearningHistoryProvider\getEntries().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $res = array();
 
         $sql = "SELECT lor.objective_id, lor.user_id, lor.status, lor.is_final, lor.tstamp, lor.course_id, cobj.title" .
             " FROM loc_user_results lor" .
             " JOIN crs_objectives cobj ON (cobj.objective_id = lor.objective_id)" .
             " WHERE lor.user_id = " . $ilDB->quote($a_user_id, "integer") .
             " AND lor.type = " . $ilDB->quote(self::TYPE_QUALIFIED, "integer") .
             " AND lor.tstamp >= " . $ilDB->quote($a_from_ts, "integer") .
             " AND lor.tstamp <= " . $ilDB->quote($a_to_ts, "integer") .
             " AND lor.status = " . $ilDB->quote(self::STATUS_COMPLETED, "integer");
 
         $set = $ilDB->query($sql);
         while ($row = $ilDB->fetchAssoc($set)) {
             $res[$row["objective_id"]] = $row;
         }
         return $res;
     }

Here is the caller graph for this function:

◆ getCourseResultsForUserPresentation()

ilLOUserResults::getCourseResultsForUserPresentation ( )

Get all results for course and user.

Returns: array

Definition at line 362 of file class.ilLOUserResults.php.

References $DIC, $ilDB, $res, $row, $type, and ilLOSettings\getInstanceByObjId().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         $res = array();
 
         include_once("./Modules/Course/classes/Objectives/class.ilLOSettings.php");
         $settings = ilLOSettings::getInstanceByObjId($this->course_obj_id);
 
         $set = $ilDB->query("SELECT *" .
             " FROM loc_user_results" .
             " WHERE course_id = " . $ilDB->quote($this->course_obj_id, "integer") .
             " AND user_id = " . $ilDB->quote($this->user_id, "integer"));
         while ($row = $ilDB->fetchAssoc($set)) {
             // do not read initial test results, if disabled.
             if (
                 $row['type'] == self::TYPE_INITIAL &&
                 !$settings->worksWithInitialTest()
             ) {
                 continue;
             }
             
             $objective_id = $row["objective_id"];
             $type = $row["type"];
             unset($row["objective_id"]);
             unset($row["type"]);
             $res[$objective_id][$type] = $row;
         }
         
         return $res;
     }

Here is the call graph for this function:

◆ getFailedObjectiveIds()

ilLOUserResults::getFailedObjectiveIds ( $a_is_final = true )

Get all objectives where the user failed the qualified test.

Parameters

bool $a_is_final

Returns: array objective-ids

Definition at line 352 of file class.ilLOUserResults.php.

References findObjectiveIds().

     {
         return $this->findObjectiveIds(self::TYPE_QUALIFIED, self::STATUS_FAILED, $a_is_final);
     }

Here is the call graph for this function:

◆ getObjectiveStatusForLP()

static ilLOUserResults::getObjectiveStatusForLP	(		$a_user_id,
			$a_obj_id,
		array	$a_objective_ids
	)

static

Definition at line 396 of file class.ilLOUserResults.php.

References $DIC, $ilDB, $res, $row, ilLOSettings\getInstanceByObjId(), ilLPStatus\LP_STATUS_COMPLETED_NUM, ilLPStatus\LP_STATUS_FAILED_NUM, and ilLPStatus\LP_STATUS_IN_PROGRESS_NUM.

Referenced by ilTrQuery\getObjectivesStatusForUser().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
                 
         // are initital test(s) qualifying?
         include_once "Modules/Course/classes/Objectives/class.ilLOSettings.php";
         $lo_set = ilLOSettings::getInstanceByObjId($a_obj_id);
         $initial_qualifying = $lo_set->isInitialTestQualifying();
         
         // this method returns LP status codes!
         include_once "Services/Tracking/classes/class.ilLPStatus.php";
         
         $res = array();
         
         $sql = "SELECT lor.objective_id, lor.user_id, lor.status, lor.is_final" .
             " FROM loc_user_results lor" .
             " JOIN crs_objectives cobj ON (cobj.objective_id = lor.objective_id)" .
             " WHERE " . $ilDB->in("lor.objective_id", $a_objective_ids, "", "integer");
         if (!(bool) $initial_qualifying) {
             $sql .= " AND lor.type = " . $ilDB->quote(self::TYPE_QUALIFIED, "integer");
         }
         $sql .= " AND lor.user_id = " . $ilDB->quote($a_user_id, "integer") .
             " AND cobj.active = " . $ilDB->quote(1, "integer") .
             " ORDER BY lor.type"; // qualified must come last!
         $set = $ilDB->query($sql);
         while ($row = $ilDB->fetchAssoc($set)) {
             switch ($row["status"]) {
                 case self::STATUS_FAILED:
                     if ((bool) $row["is_final"]) {
                         $status = ilLPStatus::LP_STATUS_FAILED_NUM;
                     } else {
                         // #15379
                         $status = ilLPStatus::LP_STATUS_IN_PROGRESS_NUM;
                     }
                     break;
                 
                 case self::STATUS_COMPLETED:
                     $status = ilLPStatus::LP_STATUS_COMPLETED_NUM;
                     break;
                 
                 default:
                     /*
                     $status = ilLPStatus::LP_STATUS_NOT_ATTEMPTED_NUM;
                     break;
                     */
                     continue 2;
             }
             
             // if both initial and qualified, qualified will overwrite initial
             $res[$row["objective_id"]] = $status;
         }
         
         return $res;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getSuggestedObjectiveIds()

ilLOUserResults::getSuggestedObjectiveIds ( )

Get all objectives where the user failed the initial test.

Returns: array objective-ids

Definition at line 304 of file class.ilLOUserResults.php.

References findObjectiveIds().

     {
         return $this->findObjectiveIds(self::TYPE_INITIAL, self::STATUS_FAILED);
     }

Here is the call graph for this function:

◆ getSummarizedObjectiveStatusForLP()

static ilLOUserResults::getSummarizedObjectiveStatusForLP	(		$a_obj_id,
		array	$a_objective_ids,
			$a_user_id = `null`
	)

static

Definition at line 453 of file class.ilLOUserResults.php.

References $DIC, $GLOBALS, $ilDB, $res, $row, $user_id, ilLOSettings\getInstanceByObjId(), ilLPStatus\LP_STATUS_COMPLETED_NUM, ilLPStatus\LP_STATUS_FAILED_NUM, and ilLPStatus\LP_STATUS_IN_PROGRESS_NUM.

Referenced by ilLPStatusObjectives\_getStatusInfo(), and ilLPStatusObjectives\determineStatus().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         $GLOBALS['DIC']->logger()->trac()->debug('Get summorized objective status');
         
         // change event is NOT parsed here!
         
         // are initital test(s) qualifying?
         include_once "Modules/Course/classes/Objectives/class.ilLOSettings.php";
         $lo_set = ilLOSettings::getInstanceByObjId($a_obj_id);
         $initial_qualifying = $lo_set->isInitialTestQualifying();
         
         // this method returns LP status codes!
         include_once "Services/Tracking/classes/class.ilLPStatus.php";
                 
         $res = $tmp_completed = array();
         
         $sql = "SELECT lor.objective_id, lor.user_id, lor.status, lor.type, lor.is_final" .
             " FROM loc_user_results lor" .
             " JOIN crs_objectives cobj ON (cobj.objective_id = lor.objective_id)" .
             " WHERE " . $ilDB->in("lor.objective_id", $a_objective_ids, "", "integer") .
             " AND cobj.active = " . $ilDB->quote(1, "integer");
         if (!(bool) $initial_qualifying) {
             $sql .= " AND lor.type = " . $ilDB->quote(self::TYPE_QUALIFIED, "integer");
         }
         if ($a_user_id) {
             $sql .= " AND lor.user_id = " . $ilDB->quote($a_user_id, "integer");
         }
         $sql .= " ORDER BY lor.type DESC"; // qualified must come first!
         $set = $ilDB->query($sql);
         
         $has_final_result = array();
         while ($row = $ilDB->fetchAssoc($set)) {
             if ($row['type'] == self::TYPE_QUALIFIED) {
                 $has_final_result[$row['objective_id']] = $row['user_id'];
             }
             
             $user_id = (int) $row["user_id"];
             $status = (int) $row["status"];
             
             // initial tests only count if no qualified test
             if (
                 $row["type"] == self::TYPE_INITIAL &&
                 in_array($row['user_id'], (array) $has_final_result[$row['objective_id']])
             ) {
                 continue;
             }
             
             // user did do something
             $res[$user_id] = ilLPStatus::LP_STATUS_IN_PROGRESS_NUM;
             
             switch ($status) {
                 case self::STATUS_COMPLETED:
                     $tmp_completed[$user_id]++;
                     break;
                 
                 case self::STATUS_FAILED:
                     if ((bool) $row["is_final"]) {
                         // object is failed when at least 1 objective is failed without any tries left
                         $res[$user_id] = ilLPStatus::LP_STATUS_FAILED_NUM;
                     }
                     break;
             }
         }
         
         $all_nr = sizeof($a_objective_ids);
         foreach ($tmp_completed as $user_id => $counter) {
             // if used as precondition object should be completed ASAP, status can be lost on subsequent tries
             if ($counter == $all_nr) {
                 $res[$user_id] = ilLPStatus::LP_STATUS_COMPLETED_NUM;
             }
         }
         
         if ($a_user_id) {
             // might return null!
             return $res[$a_user_id];
         } else {
             return $res;
         }
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ hasResults()

static ilLOUserResults::hasResults	(	$a_container_id,
		$a_user_id
	)

static

Definition at line 537 of file class.ilLOUserResults.php.

References $DIC, $ilDB, $query, $res, $row, and ilDBConstants\FETCHMODE_OBJECT.

Referenced by ilContainerObjectiveGUI\getMainContent().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         $query = 'SELECT objective_id FROM loc_user_results ' .
                 'WHERE course_id = ' . $ilDB->quote($a_container_id, 'integer') . ' ' .
                 'AND user_id = ' . $ilDB->quote($a_user_id, 'integer');
         
         $res = $ilDB->query($query);
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             return true;
         }
         return false;
     }

Here is the caller graph for this function:

◆ isValidStatus()

static ilLOUserResults::isValidStatus ( $a_status )

staticprotected

Is given status valid?

Parameters

int $a_status

Returns: bool

Definition at line 96 of file class.ilLOUserResults.php.

Referenced by findObjectiveIds().

     {
         return in_array((int) $a_status, array(self::STATUS_COMPLETED, self::STATUS_FAILED));
     }

Here is the caller graph for this function:

◆ isValidType()

static ilLOUserResults::isValidType ( $a_type )

staticprotected

Is given type valid?

Parameters

int $a_type

Returns: bool

Definition at line 85 of file class.ilLOUserResults.php.

References $a_type.

Referenced by findObjectiveIds().

     {
         return in_array((int) $a_type, array(self::TYPE_INITIAL, self::TYPE_QUALIFIED));
     }

Here is the caller graph for this function:

◆ lookupResult()

static ilLOUserResults::lookupResult	(	$a_course_obj_id,
		$a_user_id,
		$a_objective_id,
		$a_tst_type
	)

static

Lookup user result.

Definition at line 39 of file class.ilLOUserResults.php.

References $DIC, $ilDB, $query, $res, $row, and ilDBConstants\FETCHMODE_OBJECT.

Referenced by ilContainerObjectiveGUI\addItemDetails(), ilLOTestQuestionAdapter\initUserResult(), ilLOMemberTestResultTableGUI\parse(), and ilLOTestQuestionAdapter\updateQuestionResult().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         $query = 'SELECT * FROM loc_user_results ' .
                 'WHERE user_id = ' . $ilDB->quote($a_user_id, 'integer') . ' ' .
                 'AND course_id = ' . $ilDB->quote($a_course_obj_id, 'integer') . ' ' .
                 'AND objective_id = ' . $ilDB->quote($a_objective_id, 'integer') . ' ' .
                 'AND type = ' . $ilDB->quote($a_tst_type, 'integer');
         $res = $ilDB->query($query);
         $ur = array(
             'status' => self::STATUS_FAILED,
             'result_perc' => 0,
             'limit_perc' => 0,
             'tries' => 0,
             'is_final' => 0,
             'has_result' => false
         );
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             $ur['status'] = $row->status;
             $ur['result_perc'] = $row->result_perc;
             $ur['limit_perc'] = $row->limit_perc;
             $ur['tries'] = $row->tries;
             $ur['is_final'] = $row->is_final;
             $ur['has_result'] = true;
         }
         return $ur;
     }

Here is the caller graph for this function:

◆ resetFinalByObjective()

static ilLOUserResults::resetFinalByObjective ( $a_objective_id )

static

Definition at line 70 of file class.ilLOUserResults.php.

References $GLOBALS, and $query.

     {
         $query = 'UPDATE loc_user_results ' .
                 'SET is_final = ' . $GLOBALS['DIC']['ilDB']->quote(0, 'integer') . ' ' .
                 'WHERE objective_id = ' . $GLOBALS['DIC']['ilDB']->quote($a_objective_id, 'integer');
         $GLOBALS['DIC']['ilDB']->manipulate($query);
     }

◆ saveObjectiveResult()

ilLOUserResults::saveObjectiveResult	(	$a_objective_id,
		$a_type,
		$a_status,
		$a_result_percentage,
		$a_limit_percentage,
		$a_tries,
		$a_is_final
	)

Save objective result.

Parameters

int	$a_objective_id
int	$a_type
int	$a_status
int	$a_result_percentage
int	$a_limit_percentage
int	$a_tries
bool	$a_is_final

Returns: bool

Definition at line 220 of file class.ilLOUserResults.php.

References $a_type, $DIC, and $ilDB.

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         if (!self::isValidType($a_type) ||
             !self::isValidStatus($a_status)) {
             return false;
         }
         $ilDB->replace(
             "loc_user_results",
             array(
                 "course_id" => array("integer", $this->course_obj_id),
                 "user_id" => array("integer", $this->user_id),
                 "objective_id" => array("integer", $a_objective_id),
                 "type" => array("integer", $a_type)
             ),
             array(
                 "status" => array("integer", $a_status),
                 "result_perc" => array("integer", $a_result_percentage),
                 "limit_perc" => array("integer", $a_limit_percentage),
                 "tries" => array("integer", $a_tries),
                 "is_final" => array("integer", $a_is_final),
                 "tstamp" => array("integer", time()),
             )
         );
         return true;
     }

Field Documentation

◆ $course_obj_id

ilLOUserResults::$course_obj_id

protected

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

◆ $user_id

ilLOUserResults::$user_id

protected

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

Referenced by getSummarizedObjectiveStatusForLP().

◆ STATUS_COMPLETED

const ilLOUserResults::STATUS_COMPLETED = 1

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

Referenced by ilContainerObjectiveGUI\buildObjectiveProgressBar(), ilContainerObjectiveGUI\getObjectiveResultSummary(), ilTrQuery\getUserObjectiveMatrix(), ilContainerObjectiveGUI\renderTest(), and ilLOTestQuestionAdapter\updateQuestionResult().

◆ STATUS_FAILED

const ilLOUserResults::STATUS_FAILED = 2

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

Referenced by ilTrQuery\getUserObjectiveMatrix(), and ilLOTestQuestionAdapter\updateQuestionResult().

◆ TYPE_INITIAL

const ilLOUserResults::TYPE_INITIAL = 1

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

Referenced by ilContainerObjectiveGUI\buildAccordionTitle(), ilContainerObjectiveGUI\buildObjectiveProgressBar(), ilContainerObjectiveGUI\getObjectiveResultSummary(), ilTestLearningObjectivesStatusGUI\getUsersObjectivesResults(), ilContainerObjectiveGUI\parseLOUserResults(), and ilPortfolioPageGUI\parseLOUserResults().

◆ TYPE_QUALIFIED

const ilLOUserResults::TYPE_QUALIFIED = 2

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

Referenced by ilContainerObjectiveGUI\addItemDetails(), ilContainerObjectiveGUI\buildAccordionTitle(), ilContainerObjectiveGUI\buildObjectiveProgressBar(), ilContainerObjectiveGUI\getObjectiveResultSummary(), ilTrQuery\getUserObjectiveMatrix(), ilTestLearningObjectivesStatusGUI\getUsersObjectivesResults(), ilContainerObjectiveGUI\parseLOUserResults(), and ilPortfolioPageGUI\parseLOUserResults().

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

Modules/Course/classes/Objectives/class.ilLOUserResults.php

Public Member Functions

Static Public Member Functions

Data Fields

Protected Member Functions

Static Protected Member Functions

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ delete()

◆ deleteResultsForCourse()

◆ deleteResultsForUser()

◆ deleteResultsFromLP()

◆ findObjectiveIds()

◆ getCompletedObjectiveIds()

◆ getCompletedObjectiveIdsByType()

◆ getCompletionsOfUser()

◆ getCourseResultsForUserPresentation()

◆ getFailedObjectiveIds()

◆ getObjectiveStatusForLP()

◆ getSuggestedObjectiveIds()

◆ getSummarizedObjectiveStatusForLP()

◆ hasResults()

◆ isValidStatus()

◆ isValidType()

◆ lookupResult()

◆ resetFinalByObjective()

◆ saveObjectiveResult()

Field Documentation

◆ $course_obj_id

◆ $user_id

◆ STATUS_COMPLETED

◆ STATUS_FAILED

◆ TYPE_INITIAL

◆ TYPE_QUALIFIED