Collaboration diagram for ilECSCmsData:

Public Member Functions
	__construct (int $a_obj_id=0)

	setTitle ($a_title)

	getTitle ()

	setTerm ($a_term)

	getTerm ()

	setObjId ($a_id)

	getObjId ()

	setCmsId ($a_id)

	getCmsId ()

	setServerId ($a_id)

	getServerId ()

	setTreeId ($a_id)

	getTreeId ()

	setMid ($a_id)

	getMid ()

	setStatus ($a_status)

	getStatus ()

	setDeleted ($a_is_deleted)

	isDeleted ()

	save ()

	update ()

	delete ()

	deleteTree ()

Static Public Member Functions
static	treeExists (int $a_server_id, int $a_mid, int $a_tree_id)

static	findDeletedNodes (int $a_server_id, int $a_mid, int $a_tree_id)
	Find deleted nodes Uses a left join since this is more robust. More...

static	lookupObjId (int $a_server_id, int $a_mid, int $a_tree_id, string $cms_id)

static	lookupFirstTreeOfNode ($a_server_id, $a_mid, $cms_id)
	Lookup first obj_id of cms node. More...

static	lookupTitle (int $a_server_id, int $a_mid, int $a_tree_id)
	Lookup title by obj id. More...

static	lookupTopTerm (int $a_server_id, int $a_mid, int $a_tree_id)
	Lookup term (highest term in cms tree) More...

static	lookupStatusByObjId (int $a_server_id, int $a_mid, int $a_tree_id, int $obj_id)
	Lookup status. More...

static	lookupStatusByCmsId (int $a_server_id, int $a_mid, int $a_tree_id, string $cms_id)
	Lookup status. More...

static	updateStatus (int $a_server_id, int $a_mid, int $a_tree_id)

static	lookupCmsId ($a_obj_id)
	Lookup cms id. More...

static	lookupCmsIds (array $a_obj_ids)

static	lookupCmsIdsOfTree ($a_server_id, $a_mid, $a_tree_id)

static	writeStatus ($a_server_id, $a_mid, $a_tree_id, $cms_ids, $status)
	Update status. More...

static	writeAllStatus ($a_server_id, $a_mid, $a_tree_id, $status)
	Update status. More...

static	writeAllDeleted ($a_server_id, $a_mid, $a_tree_id, $a_deleted_flag)
	Write deleted status. More...

static	lookupTreeIds (int $a_server_id, int $a_mid)

static	deleteByServerId ($a_server_id)

Data Fields
const	MAPPING_UNMAPPED = 1

const	MAPPING_PENDING_DISCONNECTABLE = 2

const	MAPPING_PENDING_NOT_DISCONNECTABLE = 3

const	MAPPING_MAPPED = 4

const	MAPPING_DELETED = 5

Protected Member Functions
	read ()

Private Attributes
ilDBInterface	$db

int	$obj_id

int	$server_id

int	$mid

int	$tree_id

string	$cms_id

string	$title

string	$term

int	$status = self::MAPPING_UNMAPPED

bool	$deleted = false

Detailed Description

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

Definition at line 23 of file class.ilECSCmsData.php.

Constructor & Destructor Documentation

◆ __construct()

ilECSCmsData::__construct ( int $a_obj_id = 0 )

Definition at line 43 of file class.ilECSCmsData.php.

References $DIC, and read().

     {
         global $DIC;
         $this->db = $DIC->database();
 
         $this->obj_id = $a_obj_id;
         $this->read();
     }

Here is the call graph for this function:

Member Function Documentation

◆ delete()

ilECSCmsData::delete ( )

Definition at line 500 of file class.ilECSCmsData.php.

                             : void
     {
         $query = "DELETE FROM ecs_cms_data  " .
             'WHERE obj_id = ' . $this->db->quote($this->obj_id, 'integer');
         $this->db->manipulate($query);
     }

◆ deleteByServerId()

static ilECSCmsData::deleteByServerId ( $a_server_id )

static

Definition at line 516 of file class.ilECSCmsData.php.

References $DIC, and $ilDB.

Referenced by ilECSSetting\delete().

                                                          : void
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = "DELETE FROM ecs_cms_data  " .
             'WHERE server_id = ' . $ilDB->quote($a_server_id, 'integer');
         $ilDB->manipulate($query);
     }

Here is the caller graph for this function:

