◆ __construct()
ilTermsOfServiceTableDatabaseDataProvider::__construct |
( |
ilDB |
$db | ) |
|
◆ getFromPart()
ilTermsOfServiceTableDatabaseDataProvider::getFromPart |
( |
array |
$params, |
|
|
array |
$filter |
|
) |
| |
|
abstractprotected |
◆ getGroupByPart()
ilTermsOfServiceTableDatabaseDataProvider::getGroupByPart |
( |
array |
$params, |
|
|
array |
$filter |
|
) |
| |
|
abstractprotected |
◆ getHavingPart()
ilTermsOfServiceTableDatabaseDataProvider::getHavingPart |
( |
array |
$params, |
|
|
array |
$filter |
|
) |
| |
|
abstractprotected |
◆ getList()
ilTermsOfServiceTableDatabaseDataProvider::getList |
( |
array |
$params, |
|
|
array |
$filter |
|
) |
| |
- Parameters
-
array | $params | |
array | $filter | |
- Returns
- array
- Exceptions
-
Implements ilTermsOfServiceTableDataProvider.
Definition at line 80 of file class.ilTermsOfServiceTableDatabaseDataProvider.php.
81 {
83 'items' => array(),
84 'cnt' => 0
85 );
86
93
95 {
96 if(!is_numeric(
$params[
'limit']))
97 {
98 throw new InvalidArgumentException('Please provide a valid numerical limit.');
99 }
100
102 {
104 }
105 else if(!is_numeric(
$params[
'offset']))
106 {
107 throw new InvalidArgumentException('Please provide a valid numerical offset.');
108 }
109
111 }
112
113 $where = strlen($where) ? 'WHERE ' . $where : '';
114 $query =
"SELECT {$select} FROM {$from} {$where}";
115
116 if(strlen($group))
117 {
118 $query .=
" GROUP BY {$group}";
119 }
120
121 if(strlen($having))
122 {
123 $query .=
" HAVING {$having}";
124 }
125
126 if(strlen($order))
127 {
128 $query .=
" ORDER BY {$order}";
129 }
130
132 while(
$row = $this->db->fetchAssoc(
$res))
133 {
135 }
136
138 {
139 $cnt_sql = "SELECT COUNT(*) cnt FROM ({$query}) subquery";
140 $row_cnt = $this->db->fetchAssoc($this->db->query($cnt_sql));
141 $data[
'cnt'] = $row_cnt[
'cnt'];
142 }
143
145 }
getWherePart(array $params, array $filter)
getOrderByPart(array $params, array $filter)
getSelectPart(array $params, array $filter)
getGroupByPart(array $params, array $filter)
getFromPart(array $params, array $filter)
getHavingPart(array $params, array $filter)
References $data, $params, $query, $res, $row, getFromPart(), getGroupByPart(), getHavingPart(), getOrderByPart(), getSelectPart(), and getWherePart().
◆ getOrderByPart()
ilTermsOfServiceTableDatabaseDataProvider::getOrderByPart |
( |
array |
$params, |
|
|
array |
$filter |
|
) |
| |
|
abstractprotected |
◆ getSelectPart()
ilTermsOfServiceTableDatabaseDataProvider::getSelectPart |
( |
array |
$params, |
|
|
array |
$filter |
|
) |
| |
|
abstractprotected |
◆ getWherePart()
ilTermsOfServiceTableDatabaseDataProvider::getWherePart |
( |
array |
$params, |
|
|
array |
$filter |
|
) |
| |
|
abstractprotected |
◆ $db
ilTermsOfServiceTableDatabaseDataProvider::$db |
|
protected |
The documentation for this class was generated from the following file: