ilCourseObjectiveResult Class Reference

class ilcourseobjective More...

Collaboration diagram for ilCourseObjectiveResult:

Public Member Functions
	__construct ($a_usr_id)
	Constructor. More...
	getUserId ()
	getAccomplished ($a_crs_id)
	getSuggested ($a_crs_id, $a_status=IL_OBJECTIVE_STATUS_FINAL)
	reset ($a_course_id)
	getStatus ($a_course_id)
	hasAccomplishedObjective ($a_objective_id)
	readStatus ($a_crs_id)
	__deleteEntries ($a_objective_ids)

Static Public Member Functions
static	_getAccomplished ($a_user_id, $a_crs_id)
static	_getSuggested ($a_user_id, $a_crs_id, $a_status=IL_OBJECTIVE_STATUS_FINAL)
static	getSuggestedQuestions ($a_usr_id, $a_crs_id)
	get suggested questions ids More...
static	_deleteUser ($user_id)
static	_updateObjectiveResult ($a_user_id, $a_active_id, $a_question_id)
static	_readAssignedObjectivesOfQuestion ($a_question_id)
static	_readAssignedObjectives ($a_all_objectives)
static	_updateObjectiveStatus ($a_user_id, $objectives)
static	__isFullfilled ($question_points, $objective_data)
static	__updatePassed ($a_user_id, $objective_ids)
	can be protected? More...

Data Fields
	$db = null
	$user_id = null

Protected Member Functions
	resetTestForUser (ilObjTest $a_test, $a_user_id)

Detailed Description

class ilcourseobjective

Author

Stefan Meyer meyer.nosp@m.@lei.nosp@m.fos.c.nosp@m.om

Version

$Id$

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

Constructor & Destructor Documentation

__construct()

ilCourseObjectiveResult::__construct

(

$a_usr_id

)

Constructor.

Parameters

int

$a_usr_id

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

        {
                global $ilDB;
 
                $this->db = $ilDB;
 
                $this->user_id = $a_usr_id;
        }

References $ilDB.

Member Function Documentation

__deleteEntries()

ilCourseObjectiveResult::__deleteEntries

(

$a_objective_ids

)

Definition at line 317 of file class.ilCourseObjectiveResult.php.

        {
                global $ilLog;
                
                $ilLog->logStack();
                #$ilLog(__METHOD__.': Call of deprecated method.');
                
                return true;
        }

References $ilLog.

__isFullfilled()

static ilCourseObjectiveResult::__isFullfilled (   $question_points,   $objective_data  )

static

Definition at line 493 of file class.ilCourseObjectiveResult.php.

        {
                if(!is_array($objective_data['questions']))
                {
                        return false;
                }
                $max_points = 0;
                $reached_points = 0;
                foreach($objective_data['questions'] as $question_id)
                {
                        $max_points += $question_points[$question_id]['max_points'];
                        $reached_points += $question_points[$question_id]['reached_points'];
                }
                if(!$max_points)
                {
                        return false;
                }
                        
                return $reached_points >= $objective_data['tst_limit'] ? true : false;
                
                return (($reached_points / $max_points * 100) >= $objective_data['tst_limit']) ? true : false;
        }

Referenced by _updateObjectiveStatus().

Here is the caller graph for this function:

__updatePassed()

static ilCourseObjectiveResult::__updatePassed (   $a_user_id,   $objective_ids  )

static

can be protected?

@global type $ilDB

Parameters

type	$a_user_id
type	$objective_ids

