| Server IP : 153.92.12.27 / 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 "koneksi.php";
session_start();
// 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:10px;
}
.tab-content{
font-size: 10px;
}
#home th,td{
font-size: 9px;
}
#home td{
font-size: 9px;
}
#rekomendasi td{
font-size: 10px;
}
#profile td{
font-size: 9px;
}
#pembinaan td{
font-size: 9px;
}
}
</style>
</head>
<body id="page-top">
<body>
<!-- Page Wrapper -->
<div id="wrapper">
<?php include "sidebar.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">
<?php
//$koneksi = mysqli_connect("localhost","bhaktiag_sales","cleosa2020","bhaktiag_sales");
//$koneksi = mysqli_connect("localhost","root","","agdsales");
?>
<center><h4>Data Transaksi Anggota Baru Iuran bulanan dalam satu Tahun Periode pencarian</h4><center>
</p>
<div class="">
<div class="container mt-4">
<!-- form filter data berdasarkan range tanggal -->
<form class="form-inline" action="" method="get">
<div class="row g-3 align-items-center">
<div class="col-auto">
<label class="col-form-label"> Cari Tahun : </label>
</div>
<div class="col-auto">
<select class="form-control" name="tahun">
<option value="2020"> 2020 </option>
<option value="2021"> 2021 </option>
<option value="2022">2022 </option>
<option value="2023">2023 </option>
<option value="2024">2024 </option>
<option value="2025">2025 </option>
<option value="2026">2026 </option>
<option value="2027">2027 </option>
</select>
</div>
<div class="col-auto">
<button class='btn btn-warning btn-sm' 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['tahun']) ){
$tahun = isset($_GET['tahun']) ? $_GET['tahun'] : null;
?>
<div role="tabpanel" class="tab-pane" id="pembinaan">
<h4> Rekap Data Penerimaan Pembinaan Anggota Baru </h4>
<br>
<br>
<?php
$sql = "
SELECT
IFNULL( nmlead, 'SUB TOTAL' ) AS nama_sales,
IFNULL( kta, 'TOTAL' ) AS sales_tim,
IFNULL( perbayar, 'TOTAL' ) AS periode,
IFNULL( periode, 'TOTAL' ) AS per_sisa,
SUM( IF( MONTH(tgl_bayar) = 1, bayar, 0) ) AS bln_januari,
COUNT( IF( MONTH(tgl_bayar) = 1, id_tagihan, NULL) ) AS trx_1,
SUM( IF( MONTH(tgl_bayar) = 2, bayar, 0) ) AS bln_februari,
COUNT( IF( MONTH(tgl_bayar) = 2, bayar, NULL) ) AS trx_2,
SUM( IF( MONTH(tgl_bayar) = 3, bayar, 0) ) AS bln_maret,
COUNT( IF( MONTH(tgl_bayar) = 3, bayar, NULL) ) AS trx_3,
SUM( IF( MONTH(tgl_bayar) = 4,bayar, 0) ) AS bln_april,
COUNT( IF( MONTH(tgl_bayar) = 4, bayar, NULL) ) AS trx_4,
SUM( IF( MONTH(tgl_bayar) = 5,bayar, 0) ) AS bln_mei,
COUNT( IF( MONTH(tgl_bayar) = 5, bayar, NULL) ) AS trx_5,
SUM( IF( MONTH(tgl_bayar) = 6,bayar, 0) ) AS bln_juni,
COUNT( IF( MONTH(tgl_bayar) = 6, bayar, NULL) ) AS trx_6,
SUM( IF( MONTH(tgl_bayar) = 7,bayar, 0) ) AS bln_juli,
COUNT( IF( MONTH(tgl_bayar) = 7, bayar, NULL) ) AS trx_7,
SUM( IF( MONTH(tgl_bayar) = 8,bayar, 0) ) AS bln_agustus,
COUNT( IF( MONTH(tgl_bayar) = 8, bayar, NULL) ) AS trx_8,
SUM( IF( MONTH(tgl_bayar) = 9,bayar, 0) ) AS bln_september,
COUNT( IF( MONTH(tgl_bayar) = 9, bayar, NULL) ) AS trx_9,
SUM( IF( MONTH(tgl_bayar) = 10,bayar, 0) ) AS bln_oktober,
COUNT( IF( MONTH(tgl_bayar) = 10, bayar, NULL) ) AS trx_10,
SUM( IF( MONTH(tgl_bayar) = 11,bayar, 0) ) AS bln_november,
COUNT( IF( MONTH(tgl_bayar) = 11, bayar, NULL) ) AS trx_11,
SUM( IF( MONTH(tgl_bayar) = 12,bayar, 0) ) AS bln_desember,
COUNT( IF( MONTH(tgl_bayar) = 12, bayar, NULL) ) AS trx_12,
COUNT(id_tagihan) AS jml_trx,
SUM( bayar ) AS total_trx
FROM iuran where YEAR(tgl_bayar)= '$tahun'
GROUP BY nmlead
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 tahun: $tahun 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="2">' . $bln[1] . '</th>';
$header_row2 .= '<th>Nilai</th>
<th>Trx</th>';
}
}
echo '<table>
<table class="table table-bordered">
<thead>
<tr>
<th rowspan="2">No</th>
<th rowspan="2">Jenis Transaksi</th>
<th rowspan="2">KTA + Gedung</th>
<th rowspan="2">Periode Bayar</th>
<th rowspan="2">Periode Sisa</th>
'. $header_row1 .'
<th rowspan="2">Jml Trx</th>
<th rowspan="2">Total Trx</th>
</tr>
<tr>'
. $header_row2 .
'</tr>
</thead>
<tbody>';
$no = 1;
foreach ($result as $array)
{
$class = '';
$print_no = $no;
if ($array['nama_sales'] == 'SUB TOTAL') {
$class = ' class="total"';
$print_no = '';
} else {
$no++;
}
echo '<tr'.$class.'>
<td>' . $print_no . '</td>';
foreach ($array as $key => $val)
{
if ($key !== 'nama_sales' && $key !== 'sales_tim' && $key !== 'periode'&& $key !== 'per_sisa')
{
$val = number_format($val, '0', ',', '.');
}
echo '<td>' . $val . '</td>';
}
echo '</tr>';
}
echo '
</tbody>
</table>
</body>
</html>';
}
?>
<?php
}else{
?>
<?php
$sql = "
SELECT
IFNULL( nmlead, 'SUB TOTAL' ) AS nama_sales,
IFNULL( kta, 'TOTAL' ) AS sales_tim,
IFNULL( perbayar, 'TOTAL' ) AS periode,
IFNULL( periode, 'TOTAL' ) AS per_sisa,
SUM( IF( MONTH(tgl_bayar) = 1, bayar, 0) ) AS bln_januari,
COUNT( IF( MONTH(tgl_bayar) = 1, id_tagihan, NULL) ) AS trx_1,
SUM( IF( MONTH(tgl_bayar) = 2, bayar, 0) ) AS bln_februari,
COUNT( IF( MONTH(tgl_bayar) = 2, bayar, NULL) ) AS trx_2,
SUM( IF( MONTH(tgl_bayar) = 3, bayar, 0) ) AS bln_maret,
COUNT( IF( MONTH(tgl_bayar) = 3, bayar, NULL) ) AS trx_3,
SUM( IF( MONTH(tgl_bayar) = 4,bayar, 0) ) AS bln_april,
COUNT( IF( MONTH(tgl_bayar) = 4, bayar, NULL) ) AS trx_4,
SUM( IF( MONTH(tgl_bayar) = 5,bayar, 0) ) AS bln_mei,
COUNT( IF( MONTH(tgl_bayar) = 5, bayar, NULL) ) AS trx_5,
SUM( IF( MONTH(tgl_bayar) = 6,bayar, 0) ) AS bln_juni,
COUNT( IF( MONTH(tgl_bayar) = 6, bayar, NULL) ) AS trx_6,
SUM( IF( MONTH(tgl_bayar) = 7,bayar, 0) ) AS bln_juli,
COUNT( IF( MONTH(tgl_bayar) = 7, bayar, NULL) ) AS trx_7,
SUM( IF( MONTH(tgl_bayar) = 8,bayar, 0) ) AS bln_agustus,
COUNT( IF( MONTH(tgl_bayar) = 8, bayar, NULL) ) AS trx_8,
SUM( IF( MONTH(tgl_bayar) = 9,bayar, 0) ) AS bln_september,
COUNT( IF( MONTH(tgl_bayar) = 9, bayar, NULL) ) AS trx_9,
SUM( IF( MONTH(tgl_bayar) = 10,bayar, 0) ) AS bln_oktober,
COUNT( IF( MONTH(tgl_bayar) = 10, bayar, NULL) ) AS trx_10,
SUM( IF( MONTH(tgl_bayar) = 11,bayar, 0) ) AS bln_november,
COUNT( IF( MONTH(tgl_bayar) = 11, bayar, NULL) ) AS trx_11,
SUM( IF( MONTH(tgl_bayar) = 12,bayar, 0) ) AS bln_desember,
COUNT( IF( MONTH(tgl_bayar) = 12, bayar, NULL) ) AS trx_12,
COUNT(id_tagihan) AS jml_trx,
SUM( bayar ) AS total_trx
FROM iuran where YEAR(tgl_bayar)= '2022'
GROUP BY nmlead
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="2">' . $bln[1] . '</th>';
$header_row2 .= '<th>Nilai</th>
<th>Trx</th>';
}
}
echo '<table>
<table class="table table-bordered">
<thead>
<tr>
<th rowspan="2">No</th>
<th rowspan="2">Jenis Transaksi</th>
<th rowspan="2">KTA + Gedung</th>
<th rowspan="2">Periode Bayar</th>
<th rowspan="2">Periode Sisa</th>
'. $header_row1 .'
<th rowspan="2">Jml Trx</th>
<th rowspan="2">Total Trx</th>
</tr>
<tr>'
. $header_row2 .
'</tr>
</thead>
<tbody>';
$no = 1;
foreach ($result as $array)
{
$class = '';
$print_no = $no;
if ($array['nama_sales'] == 'SUB TOTAL') {
$class = ' class="total"';
$print_no = '';
} else {
$no++;
}
echo '<tr'.$class.'>
<td>' . $print_no . '</td>';
foreach ($array as $key => $val)
{
if ($key !== 'nama_sales' && $key !== 'sales_tim' && $key !== 'periode'&& $key !== 'per_sisa')
{
$val = number_format($val, '0', ',', '.');
}
echo '<td>' . $val . '</td>';
}
echo '</tr>';
}
echo '
</tbody>
</table>
</body>
</html>';
?>
<?php
}
?>
</div>
</div>
</div>
</div>
</body>
</html>
</div>
<!-- proses edit data -->
</div>
<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>
</body>
</html>