/**
*
*/
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);
}
