<?php
session_start();
if (empty($_SESSION['loginku'])) {
header("Location: login");
}
require 'koneksi.php';
require 'function.php';
include 'header.php';
$now = date("Y-m-d");
?>
<?php include 'navbar.php' ?>
<body style="background-color: #f7f7f7">
<div class="container-fluid mt-3 mb-5 pb-5">
<div class="alert alert-danger">
<i class="fa-solid fa-circle-info text-danger"></i> Untuk laporan harian/tanggal yang AutoSUM buka menu Orderan/Pengeluaran & pilih tanggal
</div>
<!-- Trigger Button -->
<button type="button" class="btn btn-primary mb-3" data-bs-toggle="modal" data-bs-target="#laporMOD">
<img src="gambar/play.png" alt="" width="25px"> Memahami laporan
</button>
<div class="row">
<!-- Kolom 1: Total Provit -->
<div class="col-lg-6 mb-3">
<div class="card shadow-sm border-0 text-white bg-success card-round">
<div class="card-body d-flex justify-content-between align-items-start">
<div>
<small class="text-white-50">Total Profit</small>
<p class="card-text display-4 mb-0">
<?php
$total_provit = 0;
$d_invoice = mysqli_query($kon, "SELECT provit FROM invoice WHERE resto='$_SESSION[resto]' AND status='selesai' ");
while ($l_invoice = mysqli_fetch_array($d_invoice)) {
$total_provit += $l_invoice['provit'];
}
?>
Rp <?= number_format($total_provit, 0, ',', '.') ?>
</p>
</div>
<div class="text-end">
<small>lifetime <i class="fa-solid fa-chart-simple text-white-50"></i></small>
<div><i class="bi bi-bar-chart-line-fill" style="font-size: 2rem;"></i></div>
</div>
</div>
</div>
</div>
<!-- Kolom 2: Total Gaji -->
<div class="col-lg-6 mb-3">
<div class="card shadow-sm border-0 text-white bg-danger card-round">
<div class="card-body d-flex justify-content-between align-items-start">
<div>
<small class="text-white-50">Total Gaji</small>
<p class="card-text display-4 mb-0">
<?php
$total_gaji = 0;
$d_gaji = mysqli_query($kon, "SELECT nominal FROM gajih");
while ($l_gaji = mysqli_fetch_array($d_gaji)) {
$total_gaji += $l_gaji['nominal'];
}
?>
Rp <?= number_format($total_gaji, 0, ',', '.') ?>
</p>
</div>
<div class="text-end">
<small>lifetime <i class="fa-solid fa-money-bill-trend-up text-white-50"></i></small>
<div><i class="bi bi-cash-stack" style="font-size: 2rem;"></i></div>
</div>
</div>
</div>
</div>
<div class="col-lg-12">
<!-- Modal pengunaan promo -->
<div class="modal fade" id="laporMOD" tabindex="-1" aria-labelledby="laporMODLabel" aria-hidden="true">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="laporMODLabel">Memahami laporan</h5>
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<div class="modal-body">
<center>
<iframe width="660" height="315" src="https://www.youtube.com/embed/3rYoRKJmr30?si=oxzZgz4LO4avf349" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe>
</center>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Tutup</button>
</div>
</div>
</div>
</div>
<div class="row d-flex mb-3">
<div class="col-lg-6 mb-3">
<div class="card card-body card-round">
<?php
$orderan = mysqli_query($kon, "SELECT * FROM invoice WHERE resto='$_SESSION[resto]' ");
?>
<h5><b><?= mysqli_num_rows($orderan); ?></b></h5>
<div class="row">
<div class="col-6">
<small>Total orderan</small>
</div>
<div class="col-6 text-right">
<small>lifetime <i class="fa-solid fa-chart-simple text-success"></i></small>
</div>
</div>
</div>
</div>
<div class="col-lg-6 mb-3">
<div class="card card-body card-round">
<?php
$d_void = mysqli_query($kon, "SELECT * FROM invoice WHERE void='ya' AND resto='$_SESSION[resto]' ");
?>
<h5><b><?= mysqli_num_rows($d_void); ?></b></h5>
<div class="row">
<div class="col-9">
<small>Void</small>
</div>
<div class="col-3 text-right">
<small>lifetime <i class="fa-solid fa-chart-simple text-success"></i></small>
</div>
</div>
</div>
</div>
<div class="col-lg-6 mb-3">
<div class="card card-body card-round">
<?php
$rtotal_total = 0;
$d_invoice = mysqli_query($kon, "SELECT realtotal FROM invoice WHERE resto='$_SESSION[resto]' AND status='Selesai' ");
while ($l_invoice = mysqli_fetch_array($d_invoice)) {
$rtotal_total += $l_invoice['realtotal'];
}
?>
<h5><b>Rp. <?= number_format($rtotal_total, 0, ',', '.') ?></b></h5>
<div class="row">
<div class="col-6">
<small>Realtotal (Income jika tidak kena diskon / kupon)</small>
</div>
<div class="col-6 text-right">
<small>lifetime <i class="fa-solid fa-chart-simple text-success"></i></small>
</div>
</div>
</div>
</div>
<div class="col-lg-6 mb-3">
<div class="card card-body card-round">
<?php
$total_total = 0;
$d_invoice = mysqli_query($kon, "SELECT total FROM invoice WHERE resto='$_SESSION[resto]' AND status='Selesai' ");
while ($l_invoice = mysqli_fetch_array($d_invoice)) {
$total_total += $l_invoice['total'];
}
?>
<h5><b>Rp. <?= number_format($total_total, 0, ',', '.') ?></b></h5>
<div class="row">
<div class="col-9">
<small>Total (Income setelah kena diskon / kupon)</small>
</div>
<div class="col-3 text-right">
<small>lifetime <i class="fa-solid fa-chart-simple text-success"></i></small>
</div>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-lg-6 mb-3">
<div class="card card-round">
<?php
$out = mysqli_query($kon, "SELECT * FROM pengeluaran WHERE resto='$_SESSION[resto]' ");
?>
<div class="card-body">
<h5><b><?= mysqli_num_rows($out); ?></b></h5>
<div class="row">
<div class="col-6">
<small>Total Pengeluaran</small>
</div>
<div class="col-6 text-right">
<small>lifetime <i class="fa-solid fa-chart-simple text-success"></i></small>
</div>
</div>
</div>
</div>
</div>
<div class="col-lg-6 mb-3">
<div class="card card-round">
<?php
$total_total = 0;
$d_pengeluaran = mysqli_query($kon, "SELECT jumlah FROM pengeluaran WHERE resto='$_SESSION[resto]' ");
while ($l_pengeluaran = mysqli_fetch_array($d_pengeluaran)) {
$total_total += $l_pengeluaran['jumlah'];
}
?>
<div class="card-body">
<h5><b>Rp. <?= number_format($total_total, 0, ',', '.') ?></b></h5>
<div class="row">
<div class="col-6">
<small>Jumlah Pengeluaran</small>
</div>
<div class="col-6 text-right">
<small>lifetime <i class="fa-solid fa-chart-simple text-success"></i></small>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="card mt-3 mb-3 card-round">
<div class="card-body">
<!-- Form input tahun -->
<div class="row mt-2 mb-3">
<div class="col-lg-3">
<h5 class="ml-2">
<i class="fa-solid fa-calendar-week text-success"></i> Data bulanan
</h5>
<form method="POST" action="">
<div class="row">
<div class="col-md-8">
<input type="number" id="selectYear" name="selectedYear" class="form-control" value="<?= date('Y') ?>">
</div>
<div class="col-md-4">
<button type="submit" name="sortmontly" class="btn btn-primary btn-block">Lihat data</button>
</div>
</div>
</form>
</div>
</div>
<!-- Grafik-grafik -->
<div class="row mt-3">
<!-- Grafik Bar -->
<div class="col-lg-6 mb-3">
<div class="card h-100">
<div class="card-body card-round" style="height: 350px;">
<canvas id="barChart" width="600" height="350"></canvas>
</div>
</div>
</div>
<!-- Grafik Potongan -->
<div class="col-lg-6 mb-3">
<div class="card h-100">
<div class="card-body card-round" style="height: 350px;">
<canvas id="potonganChart" style="width: 100%; height: 100%;"></canvas>
</div>
</div>
</div>
</div>
</div>
</div>
<ul class="nav nav-tabs" id="myTab" role="tablist">
<li class="nav-item">
<a class="nav-link active" id="orderanku-tab" data-toggle="tab" href="#orderanku" role="tab" aria-controls="orderanku" aria-selected="true">Orderan</a>
</li>
<li class="nav-item">
<a class="nav-link" id="pengeluaran-tab" data-toggle="tab" href="#pengeluaran" role="tab" aria-controls="pengeluaran" aria-selected="false">Pengeluaran</a>
</li>
</ul>
<div class="tab-content" id="myTabContent">
<div class="tab-pane fade show active" id="orderanku" role="tabpanel" aria-labelledby="orderanku-tab">
<div class="card card-body">
<h5><i class="fa-solid fa-chart-simple text-success"></i>Transaksi lifetime (dari awal merchant aktif)</h5>
<Table id="laporantable" class="display">
<thead>
<tr>
<th>Tanggal</th>
<th>Wallet</th>
<th>Idinv</th>
<th>Cashier</th>
<th>Nama</th>
<th>Meja</th>
<th>Void</th>
<th>Total</th>
<th>Provit</th>
</tr>
</thead>
<tbody>
<?php
$d_invoice = mysqli_query($kon, "SELECT * FROM invoice WHERE resto='$_SESSION[resto]' ORDER BY id DESC ");
while ($l_invoice = mysqli_fetch_array($d_invoice)) {
?>
<tr>
<td><?= $l_invoice['tanggal'] ?></td>
<td><?= $l_invoice['wallet'] ?></td>
<td>
<a href="" data-toggle="modal" data-target="#detailModal<?= $l_invoice['id_trx'] ?>">
#<?= $l_invoice['id_trx'] ?>
</a>
<!-- Detail Modal -->
<div class="modal fade" id="detailModal<?php echo $l_invoice['id_trx']; ?>" tabindex="-1" role="dialog" aria-labelledby="detailModalLabel" aria-hidden="true">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="detailModalLabel">Detail #<?php echo $l_invoice['id_trx']; ?></h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<table class="table">
<thead>
<tr>
<th>Produk</th>
<th>Kategori</th>
<th>Qty</th>
</tr>
</thead>
<tbody>
<?php
$d_trx = mysqli_query($kon, "SELECT * FROM transaksi WHERE resto='$_SESSION[resto]' AND id_trx='$l_invoice[id_trx]' ORDER BY id DESC ");
while ($l_trx = mysqli_fetch_array($d_trx)) {
?>
<tr>
<td><?= $l_trx['nama'] ?></td>
<td><?= $l_trx['kategori'] ?></td>
<td><?= $l_trx['qty'] ?></td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
</td>
<td><?= $l_invoice['cashier'] ?></td>
<td><?= $l_invoice['nama'] ?></td>
<td><?= $l_invoice['meja'] ?></td>
<td>
<?php
if ($l_invoice['void'] == 'ya') {
echo "<span class='text-danger'>Void</span>";
}
?>
</td>
<td><?= number_format($l_invoice['total'], 0, ',', '.'); ?></td>
<td>
<?= $l_invoice['provit'] ?>
</td>
</tr>
<?php } ?>
</tbody>
</Table>
</div>
</div>
<div class="tab-pane fade" id="pengeluaran" role="tabpanel" aria-labelledby="pengeluaran-tab">
<div class="card card-body">
<table class="table" id="datatable" style="width:100%">
<thead>
<tr>
<th>no</th>
<th>Tanggal</th>
<th>Tujuan</th>
<th>Jumlah</th>
<th>Kasir</th>
</tr>
</thead>
<tbody>
<?php
$no = 1;
$d_pengeluaran = mysqli_query($kon, "SELECT * FROM pengeluaran WHERE resto='$_SESSION[resto]' ORDER BY id DESC ");
while ($l_pengeluaran = mysqli_fetch_array($d_pengeluaran)) {
?>
<tr>
<td><?= $no++ ?></td>
<td><?= $l_pengeluaran['tanggal'] ?></td>
<td><?= $l_pengeluaran['tujuan'] ?></td>
<td><?= number_format($l_pengeluaran['jumlah'], 0, ',', '.') ?></td>
<td><?= $l_pengeluaran['kasir'] ?></td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</body>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/bootstrap.bundle.min.js"></script>
<?php require 'footer.php' ?>