-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathcetak.php
112 lines (101 loc) · 2.87 KB
/
cetak.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
<?php
require_once 'config/config.php';
if (isset($_GET['id_transaksi'])) {
$id_transaksi = $_GET['id_transaksi'];
$query = mysqli_query($db, "SELECT * FROM view_transaksi WHERE id_transaksi = $id_transaksi");
$query2 = mysqli_query($db, "SELECT * FROM view_transaksi_detail WHERE id_transaksi = $id_transaksi");
$query3 = mysqli_query($db, "SELECT sum(harga_paket) as harga_paket FROM view_transaksi_detail WHERE id_transaksi = $id_transaksi");
$query4 = mysqli_query($db, "SELECT * FROM view_transaksi_detail WHERE id_transaksi = $id_transaksi");
if (mysqli_num_rows($query) > 0) {
$data = mysqli_fetch_array($query);
$data2 = mysqli_fetch_array($query2);
$data3 = mysqli_fetch_array($query3);
?>
<title>Sistem Informasi Cucian - PT Mauza Utama Mobil</title>
<body onload="window.print()">
<table>
<tbody>
<tr>
<td>PT. MAUZA AUTO MOBIL</td>
</tr>
<tr>
<td>Jl. Duyung</td>
</tr>
<tr>
<td>Telp 082137126442</td>
</tr>
</tbody>
</table>
<hr width="30%" align="left">
<table>
<tbody>
<tr>
<td>Kasir</td>
<td>:</td>
<td><?php echo $data['nama_user'] ?></td>
</tr>
<tr>
<td>Kode Pelanggan</td>
<td>:</td>
<td><?php echo $data['kode_pelanggan'] ?></td>
</tr>
<tr>
<td>Nama Pelanggan</td>
<td>:</td>
<td><?php echo $data['nama_pelanggan'] ?></td>
</tr>
<tr>
<td>Tipe Mobil</td>
<td>:</td>
<td><?php echo $data['tipe_mobil'] ?></td>
</tr>
<tr>
<td>NOPOL</td>
<td>:</td>
<td><?php echo $data['nopol'] ?></td>
</tr>
<tr>
<td>Paket</td>
<td>:</td>
</tr>
<?php while ($row = mysqli_fetch_array($query4)) { ?>
<tr>
<td><?php echo '- ' . $row['nama_paket'] . ' (Rp ' . number_format($row['harga_paket'], 2, ",", ".") . ')'; ?></td>
</tr>
<?php } ?>
<tr>
<td>Total</td>
<td>:</td>
<td><?php echo 'Rp ' . number_format($data3['harga_paket'], 2, ",", ".") ?></td>
</tr>
<tr>
<td>Tunai</td>
<td>:</td>
<td><?php echo 'Rp ' . number_format($data2['bayar'], 2, ",", ".") ?></td>
</tr>
<tr>
<td>Kembali</td>
<td>:</td>
<td><?php echo 'Rp ' . number_format($data2['bayar'] - $data3['harga_paket'], 2, ",", ".") ?>
</td>
</tr>
<tr>
<td>Tanggal</td>
<td>:</td>
<td><?php echo date("d-m-Y", strtotime($data['tanggal'])) ?></td>
</tr>
</tbody>
</table>
</body>
<?php
} else {
header("Location: transaksi.php");
}
} else {
header("Location: transaksi.php");
}
?>
<script>
window.print();
window.onfocus=function() {window.close();}
</script>