ilTermsOfServiceAcceptanceHistoryProvider Class Reference

Class ilTermsOfServiceAcceptanceHistoryProvider. More...

Inheritance diagram for ilTermsOfServiceAcceptanceHistoryProvider:

Collaboration diagram for ilTermsOfServiceAcceptanceHistoryProvider:

Protected Member Functions
	getSelectPart (array $params, array $filter)
	Parameters array $params array $filter Returns string More...
	getFromPart (array $params, array $filter)
	Parameters array $params array $filter Returns string More...
	getWherePart (array $params, array $filter)
	Parameters array $params array $filter Returns string More...
	getGroupByPart (array $params, array $filter)
	Parameters array $params array $filter Returns string More...
	getHavingPart (array $params, array $filter)
	Parameters array $params array $filter Returns string @abstract More...
	getOrderByPart (array $params, array $filter)
	Parameters array $params array $filter Returns string More...
	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)

Additional Inherited Members
Public Member Functions inherited from ilTermsOfServiceTableDatabaseDataProvider
	__construct (ilDBInterface $db)
	ilTermsOfServiceTableDatabaseDataProvider constructor. More...
	getList (array $params, array $filter)
	getList (array $params, array $filter)
Protected Attributes inherited from ilTermsOfServiceTableDatabaseDataProvider
	$db

Detailed Description

Class ilTermsOfServiceAcceptanceHistoryProvider.

Author

Michael Jansen mjans.nosp@m.en@d.nosp@m.ataba.nosp@m.y.de

Definition at line 8 of file class.ilTermsOfServiceAcceptanceHistoryProvider.php.

Member Function Documentation

getFromPart()

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

protected

Parameters

array	$params
array	$filter

Returns

string

Reimplemented from ilTermsOfServiceTableDatabaseDataProvider.

Definition at line 33 of file class.ilTermsOfServiceAcceptanceHistoryProvider.php.

                                                                 : string
    {
        $joins = [
            'INNER JOIN tos_acceptance_track ON tos_acceptance_track.usr_id = ud.usr_id',
            'INNER JOIN tos_versions ON tos_versions.id = tos_acceptance_track.tosv_id',
            'LEFT JOIN tos_documents ON tos_documents.id = tos_versions.doc_id',
        ];
 
        return 'usr_data ud ' . implode(' ', $joins);
    }

getGroupByPart()

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

protected

Parameters

array	$params
array	$filter

Returns

string

Reimplemented from ilTermsOfServiceTableDatabaseDataProvider.

Definition at line 88 of file class.ilTermsOfServiceAcceptanceHistoryProvider.php.

                                                                    : string
    {
        return '';
    }

getHavingPart()

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

protected

Parameters

array	$params
array	$filter

Returns

string @abstract

Reimplemented from ilTermsOfServiceTableDatabaseDataProvider.

Definition at line 96 of file class.ilTermsOfServiceAcceptanceHistoryProvider.php.

                                                                   : string
    {
        return '';
    }

getOrderByPart()

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

protected

Parameters

array	$params
array	$filter

Returns

string

Reimplemented from ilTermsOfServiceTableDatabaseDataProvider.

Definition at line 104 of file class.ilTermsOfServiceAcceptanceHistoryProvider.php.

                                                                    : string
    {
        if (isset($params['order_field'])) {
            if (!is_string($params['order_field'])) {
                throw new InvalidArgumentException('Please provide a valid order field.');
            }
 
            if (in_array($params['order_field'], ['lng', 'src'])) {
                // Maybe necessary because of of migrated (from < 5.4.x) ILIAS installations
                $params['order_field'] = 'ts';
            }
 
            if (!in_array($params['order_field'], ['login', 'firstname', 'lastname', 'title', 'ts'])) {
                throw new InvalidArgumentException('Please provide a valid order field.');
            }
 
            if ($params['order_field'] == 'ts') {
                $params['order_field'] = 'tos_acceptance_track.ts';
            }
 
            if (!isset($params['order_direction'])) {
                $params['order_direction'] = 'ASC';
            } else {
                if (!in_array(strtolower($params['order_direction']), ['asc', 'desc'])) {
                    throw new InvalidArgumentException('Please provide a valid order direction.');
                }
            }
 
            return $params['order_field'] . ' ' . $params['order_direction'];
        }
 
        return '';
    }

getSelectPart()

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

protected

Parameters

array	$params
array	$filter

Returns

string

Reimplemented from ilTermsOfServiceTableDatabaseDataProvider.

Definition at line 13 of file class.ilTermsOfServiceAcceptanceHistoryProvider.php.

                                                                   : string
    {
        $fields = [
            'tos_acceptance_track.tosv_id',
            'tos_acceptance_track.criteria',
            'tos_acceptance_track.ts',
            'ud.usr_id',
            'ud.login',
            'ud.firstname',
            'ud.lastname',
            '(CASE WHEN tos_documents.title IS NOT NULL THEN tos_documents.title ELSE tos_versions.title END) title',
            'tos_versions.text',
        ];
 
        return implode(', ', $fields);
    }

getWherePart()

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

protected

Parameters

array	$params
array	$filter

Returns

string

Reimplemented from ilTermsOfServiceTableDatabaseDataProvider.

Definition at line 47 of file class.ilTermsOfServiceAcceptanceHistoryProvider.php.

                                                                  : string
    {
        $where = [];
 
        if (isset($filter['query']) && is_string($filter['query']) && strlen($filter['query']) > 0) {
            $where[] = '(' . implode(' OR ', [
                    $this->db->like('ud.login', 'text', '%' . $filter['query'] . '%'),
                    $this->db->like('ud.firstname', 'text', '%' . $filter['query'] . '%'),
                    $this->db->like('ud.lastname', 'text', '%' . $filter['query'] . '%'),
                    $this->db->like('ud.email', 'text', '%' . $filter['query'] . '%')
                ]) . ')';
        }
 
        if (isset($filter['period']) && is_array($filter['period'])) {
            $dateFilterParts = [];
 
            if (null !== $filter['period']['start']) {
                $dateFilterParts[] = 'tos_acceptance_track.ts >= ' . $this->db->quote(
                    $filter['period']['start'],
                    'integer'
                );
            }
 
            if (null !== $filter['period']['end']) {
                $dateFilterParts[] = 'tos_acceptance_track.ts <= ' . $this->db->quote(
                    $filter['period']['end'],
                    'integer'
                );
            }
 
            if (count($dateFilterParts) > 0) {
                $where[] = '(' . implode(' AND ', $dateFilterParts) . ')';
            }
        }
 
        return implode(' AND ', $where);
    }

---

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

• Services/TermsOfService/classes/History/class.ilTermsOfServiceAcceptanceHistoryProvider.php