Collaboration diagram for ilLOUserResults:

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

	delete ()
	Delete for user and course @global 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 @global type $ilDB.

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

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

References $DIC, $ilDB, and $query.

◆ 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.

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

References $DIC, and $ilDB.

◆ 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.

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

References $DIC, and $ilDB.

Referenced by ilObjCourse\_deleteUser().

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.

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

References $DIC, and $ilDB.

Referenced by ilTestLP\resetCustomLPDataForUserIds().

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.

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

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

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

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.

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

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

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.

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

References $a_type, and findObjectiveIds().

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.

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

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

Referenced by ilCourseLearningHistoryProvider\getEntries().

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.

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

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

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.

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

References findObjectiveIds().

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.

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

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

Referenced by ilTrQuery\getObjectivesStatusForUser().

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.

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

References findObjectiveIds().

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.

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

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

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

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.

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

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

Referenced by ilContainerObjectiveGUI\getMainContent().

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.

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

Referenced by findObjectiveIds().

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.

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

References $a_type.

Referenced by findObjectiveIds().

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.

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

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

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

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.

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

References $GLOBALS, and $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.

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

References $a_type, $DIC, and $ilDB.

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(), getObjectiveStatusForLP(), getSummarizedObjectiveStatusForLP(), 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 getObjectiveStatusForLP(), getSummarizedObjectiveStatusForLP(), 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(), ilPortfolioPageGUI\parseLOUserResults(), and ilContainerObjectiveGUI\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(), ilPortfolioPageGUI\parseLOUserResults(), and ilContainerObjectiveGUI\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