public function helpAction() { $uri = $this->getRequest()->getParam('uri'); $ns = new Zend_Session_Namespace(); if (!empty($uri)) { $uri = Shineisp_Commons_UrlRewrites::format($uri); $data = $this->wiki->getPostbyUri($uri, "w.wiki_id, w.subject as subject, w.views as views, w.creationdate as creationdate, w.content as content, w.metakeywords as metakeywords, w.metadescription as metadescription, wc.category_id as category_id, wc.category as category"); if (isset($data[0])) { // Set the Metatag information $this->view->headTitle(" | " . $data[0]['subject']); if (!empty($data[0]['metakeywords'])) { $this->view->headMeta()->setName('keywords', $data[0]['metakeywords']); } if (!empty($data[0]['metadescription'])) { $this->view->headMeta()->setName('description', $data[0]['metadescription']); } // Getting the Products $products = Wikilinks::getProductsAttached($data[0]['wiki_id'], $ns->langid); if (count($products) > 0) { $this->view->placeholder("right")->append($this->view->partial('wiki/products_reference.phtml', array('products' => $products))); $this->getHelper('layout')->setLayout('2columns-right'); } // Update the counter Wiki::update_views($data[0]['wiki_id']); $data[0]['content'] = Shineisp_Commons_Contents::chkModule($data[0]['content']); $data[0]['content'] = Shineisp_Commons_Contents::chkCmsBlocks($data[0]['content'], $ns->lang); // Send the content to the page $this->view->headertitle = $this->translator->translate('Wiki page'); $this->view->post = $data[0]; } } }
/** * findbyvar * Get a record by Var * @param $var * @return array */ public static function findbyvar($var, $locale = "en") { $record = Doctrine_Query::create()->from('CmsPages cms')->leftJoin('cms.CmsPagesData cpd')->leftJoin('cpd.Languages l')->where('l.code = ?', $locale)->andWhere('cms.var = ?', $var)->execute(array(), Doctrine_Core::HYDRATE_ARRAY); if (!empty($record[0])) { $record[0]['body'] = Shineisp_Commons_Contents::chkModule($record[0]['body']); $record[0]['body'] = Shineisp_Commons_Contents::chkCmsBlocks($record[0]['body'], $locale); return $record[0]; } else { return false; } }