public function executeView()
{
$user_id = $this->getContext()->getUser()->getAttribute('user_id', null, 'bo');
$test_applicant = TestApplicantPeer::retrieveByPk($user_id);
$c = new Criteria();
$c->add(TestApplSchedPeer::TEST_APPLICANT_ID, $test_applicant->getId());
$c->add(AcademicCalendarPeer::DEPARTMENT_ID, $test_applicant->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);
}
echo 'Mohon Maaf Anda dinyatakan <b>TIDAK LULUS</b>';
} elseif ($applicant->getStatus() == StudentDetail::RESERVE) {
echo 'Anda berada dalam daftar <b>CADANGAN</b>';
}
?>
</p>
<?php
$c = new Criteria();
$c->add(TestApplSchedPeer::TEST_APPLICANT_ID, $applicant->getId());
$c->add(AcademicCalendarPeer::DEPARTMENT_ID, $applicant->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);
$cr = new Criteria();
$cr->add(TestSubjectPeer::DEPARTMENT_ID, $applicant->getDepartment1());
$t_subject1 = TestSubjectPeer::doSelect($cr);
$t_count1 = TestSubjectPeer::doCount($cr);
?>
<fieldset>
<legend>Hasil Test</legend>
<div style="width:100%;">
<table cellspacing="0" cellpadding="0" class="fancy" style="width:100%">
<tbody>
<tr>
<th style="border-right: 1px solid #ffffff;" colspan="2"><?php
echo __('Pendaftaran');
?>
</th>
public function executeRegistrationCard()
{
$id = $this->getRequestParameter('id');
$this->forward404Unless($id);
$ta = TestApplicantPeer::retrieveByPK($id);
$this->forward404Unless($ta);
$this->filename = $this->getActionName() . '_' . $ta->getCode();
$cw = new Criteria();
$cw->add(DepartmentDetailPeer::DEPARTMENT_ID, $ta->getDepartment1());
$this->department_detail = DepartmentDetailPeer::doSelectOne($cw);
$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->ta = $ta;
$this->ta_detail = $ta->getTestApplicantDetail();
$this->sched1 = $appl_sched1;
$this->setLayout(false);
$this->orientation = 'landscape';
#$this->papersize = 'letter';
$this->papersize = 'gdscform';
$this->setViewClass('sfDomPDF');
}
public function executeGraduateReceipt()
{
$ta_id = $this->getRequestParameter('id');
$ta = TestApplicantPeer::retrieveByPK($ta_id);
$this->forward404Unless($ta);
$this->ta = $ta;
$this->ta_detail = $ta->getTestApplicantDetail();
$ta_detail = $ta->getTestApplicantDetail();
$this->ta_detail = $ta_detail;
$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();
}
$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->setTemplate('graduateReceipt');
$this->papersize = 'a4';
$this->father = $father;
$this->mother = $mother;
$this->sched1 = $appl_sched1;
$this->orientation = 'portrait';
$this->setLayout(false);
$this->setViewClass('sfDomPDF');
}
public function getTestApplSchedsJoinTestSchedule($criteria = null, $con = null)
{
include_once 'lib/model/om/BaseTestApplSchedPeer.php';
if ($criteria === null) {
$criteria = new Criteria();
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
if ($this->collTestApplScheds === null) {
if ($this->isNew()) {
$this->collTestApplScheds = array();
} else {
$criteria->add(TestApplSchedPeer::TEST_APPLICANT_ID, $this->getId());
$this->collTestApplScheds = TestApplSchedPeer::doSelectJoinTestSchedule($criteria, $con);
}
} else {
$criteria->add(TestApplSchedPeer::TEST_APPLICANT_ID, $this->getId());
if (!isset($this->lastTestApplSchedCriteria) || !$this->lastTestApplSchedCriteria->equals($criteria)) {
$this->collTestApplScheds = TestApplSchedPeer::doSelectJoinTestSchedule($criteria, $con);
}
}
$this->lastTestApplSchedCriteria = $criteria;
return $this->collTestApplScheds;
}