Exemplo n.º 1
0
 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');
 }