Exemplo n.º 1
0
 public function actionIndex()
 {
     $model = new ExportObject();
     if (isset($_POST['ExportObject'])) {
         $model->attributes = $_POST['ExportObject'];
         if ($model->validate()) {
             echo $model->getDump();
             Yii::app()->end();
         }
     }
     $objects = DaObject::model()->findAll('table_name IS NOT NULL');
     $this->render('index', array('model' => $model, 'objects' => $objects));
 }
Exemplo n.º 2
0
 /**
  * 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);
             }
         }
     }
 }