function notif($user) { //$sm = new Suratmasuk_Model(); //$sk = new Suratkeluar_Model(); $notif = new Notifikasi(); $id_user = 0; $sql = "SELECT id_user FROM user WHERE username=:user"; $param = array(':user' => $user); $data = $this->model->select($sql, $param); //var_dump($data); foreach ($data as $val) { $id_user = $val['id_user']; } //echo $id_user; $sql = "SELECT id_notif, id_surat, jenis_surat FROM notifikasi WHERE id_user=:id_user AND stat_notif=1"; $param = array(':id_user' => $id_user); $data = $this->model->select($sql, $param); $this->view->jmlnotif = count($data); //var_dump($data); $notifsm = array(); $notifsk = array(); $id_notif = array(); foreach ($data as $val) { if ($val['jenis_surat'] == 'SM') { $sql = "SELECT a.id_suratmasuk as id_suratmasuk, a.no_agenda as no_agenda,\r\n a.tgl_terima as tgl_terima, a.no_surat as no_surat, a.tgl_surat as tgl_surat,\r\n a.perihal as perihal, b.nama_satker as asal_surat \r\n FROM suratmasuk a LEFT JOIN alamat b ON a.asal_surat=b.kode_satker WHERE a.id_suratmasuk=:id_surat"; // $sql = "SELECT * FROM suratmasuk WHERE id_suratmasuk=:id_surat"; //ambil dari suratmasuk model $param = array(':id_surat' => $val['id_surat']); $notifsm[] = $this->model->select($sql, $param); //$notifsm = $sm->getSuratMasukById($val['id_surat']); $id_notif[] = $val['id_notif']; $notif->set('id_notif', $val['id_notif']); $notif->set('stat_notif', 0); $notif->setNotif(); } elseif ($val['jenis_surat'] == 'SK') { $sql = "SELECT a.id_suratkeluar as id_suratkeluar, a.tgl_surat as tgl_surat,\r\n b.tipe_naskah as tipe, a.no_surat as no_surat, c.nama_satker as tujuan,\r\n a.perihal as perihal FROM suratkeluar a LEFT JOIN tipe_naskah b ON a.tipe=b.id_tipe \r\n LEFT JOIN alamat c ON a.tujuan=c.kode_satker WHERE a.id_suratkeluar=:id_surat"; // $sql = "SELECT * FROM suratkeluar WHERE id_suratkeluar=:id_surat"; //ambil dari suratmasuk model $param = array(':id_surat' => $val['id_surat']); $notifsk[] = $this->model->select($sql, $param); //$notifsk = $sk->getSuratKeluarById($val['id_surat'],'detil'); $id_notif[] = $val['id_notif']; $notif->set('id_notif', $val['id_notif']); $notif->set('stat_notif', 0); $notif->setNotif(); } } //var_dump($id_notif); $this->view->notifsm = $notifsm; $this->view->notifsk = $notifsk; //var_dump($notifsm); $this->view->render('notifikasi/notifikasi'); }
function notif($user) { //$sm = new Suratmasuk_Model(); //$sk = new Suratkeluar_Model(); $notif = new Notifikasi(); $id_user = 0; $sql = "SELECT id_user FROM user WHERE username=:user"; $param = array(':user' => $user); $data = $this->model->select($sql, $param); //var_dump($data); foreach ($data as $val) { $id_user = $val['id_user']; } //echo $id_user; $sql = "SELECT id_notif, id_surat, jenis_surat FROM notifikasi WHERE id_user=:id_user AND stat_notif=1"; $param = array(':id_user' => $id_user); $data = $this->model->select($sql, $param); $this->view->jmlnotif = count($data); //var_dump($data); $notifsm = array(); $notifsk = array(); $id_notif = array(); foreach ($data as $val) { if ($val['jenis_surat'] == 'SM') { $sql = "SELECT * FROM suratmasuk WHERE id_suratmasuk=:id_surat"; //ambil dari suratmasuk model $param = array(':id_surat' => $val['id_surat']); $notifsm[] = $this->model->select($sql, $param); //$notifsm = $sm->getSuratMasukById($val['id_surat']); $id_notif[] = $val['id_notif']; $notif->set('id_notif', $val['id_notif']); $notif->set('stat_notif', 0); $notif->setNotif(); } elseif ($val['jenis_surat'] == 'SK') { $sql = "SELECT * FROM suratkeluar WHERE id_suratkeluar=:id_surat"; //ambil dari suratmasuk model $param = array(':id_surat' => $val['id_surat']); $notifsk[] = $this->model->select($sql, $param); //$notifsk = $sk->getSuratKeluarById($val['id_surat'],'detil'); $id_notif[] = $val['id_notif']; $notif->set('id_notif', $val['id_notif']); $notif->set('stat_notif', 0); $notif->setNotif(); } } //var_dump($id_notif); $this->view->notifsm = $notifsm; $this->view->notifsk = $notifsk; //var_dump($notifsm); $this->view->render('notifikasi/notifikasi'); }
public function detil($id) { $agenda = substr($id, 0, 1); $disposisi = new Disposisi(); if ($agenda != 'S') { $data = $this->model->getSuratById($id); $this->view->data[0] = $this->model->getId(); $this->view->data[1] = $this->model->getAgenda(); $this->view->data[2] = $this->model->getTglTerima(); $this->view->data[3] = $this->model->getTglSurat(); $this->view->data[4] = $this->model->getNomor(); $this->view->data[5] = $this->model->getAlamat(); $this->view->data[6] = $this->model->getPerihal(); $this->view->data[7] = $this->model->getFile(); $this->view->dataSurat = array(); $this->view->dataSurat[] = $this->view->data; } else { $param = array('no_agenda' => $id); $data = $this->model->getSuratById($param); $this->view->data[0] = $this->model->getId(); $this->view->data[1] = $this->model->getAgenda(); $this->view->data[2] = $this->model->getTglTerima(); $this->view->data[3] = $this->model->getTglSurat(); $this->view->data[4] = $this->model->getNomor(); $this->view->data[5] = $this->model->getAlamat(); $this->view->data[6] = $this->model->getPerihal(); $this->view->data[7] = $this->model->getFile(); $this->view->dataSurat = array(); $this->view->dataSurat[] = $this->view->data; } $this->view->ddisp = $disposisi->getDisposisi(array('id_surat' => $this->view->data[0])); $id_disp = $disposisi->id_disposisi; $bagian = Session::get('bagian'); $this->view->ddispkasi = $disposisi->getDisposisiKasi($id_disp, $bagian); $lamp = new Lampiran_Model(); $this->view->lampiran = $lamp->getLampiranSurat($this->view->data[0], 'SM'); $this->view->count = count($this->view->lampiran); /* * hapus notifikasi */ $notif = new Notifikasi(); $id_user = 0; $user = Session::get('user'); $sql = "SELECT id_user FROM user WHERE username=:user"; $param = array(':user' => $user); $data = $this->model->select($sql, $param); //var_dump($data); foreach ($data as $val) { $id_user = $val['id_user']; } $sql = "SELECT id_notif FROM notifikasi WHERE id_user=:id_user AND id_surat=:id_surat AND jenis_surat=:jenis"; $param = array(':id_user' => $id_user, ':id_surat' => $id, ':jenis' => 'SM'); $data = $this->model->select($sql, $param); foreach ($data as $val) { $notif->set('id_notif', $val['id_notif']); $notif->set('stat_notif', 0); $notif->setNotif(); } //render tampilan $this->view->render('suratmasuk/detilsurat'); }
public function detil($id) { $data = $this->model->getSuratById($id, 'detil'); // foreach ($data as $value) { $this->view->id = $data->getId(); $this->view->rujukan = $this->model->getRujukan(); $this->view->tipe = $this->model->getTipeSurat(); $this->view->no_surat = $this->model->getNomor(); $this->view->tgl_surat = $this->model->getTglSurat(); $this->view->tujuan = $this->model->getAlamat(); $this->view->perihal = $this->model->getPerihal(); $this->view->sifat = $this->model->getSifat(); $this->view->jenis = $this->model->getJenis(); $this->view->lampiran = $this->model->getJmlLampiran(); $this->view->file = $this->model->getFile(); $this->view->status = $this->model->getStatus(); // } $lamp = new Lampiran_Model(); $this->view->datal = $lamp->getLampiranSurat($this->view->id, 'SK'); $this->view->count = count($this->view->datal); /* * hapus notifikasi */ $notif = new Notifikasi(); $id_user = 0; $user = Session::get('user'); $sql = "SELECT id_user FROM user WHERE username=:user"; $param = array(':user' => $user); $data = $this->model->select($sql, $param); //var_dump($data); foreach ($data as $val) { $id_user = $val['id_user']; } $sql = "SELECT id_notif FROM notifikasi WHERE id_user=:id_user AND id_surat=:id_surat AND jenis_surat=:jenis"; $param = array(':id_user' => $id_user, ':id_surat' => $id, ':jenis' => 'SK'); $data = $this->model->select($sql, $param); foreach ($data as $val) { $notif->set('id_notif', $val['id_notif']); $notif->set('stat_notif', 0); $notif->setNotif(); } $this->view->render('suratkeluar/detilsurat'); }