class.ilBookingSchedule.php

Go to the documentation of this file.

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

class ilBookingSchedule
{
        protected $id;                  // int
        protected $title;               // string
        protected $pool_id;             // int
        protected $raster;              // int
        protected $rent_min;    // int
        protected $rent_max;    // int
        protected $auto_break;  // int
        protected $deadline;    // int
        protected $definition;  // array

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

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

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

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

        function setRaster($a_raster)
        {
                $this->raster = (int)$a_raster;
        }

        function getRaster()
        {
                return $this->raster;
        }

        function setMinRental($a_min)
        {
                $this->rent_min = (int)$a_min;
        }

        function getMinRental()
        {
                return $this->rent_min;
        }

        function setMaxRental($a_max)
        {
                $this->rent_max = (int)$a_max;
        }

        function getMaxRental()
        {
                return $this->rent_max;
        }

        function setAutoBreak($a_break)
        {
                $this->auto_break = (int)$a_break;
        }

        function getAutoBreak()
        {
                return $this->auto_break;
        }

        function setDeadline($a_deadline)
        {
                $this->deadline = (int)$a_deadline;
        }

        function getDeadline()
        {
                return $this->deadline;
        }

        function setDefinition($a_definition)
        {
                $this->definition = $a_definition;
        }

        function getDefinition()
        {
                return $this->definition;
        }

        protected function read()
        {
                global $ilDB;
                
                if($this->id)
                {
                        $set = $ilDB->query('SELECT title,raster,rent_min,rent_max,auto_break,'.
                                'deadline'.
                                ' FROM booking_schedule'.
                                ' WHERE booking_schedule_id = '.$ilDB->quote($this->id, 'integer'));
                        $row = $ilDB->fetchAssoc($set);
                        $this->setTitle($row['title']);
                        $this->setDeadline($row['deadline']);
                        if($row['raster'])
                        {
                                $this->setRaster($row['raster']);
                                $this->setMinRental($row['rent_min']);
                                $this->setMaxRental($row['rent_max']);
                                $this->setAutoBreak($row['auto_break']);
                        }

                        // load definition
                        $definition = array();
                        $set = $ilDB->query('SELECT day_id,slot_id,times'.
                                ' FROM booking_schedule_slot'.
                                ' WHERE booking_schedule_id = '.$ilDB->quote($this->id, 'integer'));
                        while($row = $ilDB->fetchAssoc($set))
                        {
                                $definition[$row["day_id"]][$row["slot_id"]] = $row["times"];
                        }
                        $this->setDefinition($definition);
                }
        }

        function save()
        {
                global $ilDB;

                if($this->id)
                {
                        return false;
                }

                $this->id = $ilDB->nextId('booking_schedule');

                $ilDB->manipulate('INSERT INTO booking_schedule'.
                        ' (booking_schedule_id,title,pool_id,raster,rent_min,rent_max,auto_break,'.
                        'deadline)'.
                        ' VALUES ('.$ilDB->quote($this->id, 'integer').','.$ilDB->quote($this->getTitle(), 'text').
                        ','.$ilDB->quote($this->getPoolId(), 'integer').','.$ilDB->quote($this->getRaster(), 'integer').
                        ','.$ilDB->quote($this->getMinRental(), 'integer').','.$ilDB->quote($this->getMaxRental(), 'integer').
                        ','.$ilDB->quote($this->getAutoBreak(), 'integer').','.$ilDB->quote($this->getDeadline(), 'integer').')');

                $this->saveDefinition();
        }

        function update()
        {
                global $ilDB;

                if(!$this->id)
                {
                        return false;
                }

                $ilDB->manipulate('UPDATE booking_schedule'.
                        ' SET title = '.$ilDB->quote($this->getTitle(), 'text').
                        ', pool_id = '.$ilDB->quote($this->getPoolId(), 'integer').
                        ', raster = '.$ilDB->quote($this->getRaster(), 'integer').
                        ', rent_min = '.$ilDB->quote($this->getMinRental(), 'integer').
                        ', rent_max = '.$ilDB->quote($this->getMaxRental(), 'integer').
                        ', auto_break = '.$ilDB->quote($this->getAutoBreak(), 'integer').
                        ', deadline = '.$ilDB->quote($this->getDeadline(), 'integer').
                        ' WHERE booking_schedule_id = '.$ilDB->quote($this->id, 'integer'));

                $this->saveDefinition();
        }

        protected function saveDefinition()
        {
                global $ilDB;

                if(!$this->id)
                {
                        return false;
                }

                $ilDB->manipulate('DELETE FROM booking_schedule_slot'.
                        ' WHERE booking_schedule_id = '.$ilDB->quote($this->id, 'integer'));

                $definition = $this->getDefinition();
                if($definition)
                {
                        foreach($definition as $day_id => $slots)
                        {
                                foreach($slots as $slot_id => $times)
                                {
                                        $fields = array(
                                                "booking_schedule_id" => array('integer', $this->id),
                                                "day_id" => array('text', $day_id),
                                                "slot_id" => array('integer', $slot_id),
                                                "times" => array('text', $times)
                                                );
                                        $ilDB->insert('booking_schedule_slot', $fields);
                                }
                        }

                }
        }

        static function hasExistingSchedules($a_pool_id)
        {
                global $ilDB;

                $set = $ilDB->query("SELECT booking_schedule_id".
                        " FROM booking_schedule".
                        " WHERE pool_id = ".$ilDB->quote($a_pool_id, 'integer'));
                return (bool)$ilDB->numRows($set);
        }

        static function getList($a_pool_id)
        {
                global $ilDB;

                $set = $ilDB->query('SELECT s.booking_schedule_id,s.title,'.
                        'MAX(t.schedule_id) AS type_has_schedule,  MAX(o.schedule_id) AS object_has_schedule'.
                        ' FROM booking_schedule s'.
                        ' LEFT JOIN booking_type t ON (s.booking_schedule_id = t.schedule_id)'.
                        ' LEFT JOIN booking_object o ON (s.booking_schedule_id = o.schedule_id)'.
                        ' WHERE s.pool_id = '.$ilDB->quote($a_pool_id, 'integer').
                        ' GROUP BY s.booking_schedule_id,s.title'.
                        ' ORDER BY s.title');
                $res = array();
                while($row = $ilDB->fetchAssoc($set))
                {
                        if(!$row['type_has_schedule'] && !$row['object_has_schedule'])
                        {
                                $row['is_used'] = false;
                        }
                        else
                        {
                                $row['is_used'] = true;
                        }
                        $res[] = $row;
                }
                return $res;
        }

        function delete()
        {
                global $ilDB;

                if($this->id)
                {
                        return $ilDB->manipulate('DELETE FROM booking_schedule'.
                                ' WHERE booking_schedule_id = '.$ilDB->quote($this->id, 'integer'));
                }
        }
        
        function getDefinitionBySlots()
        {
                $def = $this->getDefinition();
                $slots = array();
                foreach($def as $day => $times)
                {
                        foreach($times as $time)
                        {
                                $slots[$time][] = $day;
                        }
                }
                foreach($slots as $time => $days)
                {
                        $slots[$time] = array_unique($days);            
                }
                ksort($slots);
                return $slots;
        }
        
        function setDefinitionBySlots(array $a_def)
        {
                $slots = array();
                foreach($a_def as $time => $days)
                {
                        foreach($days as $day)
                        {
                                $slots[$day][] = $time;
                        }
                }
                $this->setDefinition($slots);
        }
}

?>