class.ilConsultationHourGroup.php

Go to the documentation of this file.

<?php
 
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */
 
class ilConsultationHourGroup
{
    private $group_id = 0;
    private $usr_id = 0;
    private $num_assignments = 1;
    private $title = '';
    
    public function __construct($a_group_id = 0)
    {
        $this->group_id = $a_group_id;
        $this->read();
    }
    
    public function getGroupId()
    {
        return $this->group_id;
    }
    
    public function setUserId($a_id)
    {
        $this->usr_id = $a_id;
    }
    
    public function getUserId()
    {
        return $this->usr_id;
    }
    
    public function setMaxAssignments($a_num)
    {
        $this->num_assignments = $a_num;
    }
    
    public function getMaxAssignments()
    {
        return $this->num_assignments;
    }
    
    
    public function setTitle($a_title)
    {
        $this->title = $a_title;
    }
    
    public function getTitle()
    {
        return $this->title;
    }
        
    public function save()
    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
        
        $this->group_id = $ilDB->nextId('cal_ch_group');
        $query = 'INSERT INTO cal_ch_group (grp_id,usr_id,multiple_assignments,title) ' .
                'VALUES ( ' .
                $ilDB->quote($this->getGroupId(), 'integer') . ', ' .
                $ilDB->quote($this->getUserId(), 'integer') . ', ' .
                $ilDB->quote($this->getMaxAssignments(), 'integer') . ', ' .
                $ilDB->quote($this->getTitle(), 'text') .
                ')';
        $ilDB->manipulate($query);
        return $this->getGroupId();
    }
    
    public function update()
    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
        
        $query = 'UPDATE cal_ch_group SET ' .
                'usr_id = ' . $ilDB->quote($this->getUserId(), 'integer') . ', ' .
                'multiple_assignments = ' . $ilDB->quote($this->getMaxAssignments(), 'integer') . ', ' .
                'title = ' . $ilDB->quote($this->getTitle(), 'text') . ' ' .
                'WHERE grp_id = ' . $ilDB->quote($this->getGroupId(), 'integer');
        $ilDB->manipulate($query);
        return true;
    }
    
    public function delete()
    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
        
        $query = 'DELETE FROM cal_ch_group ' .
                'WHERE grp_id = ' . $ilDB->quote($this->getGroupId(), 'integer');
        $ilDB->manipulate($query);
        
        include_once './Services/Booking/classes/class.ilBookingEntry.php';
        ilBookingEntry::resetGroup($this->getGroupId());
    }
    
    
    protected function read()
    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
        
        if (!$this->getGroupId()) {
            return false;
        }
        $query = 'SELECT * FROM cal_ch_group ' .
                'WHERE grp_id = ' . $ilDB->quote($this->getGroupId(), 'integer');
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $this->setUserId($row->usr_id);
            $this->setTitle($row->title);
            $this->setMaxAssignments($row->multiple_assignments);
        }
        return true;
    }
}