class.ilBookingManagerBookingInfoMigration.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
use ILIAS\Setup\Environment;
use ILIAS\Setup\Migration;
 
class ilBookingManagerBookingInfoMigration implements Migration
{
    protected ilResourceStorageMigrationHelper $helper;
 
    public function getLabel(): string
    {
        return 'Migration of post booking info files to the resource storage service.';
    }
 
    public function getDefaultAmountOfStepsPerRun(): int
    {
        return 1000;
    }
 
    public function getPreconditions(Environment $environment): array
    {
        return ilResourceStorageMigrationHelper::getPreconditions();
    }
 
    public function prepare(Environment $environment): void
    {
        $this->helper = new ilResourceStorageMigrationHelper(new ilBookBookingInfoStakeholder(), $environment);
    }
 
    public function step(Environment $environment): void
    {
        $r = $this->helper->getDatabase()->query(
            'SELECT booking_object_id, pool_id, owner FROM booking_object JOIN object_data ON pool_id = obj_id WHERE book_info_rid IS NULL LIMIT 1'
        );
        $d = $this->helper->getDatabase()->fetchObject($r);
        $pool_id = (int) $d->pool_id;
        $booking_object_id = (int) $d->booking_object_id;
        $resource_owner_id = (int) $d->owner;
        $base_path = $this->buildAbsolutPath($booking_object_id);
        $pattern = '/[^\.].*/m';
        $rid = is_dir($base_path)
            ? $this->helper->moveFirstFileOfPatternToStorage($base_path, $pattern, $resource_owner_id)
            : '';
        $this->helper->getDatabase()->update(
            'booking_object',
            [
                'book_info_rid' => [ilDBConstants::T_TEXT, (string) $rid]
            ],
            [
                'booking_object_id' => [ilDBConstants::T_INTEGER, $booking_object_id],
                'pool_id' => [ilDBConstants::T_INTEGER, $pool_id]
            ]
        );
    }
 
    public function getRemainingAmountOfSteps(): int
    {
        $r = $this->helper->getDatabase()->query(
            'SELECT count(booking_object_id) amount FROM booking_object JOIN object_data ON pool_id = obj_id WHERE book_info_rid IS NULL'
        );
 
        return (int) $this->helper->getDatabase()->fetchObject($r)->amount;
    }
 
    protected function buildAbsolutPath(int $booking_object_id): string
    {
        $path_from_id = ilFileSystemAbstractionStorage::createPathFromId($booking_object_id, 'book');
        return CLIENT_WEB_DIR . "/ilBookingManager/{$path_from_id}/post";
    }
}