query(
"jobcards",
"SELECT * FROM jobcards WHERE status = 1 AND user_id != 1"
);
/* =========================
BUILD JS ARRAY
========================= */
$js_array = "[";
$first = true;
if ($res->num_rows > 0) {
while ($row = $res->fetch_assoc()) {
/* =========================
COORDINATES
========================= */
if (strpos($row['drill_co_ordinates'], ":") !== false) {
$lant = -25.5653;
$long = 30.5279;
} else {
$co_ordinates = str_replace("?", "°", $row['drill_co_ordinates']);
$location = explode(" ", trim($co_ordinates));
$lant = isset($location[0]) ? (float)$location[0] : -25.5653;
$long = isset($location[1]) ? (float)$location[1] : 30.5279;
}
/* =========================
TOTAL METERS
========================= */
$total_res = $db->query(
"jobcard_timeline",
"SELECT * FROM jobcard_timeline WHERE jobcard_id = '{$row['jc_no']}'"
);
$total_rieming = 0;
$total_drilling = 0;
$total_casing = 0;
while ($total = $total_res->fetch_assoc()) {
if ($total['type'] === "RIEMING_STOP") {
$total_rieming += (float)$total['meters'];
} elseif ($total['type'] === "DRILLING_STOP") {
$total_drilling += (float)$total['meters'];
} elseif ($total['type'] === "CASING_STOP") {
$total_casing += (float)$total['meters'];
}
}
if (!$first) $js_array .= ",";
$first = false;
$js_array .= "{
latitude: {$lant},
longitude: {$long},
action_date: '{$row['action_date']}',
jobcard: '{$row['jc_no']}',
client: '{$row['client_id']}',
water_flow: '{$row['water_flow']}',
rieming: {$total_rieming},
drilling: {$total_drilling},
casing: {$total_casing}
}";
}
}
$js_array .= "]";
?>
Saved Jobcard Locations
Saved Jobcard Locations