/**
*
* @param int $id
* @return Zend_Db_Table_Rowset
*/
public function listClient($id)
{
$mapperClient = new Client_Model_Mapper_Client();
$selectClient = $mapperClient->selectClient();
$dbGroupContact = App_Model_DbTable_Factory::get('SmsGroupContact');
$selectClient->join(array('gc' => $dbGroupContact), 'gc.fk_id_perdata = c.id_perdata', array())->where('gc.fk_id_sms_group = ?', $id);
return $dbGroupContact->fetchAll($selectClient);
}
/**
*
*/
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'));
}
/**
*
* @return array
*/
public function getDataClassIndmo()
{
$dbStudentClassSent = App_Model_DbTable_Factory::get('StudentClass_Sent');
$rows = $dbStudentClassSent->fetchAll(array('sent = ?' => 0));
$mapperStudentClass = new StudentClass_Model_Mapper_StudentClass();
$mapperScholarity = new Register_Model_Mapper_PerScholarity();
$classes = array();
foreach ($rows as $row) {
$class = $mapperStudentClass->detailStudentClass($row->fk_id_fefpstudentclass);
$course = $mapperScholarity->fetchRow($class->fk_id_perscholarity);
$dataClass = array('id' => $class->id_fefpstudentclass, 'title' => $class->class_name, 'start_date' => $class->start_date, 'finish_date' => $class->schedule_finish_date, 'qualification' => $course->remote_id, 'training_provider' => $class->num_register, 'id_training_provider' => $class->fk_id_fefpeduinstitution);
$students = $mapperStudentClass->listClientClass($row->fk_id_fefpstudentclass);
$studentsClass = array();
foreach ($students as $student) {
$dataStudent = array('id' => $student->id_perdata, 'first_name' => $student->first_name, 'second_name' => $student->medium_name, 'evidence' => Client_Model_Mapper_Client::buildNumRow($student), 'last_name' => $student->last_name, 'district' => $student->num_district, 'sub_district' => $student->num_subdistrict, 'birth_date' => $student->birth_date, 'gender' => $student->gender, 'email' => $student->email, 'tel' => $student->client_fone, 'result' => $student->status_class, 'competencies' => array());
$competencies = $mapperStudentClass->listCompetencyClass($row->fk_id_fefpstudentclass, $student->id_perdata);
foreach ($competencies as $competency) {
$dataStudent['competencies'][] = array('id' => $competency->id_external, 'code' => $competency->external_code, 'result' => $competency->status);
}
$studentsClass[] = $dataStudent;
}
$dataClass['students'] = $studentsClass;
$classes[] = $dataClass;
}
return $classes;
}
/**
*
* @return array
*/
protected function _validatePurposeData()
{
$return = array('msg' => 'OBJETIVO VIZITA', 'valid' => true);
$visit = $this->_mapperClient->listVisit($this->_data->id_perdata);
if ($visit->count() < 1) {
$return['valid'] = false;
}
return $return;
}
/**
*
*/
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 init()
{
$this->setAttrib('class', 'horizontal-form')->setName('search');
$elements = array();
$mapperFeContract = new Fefop_Model_Mapper_FEContract();
// Combo to search clients
$clients = $mapperFeContract->listBeneficiaries();
$optClients[''] = '';
foreach ($clients as $row) {
$optClients[$row['id_perdata']] = Client_Model_Mapper_Client::buildNumRow($row) . ' - ' . Client_Model_Mapper_Client::buildName($row);
}
$elements[] = $this->createElement('select', 'fk_id_perdata')->setDecorators($this->getDefaultElementDecorators())->setAttrib('class', 'm-wrap span12 chosen')->addMultiOptions($optClients)->setLabel('Benefisiariu');
// Combo to search enterprises
$enterprises = $mapperFeContract->listEnterprises();
$optEnterprises[''] = '';
foreach ($enterprises as $row) {
$optEnterprises[$row['id_fefpenterprise']] = $row['enterprise_name'];
}
$elements[] = $this->createElement('select', 'fk_id_fefpenterprise')->setDecorators($this->getDefaultElementDecorators())->setAttrib('class', 'm-wrap span12 chosen')->addMultiOptions($optEnterprises)->setLabel('Empreza');
// Combo to search institutes
$intitutes = $mapperFeContract->listInstitutes();
$optInstitutes[''] = '';
foreach ($intitutes as $row) {
$optInstitutes[$row['id_fefpeduinstitution']] = $row['institution'];
}
$elements[] = $this->createElement('select', 'fk_id_fefpeduinstitution')->setDecorators($this->getDefaultElementDecorators())->setAttrib('class', 'm-wrap span12 chosen')->addMultiOptions($optInstitutes)->setLabel('Inst. Ensinu');
$dbDistrict = App_Model_DbTable_Factory::get('AddDistrict');
$districts = $dbDistrict->fetchAll();
$optCountry[''] = '';
foreach ($districts as $district) {
$optCountry[$district['id_adddistrict']] = $district['District'];
}
$elements[] = $this->createElement('select', 'fk_id_adddistrict')->setDecorators($this->getDefaultElementDecorators())->setAttrib('class', 'm-wrap span12')->addMultiOptions($optCountry)->setLabel('Distritu');
$elements[] = $this->createElement('select', 'fk_id_addsubdistrict')->setDecorators($this->getDefaultElementDecorators())->setAttrib('class', 'm-wrap span12')->setRegisterInArrayValidator(false)->setLabel('Sub-Distritu');
$mapperScholarityArea = new Register_Model_Mapper_ScholarityArea();
$sections = $mapperScholarityArea->fetchAll();
$optScholarityArea[''] = '';
foreach ($sections as $section) {
$optScholarityArea[$section['id_scholarity_area']] = $section['scholarity_area'];
}
$elements[] = $this->createElement('select', 'fk_id_scholarity_area')->setDecorators($this->getDefaultElementDecorators())->setAttrib('class', 'm-wrap span12 chosen focused')->setLabel('Area Kursu')->addMultiOptions($optScholarityArea);
$dbOccupationTimor = App_Model_DbTable_Factory::get('PROFOcupationTimor');
$occupations = $dbOccupationTimor->fetchAll();
$optOccupations[''] = '';
foreach ($occupations as $occupation) {
$optOccupations[$occupation['id_profocupationtimor']] = $occupation['acronym'] . ' ' . $occupation['ocupation_name_timor'];
}
$elements[] = $this->createElement('select', 'fk_id_profocupationtimor')->setDecorators($this->getDefaultElementDecorators())->setAttrib('class', 'm-wrap span12 chosen')->setLabel('Okupasaun')->addMultiOptions($optOccupations);
$elements[] = $this->createElement('text', 'date_start')->setDecorators($this->getDefaultElementDecorators())->setAttrib('maxlength', 10)->setAttrib('class', 'm-wrap span12 date-mask date')->setLabel('Loron Inisiu');
$elements[] = $this->createElement('text', 'date_finish')->setDecorators($this->getDefaultElementDecorators())->setAttrib('maxlength', 10)->setAttrib('class', 'm-wrap span12 date-mask date')->setLabel('Loron Remata');
$this->addElements($elements);
}
public function init()
{
$this->setAttrib('class', 'horizontal-form')->setName('search');
$elements = array();
$mapperFeRegistration = new Fefop_Model_Mapper_FERegistration();
// Combo to search clients
$clients = $mapperFeRegistration->listBeneficiaries();
$optClients[''] = '';
foreach ($clients as $row) {
$optClients[$row['id_perdata']] = Client_Model_Mapper_Client::buildNumRow($row) . ' - ' . Client_Model_Mapper_Client::buildName($row);
}
$elements[] = $this->createElement('select', 'fk_id_perdata')->setDecorators($this->getDefaultElementDecorators())->setAttrib('class', 'm-wrap span12 chosen')->addMultiOptions($optClients)->setLabel('Benefisiariu');
// Combo to search enterprises
$enterprises = $mapperFeRegistration->listEnterprises();
$optEnterprises[''] = '';
foreach ($enterprises as $row) {
$optEnterprises[$row['id_fefpenterprise']] = $row['enterprise_name'];
}
$elements[] = $this->createElement('select', 'fk_id_fefpenterprise')->setDecorators($this->getDefaultElementDecorators())->setAttrib('class', 'm-wrap span12 chosen')->addMultiOptions($optEnterprises)->setLabel('Empreza');
// Combo to search institutes
$intitutes = $mapperFeRegistration->listInstitutes();
$optInstitutes[''] = '';
foreach ($intitutes as $row) {
$optInstitutes[$row['id_fefpeduinstitution']] = $row['institution'];
}
$elements[] = $this->createElement('select', 'fk_id_fefpeduinstitution')->setDecorators($this->getDefaultElementDecorators())->setAttrib('class', 'm-wrap span12 chosen')->addMultiOptions($optInstitutes)->setLabel('Inst. Ensinu');
$optIdentifier = array('selected' => "Formasaun iha servisu fatin ne'ebe hakarak");
$elements[] = $this->createElement('select', 'identifier')->setDecorators($this->getDefaultElementDecorators())->setAttrib('class', 'm-wrap span12 chosen focused')->setLabel('Formasaun')->addMultiOptions($optIdentifier);
$mapperScholarityArea = new Register_Model_Mapper_ScholarityArea();
$sections = $mapperScholarityArea->fetchAll();
$optScholarityArea[''] = '';
foreach ($sections as $section) {
$optScholarityArea[$section['id_scholarity_area']] = $section['scholarity_area'];
}
$elements[] = $this->createElement('select', 'fk_id_scholarity_area')->setDecorators($this->getDefaultElementDecorators())->setAttrib('class', 'm-wrap span12 chosen focused')->setLabel('Area Kursu')->addMultiOptions($optScholarityArea);
$dbOccupationTimor = App_Model_DbTable_Factory::get('PROFOcupationTimor');
$occupations = $dbOccupationTimor->fetchAll();
$optOccupations[''] = '';
foreach ($occupations as $occupation) {
$optOccupations[$occupation['id_profocupationtimor']] = $occupation['acronym'] . ' ' . $occupation['ocupation_name_timor'];
}
$elements[] = $this->createElement('select', 'fk_id_profocupationtimor')->setDecorators($this->getDefaultElementDecorators())->setAttrib('class', 'm-wrap span12 chosen')->setLabel('Dezignasaun')->addMultiOptions($optOccupations);
$dbScholarityLevel = App_Model_DbTable_Factory::get('PerLevelScholarity');
$levels = $dbScholarityLevel->fetchAll(array(), array('id_perlevelscholarity'));
$optLevel[''] = '';
foreach ($levels as $level) {
$optLevel[$level->id_perlevelscholarity] = $level->level_scholarity;
}
$elements[] = $this->createElement('select', 'fk_id_perlevelscholarity')->setDecorators($this->getDefaultElementDecorators())->setAttrib('class', 'm-wrap span12 chosen')->addMultiOptions($optLevel)->setLabel('Nivel');
$this->addElements($elements);
}
/**
*
* @param array $rows
* @return Zend_Db_Table_Rowset
*/
public function getFilteredRows($filters = array())
{
$dbPerData = App_Model_DbTable_Factory::get('PerData');
$dbDistrict = App_Model_DbTable_Factory::get('AddDistrict');
$mapperClient = new Client_Model_Mapper_Client();
$select = $mapperClient->selectClient();
$select->join(array('ds' => $dbDistrict), 'ds.acronym = c.num_district', array('District'));
$filters = $this->_data;
$date = new Zend_Date();
if (!empty($filters['year'])) {
$select->where('YEAR( c.date_registration ) = ?', $filters['year']);
}
if (!empty($filters['date_start'])) {
$select->where('c.date_registration >= ?', $date->set($filters['date_start'])->toString('yyyy-MM-dd'));
}
if (!empty($filters['date_finish'])) {
$select->where('c.date_registration <= ?', $date->set($filters['date_finish'])->toString('yyyy-MM-dd'));
}
if (!empty($filters['fk_id_dec'])) {
$select->where('c.fk_id_dec = ?', $filters['fk_id_dec']);
}
$rows = $dbPerData->fetchAll($select);
return $rows;
}
public function init()
{
$this->setAttrib('class', 'horizontal-form')->setName('search');
$elements = array();
$dbDistrict = App_Model_DbTable_Factory::get('AddDistrict');
$districts = $dbDistrict->fetchAll();
$optCountry[''] = '';
foreach ($districts as $district) {
$optCountry[$district['id_adddistrict']] = $district['District'];
}
$elements[] = $this->createElement('select', 'fk_id_adddistrict')->setDecorators($this->getDefaultElementDecorators())->setAttrib('class', 'm-wrap span12 chosen')->addMultiOptions($optCountry)->setLabel('Distritu');
$optModule[''] = '';
$mapperModule = new Fefop_Model_Mapper_Module();
$rows = $mapperModule->listModules(Fefop_Model_Mapper_Program::PCE);
foreach ($rows as $row) {
$optModule[$row['id_fefop_modules']] = $row['num_module'] . ' - ' . $row['module'];
}
$elements[] = $this->createElement('select', 'fk_id_fefop_modules')->setDecorators($this->getDefaultElementDecorators())->setAttrib('class', 'm-wrap span12')->addMultiOptions($optModule)->setLabel('Modulu');
$mapperIsicDivision = new Register_Model_Mapper_IsicDivision();
$rows = $mapperIsicDivision->listAll();
$optDivisionTimor[''] = '';
foreach ($rows as $row) {
$optDivisionTimor[$row->id_isicdivision] = $row->name_disivion;
}
$elements[] = $this->createElement('select', 'fk_id_isicdivision')->setDecorators($this->getDefaultElementDecorators())->setAttrib('class', 'm-wrap span12 chosen')->setLabel('Setór atividade nian')->setAttrib('onchange', 'Fefop.PceContract.searchIsicClass(this)')->addMultiOptions($optDivisionTimor);
$elements[] = $this->createElement('select', 'fk_id_isicclasstimor')->setDecorators($this->getDefaultElementDecorators())->setAttrib('class', 'm-wrap span12 chosen')->setLabel('Área negósiu nian')->setRegisterInArrayValidator(false);
$optPartisipants[''] = '';
$optPartisipants['S'] = 'Ema ida';
$optPartisipants['G'] = 'Grupu';
$elements[] = $this->createElement('select', 'partisipants')->setDecorators($this->getDefaultElementDecorators())->setAttrib('class', 'm-wrap span12')->setLabel('Grupu')->addMultiOptions($optPartisipants);
$mapperPce = new External_Model_Mapper_Pce();
$rows = $mapperPce->listBeneficiaries();
$optBeneficiaries[''] = '';
foreach ($rows as $row) {
$optBeneficiaries[$row->id_perdata] = Client_Model_Mapper_Client::buildNumRow($row) . ' - ' . Client_Model_Mapper_Client::buildName($row);
}
$elements[] = $this->createElement('select', 'bussines_plan_developer')->setDecorators($this->getDefaultElementDecorators())->setAttrib('class', 'm-wrap span12 chosen')->setLabel("Naran ema ne'ebé dezenvolve Planu Negósiu nian")->addMultiOptions($optBeneficiaries);
$optIsSubmitted[''] = '';
$optIsSubmitted['1'] = 'Tiha ona';
$optIsSubmitted['0'] = 'Seidauk';
$elements[] = $this->createElement('select', 'submitted')->setDecorators($this->getDefaultElementDecorators())->setAttrib('class', 'm-wrap span12')->setLabel('Submit')->addMultiOptions($optIsSubmitted);
$optIsSubmitted[''] = '';
$optIsSubmitted['1'] = 'Tiha ona';
$optIsSubmitted['0'] = 'Seidauk';
$elements[] = $this->createElement('select', 'contract')->setDecorators($this->getDefaultElementDecorators())->setAttrib('class', 'm-wrap span12')->setLabel('Iha Kontratu')->addMultiOptions($optIsSubmitted);
$this->addElements($elements);
}
/**
*
* @return int|bool
*/
public function save()
{
$dbAdapter = Zend_Db_Table_Abstract::getDefaultAdapter();
$dbAdapter->beginTransaction();
try {
$dataForm = $this->_data;
if (Fefop_Model_Mapper_Module::CED == $dataForm['fk_id_fefop_modules']) {
if (!Client_Model_Mapper_Client::isHandicapped($dataForm['fk_id_perdata'])) {
$this->_message->addMessage('Kliente nee la iha defisiensia', App_Message::ERROR);
return false;
}
}
$mapperRule = new Fefop_Model_Mapper_Rule();
if (Fefop_Model_Mapper_Module::CEC == $dataForm['fk_id_fefop_modules']) {
$itemConfig = Fefop_Model_Mapper_Expense::CONFIG_PCE_CEC_FASE_I;
} else {
$itemConfig = Fefop_Model_Mapper_Expense::CONFIG_PCE_CED_FASE_I;
}
$mapperRule->validate($this->_message, $dataForm, $itemConfig);
// If there is no business plan yet
if (empty($dataForm['id_pce_contract'])) {
$dataContract = array('module' => $dataForm['fk_id_fefop_modules'], 'district' => $dataForm['fk_id_adddistrict'], 'status' => Fefop_Model_Mapper_Status::ANALYSIS);
$mapperFefopContract = new Fefop_Model_Mapper_Contract();
$dataForm['fk_id_fefop_contract'] = $mapperFefopContract->save($dataContract);
}
$this->_data = $dataForm;
$this->_data['amount'] = App_General_String::toFloat($this->_data['amount']);
$id = parent::_simpleSave();
$dataForm['fk_id_pce_contract'] = $id;
// Save Expenses
$this->_saveExpensesContract($dataForm);
$history = "INSERE KONTRATU PCE FASE I: %s BA PROGRAMA PCE IHA MODULU: %s";
$history = sprintf($history, $dataForm['fk_id_fefop_contract'], $dataForm['fk_id_fefop_modules']);
$this->_sysAudit($history);
$dbAdapter->commit();
return $id;
} catch (Exception $e) {
$dbAdapter->rollBack();
$this->_message->addMessage($this->_config->messages->error, App_Message::ERROR);
return false;
}
}
/**
*
* @param Zend_Db_Table_Row $businessPlan
* @return boolean|string
*/
protected function _checkBeneficiaryDisability($businessPlan)
{
if (Fefop_Model_Mapper_Module::CED != $businessPlan->fk_id_fefop_modules) {
return true;
}
if (!Client_Model_Mapper_Client::isHandicapped($businessPlan->fk_id_perdata)) {
return 'Kliente nee la disabilidade ba halo Modulu CED';
} 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);
}
/**
*
* @param int $id
* @return Zend_Db_Table_Rowset
*/
public function listBeneficiaries($id)
{
$mapperClient = new Client_Model_Mapper_Client();
$select = $mapperClient->selectClient();
$dbStudentClassPerData = App_Model_DbTable_Factory::get('FEFEPStudentClass_has_PerData');
$dbHandicapped = App_Model_DbTable_Factory::get('Handicapped');
$dbFPBeneficiary = App_Model_DbTable_Factory::get('FPBeneficiary');
$dbFPContract = App_Model_DbTable_Factory::get('FP_Contract');
$select->join(array('sc' => $dbStudentClassPerData), 'sc.fk_id_perdata = c.id_perdata', array('status_class' => 'status', 'date_drop_out'))->join(array('fb' => $dbFPBeneficiary), 'fb.fk_id_perdata = c.id_perdata', array('amount'))->join(array('fc' => $dbFPContract), 'fc.id_fp_contract = fb.fk_id_fp_contract
AND sc.fk_id_fefpstudentclass = fc.fk_id_fefpstudentclass', array())->joinLeft(array('hc' => $dbHandicapped), 'sc.fk_id_perdata = hc.fk_id_perdata', array('id_handicapped'))->where('fc.id_fp_contract = ?', $id)->group('id_perdata')->order(array('first_name', 'last_name'));
return $dbStudentClassPerData->fetchAll($select);
}
/**
*
*/
public function searchClientAction()
{
$this->_helper->layout()->disableLayout();
$mapperClient = new Client_Model_Mapper_Client();
$this->view->rows = $mapperClient->listByFilters($this->_getAllParams());
}
/**
*
* @return Zend_Db_Table_Rowset
*/
public function _listAppointmentsExpired()
{
$mapperClient = new Client_Model_Mapper_Client();
$selectClient = $mapperClient->selectClient();
$dbActionPlan = App_Model_DbTable_Factory::get('Action_Plan');
$dbDec = App_Model_DbTable_Factory::get('Dec');
$dbUser = App_Model_DbTable_Factory::get('SysUser');
$dbAppointment = App_Model_DbTable_Factory::get('Appointment');
$selectClient->join(array('apl' => $dbActionPlan), 'apl.fk_id_perdata = c.id_perdata', array('id_action_plan', 'fk_id_counselor'))->join(array('ce' => $dbDec), 'ce.id_dec = apl.fk_id_dec', array('ceop_case' => 'name_dec'))->join(array('co' => $dbUser), 'apl.fk_id_counselor = co.id_sysuser', array('counselor' => 'name'))->join(array('app' => $dbAppointment), 'app.fk_id_action_plan = apl.id_action_plan', array('date_appointment'))->where('apl.active = ?', 1)->where('app.appointment_filled = ?', 0)->where('DATE(app.date_appointment) < ?', Zend_Date::now()->toString('yyyy-MM-dd'));
return $dbActionPlan->fetchAll($selectClient);
}
/**
*
* @param int $case
* @param int $jobTraining
* @return Zend_Db_Table_Rowset
*/
public function listClientJobTraining($case, $jobTraining)
{
$mapperClient = new Client_Model_Mapper_Client();
$selectClient = $mapperClient->selectClient();
$dbActionPlan = App_Model_DbTable_Factory::get('Action_Plan');
$dbActionPlanHasGroup = App_Model_DbTable_Factory::get('Action_Plan_has_Group');
$dbActionPlanReferences = App_Model_DbTable_Factory::get('Action_Plan_References');
$selectClient->join(array('ap1' => $dbActionPlan), 'ap1.fk_id_perdata = c.id_perdata', array('id_action_plan'))->join(array('apg' => $dbActionPlanHasGroup), 'apg.fk_id_action_plan = ap1.id_action_plan', array())->joinLeft(array('apr' => $dbActionPlanReferences), 'apr.fk_id_action_plan = ap1.id_action_plan
AND apr.fk_id_jobtraining = ' . $jobTraining, array('id_references'))->where('apg.fk_id_action_plan_group = ?', $case)->where('ap1.active != ?', 2)->where('ap1.type = ?', 'G')->group(array('ap1.id_action_plan'));
return $dbActionPlanHasGroup->fetchAll($selectClient);
}
/**
*
*/
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 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 int $id
* @return Zend_Db_Table_Rowset
*/
public function listCandidate($id)
{
$mapperClient = new Client_Model_Mapper_Client();
$select = $mapperClient->selectClient();
$dbCandidates = App_Model_DbTable_Factory::get('JOBVacancy_Candidates');
$select->join(array('lc' => $dbCandidates), 'lc.fk_id_perdata = c.id_perdata', array('shortlisted'))->where('lc.fk_id_jobvacancy = ?', $id)->group('id_perdata')->order(array('first_name', 'last_name'));
return $dbCandidates->fetchAll($select);
}
/**
*
*/
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);
}
/**
*
* @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;
}
/**
*
* @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);
}
}
/**
*
* @param int $id
* @return Zend_Db_Table_Rowset
*/
public function listQuickList($id)
{
$mapperClient = new Client_Model_Mapper_Client();
$select = $mapperClient->selectClient();
$dbQuickShortlistPerData = App_Model_DbTable_Factory::get('QuickShortlist_has_PerData');
$select->join(array('qlp' => $dbQuickShortlistPerData), 'qlp.fk_id_perdata = c.id_perdata', array())->where('qlp.fk_id_quick_shortlist = ?', $id)->group('id_perdata')->order(array('first_name', 'last_name'));
return $dbQuickShortlistPerData->fetchAll($select);
}
/**
*
* @return Zend_Db_Table_Rowset
*/
public function selectGraduated()
{
$mapperClient = new Client_Model_Mapper_Client();
$select = $mapperClient->selectClient();
$dbStudents = App_Model_DbTable_Factory::get('FEFEPStudentClass_has_PerData');
$dbStudentClass = App_Model_DbTable_Factory::get('FEFPStudentClass');
$dbScholarity = App_Model_DbTable_Factory::get('PerScholarity');
$dbAreaScholarity = App_Model_DbTable_Factory::get('ScholarityArea');
$dbDistrict = App_Model_DbTable_Factory::get('AddDistrict');
$dbEduInstitution = App_Model_DbTable_Factory::get('FefpEduInstitution');
$select->join(array('spd' => $dbStudents), 'spd.fk_id_perdata = c.id_perdata', array())->join(array('sc' => $dbStudentClass), 'spd.fk_id_fefpstudentclass = sc.id_fefpstudentclass', array())->join(array('s' => $dbScholarity), 'sc.fk_id_perscholarity = s.id_perscholarity', array('scholarity'))->join(array('sa' => $dbAreaScholarity), 's.fk_id_scholarity_area = sa.id_scholarity_area', array('scholarity_area'))->join(array('ds' => $dbDistrict), 'ds.acronym = c.num_district', array('District'))->join(array('ei' => $dbEduInstitution), 'ei.id_fefpeduinstitution = sc.fk_id_fefpeduinstitution', array('institution'))->where('spd.status = ?', StudentClass_Model_Mapper_StudentClass::GRADUATED);
$date = new Zend_Date();
$filters = $this->_data;
if (!empty($filters['date_start'])) {
$select->where('sc.real_finish_date >= ?', $date->set($filters['date_start'])->toString('yyyy-MM-dd'));
}
if (!empty($filters['date_finish'])) {
$select->where('sc.real_finish_date <= ?', $date->set($filters['date_finish'])->toString('yyyy-MM-dd'));
}
if (!empty($filters['fk_id_dec'])) {
$select->where('sc.fk_id_dec = ?', $filters['fk_id_dec']);
}
if (!empty($filters['fk_id_fefpeduinstitution'])) {
$select->where('sc.fk_id_fefpeduinstitution = ?', $filters['fk_id_fefpeduinstitution']);
}
if (!empty($filters['fk_id_scholarity_area'])) {
$select->where('s.fk_id_scholarity_area = ?', $filters['fk_id_scholarity_area']);
}
if (!empty($filters['fk_id_perscholarity'])) {
$select->where('sc.fk_id_perscholarity = ?', $filters['fk_id_perscholarity']);
}
return $dbStudentClass->fetchAll($select);
}
/**
*
*/
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;
}
/**
*
* @param int|null $id
* @return array|Zend_Db_Table_Rowset
*/
public function listClient($id)
{
$mapperClient = new Client_Model_Mapper_Client();
$selectClient = $mapperClient->selectClient();
if (empty($id)) {
if (empty($this->_session->client_list)) {
return array();
}
$selectClient->where('c.id_perdata IN(?)', $this->_session->client_list);
} else {
$dbJobListPerdata = App_Model_DbTable_Factory::get('JOBListPrintHasPerdata');
$selectClient->join(array('jlp' => $dbJobListPerdata), 'jlp.fk_id_perdata = c.id_perdata', array('printed'))->where('jlp.fk_id_joblistprint = ?', $id);
}
return $this->_dbTable->fetchAll($selectClient);
}
/**
*
*/
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 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;
}
/**
*
* @param array $filters
* @return Zend_Db_Table_Rowset
*/
public function filterAppliedJob($filters)
{
$mapperClient = new Client_Model_Mapper_Client();
$select = $mapperClient->selectClient();
$dbShortlist = App_Model_DbTable_Factory::get('ShortlistVacancy');
$dbJobVacancy = App_Model_DbTable_Factory::get('JOBVacancy');
$select->join(array('sv' => $dbShortlist), 'sv.fk_id_perdata = c.id_perdata', array())->join(array('jv' => $dbJobVacancy), 'jv.id_jobvacancy = sv.fk_id_jobvacancy', array());
if (!empty($filters['year'])) {
$select->where('YEAR( jv.registration_date ) = ?', $filters['year']);
}
if (!empty($filters['fk_id_dec'])) {
$select->where('jv.fk_id_dec = ?', $filters['fk_id_dec']);
}
$rows = $dbShortlist->fetchAll($select);
return $rows;
}
/**
*
*/
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;
}
