class.ilSystemCheckTrash.php

Go to the documentation of this file.

<?php
class ilSystemCheckTrash
{
    const MODE_TRASH_RESTORE = 1;
    const MODE_TRASH_REMOVE = 2;
    
    private $limit_number = 0;
    private $limit_age = null;
    private $limit_types = array();
    
    
    public function __construct()
    {
        $this->limit_age = new ilDate(0, IL_CAL_UNIX);
    }
    
    public function setNumberLimit($a_limit)
    {
        $this->limit_number = $a_limit;
    }
    
    public function getNumberLimit()
    {
        return $this->limit_number;
    }
    
    public function setAgeLimit(ilDateTime $dt)
    {
        $this->limit_age = $dt;
    }
    
    public function getAgeLimit()
    {
        return $this->limit_age;
    }
    
    public function setTypesLimit($a_types)
    {
        $this->limit_types = (array) $a_types;
    }
    
    public function getTypesLimit()
    {
        return (array) $this->limit_types;
    }
    
    public function setMode($a_mode)
    {
        $this->mode = $a_mode;
    }
    
    public function getMode()
    {
        return $this->mode;
    }
    
    public function start()
    {
        $GLOBALS['DIC']['ilLog']->info('Handling delete');
        switch ($this->getMode()) {
            case self::MODE_TRASH_RESTORE:
                $GLOBALS['DIC']['ilLog']->info('Restore trash to recovery folder');
                $this->restore();
                break;
                
            case self::MODE_TRASH_REMOVE:
                $GLOBALS['DIC']['ilLog']->info('Remove selected from system.');
                $GLOBALS['DIC']['ilLog']->info('Type limit: ' . print_r($this->getTypesLimit(), true));
                $GLOBALS['DIC']['ilLog']->info('Age limit: ' . (string) $this->getAgeLimit());
                $GLOBALS['DIC']['ilLog']->info('Number limit: ' . (string) $this->getNumberLimit());
                $this->removeSelectedFromSystem();
                return true;
        }
    }
 
    protected function restore()
    {
        $deleted = $this->readDeleted();
        
        $GLOBALS['DIC']['ilLog']->info('Found deleted : ' . print_r($deleted, true));
        
        $factory = new ilObjectFactory();
        
        foreach ($deleted as $tmp_num => $deleted_info) {
            $ref_obj = $factory->getInstanceByRefId($deleted_info['child'], false);
            if (!$ref_obj instanceof ilObject) {
                continue;
            }
 
            $GLOBALS['DIC']['tree']->deleteNode($deleted_info['tree'], $deleted_info['child']);
            $GLOBALS['DIC']['ilLog']->info('Object tree entry deleted');
            
            if ($ref_obj->getType() != 'rolf') {
                $GLOBALS['DIC']['rbacadmin']->revokePermission($deleted_info['child']);
                $ref_obj->putInTree(RECOVERY_FOLDER_ID);
                $ref_obj->setPermissions(RECOVERY_FOLDER_ID);
                $GLOBALS['DIC']['ilLog']->info('Object moved to recovery folder');
            }
        }
    }
    
    protected function removeSelectedFromSystem()
    {
        $factory = new ilObjectFactory();
 
        $deleted = $this->readSelectedDeleted();
        foreach ($deleted as $tmp_num => $deleted_info) {
            $sub_nodes = $this->readDeleted($deleted_info['tree']);
            
            foreach ($sub_nodes as $tmp_num => $subnode_info) {
                $ref_obj = $factory->getInstanceByRefId($subnode_info['child'], false);
                if (!$ref_obj instanceof ilObject) {
                    continue;
                }
                
                $ref_obj->delete();
                ilTree::_removeEntry($subnode_info['tree'], $subnode_info['child']);
            }
        }
    }
    
    protected function readSelectedDeleted()
    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
        
        $and_types = '';
        ilLoggerFactory::getLogger('sysc')->dump($this->getTypesLimit());
        
        $types = array();
        foreach ((array) $this->getTypesLimit() as $id => $type) {
            if ($type) {
                $types[] = $type;
            }
        }
        if (count($types)) {
            $and_types = 'AND ' . $ilDB->in('o.type', $this->getTypesLimit(), false, 'text') . ' ';
        }
        
        $and_age = '';
        $age_limit = $this->getAgeLimit()->get(IL_CAL_UNIX);
        if ($age_limit > 0) {
            $and_age = 'AND r.deleted < ' . $ilDB->quote($this->getAgeLimit()->get(IL_CAL_DATETIME)) . ' ';
        }
        $limit = '';
        if ($this->getNumberLimit()) {
            $limit = 'LIMIT ' . (int) $this->getNumberLimit();
        }
        
        $query = 'SELECT child,tree FROM tree t JOIN object_reference r ON child = r.ref_id ' .
                'JOIN object_data o on r.obj_id = o.obj_id ' .
                'WHERE tree < ' . $ilDB->quote(0, 'integer') . ' ' .
                'AND child = -tree ';
        
        $query .= $and_age;
        $query .= $and_types;
        $query .= 'ORDER BY depth desc ';
        $query .= $limit;
        
        $GLOBALS['DIC']['ilLog']->info($query);
        
        $deleted = array();
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $deleted[] = array(
                'tree' => $row->tree,
                'child' => $row->child
            );
        }
        return $deleted;
    }
 
 
 
 
    protected function readDeleted($tree_id = null)
    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
        
        $query = 'SELECT child,tree FROM tree t JOIN object_reference r ON child = r.ref_id ' .
                'JOIN object_data o on r.obj_id = o.obj_id ';
        
        if ($tree_id === null) {
            $query .= 'WHERE tree < ' . $ilDB->quote(0, 'integer') . ' ';
        } else {
            $query .= 'WHERE tree = ' . $ilDB->quote($tree_id, 'integer') . ' ';
        }
        $query .= 'ORDER BY depth desc';
        
        $res = $ilDB->query($query);
        
        $deleted = array();
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $deleted[] = array(
                'tree' => $row->tree,
                'child' => $row->child
            );
        }
        return $deleted;
    }
}