Collaboration diagram for ilECSCmsData:

Public Member Functions
	__construct ($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 ($a_server_id, $a_mid, $a_tree_id)

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

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

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

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

static	lookupTopTerm ($a_server_id, $a_mid, $a_tree_id)
	Lookup term (highest term in cms tree) <type> $ilDB. More...

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

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

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

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

static	lookupCmsIds ($a_obj_ids)

static	lookupCmsIdsOfTree ($a_server_id, $a_mid, $a_tree_id)
	$ilDB $ilDB More...

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

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

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

static	lookupTreeIds ($a_server_id, $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
	$obj_id

	$server_id

	$mid

	$tree_id

	$cms_id

	$title

	$term

	$status = self::MAPPING_UNMAPPED

	$deleted = false

Detailed Description

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

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

Constructor & Destructor Documentation

◆ __construct()

ilECSCmsData::__construct ( $a_obj_id = 0 )

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

References read().

         {
                 $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 506 of file class.ilECSCmsData.php.

References $ilDB, and $query.

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

◆ deleteByServerId()

static ilECSCmsData::deleteByServerId ( $a_server_id )

static

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

References $ilDB, and $query.

Referenced by ilECSSetting\delete().

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

References $ilDB, and $query.

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

◆ findDeletedNodes()

static ilECSCmsData::findDeletedNodes	(	$a_server_id,
		$a_mid,
		$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. $ilDB

Parameters

type	$a_server_id
type	$a_mid
type	$a_tree_id

Returns: type

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

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

Referenced by ilECSCmsTreeCommandQueueHandler\handleUpdate().

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

References $cms_id.

         {
                 return $this->cms_id;
         }

◆ getMid()

ilECSCmsData::getMid ( )

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

References $mid.

         {
                 return $this->mid;
         }

◆ getObjId()

ilECSCmsData::getObjId ( )

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

References $obj_id.

         {
                 return $this->obj_id;
         }

◆ getServerId()

ilECSCmsData::getServerId ( )

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

References $server_id.

         {
                 return $this->server_id;
         }

◆ getStatus()

ilECSCmsData::getStatus ( )

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

References $status.

         {
                 return $this->status;
         }

◆ getTerm()

ilECSCmsData::getTerm ( )

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

References $term.

         {
                 return $this->term;
         }

◆ getTitle()

ilECSCmsData::getTitle ( )

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

References $title.

Referenced by ilECSNodeMappingTreeTableGUI\parse().

         {
                 return $this->title;
         }

Here is the caller graph for this function:

◆ getTreeId()

ilECSCmsData::getTreeId ( )

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

References $tree_id.

         {
                 return $this->tree_id;
         }

◆ isDeleted()

ilECSCmsData::isDeleted ( )

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

References $deleted.

Referenced by update().

         {
                 return $this->deleted;
         }

Here is the caller graph for this function:

◆ lookupCmsId()

static ilECSCmsData::lookupCmsId ( $a_obj_id )

static

Lookup cms id.

Parameters

type $a_obj_id

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

References array.

Referenced by ilECSMappingSettingsGUI\dInitFormTreeSettings().

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

Here is the caller graph for this function:

◆ lookupCmsIds()

static ilECSCmsData::lookupCmsIds ( $a_obj_ids )

static

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

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

Referenced by ilECSCourseCreationHandler\syncNodeToTop().

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

$ilDB $ilDB

Parameters

type	$a_server_id
type	$a_mid
type	$a_tree_id

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

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

Referenced by ilECSMappingSettingsGUI\dDeleteTree().

         {
                 global $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 $ilDB $ilDB.

Parameters

type	$a_server_id
type	$a_mid
type	$cms_id

Returns: int

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

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

Referenced by ilECSCourseCreationHandler\syncParentContainer().

         {
                 global $ilDB;
                 
                 $GLOBALS['ilLog']->write(__METHOD__.':ASDUASDUASDU '.$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);
                 
                 while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                 {
                         return $row->tree_id;
                 }
                 return 0;
         }

Here is the caller graph for this function:

◆ lookupObjId()

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

static

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

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

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

         {
                 global $ilDB;
 
                 $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);
                 
                 $GLOBALS['ilLog']->write(__METHOD__.': '.$query);
                 
                 while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                 {
                         return $row->obj_id;
                 }
                 return 0;
         }

Here is the caller graph for this function:

◆ lookupStatusByCmsId()

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

static

Lookup status.

Parameters

int $a_obj_id

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

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

Referenced by ilECSNodeMappingAssignments\deleteDisconnectableMappings().

         {
                 global $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);
                 while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                 {
                         return $row->status;
                 }
                 return self::MAPPING_UNMAPPED;
         }

Here is the caller graph for this function:

◆ lookupStatusByObjId()

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

static

Lookup status.

Parameters

int $a_obj_id

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

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

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

         {
                 global $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);
                 while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                 {
                         if($row->deleted)
                         {
                                 return self::MAPPING_DELETED;
                         }
                         return $row->status;
                 }
                 return self::MAPPING_UNMAPPED;
         }

Here is the caller graph for this function:

◆ lookupTitle()

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

static

Lookup title by obj id.

Parameters

int $a_obj_id

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

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

Referenced by ilECSMappingSettingsGUI\dConfirmDeleteTree().

         {
                 global $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);
                 while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                 {
                         return $row->title;
                 }
                 return '';
         }

Here is the caller graph for this function:

◆ lookupTopTerm()

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

static

Lookup term (highest term in cms tree) <type> $ilDB.

Parameters

<type>	$a_server_id
<type>	$a_mid
<type>	$a_tree_id

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

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

Referenced by ilECSNodeMappingTreeTableGUI\parse().

         {
                 global $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);
                 while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                 {
                         return $row->term;
                 }
                 return '';
         }

