class.ilOrgUnitRemoveDeletedUsersObjective.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
use ILIAS\Setup\Environment;
use ILIAS\Setup\NullConfig;
 
class ilOrgUnitRemoveDeletedUsersObjective extends ilSetupObjective
{
    public function __construct()
    {
        parent::__construct(new NullConfig());
    }
 
    public function getHash(): string
    {
        return hash('sha256', self::class);
    }
 
    public function getLabel(): string
    {
        return 'OrgUnit assignments are removed for deleted users';
    }
 
    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 = 'DELETE FROM il_orgu_ua' . PHP_EOL
            . 'WHERE user_id NOT IN (' . PHP_EOL
            . 'SELECT usr_id FROM usr_data' . PHP_EOL
            . ')';
        $db->manipulate($query);
        return $environment;
    }
 
    public function isApplicable(Environment $environment): bool
    {
        return true;
    }
}