class.ilBookingPrefBasedBookGatewayRepository.php

Go to the documentation of this file.

<?php

class ilBookingPrefBasedBookGatewayRepository
{
    protected ilDBInterface $db;

    public function __construct(ilDBInterface $db = null)
    {
        global $DIC;

        $this->db = ($db)
            ?: $DIC->database();
    }

    public function getPoolsWithOverdueBooking(): array
    {
        $db = $this->db;

        $pool_ids = [];
        $set = $db->queryF(
            "SELECT booking_pool_id FROM booking_settings " .
            " WHERE schedule_type = %s " .
            " AND pref_deadline < %s " .
            " AND pref_booking_hash     = %s ",
            array("integer", "integer", "text"),
            array(ilObjBookingPool::TYPE_NO_SCHEDULE_PREFERENCES, time(), "0")
        );
        while ($rec = $db->fetchAssoc($set)) {
            $pool_ids[] = $rec["booking_pool_id"];
        }
        return $pool_ids;
    }


    protected function checkProcessHash(int $pool_id): bool
    {
        $db = $this->db;

        $hash = uniqid("", true);

        $db->update("booking_settings", array(
                "pref_booking_hash" => array("text", $hash)
            ), array(   // where
                "booking_pool_id" => array("integer", $pool_id),
                "pref_booking_hash" => array("text", "0"),
            ));

        $set = $db->queryF(
            "SELECT pref_booking_hash FROM booking_settings " .
            " WHERE booking_pool_id = %s ",
            array("integer"),
            array($pool_id)
        );
        $rec = $db->fetchAssoc($set);

        return $rec["pref_booking_hash"] === $hash;
    }

    public function hasRun($pool_id) : bool
    {
        $db = $this->db;
        $set = $db->queryF(
            "SELECT pref_booking_hash FROM booking_settings " .
            " WHERE booking_pool_id = %s ",
            array("integer"),
            array($pool_id)
        );
        $rec = $db->fetchAssoc($set);

        if ($rec["pref_booking_hash"] !== "0") {
            return true;
        }
        return false;
    }

    public function resetRun($pool_id) : void
    {
        $db = $this->db;
        $db->update("booking_settings", array(
            "pref_booking_hash" => array("text", "0")
        ), array(       // where
                     "booking_pool_id" => array("integer", $pool_id)
        ));
    }

    public function storeBookings(
        int $pool_id,
        array $bookings
    ): void {
        if ($this->checkProcessHash($pool_id)) {
            foreach ($bookings as $user_id => $obj_ids) {
                foreach ($obj_ids as $obj_id) {
                    if (ilBookingReservation::isObjectAvailableNoSchedule($obj_id) &&
                        count(ilBookingReservation::getObjectReservationForUser($obj_id, $user_id)) === 0) { // #18304
                        $reservation = new ilBookingReservation();
                        $reservation->setObjectId($obj_id);
                        $reservation->setUserId($user_id);
                        $reservation->setAssignerId($user_id);
                        $reservation->setFrom(0);
                        $reservation->setTo(0);
                        $reservation->save();
                    }
                }
            }
        }
    }

    public function getBookings(
        array $obj_ids
    ): array {
        $bookings = [];
        foreach (ilBookingReservation::getList(
            $obj_ids,
            10000,
            0,
            ["status" => -ilBookingReservation::STATUS_CANCELLED]
        )["data"] as $book) {
            $bookings[$book["user_id"]][] = $book["object_id"];
        }
        return $bookings;
    }
}