public function init($options = null) { parent::init(); if ($this->_getParam('catID')) { $this->_categoryID = $this->_getParam('catID'); } }
public function setOnlineBlockAction() { parent::setOnlineBlockAction(); $blockID = $this->getRequest()->getParam('blockID'); // index the new text if block online $textSelect = new Text(); $select = $textSelect->select()->setIntegrityCheck(false)->from('TextData')->where('TD_BlockID = ?', $blockID)->join('Blocks', 'B_ID = TD_BlockID')->join('PagesIndex', 'PI_PageID = B_PageID')->where('PI_LanguageID = TD_LanguageID'); $textData = $textSelect->fetchAll($select); foreach ($textData as $text) { $indexData['pageID'] = $text['B_PageID']; $indexData['moduleID'] = $text['B_ModuleID']; $indexData['contentID'] = $text['TD_ID']; $indexData['languageID'] = $text['TD_LanguageID']; $indexData['title'] = $text['PI_PageTitle']; $indexData['text'] = ''; $indexData['link'] = ''; $indexData['contents'] = $text['PI_PageTitle'] . " " . $text['TD_OnlineText']; if ($text['PI_Status'] == 1) { if ($text['B_Online'] == 1) { $indexData['action'] = 'add'; } else { $indexData['action'] = 'delete'; } } else { $indexData['action'] = 'delete'; } Cible_FunctionsIndexation::indexation($indexData); } }
public function init() { parent::init(); $dataImagePath = "../../" . $this->_config->document_root . "/data/images/"; // $this->_catalogImageFolder = $dataImagePath // . $this->_moduleTitle . "/"; $this->_imageFolder = $dataImagePath . $this->_moduleTitle . "/" . $this->_name . "/"; $this->_rootImgPath = Zend_Registry::get("www_root") . "/data/images/" . $this->_moduleTitle . "/" . $this->_name . "/"; }
public function init() { parent::init(); $dataImagePath = "../../" . $this->_config->document_root . "/data/images/"; // $this->_catalogImageFolder = $dataImagePath // . $this->_moduleTitle . "/"; $this->_imagesFolder = $dataImagePath . $this->_moduleTitle . "/" . $this->_name . "/"; $this->_rootImgPath = Zend_Registry::get("www_root") . "/data/images/" . $this->_moduleTitle . "/" . $this->_name . "/"; $this->_rootFilePath = "../../" . "data/files/" . $this->_moduleTitle . "/" . $this->_name . "/"; $this->view->cleaction = $this->_name; $this->_imgIndex = 'imagefeat'; $config = Zend_Registry::get('config')->toArray(); //banners.imagefeat.number $this->_imgFeatureNumber = $config[$this->_moduleTitle][$this->_imgIndex]['number']; //echo $this->_imgFeatureNumber; }
/** * Export data according to given parameters. * * @return void */ public function toExcelAction() { $this->type = 'CSV'; $this->filename = $this->_actionKey . '.csv'; $params = array(); $actionName = $this->_actionKey . 'Action'; $params = $this->{$actionName}(true); $oDataName = $this->_objectList[$this->_actionKey]; $lines = new $oDataName(); $constraint = $lines->getConstraint(); $params['constraint'] = $constraint; $this->tables = array($lines->getDataTableName() => $lines->getDataColumns()); $this->view->params = $this->_getAllParams(); $columns = array_keys($params['columns']); $this->fields = array_combine($columns, $columns); $this->filters = array(); $pageID = $this->_getParam('pageID'); $langId = $this->_defaultEditLanguage; $select = $lines->getAll($langId, false); $select = $this->_addJoinQuery($select, $params); $this->select = $select; parent::toExcelAction(); }
/** * Manage table list for csv export. * * @return void */ public function toCsvAction() { // variables $pageID = $this->_getParam('pageID'); $returnAction = $this->_getParam('return'); $returnUrl = '/'; $blockID = $this->_getParam('blockID'); $baseDir = $this->view->baseUrl(); if ($this->view->aclIsAllowed($this->_moduleTitle, 'edit', true)) { $returnUrl .= $this->_moduleTitle . "/" . $this->_name . "/" . $this->_firstAction . "/"; if ($pageID > 0) { $returnUrl .= "page/" . $pageID . "/"; } // get the list of tables that may be exported $tablesList = $this->_tablesList; // generate the form to select tables to export $form = new FormExportCatalog(array('baseDir' => $baseDir, 'cancelUrl' => "{$baseDir}{$returnUrl}", 'selectedTables' => $tablesList)); $this->view->form = $form; // action if (!$this->_request->isPost()) { $form->populate($tablesList); } else { $formData = $this->_request->getPost(); $selectedTables = $formData['tablesList']; if ($selectedTables[0] == 'checkAll') { unset($selectedTables[0]); } if ($form->isValid($formData)) { if ($this->_ftpTransfer && $this->_exportFilesFolder) { $config = Zend_Registry::get('config'); $properties = $config->toArray(); $ftp = new Cible_Ftp($properties['ftpTransfer']); } // Process export foreach ($selectedTables as $name) { // if (isset($this->relatedId[$name])) // { $this->type = 'CSV'; $options['dataClass'] = $this->_formatName($name); $lines = new ExportObject($options); $dataColumns = $lines->getDataColumnsForExport(); $this->tables = array($name => $dataColumns); $this->fields = $dataColumns; $this->filters = array(); $this->select = $lines->getAll(null, false); if (is_array($this->relatedId) && count($this->relatedId) > 0) { $object = new $options['dataClass'](); //Get the constraint to find related data/table $field = $object->getConstraint(); //If no constraint it's the first table. We take the key. if (empty($field)) { $field = $object->getDataId(); } // Add where clause to the query if (isset($this->relatedId[$name]) && is_array($this->relatedId[$name]) && count($this->relatedId[$name]) > 0) { $this->select->where($field . " = ?", current($this->relatedId[$name])); for ($i = 1; $i < count($this->relatedId[$name]); $i++) { $this->select->orWhere($field . " = ?", $this->relatedId[$name][$i]); } } elseif (isset($this->relatedId[$name])) { $this->select->where($field . " = ?", $this->relatedId[$name]); } $name .= "_" . $this->_getParam('ID'); } $this->filename = $name . ".csv"; parent::toCsvAction(); if ($this->_ftpTransfer && $this->_exportFilesFolder) { $ftp->setFileName($this->filename); $ftp->setLocalFile($this->_exportFilesFolder . $this->filename); $ftp->transfer(); } // } } // return to list $this->_redirect($returnUrl); } } } }
/** * Export data according to given parameters. * * @return void */ public function toExcelAction() { $this->type = 'XLS'; $this->filename = 'Produit.xls'; $lines = new ProductsObject(); $this->tables = array('Catalog_ProductsData' => $lines->getDataColumns(), 'Catalog_ProductsIndex' => $lines->getIndexColumns()); $this->view->params = $this->_getAllParams(); $this->fields = array_merge($lines->getIndexColumns(), $lines->getDataColumns()); $this->filters = array(); $pageID = $this->_getParam('pageID'); $langId = $this->_registry->languageID; $this->select = $lines->getAll($langId, false); parent::toExcelAction(); }
public function categoriesToExcelAction() { if ($this->view->aclIsAllowed($this->view->current_module, 'edit')) { $this->filename = 'Categories.xlsx'; $this->tables = array('Categories' => array('C_ID'), 'CategoriesIndex' => array('CI_Title', 'CI_WordingShowAllRecords')); $this->fields = array('CI_Title' => array('label' => $this->view->getCibleText("list_column_{$this->_moduleID}_CI_Title")), 'CI_WordingShowAllRecords' => array()); $this->filters = array(); $this->select = $this->_db->select()->from('Categories', $this->tables['Categories'])->joinInner('CategoriesIndex', 'Categories.C_ID = CategoriesIndex.CI_CategoryID', $this->tables['CategoriesIndex'])->where('Categories.C_ModuleID = ?', Cible_FunctionsModules::getModuleIDByName($this->view->current_module))->where('CategoriesIndex.CI_LanguageID = ?', $this->_currentInterfaceLanguage); parent::toExcelAction(); } }