◆ deleteTree()

ilECSCmsData::deleteTree ( )

Definition at line 507 of file class.ilECSCmsData.php.

                                 : void
     {
         $query = "DELETE FROM ecs_cms_data  " .
             'WHERE server_id = ' . $this->db->quote($this->server_id, 'integer') . ' ' .
             'AND mid = ' . $this->db->quote($this->mid, 'integer') . ' ' .
             'AND tree_id = ' . $this->db->quote($this->tree_id, 'integer') . ' ';
         $this->db->manipulate($query);
     }

◆ findDeletedNodes()

static ilECSCmsData::findDeletedNodes	(	int	$a_server_id,
		int	$a_mid,
		int	$a_tree_id
	)

static

Find deleted nodes Uses a left join since this is more robust.

An alternative implementation could simply check the deleted flag in ecs_cms_data.

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

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

Referenced by ilECSCmsTreeCommandQueueHandler\handleUpdate().

                                                                                          : array
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = 'SELECT ed.obj_id obj_id FROM ecs_cms_data ed ' .
                 'LEFT JOIN ecs_cms_tree et ON ed.obj_id = et.child ' .
                 'WHERE et.child IS NULL ' .
                 'AND server_id = ' . $ilDB->quote($a_server_id, 'integer') . ' ' .
                 'AND mid = ' . $ilDB->quote($a_mid) . ' ' .
                 'AND tree_id  = ' . $ilDB->quote($a_tree_id);
         $res = $ilDB->query($query);
 
         $deleted = array();
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             $deleted[] = $row->obj_id;
         }
         return $deleted;
     }

Here is the caller graph for this function:

◆ getCmsId()

ilECSCmsData::getCmsId ( )

Definition at line 413 of file class.ilECSCmsData.php.

References $cms_id.

                               : string
     {
         return $this->cms_id;
     }

◆ getMid()

ilECSCmsData::getMid ( )

Definition at line 443 of file class.ilECSCmsData.php.

References $mid.

                             : int
     {
         return $this->mid;
     }

◆ getObjId()

ilECSCmsData::getObjId ( )

Definition at line 403 of file class.ilECSCmsData.php.

References $obj_id.

                               : int
     {
         return $this->obj_id;
     }

◆ getServerId()

ilECSCmsData::getServerId ( )

Definition at line 423 of file class.ilECSCmsData.php.

References $server_id.

                                  : int
     {
         return $this->server_id;
     }

◆ getStatus()

ilECSCmsData::getStatus ( )

Definition at line 453 of file class.ilECSCmsData.php.

References $status.

                                : int
     {
         return $this->status;
     }

◆ getTerm()

ilECSCmsData::getTerm ( )

Definition at line 393 of file class.ilECSCmsData.php.

References $term.

                              : string
     {
         return $this->term;
     }

◆ getTitle()

ilECSCmsData::getTitle ( )

Definition at line 383 of file class.ilECSCmsData.php.

References $title.

Referenced by ilECSNodeMappingTreeTableGUI\parse().

                               : string
     {
         return $this->title;
     }

Here is the caller graph for this function:

◆ getTreeId()

ilECSCmsData::getTreeId ( )

Definition at line 433 of file class.ilECSCmsData.php.

References $tree_id.

                                : int
     {
         return $this->tree_id;
     }

◆ isDeleted()

ilECSCmsData::isDeleted ( )

Definition at line 463 of file class.ilECSCmsData.php.

References $deleted.

Referenced by update().

                                : bool
     {
         return $this->deleted;
     }

Here is the caller graph for this function:

◆ lookupCmsId()

static ilECSCmsData::lookupCmsId ( $a_obj_id )

static

Lookup cms id.

Definition at line 254 of file class.ilECSCmsData.php.

Referenced by ilECSMappingSettingsGUI\dInitFormTreeSettings().

                                                  : string
     {
         $cms_ids = self::lookupCmsIds(array($a_obj_id));
         return $cms_ids[0];
     }

Here is the caller graph for this function:

◆ lookupCmsIds()

static ilECSCmsData::lookupCmsIds ( array $a_obj_ids )

static

Parameters

int[] $a_obj_ids

Returns: string[]

Definition at line 264 of file class.ilECSCmsData.php.

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

