JOB CARD TIMELINE
query("jobcard_timeline", "SELECT * FROM jobcard_timeline WHERE jobcard_id={$jobcards['jc_no']} ORDER BY record_id DESC");
// echo "SELECT * FROM jobcard_timeline WHERE jobcard_id={$_GET['record_id']} ORDER BY record_id DESC";
$riem_meters = 0;
$drilling_meters = 0;
$casing_meters = 0;
$blasting_meters = 0;
while ($meters_data = $last_meters->fetch_assoc()) {
if (
$meters_data['type'] == "RIEM_STOP" || $meters_data['type'] == "RIEMING_STOP" || $meters_data['type'] ==
"RIEMING_PAUSED"
) {
$riem_meters += $meters_data['meters'];
}
if ($meters_data['type'] == "DRILLING_STOP" || $meters_data['type'] == "DRILLING_PAUSE") {
$drilling_meters += $meters_data['meters'];
}
if ($meters_data['type'] == "CASING_STOP" || $meters_data['type'] == "CASING_PAUSE") {
$casing_meters += $meters_data['meters'];
}
if ($meters_data['type'] == "BLASTING_START" || $meters_data['type'] == "BLASTING_STOP") {
$blasting_meters += $meters_data['meters'];
}
}
?>
| USER |
TYPE |
SERIAL NO |
DATE TIME |
METERS |
fetch_assoc()) {
$user_name_res = $db->query("users", "SELECT * FROM users WHERE record_id = '$timeline[user_id]'");
$user_name = $user_name_res->fetch_assoc();
?>
|
|
|
|
|
CURRENT TOTAL METERS:
TOTAL RIEMING: METERS
TOTAL DRILLING: METERS
TOTAL CASING: METERS
TOTAL BLASTING: METERS
query("jobcard_timeline", "SELECT * FROM jobcard_timeline WHERE jobcard_id={$jobcards['jc_no']} ORDER BY record_id DESC");
// echo "SELECT * FROM jobcard_timeline WHERE jobcard_id={$_GET['record_id']} ORDER BY record_id DESC";
$riem_meters = 0;
$drilling_meters = 0;
$casing_meters = 0;
$blasting_meters = 0;
while ($meters_data = $last_meters->fetch_assoc()) {
if (
$meters_data['type'] == "RIEM_STOP" || $meters_data['type'] == "RIEMING_STOP" || $meters_data['type'] ==
"RIEMING_PAUSED"
) {
$riem_meters += $meters_data['meters'];
}
if ($meters_data['type'] == "DRILLING_STOP" || $meters_data['type'] == "DRILLING_PAUSE") {
$drilling_meters += $meters_data['meters'];
}
if ($meters_data['type'] == "CASING_STOP" || $meters_data['type'] == "CASING_PAUSE") {
$casing_meters += $meters_data['meters'];
}
if ($meters_data['type'] == "BLASTING_START" || $meters_data['type'] == "BLASTING_STOP") {
$blasting_meters += $meters_data['meters'];
}
}
?>
CURRENT TOTAL METERS:
TOTAL RIEMING: METERS
TOTAL DRILLING: METERS
TOTAL CASING: METERS
TOTAL BLASTING: METERS
query("jobcard_timeline", "SELECT * FROM jobcard_timeline WHERE jobcard_id={$jobcards['jc_no']} ORDER BY record_id DESC LIMIT 1");
// $last_action_data = $last_action->fetch_assoc();
?>
LAST ACTION: