Esempio n. 1
0
 public function executeSiblingsPost()
 {
     $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 page2');
     }
     $param = $this->getAllRequestParameter();
     $valid = true;
     $error_message = array();
     /* Sibling Name */
     if (empty($param['name'])) {
         $param['name'] = '';
     }
     /* Sibling Clid Number */
     if (empty($param['child_number'])) {
         $param['child_number'] = '';
     }
     /* Grade */
     if (empty($param['grade'])) {
         $param['grade'] = '';
     }
     /* status */
     if (empty($param['status'])) {
         $param['status'] = '';
     }
     /* year_attended */
     if (empty($param['year_attended'])) {
         $param['year_attended'] = '';
     }
     if (!$valid) {
         $this->jsonwrapper->print_json(array('success' => false, 'code' => 'notvalid', 'message' => 'data anda belum lengkap', 'error' => $error_message));
     }
     if (empty($param['id'])) {
         $sibling = new TestApplicantSibling();
     } else {
         $c = new Criteria();
         $c->add(TestApplicantSiblingPeer::ID, $param['id'], Criteria::EQUAL);
         $c->add(TestApplicantSiblingPeer::TEST_APPLICANT_ID, $applicant->getId(), Criteria::EQUAL);
         $sibling = TestApplicantSiblingPeer::doSelectOne($c);
         if (!$sibling) {
             $this->jsonwrapper->show_json_error('notfound', 'Sibling not found');
         }
     }
     $connection = Propel::getConnection('propel');
     $connection->begin();
     $sibling->setTestApplicantId($applicant->getId());
     $sibling->setName($param['name']);
     $sibling->setChildrenNo($param['child_number']);
     $sibling->setClassName($param['grade']);
     $sibling->setTypeOfSibling($param['status']);
     $sibling->setDepartmentName($param['year_attended']);
     try {
         $sibling->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 education history - education history'));
     }
     $connection->commit();
     $data = $sibling->toArray();
     /* Hehehe */
     $this->jsonwrapper->print_json(array('success' => true, 'code' => 'success', 'message' => 'Data successfully saved', 'data' => $data, 'href' => $this->pmbTools->pmbUrl('data/educationhistory')));
     /* ---- */
 }
 public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME)
 {
     $keys = TestApplicantSiblingPeer::getFieldNames($keyType);
     if (array_key_exists($keys[0], $arr)) {
         $this->setId($arr[$keys[0]]);
     }
     if (array_key_exists($keys[1], $arr)) {
         $this->setTestApplicantId($arr[$keys[1]]);
     }
     if (array_key_exists($keys[2], $arr)) {
         $this->setStudentRelated($arr[$keys[2]]);
     }
     if (array_key_exists($keys[3], $arr)) {
         $this->setName($arr[$keys[3]]);
     }
     if (array_key_exists($keys[4], $arr)) {
         $this->setSex($arr[$keys[4]]);
     }
     if (array_key_exists($keys[5], $arr)) {
         $this->setDepartmentId($arr[$keys[5]]);
     }
     if (array_key_exists($keys[6], $arr)) {
         $this->setClassGroupId($arr[$keys[6]]);
     }
     if (array_key_exists($keys[7], $arr)) {
         $this->setDepartmentName($arr[$keys[7]]);
     }
     if (array_key_exists($keys[8], $arr)) {
         $this->setClassName($arr[$keys[8]]);
     }
     if (array_key_exists($keys[9], $arr)) {
         $this->setNote($arr[$keys[9]]);
     }
 }
 public static function retrieveByPKs($pks, $con = null)
 {
     if ($con === null) {
         $con = Propel::getConnection(self::DATABASE_NAME);
     }
     $objs = null;
     if (empty($pks)) {
         $objs = array();
     } else {
         $criteria = new Criteria();
         $criteria->add(TestApplicantSiblingPeer::ID, $pks, Criteria::IN);
         $objs = TestApplicantSiblingPeer::doSelect($criteria, $con);
     }
     return $objs;
 }
