ExternalToolsRemovedObjective.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
namespace ILIAS\Administration\Setup;
 
use ILIAS\Setup\Environment;
use ilIniFilesLoadedObjective;
use ilDatabaseInitializedObjective;
use ilIniFile;
use ilDBInterface;
use ilAccessRBACOperationDeletedObjective;
use ILIAS\Setup\Objective;
use ilDBConstants;
 
class ExternalToolsRemovedObjective implements Objective
{
    public function getHash(): string
    {
        return hash("sha256", self::class);
    }
 
    public function getLabel(): string
    {
        return "Remove external tools admin folder";
    }
 
    public function isNotable(): bool
    {
        return true;
    }
 
    public function getPreconditions(Environment $environment): array
    {
        return [
            new ilDatabaseInitializedObjective()
        ];
    }
 
    public function achieve(Environment $environment): Environment
    {
        $db = $environment->getResource(Environment::RESOURCE_DATABASE);
 
        $query = "
            SELECT op.ops_id
            FROM rbac_operations op
            JOIN rbac_ta ta ON ta.ops_id = op.ops_id
            JOIN object_data d ON d.obj_id = ta.typ_id AND d.`type` = 'typ' AND d.title ='extt'
        ";
 
        $result = $db->query($query);
        while ($row = $db->fetchAssoc($result)) {
            $objective = new ilAccessRBACOperationDeletedObjective('extt', $row['ops_id']);
            $objective->achieve($environment);
        }
 
        $query = "
            SELECT r.ref_id, r.obj_id
            FROM object_reference r
            JOIN object_data d ON r.obj_id = d.obj_id
            WHERE d.`type` = 'extt';
        ";
 
        $result = $db->query($query);
        if ($row = $db->fetchAssoc($result)) {
            $db->manipulateF("DELETE FROM rbac_pa WHERE ref_id = %s", [ilDBConstants::T_INTEGER], [$row['ref_id']]);
            $db->manipulateF("DELETE FROM rbac_fa WHERE parent = %s", [ilDBConstants::T_INTEGER], [$row['ref_id']]);
            $db->manipulateF("DELETE FROM object_reference WHERE obj_id = %s", [ilDBConstants::T_INTEGER], [$row['obj_id']]);
            $db->manipulateF("DELETE FROM object_data WHERE obj_id = %s", [ilDBConstants::T_INTEGER], [$row['obj_id']]);
        }
 
        return $environment;
    }
 
    public function isApplicable(Environment $environment): bool
    {
        $db = $environment->getResource(Environment::RESOURCE_DATABASE);
 
        $result = $db->query("SELECT obj_id FROM object_data WHERE `type` = 'extt'");
        return (bool) $db->fetchAssoc($result);
    }
}