Stores user settings per workspace folder Table: wfld_user_setting (rw) More...

Collaboration diagram for ilWorkspaceFolderUserSettingsRepository:

Public Member Functions
	__construct ($user_id, ilDBInterface $db=null)
	Constructor. More...

	getSortation (int $wfld_id)
	Get Sortation of workspace folder. More...

	getSortationMultiple (array $wfld_ids)
	Get Sortation of workspace folder. More...

	updateSortation (int $wfld_id, int $sortation)
	Update sortation for workspace folder. More...

Protected Attributes
	$user_id

	$db

Detailed Description

Stores user settings per workspace folder Table: wfld_user_setting (rw)

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

Definition at line 11 of file class.ilWorkspaceFolderUserSettingsRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ilWorkspaceFolderUserSettingsRepository::__construct	(		$user_id,
		ilDBInterface	$db = `null`
	)

Constructor.

Definition at line 27 of file class.ilWorkspaceFolderUserSettingsRepository.php.

References $db, $DIC, and $user_id.

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

Member Function Documentation

◆ getSortation()

ilWorkspaceFolderUserSettingsRepository::getSortation ( int $wfld_id )

Get Sortation of workspace folder.

Parameters

int $wfld_id folder object id

Returns: int

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

References $db.

                                                : int
     {
         $db = $this->db;
 
         $set = $db->queryF(
             "SELECT * FROM wfld_user_setting " .
             " WHERE user_id = %s " .
             " AND wfld_id = %s ",
             array("integer", "integer"),
             array($this->user_id, $wfld_id)
         );
         $rec = $db->fetchAssoc($set);
         return (int) $rec["sortation"];
     }

◆ getSortationMultiple()

ilWorkspaceFolderUserSettingsRepository::getSortationMultiple ( array $wfld_ids )

Get Sortation of workspace folder.

Parameters

int[] $wfld_id folder object ids

Returns: int[]

Definition at line 62 of file class.ilWorkspaceFolderUserSettingsRepository.php.

References $db, and $ret.

                                                           : array
     {
         $db = $this->db;
 
         $set = $db->queryF(
             "SELECT * FROM wfld_user_setting " .
             " WHERE user_id = %s " .
             " AND " . $db->in("wfld_id", $wfld_ids, false, "integer"),
             array("integer"),
             array($this->user_id)
         );
         $ret = [];
 
         while ($rec = $db->fetchAssoc($set)) {
             $ret[$rec["wfld_id"]] = (int) $rec["sortation"];
         }
         foreach ($wfld_ids as $id) {
             if (!isset($ret[$id])) {
                 $ret[$id] = 0;
             }
         }
         return $ret;
     }

◆ updateSortation()

ilWorkspaceFolderUserSettingsRepository::updateSortation	(	int	$wfld_id,
		int	$sortation
	)

Update sortation for workspace folder.

Parameters

int	$wfld_id	folder object id
int	$sortation

Definition at line 91 of file class.ilWorkspaceFolderUserSettingsRepository.php.

References $db.

     {
         $db = $this->db;
 
         $db->replace("wfld_user_setting", array(                // pk
                 "user_id" => array("integer", $this->user_id),
                 "wfld_id" => array("integer", $wfld_id)
             ), array(
                 "sortation" => array("integer", $sortation)
             ));
     }