class.ilCalendarCategory.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 ilCalendarCategory
{
    const LTYPE_LOCAL = 1;
    const LTYPE_REMOTE = 2;
    
    private static $instances = null;

    const DEFAULT_COLOR = '#04427e';
    
    const TYPE_USR = 1;         // user
    const TYPE_OBJ = 2;         // object
    const TYPE_GLOBAL = 3;      // global
    const TYPE_CH = 4;          // consultation hours
    const TYPE_BOOK = 5;        // booking manager
    
    protected static $SORTED_TYPES = array(
        0               => self::TYPE_GLOBAL,
        1               => self::TYPE_USR,
        2               => self::TYPE_CH,
        3               => self::TYPE_BOOK,
        4               => self::TYPE_OBJ
    );
    
    
    protected $cat_id;
    protected $color;
    protected $type = self::TYPE_USR;
    protected $obj_id;
    protected $obj_type = null;
    protected $title;
    
    protected $location = self::LTYPE_LOCAL;
    protected $remote_url;
    protected $remote_user;
    protected $remote_pass;
    protected $remote_sync = null;
    
    protected $db;
    
    
    public function __construct($a_cat_id = 0)
    {
        global $ilDB;
        
        $this->db = $ilDB;
        $this->cat_id = $a_cat_id;
        
        $this->read();
    }
    