Here is the caller graph for this function:

◆ lookupTreeIds()

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

static

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

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

Referenced by ilECSNodeMappingTreeTableGUI\parse().

         {
                 global $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 = array();
                 while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                 {
                         $tree_ids[] = $row->tid;
                 }
                 return (array) $tree_ids;
         }

Here is the caller graph for this function:

◆ read()

ilECSCmsData::read ( )

protected

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

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

Referenced by __construct().

         {
                 global $ilDB;
 
                 $query = 'SELECT * FROM ecs_cms_data '.
                         'WHERE obj_id = '.$ilDB->quote($this->obj_id,'integer');
                 $res = $ilDB->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 471 of file class.ilECSCmsData.php.

References $ilDB, and $query.

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

◆ setCmsId()

ilECSCmsData::setCmsId ( $a_id )

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

         {
                 $this->cms_id = $a_id;
         }

◆ setDeleted()

ilECSCmsData::setDeleted ( $a_is_deleted )

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

         {
                 $this->deleted = $a_is_deleted;
         }

◆ setMid()

ilECSCmsData::setMid ( $a_id )

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

         {
                 $this->mid = $a_id;
         }

◆ setObjId()

ilECSCmsData::setObjId ( $a_id )

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

         {
                 $this->obj_id = $a_id;
         }

◆ setServerId()

ilECSCmsData::setServerId ( $a_id )

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

         {
                 $this->server_id = $a_id;
         }

◆ setStatus()

ilECSCmsData::setStatus ( $a_status )

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

         {
                 $this->status = $a_status;
         }

◆ setTerm()

ilECSCmsData::setTerm ( $a_term )

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

         {
                 $this->term = $a_term;
         }

◆ setTitle()

ilECSCmsData::setTitle ( $a_title )

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

         {
                 $this->title = $a_title;
         }

◆ setTreeId()

ilECSCmsData::setTreeId ( $a_id )

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

         {
                 $this->tree_id = $a_id;
         }

◆ treeExists()

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

static

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

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

Referenced by ilECSTreeReader\read().

         {
                 global $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);
                 while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                 {
                         return $row->num > 0 ? true : false;
                 }
                 return false;
         }

Here is the caller graph for this function:

◆ update()

ilECSCmsData::update ( )

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

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

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

Here is the call graph for this function:

◆ updateStatus()

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

static

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

References array, and ilECSNodeMappingAssignments\lookupAssignmentIds().

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

         {
                 // 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
                 include_once './Services/WebServices/ECS/classes/Mapping/class.ilECSNodeMappingAssignments.php';
                 include_once './Services/WebServices/ECS/classes/Tree/class.ilECSCmsTree.php';
                 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.

Parameters

type	$a_server_id
type	$a_mid
type	$a_tree_id
type	$a_deleted_flag

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

References $ilDB, and $query.

Referenced by ilECSCmsTreeCommandQueueHandler\handleUpdate().

         {
                 global $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 $ilDB.

Parameters

<type>	$a_server_id
<type>	$a_mid
<type>	$a_tree_id
<type>	$cms_ids
<type>	$status

Returns: <type>

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

References $ilDB, $query, and $status.

         {
                 global $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 $ilDB.

Parameters

<type>	$a_server_id
<type>	$a_mid
<type>	$a_tree_id
<type>	$cms_ids
<type>	$status

Returns: <type>

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

References $ilDB, $query, and $status.

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

ilECSCmsData::$cms_id

private

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

Referenced by getCmsId(), lookupFirstTreeOfNode(), lookupObjId(), and lookupStatusByCmsId().

◆ $deleted

ilECSCmsData::$deleted = false

private

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

Referenced by findDeletedNodes(), and isDeleted().

◆ $mid

ilECSCmsData::$mid

private

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

Referenced by getMid().

◆ $obj_id

ilECSCmsData::$obj_id

private

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

Referenced by getObjId(), and lookupStatusByObjId().

◆ $server_id

ilECSCmsData::$server_id

private

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

Referenced by getServerId().

◆ $status

ilECSCmsData::$status = self::MAPPING_UNMAPPED

private

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

Referenced by getStatus(), writeAllStatus(), and writeStatus().

◆ $term

ilECSCmsData::$term

private

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

Referenced by getTerm().

◆ $title

ilECSCmsData::$title

private

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

Referenced by getTitle().

◆ $tree_id

ilECSCmsData::$tree_id

private

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

Referenced by getTreeId().

◆ MAPPING_DELETED

const ilECSCmsData::MAPPING_DELETED = 5

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

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

◆ MAPPING_MAPPED

const ilECSCmsData::MAPPING_MAPPED = 4

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

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

◆ MAPPING_PENDING_DISCONNECTABLE

const ilECSCmsData::MAPPING_PENDING_DISCONNECTABLE = 2

Definition at line 14 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 15 of file class.ilECSCmsData.php.

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

◆ MAPPING_UNMAPPED

const ilECSCmsData::MAPPING_UNMAPPED = 1

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

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

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

Services/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

◆ $deleted

◆ $mid

◆ $obj_id

◆ $server_id

◆ $status

◆ $term

◆ $title

◆ $tree_id

◆ MAPPING_DELETED

◆ MAPPING_MAPPED

◆ MAPPING_PENDING_DISCONNECTABLE

◆ MAPPING_PENDING_NOT_DISCONNECTABLE

◆ MAPPING_UNMAPPED