public function catatan($id) { if (!Auth::isAllow(2, Session::get('role'))) { header('location:' . URL . 'home'); } if (isset($_POST['submit'])) { if ($this->rekamCatatan()) { $this->view->success = "Rekam catatan berhasil"; } else { $this->view->error = "Rekam catatan gagal"; } } $disposisi = new Disposisi(); $this->view->datad = $disposisi->getDisposisi(array('id_surat' => $id)); //$this->view->bagian = $this->view->datad->dist[0]; $sql = "SELECT kd_bagian FROM r_bagian WHERE id_bagian=" . Session::get('bagian'); $bagian = $this->model->select($sql); foreach ($bagian as $val) { $this->view->bagian = $val['kd_bagian']; } //dibawah ini bisa pake getSuratById $datas = $this->model->select("SELECT * FROM suratmasuk WHERE id_suratmasuk=" . $this->view->datad->id_surat); foreach ($datas as $value) { $this->view->data[0] = $value['id_suratmasuk']; $this->view->data[1] = $value['no_agenda']; $this->view->data[2] = $value['no_surat']; // var_dump($value['asal_surat']); $asal = $this->model->select('SELECT nama_satker FROM alamat WHERE kode_satker="' . trim($value['asal_surat']) . '"'); // var_dump('SELECT nama_satker FROM alamat WHERE kode_satker='.trim($value['asal_surat'])); foreach ($asal as $alamat) { $this->view->data[3] = $alamat['nama_satker']; } $this->view->data[4] = $value['perihal']; } $sql = "SELECT id_user, namaPegawai FROM user WHERE jabatan = 6 AND bagian = " . Session::get('bagian'); $this->view->peg = $this->model->select($sql); //var_dump($this->view->peg); $this->view->render('suratmasuk/catatan'); }