ilECSCmsData Class Reference

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.
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.
static	lookupTitle ($a_server_id, $a_mid, $a_tree_id)
	Lookup title by obj id.
static	lookupTopTerm ($a_server_id, $a_mid, $a_tree_id)
	Lookup term (highest term in cms tree) <type> $ilDB.
static	lookupStatusByObjId ($a_server_id, $a_mid, $a_tree_id, $obj_id)
	Lookup status.
static	lookupStatusByCmsId ($a_server_id, $a_mid, $a_tree_id, $cms_id)
	Lookup status.
static	updateStatus ($a_server_id, $a_mid, $a_tree_id)
static	lookupCmsId ($a_obj_id)
	Lookup cms id.
static	lookupCmsIds ($a_obj_ids)
static	lookupCmsIdsOfTree ($a_server_id, $a_mid, $a_tree_id)
	$ilDB $ilDB
static	writeStatus ($a_server_id, $a_mid, $a_tree_id, $cms_ids, $status)
	Update status $ilDB.
static	writeAllStatus ($a_server_id, $a_mid, $a_tree_id, $status)
	Update status $ilDB.
static	writeAllDeleted ($a_server_id, $a_mid, $a_tree_id, $a_deleted_flag)
	Write deleted status.
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:

class.ilECSCmsData.php 39298 2013-01-16 16:38:12Z smeyer

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

Constructor & Destructor Documentation

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

ilECSCmsData::delete

(

)

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

References $query.

        {
                global $ilDB;

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

static ilECSCmsData::deleteByServerId (   $a_server_id )

static

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

References $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:

ilECSCmsData::deleteTree

(

)

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

References $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);
        }

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, $query, $res, $row, and DB_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(DB_FETCHMODE_OBJECT))
                {
                        $deleted[] = $row->obj_id;
                }
                return $deleted;
        }

Here is the caller graph for this function:

ilECSCmsData::getCmsId

(

)

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

References $cms_id.

        {
                return $this->cms_id;
        }

ilECSCmsData::getMid

(

)

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

References $mid.

        {
                return $this->mid;
        }

ilECSCmsData::getObjId

(

)

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

References $obj_id.

        {
                return $this->obj_id;
        }

ilECSCmsData::getServerId

(

)

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

References $server_id.

        {
                return $this->server_id;
        }

ilECSCmsData::getStatus

(

)

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

References $status.

        {
                return $this->status;
        }

ilECSCmsData::getTerm

(

)

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

References $term.

        {
                return $this->term;
        }

ilECSCmsData::getTitle

(

)

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

References $title.

Referenced by ilECSNodeMappingTreeTableGUI\parse().

        {
                return $this->title;
        }

Here is the caller graph for this function:

ilECSCmsData::getTreeId

(

)

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

References $tree_id.

        {
                return $this->tree_id;
        }

ilECSCmsData::isDeleted

(

)

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

References $deleted.

Referenced by update().

        {
                return $this->deleted;
        }

Here is the caller graph for this function:

static ilECSCmsData::lookupCmsId (   $a_obj_id )

static

Lookup cms id.

Parameters

type

$a_obj_id

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

References lookupCmsIds().

Referenced by ilECSMappingSettingsGUI\dInitFormTreeSettings().

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

Here is the call graph for this function:

Here is the caller graph for this function:

static ilECSCmsData::lookupCmsIds (   $a_obj_ids )

static

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

References $query, $res, $row, and DB_FETCHMODE_OBJECT.

Referenced by lookupCmsId(), ilECSCourseCreationHandler\syncNodeToTop(), and updateStatus().

        {
                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(DB_FETCHMODE_OBJECT))
                {
                        $cms_ids[] = $row->cms_id;
                }
                return $cms_ids;
        }

Here is the caller graph for this function:

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

References $query, $res, $row, and DB_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(DB_FETCHMODE_OBJECT))
                {
                        $cms_ids[] = $row->cms_id;
                }
                return $cms_ids;
        }

Here is the caller graph for this function:

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, $query, $res, $row, and DB_FETCHMODE_OBJECT.

Referenced by ilECSCourseCreationHandler\syncParentContainer().

        {
                global $ilDB;

                $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,'integer'). ' '.
                        'ORDER BY tree_id ';
                $res = $ilDB->query($query);
                
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        return $row->tree_id;
                }
                return 0;
        }

Here is the caller graph for this function:

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, $query, $res, $row, and DB_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,'integer');
                $res = $ilDB->query($query);
                
                #$GLOBALS['ilLog']->write(__METHOD__.': '.$query);
                
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        return $row->obj_id;
                }
                return 0;
        }

