query("jobcards", "SELECT * FROM jobcards WHERE status = 1 AND user_id != 1");
$js_array = "[";
if ($res->num_rows > 0) {
$first = true;
while ($row = $res->fetch_assoc()) {
if (strpos($row['drill_co_ordinates'], ":")) {
$lant = -25.482195;
$long = 30.963575;
} else {
$co_ordinates = str_replace("?", "°", $row['drill_co_ordinates']);
$location = explode(" ", $co_ordinates);
$lant = $location[0];
$long = $location[1];
?>
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 += $total['meters'];
// echo $total_rieming;
?>
fetch_assoc()) {
if (strpos($row['type'], "RIEMING_STOP")) {
$total_rieming = $total_rieming + $row['meters'];
} elseif (strpos($row['type'], "DRILLING_STOP")) {
$total_drilling = $total_drilling + $row['meters'];
} elseif (strpos($row['type'], "CASING_STOP")) {
$total_casing = $total_casing + $row['meters'];
}
}
?>
Saved Locations Viewer
Saved Jobcard Locations