INTERNAL CLASS: Please do not use in consumer code. More...

Collaboration diagram for ilConditionHandler:

Public Member Functions
	__construct ()
	constructor public More...

	setReferenceHandlingType ($a_type)
	set reference handling type More...

	getReferenceHandlingType ()
	get reference handling type More...

	setErrorMessage ($a_msg)

	getErrorMessage ()

	setTargetRefId ($a_target_ref_id)
	set target ref id More...

	getTargetRefId ()
	get target ref id More...

	setTargetObjId ($a_target_obj_id)
	set target object id More...

	getTargetObjId ()
	get target obj id More...

	setTargetType ($a_target_type)
	set target object type More...

	getTargetType ()
	get target obj type More...

	setTriggerRefId ($a_trigger_ref_id)
	set trigger ref id More...

	getTriggerRefId ()
	get target ref id More...

	setTriggerObjId ($a_trigger_obj_id)
	set trigger object id More...

	getTriggerObjId ()
	get trigger obj id More...

	setTriggerType ($a_trigger_type)
	set trigger object type More...

	getTriggerType ()
	get trigger obj type More...

	setOperator ($a_operator)
	set operator More...

	getOperator ()
	get operator More...

	setValue ($a_value)
	set value More...

	getValue ()
	get value More...

	setObligatory ($a_obl)
	Set obligatory status. More...

	getObligatory ()
	Get obligatory status. More...

	setHiddenStatus ($a_status)

	getHiddenStatus ()

	enableAutomaticValidation ($a_validate=true)
	enable automated validation More...

	getOperatorsByTriggerType ($a_type)
	Get operators by trigger type. More...

	storeCondition ()
	store new condition in database More...

	checkExists ()

	updateCondition ($a_id)
	update condition More...

	updateHiddenStatus ($a_status)
	Update hidden status type $ilDB. More...

	delete ($a_ref_id)
	delete all trigger and target entries This method is called from ilObject::delete() if an object os removed from trash More...

	deleteByObjId ($a_obj_id)
	delete all trigger and target entries This method is called from ilObject::delete() if an object is removed from trash More...

	deleteCondition ($a_id)
	delete condition More...

Static Public Member Functions
static	_isReferenceHandlingOptional ($a_type)
	is reference handling optional More...

static	lookupPersistedHiddenStatusByTarget ($a_target_ref_id)
	Lookup persistedhidden status. More...

static	_adjustMovedObjectConditions ($a_ref_id)
	In the moment it is not allowed to create preconditions on objects that are located outside of a course. More...

static	updateObligatory ($a_id, $a_status)
	Toggle condition obligatory status. More...

static	getNumberOfConditionsOfTrigger ($a_trigger_obj_type, $a_trigger_id)
	get all conditions of trigger object More...

static	_getPersistedConditionsOfTrigger ($a_trigger_obj_type, $a_trigger_id)
	Get all persisted conditions of trigger object Note: This only gets persisted conditions NOT (dynamic) conditions send by the parent container logic. More...

static	_getPersistedConditionsOfTarget ($a_target_ref_id, $a_target_obj_id, $a_target_type="")
	get all persisted conditions of target object More...

static	preloadPersistedConditionsForTargetRecords ($a_type, $a_obj_ids)
	Preload conditions for target records. More...

static	_getCondition ($a_id)

static	_checkCondition ($condition, $a_usr_id=0)
	checks wether a single condition is fulfilled every trigger object type must implement a static method _checkCondition($a_operator, $a_value) More...

static	getEffectiveOptionalConditionsOfTarget ($a_target_ref_id, $a_target_obj_id, $a_obj_type='')
	Get optional conditions. More...

static	getPersistedOptionalConditionsOfTarget ($a_target_ref_id, $a_target_obj_id, $a_obj_type='')
	Get optional conditions. More...

static	lookupObligatoryConditionsOfTarget ($a_target_ref_id, $a_target_obj_id)
	Lookup obligatory conditions of target. More...

static	calculateEffectiveRequiredTriggers ($a_target_ref_id, $a_target_obj_id, $a_target_obj_type='')
	calculate number of obligatory items More...

static	calculatePersistedRequiredTriggers ($a_target_ref_id, $a_target_obj_id, $a_target_obj_type='', $a_force_update=false)
	calculate number of obligatory items More...

static	saveNumberOfRequiredTriggers ($a_target_ref_id, $a_target_obj_id, $a_num)
	Save number of obigatory triggers. More...

static	_checkAllConditionsOfTarget ($a_target_ref_id, $a_target_id, $a_target_type="", $a_usr_id=0)
	checks wether all conditions of a target object are fulfilled More...

static	cloneDependencies ($a_src_ref_id, $a_target_ref_id, $a_copy_id)

Data Fields
const	OPERATOR_PASSED = 'passed'

const	OPERATOR_FINISHED = 'finished'

const	OPERATOR_NOT_FINISHED = 'not_finished'

const	OPERATOR_NOT_MEMBER = 'not_member'

const	OPERATOR_FAILED = 'failed'

const	OPERATOR_LP = 'learning_progress'

const	OPERATOR_ACCREDITED_OR_PASSED = 'accredited_or_passed'

const	UNIQUE_CONDITIONS = 1

const	SHARED_CONDITIONS = 0

	$db

	$lng

	$error_message

	$target_obj_id

	$target_ref_id

	$target_type

	$trigger_obj_id

	$trigger_ref_id

	$trigger_type

	$operator

	$value

	$validation

	$conditions

Static Public Attributes
static	$cond_for_target_cache = array()

static	$cond_target_rows = array()

Protected Member Functions
	validate ()

	checkCircle ($a_ref_id, $a_obj_id)

Static Protected Member Functions
static	_getDistinctTargetRefIds ()
	Get all target ref ids. More...

static	_deleteTargetConditionsByRefId ($a_target_ref_id)
	Delete conditions by target ref id Note: only conditions on the target type are deleted Conditions on e.g chapters are not handled. More...

Private Attributes
	$obligatory = true

	$hidden_status = false

Detailed Description

INTERNAL CLASS: Please do not use in consumer code.

Handles conditions for accesses to different ILIAS objects

A condition consists of four elements:

a trigger object, e.g. a test or a survey question
an operator, e.g. "=", "<", "passed"
an (optional) value, e.g. "5"
a target object, e.g. a learning module

If a condition is fulfilled for a certain user, (s)he may access the target object. This first implementation handles only one access type per object, which is usually "read" access. A possible future extension may implement different access types.

