<?php

namespace App\User\Autocomplete;

use Qs_Db;

abstract class AbstractObj extends \App\User\AbstractObj
{
    const TYPE_EVENT = 'event';
    const TYPE_MAIL  = 'mail';

    /**
     * @param null|string $type
     * @return \Zend_Db_Select
     */
    abstract protected function _getAutocompleteSelect($type = null);

    public function getAutocomplete($term, $type = null)
    {
        $select = $this->_getAutocompleteSelect($type);
        $q = Qs_Db::quoteLike($term);
        $select->where("`firstName` LIKE {$q} OR `lastName` LIKE {$q}");
        return $this->_db->fetchAll($select);
    }
}