| Server IP : 88.223.91.23 / 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">Lap Keuangan</h6>
</div>
<?php
//$koneksi = mysqli_connect("localhost","bhaktiag_sales","cleosa2020","bhaktiag_sales");
//$koneksi = mysqli_connect("localhost","root","","agdsales");
?>
<center><h4>Data Rekap Iuran Bulanan <br>
Anggota IDI Kota Bandung</h4><center>
</p>
<br>
<br>
<body>
<center>
<a target="_blank" href="#expdata_ang3.php">Export Ke EXCEL Lap Rekap Iuran Bulanan</a>
</center>
<div class="">
<div>
<!-- Tab panes -->
<div class="tab-content">
<div role="tabpanel" class="tab-pane active" id="home">
<h14> Data IUran Anggota IDI Bandung</h4>
<br>
<br>
<br>
<script type="text/javascript" src="Chart.js"></script>
<center><h4>Grafik Pembayaran Iuran Bulan</h4></center>
<div style="width: 350px;margin: 0px auto;">
<canvas id="myChart2"></canvas>
</div>
<br><br>
<br>
<?php
//$produk = mysqli_query($konek,"select count(month(b_inv3.tgl_bayar)) as total,month(b_inv3.tgl_bayar) as bulan,h_registrasi.tgl_reg,h_registrasi.perihal,b_inv3.tgl_bayar
// FROM h_registrasi JOIN b_inv3 ON h_registrasi.noreg=b_inv3.noreg
// where h_registrasi.tgl_reg >'2022-01-01' and h_registrasi.status2='finish'
// AND h_registrasi.perihal<>'mutasi' AND h_registrasi.perihal<>'kehilangan'
// group by bulan ");
//$produk = mysqli_query($konek,"select count(month(b_inv3.tgl_bayar)) as total,month(b_inv3.tgl_bayar) as bulan,h_registrasi.tgl_reg,h_registrasi.perihal,b_inv3.tgl_bayar
// FROM h_registrasi JOIN b_inv3 ON h_registrasi.noreg=b_inv3.noreg
// where h_registrasi.tgl_reg >'2022-01-01' and h_registrasi.status2='finish'
// AND h_registrasi.perihal<>'mutasi' AND h_registrasi.perihal<>'kehilangan'
// group by bulan ");
$produk = mysqli_query($konek,"select count(month(jatuhtempo)) as total,month(jatuhtempo) as bulan3,jatuhtempo,bulan,tahun
FROM d_bulan where tahun='2022' AND
status='valid'
group by bulan3 order by jatuhtempo ASC");
//$produk = mysqli_query($konek,"select kode,count((IF(kode='Hot Prospek',0,NULL))) as total from d_nonspp where kode <> 'Close' group by project order by kode ");
while($row2 = mysqli_fetch_array($produk)){
$bulan2= date('M', strtotime($row2['jatuhtempo']));
$nama_produk2[] = $bulan2;
$total2[] = $row2['total'];
}
?>
<script>
var ctx = document.getElementById("myChart2").getContext('2d');
var myChart = new Chart(ctx, {
type: 'bar',
data: {
labels: <?php echo json_encode($nama_produk2); ?>,
datasets: [{
label: 'Grafik Pembayaran Iuran - Perbulan Bayar Iuran',
data: <?php echo json_encode($total2); ?>,
backgroundColor: [
'rgba(255, 99, 132, 0.2)',
'rgba(54, 162, 235, 0.2)',
'rgba(255, 206, 86, 0.2)',
'rgba(75, 192, 192, 0.2)',
'rgba(153, 102, 255, 0.2)',
'rgba(255, 159, 64, 0.2)',
'rgba(255, 99, 132, 0.2)',
'rgba(54, 162, 235, 0.2)',
'rgba(255, 206, 86, 0.2)',
'rgba(75, 192, 192, 0.2)',
'rgba(153, 102, 255, 0.2)',
'rgba(255, 159, 64, 0.2)'
],
borderColor: [
'rgba(255,99,132,1)',
'rgba(54, 162, 235, 1)',
'rgba(255, 206, 86, 1)',
'rgba(25, 206, 86, 1)',
'rgba(75, 192, 192, 1)',
'rgba(255,99,132,1)',
'rgba(54, 162, 235, 1)',
'rgba(255, 206, 86, 1)',
'rgba(25, 206, 86, 1)',
'rgba(75, 192, 192, 1)'
],
borderWidth: 1
}]
},
options: {
scales: {
yAxes: [{
ticks: {
beginAtZero:true
}
}]
}
}
});
</script>
<?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( nama, 'SUB TOTAL' ) AS nama_sales,
SUM( IF( MONTH(jatuhtempo) = 1, jumlah, 0) ) AS bln_januari,
COUNT( IF( MONTH(jatuhtempo) = 1, jumlah, NULL) ) AS trx_1,
SUM( IF( MONTH(jatuhtempo) = 2, jumlah, 0) ) AS bln_februari,
COUNT( IF( MONTH(jatuhtempo) = 2, jumlah, NULL) ) AS trx_2,
SUM( IF( MONTH(jatuhtempo) = 3, jumlah, 0) ) AS bln_maret,
COUNT( IF( MONTH(jatuhtempo) = 3, jumlah, NULL) ) AS trx_3,
SUM( IF( MONTH(jatuhtempo) = 4,jumlah, 0) ) AS bln_april,
COUNT( IF( MONTH(jatuhtempo) = 4, jumlah, NULL) ) AS trx_4,
SUM( IF( MONTH(jatuhtempo) = 5,jumlah, 0) ) AS bln_mei,
COUNT( IF( MONTH(jatuhtempo) = 5, jumlah, NULL) ) AS trx_5,
SUM( IF( MONTH(jatuhtempo) = 6,jumlah, 0) ) AS bln_juni,
COUNT( IF( MONTH(jatuhtempo) = 6, jumlah, NULL) ) AS trx_6,
SUM( IF( MONTH(jatuhtempo) = 7,jumlah, 0) ) AS bln_juli,
COUNT( IF( MONTH(jatuhtempo) = 7, jumlah, NULL) ) AS trx_7,
SUM( IF( MONTH(jatuhtempo) = 8,jumlah, 0) ) AS bln_agustus,
COUNT( IF( MONTH(jatuhtempo) = 8, jumlah, NULL) ) AS trx_8,
SUM( IF( MONTH(jatuhtempo) = 9,jumlah, 0) ) AS bln_september,
COUNT( IF( MONTH(jatuhtempo) = 9, jumlah, NULL) ) AS trx_9,
SUM( IF( MONTH(jatuhtempo) = 10,jumlah, 0) ) AS bln_oktober,
COUNT( IF( MONTH(jatuhtempo) = 10, jumlah, NULL) ) AS trx_10,
SUM( IF( MONTH(jatuhtempo) = 11,jumlah, 0) ) AS bln_november,
COUNT( IF( MONTH(jatuhtempo) = 11, jumlah, NULL) ) AS trx_11,
SUM( IF( MONTH(jatuhtempo) = 12,jumlah, 0) ) AS bln_desember,
COUNT( IF( MONTH(jatuhtempo) = 12, jumlah, NULL) ) AS trx_12,
count(jumlah) AS jml_trx,
SUM( jumlah ) AS total_trx
FROM d_bulan where tahun='2022'
GROUP BY nama
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">Nama Anggota</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>';
?>
<br><br><br><br>
</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>