query("jobcard_timeline", "SELECT * FROM jobcard_timeline WHERE jobcard_id = {$_GET['record_id']} ORDER BY record_id ASC");
if ($res_data->num_rows > 0) {
$jobcard_res = $db->query("jobcards", "SELECT * FROM jobcards WHERE record_id = {$_GET['record_id']}");
$jobcard = $jobcard_res->fetch_assoc();
// echo $jobcard['record_id'];
?>
JOBCARD SUMMARY
| TYPE |
METERS |
DATE |
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'];
}
?>
| |
|
|
| |
TOTAL |
| TOTAL RIEM METERS |
|
| TOTAL DRILLING METERS |
|
| TOTAL CASING METERS |
|
| TOTAL BLASTING METERS |
|