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