SettingsDBRepository.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

namespace ILIAS\BookingManager\Settings;

use ilDBInterface;
use ILIAS\BookingManager\InternalDataService;

class SettingsDBRepository
{
    public function __construct(
        protected ilDBInterface $db,
        protected InternalDataService $data
    ) {
    }

    public function create(Settings $settings): void
    {
        $this->db->insert('booking_settings', [
            'booking_pool_id' => ['integer', $settings->getId()],
            'public_log' => ['integer', (int) $settings->getPublicLog()],
            'schedule_type' => ['integer', $settings->getScheduleType()],
            'ovlimit' => ['integer', $settings->getOverallLimit()],
            'rsv_filter_period' => ['integer', $settings->getReservationPeriod()],
            'reminder_status' => ['integer', $settings->getReminderStatus()],
            'reminder_day' => ['integer', $settings->getReminderDay()],
            'pref_deadline' => ['integer', $settings->getPrefDeadline()],
            'preference_nr' => ['integer', $settings->getPreferenceNr()],
            'messages' => ['integer', (int) $settings->getMessages()],
        ]);
    }

    public function update(Settings $settings): void
    {
        $this->db->update('booking_settings', [
            'public_log' => ['integer', (int) $settings->getPublicLog()],
            'schedule_type' => ['integer', $settings->getScheduleType()],
            'ovlimit' => ['integer', $settings->getOverallLimit()],
            'rsv_filter_period' => ['integer', $settings->getReservationPeriod()],
            'reminder_status' => ['integer', $settings->getReminderStatus()],
            'reminder_day' => ['integer', $settings->getReminderDay()],
            'pref_deadline' => ['integer', $settings->getPrefDeadline()],
            'preference_nr' => ['integer', $settings->getPreferenceNr()],
            'messages' => ['integer', (int) $settings->getMessages()],
        ], [
            'booking_pool_id' => ['integer', $settings->getId()],
        ]);
    }

    public function getById(int $id): ?Settings
    {
        $set = $this->db->queryF(
            'SELECT * FROM booking_settings WHERE booking_pool_id = %s',
            ['integer'],
            [$id]
        );

        $record = $this->db->fetchAssoc($set);
        if ($record) {
            return $this->getSettingsFromRecord($record);
        }

        return null;
    }

    public function delete(int $id): void
    {
        $this->db->manipulateF(
            'DELETE FROM booking_settings WHERE booking_pool_id = %s',
            ['integer'],
            [$id]
        );
    }

    protected function getSettingsFromRecord(array $record): Settings
    {
        return $this->data->settings(
            (int) $record['booking_pool_id'],
            (bool) $record['public_log'],
            (int) $record['schedule_type'],
            (int) $record['ovlimit'],
            (int) $record['rsv_filter_period'],
            (bool) $record['reminder_status'],
            (int) $record['reminder_day'],
            (int) $record['pref_deadline'],
            (int) $record['preference_nr'],
            (bool) $record['messages']
        );
    }
}