-
Notifications
You must be signed in to change notification settings - Fork 0
/
list-transaksi.php
70 lines (67 loc) · 2.06 KB
/
list-transaksi.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
<?php
session_start();
require 'function.php';
if ($status == true && $id_role != 1 && $id_role != 2) {
header('Location: ' . BASEURL . '/auth/login');
}
if (isset($_POST['submit'])) {
$date1 = htmlspecialchars($_POST['tgl_awal']);
$date2 = htmlspecialchars($_POST['tgl_akhir']);
$transaksi = query("SELECT * FROM transaksi
inner join users ON transaksi.id_user=users.id_user
inner join pelanggan ON transaksi.id_pelanggan=pelanggan.id_pelanggan
WHERE DATE(tgl_wkt)
BETWEEN '$date1' AND '$date2'
ORDER BY DATE(tgl_wkt) ASC, id_transaksi ASC
");
}
$date = date('d-m-Y');
header("Content-type: application/vnd-ms-excel");
header("Content-Disposition: attachment; filename=" . "list-transaksi_" . "$date" . ".xls");
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>Daftar Transaksi</title>
<link rel="stylesheet" href="">
</head>
<style>
table {
width: 100%;
}
</style>
<body>
<br>
<table border="1">
<thead>
<th align="left">No</th>
<th align="left">ID Transaksi</th>
<th align="left">Nama Petugas</th>
<th align="left">Nama Pelanggan</th>
<th align="left">Tanggal dan Waktu</th>
<th align="left">Bayar</th>
<th align="left">Total</th>
<th align="left">Kembali</th>
</tr>
</thead>
<tbody>
<?php $i = 1; ?>
<?php foreach ($transaksi as $b) { ?>
<tr>
<td align="left"><?php echo $i; ?></td>
<td align="left"><?php echo htmlentities($b['id_transaksi']); ?></td>
<td align="left"><?php echo htmlentities($b['username']); ?></td>
<td align="left"><?php echo htmlentities($b['nama']); ?></td>
<td align="left"><?php echo htmlentities($b['tgl_wkt']); ?></td>
<td align="left"><?php echo htmlentities($b['bayar']); ?></td>
<td align="left"><?php echo htmlentities($b['total']); ?></td>
<td align="left"><?php echo htmlentities($b['kembali']); ?></td>
</tr>
<?php $i++; ?>
<?php } ?>
</tbody>
</table>
</body>
</html>