| Server IP : 84.32.84.1 / 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 : |
<html>
<head>
<title>Latihan Pencarian Tanggal</title>
<!-- 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">
<style type="text/css">
body{
font-family: roboto;
font-size:11px;
}
table {
margin: 0 auto;
border-collapse: collapse;
}
tbody {
color: #000;
}
table td {
padding: 5px 10px;
border: 1px solid #e0e0e0;
font: normal 10px Tahoma, Geneva, sans-serif;
}
table tr {
font: normal 11px Tahoma, Geneva, sans-serif;
}
/* untuk ukuran layar 700px kebawah */
@media screen and (max-width: 780px) {
.header,
.footer{
text-align: center;
}
.left {
width: auto;
float: none;
}
.middle {
width: auto;
float: none;
}
.right {
width: auto;
float: none;
}
}
</style>
</head>
<body>
<?php
include "koneksi.php";
$tglBayar = date('2022-12-31');
$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="pemb_bulanan.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>
<div class="card">
<br><br><br>
<?php
$dari2= isset($_GET['dari']) ? $_GET['dari'] : null;
$ke2= isset($_GET['ke']) ? $_GET['ke'] : null;
$date = new DateTime($dari2);
$dari = $date->format('d-m-Y');
$date = new DateTime($ke2);
$ke = $date->format('d-m-Y');
?>
<center><h4><b>Hasil Pencarian : <?php echo $dari ?> s/d <?php echo $ke ?> </b></h4> </center>
<div class="card-body">
<table class="table table-striped">
<thead>
<tr>
<th>No</th>
<th>Validasi</th>
<th>Januari</th>
<th>Februari</th>
<th>Maret</th>
<th>April</th>
<th>Mei</th>
<th>Juni</th>
<th>Juli</th>
<th>Agustus</th>
<th>September</th>
<th>Oktober</th>
<th>November</th>
<th>Desember</th>
<th>Jumlah</th>
<th>Total</th>
</tr>
</thead>
<?php
//jika tanggal dari dan tanggal ke ada maka
if(isset($_GET['dari']) && isset($_GET['ke'])){
// tampilkan data yang sesuai dengan range tanggal yang dicari
$data= $konek->query("SELECT
IFNULL( nama, 'SUB TOTAL' ) AS nama_sales,
SUM( IF( MONTH(jatuhtempo) = 1, jumlah, 0) ) AS bln_januari,
SUM( IF( MONTH(jatuhtempo) = 2, jumlah, 0) ) AS bln_februari,
SUM( IF( MONTH(jatuhtempo) = 3, jumlah, 0) ) AS bln_maret,
SUM( IF( MONTH(jatuhtempo) = 4,jumlah, 0) ) AS bln_april,
SUM( IF( MONTH(jatuhtempo) = 5,jumlah, 0) ) AS bln_mei,
SUM( IF( MONTH(jatuhtempo) = 6,jumlah, 0) ) AS bln_juni,
SUM( IF( MONTH(jatuhtempo) = 7,jumlah, 0) ) AS bln_juli,
SUM( IF( MONTH(jatuhtempo) = 8,jumlah, 0) ) AS bln_agustus,
SUM( IF( MONTH(jatuhtempo) = 9,jumlah, 0) ) AS bln_september,
SUM( IF( MONTH(jatuhtempo) = 10,jumlah, 0) ) AS bln_oktober,
SUM( IF( MONTH(jatuhtempo) = 11,jumlah, 0) ) AS bln_november,
SUM( IF( MONTH(jatuhtempo) = 12,jumlah, 0) ) AS bln_desember,
count(jumlah) AS jml_trx,
SUM( jumlah ) AS total_trx
FROM d_bulannon
WHERE jatuhtempo BETWEEN '".$_GET['dari']."' and '".$_GET['ke']."'
GROUP BY nama
WITH ROLLUP ");
}else{
//jika tidak ada tanggal dari dan tanggal ke maka tampilkan seluruh data
$data= $konek->query("SELECT
IFNULL( nama, 'SUB TOTAL' ) AS nama_sales,
SUM( IF( MONTH(jatuhtempo) = 1, jumlah, 0) ) AS bln_januari,
SUM( IF( MONTH(jatuhtempo) = 2, jumlah, 0) ) AS bln_februari,
SUM( IF( MONTH(jatuhtempo) = 3, jumlah, 0) ) AS bln_maret,
SUM( IF( MONTH(jatuhtempo) = 4,jumlah, 0) ) AS bln_april,
SUM( IF( MONTH(jatuhtempo) = 5,jumlah, 0) ) AS bln_mei,
SUM( IF( MONTH(jatuhtempo) = 6,jumlah, 0) ) AS bln_juni,
SUM( IF( MONTH(jatuhtempo) = 7,jumlah, 0) ) AS bln_juli,
SUM( IF( MONTH(jatuhtempo) = 8,jumlah, 0) ) AS bln_agustus,
SUM( IF( MONTH(jatuhtempo) = 9,jumlah, 0) ) AS bln_september,
SUM( IF( MONTH(jatuhtempo) = 10,jumlah, 0) ) AS bln_oktober,
SUM( IF( MONTH(jatuhtempo) = 11,jumlah, 0) ) AS bln_november,
SUM( IF( MONTH(jatuhtempo) = 12,jumlah, 0) ) AS bln_desember,
count(jumlah) AS jml_trx,
SUM( jumlah ) AS total_trx
FROM d_bulannon
GROUP BY nama
WITH ROLLUP ");
}
// $no digunakan sebagai penomoran
$no = 1;
// while digunakan sebagai perulangan data
while($fetch = $data->fetch_array()){
$nama_sales= $fetch['nama_sales'];
?>
<tr>
<td><?php echo $no++; ?></td>
<td><?php echo $nama_sales ?></td>
<td><?php echo $fetch['bln_januari']?></td>
<td><?php echo $fetch['bln_februari']?></td>
<td><?php echo $fetch['bln_maret']?></td>
<td><?php echo $fetch['bln_april']?></td>
<td><?php echo $fetch['bln_mei']?></td>
<td><?php echo $fetch['bln_juni']?></td>
<td><?php echo $fetch['bln_juli']?></td>
<td><?php echo $fetch['bln_agustus']?></td>
<td><?php echo $fetch['bln_september']?></td>
<td><?php echo $fetch['bln_oktober']?></td>
<td><?php echo $fetch['bln_november']?></td>
<td><?php echo $fetch['bln_desember']?></td>
<td><?php echo $fetch['jml_trx']?></td>
<td><?php echo $fetch['total_trx']?></td>
</tr>
<?php } ?>
</table>
</div>
</div>
</div>
</body>
</html>