| Server IP : 91.108.119.167 / 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 : |
<?php
// cek apakah yang mengakses halaman ini sudah login
// mengaktifkan session php
session_start();
if($_SESSION['status'] !="login"){
header("location:../");
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>IDI kota Bandung</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>
<style type="text/css">
<!--
font-family: Arial, Helvetica, sans-serif;
font-size: 10px;
table {
margin: 0 auto;
border-collapse: collapse;
}
tbody {
color: #000;
}
table td {
padding: 5px 10px;
border: 1px solid #e0e0e0;
font: normal 11px Tahoma, Geneva, sans-serif;
}
table tr {
font: normal 11px Tahoma, Geneva, sans-serif;
}
</style>
</head>
<body>
<body id="page-top">
<body>
<!-- Page Wrapper -->
<div id="wrapper">
<!-- Content Wrapper -->
<div id="content-wrapper" class="d-flex flex-column">
<!-- Main Content -->
<div id="content">
<!-- 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>
<nav class="navbar navbar-inverse">
<div class="container-fluid">
<div class="navbar-header">
<a class="navbar-brand" href="#">idikotabandung.com</a>
</div>
</div>
</nav>
<div class="container">
<center><h4>Rekomendasi Sudah di verifikasi Admin (verifikasi 1) </h4><center>
<h4><b>IDI kota Bandung</b></h4>
</div>
<!--Panel Form pencarian -->
<div class="row">
<div class="col-md-8">
<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="perihal" <?php if ($kolom=="Alamat") echo "selected";?>>Tujuan Rekom</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="s_ketfinish01.php" class="btn btn-danger">Reset</a>
</form>
</div>
</div>
</div>
</div>
<!-- Tabel data Siswa -->
<table class="table table-striped table-bordered table-hover">
<thead>
<tr>
<th>No.</th>
<th>No Reg & Tanggal_reg</th>
<th>NoSTR/MBSTR</th>
<th>Tujuan</th>
<th>No_Surat</th>
<th>Nama</th>
<th>Keahlian</th>
<th>Status_DU_SP</th>
<th>Pengajuan</th>
<th>valid_1</th>
<th>Valid_2</th>
<th>Valid_3</th>
<th>Note dari Sekre</th>
<th>Note ke User</th>
<th>Cek Surat</th>
<th>Edit</th>
<th>Validasi</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_reg_ket where verifikasi3='' and status<>'cancel' order by status LIMIT ".$limitStart.",".$limit);
}else{
//kondisi jika parameter kolom pencarian diisi
$SqlQuery = mysqli_query($konek, "SELECT * FROM h_reg_ket where
$kolomCari LIKE '%$kolomKataKunci%' AND verifikasi3='' and status<>'cancel' LIMIT ".$limitStart.",".$limit);
}
$no = $limitStart + 1;
while($row = mysqli_fetch_array($SqlQuery)){
$str= $row['mbstr'];
$date = new DateTime($str);
$mbstr = $date->format('d-m-Y');
$tglreg= $row['tgl_reg'];
$date = new DateTime($tglreg);
$tglreg = $date->format('d-m-Y');
$mbstr2= $row['mbstr2'];
?>
<tr>
<td><?php echo $no++; ?></td>
<td><?php echo $row['noreg']?><br>
<?php echo $tglreg ?><br>
<td><?php echo $row['nostr']?><br>
<?php
if ($mbstr2=='1'){
?>
<?php echo 'Selama Mengikuti PPDS' ?>
<?php
}elseif($mbstr2=='2'){
?>
<?php echo 'Seumur Hidup' ?>
<?php
}else{
?>
<?php echo $row['mbstr']?>
<?php
}
?>
</td>
<td data-header='tujuani'><?php echo $row['tujuan']?></td>
<td data-header='No Rekomendasi'><?php echo $row['noreko']?></td>
<td data-header='Nama'><?php echo $row['nmlead']?></td>
<td data-header='Ahli'><?php echo $row['ahli']?></td>
<td data-header='Ahli'><?php echo $row['statahli']?></td>
<td data-header='Jenis Rekom'><?php echo $row['perihal']?></td>
<td data-header='Verifikasi 1'><?php echo $row['verifikasi1']?></td>
<td data-header='Verifikasi 2'><?php echo $row['verifikasi2']?></td>
<td data-header='Verifikasi 3'><?php echo $row['verifikasi3']?></td>
<td data-header='note1'> <textarea cols="10" rows="4" readonly name="note1" ><?php echo $row['note1']; ?> </textarea> </td>
<form name="form" enctype="multipart/form-data" action="notif_user.php" method="POST">
<td data-header='note1'>
<input name="noreg" type = "hidden" readonly class="form-control" value="<?php echo $row['noreg']?>" />
<input name="npm" type = "hidden" readonly class="form-control" value="<?php echo $row['npm']?>" />
<input name="page" type = "hidden" readonly class="form-control" value="<?php echo $page ?>" />
<textarea cols="10" rows="4" name="note2" ><?php echo $row['note2']; ?> </textarea>
<br>
<input type="SUBMIT" name="SUBMIT" value="Note Ke User" >
</form>
</td>
<td><a class='btn btn-warning btn-sm' href='../surat/cetak_keterangan.php?noreg=<?php echo $row['noreg']; ?>&npm=<?php echo $row['npm']; ?>&page=<?php echo $page; ?>'>Cek Surat</a><br><br>
<a class='btn btn-danger btn-sm' href='cancel_keterangan.php?noreg=<?php echo $row['noreg']; ?>&npm=<?php echo $row['npm']; ?>&page=<?php echo $page; ?>'>Cancel Surat</a>
</td>
<td><a class='btn btn-danger btn-sm' href='edit_ket.php?noreg=<?php echo $row['noreg']; ?>&npm=<?php echo $row['npm']; ?>&page=<?php echo $page; ?>'>Edit</a>
</p>
<a class='btn btn-success btn-sm' href='edit_prkang.php?noreg=<?php echo $row['noreg']; ?>&npm=<?php echo $row['npm']; ?>'>Edit Faskes</a>
</td>
<td><a class='btn btn-danger btn-sm' href='valids3ket.php?noreg=<?php echo $row['noreg']; ?>&npm=<?php echo $row['npm']; ?>&id=<?php echo $row['id_tagihan']; ?>&page=<?php echo $page; ?>'>Validasi Admin</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="s_ketfinish01.php?page=<?php echo $LinkPrev; ?>">Previous</a></li>
<?php
}else{
?>
<li><a href="s_ketfinish01.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_reg_ket where verifikasi3='' and status<>'cancel' order by status ");
}else{
//kondisi jika parameter kolom pencarian diisi
$SqlQuery = mysqli_query($konek, "SELECT * FROM h_reg_ket where verifikasi3='' and status<>'cancel' 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 = 5;
// 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="s_ketfinish01.php?page=<?php echo $i; ?>"><?php echo $i; ?></a></li>
<?php
}else{
?>
<li<?php echo $linkActive; ?>><a href="s_ketfinish01.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="s_ketfinish01.php?page=<?php echo $linkNext; ?>">Next</a></li>
<?php
}else{
?>
<li><a href="s_ketfinish01.php?Kolom=<?php echo $kolomCari;?>&KataKunci=<?php echo $kolomKataKunci;?>&page=<?php echo $linkNext; ?>">Next</a></li>
<?php
}
}
?>
</ul>
</div>
<div style="font-weight:bold;">
Paging
<?php
for ($i=1; $i<=$jumlahPage ; $i++){
?>
<a href="s_ketfinish01.php?page=<?php echo $i; ?>" style="text-decoration:none"> <u><?php echo $i; ?></u></a>
<?php
}
?>
</div>
<br><br>
Total Data : <?php echo $JumlahData ?> dan Total Halaman : <?php echo $jumlahPage ?>
</div>
</body>
</html>
<!-- proses edit data -->
<?php
//if($_SERVER['REQUEST_METHOD']=='POST'){
//
//
//
// //variabel untuk menampung inputan dari form
// $id = $_POST['id'];
// $npm = $_GET['npm'];
// $noreg = $_GET['noreg'];
// $nmlead = $_POST['nmlead'];
// $tahap = $_POST['tahap']+1;
// $dokumen = $_POST['doc'];
// $keterangan = $_POST['ket'];
// $status = $_POST['status'];
// $tgl_cek = $_POST['tgl_cek'];
// $tgl_reg = $_POST['tgl_reg'];
// $ktp = $_POST['ktp'];
// $sir = $_POST['sir'];
// $foto = $_POST['foto'];
//
// // simpan inputan user ke variabel
// // $userInput = array('ket' => $data);
//
// if($npm ==''){
// echo "Form Belum lengkap Pilih Status....";
// $nmlead=$userInput['ket'];
//
// }else{
//
//
// $update = mysqli_query($konek, "UPDATE d_progres SET foto='$foto', sir='$sir',ktp='$ktp',data='chek',status='$status',keterangan='$keterangan',tgl_cek='$tgl_cek' WHERE id_tagihan='$id'");
//
//
//
// header('location:index.php');
// //echo "$id";
// if(!$update){
// echo "Update data gagal...";
// }else{
// header('location:index.php');
// }
// }
//}
?>
</div>
<head>
<script type="text/javascript" src="chartjs/Chart.js"></script>
</head>
<?php
$produk = mysqli_query($konek,"select ahli,count(ahli) as jumlah from d_praktek group by ahli ");
while($row = mysqli_fetch_array($produk)){
$nama_produk[] = $row['ahli'];
$total[] = $row['jumlah'];
//$query = mysqli_query($koneksi,"select count(nmlead) as jumlah from d_reg where npm='2001001' group by nmlead ");
//$row = $query->fetch_array();
//$jumlah_produk[] = $row['jumlah'];
}
?>
<?php // include "footer.php";?>
</div>
<!-- Bootstrap core JavaScript-->
<script src="vendor/jquery/jquery.min.js"></script>
<script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- Core plugin JavaScript-->
<script src="vendor/jquery-easing/jquery.easing.min.js"></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>
</div>
</body>
</html>