Collaboration diagram for ilECSNodeMappingAssignments:

Static Public Member Functions
static	lookupSettings (int $a_server_id, int $a_mid, int $a_tree_id, int $a_node_id)
	Lookup Settings. More...

static	lookupAssignmentIds (int $a_server_id, int $a_mid, int $a_tree_id)
	Lookup assignments. More...

static	lookupAssignmentsByRefId (int $a_server_id, int $a_mid, int $a_tree_id, int $a_ref_id)
	Lookup assignments. More...

static	isWholeTreeMapped (int $a_server_id, int $a_mid, int $a_tree_id)
	Check if whole tree is mapped. More...

static	lookupDefaultTitleUpdate ($a_server_id, $a_mid, $a_tree_id)
	Lookup default title update setting. More...

static	lookupMappedItemsForRefId (int $a_server_id, int $a_mid, int $a_tree_id, int $a_ref_id)
	Get cs ids for ref_id. More...

static	deleteMappingsByCsId (int $a_server_id, int $a_mid, int $a_tree_id, array $cs_ids)
	Delete mappings. More...

static	deleteMappings (int $a_server_id, int $a_mid, int $a_tree_id)
	Delete mappings. More...

static	deleteDisconnectableMappings (int $a_server_id, int $a_mid, int $a_tree_id, int $a_ref_id)
	delete disconnectable mappings More...

Detailed Description

Author: Stefan Meyer smeye.nosp@m.r.il.nosp@m.ias@g.nosp@m.mx.d.nosp@m.e

Definition at line 24 of file class.ilECSNodeMappingAssignments.php.

Member Function Documentation

◆ deleteDisconnectableMappings()

static ilECSNodeMappingAssignments::deleteDisconnectableMappings	(	int	$a_server_id,
		int	$a_mid,
		int	$a_tree_id,
		int	$a_ref_id
	)

static

delete disconnectable mappings

Definition at line 228 of file class.ilECSNodeMappingAssignments.php.

References ilECSCmsData\lookupStatusByCmsId(), ilECSCmsData\MAPPING_DELETED, ilECSCmsData\MAPPING_MAPPED, ilECSCmsData\MAPPING_PENDING_DISCONNECTABLE, ilECSCmsData\MAPPING_PENDING_NOT_DISCONNECTABLE, and ilECSCmsData\MAPPING_UNMAPPED.

Referenced by ilECSMappingSettingsGUI\dMap().

                                                                                                                     : void
     {
         $toDelete = array();
         foreach (self::lookupAssignmentsByRefId($a_server_id, $a_mid, $a_tree_id, $a_ref_id) as $assignment) {
             $status = ilECSCmsData::lookupStatusByCmsId($a_server_id, $a_mid, $a_tree_id, $assignment);
 
             switch ($status) {
                 case ilECSCmsData::MAPPING_PENDING_DISCONNECTABLE:
                 case ilECSCmsData::MAPPING_MAPPED:
                 case ilECSCmsData::MAPPING_DELETED:
                 case ilECSCmsData::MAPPING_UNMAPPED:
                     $toDelete[] = $assignment;
                     break;
 
                 case ilECSCmsData::MAPPING_PENDING_NOT_DISCONNECTABLE:
                     break;
             }
         }
         self::deleteMappingsByCsId($a_server_id, $a_mid, $a_tree_id, $toDelete);
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ deleteMappings()

static ilECSNodeMappingAssignments::deleteMappings	(	int	$a_server_id,
		int	$a_mid,
		int	$a_tree_id
	)

static

Delete mappings.

Definition at line 211 of file class.ilECSNodeMappingAssignments.php.

References $DIC, and $ilDB.

Referenced by ilECSMappingSettingsGUI\dDeleteTree(), and ilECSCmsTreeCommandQueueHandler\handleDelete().

                                                                                        : bool
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = 'DELETE FROM ecs_node_mapping_a ' .
             'WHERE server_id = ' . $ilDB->quote($a_server_id) . ' ' .
             'AND mid = ' . $ilDB->quote($a_mid, 'integer') . ' ' .
             'AND cs_root = ' . $ilDB->quote($a_tree_id, 'integer') . ' ';
         $ilDB->manipulate($query);
         return true;
     }

