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;
}