Referenced by ilECSCourseCreationHandler\syncNodeToTop().

                                                          : array
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = 'SELECT cms_id FROM ecs_cms_data ' .
             'WHERE ' . $ilDB->in('obj_id', $a_obj_ids, false, 'integer');
         $res = $ilDB->query($query);
 
         $cms_ids = [];
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             $cms_ids[] = $row->cms_id;
         }
         return $cms_ids;
     }

Here is the caller graph for this function:

◆ lookupCmsIdsOfTree()

static ilECSCmsData::lookupCmsIdsOfTree	(	$a_server_id,
		$a_mid,
		$a_tree_id
	)

static

Definition at line 281 of file class.ilECSCmsData.php.

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

Referenced by ilECSMappingSettingsGUI\dDeleteTree().

                                                                                : array
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = 'SELECT cms_id FROM ecs_cms_data ' .
                 'WHERE server_id = ' . $ilDB->quote($a_server_id, 'integer') . ' ' .
                 'AND mid = ' . $ilDB->quote($a_mid, 'integer') . ' ' .
                 'AND tree_id = ' . $ilDB->quote($a_tree_id, 'integer');
         $res = $ilDB->query($query);
         $cms_ids = array();
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             $cms_ids[] = $row->cms_id;
         }
         return $cms_ids;
     }

Here is the caller graph for this function:

◆ lookupFirstTreeOfNode()

static ilECSCmsData::lookupFirstTreeOfNode	(	$a_server_id,
		$a_mid,
		$cms_id
	)

static

Lookup first obj_id of cms node.

Definition at line 121 of file class.ilECSCmsData.php.

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

Referenced by ilECSCourseCreationHandler\syncParentContainer().

                                                                                : int
     {
         global $DIC;
 
         $ilDB = $DIC->database();
         $logger = $DIC->logger()->wsrv();
 
         $logger->debug($a_server_id . ' ' . $a_mid . ' ' . $cms_id);
 
         $query = 'SELECT tree_id FROM ecs_cms_data ' .
             'WHERE server_id = ' . $ilDB->quote($a_server_id, 'integer') . ' ' .
             'AND mid = ' . $ilDB->quote($a_mid, 'integer') . ' ' .
             'AND cms_id = ' . $ilDB->quote($cms_id, 'text') . ' ' .
             'ORDER BY tree_id ';
         $res = $ilDB->query($query);
 
         if ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             return $row->tree_id;
         }
         return 0;
     }

Here is the caller graph for this function:

◆ lookupObjId()

static ilECSCmsData::lookupObjId	(	int	$a_server_id,
		int	$a_mid,
		int	$a_tree_id,
		string	$cms_id
	)

static

Definition at line 96 of file class.ilECSCmsData.php.

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

Referenced by ilECSCmsTreeCommandQueueHandler\handleCreate(), ilECSCmsTreeCommandQueueHandler\handleUpdate(), ilECSTreeReader\storeTree(), and ilECSCourseCreationHandler\syncNodeToTop().

                                                                                                     : int
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         $logger = $DIC->logger()->wsrv();
 
         $query = 'SELECT obj_id FROM ecs_cms_data ' .
             'WHERE server_id = ' . $ilDB->quote($a_server_id, 'integer') . ' ' .
             'AND mid = ' . $ilDB->quote($a_mid, 'integer') . ' ' .
             'AND tree_id = ' . $ilDB->quote($a_tree_id, 'integer') . ' ' .
             'AND cms_id = ' . $ilDB->quote($cms_id, 'text');
         $res = $ilDB->query($query);
 
         $logger->debug($query);
 
         if ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             return $row->obj_id;
         }
         return 0;
     }

Here is the caller graph for this function:

◆ lookupStatusByCmsId()

static ilECSCmsData::lookupStatusByCmsId	(	int	$a_server_id,
		int	$a_mid,
		int	$a_tree_id,
		string	$cms_id
	)

static

Lookup status.

Definition at line 213 of file class.ilECSCmsData.php.

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

Referenced by ilECSNodeMappingAssignments\deleteDisconnectableMappings().

                                                                                                             : int
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = 'SELECT status FROM ecs_cms_data ' .
             'WHERE server_id = ' . $ilDB->quote($a_server_id, 'integer') . ' ' .
             'AND mid = ' . $ilDB->quote($a_mid, 'integer') . ' ' .
             'AND tree_id = ' . $ilDB->quote($a_tree_id, 'integer') . ' ' .
             'AND cms_id = ' . $ilDB->quote($cms_id, 'text');
         $res = $ilDB->query($query);
         if ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             return (int) $row->status;
         }
         return self::MAPPING_UNMAPPED;
     }

