-
Notifications
You must be signed in to change notification settings - Fork 0
/
pencariandatapesan.php
211 lines (179 loc) · 10.2 KB
/
pencariandatapesan.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
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
<?php
include 'dbconnect.php';
include 'support.php';
?>
<html lang="en">
<head>
<!-- Required meta tags -->
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<!-- Bootstrap CSS -->
<link rel="stylesheet" href="css/body.css">
<link rel="stylesheet" href="css/style.css">
<!-- <link rel="stylesheet" href="../css/style.css"> -->
<script type="text/javascript" src="js/script.js"></script>
<title>Pencarian Data Pemesanan</title>
<div id="kepala1" class="shadow-sm py-1 sticky-top " >
<nav class="navbar navbar-expand-md navbar-light">
<a class="navbar-brand a" href="index.php">Mlaku.co</a>
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse sticky" id="navbarSupportedContent">
<ul class="navbar-nav mr-auto pl-2">
<!-- <li class="nav-item active">
<a class="nav-link" href="index.php">Home <span class="sr-only">(current)</span></a>
</li> -->
<li class="nav-item">
<a class="nav-link" href="pencariandatapesan.php">Search Order</a>
</li>
<li class="nav-item dropdown">
<a class="nav-link dropdown-toggle" href="#" id="navbarDropdown" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
Categories
</a>
<div class="dropdown-menu" aria-labelledby="navbarDropdown">
<a class="dropdown-item" href="categories/alatkemah.php">Alat Kemah</a>
<a class="dropdown-item" href="categories/alathiking.php">Alat Hiking</a>
<a class="dropdown-item" href="categories/pakaiantravelling.php">Pakaian Travelling</a>
</div>
</li>
<li class="nav-item">
<a class="nav-link" href="about.php">About Us</a>
</li>
</ul>
<!-- copas ini pak -->
<a class="nav-link my-2 my-lg-0 ml-5" href="login.php">Sign in for Admin</a>
<form class="form-inline my-2 my-lg-0" method="GET" action="pencarian.php">
<input class="form-control mr-sm-2" type="text" name="search" placeholder="Search" aria-label="Search" onkeyup="this.value = this.value.toLowerCase();">
<!-- <button class="btn btn-outline-success my-2 my-sm-0" name="search" type="submit">Search</button>-->
</form>
<!-- sampai sini, ganti aja yang sebelumnya. -->
</div>
</nav>
</div>
</head>
<body class="bg2">
<div class="container" >
<form action="" method="get">
<div class="py-1 pl-3 mt-3">
Masukkan Nomor Pemesanan:
<input type="text" name="no_pes" required oninvalid="this.setCustomValidity('Nomor pemesanan wajib diisi!')" oninput="setCustomValidity('')">
<input type="submit" class="btn-small btn-primary mx-2" name="submit" value="Cari">
</div>
</form>
</div>
<?php
if($_GET){
$nopes=$_GET['no_pes'];
$query = mysqli_query($konek,
"SELECT d.no_pemesanan as 'nopes', d.tanggal_pesan as 'tglpsn', p.id_pelanggan as 'idpel', p.nama_pelanggan as 'napel', p.email as 'email', d.lama_pesan as 'lamasewa', d.total_harga as 'totalharga'
FROM detailpemesanan d, pemesanan p
WHERE p.no_pemesanan=d.no_pemesanan AND d.no_pemesanan = '$nopes'"
)->fetch_object();
?>
<div class="container">
<div class="row justify-content-md-center">
<div class="col product">
<br>
<div class="card" style="width: 20rem;">
<div class="card body px-3 py-3">
<center>
Nomor Pemesanan: <b style="font-size:20px"><?= $query->nopes ?></b>
<br><br>
Tanggal Pesan: <b><?php
$newtgl=date("d-m-Y", strtotime($query->tglpsn));
echo $newtgl
?></b>
</center>
<!-- <br><br> -->
</div>
</div>
<br>
<div class="card" style="width: 20rem;">
<div class="card body px-3 py-3">
<center>
<p>E-Mail: <br><b><?php echo $query->email ?></b></p>
<p>Nama Lengkap: <br><b><?php echo $query->napel ?></b></p>
<lp>ID Pelanggan (KTP/SIM): </br><b><?php echo $query->idpel ?></b>
</center>
<!-- <br><br> -->
</div>
</div>
</div>
<div class="col product">
<br>
<div class="card" style="width: 25rem;">
<div class="card body px-3 py-3">
<p>Barang yang dipesan:</p>
<center>
<table id="t01">
<tr style="font-size:14px">
<th>Nama Barang</th>
<th>Harga</th>
<th>Kuantitas</th>
<th>Jumlah</th>
</tr>
<?php
$sql = mysqli_query($konek,
"SELECT i.nama_bar as 'namabar', pp.harga as 'harga', pp.kuantitas as 'kuantitas'
FROM itemproduk i, produkpemesanan pp
WHERE pp.id_bar = i.id_bar AND pp.nomor_pemesanan LIKE '$nopes'"
);
// $cart = unserialize(serialize($_SESSION['cart']));
// $s = 0;
// $index = 0;
// for($i=0; $i<count($cart); $i++){
// $s += $cart[$i]->price * $cart[$i]->quantity;
$s=0;
while($query2 = mysqli_fetch_object($sql)){
?>
<tr style="font-size:13px">
<td> <?php echo $query2->namabar; ?> </td>
<td> Rp<?php echo number_format($query2->harga); ?>,- </td>
<td> <center> <?php echo $query2->kuantitas; ?></center> </td>
<?php $subtot=$query2->harga * $query2->kuantitas;
$s+=$subtot;
?>
<td> Rp<?php echo number_format($subtot); ?>,- </td>
</tr>
<?php } ?>
<tr style="font-size:14px">
<td colspan="3" style="text-align:center; font-weight:bold">Subtotal
</td>
<td> <b>Rp<?php echo number_format($s); ?>,-<b> </td>
</tr>
</table>
</center>
<br>
<?php
if(isset($_GET["id"]) || isset($_GET["index"])){
// header('Location: cart.php');
}
?>
</div>
</div>
</div>
<div class="col product">
<br>
<div class="card" style="width: 15rem;">
<div class="card body px-3 py-3">
<center>
<p>Lama Penyewaan: <br><b><?php echo $query->lamasewa ?> hari</b>
<?php //$totalbayar = $s * $query->lamasewa ?>
<p>Total Pembayaran: <br><b style="font-size:20px">Rp<?php echo number_format($query->totalharga) ?>,-</b>
</center>
</div>
</div>
<br>
<p style="text-align: justify; width:15rem; font-size: 13px">Bila ada kesalahan data hasil inputan pelanggan, dapat menghubungi kontak Admin yang ada di halaman About Us.
<b>(Harap mencantumkan nomor pesanan beserta data yang salah atau mengirim hasil Screenshot halaman ini).</b></p>
</div>
</div>
<!-- </div> -->
<br>
</div>
<?php
}
?>
</body>
</html>