The condition data is stored in the database table "condition" (Note: This table must not be accessed directly from other classes. The data should be accessed via the interface of class ilCondition.) cond_id INT condition id trigger_obj_type VARCHAR(10) "crs" | "tst" | ... trigger_ref_id INT obj id of trigger object (only exception where this is 0 are currently (5.3) course groupings this might be refactored trigger_obj_id INT obj id of trigger object operator varchar(10 "=", "<", ">", ">=", "<=", "passed", "contains", ... value VARCHAR(10) optional value target_obj_type VARCHAR(10) "lm" | "frm" | "st", "lobj", ... target_obj_id object id of target object target_ref_id reference id of target object

Special current targets (5.3)

learning objectives: type: "lobj"; obj_id: objective id; ref_id: ref id of course
lm chapters: type: "st"; obj_id: chapter id, ref_id: ref id of learning module

Trigger objects are always stored with their object id (if a test has been passed by a user, he doesn't need to repeat it in other contexts. But target objects are usually stored with their reference id if available, otherwise, if they are non-referenced objects (e.g. (survey) questions) they are stored with their object id.

Stefan Meyer 10-08-2004 In addition we store the ref_id of the trigger object to allow the target object to link to the triggered object. But it's not possible to assign two or more linked (same obj_id) triggered objects to a target object

Examples:

Learning module 5 may only be accessed, if test 6 has been passed: trigger_obj_type "tst" trigger_id 6 (object id) trigger_ref_id 117 operator "passed" value target_obj_type "lm" target_id 5 (reference id)

Survey question 10 should only be presented, if survey question 8 is answered with a value greater than 4. trigger_obj_type "qst" trigger_id 8 (question (instance) object id) trigger_ref_id 117 operator ">" value "4" target_obj_type "lm" target_id 10 (question (instance) object id)

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

Version: $Id$

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

Constructor & Destructor Documentation

◆ __construct()

ilConditionHandler::__construct ( )

constructor public

Definition at line 122 of file class.ilConditionHandler.php.

References $DIC, $ilDB, and $lng.

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         $lng = $DIC['lng'];
 
         $this->db = &$ilDB;
         $this->lng = &$lng;
         $this->validation = true;
     }

Member Function Documentation

◆ _adjustMovedObjectConditions()

static ilConditionHandler::_adjustMovedObjectConditions ( $a_ref_id )

static

In the moment it is not allowed to create preconditions on objects that are located outside of a course.

Therefore, after moving an object: check for parent type 'crs'. if that fails delete preconditions

public

Parameters

int	reference id of moved object

Definition at line 217 of file class.ilConditionHandler.php.

References $conditions, $DIC, and $tree.

Referenced by ilSoapObjectAdministration\moveObject(), ilContainerGUI\pasteObject(), ilContainerGUI\performPasteIntoMultipleObjectsObject(), and ilChatroomInstaller\setChatroomSettings().

     {
         global $DIC;
 
         return true;
 
         $tree = $DIC['tree'];
         
         if ($tree->checkForParentType($a_ref_id, 'crs')) {
             // Nothing to do
             return true;
         }
         
         // Need another implementation that has better performance
         $childs = $tree->getSubTree($tree->getNodeData($a_ref_id), false);
         $conditions = self::_getDistinctTargetRefIds();
         
         foreach (array_intersect($conditions, $childs) as $target_ref) {
             if (!$tree->checkForParentType($target_ref, 'crs')) {
                 self::_deleteTargetConditionsByRefId($target_ref);
             }
         }
         return true;
     }

Here is the caller graph for this function:

◆ _checkAllConditionsOfTarget()

static ilConditionHandler::_checkAllConditionsOfTarget	(	$a_target_ref_id,
		$a_target_id,
		$a_target_type = `""`,
		$a_usr_id = `0`
	)

static

checks wether all conditions of a target object are fulfilled

Definition at line 1200 of file class.ilConditionHandler.php.

References $conditions, $DIC, $ilUser, $tree, _checkCondition(), and ilMemberViewSettings\getInstance().

Referenced by ilObjContentObject\_checkPreconditionsOfPage(), ilContainerObjectiveGUI\addItemDetails(), ilAccess\doConditionCheck(), ilRepositoryExplorerGUI\getChildsOfNode(), ilObjCourseListGUI\initItem(), ilObjGroupReferenceListGUI\initItem(), ilObjCourseReferenceListGUI\initItem(), ilRepositoryExplorer\isClickable(), ilRepositoryExplorerGUI\isNodeClickable(), ilRepositoryExplorer\showChilds(), and ilCourseContentGUI\showStartObjects().

     {
         global $DIC;
 
         $ilUser = $DIC['ilUser'];
         $tree = $DIC['tree'];
         
         $a_usr_id = $a_usr_id ? $a_usr_id : $ilUser->getId();
 
         $conditions = ilConditionHandler::_getEffectiveConditionsOfTarget($a_target_ref_id, $a_target_id, $a_target_type);
 
         if (!count($conditions)) {
             return true;
         }
 
         // @todo check this
         include_once './Services/Container/classes/class.ilMemberViewSettings.php';
         if (ilMemberViewSettings::getInstance()->isActive()) {
             return true;
         }
 
         // First check obligatory conditions
         $optional = self::getEffectiveOptionalConditionsOfTarget($a_target_ref_id, $a_target_id, $a_target_type);
         $num_required = self::calculateEffectiveRequiredTriggers($a_target_ref_id, $a_target_id, $a_target_type);
         $passed = 0;
         foreach ($conditions as $condition) {
             if ($tree->isDeleted($condition['trigger_ref_id'])) {
                 continue;
             }
             $check = ilConditionHandler::_checkCondition($condition, $a_usr_id);
 
             if ($check) {
                 ++$passed;
                 if ($passed >= $num_required) {
                     return true;
                 }
             } else {
                 if (!count($optional)) {
                     return false;
                 }
             }
         }
         // not all optional conditions passed
         return false;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ _checkCondition()

static ilConditionHandler::_checkCondition	(	$condition,
		$a_usr_id = `0`
	)

static

checks wether a single condition is fulfilled every trigger object type must implement a static method _checkCondition($a_operator, $a_value)

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

References $DIC, $ilUser, $location, ilObjCourseGrouping\_checkCondition(), and ilLPStatus\_hasUserCompleted().

Referenced by _checkAllConditionsOfTarget(), ilObjContentObject\_getMissingPreconditionsOfPage(), ilObjContentObject\_getMissingPreconditionsTopChapter(), ilInfoScreenGUI\addPreconditionSection(), and ilObjectListGUI\parseConditions().

     {
         global $DIC;
 
         $ilUser = $DIC['ilUser'];
         $objDefinition = $DIC['objDefinition'];
 
         $a_usr_id = $a_usr_id ? $a_usr_id : $ilUser->getId();
         
         //$condition = ilConditionHandler::_getCondition($a_id);
         
         // check lp
         if ($condition['operator'] == self::OPERATOR_LP) {
             include_once './Services/Tracking/classes/class.ilLPStatus.php';
             return ilLPStatus::_hasUserCompleted($condition['trigger_obj_id'], $a_usr_id);
         }
         
         switch ($condition['trigger_type']) {
             case 'crsg':
                 include_once './Modules/Course/classes/class.ilObjCourseGrouping.php';
                 return ilObjCourseGrouping::_checkCondition($condition['trigger_obj_id'], $condition['operator'], $condition['value'], $a_usr_id);
         }
         
         $class = $objDefinition->getClassName($condition['trigger_type']);
         $location = $objDefinition->getLocation($condition['trigger_type']);
         $full_class = "ilObj" . $class . "Access";
         include_once($location . "/class." . $full_class . ".php");
 
         $fullfilled = call_user_func(
             array($full_class, 'checkCondition'),
             $condition['trigger_obj_id'],
             $condition['operator'],
             $condition['value'],
             $a_usr_id
         );
         return $fullfilled;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ _deleteTargetConditionsByRefId()

static ilConditionHandler::_deleteTargetConditionsByRefId ( $a_target_ref_id )

staticprotected

Delete conditions by target ref id Note: only conditions on the target type are deleted Conditions on e.g chapters are not handled.

public

Parameters

int	ref id of target

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

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

Referenced by ilRBACTest\testConditions().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         $query = "DELETE FROM conditions " .
             "WHERE target_ref_id = " . $ilDB->quote($a_target_ref_id, 'integer') . " " .
             "AND target_type != 'st' ";
         $res = $ilDB->manipulate($query);
         return true;
     }

Here is the caller graph for this function:

◆ _getCondition()

static ilConditionHandler::_getCondition ( $a_id )

static

Definition at line 960 of file class.ilConditionHandler.php.

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

Referenced by ilConditionHandlerGUI\askDelete(), ilConditionHandlerGUI\edit(), ilConditionHandlerGUI\initFormCondition(), ilRBACTest\testConditions(), and ilConditionHandlerGUI\updateCondition().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = "SELECT * FROM conditions " .
             "WHERE condition_id = " . $ilDB->quote($a_id, 'integer');
 
         $res = $ilDB->query($query);
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             $tmp_array['id'] = $row->condition_id;
             $tmp_array['target_ref_id'] = $row->target_ref_id;
             $tmp_array['target_obj_id'] = $row->target_obj_id;
             $tmp_array['target_type'] = $row->target_type;
             $tmp_array['trigger_ref_id'] = $row->trigger_ref_id;
             $tmp_array['trigger_obj_id'] = $row->trigger_obj_id;
             $tmp_array['trigger_type'] = $row->trigger_type;
             $tmp_array['operator'] = $row->operator;
             $tmp_array['value'] = $row->value;
             $tmp_array['ref_handling'] = $row->ref_handling;
             $tmp_array['obligatory'] = $row->obligatory;
             $tmp_array['hidden_status'] = $row->hidden_status;
 
             return $tmp_array;
         }
         return false;
     }

Here is the caller graph for this function:

◆ _getDistinctTargetRefIds()

static ilConditionHandler::_getDistinctTargetRefIds ( )

staticprotected

Get all target ref ids.

public

Definition at line 249 of file class.ilConditionHandler.php.

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

Referenced by ilRBACTest\testConditions().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         $query = "SELECT DISTINCT target_ref_id ref FROM conditions ";
         $res = $ilDB->query($query);
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             $ref_ids[] = $row->ref;
         }
         return $ref_ids ? $ref_ids : array();
     }

Here is the caller graph for this function:

◆ _getPersistedConditionsOfTarget()

static ilConditionHandler::_getPersistedConditionsOfTarget	(	$a_target_ref_id,
		$a_target_obj_id,
		$a_target_type = `""`
	)

static

get all persisted conditions of target object

Parameters

int	$a_target_ref_id
int	$a_target_obj_id
string	$a_target_type

Returns: array

Definition at line 876 of file class.ilConditionHandler.php.

References $conditions, $DIC, $ilDB, $query, $res, $row, $rows, and ilObject\_lookupType().

Referenced by ilConditionHandlerGUI\__getConditionsOfTarget(), ilObjCourseGrouping\_checkGroupingDependencies(), ilObjCourseGrouping\_getGroupingCourseIds(), ilObjCourseGrouping\_getGroupingItems(), ilObjContentObject\_getMissingPreconditionsOfPage(), ilObjContentObject\_getMissingPreconditionsTopChapter(), checkCircle(), cloneDependencies(), ilConditionHandlerGUI\listConditions(), ilConditionHandlerGUI\saveObligatoryList(), ilConditionHandlerGUI\saveObligatorySettings(), ilConditionHandlerGUI\showObligatoryForm(), and ilRBACTest\testConditions().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         // get type if no type given
         if ($a_target_type == "") {
             $a_target_type = ilObject::_lookupType($a_target_obj_id);
         }
 
         // check conditions for target cache
         if (isset(self::$cond_for_target_cache[$a_target_ref_id . ":" . $a_target_obj_id . ":" .
             $a_target_type])) {
             return self::$cond_for_target_cache[$a_target_ref_id . ":" . $a_target_obj_id . ":" .
                 $a_target_type];
         }
 
         // check rows cache
         if (isset(self::$cond_target_rows[$a_target_type . ":" . $a_target_obj_id])) {
             $rows = self::$cond_target_rows[$a_target_type . ":" . $a_target_obj_id];
         } else {
             // query data from db
             $query = "SELECT * FROM conditions " .
                 "WHERE target_obj_id = " . $ilDB->quote($a_target_obj_id, 'integer') . " " .
                 " AND target_type = " . $ilDB->quote($a_target_type, 'text');
 
             $res = $ilDB->query($query);
             $rows = array();
             while ($row = $ilDB->fetchAssoc($res)) {
                 $rows[] = $row;
             }
         }
 
         reset($rows);
         $conditions = array();
         foreach ($rows as $row) {
             if ($row["ref_handling"] == self::UNIQUE_CONDITIONS) {
                 if ($row["target_ref_id"] != $a_target_ref_id) {
                     continue;
                 }
             }
             
             $row["id"] = $row["condition_id"];
             $conditions[] = $row;
         }
 
         // write conditions for target cache
         self::$cond_for_target_cache[$a_target_ref_id . ":" . $a_target_obj_id . ":" .
             $a_target_type] = $conditions;
 
         return $conditions;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ _getPersistedConditionsOfTrigger()

static ilConditionHandler::_getPersistedConditionsOfTrigger	(	$a_trigger_obj_type,
		$a_trigger_id
	)

static

Get all persisted conditions of trigger object Note: This only gets persisted conditions NOT (dynamic) conditions send by the parent container logic.

Definition at line 771 of file class.ilConditionHandler.php.

References $c, $conditions, $DIC, $ilDB, $location, $obligatory, $query, $res, $row, $tree, ilObject\_lookupObjId(), ilObject\_lookupType(), and ilDBConstants\FETCHMODE_OBJECT.

Referenced by ilObjCourseGrouping\_checkGroupingDependencies(), ilObjCourseGrouping\_getGroupingCourseIds(), ilObjCourseGrouping\_getGroupingItems(), ilObjCourseGrouping\deassign(), ilObjCourseGrouping\getAssignedItems(), and ilRBACTest\testConditions().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = "SELECT * FROM conditions " .
             "WHERE trigger_obj_id = " . $ilDB->quote($a_trigger_id, 'integer') . " " .
             " AND trigger_type = " . $ilDB->quote($a_trigger_obj_type, 'text');
 
         $res = $ilDB->query($query);
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             $tmp_array['id'] = $row->condition_id;
             $tmp_array['target_ref_id'] = $row->target_ref_id;
             $tmp_array['target_obj_id'] = $row->target_obj_id;
             $tmp_array['target_type'] = $row->target_type;
             $tmp_array['trigger_ref_id'] = $row->trigger_ref_id;
             $tmp_array['trigger_obj_id'] = $row->trigger_obj_id;
             $tmp_array['trigger_type'] = $row->trigger_type;
             $tmp_array['operator'] = $row->operator;
             $tmp_array['value'] = $row->value;
             $tmp_array['ref_handling'] = $row->ref_handling;
             $tmp_array['obligatory'] = $row->obligatory;
             $tmp_array['hidden_status'] = $row->hidden_status;
 
             $conditions[] = $tmp_array;
             unset($tmp_array);
         }
 
         return $conditions ? $conditions : array();
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ _isReferenceHandlingOptional()

static ilConditionHandler::_isReferenceHandlingOptional ( $a_type )

static

is reference handling optional

public

Parameters

string target type ILIAS obj type

Definition at line 142 of file class.ilConditionHandler.php.

References $a_type, $DIC, $location, $tree, ilObject\_lookupObjId(), and ilObject\_lookupType().

Referenced by ilConditionHandlerGUI\initFormCondition().

     {
         switch ($a_type) {
             case 'st':
                 return true;
             
             default:
                 return false;
         }
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ calculateEffectiveRequiredTriggers()

static ilConditionHandler::calculateEffectiveRequiredTriggers	(	$a_target_ref_id,
		$a_target_obj_id,
		$a_target_obj_type = `''`
	)

static

calculate number of obligatory items

Parameters

int	$a_target_ref_id
int	$a_target_obj_id

Returns: int

Definition at line 1109 of file class.ilConditionHandler.php.

References $DIC, $ilDB, and $result.

Referenced by ilInfoScreenGUI\addPreconditionSection(), and ilObjectListGUI\parseConditions().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         // Get all conditions
         $all = self::_getEffectiveConditionsOfTarget($a_target_ref_id, $a_target_obj_id, $a_target_obj_type);
         $opt = self::getEffectiveOptionalConditionsOfTarget($a_target_ref_id, $a_target_obj_id, $a_target_obj_type);
 
         $set_obl = 0;
         if (isset($all[0])) {
             $set_obl = $all[0]['num_obligatory'];
         }
 
         // existing value is valid
         if ($set_obl > 0 and
             $set_obl < count($all) and
             $set_obl > (count($all) - count($opt) + 1)) {
             return $set_obl;
         }
 
         if (count($opt)) {
             $result = count($all) - count($opt) + 1;
         } else {
             $result = count($all);
         }
         return $result;
     }

Here is the caller graph for this function:

◆ calculatePersistedRequiredTriggers()

static ilConditionHandler::calculatePersistedRequiredTriggers	(	$a_target_ref_id,
		$a_target_obj_id,
		$a_target_obj_type = `''`,
		$a_force_update = `false`
	)

static

calculate number of obligatory items

Parameters

int	$a_target_ref_id
int	$a_target_obj_id

Returns: int

Definition at line 1145 of file class.ilConditionHandler.php.

References $DIC, $ilDB, and $result.

Referenced by ilConditionHandlerGUI\saveObligatoryList().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         // Get all conditions
         $all = self::_getPersistedConditionsOfTarget($a_target_ref_id, $a_target_obj_id, $a_target_obj_type);
         $opt = self::getPersistedOptionalConditionsOfTarget($a_target_ref_id, $a_target_obj_id, $a_target_obj_type);
 
         $set_obl = 0;
         if (isset($all[0])) {
             $set_obl = $all[0]['num_obligatory'];
         }
         
         // existing value is valid
         if ($set_obl > 0 and
             $set_obl < count($all) and
             $set_obl > (count($all) - count($opt) + 1)) {
             return $set_obl;
         }
         
         if (count($opt)) {
             $result = count($all) - count($opt) + 1;
         } else {
             $result = count($all);
         }
         if ($a_force_update) {
             self::saveNumberOfRequiredTriggers($a_target_ref_id, $a_target_obj_id, $result);
         }
         return $result;
     }

Here is the caller graph for this function:

◆ checkCircle()

ilConditionHandler::checkCircle	(	$a_ref_id,
		$a_obj_id
	)

protected

Definition at line 1283 of file class.ilConditionHandler.php.

References _getPersistedConditionsOfTarget(), and getOperator().

