| Server IP : 88.222.222.201 / 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 include "koneksi.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">
<h6 class="m-0 font-weight-bold text-primary">Iuran per Anggota</h6>
</div>
<?php
//$koneksi = mysqli_connect("localhost","bhaktiag_sales","cleosa2020","bhaktiag_sales");
//$koneksi = mysqli_connect("localhost","root","","agdsales");
?>
<center><h4>Data Pengajuan Rekomendasi Anggota IDI Kota Bandung</h4><center>
</p>
<body>
<div class="">
<div>
<!-- Tab panes -->
<div class="tab-content">
<div role="tabpanel" class="tab-pane active" id="home">
<h14> Data Rekomendasi Anggota IDI Bandung</h4>
<br>
<br>
<br>
<?php
$tglBayar = date('Y-m-d');
$bulanlalu=date('Y-m-d', strtotime('-1 month', strtotime( $tglBayar )));
?>
<div class="">
<?php
//$db_host = 'localhost';
//$db_port = '3306';
//$db_name = 'tutorial';
//$db_user = 'root';
//$db_pass = '';
//$conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name);
//if (!$conn) {
// die ('Gagal terhubung MySQL: ' . mysqli_connect_error());
//}
$sql = "
SELECT
IFNULL( perihal, 'SUB TOTAL' ) AS nama_sales,
IFNULL( kode, 'TOTAL' ) AS sales_tim,
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,
(jumlah) AS jml_trx,
SUM( bayar ) AS total_trx
FROM b_inv3 where validasi='valid' and stat_ang<>'non'
GROUP BY perihal
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>
<thead>
<tr>
<th rowspan="2">No</th>
<th rowspan="2">Jenis Transaksi</th>
<th rowspan="2">Kategori</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')
{
$val = number_format($val, '0', ',', '.');
}
echo '<td>' . $val . '</td>';
}
echo '</tr>';
}
echo '
</tbody>
</table>
</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>