<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>