-
Notifications
You must be signed in to change notification settings - Fork 0
/
All_Work_Order.php
123 lines (111 loc) · 5.22 KB
/
All_Work_Order.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
112
113
114
115
116
117
118
119
120
121
122
123
<html>
<head>
<title>All Work Order | Fleet Management System</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-wEmeIV1mKuiNpC+IOBjI7aAzPcEZeedi5yW5f2yOq55WWLwNGmvvx4Um1vskeMj0" crossorigin="anonymous">
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0/dist/js/bootstrap.bundle.min.js" integrity="sha384-p34f1UUtsS3wqzfto5wAAmdvj+osOnFyQFpp4Ua3gs/ZVWx6oOypYoCJhGGScy+8" crossorigin="anonymous"></script>
</head>
<body class="form-control">
<div>
<header>
<nav class="navbar navbar-expand-lg navbar-dark " style="background-color: #053D4F">
<div class="container">
<a class="navbar-brand" href="dashboard.php">
<img src="./img/Mechanic_koi.PNG" alt="" width="80" height="60">
</a>
</div>
<div class="container">
<div class="collapse navbar-collapse" id="navbarNavDropdown">
<ul class="navbar-nav">
<li class="nav-item">
<a class="nav-link" aria-current="page" href="dashboard.php"><img src="./img/speedometer.PNG" alt="" width="30" height="30">Dashboard</a>
</li>
<li class="nav-item dropdown">
<a class="nav-link dropdown-toggle" href="#" id="navbarDropdownMenuLink" role="button" data-bs-toggle="dropdown" aria-expanded="false"><img src="./img/car.PNG" alt="" width="30" height="30">Vehicles</a>
<ul class="dropdown-menu" aria-labelledby="navbarDropdownMenuLink">
<li><a class="dropdown-item" href="All_Vehicle.php">All Vehicles</a></li>
<li><a class="dropdown-item" href="AddVehicle.php">Add Vehicles</a></li>
</ul>
</li>
<li class="nav-item dropdown">
<a class="nav-link dropdown-toggle" href="#" id="navbarDropdownMenuLink" role="button" data-bs-toggle="dropdown" aria-expanded="false"><img src="./img/mechanic.svg" alt="" width="30" height="30">Mechanics</a>
<ul class="dropdown-menu" aria-labelledby="navbarDropdownMenuLink">
<li><a class="dropdown-item" href="All_Mechanics.php">All Mechanics</a></li>
<li><a class="dropdown-item" href="Add_Mechanics.php">Add Mechanics</a></li>
</ul>
</li>
<li class="nav-item">
<a class="nav-link" href="#"><img src="./img/Tracking.svg" alt="" width="30" height="30">Tracking</a>
</li>
<li class="nav-item dropdown">
<a class="nav-link dropdown-toggle active" href="#" id="navbarDropdownMenuLink" role="button" data-bs-toggle="dropdown" aria-expanded="false"><img src="./img/notepad.svg" alt="" width="30" height="30">Work Orders</a>
<ul class="dropdown-menu" aria-labelledby="navbarDropdownMenuLink">
<li><a class="dropdown-item" href="All_Work_Order.php">All Work Orders</a></li>
<li><a class="dropdown-item" href="Add_Work_Order.php">Add Work Orders</a></li>
</ul>
</li>
</ul>
<li class="nav-item">
<a class="nav-link" style="color:#FFFFFF8C !important; text-decoration:none; margin-top:-25px;" href="./php/logout.php">LOGOUT</a>
</li>
</div>
</div>
</nav>
</header>
</div>
<div class="container">
<div class="table-responsive">
<h2>Work Order List</h2>
<br />
<table class="table table-bordered table-striped" id="work_order_list">
<tr>
<th>Vehicle Id</th>
<th>Date</th>
<th>Work Order Title</th>
<th>Issue Description</th>
<th>Assigned To</th>
<th>Deadline</th>
<th>Total Cost</th>
<th>Status</th>
</tr>
<?php
include("connection.php");
error_reporting(0);
$query= "SELECT * FROM WORK_ORDER_LIST";
$data = mysqli_query($conn,$query);
$total = mysqli_num_rows($data);
//echo $result['vehicleid']." ".$result['brand_Model']." ".$result['license']." ".$result['Color']." ".$result['Owner_name']." ".$result['email']." ".$result['mobile'];
//echo $total;
if($total!=0)
{
//$result = mysqli_fetch_assoc($data);
while($result = mysqli_fetch_assoc($data))
{
echo "
<tr>
<td>".$result['vehicle_id']."</td>
<td>".$result['date']."</td>
<td>".$result['work_order_title']."</td>
<td>".$result['issue_description']."</td>
<td>".$result['assigned_to']."</td>
<td>".$result['deadline']."</td>
<td>".$result['total_cost']."</td>
<td>".$result['status']."</td>
</tr>
";
}
//echo "Table has records";
}
else{
echo "No records found";
}
?>
</table>
</div>
</div>
<footer style="padding: 20px; margin-top: 140px; color: #ffffff; background-color: #053D4F; text-align: center; border-top: #e8491d 3px solid;position: fixed; left:0;bottom: 0;width: 100%;text-align: center;">
<p>Fleet Management System, Copyright © Mechanic Koi</p>
</footer>
</body>
</html>