Here is the caller graph for this function:

◆ lookupStatusByObjId()

static ilECSCmsData::lookupStatusByObjId	(	int	$a_server_id,
		int	$a_mid,
		int	$a_tree_id,
		int	$obj_id
	)

static

Lookup status.

Definition at line 189 of file class.ilECSCmsData.php.

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

Referenced by ilECSNodeMappingCmsExplorer\buildFormItem(), and ilECSNodeMappingCmsExplorer\buildTitle().

                                                                                                          : int
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = 'SELECT status,deleted FROM ecs_cms_data ' .
             'WHERE server_id = ' . $ilDB->quote($a_server_id, 'integer') . ' ' .
             'AND mid = ' . $ilDB->quote($a_mid, 'integer') . ' ' .
             'AND tree_id = ' . $ilDB->quote($a_tree_id, 'integer') . ' ' .
             'AND obj_id = ' . $ilDB->quote($obj_id, 'integer');
         $res = $ilDB->query($query);
         if ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             if ($row->deleted) {
                 return self::MAPPING_DELETED;
             }
             return (int) $row->status;
         }
         return self::MAPPING_UNMAPPED;
     }

Here is the caller graph for this function:

◆ lookupTitle()

static ilECSCmsData::lookupTitle	(	int	$a_server_id,
		int	$a_mid,
		int	$a_tree_id
	)

static

Lookup title by obj id.

Definition at line 146 of file class.ilECSCmsData.php.

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

Referenced by ilECSMappingSettingsGUI\dConfirmDeleteTree().

                                                                                     : string
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = 'SELECT * FROM ecs_cms_data ' .
             'WHERE server_id = ' . $ilDB->quote($a_server_id, 'integer') . ' ' .
             'AND mid = ' . $ilDB->quote($a_mid, 'integer') . ' ' .
             'AND tree_id = ' . $ilDB->quote($a_tree_id, 'integer');
         $res = $ilDB->query($query);
         if ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             return $row->title;
         }
         return '';
     }

Here is the caller graph for this function:

◆ lookupTopTerm()

static ilECSCmsData::lookupTopTerm	(	int	$a_server_id,
		int	$a_mid,
		int	$a_tree_id
	)

static

Lookup term (highest term in cms tree)

Definition at line 166 of file class.ilECSCmsData.php.

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

Referenced by ilECSNodeMappingTreeTableGUI\parse().

                                                                                       : string
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = 'SELECT term FROM ecs_cms_data ' .
             'JOIN ecs_cms_tree ON obj_id = child ' .
             'WHERE tree = ' . $ilDB->quote($a_tree_id, 'integer') . ' ' .
             'AND server_id = ' . $ilDB->quote($a_server_id, 'integer') . ' ' .
             'AND mid = ' . $ilDB->quote($a_mid, 'integer') . ' ' .
             'AND tree_id = ' . $ilDB->quote($a_tree_id, 'integer') . ' ' .
             'ORDER BY depth';
         $res = $ilDB->query($query);
         if ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             return $row->term;
         }
         return '';
     }

Here is the caller graph for this function:

◆ lookupTreeIds()

static ilECSCmsData::lookupTreeIds	(	int	$a_server_id,
		int	$a_mid
	)

static

Parameters

int	$a_server_id
int	$a_mid

Returns: int[]

Definition at line 359 of file class.ilECSCmsData.php.

References $DIC, $ilDB, $res, ilDBConstants\FETCHMODE_OBJECT, and ILIAS\Repository\int().

Referenced by ilECSNodeMappingTreeTableGUI\parse().

                                                                       : array
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = 'SELECT DISTINCT(tree_id) tid FROM ecs_cms_data ' .
             'WHERE server_id = ' . $ilDB->quote($a_server_id, 'integer') . ' ' .
             'AND mid = ' . $ilDB->quote($a_mid, 'integer');
         $res = $ilDB->query($query);
 
         $tree_ids = [];
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             $tree_ids[] = (int) $row->tid;
         }
         return $tree_ids;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ read()

ilECSCmsData::read ( )

protected

Definition at line 527 of file class.ilECSCmsData.php.

