class.ilTimingUser.php

Go to the documentation of this file.

<?php
 
declare(strict_types=0);
class ilTimingUser
{
    private int $ref_id = 0;
    private int $usr_id = 0;
    private ilDateTime $start;
    private ilDateTime $end;
 
    private bool $is_scheduled = false;
 
    protected ilDBInterface $db;
 
    public function __construct(int $a_ref_id, int $a_usr_id)
    {
        global $DIC;
 
        $this->db = $DIC->database();
 
        $this->ref_id = $a_ref_id;
        $this->usr_id = $a_usr_id;
 
        $this->start = new ilDateTime(0, IL_CAL_UNIX);
        $this->end = new ilDateTime(0, IL_CAL_UNIX);
        $this->read();
    }
 
    public function getUserId(): int
    {
        return $this->usr_id;
    }
 
    public function getRefId(): int
    {
        return $this->ref_id;
    }
 
    public function isScheduled(): bool
    {
        return $this->is_scheduled;
    }
 
    public function getStart(): ilDateTime
    {
        return $this->start;
    }
 
    public function getEnd(): ilDateTime
    {
        return $this->end;
    }
 
    public function create(): void
    {
        if ($this->isScheduled()) {
            $this->update();
            return;
        }
 
        $query = 'INSERT INTO crs_timings_user (ref_id, usr_id, sstart, ssend ) VALUES ( ' .
            $this->db->quote($this->getRefId(), 'integer') . ', ' .
            $this->db->quote($this->getUserId(), 'integer') . ', ' .
            $this->db->quote($this->getStart()->get(IL_CAL_UNIX), 'integer') . ', ' .
            $this->db->quote($this->getEnd()->get(IL_CAL_UNIX), 'integer') . ' ' .
            ')';
        $this->db->manipulate($query);
        $this->is_scheduled = true;
    }
 
    public function update(): void
    {
        if (!$this->isScheduled()) {
            $this->create();
            return;
        }
 
        $query = 'UPDATE crs_timings_user ' .
            'SET sstart = ' . $this->db->quote($this->getStart()->get(IL_CAL_UNIX), 'integer') . ', ' .
            'ssend = ' . $this->db->quote($this->getEnd()->get(IL_CAL_UNIX), 'integer') . ' ' .
            'WHERE ref_id = ' . $this->db->quote($this->getRefId(), 'integer') . ' ' .
            'AND usr_id = ' . $this->db->quote($this->getUserId(), 'integer');
        $this->db->manipulate($query);
    }
 
    public function delete(): void
    {
        $query = 'DELETE FROM crs_timings_user ' . ' ' .
            'WHERE ref_id = ' . $this->db->quote($this->getRefId(), 'integer') . ' ' .
            'AND usr_id = ' . $this->db->quote($this->getUserId(), 'integer');
        $this->db->manipulate($query);
        $this->is_scheduled = false;
    }
 
    public function read(): void
    {
        $query = 'SELECT * FROM crs_timings_user ' .
            'WHERE ref_id = ' . $this->db->quote($this->getRefId(), 'integer') . ' ' .
            'AND usr_id = ' . $this->db->quote($this->getUserId(), 'integer');
        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $this->is_scheduled = true;
            $this->start = new ilDateTime((int) $row->sstart, IL_CAL_UNIX);
            $this->end = new ilDateTime((int) $row->ssend, IL_CAL_UNIX);
        }
    }
}