Beispiel #1
0
 public function executeRun()
 {
     $this->applicant = $this->applicant;
     $this->error = false;
     $this->regTestPeriod = RegTestPeriodPeer::retrieveByPK($this->applicant->getRegTestPeriod1());
     if (!$this->regTestPeriod) {
         $this->success = true;
         $this->messageError = 'RegTestPeriod not found';
         return false;
     }
     $testSubjectCriteria = new Criteria();
     $testSubjectCriteria->add(TestSubjectPeer::DEPARTMENT_ID, $this->applicant->getDepartment1());
     $testSubject = TestSubjectPeer::doSelect($testSubjectCriteria);
     $testSubjectCount = TestSubjectPeer::doCount($testSubjectCriteria);
     if ($testSubjectCount < 1) {
         $this->success = true;
         $this->messageError = 'Test Subject not found';
         return false;
     }
     $testSubjectId = array();
     foreach ($testSubject as $t) {
         $testSubjectId[] = $t->getId();
     }
     $testScoreCriteria = new Criteria();
     $testScoreCriteria->add(TestScorePeer::TEST_APPLICANT_ID, $this->applicant->getId(), Criteria::EQUAL);
     $testScoreCriteria->add(TestScorePeer::TEST_SUBJECT_ID, $testSubjectId, Criteria::IN);
     $testScoresTemp = TestScorePeer::doSelect($testScoreCriteria);
     $testScores = array();
     foreach ($testScoresTemp as $t) {
         $testScores[$t->getTestSubjectId()] = $t;
     }
     $this->testSubject = $testSubject;
     $this->testSubjectCount = $testSubjectCount;
     $this->testScores = $testScores;
 }
Beispiel #2
0
 public function executeRun()
 {
     $this->applicant = $this->applicant;
     $this->error = false;
     $this->regTestPeriod = RegTestPeriodPeer::retrieveByPK($this->applicant->getRegTestPeriod1());
     if (!$this->regTestPeriod) {
         $this->success = true;
         $this->messageError = 'RegTestPeriod not found';
         return false;
     }
     $cd = new Criteria();
     $cd->add(TestSchedulePeer::REG_TEST_PERIOD_ID, $this->regTestPeriod->getId());
     $cd->addJoin(TestSchedulePeer::ID, TestApplSchedPeer::TEST_SCHEDULE_ID);
     $cd->add(TestApplSchedPeer::TEST_APPLICANT_ID, $this->applicant->getId());
     $this->testAppl = TestApplSchedPeer::doSelectOne($cd);
     if (!$this->testAppl) {
         $this->success = true;
         $this->messageError = 'Test Applicant Schedule not found';
         return false;
     }
     $cd = new Criteria();
     $cd->add(RegSchedulePeer::REG_PERIOD_ID, $this->regTestPeriod->getRegPeriodId(), Criteria::EQUAL);
     $cd->addAscendingOrderByColumn(RegSchedulePeer::START);
     $this->regSchedules = RegSchedulePeer::doSelect($cd);
 }
Beispiel #3
0
 public function executeApplicant()
 {
     $this->applicant = $this->applicant;
     $this->error = false;
     $this->department = DepartmentPeer::retrieveByPK($this->applicant->getDepartment1());
     $this->classGroup = ClassGroupPeer::retrieveByPK($this->applicant->getClassGroup1());
     $this->regTestPeriod = RegTestPeriodPeer::retrieveByPK($this->applicant->getRegTestPeriod1());
     if (!$this->regTestPeriod) {
         $this->error = true;
         $this->messageError = 'RegTestPeriod not found';
         return false;
     }
 }
