add_styles_page();
$db = new db_safeguard();
$repair_data_res = $db->query("pump_repair", "SELECT * FROM pump_repair WHERE record_id = '{$_GET['record_id']}'");
// echo "SELECT * FROM pump_installation WHERE record_id = '{$_GET['record_id']}'";
$repair_data = $repair_data_res->fetch_assoc();
$user_res = $db->query("users", "SELECT * FROM users WHERE record_id = '{$_SESSION['user_id']}'");
$user = $user_res->fetch_assoc();
$current_date = date("Y-m-d H:i", strtotime("+2 Hours"));
?>
×
query("jobcard_timeline", "SELECT * FROM jobcard_timeline WHERE jobcard_id = '{$_GET['jobcard_no']}' ORDER BY record_id DESC LIMIT 1");
$data = $res_data->fetch_assoc();
?>
query("jobcard_timeline", "SELECT * FROM jobcard_timeline WHERE jobcard_id = '{$repair_data['jobcard_no']}' ORDER BY record_id DESC LIMIT 1");
// echo "SELECT * FROM jobcard_timeline WHERE jobcard_id = '{$repair_data['jobcard_no']}' ORDER BY record_id DESC";
$data = $res_data->fetch_assoc();
if ($res_data->num_rows == 0 || $data['type'] == "DEPARTURE" || $data['type'] == "ARRIVED") {
$res_arrival = $db->query("jobcard_timeline", "SELECT * FROM jobcard_timeline WHERE jobcard_id = '{$repair_data['jobcard_no']}' ORDER BY record_id DESC");
// echo "SELECT * FROM jobcard_timeline WHERE jobcard_id = '{$repair_data['jobcard_no']}' ORDER BY record_id DESC";
$has_departed = false;
$has_arrived = false;
if ($res_arrival->num_rows > 0) {
while ($current_status = $res_arrival->fetch_assoc()) {
if ($current_status['type'] == "DEPARTURE") {
$has_departed = true;
}
if ($current_status['type'] == "ARRIVED") {
$has_arrived = true;
}
}
}
if ($has_departed && $has_arrived) {
$current_jc_status = new input();
$current_jc_status->value("DEPARTED AND ARRIVED");
$current_jc_status->readonly();
$current_jc_status->class("inputs");
$current_jc_status->type("hidden");
$current_jc_status->id("jc_current_status");
$current_jc_status->onchange("check_status()");
$current_jc_status->add();
// echo $repair_data['client_type'];
if ($repair_data['client_type'] == "NEW") {
} else {
$jobcard_data_res = $db->query("pump_installation", "SELECT * FROM pump_installation WHERE record_id = '{$repair_data['installation_id']}'");
// echo "SELECT * FROM pump_repair WHERE record_id = '{$repair_data['installation_id']}'";
$jobcard_data = $jobcard_data_res->fetch_assoc();
$jobcard_history_res = $db->query("jobcards", "SELECT * FROM jobcards WHERE jc_no = '{$jobcard_data['drilling_invoice']}'");
// echo "SELECT * FROM jobcards WHERE jc_no = '{$jobcard_data['drilling_invoice']}'";
$jobcard_history = $jobcard_history_res->fetch_assoc();
?>
JOCARD HISTORY
INSTALL DETAILS
PUMP SLIP
PUMP SLIP
NO SIGNATURE FOUND
SIGNATURES
Please Note: Savuki Drilling Mpumalanga
1. Cannot be held responsible for any damage or borehole collapse.
2. Steel casings must be installed on the recommendation of the drill team.
3. Will not be held liable for any damage on property.
4. No water is guaranteed even if Savuki Drilling surveyed.
5. Client pays for service of drilling, not water.
SAFETY PRECAUTION -
CUSTOMER IS RESPONSIBLE FOR COVERING OF BOREHOLE AFTER DRILLING.
SAVUKI DRILLING MPUMALANGA WILL NOT BE LIABLE FOR ANY ACCIDENTS CAUSED BY ANY UNCOVERED BOREHOLES.
EMPLOYEE SIGNATURE
EMPLOYEE SIGNATURE
CLIENT SIGNATURE
CLIENT SIGNATURE
SAVED";
} else {
}
?>
MAP
query("pump_repair", "SELECT * FROM pump_repair WHERE record_id = {$_GET['record_id']} ORDER BY record_id DESC");
$jobcard_data = $res_jobcard->fetch_assoc();
$getLocation = new button();
$getLocation->value("GET LOCATION");
$getLocation->onclick("getLocation()");
$getLocation->add();
// Latitude: -25.482210, Longitude: 30.963649
//split the string with a comma
$lat = explode(", ", $jobcard_data['map_co_ordinates'])[0];
// echo $lat;
$long = explode(", ", $jobcard_data['map_co_ordinates'])[1];
// echo $long;
?>