/** * getPropertyValue * @param string $strPropertyName * @param integer $intWidgetInstanceId * @return Zend_Db_Table_Rowset_Abstract * @author Florian Mathis <*****@*****.**> * @version 1.0 */ public function getPropertyValue($strPropertyName = null, $intWidgetInstanceId = 0) { $this->core->logger->debug('widgets->blog->Model_BlogEntry->getPropertyValue(' . $strPropertyName . ', ' . $intWidgetInstanceId . ')'); $objSelect = $this->getWidgetInstancePropertiesTable()->select(); $objSelect->from($this->objWidgetInstancePropertiesTable, array('value')); $objSelect->join('widgetInstances', 'widgetInstances.id = widgetInstanceProperties.idWidgetInstances', array()); $objSelect->where('widgetInstances.widgetInstanceId = ?', $intWidgetInstanceId)->where('property = ?', $strPropertyName); $objData = $this->objWidgetInstancePropertiesTable->fetchRow($objSelect); return $objData['value']; }
/** * getTagsBySubwidgetId * @param string $strSubwidgetId * @return Zend_Db_Table_Abstract * @author Florian Mathis <*****@*****.**> * @version 1.0 */ public function getTagsBySubwidgetId($strSubwidgetId) { $this->core->logger->debug('widgets->blog->Model_BlogTags->getTagsBySubwidgetId(' . $strSubwidgetId . ')'); $objSelect = $this->getBlogEntryTagTable()->select(); $objSelect->setIntegrityCheck(false); $objSelect->from('tags', array('title')); $objSelect->join('tagSubwidgets', 'tagSubwidgets.idTags = tags.id', array()); $objSelect->where('tagSubwidgets.subwidgetId = ?', $strSubwidgetId); return $this->objBlogEntriesTagTable->fetchAll($objSelect); }