Referenced by validate().

     {
         foreach (ilConditionHandler::_getPersistedConditionsOfTarget($a_ref_id, $a_obj_id) as $condition) {
             if ($condition['trigger_obj_id'] == $this->target_obj_id and $condition['operator'] == $this->getOperator()) {
                 $this->circle = true;
                 break;
             } else {
                 $this->checkCircle($condition['trigger_ref_id'], $condition['trigger_obj_id']);
             }
         }
         return $this->circle;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ checkExists()

ilConditionHandler::checkExists ( )

Definition at line 618 of file class.ilConditionHandler.php.

References $DIC, $ilDB, $query, $res, getOperator(), getTargetObjId(), getTargetRefId(), getTriggerObjId(), and getTriggerRefId().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         $query = "SELECT * FROM conditions " .
             "WHERE target_ref_id = " . $ilDB->quote($this->getTargetRefId(), 'integer') . " " .
             "AND target_obj_id = " . $ilDB->quote($this->getTargetObjId(), 'integer') . " " .
             "AND trigger_ref_id = " . $ilDB->quote($this->getTriggerRefId(), 'integer') . " " .
             "AND trigger_obj_id = " . $ilDB->quote($this->getTriggerObjId(), 'integer') . " " .
             "AND operator = " . $ilDB->quote($this->getOperator(), 'text');
         $res = $ilDB->query($query);
 
         return $res->numRows() ? true : false;
     }

Here is the call graph for this function:

◆ cloneDependencies()

static ilConditionHandler::cloneDependencies	(	$a_src_ref_id,
		$a_target_ref_id,
		$a_copy_id
	)

static

Definition at line 1296 of file class.ilConditionHandler.php.

References $conditions, $valid, ilCopyWizardOptions\_getInstance(), _getPersistedConditionsOfTarget(), ilObject\_lookupObjId(), and ilObject\_lookupType().

Referenced by ilObject\cloneDependencies().

     {
         include_once './Services/CopyWizard/classes/class.ilCopyWizardOptions.php';
         $cwo = ilCopyWizardOptions::_getInstance($a_copy_id);
         $mappings = $cwo->getMappings();
 
         $valid = 0;
         $conditions = ilConditionHandler::_getPersistedConditionsOfTarget($a_src_ref_id, ilObject::_lookupObjId($a_src_ref_id));
         foreach ($conditions as $con) {
             if ($mappings[$con['trigger_ref_id']]) {
                 $newCondition = new ilConditionHandler();
 
                 $target_obj = ilObject::_lookupObjId($a_target_ref_id);
                 $target_typ = ilObject::_lookupType($target_obj);
 
                 $newCondition->setTargetRefId($a_target_ref_id);
                 $newCondition->setTargetObjId($target_obj);
                 $newCondition->setTargetType($target_typ);
 
                 $trigger_ref = $mappings[$con['trigger_ref_id']];
                 $trigger_obj = ilObject::_lookupObjId($trigger_ref);
                 $trigger_typ = ilObject::_lookupType($trigger_obj);
 
                 $newCondition->setTriggerRefId($trigger_ref);
                 $newCondition->setTriggerObjId($trigger_obj);
                 $newCondition->setTriggerType($trigger_typ);
                 $newCondition->setOperator($con['operator']);
                 $newCondition->setValue($con['value']);
                 $newCondition->setReferenceHandlingType($con['ref_handling']);
                 $newCondition->setObligatory($con['obligatory']);
                 
                 // :TODO: not sure about this
                 $newCondition->setHiddenStatus(self::lookupPersistedHiddenStatusByTarget($a_src_ref_id));
                 
                 if ($newCondition->storeCondition()) {
                     $valid++;
                 }
             }
         }
         if ($valid) {
             $tgt_obj_id = ilObject::_lookupObjId($a_target_ref_id);
             
             // num_obligatory
             self::calculatePersistedRequiredTriggers($a_target_ref_id, $tgt_obj_id, ilObject::_lookupType($tgt_obj_id), true);
         }
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ delete()

ilConditionHandler::delete ( $a_ref_id )

delete all trigger and target entries This method is called from ilObject::delete() if an object os removed from trash

Definition at line 699 of file class.ilConditionHandler.php.

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

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         $query = "DELETE FROM conditions WHERE " .
             "target_ref_id = " . $ilDB->quote($a_ref_id, 'integer') . " " .
             "OR trigger_ref_id = " . $ilDB->quote($a_ref_id, 'integer');
         $res = $ilDB->manipulate($query);
 
         return true;
     }

◆ deleteByObjId()

ilConditionHandler::deleteByObjId ( $a_obj_id )

delete all trigger and target entries This method is called from ilObject::delete() if an object is removed from trash

Definition at line 716 of file class.ilConditionHandler.php.

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

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         $query = "DELETE FROM conditions WHERE " .
             "target_obj_id = " . $ilDB->quote($a_obj_id, 'integer') . " " .
             "OR trigger_obj_id = " . $ilDB->quote($a_obj_id, 'integer');
         $res = $ilDB->manipulate($query);
 
         return true;
     }

◆ deleteCondition()

ilConditionHandler::deleteCondition ( $a_id )

delete condition

Definition at line 733 of file class.ilConditionHandler.php.

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

Referenced by storeCondition().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = "DELETE FROM conditions " .
             "WHERE condition_id = " . $ilDB->quote($a_id, 'integer');
         $res = $ilDB->manipulate($query);
 
         return true;
     }

Here is the caller graph for this function:

◆ enableAutomaticValidation()

ilConditionHandler::enableAutomaticValidation ( $a_validate = true )

enable automated validation

Definition at line 479 of file class.ilConditionHandler.php.

References $DIC, $name, $t, $type, ilObjUserTracking\_enabledLearningProgress(), getOperatorsByTriggerType(), and ilObjectLP\isSupportedObjectType().

     {
         $this->validation = $a_validate;
     }

Here is the call graph for this function:

◆ getEffectiveOptionalConditionsOfTarget()

static ilConditionHandler::getEffectiveOptionalConditionsOfTarget	(	$a_target_ref_id,
		$a_target_obj_id,
		$a_obj_type = `''`
	)

static

Get optional conditions.

Parameters

int	$a_target_ref_id
int	$a_target_obj_id
string	$a_obj_type

Returns: array

Definition at line 1041 of file class.ilConditionHandler.php.

References $conditions.

