ILIAS  trunk Revision v11.0_alpha-1749-g1a06bdef097
All Data Structures Namespaces Files Functions Variables Enumerations Enumerator Modules Pages
ILIAS\BookingManager\BookingProcess\SelectedObjectsDBRepository Class Reference
+ Collaboration diagram for ILIAS\BookingManager\BookingProcess\SelectedObjectsDBRepository:

Public Member Functions

 __construct (\ilDBInterface $db)
 
 getSelectedObjects (int $pool_id, int $user_id)
 
 setSelectedObjects (int $pool_id, int $user_id, array $obj_ids)
 

Protected Member Functions

 deleteSelectedObjects (int $pool_id, int $user_id)
 

Protected Attributes

ilDBInterface $db
 

Detailed Description

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

Definition at line 24 of file class.SelectedObjectsDBRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ILIAS\BookingManager\BookingProcess\SelectedObjectsDBRepository::__construct ( \ilDBInterface  $db)

Member Function Documentation

◆ deleteSelectedObjects()

ILIAS\BookingManager\BookingProcess\SelectedObjectsDBRepository::deleteSelectedObjects ( int  $pool_id,
int  $user_id 
)
protected

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

References ILIAS\BookingManager\BookingProcess\SelectedObjectsDBRepository\$db, and ilDBInterface\manipulateF().

Referenced by ILIAS\BookingManager\BookingProcess\SelectedObjectsDBRepository\setSelectedObjects().

64  : void
65  {
66  $db = $this->db;
68  "DELETE FROM book_sel_object WHERE " .
69  " user_id = %s" .
70  " AND pool_id = %s",
71  ["integer", "integer"],
72  [$user_id, $pool_id]
73  );
74  }
manipulateF(string $query, array $types, array $values)
+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ getSelectedObjects()

ILIAS\BookingManager\BookingProcess\SelectedObjectsDBRepository::getSelectedObjects ( int  $pool_id,
int  $user_id 
)

Definition at line 34 of file class.SelectedObjectsDBRepository.php.

References ILIAS\BookingManager\BookingProcess\SelectedObjectsDBRepository\$db, ILIAS\Repository\int(), and ilDBInterface\queryF().

34  : array
35  {
36  $db = $this->db;
37  $set = $db->queryF(
38  "SELECT * FROM book_sel_object " .
39  " WHERE user_id = %s " .
40  " AND pool_id = %s ",
41  ["integer", "integer"],
42  [$user_id, $pool_id]
43  );
44  $obj_ids = [];
45  while ($rec = $db->fetchAssoc($set)) {
46  $obj_ids[] = (int) $rec["object_id"];
47  }
48  return $obj_ids;
49  }
fetchAssoc(ilDBStatement $statement)
queryF(string $query, array $types, array $values)
+ Here is the call graph for this function:

◆ setSelectedObjects()

ILIAS\BookingManager\BookingProcess\SelectedObjectsDBRepository::setSelectedObjects ( int  $pool_id,
int  $user_id,
array  $obj_ids 
)

Definition at line 51 of file class.SelectedObjectsDBRepository.php.

References ILIAS\BookingManager\BookingProcess\SelectedObjectsDBRepository\$db, and ILIAS\BookingManager\BookingProcess\SelectedObjectsDBRepository\deleteSelectedObjects().

51  : void
52  {
53  $db = $this->db;
54  $this->deleteSelectedObjects($pool_id, $user_id);
55  foreach ($obj_ids as $obj_id) {
56  $db->insert("book_sel_object", [
57  "user_id" => ["integer", $user_id],
58  "pool_id" => ["integer", $pool_id],
59  "object_id" => ["integer", $obj_id]
60  ]);
61  }
62  }
insert(string $table_name, array $values)
+ Here is the call graph for this function:

Field Documentation

◆ $db


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