Beispiel #4
0
 public function signInApplicant($user)
 {
     $this->addCredential('bo');
     $this->setAttribute('user_id', $user->getId(), 'bo');
     $this->setAttribute('username_long', $user->getName(), 'bo');
     $this->setAuthenticated2(true, 'bo');
     $this->setAttribute('username', $user->getCode(), 'bo');
     $this->setAttribute('department_id1', DepartmentPeer::retrieveByPK($user->getDepartment1())->getId(), 'bo');
     $this->setAttribute('department1_name', DepartmentPeer::retrieveByPK($user->getDepartment1())->getName(), 'bo');
     $this->setAttribute('department_id2', $user->getDepartment2() ? DepartmentPeer::retrieveByPK($user->getDepartment2())->getId() : '', 'bo');
     $this->setAttribute('department2_name', $user->getDepartment2() ? DepartmentPeer::retrieveByPK($user->getDepartment2())->getName() : '', 'bo');
     $this->setAttribute('class_name1', ClassGroupPeer::retrieveByPK($user->getClassGroup1())->getName(), 'bo');
     $this->setAttribute('class_parent1', ClassGroupPeer::retrieveByPK($user->getClassGroup1())->getParentName(), 'bo');
     $this->setAttribute('class_name2', $user->getClassGroup2() ? ClassGroupPeer::retrieveByPK($user->getClassGroup2())->getName() : '', 'bo');
     $this->setAttribute('class_parent2', $user->getClassGroup2() ? ClassGroupPeer::retrieveByPK($user->getClassGroup2())->getParentName() : '', 'bo');
     $this->setAttribute('reg_period1', RegTestPeriodPeer::retrieveByPK($user->getRegTestPeriod1())->getRegPeriod()->getName(), 'bo');
     $this->setAttribute('reg_period2', $user->getRegTestPeriod2() ? RegTestPeriodPeer::retrieveByPK($user->getgetRegTestPeriod2())->getRegPeriod()->getName() : '', 'bo');
     $this->setAttribute('login_time', time(), 'bo');
 }
Beispiel #5
0
        echo "&nbsp;Nov&nbsp;";
    } elseif ($bln1 == 12) {
        echo "&nbsp;Des&nbsp;";
    }
    echo $tahun1;
} else {
    echo '-';
}
?>
                                    </span><br />
                                    Periode Pembayaran
                                    </li>
                                    <li style="padding-top: 3px;">
                                    <span style="color:darkgoldenrod;">
									<?php 
$reg_test_period = RegTestPeriodPeer::retrieveByPK($applicant->getRegTestPeriod1());
$tanggal2 = substr($reg_test_period->getStart(), 8, 2);
$bln2 = substr($reg_test_period->getStart(), 5, 2);
$tahun2 = substr($reg_test_period->getStart(), 0, 4);
?>
									<?php 
