| Server IP : 88.223.91.77 / 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 include "header.php";
// cek apakah yang mengakses halaman ini sudah login
if($_SESSION['status']<>"login"){
header("location:location:../login.php");
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="description" content="">
<meta name="author" content="">
<head>
<title>IDI | List Kategori</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>
body{
background: #dedede;
font-family: 'Helvetica', arial, sans-serif;
font-size: 10px;
}
.table th,
.table td {
padding: 5px 5px;
font-size:12px;
}
.tab-content{
font-size: 10px;
}
#home th,td{
font-size: 9px;
}
#home td{
font-size: 9px;
}
}
</style>
<!-- bootstrap cdn -->
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta3/dist/css/bootstrap.min.css" rel="stylesheet"
integrity="sha384-eOJMYsd53ii+scO/bJGFsiCZc+5NDVN2yr8+0RDqr0Ql0h+rP48ckxlpbzKgwra6" crossorigin="anonymous">
</head>
<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">Revisi Iuran by Anggota VALID</h6>
</div>
<div class="card-body">
<div class="table-responsive">
<?php
//$koneksi = mysqli_connect("localhost","bhaktiag_sales","cleosa2020","bhaktiag_sales");
//$koneksi = mysqli_connect("localhost","root","","agdsales");
?>
<center><h4>Data Revisi Iuran by Anggota VALID</h4><center>
</p>
<body>
<div class="">
<div>
<!-- Tab panes -->
<div class="tab-content">
<div role="tabpanel" class="tab-pane active" id="home">
<h14> Data Revisi Iuran by Anggota VALID</h4>
<br>
<br>
<br>
<?php
$tglBayar = date('Y-m-d');
$tglBayar2 = date('2022-02-01');
$bulanlalu=date('Y-m-d', strtotime('-1 month', strtotime( $tglBayar2 )));
?>
<div class="container mt-4">
<!-- form filter data berdasarkan range tanggal -->
<form action="lap_iuran_rev.php" method="get">
<div class="row g-3 align-items-center">
<div class="col-auto">
<label class="col-form-label">Periode</label>
</div>
<div class="col-auto">
<input type="date" class="form-control" name="dari" value ="<?php echo $bulanlalu ?>" required>
</div>
<div class="col-auto">
-
</div>
<div class="col-auto">
<input type="date" class="form-control" name="ke" value ="<?php echo $tglBayar ?>" required>
</div>
<div class="col-auto">
<button class="btn btn-primary" type="submit">Cari</button>
</div>
</div>
</form>
</p> </p> </p>
</p> </p> </p>
<?php
//jika tanggal dari dan tanggal ke ada maka
if(isset($_GET['dari']) && isset($_GET['ke'])){
$dari = isset($_GET['dari']) ? $_GET['dari'] : null;
$sampai = isset($_GET['ke']) ? $_GET['ke'] : null;
// $dari=$_GET['dari'];
// $sampai=$_GET['ke'];
$sql = "
SELECT
IFNULL( nmlead, 'SUB TOTAL' ) AS nmlead,
IFNULL( npm, 'TOTAL' ) AS npm,
IFNULL( tglbayar_iur, 'TOTAL' ) AS sales_tim,
IFNULL( npa, 'TOTAL' ) AS npa,
IFNULL( mbstr, 'TOTAL' ) AS mbstr,
( awalmbstr) AS tgl_awal,
( tgliuran) AS tgl_akhir,
IFNULL( periode, 'TOTAL' ) AS periode,
SUM(nominal_iur) AS bln_bayar,
SUM(nominal_iur) AS total_trx
FROM h_anggota
where tglbayar_iur between '$dari' and '$sampai' AND validasi='valid'
GROUP BY npm
WITH ROLLUP
";
$query = mysqli_query($konek, $sql);
$result = mysqli_fetch_all($query,MYSQLI_ASSOC);
//jika pencarian data tidak ditemukan
if(mysqli_num_rows($query)==0){
echo "<font color=red><blink> Pencarian data dari Tanggal: $dari sampai Tanggal : $sampai,tidak ditemukan!</blink></font>";
}else{
echo '<html>
<head>
<title>Pivot Table Dengan PHP dan MySQL</title>
<style>
body {font-family:"open sans", "segoe ui", tahoma, arial}
table {border-collapse: collapse}
.total td {background-color: #f5f5f5 !important;}
.right{text-align: right}
table tr:nth-child(odd) td {
background-color: #fbfbfb;
border-bottom: 1px solid #efefef;
border-top: 1px solid #ececec;
}
table th {
color: #616161;
margin: 0;
padding: 10px 10px;
border: 1px solid #e4e4e4;
text-align: center;
font-size: 14px;
text-transform: uppercase;
background: #efefef;
}
table td {
border-right: 1px solid #ececec;
border-left: 1px solid #ececec;
padding: 7px 15px;
color: #676767;
font-size: 14px;
}
table td:nth-child(n+3) {
text-align: right;
}
</style>
</head>
<body>';
$header_row1 = $header_row2 = '';
foreach ($result[0] as $key => $val)
{
if (strpos($key, 'bln_') !== false)
{
$bln = explode('_', $key);
$header_row1 .= '<th colspan="1">' . $bln[1] . '</th>';
$header_row2 .= '<th>Nilai</th>
';
}
}
echo '
<input class="form-control" id="posSearch" type="text" placeholder="Cari..">
<br>
<table>
<table class="table table-bordered">
<thead>
<tr>
<th rowspan="2">No</th>
<th rowspan="2">Nama Anggota</th>
<th rowspan="2">No Invoice</th>
<th rowspan="2">Tanggal Bayar</th>
<th rowspan="2">NPA</th>
<th rowspan="2">Masa Berlaku STR</th>
<th rowspan="2">Awal Iuran</th>
<th rowspan="2">Akhir Iuran</th>
<th rowspan="2">Periode Bulan</th>
<th rowspan="2">Status</th>
'. $header_row1 .'
<th rowspan="2">Total</th>
</tr>
</thead>
<tbody id="posTable">';
$no = 1;
foreach ($result as $array)
{
$class = '';
$print_no = $no;
if ($array['nmlead'] == 'SUB TOTAL') {
$class = ' class="total"';
$print_no = '';
} else {
$no++;
}
echo '<tr'.$class.'>
<td>' . $print_no . '</td>';
foreach ($array as $key => $val)
{
if ($key !== 'nmlead' && $key !== 'sales_tim' && $key !== 'npa'&& $key !== 'status' && $key !== 'npm'&& $key !== 'mbstr'&& $key !== 'tgl_awal' && $key !== 'tgl_akhir' && $key !== 'periode')
{
$val = number_format($val, '0', ',', '.');
}
echo '<td>' . $val . '</td>';
}
?>
<td> <a href='rekomendasi.php?npm=<?php echo $npm ?>'> cek</a></td>
<?php
echo '</tr>';
}
echo '
</tbody>
</table>
</body>
</html>';
}
?>
<?php
}else{
//jika tidak ada tanggal dari dan tanggal ke maka tampilkan seluruh data
$sql = "
SELECT
IFNULL( nmlead, 'SUB TOTAL' ) AS nmlead,
IFNULL( npm, 'TOTAL' ) AS npm,
IFNULL( tglbayar_iur, 'TOTAL' ) AS sales_tim,
IFNULL( npa, 'TOTAL' ) AS npa,
IFNULL( mbstr, 'TOTAL' ) AS mbstr,
( awalmbstr) AS tgl_awal,
( tgliuran) AS tgl_akhir,
IFNULL( periode, 'TOTAL' ) AS periode,
SUM(nominal_iur) AS bln_bayar,
SUM(nominal_iur) AS total_trx
FROM h_anggota where validasi='valid'
GROUP BY npm
WITH ROLLUP
";
$query = mysqli_query($konek, $sql);
$result = mysqli_fetch_all($query,MYSQLI_ASSOC);
echo '<html>
<head>
<title>Pivot Table Dengan PHP dan MySQL</title>
<style>
body {font-family:"open sans", "segoe ui", tahoma, arial}
table {border-collapse: collapse}
.total td {background-color: #f5f5f5 !important;}
.right{text-align: right}
table tr:nth-child(odd) td {
background-color: #fbfbfb;
border-bottom: 1px solid #efefef;
border-top: 1px solid #ececec;
}
table th {
color: #616161;
margin: 0;
padding: 10px 10px;
border: 1px solid #e4e4e4;
text-align: center;
font-size: 14px;
text-transform: uppercase;
background: #efefef;
}
table td {
border-right: 1px solid #ececec;
border-left: 1px solid #ececec;
padding: 7px 15px;
color: #676767;
font-size: 14px;
}
table td:nth-child(n+3) {
text-align: right;
}
</style>
</head>
<body>';
$header_row1 = $header_row2 = '';
foreach ($result[0] as $key => $val)
{
if (strpos($key, 'bln_') !== false)
{
$bln = explode('_', $key);
$header_row1 .= '<th colspan="1">' . $bln[1] . '</th>';
$header_row2 .= '<th>Nilai</th>
';
}
}
echo '
<input class="form-control" id="posSearch" type="text" placeholder="Cari..">
<br>
<table>
<table class="table table-bordered">
<thead>
<tr>
<th rowspan="2">No</th>
<th rowspan="2">Nama Anggota</th>
<th rowspan="2">ID Anggota</th>
<th rowspan="2">Tanggal Bayar</th>
<th rowspan="2">NPA</th>
<th rowspan="2">Masa Berlaku STR</th>
<th rowspan="2">Awal Iuran</th>
<th rowspan="2">Akhir Iuran</th>
<th rowspan="2">Periode Bulan</th>
'
. $header_row1 .
'
<th rowspan="2">Total</th>
</tr>
</thead>
<tbody id="posTable">';
$no = 1;
foreach ($result as $array)
{
$class = '';
$print_no = $no;
if ($array['nmlead'] == 'SUB TOTAL') {
$class = ' class="total"';
$print_no = '';
} else {
$no++;
}
echo '<tr'.$class.'>
<td>' . $print_no . '</td>';
foreach ($array as $key => $val)
{
if ($key !== 'nmlead' && $key !== 'npm' && $key !== 'sales_tim' && $key !== 'npa'&& $key !== 'status'
&& $key !== 'mbstr' && $key !== 'tgl_awal' && $key !== 'tgl_akhir' && $key !== 'periode')
{
$val = number_format($val, '0', ',', '.');
}
echo '<td>' . $val . '</td>';
}
?>
<td> <a href='rekomendasi.php?npm=<?php echo $npm ?>'> cek</a></td>
<?php
echo '</tr>';
}
echo '
</tbody>
</table>
</body>
</html>';
}
?>
</div>
</div>
</div>
</div>
</body>
</html>
</div>
<!-- proses edit data -->
</div>
<!--Script Javascript-->
<script>
$(document).ready(function(){
$("#posSearch").on("keyup", function() {
var value = $(this).val().toLowerCase();
$("#posTable tr").filter(function() {
$(this).toggle($(this).text().toLowerCase().indexOf(value) > -1)
});
});
});
</script>
</div>
</div>
</div>
</div>
</body>
</html>