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