Handles conditions for accesses to different ILIAS objects. 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...

	getTriggerTypes ()
	get all possible trigger types NOT STATIC public More...

	getOperatorsByTargetType ($a_type)
	Get operators by target type. More...

	storeCondition ()
	store new condition in database NOT STATIC public 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...

	validate ()

	checkCircle ($a_ref_id, $a_obj_id)

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

static	lookupHiddenStatusByTarget ($a_target_ref_id)
	Lookup hidden status type $ilDB. 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	_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...

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

static	getNumberOfConditionsOfTrigger ($a_trigger_obj_type, $a_trigger_id)

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

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

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

static	_getCondition ($a_id)

static	_checkCondition ($a_id, $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	getOptionalConditionsOfTarget ($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	calculateRequiredTriggers ($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()

Private Attributes
	$obligatory = true

	$hidden_status = false

Detailed Description

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" | "qst", ... trigger_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" | "pg", ... target_id object or reference id of target object

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 66 of file class.ilConditionHandler.php.

Constructor & Destructor Documentation

◆ __construct()

ilConditionHandler::__construct ( )

constructor public

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

References $ilDB, $lng, and validation.

     {
         global $ilDB,$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 164 of file class.ilConditionHandler.php.

References $conditions.

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

     {
         global $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 966 of file class.ilConditionHandler.php.

References $conditions, $ilBench, $ilUser, _checkCondition(), _getConditionsOfTarget(), 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 $ilBench,$ilUser,$tree;
         
         $a_usr_id = $a_usr_id ? $a_usr_id : $ilUser->getId();
 
         $conditions = ilConditionHandler::_getConditionsOfTarget($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::getOptionalConditionsOfTarget($a_target_ref_id, $a_target_id, $a_target_type);
         $num_required = self::calculateRequiredTriggers($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['id'], $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	(	$a_id,
		$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 832 of file class.ilConditionHandler.php.

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

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

     {
         global $ilUser, $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 )

static

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 214 of file class.ilConditionHandler.php.

References $ilDB, $query, and $res.

Referenced by ilRBACTest\testConditions().

     {
         global $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 798 of file class.ilConditionHandler.php.

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

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

     {
         global $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:

◆ _getConditionsOfTarget()

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

static

get all conditions of target object

Parameters

$a_target_ref_id	target reference id
$a_target_obj_id	target object id
$a_target_type	target object type (must be provided only if object is not derived from ilObject and therefore stored in object_data; this is e.g. the case for chapters (type = "st"))

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

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

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

     {
         global $ilDB, $ilBench;
 
         // 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:

◆ _getConditionsOfTrigger()

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

static

get all conditions of trigger object

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

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

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

     {
         global $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 caller graph for this function:

◆ _getDistinctTargetRefIds()

static ilConditionHandler::_getDistinctTargetRefIds ( )

static

Get all target ref ids.

public

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

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

Referenced by ilRBACTest\testConditions().

     {
         global $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:

◆ _isReferenceHandlingOptional()

static ilConditionHandler::_isReferenceHandlingOptional ( $a_type )

static

is reference handling optional

public

Parameters

string target type ILIAS obj type

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

References $a_type.

Referenced by ilConditionHandlerGUI\initFormCondition().

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

Here is the caller graph for this function:

◆ calculateRequiredTriggers()

static ilConditionHandler::calculateRequiredTriggers	(	$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 915 of file class.ilConditionHandler.php.

References $ilDB, and $result.

Referenced by ilObjectListGUI\parseConditions(), and ilConditionHandlerGUI\saveObligatoryList().

     {
         global $ilDB;
 
         // Get all conditions
         $all = self::_getConditionsOfTarget($a_target_ref_id, $a_target_obj_id, $a_target_obj_type);
         $opt = self::getOptionalConditionsOfTarget($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
	)

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

References _getConditionsOfTarget(), and getOperator().

Referenced by validate().

     {
         foreach (ilConditionHandler::_getConditionsOfTarget($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 541 of file class.ilConditionHandler.php.

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

     {
         global $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 1057 of file class.ilConditionHandler.php.

References $conditions, $valid, _getConditionsOfTarget(), ilCopyWizardOptions\_getInstance(), 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::_getConditionsOfTarget($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::lookupHiddenStatusByTarget($a_src_ref_id));
                 
                 if ($newCondition->storeCondition()) {
                     $valid++;
                 }
             }
         }
         if ($valid) {
             $tgt_obj_id = ilObject::_lookupObjId($a_target_ref_id);
             
             // num_obligatory
             self::calculateRequiredTriggers($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 614 of file class.ilConditionHandler.php.

References $ilDB, $query, and $res.

     {
         global $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 629 of file class.ilConditionHandler.php.

References $ilDB, $query, and $res.

     {
         global $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 644 of file class.ilConditionHandler.php.

References $ilDB, $query, and $res.

Referenced by storeCondition().

     {
         global $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 418 of file class.ilConditionHandler.php.

References validation.

     {
         $this->validation = $a_validate;
     }

◆ getErrorMessage()

ilConditionHandler::getErrorMessage ( )

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

References $error_message.

     {
         return $this->error_message;
     }

◆ getHiddenStatus()

ilConditionHandler::getHiddenStatus ( )

Definition at line 409 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

Parameters

string	$a_trigger_obj_type
int	$a_trigger_id

Returns: int

Exceptions

ilDatabaseException

Definition at line 661 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 399 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 365 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:

◆ getOperatorsByTargetType()

ilConditionHandler::getOperatorsByTargetType ( $a_type )

Get operators by target type.

Parameters

string $a_type

Returns: type

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

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

Referenced by getTriggerTypes().

     {
         global $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/AccessControl/interfaces/interface.ilConditionHandling.php';
         
         $reflection = new ReflectionClass($full_class);
         if (!$reflection->implementsInterface('ilConditionHandling')) {
             return array();
         }
         
         
         $operators = call_user_func(
             array($full_class, 'getConditionOperators'),
             $a_type
         );
         
         // 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:

◆ getOptionalConditionsOfTarget()

static ilConditionHandler::getOptionalConditionsOfTarget	(	$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

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

References $conditions, and array.

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

     {
         $conditions = self::_getConditionsOfTarget($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 243 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 285 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 269 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 301 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 333 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 317 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 349 of file class.ilConditionHandler.php.

References $trigger_type.

Referenced by storeCondition().

     {
         return $this->trigger_type;
     }

Here is the caller graph for this function:

◆ getTriggerTypes()

ilConditionHandler::getTriggerTypes ( )

get all possible trigger types NOT STATIC public

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

References $name, $type, array, and getOperatorsByTargetType().

     {
         global $objDefinition;
         
         $trigger_types =  array('crs','exc','tst','sahs', 'svy', 'lm', 'iass', 'prg');
 
         foreach ($objDefinition->getPlugins() as $p_type => $p_info) {
             if (@include_once $p_info['location'] . '/class.ilObj' . $p_info['class_name'] . 'Access.php') {
                 include_once './Services/AccessControl/interfaces/interface.ilConditionHandling.php';
                 $name = 'ilObj' . $p_info['class_name'] . 'Access';
                 $reflection = new ReflectionClass($name);
                 if ($reflection->implementsInterface('ilConditionHandling')) {
                     $trigger_types[] = $p_type;
                 }
             }
         }
         
         
         $active_triggers = array();
         foreach ($trigger_types as $type) {
             if (count($this->getOperatorsByTargetType($type))) {
                 $active_triggers[] = $type;
             }
         }
         
         
         
         
         return $active_triggers;
     }

Here is the call graph for this function:

◆ getValue()

ilConditionHandler::getValue ( )

get value

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

References $value.

Referenced by storeCondition(), and updateCondition().

     {
         return $this->value;
     }

Here is the caller graph for this function:

◆ lookupHiddenStatusByTarget()

static ilConditionHandler::lookupHiddenStatusByTarget ( $a_target_ref_id )

static

Lookup hidden status type $ilDB.

Parameters

type $a_target_ref_id

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

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

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

     {
         global $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:

◆ 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 892 of file class.ilConditionHandler.php.

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

Referenced by ilConditionHandlerGUI\showObligatoryForm().

     {
         global $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:

◆ preloadConditionsForTargetRecords()

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

static

Preload conditions for target records.

Parameters

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

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

Referenced by ilObjectListGUIPreloader\preload().

     {
         global $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 951 of file class.ilConditionHandler.php.

References $ilDB, and $query.

Referenced by ilConditionHandlerGUI\saveObligatorySettings().

     {
         global $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 249 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 404 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 390 of file class.ilConditionHandler.php.

     {
         $this->obligatory = $a_obl;
     }

◆ setOperator()

ilConditionHandler::setOperator ( $a_operator )

set operator

Definition at line 357 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 232 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 277 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 261 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 293 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 325 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 309 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 341 of file class.ilConditionHandler.php.

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

◆ setValue()

ilConditionHandler::setValue ( $a_value )

set value

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

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

◆ storeCondition()

ilConditionHandler::storeCondition ( )

store new condition in database NOT STATIC public

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

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

     {
         global $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 558 of file class.ilConditionHandler.php.

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

     {
         global $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 581 of file class.ilConditionHandler.php.

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

     {
         global $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 598 of file class.ilConditionHandler.php.

References $ilDB, $query, and $res.

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

     {
         global $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 ( )

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

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

Referenced by storeCondition().

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