| Server IP : 91.108.119.234 / Your IP : 216.73.216.46 Web Server : LiteSpeed System : Linux id-dci-web1986.main-hosting.eu 5.14.0-611.26.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Jan 29 05:24:47 EST 2026 x86_64 User : u686484674 ( 686484674) PHP Version : 8.0.30 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/u686484674/domains/idikotabandung.com/public_html/surat/ |
Upload File : |
<?php
//cek session
if(empty($_SESSION['admin'])){
$_SESSION['err'] = '<center>Anda harus login terlebih dahulu!</center>';
header("Location: ./");
die();
} else {
if($_SESSION['admin'] != 1 AND $_SESSION['admin'] != 3){
echo '<script language="javascript">
window.alert("ERROR! Anda tidak memiliki hak akses untuk membuka halaman ini");
window.location.href="./logout.php";
</script>';
} else {
if(isset($_REQUEST['act'])){
$act = $_REQUEST['act'];
switch ($act) {
case 'add':
include "tambah_surat_undangan.php";
break;
case 'edit':
include "edit_surat_undangan.php";
break;
case 'print':
include "cetak_undangan.php";
break;
case 'del':
include "hapus_surat_undangan.php";
break;
}
} else {
$query = mysqli_query($config, "SELECT surat_keluar FROM tbl_sett");
list($surat_keluar) = mysqli_fetch_array($query);
//pagging
$limit = $surat_keluar;
$pg = @$_GET['pg'];
if(empty($pg)){
$curr = 0;
$pg = 1;
} else {
$curr = ($pg - 1) * $limit;
}?>
<!-- Row Start -->
<div class="row">
<!-- Secondary Nav START -->
<div class="col s12">
<div class="z-depth-1">
<nav class="secondary-nav">
<div class="nav-wrapper blue-grey darken-1">
<div class="col m7">
<ul class="left">
<li class="waves-effect waves-light hide-on-small-only"><a href="?page=tsu" class="judul"><i class="material-icons">drafts</i> Surat Undangan</a></li>
<li class="waves-effect waves-light">
<a href="?page=tsg&act=add"><i class="material-icons md-24">add_circle</i> Tambah Data</a>
</li>
</ul>
</div>
<div class="col m5 hide-on-med-and-down">
<form method="post" action="?page=tsu">
<div class="input-field round-in-box">
<input id="search" type="search" name="cari" placeholder="Ketik dan tekan enter mencari data..." required>
<label for="search"><i class="material-icons">search</i></label>
<input type="submit" name="submit" class="hidden">
</div>
</form>
</div>
</div>
</nav>
</div>
</div>
<!-- Secondary Nav END -->
</div>
<!-- Row END -->
<?php
if(isset($_SESSION['succAdd'])){
$succAdd = $_SESSION['succAdd'];
echo '<div id="alert-message" class="row">
<div class="col m12">
<div class="card green lighten-5">
<div class="card-content notif">
<span class="card-title green-text"><i class="material-icons md-36">done</i> '.$succAdd.'</span>
</div>
</div>
</div>
</div>';
unset($_SESSION['succAdd']);
}
if(isset($_SESSION['succEdit'])){
$succEdit = $_SESSION['succEdit'];
echo '<div id="alert-message" class="row">
<div class="col m12">
<div class="card green lighten-5">
<div class="card-content notif">
<span class="card-title green-text"><i class="material-icons md-36">done</i> '.$succEdit.'</span>
</div>
</div>
</div>
</div>';
unset($_SESSION['succEdit']);
}
if(isset($_SESSION['succDel'])){
$succDel = $_SESSION['succDel'];
echo '<div id="alert-message" class="row">
<div class="col m12">
<div class="card green lighten-5">
<div class="card-content notif">
<span class="card-title green-text"><i class="material-icons md-36">done</i> '.$succDel.'</span>
</div>
</div>
</div>
</div>';
unset($_SESSION['succDel']);
}
?>
<!-- Row form Start -->
<div class="row jarak-form">
<?php
if(isset($_REQUEST['submit'])){
$cari = mysqli_real_escape_string($config, $_REQUEST['cari']);
echo '
<div class="col s12" style="margin-top: -18px;">
<div class="card blue lighten-5">
<div class="card-content">
<p class="description">Hasil pencarian untuk kata kunci <strong>"'.stripslashes($cari).'"</strong><span class="right"><a href="?page=tsu"><i class="material-icons md-36" style="color: #333;">clear</i></a></span></p>
</div>
</div>
</div>
<div class="col m12" id="colres">
<table class="bordered" id="tbl">
<thead class="blue lighten-4" id="head">
<tr>
<th width="10%">No. Agenda<br/>Kode</th>
<th width="31%">Isi Ringkas<br/> File</th>
<th width="24%">Tujuan</th>
<th width="19%">No. Surat<br/>Tgl Surat</th>
<th width="16%">Tindakan <span class="right"><i class="material-icons" style="color: #333;">settings</i></span></th>
</tr>
</thead>
<tbody>
<tr>';
//script untuk mencari data
$query = mysqli_query($config, "SELECT * FROM tbl_surat_umum WHERE isi LIKE '%$cari%' ORDER by id_surat DESC LIMIT $curr, $limit");
if(mysqli_num_rows($query) > 0){
$no = 1;
while($row = mysqli_fetch_array($query)){
echo '
<td>'.$row['no_agenda'].'<br/><hr/>'.$row['kode'].'</td>
<td>'.substr($row['isi'],0,200).'<br/><br/><strong>File :</strong>';
if(!empty($row['file'])){
echo ' <strong><a href="?page=gsk&act=fsk&id_surat='.$row['id_surat'].'">'.$row['file'].'</a></strong>';
} else {
echo ' <em>Tidak ada file yang diupload</em>';
} echo '</td>
<td>'.$row['tujuan'].'</td>';
$y = substr($row['tgl_surat'],0,4);
$m = substr($row['tgl_surat'],5,2);
$d = substr($row['tgl_surat'],8,2);
if($m == "01"){
$nm = "Januari";
} elseif($m == "02"){
$nm = "Februari";
} elseif($m == "03"){
$nm = "Maret";
} elseif($m == "04"){
$nm = "April";
} elseif($m == "05"){
$nm = "Mei";
} elseif($m == "06"){
$nm = "Juni";
} elseif($m == "07"){
$nm = "Juli";
} elseif($m == "08"){
$nm = "Agustus";
} elseif($m == "09"){
$nm = "September";
} elseif($m == "10"){
$nm = "Oktober";
} elseif($m == "11"){
$nm = "November";
} elseif($m == "12"){
$nm = "Desember";
}
echo '
<td>'.$row['no_surat'].'<br/><hr/>'.$d." ".$nm." ".$y.'</td>
<td>';
if($_SESSION['id_user'] != $row['id_user'] AND $_SESSION['id_user'] != 1){
echo '<a class="btn small yellow darken-3 waves-effect waves-light" href="?page=ctg&id_surat='.$row['id_surat'].'" target="_blank">
<i class="material-icons">print</i> PRINT</a>';
} else {
echo '<a class="btn small yellow darken-3 waves-effect waves-light" href="?page=ctg&id_surat='.$row['id_surat'].'" target="_blank">
<i class="material-icons">print</i> PRINT</a>';
echo '<a class="btn small blue waves-effect waves-light" href="?page=tsu&act=edit&id_surat='.$row['id_surat'].'">
<i class="material-icons">edit</i> EDIT</a>
<a class="btn small deep-orange waves-effect waves-light" href="?page=tsu&act=del&id_surat='.$row['id_surat'].'">
<i class="material-icons">delete</i> DEL</a>';
} echo '
</td>
</tr>
</tbody>';
}
} else {
echo '<tr><td colspan="5"><center><p class="add">Tidak ada data yang ditemukan</p></center></td></tr>';
}
echo '</table><br/><br/>
</div>
</div>
<!-- Row form END -->';
$query = mysqli_query($config, "SELECT * FROM tbl_surat_umum");
$cdata = mysqli_num_rows($query);
$cpg = ceil($cdata/$limit);
echo '<!-- Pagination START -->
<ul class="pagination">';
if($cdata > $limit ){
//first and previous pagging
if($pg > 1){
$prev = $pg - 1;
echo '<li><a href="?page=tsu&pg=1"><i class="material-icons md-48">first_page</i></a></li>
<li><a href="?page=tsu&pg='.$prev.'"><i class="material-icons md-48">chevron_left</i></a></li>';
} else {
echo '<li class="disabled"><a href=""><i class="material-icons md-48">first_page</i></a></li>
<li class="disabled"><a href=""><i class="material-icons md-48">chevron_left</i></a></li>';
}
//perulangan pagging
for($i=1; $i <= $cpg; $i++)
if($i != $pg){
echo '<li class="waves-effect waves-dark"><a href="?page=tsu&pg='.$i.'"> '.$i.' </a></li>';
} else {
echo '<li class="active waves-effect waves-dark"><a href="?page=tsu&pg='.$i.'"> '.$i.' </a></li>';
}
//last and next pagging
if($pg < $cpg){
$next = $pg + 1;
echo '<li><a href="?page=tsu&pg='.$next.'"><i class="material-icons md-48">chevron_right</i></a></li>
<li><a href="?page=tsu&pg='.$cpg.'"><i class="material-icons md-48">last_page</i></a></li>';
} else {
echo '<li class="disabled"><a href=""><i class="material-icons md-48">chevron_right</i></a></li>
<li class="disabled"><a href=""><i class="material-icons md-48">last_page</i></a></li>';
}
echo '
</ul>
<!-- Pagination END -->';
} else {
echo '';
}
} else {
echo '
<div class="col m12" id="colres">
<table class="bordered" id="tbl">
<thead class="blue lighten-4" id="head">
<tr>
<th width="10%">No. Agenda<br/>Kode</th>
<th width="31%">Isi Ringkas<br/> File</th>
<th width="24%">Tujuan</th>
<th width="19%">No. Surat<br/>Tgl Surat</th>
<th width="16%">Tindakan <span class="right tooltipped" data-position="left" data-tooltip="Atur jumlah data yang ditampilkan"><a class="modal-trigger" href="#modal"><i class="material-icons" style="color: #333;">settings</i></a></span></th>
<div id="modal" class="modal">
<div class="modal-content white">
<h5>Jumlah data yang ditampilkan per halaman</h5>';
$query = mysqli_query($config, "SELECT id_sett,surat_keluar FROM tbl_sett");
list($id_sett,$surat_keluar) = mysqli_fetch_array($query);
echo '
<div class="row">
<form method="post" action="">
<div class="input-field col s12">
<input type="hidden" value="'.$id_sett.'" name="id_sett">
<div class="input-field col s1" style="float: left;">
<i class="material-icons prefix md-prefix">looks_one</i>
</div>
<div class="input-field col s11 right" style="margin: -5px 0 20px;">
<select class="browser-default validate" name="surat_keluar" required>
<option value="'.$surat_keluar.'">'.$surat_keluar.'</option>
<option value="5">5</option>
<option value="10">10</option>
<option value="20">20</option>
<option value="50">50</option>
<option value="100">100</option>
</select>
</div>
<div class="modal-footer white">
<button type="submit" class="modal-action waves-effect waves-green btn-flat" name="simpan">Simpan</button>';
if(isset($_REQUEST['simpan'])){
$id_sett = "1";
$surat_keluar = $_REQUEST['surat_keluar'];
$id_user = $_SESSION['id_user'];
$query = mysqli_query($config, "UPDATE tbl_sett SET surat_keluar='$surat_keluar',id_user='$id_user' WHERE id_sett='$id_sett'");
if($query == true){
header("Location: ./admin.php?page=tsu");
die();
}
} echo '
<a href="#!" class=" modal-action modal-close waves-effect waves-green btn-flat">Batal</a>
</div>
</div>
</form>
</div>
</div>
</div>
</tr>
</thead>
<tbody>
<tr>';
//script untuk mencari data
$query = mysqli_query($config, "SELECT * FROM tbl_surat_umum ORDER by id_surat DESC LIMIT $curr, $limit");
if(mysqli_num_rows($query) > 0){
$no = 1;
while($row = mysqli_fetch_array($query)){
echo '
<td>'.$row['no_agenda'].'<br/><hr/>'.$row['kode'].'</td>
<td>'.substr($row['isi'],0,200).'<br/><br/><strong>File :</strong>';
if(!empty($row['file'])){
echo ' <strong><a href="?page=gsk&act=fsk&id_surat='.$row['id_surat'].'">'.$row['file'].'</a></strong>';
} else {
echo ' <em>Tidak ada file yang diupload</em>';
} echo '</td>
<td>'.$row['tujuan'].'</td>';
$y = substr($row['tgl_surat'],0,4);
$m = substr($row['tgl_surat'],5,2);
$d = substr($row['tgl_surat'],8,2);
if($m == "01"){
$nm = "Januari";
} elseif($m == "02"){
$nm = "Februari";
} elseif($m == "03"){
$nm = "Maret";
} elseif($m == "04"){
$nm = "April";
} elseif($m == "05"){
$nm = "Mei";
} elseif($m == "06"){
$nm = "Juni";
} elseif($m == "07"){
$nm = "Juli";
} elseif($m == "08"){
$nm = "Agustus";
} elseif($m == "09"){
$nm = "September";
} elseif($m == "10"){
$nm = "Oktober";
} elseif($m == "11"){
$nm = "November";
} elseif($m == "12"){
$nm = "Desember";
}
echo '
<td>'.$row['no_surat'].'<br/><hr/>'.$d." ".$nm." ".$y.'</td>
<td>';
if($_SESSION['id_user'] != $row['id_user'] AND $_SESSION['id_user'] != 1){
echo '<a class="btn small yellow darken-3 waves-effect waves-light" href="?page=ctg&id_surat='.$row['id_surat'].'" target="_blank">
<i class="material-icons">print</i> PRINT</a>';
} else {
echo '<a class="btn small yellow darken-3 waves-effect waves-light" href="cetak_undangan.php?id_surat='.$row['id_surat'].'" target="_blank">
<i class="material-icons">print</i> PRINT</a>';
echo '<a class="btn small blue waves-effect waves-light" href="?page=tsu&act=edit&id_surat='.$row['id_surat'].'">
<i class="material-icons">edit</i> EDIT</a>
<a class="btn small deep-orange waves-effect waves-light" href="?page=tsu&act=del&id_surat='.$row['id_surat'].'">
<i class="material-icons">delete</i> DEL</a>';
} echo '
</td>
</tr>
</tbody>';
}
} else {
echo '<tr><td colspan="5"><center><p class="add">Tidak ada data untuk ditampilkan. <u><a href="?page=tsu&act=add">Tambah data baru</a></u> </p></center></td></tr>';
}
echo '</table>
</div>
</div>
<!-- Row form END -->';
$query = mysqli_query($config, "SELECT * FROM tbl_surat_umum");
$cdata = mysqli_num_rows($query);
$cpg = ceil($cdata/$limit);
echo '<br/><!-- Pagination START -->
<ul class="pagination">';
if($cdata > $limit ){
//first and previous pagging
if($pg > 1){
$prev = $pg - 1;
echo '<li><a href="?page=tsu&pg=1"><i class="material-icons md-48">first_page</i></a></li>
<li><a href="?page=tsu&pg='.$prev.'"><i class="material-icons md-48">chevron_left</i></a></li>';
} else {
echo '<li class="disabled"><a href=""><i class="material-icons md-48">first_page</i></a></li>
<li class="disabled"><a href=""><i class="material-icons md-48">chevron_left</i></a></li>';
}
//perulangan pagging
for($i=1; $i <= $cpg; $i++)
if($i != $pg){
echo '<li class="waves-effect waves-dark"><a href="?page=tsu&pg='.$i.'"> '.$i.' </a></li>';
} else {
echo '<li class="active waves-effect waves-dark"><a href="?page=tsu&pg='.$i.'"> '.$i.' </a></li>';
}
//last and next pagging
if($pg < $cpg){
$next = $pg + 1;
echo '<li><a href="?page=tsu&pg='.$next.'"><i class="material-icons md-48">chevron_right</i></a></li>
<li><a href="?page=tsu&pg='.$cpg.'"><i class="material-icons md-48">last_page</i></a></li>';
} else {
echo '<li class="disabled"><a href=""><i class="material-icons md-48">chevron_right</i></a></li>
<li class="disabled"><a href=""><i class="material-icons md-48">last_page</i></a></li>';
}
echo '
</ul>
<!-- Pagination END -->';
} else {
echo '';
}
}
}
}
}
?>