class.ilObjSession.php

Go to the documentation of this file.

<?php
 
/* Copyright (c) 1998-2010 ILIAS open source, Extended GPL, see docs/LICENSE */
 
include_once('./Modules/Session/classes/class.ilSessionAppointment.php');
include_once './Services/Membership/classes/class.ilMembershipRegistrationSettings.php';
 
class ilObjSession extends ilObject
{
        const CAL_REG_START = 1;
        
        protected $db;
        
        protected $location;
        protected $name;
        protected $phone;
        protected $email;
        protected $details;
        protected $registration;
        protected $event_id;
        
        protected $reg_type = ilMembershipRegistrationSettings::TYPE_NONE;
        protected $reg_limited = 0;
        protected $reg_limited_users = 0;
        protected $reg_waiting_list = 0;
 
 
        protected $appointments;
        protected $files = array();
        
 
        
        public function __construct($a_id = 0,$a_call_by_reference = true)
        {
                global $ilDB;
 
                $this->db = $ilDB;
                $this->type = "sess";
                parent::__construct($a_id,$a_call_by_reference);
        }
        
        public static function _lookupRegistrationEnabled($a_obj_id)
        {
                global $ilDB;
                
                $query = "SELECT reg_type FROM event ".
                        "WHERE obj_id = ".$ilDB->quote($a_obj_id ,'integer')." ";
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        return (bool) $row->reg_type != ilMembershipRegistrationSettings::TYPE_NONE;
                }
                return false;
        }
        
        public static function lookupSession($a_obj_id)
        {
                global $ilDB;
                
                $query = "SELECT * FROM event ".
                        "WHERE obj_id = ".$ilDB->quote($a_obj_id);
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $data['location']       = $row->location ? $row->location : '';
                        $data['details']        = $row->details ? $row->details : '';
                        $data['name']           = $row->tutor_name ? $row->tutor_name : '';
                        $data['email']          = $row->tutor_email ? $row->tutor_email : '';
                        $data['phone']          = $row->tutor_phone ? $row->tutor_phone : '';
                }
                return (array) $data;
        }
        
        public function getPresentationTitle()
        {
                $date = new ilDate($this->getFirstAppointment()->getStart()->getUnixTime(),IL_CAL_UNIX);
                if($this->getTitle())
                {
                        return ilDatePresentation::formatDate($this->getFirstAppointment()->getStart()).': '.$this->getTitle();                 
                }
                else
                {
                        return ilDatePresentation::formatDate($date);                   
                }
 
        }
        
        
        
        public function getEventId()
        {
                return $this->event_id;
        }
        
        public function setLocation($a_location)
        {
                $this->location = $a_location;
        }
        
        public function getLocation()
        {
                return $this->location;
        }
        
        public function setName($a_name)
        {
                $this->name = $a_name;
        }
        
        public function getName()
        {
                return $this->name;
        }
        
        public function setPhone($a_phone)
        {
                $this->phone = $a_phone;
        }
        
        public function getPhone()
        {
                return $this->phone;
        }
        
        public function setEmail($a_email)
        {
                $this->email = $a_email;
        }
        
        public function getEmail()
        {
                return $this->email;
        }
        
        public function hasTutorSettings()
        {
                return strlen($this->getName()) or 
                        strlen($this->getEmail()) or
                        strlen($this->getPhone());
        }
        
        
        public function setDetails($a_details)
        {
                $this->details = $a_details;
        }
        
        public function getDetails()
        {
                return $this->details;
        }
        
        public function setRegistrationType($a_type)
        {
                $this->reg_type = $a_type;
        }
        
        public function getRegistrationType()
        {
                return $this->reg_type;
        }
        
        public function isRegistrationUserLimitEnabled()
        {
                return $this->reg_limited;
        }
        
        public function enableRegistrationUserLimit($a_limit)
        {
                $this->reg_limited = $a_limit;
        }
        
        public function getRegistrationMaxUsers()
        {
                return $this->reg_limited_users;
        }
        
        public function setRegistrationMaxUsers($a_users)
        {
                $this->reg_limited_users = $a_users;
        }
        
        public function isRegistrationWaitingListEnabled()
        {
                return $this->reg_waiting_list;
        }
        
        public function enableRegistrationWaitingList($a_stat)
        {
                $this->reg_waiting_list = $a_stat;
        }
        
        
        
        public function enabledRegistration()
        {
                return $this->reg_type != ilMembershipRegistrationSettings::TYPE_NONE;
        }
        
        public function getAppointments()
        {
                return $this->appointments ? $this->appointments : array();
        }
        
        public function addAppointment($appointment)
        {
                $this->appointments[] = $appointment;
        }
        
        public function setAppointments($appointments)
        {
                $this->appointments = $appointments;
        }
 
        public function getFirstAppointment()
        {
                return is_object($this->appointments[0]) ? $this->appointments[0] : ($this->appointments[0] = new ilSessionAppointment());
        }
        
        public function getFiles()
        {
                return $this->files ? $this->files : array();
        }
        
        public function validate()
        {
                return true;
        }
        
        public function cloneObject($a_target_id,$a_copy_id = 0)
        {
                global $ilDB,$ilUser,$ilAppEventHandler;
                
                $new_obj = parent::cloneObject($a_target_id,$a_copy_id);
                
                $this->read();
                
                // Copy settings
                $this->cloneSettings($new_obj);
                
                // Clone appointment
                $new_app = $this->getFirstAppointment()->cloneObject($new_obj->getId());
                $new_obj->setAppointments(array($new_app));
                $new_obj->update();
 
                // Clone session files
                foreach($this->files as $file)
                {
                        $file->cloneFiles($new_obj->getEventId());
                }
                
                // Raise update forn new appointments
                
                
        
                // Copy learning progress settings
                include_once('Services/Tracking/classes/class.ilLPObjSettings.php');
                $obj_settings = new ilLPObjSettings($this->getId());
                $obj_settings->cloneSettings($new_obj->getId());
                unset($obj_settings);
                
                return $new_obj;
        }
        
        public function cloneSettings(ilObjSession $new_obj)
        {
                // @var 
                $new_obj->setLocation($this->getLocation());
                $new_obj->setName($this->getName());
                $new_obj->setPhone($this->getPhone());
                $new_obj->setEmail($this->getEmail());
                $new_obj->setDetails($this->getDetails());
                
                $new_obj->setRegistrationType($this->getRegistrationType());
                $new_obj->enableRegistrationUserLimit($this->isRegistrationUserLimitEnabled());
                $new_obj->enableRegistrationWaitingList($this->isRegistrationWaitingListEnabled());
                $new_obj->setRegistrationMaxUsers($this->getRegistrationMaxUsers());
                
                $new_obj->update();
                
                return true;
        }
        
        public function cloneDependencies($a_target_id,$a_copy_id)
        {
                global $ilObjDataCache;
                
                parent::cloneDependencies($a_target_id,$a_copy_id);
 
                $target_obj_id = $ilObjDataCache->lookupObjId($a_target_id);
                
                include_once('./Modules/Session/classes/class.ilEventItems.php');
                $session_materials = new ilEventItems($target_obj_id);
                $session_materials->cloneItems($this->getId(),$a_copy_id);
 
                return true;
        }
        
        
        
        public function create()
        {
                global $ilDB;
                global $ilAppEventHandler;
        
                parent::create();
                
                $next_id = $ilDB->nextId('event');
                $query = "INSERT INTO event (event_id,obj_id,location,tutor_name,tutor_phone,tutor_email,details,registration, ".
                        'reg_type, reg_limit_users, reg_limited,reg_waiting_list) '.
                        "VALUES( ".
                        $ilDB->quote($next_id,'integer').", ".
                        $this->db->quote($this->getId() ,'integer').", ".
                        $this->db->quote($this->getLocation() ,'text').",".
                        $this->db->quote($this->getName() ,'text').", ".
                        $this->db->quote($this->getPhone() ,'text').", ".
                        $this->db->quote($this->getEmail() ,'text').", ".
                        $this->db->quote($this->getDetails() ,'text').",".
                        $this->db->quote($this->enabledRegistration() ,'integer').", ".
                        $this->db->quote($this->getRegistrationType(),'integer').', '.
                        $this->db->quote($this->getRegistrationMaxUsers(),'integer').', '.
                        $this->db->quote($this->isRegistrationUserLimitEnabled(),'integer').', '.
                        $this->db->quote($this->isRegistrationWaitingListEnabled(),'integer').' '.
                        ")";
                $res = $ilDB->manipulate($query);
                $this->event_id = $next_id;
                
                $ilAppEventHandler->raise('Modules/Session',
                        'create',
                        array('object' => $this,
                                'obj_id' => $this->getId(),
                                'appointments' => $this->prepareCalendarAppointments('create')));
 
                return $this->getId();
        }
        
        public function update()
        {
                global $ilDB;
                global $ilAppEventHandler;
 
                if(!parent::update())
                {
                        return false;
                }
                $query = "UPDATE event SET ".
                        "location = ".$this->db->quote($this->getLocation() ,'text').",".
                        "tutor_name = ".$this->db->quote($this->getName() ,'text').", ".
                        "tutor_phone = ".$this->db->quote($this->getPhone() ,'text').", ".
                        "tutor_email = ".$this->db->quote($this->getEmail() ,'text').", ".
                        "details = ".$this->db->quote($this->getDetails() ,'text').", ".
                        "registration = ".$this->db->quote($this->enabledRegistration() ,'integer').", ".
                        "reg_type = ".$this->db->quote($this->getRegistrationType() ,'integer').", ".
                        "reg_limited = ".$this->db->quote($this->isRegistrationUserLimitEnabled() ,'integer').", ".
                        "reg_limit_users = ".$this->db->quote($this->getRegistrationMaxUsers() ,'integer').", ".
                        "reg_waiting_list = ".$this->db->quote($this->isRegistrationWaitingListEnabled(),'integer')." ".
                        "WHERE obj_id = ".$this->db->quote($this->getId() ,'integer')." ";
                $res = $ilDB->manipulate($query);
                
                $ilAppEventHandler->raise('Modules/Session',
                        'update',
                        array('object' => $this,
                                'obj_id' => $this->getId(),
                                'appointments' => $this->prepareCalendarAppointments('update')));
                return true;
        }
        
        public function delete()
        {
                global $ilDB;
                global $ilAppEventHandler;
                
                if(!parent::delete())
                {
                        return false;
                }
                $query = "DELETE FROM event ".
                        "WHERE obj_id = ".$this->db->quote($this->getId() ,'integer')." ";
                $res = $ilDB->manipulate($query);
                
                include_once('./Modules/Session/classes/class.ilSessionAppointment.php');
                ilSessionAppointment::_deleteBySession($this->getId());
                
                include_once('./Modules/Session/classes/class.ilEventItems.php');
                ilEventItems::_delete($this->getId());
                
                include_once('./Modules/Session/classes/class.ilEventParticipants.php');
                ilEventParticipants::_deleteByEvent($this->getId());
                
                foreach($this->getFiles() as $file)
                {
                        $file->delete();
                }
                
                $ilAppEventHandler->raise('Modules/Session',
                        'delete',
                        array('object' => $this,
                                'obj_id' => $this->getId(),
                                'appointments' => $this->prepareCalendarAppointments('delete')));
                
                
                return true;
        }
        
        public function read()
        {
                parent::read();
                
                $query = "SELECT * FROM event WHERE ".
                        "obj_id = ".$this->db->quote($this->getId() ,'integer')." ";
                $res = $this->db->query($query);
                
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $this->setLocation($row->location);
                        $this->setName($row->tutor_name);
                        $this->setPhone($row->tutor_phone);
                        $this->setEmail($row->tutor_email);
                        $this->setDetails($row->details);
                        $this->setRegistrationType($row->reg_type);
                        $this->enableRegistrationUserLimit($row->reg_limited);
                        $this->enableRegistrationWaitingList($row->reg_waiting_list);
                        $this->setRegistrationMaxUsers($row->reg_limit_users);
                        $this->event_id = $row->event_id;
                }
 
                $this->initAppointments();
                $this->initFiles();
        }
        
        protected function initAppointments()
        {
                // get assigned appointments
                include_once('./Modules/Session/classes/class.ilSessionAppointment.php');
                $this->appointments = ilSessionAppointment::_readAppointmentsBySession($this->getId());
        }
        
        public function initFiles()
        {
                include_once('./Modules/Session/classes/class.ilSessionFile.php');
                $this->files = ilSessionFile::_readFilesByEvent($this->getEventId());
        }
        
        
        public function prepareCalendarAppointments($a_mode = 'create')
        {
                include_once('./Services/Calendar/classes/class.ilCalendarAppointmentTemplate.php');
                
                switch($a_mode)
                {
                        case 'create':
                        case 'update':
 
                                $app = new ilCalendarAppointmentTemplate(self::CAL_REG_START);
                                $app->setTranslationType(IL_CAL_TRANSLATION_NONE);
                                $app->setTitle($this->getTitle() ? $this->getTitle() : $this->lng->txt('obj_sess'));
                                $app->setDescription($this->getLongDescription());
                                
                                $sess_app = $this->getFirstAppointment();
                                $app->setFullday($sess_app->isFullday());
                                $app->setStart($sess_app->getStart());
                                $app->setEnd($sess_app->getEnd());
                                $apps[] = $app;
 
                                return $apps;
                                
                        case 'delete':
                                // Nothing to do: The category and all assigned appointments will be deleted.
                                return array();
                }
        }
        
}
 
?>