ilBookingPreferencesDBRepository Class Reference

Booking preferences repo. More...

Collaboration diagram for ilBookingPreferencesDBRepository:

Public Member Functions
	__construct (ilBookingPreferencesFactory $factory, ilDBInterface $db=null)
	Constructor. More...
	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
	$db
	$factory

Detailed Description

Booking preferences repo.

Author

killi.nosp@m.ng@l.nosp@m.eifos.nosp@m..de

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

Constructor & Destructor Documentation

__construct()

ilBookingPreferencesDBRepository::__construct	(	ilBookingPreferencesFactory	$factory,
		ilDBInterface	$db = null
	)

Constructor.

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

References $db, $DIC, and $factory.

    {
        global $DIC;

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

Member Function Documentation

getPreferences()

ilBookingPreferencesDBRepository::getPreferences

(

int

$a_pool_id

)

Get booking preferences for a pool id.

Parameters

int

$a_pool_id

Returns

ilBookingPreferences

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

References $db.

    {
        $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 (!is_array($preferences[$rec["user_id"]]) || !in_array($rec["book_obj_id"], $preferences[$rec["user_id"]])) {
                $preferences[$rec["user_id"]][] = $rec["book_obj_id"];
            }
        }
        return $this->factory->preferences($preferences);
    }

getPreferencesOfUser()

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

Get booking preferences for a pool id.

Parameters

int	$a_pool_id
int	$a_user_id

Returns

ilBookingPreferences

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

References $db.

    {
        $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 (!is_array($preferences[$rec["user_id"]]) || !in_array($rec["book_obj_id"], $preferences[$rec["user_id"]])) {
                $preferences[$rec["user_id"]][] = $rec["book_obj_id"];
            }
        }
        return $this->factory->preferences($preferences);
    }

savePreferences()

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

Save all preferences of a pool.

Parameters

int	$a_pool_id
	ilBookingPreferences	$

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

References $db.

    {
        $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),
                    ));
                }
            }
        }
    }

savePreferencesOfUser()

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

Save all preferences of a user for a pool.

Parameters

int	$a_pool_id
int	$a_user_id
ilBookingPreferences	$preferences

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

References $db, and ilBookingPreferences\getPreferences().

    {
        $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),
                    ));
                }
            }
        }
    }

Here is the call graph for this function:

Field Documentation

$db

ilBookingPreferencesDBRepository::$db

protected

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

Referenced by __construct(), getPreferences(), getPreferencesOfUser(), savePreferences(), and savePreferencesOfUser().

$factory

ilBookingPreferencesDBRepository::$factory

protected

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

Referenced by __construct().

---

The documentation for this class was generated from the following file:

• Modules/BookingManager/Preferences/classes/class.ilBookingPreferencesDBRepository.php