Class ilAccessibilityTableDatabaseDataProvider. More...

Inheritance diagram for ilAccessibilityTableDatabaseDataProvider:

Collaboration diagram for ilAccessibilityTableDatabaseDataProvider:

Public Member Functions
	__construct (ilDBInterface $db)
	ilAccessibilityTableDatabaseDataProvider constructor. More...

	getList (array $params, array $filter)

Protected Member Functions
	getSelectPart (array $params, array $filter)

	getFromPart (array $params, array $filter)

	getWherePart (array $params, array $filter)

	getGroupByPart (array $params, array $filter)

	getHavingPart (array $params, array $filter)

	getOrderByPart (array $params, array $filter)

Protected Attributes
	$db

Detailed Description

Class ilAccessibilityTableDatabaseDataProvider.

Definition at line 7 of file class.ilAccessibilityTableDatabaseDataProvider.php.

Constructor & Destructor Documentation

◆ __construct()

ilAccessibilityTableDatabaseDataProvider::__construct ( ilDBInterface $db )

ilAccessibilityTableDatabaseDataProvider constructor.

Parameters

ilDBInterface $db

Definition at line 16 of file class.ilAccessibilityTableDatabaseDataProvider.php.

References $db, getFromPart(), getGroupByPart(), getHavingPart(), getOrderByPart(), getSelectPart(), and getWherePart().

     {
         $this->db = $db;
     }

Here is the call graph for this function:

Member Function Documentation

◆ getFromPart()

ilAccessibilityTableDatabaseDataProvider::getFromPart	(	array	$params,
		array	$filter
	)

abstractprotected

Parameters

array	$params
array	$filter

Returns: string

Referenced by __construct(), and getList().

Here is the caller graph for this function:

◆ getGroupByPart()

ilAccessibilityTableDatabaseDataProvider::getGroupByPart	(	array	$params,
		array	$filter
	)

abstractprotected

Parameters

array	$params
array	$filter

Returns: string

Referenced by __construct(), and getList().

Here is the caller graph for this function:

◆ getHavingPart()

ilAccessibilityTableDatabaseDataProvider::getHavingPart	(	array	$params,
		array	$filter
	)

abstractprotected

Parameters

array	$params
array	$filter

Returns: string

Referenced by __construct(), and getList().

Here is the caller graph for this function:

◆ getList()

ilAccessibilityTableDatabaseDataProvider::getList	(	array	$params,
		array	$filter
	)

Parameters

array	$params
array	$filter

Returns: array

Exceptions

InvalidArgumentException

Implements ilAccessibilityTableDataProvider.

Definition at line 70 of file class.ilAccessibilityTableDatabaseDataProvider.php.

References $data, $query, $res, getFromPart(), getGroupByPart(), getHavingPart(), getOrderByPart(), getSelectPart(), and getWherePart().

                                                           : array
     {
         $data = [
             'items' => [],
             'cnt' => 0
         ];
 
         $select = $this->getSelectPart($params, $filter);
         $where = $this->getWherePart($params, $filter);
         $from = $this->getFromPart($params, $filter);
         $order = $this->getOrderByPart($params, $filter);
         $group = $this->getGroupByPart($params, $filter);
         $having = $this->getHavingPart($params, $filter);
 
         if (isset($params['limit'])) {
             if (!is_numeric($params['limit'])) {
                 throw new InvalidArgumentException('Please provide a valid numerical limit.');
             }
 
             if (!isset($params['offset'])) {
                 $params['offset'] = 0;
             } else {
                 if (!is_numeric($params['offset'])) {
                     throw new InvalidArgumentException('Please provide a valid numerical offset.');
                 }
             }
 
             $this->db->setLimit($params['limit'], $params['offset']);
         }
 
         $where = strlen($where) ? 'WHERE ' . $where : '';
         $query = "SELECT {$select} FROM {$from} {$where}";
 
         if (strlen($group)) {
             $query .= " GROUP BY {$group}";
         }
 
         if (strlen($having)) {
             $query .= " HAVING {$having}";
         }
 
         if (strlen($order)) {
             $query .= " ORDER BY {$order}";
         }
 
         $res = $this->db->query($query);
         while ($row = $this->db->fetchAssoc($res)) {
             $data['items'][] = $row;
         }
 
         if (isset($params['limit'])) {
             $cnt_sql = "SELECT COUNT(*) cnt FROM ({$query}) subquery";
             $row_cnt = $this->db->fetchAssoc($this->db->query($cnt_sql));
             $data['cnt'] = $row_cnt['cnt'];
         }
 
         return $data;
     }