Referenced by ilInfoScreenGUI\addPreconditionSection(), and ilObjectListGUI\parseConditions().

     {
         $conditions = self::_getEffectiveConditionsOfTarget($a_target_ref_id, $a_target_obj_id);
         
         $opt = array();
         foreach ($conditions as $con) {
             if ($con['obligatory']) {
                 continue;
             }
             
             $opt[] = $con;
         }
         return $opt;
     }

Here is the caller graph for this function:

◆ getErrorMessage()

ilConditionHandler::getErrorMessage ( )

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

References $error_message.

     {
         return $this->error_message;
     }

◆ getHiddenStatus()

ilConditionHandler::getHiddenStatus ( )

Definition at line 470 of file class.ilConditionHandler.php.

References $hidden_status.

Referenced by storeCondition().

     {
         return $this->hidden_status;
     }

Here is the caller graph for this function:

◆ getNumberOfConditionsOfTrigger()

static ilConditionHandler::getNumberOfConditionsOfTrigger	(	$a_trigger_obj_type,
		$a_trigger_id
	)

static

get all conditions of trigger object

Parameters

string	$a_trigger_obj_type
int	$a_trigger_id

Returns: int

Exceptions

ilDatabaseException

Definition at line 754 of file class.ilConditionHandler.php.

References $db, $DIC, $query, $res, $row, ilDBConstants\FETCHMODE_OBJECT, ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

Referenced by ilScormLP\checkSCORMPreconditions().

     {
         global $DIC;
         $db = $DIC->database();
 
         $query = 'select count(*) num from conditions ' .
             'where trigger_obj_id = ' . $db->quote($a_trigger_id, ilDBConstants::T_INTEGER) . ' ' .
             'and trigger_type = ' . $db->quote($a_trigger_obj_type, ilDBConstants::T_TEXT);
         $res = $db->query($query);
         $row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT);
         return (int) $row->num;
     }

Here is the caller graph for this function:

◆ getObligatory()

ilConditionHandler::getObligatory ( )

Get obligatory status.

Returns: obligatory status

Definition at line 460 of file class.ilConditionHandler.php.

References $obligatory.

Referenced by storeCondition(), and updateCondition().

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

Here is the caller graph for this function:

◆ getOperator()

ilConditionHandler::getOperator ( )

get operator

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

References $operator.

Referenced by checkCircle(), checkExists(), storeCondition(), and updateCondition().

     {
         return $this->operator;
     }

Here is the caller graph for this function:

◆ getOperatorsByTriggerType()

ilConditionHandler::getOperatorsByTriggerType ( $a_type )

Get operators by trigger type.

Parameters

string $a_type

Returns: string[]

Definition at line 541 of file class.ilConditionHandler.php.

References $a_type, $DIC, $location, ilObjUserTracking\_enabledLearningProgress(), and ilObjectLP\isSupportedObjectType().

Referenced by enableAutomaticValidation().

     {
         global $DIC;
 
         $objDefinition = $DIC['objDefinition'];
         
         switch ($a_type) {
             case 'crsg':
                 return array('not_member');
         }
         
         $class = $objDefinition->getClassName($a_type);
         $location = $objDefinition->getLocation($a_type);
         $full_class = "ilObj" . $class . "Access";
         include_once($location . "/class." . $full_class . ".php");
         
         include_once './Services/Conditions/interfaces/interface.ilConditionHandling.php';
         
         $reflection = new ReflectionClass($full_class);
         if ($reflection->implementsInterface('ilConditionHandling')) {
             $operators = call_user_func(
                 array($full_class, 'getConditionOperators'),
                 $a_type
             );
         } else {
             $operators = [];
         }
         
         // Add operator lp
         include_once("Services/Tracking/classes/class.ilObjUserTracking.php");
         if (ilObjUserTracking::_enabledLearningProgress()) {
             // only if object type has lp
             include_once("Services/Object/classes/class.ilObjectLP.php");
             if (ilObjectLP::isSupportedObjectType($a_type)) {
                 array_unshift($operators, self::OPERATOR_LP);
             }
         }
         return $operators;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getPersistedOptionalConditionsOfTarget()

static ilConditionHandler::getPersistedOptionalConditionsOfTarget	(	$a_target_ref_id,
		$a_target_obj_id,
		$a_obj_type = `''`
	)

static

Get optional conditions.

Parameters

int	$a_target_ref_id
int	$a_target_obj_id
string	$a_obj_type

Returns: array

Definition at line 1063 of file class.ilConditionHandler.php.

References $conditions.

Referenced by ilConditionHandlerGUI\listConditions(), ilConditionHandlerGUI\saveObligatorySettings(), and ilConditionHandlerGUI\showObligatoryForm().

     {
         $conditions = self::_getPersistedConditionsOfTarget($a_target_ref_id, $a_target_obj_id);
 
         $opt = array();
         foreach ($conditions as $con) {
             if ($con['obligatory']) {
                 continue;
             }
 
             $opt[] = $con;
         }
         return $opt;
     }

Here is the caller graph for this function:

◆ getReferenceHandlingType()

ilConditionHandler::getReferenceHandlingType ( )

get reference handling type

public

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

Referenced by storeCondition(), and updateCondition().

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

Here is the caller graph for this function:

◆ getTargetObjId()

ilConditionHandler::getTargetObjId ( )

get target obj id

Definition at line 346 of file class.ilConditionHandler.php.

References $target_obj_id.

Referenced by checkExists(), and storeCondition().

     {
         return $this->target_obj_id;
     }

Here is the caller graph for this function:

◆ getTargetRefId()

ilConditionHandler::getTargetRefId ( )

get target ref id

Definition at line 330 of file class.ilConditionHandler.php.

References $target_ref_id.

Referenced by checkExists(), storeCondition(), updateCondition(), updateHiddenStatus(), and validate().

     {
         return $this->target_ref_id;
     }

Here is the caller graph for this function:

◆ getTargetType()

ilConditionHandler::getTargetType ( )

get target obj type

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

References $target_type.

Referenced by storeCondition().

     {
         return $this->target_type;
     }

Here is the caller graph for this function:

◆ getTriggerObjId()

ilConditionHandler::getTriggerObjId ( )

get trigger obj id

Definition at line 394 of file class.ilConditionHandler.php.

References $trigger_obj_id.

Referenced by checkExists(), and storeCondition().

     {
         return $this->trigger_obj_id;
     }

Here is the caller graph for this function:

◆ getTriggerRefId()

ilConditionHandler::getTriggerRefId ( )

get target ref id

Definition at line 378 of file class.ilConditionHandler.php.

References $trigger_ref_id.

Referenced by checkExists(), storeCondition(), and validate().

     {
         return $this->trigger_ref_id;
     }

Here is the caller graph for this function:

◆ getTriggerType()

ilConditionHandler::getTriggerType ( )

get trigger obj type

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

References $trigger_type.

Referenced by storeCondition().

     {
         return $this->trigger_type;
     }

Here is the caller graph for this function:

◆ getValue()

ilConditionHandler::getValue ( )

get value

Definition at line 442 of file class.ilConditionHandler.php.

References $value.

Referenced by storeCondition(), and updateCondition().

     {
         return $this->value;
     }

Here is the caller graph for this function:

◆ lookupObligatoryConditionsOfTarget()

static ilConditionHandler::lookupObligatoryConditionsOfTarget	(	$a_target_ref_id,
		$a_target_obj_id
	)

static

Lookup obligatory conditions of target.

Parameters

type	$a_target_ref_id
type	$a_target_obj_id

Definition at line 1084 of file class.ilConditionHandler.php.

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

Referenced by ilConditionHandlerGUI\showObligatoryForm().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         $query = 'SELECT max(num_obligatory) obl from conditions WHERE ' .
             'target_ref_id = ' . $ilDB->quote($a_target_ref_id, 'integer') . ' ' .
             'AND target_obj_id = ' . $ilDB->quote($a_target_obj_id, 'integer') . ' ' .
             'GROUP BY (num_obligatory)';
         $res = $ilDB->query($query);
         
         $obl = 0;
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             $obl = $row->obl;
         }
         return $obl;
     }

