This repository was archived by the owner on Aug 27, 2025. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathorderlist.php
More file actions
157 lines (156 loc) · 9.32 KB
/
orderlist.php
File metadata and controls
157 lines (156 loc) · 9.32 KB
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
<?php
include("header-dashboard.php");
?>
<?php
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$ID_Order=$_POST['ID_Order'];
$Date_De = date("H:i:s Y/m/d");
$Statement_Update_Order = "UPDATE `order` SET Date_De='$Date_De', Status_Order = 'Giao Thành Công' WHERE ID_Order = $ID_Order";
$Query_Update_Order = mysqli_query($conn, $Statement_Update_Order);
}
?>
<title>Quản Lí Đơn Hàng - SIT</title>
<div class="main-content">
<div class="page-content">
<div class="container-fluid">
<div class="row">
<div class="col-12">
<div class="card">
<div class="card-body">
<div class="table-responsive">
<table id="datatable" class="table table-bordered dt-responsive nowrap" style="border-collapse: collapse; border-spacing: 0; width: 100%;">
<thead class="thead-light">
<tr>
<th>Mã đơn hàng</th>
<th>Ngày mua</th>
<th>Khách hàng</th>
<th>Trạng thái</th>
<th>Chi Tiết</th>
</tr>
</thead>
<tbody>
<?php
$Statement_Order = "SELECT * FROM `order`WHERE Status_Order = 'Chưa Giải Quyết' ";
$Query_Order = mysqli_query($conn, $Statement_Order);
// Từ bảng order chúng ta bắt đầu truy vấn các trường dữ liệu ở các bảng khác để bổ sung thông tin cho hóa đơn
while ($Display_Order = mysqli_fetch_assoc($Query_Order)){
// Từ ID_User lấy ra dữ liệu tên người dùng
$Statement_Users = "SELECT * FROM users WHERE ID_User =".$Display_Order['ID_User'];
$Query_Users = mysqli_query($conn, $Statement_Users);
$Display_Users = mysqli_fetch_assoc($Query_Users);
// Từ ID_Order lấy toàn bộ dữ liệu của đơn đặt hàng
$Statement_OrderDetail = "SELECT * FROM orderdetail WHERE ID_Order =".$Display_Order['ID_Order'];
$Query_OrderDetail = mysqli_query($conn, $Statement_OrderDetail);
$Display_OrderDetail = mysqli_fetch_assoc($Query_OrderDetail);
echo "<tr>
<td><a href='javascript: void(0);' class='text-primary ml-3'>VKU".$Display_Order['ID_Order']."</a> </td>
<td>$Display_Order[Date_Order]</td>
<td>
$Display_Users[Name_User]
</td>
<td>";
if($Display_Order['Status_Order']=="Chưa Giải Quyết"){
echo "<span class='badge badge-pill badge-soft-danger font-size-13'>Chưa Giao</span>";
}
else echo "<span class='badge badge-pill badge-soft-success font-size-13'>Đã Giao</span>";
echo "</td>";
echo "<td>
<button type='button' class='btn btn-primary btn-sm btn-rounded' data-toggle='modal' data-target='.Modal$Display_Order[ID_Order]'>
Xem
</button>
</td>
</tr>";
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- Tạo ra Modal để xem chi tiết dơn hàng voiuws nhiều sản phẩm hơn -->
<?php
$Statement_Order = "SELECT * FROM `order`";
$Query_Order = mysqli_query($conn, $Statement_Order);
while ($Display_Order = mysqli_fetch_assoc($Query_Order)){
$Statement_Users = "SELECT * FROM users WHERE ID_User =".$Display_Order['ID_User'];
$Query_Users = mysqli_query($conn, $Statement_Users);
$Display_Users = mysqli_fetch_assoc($Query_Users);
echo "<div class='modal fade Modal$Display_Order[ID_Order]' tabindex='-1' role='dialog' aria-labelledby='exampleModalLabel' aria-hidden='true'>
<div class='modal-dialog modal-dialog-centered' role='document'>
<div class='modal-content'>
<div class='modal-header'>
<h5 class='modal-title' id='exampleModalLabel'>Chi Tiết Đơn Hàng</h5>
<button type='button' class='close' data-dismiss='modal' aria-label='Close'>
<span aria-hidden='true'>×</span>
</button>
</div>
<div class='modal-body'>
<p class='mb-2'>Mã Đơn Hàng: <span class='text-primary'> VKU$Display_Order[ID_Order]</span></p>
<p class='mb-2'>Khách Hàng: <span class='text-primary'> $Display_Users[Name_User]</span></p>
<p class='mb-2'>Liên Lạc: <span class='text-primary'> $Display_Order[Phone_User]</span></p>
<p class='mb-4'>Địa Chỉ: <span class='text-primary'> $Display_Order[Address_User]</span></p>
<div class='table-responsive'>
<table class='table table-centered table-nowrap'>
<thead>
<tr>
<th scope='col'>Hình Ảnh</th>
<th scope='col'>Tên Sản Phẩm</th>
<th scope='col'>Tổng</th>
</tr>
</thead>
<tbody>";
$Statement_OrderDetail = "SELECT * FROM orderdetail WHERE ID_Order =".$Display_Order['ID_Order'];
$Query_OrderDetail = mysqli_query($conn, $Statement_OrderDetail);
$Total=0;
while($Display_OrderDetail = mysqli_fetch_assoc($Query_OrderDetail)){
$Statement_Product = "SELECT * FROM product WHERE ID_Product =".$Display_OrderDetail['ID_Product'];
$Query_Product = mysqli_query($conn, $Statement_Product);
$Display_Product = mysqli_fetch_assoc($Query_Product);
echo "<tr>
<th scope='row'>
<div>
<img src='images/shop/$Display_Product[Image_Product]' class='border' width='70px'>
</div>
</th>
<td>
<div>
<h5 class='text-truncate font-size-14'>$Display_Product[Name_Product]</h5>
<p class='text-muted mb-0'>".number_format($Display_Product['Price_Product'], 3)."đ x $Display_OrderDetail[Quanlity_Order]</p>
</div>
</td>
<td>".number_format($Display_OrderDetail['Price_Order'])."đ</td>
</tr>";
$Total+= $Display_OrderDetail['Price_Order'];
}
echo"<tr>
<td colspan='2'>
<h6 class='m-0 text-right'>Total:</h6>
</td>
<td>
".number_format($Total)."đ
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div class='modal-footer'>
<form action='' method='post'>
<input type='hidden' name='ID_Order' value='".$Display_Order['ID_Order']."'>
<button type='submit' class='btn btn-success'>Đã Giao</button>
</form>
<button type='button' class='btn btn-secondary' data-dismiss='modal'>Close</button>
</div>
</div>
</div>
</div>";
}
?>
</div>
<?php
include("footeradmin.php");
?>