Repo class for schedules. More...

Collaboration diagram for ILIAS\BookingManager\Schedule\SchedulesDBRepository:

Public Member Functions
	__construct (\ilDBInterface $db)

	loadDataOfPool (int $pool_id)

	hasSchedules (int $pool_id)

	getScheduleList (int $pool_id)

	getScheduleData (int $pool_id)

Protected Member Functions
	getScheduleDataForPool (int $pool_id)

Protected Attributes
ilDBInterface	$db

Static Protected Attributes
static array	$pool_loaded = []

static array	$pool_schedules = []

static array	$raw_data = []

Detailed Description

Repo class for schedules.

Author: Alexander Killing killi.nosp@m.ng@l.nosp@m.eifos.nosp@m..de

Definition at line 25 of file class.SchedulesDBRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ILIAS\BookingManager\Schedule\SchedulesDBRepository::__construct ( \ilDBInterface $db )

Definition at line 32 of file class.SchedulesDBRepository.php.

References ILIAS\BookingManager\Schedule\SchedulesDBRepository\$db.

       {
         $this->db = $db;
     }

Member Function Documentation

◆ getScheduleData()

ILIAS\BookingManager\Schedule\SchedulesDBRepository::getScheduleData ( int $pool_id )

Definition at line 94 of file class.SchedulesDBRepository.php.

References $data, and ILIAS\BookingManager\Schedule\SchedulesDBRepository\getScheduleDataForPool().

                                                  : array
     {
         $schedules = [];
         foreach ($this->getScheduleDataForPool($pool_id) as $data) {
             $schedules[$data["booking_schedule_id"]] = $data;
         }
         return $schedules;
     }

Here is the call graph for this function:

◆ getScheduleDataForPool()

ILIAS\BookingManager\Schedule\SchedulesDBRepository::getScheduleDataForPool ( int $pool_id )

protected

Definition at line 71 of file class.SchedulesDBRepository.php.

References ILIAS\BookingManager\Schedule\SchedulesDBRepository\loadDataOfPool().

Referenced by ILIAS\BookingManager\Schedule\SchedulesDBRepository\getScheduleData(), and ILIAS\BookingManager\Schedule\SchedulesDBRepository\getScheduleList().

      : array {
         $this->loadDataOfPool($pool_id);
         return self::$pool_schedules[$pool_id] ?? [];
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getScheduleList()

ILIAS\BookingManager\Schedule\SchedulesDBRepository::getScheduleList ( int $pool_id )

Definition at line 85 of file class.SchedulesDBRepository.php.

References $data, and ILIAS\BookingManager\Schedule\SchedulesDBRepository\getScheduleDataForPool().

                                                  : array
     {
         $list = [];
         foreach ($this->getScheduleDataForPool($pool_id) as $data) {
             $list[$data["booking_schedule_id"]] = $data["title"];
         }
         return $list;
     }

Here is the call graph for this function:

◆ hasSchedules()

ILIAS\BookingManager\Schedule\SchedulesDBRepository::hasSchedules ( int $pool_id )

Definition at line 78 of file class.SchedulesDBRepository.php.

References ILIAS\BookingManager\Schedule\SchedulesDBRepository\loadDataOfPool().

      : bool {
         $this->loadDataOfPool($pool_id);
         return count(self::$pool_schedules[$pool_id] ?? []) > 0;
     }

Here is the call graph for this function:

◆ loadDataOfPool()

ILIAS\BookingManager\Schedule\SchedulesDBRepository::loadDataOfPool ( int $pool_id )

Definition at line 38 of file class.SchedulesDBRepository.php.

References ILIAS\BookingManager\Schedule\SchedulesDBRepository\$db, and ilDBInterface\query().

Referenced by ILIAS\BookingManager\Schedule\SchedulesDBRepository\getScheduleDataForPool(), and ILIAS\BookingManager\Schedule\SchedulesDBRepository\hasSchedules().

                                                 : void
     {
         $db = $this->db;
 
         if (isset(self::$pool_loaded[$pool_id]) && self::$pool_loaded[$pool_id]) {
             return;
         }
 
         $set = $db->query(
             'SELECT s.booking_schedule_id,s.title,' .
             'MAX(o.schedule_id) AS object_has_schedule' .
             ' FROM booking_schedule s' .
             ' LEFT JOIN booking_object o ON (s.booking_schedule_id = o.schedule_id)' .
             ' WHERE s.pool_id = ' . $db->quote($pool_id, 'integer') .
             ' GROUP BY s.booking_schedule_id,s.title' .
             ' ORDER BY s.title'
         );
 
         self::$pool_schedules[$pool_id] = [];
 
         while ($row = $db->fetchAssoc($set)) {
             if (!$row['object_has_schedule']) {
                 $row['is_used'] = false;
             } else {
                 $row['is_used'] = true;
             }
             self::$raw_data[$row["booking_schedule_id"]] = $row;
             self::$pool_schedules[$pool_id][] = $row;
         }
 
         self::$pool_loaded[$pool_id] = true;
     }