<?php

namespace App\Event\History\Admin;

use App\Event\History\AbstractObj;
use Qs_Db_Filter;
use Qs_Db_Obj;
use Zend_Db_Select;

class Obj extends AbstractObj
{
    protected function _filter(Zend_Db_Select $select)
    {
        parent::_filter($select);
        foreach ($this->_getCleanedFilter($this->_filter) as $field => $value) {
            switch ($field) {
                case 'attendeeName':
                    Qs_Db_Filter::where($select, ['firstName', 'lastName'], $value);
                    break;
                case 'eventName':
                    $word = str_replace(array('\\', '_', '%'), array('\\\\', '\_', '\%'), $value);
                    $select->where('`e`.`title` LIKE ?', '%' . $word . '%');
                    break;
                default:
                    break;
            }
        }
        return $this;
    }
}