-
Notifications
You must be signed in to change notification settings - Fork 3
/
rider_his.php
111 lines (79 loc) · 3.2 KB
/
rider_his.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
<?php
session_start();
$rdr = $_SESSION['cusID'];
require_once("dbconnect.php");
// $sql = "SELECT *
// FROM RIDERS
// WHERE CUSID = '$rdr'";
// $exec = mysqli_query($connection, $sql);
// $rider = mysqli_fetch_all($exec, MYSQLI_ASSOC);
// $riderID = $rider[0]['riderID'];
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" type="text/css" href="style.css">
<link href="https://fonts.googleapis.com/css2?family=Open+Sans:wght@600&family=Roboto:wght@500;700&display=swap" rel="stylesheet">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<title>Delivery History</title>
</head>
<body>
<h1>Rider Order Delivery History</h1>
<?php
// Rider ID as C1003
$riderID = $rdr;
// Query to get distinct order ids for definite no of orders
$sql1= "SELECT COUNT(DISTINCT orderID)
AS orderCount
FROM orders
WHERE riderID ='$riderID'and status = 'delivered'";
$resultCountOrders = mysqli_query($connection, $sql1);
if ($resultCountOrders){
$rowCountOrders = mysqli_fetch_assoc($resultCountOrders);
$orderCount = $rowCountOrders['orderCount'];
if ($orderCount > 0) {
echo "Total Order(s) delivered: " . $orderCount . "<br>";
} else {
echo "No orders delivered yet.<br>";
}
}
$sql2 = "SELECT DISTINCT orderID
FROM orders
WHERE riderID = '$riderID'and status = 'delivered'";
$result_OIDs = mysqli_query($connection, $sql2);
$orderIDs = array();
while ($row = mysqli_fetch_assoc($result_OIDs)) {
$orderIDs[] = $row['orderID'];
}
foreach ($orderIDs as $orderID){
echo "<u>ORDER ID:". $orderID . "</u><br>";
$sql3 = "SELECT CONCAT(fname, ' ', lname) AS CusName, C.address as C_address,R.name as Res_name, R.address as Res_address
FROM Orders O, Customers C, Restaurant R
WHERE O.cusID = C.cusID AND O.resID = R.resID AND orderID = '$orderID' and status = 'delivered'";
$result_display = mysqli_query($connection, $sql3);
$numRows = mysqli_num_rows($result_display);
$sql4 = "SELECT SUM(Quantity * amount) as TP
FROM orders
WHERE orderID = '$orderID' and status = 'delivered'";
$result_TP = mysqli_query($connection, $sql4);
$totalPriceRow = mysqli_fetch_assoc($result_TP);
$totalPrice = $totalPriceRow['TP'];
for ($i = 0; $i < $numRows; $i++) {
$row = mysqli_fetch_assoc($result_display);
if ($i == 0) {
echo "from Restaurant: " . $row['Res_name'] . "<br>";
echo "located at: " . $row['Res_address'] . "<br>";
}
if ($i == 0) {
echo "to Customer: " . $row['CusName'] . "<br>";
echo "dwelling at: " . $row['C_address'] . "<br>";
}
}
echo "Total Bill collected in TK " . $totalPrice . "<br>";
echo "---------------------------------------------------<br>";
}
?>
</body>
</html>