ILIAS  trunk Revision v11.0_alpha-2662-g519ff7d528f
Public Member Functions | Protected Attributes
ILIAS\Skill\Usage\UsageDBRepository Class Reference
+ Collaboration diagram for ILIAS\Skill\Usage\UsageDBRepository:

Public Member Functions

 __construct (\ilDBInterface $db)
 
 deleteHistoryUsagesLowerEqualThan (string $pc_type, string $a_type, int $a_id, int $a_usage_hist_nr, string $a_lang="-")
 

Protected Attributes

ilDBInterface $db
 

Detailed Description

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

Definition at line 26 of file class.UsageDBRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ILIAS\Skill\Usage\UsageDBRepository::__construct ( \ilDBInterface  $db)

Definition at line 30 of file class.UsageDBRepository.php.

References ILIAS\Skill\Usage\UsageDBRepository\$db.

31  {
32  $this->db = $db;
33  }

Member Function Documentation

◆ deleteHistoryUsagesLowerEqualThan()

ILIAS\Skill\Usage\UsageDBRepository::deleteHistoryUsagesLowerEqualThan ( string  $pc_type,
string  $a_type,
int  $a_id,
int  $a_usage_hist_nr,
string  $a_lang = "-" 
)

Definition at line 35 of file class.UsageDBRepository.php.

References ILIAS\Skill\Usage\UsageDBRepository\$db, $q, and ilDBInterface\quote().

41  : void {
42  $db = $this->db;
43 
44  $and_hist = " AND usage_hist_nr > 0 AND usage_hist_nr <= " . $db->quote($a_usage_hist_nr, "integer");
45 
46  $q = "DELETE FROM page_pc_usage WHERE usage_type = " .
47  $db->quote($a_type, "text") .
48  " AND usage_id = " . $db->quote((int) $a_id, "integer") .
49  " AND usage_lang = " . $db->quote($a_lang, "text") .
50  $and_hist .
51  " AND pc_type = " . $db->quote($pc_type, "text");
52  $db->manipulate($q);
53  }
ilDBInterface\quote
quote($value, string $type)
$q
$q
Definition: shib_logout.php:23
ilDBInterface\manipulate
manipulate(string $query)
Run a (write) Query on the database.
+ Here is the call graph for this function:

Field Documentation

◆ $db

ilDBInterface ILIAS\Skill\Usage\UsageDBRepository::$db
protected

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

Referenced by ILIAS\Skill\Usage\UsageDBRepository\__construct(), and ILIAS\Skill\Usage\UsageDBRepository\deleteHistoryUsagesLowerEqualThan().

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