Esempio n. 4
0
 public function executeRegistrationReceipt()
 {
     $ta_id = $this->getRequestParameter('id');
     $ta = TestApplicantPeer::retrieveByPK($ta_id);
     $this->forward404Unless($ta);
     $this->ta = $ta;
     $this->ta_detail = $ta->getTestApplicantDetail();
     $this->enquirer = $ta->getTestApplicantEnquirer();
     $this->filename = $this->getActionName() . '_' . $ta->getName();
     $cw = new Criteria();
     $cw->add(DepartmentDetailPeer::DEPARTMENT_ID, $ta->getDepartment1());
     $this->department_detail = DepartmentDetailPeer::doSelectOne($cw);
     $cm = new Criteria();
     $cm->add(TestApplicantParentsPeer::TEST_APPLICANT_ID, $ta->getId());
     $cm->add(TestApplicantParentsPeer::RELATION, StudentParents::RELATION_FATHER);
     $father = TestApplicantParentsPeer::doSelectOne($cm);
     if ($father == null) {
         $father = new TestApplicantParents();
     }
     $cl = new Criteria();
     $cl->add(TestApplicantParentsPeer::TEST_APPLICANT_ID, $ta->getId());
     $cl->add(TestApplicantParentsPeer::RELATION, StudentParents::RELATION_MOTHER);
     $mother = TestApplicantParentsPeer::doSelectOne($cl);
     if ($mother == null) {
         $mother = new TestApplicantParents();
     }
     $ck = new Criteria();
     $ck->add(TestApplicantParentsPeer::TEST_APPLICANT_ID, $ta->getId());
     $ck->add(TestApplicantParentsPeer::RELATION, StudentParents::RELATION_GUARDIAN);
     $guardian = TestApplicantParentsPeer::doSelectOne($ck);
     if ($guardian == null) {
         $guardian = new TestApplicantParents();
     }
     $ct = new Criteria();
     $ct->add(TestApplicantSiblingPeer::TEST_APPLICANT_ID, $ta->getId());
     $siblings = TestApplicantSiblingPeer::doSelect($ct);
     $cti = new Criteria();
     $cti->add(TestApplicantSiblingPeer::TEST_APPLICANT_ID, $ta->getId());
     $cti->add(TestApplicantSiblingPeer::TYPE_OF_SIBLING, TestApplicantSibling::CURRENTLY);
     $current_sibling = TestApplicantSiblingPeer::doSelectOne($cti);
     if ($current_sibling == null) {
         $current_sibling = new TestApplicantSibling();
     }
     $this->current_sibling = $current_sibling;
     $cte = new Criteria();
     $cte->add(TestApplicantSiblingPeer::TEST_APPLICANT_ID, $ta->getId());
     $cte->add(TestApplicantSiblingPeer::TYPE_OF_SIBLING, TestApplicantSibling::APPLIED);
     $applied_sibling = TestApplicantSiblingPeer::doSelectOne($cte);
     if ($applied_sibling == null) {
         $applied_sibling = new TestApplicantSibling();
     }
     $this->applied_sibling = $applied_sibling;
     $ctr = new Criteria();
     $ctr->add(TestApplicantSiblingPeer::TEST_APPLICANT_ID, $ta->getId());
     $ctr->add(TestApplicantSiblingPeer::TYPE_OF_SIBLING, TestApplicantSibling::GRADUATED);
     $graduated_sibling = TestApplicantSiblingPeer::doSelectOne($ctr);
     if ($graduated_sibling == null) {
         $graduated_sibling = new TestApplicantSibling();
     }
     $this->graduated_sibling = $graduated_sibling;
     $cmi = new Criteria();
     $cmi->add(TestApplicantMedicalPeer::TEST_APPLICANT_ID, $ta->getId());
     $medical = TestApplicantMedicalPeer::doSelectOne($cmi);
     if ($medical == null) {
         $medical = new TestApplicantMedical();
     }
     $cdi = new Criteria();
     $cdi->add(TestApplicantEducationsPeer::TEST_APPLICANT_ID, $ta->getId());
     $this->ta_educations = TestApplicantEducationsPeer::doSelect($cdi);
     $this->ta_edu_counts = TestApplicantEducationsPeer::doCount($cdi);
     $cm = new Criteria();
     $cm->add(TestApplicantParentsPeer::TEST_APPLICANT_ID, $ta->getId());
     $cm->add(TestApplicantParentsPeer::RELATION, StudentParents::RELATION_GUARDIAN);
     $primary_contact = TestApplicantParentsPeer::doSelectOne($cm);
     if ($primary_contact == null) {
         $primary_contact = new TestApplicantParents();
     }
     $cmi = new Criteria();
     $cmi->add(TestApplicantParentsPeer::TEST_APPLICANT_ID, $ta->getId());
     $cmi->add(TestApplicantParentsPeer::RELATION, StudentParents::RELATION_GUARDIAN2);
     $secondary_contact = TestApplicantParentsPeer::doSelectOne($cmi);
     if ($secondary_contact == null) {
         $secondary_contact = new TestApplicantParents();
     }
     $cmt = new Criteria();
     $cmt->add(TestApplicantParentsPeer::TEST_APPLICANT_ID, $ta->getId());
     $cmt->add(TestApplicantParentsPeer::RELATION, StudentParents::RELATION_GUARDIAN3);
     $local_contact = TestApplicantParentsPeer::doSelectOne($cmt);
     if ($local_contact == null) {
         $local_contact = new TestApplicantParents();
     }
     $this->primary_contact = $primary_contact;
     $this->secondary_contact = $secondary_contact;
     $this->local_contact = $local_contact;
     if ($ta->getStatus() == StudentDetail::BUY) {
         $this->setTemplate('enquiryReceipt');
     } else {
         $this->setTemplate('registrationReceipt');
     }
     $c = new Criteria();
     $c->add(TestApplSchedPeer::TEST_APPLICANT_ID, $ta->getId());
     $c->add(AcademicCalendarPeer::DEPARTMENT_ID, $ta->getDepartment1());
     $c->addJoin(AcademicCalendarPeer::ID, RegPeriodPeer::ACADEMIC_CALENDAR_ID);
     $c->addJoin(RegPeriodPeer::ID, RegTestPeriodPeer::REG_PERIOD_ID);
     $c->addJoin(RegTestPeriodPeer::ID, TestSchedulePeer::REG_TEST_PERIOD_ID);
     $c->addJoin(TestSchedulePeer::ID, TestApplSchedPeer::TEST_SCHEDULE_ID);
     $appl_sched1 = TestApplSchedPeer::doSelectJoinTestSchedule($c);
     $this->sched1 = $appl_sched1;
     $this->siblings = $siblings;
     $this->father = $father;
     $this->mother = $mother;
     $this->guardian = $guardian;
     $this->medical = $medical;
     $this->setLayout(false);
     $this->papersize = 'a4';
     $this->orientation = 'portrait';
     $this->setViewClass('sfDomPDF');
 }
Esempio n. 5
0
 public function getTestApplicantSiblingsJoinStudent($criteria = null, $con = null)
 {
     include_once 'lib/model/om/BaseTestApplicantSiblingPeer.php';
     if ($criteria === null) {
         $criteria = new Criteria();
     } elseif ($criteria instanceof Criteria) {
         $criteria = clone $criteria;
     }
     if ($this->collTestApplicantSiblings === null) {
         if ($this->isNew()) {
             $this->collTestApplicantSiblings = array();
         } else {
             $criteria->add(TestApplicantSiblingPeer::CLASS_GROUP_ID, $this->getId());
             $this->collTestApplicantSiblings = TestApplicantSiblingPeer::doSelectJoinStudent($criteria, $con);
         }
     } else {
         $criteria->add(TestApplicantSiblingPeer::CLASS_GROUP_ID, $this->getId());
         if (!isset($this->lastTestApplicantSiblingCriteria) || !$this->lastTestApplicantSiblingCriteria->equals($criteria)) {
             $this->collTestApplicantSiblings = TestApplicantSiblingPeer::doSelectJoinStudent($criteria, $con);
         }
     }
     $this->lastTestApplicantSiblingCriteria = $criteria;
     return $this->collTestApplicantSiblings;
 }