Definition at line 523 of file class.ilCourseObjectiveResult.php.

        {
                global $ilDB;
 
                $passed = array();
                
                $query = "SELECT COUNT(t1.crs_id) num,t1.crs_id FROM crs_objectives t1 ".
                        "JOIN crs_objectives t2 WHERE t1.crs_id = t2.crs_id and  ".
                        $ilDB->in('t1.objective_id',$objective_ids,false,'integer')." ".
                        "GROUP BY t1.crs_id";
                $res = $ilDB->query($query);
                $crs_ids = array();
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                {
                        $query = "SELECT COUNT(cs.objective_id) num_passed FROM crs_objective_status cs ".
                                "JOIN crs_objectives co ON cs.objective_id = co.objective_id ".
                                "WHERE crs_id = ".$ilDB->quote($row->crs_id ,'integer')." ".
                                "AND user_id = ".$ilDB->quote($a_user_id ,'integer')." ";
 
                        $user_res = $ilDB->query($query);
                        while($user_row = $user_res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                        {
                                if($user_row->num_passed == $row->num)
                                {
                                        $passed[] = $row->crs_id;
                                }
                        }
                        $crs_ids[$row->crs_id] = $row->crs_id;
                }
                if(count($passed))
                {
                        foreach($passed as $crs_id)
                        {
                                include_once('Modules/Course/classes/class.ilCourseParticipants.php');
                                $members = ilCourseParticipants::_getInstanceByObjId($crs_id);
                                $members->updatePassed($a_user_id,true);
                        }
                }
                
                // update tracking status
                foreach ($crs_ids as $cid)
                {
                        include_once("./Services/Tracking/classes/class.ilLPStatusWrapper.php");
                        ilLPStatusWrapper::_updateStatus($cid, $a_user_id);
                }
        }

References $ilDB, $query, $res, $row, ilCourseParticipants\_getInstanceByObjId(), ilLPStatusWrapper\_updateStatus(), and ilDBConstants\FETCHMODE_OBJECT.

Referenced by _updateObjectiveStatus().

Here is the call graph for this function:

Here is the caller graph for this function:

_deleteUser()

static ilCourseObjectiveResult::_deleteUser (   $user_id )

static

Definition at line 327 of file class.ilCourseObjectiveResult.php.

        {
                global $ilDB;
 
                $query = "DELETE FROM crs_objective_status ".
                        "WHERE user_id = ".$ilDB->quote($user_id ,'integer')." ";
                $res = $ilDB->manipulate($query);
 
                $query = "DELETE FROM crs_objective_status_p ".
                        "WHERE user_id = ".$ilDB->quote($user_id ,'integer')." ";
                $res = $ilDB->manipulate($query);
                return true;
        }

References $ilDB, $query, $res, and $user_id.

_getAccomplished()

static ilCourseObjectiveResult::_getAccomplished (   $a_user_id,   $a_crs_id  )

static

Definition at line 46 of file class.ilCourseObjectiveResult.php.

        {
                global $ilDB;
 
                include_once 'Modules/Course/classes/class.ilCourseObjective.php';
                // begin-patch lok
                $objectives = ilCourseObjective::_getObjectiveIds($a_crs_id,true);
                // end-patch lok
 
                if(!is_array($objectives))
                {
                        return array();
                }
                $query = "SELECT objective_id FROM crs_objective_status ".
                        "WHERE ".$ilDB->in('objective_id',$objectives,false,'integer').' '.
                        "AND user_id = ".$ilDB->quote($a_user_id ,'integer')." ";
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                {
                        $accomplished[] = $row->objective_id;
                }
                return $accomplished ? $accomplished : array();
        }

References $ilDB, $query, $res, $row, ilCourseObjective\_getObjectiveIds(), and ilDBConstants\FETCHMODE_OBJECT.

Referenced by getAccomplished().

Here is the call graph for this function:

Here is the caller graph for this function:

_getSuggested()

static ilCourseObjectiveResult::_getSuggested (   $a_user_id,   $a_crs_id,   $a_status = IL_OBJECTIVE_STATUS_FINAL  )

static

Definition at line 75 of file class.ilCourseObjectiveResult.php.

        {
                global $ilDB;
 
                include_once './Modules/Course/classes/class.ilCourseObjective.php';
                // begin-patch lok
                $objectives = ilCourseObjective::_getObjectiveIds($a_crs_id,true);
                // end-patch lok
 
                $finished = array();
                if($a_status == IL_OBJECTIVE_STATUS_FINAL or
                   $a_status == IL_OBJECTIVE_STATUS_FINISHED)
                {
                        // check finished
                        $query = "SELECT objective_id FROM crs_objective_status ".
                                "WHERE ".$ilDB->in('objective_id',$objectives,false,'integer')." ".
                                "AND user_id = ".$ilDB->quote($a_user_id ,'integer')." ";
                        $res = $ilDB->query($query);
                        while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                        {
                                $finished[] = $row->objective_id;
                        }
                }
                else
                {
                        // Pretest 
                        $query = "SELECT objective_id FROM crs_objective_status_p ".
                                "WHERE ".$ilDB->in('objective_id',$objectives,false,'integer').' '.
                                "AND user_id = ".$ilDB->quote($a_user_id ,'integer');
                        $res = $ilDB->query($query);
                        while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                        {
                                $finished[] = $row->objective_id;
                        }
                }
                foreach($objectives as $objective_id)
                {
                        if(!in_array($objective_id,$finished))
                        {
                                $suggested[] = $objective_id;
                        }
                }
                return $suggested ? $suggested : array();
        }

References $ilDB, $query, $res, $row, ilCourseObjective\_getObjectiveIds(), ilDBConstants\FETCHMODE_OBJECT, IL_OBJECTIVE_STATUS_FINAL, and IL_OBJECTIVE_STATUS_FINISHED.

Referenced by getSuggested(), and ilCourseObjectiveResultCache\readSuggested().

Here is the call graph for this function:

Here is the caller graph for this function:

_readAssignedObjectives()

static ilCourseObjectiveResult::_readAssignedObjectives (   $a_all_objectives )

static

Definition at line 380 of file class.ilCourseObjectiveResult.php.

        {
                global $ilDB;
 
                // Read necessary points
                $query = "SELECT t.objective_id obj,t.ref_id ref, question_id,tst_status,tst_limit ".
                        "FROM crs_objective_tst t JOIN crs_objective_qst q ".
                        "ON (t.objective_id = q.objective_id AND t.ref_id = q.ref_id) ".
                        "WHERE ".$ilDB->in('t.objective_id',$a_all_objectives,false,'integer');
 
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                {
                        /*
                        $objectives[$row->obj."_".$row->ref]['questions'][$row->question_id] = $row->question_id;
                        $objectives[$row->obj."_".$row->ref]['tst_status'] = $row->tst_status;
                        $objectives[$row->obj."_".$row->ref]['tst_limit'] = $row->tst_limit;
                        $objectives[$row->obj."_".$row->ref]['objective_id'] = $row->obj;
                        */
                        
                        $objectives[$row->obj."_".$row->tst_status]['questions'][$row->question_id] = $row->question_id;
                        $objectives[$row->obj."_".$row->tst_status]['tst_status'] = $row->tst_status;
                        $objectives[$row->obj."_".$row->tst_status]['tst_limit'] = $row->tst_limit;
                        $objectives[$row->obj."_".$row->tst_status]['objective_id'] = $row->obj;
                        
                        
                }
                return $objectives ? $objectives : array();
        }

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

Referenced by _readAssignedObjectivesOfQuestion(), getStatus(), and readStatus().

Here is the caller graph for this function:

_readAssignedObjectivesOfQuestion()

static ilCourseObjectiveResult::_readAssignedObjectivesOfQuestion (   $a_question_id )

static

Definition at line 355 of file class.ilCourseObjectiveResult.php.

        {
                global $ilDB;
 
                // get all objtives and questions this current question is assigned to
                $query = "SELECT q2.question_id qid,q2.objective_id ob FROM crs_objective_qst q1, ".
                        "crs_objective_qst q2 ".
                        "WHERE q1.question_id = ".$ilDB->quote($a_question_id ,'integer')." ".
                        "AND q1.objective_id = q2.objective_id ";
 
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                {
                        $objectives['all_objectives'][$row->ob] = $row->ob;
                        $objectives['all_questions'][$row->qid] = $row->qid;
                }
                if(!is_array($objectives))
                {
                        return false;
                }
                $objectives['objectives'] = self::_readAssignedObjectives($objectives['all_objectives']);
                return $objectives ? $objectives : array();
        }

References $ilDB, $query, $res, $row, _readAssignedObjectives(), and ilDBConstants\FETCHMODE_OBJECT.

Here is the call graph for this function:

_updateObjectiveResult()

static ilCourseObjectiveResult::_updateObjectiveResult (   $a_user_id,   $a_active_id,   $a_question_id  )

static

Definition at line 341 of file class.ilCourseObjectiveResult.php.

        {
                // find all objectives this question is assigned to
                if(!$objectives = self::_readAssignedObjectivesOfQuestion($a_question_id))
                {
                        // no objectives found. TODO user has passed a test. After that questions of that test are assigned to an objective.
                        // => User has not passed
                        return true;
                }
                self::_updateObjectiveStatus($a_user_id,$objectives);
                
                return true;
        }

References _updateObjectiveStatus().

Referenced by assQuestion\_setReachedPoints(), and assQuestion\calculateResultsFromSolution().

Here is the call graph for this function:

Here is the caller graph for this function:

_updateObjectiveStatus()

static ilCourseObjectiveResult::_updateObjectiveStatus (   $a_user_id,   $objectives  )

static

Definition at line 410 of file class.ilCourseObjectiveResult.php.

        {
                global $ilDB,$ilUser;
 
                if(!count($objectives['all_questions']) or
                   !count($objectives['all_objectives']))
                {
                        return false;
                }
                // Read reachable points
                $query = "SELECT question_id,points FROM qpl_questions ".
                        "WHERE ".$ilDB->in('question_id',(array) $objectives['all_questions'],false,'integer');
                $res = $ilDB->query($query);
                while($row = $ilDB->fetchAssoc($res))
                {
                        $objectives['all_question_points'][$row['question_id']]['max_points'] = $row['points'];
                }
                // Read reached points
                $query = "SELECT question_fi, MAX(points) as reached FROM tst_test_result ".
                        "JOIN tst_active ON (active_id = active_fi) ".
                        "WHERE user_fi = ".$ilDB->quote($a_user_id,'integer')." ".
                        "AND ".$ilDB->in('question_fi',(array) $objectives['all_questions'],false,'integer')." ".
                        #"AND question_fi IN (".implode(",",ilUtil::quoteArray($objectives['all_questions'])).") ".
                        "GROUP BY question_fi,user_fi";
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                {
                        $objectives['all_question_points'][$row->question_fi]['reached_points'] = $row->reached;
                }
                
                // Check accomplished
                $fullfilled = array();
                $pretest = array();
                foreach($objectives['objectives'] as $kind => $data)
                {
                        // objective does not allow to change status
                        if(ilCourseObjectiveResult::__isFullfilled($objectives['all_question_points'],$data))
                        {
                                // Status 0 means pretest fullfilled, status 1 means final test fullfilled
                                if($data['tst_status'])
                                {
                                        $fullfilled[] = array($data['objective_id'],$ilUser->getId(),$data['tst_status']);
                                }
                                else
                                {
                                        $pretest[] = array($data['objective_id'],$ilUser->getId());
                                }
                        }
                }
                if(count($fullfilled))
                {
                        foreach($fullfilled as $fullfilled_arr)
                        {
                                $ilDB->replace(
                                        'crs_objective_status',
                                        array(
                                                'objective_id' => array('integer',$fullfilled_arr[0]),
                                                'user_id' => array('integer',$fullfilled_arr[1])
                                        ),
                                        array(
                                                'status' => array('integer',$fullfilled_arr[2])
                                        )
                                );
                        }
                        ilCourseObjectiveResult::__updatePassed($a_user_id,$objectives['all_objectives']);
                }
                if(count($pretest))
                {
                        foreach($pretest as $pretest_arr)
                        {
                                $ilDB->replace(
                                        'crs_objective_status_p',
                                        array(
                                                'objective_id' => array('integer',$pretest_arr[0]),
                                                'user_id' => array('integer',$pretest_arr[1])
                                        ),
                                        array()
                                );
                        }
                }
                return true;
        }

References $data, $ilDB, $ilUser, $query, $res, $row, __isFullfilled(), __updatePassed(), and ilDBConstants\FETCHMODE_OBJECT.

Referenced by _updateObjectiveResult(), and readStatus().

Here is the call graph for this function:

Here is the caller graph for this function:

getAccomplished()

ilCourseObjectiveResult::getAccomplished

(

$a_crs_id

)

Definition at line 42 of file class.ilCourseObjectiveResult.php.

        {
                return ilCourseObjectiveResult::_getAccomplished($this->getUserId(),$a_crs_id);
        }

References _getAccomplished(), and getUserId().

Referenced by getStatus().

Here is the call graph for this function:

Here is the caller graph for this function:

getStatus()

ilCourseObjectiveResult::getStatus

(

$a_course_id

)

Definition at line 232 of file class.ilCourseObjectiveResult.php.

        {
                include_once './Modules/TestQuestionPool/classes/class.assQuestion.php';
                include_once 'Modules/Course/classes/class.ilCourseObjective.php';
                // begin-patch lok
                $objective_ids = ilCourseObjective::_getObjectiveIds($a_course_id,true);
                // end-patch lok
                $objectives = ilCourseObjectiveResult::_readAssignedObjectives($objective_ids);
                $accomplished = $this->getAccomplished($a_course_id);
                $suggested = $this->getSuggested($a_course_id);
 
                if(!count($objective_ids))
                {
                        return IL_OBJECTIVE_STATUS_EMPTY;
                }
 
                if(count($accomplished) == count($objective_ids))
                {
                        return IL_OBJECTIVE_STATUS_FINISHED;
                }
 
                $all_pretest_answered = false;
                $all_final_answered = false;
                foreach($objectives as $data)
                {
                        if(assQuestion::_areAnswered($this->getUserId(),$data['questions']))
                        {
                                if($data['tst_status'])
                                {
                                        $all_final_answered = true;
                                }
                                else
                                {
                                        $all_pretest_answered = true;
                                }
                        }
                }
                if($all_final_answered)
                {
                        return IL_OBJECTIVE_STATUS_FINAL;
                }
                if($all_pretest_answered and 
                   !count($suggested))
                {
                        return IL_OBJECTIVE_STATUS_PRETEST_NON_SUGGEST;
                }
                elseif($all_pretest_answered)
                {
                        return IL_OBJECTIVE_STATUS_PRETEST;
                }
                return IL_OBJECTIVE_STATUS_NONE;
        }

References $data, assQuestion\_areAnswered(), ilCourseObjective\_getObjectiveIds(), _readAssignedObjectives(), getAccomplished(), getSuggested(), getUserId(), IL_OBJECTIVE_STATUS_EMPTY, IL_OBJECTIVE_STATUS_FINAL, IL_OBJECTIVE_STATUS_FINISHED, IL_OBJECTIVE_STATUS_NONE, IL_OBJECTIVE_STATUS_PRETEST, and IL_OBJECTIVE_STATUS_PRETEST_NON_SUGGEST.

Here is the call graph for this function:

getSuggested()

ilCourseObjectiveResult::getSuggested	(		$a_crs_id,
			$a_status = IL_OBJECTIVE_STATUS_FINAL
	)

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

        {
                return ilCourseObjectiveResult::_getSuggested($this->getUserId(),$a_crs_id,$a_status);
        }

References _getSuggested(), and getUserId().

Referenced by getStatus().

Here is the call graph for this function:

Here is the caller graph for this function:

getSuggestedQuestions()

static ilCourseObjectiveResult::getSuggestedQuestions (   $a_usr_id,   $a_crs_id  )

static

get suggested questions ids

Parameters

object	$a_usr_id
object	$a_crs_id

Returns

Definition at line 126 of file class.ilCourseObjectiveResult.php.

        {
                foreach(self::_getSuggested($a_usr_id,$a_crs_id) as $objective_id)
                {
                        include_once './Modules/Course/classes/class.ilCourseObjectiveQuestion.php';
                        $obj = new ilCourseObjectiveQuestion($objective_id);
                        foreach($obj->getFinalTestQuestions() as $qst)
                        {
                                $qsts[] = $qst['question_id'];
                        }
                }
                return $qsts ? $qsts : array();
        }

getUserId()

ilCourseObjectiveResult::getUserId

(

)

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

        {
                return $this->user_id;
        }

References $user_id.

Referenced by getAccomplished(), getStatus(), getSuggested(), hasAccomplishedObjective(), readStatus(), and reset().

Here is the caller graph for this function:

hasAccomplishedObjective()

ilCourseObjectiveResult::hasAccomplishedObjective

(

$a_objective_id

)

Definition at line 285 of file class.ilCourseObjectiveResult.php.

        {
                global $ilDB;
                
                $query = "SELECT status FROM crs_objective_status ".
                        "WHERE objective_id = ".$ilDB->quote($a_objective_id ,'integer')." ".
                        "AND user_id = ".$ilDB->quote($this->getUserId() ,'integer')."";
 
                $res = $this->db->query($query);
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                {
                        return true;
                }
                return false;
        }

References $ilDB, $query, $res, $row, ilDBConstants\FETCHMODE_OBJECT, and getUserId().

Here is the call graph for this function:

readStatus()

ilCourseObjectiveResult::readStatus

(

$a_crs_id

)

Definition at line 301 of file class.ilCourseObjectiveResult.php.

        {
                include_once './Modules/Course/classes/class.ilCourseObjective.php';
 
                // begin-patch lok
                $objective_ids = ilCourseObjective::_getObjectiveIds($a_crs_id,true);
                // end-patch lok
                $objectives = ilCourseObjectiveResult::_readAssignedObjectives($objective_ids);
                ilCourseObjectiveResult::_updateObjectiveStatus($this->getUserId(),$objectives);
                return true;
        }

References ilCourseObjective\_getObjectiveIds(), _readAssignedObjectives(), _updateObjectiveStatus(), and getUserId().

Here is the call graph for this function:

reset()

ilCourseObjectiveResult::reset

(

$a_course_id

)

Definition at line 158 of file class.ilCourseObjectiveResult.php.

        {
                global $ilDB;
                
                include_once './Modules/Course/classes/class.ilCourseObjective.php';
                include_once './Modules/Course/classes/class.ilCourseObjectiveQuestion.php';            
                
                include_once './Services/Object/classes/class.ilObjectFactory.php';
                $factory = new ilObjectFactory();
                
                include_once './Modules/Course/classes/Objectives/class.ilLOTestAssignments.php';
                include_once './Modules/Course/classes/Objectives/class.ilLOSettings.php';
                $assignments = ilLOTestAssignments::getInstance($a_course_id);
                foreach(array_merge
                                (
                                        $assignments->getAssignmentsByType(ilLOSettings::TYPE_TEST_INITIAL),
                                        $assignments->getAssignmentsByType(ilLOSettings::TYPE_TEST_QUALIFIED)
                                )
                                as $assignment)
                {
                        $tst = $factory->getInstanceByRefId($assignment->getTestRefId(),FALSE);
                        if($tst instanceof ilObjTest)
                        {
                                global $lng;
                                
                                require_once 'Modules/Test/classes/class.ilTestParticipantData.php';
                                $participantData = new ilTestParticipantData($ilDB, $lng);
                                $participantData->setUserIds(array($this->getUserId()));
                                $participantData->load($tst->getTestId());
                                $tst->removeTestResults($participantData);
 
                        }
                }
 
                $initial = ilLOSettings::getInstanceByObjId($a_course_id)->getInitialTest();
                $initial_tst = $factory->getInstanceByRefId($initial, FALSE);
                if($initial_tst instanceof ilObjTest)
                {
                        $this->resetTestForUser($initial_tst, $this->getUserId());                              
                }
                
                $qualified = ilLOSettings::getInstanceByObjId($a_course_id)->getQualifiedTest();
                $qualified_tst = $factory->getInstanceByRefId($qualified, FALSE);
                if($qualified_tst instanceof ilObjTest)
                {
                        $this->resetTestForUser($qualified_tst, $this->getUserId());                    
                }
                
                $objectives = ilCourseObjective::_getObjectiveIds($a_course_id,FALSE);
 
                if(count($objectives))
                {
                        $query = "DELETE FROM crs_objective_status ".
                                "WHERE ".$ilDB->in('objective_id',$objectives,false,'integer').' '.
                                "AND user_id = ".$ilDB->quote($this->getUserId() ,'integer')." ";
                        $res = $ilDB->manipulate($query);
 
                        $query = "DELETE FROM crs_objective_status_p ".
                                "WHERE ".$ilDB->in('objective_id',$objectives,false,'integer').' '.
                                "AND user_id = ".$ilDB->quote($this->getUserId())."";
                        $res = $ilDB->manipulate($query);
                        
                        $query = "DELETE FROM loc_user_results ".
                                "WHERE ".$ilDB->in('objective_id',$objectives,false,'integer').' '.
                                "AND user_id = ".$ilDB->quote($this->getUserId())."";
                }
        
                // update/reset LP for course
                include_once './Services/Tracking/classes/class.ilLPStatusWrapper.php'; 
                ilLPStatusWrapper::_updateStatus($a_course_id, $this->getUserId());
                
                return true;
        }

References $ilDB, $lng, $query, $res, ilCourseObjective\_getObjectiveIds(), ilLPStatusWrapper\_updateStatus(), ilLOTestAssignments\getInstance(), ilLOSettings\getInstanceByObjId(), getUserId(), resetTestForUser(), ilLOSettings\TYPE_TEST_INITIAL, and ilLOSettings\TYPE_TEST_QUALIFIED.

Here is the call graph for this function:

resetTestForUser()

ilCourseObjectiveResult::resetTestForUser ( ilObjTest  $a_test,   $a_user_id  )

protected

Definition at line 140 of file class.ilCourseObjectiveResult.php.

        {
                // this is done in ilTestLP (see below)
                // $a_test->removeTestResultsForUser($a_user_id);
                                        
                // #15038
                include_once "Modules/Test/classes/class.ilTestLP.php";
                $test_lp = ilTestLP::getInstance($a_test->getId());
                $test_lp->resetLPDataForUserIds(array($a_user_id));             
                
                // #15205 - see ilObjTestGUI::confirmDeleteSelectedUserDataObject()
                $active_id = $a_test->getActiveIdOfUser($a_user_id);
                if($active_id)
                {
                        $a_test->removeTestActives(array($active_id));
                }
        }

References ilObjTest\getActiveIdOfUser(), ilObject\getId(), ilObjectLP\getInstance(), and ilObjTest\removeTestActives().

Referenced by reset().

Here is the call graph for this function:

Here is the caller graph for this function:

Field Documentation

$db

ilCourseObjectiveResult::$db = null

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

$user_id

ilCourseObjectiveResult::$user_id = null

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

Referenced by _deleteUser(), and getUserId().

---

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

• Modules/Course/classes/class.ilCourseObjectiveResult.php