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