Search

gistfile1.js

$searchQuery = Doctrine_Core::getTable('Model_Entity_City')
            ->search($this->_request->query);

        $searchIds = array();
        foreach ($searchQuery as $result) {
            $searchIds[] = $result['id'];
        }

        // DQL
        $query  = Doctrine_Query::create()
                ->from('Model_Entity_City c')
                ->whereIn('c.id', $searchIds)
                ->orderBy("c.id ASC")
                ->useQueryCache(Kebab_Cache_Query::isEnable());

        // Pager
        $responseData = $query->execute()->toArray();

        $this->_helper->response(true)->addTotal(count($responseData))->addData($responseData)->getResponse();