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