Here is the caller graph for this function:

◆ deleteMappingsByCsId()

static ilECSNodeMappingAssignments::deleteMappingsByCsId	(	int	$a_server_id,
		int	$a_mid,
		int	$a_tree_id,
		array	$cs_ids
	)

static

Delete mappings.

Definition at line 193 of file class.ilECSNodeMappingAssignments.php.

References $DIC, and $ilDB.

Referenced by ilECSMappingSettingsGUI\dMap().

                                                                                                             : bool
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = 'DELETE FROM ecs_node_mapping_a ' .
             'WHERE server_id = ' . $ilDB->quote($a_server_id) . ' ' .
             'AND mid = ' . $ilDB->quote($a_mid, 'integer') . ' ' .
             'AND cs_root = ' . $ilDB->quote($a_tree_id, 'integer') . ' ' .
             'AND ' . $ilDB->in('cs_id', $cs_ids, false, 'integer');
         $ilDB->manipulate($query);
         return true;
     }

Here is the caller graph for this function:

◆ isWholeTreeMapped()

static ilECSNodeMappingAssignments::isWholeTreeMapped	(	int	$a_server_id,
		int	$a_mid,
		int	$a_tree_id
	)

static

Check if whole tree is mapped.

Definition at line 128 of file class.ilECSNodeMappingAssignments.php.

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

Referenced by ilECSMappingUtils\lookupMappingStatus().

                                                                                           : bool
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = 'SELECT depth FROM ecs_node_mapping_a ' .
             'JOIN ecs_cms_tree ON (tree = cs_root AND child = cs_id) ' .
             'WHERE server_id = ' . $ilDB->quote($a_server_id, 'integer') . ' ' .
             'AND mid = ' . $ilDB->quote($a_mid, 'integer') . ' ' .
             'AND cs_root = ' . $ilDB->quote($a_tree_id, 'integer') . ' ';
         $res = $ilDB->query($query);
         if ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             return $row->depth === 1;
         }
         return false;
     }

Here is the caller graph for this function:

◆ lookupAssignmentIds()

static ilECSNodeMappingAssignments::lookupAssignmentIds	(	int	$a_server_id,
		int	$a_mid,
		int	$a_tree_id
	)

static

Lookup assignments.

Definition at line 81 of file class.ilECSNodeMappingAssignments.php.

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

Referenced by ilECSCmsData\updateStatus().

                                                                                             : array
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = 'SELECT cs_id FROM ecs_node_mapping_a ' .
             'WHERE server_id = ' . $ilDB->quote($a_server_id, 'integer') . ' ' .
             'AND mid = ' . $ilDB->quote($a_mid, 'integer') . ' ' .
             'AND cs_root = ' . $ilDB->quote($a_tree_id, 'integer') . ' ' .
             'AND ref_id > 0';
         $res = $ilDB->query($query);
 
         $assignments = array();
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             $assignments[] = $row->cs_id;
         }
         return $assignments;
     }

Here is the caller graph for this function:

◆ lookupAssignmentsByRefId()

static ilECSNodeMappingAssignments::lookupAssignmentsByRefId	(	int	$a_server_id,
		int	$a_mid,
		int	$a_tree_id,
		int	$a_ref_id
	)

static

Lookup assignments.

Definition at line 104 of file class.ilECSNodeMappingAssignments.php.

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

                                                                                                                 : array
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = 'SELECT cs_id FROM ecs_node_mapping_a ' .
             'WHERE server_id = ' . $ilDB->quote($a_server_id, 'integer') . ' ' .
             'AND mid = ' . $ilDB->quote($a_mid, 'integer') . ' ' .
             'AND cs_root = ' . $ilDB->quote($a_tree_id, 'integer') . ' ' .
             'AND ref_id = ' . $ilDB->quote($a_ref_id, 'integer') . ' ';
         $res = $ilDB->query($query);
 
         $assignments = array();
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             $assignments[] = $row->cs_id;
         }
         return $assignments;
     }

