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(); $user_res = $db->query("users", "SELECT * FROM users WHERE username = '{$jobcard_data['installed_by']}'"); $users = $user_res->fetch_assoc(); $make_notes_btn = new button(); $make_notes_btn->value("MAKE NOTES"); $make_notes_btn->onclick("open_notesPopup()"); $jobcard_id_record_id = new input(); $jobcard_id_record_id->type("hidden"); $jobcard_id_record_id->name("jobcard_id"); $jobcard_id_record_id->id("jobcard_id"); $jobcard_id_record_id->value($_GET['record_id']); $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->name("reason"); $reasons->id("reason"); $reasons->addAttribute("style", "width: 20%;"); $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;"); $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 = new input(); $notes->class("big_inputs"); $notes->type("text"); $notes->placeholder("NOTES"); $notes->name("note"); $notes->id("note"); $notes->addAttribute("style", "width: 50%;"); $add_notes = new button(); $add_notes->value("ADD NOTES"); $add_notes->onclick("add_notes()"); $add_notes->style("width: 100%;"); $add_notes->id("notes_btn"); $image = new file_upload(); $image->file_save_path("../jobcards/notes/"); $image->file_type("png, jpg, jpeg"); $image->name("image"); $image->id("image"); $image->class("inputs"); $image->style("width: 50%;"); $ajax = new js_ajax(); $ajax->function_name("add_notes"); $ajax->insert("notes"); $ajax->selected_div(".notes_content input , .notes_content select "); $ajax->submit_btn_id("notes_btn"); $ajax->on_success("NOTE SAVED"); ?>

JOBCARD SUMMARY

add(); ?>

JOBCARD ID :

DATE STARTED :

DATE FINISHED :

PROBLEM DESCRIPTION

<?php echo htmlspecialchars($repair_data['problem_description']); ?>

SOLUTION

<?php echo htmlspecialchars($repair_data['problem_solution']); ?>

REPAURED BY

JOBCARD IMAGES

EMPLOYEE SIGNATURE

EMPLOYEE SIGNATURE

NO SIGNATURE FOUND

CLIENT SIGNATURE

CLIENT SIGNATURE

NO SIGNATURE FOUND

PUMP SLIP

PUMP SLIP

NO SIGNATURE FOUND

value("DONE"); $done_btn->onclick("complete()"); $done_btn->add(); $done_ajax = new js_ajax(); $done_ajax->function_name("complete"); $done_ajax->update("pump_repair"); $done_ajax->selected_div(".complete_div input , .complete_div select , .complete_div textarea"); $done_ajax->on_success("JOBCARD COMPLETED"); $done_ajax->redirect('../home.php'); ?>

× query("jobcard_timeline", "SELECT * FROM jobcard_timeline WHERE jobcard_id = {$_GET['record_id']} 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(); $jobcard_id_record_id->add(); $date_time->add(); $notes_label->add(); ?>

add(); $reasons->add(); $notes_sub_label->add(); ?>

add(); new camera('image', $_GET['record_id'], "../jobcards/notes/", "notes_images"); ?> add(); $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"); ?> query("notes", "SELECT * FROM notes WHERE jobcard_id = {$_GET['record_id']} AND reason NOT LIKE '%BIT%'"); if ($notes_res->num_rows > 0) { while ($row = $notes_res->fetch_assoc()) { $table_data = $table_data . " " . $row['reason'] . " " . $row['note'] . " " . $row['image'] . " " . $row['date_time'] . " "; } $notes = $notes_res->fetch_assoc(); } else { $table_data = $table_data . " NO NOTES RECORDED
"; } ?>

REASON	NOTE	IMAGE	DATE TIME