/**
*
* @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;
}
/**
*
* @param array $data
* @return string
*/
public function geClassShortlist($data)
{
$mapperStudentClass = new StudentClass_Model_Mapper_StudentClass();
$mapperClient = new Client_Model_Mapper_Client();
$mapperCase = new Client_Model_Mapper_Case();
$class = $mapperStudentClass->detailStudentClass($data['class']);
$client = $mapperClient->detailClient($data['client']);
$case = $mapperCase->detailCase($data['case']);
$view = Zend_Layout::getMvcInstance()->getView();
$link = '<a href="%s" target="_blank">%s</a>';
$className = str_pad($class->id_fefpstudentclass, 5, '0', STR_PAD_LEFT) . ' - ' . $class->class_name;
$clientName = Client_Model_Mapper_Client::buildNumRow($client) . ' - ' . Client_Model_Mapper_Client::buildName($client);
$aClass = sprintf($link, $view->baseUrl('/student-class/register/edit/id/' . $class->id_fefpstudentclass), $class->name_dec . ' - ' . $className);
$aClient = sprintf($link, $view->baseUrl('/client/client/print/id/' . $client->id_perdata), $clientName);
$idCase = str_pad($case->id_action_plan, 5, '0', STR_PAD_LEFT);
return sprintf(self::JOB_SHORTLIST, $aClient, $idCase, $case->name_dec, $case->name, $aClass, $class->name_dec);
}
/**
*
*/
public function classClientAction()
{
$this->_helper->layout()->disableLayout();
$mapperStudentClass = new StudentClass_Model_Mapper_StudentClass();
$class = $mapperStudentClass->detailStudentClass($this->_getParam('class'));
$this->view->class = $class;
}
/**
*
*/
public function fetchClassAction()
{
$mapperStudentClass = new StudentClass_Model_Mapper_StudentClass();
$studentClass = $mapperStudentClass->detailStudentClass($this->_getParam('id'));
$data = array();
$data['fk_id_fefpstudentclass'] = $studentClass['id_fefpstudentclass'];
$data['class_name'] = $studentClass['class_name'];
$data['date_start'] = $this->view->date($studentClass['start_date']);
$data['date_finish'] = $this->view->date($studentClass['schedule_finish_date']);
$dateInit = new Zend_Date($studentClass['start_date']);
$dateFinish = new Zend_Date($studentClass['schedule_finish_date']);
$diff = $dateFinish->sub($dateInit);
$measure = new Zend_Measure_Time($diff->toValue(), Zend_Measure_Time::SECOND);
$diffDays = $measure->convertTo(Zend_Measure_Time::DAY, 0);
$data['duration'] = preg_replace('/[^0-9]/i', '', $diffDays);
$this->_helper->json($data);
}
/**
*
*/
public function fetchClassAction()
{
$mapperClass = new StudentClass_Model_Mapper_StudentClass();
$class = $mapperClass->detailStudentClass($this->_getParam('id_class'));
$data = array();
if (!empty($class)) {
$data = array('status' => $class->fk_id_perscholarity == $this->_getParam('scholarity') && $class->fk_id_fefpeduinstitution == $this->_getParam('institute'), 'id' => $class->id_fefpstudentclass, 'class' => str_pad($class->id_fefpstudentclass, 5, '0', STR_PAD_LEFT) . ' - ' . $class->class_name, 'date_start' => $this->view->date($class->start_date), 'date_finish' => $this->view->date($class->real_finish_date));
}
$this->_helper->json($data);
}