query("jobcards", "SELECT * FROM jobcards WHERE jc_no = $jc_no");
$data = $data_res->fetch_assoc();
$res = $db->query(
"jobcard_timeline",
"SELECT * FROM jobcard_timeline
WHERE jobcard_id = {$data['record_id']}"
);
$riem = 0;
$drill = 0;
$casing = 0;
$blast = 0;
while ($row = $res->fetch_assoc()) {
if (in_array($row['type'], ['RIEMING', 'RIEMING_START', 'RIEMING_STOP', 'RIEMING_STOP', 'RIEMING_PAUSED'])) {
$riem += (float) $row['meters'];
}
if (in_array($row['type'], ['DRILLING', 'DRILLING_START', 'DRILLING_STOP', 'DRILLING_PAUSE'])) {
$drill += (float) $row['meters'];
}
if (in_array($row['type'], ['CASING', 'CASING_START', 'CASING_STOP', 'CASING_PAUSE'])) {
$casing += (float) $row['meters'];
}
if (in_array($row['type'], ['BLASTING', 'BLASTING_PAUSE', 'BLASTING_START', 'BLASTING_STOP'])) {
$blast += (float) $row['meters'];
}
}
?>
CURRENT TOTAL METERS
RIEMING: m
DRILLING: m
CASING: m
BLASTING: m