class.ilBookingObject.php

Go to the documentation of this file.

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

class ilBookingObject
{
        protected $id;                  // int
        protected $pool_id;             // int
        protected $title;               // string
        protected $description; // string
        protected $nr_of_items; // int
        protected $schedule_id; // int
        protected $info_file; // string
        protected $post_text; // string
        protected $post_file; // string

        function __construct($a_id = NULL)
        {
                $this->id = (int)$a_id;
                $this->read();
        }
        
        function getId()
        {
                return $this->id;
        }

        function setTitle($a_title)
        {
                $this->title = $a_title;
        }

        function getTitle()
        {
                return $this->title;
        }
        
        function setDescription($a_value)
        {
                $this->description = $a_value;
        }

        function getDescription()
        {
                return $this->description;
        }

        function setPoolId($a_pool_id)
        {
                $this->pool_id = (int)$a_pool_id;
        }

        function getPoolId()
        {
                return $this->pool_id;
        }

        function setScheduleId($a_schedule_id)
        {
                $this->schedule_id = (int)$a_schedule_id;
        }

        function getScheduleId()
        {
                return $this->schedule_id;
        }
        
        function setNrOfItems($a_value)
        {
                $this->nr_of_items = (int)$a_value;
        }

        function getNrOfItems()
        {
                return $this->nr_of_items;
        }
        
        function setFile($a_value)
        {
                $this->info_file = $a_value;
        }

        function getFile()
        {
                return $this->info_file;
        }
        
        function getFileFullPath()
        {               
                if($this->id && $this->info_file)
                {
                        $path = $this->initStorage($this->id, "file");                  
                        return $path.$this->info_file;                  
                }
        }       
        
        function uploadFile(array $a_upload)
        {
                if(!$this->id)
                {
                        return false;
                }
                
                $this->deleteFile();
        
                $path = $this->initStorage($this->id, "file");
                $original = $a_upload["name"];
                if (ilUtil::moveUploadedFile($a_upload["tmp_name"], $original, $path.$original))
                {
                        chmod($path.$original, 0770);

                        $this->setFile($original);
                        return true;
                }
                return false;
        }       
        
        public function deleteFile()
        {
                if($this->id)
                {
                        $path = $this->getFileFullPath();
                        if($path)
                        {                       
                                @unlink($path);
                                $this->setFile(null);
                        }
                }
        }
        
        function setPostText($a_value)
        {
                $this->post_text = $a_value;
        }

        function getPostText()
        {
                return $this->post_text;
        }
        
        function setPostFile($a_value)
        {
                $this->post_file = $a_value;
        }

        function getPostFile()
        {
                return $this->post_file;
        }
                
        function getPostFileFullPath()
        {               
                if($this->id && $this->post_file)
                {
                        $path = $this->initStorage($this->id, "post");                  
                        return $path.$this->post_file;                  
                }
        }       
        
        function uploadPostFile(array $a_upload)
        {
                if(!$this->id)
                {
                        return false;
                }
                
                $this->deletePostFile();
        
                $path = $this->initStorage($this->id, "post");
                $original = $a_upload["name"];

                if (ilUtil::moveUploadedFile($a_upload["tmp_name"], $original, $path.$original))
                {
                        chmod($path.$original, 0770);

                        $this->setPostFile($original);
                        return true;
                }
                return false;
        }       
        
        public function deletePostFile()
        {
                if($this->id)
                {
                        $path = $this->getPostFileFullPath();
                        if($path)
                        {                       
                                @unlink($path);
                                $this->setPostFile(null);
                        }
                }
        }
        
        public function deleteFiles()
        {
                if($this->id)
                {
                        include_once "Modules/BookingManager/classes/class.ilFSStorageBooking.php";
                        $storage = new ilFSStorageBooking($this->id);
                        $storage->delete();
                        
                        $this->setFile(null);
                        $this->setPostFile(null);
                }
        }

        public static function initStorage($a_id, $a_subdir = null)
        {               
                include_once "Modules/BookingManager/classes/class.ilFSStorageBooking.php";
                $storage = new ilFSStorageBooking($a_id);
                $storage->create();
                
                $path = $storage->getAbsolutePath()."/";
                
                if($a_subdir)
                {
                        $path .= $a_subdir."/";
                        
                        if(!is_dir($path))
                        {
                                mkdir($path);
                        }
                }
                                
                return $path;
        }       

