function updatezoneAction()
{
$articleID = $this->_getParam('articleID');
$newpositionID = $this->_getParam('newpositionID');
$newzoneID = $this->_getParam('newzoneID');
$newpositionID = $this->_getParam('newpositionID');
$newsletterArticleSelect = new NewsletterArticles();
$select = $newsletterArticleSelect->select();
$select->where('NA_ID = ?', $articleID);
$newsletterArticleData = $newsletterArticleSelect->fetchRow($select);
$releaseID = $newsletterArticleData['NA_ReleaseID'];
$oldzoneID = $newsletterArticleData['NA_ZoneID'];
$oldpositionID = $newsletterArticleData['NA_PositionID'];
//update zone
$newsletterArticleData['NA_ZoneID'] = $newzoneID;
$newsletterArticleData->save();
// update position (old zone)
$newsletterArticlePosition = new NewsletterArticles();
$where = 'NA_PositionID > ' . $oldpositionID;
$where .= ' AND NA_ReleaseID = ' . $releaseID;
$where .= ' AND NA_ZoneID = ' . $oldzoneID;
$newsletterArticlePosition->update(array('NA_PositionID' => new Zend_Db_Expr('NA_PositionID - 1 ')), $where);
// update position (new zone)
$where = 'NA_PositionID >= ' . $newpositionID;
$where .= ' AND NA_ReleaseID = ' . $releaseID;
$where .= ' AND NA_ZoneID = ' . $newzoneID;
$newsletterArticlePosition->update(array('NA_PositionID' => new Zend_Db_Expr('NA_PositionID + 1 ')), $where);
// update position article
$newsletterArticleData['NA_PositionID'] = $newpositionID;
$newsletterArticleData->save();
$this->getHelper('viewRenderer')->setNoRender();
}
public function showWebAction()
{
$this->view->title = "Aperçu de l'infolettre";
if ($this->view->aclIsAllowed('newsletter', 'manage', true)) {
$this->view->assign('isXmlHttpRequest', $this->_isXmlHttpRequest);
$this->view->assign('success', false);
if ($this->_request->isPost()) {
$this->view->assign('success', true);
} else {
$newsletterID = $this->_getParam('newsletterID');
$articleID = $this->_getParam('articleID');
$this->view->newsletterID = $newsletterID;
$this->view->articleID = $articleID;
// release info
$newsletterSelect = new NewsletterReleases();
$select = $newsletterSelect->select()->setIntegrityCheck(false);
$select->from('Newsletter_Releases')->join('Languages', 'L_ID = NR_LanguageID')->join('CategoriesIndex', 'CI_CategoryID = NR_CategoryID')->join('Newsletter_Models_Index', 'NMI_NewsletterModelID = NR_ModelID')->join('Newsletter_Models', 'NM_ID = NMI_NewsletterModelID')->where('CI_LanguageID = ?', Zend_Registry::get("languageID"))->where('NMI_LanguageID = ?', Zend_Registry::get("languageID"))->where('NR_ID = ?', $newsletterID);
$newsletterData = $newsletterSelect->fetchRow($select);
$this->view->template = $newsletterData['NM_DirectoryWeb'];
$newsletterTextIntro = $newsletterData['NR_TextIntro'];
$newsletterTextIntro = str_replace('##prenom##', 'Prénom Test', $newsletterTextIntro);
$newsletterTextIntro = str_replace('##nom##', 'Nom Test', $newsletterTextIntro);
$newsletterTextIntro = str_replace('##salutation##', 'Salutation Test', $newsletterTextIntro);
$this->view->intro = $newsletterTextIntro;
$this->view->newsletterTitle = $newsletterData['NR_Title'];
if ($articleID != '') {
// articles info
$newsletterArticlesSelect = new NewsletterArticles();
$select = $newsletterArticlesSelect->select();
$select->where('NA_ID = ?', $articleID);
$newsletterArticlesData = $newsletterArticlesSelect->fetchRow($select);
$this->view->article = $newsletterArticlesData->toArray();
} else {
/*
// release info
$newsletterSelect = new NewsletterReleases();
$select = $newsletterSelect->select()->setIntegrityCheck(false);
$select->from('Newsletter_Releases')
->join('Languages', 'L_ID = NR_LanguageID')
->join('CategoriesIndex', 'CI_CategoryID = NR_CategoryID')
->join('Newsletter_Models_Index', 'NMI_NewsletterModelID = NR_ModelID')
->join('Newsletter_Models', 'NM_ID = NMI_NewsletterModelID')
->where('CI_LanguageID = ?', Zend_Registry::get("languageID"))
->where('NMI_LanguageID = ?', Zend_Registry::get("languageID"))
->where('NR_ID = ?', $newsletterID);
$newsletterData = $newsletterSelect->fetchRow($select);
//$this->view->newsletter = $newsletterData->toArray();
//$this->view->newsletterID = $newsletterID;
//$this->view->articleID = $this->_getParam('articleID');
$this->view->template = $newsletterData['NM_DirectoryWeb'];
*/
// articles info
$newsletterArticlesSelect = new NewsletterArticles();
$select = $newsletterArticlesSelect->select();
$select->where('NA_ReleaseID = ?', $newsletterID)->order('NA_ZoneID')->order('NA_PositionID');
$newsletterArticlesData = $newsletterArticlesSelect->fetchAll($select);
$this->view->articles = $newsletterArticlesData->toArray();
}
$registry = Zend_Registry::getInstance()->set('format', 'web');
}
}
}
