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(); $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(); $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 = '{$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"); $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(); ?>

JOCARD HISTORY


INSTALL DETAILS




PUMP SLIP

PUMP SLIP

NO SIGNATURE FOUND

SIGNATURES

Please Note: Savuki Drilling Mpumalanga 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 { } ?>

JOBCARD




query("jobcard_timeline", "SELECT * FROM jobcard_timeline WHERE jobcard_id = '{$_GET['jobcard_no']}' ORDER BY jobcard_id DESC LIMIT 1"); // echo "SELECT * FROM jobcard_timeline WHERE jobcard_id = '{$_GET['jobcard_no']}' 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_repair"); $update_ajax->selected_div(".main_div input , .main_div select, .main_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("jobcard_time"); $riem_ajax->insert("jobcard_timeline"); $riem_ajax->add_column_and_value("jobcard_id={$_GET['jobcard_no']},date_time={$current_date},type=REPAIR,user_id={$_SESSION['user_id']}"); $riem_ajax->redirect("repair_actions.php?record_id={$_GET['record_id']}&jobcard_no={$_GET['jobcard_no']}"); $riem_ajax->exclude_inputs("payment_method"); } 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_repair"); $submit_details->selected_div(".main_div input , .main_div select, .main_div textarea"); $submit_details->redirect("repair_actions.php?record_id={$_GET['record_id']}"); $submit_details->exclude_inputs("['jc_current_status', 'eft_type']"); $submit_details->on_success("DATA CAPTURED AND SAVED"); } ?>
value("ARRIVAL"); $arrival_btn->onclick("team_arrived()"); $arrival_btn->id("arrival_button"); $arrival_btn->class('process_btn'); $current_jc_status = new input(); $current_jc_status->value("DEPARTED"); $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()"); $depart_ajax = new js_ajax(); $depart_ajax->function_name("team_arrived"); $depart_ajax->insert("jobcard_timeline"); $depart_ajax->selected_div("arrival"); $depart_ajax->add_column_and_value("jobcard_id={$repair_data['jobcard_no']},date_time={$current_date},type=ARRIVED,user_id={$_SESSION['user_id']}"); $depart_ajax->on_success("ARRIVAL CAPTURED"); // echo "SELECT * FROM jobcard_timeline WHERE jobcard_id = '{$_GET['jobcard_no']}' ORDER BY record_id DESC"; ?>
add(); $current_jc_status->add(); ?>
value("DEPARTURE"); $depart_btn->onclick("team_departed()"); $depart_btn->id("departure_button"); $depart_btn->class('process_btn'); $current_jc_status = new input(); $current_jc_status->value("START"); $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()"); $depart_ajax = new js_ajax(); $depart_ajax->function_name("team_departed"); $depart_ajax->insert("jobcard_timeline"); $depart_ajax->selected_div("departure"); $depart_ajax->add_column_and_value("jobcard_id={$repair_data['jobcard_no']},date_time={$current_date},type=DEPARTURE,user_id={$_SESSION['user_id']}"); $depart_ajax->on_success("DEPARTURE CAPTURED"); ?>
add(); $depart_btn->add(); ?>