if ($reg_test_period->getStart() != null) {
    echo $tanggal2;
    if ($bln2 == 1) {
        echo "&nbsp;Jan&nbsp;";
    } elseif ($bln2 == 2) {
        echo "&nbsp;Feb&nbsp;";
    } elseif ($bln2 == 3) {
        echo "&nbsp;Mar&nbsp;";
    } elseif ($bln2 == 4) {
        echo "&nbsp;April&nbsp;";
Beispiel #6
0
 public function getRegTestPeriod($con = null)
 {
     include_once 'lib/model/om/BaseRegTestPeriodPeer.php';
     if ($this->aRegTestPeriod === null && $this->reg_test_period_id !== null) {
         $this->aRegTestPeriod = RegTestPeriodPeer::retrieveByPK($this->reg_test_period_id, $con);
     }
     return $this->aRegTestPeriod;
 }
?>
<table align="center" style="border-collapse:collapse; width:100%; position: absolute;">
	
    <tr>
    	<td align="justify" width="100%">
		<?php 
$cls = ClassGroupPeer::retrieveByPk($ta->getClassGroup1());
?>
        <p style="text-align: justify;">Berikut Merupakan Rincian Biaya Pendidikan di <b><?php 
echo $department_detail ? $department_detail->getName() ? $department_detail->getName() : '' : '';
?>
 Program <?php 
echo $ta->getClassGroup1() ? $cls->getParentName() : '-';
?>
</b> Tahun Pelajaran <?php 
echo RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getAcademicCalendar()->getName();
?>
 :</p></td>
    </tr>    
    <tr>
    	<td align="justify" width="100%">
         <table border="0" width="100%">
    		<?php 
$i = 0;
foreach ($academic_costs as $academic_cost) {
    $i++;
    ?>
            <tr>
            	<td width="3%"></td>
    			<td width="3%" align="left"><?php 
    echo $i . '.';
    echo $i + ($pager->getPage() - 1) * $pager->getMaxPerPage();
    ?>
","<?php 
    echo $test_applicant->getCode();
    ?>
","<?php 
    echo $test_applicant->getName();
    ?>
","<?php 
    echo DepartmentPeer::retrieveByPK($test_applicant->getDepartment1())->toString();
    ?>
","<?php 
    echo ClassGroupPeer::retrieveByPK($test_applicant->getClassGroup1())->toString();
    ?>
","<?php 
    echo $test_applicant->getRegTestPeriod1() ? RegTestPeriodPeer::retrieveByPK($test_applicant->getRegTestPeriod1())->getRegPeriod()->getName() : '-';
    ?>
","<?php 
    if ($test_applicant->getApplicantType() == TestApplicant::STATUS_NEW) {
        echo __('Baru');
    } elseif ($test_applicant->getApplicantType() == TestApplicant::STATUS_TRANSFER) {
        echo __('Pindahan');
    } elseif ($test_applicant->getApplicantType() == TestApplicant::STATUS_EXTEND) {
        echo __('Lanjutan');
    }
    ?>
","<?php 
    echo $test_applicant->getYear();
    ?>
","<?php 
    if ($test_applicant->getStatus() == StudentDetail::BUY) {
Beispiel #9
0
 public function executeGraduateReceipt()
 {
     $ta_id = $this->getRequestParameter('id');
     $ta = TestApplicantPeer::retrieveByPK($ta_id);
     $this->forward404Unless($ta);
     $this->ta = $ta;
     $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);
     #Uang Osis Untuk SMP
     if ($ta->getDepartment1() == 2) {
         $cm = new Criteria();
         $cm->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getAcademicCalendarId());
         $cm->add(AcademicCostPeer::ACADEMIC_COST_COMPONENT_ID, 30);
         #$cm->add(AcademicCostPeer::CLASS_GROUP_ID, ClassGroupPeer::retrieveByPk($ta->getClassGroup1())->getId());
         $this->osis = AcademicCostPeer::doSelectOne($cm);
     }
     #Calon Siswa dari Al-Azhar
     if ($ta->getIsAlazhar() == TestApplicant::IS_ALAZHAR) {
         #Ayah atau Ibu Guru
         if ($ta_detail->getFatherJob() == TestApplicant::IS_TEACHER || $ta_detail->getMotherJob() == TestApplicant::IS_TEACHER) {
             #Guru Pengajar Al-Azhar (Siswa Dalam - Guru Dalam)
             if ($ta_detail->getDetailFatherJob() == 1 || $ta_detail->getDetailMotherJob() == 1) {
                 $c = new Criteria();
                 $c->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getAcademicCalendarId());
                 $c->add(AcademicCostPeer::ACADEMIC_PROCESS_ID, 1);
                 $c->add(AcademicCostPeer::CLASS_GROUP_ID, ClassGroupPeer::retrieveByPk($ta->getClassGroup1())->getParent());
                 $cton1 = $c->getNewCriterion(AcademicCostPeer::PAYER_TYPE_ID, 7);
                 $cton2 = $c->getNewCriterion(AcademicCostPeer::PAYER_TYPE_ID, 10);
                 $cton1->addOr($cton2);
                 $c->add($cton1);
                 $c->addDescendingOrderByColumn(AcademicCostPeer::AMOUNT);
                 $academic_costs = AcademicCostPeer::doSelect($c);
                 $this->academic_costs = $academic_costs;
                 #SPP Bulanan Guru Dalam
                 $cr = new Criteria();
                 $cr->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getAcademicCalendarId());
                 $cr->add(AcademicCostPeer::ACADEMIC_PROCESS_ID, 2);
                 $cr->add(AcademicCostPeer::CLASS_GROUP_ID, ClassGroupPeer::retrieveByPk($ta->getClassGroup1())->getId());
                 $cr->add(AcademicCostPeer::PAYER_TYPE_ID, 19);
                 $this->spp = AcademicCostPeer::doSelectOne($cr);
                 #Guru Pengajar (Siswa Dalam - Guru Luar)
             } else {
                 $c = new Criteria();
                 $c->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getAcademicCalendarId());
                 $c->add(AcademicCostPeer::ACADEMIC_PROCESS_ID, 1);
                 $c->add(AcademicCostPeer::CLASS_GROUP_ID, ClassGroupPeer::retrieveByPk($ta->getClassGroup1())->getParent());
                 $cton1 = $c->getNewCriterion(AcademicCostPeer::PAYER_TYPE_ID, 7);
                 $cton2 = $c->getNewCriterion(AcademicCostPeer::PAYER_TYPE_ID, 9);
                 $cton1->addOr($cton2);
                 $c->add($cton1);
                 $c->addDescendingOrderByColumn(AcademicCostPeer::AMOUNT);
                 $academic_costs = AcademicCostPeer::doSelect($c);
                 $this->academic_costs = $academic_costs;
                 #SPP Bulanan Guru Luar
                 $cr = new Criteria();
                 $cr->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getAcademicCalendarId());
                 $cr->add(AcademicCostPeer::ACADEMIC_PROCESS_ID, 2);
                 $cr->add(AcademicCostPeer::CLASS_GROUP_ID, ClassGroupPeer::retrieveByPk($ta->getClassGroup1())->getId());
                 $cr->add(AcademicCostPeer::PAYER_TYPE_ID, 18);
                 $this->spp = AcademicCostPeer::doSelectOne($cr);
             }
             #Ayah dan Ibu Guru
         } elseif ($ta_detail->getFatherJob() == TestApplicant::IS_TEACHER && $ta_detail->getMotherJob() == TestApplicant::IS_TEACHER) {
             #Guru Pengajar Al-Azhar (Siswa Dalam - Guru Dalam)
             if ($ta_detail->getDetailFatherJob() == 1 || $ta_detail->getDetailMotherJob() == 1) {
                 $c = new Criteria();
                 $c->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getAcademicCalendarId());
                 $c->add(AcademicCostPeer::ACADEMIC_PROCESS_ID, 1);
                 $c->add(AcademicCostPeer::CLASS_GROUP_ID, ClassGroupPeer::retrieveByPk($ta->getClassGroup1())->getParent());
                 $cton1 = $c->getNewCriterion(AcademicCostPeer::PAYER_TYPE_ID, 7);
                 $cton2 = $c->getNewCriterion(AcademicCostPeer::PAYER_TYPE_ID, 10);
                 $cton1->addOr($cton2);
                 $c->add($cton1);
                 $c->addDescendingOrderByColumn(AcademicCostPeer::AMOUNT);
                 $academic_costs = AcademicCostPeer::doSelect($c);
                 $this->academic_costs = $academic_costs;
                 #SPP Bulanan Guru Dalam
                 $cr = new Criteria();
                 $cr->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getAcademicCalendarId());
                 $cr->add(AcademicCostPeer::ACADEMIC_PROCESS_ID, 2);
                 $cr->add(AcademicCostPeer::CLASS_GROUP_ID, ClassGroupPeer::retrieveByPk($ta->getClassGroup1())->getId());
                 $cr->add(AcademicCostPeer::PAYER_TYPE_ID, 19);
                 $this->spp = AcademicCostPeer::doSelectOne($cr);
                 #Guru Pengajar (Siswa Dalam - Guru Luar)
             } else {
                 $c = new Criteria();
                 $c->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getAcademicCalendarId());
                 $c->add(AcademicCostPeer::ACADEMIC_PROCESS_ID, 1);
                 $c->add(AcademicCostPeer::CLASS_GROUP_ID, ClassGroupPeer::retrieveByPk($ta->getClassGroup1())->getParent());
                 $cton1 = $c->getNewCriterion(AcademicCostPeer::PAYER_TYPE_ID, 7);
                 $cton2 = $c->getNewCriterion(AcademicCostPeer::PAYER_TYPE_ID, 9);
                 $cton1->addOr($cton2);
                 $c->add($cton1);
                 $c->addDescendingOrderByColumn(AcademicCostPeer::AMOUNT);
                 $academic_costs = AcademicCostPeer::doSelect($c);
                 $this->academic_costs = $academic_costs;
                 #SPP Bulanan Guru Luar
                 $cr = new Criteria();
                 $cr->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getAcademicCalendarId());
                 $cr->add(AcademicCostPeer::ACADEMIC_PROCESS_ID, 2);
                 $cr->add(AcademicCostPeer::CLASS_GROUP_ID, ClassGroupPeer::retrieveByPk($ta->getClassGroup1())->getId());
                 $cr->add(AcademicCostPeer::PAYER_TYPE_ID, 18);
                 $this->spp = AcademicCostPeer::doSelectOne($cr);
             }
             #Siswa Dalam - non Guru
         } else {
             $c = new Criteria();
             $c->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getAcademicCalendarId());
             $c->add(AcademicCostPeer::ACADEMIC_PROCESS_ID, 1);
             $c->add(AcademicCostPeer::CLASS_GROUP_ID, ClassGroupPeer::retrieveByPk($ta->getClassGroup1())->getParent());
             $cton1 = $c->getNewCriterion(AcademicCostPeer::PAYER_TYPE_ID, 7);
             $cton2 = $c->getNewCriterion(AcademicCostPeer::PAYER_TYPE_ID, 11);
             $cton1->addOr($cton2);
             $c->add($cton1);
             $c->addDescendingOrderByColumn(AcademicCostPeer::AMOUNT);
             $academic_costs = AcademicCostPeer::doSelect($c);
             $this->academic_costs = $academic_costs;
             #SPP Bulanan Non Guru
             $cr = new Criteria();
             $cr->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getAcademicCalendarId());
             $cr->add(AcademicCostPeer::ACADEMIC_PROCESS_ID, 2);
             $cr->add(AcademicCostPeer::CLASS_GROUP_ID, ClassGroupPeer::retrieveByPk($ta->getClassGroup1())->getId());
             $cr->add(AcademicCostPeer::PAYER_TYPE_ID, 20);
             $this->spp = AcademicCostPeer::doSelectOne($cr);
         }
         #Iuran Jamiyah Siswa Dalam
         $ce = new Criteria();
         $ce->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getAcademicCalendarId());
         $ce->add(AcademicCostPeer::ACADEMIC_COST_COMPONENT_ID, 17);
         $ce->add(AcademicCostPeer::CLASS_GROUP_ID, ClassGroupPeer::retrieveByPk($ta->getClassGroup1())->getParent());
         $ce->add(AcademicCostPeer::PAYER_TYPE_ID, 7);
         $this->jamiyah = AcademicCostPeer::doSelectOne($ce);
         #Calon Siswa dari Luar Al-Azhar
     } else {
         #Ayah atau Ibu Guru
         if ($ta_detail->getFatherJob() == TestApplicant::IS_TEACHER || $ta_detail->getMotherJob() == TestApplicant::IS_TEACHER) {
             #Guru Pengajar Al-Azhar (Siswa Luar - Guru Dalam)
             if ($ta_detail->getDetailFatherJob() == 1 || $ta_detail->getDetailMotherJob() == 1) {
                 $c = new Criteria();
                 $c->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getAcademicCalendarId());
                 $c->add(AcademicCostPeer::ACADEMIC_PROCESS_ID, 1);
                 $c->add(AcademicCostPeer::CLASS_GROUP_ID, ClassGroupPeer::retrieveByPk($ta->getClassGroup1())->getParent());
                 $cton1 = $c->getNewCriterion(AcademicCostPeer::PAYER_TYPE_ID, 7);
                 $cton2 = $c->getNewCriterion(AcademicCostPeer::PAYER_TYPE_ID, 13);
                 $cton1->addOr($cton2);
                 $c->add($cton1);
                 $c->addDescendingOrderByColumn(AcademicCostPeer::AMOUNT);
                 $academic_costs = AcademicCostPeer::doSelect($c);
                 $this->academic_costs = $academic_costs;
                 #SPP Bulanan Guru Dalam
                 $cr = new Criteria();
                 $cr->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getAcademicCalendarId());
                 $cr->add(AcademicCostPeer::ACADEMIC_PROCESS_ID, 2);
                 $cr->add(AcademicCostPeer::CLASS_GROUP_ID, ClassGroupPeer::retrieveByPk($ta->getClassGroup1())->getId());
                 $cr->add(AcademicCostPeer::PAYER_TYPE_ID, 19);
                 $this->spp = AcademicCostPeer::doSelectOne($cr);
                 #Guru Pengajar (Siswa Luar - Guru Luar)
             } else {
                 $c = new Criteria();
                 $c->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getAcademicCalendarId());
                 $c->add(AcademicCostPeer::ACADEMIC_PROCESS_ID, 1);
                 $c->add(AcademicCostPeer::CLASS_GROUP_ID, ClassGroupPeer::retrieveByPk($ta->getClassGroup1())->getParent());
                 $cton1 = $c->getNewCriterion(AcademicCostPeer::PAYER_TYPE_ID, 7);
                 $cton2 = $c->getNewCriterion(AcademicCostPeer::PAYER_TYPE_ID, 12);
                 $cton1->addOr($cton2);
                 $c->add($cton1);
                 $c->addDescendingOrderByColumn(AcademicCostPeer::AMOUNT);
                 $academic_costs = AcademicCostPeer::doSelect($c);
                 $this->academic_costs = $academic_costs;
                 #SPP Bulanan Guru Luar
                 $cr = new Criteria();
                 $cr->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getAcademicCalendarId());
                 $cr->add(AcademicCostPeer::ACADEMIC_PROCESS_ID, 2);
                 $cr->add(AcademicCostPeer::CLASS_GROUP_ID, ClassGroupPeer::retrieveByPk($ta->getClassGroup1())->getId());
                 $cr->add(AcademicCostPeer::PAYER_TYPE_ID, 18);
                 $this->spp = AcademicCostPeer::doSelectOne($cr);
             }
             #Ayah dan Ibu Guru
         } elseif ($ta_detail->getFatherJob() == TestApplicant::IS_TEACHER && $ta_detail->getMotherJob() == TestApplicant::IS_TEACHER) {
             #Guru Pengajar Al-Azhar (Siswa Luar - Guru Dalam)
             if ($ta_detail->getDetailFatherJob() == 1 || $ta_detail->getDetailMotherJob() == 1) {
                 $c = new Criteria();
                 $c->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getAcademicCalendarId());
                 $c->add(AcademicCostPeer::ACADEMIC_PROCESS_ID, 1);
                 $c->add(AcademicCostPeer::CLASS_GROUP_ID, ClassGroupPeer::retrieveByPk($ta->getClassGroup1())->getParent());
                 $cton1 = $c->getNewCriterion(AcademicCostPeer::PAYER_TYPE_ID, 7);
                 $cton2 = $c->getNewCriterion(AcademicCostPeer::PAYER_TYPE_ID, 13);
                 $cton1->addOr($cton2);
                 $c->add($cton1);
                 $c->addDescendingOrderByColumn(AcademicCostPeer::AMOUNT);
                 $academic_costs = AcademicCostPeer::doSelect($c);
                 $this->academic_costs = $academic_costs;
                 #SPP Bulanan Guru Dalam
                 $cr = new Criteria();
                 $cr->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getAcademicCalendarId());
                 $cr->add(AcademicCostPeer::ACADEMIC_PROCESS_ID, 2);
                 $cr->add(AcademicCostPeer::CLASS_GROUP_ID, ClassGroupPeer::retrieveByPk($ta->getClassGroup1())->getId());
                 $cr->add(AcademicCostPeer::PAYER_TYPE_ID, 19);
                 $this->spp = AcademicCostPeer::doSelectOne($cr);
                 #Guru Pengajar (Siswa Luar - Guru Luar)
             } else {
                 $c = new Criteria();
                 $c->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getAcademicCalendarId());
                 $c->add(AcademicCostPeer::ACADEMIC_PROCESS_ID, 1);
                 $c->add(AcademicCostPeer::CLASS_GROUP_ID, ClassGroupPeer::retrieveByPk($ta->getClassGroup1())->getParent());
                 $cton1 = $c->getNewCriterion(AcademicCostPeer::PAYER_TYPE_ID, 7);
                 $cton2 = $c->getNewCriterion(AcademicCostPeer::PAYER_TYPE_ID, 12);
                 $cton1->addOr($cton2);
                 $c->add($cton1);
                 $c->addDescendingOrderByColumn(AcademicCostPeer::AMOUNT);
                 $academic_costs = AcademicCostPeer::doSelect($c);
                 $this->academic_costs = $academic_costs;
                 #SPP Bulanan Guru Luar
                 $cr = new Criteria();
                 $cr->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getAcademicCalendarId());
                 $cr->add(AcademicCostPeer::ACADEMIC_PROCESS_ID, 2);
                 $cr->add(AcademicCostPeer::CLASS_GROUP_ID, ClassGroupPeer::retrieveByPk($ta->getClassGroup1())->getId());
                 $cr->add(AcademicCostPeer::PAYER_TYPE_ID, 18);
                 $this->spp = AcademicCostPeer::doSelectOne($cr);
             }
             #Siswa Luar - non Guru
         } else {
             $c = new Criteria();
             $c->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getAcademicCalendarId());
             $c->add(AcademicCostPeer::ACADEMIC_PROCESS_ID, 1);
             $c->add(AcademicCostPeer::CLASS_GROUP_ID, ClassGroupPeer::retrieveByPk($ta->getClassGroup1())->getParent());
             $cton1 = $c->getNewCriterion(AcademicCostPeer::PAYER_TYPE_ID, 7);
             $cton2 = $c->getNewCriterion(AcademicCostPeer::PAYER_TYPE_ID, 14);
             $cton1->addOr($cton2);
             $c->add($cton1);
             $c->addDescendingOrderByColumn(AcademicCostPeer::AMOUNT);
             $academic_costs = AcademicCostPeer::doSelect($c);
             $this->academic_costs = $academic_costs;
             #SPP Bulanan Non Guru
             $cr = new Criteria();
             $cr->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getAcademicCalendarId());
             $cr->add(AcademicCostPeer::ACADEMIC_PROCESS_ID, 2);
             $cr->add(AcademicCostPeer::CLASS_GROUP_ID, ClassGroupPeer::retrieveByPk($ta->getClassGroup1())->getId());
             $cr->add(AcademicCostPeer::PAYER_TYPE_ID, 20);
             $this->spp = AcademicCostPeer::doSelectOne($cr);
         }
         #Iuran Jamiyah Siswa Luar
         $ce = new Criteria();
         $ce->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getAcademicCalendarId());
         $ce->add(AcademicCostPeer::ACADEMIC_COST_COMPONENT_ID, 17);
         $ce->add(AcademicCostPeer::CLASS_GROUP_ID, ClassGroupPeer::retrieveByPk($ta->getClassGroup1())->getParent());
         $ce->add(AcademicCostPeer::PAYER_TYPE_ID, 8);
         $this->jamiyah = AcademicCostPeer::doSelectOne($ce);
     }
     $this->papersize = 'a4';
     $this->orientation = 'portrait';
     $this->setViewClass('sfDomPDF');
 }
