/**
*
*/
public function indexAction()
{
$this->view->client = $this->_getParam('client');
$this->view->case = $this->_getParam('case');
// Search Client
$mapperClient = new Client_Model_Mapper_Client();
$this->view->clientRow = $mapperClient->detailClient($this->_getParam('client'));
}
/**
*
*/
public function evidenceAction()
{
$this->_helper->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$id = $this->_getParam('id');
$client = $this->_mapper->detailClient($id);
if (!empty($client->id_action_plan)) {
App_General_EvidenceCard::generate($client);
}
throw new Exception("Kliente ne'e seidauk iha Kazu Akonsellamentu");
}
/**
*
*/
public function printAction()
{
$this->_helper->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$id = $this->_getParam('id');
$clients = $this->_getParam('clients');
$clients = explode(',', $clients);
$this->_mapper->savePrint($id, $clients);
$mapperClient = new Client_Model_Mapper_Client();
$dataClient = array();
foreach ($clients as $client) {
$dataClient[] = $mapperClient->detailClient($client);
}
App_General_EvidenceCard::generate($dataClient);
}
/**
*
*/
public function fetchClientAction()
{
$mapperClient = new Client_Model_Mapper_Client();
$client = $mapperClient->detailClient($this->_getParam('id'));
$data = $client->toArray();
$data['fk_id_perdata'] = $data['id_perdata'];
$data['staff_name'] = Client_Model_Mapper_Client::buildName($client);
$data['birth_date'] = $data['birth_date_format'];
$data['gender'] = substr($data['gender'], 0, 1);
$this->_helper->json($data);
}
/**
*
* @param Zend_Db_Table_Row $businessPlan
* @return boolean|string
*/
protected function _checkBeneficiaryGraduation($businessPlan)
{
//if ( Fefop_Model_Mapper_Module::CEG != $businessPlan->fk_id_fefop_modules )
// return true;
$mapperClient = new Client_Model_Mapper_Client();
$client = $mapperClient->detailClient($businessPlan->fk_id_perdata);
$maxDili = array('SUPERIOR', 'POS-GRADUASAUN');
if (strtolower($businessPlan->district) == 'dili' && (is_int($client->max_level_scholarity) && $client->max_level_scholarity < 2 || !in_array($client->max_level_scholarity, $maxDili)) || strtolower($businessPlan->district) != 'dili' && $client->max_level_scholarity < 1) {
return sprintf('Kliente la iha Nivel Sertifikasaun Nasional level: %d', strtolower($businessPlan->district) == 'Dili' ? 2 : 1);
} else {
return true;
}
}
/**
*
* @param int $client
* @param int $idJobTraining
* @return string
*/
public function getFollowUpJob($client)
{
$view = Zend_Layout::getMvcInstance()->getView();
$mapperClient = new Client_Model_Mapper_Client();
$client = $mapperClient->detailClient($client);
$link = '<a href="%s" target="_blank">%s</a>';
$clientName = Client_Model_Mapper_Client::buildNumRow($client) . ' - ' . Client_Model_Mapper_Client::buildName($client);
$aClient = sprintf($link, $view->baseUrl('/client/client/view/id/' . $client->id_perdata), $clientName);
return sprintf(self::JOB_FOLLOW_UP, $aClient, $client->client_fone, $client->email);
}
/**
*
*/
public function fetchClientAction()
{
$mapperClient = new Client_Model_Mapper_Client();
$client = $mapperClient->detailClient($this->_getParam('id'));
$data = array();
$data['fk_id_perdata'] = $client['id_perdata'];
$data['beneficiary'] = Client_Model_Mapper_Client::buildName($client);
$this->_helper->json($data);
}
/**
*
*/
public function exportAction()
{
$id = $this->_getParam('id');
$row = $this->_mapper->detail($id);
$contractFiles = array('CEC' => 'Contrato_CEC_I_tet.xlsx', 'CED' => 'Contrato_CED_I_tet.xlsx');
// Fetch Contract
$mapperContract = new Fefop_Model_Mapper_Contract();
$contract = $mapperContract->detail($row->fk_id_fefop_contract);
$data = $row->toArray();
$data += $contract->toArray();
$data['contract'] = Fefop_Model_Mapper_Contract::buildNumById($row->fk_id_fefop_contract);
$data['date_inserted'] = $this->view->date($data['date_inserted']);
$data['date_start'] = $this->view->date($data['date_start'], 'yyyy-M-dd');
$data['date_finish'] = $this->view->date($data['date_finish'], 'yyyy-M-dd');
$mapperClient = new Client_Model_Mapper_Client();
$client = $mapperClient->detailClient($row->fk_id_perdata);
$data['evidence_card'] = Client_Model_Mapper_Client::buildNumRow($client);
$data['client_name'] = Client_Model_Mapper_Client::buildName($client);
$data['electoral'] = $client->electoral;
$data['gender'] = $client->gender;
$data['client_fone'] = $client->client_fone;
$data['email'] = $client->email;
$expensesRows = $mapperContract->listExpensesContract($row->fk_id_fefop_contract);
$expenses = array();
$total = 0;
foreach ($expensesRows as $expense) {
$expenses[] = array('name' => $expense->description, 'amount' => (double) $expense->amount);
$total += (double) $expense->amount;
}
$excelPath = APPLICATION_PATH . '/../library/PHPExcel/';
require_once $excelPath . 'PHPExcel/IOFactory.php';
$objReader = PHPExcel_IOFactory::createReader('Excel2007');
$objPHPExcel = $objReader->load(APPLICATION_PATH . '/../public/forms/FEFOP/' . $contractFiles[$data['num_module']]);
$activeSheet = $objPHPExcel->getActiveSheet();
$activeSheet->setCellValue('P12', $data['contract']);
$activeSheet->setCellValue('T8', $data['date_inserted']);
$activeSheet->setCellValue('F16', $data['evidence_card']);
$activeSheet->setCellValue('F17', $data['electoral']);
$activeSheet->setCellValue('E19', $data['client_name']);
$activeSheet->setCellValue('D100', $data['client_name']);
$activeSheet->setCellValue('Q19', $data['client_fone']);
$activeSheet->setCellValue('O20', $data['email']);
$activeSheet->setCellValue('F25', $data['name_disivion']);
$activeSheet->setCellValue('L25', $data['name_classtimor']);
$activeSheet->setCellValue('F27', $data['scholarity']);
$activeSheet->setCellValue('Q27', $data['external_code']);
$activeSheet->setCellValue('F29', $data['class_name']);
//$activeSheet->setCellValue( 'Q23', (float)$data['amount_training'] );
$activeSheet->setCellValue('F33', $data['date_start']);
$activeSheet->setCellValue('F34', $data['date_finish']);
//$activeSheet->setCellValue( 'J27', $data['duration'] . ' days' );
$activeSheet->setCellValue('P33', $data['district_course']);
$activeSheet->setCellValue('P34', $data['sub_district']);
$startExpense = 40;
$count = 'A';
foreach ($expenses as $expense) {
$activeSheet->setCellValue('B' . $startExpense, $count++);
$activeSheet->setCellValue('C' . $startExpense, $expense['name']);
$activeSheet->setCellValue('S' . $startExpense, $expense['amount']);
$startExpense++;
}
//$activeSheet->setCellValue( 'S' . $startExpense, $total );
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;
}
/**
*
* @return int
* @throws Exception
*/
protected function _getAge()
{
switch (true) {
case !empty($this->_dataModel['age']):
return $this->_dataModel['age'];
case !empty($this->_dataModel['client']) && is_object($this->_dataModel['client']):
return $this->_dataModel['client']->age;
case !empty($this->_dataModel['client']) && is_array($this->_dataModel['client']):
$mapperClient = new Client_Model_Mapper_Client();
$select = $mapperClient->selectClient();
$select->where('c.id_perdata IN(?)', (array) $this->_dataModel['client']);
$this->_dataModel['client'] = $this->_dbTable->fetchAll($select);
$ages = array();
foreach ($this->_dataModel['client'] as $client) {
$ages[] = $client->age;
}
return $ages;
case !empty($this->_dataModel['fk_id_perdata']):
$mapperClient = new Client_Model_Mapper_Client();
$this->_dataModel['client'] = $mapperClient->detailClient($this->_dataModel['fk_id_perdata']);
return $this->_dataModel['client']->age;
default:
$message = 'La hetan kliente tinan ba halo validasaun';
$this->_messageModel->addMessage($message, App_Message::ERROR);
throw new Exception($message);
}
}
/**
*
*/
public function editTraineeAction()
{
$this->_helper->layout()->disableLayout();
// Form Edit Trainee
$formEditTrainee = $this->_initForm('editTrainee');
$idTrainee = $this->_getParam('trainee');
$trainee = $this->_mapper->fetchTrainee($idTrainee);
$data = $trainee->toArray();
$date = new Zend_Date();
if (!empty($data['date_start'])) {
$data['date_start'] = $date->set($data['date_start'])->toString('dd/MM/yyyy');
}
if (!empty($data['date_finish'])) {
$data['date_finish'] = $date->set($data['date_finish'])->toString('dd/MM/yyyy');
}
$formEditTrainee->populate($data);
// Fetch the client
$mapperClient = new Client_Model_Mapper_Client();
$this->view->client = $mapperClient->detailClient($trainee->fk_id_perdata);
if (!$this->view->jobTrainingActive()->hasAccessEdit()) {
$formEditTrainee->getElement('save')->setAttrib('disabled', true);
}
$mapperFeContract = new Fefop_Model_Mapper_FEContract();
$contract = $mapperFeContract->getContractByTrainee($idTrainee);
if (!empty($contract)) {
$formEditTrainee->getElement('date_start')->setAttrib('readonly', true)->setAttrib('class', 'm-wrap span12');
$formEditTrainee->getElement('date_finish')->setAttrib('readonly', true)->setAttrib('class', 'm-wrap span12 ');
$this->view->contract = $contract->fk_id_fefop_contract;
}
$this->view->form = $formEditTrainee;
$this->view->trainee = $trainee;
}
/**
*
*/
public function fetchTraineeAction()
{
$id = $this->_getParam('id');
$mapperJobTraining = new StudentClass_Model_Mapper_JobTraining();
$trainee = $mapperJobTraining->fetchTrainee($id);
$data = array();
$mapperClient = new Client_Model_Mapper_Client();
$client = $mapperClient->detailClient($trainee->fk_id_perdata);
$contract = $this->_mapper->getContractByTrainee($id);
if (!empty($contract)) {
$data['valid'] = false;
} else {
$data['valid'] = true;
$data['fk_id_trainee'] = $trainee->id_trainee;
$data['fk_id_fefpenterprise'] = $trainee->fk_id_fefpenterprise;
$data['fk_id_fefpeduinstitution'] = $trainee->fk_id_fefpeduinstitution;
$data['entity'] = $trainee->entity;
$data['fk_id_scholarity_area'] = $trainee->fk_id_scholarity_area;
$data['beneficiary'] = Client_Model_Mapper_Client::buildName($client);
$data['fk_id_perdata'] = $trainee->fk_id_perdata;
$data['date_start'] = $trainee->date_start_formated;
$data['date_finish'] = $trainee->date_finish_formated;
$data['duration_month'] = $trainee->duration;
}
$this->_helper->json($data);
}
/**
*
*/
public function printAppointmentAction()
{
$this->_helper->layout()->setLayout('print');
$id = $this->_getParam('id');
$mapperAppointment = new Client_Model_Mapper_Appointment();
$this->view->appointment = $mapperAppointment->detailAppointment($id);
$this->view->objectives = $mapperAppointment->listObjectives($id);
$mapperClient = new Client_Model_Mapper_Client();
$this->view->client = $mapperClient->detailClient($this->view->appointment->fk_id_perdata);
}
/**
*
*/
public function exportAction()
{
$id = $this->_getParam('id');
$row = $this->_mapper->fetchBusinessPlan($id);
$contractFiles = array('CEG' => 'Contrato_CEG_tet.xlsx', 'CEC' => 'Contrato_CEC_II_tet.xlsx', 'CED' => 'Contrato_CED_II_tet.xlsx');
// Fetch Contract
$mapperContract = new Fefop_Model_Mapper_Contract();
$contract = $mapperContract->detail($row->fk_id_fefop_contract);
$data = $row->toArray();
$data += $contract->toArray();
$reserve_fund = $this->_mapper->getTotal($id, 'reserve_fund');
$reserve_fund = $reserve_fund < 1 ? 600 : $reserve_fund;
$data['contract'] = Fefop_Model_Mapper_Contract::buildNumById($row->fk_id_fefop_contract);
$data['business_plan'] = External_Model_Mapper_Pce::buildNumRow($row);
$data['date_inserted'] = $this->view->date($data['date_inserted']);
$dateInsert = new Zend_Date($data['date_inserted']);
$data['date_finish'] = $dateInsert->addYear(2)->toString('dd/MM/yyyy');
$mapperClient = new Client_Model_Mapper_Client();
$client = $mapperClient->detailClient($row->fk_id_perdata);
$data['evidence_card'] = Client_Model_Mapper_Client::buildNumRow($client);
$data['client_name'] = Client_Model_Mapper_Client::buildName($client);
$data['is_handicapped'] = Client_Model_Mapper_Client::isHandicapped($row->fk_id_perdata);
$data['electoral'] = $client->electoral;
$data['gender'] = $client->gender;
$data['client_fone'] = $client->client_fone;
$group = array();
$rowsGroup = $this->_mapper->listClientBusinessPlan($id);
foreach ($rowsGroup as $rowGroup) {
$group[] = array('name' => Client_Model_Mapper_Client::buildName($rowGroup), 'evidence_card' => Client_Model_Mapper_Client::buildNumRow($rowGroup), 'electoral' => $client->electoral, 'gender' => $client->gender, 'is_handicapped' => Client_Model_Mapper_Client::isHandicapped($client->id_perdata));
}
$expensesRows = $mapperContract->listExpensesContract($row->fk_id_fefop_contract);
$expenses = array();
$total = 0;
foreach ($expensesRows as $expense) {
$expenses[] = array('name' => $expense->description, 'amount' => (double) $expense->amount);
$total += (double) $expense->amount;
}
$excelPath = APPLICATION_PATH . '/../library/PHPExcel/';
require_once $excelPath . 'PHPExcel/IOFactory.php';
$objReader = PHPExcel_IOFactory::createReader('Excel2007');
$objPHPExcel = $objReader->load(APPLICATION_PATH . '/../public/forms/FEFOP/' . $contractFiles[$data['num_module']]);
$activeSheet = $objPHPExcel->getActiveSheet();
$activeSheet->setCellValue('P12', $data['contract']);
$activeSheet->setCellValue('Q40', $data['business_plan']);
$activeSheet->setCellValue('T8', $data['date_inserted']);
$activeSheet->setCellValue('F45', $data['date_inserted']);
$activeSheet->setCellValue('F46', $data['date_finish']);
$activeSheet->setCellValue('F16', $data['evidence_card']);
$activeSheet->setCellValue('F17', $data['electoral']);
$activeSheet->setCellValue('E19', $data['client_name']);
$activeSheet->setCellValue('D117', $data['client_name']);
$activeSheet->setCellValue('Q19', $data['client_fone']);
$activeSheet->setCellValue('O20', $data['email']);
$activeSheet->setCellValue('H25', $data['total_partisipants']);
// Responsible
$activeSheet->setCellValue('E28', $data['client_name']);
$activeSheet->setCellValue('M28', $data['evidence_card']);
$activeSheet->setCellValue('O28', $data['electoral']);
$activeSheet->setCellValue('Q28', $data['gender']);
$activeSheet->setCellValue('R28', $data['is_handicapped'] ? 'Sin' : 'Lae');
$startPerson = 29;
foreach ($group as $person) {
$activeSheet->setCellValue('E' . $startPerson, $person['name']);
$activeSheet->setCellValue('M' . $startPerson, $person['evidence_card']);
$activeSheet->setCellValue('O' . $startPerson, $person['electoral']);
$activeSheet->setCellValue('Q' . $startPerson, $person['gender']);
$activeSheet->setCellValue('R' . $startPerson, $person['is_handicapped'] ? 'Sin' : 'Lae');
$startPerson++;
}
$activeSheet->setCellValue('F38', $data['name_disivion']);
$activeSheet->setCellValue('L38', $data['name_classtimor']);
$activeSheet->setCellValue('F40', $data['project_name']);
$activeSheet->setCellValue('P45', $data['district']);
$activeSheet->setCellValue('P46', $data['sub_district']);
$activeSheet->setCellValue('P47', $data['sucu']);
$startExpense = 52;
$count = 'A';
foreach ($expenses as $expense) {
$activeSheet->setCellValue('B' . $startExpense, $count++);
$activeSheet->setCellValue('C' . $startExpense, $expense['name']);
$activeSheet->setCellValue('S' . $startExpense, $expense['amount']);
$startExpense++;
}
$activeSheet->setCellValue('B' . $startExpense, $count++);
$activeSheet->setCellValue('C' . $startExpense, 'Fundu Maneiu (600 USD + 10% rubrika sira iha leten)');
$activeSheet->setCellValue('S' . $startExpense, $reserve_fund);
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;
}
/**
*
*/
public function addClientAction()
{
if ($this->getRequest()->isXmlHttpRequest()) {
$this->_helper->layout()->disableLayout();
}
$id = $this->_getParam('id');
$row = $this->_getParam('row');
$no_edit = $this->_getParam('no_edit');
if (empty($row)) {
$mapperClient = new Client_Model_Mapper_Client();
$row = $mapperClient->detailClient($id);
}
$this->view->no_edit = $no_edit;
$this->view->client = $row;
}
/**
*
* @return int|bool
*/
public function saveStaff()
{
$dbAdapter = Zend_Db_Table_Abstract::getDefaultAdapter();
$dbAdapter->beginTransaction();
try {
$dbStaff = App_Model_DbTable_Factory::get('Staff');
$dataForm = $this->_data;
$mapperClient = new Client_Model_Mapper_Client();
$client = $mapperClient->detailClient($dataForm['fk_id_perdata']);
$this->_data['birth_date'] = $client->birth_date;
$this->_data['gender'] = substr($client->gender, 0, 1);
//$dateBirth = new Zend_Date( $this->_data['birth_date'] );
//$this->_data['birth_date'] = $dateBirth->toString( 'yyyy-MM-dd' );
if (empty($dataForm['id_staff'])) {
$history = 'INSERE STAFF OF INSTITUISAUN ENSINU: %s - %s - %s DADUS PRINCIPAL - INSERE NOVO STAFF OF INSTITUISAUN ENSINU';
} else {
$history = 'ALTERA STAFF OF INSTITUISAUN ENSINU: %s - %s - %s DADUS PRINCIPAL - ALTERA STAFF OF INSTITUISAUN ENSINU';
}
$id = parent::_simpleSave($dbStaff, false);
$history = sprintf($history, $dataForm['staff_name'], $id, $dataForm['fk_id_fefpeduinstitution']);
$this->_sysAudit($history, Register_Form_EducationInstitutionStaff::ID);
$dbAdapter->commit();
return $id;
} catch (Exception $e) {
$dbAdapter->rollBack();
$this->_message->addMessage($this->_config->messages->error, App_Message::ERROR);
return false;
}
}