<?php

class App_Test_Autocomplete_Obj extends Qs_Db_Obj
{
    protected $_tableAlias = 'DState';

    public function getStates($term)
    {
        $states = [];

        $select = $this->_db->select();
        $select->from($this->_getPair(), ['id', 'title']);
        $select->where('title LIKE ?', $term . '%');
        $select->order('title');
        $select->limit(50);

        if (($list = $this->_db->fetchAll($select))) {
            foreach ($list as $row) {
                $states[] = ['value' => $row['id'], 'title' => $row['title']];
            }
        }
        return $states;
    }
}