public function get_cuti_by_id(Cuti $ct, $kd_user)
{
$sql = "SELECT * FROM " . $this->t_cuti;
$sql .= " a LEFT JOIN d_pb b ON a.KD_PB=b.KD_PB";
$sql .= " 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 ";
$sql .= " WHERE a.KD_CUTI=" . $ct->get_kode_cuti();
$sql .= " AND e.KD_USER=" . $kd_user;
$result = $this->_db->select($sql);
foreach ($result as $v) {
$this->set_kode_cuti($v['KD_CUTI']);
$this->set_jenis_cuti($v['KD_JNS_SRT_CUTI']);
$this->set_no_surat_cuti($v['NO_CUTI']);
$this->set_tgl_surat_cuti($v['TGL_CUTI']);
$this->set_pb($v['KD_PB']);
$this->set_prd_mulai($v['PRD_MUL_CUTI']);
$this->set_prd_selesai($v['PRD_SEL_CUTI']);
$this->set_perk_stop($v['PERK_STOP']);
$this->set_perk_go($v['PERK_GO']);
$this->set_file($v['FILE_CUTI']);
}
return $this;
}