Here is the caller graph for this function:

◆ lookupPersistedHiddenStatusByTarget()

static ilConditionHandler::lookupPersistedHiddenStatusByTarget ( $a_target_ref_id )

static

Lookup persistedhidden status.

Parameters

int $a_target_ref_id

Returns: bool

Definition at line 192 of file class.ilConditionHandler.php.

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

Referenced by ilConditionHandlerGUI\assign(), and ilConditionHandlerGUI\showObligatoryForm().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         $query = 'SELECT hidden_status FROM conditions ' .
                 'WHERE target_ref_id = ' . $ilDB->quote($a_target_ref_id, 'integer');
         $res = $ilDB->query($query);
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             return $row->hidden_status;
         }
         return false;
     }

Here is the caller graph for this function:

◆ preloadPersistedConditionsForTargetRecords()

static ilConditionHandler::preloadPersistedConditionsForTargetRecords	(	$a_type,
		$a_obj_ids
	)

static

Preload conditions for target records.

Parameters

Definition at line 936 of file class.ilConditionHandler.php.

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

Referenced by ilObjectListGUIPreloader\preload().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         if (is_array($a_obj_ids) && count($a_obj_ids) > 0) {
             $res = $ilDB->query("SELECT * FROM conditions " .
                 "WHERE " . $ilDB->in("target_obj_id", $a_obj_ids, false, "integer") .
                 " AND target_type = " . $ilDB->quote($a_type, 'text'));
             $rows = array();
             while ($row = $ilDB->fetchAssoc($res)) {
                 self::$cond_target_rows[$a_type . ":" . $row["target_obj_id"]][]
                     = $row;
             }
             // init obj ids without any record
             foreach ($a_obj_ids as $obj_id) {
                 if (!is_array(self::$cond_target_rows[$a_type . ":" . $obj_id])) {
                     self::$cond_target_rows[$a_type . ":" . $obj_id] = array();
                 }
             }
         }
     }

Here is the caller graph for this function:

◆ saveNumberOfRequiredTriggers()

static ilConditionHandler::saveNumberOfRequiredTriggers	(	$a_target_ref_id,
		$a_target_obj_id,
		$a_num
	)

static

Save number of obigatory triggers.

Parameters

int	$a_target_ref_id
int	$a_target_obj_id

Definition at line 1183 of file class.ilConditionHandler.php.

References $DIC, $ilDB, and $query.

Referenced by ilConditionHandlerGUI\saveObligatorySettings().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = 'UPDATE conditions ' .
             'SET num_obligatory = ' . $ilDB->quote($a_num, 'integer') . ' ' .
             'WHERE target_ref_id = ' . $ilDB->quote($a_target_ref_id, 'integer') . ' ' .
             'AND target_obj_id = ' . $ilDB->quote($a_target_obj_id, 'integer');
         $ilDB->manipulate($query);
         return;
     }

Here is the caller graph for this function:

◆ setErrorMessage()

ilConditionHandler::setErrorMessage ( $a_msg )

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

Referenced by validate().

     {
         $this->error_message = $a_msg;
     }

Here is the caller graph for this function:

◆ setHiddenStatus()

ilConditionHandler::setHiddenStatus ( $a_status )

Definition at line 465 of file class.ilConditionHandler.php.

     {
         $this->hidden_status = $a_status;
     }

◆ setObligatory()

ilConditionHandler::setObligatory ( $a_obl )

Set obligatory status.

Parameters

bool $a_obl

Definition at line 451 of file class.ilConditionHandler.php.

     {
         $this->obligatory = $a_obl;
     }

◆ setOperator()

ilConditionHandler::setOperator ( $a_operator )

set operator

Definition at line 418 of file class.ilConditionHandler.php.

     {
         return $this->operator = $a_operator;
     }

◆ setReferenceHandlingType()

ilConditionHandler::setReferenceHandlingType ( $a_type )

set reference handling type

Parameters

int public

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

References $a_type.

     {
         return $this->condition_reference_type = $a_type;
     }

◆ setTargetObjId()

ilConditionHandler::setTargetObjId ( $a_target_obj_id )

set target object id

Definition at line 338 of file class.ilConditionHandler.php.

     {
         return $this->target_obj_id = $a_target_obj_id;
     }

◆ setTargetRefId()

ilConditionHandler::setTargetRefId ( $a_target_ref_id )

set target ref id

Definition at line 322 of file class.ilConditionHandler.php.

     {
         return $this->target_ref_id = $a_target_ref_id;
     }

◆ setTargetType()

ilConditionHandler::setTargetType ( $a_target_type )

set target object type

Definition at line 354 of file class.ilConditionHandler.php.

     {
         return $this->target_type = $a_target_type;
     }

◆ setTriggerObjId()

ilConditionHandler::setTriggerObjId ( $a_trigger_obj_id )

set trigger object id

Definition at line 386 of file class.ilConditionHandler.php.

     {
         return $this->trigger_obj_id = $a_trigger_obj_id;
     }

