D7net Mini Sh3LL v1
Current File : C:/Domains/maymaytinson.com/httpdocs/lib/images/13/../10/../7/../16/../activity/../JUKI/../15/../zip_food/../18/../17/../2/../21/../20/../22/../5/../11/../7/../5/../22/../22/../../../upload/../upload/../conn/../include/listOrder.php |
<div id="listProduct">
<div id="list">
<table>
<thead>
<th>Stt</th>
<th>Tên khách hàng</th>
<th>Tổng số lượng</th>
<th>Tổng số tiền</th>
<th>Loại</th>
<th>Trạng thái</th>
</thead>
<?php
if(!isset($_GET['keyword'])){
$_GET['keyword']="";
}
$stmt=$conn->prepare("SELECT *,SUM(payment.amount) AS sumAmount,SUM(payment.price) AS sumPrice FROM payment JOIN member ON member.id=payment.customer WHERE member.name LIKE '%".$_GET['keyword']."%' GROUP BY payment.dateBuy");
$stmt->execute();
$payment=$stmt->fetchAll(PDO::FETCH_ASSOC);
$stt=1;
foreach ($payment as $payment) {?>
<tr title="Nhấp vào để chỉnh sửa">
<td align="center" onclick="document.location = 'editOrder.php?id=<?php echo $payment['id'] ?>&dateBuy=<?php echo $payment['dateBuy'] ?>';"><?php echo $stt;$stt++; ?></td>
<td onclick="document.location = 'editOrder.php?id=<?php echo $payment['id'] ?>&dateBuy=<?php echo $payment['dateBuy'] ?>';"><?php echo $payment['name']; ?></td>
<td align="center" onclick="document.location = 'editOrder.php?id=<?php echo $payment['id'] ?>&dateBuy=<?php echo $payment['dateBuy'] ?>';"><?php echo $payment['sumAmount']; ?></td>
<td align="center" onclick="document.location = 'editOrder.php?id=<?php echo $payment['id'] ?>&dateBuy=<?php echo $payment['dateBuy'] ?>';"><span class="price"><?php echo number_format($payment['sumPrice'])." đ"; ?></span></td>
<td align="center" onclick="document.location = 'editOrder.php?id=<?php echo $payment['id'] ?>&dateBuy=<?php echo $payment['dateBuy'] ?>';"><?php if($payment['isMember']==1){ echo "Thành viên"; }if($payment['isMember']==0){ echo "Khách hàng"; }; ?></td>
<td align="center" onclick="document.location = 'editOrder.php?id=<?php echo $payment['id'] ?>&dateBuy=<?php echo $payment['dateBuy'] ?>';"><?php if($payment['status']==0){ echo "Đang chờ"; }else{ echo "Đã thanh toán"; } ?></td>
</tr>
<?php } ?>
</table>
</div>
</div>
AnonSec - 2021 | Recode By D7net