class.ilTermsOfServiceAcceptanceHistoryProvider.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2013 ILIAS open source, Extended GPL, see docs/LICENSE */

require_once 'Services/TermsOfService/classes/class.ilTermsOfServiceTableDatabaseDataProvider.php';

class ilTermsOfServiceAcceptanceHistoryProvider extends ilTermsOfServiceTableDatabaseDataProvider
{
        protected function getSelectPart(array $params, array $filter)
        {
                $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);
        }

        protected function getFromPart(array $params, array $filter)
        {
                $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);
        }

        protected function getWherePart(array $params, array $filter)
        {
                $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);
        }

        protected function getGroupByPart(array $params, array $filter)
        {
                return '';
        }

        protected function getHavingPart(array $params, array $filter)
        {
                return '';
        }

        protected function getOrderByPart(array $params, array $filter)
        {
                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';
                        }
                        else if(!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 '';
        }
}