◆ setTriggerRefId()

ilConditionHandler::setTriggerRefId ( $a_trigger_ref_id )

set trigger ref id

Definition at line 370 of file class.ilConditionHandler.php.

     {
         return $this->trigger_ref_id = $a_trigger_ref_id;
     }

◆ setTriggerType()

ilConditionHandler::setTriggerType ( $a_trigger_type )

set trigger object type

Definition at line 402 of file class.ilConditionHandler.php.

     {
         return $this->trigger_type = $a_trigger_type;
     }

◆ setValue()

ilConditionHandler::setValue ( $a_value )

set value

Definition at line 434 of file class.ilConditionHandler.php.

     {
         return $this->value = $a_value;
     }

◆ storeCondition()

ilConditionHandler::storeCondition ( )

store new condition in database

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

References $DIC, $ilDB, $query, $res, deleteCondition(), getHiddenStatus(), getObligatory(), getOperator(), getReferenceHandlingType(), getTargetObjId(), getTargetRefId(), getTargetType(), getTriggerObjId(), getTriggerRefId(), getTriggerType(), getValue(), and validate().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         // first insert, then validate: it's easier to check for circles if the new condition is in the db table
         $next_id = $ilDB->nextId('conditions');
         $query = 'INSERT INTO conditions (condition_id,target_ref_id,target_obj_id,target_type,' .
             'trigger_ref_id,trigger_obj_id,trigger_type,operator,value,ref_handling,obligatory,hidden_status) ' .
             'VALUES (' .
             $ilDB->quote($next_id, 'integer') . ',' .
             $ilDB->quote($this->getTargetRefId(), 'integer') . "," .
             $ilDB->quote($this->getTargetObjId(), 'integer') . "," .
             $ilDB->quote($this->getTargetType(), 'text') . "," .
             $ilDB->quote($this->getTriggerRefId(), 'integer') . "," .
             $ilDB->quote($this->getTriggerObjId(), 'integer') . "," .
             $ilDB->quote($this->getTriggerType(), 'text') . "," .
             $ilDB->quote($this->getOperator(), 'text') . "," .
             $ilDB->quote($this->getValue(), 'text') . ", " .
             $ilDB->quote($this->getReferenceHandlingType(), 'integer') . ', ' .
             $ilDB->quote($this->getObligatory(), 'integer') . ', ' .
             $ilDB->quote($this->getHiddenStatus(), 'integer') . ' ' .
             ')';
 
         $res = $ilDB->manipulate($query);
 
         if ($this->validation && !$this->validate()) {
             $this->deleteCondition($next_id);
             return false;
         }
         return true;
     }

Here is the call graph for this function:

◆ updateCondition()

ilConditionHandler::updateCondition ( $a_id )

update condition

Definition at line 637 of file class.ilConditionHandler.php.

References $DIC, $ilDB, $query, $res, getObligatory(), getOperator(), getReferenceHandlingType(), getTargetRefId(), and getValue().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         $query = "UPDATE conditions SET " .
             "target_ref_id = " . $ilDB->quote($this->getTargetRefId(), 'integer') . ", " .
             "operator = " . $ilDB->quote($this->getOperator(), 'text') . ", " .
             "value = " . $ilDB->quote($this->getValue(), 'text') . ", " .
             "ref_handling = " . $this->db->quote($this->getReferenceHandlingType(), 'integer') . ", " .
             'obligatory = ' . $this->db->quote($this->getObligatory(), 'integer') . ' ' .
             "WHERE condition_id = " . $ilDB->quote($a_id, 'integer');
         $res = $ilDB->manipulate($query);
 
         return true;
     }

Here is the call graph for this function:

◆ updateHiddenStatus()

ilConditionHandler::updateHiddenStatus ( $a_status )

Update hidden status type $ilDB.

Parameters

type	$a_target_ref_id
type	$a_status

Returns: boolean

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

References $DIC, $ilDB, $query, and getTargetRefId().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         $query = 'UPDATE conditions SET ' .
                 'hidden_status = ' . $ilDB->quote($a_status, 'integer') . ' ' .
                 'WHERE target_ref_id = ' . $ilDB->quote($this->getTargetRefId(), 'integer');
         $ilDB->manipulate($query);
         return true;
     }

Here is the call graph for this function:

◆ updateObligatory()

static ilConditionHandler::updateObligatory	(	$a_id,
		$a_status
	)

static

Toggle condition obligatory status.

Parameters

int	$a_id
bool	$a_status

Definition at line 681 of file class.ilConditionHandler.php.

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

Referenced by ilConditionHandlerGUI\saveObligatoryList(), and ilConditionHandlerGUI\saveObligatorySettings().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         $query = "UPDATE conditions SET " .
             'obligatory = ' . $ilDB->quote($a_status, 'integer') . ' ' .
             "WHERE condition_id = " . $ilDB->quote($a_id, 'integer');
         $res = $ilDB->manipulate($query);
 
         return true;
     }

Here is the caller graph for this function:

◆ validate()

ilConditionHandler::validate ( )

protected

Definition at line 1247 of file class.ilConditionHandler.php.

References $DIC, $ilDB, $query, $res, checkCircle(), ilObjectFactory\getInstanceByRefId(), getTargetRefId(), getTriggerRefId(), and setErrorMessage().

Referenced by storeCondition().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         // check if obj_id is already assigned
         $trigger_obj = &ilObjectFactory::getInstanceByRefId($this->getTriggerRefId());
         $target_obj = &ilObjectFactory::getInstanceByRefId($this->getTargetRefId());
 
 
         $query = "SELECT * FROM conditions WHERE " .
             "trigger_ref_id = " . $ilDB->quote($trigger_obj->getRefId(), 'integer') . " " .
             "AND target_ref_id = " . $ilDB->quote($target_obj->getRefId(), 'integer');
 
         $res = $this->db->query($query);
         if ($res->numRows() > 1) {
             $this->setErrorMessage($this->lng->txt('condition_already_assigned'));
 
             unset($trigger_obj);
             unset($target_obj);
             return false;
         }
 
         // check for circle
         $this->target_obj_id = $target_obj->getId();
         if ($this->checkCircle($this->getTargetRefId(), $target_obj->getId())) {
             $this->setErrorMessage($this->lng->txt('condition_circle_created'));
             
             unset($trigger_obj);
             unset($target_obj);
             return false;
         }
         return true;
     }