public function executeParentsProcess() { $this->getEnquirer(); if (!$this->filterUser(true)) { $this->jsonwrapper->print_json(array('success' => false, 'code' => 'security', 'message' => 'You must login to access this url.')); } $applicant = $this->pmbTools->getApplicant($this->user); if (!$applicant) { $this->jsonwrapper->show_json_error('Permission', 'You dont have permission to access this page'); } if ($applicant->getStatus() != StudentDetail::GRADUATE) { $this->jsonwrapper->show_json_error('Permission', 'You dont have permission to access this page'); } $applicantDetail = $applicant->getTestApplicantDetail(); $param = $this->getAllRequestParameter(); $valid = true; $error_message = array(); /* Name */ /* Mother Name */ if (empty($param['mother_name'])) { $error_message[] = array('field' => 'mother_name', 'message' => 'Please enter mother name'); $valid = false; } /* Father Name */ if (empty($param['father_name'])) { $error_message[] = array('field' => 'father_name', 'message' => 'Please enter father name'); $valid = false; } /* POB */ /* mother_pob */ if (empty($param['mother_pob'])) { $error_message[] = array('field' => 'mother_pob', 'message' => 'Please enter mother pob'); $valid = false; } /* father_pob */ if (empty($param['father_pob'])) { $error_message[] = array('field' => 'father_pob', 'message' => 'Please enter father pob'); $valid = false; } /* DOB */ /* mother_dob */ if (empty($param['mother_dob'])) { $error_message[] = array('field' => 'mother_dob', 'message' => 'Please enter mother dob'); $valid = false; } /* father_dob */ if (empty($param['father_dob'])) { $error_message[] = array('field' => 'father_dob', 'message' => 'Please enter father dob'); $valid = false; } /* Religion */ /* mother_religion */ if (empty($param['mother_religion'])) { $error_message[] = array('field' => 'mother_religion', 'message' => 'Please enter mother religion'); $valid = false; } /* father_religion */ if (empty($param['father_religion'])) { $error_message[] = array('field' => 'father_religion', 'message' => 'Please enter father religion'); $valid = false; } /* Nationality */ /* mother_nationality */ if (empty($param['mother_nationality'])) { $error_message[] = array('field' => 'mother_nationality', 'message' => 'Please enter mother nationality'); $valid = false; } /* father_nationality */ if (empty($param['father_nationality'])) { $error_message[] = array('field' => 'father_nationality', 'message' => 'Please enter father nationality'); $valid = false; } /* KTP */ /* mother_ktp */ if (empty($param['mother_ktp'])) { $error_message[] = array('field' => 'mother_ktp', 'message' => 'Please enter mother ktp number'); $valid = false; } /* father_ktp */ if (empty($param['father_ktp'])) { $error_message[] = array('field' => 'father_ktp', 'message' => 'Please enter father ktp number'); $valid = false; } /* KITAS */ /* mother_kitas */ if (empty($param['mother_kitas'])) { $error_message[] = array('field' => 'mother_kitas', 'message' => 'Please enter mother kitas number'); $valid = false; } /* father_kitas */ if (empty($param['father_kitas'])) { $error_message[] = array('field' => 'father_kitas', 'message' => 'Please enter father kitas number'); $valid = false; } /* Home Address */ /* mother_home_address */ if (empty($param['mother_home_address'])) { $error_message[] = array('field' => 'mother_home_address', 'message' => 'Please enter mother home address'); $valid = false; } /* father_home_address */ if (empty($param['father_home_address'])) { $error_message[] = array('field' => 'father_home_address', 'message' => 'Please enter father home address'); $valid = false; } /* Home Phone */ /* mother_home_phone */ if (empty($param['mother_home_phone'])) { $error_message[] = array('field' => 'mother_home_phone', 'message' => 'Please enter mother home phone'); $valid = false; } /* father_home_phone */ if (empty($param['father_home_phone'])) { $error_message[] = array('field' => 'father_home_phone', 'message' => 'Please enter father home phone'); $valid = false; } /* Cellphone */ /* mother_cellphone */ if (empty($param['mother_cellphone'])) { $error_message[] = array('field' => 'mother_cellphone', 'message' => 'Please enter mother cellphone'); $valid = false; } /* father_cellphone */ if (empty($param['father_cellphone'])) { $error_message[] = array('field' => 'father_cellphone', 'message' => 'Please enter father cellphone'); $valid = false; } /* Occupation */ /* mother_occupation */ if (empty($param['mother_occupation'])) { $error_message[] = array('field' => 'mother_cellphone', 'message' => 'Please enter mother occupation'); $valid = false; } /* father_occupation */ if (empty($param['father_occupation'])) { $error_message[] = array('field' => 'father_occupation', 'message' => 'Please enter father occupation'); $valid = false; } /* Job Title */ /* mother_job_title */ if (empty($param['mother_job_title'])) { $error_message[] = array('field' => 'mother_job_title', 'message' => 'Please enter mother Job Title'); $valid = false; } /* father_job_title */ if (empty($param['father_job_title'])) { $error_message[] = array('field' => 'father_job_title', 'message' => 'Please enter father Job Title'); $valid = false; } /* Company Name */ /* mother_company_name */ if (empty($param['mother_company_name'])) { $error_message[] = array('field' => 'mother_company_name', 'message' => 'Please enter mother Company Name'); $valid = false; } /* father_company_name */ if (empty($param['father_company_name'])) { $error_message[] = array('field' => 'father_company_name', 'message' => 'Please enter father Company Name'); $valid = false; } /* Company Address */ /* mother_company_address */ if (empty($param['mother_company_address'])) { $error_message[] = array('field' => 'mother_company_address', 'message' => 'Please enter mother Company Address'); $valid = false; } /* father_company_address */ if (empty($param['father_company_address'])) { $error_message[] = array('field' => 'father_company_address', 'message' => 'Please enter father Company Address'); $valid = false; } /* Company Phone */ /* mother_company_phone */ if (empty($param['mother_company_phone'])) { $error_message[] = array('field' => 'mother_company_phone', 'message' => 'Please enter mother Company Phone'); $valid = false; } /* father_company_phone */ if (empty($param['father_company_phone'])) { $error_message[] = array('field' => 'father_company_phone', 'message' => 'Please enter father Company Phone'); $valid = false; } /* Email */ /* mother_email */ if (empty($param['mother_email'])) { $error_message[] = array('field' => 'mother_email', 'message' => 'Please enter mother Email'); $valid = false; } /* father_email */ if (empty($param['father_email'])) { $error_message[] = array('field' => 'father_email', 'message' => 'Please enter father Email'); $valid = false; } /* If not valid */ if (!$valid) { $this->jsonwrapper->print_json(array('success' => false, 'code' => 'notvalid', 'error' => $error_message)); } /* Start Transaction */ $connection = Propel::getConnection('propel'); $connection->begin(); $father = $this->getFather($applicant); if (!$father) { $father = new TestApplicantParents(); $father->setTestApplicantId($applicant->getId()); $father->setRelation(StudentParents::RELATION_FATHER); try { $father->save(); } catch (Exception $e) { $connection->rollback(); $this->jsonwrapper->print_json(array('success' => false, 'code' => 'fail', 'message' => 'Error while save the data, please try again later.', 'message2' => 'Error save create father - process1')); } } $mother = $this->getMother($applicant); if (!$mother) { $mother = new TestApplicantParents(); $mother->setTestApplicantId($applicant->getId()); $mother->setRelation(StudentParents::RELATION_MOTHER); try { $mother->save(); } catch (Exception $e) { $connection->rollback(); $this->jsonwrapper->print_json(array('success' => false, 'code' => 'fail', 'message' => 'Error while save the data, please try again later.', 'message2' => 'Error save create mother - process2')); } } $mother->setName($param['mother_name']); $mother->setPob($param['mother_pob']); $motherDob = date('Y-m-d H:i:s', strtotime($param['mother_dob'])); $mother->setDob($motherDob); $mother->setReligionId($param['mother_religion']); $mother->setCountryId($param['mother_nationality']); $mother->setIdcardNo($param['mother_ktp']); $mother->setKitasNo($param['mother_kitas']); $mother->setAddress($param['mother_home_address']); $mother->setHomePhone($param['mother_home_phone']); $mother->setCellphone($param['mother_cellphone']); $mother->setJob($param['mother_occupation']); $mother->setJob($param['mother_occupation']); $mother->setNoteDetail($param['mother_job_title']); $mother->setCompanyName($param['mother_company_name']); $mother->setCompanyAddress($param['mother_company_address']); $mother->setOfficePhone($param['mother_company_phone']); $mother->setEmail($param['mother_email']); $father->setName($param['father_name']); $father->setPob($param['father_pob']); $fatherDob = date('Y-m-d H:i:s', strtotime($param['father_dob'])); $father->setDob($fatherDob); $father->setReligionId($param['father_religion']); $father->setCountryId($param['father_nationality']); $father->setIdcardNo($param['father_ktp']); $father->setKitasNo($param['father_kitas']); $father->setAddress($param['father_home_address']); $father->setHomePhone($param['father_home_phone']); $father->setCellphone($param['father_cellphone']); $father->setJob($param['father_occupation']); $father->setJob($param['father_occupation']); $father->setNoteDetail($param['father_job_title']); $father->setCompanyName($param['father_company_name']); $father->setCompanyAddress($param['father_company_address']); $father->setOfficePhone($param['father_company_phone']); $father->setEmail($param['father_email']); try { $mother->save(); } catch (Exception $e) { $connection->rollback(); $this->jsonwrapper->print_json(array('success' => false, 'code' => 'fail', 'message' => 'Error while save the data, please try again later.', 'message2' => 'Error save mother - process3')); } try { $father->save(); } catch (Exception $e) { $connection->rollback(); $this->jsonwrapper->print_json(array('success' => false, 'code' => 'fail', 'message' => 'Error while save the data, please try again later.', 'message2' => 'Error save father - process4')); } /* Commit Transaction */ $connection->commit(); /* Hehehe */ $this->jsonwrapper->print_json(array('success' => true, 'code' => 'success', 'message' => 'Data successfully saved', 'href' => $this->pmbTools->pmbUrl('data/medicalinformation'))); /* ---- */ /* Start Transaction */ }
public function executeUpdate() { ## Kelas yang dipilih $class = ClassGroupPeer::retrieveByPK($this->getRequestParameter('class_group1')); $dept = DepartmentPeer::retrieveByPk($this->getRequestParameter('department_id')); $cd = new Criteria(); $cd->add(AcademicCalendarPeer::CURR_SYSTEM_ID, 2); $cd->add(AcademicCalendarPeer::COURSE_MODEL, 'C'); $cd->add(AcademicCalendarPeer::DEPARTMENT_ID, $dept->getId()); $accal_applicant = AcademicCalendarPeer::doSelectOne($cd); $applicant_detail = new TestApplicantDetail(); $applicant_detail->setId($this->getRequestParameter('test_applicant_detail_id')); $applicant_detail->setShortName($this->getRequestParameter('short_name')); $applicant_detail->setPob($this->getRequestParameter('pob')); if ($this->getRequestParameter('dob')) { $applicant_detail->setDob($this->getRequestParameter('dob')); } $applicant_detail->setSex($this->getRequestParameter('sex')); $applicant_detail->setReligionId($this->getRequestParameter('religion_id')); $applicant_detail->setCountryId($this->getRequestParameter('country_id')); $applicant_detail->setNativeLanguage($this->getRequestParameter('native_language')); $applicant_detail->setFather($this->getRequestParameter('father')); $applicant_detail->setMother($this->getRequestParameter('mother')); $applicant_detail->setFatherJob($this->getRequestParameter('father_job')); $applicant_detail->setMotherJob($this->getRequestParameter('mother_job')); $applicant_detail->setDetailFatherJob($this->getRequestParameter('detail_father_job')); $applicant_detail->setDetailMotherJob($this->getRequestParameter('detail_mother_job')); $applicant_detail->setAddress($this->getRequestParameter('address')); $applicant_detail->setPostCode($this->getRequestParameter('post_code')); $applicant_detail->setRegionId($this->getRequestParameter('region_id')); $applicant_detail->setPhone($this->getRequestParameter('home_phone')); $applicant_detail->setCellphone($this->getRequestParameter('father_cellphone')); $applicant_detail->setCompany($this->getRequestParameter('company')); $applicant_detail->setParentName($this->getRequestParameter('father')); $applicant_detail->setJobTitle($this->getRequestParameter('job_title')); $applicant_detail->setSchoolOfOrigin($this->getRequestParameter('school_of_origin')); $applicant_detail->setSchoolOfOriginAddress($this->getRequestParameter('school_of_origin_address')); $applicant_detail->setRegNote($this->getRequestParameter('reg_note')); $applicant_detail->setChildNumber($this->getRequestParameter('child_number')); $applicant_detail->setBloodSiblings($this->getRequestParameter('blood_siblings')); $applicant_detail->setStepSiblings($this->getRequestParameter('step_siblings')); $applicant_detail->setOrphanageStatus($this->getRequestParameter('orphanage_status')); $applicant_detail->setResidenceStatus($this->getRequestParameter('residence_status')); $applicant_detail->setHomeDistance($this->getRequestParameter('home_distance')); $applicant_detail->setTransport($this->getRequestParameter('transport')); #$applicant_detail->setAcademicCalendarId($accal_applicant->getId()); $applicant_detail->setIllness($this->getRequestParameter('illness')); $applicant_detail->setIllnessNote($this->getRequestParameter('illness_note')); $applicant_detail->setGraduationGrade($this->getRequestParameter('graduation_grade')); $applicant_detail->setGraduationYear($this->getRequestParameter('graduation_year')); $applicant_detail->setBloodType($this->getRequestParameter('blood_type')); $applicant_detail->setTall($this->getRequestParameter('tall')); $applicant_detail->setWeight($this->getRequestParameter('weight')); $applicant_detail->save(); $applicant = new TestApplicant(); $is_new = true; $applicant->setId($this->getRequestParameter('id')); $applicant->setName($this->getRequestParameter('name')); $applicant->setCode2($this->getRequestParameter('code2')); $applicant->setClassGroup1($this->getRequestParameter('class_group1')); $applicant->setDepartment1($this->getRequestParameter('department_id')); ## Siswa Dalam if ($this->getRequestParameter('is_alazhar') == TestApplicant::IS_ALAZHAR) { $code_appl = '.' . $dept->getCode() . '.A'; } else { $code_appl = '.' . $dept->getCode() . '.B'; } $stu_code = ParamsPeer::retrieveByCode('sma_code'); $sc = $stu_code->getValue(); $sc = explode('$', $sc); array_shift($sc); $code_len = 0; $code = ''; foreach ($sc as $k => $v) { $v = explode('#', $v); if ($v[0] == 'year') { $code_a = substr($accal_applicant->getName(), 2, 2); $code_b = substr($accal_applicant->getName(), 7, 2); $yr = $code_a . '/' . $code_b; if (strlen($yr) <= $v[1]) { $code .= str_pad($yr, $v[1], '0', STR_PAD_LEFT); } else { $code .= substr($yr, strlen($yr) - $v[1]); } $code_len += $v[1]; } elseif ($v[0] == 'app') { $code_len += $v[1]; $code .= str_pad($code_appl, $v[1], '0', STR_PAD_LEFT); } elseif ($v[0] == 'seq') { $c = new Criteria(); $c->add(TestApplicantPeer::CODE, $code . '%', Criteria::LIKE); $c->addDescendingOrderByColumn(TestApplicantPeer::CODE); $c->setLimit(1); $last_applicant = TestApplicantPeer::doSelectOne($c); if ($last_applicant) { $lap = $last_applicant->getCode(); $lap = substr_replace($lap, '', 0, $code_len); $lap = substr($lap, 0, $v[1]); $lap++; $code .= str_pad($lap, $v[1], '0', STR_PAD_LEFT); } else { $code .= str_pad(1, $v[1], '0', STR_PAD_LEFT); break; } } $sc[$k] = $v; } $applicant->setCode($code); $applicant->setDepartment2($accal_applicant->getId()); $applicant->setApplicantType(TestApplicant::STATUS_NEW); $applicant->setYear($accal_applicant->getYear()); $applicant->setCode2($this->getRequestParameter('code2')); $applicant->setIsAlazhar($this->getRequestParameter('is_alazhar')); $crypted = sha1(sfConfig::get('app_salt') . $applicant_detail->getDob('dmY')); $applicant->setPassword($crypted); $applicant->setStatus(StudentDetail::WEB); $applicant->setTestApplicantDetail($applicant_detail); if ($dept->getCourseModel() == Department::CM_SMP) { $applicant->setClassGroup2($this->getRequestParameter('class_group2')); } elseif ($dept->getCourseModel() == Department::CM_SMA) { //$applicant->setClassGroup2($this->getRequestParameter('program')); } $applicant->save(); $c = new Criteria(); $c->add(RegPeriodPeer::CURRICULUM_ID, $applicant->getIsAlazhar()); $c->add(RegPeriodPeer::ACADEMIC_CALENDAR_ID, $applicant->getDepartment2()); $c->addJoin(RegTestPeriodPeer::REG_PERIOD_ID, RegPeriodPeer::ID); $reg_test_periods = RegTestPeriodPeer::doSelect($c); foreach ($reg_test_periods as $reg_test_period) { $cw = new Criteria(); $cw->add(TestSchedulePeer::REG_TEST_PERIOD_ID, $reg_test_period->getId()); $cw->addAscendingorderByColumn(TestSchedulePeer::ID); $scheds = TestSchedulePeer::doSelect($cw); $s1 = array(); foreach ($scheds as $s) { $s1[$s->getRegTestPeriodId()][] = array('reg_test_period_id' => $s->getRegTestPeriodId(), 'used' => $s->countTestApplScheds(), 'capacity' => $s->getCapacity(), 'sched' => $s); } foreach ($s1 as $s) { $c = new Criteria(); $c->add(TestSchedulePeer::REG_TEST_PERIOD_ID, $reg_test_period->getId()); $c->addJoin(TestApplSchedPeer::TEST_SCHEDULE_ID, TestSchedulePeer::ID); $c->add(TestApplSchedPeer::TEST_APPLICANT_ID, $applicant->getId()); $tas = TestApplSchedPeer::doSelectOne($c); if ($tas == null) { $i = 0; while ($s[$i]) { $sched = $s[$i]; if ($sched['used'] < $sched['capacity']) { $tas = new TestApplSched(); $tas->setTestApplicant($applicant); $tas->setTestSchedule($sched['sched']); $tas->save(); break; } $i++; } } } $test_applicant = TestApplicantPeer::retrieveByPk($applicant->getId()); $this->forward404Unless($test_applicant); $test_applicant->setRegTestPeriod1($reg_test_period->getId()); $test_applicant->save(); } if ($applicant_detail->getDetailFatherJob() == 1) { $father_job == 'Guru / Pengajar / Karyawan AlAzhar'; } elseif ($applicant_detail->getDetailFatherJob() == 2) { $father_job == 'Guru / Pengajar Non ALAzhar'; } elseif ($applicant_detail->getDetailFatherJob() == 3) { $father_job == 'Pegawai Swasta'; } elseif ($applicant_detail->getDetailFatherJob() == 4) { $father_job == 'Pegawai Negeri Sipil'; } elseif ($applicant_detail->getDetailFatherJob() == 5) { $father_job == 'Wiraswasta'; } elseif ($applicant_detail->getDetailFatherJob() == 6) { $father_job == 'Tidak Bekerja'; } else { $father_job == 'Lainnya'; } if ($applicant_detail->getDetailMotherJob() == 1) { $mother_job == 'Guru / Pengajar / Karyawan AlAzhar'; } elseif ($applicant_detail->getDetailMotherJob() == 2) { $mother_job == 'Guru / Pengajar Non ALAzhar'; } elseif ($applicant_detail->getDetailMotherJob() == 3) { $mother_job == 'Pegawai Swasta'; } elseif ($applicant_detail->getDetailMotherJob() == 4) { $mother_job == 'Pegawai Negeri Sipil'; } elseif ($applicant_detail->getDetailMotherJob() == 5) { $mother_job == 'Wiraswasta'; } elseif ($applicant_detail->getDetailMotherJob() == 6) { $mother_job == 'Tidak Bekerja'; } else { $mother_job == 'Lainnya'; } #Data Orang Tua (Ayah) $applicant_father = new TestApplicantParents(); $applicant_father->setName($this->getRequestParameter('father')); $applicant_father->setTestApplicant($applicant); if ($this->getRequestParameter('father_dob')) { $applicant_father->setDob($this->getRequestParameter('father_dob')); } $applicant_father->setPob($this->getRequestParameter('father_pob')); $applicant_father->setReligionId($this->getRequestParameter('religion_father')); $applicant_father->setDegreeId($this->getRequestParameter('degree_father')); $applicant_father->setJob($father_job); $applicant_father->setAddress($this->getRequestParameter('address')); $applicant_father->setOfficePhone($this->getRequestParameter('father_office_phone')); $applicant_father->setPostCode($this->getRequestParameter('post_code')); $applicant_father->setRegionId($this->getRequestParameter('region_id')); $applicant_father->setHomePhone($this->getRequestParameter('home_phone')); $applicant_father->setCellphone($this->getRequestParameter('father_cellphone')); $applicant_father->setCountryId($this->getRequestParameter('father_country')); $applicant_father->setMonthlyRevenue($this->getRequestParameter('father_revenue')); $applicant_father->setEmail($this->getRequestParameter('email')); $applicant_father->setNote($this->getRequestParameter('father_note')); $applicant_father->setNoteDetail($this->getRequestParameter('father_note_detail')); if ($this->getRequestParameter('father_date_note')) { $applicant_father->setNoteDate($this->getRequestParameter('father_date_note')); } $applicant_father->setRelation(StudentParents::RELATION_FATHER); $applicant_father->save(); #Data Orang Tua (Ibu) $applicant_mother = new TestApplicantParents(); $applicant_mother->setName($this->getRequestParameter('mother')); $applicant_mother->setTestApplicant($applicant); if ($this->getRequestParameter('mother_dob')) { $applicant_mother->setDob($this->getRequestParameter('mother_dob')); } $applicant_mother->setPob($this->getRequestParameter('mother_pob')); $applicant_mother->setReligionId($this->getRequestParameter('religion_mother')); $applicant_mother->setDegreeId($this->getRequestParameter('degree_mother')); $applicant_mother->setJob($mother_job); $applicant_mother->setAddress($this->getRequestParameter('address')); $applicant_mother->setOfficePhone($this->getRequestParameter('mother_office_phone')); $applicant_mother->setPostCode($this->getRequestParameter('post_code')); $applicant_mother->setRegionId($this->getRequestParameter('region_id')); $applicant_mother->setHomePhone($this->getRequestParameter('home_phone')); $applicant_mother->setCellphone($this->getRequestParameter('mother_cellphone')); $applicant_mother->setCountryId($this->getRequestParameter('mother_country')); $applicant_mother->setMonthlyRevenue($this->getRequestParameter('mother_revenue')); $applicant_mother->setEmail($this->getRequestParameter('email')); $applicant_mother->setNote($this->getRequestParameter('mother_note')); $applicant_mother->setNoteDetail($this->getRequestParameter('mother_note_detail')); if ($this->getRequestParameter('mother_date_note')) { $applicant_mother->setNoteDate($this->getRequestParameter('mother_date_note')); } $applicant_mother->setRelation(StudentParents::RELATION_MOTHER); $applicant_mother->save(); $this->getContext()->getUser()->signInTestApplicant($applicant); #return $this->redirect('auth/start'); return $this->redirect('auth/index'); }