class.ilSCTasks.php

Go to the documentation of this file.

<?php
 
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */
 
include_once './Services/SystemCheck/classes/class.ilSCTask.php';
 
class ilSCTasks
{
 
    private static $instances = array();
    
    private $grp_id = 0;
    private $tasks = array();
    
    private function __construct($a_grp_id)
    {
        $this->grp_id = $a_grp_id;
        $this->read();
    }
    
    public static function getInstanceByGroupId($a_group_id)
    {
        if (!array_key_exists($a_group_id, self::$instances)) {
            return self::$instances[$a_group_id] = new self($a_group_id);
        }
        return self::$instances[$a_group_id];
    }
    
    public function updateFromComponentDefinition($a_identifier)
    {
        foreach ($this->getTasks() as $task) {
            if ($task->getIdentifier() == $a_identifier) {
                return true;
            }
        }
        
        $task = new ilSCTask();
        $task->setGroupId($this->getGroupId());
        $task->setIdentifier($a_identifier);
        $task->create();
        
        return $task->getId();
    }
    
    
    
    public static function lookupGroupId($a_task_id)
    {
        global $ilDB;
        
        $query = 'SELECT grp_id FROM sysc_tasks ' .
                'WHERE id = ' . $ilDB->quote($a_task_id, 'integer');
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return $row->grp_id;
        }
        return 0;
    }
    
    public static function lookupCompleted($a_grp_id)
    {
        global $ilDB;
        
        $query = 'SELECT count(id) num FROM sysc_tasks ' .
                'WHERE status = ' . $ilDB->quote(ilSCTask::STATUS_COMPLETED, 'integer') . ' ' .
                'AND grp_id = ' . $ilDB->quote($a_grp_id, 'integer');
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return $row->num;
        }
        return 0;
    }
    
    public static function lookupFailed($a_grp_id)
    {
        global $ilDB;
        
        $query = 'SELECT count(id) num FROM sysc_tasks ' .
                'WHERE status = ' . $ilDB->quote(ilSCTask::STATUS_FAILED, 'integer') . ' ' .
                'AND grp_id = ' . $ilDB->quote($a_grp_id, 'integer');
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return $row->num;
        }
        return 0;
    }
    
    public static function lookupLastUpdate($a_grp_id)
    {
        global $ilDB;
        
        $query = 'SELECT MAX(last_update) last_update FROM sysc_tasks ' .
                'WHERE status = ' . $ilDB->quote(ilSCTask::STATUS_FAILED, 'integer') . ' ' .
                'AND grp_id = ' . $ilDB->quote($a_grp_id, 'integer');
        $res = $ilDB->query($query);
        
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return new ilDateTime($row->last_update, IL_CAL_DATETIME, ilTimeZone::UTC);
        }
        return new ilDateTime(time(), IL_CAL_UNIX);
    }
    
    public function getGroupId()
    {
        return $this->grp_id;
    }
 
    public function getTasks()
    {
        return (array) $this->tasks;
    }
    
    protected function read()
    {
        global $ilDB;
        
        $query = 'SELECT id FROM sysc_tasks ' .
                'ORDER BY id ';
        $res = $ilDB->query($query);
        
        $this->tasks = array();
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $this->tasks[] = new ilSCTask($row->id);
        }
    }
}