public function executeDeleteTempStudent()
{
$temp_table = TempTablePeer::retrieveByPk($this->getRequestParameter('id'));
$this->forward404Unless($temp_table);
$temp_table->delete();
$academic_calendar = AcademicCalendarPeer::retrieveByPK($this->getRequestParameter('accal_id'));
$this->forward404Unless($academic_calendar);
$counseling = CounselingPeer::retrieveByPk($this->getRequestParameter('counseling_id'));
$this->forward404Unless($counseling);
$tanggal = $this->getRequestParameter('time');
$time2 = $this->getRequestParameter('time2');
return $this->redirect('counseling_raport/previewStudent?counseling_id=' . $counseling->getId() . '&accal_id=' . $academic_calendar->getId() . '&time=' . $tanggal . '&time2=' . $time2);
}
public function executeGetListStudent()
{
$i18n = new sfI18N();
$i18n->initialize($this->getContext());
$i18n->setCulture($this->getUser()->getCulture());
$action_i18n = $i18n->globalMessageFormat->format('save as new');
$action_type = $this->getRequestParameter('action_type');
$group_id = $this->getContext()->getUser()->getAttribute('group_id', null, 'bo');
$counseling_id = $this->getRequestParameter('counseling_id');
$counseling = CounselingPeer::retrieveByPk($counseling_id);
$year = $this->getRequestParameter('year');
$month = $this->getRequestParameter('month');
$c = new Criteria();
#$c->add(VStuSppPeer::MONTH, $month);
#$c->add(VStuSppPeer::YEAR, $year);
#$c->addJoin(StudentPeer::ID, VStuSppPeer::PAYER);
$c->add(StudentPeer::CLASS_GROUP_ID, $counseling->getClassGroupId());
$c->add(StudentPeer::ACADEMIC_CALENDAR_ID, $counseling->getAcademicCalendarId());
$c->add(StudentPeer::STATUS, Student::STATUS_GRADUATE, Criteria::NOT_EQUAL);
$c->add(StudentPeer::STATUS, Student::STATUS_OVERDUE, 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->filterStudent($c, $this->getRequestParameter('filters'));
}
}
}
$rpp = $this->getRequestParameter('max_per_page', $this->getUser()->getAttribute('max_per_page', ParamsPeer::retrieveByCode('row_per_page')->getValue(), 'student'));
$this->getUser()->setAttribute('max_per_page', $rpp, 'student');
$pager = new sfPropelPager('Student', $rpp);
$pager->setCriteria($c);
$page = $this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'student'));
$this->getUser()->setAttribute('page', $page, 'student');
$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);
}
array_unshift($actions, array('name' => 'Proses', 'type' => 'image', 'options' => array('class' => 'save_button', 'onclick' => "action_type.value=this.value", 'title' => 'Proses')));
array_unshift($actions, array('name' => '_AS_CSV_', 'url' => "student_finance/getListStudentAsCSV?month={$month}&year={$year}&{$filter_string}", 'color' => 'black', 'type' => 'direct'));
array_unshift($actions, array('name' => '_AS_PDF_', 'url' => "student_finance/getListStudentAsPDF?month={$month}&year={$year}&{$filter_string}", 'color' => 'black', 'type' => 'direct'));
$this->actions = $actions;
$this->month = $month;
$this->year = $year;
$this->counseling = $counseling;
$this->subtitle = $counseling->getAcademicCalendar()->toString() . ' # ' . $counseling->getClassGroup()->toString();
$actions2 = array(array('name' => '<span>Jurnal Pembayaran Wakaf</span>', 'url' => 'student_finance/listStudent?counseling_id=' . $counseling->getId(), 'color' => 'sky'));
array_unshift($actions2, array('name' => '<span>Jurnal Keuangan Murid</span>', 'url' => 'student_finance/list', 'color' => 'sky'));
array_push($actions2, array('name' => '<span>Jurnal Pembayaran Infaq</span>', 'url' => 'student_finance/listInfaq?counseling_id=' . $counseling->getId(), 'color' => 'sky'));
array_push($actions2, array('name' => '<span>Jurnal Pembayaran SPP</span>', 'url' => 'student_finance/listSpp?counseling_id=' . $counseling->getId(), 'color' => 'sun', 'type' => 'direct'));
array_push($actions2, array('name' => '<span>Jurnal Pembayaran Lain-lain</span>', 'url' => 'student_finance/listElse?counseling_id=' . $counseling->getId(), 'color' => 'sky'));
$this->actions2 = $actions2;
$this->type = 'add';
}
public function executeDeleteTemp()
{
$temp_table = TempTablePeer::retrieveByPk($this->getRequestParameter('id'));
$this->forward404Unless($temp_table);
$temp_table->delete();
$academic_calendar = AcademicCalendarPeer::retrieveByPK($this->getRequestParameter('accal_id'));
$this->forward404Unless($academic_calendar);
$counseling = CounselingPeer::retrieveByPk($this->getRequestParameter('counseling_id'));
$this->forward404Unless($counseling);
$tanggal = $this->getRequestParameter('time');
$tanggal2 = $this->getRequestParameter('time2');
$term = $this->getRequestParameter('term');
$tgl_cetak = $this->getRequestParameter('tgl_cetak');
$this->getRequest()->setParameter('accal_id', $academic_calendar->getId());
$this->getRequest()->setParameter('term', $term);
$this->getRequest()->setParameter('counseling_id', $counseling->getId());
$this->getRequest()->setParameter('time', $tanggal);
$this->getRequest()->setParameter('time2', $tanggal2);
$this->getRequest()->setParameter('tgl_cetak', $tgl_cetak);
$this->forward($this->getModuleName(), 'preview');
}
public function executeDeleteTempExam()
{
$temp_table = TempTablePeer::retrieveByPk($this->getRequestParameter('id'));
$this->forward404Unless($temp_table);
$temp_table->delete();
$academic_calendar = AcademicCalendarPeer::retrieveByPK($this->getRequestParameter('accal_id'));
$this->forward404Unless($academic_calendar);
$counseling = CounselingPeer::retrieveByPk($this->getRequestParameter('counseling_id'));
$this->forward404Unless($counseling);
$tanggal = $this->getRequestParameter('time');
$time2 = $this->getRequestParameter('time2');
$test1 = $this->getRequestParameter('test1');
$test2 = $this->getRequestParameter('test2');
$task1 = $this->getRequestParameter('task1');
$task2 = $this->getRequestParameter('task2');
$note = $this->getRequestParameter('note');
return $this->redirect('counseling/previewExam?counseling_id=' . $counseling->getId() . '&accal_id=' . $academic_calendar->getId() . '&time=' . $tanggal . '&time2=' . $time2 . '¬e=' . $note . '&test1=' . $test1 . '&test2=' . $test2 . '&task1=' . $task1 . '&task2=' . $task2);
}
public function executeDelete()
{
$counseling = CounselingPeer::retrieveByPk($this->getRequestParameter('id'));
$this->forward404Unless($counseling);
$ref_error = 0;
foreach ($counseling->getRefCountMethods() as $ref) {
$method = "count" . $ref['affix'];
$count = $counseling->{$method}();
if ($count > 0) {
++$ref_error;
$this->getRequest()->setError('counselor/delete/' . sfInflector::camelize($ref['table']), $count);
}
}
if ($ref_error > 0) {
$this->getRequest()->setError('counselor/delete', '_ERR_DELETE_ (' . $counseling->toString() . ' - id:' . $counseling->getId() . ')');
} else {
$counseling->delete();
}
return $this->forward('counselor', 'list');
}
public function executeGetStudentAsXLS()
{
$counseling = CounselingPeer::retrieveByPk($this->getRequestParameter('id'));
$this->forward404Unless($counseling);
$this->counseling = $counseling;
$c = new Criteria();
$c->add(StudentAccalPeer::ACADEMIC_CALENDAR_ID, $counseling->getAcademicCalendar()->getChildB()->getId());
$c->add(StudentAccalPeer::CLASS_GROUP_ID, $counseling->getClassGroupId());
$c->addJoin(StudentPeer::ID, StudentAccalPeer::STUDENT_ID);
$c->addAscendingOrderByColumn(StudentPeer::NAME);
$rpp = $this->getRequestParameter('max_per_page', $this->getUser()->getAttribute('max_per_page', ParamsPeer::retrieveByCode('row_per_page')->getValue(), 'student'));
$this->getUser()->setAttribute('max_per_page', $rpp, 'student');
$pager = new sfPropelPager('Student', $rpp);
$pager->setCriteria($c);
$page = $this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'student'));
$this->getUser()->setAttribute('page', $page, 'student');
$pager->setPage($page);
$pager->init();
$this->pager = $pager;
$this->setLayout(false);
$this->getResponse()->setHttpHeader('Content-Type', 'application/vnd-ms-excel');
$this->getResponse()->setHttpHeader('Content-Disposition', 'attachment; filename="Peserta_Kelas_' . $counseling->getClassGroup()->getName() . '_' . $counseling->getAcademicCalendar()->getName() . '.xls"');
}
public function executeGetListForCounseling()
{
$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(StudentPeer::ACADEMIC_CALENDAR_ID, AcademicCalendarPeer::ID);
$counseling_id = $this->getRequestParameter('counseling_id');
$counseling = CounselingPeer::retrieveByPk($counseling_id);
if ($counseling) {
$c->add(AcademicCalendarPeer::DEPARTMENT_ID, $counseling->getAcademicCalendar()->getDepartmentId(), Criteria::IN);
$c->addJoin(StudentPeer::ACADEMIC_CALENDAR_ID, AcademicCalendarPeer::ID);
#$c->add(StudentPeer::ACADEMIC_CALENDAR_ID, $counseling->getAcademicCalendarId());
} else {
#$c->add(AcademicCalendarPeer::DEPARTMENT_ID, $counseling->getAcademicCalendar()->getDepartmentId(), Criteria::IN);
#$c->addJoin(StudentPeer::ACADEMIC_CALENDAR_ID, AcademicCalendarPeer::ID);
$c->add(StudentPeer::ACADEMIC_CALENDAR_ID, -1);
}
// filter out graduated student
$c->add(StudentPeer::STATUS, Student::STATUS_GRADUATE, Criteria::NOT_EQUAL);
$this->sort($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(), 'student'));
$this->getUser()->setAttribute('max_per_page', $rpp, 'student');
$pager = new sfPropelPager('Student', $rpp);
$pager->setCriteria($c);
$page = $this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'student'));
$this->getUser()->setAttribute('page', $page, 'student');
$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->counseling_id = $counseling_id;
}
public function executeListFullTryout()
{
$employee_id = sfContext::getInstance()->getUser()->getAttribute('user_id', null, 'bo');
$employee = EmployeePeer::retrieveByPK($employee_id);
$this->forward404Unless($employee);
$this->employee_id = $employee_id;
$this->employee = $employee;
$counseling = CounselingPeer::retrieveByPk($this->getRequestParameter('counseling_id'));
$this->forward404Unless($counseling);
$academic_calendar = AcademicCalendarPeer::retrieveByPk($this->getRequestParameter('accal_id'));
$this->forward404Unless($academic_calendar);
$c = new Criteria();
$c->add(StudentAccalPeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId());
$c->add(StudentAccalPeer::CLASS_GROUP_ID, $counseling->getClassGroupId());
$c->addJoin(VStudentActivePeer::ID, StudentAccalPeer::STUDENT_ID);
$c->addJoin(StudentPeer::ID, VStudentActivePeer::ID);
$c->addAscendingOrderByColumn(StudentPeer::CLASS_NAME);
$this->students = StudentPeer::doSelect($c);
$this->student_count = StudentPeer::doCount($c);
$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;
$grade_id = $this->getRequestParameter('grade_id');
$this->grade_id = $grade_id;
$cr = new Criteria();
$cr->add(GradeSpecPeer::PARENT, 45, Criteria::IN);
#$cr->add(GradeSpecPeer::ID, $grade_id, Criteria::NOT_IN);
$grade1 = GradeSpecPeer::doSelect($cr);
$count1 = GradeSpecPeer::doCount($cr);
$this->grade1 = $grade1;
$this->count1 = $count1;
$grade_current = GradeSpecPeer::retrieveByPk($grade_id);
$this->counseling = $counseling;
$this->academic_calendar = $academic_calendar;
$this->subtitle = $grade_current->getCode() . ' # ' . $counseling->getClassGroup()->getName() . ' - ' . $academic_calendar->toString();
#SMP
if ($academic_calendar->getDepartmentId() == 2) {
$cw = new Criteria();
$cw->add(VCoursePeer::CLASS_GROUP_ID, $counseling->getClassGroupId(), Criteria::IN);
$cw->add(VCoursePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId(), Criteria::IN);
$cton1 = $cw->getNewCriterion(VCoursePeer::SUBJECT_CURR_ID, 350, Criteria::IN);
$cton2 = $cw->getNewCriterion(VCoursePeer::SUBJECT_CURR_ID, 351, Criteria::IN);
$cton3 = $cw->getNewCriterion(VCoursePeer::SUBJECT_CURR_ID, 346, Criteria::IN);
$cton4 = $cw->getNewCriterion(VCoursePeer::SUBJECT_CURR_ID, 339, Criteria::IN);
$cton5 = $cw->getNewCriterion(VCoursePeer::SUBJECT_CURR_ID, 340, Criteria::IN);
$cton6 = $cw->getNewCriterion(VCoursePeer::SUBJECT_CURR_ID, 337, Criteria::IN);
$cton5->addOr($cton6);
$cton4->addOr($cton5);
$cton3->addOr($cton4);
$cton2->addOr($cton3);
$cton1->addOr($cton2);
$cw->add($cton1);
$cw->addAscendingOrderByColumn(VCoursePeer::CODE);
$this->smp_subjects = VCoursePeer::doSelect($cw);
$this->smp_count = VCoursePeer::doCount($cw);
$cd = new Criteria();
$cd->add(VCoursePeer::CLASS_GROUP_ID, $counseling->getClassGroupId(), Criteria::IN);
$cd->add(VCoursePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId(), Criteria::IN);
$cton1 = $cd->getNewCriterion(VCoursePeer::SUBJECT_CURR_ID, 352, Criteria::IN);
$cton2 = $cd->getNewCriterion(VCoursePeer::SUBJECT_CURR_ID, 349, Criteria::IN);
$cton3 = $cd->getNewCriterion(VCoursePeer::SUBJECT_CURR_ID, 348, Criteria::IN);
$cton4 = $cd->getNewCriterion(VCoursePeer::SUBJECT_CURR_ID, 341, Criteria::IN);
$cton5 = $cd->getNewCriterion(VCoursePeer::SUBJECT_CURR_ID, 355, Criteria::IN);
$cton4->addOr($cton5);
$cton3->addOr($cton4);
$cton2->addOr($cton3);
$cton1->addOr($cton2);
$cd->add($cton1);
$cd->addAscendingOrderByColumn(VCoursePeer::CODE);
$this->smp_subjects2 = VCoursePeer::doSelect($cd);
$this->smp_count2 = VCoursePeer::doCount($cd);
$cm = new Criteria();
$cm->add(VCoursePeer::CLASS_GROUP_ID, $counseling->getClassGroupId(), Criteria::IN);
$cm->add(VCoursePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId(), Criteria::IN);
$cton1 = $cm->getNewCriterion(VCoursePeer::SUBJECT_CURR_ID, 353, Criteria::IN);
$cton2 = $cm->getNewCriterion(VCoursePeer::SUBJECT_CURR_ID, 354, Criteria::IN);
$cton1->addOr($cton2);
$cm->add($cton1);
$cm->addAscendingOrderByColumn(VCoursePeer::CODE);
$this->ipas = VCoursePeer::doSelect($cm);
$this->ipa_count = VCoursePeer::doCount($cm);
$cl = new Criteria();
$cl->add(VCoursePeer::CLASS_GROUP_ID, $counseling->getClassGroupId(), Criteria::IN);
$cl->add(VCoursePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId(), Criteria::IN);
$cton1 = $cl->getNewCriterion(VCoursePeer::SUBJECT_CURR_ID, 343, Criteria::IN);
$cton2 = $cl->getNewCriterion(VCoursePeer::SUBJECT_CURR_ID, 338, Criteria::IN);
$cton3 = $cl->getNewCriterion(VCoursePeer::SUBJECT_CURR_ID, 347, Criteria::IN);
$cton2->addOr($cton3);
$cton1->addOr($cton2);
$cl->add($cton1);
$cl->addAscendingOrderByColumn(VCoursePeer::CODE);
$this->ips = VCoursePeer::doSelect($cl);
$this->ips_count = VCoursePeer::doCount($cl);
#SD
} else {
if ($counseling->getClassGroup()->getParent() == 54) {
$cw = new Criteria();
$cw->add(VCoursePeer::CLASS_GROUP_ID, $counseling->getClassGroupId());
$cw->add(VCoursePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId());
$cton1 = $cw->getNewCriterion(VCoursePeer::SUBJECT_CURR_ID, 319, Criteria::NOT_IN);
$cton2 = $cw->getNewCriterion(VCoursePeer::SUBJECT_CURR_ID, 332, Criteria::NOT_IN);
$cton1->addAnd($cton2);
$cw->add($cton1);
$cw->addAscendingOrderByColumn(VCoursePeer::CODE);
$this->sd_subjects = VCoursePeer::doSelect($cw);
$this->sd_count = VCoursePeer::doCount($cw);
} else {
$cw = new Criteria();
$cw->add(VCoursePeer::CLASS_GROUP_ID, $counseling->getClassGroupId());
$cw->add(VCoursePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId());
$cw->add(VCoursePeer::SUBJECT_CURR_ID, 319, Criteria::NOT_IN);
$cw->addAscendingOrderByColumn(VCoursePeer::CODE);
$this->sd_subjects = VCoursePeer::doSelect($cw);
$this->sd_count = VCoursePeer::doCount($cw);
}
$cri = new Criteria();
$cri->add(VCoursePeer::CLASS_GROUP_ID, $counseling->getClassGroupId(), Criteria::IN);
$cri->add(VCoursePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId(), Criteria::IN);
$cri->add(VCoursePeer::SUBJECT_GROUP_ID, 7, Criteria::IN);
$cri->add(VCoursePeer::SUBJECT_CURR_ID, 319, Criteria::NOT_IN);
$cri->addAscendingOrderByColumn(VCoursePeer::CODE);
$this->sd_subjects7 = VCoursePeer::doSelect($cri);
$this->sd_count7 = VCoursePeer::doCount($cri);
$crit = new Criteria();
$crit->add(VCoursePeer::CLASS_GROUP_ID, $counseling->getClassGroupId());
$crit->add(VCoursePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId());
$crit->add(VCoursePeer::SUBJECT_GROUP_ID, 8);
$crit->addAscendingOrderByColumn(VCoursePeer::CODE);
$this->sd_subjects8 = VCoursePeer::doSelect($crit);
$this->sd_count8 = VCoursePeer::doCount($crit);
}
$actions = array();
array_unshift($actions, array('name' => '_AS_CSV_', 'url' => "course_detail/listFullTryoutAsCSV?counseling_id=" . $counseling->getId() . "&accal_id=" . $academic_calendar->getId() . "&grade_id=" . $grade_id, 'color' => 'black', 'type' => 'direct'));
array_unshift($actions, array('name' => '_AS_PDF_', 'url' => "course_detail/listFullTryoutAsPDF?counseling_id=" . $counseling->getId() . "&accal_id=" . $academic_calendar->getId() . "&grade_id=" . $grade_id, 'color' => 'black', 'type' => 'direct'));
$this->actions = $actions;
$actions2 = array(array('name' => '<span>' . $academic_calendar->getName() . '</span>', 'url' => 'counseling_menu/listLedger', 'color' => 'sun'));
foreach ($grade1 as $grade) {
if ($grade->getId() == $grade_id) {
array_push($actions2, array('name' => '<span>' . $grade->getCode() . '</span>', 'url' => 'course_detail/listFullTryout?counseling_id=' . $counseling->getId() . '&accal_id=' . $academic_calendar->getId() . '&grade_id=' . $grade->getId(), 'color' => 'sky', 'type' => 'direct'));
} else {
array_push($actions2, array('name' => '<span>' . $grade->getCode() . '</span>', 'url' => 'course_detail/listFullTryout?counseling_id=' . $counseling->getId() . '&accal_id=' . $academic_calendar->getId() . '&grade_id=' . $grade->getId(), 'color' => 'sun'));
}
}
$this->actions2 = $actions2;
}