Beispiel #10
0
 public function getRegTestPeriodRelatedByRegTestPeriod2($con = null)
 {
     include_once 'lib/model/om/BaseRegTestPeriodPeer.php';
     if ($this->aRegTestPeriodRelatedByRegTestPeriod2 === null && $this->reg_test_period2 !== null) {
         $this->aRegTestPeriodRelatedByRegTestPeriod2 = RegTestPeriodPeer::retrieveByPK($this->reg_test_period2, $con);
     }
     return $this->aRegTestPeriodRelatedByRegTestPeriod2;
 }
Beispiel #11
0
                            	<?php 
echo $test_applicant->getRegTestPeriod2() ? RegTestPeriodPeer::retrieveByPK($test_applicant->getRegTestPeriod2())->getRegPeriod()->getAcademicCalendar()->toString() : '-';
?>
                            </b></p>
                            </td>
        				</tr>
        				<tr>   
           					<td style="vertical-align:middle;" width="30%"><label><?php 
echo __('Jadwal Test 2');
?>
</label></td>
           					<td width="2%" style="text-align:center; vertical-align:middle;">:</td>
		   					<td style="vertical-align:middle;">
							<p class="detail"><b>
                            	<?php 
echo $test_applicant->getRegTestPeriod2() ? RegTestPeriodPeer::retrieveByPK($test_applicant->getRegTestPeriod2())->toString() : '-';
?>
                            </b></p>
                            </td>
        				</tr>
                   	</table>
        			</td>
        		</tr>
        		</table>
        		</td></tr>
                
                <tr><td colspan="3"><div class="subtitle">Profil Calon Siswa</div></td></tr>
				<!-- Fifth Line -->
        		<tr>
           			<td style="vertical-align:middle;"><label  ><?php 
