This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...

Collaboration diagram for ilBookingPreferencesDBRepository:

Public Member Functions
	__construct (ILIAS\BookingManager\InternalDataService $data, ?ilDBInterface $db=null)

	getPreferences (int $a_pool_id)
	Get booking preferences for a pool id. More...

	getPreferencesOfUser (int $a_pool_id, int $a_user_id)
	Get booking preferences for a pool id. More...

	savePreferences (int $a_pool_id, ilBookingPreferences $preferences)
	Save all preferences of a pool. More...

	savePreferencesOfUser (int $a_pool_id, int $a_user_id, ilBookingPreferences $preferences)
	Save all preferences of a user for a pool. More...

Protected Attributes
ilDBInterface	$db

ILIAS BookingManager InternalDataService	$data

Detailed Description

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning Booking preferences repo

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

Definition at line 23 of file class.ilBookingPreferencesDBRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ilBookingPreferencesDBRepository::__construct	(	ILIAS\BookingManager\InternalDataService	$data,
		?ilDBInterface	$db = `null`
	)

Definition at line 28 of file class.ilBookingPreferencesDBRepository.php.

References $data, $db, and $DIC.

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

Member Function Documentation

◆ getPreferences()

ilBookingPreferencesDBRepository::getPreferences ( int $a_pool_id )

Get booking preferences for a pool id.

Definition at line 42 of file class.ilBookingPreferencesDBRepository.php.

References $db, ilDBInterface\fetchAssoc(), and ilDBInterface\queryF().

Referenced by ilBookingPreferencesGUI\listBookingResults().

                                                   : ilBookingPreferences
     {
         $db = $this->db;
 
         $set = $db->queryF(
             "SELECT * FROM booking_preferences " .
             " WHERE book_pool_id = %s ",
             array("integer"),
             array($a_pool_id)
         );
         $preferences = [];
         while ($rec = $db->fetchAssoc($set)) {
             if (!isset($preferences[$rec["user_id"]]) || !in_array($rec["book_obj_id"], $preferences[$rec["user_id"]], true)) {
                 $preferences[$rec["user_id"]][] = $rec["book_obj_id"];
             }
         }
         return $this->data->preferences($preferences);
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getPreferencesOfUser()

ilBookingPreferencesDBRepository::getPreferencesOfUser	(	int	$a_pool_id,
		int	$a_user_id
	)

Get booking preferences for a pool id.

Definition at line 64 of file class.ilBookingPreferencesDBRepository.php.

References $db, ilDBInterface\fetchAssoc(), and ilDBInterface\queryF().

Referenced by ilBookingPreferencesGUI\initPreferenceForm(), and ilBookingPreferencesGUI\listBookingResults().

      : ilBookingPreferences {
         $db = $this->db;
 
         $set = $db->queryF(
             "SELECT * FROM booking_preferences " .
             " WHERE book_pool_id = %s " .
             " AND user_id = %s ",
             array("integer", "integer"),
             array($a_pool_id, $a_user_id)
         );
         $preferences = [];
         while ($rec = $db->fetchAssoc($set)) {
             if (!isset($preferences[$rec["user_id"]]) || !in_array($rec["book_obj_id"], $preferences[$rec["user_id"]], true)) {
                 $preferences[$rec["user_id"]][] = $rec["book_obj_id"];
             }
         }
         return $this->data->preferences($preferences);
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ savePreferences()

ilBookingPreferencesDBRepository::savePreferences	(	int	$a_pool_id,
		ilBookingPreferences	$preferences
	)

Save all preferences of a pool.

Definition at line 89 of file class.ilBookingPreferencesDBRepository.php.

References $db, $user_id, ilDBInterface\insert(), and ilDBInterface\manipulateF().

      : void {
         $db = $this->db;
 
         $db->manipulateF(
             "DELETE FROM booking_preferences WHERE " .
             " book_pool_id = %s",
             array("integer"),
             array($a_pool_id)
         );
 
         foreach ($preferences as $user_id => $obj_ids) {
             if (is_array($obj_ids) && $user_id > 0) {
                 foreach ($obj_ids as $obj_id) {
                     $db->insert("booking_preferences", array(
                         "book_pool_id" => array("integer", $a_pool_id),
                         "user_id" => array("integer", $user_id),
                         "book_obj_id" => array("integer", $obj_id),
                     ));
                 }
             }
         }
     }

Here is the call graph for this function:

◆ savePreferencesOfUser()

ilBookingPreferencesDBRepository::savePreferencesOfUser	(	int	$a_pool_id,
		int	$a_user_id,
		ilBookingPreferences	$preferences
	)

Save all preferences of a user for a pool.

Definition at line 118 of file class.ilBookingPreferencesDBRepository.php.

References $db, $user_id, ilBookingPreferences\getPreferences(), ilDBInterface\insert(), and ilDBInterface\manipulateF().

Referenced by ilBookingPreferencesGUI\savePreferences().

      : void {
         $db = $this->db;
 
         $db->manipulateF(
             "DELETE FROM booking_preferences WHERE " .
             " book_pool_id = %s" .
             " AND user_id = %s",
             array("integer","integer"),
             array($a_pool_id, $a_user_id)
         );
 
         foreach ($preferences->getPreferences() as $user_id => $obj_ids) {
             if (is_array($obj_ids) && $user_id === $a_user_id) {
                 foreach ($obj_ids as $obj_id) {
                     $db->insert("booking_preferences", array(
                         "book_pool_id" => array("integer", $a_pool_id),
                         "user_id" => array("integer", $user_id),
                         "book_obj_id" => array("integer", $obj_id),
                     ));
                 }
             }
         }
     }