Dynamic_Checksheet/maint.php at main · jgarbe/Dynamic_Checksheet · GitHub

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


<?php
/////////////////////////////////////////////////////////////////////
//
//	Written by Jim Garbe-- Dynamic Checksheet
//
/////////////////////////////////////////////////////////////////////
	require_once('inc/appvars.php');  // Set the Variables
	require_once('inc/connectvars.php');  // Set the username connection variables.
	require_once('inc/functions.php.inc'); // bring in the functions.
	require_once("inc/maintmerge.inc.php");
	//require_once("inc/mailvars.php");
  $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
print ("<div style=background-color:blue; >");

print ("<table border=1px style= color:yellow;>");
print ("<tr>");
		print ("\t\t<th>\n");
			print ("\t\t\tChecksheet");
		print ("\n\t\t</th>\n");

		print ("\t\t<th>\n");
			print ("\t\t\tOdometer\n");
		print ("\t\t</th>\n");

		print ("\t\t<th>\n");
			print ("\t\t\tService Due\n");
		print ("\t\t</th>\n");

		print ("\t\t<th>\n");
			print ("\t\t\tDifference\n");
		print ("\t\t</th>\n");

		print ("\t\t<th>\n");
			print ("\t\t\tUnresolved Maintenance Notes\n");
		print ("\t\t</th>\n");


print ("</tr>\n");

	$cquery="SELECT * FROM Checksheets WHERE veh = '1' ORDER BY ChecksheetName";
  $cdata = mysqli_query($dbc, $cquery);
 	while ($c_row=mysqli_fetch_array($cdata)) {
	print ("<tr>");
	$CS=$c_row['ChecksheetName'];
	print("<td>".$CS."</td>");
	$query="SELECT ".$CS."_events.*, ".$CS."_checksheet.result FROM ".$CS."_checksheet,".$CS."_events WHERE ".$CS."_events.id =  ".$CS."_checksheet.event_id AND ".$CS."_checksheet.item_id = 1 AND UNIX_TIMESTAMP(".$CS."_events.date) >=".(time()-86400)." LIMIT 1";
  $data = mysqli_query($dbc, $query);
if ($row=mysqli_fetch_array($data)) {
	$miles=$row['result'];
print("<td>".$row['result']."</td>\n");
} else {
print("<td>-</td>\n");
}//end query for odometer

	$query2="SELECT ".$CS."_events.*, ".$CS."_checksheet.result FROM ".$CS."_checksheet,".$CS."_events WHERE ".$CS."_events.id =  ".$CS."_checksheet.event_id AND ".$CS."_checksheet.item_id = 2 AND UNIX_TIMESTAMP(".$CS."_events.date) >='".(time()-86400)."'";
  $data2 = mysqli_query($dbc, $query2);
if ($row2=mysqli_fetch_array($data2)) {
	$service=$row2['result'];
print("<td>".$row2['result']."</td>\n");

}else {
print("<td>-</td>\n");
} //end query for service miles
if (!empty($service)&& !empty($miles)){
if ($service <= $miles){
	$ODmileage=$miles-$service;
	print("\t<td>".$ODmileage." Overdue</td>\n");
$service=NULL;
$miles=NULL;
} else {

	$Smileage=$service-$miles;
	print("\t<td>".$Smileage." Until Next Service Due</td>\n");
$service=NULL;
$miles=NULL;
}
} else {
 print("<td>-</td>\n");
}// end finding difference between service and odometer


print("<td><ol>\n");
$query3="SELECT Comment_.*,Maintenance.*  FROM Comment_,Maintenance WHERE Maintenance.comments_id = Comment_.comment_id AND Maintenance.resolved = 0 AND Maintenance.checksheet_id = '".checksheetnotochecksheet_id($CS)."'";
  $data3 = mysqli_query($dbc, $query3);
while ($row3=mysqli_fetch_array($data3)) {

	$maint_note=$row3['_comment'];
print("<li>".$maint_note."</li>\n");

}
print("</ol></td>\n");

print("</tr>\n");
}

print ("</table>\n");

print ("</div>\n");
  mysqli_close($dbc);

?>