add_styles_page();
$db = new db_safeguard();
// $data = [
// 'Math' => 85,
// 'Science' => 70,
// 'English' => 90,
// 'History' => 60,
// 'Art' => 75
// ];
// // $html->bar_graph_percentage($data);
// $data_1 = [
// 'Apples' => 150,
// 'Bananas' => 90,
// 'Oranges' => 120,
// 'Grapes' => 60
// ];
// // $html->bar_graph_horizontal($data_1);
// $data_2 = [
// 'Jan' => 50,
// 'Feb' => 80,
// 'Mar' => 120,
// 'Apr' => 100,
// 'May' => 70
// ];
$jobcards_res = $db->query("jobcard_timeline", "SELECT * FROM jobcard_timeline");
$job_card_res = $db->query("jobcard_timeline", "SELECT * FROM jobcard_timeline ORDER BY record_id ASC");
if ($job_card_res->num_rows == 0) {
echo "
NOT STARTED YET
";
} else {
$meters_drilling = 0;
while ($job_card = $job_card_res->fetch_assoc()) {
if ($job_card['type'] == "RIEM_STOP") {
$riem_meters += $job_card['meters'];
}
if ($job_card['type'] == 'DRILLING_STOP') {
$meters_drilling += $job_card['meters'];
}
if ($job_card['type'] == "CASING_STOP") {
$casing_meters += $job_card['meters'];
}
}
$data_2 = [
'RIEM' => $riem_meters,
'DRILL' => $meters_drilling,
'CASING' => $casing_meters,
];
}
?>
TOTAL METERS REPORT
bar_graph_vertical($data_2);
?>