public function showAll($limit = null, $batas = null) { @Session::createSession(); $role = Session::get('role'); $bagian = Session::get('bagian'); $user = Session::get('user'); if (Auth::isRole($role, 2) and !Auth::isBagian($bagian, 1)) { $sql = "SELECT a.id_suratkeluar as id_suratkeluar,\r\n a.rujukan as rujukan,\r\n a.no_surat as no_surat,\r\n a.tgl_surat as tgl_surat,\r\n b.nama_satker as tujuan,\r\n a.perihal as perihal,\r\n c.sifat_surat as sifat,\r\n d.klasifikasi as jenis,\r\n a.lampiran as lampiran,\r\n a.file as file,\r\n e.status as status,\r\n h.namaPegawai as user,\r\n f.tipe_naskah as tipe,\r\n a.start as start\r\n FROM suratkeluar a LEFT JOIN alamat b ON a.tujuan = b.kode_satker\r\n LEFT JOIN sifat_surat c ON a.sifat = c.kode_sifat\r\n LEFT JOIN klasifikasi_surat d ON a.jenis = d.kode_klassurat\r\n LEFT JOIN status e ON a.status = e.id_status\r\n LEFT JOIN tipe_naskah f ON a.tipe = f.id_tipe \r\n LEFT JOIN notifikasi g ON a.id_suratkeluar = g.id_surat\r\n LEFT JOIN user h ON a.user = h.username\r\n WHERE g.jenis_surat='SK' AND g.id_user="******"\r\n GROUP BY a.id_suratkeluar ORDER BY a.id_suratkeluar DESC"; } elseif (Auth::isRole($role, 3)) { $sql = "SELECT a.id_suratkeluar as id_suratkeluar,\r\n a.rujukan as rujukan,\r\n a.no_surat as no_surat,\r\n a.tgl_surat as tgl_surat,\r\n b.nama_satker as tujuan,\r\n a.perihal as perihal,\r\n c.sifat_surat as sifat,\r\n d.klasifikasi as jenis,\r\n a.lampiran as lampiran,\r\n a.file as file,\r\n e.status as status,\r\n h.namaPegawai as user,\r\n f.tipe_naskah as tipe,\r\n a.start as start\r\n FROM suratkeluar a LEFT JOIN alamat b ON a.tujuan = b.kode_satker\r\n LEFT JOIN sifat_surat c ON a.sifat = c.kode_sifat\r\n LEFT JOIN klasifikasi_surat d ON a.jenis = d.kode_klassurat\r\n LEFT JOIN status e ON a.status = e.id_status\r\n LEFT JOIN tipe_naskah f ON a.tipe = f.id_tipe\r\n LEFT JOIN user h ON a.user = h.username\r\n WHERE a.user='******'\r\n GROUP BY a.id_suratkeluar ORDER BY a.id_suratkeluar DESC"; } else { $sql = "SELECT a.id_suratkeluar as id_suratkeluar,\r\n a.rujukan as rujukan,\r\n a.no_surat as no_surat,\r\n a.tgl_surat as tgl_surat,\r\n b.nama_satker as tujuan,\r\n a.perihal as perihal,\r\n c.sifat_surat as sifat,\r\n d.klasifikasi as jenis,\r\n a.lampiran as lampiran,\r\n a.file as file,\r\n e.status as status,\r\n h.namaPegawai as user,\r\n f.tipe_naskah as tipe,\r\n a.start as start\r\n FROM suratkeluar a JOIN alamat b ON a.tujuan = b.kode_satker\r\n JOIN sifat_surat c ON a.sifat = c.kode_sifat\r\n JOIN klasifikasi_surat d ON a.jenis = d.kode_klassurat\r\n JOIN status e ON a.status = e.id_status\r\n LEFT JOIN user h ON a.user = h.username\r\n JOIN tipe_naskah f ON a.tipe = f.id_tipe ORDER BY a.id_suratkeluar DESC"; } // var_dump($sql); if (!is_null($limit) and !is_null($batas)) { $sql .= " LIMIT {$limit},{$batas}"; } $data = $this->select($sql); $surat = array(); foreach ($data as $value) { $obj = new $this(); $obj->setId($value['id_suratkeluar']); $obj->setRujukan($value['rujukan']); $obj->setNomor($value['no_surat']); $obj->setTglSurat($value['tgl_surat']); $obj->setAlamat($value['tujuan']); $obj->setPerihal($value['perihal']); $obj->setSifat($value['sifat']); $obj->setJenis($value['jenis']); $obj->setJmlLampiran($value['lampiran']); $obj->setFile($value['file']); $obj->setStatus($value['status']); $obj->setTipeSurat($value['tipe']); $obj->setStart($value['start']); $obj->setUserCreate($value['user']); $surat[] = $obj; } return $surat; }
public function showAll($limit = null, $batas = null) { @Session::createSession(); $role = Session::get('role'); $bagian = Session::get('bagian'); $user = Session::get('user'); if (Auth::isRole($role, 2) and !Auth::isBagian($bagian, 1) or Auth::isRole($role, 3)) { $sql = "SELECT a.id_suratmasuk as id_suratmasuk,\r\n a.no_agenda as no_agenda,\r\n a.no_surat as no_surat,\r\n a.tgl_terima as tgl_terima,\r\n a.tgl_surat as tgl_surat,\r\n b.nama_satker as asal_surat,\r\n a.perihal as perihal,\r\n a.status as status,\r\n a.sifat as sifat,\r\n a.jenis as jenis,\r\n a.lampiran as lampiran,\r\n a.start as start,\r\n a.end as end\r\n FROM suratmasuk a LEFT JOIN alamat b \r\n ON a.asal_surat = b.kode_satker\r\n LEFT JOIN notifikasi c ON a.id_suratmasuk = c.id_surat\r\n WHERE c.jenis_surat='SM' AND id_user="******"\r\n ORDER BY a.id_suratmasuk DESC"; } else { $sql = "SELECT a.id_suratmasuk as id_suratmasuk,\r\n a.no_agenda as no_agenda,\r\n a.no_surat as no_surat,\r\n a.tgl_terima as tgl_terima,\r\n a.tgl_surat as tgl_surat,\r\n b.nama_satker as asal_surat,\r\n a.perihal as perihal,\r\n a.status as status,\r\n a.sifat as sifat,\r\n a.jenis as jenis,\r\n a.lampiran as lampiran,\r\n a.start as start,\r\n a.end as end\r\n FROM suratmasuk a LEFT JOIN alamat b \r\n ON a.asal_surat = b.kode_satker\r\n ORDER BY a.id_suratmasuk DESC"; } //$sql = "SELECT * FROM suratmasuk"; if (!is_null($limit) and !is_null($batas)) { $sql .= " LIMIT {$limit},{$batas}"; } // print_r($sql); $data = $this->select($sql); //ntar dihapus $surat = array(); foreach ($data as $value) { $obj = new $this(); $obj->setAlamat($value['asal_surat']); $obj->setId($value['id_suratmasuk']); $obj->setJenis($value['jenis']); $obj->setJmlLampiran($value['lampiran']); $obj->setNomor($value['no_surat']); $obj->setPerihal($value['perihal']); $obj->setSifat($value['sifat']); $obj->setTglSurat($value['tgl_surat']); $obj->setTglTerima($value['tgl_terima']); $obj->setAgenda($value['no_agenda']); $obj->setStart($value['start']); $surat[] = $obj; } // var_dump($surat); return $surat; }
public function displayKinerja() { $duser = new User(); $data = $duser->getUser(); $kinerja = array(); foreach ($data as $val) { if (Auth::isRole($val->get('role'), 3)) { $kp = $this->calculateKinerja($val); if (!is_null($kp)) { $kinerja[] = $kp; } } } return $kinerja; }
echo '<font color=red>batas waktu : ' . Tanggal::tgl_indo($tgl[0]) . ' ' . $tgl[1] . '</font>'; } echo '</td>'; echo '<td width=50%>' . $value->getTipeSurat() . ' <font color=green><i>[' . $value->getUserCreate() . ']</i></font> </br><a href="' . URL . 'suratkeluar/detil/' . $value->getId() . '" title="klik disini untuk melihat detil surat!" class=tip>' . $value->getAlamat() . '</br><i>' . $value->getPerihal() . '</i></a></td>'; } //echo '<td>' . $value['tgl_terima'] . '</td>'; //echo '<td>' . $value['tgl_surat'] . '</td>'; //echo '<td>' . $value['asal_surat'] . '</td>'; //echo '<td>' . $value['perihal'] . '</td>'; echo '<td width=30%>'; if (Auth::isRole($role, 2)) { echo '<a href="' . URL . 'suratkeluar/edit/' . $value->getId() . '" title="ubah data surat" class=tip><input class="btn btn-green" type=button value=Ubah></a> <a href="' . URL . 'suratkeluar/remove/' . $value->getId() . '" title="hapus data surat" class=tip><input class="btn btn-danger" type=button value=Hapus onclick="return selesai()"></a> '; } if (!Auth::isRole($role, 5) and !Auth::isRole($role, 4)) { echo '<a href="' . URL . 'suratkeluar/rekamrev/' . $value->getId() . '" title="rekam revisi surat" class=tip><input class="btn write" type=button value="Revisi"></a> '; } echo '<a href="' . URL . 'suratkeluar/download/' . $value->getId() . '" title="download file surat" class=tip><input class="btn download" type=button value="Download"></a></td>'; echo '</tr>'; } ?> </table></div> <?php } else { ?> </div> <br><br><br><br><br><br><br><br> <h1 align="center">Data tidak ditemukan</h1> <?php }
//echo '<td>' . $value['tgl_terima'] . '</td>'; //echo '<td>' . $value['tgl_surat'] . '</td>'; //echo '<td>' . $value['asal_surat'] . '</td>'; //echo '<td>' . $value['perihal'] . '</td>'; echo '<td halign=center width=30%>'; if (Auth::isRole($role, 2) and Auth::isBagian($bagian, 1)) { echo '<a href="' . URL . 'suratmasuk/edit/' . $value->getId() . '" title="ubah data surat" class=tip><input class="btn btn-green" type=button value=ubah></a> <a href="' . URL . 'suratmasuk/hapus/' . $value->getId() . '" title="hapus data surat" class=tip><input class="btn btn-danger" type=button value="hapus" onclick="return selesai(\'' . $value->getAgenda() . '\');"></a>'; } if (Auth::isRole($role, 1) or Auth::isRole($role, 4)) { echo '<a href="' . URL . 'suratmasuk/disposisi/' . $value->getId() . '" title="rekam disposisi" class=tip><input class="btn write" type=button value=disposisi></a>'; } if (Auth::isRole($role, 5)) { echo '<a title="cetak disposisi" class=tip><input class="btn print" type=button value="disposisi" onclick="cetakdisposisi(' . $value->getId() . ');"></a> '; } if (Auth::isRole($role, 5) or Auth::isRole($role, 3)) { echo '<a href="' . URL . 'suratmasuk/upload/' . $value->getId() . '" title="upload file surat" class=tip><input class="btn upload" type=button value="upload"></a> <!--<a href="' . URL . 'suratmasuk/updatestatus/' . $value->getId() . '"><input class=btn type=button value=Status></a> <a href="' . URL . 'suratmasuk/distribusi/' . $value->getId() . '"><input class=btn type=button value=Distribusi></a>--></td>'; } echo '</tr>'; $no++; } ?> </form> </table></div> <?php } else { ?> </div> <br><br><br><br><br><br><br><br>
?> suratmasuk/edit/<?php echo $this->data[0]; ?> " title="ubah data surat" class="tip"><input class="btn edit" type="button" value="U B A H"></a> <a href="<?php echo URL; ?> suratmasuk/catatan/<?php echo $this->data[0]; ?> " title="rekam disposisi pejabat es IV kepada pelaksana" class="tip"><input class="btn write" type="button" value="DISPOSISI KASI"></a><?php } ?> <?php if (Auth::isRole($role, 1) or Auth::isRole($role, 4)) { echo '<a href="' . URL . 'suratmasuk/disposisi/' . $this->data[0] . '" title="rekam disposisi" class=tip><input class="btn write" type=button value=disposisi></a>'; } ?> </td></tr> </table></div> <?php if ($this->count > 0) { ?> </br> <hr> <h3>Lampiran :</h3> <hr> </br>
<font id="sm" color="white" style="font-size: 50px;font-weight: bold;">0</font> </div> <?php } ?> </div> <div class="shortcut sk" onclick="menus('suratkeluar')"> <img src="<?php echo URL; ?> public/images/sk.png"></img> <p><font color="white" style="font-family: 'segoe ui','tahoma';font-size: 15px; margin-left: 5px;"> <b>Surat Keluar</b> </font></p> <?php if (!Auth::isRole(Session::get('role'), 5) and !Auth::isRole(Session::get('role'), 4)) { ?> <div id="notifsk" style="float: right; margin-right: 10px;margin-top: 100px;color: white;"> <font id="sk" color="white" style="font-size: 50px;font-weight: bold;">0</font></div> <?php } ?> </div> </div> <div class="shortcut arsip" onclick="menus('arsip')"> <img src="<?php echo URL; ?> public/images/arsip_home.png"></img> <p><font color="white" style="font-family: 'segoe ui','tahoma';font-size: 15px; margin-left: 5px;"> <b>Arsip</b>
?> arsip/rekam/<?php echo $this->id; ?> /SK" title="rekam ke dalam lokasi arsip" class="tip"><input class="btn arsip" type="button" value="ARSIP"></a> <a href="<?php echo URL; ?> suratkeluar/edit/<?php echo $this->id; ?> " title="ubah data surat keluar" class="tip"><input class="btn edit" type="button" value="U B A H"></a><?php } ?> <?php if (Auth::isRole($role, 2) or Auth::isRole($role, 1)) { ?> <a href="<?php echo URL; ?> suratkeluar/rekamrev/<?php echo $this->id; ?> " title="rekam dan upload revisi konsep surat" class="tip"><input class="btn write" type="button" value="REVISI"></a><?php } ?> </td></tr> </table></div> <?php if ($this->count > 0) {
<?php if (Auth::isRole($role, 5)) { ?> <li onclick="menu('kantor')"><a >Kantor</a></li> <!--href="<?php echo URL; ?> admin/rekamKantor"--><?php } ?> <li onclick="menu('alamat')"><a >Alamat Surat</a></li> <!--href="<?php echo URL; ?> admin/rekamAlamat"--> <?php if (Auth::isRole($role, 5)) { ?> <li onclick="menu('lokasi')"><a >Lokasi Arsip</a></li> <!--href="<?php echo URL; ?> admin/rekamLokasi"--> <li onclick="menu('klasarsip')"><a >Klasifikasi Arsip</a></li> <!--href="<?php echo URL; ?> admin/rekamKlasifikasiArsip"--> <li onclick="menu('tipenaskah')"><a >Lampiran</a></li> <!--href="<?php echo URL; ?> admin/rekamJenisLampiran"--> <li onclick="menu('nomor')"><a >Penomoran</a></li> <!--href="<?php echo URL;