Exemplo n.º 1
0
 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);
     }
 }
Exemplo n.º 2
0
 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();
 }
Exemplo n.º 3
0
 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);
     }
 }