<?php
session_start();
if (empty($_SESSION['loginku'])) {
header("Location: login");
}
require 'koneksi.php';
require 'function.php';
include 'header.php';
$defaultdate = date("Y-m-d");
// Check if the form is submitted
if (isset($_POST['sortdaily'])) {
// Jika formulir dikirim, gunakan nilai dari input 'selectedYear'
$date = htmlspecialchars($_POST['selecteDate']);
} else {
// Jika formulir tidak dikirim, gunakan tahun default
$date = $defaultdate;
}
#selesaikan orderan
if (isset($_POST['btnselesaikan'])) {
$id_trx = pilter($kon, $_POST['id_trx']);
$sql = "UPDATE invoice SET status='Selesai' WHERE id_trx=?";
$stmt = mysqli_prepare($kon, $sql);
mysqli_stmt_bind_param($stmt, "s", $id_trx);
mysqli_stmt_execute($stmt);
}
#lakukan void
if (isset($_POST['btnvoid'])) {
$id_trx = $_POST['id_trx'];
$access_code = $_POST['access_code'];
// Ambil kode akses dari tabel vvoider
$sql_check = "SELECT kode FROM voider WHERE id = 1";
$result = mysqli_query($kon, $sql_check);
$row = mysqli_fetch_assoc($result);
$valid_access_code = $row['kode'];
if ($access_code === $valid_access_code) {
// Ambil data bahan yang digunakan dari tabel bahan_terpakai berdasarkan transaksi_id
$sql_select = "SELECT id_bahan_baku, jumlah_terpakai FROM bahan_terpakai WHERE transaksi_id = ?";
$stmt_select = mysqli_prepare($kon, $sql_select);
mysqli_stmt_bind_param($stmt_select, "s", $id_trx);
mysqli_stmt_execute($stmt_select);
$result_select = mysqli_stmt_get_result($stmt_select);
while ($row = mysqli_fetch_assoc($result_select)) {
$id_bahan_baku = $row['id_bahan_baku'];
$jumlah_terpakai = $row['jumlah_terpakai'];
// Update stok di tabel bahan_baku dengan menambahkan jumlah yang digunakan kembali
$sql_update = "UPDATE bahan_baku SET jumlah_stok = jumlah_stok + ? WHERE id = ?";
$stmt_update = mysqli_prepare($kon, $sql_update);
mysqli_stmt_bind_param($stmt_update, "ii", $jumlah_terpakai, $id_bahan_baku);
mysqli_stmt_execute($stmt_update);
}
// Hapus data dari tabel bahan_terpakai berdasarkan transaksi_id
$sql_delete = "DELETE FROM bahan_terpakai WHERE transaksi_id = ?";
$stmt_delete = mysqli_prepare($kon, $sql_delete);
mysqli_stmt_bind_param($stmt_delete, "s", $id_trx);
mysqli_stmt_execute($stmt_delete);
// ubah keterangan void menjadi ya
$sql = "UPDATE invoice SET void='ya' WHERE id_trx=?";
$stmt = mysqli_prepare($kon, $sql);
mysqli_stmt_bind_param($stmt, "s", $id_trx);
mysqli_stmt_execute($stmt);
// ubah status dari proses ke batal
$sql = "UPDATE invoice SET status='Batal' WHERE id_trx=?";
$stmt = mysqli_prepare($kon, $sql);
mysqli_stmt_bind_param($stmt, "s", $id_trx);
mysqli_stmt_execute($stmt);
} else {
echo "Invalid access code!";
}
}
?>
<?php include 'navbar.php' ?>
<body style="background-color: #f7f7f7">
<div class="container-fluid mt-3 mb-5">
<div class="row mb-3">
<div class="col-lg-6">
<form action="" method="POST">
<div class="row">
<div class="col-md-8">
<!-- Kolom input field -->
<input type="date" id="tanggal" name="selecteDate" class="form-control" placeholder="Input tanggal">
</div>
<div class="col-md-4">
<!-- Kolom tombol -->
<button type="submit" name="sortdaily" class="btn btn-primary btn-block">Lihat data</button>
</div>
</div>
</form>
</div>
</div>
<div class="row">
<div class="col lg-6">
<div class="card card-body card-round">
<table class="table" id="datatable">
<thead>
<tr>
<th>Tanggal</th>
<th>Wallet</th>
<th>Idinv</th>
<th>Cashier</th>
<th>Nama</th>
<th>Meja</th>
<th>Total</th>
<th>Wallet</th>
<th>Aksi</th>
</tr>
</thead>
<tbody>
<?php
$d_invoice = mysqli_query($kon, "SELECT * FROM invoice WHERE resto='$_SESSION[resto]' AND tanggal='$date' 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'] ?> <?= $l_invoice['meja'] ?> <!-- jika TA jadi gambar takeaway-->
</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><?= number_format($l_invoice['total'], 0, ',', '.') ?></td>
<td><?= $l_invoice['wallet'] ?></td>
<td>
<?php if ($l_invoice['status'] === 'Proses' && $l_invoice['void'] === 'tidak') { ?>
<button class="btn btn-warning" data-toggle="modal" data-target="#selesaiModal<?= $l_invoice['id_trx'] ?>">Selesaikan</button>
<?php } else if ($l_invoice['status'] === 'Proses' && $l_invoice['void'] === 'ya') { ?>
<button class="btn btn-danger" disabled>Divoid</button>
<?php } else if ($l_invoice['status'] === 'Batal' && $l_invoice['void'] === 'ya') { ?>
<button class="btn btn-danger" disabled>Divoid</button>
<?php } else { ?>
<button class="btn btn-success" disabled>Selesai</button>
<?php } ?>
<!-- void hanya bisa ketika status masih proses dan void= 'tidak' -->
<?php if ($l_invoice['status'] === 'Proses' && $l_invoice['void'] === 'tidak') { ?>
<button class="btn btn-danger" data-toggle="modal" data-target="#voidModal<?= $l_invoice['id_trx'] ?>">Void</button>
<?php } ?>
</td>
</tr>
<!-- modal selesai -->
<div class="modal fade" id="selesaiModal<?= $l_invoice['id_trx'] ?>" tabindex="-1" role="dialog" aria-hidden="true">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title">Yakin #<?= $l_invoice['id_trx'] ?> sudah selesai?</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<form action="" method="POST">
<input type="hidden" name="id_trx" value="<?= $l_invoice['id_trx'] ?>">
<button type="submit" name="btnselesaikan" class="btn btn-primary btn-block">Ya sudah!</button>
</form>
</div>
</div>
</div>
</div>
<!-- modal void -->
<div class="modal fade" id="voidModal<?= $l_invoice['id_trx'] ?>" tabindex="-1" role="dialog" aria-hidden="true">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title">Yakin #<?= $l_invoice['id_trx'] ?> divoid?</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<form action="" method="POST">
<input type="hidden" name="id_trx" value="<?= $l_invoice['id_trx'] ?>">
<div class="form-group">
<label for="access_code">Kode Akses VOID:</label>
<input type="text" name="access_code" class="form-control" required>
</div>
<button type="submit" name="btnvoid" class="btn btn-danger btn-block">Void</button>
</form>
</div>
</div>
</div>
</div>
<?php } ?>
</tbody>
</table>
</div>
</div>
<div class="col lg-6">
<div class="row d-flex mb-3">
<div class="col-lg-6">
<div class="card card-body card-round">
<?php
$orderan = mysqli_query($kon, "SELECT * FROM invoice WHERE resto='$_SESSION[resto]' AND tanggal='$date' ");
?>
<h5><b><?= mysqli_num_rows($orderan); ?></b></h5>
<small>Total orderan </small>
</div>
</div>
<div class="col-lg-6">
<div class="card card-body card-round">
<?php
$orderanproses = mysqli_query($kon, "SELECT * FROM invoice WHERE resto='$_SESSION[resto]' AND tanggal='$date' AND status='Proses' ");
?>
<h5><b><?= mysqli_num_rows($orderanproses); ?></b></h5>
<small>On proses</small>
</div>
</div>
</div>
<div class="row d-flex mb-3">
<div class="col-lg-6">
<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 tanggal='$date' 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>
<small>Total (Income setelah kena diskon / kupon)</small>
</div>
</div>
<div class="col-lg-6">
<div class="card card-body card-round">
<?php
$total_realtotal = 0;
$d_invoice = mysqli_query($kon, "SELECT realtotal FROM invoice WHERE resto='$_SESSION[resto]' AND tanggal='$date' AND status='Selesai' ");
while ($l_invoice = mysqli_fetch_array($d_invoice)) {
$total_realtotal += $l_invoice['realtotal'];
}
?>
<h5><b>Rp. <?= number_format($total_realtotal, 0, ',', '.') ?></b></h5>
<small>Realtotal (Income jika tidak kena diskon / kupon) </small>
</div>
</div>
</div>
<div class="row d-flex mb-3">
<div class="col-lg-12">
<div class="card card-body card-round">
<h5><b>Rp. <?= number_format($total_total -= $total_realtotal, 0, ',', '.') ?></b></h5>
<small>Yang disubsidi untuk promo & kupon</small>
</div>
</div>
</div>
<div class="row d-flex">
<div class="col-lg-6">
<div class="card card-body card-round">
<?php
$d_void = mysqli_query($kon, "SELECT * FROM invoice WHERE void='ya' AND resto='$_SESSION[resto]' AND tanggal='$date' ");
?>
<h5><b><?= mysqli_num_rows($d_void); ?></b></h5>
<small>Total void</small>
</div>
</div>
<div class="col-lg-6">
<div class="card card-body card-round">
<?php
$tot_void = 0;
$d_void = mysqli_query($kon, "SELECT * FROM invoice WHERE void='ya' AND resto='$_SESSION[resto]' AND tanggal='$date' ");
while ($l_void = mysqli_fetch_array($d_void)) {
$tot_void += $l_void['total'];
}
?>
<h5><b><?= "Rp " . number_format($tot_void, 0, ',', '.') ?></b></h5>
<small>
Total nominal void
<br>
(Hanya menghitung berdasakan total bukan realtotal)
</small>
</div>
</div>
</div>
<div class="alert alert-danger mt-3">
Hanya menampilkan kemana uang transaksi masuk. bukan berarti sistem kasir terkoneksi dengan aplikasi pihak ke3
</div>
<div class="row d-flex mt-3">
<div class="col-lg-6">
<?php
$total_gofood = 0;
$d_gofood = mysqli_query($kon, "SELECT realtotal FROM invoice WHERE resto='$_SESSION[resto]' AND tanggal='$date' AND status='Selesai' AND wallet='gofood' ");
while ($l_gofood = mysqli_fetch_array($d_gofood)) {
$total_gofood += $l_gofood['realtotal'];
}
?>
<div class="card card-body card-round">
<h5><b><?= $total_gofood ?></b></h5>
Gofood (uang yang masuk ke Gofood)
</div>
</div>
<div class="col-lg-6">
<?php
$total_grabfood = 0;
$d_grabfood = mysqli_query($kon, "SELECT realtotal FROM invoice WHERE resto='$_SESSION[resto]' AND tanggal='$date' AND status='Selesai' AND wallet='grabfood' ");
while ($l_grabfood = mysqli_fetch_array($d_grabfood)) {
$total_grabfood += $l_grabfood['realtotal'];
}
?>
<div class="card card-body card-round">
<h5><b><?= $total_grabfood ?></b></h5>
Grabfood (uang yang masuk ke Grabfood)
</div>
</div>
</div>
<div class="row d-flex mt-3">
<div class="col-lg-6">
<?php
$total_shopeefood = 0;
$query = "SELECT realtotal FROM invoice WHERE resto=? AND tanggal=? AND status='Selesai' AND wallet='shopeefood'";
if ($stmt = $kon->prepare($query)) {
$stmt->bind_param("ss", $_SESSION['resto'], $date);
$stmt->execute();
$stmt->bind_result($realtotal);
while ($stmt->fetch()) {
$total_shopeefood += $realtotal;
}
$stmt->close();
}
?>
<div class="card card-body card-round">
<h5><b><?= $total_shopeefood ?></b></h5>
ShopeeFood (uang yang masuk ke Shopeefood)
</div>
</div>
<div class="col-lg-6">
<?php
$total_qris = 0;
$d_qris = mysqli_query($kon, "SELECT realtotal FROM invoice WHERE resto='$_SESSION[resto]' AND tanggal='$date' AND status='Selesai' AND wallet='qris' ");
while ($l_qris = mysqli_fetch_array($d_qris)) {
$total_qris += $l_qris['realtotal'];
}
?>
<div class="card card-body card-round">
<h5><b><?= $total_qris ?></b></h5>
Qris (uang yang masuk ke Qris)
</div>
</div>
</div>
</div>
</div>
</body>
<?php require 'footer.php' ?>