public function detailsreleaseAction() { // $this->view->jQuery()->addJavascriptFile($this->view->locateFile('jquery.prettyPhoto.js', 'jquery')); // $this->view->headLink()->appendStylesheet($this->view->locateFile('prettyPhoto.css'), 'screen'); $userId = 0; $id = $this->_getParam('ID'); $newsletterSelect = new NewsletterReleases(); $url = $this->_request->getPathInfo(); $fromEmail = (bool) preg_match('/-uid-[0-9]+/', $url); $user = Zend_Registry::get('user'); $memberId = 0; $blockID = $this->_getParam('BlockID'); $blockParams = Cible_FunctionsBlocks::getBlockParameters($blockID)->toArray(); $newsletterCategoryID = $blockParams[0]['P_Value']; if ($id == 0) { if ($fromEmail) { $pos = strpos($url, '-uid-'); $uid = explode('-', substr($url, $pos)); $memberId = end($uid); $url = substr_replace($url, '', $pos); $path = Zend_Registry::get('web_root') . '/'; setcookie('uid_newsletter', (string) $memberId, 0, $path); } else { if (isset($_COOKIE['uid_newsletter'])) { $memberId = $_COOKIE['uid_newsletter']; } } if ($memberId == 0 && $user) { $oMember = new MemberProfile(); $member = $oMember->findMember(array('email' => $user['email'])); $memberId = $member['member_id']; } $titleUrl = Cible_FunctionsGeneral::getTitleFromPath($url); if ($titleUrl != "") { $id = $newsletterSelect->getNewsletterIdByName($titleUrl); } } if (!empty($id)) { // release info $select = $newsletterSelect->select()->setIntegrityCheck(false); $select->from('Newsletter_Releases')->join('Languages', 'L_ID = NR_LanguageID', array())->join('CategoriesIndex', 'CI_CategoryID = NR_CategoryID', array())->join('Newsletter_Models_Index', 'NMI_NewsletterModelID = NR_ModelID', array())->join('Newsletter_Models', 'NM_ID = NMI_NewsletterModelID', array())->where('NR_LanguageID = ?', Zend_Registry::get("languageID"))->where('NR_CategoryID = ?', $newsletterCategoryID)->where('NR_Online = ?', 1)->where('NR_ID = ?', $id)->order('NR_Date DESC'); $newsletterData = $newsletterSelect->fetchRow($select); } else { $newsletterSelect = new NewsletterReleases(); $select = $newsletterSelect->select()->setIntegrityCheck(false); $select->from('Newsletter_Releases')->join('Languages', 'L_ID = NR_LanguageID', array())->join('CategoriesIndex', 'CI_CategoryID = NR_CategoryID', array())->join('Newsletter_Models_Index', 'NMI_NewsletterModelID = NR_ModelID', array())->join('Newsletter_Models', 'NM_ID = NMI_NewsletterModelID', array())->where('NR_LanguageID = ?', Zend_Registry::get("languageID"))->where('NR_CategoryID = ?', $newsletterCategoryID)->where('NR_Online = ?', 1)->order('NR_Date DESC'); $newsletterData = $newsletterSelect->fetchRow($select); $id = $newsletterData['NR_ID']; } if ($id != '' && $newsletterData['NR_Online'] == 1) { // articles info $newsletterArticlesSelect = new NewsletterArticles(); $select = $newsletterArticlesSelect->select(); $select->where('NA_ReleaseID = ?', $id)->order('NA_ZoneID')->order('NA_PositionID'); $newsletterArticlesData = $newsletterArticlesSelect->fetchAll($select); $this->view->articles = $newsletterArticlesData->toArray(); } else { $this->view->articles = array(); } $titleParution = $newsletterData['NR_Title']; $blockID = $this->_getParam('BlockID'); $blockParams = Cible_FunctionsBlocks::getBlockParameters($blockID)->toArray(); $newsletterCategoryID = $blockParams[0]['P_Value']; $details_page = Cible_FunctionsCategories::getPagePerCategoryView($newsletterCategoryID, 'details_article', 8); $this->view->assign('parution_title', $titleParution); $this->view->assign('parution_date', $newsletterData['NR_Date']); $this->view->assign('details_page', $details_page); $this->view->assign('back_to_release', $this->view->baseUrl() . "/" . Cible_FunctionsCategories::getPagePerCategoryView($newsletterCategoryID, 'details_release', 8)); $this->view->assign('subscribeLink', $this->view->baseUrl() . "/" . Cible_FunctionsCategories::getPagePerCategoryView($newsletterCategoryID, 'subscribe', 8)); $this->view->assign('unsubscribeLink', $this->view->baseUrl() . "/" . Cible_FunctionsCategories::getPagePerCategoryView($newsletterCategoryID, 'unsubscribe', 8)); $this->view->assign('archivesLink', $this->view->baseUrl() . "/" . Cible_FunctionsCategories::getPagePerCategoryView($newsletterCategoryID, 'list_archives', 8) . '/categoryID/' . $newsletterCategoryID); }