class.ilCalendarRegistration.php

Go to the documentation of this file.

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

class ilCalendarRegistration
{
        private $appointment_id = 0;
        
        private $registered = array();
        
        public function __construct($a_appointment_id)
        {
                $this->appointment_id = $a_appointment_id;
                
                $this->read();
        }
        
        public static function deleteByUser($a_usr_id)
        {
                global $ilDB;

                $query = "DELETE FROM cal_registrations ".
                        "WHERE usr_id = ".$ilDB->quote($a_usr_id,'integer');
                $ilDB->manipulate($query);
        }
        
        public static function deleteByAppointment($a_cal_id)
        {
                global $ilDB;

                $query = "DELETE FROM cal_registrations ".
                        "WHERE cal_id = ".$ilDB->quote($a_cal_id,'integer');
                $ilDB->manipulate($query);
        }
        
        public function getAppointmentId()
        {
                return $this->appointment_id;
        }
        
        public function getRegisteredUsers()
        {
                foreach($this->registered as $reg_data)
                {
                        if($reg_data['usr_id'] == $a_usr_id)
                        {
                                if($reg_data['dstart'] == $start->get(IL_CAL_UNIX) and $reg_data['dend'] == $end->get(IL_CAL_UNIX))
                                {
                                        return true;
                                }
                        }                       
                }
                return (array) $this->registered;
        }
        
        public function isRegistered($a_usr_id,ilDateTime $start, ilDateTime $end)
        {
                foreach($this->registered as $reg_data)
                {
                        if($reg_data['usr_id'] == $a_usr_id)
                        {
                                if($reg_data['dstart'] == $start->get(IL_CAL_UNIX) and $reg_data['dend'] == $end->get(IL_CAL_UNIX))
                                {
                                        return true;
                                }
                        }                       
                }
        }
        
        public function register($a_usr_id,ilDateTime $start, ilDateTime $end)
        {
                global $ilDB;
                
                $this->unregister($a_usr_id,$start,$end);
                
                $query = "INSERT INTO cal_registrations (cal_id,usr_id,dstart,dend) ".
                        "VALUES ( ".
                        $ilDB->quote($this->getAppointmentId(),'integer').", ".
                        $ilDB->quote($a_usr_id,'integer').", ".
                        $ilDB->quote($start->get(IL_CAL_UNIX),'integer').", ".
                        $ilDB->quote($end->get(IL_CAL_UNIX),'integer').
                        ")";
                $ilDB->manipulate($query);
                
                $this->registered[] = $a_usr_id;
                return true;
        }
        
        public function unregister($a_usr_id,ilDateTime $start, ilDateTime $end)
        {
                global $ilDB;
                
                $query = "DELETE FROM cal_registrations ".
                        "WHERE cal_id = ".$ilDB->quote($this->getAppointmentId(),'integer').' '.
                        "AND usr_id = ".$ilDB->quote($a_usr_id,'integer').' '.
                        "AND dstart = ".$ilDB->quote($start->get(IL_CAL_UNIX),'integer').' '.
                        "AND dend = ".$ilDB->quote($end->get(IL_CAL_UNIX),'integer');
                $res = $ilDB->manipulate($query);
        }
        
        
        protected function read()
        {
                global $ilDB;

                if(!$this->getAppointmentId())
                {
                        return false;
                }
                
                $query = "SELECT * FROM cal_registrations WHERE cal_id = ".$ilDB->quote($this->getAppointmentId(),'integer');
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                {
                        $this->registered[] = array(
                                'usr_id'=> $row->usr_id,
                                'dstart' =>$row->dstart,
                                'dend'  => $row->dend
                        ); 
                }
        }
}
?>