ilTermsOfServiceAcceptanceHistoryProvider Class Reference

Inheritance diagram for ilTermsOfServiceAcceptanceHistoryProvider:

Collaboration diagram for ilTermsOfServiceAcceptanceHistoryProvider:

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

Author

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

Version

$Id$

Definition at line 10 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 39 of file class.ilTermsOfServiceAcceptanceHistoryProvider.php.

    {
        $joins = array(
            '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',
        );
        
        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 86 of file class.ilTermsOfServiceAcceptanceHistoryProvider.php.

    {
        return '';
    }

getHavingPart()

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

protected

Parameters

array	$params
array	$filter

Returns

string

Reimplemented from ilTermsOfServiceTableDatabaseDataProvider.

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

    {
        return '';
    }

getOrderByPart()

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

protected

Parameters

array	$params
array	$filter

Returns

string

Exceptions

InvalidArgumentException

Reimplemented from ilTermsOfServiceTableDatabaseDataProvider.

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

    {
        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'], array('lng', 'login', 'firstname', 'lastname', 'src', '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';
            } elseif (!in_array(strtolower($params['order_direction']), array('asc', 'desc'))) {
                throw new InvalidArgumentException('Please provide a valid order direction.');
            }
 
            return $params['order_field'] . ' ' . $params['order_direction'];
        }
        
        return '';
    }

References $params.

getSelectPart()

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

protected

Parameters

array	$params
array	$filter

Returns

string

Reimplemented from ilTermsOfServiceTableDatabaseDataProvider.

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

    {
        $fields = array(
            'tos_acceptance_track.tosv_id',
            'ud.usr_id',
            'ud.login',
            'ud.firstname',
            'ud.lastname',
            'tos_acceptance_track.ts',
            'tos_versions.src',
            'tos_versions.text',
            'tos_versions.lng'
        );
 
        return implode(', ', $fields);
    }

getWherePart()

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

protected

Parameters

array	$params
array	$filter

Returns

string

Reimplemented from ilTermsOfServiceTableDatabaseDataProvider.

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

    {
        $where = array();
 
        if (isset($filter['query']) && strlen($filter['query'])) {
            $where[] = '(' . implode(' OR ', array(
                $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['lng']) && strlen($filter['lng'])) {
            $where[] = 'tos_versions.lng = ' . $this->db->quote($filter['lng'], 'text');
        }
 
        if (isset($filter['period']) && is_array($filter['period'])) {
            $where[] = '(' . implode(' AND ', array(
                'tos_acceptance_track.ts >= ' . $this->db->quote($filter['period']['start'], 'integer'),
                'tos_acceptance_track.ts <= ' . $this->db->quote($filter['period']['end'], 'integer')
            )) . ')';
        }
 
        return implode(' AND ', $where);
    }

---

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

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