/** * 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; }