query(
"jobcards",
"SELECT * FROM jobcards WHERE status = 1 AND user_id != 1"
);
/* =========================
COORDINATE PARSER
========================= */
function parseCoordinates(?string $raw, float $defLat = -25.5653, float $defLng = 30.5279): array
{
if ($raw === null || trim($raw) === '') return [$defLat, $defLng];
$raw = trim($raw);
if (preg_match('/\d+:\d+/', $raw)) return [$defLat, $defLng];
$clean = str_replace(['°', "'", '"', '?', ','], ' ', $raw);
$clean = preg_replace('/\s+/', ' ', trim($clean));
preg_match_all('/-?\d+(?:\.\d+)?/', $clean, $m);
$n = $m[0];
if (count($n) >= 2) {
$lat = (float)$n[0];
$lng = (float)$n[1];
if (preg_match('/[Ss]/', $raw)) $lat = -abs($lat);
if (preg_match('/[Ww]/', $raw)) $lng = -abs($lng);
if ($lat >= -35 && $lat <= -22 && $lng >= 16 && $lng <= 33) {
return [$lat, $lng];
}
}
return [$defLat, $defLng];
}
/* =========================
BUILD PHP ARRAY
========================= */
$locations = [];
if ($res->num_rows > 0) {
while ($row = $res->fetch_assoc()) {
[$lant, $long] = parseCoordinates($row['drill_co_ordinates']);
$total_res = $db->query(
"jobcard_timeline",
"SELECT type, meters FROM jobcard_timeline WHERE jobcard_id = '{$row['jc_no']}'"
);
$tr = $td = $tc = $tb = 0;
while ($t = $total_res->fetch_assoc()) {
if ($t['type'] === 'RIEMING_STOP' || $t['type'] === 'RIEMING_PAUSE') $tr += (float)$t['meters'];
elseif ($t['type'] === 'DRILLING_STOP' || $t['type'] === 'DRILLING_PAUSE') $td += (float)$t['meters'];
elseif ($t['type'] === 'CASING_STOP' || $t['type'] === 'CASING_PAUSE') $tc += (float)$t['meters'];
elseif ($t['type'] === 'BLASTING_STOP' || $t['type'] === 'BLASTING_PAUSE') $tb += (float)$t['meters'];
}
$locations[] = [
'latitude' => $lant,
'longitude' => $long,
'action_date' => $row['action_date'],
'jobcard' => $row['jc_no'],
'water_flow' => $row['water_flow'],
'rieming' => $tr,
'drilling' => $td,
'casing' => $tc,
'blasting' => $tb,
];
}
}
$js_array = json_encode($locations, JSON_HEX_TAG | JSON_HEX_APOS | JSON_HEX_QUOT);
?>
Jobcard Locations