| Server IP : 88.223.91.32 / Your IP : 216.73.217.80 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/IDI/superadmin/ |
Upload File : |
<!DOCTYPE html>
<html lang="en">
<head>
<title>Perpanjnagan STR</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- css bootstrap -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/js/bootstrap.min.js"></script>
<!-- Custom styles for this template-->
<link href="css/sb-admin-2.min.css" rel="stylesheet">
<title>IDI Kota Bandung</title>
<!-- Custom fonts for this template-->
<link href="vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css">
<link href="https://fonts.googleapis.com/css?family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i" rel="stylesheet">
<!-- Custom styles for this template-->
<link href="css/sb-admin-2.min.css" rel="stylesheet">
<!-- Custom styles for this page -->
<link href="vendor/datatables/dataTables.bootstrap4.min.css" rel="stylesheet">
<style type="text/css">
body{
font-family: roboto;
}
table {
margin: 0 auto;
border-collapse: collapse;
}
tbody {
color: #000;
}
table td {
padding: 5px 10px;
border: 1px solid #e0e0e0;
font: normal 12px Tahoma, Geneva, sans-serif;
}
table tr {
font: normal 12px Tahoma, Geneva, sans-serif;
}
/* untuk ukuran layar 700px kebawah */
@media screen and (max-width: 780px) {
.header,
.footer{
text-align: center;
}
.left {
width: auto;
float: none;
}
.middle {
width: auto;
float: none;
}
.right {
width: auto;
float: none;
}
}
</style>
<style type="text/css">
/* Table demo-table */
table {
margin: auto;
font-family: "Lucida Sans Unicode", "Lucida Grande", "Segoe Ui";
font-size: 12px;
}
.demo-table {
border-collapse: collapse;
font-size: 11px;
}
.demo-table th,
.demo-table td {
border-bottom: 1px solid #e1edff;
border-left: 1px solid #e1edff;
padding: 5px 10px;
}
.demo-table th,
.demo-table td:last-child {
border-right: 1px solid #e1edff;
}
.demo-table td:first-child {
border-top: 1px solid #e1edff;
}
.demo-table td:last-child{
border-bottom: 0;
}
caption {
caption-side: top;
margin-bottom: 10px;
}
/* Table Header */
.demo-table thead th {
background-color: #508abb;
color: #FFFFFF;
border-color: #6ea1cc !important;
text-transform: uppercase;
}
/* Table Body */
.demo-table tbody td {
color: #353535;
}
.demo-table tbody tr:nth-child(odd) td {
background-color: #f4fbff;
}
.demo-table tbody tr:hover th,
.demo-table tbody tr:hover td {
background-color: #ffffa2;
border-color: #ffff0f;
transition: all .2s;
}
.table-container {
overflow: auto;
}
/* side bar jqery*/
@media only screen and (max-width: 480px) {
table {
width: 100%;
}
thead th.column-primary {
width: 100%;
}
thead th:not(.column-primary) {
display:none;
}
th[scope="row"] {
vertical-align: top;
}
td {
display: block;
width: auto;
text-align: right;
}
thead th::before {
text-transform: uppercase;
font-weight: bold;
content: attr(data-header);
}
thead th:first-child span {
display: none;
}
td::before {
float: left;
text-transform: uppercase;
font-weight: bold;
content: attr(data-header);
}
}
</style>
</head>
<body>
<nav class="navbar navbar-inverse">
<div class="container-fluid">
<div class="navbar-header">
<a class="navbar-brand" href="#">IDI Bandung</a>
</div>
</div>
</nav>
<!-- Page Wrapper -->
<div id="wrapper">
<?php include "sidebar006.php"; ?>
<!-- Content Wrapper -->
<div id="content-wrapper" class="d-flex flex-column">
<!-- Main Content -->
<div id="content">
<?php include "topbar.php";?>
<!-- Begin Page Content -->
<div class="container-fluid">
<!-- DataTales Example -->
<div class="card shadow mb-4">
<div class="card-header py-3">
<h6 class="m-0 font-weight-bold text-primary">List Post</h6>
</div>
<div class="card-body">
<div class="table-responsive">
<div class="container">
<div align="center">
Pengajuan rekomendasi P2KB Baru
<br>
</br>
<i class='fa fa-file-excel-o'> EXPORT Ke EXCEL Lap Rekap P2KB sudah Valid : </i>
<a target="_blank" href="expdata_p2kbprog.php">Export Ke EXCEL Rekap Pengajuan P2KB Sudah Valid</a>
<br><br>
<center><a href='dashboard006.php' class="btn btn-info btn-sm"><span class="glyphicon glyphicon-home"> </span> Home</a></center>
<br/>
</div>
<!--Panel Form pencarian -->
<div class="row">
<div class="col-md-5">
<div class="panel panel-default">
<div class="panel-heading"><b>Pencarian</b></div>
<div class="panel-body">
<form class="form-inline" >
<div class="form-group">
<select class="form-control" id="Kolom" name="Kolom" required="">
<?php
$kolom=(isset($_GET['Kolom']))? $_GET['Kolom'] : "";
?>
<option value="nmlead" <?php if ($kolom=="Nama") echo "selected"; ?>>Nama</option>
<option value="status2" <?php if ($kolom=="Alamat") echo "selected";?>>Status</option>
</select>
</div>
<div class="form-group">
<input type="text" class="form-control" id="KataKunci" name="KataKunci" placeholder="Kata kunci.." required="" value="<?php if (isset($_GET['KataKunci'])) echo $_GET['KataKunci']; ?>">
</div>
<button type="submit" class="btn btn-primary">Cari</button>
<a href="tablepage.php" class="btn btn-danger">Reset</a>
</form>
</div>
</div>
</div>
</div>
<!-- Tabel data h_registrasi -->
<?php
include "koneksi.php";
$page = (isset($_GET['page']))? (int) $_GET['page'] : 1;
$kolomCari=(isset($_GET['Kolom']))? $_GET['Kolom'] : "";
$kolomKataKunci=(isset($_GET['KataKunci']))? $_GET['KataKunci'] : "";
// Jumlah data per halaman
$limit = 10;
$limitStart = ($page - 1) * $limit;
//kondisi jika parameter pencarian kosong
if($kolomCari=="" && $kolomKataKunci==""){
$SqlQuery = mysqli_query($konek, "SELECT * FROM h_registrasi LIMIT ".$limitStart.",".$limit);
}else{
//kondisi jika parameter kolom pencarian diisi
$SqlQuery = mysqli_query($konek, "SELECT * FROM h_registrasi WHERE $kolomCari LIKE '%$kolomKataKunci%' LIMIT ".$limitStart.",".$limit);
}
$no = $limitStart + 1;
$row = mysqli_fetch_array($SqlQuery);
?>
<div align="right">
<ul class="pagination">
<?php
// Jika page = 1, maka LinkPrev disable
if($page == 1){
?>
<!-- link Previous Page disable -->
<li class="disabled"><a href="#">Previous</a></li>
<?php
}
else{
$LinkPrev = ($page > 1)? $page - 1 : 1;
if($kolomCari=="" && $kolomKataKunci==""){
?>
<li><a href="tablepage.php?page=<?php echo $LinkPrev; ?>">Previous</a></li>
<?php
}else{
?>
<li><a href="tablepage.php?Kolom=<?php echo $kolomCari;?>&KataKunci=<?php echo $kolomKataKunci;?>&page=<?php echo $LinkPrev;?>">Previous</a></li>
<?php
}
}
?>
<?php
//kondisi jika parameter pencarian kosong
if($kolomCari=="" && $kolomKataKunci==""){
$SqlQuery = mysqli_query($konek, "SELECT * FROM h_registrasi");
}else{
//kondisi jika parameter kolom pencarian diisi
$SqlQuery = mysqli_query($konek, "SELECT * FROM h_registrasi WHERE $kolomCari LIKE '%$kolomKataKunci%'");
}
//Hitung semua jumlah data yang berada pada tabel Sisawa
$JumlahData = mysqli_num_rows($SqlQuery);
// Hitung jumlah halaman yang tersedia
$jumlahPage = ceil($JumlahData / $limit);
// Jumlah link number
$jumlahNumber = 1;
// Untuk awal link number
$startNumber = ($page > $jumlahNumber)? $page - $jumlahNumber : 1;
// Untuk akhir link number
$endNumber = ($page < ($jumlahPage - $jumlahNumber))? $page + $jumlahNumber : $jumlahPage;
for($i = $startNumber; $i <= $endNumber; $i++){
$linkActive = ($page == $i)? ' class="active"' : '';
if($kolomCari=="" && $kolomKataKunci==""){
?>
<li<?php echo $linkActive; ?>><a href="tablepage.php?page=<?php echo $i; ?>"><?php echo $i; ?></a></li>
<?php
}else{
?>
<li<?php echo $linkActive; ?>><a href="tablepage.php?Kolom=<?php echo $kolomCari;?>&KataKunci=<?php echo $kolomKataKunci;?>&page=<?php echo $i; ?>"><?php echo $i; ?></a></li>
<?php
}
}
?>
<!-- link Next Page -->
<?php
if($page == $jumlahPage){
?>
<li class="disabled"><a href="#">Next</a></li>
<?php
}
else{
$linkNext = ($page < $jumlahPage)? $page + 1 : $jumlahPage;
if($kolomCari=="" && $kolomKataKunci==""){
?>
<li><a href="tablepage.php?page=<?php echo $linkNext; ?>">Next</a></li>
<?php
}else{
?>
<li><a href="tablepage.php?Kolom=<?php echo $kolomCari;?>&KataKunci=<?php echo $kolomKataKunci;?>&page=<?php echo $linkNext; ?>">Next</a></li>
<?php
}
}
?>
</ul>
</div>
</div>
<table class="table table-striped table-bordered table-hover">
<table class="table table-bordered" id="dataTable" width="90%" cellspacing="0">
<thead>
<tr>
<th>No</th>
<th>Tgl Masuk Berkas</th>
<th>NPA</th>
<th>Nama</th>
<th>telp</th>
<th>Email</th>
<th>Password</th>
<th>Bukti Transfer IDI Online</th>
<th>Bukti Transfer adm</th>
<th>Status</th>
<th>Cek</th>
<th>Hapus Duplikat</th>
</tr>
</thead>
<tbody>
<?php
include "koneksi.php";
$page = (isset($_GET['page']))? (int) $_GET['page'] : 1;
$kolomCari=(isset($_GET['Kolom']))? $_GET['Kolom'] : "";
$kolomKataKunci=(isset($_GET['KataKunci']))? $_GET['KataKunci'] : "";
// Jumlah data per halaman
$limit = 5;
$limitStart = ($page - 1) * $limit;
//kondisi jika parameter pencarian kosong
if($kolomCari=="" && $kolomKataKunci==""){
$SqlQuery = mysqli_query($konek, "SELECT * FROM h_registrasi where status2='proses' AND status2<>'finish' and perihal='p2kb' LIMIT ".$limitStart.",".$limit);
}else{
//kondisi jika parameter kolom pencarian diisi
$SqlQuery = mysqli_query($konek, "SELECT * FROM h_registrasi where status2='proses' AND status2<>'finish' and perihal='p2kb' WHERE $kolomCari LIKE '%$kolomKataKunci%' LIMIT ".$limitStart.",".$limit);
}
$no = $limitStart + 1;
while($row = mysqli_fetch_array($SqlQuery)){
$noreg= $row['noreg'];
$str= $row['mbstr'];
$date1 = new DateTime($str);
$mbstr = $date1->format('d-m-Y');
$tgliuran= $row['iuran'];
$date2 = new DateTime($tgliuran);
$iuran= $date2->format('d-m-Y');
$tglmasuk= $row['tgl_reg'];
$date3 = new DateTime($tglmasuk);
$tglberkas= $date3->format('d-m-Y');
?>
<tr>
<td><?php echo $no ?></td>
<td><?php echo $tglberkas ?></td>
<td><?php echo $row['npa']?></td>
<td><?php echo $row['nmlead']?></td>
<td><?php echo $row['telp']?></td>
<td><?php echo $row['email']?></td>
<td><?php echo $row['password']?></td>
<td>
<a href="<?php echo $row['gambar']; ?>" title="Foto Bukti!" class="MagicZoom" rel="zoom-id:zoom;opacity-reverse:true; ">
<img src="../anggota/<?php echo $row['gambar']; ?>" style="width:50%;"/> </a>
</td>
<td>
<?php
$data = $konek->query("SELECT * FROM b_inv3 where noreg='$noreg' ") or die(mysqli_error());
$d=mysqli_fetch_array($data);
$bukti= isset($d['gambar']) ? $d['gambar'] : null;
if ($bukti==""){
?>
<?php echo "-" ?>
<?php
}else{
?>
<img src="../anggota/files/<?php echo $d['gambar']; ?>" style="width:50%;"/>
<?php
}
?>
</td>
<td><?php echo $row['status2']?></td>
<td><a class='btn btn-success btn-sm' href='upd_sipp2kb.php?noreg=<?php echo $row['noreg']; ?>&npm=<?php echo $row['npm']; ?>'>Cek</a></td>
<td> <a href="#" onclick="confirm_modal('del_dupp2kb.php?&noreg=<?php echo $row['noreg']; ?>&npm=<?php echo $row['npm']; ?>&view=2');"><button class="btn btn-danger btn-xs" title="Hapus">Hapus</button></a> </td>
</tr>
<?php
}
?>
</tbody>
</table>
<div align="right">
<ul class="pagination">
<?php
// Jika page = 1, maka LinkPrev disable
if($page == 1){
?>
<!-- link Previous Page disable -->
<li class="disabled"><a href="#">Previous</a></li>
<?php
}
else{
$LinkPrev = ($page > 1)? $page - 1 : 1;
if($kolomCari=="" && $kolomKataKunci==""){
?>
<li><a href="tablepage.php?page=<?php echo $LinkPrev; ?>">Previous</a></li>
<?php
}else{
?>
<li><a href="tablepage.php?Kolom=<?php echo $kolomCari;?>&KataKunci=<?php echo $kolomKataKunci;?>&page=<?php echo $LinkPrev;?>">Previous</a></li>
<?php
}
}
?>
<?php
//kondisi jika parameter pencarian kosong
if($kolomCari=="" && $kolomKataKunci==""){
$SqlQuery = mysqli_query($konek, "SELECT * FROM h_registrasi where status2='proses' AND status2<>'finish' and perihal='p2kb' ");
}else{
//kondisi jika parameter kolom pencarian diisi
$SqlQuery = mysqli_query($konek, "SELECT * FROM h_registrasi where status2='proses' AND status2<>'finish' and perihal='p2kb' AND $kolomCari LIKE '%$kolomKataKunci%'");
}
//Hitung semua jumlah data yang berada pada tabel Sisawa
$JumlahData = mysqli_num_rows($SqlQuery);
// Hitung jumlah halaman yang tersedia
$jumlahPage = ceil($JumlahData / $limit);
// Jumlah link number
$jumlahNumber = 1;
// Untuk awal link number
$startNumber = ($page > $jumlahNumber)? $page - $jumlahNumber : 1;
// Untuk akhir link number
$endNumber = ($page < ($jumlahPage - $jumlahNumber))? $page + $jumlahNumber : $jumlahPage;
for($i = $startNumber; $i <= $endNumber; $i++){
$linkActive = ($page == $i)? ' class="active"' : '';
if($kolomCari=="" && $kolomKataKunci==""){
?>
<li<?php echo $linkActive; ?>><a href="tablepage.php?page=<?php echo $i; ?>"><?php echo $i; ?></a></li>
<?php
}else{
?>
<li<?php echo $linkActive; ?>><a href="tablepage.php?Kolom=<?php echo $kolomCari;?>&KataKunci=<?php echo $kolomKataKunci;?>&page=<?php echo $i; ?>"><?php echo $i; ?></a></li>
<?php
}
}
?>
<!-- link Next Page -->
<?php
if($page == $jumlahPage){
?>
<li class="disabled"><a href="#">Next</a></li>
<?php
}
else{
$linkNext = ($page < $jumlahPage)? $page + 1 : $jumlahPage;
if($kolomCari=="" && $kolomKataKunci==""){
?>
<li><a href="tablepage.php?page=<?php echo $linkNext; ?>">Next</a></li>
<?php
}else{
?>
<li><a href="tablepage.php?Kolom=<?php echo $kolomCari;?>&KataKunci=<?php echo $kolomKataKunci;?>&page=<?php echo $linkNext; ?>">Next</a></li>
<?php
}
}
?>
</ul>
</div>
</div>
<!-- Javascript untuk popup modal Delete-->
<script type="text/javascript">
function confirm_modal(delete_url)
{
$('#modal_delete').modal('show', {backdrop: 'static'});
document.getElementById('delete_link').setAttribute('href' , delete_url);
}
</script>
<!-- Page level plugins -->
<script src="vendor/datatables/jquery.dataTables.min.js"></script>
<script src="vendor/datatables/dataTables.bootstrap4.min.js"></script>
<!-- Page level custom scripts -->
<script src="js/demo/datatables-demo.js"></script>
</body>
</html>