        protected function read()
        {
                global $ilDB;
                
                if($this->id)
                {
                        $set = $ilDB->query('SELECT *'.
                                ' FROM booking_object'.
                                ' WHERE booking_object_id = '.$ilDB->quote($this->id, 'integer'));
                        $row = $ilDB->fetchAssoc($set);
                        $this->setTitle($row['title']);
                        $this->setDescription($row['description']);
                        $this->setPoolId($row['pool_id']);
                        $this->setScheduleId($row['schedule_id']);
                        $this->setNrOfItems($row['nr_items']);
                        $this->setFile($row['info_file']);
                        $this->setPostText($row['post_text']);
                        $this->setPostFile($row['post_file']);
                }
        }
        
        protected function getDBFields()
        {
                $fields = array(
                        'title' => array('text', $this->getTitle()),
                        'description' => array('text', $this->getDescription()),
                        'schedule_id' => array('text', $this->getScheduleId()),
                        'nr_items' => array('text', $this->getNrOfItems()),                     
                        'info_file' => array('text', $this->getFile()),                 
                        'post_text' => array('text', $this->getPostText()),                     
                        'post_file' => array('text', $this->getPostFile())                      
                );
                
                return $fields;         
        }

        function save()
        {
                global $ilDB;

                if($this->id)
                {
                        return false;
                }
                
                $this->id = $ilDB->nextId('booking_object');
                
                $fields = $this->getDBFields();
                $fields['booking_object_id'] = array('integer', $this->id);
                $fields['pool_id'] = array('integer', $this->getPoolId());

                return $ilDB->insert('booking_object', $fields);
        }

        function update()
        {
                global $ilDB;

                if(!$this->id)
                {
                        return false;
                }
                
                $fields = $this->getDBFields();
                                                
                return $ilDB->update('booking_object', $fields, 
                        array('booking_object_id'=>array('integer', $this->id)));
        }

        static function getList($a_pool_id, $a_title = null)
        {
                global $ilDB;
                
                $sql = 'SELECT *'.
                        ' FROM booking_object'.
                        ' WHERE pool_id = '.$ilDB->quote($a_pool_id, 'integer');
                
                if($a_title)
                {
                        $sql .= ' AND ('.$ilDB->like('title', 'text', '%'.$a_title.'%').
                                ' OR '.$ilDB->like('description', 'text', '%'.$a_title.'%').')';
                }
                
                $sql .= ' ORDER BY title';

                $set = $ilDB->query($sql);
                $res = array();
                while($row = $ilDB->fetchAssoc($set))
                {
                        $res[] = $row;
                }
                return $res;
        }
        
        function delete()
        {
                global $ilDB;

                if($this->id)
                {
                        $this->deleteFiles();
                        
                        return $ilDB->manipulate('DELETE FROM booking_object'.
                                ' WHERE booking_object_id = '.$ilDB->quote($this->id, 'integer'));
                }
        }
        
        static function getNrOfItemsForObjects(array $a_obj_ids)
        {
                global $ilDB;
                
                $map = array();
                
                $set = $ilDB->query("SELECT booking_object_id,nr_items".
                        " FROM booking_object".
                        " WHERE ".$ilDB->in("booking_object_id", $a_obj_ids, "", "integer"));
                while($row = $ilDB->fetchAssoc($set))
                {
                        $map[$row["booking_object_id"]] = $row["nr_items"];
                }
                
                return $map;
        }       
        
        public function doClone($a_pool_id, $a_schedule_map = null)
        {
                $new_obj = new self();
                $new_obj->setPoolId($a_pool_id);
                $new_obj->setTitle($this->getTitle());
                $new_obj->setDescription($this->getDescription());
                $new_obj->setNrOfItems($this->getNrOfItems());  
                $new_obj->setFile($this->getFile());
                $new_obj->setPostText($this->getPostText());
                $new_obj->setPostFile($this->getPostFile());
                
                if($a_schedule_map)
                {
                        $schedule_id = $this->getScheduleId();
                        if($schedule_id)
                        {
                                $new_obj->setScheduleId($a_schedule_map[$schedule_id]);
                        }
                }
                
                $new_obj->save();       
                                
                // files
                $source = $this->initStorage($this->getId());
                $target = $new_obj->initStorage($new_obj->getId());             
                ilUtil::rCopy($source, $target);                
        }

        public static function lookupPoolId($object_id)
        {
                global $DIC;

                $db = $DIC->database();
                $set = $db->queryF("SELECT pool_id FROM booking_object ".
                        " WHERE booking_object_id = %s ",
                        array("integer"),
                        array($object_id)
                        );
                $rec = $db->fetchAssoc($set);
                return (int) $rec["pool_id"];
        }

}

?>