public function getParentName()
{
if ($this->getParent() != null && $this->getParent() != 0) {
return ClassGroupPeer::retrieveByPk($this->getParent())->getName();
}
return '-';
}
<div class="login">
<p style="text-align:left; width:90%; line-height: 15px; padding-top: 0px;"></p>
<h2 class="contentheading"><b><?php
echo $this->getContext()->getUser()->getAttribute('username_long', '', 'bo');
?>
</b></h2>
<?php
$applicant = TestApplicantPeer::retrieveByPk($this->getContext()->getUser()->getAttribute('user_id', '', 'bo'));
$cls = ClassGroupPeer::retrieveByPk($applicant->getClassGroup1());
?>
<p style="padding-top: 15px; line-height: 20px;">No. Pendaftaran Anda adalah <br><b><?php
echo $applicant->getCode() ? $applicant->getCode() : '-';
?>
</b><br />
Pilihan Kelas Anda adalah <br><b><?php
echo $applicant->getClassGroup1() ? $cls->toString() . ' - ' . $cls->getParentName() : '-';
?>
</b><br /><br>
<?php
echo link_to_remote('Informasi Detail', array('url' => 'auth/test?id=' . $applicant->getId(), 'update' => 'content', 'script' => 'true'), array('class' => 'user_logout', 'title' => 'Detail Informasi'));
?>
<br />
<?php
echo link_to('Logout', '/auth/logout', 'class=user_logout title=keluar');
?>
</p>
</div>
<td align="left">2.</td>
<td align="left">Nama</td>
<td align="center">:</td>
<td align="left"><?php
echo $ta->getName() ? $ta->getName() : '-';
?>
</td>
</tr>
<tr>
<td></td>
<td align="left">3.</td>
<td align="left">Pilihan Kelas</td>
<td align="center">:</td>
<td align="left">
<?php
$cls = ClassGroupPeer::retrieveByPk($ta->getClassGroup1());
echo $ta->getClassGroup1() ? $cls->toString() . ' - ' . $cls->getParentName() : '-';
?>
</td>
</tr>
<tr>
<td></td>
<td align="left">4.</td>
<td align="left">Asal Sekolah</td>
<td align="center">:</td>
<td align="left"><?php
echo $ta_detail->getJobTitle() ? $ta_detail->getJobTitle() : '-';
?>
</td>
</tr>
<tr>
?>
<?php
}
?>
<?php
} else {
?>
<?php
echo '-';
?>
<?php
}
?>
</td>
<td><?php
echo $student->getClassGroupId() ? ClassGroupPeer::retrieveByPk($student->getClassGroupId())->toString() : '-';
?>
</td>
<td><?php
if ($student->getStatus() == Student::STATUS_ACTIVE) {
echo __('_STUDENT_STATUS_ACTIVE_');
} elseif ($student->getStatus() == Student::STATUS_INACTIVE) {
echo __('_STUDENT_STATUS_INACTIVE_');
} elseif ($student->getStatus() == Student::STATUS_OVERDUE) {
echo __('_STUDENT_STATUS_OVERDUE_');
} elseif ($student->getStatus() == Student::STATUS_FINAL) {
echo __('_STUDENT_STATUS_FINAL_');
} elseif ($student->getStatus() == Student::STATUS_GRADUATE) {
echo __('_STUDENT_STATUS_GRADUATE_');
}
?>
</tr>
<tr>
<td align="left">9.</td>
<td align="left">Diterima di Sekolah ini</td>
<td align="center">:</td>
<td align="left"></td>
</tr>
<tr>
<td align="left"></td>
<td align="left">a. Di Kelas <?php
echo $score_rule ? $score_rule->getLanguage() == 'Bilingual' ? '<i style="font-size: 80%; font-weight: normal;"> / In The Grade</i>' : '' : '';
?>
</td>
<td align="center">:</td>
<td align="left"><?php
echo $applicant ? ClassGroupPeer::retrieveByPk($applicant->getClassGroup1())->toString() : '-';
?>
</td>
</tr>
<tr>
<td align="left"></td>
<td align="left">b. Pada Tanggal <?php
echo $score_rule ? $score_rule->getLanguage() == 'Bilingual' ? '<i style="font-size: 80%; font-weight: normal;"> / On The Date of</i>' : '' : '';
?>
</td>
<td align="center">:</td>
<td align="left">12 Juli <?php
echo $student->getYear() ? $student->getYear() : ' ';
?>
</td>
</tr>
public function executeListSubject(Criteria $cr = null)
{
$group_id = $this->getContext()->getUser()->getAttribute('group_id', null, 'bo');
$cr = new Criteria();
$this->class_group = ClassGroupPeer::retrieveByPk($this->getRequestParameter('class_id'));
$this->forward404Unless($this->class_group);
$this->academic_calendar = AcademicCalendarPeer::retrieveByPk($this->getRequestParameter('accal_id'));
$this->forward404Unless($this->academic_calendar);
$cr->add(SubjectAccalPeer::ACADEMIC_CALENDAR_ID, $this->academic_calendar->getId());
$cr->addJoin(CourseSchedulePeer::SUBJECT_ACCAL_ID, SubjectAccalPeer::ID);
$cr->add(CourseSchedulePeer::CLASS_GROUP_ID, $this->class_group->getId());
$this->sortSubject($cr);
if ($this->getRequest()->hasParameter('filters')) {
$filters = $this->getRequestParameter('filters');
if ($filters == 'clear') {
$this->filters = null;
} else {
$defined_filter = false;
foreach ($filters as $f) {
if ($f != null && $f != '') {
$defined_filter = true;
break;
}
}
if ($defined_filter) {
$this->filters = $filters;
$this->filterSubject($cr, $this->getRequestParameter('filters'));
}
}
}
$rpp = $this->getRequestParameter('max_per_page', $this->getUser()->getAttribute('max_per_page', ParamsPeer::retrieveByCode('row_per_page')->getValue(), 'course_schedule'));
$this->getUser()->setAttribute('max_per_page', $rpp, 'course_schedule');
$pager = new sfPropelPager('CourseSchedule', $rpp);
$cr->add(SubjectAccalPeer::ACADEMIC_CALENDAR_ID, $this->academic_calendar->getId());
$cr->addJoin(CourseSchedulePeer::SUBJECT_ACCAL_ID, SubjectAccalPeer::ID);
$cr->add(CourseSchedulePeer::CLASS_GROUP_ID, $this->class_group->getId());
$pager->setCriteria($cr);
$page = $this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'course_schedule'));
$this->getUser()->setAttribute('page', $page, 'course_schedule');
$pager->setPage($page);
$pager->init();
$this->pager = $pager;
$actions = array(array('name' => 'filter', 'color' => 'white'));
$filter_string = "";
if ($this->filters) {
foreach ($this->filters as $key => $val) {
$filter_string .= "&filters[{$key}]={$val}";
}
$filter_string = preg_replace('/^&/', '', $filter_string);
}
$this->filter_string = $filter_string;
#array_unshift($actions, array('name'=>'_AS_CSV_','url'=>"subject_plan/listSubjectAsCSV?$filter_string", 'color'=>'white', 'type'=>'direct'));
#array_unshift($actions, array('name'=>'_AS_PDF_','url'=>"subject_plan/listSubjectAsPDF?$filter_string", 'color'=>'white', 'type'=>'direct'));
array_unshift($actions, array('name' => 'back', 'url' => "subject_plan/list", 'color' => 'green'));
$this->subtitle = '';
$this->actions = $actions;
}
<?php
echo input_hidden_tag('accal2', $accal2);
?>
</td>
</tr>
<tr>
<td width="20%" style="vertical-align:middle;"><label><?php
echo __('Class group');
?>
</label></td>
<td width="2%" style="text-align:center; vertical-align:middle;">:</td>
<td style="vertical-align:middle;">
<p class="detail" style="font-weight: bold;">
<?php
echo $class2 ? ClassGroupPeer::retrieveByPk($class2)->getName() : '-';
?>
</p>
<?php
echo input_hidden_tag('class2', $class2);
?>
</td>
</tr>
</tbody>
</table>
</td></tr>
</table>
<table class="form">
<tr><td class="form">
<table class="form_content" width="100%">
public function executeSimpan()
{
$academic1 = AcademicCalendarPeer::retrieveByPk($this->getRequestParameter('accal1'));
$academic2 = AcademicCalendarPeer::retrieveByPk($this->getRequestParameter('accal2'));
$class1 = ClassGroupPeer::retrieveByPk($this->getRequestParameter('class1'));
$class2 = ClassGroupPeer::retrieveByPk($this->getRequestParameter('class2'));
return $this->redirect('score_rule_new/preview?class1=' . $this->getRequestParameter('class1') . '&accal1=' . $this->getRequestParameter('accal1') . '&class2=' . $this->getRequestParameter('class2') . '&accal2=' . $this->getRequestParameter('accal2'));
}
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');
}
public function executeDelete()
{
$class_group = ClassGroupPeer::retrieveByPk($this->getRequestParameter('id'));
$this->forward404Unless($class_group);
$ref_error = 0;
foreach ($class_group->getRefCountMethods() as $ref) {
$method = "count" . $ref['affix'];
$count = $class_group->{$method}();
if ($count > 0) {
++$ref_error;
$this->getRequest()->setError('class_group/delete/' . sfInflector::camelize($ref['table']), $count);
}
}
if ($ref_error > 0) {
$this->getRequest()->setError('class_group/delete', '_ERR_DELETE_ (' . $class_group->toString() . ' - id:' . $class_group->getId() . ')');
} else {
$class_group->delete();
}
return $this->forward('class_group', 'list');
}
public function executeSaveCopy()
{
$academic1 = AcademicCalendarPeer::retrieveByPk($this->getRequestParameter('accal1'));
$academic2 = AcademicCalendarPeer::retrieveByPk($this->getRequestParameter('accal2'));
$class1 = ClassGroupPeer::retrieveByPk($this->getRequestParameter('class1'));
$class2 = ClassGroupPeer::retrieveByPk($this->getRequestParameter('class2'));
return $this->redirect('course_sched/previewCopy?class1=' . $this->getRequestParameter('class1') . '&accal1=' . $this->getRequestParameter('accal1') . '&class2=' . $this->getRequestParameter('class2') . '&accal2=' . $this->getRequestParameter('accal2'));
}
public function executeSaveStu()
{
$academic_calendar = AcademicCalendarPeer::retrieveByPK($this->getRequestParameter('accal_id'));
$this->forward404Unless($academic_calendar);
$class_group = ClassGroupPeer::retrieveByPk($this->getRequestParameter('class_id'));
$this->forward404Unless($class_group);
$counseling = CounselingPeer::retrieveByPk($this->getRequestParameter('counseling_id'));
$this->forward404Unless($counseling);
$c = new Criteria();
$c->add(AcademicCalendarPeer::PARENT, $counseling->getAcademicCalendarId());
$accals = AcademicCalendarPeer::doSelect($c);
$student_list_ser = $this->getRequestParameter('student_list_ser');
$params = array();
foreach (explode('&', $this->getRequestParameter('student_list_ser')) as $p) {
$p = explode('=', $p);
$params[rawurldecode($p[0])][] = rawurldecode($p[1]);
}
if (array_key_exists('students', $params)) {
foreach ($params['students'] as $student_id) {
if ($accals) {
foreach ($accals as $accal) {
$ct = new Criteria();
$ct->add(StudentAccalPeer::ACADEMIC_CALENDAR_ID, $accal->getId(), Criteria::EQUAL);
$ct->add(StudentAccalPeer::CLASS_GROUP_ID, $counseling->getClassGroupId(), Criteria::NOT_EQUAL);
$ct->add(StudentAccalPeer::STUDENT_ID, $student_id, Criteria::EQUAL);
$stu_accal = StudentAccalPeer::doSelectOne($ct);
if ($stu_accal) {
$stu_accal->delete();
}
$cr = new Criteria();
$cr->add(StudentAccalPeer::ACADEMIC_CALENDAR_ID, $accal->getId());
$cr->add(StudentAccalPeer::CLASS_GROUP_ID, $counseling->getClassGroupId());
$cr->add(StudentAccalPeer::STUDENT_ID, $student_id);
$student_accal = StudentAccalPeer::doSelectOne($cr);
if ($student_accal == null) {
$student_accal = new StudentAccal();
}
$student_accal->setStudentId($student_id);
$student_accal->setAcademicCalendarId($accal->getId());
$student_accal->setClassGroupId($counseling->getClassGroupId());
$student_accal->setStatus(Student::STATUS_ACTIVE);
$student_accal->save();
}
$student = StudentPeer::retrieveByPK($student_id);
#$student->setAcademicCalendarId($counseling->getAcademicCalendarId());
$student->setClassGroupId($counseling->getClassGroupId());
$student->save();
}
}
}
#return $this->redirect('counseling_sd/listEksStu?id='.$schedule->getId().'&detail_id='.$schedule_detail->getId().'&accal_id='.$academic_calendar->getId().'&counseling_id='.$counseling->getId());
#$this->getRequest()->setParameter('accal_id', $academic_calendar->getId());
#$this->getRequest()->setParameter('id', $schedule->getId());
$this->getRequest()->setParameter('id', $counseling->getId());
$this->forward($this->getModuleName(), 'student');
}
public function executeGetListForCounseling2()
{
$group_id = $this->getContext()->getUser()->getAttribute('group_id', null, 'bo');
$c = new Criteria();
$c->add(JobPeer::CODE, $this->getModuleName());
$job = JobPeer::doSelectOne($c);
$acl = AclPeer::retrieveByPK($group_id, $job->getId());
if (!$acl) {
$this->forward('default', 'error404');
}
$this->can_edit = $acl->getEditPriv() == 1;
$this->can_remove = $acl->getRemovePriv() == 1;
$c = new Criteria();
$dept = $this->getContext()->getUser()->getAttribute('department', null, 'bo');
$c->add(AcademicCalendarPeer::DEPARTMENT_ID, $dept->getChildRecurs(), Criteria::IN);
$c->addJoin(VStudentClassPeer::ACADEMIC_CALENDAR_ID, AcademicCalendarPeer::ID);
$class_id = $this->getRequestParameter('class_id');
$class = ClassGroupPeer::retrieveByPk($class_id);
$class_group = VClassGroupPeer::retrieveByPk($class_id);
if ($class) {
$cton1 = $c->getNewCriterion(VStudentClassPeer::CLASS_GROUP_ID, $class, Criteria::IN);
$cton2 = $c->getNewCriterion(VStudentClassPeer::CLASS_PARENT, $class, Criteria::IN);
$cton1->addOr($cton2);
$c->add($cton1);
#$c->add(VStudentClassPeer::CLASS_GROUP_ID, $class, Criteria::IN);
#$c->add(StudentPeer::CLASS_GROUP_ID, $class->getId(), Criteria::IN);
} elseif ($class_group) {
#$cton1 = $c->getNewCriterion(VStudentClassPeer::CLASS_GROUP_ID, $class_group, Criteria::IN);
#$cton2 = $c->getNewCriterion(VStudentClassPeer::CLASS_PARENT, $class_group, Criteria::IN);
#$cton1->addOr($cton2);
#$c->add($cton1);
$c->add(VStudentClassPeer::CLASS_PARENT, $class_group, Criteria::IN);
} else {
#$c->add(StudentPeer::ACADEMIC_CALENDAR_ID, -1);
$c->add(VStudentClassPeer::ACADEMIC_CALENDAR_ID, -1);
}
// filter out graduated student
$c->add(VStudentClassPeer::STATUS, Student::STATUS_GRADUATE, Criteria::NOT_EQUAL);
$this->sortStudent($c);
if ($this->getRequest()->hasParameter('filters')) {
$filters = $this->getRequestParameter('filters');
if ($filters == 'clear') {
$this->filters = null;
} else {
$defined_filter = false;
foreach ($filters as $f) {
if (is_array($f)) {
if (strlen($f['from']) > 0 || strlen($f['to']) > 0) {
$defined_filter = true;
break;
}
} else {
if ($f != null && $f != '') {
$defined_filter = true;
break;
}
}
}
if ($defined_filter) {
$this->filters = $filters;
$this->filter($c, $this->getRequestParameter('filters'));
}
}
}
$rpp = $this->getRequestParameter('max_per_page', $this->getUser()->getAttribute('max_per_page', ParamsPeer::retrieveByCode('row_per_page')->getValue(), 'v_student_class'));
$this->getUser()->setAttribute('max_per_page', $rpp, 'v_student_class');
$pager = new sfPropelPager('VStudentClass', $rpp);
$pager->setCriteria($c);
$page = $this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'v_student_class'));
$this->getUser()->setAttribute('page', $page, 'v_student_class');
$pager->setPage($page);
$pager->init();
$this->pager = $pager;
#$actions = array(array('name'=>'filter','color'=>'white'),);
#if ($acl->getAddPriv()) array_unshift($actions, array('name'=>'add','url'=>'student/create', 'color'=>'green'));
$actions = array(array('name' => 'filter', 'color' => 'white'));
$filter_string = "";
if ($this->filters) {
foreach ($this->filters as $key => $val) {
$filter_string .= "&filters[{$key}]={$val}";
}
$filter_string = preg_replace('/^&/', '', $filter_string);
}
$this->actions = $actions;
$this->class_id = $class_id;
}
public function executeListShow()
{
$employee_id = sfContext::getInstance()->getUser()->getAttribute('user_id', null, 'bo');
$employee = EmployeePeer::retrieveByPK($employee_id);
$this->forward404Unless($employee);
$this->employee_id = $employee_id;
$c = new Criteria();
$c->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $this->getRequestParameter('accal_id'));
$c->add(StudentCoursePeer::SUBJECT_CURR_ID, $this->getRequestParameter('subject_id'));
$c->add(StudentCoursePeer::CLASS_GROUP_ID, $this->getRequestParameter('class_id'));
$c->addJoin(VStudentActivePeer::ID, StudentCoursePeer::STUDENT_ID);
$c->addAscendingOrderByColumn(VStudentActivePeer::NAME);
$this->students = VStudentActivePeer::doSelect($c);
$this->student_count = VStudentActivePeer::doCount($c);
$subject_curr = SubjectCurrPeer::retrieveByPk($this->getRequestParameter('subject_id'));
$this->forward404Unless($subject_curr);
$class_group = ClassGroupPeer::retrieveByPk($this->getRequestParameter('class_id'));
$this->forward404Unless($class_group);
$academic_calendar = AcademicCalendarPeer::retrieveByPk($this->getRequestParameter('accal_id'));
$this->forward404Unless($academic_calendar);
$cw = new Criteria();
$cw->add(CourseSchedulePeer::SUBJECT_CURR_ID, $subject_curr->getId());
$cw->add(CourseSchedulePeer::CLASS_GROUP_ID, $class_group->getId());
$cw->add(CourseSchedulePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId());
$course_schedule = CourseSchedulePeer::doSelectOne($cw);
$cr = new Criteria();
$cr->add(GradeSpecPeer::PARENT, 1);
$this->grade1 = GradeSpecPeer::doSelect($cr);
$this->count1 = GradeSpecPeer::doCount($cr);
$cr = new Criteria();
$cr->add(GradeSpecPeer::PARENT, 7);
$this->grade2 = GradeSpecPeer::doSelect($cr);
$this->count2 = GradeSpecPeer::doCount($cr);
$cr = new Criteria();
$cr->add(GradeSpecPeer::PARENT, 30);
$this->grade3 = GradeSpecPeer::doSelect($cr);
$this->count3 = GradeSpecPeer::doCount($cr);
$this->subject_curr = $subject_curr;
$this->academic_calendar = $academic_calendar;
$this->class_group = $class_group;
$rpp = $this->getRequestParameter('max_per_page', 999);
$pager = new sfPropelPager('Student', $rpp);
$pager->setCriteria($c);
$pager->setPage($this->getRequestParameter('page', 1));
$pager->init();
$this->pager = $pager;
$actions2 = array(array('name' => '<span>Daftar Guru Kelas</span>', 'url' => 'employee_agenda/list', 'color' => 'sun'));
array_push($actions2, array('name' => '<span>Agenda Kelas</span>', 'url' => 'employee_agenda/listAgenda?course_id=' . $course_schedule->getId(), 'color' => 'sun'));
array_push($actions2, array('name' => '<span>Absensi</span>', 'url' => 'employee_agenda/listAbsence?course_id=' . $course_schedule->getId(), 'color' => 'sun'));
array_push($actions2, array('name' => '<span>Jadwal Tugas/Ulangan/PR</span>', 'url' => 'employee_agenda/listTest?course_id=' . $course_schedule->getId(), 'color' => 'sun'));
array_push($actions2, array('name' => '<span>Penilaian</span>', 'url' => 'course_detail/listShow?subject_id=' . $course_schedule->getSubjectCurrId() . '&class_id=' . $course_schedule->getClassGroupId() . '&accal_id=' . $course_schedule->getAcademicCalendarId(), 'color' => 'sun', 'type' => 'direct'));
if ($course_schedule->getClassGroup()->getParent() == 70 || $course_schedule->getClassGroup()->getParent() == 85 || $course_schedule->getClassGroup()->getParent() == 117) {
array_push($actions2, array('name' => '<span>Penilaian Tryout</span>', 'url' => 'course_detail/listTryout?subject_id=' . $course_schedule->getSubjectCurrId() . '&class_id=' . $course_schedule->getClassGroupId() . '&accal_id=' . $course_schedule->getAcademicCalendarId(), 'color' => 'sun'));
}
$this->actions2 = $actions2;
}