References $res, and ilDBConstants\FETCHMODE_OBJECT.

Referenced by __construct().

                              : void
     {
         $query = 'SELECT * FROM ecs_cms_data ' .
             'WHERE obj_id = ' . $this->db->quote($this->obj_id, 'integer');
         $res = $this->db->query($query);
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             $this->title = $row->title;
             $this->term = $row->term;
             $this->server_id = $row->server_id;
             $this->mid = $row->mid;
             $this->tree_id = $row->tree_id;
             $this->cms_id = $row->cms_id;
             $this->status = $row->status;
             $this->deleted = $row->deleted;
         }
     }

Here is the caller graph for this function:

◆ save()

ilECSCmsData::save ( )

Definition at line 469 of file class.ilECSCmsData.php.

                           : bool
     {
         $this->obj_id = $this->db->nextId('ecs_cms_data');
 
         $query = 'INSERT INTO ecs_cms_data (obj_id,server_id,mid,tree_id,cms_id,title,term,status,deleted) ' .
             'VALUES ( ' .
             $this->db->quote($this->obj_id, 'integer') . ', ' .
             $this->db->quote($this->server_id, 'integer') . ', ' .
             $this->db->quote($this->mid, 'integer') . ', ' .
             $this->db->quote($this->tree_id, 'integer') . ', ' .
             $this->db->quote($this->cms_id, 'text') . ', ' .
             $this->db->quote($this->title, 'text') . ', ' .
             $this->db->quote($this->term, 'text') . ', ' .
             $this->db->quote($this->status, 'integer') . ', ' .
             $this->db->quote($this->deleted, 'integer') . ' ' .
             ')';
         $this->db->manipulate($query);
         return true;
     }

◆ setCmsId()

ilECSCmsData::setCmsId ( $a_id )

Definition at line 408 of file class.ilECSCmsData.php.

                                    : void
     {
         $this->cms_id = $a_id;
     }

◆ setDeleted()

ilECSCmsData::setDeleted ( $a_is_deleted )

Definition at line 458 of file class.ilECSCmsData.php.

                                              : void
     {
         $this->deleted = $a_is_deleted;
     }

◆ setMid()

ilECSCmsData::setMid ( $a_id )

Definition at line 438 of file class.ilECSCmsData.php.

                                  : void
     {
         $this->mid = $a_id;
     }

◆ setObjId()

ilECSCmsData::setObjId ( $a_id )

Definition at line 398 of file class.ilECSCmsData.php.

                                    : void
     {
         $this->obj_id = $a_id;
     }

◆ setServerId()

ilECSCmsData::setServerId ( $a_id )

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

                                       : void
     {
         $this->server_id = $a_id;
     }

◆ setStatus()

ilECSCmsData::setStatus ( $a_status )

Definition at line 448 of file class.ilECSCmsData.php.

                                         : void
     {
         $this->status = $a_status;
     }

◆ setTerm()

ilECSCmsData::setTerm ( $a_term )

Definition at line 388 of file class.ilECSCmsData.php.

                                     : void
     {
         $this->term = $a_term;
     }

◆ setTitle()

ilECSCmsData::setTitle ( $a_title )

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

                                       : void
     {
         $this->title = $a_title;
     }

◆ setTreeId()

ilECSCmsData::setTreeId ( $a_id )

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

                                     : void
     {
         $this->tree_id = $a_id;
     }

◆ treeExists()

static ilECSCmsData::treeExists	(	int	$a_server_id,
		int	$a_mid,
		int	$a_tree_id
	)

static

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

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

Referenced by ilECSTreeReader\read().

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

Here is the caller graph for this function:

◆ update()

ilECSCmsData::update ( )

Definition at line 489 of file class.ilECSCmsData.php.

References isDeleted().

                             : void
     {
         $query = "UPDATE ecs_cms_data SET " .
             'title = ' . $this->db->quote($this->title, 'text') . ', ' .
             'term = ' . $this->db->quote($this->term, 'text') . ', ' .
             'status = ' . $this->db->quote($this->status, 'text') . ', ' .
             'deleted = ' . $this->db->quote($this->isDeleted(), 'integer') . ' ' .
             'WHERE obj_id = ' . $this->db->quote($this->obj_id, 'integer');
         $this->db->manipulate($query);
     }

Here is the call graph for this function:

◆ updateStatus()

