error_reporting(-1);
include 'settings.php';
include 'login.php';
include 'fungsi.php';
include 'session.php';
$id = $_GET["id"];
$query = mysqli_query($connection, "select * from bps where id like '{$id}' limit 1");
$row = mysqli_fetch_array($query);
$npwp = formatnpwp($row["npwp"]);
$namawp = strtoupper($row["namawp"]);
$tanggalterima = converttanggal($row["tanggalterima"]);
$jenisspt = jenisspt($row["jenisspt"]);
$kodespt = kodespt($row["jenisspt"]);
$tahunpajak = $row["tahunpajak"];
$statusbayar = statusbayar($row["statusbayar"]);
$nominal = formatrupiah($row["nominal"]);
$nominalcurr = nominalcurr($row["nominalcurr"]);
$tanggalbayar = $row["tanggalbayar"];
$reskom = reskom($row["reskom"]);
$pembetulan = $row["pembetulan"];
$angsuranps25 = $row["angsuranps25"];
$espt = $row["espt"];
$perekam = $row["perekam"];
$nipperekam = cariperekam($perekam);
$namaperekam = carinamaperekam($perekam);
$nomorbps = str_pad($row["nomorbps"], 8, '0', STR_PAD_LEFT);
?>
<html>
<head>
<meta charset="utf-8">
<?php
error_reporting(-1);
include 'settings.php';
include 'login.php';
include 'fungsi.php';
include 'session.php';
$nipperekam = cariperekam($login_nip);
$namaperekam = carinamaperekam($login_nip);
$tanggalterima = $_GET["tanggalterima"];
$query = mysqli_query($connection, "select tanggalterima, count(nomorbps) as jumlah from bps where tanggalterima = '{$tanggalterima}'");
$row = mysqli_fetch_array($query);
$jumlah = formatrupiah($row["jumlah"]);
$tanggalpanjang = convertbulan($tanggalterima);
?>
<html>
<head>
<title></title>
<style>
body {
font-family: arial;
}
td {
vertical-align: top;
}
</style>
</head>
<body>
<p align="center">
KEMENTERIAN KEUANGAN REPUBLIK INDONESIA
</tfoot>
<tbody>
<?php
$query = mysqli_query($connection, "select tanggalterima, count(nomorbps) as jumlah from bps where perekam = '{$login_nip}' group by tanggalterima");
while ($row = mysqli_fetch_array($query)) {
$tanggalterima = converttanggal($row["tanggalterima"]);
$jumlah = formatrupiah($row["jumlah"]);
$querynihil = mysqli_query($connection, "select count(nomorbps) as jumlah from bps where statusbayar = '1' and perekam = '{$login_nip}' and tanggalterima = '{$row['tanggalterima']}'");
$rownihil = mysqli_fetch_array($querynihil);
$nihil = formatrupiah($rownihil["jumlah"]);
$querykb = mysqli_query($connection, "select count(nomorbps) as jumlah from bps where statusbayar = '2' and perekam = '{$login_nip}' and tanggalterima = '{$row['tanggalterima']}'");
$rowkb = mysqli_fetch_array($querykb);
$kb = formatrupiah($rowkb["jumlah"]);
$querylb = mysqli_query($connection, "select count(nomorbps) as jumlah from bps where statusbayar = '3' and perekam = '{$login_nip}' and tanggalterima = '{$row['tanggalterima']}'");
$rowlb = mysqli_fetch_array($querylb);
$lb = formatrupiah($rowlb["jumlah"]);
echo '
<tr>
<td class="text-center">' . $tanggalterima . '</td>
<td class="text-center">' . $nihil . '</td>
<td class="text-center">' . $kb . '</td>
<td class="text-center">' . $lb . '</td>
<td class="text-center">' . $jumlah . '</td>
<td class="text-center"><a href=register.php?tanggalterima=' . $row["tanggalterima"] . ' target="_blank">Cetak</td>
</tr>';
}
?>
</tbody>
</table>
</div>
