Untitled
unknown
plain_text
2 years ago
8.5 kB
2
Indexable
Never
<?php
include '../../../config/database-config.php';
include '../part/akses.php';
include '../part/header.php';
?>
<aside class="main-sidebar" style="">
<section class="sidebar">
<div class="user-panel">
<div class="pull-left image">
<?php
if (isset($_SESSION['lvl']) && ($_SESSION['lvl'] == 'Administrator')) {
echo '<img src="../../../assets/img/ava-admin-female.png" class="img-circle" alt="User Image">';
} else if (isset($_SESSION['lvl']) && ($_SESSION['lvl'] == 'Kepala Desa')) {
echo '<img src="../../../assets/img/ava-kades.png" class="img-circle" alt="User Image">';
}
?>
</div>
<div class="pull-left info">
<p><?php echo $_SESSION['lvl']; ?></p>
<a href="#"><i class="fa fa-circle text-success"></i> Online</a>
</div>
</div>
<ul class="sidebar-menu" data-widget="tree">
<li class="header">MAIN NAVIGATION</li>
<li>
<a href="../../dashboard/">
<i class="fas fa-tachometer-alt"></i> <span> Dashboard</span>
</a>
</li>
<li>
<a href="../../pejabat/">
<i class="fa fa-user"></i> <span>Pejabat Desa</span>
</a>
</li>
<li>
<a href="../../penduduk/">
<i class="fa fa-users"></i> <span>Data Penduduk</span>
</a>
</li>
<li class="active treeview">
<a href="#">
<i class="fas fa-envelope-open-text"></i> <span> Surat</span>
<span class="pull-right-container"><i class="fa fa-angle-left pull-right"></i></span>
</a>
<ul class="treeview-menu">
<li class="active">
<a href="#">
<i class="fa fa-circle-notch"></i> Permintaan Surat
</a>
</li>
<li>
<a href="../../surat/surat_selesai/">
<i class="fa fa-circle-notch"></i> Surat Selesai
</a>
</li>
</ul>
</li>
<li>
<a href="../../laporan/">
<i class="fas fa-chart-line"></i> <span> Laporan</span>
</a>
</li>
</ul>
</section>
</aside>
<div class="content-wrapper">
<section class="content-header">
<h1>Permintaan Surat</h1>
<ol class="breadcrumb">
<li><a href="../../dashboard/"><i class="fa fa-tachometer-alt"></i> Dashboard</a></li>
<li class="active">Permintaan Surat</li>
</ol>
</section>
<section class="content">
<div class="row">
<div class="col-md-12">
<br><br>
<table class="table table-striped table-bordered table-responsive" id="data-table" width="100%" cellspacing="0">
<thead>
<tr>
<th><strong>Tanggal</strong></th>
<th><strong>NIK</strong></th>
<th><strong>Nama</strong></th>
<th><strong>Jenis Surat</strong></th>
<th><strong>Status</strong></th>
<th><strong>Aksi</strong></th>
</tr>
</thead>
<tbody>
<?php
$qTampil = mysqli_query($connect, "SELECT penduduk.nama, surat_keterangan_tidak_mampu.id_sk, surat_keterangan_tidak_mampu.no_surat, surat_keterangan_tidak_mampu.nik, surat_keterangan_tidak_mampu.jenis_surat, surat_keterangan_tidak_mampu.status_surat, surat_keterangan_tidak_mampu.tanggal_surat FROM penduduk LEFT JOIN surat_keterangan_tidak_mampu ON surat_keterangan_tidak_mampu.nik = penduduk.nik WHERE surat_keterangan_tidak_mampu.status_surat='pending'
UNION SELECT penduduk.nama, surat_keterangan_domisili.id_skd, surat_keterangan_domisili.no_surat, surat_keterangan_domisili.nik, surat_keterangan_domisili.jenis_surat, surat_keterangan_domisili.status_surat, surat_keterangan_domisili.tanggal_surat FROM penduduk LEFT JOIN surat_keterangan_domisili ON surat_keterangan_domisili.nik = penduduk.nik WHERE surat_keterangan_domisili.status_surat='pending'
UNION SELECT penduduk.nama, surat_keterangan_kepemilikan_kendaraan_bermotor.id_skkkb, surat_keterangan_kepemilikan_kendaraan_bermotor.no_surat, surat_keterangan_kepemilikan_kendaraan_bermotor.nik, surat_keterangan_kepemilikan_kendaraan_bermotor.jenis_surat, surat_keterangan_kepemilikan_kendaraan_bermotor.status_surat, surat_keterangan_kepemilikan_kendaraan_bermotor.tanggal_surat FROM penduduk LEFT JOIN surat_keterangan_kepemilikan_kendaraan_bermotor ON surat_keterangan_kepemilikan_kendaraan_bermotor.nik = penduduk.nik WHERE surat_keterangan_kepemilikan_kendaraan_bermotor.status_surat='pending'
UNION SELECT penduduk.nama, surat_keterangan_usaha.id_sku, surat_keterangan_usaha.no_surat, surat_keterangan_usaha.nik, surat_keterangan_usaha.jenis_surat, surat_keterangan_usaha.status_surat, surat_keterangan_usaha.tanggal_surat FROM penduduk LEFT JOIN surat_keterangan_usaha ON surat_keterangan_usaha.nik = penduduk.nik WHERE surat_keterangan_usaha.status_surat='pending'
UNION SELECT penduduk.nama, surat_lapor_hajatan.id_slh, surat_lapor_hajatan.no_surat, surat_lapor_hajatan.nik, surat_lapor_hajatan.jenis_surat, surat_lapor_hajatan.status_surat, surat_lapor_hajatan.tanggal_surat FROM penduduk LEFT JOIN surat_lapor_hajatan ON surat_lapor_hajatan.nik = penduduk.nik WHERE surat_lapor_hajatan.status_surat='pending'");
if ($qTampil->num_rows > 0) {
foreach ($qTampil as $row) {
?>
</tr>
<tr>
<?php
$tgl_lhr = date($row['tanggal_surat']);
$tgl = date('d ', strtotime($tgl_lhr));
$bln = date('F', strtotime($tgl_lhr));
$thn = date(' Y', strtotime($tgl_lhr));
$blnIndo = array(
'January' => 'Januari',
'February' => 'Februari',
'March' => 'Maret',
'April' => 'April',
'May' => 'Mei',
'June' => 'Juni',
'July' => 'Juli',
'August' => 'Agustus',
'September' => 'September',
'October' => 'Oktober',
'November' => 'November',
'December' => 'Desember',
);
?>
<td><?php echo $tgl . $blnIndo[$bln] . $thn; ?></td>
<td><?php echo $row['nik']; ?></td>
<td style="text-transform: capitalize;"><?php echo $row['nama']; ?></td>
<td><?php echo $row['jenis_surat']; ?></td>
<td><a class="btn btn-danger btn-sm" href='#'><i class="fa fa-spinner"></i><b> <?php echo $row['status_surat']; ?></b></a></td>
<td>
<?php
if ($row['jenis_surat'] == "Surat Keterangan Tidak Mampu") {
?>
<a class="btn btn-success btn-sm" href='konfirmasi/surat_keterangan_tidak_mampu/index.php?id=<?php echo $row['id_sk']; ?>'><i class="fa fa-check"></i><b> KONFIRMASI</b></a>
<?php
} else if ($row['jenis_surat'] == "Surat Keterangan Domisili") {
?>
<a class="btn btn-success btn-sm" href='konfirmasi/surat_keterangan_domisili/index.php?id=<?php echo $row['id_sk']; ?>'><i class="fa fa-check"></i><b> KONFIRMASI</b></a>
<?php
} else if ($row['jenis_surat'] == "Surat Keterangan Kepemilikan Kendaraan Bermotor") {
?>
<a class="btn btn-success btn-sm" href='konfirmasi/surat_keterangan_kepemilikan_kendaraan_bermotor/index.php?id=<?php echo $row['id_sk']; ?>'><i class="fa fa-check"></i><b> KONFIRMASI</b></a>
<?php
} else if ($row['jenis_surat'] == "Surat Keterangan Usaha") {
?>
<a class="btn btn-success btn-sm" href='konfirmasi/surat_keterangan_usaha/index.php?id=<?php echo $row['id_sk']; ?>'><i class="fa fa-check"></i><b> KONFIRMASI</b></a>
<?php
} else if ($row['jenis_surat'] == "Surat Lapor Hajatan") {
?>
<a class="btn btn-success btn-sm" href='konfirmasi/surat_lapor_hajatan/index.php?id=<?php echo $row['id_sk']; ?>'><i class="fa fa-check"></i><b> KONFIRMASI</b></a>
<?php
}
?>
</td>
</tr>
<?php
}
}
?>
</tbody>
</table>
</div>
</div>
</section>
</div>
<?php
include '../part/footer.php';
?>