-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathreciept.php
155 lines (147 loc) · 6.52 KB
/
reciept.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
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
<?php
include_once 'functions/authentication.php';
include_once 'functions/connection.php';
$id = $_GET['id'];
$sql = "SELECT SUM(i.price * r.qty) AS total, c.fullname
FROM transactions t
JOIN rentals r ON t.id = r.transact_id
JOIN customers c ON t.customer_id = c.id
JOIN inventory i ON r.item_id = i.id
WHERE t.id = :id";
$statement = $db->prepare($sql);
$statement->bindParam(':id', $id);
$statement->execute();
$result = $statement->fetch();
$total = $result['total'];
$customer = $result['fullname'];
function getItems(){
global $id;
global $db;
$sql = "SELECT c.fullname, i.price, r.returned, r.qty, i.name, r.created_at
FROM transactions t
JOIN customers c ON t.customer_id = c.id
JOIN rentals r ON t.id = r.transact_id
JOIN inventory i ON r.item_id = i.id
WHERE t.id = :id";
$statement = $db->prepare($sql);
$statement->bindParam(':id', $id);
$statement->execute();
$items = $statement->fetchAll();
foreach($items as $row){
$startDateObj = new DateTime($row['created_at']);
$endDateObj = new DateTime($row['returned']);
$interval = $startDateObj->diff($endDateObj);
$days = $interval->days;
?>
<tr class="font-monospace" style="font-size: 10px;">
<td class="font-monospace" style="font-size: 10px;">ITEM: <strong><?php echo $row['name'] ?></strong></td>
<td class="font-monospace text-end" style="font-size: 10px;"></td>
<td class="font-monospace text-center" style="font-size: 10px;"><strong>Qty <?php echo $row['qty'] ?> | <?php echo $row['created_at'] ?> - <?php echo $row['returned'] ?> |</strong> <?php echo $days ?> DAYS</td>
<td class="font-monospace text-end" style="font-size: 10px;"><strong>₱<?php echo $row['price'] ?></strong></td>
</tr>
<?php
}
}
?>
<!DOCTYPE html>
<html data-bs-theme="light" lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0, shrink-to-fit=no">
<title>RMMFB</title>
<meta name="description" content="Rental Management and Monitoring for a Fashion Boutique">
<link rel="icon" type="image/png" sizes="512x512" href="assets/img/boutique.png">
<link rel="icon" type="image/png" sizes="512x512" href="assets/img/boutique.png">
<link rel="icon" type="image/png" sizes="512x512" href="assets/img/boutique.png">
<link rel="icon" type="image/png" sizes="512x512" href="assets/img/boutique.png">
<link rel="icon" type="image/png" sizes="512x512" href="assets/img/boutique.png">
<link rel="stylesheet" href="assets/bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="assets/bootstrap/css/bootstrap-select.min.css">
<link rel="stylesheet" href="assets/css/Nunito.css">
</head>
<body onload="printPageAndRedirect()">
<div class="table-responsive">
<table class="table">
<thead>
<tr>
<th class="font-monospace text-center" style="color: var(--bs-gray-900);font-size: 13px;">
<img src="assets/img/boutique.png" width="40"> Fashion Boutique<br>
<span style="font-weight: normal !important;">Cabera Street St. Barangay Balangasan, Pagadian City</span><br>
<span style="font-weight: normal !important;">Phone (+63) 970-081-2044</span><br>
<span style="font-weight: normal !important;">TRN 000 000 000 000 000</span><br>
</th>
</tr>
</thead>
<tbody>
<tr></tr>
<tr></tr>
</tbody>
</table>
</div>
<div class="table-responsive">
<table class="table table-borderless">
<thead>
<tr>
<th class="font-monospace text-center" style="font-size: 10px;">Rental Reciept</th>
</tr>
</thead>
<tbody class="font-monospace">
<tr class="font-monospace"></tr>
<tr class="font-monospace"></tr>
</tbody>
</table>
</div>
<div class="table-responsive font-monospace">
<table class="table table-borderless">
<thead class="font-monospace">
<tr class="font-monospace">
<th class="font-monospace" style="font-size: 10px;"><span style="font-weight: normal !important;">CUSTOMER: <strong><?php echo $customer; ?></strong></span></th>
<th class="font-monospace text-end" style="font-size: 10px;"></th>
<th class="font-monospace text-end" style="font-size: 10px;"></th>
<th class="font-monospace text-end" style="font-size: 10px;">INVOICE #<?php echo $_GET['id'] ?></th>
</tr>
</thead>
<tbody class="font-monospace">
<?php getItems() ?>
</tbody>
</table>
</div>
<div class="table-responsive">
<table class="table">
<thead class="font-monospace">
<tr class="font-monospace">
<th class="font-monospace text-end"><strong>TOTAL</strong> <strong>₱<?php echo $total; ?></strong></th>
</tr>
</thead>
<tbody>
<tr></tr>
</tbody>
</table>
</div>
<script src="assets/js/jquery.min.js"></script>
<script src="assets/bootstrap/js/bootstrap.min.js"></script>
<script src="assets/bootstrap/js/bootstrap-select.min.js"></script>
<script src="assets/js/jquery.dataTables.min.js"></script>
<script src="assets/js/dataTables.bootstrap5.min.js"></script>
<script src="assets/js/dataTables.buttons.min.js"></script>
<script src="assets/js/jszip.min.js"></script>
<script src="assets/js/pdfmake.min.js"></script>
<script src="assets/js/three.min.js"></script>
<script src="assets/js/theme.js"></script>
<script src="assets/js/vfs_fonts.js"></script>
<script src="assets/js/buttons.html5.min.js"></script>
<script src="assets/js/buttons.print.min.js"></script>
<script src="assets/js/vanta.birds.min.js"></script>
<script src="assets/js/vanta.waves.min.js"></script>
<script src="assets/js/sweetalert2.all.min.js"></script>
<script src="assets/js/main.js"></script>
<script>
function printPageAndRedirect() {
window.print();
setTimeout(function() {
window.location.href = 'rents.php';
}, 1000); // Redirect after 1 second (adjust as needed)
}
</script>
</body>
</html>