class.ilCmiXapiResult.php

Go to the documentation of this file.

<?php

/* Copyright (c) 1998-2019 ILIAS open source, Extended GPL, see docs/LICENSE */


class ilCmiXapiResult
{
    protected $id;
    
    protected $objId;
    
    protected $usrId;
    
    protected $version;
    
    protected $score;
    
    protected $status;
    
    protected $lastUpdate;
    
    public function __construct()
    {
        $this->id = 0;
        $this->objId = 0;
        $this->usrId = 0;
        $this->version = 0;
        $this->score = 0.0;
        $this->status = '';
        $this->lastUpdate = '';
    }
    
    public function getId() : int
    {
        return $this->id;
    }
    
    public function setId(int $id)
    {
        $this->id = $id;
    }
    
    public function getObjId() : int
    {
        return $this->objId;
    }
    
    public function setObjId(int $objId)
    {
        $this->objId = $objId;
    }
    
    public function getUsrId() : int
    {
        return $this->usrId;
    }
    
    public function setUsrId(int $usrId)
    {
        $this->usrId = $usrId;
    }
    
    public function getVersion() : int
    {
        return $this->version;
    }
    
    public function setVersion(int $version)
    {
        $this->version = $version;
    }
    
    public function getScore() : float
    {
        return $this->score;
    }
    
    public function setScore(float $score)
    {
        $this->score = $score;
    }
    
    public function getStatus() : string
    {
        return $this->status;
    }
    
    public function setStatus(string $status)
    {
        $this->status = $status;
    }
    
    public function getLastUpdate() : string
    {
        return $this->lastUpdate;
    }
    
    public function setLastUpdate(string $lastUpdate)
    {
        $this->lastUpdate = $lastUpdate;
    }
    
    public function save()
    {
        if ($this->getId()) {
            $this->update();
        } else {
            $this->insert();
        }
    }
    
    protected function update()
    {
        global $DIC; /* @var \ILIAS\DI\Container $DIC */
        
        $DIC->database()->update('cmix_results', array(
                'obj_id' => array('intger', $this->getObjId()),
                'usr_id' => array('intger', $this->getUsrId()),
                'version' => array('intger', $this->getVersion()),
                'score' => array('float', $this->getScore()),
                'status' => array('text', $this->getStatus()),
                'last_update' => array('timestamp', ilCmiXapiAuthToken::selectCurrentTimestamp())
            ), array(
                'id' => array('intger', $this->getId())
        ));
    }
    
    protected function insert()
    {
        global $DIC; /* @var \ILIAS\DI\Container $DIC */
        
        $this->setId($DIC->database()->nextId('cmix_results'));
        
        $DIC->database()->insert('cmix_results', array(
            'id' => array('intger', $this->getId()),
            'obj_id' => array('intger', $this->getObjId()),
            'usr_id' => array('intger', $this->getUsrId()),
            'version' => array('intger', $this->getVersion()),
            'score' => array('float', $this->getScore()),
            'status' => array('text', $this->getStatus()),
            'last_update' => array('timestamp', ilCmiXapiAuthToken::selectCurrentTimestamp())
        ));
    }
    
    protected function assignFromDbRow($row)
    {
        $this->setId($row['id']);
        $this->setObjId($row['obj_id']);
        $this->setUsrId($row['usr_id']);
        $this->setVersion($row['version']);
        $this->setScore($row['score']);
        $this->setStatus($row['status']);
        $this->setLastUpdate($row['last_update']);
    }
    
    public static function getInstanceByObjIdAndUsrId($objId, $usrId)
    {
        global $DIC; /* @var \ILIAS\DI\Container $DIC */
        
        $query = "
                        SELECT * FROM cmix_results
                        WHERE obj_id = %s AND usr_id = %s
                ";
        
        $res = $DIC->database()->queryF($query, array('integer', 'integer'), array($objId, $usrId));
        
        while ($row = $DIC->database()->fetchAssoc($res)) {
            $result = new self();
            $result->assignFromDbRow($row);
            
            return $result;
        }
        
        throw new ilCmiXapiException(
            "no result record exists for: usr=$usrId obj=$objId"
        );
    }
    
    public static function getEmptyInstance()
    {
        return new self();
    }
    
    public static function getResultsForObject($objId)
    {
        global $DIC;
        
        $query = 'SELECT * FROM cmix_results'
            . ' WHERE obj_id = ' . $DIC->database()->quote($objId, 'integer');
        
        $res = $DIC->database()->query($query);
        
        $results = [];
        
        if ($row = $DIC->database()->fetchAssoc($res)) {
            $result = new self();
            $result->assignFromDbRow($row);
            
            $results[$result->getUsrId()] = $result;
        }
        
        return $results;
    }
}