public function executeSiblingsData() { $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'); } $siblingsCriteria = new Criteria(); $siblingsCriteria->add(TestApplicantSiblingPeer::TEST_APPLICANT_ID, $applicant->getId(), Criteria::EQUAL); $siblingsTemp = TestApplicantSiblingPeer::doSelect($siblingsCriteria); $siblings = array(); if ($siblingsTemp) { foreach ($siblingsTemp as $s) { $siblings[] = $s->toArray(); } } $this->jsonwrapper->print_json(array('success' => 1, 'data' => $siblings)); }
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; }
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'); }
public function getTestApplicantSiblings($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()); TestApplicantSiblingPeer::addSelectColumns($criteria); $this->collTestApplicantSiblings = TestApplicantSiblingPeer::doSelect($criteria, $con); } } else { if (!$this->isNew()) { $criteria->add(TestApplicantSiblingPeer::CLASS_GROUP_ID, $this->getId()); TestApplicantSiblingPeer::addSelectColumns($criteria); if (!isset($this->lastTestApplicantSiblingCriteria) || !$this->lastTestApplicantSiblingCriteria->equals($criteria)) { $this->collTestApplicantSiblings = TestApplicantSiblingPeer::doSelect($criteria, $con); } } } $this->lastTestApplicantSiblingCriteria = $criteria; return $this->collTestApplicantSiblings; }