/** * */ public function fetchNumClientAction() { $num = Client_Model_Mapper_Client::buildNumById($this->_getParam('id')); $this->_helper->json(array('num' => $num)); }
/** * */ public function exportAction() { $id = $this->_getParam('id'); $contract = $this->_mapper->detail($id); $data = $contract->toArray(); $data['contract'] = Fefop_Model_Mapper_Contract::buildNumById($contract->fk_id_fefop_contract); $data['evidence'] = Client_Model_Mapper_Client::buildNumById($contract->fk_id_perdata); $data['date_start'] = $this->view->date($data['date_start']); $data['date_finish'] = $this->view->date($data['date_finish']); $data['date_formation'] = $this->view->date($data['date_formation']); $data['date_inserted'] = $this->view->date($data['date_inserted']); $expenses = $this->_mapper->listExpenses($id); $data['expenses'] = $expenses->toArray(); $excelPath = APPLICATION_PATH . '/../library/PHPExcel/'; require_once $excelPath . 'PHPExcel/IOFactory.php'; $objReader = PHPExcel_IOFactory::createReader('Excel2007'); $objPHPExcel = $objReader->load(APPLICATION_PATH . '/../public/forms/FEFOP/Contrato_FE_tet.xlsx'); $activeSheet = $objPHPExcel->getActiveSheet(); $activeSheet->setCellValue('R10', $data['contract']); $activeSheet->setCellValue('V8', $data['date_inserted']); $activeSheet->setCellValue('F15', $data['scholarity_area']); $activeSheet->setCellValue('F16', $data['ocupation_name_timor']); $activeSheet->setCellValue('G21', $data['date_start']); $activeSheet->setCellValue('G22', $data['date_finish']); $activeSheet->setCellValue('K21', (int) $data['duration_month']); $activeSheet->setCellValue('Q21', $data['district']); $activeSheet->setCellValue('Q22', $data['sub_district']); $activeSheet->setCellValue('H28', $data['entity']); $activeSheet->setCellValue('H29', $data['beneficiary']); $activeSheet->setCellValue('E117', $data['beneficiary']); $activeSheet->setCellValue('S29', $data['evidence']); //$activeSheet->setCellValue( 'U28', $data['date_formation'] ); // Expenses $startRow = 34; foreach ($data['expenses'] as $expense) { $activeSheet->setCellValue('D' . $startRow, $expense['description']); $activeSheet->setCellValue('U' . $startRow, $expense['amount']); $startRow++; } header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); $file = sprintf('Contract_%s.xlsx', $data['contract']); header(sprintf('Content-Disposition: attachment;filename="%s"', $file)); header('Cache-Control: max-age=0'); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save('php://output'); exit; }
/** * * @param int $id * @return array */ protected function _contractToExport($id) { $contract = $this->_mapper->detail($id); $data = $contract->toArray(); $data['contract'] = Fefop_Model_Mapper_Contract::buildNumById($contract->fk_id_fefop_contract); $data['evidence'] = Client_Model_Mapper_Client::buildNumById($contract->fk_id_perdata); $data['formation_plan'] = Fefop_Model_Mapper_DRHTrainingPlan::buildNum($contract->fk_id_drh_trainingplan); $data['date_start'] = $this->view->date($data['date_start']); $data['date_finish'] = $this->view->date($data['date_finish']); $data['date_inserted'] = $this->view->date($data['date_inserted']); $data['modality'] = $this->view->nomenclature()->drhModality($data['modality']); $expenses = $this->_mapper->listExpenses($id); $data['expenses'] = $expenses->toArray(); return $data; }
/** * */ public function certificateAction() { $id = $this->_getParam('id'); $case = $this->_mapper->detailCase($id); $data = array('beneficiary' => Client_Model_Mapper_Client::buildNameById($case->fk_id_perdata), 'evidence' => Client_Model_Mapper_Client::buildNumById($case->fk_id_perdata)); $file = APPLICATION_PATH . '/../public/forms/Kazu/Sertifikadu_Atendimentu.rtf'; App_Util_Export::toRtf($file, $data); }