| Server IP : 84.32.84.179 / Your IP : 216.73.217.31 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 session_start();
// cek apakah yang mengakses halaman ini sudah login
if($_SESSION['status']<>"login"){
header("location:location:../login.php");
}
?>
<?php include "koneksi.php"
?>
<?php
header("Content-type: application/vnd-ms-excel");
header("Content-Disposition: attachment; filename=Data Rekap Pengajuan P2KB.xls");
?>
<center><h4>Data P2KB </h4><center>
<title>Pencarian Berdasarkan Status Belum Finish</title>
<br>
<br>
<br>
<table class="table table-bordered" id="dataTable" width="60%" 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>Masa Berlaku Akhir No STR</th>
<th>Buti Transf online</th>
<th>Bukti Trans Administarsi</th>
<th>Status</th>
</tr>
</thead>
<tbody >
<?php
$hari = date('Y-m-d');
//require 'config.php';
// $row = $konek->query("SELECT * FROM h_anggota2 where status LIKE '%$status%' order by npm") or die(mysqli_error());
$row = $konek->query("SELECT * FROM h_registrasi where perihal='p2kb' and status2='finish' order by tgl_reg") or die(mysqli_error());
$hari = date('Y-m-d');
$no = 1;
while($fetch = $row->fetch_array()){
$noreg= $fetch['noreg'];
$str= $fetch['mbstr'];
$date1 = new DateTime($str);
$mbstr = $date1->format('d-m-Y');
$tgliuran= $fetch['iuran'];
$date2 = new DateTime($tgliuran);
$iuran= $date2->format('d-m-Y');
$tglmasuk= $fetch['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 $fetch['npa']?></td>
<td><?php echo $fetch['nmlead']?></td>
<td><?php echo $fetch['telp']?></td>
<td><?php echo $fetch['email']?></td>
<td><?php echo $fetch['password']?></td>
<td><?php echo $mbstr ?></td>
<td><?php echo $fetch['gambar']?></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{
?>
<?php echo $bukti ?>
<?php
}
?>
</td>
<td><?php echo $fetch['status2']?></td>
</tr>
<?php
$no++;
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</body>
</html>