<?php

namespace App\User\Autocomplete;


abstract class AbstractObj extends \App\User\AbstractObj
{
    const TYPE_TRADESHOW = 'tradeshow';
    const TYPE_EVENT     = 'event';

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

    public function getAutocomplete($term, $type = null)
    {
        $select = $this->_getAutocompleteSelect($type);
        $select->where(
            'CONCAT_WS(" ", IFNULL(User.`nickname`, User.`firstName`), User.`lastName`) LIKE ?',
            '%' . $term . '%'
        );
        return $this->_db->fetchAll($select);
    }
}