class.ilECSNodeMappingAssignments.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */

include_once './Services/WebServices/ECS/classes/Mapping/class.ilECSNodeMappingAssignment.php';

class ilECSNodeMappingAssignments
{

        public static function hasAssignments($a_server_id, $a_mid, $a_tree_id)
        {
                global $ilDB;
                
                $query = 'SELECT ref_id FROM ecs_node_mapping_a '.
                        'WHERE server_id = '.$ilDB->quote($a_server_id,'integer'). ' '.
                        'AND mid = '.$ilDB->quote($a_mid,'integer').' '.
                        'AND cs_root = '.$ilDB->quote($a_tree_id,'integer').' '.
                        'AND ref_id > 0';
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        return true;
                }
                return false;
        }
        
        public static function lookupSettings($a_server_id, $a_mid, $a_tree_id, $a_node_id)
        {
                global $ilDB;
                
                $query = 'SELECT title_update, position_update, tree_update FROM ecs_node_mapping_a '.
                        'WHERE server_id = '.$ilDB->quote($a_server_id,'integer'). ' '.
                        'AND mid = '.$ilDB->quote($a_mid,'integer').' '.
                        'AND cs_root = '.$ilDB->quote($a_tree_id,'integer').' '.
                        'AND cs_id = '.$ilDB->quote($a_node_id,'integer');
                $res = $ilDB->query($query);
                
                if(!$res->numRows())
                {
                        return false;
                }
                
                $settings = array();
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $settings['title_update'] = $row->title_update;
                        $settings['position_update'] = $row->position_update;
                        $settings['tree_update'] = $row->tree_update;
                }
                return (array) $settings;
        }
        
        public static function lookupAssignmentIds($a_server_id, $a_mid, $a_tree_id)
        {
                global $ilDB;
                
                $query = 'SELECT cs_id FROM ecs_node_mapping_a '.
                        'WHERE server_id = '.$ilDB->quote($a_server_id,'integer'). ' '.
                        'AND mid = '.$ilDB->quote($a_mid,'integer').' '.
                        'AND cs_root = '.$ilDB->quote($a_tree_id,'integer').' '.
                        'AND ref_id > 0';
                $res = $ilDB->query($query);
                
                $assignments = array();
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $assignments[] = $row->cs_id;
                }
                return $assignments;
        }

        public static function lookupAssignmentsByRefId($a_server_id, $a_mid, $a_tree_id, $a_ref_id)
        {
                global $ilDB;

                $query = 'SELECT cs_id FROM ecs_node_mapping_a '.
                        'WHERE server_id = '.$ilDB->quote($a_server_id,'integer'). ' '.
                        'AND mid = '.$ilDB->quote($a_mid,'integer').' '.
                        'AND cs_root = '.$ilDB->quote($a_tree_id,'integer').' '.
                        'AND ref_id = '.$ilDB->quote($a_ref_id,'integer').' ';
                $res = $ilDB->query($query);

                $assignments = array();
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $assignments[] = $row->cs_id;
                }
                return $assignments;
        }


        public static function isWholeTreeMapped($a_server_id, $a_mid, $a_tree_id)
        {
                global $ilDB;

                $query = 'SELECT depth FROM ecs_node_mapping_a '.
                        'JOIN ecs_cms_tree ON (tree = cs_root AND child = cs_id) '.
                        'WHERE server_id = '.$ilDB->quote($a_server_id,'integer').' '.
                        'AND mid = '.$ilDB->quote($a_mid,'integer').' '.
                        'AND cs_root = '.$ilDB->quote($a_tree_id,'integer').' ';
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        return $row->depth == 1;
                }
                return false;
        }

        public static function lookupDefaultTitleUpdate($a_server_id, $a_mid, $a_tree_id)
        {
                global $ilDB;

                $query = 'SELECT title_update FROM ecs_node_mapping_a '.
                        'WHERE server_id = '.$ilDB->quote($a_server_id,'integer').' '.
                        'AND mid = '.$ilDB->quote($a_mid,'integer').' '.
                        'AND cs_root = '.$ilDB->quote($a_tree_id,'integer').' '.
                        'AND cs_id = '.$ilDB->quote(0,'integer').' ';
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        return (bool) $row->title_update;
                }
                return false;
        }

        public static function lookupMappedItemsForRefId($a_server_id, $a_mid, $a_tree_id, $a_ref_id)
        {
                global $ilDB;

                $query = 'SELECT cs_id FROM ecs_node_mapping_a '.
                        'WHERE server_id = '.$ilDB->quote($a_server_id,'integer').' '.
                        'AND mid = '.$ilDB->quote($a_mid,'integer').' '.
                        'AND cs_root = '.$ilDB->quote($a_tree_id,'integer').' '.
                        'AND ref_id = '.$ilDB->quote($a_ref_id,'integer').' ';
                $res = $ilDB->query($query);

                $cs_ids = array();
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $cs_ids[] = $row->cs_id;
                }
                return $cs_ids;
        }

        public static function deleteMappingsByCsId($a_server_id, $a_mid, $a_tree_id, $cs_ids)
        {
                global $ilDB;

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

        public static function deleteMappings($a_server_id, $a_mid, $a_tree_id)
        {
                global $ilDB;

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

        public static function deleteDisconnectableMappings($a_server_id, $a_mid, $a_tree_id, $a_ref_id)
        {
                global $ilDB;

                include_once './Services/WebServices/ECS/classes/Tree/class.ilECSCmsTree.php';
                include_once './Services/WebServices/ECS/classes/Tree/class.ilECSCmsData.php';

                $toDelete = array();
                foreach(self::lookupAssignmentsByRefId($a_server_id, $a_mid, $a_tree_id,$a_ref_id) as $assignment)
                {
                        $status = ilECSCmsData::lookupStatusByCmsId($a_server_id, $a_mid, $a_tree_id, $assignment);

                        switch($status)
                        {
                                case ilECSCmsData::MAPPING_UNMAPPED:
                                        $toDelete[] = $assignment;
                                        break;

                                case ilECSCmsData::MAPPING_PENDING_DISCONNECTABLE:
                                        $toDelete[] = $assignment;
                                        break;
                                case ilECSCmsData::MAPPING_PENDING_NOT_DISCONNECTABLE:
                                        break;

                                case ilECSCmsData::MAPPING_MAPPED:
                                        $toDelete[] = $assignment;
                                        break;

                                case ilECSCmsData::MAPPING_DELETED:
                                        $toDelete[] = $assignment;
                                        break;
                        }
                }
                self::deleteMappingsByCsId($a_server_id, $a_mid, $a_tree_id, $toDelete);
        }
}
?>