    public static function _getInstanceByObjId($a_obj_id)
    {
        global $ilDB;
        
        $query = "SELECT cat_id FROM cal_categories " .
            "WHERE obj_id = " . $ilDB->quote($a_obj_id, 'integer') . " " .
            "AND type = " . $ilDB->quote(self::TYPE_OBJ, 'integer');
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return new ilCalendarCategory($row->cat_id);
        }
        return null;
    }

    public static function getInstanceByCategoryId($a_cat_id)
    {
        if (!self::$instances[$a_cat_id]) {
            return self::$instances[$a_cat_id] = new ilCalendarCategory($a_cat_id);
        }
        return self::$instances[$a_cat_id];
    }
     
    public static function lookupCategorySortIndex($a_type_id)
    {
        return array_search($a_type_id, self::$SORTED_TYPES);
    }
    public static function lookupAppointments($a_category_id)
    {
        global $ilDB;
    
        $query = "SELECT * FROM cal_cat_assignments " .
            'WHERE cat_id = ' . $ilDB->quote($a_category_id, 'integer');
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $apps[] = $row->cal_id;
        }
        return $apps ? $apps : array();
    }
    
    
    public function getCategoryID()
    {
        return $this->cat_id;
    }
    
    public function setTitle($a_title)
    {
        $this->title = $a_title;
    }
    
    public function getTitle()
    {
        return $this->title;
    }
    
    
    public function setColor($a_color)
    {
        $this->color = $a_color;
    }
    
    public function getColor()
    {
        return $this->color;
    }
    
    public function setType($a_type)
    {
        $this->type = $a_type;
    }
    
    public function getType()
    {
        return $this->type;
    }
    
    public function setObjId($a_obj_id)
    {
        $this->obj_id = $a_obj_id;
    }
    
    public function getObjId()
    {
        return $this->obj_id;
    }
    
    public function getObjType()
    {
        return $this->obj_type;
    }
    
    public function getLocationType()
    {
        return $this->location;
    }
    
    public function setLocationType($a_type)
    {
        $this->location = $a_type;
    }
    
    public function setRemoteUrl($a_url)
    {
        $this->remote_url = $a_url;
    }
    
    public function getRemoteUrl()
    {
        return $this->remote_url;
    }

    public function setRemoteUser($a_user)
    {
        $this->remote_user = $a_user;
    }
    
    public function getRemoteUser()
    {
        return $this->remote_user;
    }
    
    public function setRemotePass($a_pass)
    {
        $this->remote_pass = $a_pass;
    }
    
    public function getRemotePass()
    {
        return $this->remote_pass;
    }
    
    public function setRemoteSyncLastExecution(ilDateTime $dt = null)
    {
        $this->remote_sync = $dt;
    }
    
    public function getRemoteSyncLastExecution()
    {
        if ($this->remote_sync instanceof ilDateTime) {
            return $this->remote_sync;
        }
        return new ilDateTime();
    }

    
    public function add()
    {
        global $ilDB;

        $next_id = $ilDB->nextId('cal_categories');
        
        $query = "INSERT INTO cal_categories (cat_id,obj_id,color,type,title,loc_type,remote_url,remote_user,remote_pass,remote_sync) " .
            "VALUES ( " .
            $ilDB->quote($next_id, 'integer') . ", " .
            $this->db->quote($this->getObjId(), 'integer') . ", " .
            $this->db->quote($this->getColor(), 'text') . ", " .
            $this->db->quote($this->getType(), 'integer') . ", " .
            $this->db->quote($this->getTitle(), 'text') . ", " .
            $this->db->quote($this->getLocationType(), 'integer') . ', ' .
            $this->db->quote($this->getRemoteUrl(), 'text') . ', ' .
            $this->db->quote($this->getRemoteUser(), 'text') . ', ' .
            $this->db->quote($this->getRemotePass(), 'text') . ', ' .
            $this->db->quote($this->getRemoteSyncLastExecution()->get(IL_CAL_DATETIME, '', ilTimeZone::UTC), 'timestamp') . ' ' .
            ")";
        
        $ilDB->manipulate($query);

        $this->cat_id = $next_id;
        return $this->cat_id;
    }
    
    public function update()
    {
        global $ilDB;
        
        $query = "UPDATE cal_categories " .
            "SET obj_id = " . $this->db->quote($this->getObjId(), 'integer') . ", " .
            "color = " . $this->db->quote($this->getColor(), 'text') . ", " .
            "type = " . $this->db->quote($this->getType(), 'integer') . ", " .
            "title = " . $this->db->quote($this->getTitle(), 'text') . ", " .
            "loc_type = " . $this->db->quote($this->getLocationType(), 'integer') . ', ' .
            "remote_url = " . $this->db->quote($this->getRemoteUrl(), 'text') . ', ' .
            "remote_user = " . $this->db->quote($this->getRemoteUser(), 'text') . ', ' .
            "remote_pass = " . $this->db->quote($this->getRemotePass(), 'text') . ', ' .
            'remote_sync = ' . $this->db->quote($this->getRemoteSyncLastExecution()->get(IL_CAL_DATETIME, '', ilTimeZone::UTC), 'timestamp') . ' ' .
            "WHERE cat_id = " . $this->db->quote($this->cat_id, 'integer') . " ";
        $res = $ilDB->manipulate($query);
        return true;
    }

    public function delete()
    {
        global $ilDB;
        
        $query = "DELETE FROM cal_categories " .
            "WHERE cat_id = " . $this->db->quote($this->cat_id, 'integer') . " ";
        $res = $ilDB->manipulate($query);

        include_once('./Services/Calendar/classes/class.ilCalendarVisibility.php');
        ilCalendarVisibility::_deleteCategories($this->cat_id);
        
        include_once('./Services/Calendar/classes/class.ilCalendarCategoryAssignments.php');
        foreach (ilCalendarCategoryAssignments::_getAssignedAppointments(array($this->cat_id)) as $app_id) {
            include_once('./Services/Calendar/classes/class.ilCalendarEntry.php');
            ilCalendarEntry::_delete($app_id);
        }
        ilCalendarCategoryAssignments::_deleteByCategoryId($this->cat_id);
    }
    
    public function validate()
    {
        if ($this->getLocationType() == ilCalendarCategory::LTYPE_REMOTE and !$this->getRemoteUrl()) {
            return false;
        }
        if (strlen($this->getTitle()) and strlen($this->getColor()) and $this->getType()) {
            return true;
        }
        return false;
    }
    
    private function read()
    {
        global $ilDB;
        
        if (!$this->cat_id) {
            return true;
        }
        
        $query = "SELECT * FROM cal_categories " .
            "WHERE cat_id = " . $this->db->quote($this->getCategoryID(), 'integer') . " ";
        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $this->cat_id = $row->cat_id;
            $this->obj_id = $row->obj_id;
            $this->type = $row->type;
            $this->color = $row->color;
            $this->title = $row->title;
            $this->location = $row->loc_type;
            $this->remote_url = $row->remote_url;
            $this->remote_user = $row->remote_user;
            $this->remote_pass = $row->remote_pass;
            
            if ($row->remote_sync) {
                $this->remote_sync = new ilDateTime($row->remote_sync, IL_CAL_DATETIME, 'UTC');
            } else {
                $this->remote_sync = new ilDateTime();
            }
        }
        if ($this->getType() == self::TYPE_OBJ) {
            $this->title = ilObject::_lookupTitle($this->getObjId());
            $this->obj_type = ilObject::_lookupType($this->getObjId());
        }
    }
}