echo __('Short name');
                            <td width="30%" align="left">Gelombang Pendaftaran</td>
                            <td width="5%" align="center">:</td>
                            <td width="57%" align="left">
                    <?php 
echo $ta->getRegTestPeriod1() && RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1()) ? RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getName() : '';
?>
                    </td>
                    </tr>
                <tr>
                    <td></td>
                            <td align="left">20.</td>
                            <td align="left">Periode Pendaftaran</td>
                            <td align="center">:</td>
                            <td align="left">
                                    <?php 
$reg_test_period = RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1());
?>
                                     <?php 
echo $reg_test_period->getRegPeriod()->getStart() ? DateToIndo($reg_test_period->getRegPeriod()->getStart()) : '-';
?>
&nbsp;s.d&nbsp;<?php 
echo $reg_test_period->getRegPeriod()->getEnd() ? DateToIndo($reg_test_period->getRegPeriod()->getEnd()) : '-';
?>
                    </td>
                    </tr>
            </table>
            </td>    
        </tr>
        <tr><td height="10px;">&nbsp;</td></tr>
        <tr><td align="justify" style="vertical-align: middle;">Simpanlah lembar pendaftaran ini sebagai bukti pendaftaran Anda. 
        <br />Gunakan <b>No Pendaftaran dan Tanggal Lahir</b> Calon Siswa untuk mengakses Informasi PMB di alamat <em>http://pmbonline.muhajirien.org</em></td></tr>
