query("jobcards", "SELECT * FROM jobcards WHERE jc_no = {$jc_no}");
if ($jobcard_data_res->num_rows > 0) {
$jobcard_data = $jobcard_data_res->fetch_assoc();
$res_data = $db->query("jobcard_timeline", "SELECT * FROM jobcard_timeline WHERE jobcard_id = {$jobcard_data['record_id']} ORDER BY record_id ASC");
$riem_meters = 0;
$drilling_meters = 0;
$casing_meters = 0;
$blasting_meters = 0;
$rows = "";
while ($jc_timeline = $res_data->fetch_assoc()) {
if ($jc_timeline['type'] == "RIEM_STOP" || $jc_timeline['type'] == "RIEMING_STOP") {
$riem_meters += $jc_timeline['meters'];
}
if ($jc_timeline['type'] == "DRILLING_STOP") {
$drilling_meters += $jc_timeline['meters'];
}
if ($jc_timeline['type'] == "CASING_STOP") {
$casing_meters += $jc_timeline['meters'];
}
if ($jc_timeline['type'] == "BLASTING_START" || $jc_timeline['type'] == "BLASTING_STOP") {
$blasting_meters += $jc_timeline['meters'];
}
$rows .= "
| {$jc_timeline['type']} |
{$jc_timeline['meters']} |
{$jc_timeline['date_time']} |
{$jc_timeline['serial_number']} |
";
}
echo "
| TYPE |
METERS |
DATE |
SERIAL NO |
{$rows}
|
TOTAL |
| TOTAL RIEM METERS |
{$riem_meters} |
| TOTAL DRILLING METERS |
{$drilling_meters} |
| TOTAL CASING METERS |
{$casing_meters} |
| TOTAL BLASTING METERS |
{$blasting_meters} |
";
} else {
echo "No timeline data found.
";
}
?>