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(DB_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(DB_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(DB_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(DB_FETCHMODE_OBJECT))
                {
                        return new ilDateTime($row->last_update,IL_CAL_DATETIME,'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(DB_FETCHMODE_OBJECT))
                {
                        $this->tasks[] = new ilSCTask($row->id);
                }
        }
}
?>