예제 #1
0
 public function prepare()
 {
     $this->files = array();
     $templatePath = $this->templatePath;
     if (!empty($_FILES)) {
         $tempFile = $_FILES['CrudCode']['tmp_name']['file'];
         $fileTypes = array('xls', 'xlsx');
         // File extensions
         $fileParts = pathinfo($_FILES['CrudCode']['name']['file']);
         if (in_array(@$fileParts['extension'], $fileTypes)) {
             Yii::import('ext.heart.excel.EHeartExcel', true);
             EHeartExcel::init();
             $inputFileType = PHPExcel_IOFactory::identify($tempFile);
             $objReader = PHPExcel_IOFactory::createReader($inputFileType);
             $objPHPExcel = $objReader->load($tempFile);
             $sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);
             $baseRow = 2;
             $inserted = 0;
             $read_status = false;
             //die();
             while (!empty($sheetData[$baseRow]['A'])) {
                 $read_status = true;
                 $this->modelType = $sheetData[$baseRow]['B'];
                 $this->model = $sheetData[$baseRow]['C'];
                 $this->controller = $sheetData[$baseRow]['D'];
                 $this->modelParent = $sheetData[$baseRow]['E'];
                 $this->controllerParent = $sheetData[$baseRow]['F'];
                 $class = @Yii::import($this->model, true);
                 $table = CActiveRecord::model($class)->tableSchema;
                 $this->_modelClass = $class;
                 $this->_table = $table;
                 $controllerTemplateFile = $templatePath . DIRECTORY_SEPARATOR . 'controller.php';
                 $this->files[] = new CCodeFile($this->controllerFile, $this->render($controllerTemplateFile));
                 $files = scandir($templatePath);
                 foreach ($files as $file) {
                     if (is_file($templatePath . '/' . $file) && CFileHelper::getExtension($file) === 'php' && $file !== 'controller.php') {
                         $this->files[] = new CCodeFile($this->viewPath . DIRECTORY_SEPARATOR . $file, $this->render($templatePath . '/' . $file));
                     }
                 }
                 $baseRow++;
             }
             if ($this->files != array()) {
                 $this->save();
             }
         }
     } else {
         $controllerTemplateFile = $templatePath . DIRECTORY_SEPARATOR . 'controller.php';
         $this->files[] = new CCodeFile($this->controllerFile, $this->render($controllerTemplateFile));
         $files = scandir($templatePath);
         foreach ($files as $file) {
             if (is_file($templatePath . '/' . $file) && CFileHelper::getExtension($file) === 'php' && $file !== 'controller.php') {
                 $this->files[] = new CCodeFile($this->viewPath . DIRECTORY_SEPARATOR . $file, $this->render($templatePath . '/' . $file));
             }
         }
     }
 }
예제 #2
0
 public function init()
 {
     if (isset($_GET[$this->grid_mode_var])) {
         $this->grid_mode = $_GET[$this->grid_mode_var];
     }
     if (isset($_GET['exportType'])) {
         $this->exportType = $_GET['exportType'];
     }
     if ($this->grid_mode == 'export') {
         $this->title = $this->title ? $this->title : Yii::app()->getController()->getPageTitle();
         $this->initColumns();
     }
     if ($this->exportType == "PDF") {
         Yii::import('ext.heart.pdf.EHeartPDF', true);
         EHeartPDF::init();
         // create new PDF document
         $this->pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
         $this->pdf->SetCreator(PDF_CREATOR);
         $this->pdf->SetAuthor('YiiHeart');
     }
     if ($this->exportType == "WORD") {
         Yii::import('ext.heart.opentbs.EHeartOpenTBS', true);
         EHeartOpenTBS::init();
         $this->TBS = new clsTinyButStrong();
         // new instance of TBS
         $this->TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
         // load the OpenTBS plugin
         $templatePath = Yii::getPathOfAlias('ext.heart.opentbs');
         $template = $templatePath . DIRECTORY_SEPARATOR . 'template.docx';
         $this->TBS->LoadTemplate($template);
     } else {
         if ($this->grid_mode == 'export') {
             Yii::import('ext.heart.excel.EHeartExcel', true);
             EHeartExcel::init();
             $this->objPHPExcel = new PHPExcel();
             // Creating a workbook
             $this->objPHPExcel->getProperties()->setCreator($this->creator);
             $this->objPHPExcel->getProperties()->setTitle($this->title);
             $this->objPHPExcel->getProperties()->setSubject($this->subject);
             $this->objPHPExcel->getProperties()->setDescription($this->description);
             $this->objPHPExcel->getProperties()->setCategory($this->category);
         } else {
             parent::init();
         }
     }
 }