◆ lookupDefaultTitleUpdate()

static ilECSNodeMappingAssignments::lookupDefaultTitleUpdate	(	$a_server_id,
		$a_mid,
		$a_tree_id
	)

static

Lookup default title update setting.

Definition at line 149 of file class.ilECSNodeMappingAssignments.php.

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

Referenced by ilECSMappingSettingsGUI\dMap().

                                                                                      : bool
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = 'SELECT title_update FROM ecs_node_mapping_a ' .
             'WHERE server_id = ' . $ilDB->quote($a_server_id, 'integer') . ' ' .
             'AND mid = ' . $ilDB->quote($a_mid, 'integer') . ' ' .
             'AND cs_root = ' . $ilDB->quote($a_tree_id, 'integer') . ' ' .
             'AND cs_id = ' . $ilDB->quote(0, 'integer') . ' ';
         $res = $ilDB->query($query);
         if ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             return (bool) $row->title_update;
         }
         return false;
     }

Here is the caller graph for this function:

◆ lookupMappedItemsForRefId()

static ilECSNodeMappingAssignments::lookupMappedItemsForRefId	(	int	$a_server_id,
		int	$a_mid,
		int	$a_tree_id,
		int	$a_ref_id
	)

static

Get cs ids for ref_id.

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

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

Referenced by ilECSMappingSettingsGUI\dShowCmsExplorer().

                                                                                                                  : array
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = 'SELECT cs_id FROM ecs_node_mapping_a ' .
             'WHERE server_id = ' . $ilDB->quote($a_server_id, 'integer') . ' ' .
             'AND mid = ' . $ilDB->quote($a_mid, 'integer') . ' ' .
             'AND cs_root = ' . $ilDB->quote($a_tree_id, 'integer') . ' ' .
             'AND ref_id = ' . $ilDB->quote($a_ref_id, 'integer') . ' ';
         $res = $ilDB->query($query);
 
         $cs_ids = array();
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             $cs_ids[] = $row->cs_id;
         }
         return $cs_ids;
     }

Here is the caller graph for this function:

◆ lookupSettings()

static ilECSNodeMappingAssignments::lookupSettings	(	int	$a_server_id,
		int	$a_mid,
		int	$a_tree_id,
		int	$a_node_id
	)

static

Lookup Settings.

Returns: array|false false in case of no specific setting available, array of settings

Definition at line 52 of file class.ilECSNodeMappingAssignments.php.

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

Referenced by ilECSCmsTreeSynchronizer\sync().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = 'SELECT title_update, position_update, tree_update FROM ecs_node_mapping_a ' .
             'WHERE server_id = ' . $ilDB->quote($a_server_id, 'integer') . ' ' .
             'AND mid = ' . $ilDB->quote($a_mid, 'integer') . ' ' .
             'AND cs_root = ' . $ilDB->quote($a_tree_id, 'integer') . ' ' .
             'AND cs_id = ' . $ilDB->quote($a_node_id, 'integer');
         $res = $ilDB->query($query);
 
         if (!$res->numRows()) {
             return false;
         }
 
         $settings = [];
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             $settings['title_update'] = $row->title_update;
             $settings['position_update'] = $row->position_update;
             $settings['tree_update'] = $row->tree_update;
         }
         return $settings;
     }

Here is the caller graph for this function:

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

components/ILIAS/WebServices/ECS/classes/Mapping/class.ilECSNodeMappingAssignments.php

Static Public Member Functions

Detailed Description

Member Function Documentation

◆ deleteDisconnectableMappings()

◆ deleteMappings()

◆ deleteMappingsByCsId()

◆ isWholeTreeMapped()

◆ lookupAssignmentIds()

◆ lookupAssignmentsByRefId()

◆ lookupDefaultTitleUpdate()

◆ lookupMappedItemsForRefId()

◆ lookupSettings()