/** * */ public function indexAction() { $id = $this->_getParam('id'); if (empty($id)) { $stepBreadCrumb = array('label' => 'Rejistu Foun', 'url' => 'student-class/job-training'); } else { $stepBreadCrumb = array('label' => 'Edita Rejistu', 'url' => 'student-class/job-training/edit/id/' . $id); $row = $this->_mapper->fetchRow($id); if (empty($row)) { $this->_helper->redirector->goToSimple('index'); } $this->view->title()->setSubTitle($row->title); } $this->view->id = $id; $this->view->user = Zend_Auth::getInstance()->getIdentity(); $this->view->breadcrumb()->addStep($stepBreadCrumb); }
/** * * @param type $idJobTraining * @return \App_View_Helper_JobTrainingActive */ public function setJobTraining($idJobTraining) { $mapperJobTraining = new StudentClass_Model_Mapper_JobTraining(); $this->_jobTraining = $mapperJobTraining->fetchRow($idJobTraining); return $this; }
/** * * @return int|bool */ public function clientToJobTraining() { $dbAdapter = Zend_Db_Table_Abstract::getDefaultAdapter(); $dbAdapter->beginTransaction(); try { $dbActionPlan = App_Model_DbTable_Factory::get('Action_Plan'); $dbActionPlanBarrier = App_Model_DbTable_Factory::get('Action_Plan_Barrier'); $dbJobTrainingCandidates = App_Model_DbTable_Factory::get('JOBTraining_Candidates'); $dbPersonHistory = App_Model_DbTable_Factory::get('Person_History'); $dbActionPlanReferences = App_Model_DbTable_Factory::get('Action_Plan_References'); $clients = array(); $casesClient = array(); // Fetch the clients related to the case $rows = $dbActionPlan->fetchAll(array('id_action_plan IN (?)' => $this->_data['cases'])); foreach ($rows as $row) { $clients[] = $row->fk_id_perdata; $casesClient[$row->fk_id_perdata] = $row->id_action_plan; } // Fetch the job training $mapperJobTraining = new StudentClass_Model_Mapper_JobTraining(); $jobTraining = $mapperJobTraining->fetchRow($this->_data['idJobTraining']); if ($jobTraining->status != 1) { $this->_message->addMessage('Job Training ida ne\'e taka tiha ona, la bele tau kliente iha lista kandidatu.', App_Message::ERROR); return false; } $where = array('fk_id_jobtraining = ?' => $this->_data['idJobTraining']); $rows = $dbJobTrainingCandidates->fetchAll($where); $clientsCandidates = array(); foreach ($rows as $row) { $clientsCandidates[] = $row->fk_id_perdata; } $newClients = array_diff($clients, $clientsCandidates); // If all the candidates are already in candidate list if (empty($newClients)) { $this->_message->addMessage('Kliente hotu iha Lista Kandidatu tiha ona ba job training ida ne\'e.', App_Message::ERROR); return false; } // Insert all the clients in the candidate list foreach ($newClients as $client) { // Add the client to the list candidates $row = $dbJobTrainingCandidates->createRow(); $row->fk_id_jobtraining = $this->_data['idJobTraining']; $row->fk_id_perdata = $client; $row->fk_id_sysuser = Zend_Auth::getInstance()->getIdentity()->id_sysuser; $row->selected = 0; $row->save(); // Save history to client $rowHistory = $dbPersonHistory->createRow(); $rowHistory->fk_id_perdata = $client; $rowHistory->fk_id_sysuser = Zend_Auth::getInstance()->getIdentity()->id_sysuser; $rowHistory->fk_id_dec = Zend_Auth::getInstance()->getIdentity()->fk_id_dec; $rowHistory->date_time = Zend_Date::now()->toString('yyyy-MM-dd HH:mm'); $rowHistory->action = sprintf('KLIENTE SELECIONADO BA LISTA KANDIDATU JOB TRAINING NUMERO: %s ', $this->_data['idJobTraining']); $rowHistory->description = 'KLIENTE SELECIONADO BA LISTA KANDIDATU JOB TRAININGU NUMERO'; $rowHistory->save(); // Save the auditing $history = sprintf('KLIENTE BA LISTA KANDIDATU: %s - BA JOB TRAINING NUMERU: %s ', $client, $this->_data['idJobTraining']); $this->_sysAudit($history); $whereBarrier = array('fk_id_action_plan = ?' => $casesClient[$client], 'fk_id_barrier_intervention = ?' => $this->_data['intervention']); $barrier = $dbActionPlanBarrier->fetchRow($whereBarrier); // Insert the reference to the action barrier $rowReference = $dbActionPlanReferences->createRow(); $rowReference->fk_id_perdata = $client; $rowReference->fk_id_action_plan = $casesClient[$client]; $rowReference->fk_id_action_barrier = $barrier->id_action_barrier; $rowReference->fk_id_sysuser = Zend_Auth::getInstance()->getIdentity()->id_sysuser; $rowReference->fk_id_jobtraining = $this->_data['idJobTraining']; $rowReference->save(); } $dbAdapter->commit(); return $this->_data['case_id']; } catch (Exception $e) { $dbAdapter->rollBack(); $this->_message->addMessage($this->_config->messages->error, App_Message::ERROR); return false; } }