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 28 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 525 of file class.ilECSCmsData.php.

References $DIC, $ilDB, and $query.

     {
         global $DIC;
 
         $ilDB = $DIC['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 549 of file class.ilECSCmsData.php.

References $DIC, $ilDB, and $query.

Referenced by ilECSSetting\delete().

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

References $DIC, $ilDB, and $query.

     {
         global $DIC;
 
         $ilDB = $DIC['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, $DIC, $ilDB, $query, $res, $row, and ilDBConstants\FETCHMODE_OBJECT.

Referenced by ilECSCmsTreeCommandQueueHandler\handleUpdate().

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

References $cms_id.

     {
         return $this->cms_id;
     }

◆ getMid()

ilECSCmsData::getMid ( )

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

References $mid.

     {
         return $this->mid;
     }

◆ getObjId()

ilECSCmsData::getObjId ( )

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

References $obj_id.

     {
         return $this->obj_id;
     }

◆ getServerId()

ilECSCmsData::getServerId ( )

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

References $server_id.

     {
         return $this->server_id;
     }

◆ getStatus()

ilECSCmsData::getStatus ( )

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

References $status.

     {
         return $this->status;
     }

◆ getTerm()

ilECSCmsData::getTerm ( )

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

References $term.

     {
         return $this->term;
     }

◆ getTitle()

ilECSCmsData::getTitle ( )

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

References $tree_id.

     {
         return $this->tree_id;
     }

◆ isDeleted()

ilECSCmsData::isDeleted ( )

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

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 261 of file class.ilECSCmsData.php.

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

Referenced by ilECSCourseCreationHandler\syncNodeToTop().

     {
         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 = 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 285 of file class.ilECSCmsData.php.

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

Referenced by ilECSMappingSettingsGUI\dDeleteTree().

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

Parameters

type	$a_server_id
type	$a_mid
type	$cms_id

Returns: int

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

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

Referenced by ilECSCourseCreationHandler\syncParentContainer().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         $GLOBALS['DIC']['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 83 of file class.ilECSCmsData.php.

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

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

     {
         global $DIC;
 
         $ilDB = $DIC['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['DIC']['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 210 of file class.ilECSCmsData.php.

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

Referenced by ilECSNodeMappingAssignments\deleteDisconnectableMappings().

     {
         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);
         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 185 of file class.ilECSCmsData.php.

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

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

     {
         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);
         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 137 of file class.ilECSCmsData.php.

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

Referenced by ilECSMappingSettingsGUI\dConfirmDeleteTree().

     {
         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);
         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 161 of file class.ilECSCmsData.php.

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

Referenced by ilECSNodeMappingTreeTableGUI\parse().

     {
         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);
         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 376 of file class.ilECSCmsData.php.

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

Referenced by ilECSNodeMappingTreeTableGUI\parse().

     {
         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 = 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 560 of file class.ilECSCmsData.php.

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

Referenced by __construct().

     {
         global $DIC;
 
         $ilDB = $DIC['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 486 of file class.ilECSCmsData.php.

References $DIC, $ilDB, and $query.

     {
         global $DIC;
 
         $ilDB = $DIC['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 425 of file class.ilECSCmsData.php.

     {
         $this->cms_id = $a_id;
     }

◆ setDeleted()

ilECSCmsData::setDeleted ( $a_is_deleted )

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

     {
         $this->deleted = $a_is_deleted;
     }

◆ setMid()

ilECSCmsData::setMid ( $a_id )

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

     {
         $this->mid = $a_id;
     }

◆ setObjId()

ilECSCmsData::setObjId ( $a_id )

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

     {
         $this->obj_id = $a_id;
     }

◆ setServerId()

ilECSCmsData::setServerId ( $a_id )

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

     {
         $this->server_id = $a_id;
     }

◆ setStatus()

ilECSCmsData::setStatus ( $a_status )

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

     {
         $this->status = $a_status;
     }

◆ setTerm()

ilECSCmsData::setTerm ( $a_term )

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

     {
         $this->term = $a_term;
     }

◆ setTitle()

ilECSCmsData::setTitle ( $a_title )

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

     {
         $this->title = $a_title;
     }

◆ setTreeId()

ilECSCmsData::setTreeId ( $a_id )

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

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

Referenced by ilECSTreeReader\read().

     {
         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);
         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 510 of file class.ilECSCmsData.php.

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

     {
         global $DIC;
 
         $ilDB = $DIC['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 228 of file class.ilECSCmsData.php.

References 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 361 of file class.ilECSCmsData.php.

References $DIC, $ilDB, and $query.

Referenced by ilECSCmsTreeCommandQueueHandler\handleUpdate().

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

Parameters

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

Returns: <type>

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

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

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

Parameters

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

Returns: <type>

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

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

     {
         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

ilECSCmsData::$cms_id

private

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

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

◆ $deleted

ilECSCmsData::$deleted = false

private

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

Referenced by findDeletedNodes(), and isDeleted().

◆ $mid

ilECSCmsData::$mid

private

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

Referenced by getMid().

◆ $obj_id

ilECSCmsData::$obj_id

private

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

Referenced by getObjId(), and lookupStatusByObjId().

◆ $server_id

ilECSCmsData::$server_id

private

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

Referenced by getServerId().

◆ $status

ilECSCmsData::$status = self::MAPPING_UNMAPPED

private

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

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

◆ $term

ilECSCmsData::$term

private

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

Referenced by getTerm().

◆ $title

ilECSCmsData::$title

private

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

Referenced by getTitle().

◆ $tree_id

ilECSCmsData::$tree_id

private

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

Referenced by getTreeId().

◆ MAPPING_DELETED

const ilECSCmsData::MAPPING_DELETED = 5

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

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

◆ MAPPING_MAPPED

const ilECSCmsData::MAPPING_MAPPED = 4

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

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

◆ MAPPING_PENDING_DISCONNECTABLE

const ilECSCmsData::MAPPING_PENDING_DISCONNECTABLE = 2

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

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

◆ MAPPING_UNMAPPED

const ilECSCmsData::MAPPING_UNMAPPED = 1

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