-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathpending_orders.php
More file actions
241 lines (222 loc) · 14.2 KB
/
Copy pathpending_orders.php
File metadata and controls
241 lines (222 loc) · 14.2 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
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
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
<!DOCTYPE html><html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta http-equiv="refresh" content="60"><title>Pending Orders</title>
<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
<!-- Optional theme -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css" integrity="sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl/Sp" crossorigin="anonymous">
<!-- Latest compiled and minified JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
<style>
table tr td:last-child a span{
margin-right: 10px;
}
#loader
{
transition:all .3s ease-in-out;opacity:1;visibility:visible;position:fixed;height:100vh;width:100%;background:#fff;z-index:90000
}
#loader.fadeOut
{
opacity:0;visibility:hidden
}
.spinner
{
width:40px;height:40px;position:absolute;top:calc(50% - 20px);left:calc(50% - 20px);background-color:#333;border-radius:100%;-webkit-animation:sk-scaleout 1s infinite ease-in-out;animation:sk-scaleout 1s infinite ease-in-out
}
@-webkit-keyframes sk-scaleout
{
0%{-webkit-transform:scale(0)}100%{-webkit-transform:scale(1);opacity:0}
}
@keyframes sk-scaleout
{
0%{-webkit-transform:scale(0);transform:scale(0)}100%{-webkit-transform:scale(1);transform:scale(1);opacity:0}
}
</style>
<link href="style.css" rel="stylesheet"></head>
<body class="app">
<div id="loader"><div class="spinner"></div></div>
<script type="text/javascript">window.addEventListener('load', () => {
const loader = document.getElementById('loader');
setTimeout(() => {
loader.classList.add('fadeOut');
}, 300);
});
</script>
<div>
<div class="sidebar"><div class="sidebar-inner"><div class="sidebar-logo">
<div class="peers ai-c fxw-nw"><div class="peer peer-greed"><a class="sidebar-link td-n" href="index.html" class="td-n"><div class="peers ai-c fxw-nw"><div class="peer"><div class="logo"><img src="assets/static/images/logo.png" alt=""></div></div><div class="peer peer-greed"><h5 class="lh-1 mB-0 logo-text">Adminator</h5></div></div></a></div><div class="peer"><div class="mobile-toggle sidebar-toggle"><a href="" class="td-n"><i class="ti-arrow-circle-left"></i></a></div></div></div></div><ul class="sidebar-menu scrollable pos-r">
<li class="nav-item mT-30 active">
<a class="sidebar-link" href="index.html" default>
<span class="icon-holder">
<i class="c-blue-500 ti-home"></i>
</span>
<span class="title">Dashboard</span>
</a>
</li>
<li class="nav-item">
<a class="sidebar-link" href="add_item.php">
<span class="icon-holder">
<i class="c-brown-500 ti-email"></i>
</span>
<span class="title">Add Items</span>
</a>
</li>
<li class="nav-item">
<a class="sidebar-link" href="current_offers.php">
<span class="icon-holder">
<i class="c-blue-500 ti-share"></i>
</span>
<span class="title">Add Offers</span>
</a>
</li>
<li class="nav-item">
<a class="sidebar-link" href="pending_orders.php">
<span class="icon-holder">
<i class="c-deep-orange-500 ti-calendar"></i>
</span>
<span class="title">Pending Orders</span>
</a>
</li>
<li class="nav-item">
<a class="sidebar-link" href="cancelled_orders.php">
<span class="icon-holder">
<i class="c-deep-purple-500 ti-comment-alt"></i>
</span>
<span class="title">Cancelled Orders</span>
</a>
</li>
<li class="nav-item">
<a class="sidebar-link" href="delivered_orders.php">
<span class="icon-holder">
<i class="c-indigo-500 ti-comment-alt"></i>
</span>
<span class="title">Delivered Orders</span>
</a>
</li>
<li class="nav-item">
<a class="sidebar-link" href="todays_order.php">
<span class="icon-holder">
<i class="c-light-blue-500 ti-pencil"></i>
</span>
<span class="title">Todays Orders</span>
</a>
</li>
<li class="nav-item">
<a class="sidebar-link" href="upcoming_booking.php">
<span class="icon-holder">
<i class="c-pink-500 ti-palette"></i>
</span>
<span class="title">Upcoming Table Booking</span>
</a>
</li>
<li class="nav-item">
<a class="sidebar-link" href="completed_booking.php">
<span class="icon-holder">
<i class="c-pink-500 ti-palette"></i>
</span>
<span class="title">Past Table Booking</span>
</a>
</li>
<li class="nav-item">
<a class="sidebar-link" href="customer_review.php">
<span class="icon-holder">
<i class="c-pink-500 ti-palette"></i>
</span>
<span class="title">Customer Reviews</span>
</a>
</li>
</ul></div></div>
<div class="page-container"><div class="header navbar"><div class="header-container">
<ul class="nav-left"><li><a id="sidebar-toggle" class="sidebar-toggle" href="javascript:void(0);"><i class="ti-menu"></i></a></li><li class="search-box"><a class="search-toggle no-pdd-right" href="javascript:void(0);"><i class="search-icon ti-search pdd-right-10"></i> <i class="search-icon-close ti-close pdd-right-10"></i></a></li><li class="search-input"><input class="form-control" type="text" placeholder="Search..."></li></ul><ul class="nav-right"><li class="notifications dropdown"><span class="counter bgc-red">3</span> <a href="" class="dropdown-toggle no-after" data-toggle="dropdown"><i class="ti-bell"></i></a><ul class="dropdown-menu"><li class="pX-20 pY-15 bdB"><i class="ti-bell pR-10"></i> <span class="fsz-sm fw-600 c-grey-900">Notifications</span></li><li><ul class="ovY-a pos-r scrollable lis-n p-0 m-0 fsz-sm"><li><a href="" class="peers fxw-nw td-n p-20 bdB c-grey-800 cH-blue bgcH-grey-100"><div class="peer mR-15"><img class="w-3r bdrs-50p" src="https://randomuser.me/api/portraits/men/1.jpg" alt=""></div><div class="peer peer-greed"><span><span class="fw-500">John Doe</span> <span class="c-grey-600">liked your <span class="text-dark">post</span></span></span><p class="m-0"><small class="fsz-xs">5 mins ago</small></p></div></a></li><li><a href="" class="peers fxw-nw td-n p-20 bdB c-grey-800 cH-blue bgcH-grey-100"><div class="peer mR-15"><img class="w-3r bdrs-50p" src="https://randomuser.me/api/portraits/men/2.jpg" alt=""></div><div class="peer peer-greed"><span><span class="fw-500">Moo Doe</span> <span class="c-grey-600">liked your <span class="text-dark">cover image</span></span></span><p class="m-0"><small class="fsz-xs">7 mins ago</small></p></div></a></li><li><a href="" class="peers fxw-nw td-n p-20 bdB c-grey-800 cH-blue bgcH-grey-100"><div class="peer mR-15"><img class="w-3r bdrs-50p" src="https://randomuser.me/api/portraits/men/3.jpg" alt=""></div><div class="peer peer-greed"><span><span class="fw-500">Lee Doe</span> <span class="c-grey-600">commented on your <span class="text-dark">video</span></span></span><p class="m-0"><small class="fsz-xs">10 mins ago</small></p></div></a></li></ul></li><li class="pX-20 pY-15 ta-c bdT"><span><a href="" class="c-grey-600 cH-blue fsz-sm td-n">View All Notifications <i class="ti-angle-right fsz-xs mL-10"></i></a></span></li></ul></li><li class="notifications dropdown"><span class="counter bgc-blue">3</span> <a href="" class="dropdown-toggle no-after" data-toggle="dropdown"><i class="ti-email"></i></a><ul class="dropdown-menu"><li class="pX-20 pY-15 bdB"><i class="ti-email pR-10"></i> <span class="fsz-sm fw-600 c-grey-900">Emails</span></li><li><ul class="ovY-a pos-r scrollable lis-n p-0 m-0 fsz-sm"><li><a href="" class="peers fxw-nw td-n p-20 bdB c-grey-800 cH-blue bgcH-grey-100"><div class="peer mR-15"><img class="w-3r bdrs-50p" src="https://randomuser.me/api/portraits/men/1.jpg" alt=""></div><div class="peer peer-greed"><div><div class="peers jc-sb fxw-nw mB-5"><div class="peer"><p class="fw-500 mB-0">John Doe</p></div><div class="peer"><small class="fsz-xs">5 mins ago</small></div></div><span class="c-grey-600 fsz-sm">Want to create your own customized data generator for your app...</span></div></div></a></li><li><a href="" class="peers fxw-nw td-n p-20 bdB c-grey-800 cH-blue bgcH-grey-100"><div class="peer mR-15"><img class="w-3r bdrs-50p" src="https://randomuser.me/api/portraits/men/2.jpg" alt=""></div><div class="peer peer-greed"><div><div class="peers jc-sb fxw-nw mB-5"><div class="peer"><p class="fw-500 mB-0">Moo Doe</p></div><div class="peer"><small class="fsz-xs">15 mins ago</small></div></div><span class="c-grey-600 fsz-sm">Want to create your own customized data generator for your app...</span></div></div></a></li><li><a href="" class="peers fxw-nw td-n p-20 bdB c-grey-800 cH-blue bgcH-grey-100"><div class="peer mR-15"><img class="w-3r bdrs-50p" src="https://randomuser.me/api/portraits/men/3.jpg" alt=""></div><div class="peer peer-greed"><div><div class="peers jc-sb fxw-nw mB-5"><div class="peer"><p class="fw-500 mB-0">Lee Doe</p></div><div class="peer"><small class="fsz-xs">25 mins ago</small></div></div><span class="c-grey-600 fsz-sm">Want to create your own customized data generator for your app...</span></div></div></a></li></ul></li><li class="pX-20 pY-15 ta-c bdT"><span><a href="" class="c-grey-600 cH-blue fsz-sm td-n">View All Email <i class="fs-xs ti-angle-right mL-10"></i></a></span></li></ul></li><li class="dropdown"><a href="" class="dropdown-toggle no-after peers fxw-nw ai-c lh-1" data-toggle="dropdown"><div class="peer mR-10"><img class="w-2r bdrs-50p" src="https://randomuser.me/api/portraits/men/10.jpg" alt=""></div><div class="peer"><span class="fsz-sm c-grey-900">John Doe</span></div></a><ul class="dropdown-menu fsz-sm"><li><a href="" class="d-b td-n pY-5 bgcH-grey-100 c-grey-700"><i class="ti-settings mR-10"></i> <span>Setting</span></a></li><li><a href="" class="d-b td-n pY-5 bgcH-grey-100 c-grey-700"><i class="ti-user mR-10"></i> <span>Profile</span></a></li><li><a href="" class="d-b td-n pY-5 bgcH-grey-100 c-grey-700"><i class="ti-email mR-10"></i> <span>Messages</span></a></li><li role="separator" class="divider"></li><li><a href="" class="d-b td-n pY-5 bgcH-grey-100 c-grey-700"><i class="ti-power-off mR-10"></i> <span>Logout</span></a></li></ul></li></ul></div></div>
<main class="main-content bgc-grey-100">
<div id="mainContent"><div class="container-fluid">
<h2 class="c-grey-900 mT-10 mB-30">Pending Orders Full Report</h2>
<div class="row"><div class="col-md-12">
<div class="bgc-white bd bdrs-3 p-20 mB-20">
<table id="dataTable" class="table table-striped table-bordered" cellspacing="0" width="100%">
<?php
$dbhost = 'localhost:3306';
$dbuser = 'root';
$dbpass = '';
$dbname = 'food';
$conn = mysqli_connect($dbhost, $dbuser, $dbpass,$dbname);
if(! $conn ) {
die('Could not connect: ' . mysqli_error());
}
//echo 'Connected successfully</br>';
// $sql = 'SELECT * FROM basic WHERE psta="$psta"';
$sql= "SELECT * FROM customerdetail WHERE status='Pending' ";
//echo $psta;
if($result = mysqli_query($conn, $sql)) {
if(mysqli_num_rows($result) > 0) {
echo "<thead>";
echo "<tr>";
echo"<th>O_Id</th>";
echo"<th>First Name</th>";
echo"<th>Sur Name</th>";
echo"<th>Street</th>";
echo"<th>City</th>";
echo"<th>Phone</th>";
echo"<th>Email</th>";
echo"<th>Delivery Time</th>";
echo"<th>Total</th>";
echo"<th>Status</th>";
echo"<th>Actions</th>";
echo"</tr>";
echo"</thead>";
echo "<tfoot>";
echo "<tr>";
echo"<th>O_Id</th>";
echo"<th>First Name</th>";
echo"<th>Sur Name</th>";
echo"<th>Street</th>";
echo"<th>City</th>";
echo"<th>Phone</th>";
echo"<th>Email</th>";
echo"<th>Delivery Time</th>";
echo"<th>Total</th>";
echo"<th>Status</th>";
echo"<th>Actions</th>";
echo"</tr>";
echo"</tfoot>";
echo"<tbody>";
while($row = mysqli_fetch_array($result)){
echo "<tr>";
echo "<td>" . $row['id'] . "</td>";
echo "<td>" . $row['firstname'] . "</td>";
echo "<td>" . $row['surname'] . "</td>";
echo "<td>" . $row['street'] . "</td>";
echo "<td>" . $row['city'] . "</td>";
echo "<td>" . $row['phone'] . "</td>";
echo "<td>" . $row['email'] . "</td>";
echo "<td>" . $row['deliverytime'] . "</td>";
echo "<td>" . $row['total'] . "</td>";
echo "<td>" . $row['status'] . "</td>";
echo "<td>";
echo "<a href='update_current_orders.php?id=". $row['id'] . "' title='View Order' data-toggle='tooltip'><span class='glyphicon glyphicon-pencil'></span></a>";
echo "</td>";
echo "</tr>";
}
echo "</tbody>";
mysqli_free_result($result);
} else {
echo "No records matching your query were found.";
}
} else {
echo "ERROR: Could not able to execute $sql. " . mysqli_error($conn);
}
mysqli_close($conn);
?>
</table>
</div></div>
</div></div>
</div>
</main>
<footer class="bdT ta-c p-30 lh-0 fsz-sm c-grey-600"><span>Copyright © 2017 Designed by <a href="../../index.html" target="_blank" title="Colorlib">StartUp Millenium</a>. All rights reserved.</span><!-- Global site tag (gtag.js) - Google Analytics -->
<script async src="https://www.googletagmanager.com/gtag/js?id=UA-23581568-13"></script>
<script>
window.dataLayer = window.dataLayer || [];
function gtag(){dataLayer.push(arguments);}
gtag('js', new Date());
gtag('config', 'UA-23581568-13');
</script>
</footer></div></div><script type="text/javascript" src="vendor.js"></script><script type="text/javascript" src="bundle.js"></script></body></html>