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');
}
