4require_once
'Services/TermsOfService/interfaces/interface.ilTermsOfServiceTableDataProvider.php';
96 if(!is_numeric(
$params[
'limit']))
98 throw new InvalidArgumentException(
'Please provide a valid numerical limit.');
105 else if(!is_numeric(
$params[
'offset']))
107 throw new InvalidArgumentException(
'Please provide a valid numerical offset.');
113 $where = strlen($where) ?
'WHERE ' . $where :
'';
114 $query =
"SELECT {$select} FROM {$from} {$where}";
118 $query .=
" GROUP BY {$group}";
123 $query .=
" HAVING {$having}";
128 $query .=
" ORDER BY {$order}";
132 while(
$row = $this->db->fetchAssoc(
$res))
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'];
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)
getFromPart(array $params, array $filter)
getHavingPart(array $params, array $filter)