Here is the caller graph for this function:

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

static

Lookup status.

Parameters

int

$a_obj_id

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

References $cms_id, $query, $res, $row, DB_FETCHMODE_OBJECT, and MAPPING_UNMAPPED.

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,'integer');
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        return $row->status;
                }
                return self::MAPPING_UNMAPPED;
        }

Here is the caller graph for this function:

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

static

Lookup status.

Parameters

int

$a_obj_id

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

References $obj_id, $query, $res, $row, DB_FETCHMODE_OBJECT, MAPPING_DELETED, and MAPPING_UNMAPPED.

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(DB_FETCHMODE_OBJECT))
                {
                        if($row->deleted)
                        {
                                return self::MAPPING_DELETED;
                        }
                        return $row->status;
                }
                return self::MAPPING_UNMAPPED;
        }

Here is the caller graph for this function:

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

References $query, $res, $row, and DB_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(DB_FETCHMODE_OBJECT))
                {
                        return $row->title;
                }
                return '';
        }

Here is the caller graph for this function:

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

References $query, $res, $row, and DB_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(DB_FETCHMODE_OBJECT))
                {
                        return $row->term;
                }
                return '';
        }

Here is the caller graph for this function:

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

static

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

References $query, $res, $row, and DB_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(DB_FETCHMODE_OBJECT))
                {
                        $tree_ids[] = $row->tid;
                }
                return (array) $tree_ids;
        }

Here is the caller graph for this function:

ilECSCmsData::read ( )

protected

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

References $query, $res, $row, and DB_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(DB_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:

ilECSCmsData::save

(

)

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

References $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,'integer').', '.
                        $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;
        }

ilECSCmsData::setCmsId

(

$a_id

)

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

        {
                $this->cms_id = $a_id;
        }

ilECSCmsData::setDeleted

(

$a_is_deleted

)

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

        {
                $this->deleted = $a_is_deleted;
        }

ilECSCmsData::setMid

(

$a_id

)

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

        {
                $this->mid = $a_id;
        }

ilECSCmsData::setObjId

(

$a_id

)

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

        {
                $this->obj_id = $a_id;
        }

ilECSCmsData::setServerId

(

$a_id

)

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

        {
                $this->server_id = $a_id;
        }

ilECSCmsData::setStatus

(

$a_status

)

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

        {
                $this->status = $a_status;
        }

ilECSCmsData::setTerm

(

$a_term

)

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

        {
                $this->term = $a_term;
        }

ilECSCmsData::setTitle

(

$a_title

)

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

        {
                $this->title = $a_title;
        }

ilECSCmsData::setTreeId

(

$a_id

)

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

        {
                $this->tree_id = $a_id;
        }

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

static

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

References $query, $res, $row, and DB_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(DB_FETCHMODE_OBJECT))
                {
                        return $row->num > 0 ? true : false;
                }
                return false;
        }

Here is the caller graph for this function:

ilECSCmsData::update

(

)

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

References $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:

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

static

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

References ilECSNodeMappingAssignments\lookupAssignmentIds(), lookupCmsIds(), writeAllStatus(), and writeStatus().

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:

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

References $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:

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

References $query, and $status.

Referenced by updateStatus().

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

Here is the caller graph for this function:

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

References $query, and $status.

Referenced by updateStatus().

        {
                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,'integer');
                $ilDB->manipulate($query);
                return true;
        }

Here is the caller graph for this function:

Field Documentation

ilECSCmsData::$cms_id

private

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

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

ilECSCmsData::$deleted = false

private

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

Referenced by findDeletedNodes(), and isDeleted().

ilECSCmsData::$mid

private

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

Referenced by getMid().

ilECSCmsData::$obj_id

private

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

Referenced by getObjId(), and lookupStatusByObjId().

ilECSCmsData::$server_id

private

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

Referenced by getServerId().

ilECSCmsData::$status = self::MAPPING_UNMAPPED

private

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

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

ilECSCmsData::$term

private

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

Referenced by getTerm().

ilECSCmsData::$title

private

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

Referenced by getTitle().

ilECSCmsData::$tree_id

private

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

Referenced by getTreeId().

const ilECSCmsData::MAPPING_DELETED = 5

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

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

const ilECSCmsData::MAPPING_MAPPED = 4

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

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

const ilECSCmsData::MAPPING_PENDING_DISCONNECTABLE = 2

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

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

const ilECSCmsData::MAPPING_PENDING_NOT_DISCONNECTABLE = 3

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

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

const ilECSCmsData::MAPPING_UNMAPPED = 1

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

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

---

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

• Services/WebServices/ECS/classes/Tree/class.ilECSCmsData.php