add_styles_page(); $db = new db_safeguard(); session_start(); $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']}'"); $jobcard_history = $jobcard_history_res->fetch_assoc(); $user_res = $db->query("users", "SELECT * FROM users WHERE record_id = '{$_SESSION['user_id']}'"); $users = $user_res->fetch_assoc(); $current_date_time = date("Y-m-d H:i", strtotime("+2 Hours")); /////////////////////////////// NOTES POPUP SECTION //////////////////////////////////////////////// $jobcard_id = new input(); $jobcard_id->type("hidden"); $jobcard_id->name("jobcard_id"); $jobcard_id->id("jobcard_id"); $jobcard_id->value($_GET['record_id']); $date_time = new input(); $date_time->type("hidden"); $date_time->name("date_time"); $date_time->id("date_time"); $date_time->value($current_date_time); $reasons_label = new label(); $reasons_label->class("big_labels"); $reasons_label->for("reasons"); $reasons_label->value("REASONS"); $reasons_label->addAttribute("style", " color: white;"); $reasons = new select(); $reasons->class("big_inputs"); $reasons->addAttribute("style", "width: 90%;"); $reasons->name("reason"); $reasons->id("reason"); $reasons->add_option("ARRIVED AT LOCATION", "ARRIVED AT LOCATION"); $reasons->add_option("WAITING FOR CLIENT", "WAITING FOR CLIENT"); $reasons->add_option("TRAVELING TO SITE", "TRAVELING TO SITE"); $reasons->add_option("ARRIVED ON SITE", "ARRIVED ON SITE"); $reasons->add_option("TALKING TO CLIENT", "TALKING TO CLIENT"); $reasons->add_option("FETCHING MONEY", "FETCHING MONEY"); $reasons->add_option("BRAKING", "BRAKING"); $reasons->add_option("CHANGING RIEMER", "CHANGING RIEMER"); $reasons->add_option("STOP", "STOP"); $reasons->add_option("PENDING", "PENDING"); $reasons->add_option("START", "START"); $reasons->add_option("INSTALLING", "INSTALLING"); $reasons->add_option("RECEIVED", "RECEIVED"); $reasons->add_option("BACK TO WORKSHOP", "BACK TO WORKSHOP"); $reasons->add_option("OTHER", "OTHER"); $notes_label = new label(); $notes_label->class("notes_heading"); $notes_label->for("notes"); $notes_label->value("NOTES"); $notes_label->addAttribute("style", "color: white; margin:1px;"); $pump_slip_label = new label(); $pump_slip_label->class("big_labels"); $pump_slip_label->for("pump_slip"); $pump_slip_label->value("PUMP SLIP"); $notes_sub_label = new label(); $notes_sub_label->class("big_labels"); $notes_sub_label->for("notes"); $notes_sub_label->value("NOTES"); $notes_sub_label->addAttribute("style", " color: white;"); $notes_image_label = new label(); $notes_image_label->class("big_labels"); $notes_image_label->for("notes"); $notes_image_label->value("NOTE IMAGE"); $notes_image_label->addAttribute("style", " color: white;"); $add_notes = new button(); $add_notes->value("ADD NOTES"); $add_notes->onclick("add_notes()"); $add_notes->style("width: 100%;"); $add_notes->id("notes_btn"); $notes_ajax = new js_ajax(); $notes_ajax->function_name("add_notes"); $notes_ajax->insert("notes"); $notes_ajax->selected_div(".notes_content input , .notes_content select, .notes_content textarea"); $notes_ajax->submit_btn_id("notes_btn"); $notes_ajax->on_success("NOTE SAVED"); $make_notes_btn = new button(); $make_notes_btn->value("MAKE NOTES"); $make_notes_btn->onclick("open_notesPopup()"); ?>
× 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(); $data_type = new input(); $data_type->class("inputs"); $data_type->type("hidden"); $data_type->readonly(); $data_type->value($data['type']); $data_type->add(); $date_time->add(); $notes_label->add(); ?>
add(); $reasons->add(); $notes_sub_label->add(); ?>
add(); // new camera('notes_image_image', $_GET['record_id'], '../jobcards/notes_image/', 'notes_image'); ?>
add(); ?>
query("notes", "SELECT * FROM notes WHERE jobcard_id = '{$_GET['jobcard_no']}' AND reason NOT LIKE '%BIT%' AND reason NOT LIKE '%INSTALL%'"); if ($notes_res->num_rows > 0) { while ($row = $notes_res->fetch_assoc()) { $image_cell = $row['image'] ? "" : ''; $table_data .= ""; } } else { $table_data = ""; } echo $table_data; ?>
REASON NOTE IMAGE DATE TIME
" . htmlspecialchars($row['reason']) . " " . htmlspecialchars($row['note']) . " " . $image_cell . " " . htmlspecialchars($row['date_time']) . "
NO NOTES RECORDED



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 { } ?>

IMAGE HISTORY


JOCARD

add(); ?>
add(); ?>
" hidden>
value('COMPLETE'); $complete_jobcard->onclick('submit_jobcard()'); $complete_jobcard->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"); $submit_details->redirect($target_dir); $submit_details->on_success("JOBCARD COMPLET"); ?>