86 if (!is_numeric(
$params[
'limit'])) {
87 throw new \InvalidArgumentException(
'Please provide a valid numerical limit.');
90 if (!isset(
$params[
'offset'])) {
93 if (!is_numeric(
$params[
'offset'])) {
94 throw new \InvalidArgumentException(
'Please provide a valid numerical offset.');
101 $where = strlen($where) ?
'WHERE ' . $where :
'';
102 $query =
"SELECT {$select} FROM {$from} {$where}";
104 if (strlen($group)) {
105 $query .=
" GROUP BY {$group}";
108 if (strlen($having)) {
109 $query .=
" HAVING {$having}";
112 if (strlen($order)) {
113 $query .=
" ORDER BY {$order}";
117 while (
$row = $this->db->fetchAssoc(
$res)) {
122 $cnt_sql =
"SELECT COUNT(*) cnt FROM ({$query}) subquery";
123 $row_cnt = $this->db->fetchAssoc($this->db->query($cnt_sql));
124 $data[
'cnt'] = $row_cnt[
'cnt'];
An exception for terminatinating execution or to throw for unit testing.
Class ilTermsOfServiceTableDatabaseDataProvider.
getWherePart(array $params, array $filter)
getOrderByPart(array $params, array $filter)
getSelectPart(array $params, array $filter)
getGroupByPart(array $params, array $filter)
getList(array $params, array $filter)
__construct(\ilDBInterface $db)
ilTermsOfServiceTableDatabaseDataProvider constructor.
getFromPart(array $params, array $filter)
getHavingPart(array $params, array $filter)
Interface ilTermsOfServiceTableDataProvider.
foreach($_POST as $key=> $value) $res