static ilECSCmsData::updateStatus	(	int	$a_server_id,
		int	$a_mid,
		int	$a_tree_id
	)

static

Definition at line 231 of file class.ilECSCmsData.php.

References ilECSNodeMappingAssignments\lookupAssignmentIds().

Referenced by ilECSMappingSettingsGUI\dInitEditTree(), and ilECSMappingSettingsGUI\dMap().

                                                                                      : void
     {
         // Set all status to pending unmapped
         self::writeAllStatus($a_server_id, $a_mid, $a_tree_id, self::MAPPING_UNMAPPED);
 
         // Set mapped for mapped and their descendent
         foreach (ilECSNodeMappingAssignments::lookupAssignmentIds($a_server_id, $a_mid, $a_tree_id) as $assignment) {
             $cmsTree = new ilECSCmsTree($a_tree_id);
             $subIds = self::lookupCmsIds(array_merge($cmsTree->getSubTreeIds($assignment), array($assignment)));
 
             self::writeStatus(
                 $a_server_id,
                 $a_mid,
                 $a_tree_id,
                 $subIds,
                 self::MAPPING_MAPPED
             );
         }
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ writeAllDeleted()

static ilECSCmsData::writeAllDeleted	(	$a_server_id,
		$a_mid,
		$a_tree_id,
		$a_deleted_flag
	)

static

Write deleted status.

Definition at line 339 of file class.ilECSCmsData.php.

References $DIC, and $ilDB.

Referenced by ilECSCmsTreeCommandQueueHandler\handleUpdate().

                                                                                              : bool
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = 'UPDATE ecs_cms_data ' .
             'SET deleted = ' . $ilDB->quote($a_deleted_flag, 'integer') . ' ' .
             'WHERE server_id = ' . $ilDB->quote($a_server_id, 'integer') . ' ' .
             'AND mid = ' . $ilDB->quote($a_mid, 'integer') . ' ' .
             'AND tree_id = ' . $ilDB->quote($a_tree_id, 'integer') . ' ';
         $ilDB->manipulate($query);
         return true;
     }

Here is the caller graph for this function:

◆ writeAllStatus()

static ilECSCmsData::writeAllStatus	(	$a_server_id,
		$a_mid,
		$a_tree_id,
		$status
	)

static

Update status.

Definition at line 321 of file class.ilECSCmsData.php.

References $DIC, and $ilDB.

                                                                                     : bool
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = 'UPDATE ecs_cms_data ' .
             'SET status = ' . $ilDB->quote($status, 'integer') . ' ' .
             'WHERE server_id = ' . $ilDB->quote($a_server_id, 'integer') . ' ' .
             'AND mid = ' . $ilDB->quote($a_mid, 'integer') . ' ' .
             'AND tree_id = ' . $ilDB->quote($a_tree_id, 'integer') . ' ';
         $ilDB->manipulate($query);
         return true;
     }

◆ writeStatus()

static ilECSCmsData::writeStatus	(	$a_server_id,
		$a_mid,
		$a_tree_id,
		$cms_ids,
		$status
	)

static

Update status.

Definition at line 302 of file class.ilECSCmsData.php.

References $DIC, and $ilDB.

                                                                                            : bool
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = 'UPDATE ecs_cms_data ' .
             'SET status = ' . $ilDB->quote($status, 'integer') . ' ' .
             'WHERE server_id = ' . $ilDB->quote($a_server_id, 'integer') . ' ' .
             'AND mid = ' . $ilDB->quote($a_mid, 'integer') . ' ' .
             'AND tree_id = ' . $ilDB->quote($a_tree_id, 'integer') . ' ' .
             'AND ' . $ilDB->in('cms_id', $cms_ids, false, 'text');
         $ilDB->manipulate($query);
         return true;
     }

Field Documentation

◆ $cms_id

string ilECSCmsData::$cms_id

private

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

Referenced by getCmsId().

◆ $db

ilDBInterface ilECSCmsData::$db

private

Definition at line 31 of file class.ilECSCmsData.php.

◆ $deleted

bool ilECSCmsData::$deleted = false

private

Definition at line 41 of file class.ilECSCmsData.php.

Referenced by findDeletedNodes(), and isDeleted().

◆ $mid

int ilECSCmsData::$mid

private

Definition at line 35 of file class.ilECSCmsData.php.

Referenced by getMid().

◆ $obj_id

int ilECSCmsData::$obj_id

private

Definition at line 33 of file class.ilECSCmsData.php.

Referenced by getObjId().

◆ $server_id

int ilECSCmsData::$server_id

private

Definition at line 34 of file class.ilECSCmsData.php.

Referenced by getServerId().

◆ $status

int ilECSCmsData::$status = self::MAPPING_UNMAPPED

private

Definition at line 40 of file class.ilECSCmsData.php.

Referenced by getStatus().

◆ $term

string ilECSCmsData::$term

private

Definition at line 39 of file class.ilECSCmsData.php.

Referenced by getTerm().

◆ $title

string ilECSCmsData::$title

private

Definition at line 38 of file class.ilECSCmsData.php.

Referenced by getTitle().

◆ $tree_id

int ilECSCmsData::$tree_id

private

Definition at line 36 of file class.ilECSCmsData.php.

Referenced by getTreeId().

◆ MAPPING_DELETED

const ilECSCmsData::MAPPING_DELETED = 5

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

Referenced by ilECSNodeMappingCmsExplorer\buildFormItem(), ilECSNodeMappingCmsExplorer\buildTitle(), and ilECSNodeMappingAssignments\deleteDisconnectableMappings().

◆ MAPPING_MAPPED

const ilECSCmsData::MAPPING_MAPPED = 4

Definition at line 28 of file class.ilECSCmsData.php.

Referenced by ilECSNodeMappingCmsExplorer\buildTitle(), and ilECSNodeMappingAssignments\deleteDisconnectableMappings().

◆ MAPPING_PENDING_DISCONNECTABLE

const ilECSCmsData::MAPPING_PENDING_DISCONNECTABLE = 2

Definition at line 26 of file class.ilECSCmsData.php.

Referenced by ilECSNodeMappingCmsExplorer\buildTitle(), and ilECSNodeMappingAssignments\deleteDisconnectableMappings().

◆ MAPPING_PENDING_NOT_DISCONNECTABLE

const ilECSCmsData::MAPPING_PENDING_NOT_DISCONNECTABLE = 3

Definition at line 27 of file class.ilECSCmsData.php.

Referenced by ilECSNodeMappingCmsExplorer\buildTitle(), and ilECSNodeMappingAssignments\deleteDisconnectableMappings().

◆ MAPPING_UNMAPPED

const ilECSCmsData::MAPPING_UNMAPPED = 1

Definition at line 25 of file class.ilECSCmsData.php.

Referenced by ilECSNodeMappingCmsExplorer\buildTitle(), and ilECSNodeMappingAssignments\deleteDisconnectableMappings().

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

components/ILIAS/WebServices/ECS/classes/Tree/class.ilECSCmsData.php

Public Member Functions

Static Public Member Functions

Data Fields

Protected Member Functions

Private Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ delete()

◆ deleteByServerId()

◆ deleteTree()

◆ findDeletedNodes()

◆ getCmsId()

◆ getMid()

◆ getObjId()

◆ getServerId()

◆ getStatus()

◆ getTerm()

◆ getTitle()

◆ getTreeId()

◆ isDeleted()

◆ lookupCmsId()

◆ lookupCmsIds()

◆ lookupCmsIdsOfTree()

◆ lookupFirstTreeOfNode()

◆ lookupObjId()

◆ lookupStatusByCmsId()

◆ lookupStatusByObjId()

◆ lookupTitle()

◆ lookupTopTerm()

◆ lookupTreeIds()

◆ read()

◆ save()

◆ setCmsId()

◆ setDeleted()

◆ setMid()

◆ setObjId()

◆ setServerId()

◆ setStatus()

◆ setTerm()

◆ setTitle()

◆ setTreeId()

◆ treeExists()

◆ update()

◆ updateStatus()

◆ writeAllDeleted()

◆ writeAllStatus()

◆ writeStatus()

Field Documentation

◆ $cms_id

◆ $db

◆ $deleted

◆ $mid

◆ $obj_id

◆ $server_id

◆ $status

◆ $term

◆ $title

◆ $tree_id

◆ MAPPING_DELETED

◆ MAPPING_MAPPED

◆ MAPPING_PENDING_DISCONNECTABLE

◆ MAPPING_PENDING_NOT_DISCONNECTABLE

◆ MAPPING_UNMAPPED