class.ilCalendarCategoryAssignments.php

Go to the documentation of this file.

<?php
/*
        +-----------------------------------------------------------------------------+
        | ILIAS open source                                                           |
        +-----------------------------------------------------------------------------+
        | Copyright (c) 1998-2006 ILIAS open source, University of Cologne            |
        |                                                                             |
        | This program is free software; you can redistribute it and/or               |
        | modify it under the terms of the GNU General Public License                 |
        | as published by the Free Software Foundation; either version 2              |
        | of the License, or (at your option) any later version.                      |
        |                                                                             |
        | This program is distributed in the hope that it will be useful,             |
        | but WITHOUT ANY WARRANTY; without even the implied warranty of              |
        | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the               |
        | GNU General Public License for more details.                                |
        |                                                                             |
        | You should have received a copy of the GNU General Public License           |
        | along with this program; if not, write to the Free Software                 |
        | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA. |
        +-----------------------------------------------------------------------------+
*/
 
class ilCalendarCategoryAssignments
{
        protected $db;
        
        protected $cal_entry_id = 0;
        protected $assignments = array();
 
        public function __construct($a_cal_entry_id)
        {
                global $ilDB;
                
                $this->db = $ilDB;
                $this->cal_entry_id = $a_cal_entry_id;
                
                $this->read();
        }
        
        public static function _lookupCategories($a_cal_id)
        {
                global $ilDB;
                
                $query = "SELECT cat_id FROM cal_cat_assignments ".
                        "WHERE cal_id = ".$ilDB->quote($a_cal_id ,'integer')." ";
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $cat_ids[] = $row->cat_id;
                }
                return $cat_ids ? $cat_ids : array();
        }
        
        public static function _lookupCategory($a_cal_id)
        {
                if(count($cats = self::_lookupCategories($a_cal_id)))
                {
                        return $cats[0];
                }
                return 0;
        }
 
        public static function _getAppointmentCalendars($a_cal_ids)
        {
                global $ilDB;
                
                $query = "SELECT * FROM cal_cat_assignments ".
                        "WHERE ".$ilDB->in('cal_id',$a_cal_ids,false,'integer');
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $map[$row->cal_id] = $row->cat_id;
                }
                return $map ? $map : array();
        }
        
        public static function _getAssignedAppointments($a_cat_id)
        {
                global $ilDB;
                
                $query = "SELECT * FROM cal_cat_assignments ".
                        "WHERE ".$ilDB->in('cat_id',$a_cat_id,false,'integer');
 
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $cal_ids[] = $row->cal_id;
                }
                return $cal_ids ? $cal_ids : array();
        }
        
        public static function lookupNumberOfAssignedAppointments($a_cat_ids)
        {
                global $ilDB;
                
                $query = 'SELECT COUNT(*) num FROM cal_cat_assignments '.
                                'WHERE '.$ilDB->in('cat_id', $a_cat_ids, false, 'integer');
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        return $row->num;
                }
                return 0;
        }
 
        public static function _getAutoGeneratedAppointmentsByObjId($a_obj_id)
        {
                global $ilDB;
                
                $query = "SELECT ce.cal_id FROM cal_categories cc ".
                        "JOIN cal_cat_assignments cca ON cc.cat_id = cca.cat_id ".
                        "JOIN cal_entries ce ON cca.cal_id = ce.cal_id ".
                        "WHERE auto_generated = 1 ".
                        "AND obj_id = ".$ilDB->quote($a_obj_id ,'integer')." ";
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $apps[] = $row->cal_id;
                }
                return $apps ? $apps : array();
        }
        
        public static function _deleteByAppointmentId($a_app_id)
        {
                global $ilDB;
                
                $query = "DELETE FROM cal_cat_assignments ".
                        "WHERE cal_id = ".$ilDB->quote($a_app_id ,'integer')." ";
                $res = $ilDB->manipulate($query);
                
                return true;
        }
        
        public static function _deleteByCategoryId($a_cat_id)
        {
                global $ilDB;
                
                $query = "DELETE FROM cal_cat_assignments ".
                        "WHERE cat_id = ".$ilDB->quote($a_cat_id ,'integer')." ";
                $res = $ilDB->manipulate($query);
                return true;
        }
        
        public function getFirstAssignment()
        {
                return isset($this->assignments[0]) ? $this->assignments[0] : false;
        }
        
        public function getAssignments()
        {
                return $this->assignments ? $this->assignments : array();
        }
        
        public function addAssignment($a_cal_cat_id)
        {
                global $ilDB;
                
                $query = "INSERT INTO cal_cat_assignments (cal_id,cat_id) ".
                        "VALUES ( ".
                        $this->db->quote($this->cal_entry_id ,'integer').", ".
                        $this->db->quote($a_cal_cat_id ,'integer')." ".
                        ")";
                $res = $ilDB->manipulate($query);
                $this->assignments[] = (int) $a_cal_cat_id;
                
                return true;
        }
        
        public function deleteAssignment($a_cat_id)
        {
                global $ilDB;
                
                $query = "DELETE FROM cal_cat_assignments ".
                        "WHERE cal_id = ".$this->db->quote($this->cal_entry_id ,'integer').", ".
                        "AND cat_id = ".$this->db->quote($a_cat_id ,'integer')." ";
                $res = $ilDB->manipulate($query);
                
                if(($key = array_search($a_cat_id,$this->assignments)) !== false)
                {
                        unset($this->assignments[$key]);
                }
                return true;
        }
        
        public function deleteAssignments()
        {
                global $ilDB;
                
                $query = "DELETE FROM cal_cat_assignments ".
                        "WHERE cal_id = ".$this->db->quote($this->cal_entry_id ,'integer')." ";
                $res = $ilDB->manipulate($query);
                return true;
        }
 
        
        private function read()
        {
                global $ilDB;
 
                $query = "SELECT * FROM cal_cat_assignments ".
                        "WHERE cal_id = ".$this->db->quote($this->cal_entry_id ,'integer')." ";
                
                $res = $this->db->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $this->assignments[] = $row->cat_id;
                }
        }
}
?>