ilAccessibilityTableDatabaseDataProvider Class Reference

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)
	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.

    {
        $this->db = $db;
    }

References $db.

Member Function Documentation

getFromPart()

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

abstractprotected

Parameters

array	$params
array	$filter

Returns

string

Referenced by 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 getList().

Here is the caller graph for this function:

getHavingPart()

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

abstractprotected

Parameters

array	$params
array	$filter

Returns

string @abstract

Referenced by 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.

                                                          : 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;
    }

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

Here is the call graph for this function:

getOrderByPart()

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

abstractprotected

Parameters

array	$params
array	$filter

Returns

string

Referenced by getList().

Here is the caller graph for this function:

getSelectPart()

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

abstractprotected

Parameters

array	$params
array	$filter

Returns

string

Referenced by getList().

Here is the caller graph for this function:

getWherePart()

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

abstractprotected

Parameters

array	$params
array	$filter

Returns

string

Referenced by getList().

Here is the caller graph for this function:

Field Documentation

$db

ilAccessibilityTableDatabaseDataProvider::$db

protected

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

Referenced by __construct().

---

The documentation for this class was generated from the following file:

• Services/Accessibility/classes/class.ilAccessibilityTableDatabaseDataProvider.php