public function delCuti($id)
{
$sc = new JenisSuratCuti($this->registry);
if (is_null($id)) {
throw new Exception();
echo "id belum dimasukkan!";
return;
}
$sc->set_kode($id);
$sc->delete_jsc();
header('location:' . URL . 'admin/addCuti');
}
public function get_cuti_by_pb_name($name, $kd_user = null)
{
$sql = "SELECT a.KD_CUTI as KD_CUTI,\r\n a.KD_JNS_SRT_CUTI as KD_JNS_SRT_CUTI,\r\n a.KD_PB as KD_PB,\r\n a.NO_CUTI as NO_CUTI,\r\n a.TGL_CUTI AS TGL_CUTI,\r\n a.PRD_MUL_CUTI as PRD_MUL_CUTI,\r\n a.PRD_SEL_CUTI as PRD_SEL_CUTI,\r\n a.PERK_STOP as PERK_STOP,\r\n a.PERK_GO as PERK_GO,\r\n a.FILE_CUTI as FILE_CUTI\r\n FROM " . $this->t_cuti . " a \r\n LEFT JOIN d_pb b ON a.KD_PB=b.KD_PB\r\n LEFT JOIN r_jur c ON b.KD_JUR=c.KD_JUR\r\n LEFT JOIN r_fakul d ON c.KD_FAKUL=d.KD_FAKUL\r\n LEFT JOIN r_univ e ON d.KD_UNIV=e.KD_UNIV\r\n WHERE b.NM_PB LIKE '%" . $name . "%'";
if (!is_null($kd_user)) {
$sql .= " AND e.KD_USER="******"-" . $d_pb->get_nip() . "-" . $d_jur->get_nama());
$cuti->set_no_surat_cuti($v['NO_CUTI']);
$cuti->set_tgl_surat_cuti($v['TGL_CUTI']);
$cuti->set_prd_mulai($v['PRD_MUL_CUTI']);
$cuti->set_prd_selesai($v['PRD_SEL_CUTI']);
$cuti->set_perk_stop($v['PERK_STOP']);
$cuti->set_perk_go($v['PERK_GO']);
unset($pb);
unset($jur);
$data[] = $cuti;
}
return $data;
}
