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 $DIC;

        $ilDB = $DIC['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(ilDBConstants::FETCHMODE_OBJECT)) {
            return $row->hash;
        }
        return false;
    }
    
    public static function lookupUser($a_token)
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        
        $query = "SELECT * FROM cal_auth_token " .
            "WHERE hash = " . $ilDB->quote($a_token, 'text');
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::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 $DIC;

        $ilDB = $DIC['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 $DIC;

        $ilDB = $DIC['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()
    {
        $random = new \ilRandom();
        $this->token = md5($this->getUserId() . $this->getSelectionType() . $random->int());
    }
    
    protected function read()
    {
        global $DIC;

        $ilDB = $DIC['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(ilDBConstants::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;
    }
}