Beispiel #13
0
 public static function doSelectByRegTestPeriod1()
 {
     $ta_id = sfContext::getInstance()->getRequest()->getParameter('id');
     $ta = TestApplicantPeer::retrieveByPK($ta_id);
     if ($ta == null) {
         return array();
     }
     $accal_id = RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriodId()->getAcademicCalendarId();
     $c = new Criteria();
     $c->add(LocationPeer::ACADEMIC_CALENDAR_ID, $accal_id);
     $objs = LocationPeer::doSelect($c);
     return $objs;
 }
?>
</td>
    </tr>
	<tr>
    	<td>8. Kelas</td>
        <td style=" text-align: center;">:</td>
        <td><?php 
echo $ta->getClassGroup1() && ClassGroupPeer::retrieveByPK($ta->getClassGroup1()) ? ClassGroupPeer::retrieveByPK($ta->getClassGroup1())->getName() : '';
?>
</td>
    </tr>
	<tr>
    	<td>9. Gelombang pandaftaran</td>
        <td style="text-align: center;">:</td>
        <td><?php 
echo $ta->getRegTestPeriod1() && RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1()) ? RegTestPeriodPeer::retrieveByPK($ta->getRegTestPeriod1())->getRegPeriod()->getName() : '';
?>
</td>
    </tr>
	<tr><td colspan="3"><br /><br>Jakarta, <?php 
echo date('d-m-Y');
?>
</td></tr>
	<tr><td colspan="3">
	<?php 
if ($ta->getDepartment1() == 2) {
    ?>
     	<?php 
    echo DepartmentPeer::retrieveByPK($ta->getDepartment1())->toString();
    ?>
&nbsp;ISLAM AL-AZHAR 10 KEMBANGAN