public function exportCommonMarket() { if (!Yii::app()->user->checkAccess("Export Decisions")) { throw new CHttpException(403, 'You are not authorized to access this feature'); } $export_key = 'cm'; $models = EacFacts::model()->findAll(); spl_autoload_unregister(array('YiiBase', 'autoload')); $phpExcelPath = Yii::getPathOfAlias('application.vendor.phpoffice'); include $phpExcelPath . DIRECTORY_SEPARATOR . 'PHPExcel.php'; // Create new PHPExcel object $objPHPExcel = new PHPExcel(); // Set properties $objPHPExcel->getProperties()->setCreator("EAMS Country TZ")->setLastModifiedBy("EAMs")->setTitle("EAMS TZ Export")->setSubject("EAMS TZ Export")->setDescription("EAMS TZ Export")->setKeywords("office 2007 openxml php")->setCategory("common market"); $objPHPExcel->getActiveSheet()->setTitle('Common Market'); // Add heading row $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', 'Freedoms / Rights')->setCellValue('B1', 'Provision')->setCellValue('C1', 'Indicator')->setCellValue('D1', 'Data Collection Guidelines')->setCellValue('E1', 'Numeric Data')->setCellValue('F1', 'Alphanumeric Data')->setCellValue('G1', 'Indicator_ID')->setCellValue('H1', 'data_field_code')->setCellValue('I1', 'reporting_period')->setCellValue('J1', 'financial_year'); $rowCount = 2; foreach ($models as $model) { $objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$rowCount}", $model->protocol_details)->setCellValue("B{$rowCount}", $model->protocol_provision_description)->setCellValue("C{$rowCount}", $model->indicator_description)->setCellValue("D{$rowCount}", $model->data_collection_guidelines)->setCellValue("E{$rowCount}", $model->numeric_data)->setCellValue("F{$rowCount}", $model->alphanumeric_data)->setCellValue("G{$rowCount}", $model->indicator_id)->setCellValue("H{$rowCount}", $model->data_field_code)->setCellValue("I{$rowCount}", 'reporting period')->setCellValue("J{$rowCount}", 'financial year'); $rowCount++; } // header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); // header('Content-Disposition: attachment;filename="template.xlsx"'); // header('Cache-Control: max-age=0'); $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); $targetDir = Yii::getPathOfAlias('webroot') . '/uploads/exports/'; $filename = 'common_market_export_' . md5(time() . uniqid('export', true)) . '.xlsx'; $objWriter->save($targetDir . $filename); spl_autoload_register(array('YiiBase', 'autoload')); $fileExportModel = new EamsFilesExport(); $fileExportModel->name = $filename; $fileExportModel->export_key = $export_key; $fileExportModel->mime_type = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'; $fileExportModel->file_extension = 'xlsx'; $fileExportModel->file_size = filesize($targetDir . $filename); $fileExportModel->date_created = date('Y-m-d H:i:s'); $fileExportModel->save(); $this->sendFileToEamsCentral($fileExportModel); }
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer $id the ID of the model to be loaded * @return EacFacts the loaded model * @throws CHttpException */ public function loadModel($id) { $model = EacFacts::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
public function actionSaveCommonMarket() { if (isset($_POST['data'])) { $data = json_decode($_POST['data']); foreach ($data as $key => $item) { if (!EacFacts::model()->exists('indicator_id = :id', [':id' => $item->indicator_id])) { $fact = new EacFacts(); $fact->protocol_id = $item->protocol_id; $fact->protocol_details = $item->protocol_details; $fact->protocol_provision_id = $item->protocol_provision_id; $fact->protocol_provision_description = $item->provision; $fact->data_field_code = $item->data_field_code; $fact->data_field_desc = ""; $fact->indicator_id = $item->indicator_id; $fact->indicator_description = $item->indicator; $fact->data_collection_guidelines = $item->data_collection_guidelines; $fact->date_created = date('Y-m-d H:i:s'); $fact->create_user_id = Yii::app()->user->id; $fact->date_updated = date('Y-m-d H:i:s'); $fact->update_user_id = Yii::app()->user->id; $fact->save(); } //if } //foreach } }