예제 #3
0
 /**
  * Creates a new model.
  * If creation is successful, the browser will be redirected to the 'view' page.
  */
 public function actionImport()
 {
     $model = new Realize();
     // Uncomment the following line if AJAX validation is needed
     // $this->performAjaxValidation($model);
     if (isset($_POST['Realize'])) {
         if (!empty($_FILES)) {
             $tempFile = $_FILES['Realize']['tmp_name']['fileImport'];
             $fileTypes = array('xls', 'xlsx');
             // File extensions
             $fileParts = pathinfo($_FILES['Realize']['name']['fileImport']);
             if (in_array(@$fileParts['extension'], $fileTypes)) {
                 Yii::import('ext.heart.excel.EHeartExcel', true);
                 EHeartExcel::init();
                 $inputFileType = PHPExcel_IOFactory::identify($tempFile);
                 $objReader = PHPExcel_IOFactory::createReader($inputFileType);
                 $objPHPExcel = $objReader->load($tempFile);
                 $sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);
                 $baseRow = 2;
                 $inserted = 0;
                 $read_status = false;
                 while (!empty($sheetData[$baseRow]['A'])) {
                     $read_status = true;
                     //$realize_id=  $sheetData[$baseRow]['A'];
                     $faktura_id = $sheetData[$baseRow]['B'];
                     $prod_id = $sheetData[$baseRow]['C'];
                     $price = $sheetData[$baseRow]['D'];
                     $count = $sheetData[$baseRow]['E'];
                     $model2 = new Realize();
                     //$model2->realize_id=  $realize_id;
                     $model2->faktura_id = $faktura_id;
                     $model2->prod_id = $prod_id;
                     $model2->price = $price;
                     $model2->count = $count;
                     try {
                         if ($model2->save()) {
                             $inserted++;
                         }
                     } catch (Exception $e) {
                         Yii::app()->user->setFlash('error', "{$e->getMessage()}");
                         //$this->refresh();
                     }
                     $baseRow++;
                 }
                 Yii::app()->user->setFlash('success', $inserted . ' row inserted');
             } else {
                 Yii::app()->user->setFlash('warning', 'Wrong file type (xlsx, xls, and ods only)');
             }
         }
         $this->render('admin', array('model' => $model));
     } else {
         $this->render('admin', array('model' => $model));
     }
 }
예제 #4
-1
 public function actionTemplate()
 {
     Yii::import('ext.heart.excel.EHeartExcel', true);
     EHeartExcel::init();
     $objPHPExcel = new PHPExcel();
     $objPHPExcel->getActiveSheet()->setCellValue('A1', 'No')->setCellValue('B1', 'ModelType')->setCellValue('C1', 'Model')->setCellValue('D1', 'Controller')->setCellValue('E1', 'ModelParent')->setCellValue('F1', 'ControllerParent');
     $modelPath = Yii::getPathOfAlias('application.models');
     $files = scandir($modelPath);
     $row = 2;
     foreach ($files as $file) {
         if (is_file($modelPath . '/' . $file) && CFileHelper::getExtension($file) === 'php' && !in_array($file, array('ContactForm.php', 'LoginForm.php', 'Admin.php', 'User.php'))) {
             $file_arr = explode(".", $file);
             $filename = $file_arr[0];
             $objPHPExcel->getActiveSheet()->setCellValue('A' . $row, $row - 1)->setCellValue('B' . $row, "1")->setCellValue('C' . $row, $filename)->setCellValue('D' . $row, 'test/' . $filename)->setCellValue('E' . $row, '-')->setCellValue('F' . $row, '-');
             $row++;
         }
     }
     // Redirect output to a client’s web browser (Excel2007)
     header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
     header('Content-Disposition: attachment;filename="models.xlsx"');
     header('Cache-Control: max-age=0');
     $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
     $objWriter->save('php://output');
     exit;
 }