class.ilCalendarAuthenticationToken.php

Go to the documentation of this file.

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


class ilCalendarAuthenticationToken
{
        const SELECTION_NONE = 0;
        const SELECTION_PD = 1;
        const SELECTION_CATEGORY = 2;
        const SELECTION_CALENDAR = 3;
        
        private $user = null;
        
        private $token  = '';
        private $selection_type = 0;
        private $calendar = 0;
        
        private $ical = null;
        private $ical_ctime = null;
        
        public function __construct($a_user_id,$a_token = '')
        {
                $this->user = $a_user_id;
                $this->token = $a_token;
                
                $this->read();
        }
        
        public static function lookupAuthToken($a_user_id, $a_selection,$a_calendar = 0)
        {
                global $ilDB;
                
                $query = "SELECT * FROM cal_auth_token ".
                        "WHERE user_id = ".$ilDB->quote($a_user_id,'integer').' '.
                        "AND selection = ".$ilDB->quote($a_selection,'integer').' '.
                        "AND calendar = ".$ilDB->quote($a_calendar,'integer');
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        return $row->hash;
                }
                return false;
        }
        
        public static function lookupUser($a_token)
        {
                global $ilDB;
                
                $query = "SELECT * FROM cal_auth_token ".
                        "WHERE hash = ".$ilDB->quote($a_token,'text');
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        return $row->user_id;
                }
                return 0;
        }
        
        public function getSelectionType()
        {
                return $this->selection_type;
        }
        

        public function getUserId()
        {
                return $this->user;
        }
        
        public function setSelectionType($a_type)
        {
                $this->selection_type = $a_type;
        }
        
        public function setCalendar($a_cal)
        {
                $this->calendar = $a_cal;
        }
        
        public function getCalendar()
        {
                return $this->calendar;
        }
        
        public function setIcal($ical)
        {
                $this->ical = $ical;
        }
        
        public function getIcal()
        {
                return $this->ical;
        }
        
        
        public function getToken()
        {
                return $this->token;
        }
        
        public function storeIcal()
        {
                global $ilDB;
                
                $ilDB->update(
                        'cal_auth_token',
                        array(
                                'ical'          => array('clob',$this->getIcal()),
                                'c_time'        => array('integer',time())
                        ),
                        array(
                                'user_id'       => array('integer',$this->getUserId()),
                                'hash'          => array('text',$this->getToken())
                        )
                );
        }
        
        public function isIcalExpired()
        {
                return true;

                include_once './Services/Calendar/classes/class.ilCalendarSettings.php';
                
                if(!ilCalendarSettings::_getInstance()->isSynchronisationCacheEnabled())
                {
                        return true;
                }
                if(!ilCalendarSettings::_getInstance()->getSynchronisationCacheMinutes())
                {
                        return true;
                }
                return time() > ($this->ical_ctime + 60 * ilCalendarSettings::_getInstance()->getSynchronisationCacheMinutes());
        }
        
        public function add()
        {
                global $ilDB;
                
                $this->createToken();
                
                $query = "INSERT INTO cal_auth_token (user_id,hash,selection,calendar) ".
                        "VALUES ( ".
                        $ilDB->quote($this->getUserId(),'integer').', '.
                        $ilDB->quote($this->getToken(),'text').', '.
                        $ilDB->quote($this->getSelectionType(),'integer').', '.
                        $ilDB->quote($this->getCalendar(),'integer').' '.
                        ')';
                $ilDB->manipulate($query);
                
                return $this->getToken();
        }
        
        protected function createToken()
        {
                $this->token = md5($this->getUserId().$this->getSelectionType().rand());
        }
        
        protected function read()
        {
                global $ilDB;

                if(!$this->getToken())
                {
                        $query = "SELECT * FROM cal_auth_token ".
                                "WHERE user_id = ".$ilDB->quote($this->getUserId(),'integer');
                }
                else
                {
                        $query = 'SELECT * FROM cal_auth_token '.
                                'WHERE user_id = '.$ilDB->quote($this->getUserId(),'integer').' '.
                                'AND hash = '.$ilDB->quote($this->getToken(),'text');

                }
                        
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $this->token = $row->hash;
                        $this->selection_type = $row->selection;
                        $this->calendar = $row->calendar;
                        $this->ical = $row->ical;
                        $this->ical_ctime = $row->c_time;
                }
                return true;
        }
}
?>