public function listAction() { if ($this->view->aclIsAllowed('LecteurRss', 'edit', true)) { // NEW LIST GENERATOR CODE // $tables = array('LecteurRssData' => array('ND_ID', 'ND_CategoryID', 'ND_Date', 'ND_ReleaseDate'), 'LecteurRssIndex' => array('NI_LecteurRssDataID', 'NI_LanguageID', 'NI_Title', 'NI_Status'), 'Status' => array('S_Code')); $field_list = array('NI_Title' => array('width' => '300px'), 'ND_Date' => array(), 'S_Code' => array('width' => '80px', 'postProcess' => array('type' => 'dictionnary', 'prefix' => 'status_'))); $this->view->params = $this->_getAllParams(); $blockID = $this->_getParam('blockID'); $pageID = $this->_getParam('pageID'); $blockParameters = Cible_FunctionsBlocks::getBlockParameters($blockID); $categoryID = $blockParameters[0]['P_Value']; $category = new CategoriesIndex(); $select = $category->select()->where('CI_CategoryID = ?', $categoryID)->where('CI_LanguageID = ?', Zend_Registry::get("languageID")); $categoryArray = $category->fetchRow($select); $this->view->assign('categoryName', $categoryArray['CI_Title']); $LecteurRss = new LecteurRssData(); $select = $LecteurRss->select()->from('LecteurRssData')->setIntegrityCheck(false)->join('LecteurRssIndex', 'LecteurRssData.ND_ID = LecteurRssIndex.NI_LecteurRssDataID')->join('Status', 'LecteurRssIndex.NI_Status = Status.S_ID')->where('ND_CategoryID = ?', $categoryID)->where('NI_LanguageID = ?', Zend_Registry::get("languageID")); //->order('NI_Title'); $options = array('commands' => array($this->view->link($this->view->url(array('controller' => 'index', 'action' => 'add')), $this->view->getCibleText('button_add_LecteurRss'), array('class' => 'action_submit add'))), 'filters' => array('LecteurRss-status-filter' => array('label' => 'Filtre 1', 'default_value' => null, 'associatedTo' => 'S_Code', 'choices' => array('' => $this->view->getCibleText('filter_empty_status'), 'online' => $this->view->getCibleText('status_online'), 'offline' => $this->view->getCibleText('status_offline')))), 'action_panel' => array('width' => '50', 'actions' => array('edit' => array('label' => $this->view->getCibleText('button_edit'), 'url' => "{$this->view->baseUrl()}/LecteurRss/index/edit/LecteurRssID/%ID%/pageID/" . $pageID . "/blockID/" . $blockID, 'findReplace' => array('search' => '%ID%', 'replace' => 'ND_ID')), 'delete' => array('label' => $this->view->getCibleText('button_delete'), 'url' => "{$this->view->baseUrl()}/LecteurRss/index/delete/LecteurRssID/%ID%/pageID/" . $pageID . "/blockID/" . $blockID, 'findReplace' => array('search' => '%ID%', 'replace' => 'ND_ID'))))); $mylist = new Cible_Paginator($select, $tables, $field_list, $options); $this->view->assign('mylist', $mylist); } }
public function ajaxAction() { /* * ********************************* */ // variables $action = $this->_getParam('actionAjax'); /* * ********************************* */ // Dissociate a person of a newsletter if ($action == 'dissociateMemberNewsletter') { $memberID = $this->_getParam('memberID'); $newsletterCategoryID = $this->_getParam('newsletterCategoryID'); $memberNewsletterCategories = $this->_getParam('memberNewslettersCat'); $memberNewsletterCategories = explode(',', $memberNewsletterCategories); $newsletterCategories = $this->view->GetAllNewsletterCategories(); $newsletterCategories = $newsletterCategories->toArray(); foreach ($memberNewsletterCategories as $memberCategory) { $i = 0; foreach ($newsletterCategories as $category) { if ($memberCategory == $category['CI_CategoryID']) { array_splice($newsletterCategories, $i, 1); } $i++; } } echo json_encode($newsletterCategories); } elseif ($action == 'associateMemberNewsletter') { $memberID = $this->_getParam('memberID'); $newsletterCategoryID = $this->_getParam('newsletterCategoryID'); $memberNewslettersCat = $this->_getParam('memberNewslettersCat'); $categorySelect = new CategoriesIndex(); $select = $categorySelect->select()->where("CI_CategoryID IN ({$memberNewslettersCat})")->where('CI_LanguageID = ?', Zend_Registry::get('languageID'))->order('CI_Title'); $categoryData = $categorySelect->fetchAll($select); //$this->view->dump($categoryData->toArray()); echo json_encode($categoryData->toArray()); } $this->getHelper('viewRenderer')->setNoRender(); }
public function listAction() { if ($this->view->aclIsAllowed('newsletter', 'manage', true)) { $tables = array('Newsletter_Releases' => array('NR_ID', 'NR_Title', 'NR_Date', 'NR_Online', 'NR_Status'), 'Status' => array('S_Code')); $field_list = array('NR_Title' => array(), 'NR_Date' => array('width' => '120px'), 'S_Code' => array('width' => '80px', 'postProcess' => array('type' => 'dictionnary', 'prefix' => 'status_')), 'NR_Status' => array('width' => '80px', 'postProcess' => array('type' => 'dictionnary', 'prefix' => 'send_'))); $this->view->params = $this->_getAllParams(); $blockID = $this->_getParam('blockID'); $pageID = $this->_getParam('pageID'); $blockParameters = Cible_FunctionsBlocks::getBlockParameters($blockID); $categoryID = $blockParameters[0]['P_Value']; $category = new CategoriesIndex(); $select = $category->select()->where('CI_CategoryID = ?', $categoryID)->where('CI_LanguageID = ?', Zend_Registry::get("languageID")); $categoryArray = $category->fetchRow($select); $this->view->assign('categoryName', $categoryArray['CI_Title']); //get all releases $releasesSelect = new NewsletterReleases(); $select = $releasesSelect->select()->setIntegrityCheck(false); $select->from('Newsletter_Releases')->join('CategoriesIndex', 'CI_CategoryID = NR_CategoryID')->join('Status', 'Newsletter_Releases.NR_Online = Status.S_ID')->where('CI_LanguageID = ?', Zend_Registry::get("languageID")); //->order('NR_Title'); $releasesData = $releasesSelect->fetchAll($select); $options = array('commands' => array($this->view->link($this->view->url(array('controller' => 'index', 'action' => 'add')), $this->view->getCibleText('button_add_newsletter'), array('class' => 'action_submit add'))), 'disable-export-to-excel' => 'true', 'filters' => array('newsletter-category-filter' => array('label' => 'Filtre 1', 'default_value' => null, 'associatedTo' => 'S_Code', 'choices' => array('' => $this->view->getCibleText('filter_empty_status'), 'online' => $this->view->getCibleText('status_online'), 'offline' => $this->view->getCibleText('status_offline'))), 'newsletter-status-filter' => array('label' => 'Filtre 2', 'default_value' => null, 'associatedTo' => 'NR_Status', 'choices' => array('' => $this->view->getCibleText('filter_empty_send'), 1 => $this->view->getCibleText('send_1'), 0 => $this->view->getCibleText('send_2')))), 'action_panel' => array('width' => '50', 'actions' => array('edit' => array('label' => $this->view->getCibleText('button_edit'), 'url' => "{$this->view->baseUrl()}/newsletter/index/edit/newsletterID/%ID%/pageID/" . $pageID . "/blockID/" . $blockID, 'findReplace' => array('search' => '%ID%', 'replace' => 'NR_ID')), 'delete' => array('label' => $this->view->getCibleText('button_delete'), 'url' => "{$this->view->baseUrl()}/newsletter/index/delete/newsletterID/%ID%/pageID/" . $pageID . "/blockID/" . $blockID, 'findReplace' => array('search' => '%ID%', 'replace' => 'NR_ID'))))); $mylist = new Cible_Paginator($select, $tables, $field_list, $options); $this->view->assign('mylist', $mylist); } }