/**
* Retruns tags for autocomplete
* @param AM_Model_Db_Page $oPage
* @param string $sTagName
* @return AM_Model_Db_Rowset_Term
*/
public function getTagsForAutocomplete(AM_Model_Db_Page $oPage, $sTagName)
{
$oVocabulary = $oPage->getRevision()->getVocabularyTag();
$oQuery = $this->select()->from('term')->setIntegrityCheck(false)->joinLeft('page', $this->getAdapter()->quoteInto('page.id = ?', $oPage->id), null)->joinLeft('term_page', 'term_page.page = page.id AND term_page.term = term.id', null)->where('term.vocabulary = ?', $oVocabulary->id)->where('term.deleted = "no"')->where('term_page.id IS NULL')->where('term.title LIKE CONCAT("%", ?, "%")', trim($sTagName));
$oTerms = $this->fetchAll($oQuery);
return $oTerms;
}
/**
* Get formatted array of TOC
* @return array
*/
protected function _getTocList()
{
$aResult = AM_Model_Db_Table_Abstract::factory('term')->getTocAsList($this->_oPage->getRevision());
return array('' => 'Nothing selected') + $aResult;
}
