public function addCuti($id = null) { $sc = new JenisSuratCuti($this->registry); if (isset($_POST['add_sc'])) { $nama = $_POST['nama']; $keterangan = $_POST['keterangan']; $sc->set_nama($nama); $sc->set_keterangan($keterangan); if (!$sc->add_jsc()) { $this->view->d_rekam = $sc; $this->view->error = $sc->get_error(); } } if (!is_null($id)) { $sc->set_kode($id); $this->view->d_ubah = $sc->get_jsc_by_id($sc); } $this->view->data = $sc->get_jsc(); // var_dump($this->view->d_ubah); $this->view->render('admin/cuti'); }
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; }