add_styles_page();
$db = new db_safeguard();
$jobcard_data_res = $db->query("pump_installation", "SELECT * FROM pump_installation WHERE record_id = '{$_GET['record_id']}'");
$jobcard_data = $jobcard_data_res->fetch_assoc();
$jobcard_history_res = $db->query("jobcards", "SELECT * FROM jobcards WHERE jc_no = '{$jobcard_data['drilling_invoice']}'");
$jobcard_history = $jobcard_history_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 = '{$jobcard_data['jobcard_no']}' ORDER BY record_id DESC LIMIT 1");
// echo "SELECT * FROM jobcard_timeline WHERE jobcard_id = '{$jobcard_data['jobcard_no']}' ORDER BY record_id DESC LIMIT 1";
$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 = '{$_GET['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();
?>
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";
}
?>
MAP
query("pump_installation", "SELECT * FROM pump_installation WHERE record_id = {$_GET['record_id']} ORDER BY record_id DESC");
$jobcard_data = $res_jobcard->fetch_assoc();
//split the string with a comma
$lat = explode(", ", $jobcard_data['map_co_ordinates'])[0];
$long = explode(", ", $jobcard_data['map_co_ordinates'])[1];
?>
Getting location...
JOBCARD
`
query("jobcard_timeline", "SELECT * FROM jobcard_timeline WHERE jobcard_id = '{$_GET['jobcard_no']}' ORDER BY record_id DESC LIMIT 1");
// echo "SELECT * FROM jobcard_timeline WHERE jobcard_id = {$_GET['record_id']} ORDER BY record_id DESC LIMIT 1";
$record_res = $res_arrival->fetch_assoc();
if ($record_res['type'] == "ARRIVED") {
$next_btn = new button();
$next_btn->style("margin-top: 5vw; margin-bottom: 3vw;");
$next_btn->value("SAVE");
$next_btn->onclick("if (check()) { update_jobcard(); next(); }");
$next_btn->add();
$update_ajax = new js_ajax();
$update_ajax->function_name("update_jobcard");
$update_ajax->update("pump_installation");
$update_ajax->selected_div(".install_div input , .install_div select, .install_div textarea");
$update_ajax->add_column_and_value("record_id={$_GET['record_id']}");
$update_ajax->on_success("DATA CAPTURED AND SAVED");
$riem_ajax = new js_ajax();
$riem_ajax->function_name("next");
$riem_ajax->selected_div("install_job_data");
$riem_ajax->insert("jobcard_timeline");
$riem_ajax->add_column_and_value("jobcard_id={$_GET['jobcard_no']},date_time={$current_date},type=INSTALLING,user_id={$_SESSION['user_id']}");
$riem_ajax->redirect("install_actions.php?record_id={$_GET['record_id']}&jobcard_no={$_GET['jobcard_no']}");
$riem_ajax->exclude_inputs("['jc_current_status', 'eft_type', 'payment_method']");
$riem_ajax->on_success("DATA CAPTURED AND SAVED");
} elseif ($record_res['type'] == "DEPARTED") {
$next_btn = new button();
$next_btn->value("DISABLED");
$next_btn->style("background-color: #00008045; color: white;");
$next_btn->add();
} else {
$next_btn = new button();
$next_btn->value("NEXT");
$next_btn->onclick("submit_jobcard()");
$next_btn->add();
$submit_details = new js_ajax();
$submit_details->function_name("submit_jobcard");
$submit_details->update("pump_installation");
$submit_details->selected_div(".install_div input , .install_div select, install_div textarea");
$submit_details->redirect("install_actions.php?record_id={$_GET['record_id']}&jobcard_no={$_GET['jobcard_no']}");
$submit_details->exclude_inputs("['jc_current_status', 'eft_type', 'payment_method']");
$submit_details->on_success("DATA UPDATED");
}
?>