public function executePreview() { $counseling_id = $this->getRequestParameter('counseling_id'); $counseling = CounselingPeer::retrieveByPK($counseling_id); $this->forward404Unless($counseling); $accal_id = $this->getRequestParameter('accal_id'); $academic_calendar = AcademicCalendarPeer::retrieveByPK($accal_id); $this->forward404Unless($academic_calendar); $time = $this->getRequestParameter('time'); $time2 = $this->getRequestParameter('time2'); $tgl_cetak = $this->getRequestParameter('tgl_cetak'); $term = $this->getRequestParameter('term'); $cr = new Criteria(); $cr->add(TempTablePeer::COUNSELING_ID, $counseling->getId()); $cr->add(TempTablePeer::TIME, $time); ##Sort Option $cr->addJoin(StudentPeer::ID, TempTablePeer::STUDENT_ID); $cr->addAscendingOrderByColumn(StudentPeer::NAME); $temp_table = TempTablePeer::doSelect($cr); #Printout Cover $actions = array(array('name' => 'cover', 'url' => 'counseling_sd/listRaport?counseling_id=' . $counseling->getId() . '&accal_id=' . $academic_calendar->getId(), 'color' => 'blue', 'before' => "window.open('" . $this->getController()->genUrl('/counseling_sd/printCover') . "?counseling_id='+\$('counseling_id').value+'&time='+\$('tanggal').value+'&time2='+\$('time2').value+'&tgl_cetak='+\$('tgl_cetak').value+'&accal_id='+\$('accal_id').value,'link','height=480,width=640,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,location=no,directories=no,status=no')")); #Printout Induk Register array_push($actions, array('name' => 'induk', 'url' => 'counseling_sd/listRaport?counseling_id=' . $counseling->getId() . '&accal_id=' . $academic_calendar->getId(), 'color' => 'blue', 'before' => "window.open('" . $this->getController()->genUrl('/counseling_sd/printRegister') . "?counseling_id='+\$('counseling_id').value+'&time='+\$('tanggal').value+'&time2='+\$('time2').value+'&tgl_cetak='+\$('tgl_cetak').value+'&accal_id='+\$('accal_id').value,'link','height=480,width=640,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,location=no,directories=no,status=no')")); #Printout Raport Bayangan array_push($actions, array('name' => 'bayangan', 'url' => 'counseling_sd/listRaport?counseling_id=' . $counseling->getId() . '&accal_id=' . $academic_calendar->getId(), 'color' => 'blue', 'before' => "window.open('" . $this->getController()->genUrl('/counseling_sd/printMiddle') . "?counseling_id='+\$('counseling_id').value+'&time='+\$('tanggal').value+'&time2='+\$('time2').value+'&tgl_cetak='+\$('tgl_cetak').value+'&accal_id='+\$('accal_id').value,'link','height=480,width=640,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,location=no,directories=no,status=no')")); #Printout Raport Semester array_push($actions, array('name' => 'raport', 'url' => 'counseling_sd/listRaport?counseling_id=' . $counseling->getId() . '&accal_id=' . $academic_calendar->getId(), 'color' => 'blue', 'before' => "window.open('" . $this->getController()->genUrl('/counseling_sd/printFinal') . "?counseling_id='+\$('counseling_id').value+'&time='+\$('tanggal').value+'&time2='+\$('time2').value+'&tgl_cetak='+\$('tgl_cetak').value+'&accal_id='+\$('accal_id').value,'link','height=480,width=640,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,location=no,directories=no,status=no')")); $actions2 = array(array('name' => '<span>Wali Kelas</span>', 'url' => 'counseling_sd/list?academic_calendar_id=' . $academic_calendar->getId(), 'color' => 'sun')); array_push($actions2, array('name' => '<span>' . $academic_calendar->toString() . '</span>', 'url' => 'counseling_sd/preview?counseling_id=' . $counseling->getId() . '&accal_id=' . $academic_calendar->getId() . '&time=' . $time . '&time2=' . $time2 . '&tgl_cetak=' . $tgl_cetak . '&term=' . $term, 'color' => 'sky', 'type' => 'direct')); $this->actions2 = $actions2; $this->actions = $actions; $this->actions3 = array(); $this->counseling = $counseling; $this->subtitle = $academic_calendar->toString() . ' # ' . $counseling->getClassGroup()->toString(); $this->academic_calendar = $academic_calendar; $this->counseling_id = $counseling->getId(); $this->accal_id = $academic_calendar->getId(); $this->time = $time; $this->time2 = $time2; $this->tgl_cetak = $tgl_cetak; $this->term = $term; $this->temp_table = $temp_table; }
public function executePreviewStudent() { $counseling_id = $this->getRequestParameter('counseling_id'); $counseling = CounselingPeer::retrieveByPK($counseling_id); $this->forward404Unless($counseling); $accal_id = $this->getRequestParameter('accal_id'); $academic_calendar = AcademicCalendarPeer::retrieveByPK($accal_id); $this->forward404Unless($academic_calendar); $time = $this->getRequestParameter('time'); $time2 = $this->getRequestParameter('time2'); $tgl_cetak = $this->getRequestParameter('tgl_cetak'); $cr = new Criteria(); $cr->add(TempTablePeer::COUNSELING_ID, $counseling->getId()); $cr->add(TempTablePeer::TIME, $time); $temp_table = TempTablePeer::doSelect($cr); #Printout Pekan Ulangan $actions = array(array('name' => 'Print PDF', 'url' => 'counseling_raport/listStudent?counseling_id=' . $counseling->getId() . '&accal_id=' . $academic_calendar->getId(), 'color' => 'black', 'before' => "window.open('" . $this->getController()->genUrl('/counseling_raport/printCounseling') . "?counseling_id='+\$('counseling_id').value+'&time='+\$('tanggal').value+'&time2='+\$('time2').value+'&tgl_cetak='+\$('tgl_cetak').value+'&accal_id='+\$('accal_id').value,'link','height=480,width=640,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,location=no,directories=no,status=no')")); $actions2 = array(array('name' => '<span>Penilaian Konseling</span>', 'url' => 'counseling_raport/list', 'color' => 'sky')); array_push($actions2, array('name' => '<span>Printout Laporan Konseling</span>', 'url' => 'counseling_raport/listStudent?accal_id=' . $academic_calendar->getId() . '&counseling_id=' . $counseling->getId(), 'color' => 'sun', 'type' => 'direct')); $this->actions = $actions; $this->actions2 = $actions2; $this->actions3 = array(); $this->counseling = $counseling; $this->subtitle = $academic_calendar->toString() . ' # ' . $counseling->getClassGroup()->toString(); $this->academic_calendar = $academic_calendar; $this->counseling_id = $counseling->getId(); $this->accal_id = $academic_calendar->getId(); $this->time = $time; $this->time2 = $time2; $this->tgl_cetak = $tgl_cetak; $this->temp_table = $temp_table; }
public function getTempTables($criteria = null, $con = null) { include_once 'lib/model/om/BaseTempTablePeer.php'; if ($criteria === null) { $criteria = new Criteria(); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collTempTables === null) { if ($this->isNew()) { $this->collTempTables = array(); } else { $criteria->add(TempTablePeer::COUNSELING_ID, $this->getId()); TempTablePeer::addSelectColumns($criteria); $this->collTempTables = TempTablePeer::doSelect($criteria, $con); } } else { if (!$this->isNew()) { $criteria->add(TempTablePeer::COUNSELING_ID, $this->getId()); TempTablePeer::addSelectColumns($criteria); if (!isset($this->lastTempTableCriteria) || !$this->lastTempTableCriteria->equals($criteria)) { $this->collTempTables = TempTablePeer::doSelect($criteria, $con); } } } $this->lastTempTableCriteria = $criteria; return $this->collTempTables; }
public function executePreview() { $counseling_id = $this->getRequestParameter('counseling_id'); $counseling = CounselingPeer::retrieveByPK($counseling_id); $this->forward404Unless($counseling); $accal_id = $this->getRequestParameter('accal_id'); $academic_calendar = AcademicCalendarPeer::retrieveByPK($accal_id); $this->forward404Unless($academic_calendar); $time = $this->getRequestParameter('time'); $time2 = $this->getRequestParameter('time2'); $tgl_cetak = $this->getRequestParameter('tgl_cetak'); $status = $this->getRequestParameter('status'); $note = $this->getRequestParameter('note'); $cr = new Criteria(); $cr->add(TempTablePeer::COUNSELING_ID, $counseling->getId()); $cr->add(TempTablePeer::TIME, $time); $temp_table = TempTablePeer::doSelect($cr); #Printout Cover $actions = array(array('name' => 'cover', 'url' => 'counseling_hist/listRaport?counseling_id=' . $counseling->getId() . '&accal_id=' . $academic_calendar->getId(), 'color' => 'blue', 'before' => "window.open('" . $this->getController()->genUrl('/counseling_hist/printCover') . "?counseling_id='+\$('counseling_id').value+'&time='+\$('tanggal').value+'&time2='+\$('time2').value+'&tgl_cetak='+\$('tgl_cetak').value+'&accal_id='+\$('accal_id').value,'link','height=480,width=640,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,location=no,directories=no,status=no')")); #Printout Induk Register array_push($actions, array('name' => 'induk', 'url' => 'counseling_hist/listRaport?counseling_id=' . $counseling->getId() . '&accal_id=' . $academic_calendar->getId(), 'color' => 'blue', 'before' => "window.open('" . $this->getController()->genUrl('/counseling_hist/printRegister') . "?counseling_id='+\$('counseling_id').value+'&time='+\$('tanggal').value+'&time2='+\$('time2').value+'&tgl_cetak='+\$('tgl_cetak').value+'&accal_id='+\$('accal_id').value,'link','height=480,width=640,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,location=no,directories=no,status=no')")); #Printout Raport Bayangan array_push($actions, array('name' => 'bayangan', 'url' => 'counseling_hist/listRaport?counseling_id=' . $counseling->getId() . '&accal_id=' . $academic_calendar->getId(), 'color' => 'blue', 'before' => "window.open('" . $this->getController()->genUrl('/counseling_hist/printMiddle') . "?counseling_id='+\$('counseling_id').value+'&time='+\$('tanggal').value+'&time2='+\$('time2').value+'&tgl_cetak='+\$('tgl_cetak').value+'&accal_id='+\$('accal_id').value,'link','height=480,width=640,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,location=no,directories=no,status=no')")); #Printout Raport Semester array_push($actions, array('name' => 'raport', 'url' => 'counseling_hist/listRaport?counseling_id=' . $counseling->getId() . '&accal_id=' . $academic_calendar->getId(), 'color' => 'blue', 'before' => "window.open('" . $this->getController()->genUrl('/counseling_hist/printFinal') . "?counseling_id='+\$('counseling_id').value+'&time='+\$('tanggal').value+'&time2='+\$('time2').value+'&tgl_cetak='+\$('tgl_cetak').value+'&accal_id='+\$('accal_id').value,'link','height=480,width=640,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,location=no,directories=no,status=no')")); $actions2 = array(array('name' => '<span>' . $academic_calendar->toString() . '</span>', 'url' => 'counseling_hist/listDetail?accal_id=' . $academic_calendar->getId() . '&counseling_id=' . $counseling->getId(), 'color' => 'sun')); array_push($actions2, array('name' => '<span>Rekap Nilai UTS</span>', 'url' => 'counseling_hist/listUts?accal_id=' . $academic_calendar->getId() . '&counseling_id=' . $counseling->getId(), 'color' => 'sun')); array_push($actions2, array('name' => '<span>Rekap Nilai UAS</span>', 'url' => 'counseling_hist/listUas?accal_id=' . $academic_calendar->getId() . '&counseling_id=' . $counseling->getId(), 'color' => 'sun')); array_push($actions2, array('name' => '<span>Ledger Kelas</span>', 'url' => 'counseling_hist/listLedger?accal_id=' . $academic_calendar->getId() . '&counseling_id=' . $counseling->getId(), 'color' => 'sun')); array_push($actions2, array('name' => '<span>Ranking Paralel</span>', 'url' => 'counseling_hist/listParalel?accal_id=' . $academic_calendar->getId() . '&counseling_id=' . $counseling->getId(), 'color' => 'sun')); array_push($actions2, array('name' => '<span>Printout Raport</span>', 'url' => 'counseling_hist/listRaport?accal_id=' . $academic_calendar->getId() . '&counseling_id=' . $counseling->getId(), 'color' => 'sun', 'type' => 'direct')); $this->actions = $actions; $this->actions2 = $actions2; $this->actions3 = array(); $this->counseling = $counseling; $this->subtitle = $academic_calendar->toString() . ' # ' . $counseling->getClassGroup()->toString(); $this->academic_calendar = $academic_calendar; $this->counseling_id = $counseling->getId(); $this->accal_id = $academic_calendar->getId(); $this->time = $time; $this->time2 = $time2; $this->tgl_cetak = $tgl_cetak; $this->status = $status; $this->note = $note; $this->temp_table = $temp_table; }
public function executePreview() { $now = date('d-m-Y'); $cr = new Criteria(); #$cr->add(TempTablePeer::TIME, $now); $cr->add(TempTablePeer::EMPLOYEE_ID, 1112); $temp_table = TempTablePeer::doSelect($cr); #Printout No Punggung $actions = array(array('name' => 'sign', 'url' => 'collection_print/preview', 'color' => 'blue', 'before' => "window.open('" . $this->getController()->genUrl('/collection_print/printSign') . "?time='+\$('time').value,'link','height=480,width=640,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,location=no,directories=no,status=no')")); #Printout Lidah Buku array_push($actions, array('name' => 'tongue', 'url' => 'collection_print/preview', 'color' => 'blue', 'before' => "window.open('" . $this->getController()->genUrl('/collection_print/printTongue') . "?time='+\$('time').value,'link','height=480,width=640,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,location=no,directories=no,status=no')")); #Printout Katalog Buku array_push($actions, array('name' => 'catalog', 'url' => 'collection_print/preview', 'color' => 'blue', 'before' => "window.open('" . $this->getController()->genUrl('/collection_print/printCatalog') . "?time='+\$('time').value,'link','height=480,width=640,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,location=no,directories=no,status=no')")); #Printout Label Buku array_push($actions, array('name' => 'label', 'url' => 'collection_print/preview', 'color' => 'blue', 'before' => "window.open('" . $this->getController()->genUrl('/collection_print/printLabel') . "?time='+\$('time').value,'link','height=480,width=640,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,location=no,directories=no,status=no')")); $this->actions = $actions; $this->subtitle = ' '; $this->now = $now; $this->temp_table = $temp_table; $actions3 = array(array('name' => 'Kembali', 'url' => 'collection_print/list', 'color' => 'black')); $this->actions3 = $actions3; }
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(TempTablePeer::ID, $pks, Criteria::IN); $objs = TempTablePeer::doSelect($criteria, $con); } return $objs; }
public function executePreviewAbsence() { $academic_calendar_id = $this->getRequestParameter('academic_calendar_id'); $academic_calendar = AcademicCalendarPeer::retrieveByPK($academic_calendar_id); $this->forward404Unless($academic_calendar); $department_id = $this->getRequestParameter('department_id'); $department = DepartmentPeer::retrieveByPK($department_id); $this->forward404Unless($department); $month_id1 = $this->getRequestParameter('month_id1'); $month1 = MonthPeer::retrieveByPK($month_id1); $this->forward404Unless($month1); $month_id2 = $this->getRequestParameter('month_id2'); $month2 = MonthPeer::retrieveByPK($month_id2); $this->forward404Unless($month2); $thn1 = $this->getRequestParameter('thn1'); $thn2 = $this->getRequestParameter('thn2'); $tgl_absen1 = $this->getRequestParameter('tgl_absen1'); $tgl_absen2 = $this->getRequestParameter('tgl_absen2'); $time = $this->getRequestParameter('time'); $time2 = $this->getRequestParameter('time2'); $tgl_cetak = $this->getRequestParameter('tgl_cetak'); $cr = new Criteria(); $cr->add(TempTablePeer::COUNSELING_ID, $academic_calendar->getId()); $cr->add(TempTablePeer::STUDENT_ID, $department->getId()); $cr->add(TempTablePeer::TIME, $time); $temp_table = TempTablePeer::doSelect($cr); $actions = array(array('name' => 'Kembali', 'url' => 'employee_report/listAbsenceEmployee?academic_calendar_id=' . $academic_calendar->getId() . '&department_id=' . $department->getId(), 'color' => 'black')); array_push($actions, array('name' => 'Print PDF', 'url' => "employee_report/printAbsence?academic_calendar_id=" . $academic_calendar->getId() . "&department_id=" . $department->getId() . "&month_id1=" . $month_id1 . "&month_id2=" . $month_id2 . "&thn1=" . $thn1 . "&thn2=" . $thn2 . "&tgl_absen1=" . $tgl_absen1 . "&tgl_absen2=" . $tgl_absen2 . "&time=" . $time . "&time2=" . $time2 . "&tgl_cetak=" . $tgl_cetak, 'color' => 'black', 'type' => 'direct')); #array_push($actions, array('name' => 'Print Excel', 'url' => "employee_report/printAbsenceXLS?academic_calendar_id=".$academic_calendar->getId()."&department_id=".$department->getId()."&month_id=".$month_id."&tgl_absen1=".$tgl_absen1."&tgl_absen2=".$tgl_absen2."&time=".$time."&time2=".$time2."&tgl_cetak=".$tgl_cetak, 'color' => 'black', 'type' => 'direct')); $this->actions = $actions; $actions2 = array(array('name' => '<span>Rekap Kepegawaian</span>', 'url' => 'employee_report/list', 'color' => 'sky')); array_push($actions2, array('name' => '<span>Mutasi Jabatan</span>', 'url' => 'employee_report/listJob?academic_calendar_id=' . $academic_calendar->getId() . '&department_id=' . $department->getId(), 'color' => 'sky')); array_push($actions2, array('name' => '<span>Absensi Pegawai</span>', 'url' => 'employee_report/listAbsence?academic_calendar_id=' . $academic_calendar->getId() . '&department_id=' . $department->getId(), 'color' => 'sky')); array_push($actions2, array('name' => '<span>Absen Per Pegawai</span>', 'url' => 'employee_report/listAbsenceEmployee?academic_calendar_id=' . $academic_calendar->getId() . '&department_id=' . $department->getId(), 'color' => 'sun', 'type' => 'direct')); array_push($actions2, array('name' => '<span>Cuti Pegawai</span>', 'url' => 'employee_report/listLeave?academic_calendar_id=' . $academic_calendar->getId() . '&department_id=' . $department->getId(), 'color' => 'sky')); array_push($actions2, array('name' => '<span>Izin Pegawai</span>', 'url' => 'employee_report/listPermit?academic_calendar_id=' . $academic_calendar->getId() . '&department_id=' . $department->getId(), 'color' => 'sky')); array_push($actions2, array('name' => '<span>Pengobatan</span>', 'url' => 'employee_report/listMedical?academic_calendar_id=' . $academic_calendar->getId() . '&department_id=' . $department->getId(), 'color' => 'sky')); array_push($actions2, array('name' => '<span>Gaji Pegawai</span>', 'url' => 'employee_report/listSalary?academic_calendar_id=' . $academic_calendar->getId() . '&department_id=' . $department->getId(), 'color' => 'sky')); $this->actions2 = $actions2; $this->actions3 = array(); $this->academic_calendar = $academic_calendar; $this->department = $department; $this->subtitle = $academic_calendar->getName() . ' # ' . $department->getName(); $this->time = $time; $this->time2 = $time2; $this->tgl_cetak = $tgl_cetak; $this->tgl_absen1 = $tgl_absen1; $this->tgl_absen2 = $tgl_absen2; $this->temp_table = $temp_table; $this->month1 = $month1; $this->month2 = $month2; $this->thn1 = $thn1; $this->thn2 = $thn2; }