add_styles_page(); $db = new db_safeguard(); // Get record data $record_id = $_GET['record_id']; $work_res = $db->query("work_requests", "SELECT * FROM work_requests WHERE record_id = {$record_id}"); if ($work_res->num_rows == 0) { die("Lead not found"); } $work_data = $work_res->fetch_assoc(); $jc_no = $work_data['jc_no']; // echo "SELECT * FROM jobcards WHERE jc_no = {$work_data['jc_no']}"; $work_data_res = $db->query("work_requests", "SELECT * FROM work_requests WHERE record_id = {$_GET['record_id']}"); // echo "SELECT * FROM jobcards WHERE jc_no = {$work_data['jc_no']}"; if ($work_data_res->num_rows > 0) { $work_data = $work_data_res->fetch_assoc(); if ($work_data['type'] == "JOBCARD") { ?> class("inputs"); $record_id->type("hidden"); $record_id->name("record_id"); $record_id->id("record_id"); $record_id->value($_GET['record_id']); $date = new input(); $date->class("inputs"); $date->type("hidden"); $date->name("date_created"); $date->id("date_created"); $date->style("display: none;"); $date->value_from_db("work_requests", "date_created", "record_id = {$_GET['record_id']}"); $date->readonly(); $jobcard_number_label = new label(); $jobcard_number_label->for("jc_no_label"); $jobcard_number_label->value("JOBCARD NO : "); $jobcard_number_label->addAttribute("style", "font-size: 1.5em; width: 40%;"); $jobcard_number = new input(); $jobcard_number->class("inputs"); $jobcard_number->name("jc_no"); $jobcard_number->id("jc_no"); $jobcard_number->type("number"); $jobcard_number->value_from_db("work_requests", "jc_no", "record_id = {$_GET['record_id']}"); $jobcard_number->readonly(); $jobcard_number->addAttribute("style", "font-size: 1em; width: 100%; margin: 0.5vw auto;"); $contact_number_label = new label(); $contact_number_label->for("contact_number"); $contact_number_label->value("CONTACT NUMBER : "); $contact_number_label->addAttribute("style", "font-size: 1.5em; width: 40%;"); $phone = new input(); $phone->class("inputs"); $phone->type("text"); $phone->name("contact_number"); $phone->id("contact_number"); $phone->value_from_db("work_requests", "contact_number", "record_id = {$_GET['record_id']}"); $phone->addAttribute("style", "font-size: 1em; width: 100%; margin: 0.5vw auto;"); $other_number_label = new label(); $other_number_label->for("other_number"); $other_number_label->value("OTHER NUMBER : "); $other_number_label->addAttribute("style", "font-size: 1.5em; width: 40%;"); $other_number = new input(); $other_number->class("inputs"); $other_number->type("text"); $other_number->name("other_number"); $other_number->id("other_number"); $other_number->value_from_db("work_requests", "other_number", "record_id = {$_GET['record_id']}"); $other_number->addAttribute("style", "font-size: 1em; width: 100%; margin: 0.5vw auto;"); $alternate_number_label = new label(); $alternate_number_label->for("alternate_number"); $alternate_number_label->value("ALTERNATE NUMBER : "); $alternate_number_label->addAttribute("style", "font-size: 1.5em; width: 40%;"); $alternate_number = new input(); $alternate_number->class("inputs"); $alternate_number->type("text"); $alternate_number->name("alternate_number"); $alternate_number->id("alternate_number"); $alternate_number->value_from_db("work_requests", "alternate_number", "record_id = {$_GET['record_id']}"); $alternate_number->addAttribute("style", "font-size: 1em; width: 100%; margin: 0.5vw auto;"); $type_label = new label(); $type_label->for("type_label"); $type_label->value("TYPE : "); $type_label->addAttribute("style", "font-size: 1.5em; width: 40%;"); $type = new select(); $type->class("inputs"); $type->name("type"); $type->id("type"); $type->add_option("LEAD", "LEAD"); $type->add_option("JOBCARD", "JOBCARD"); $type->addAttribute("style", "font-size: 1em; width: 100%; margin: 0.5vw auto;"); $area_label = new label(); $area_label->for("area"); $area_label->value("AREA : "); $area_label->addAttribute("style", "font-size: 1.5em; width: 40%;"); $area = new input(); $area->class("inputs"); $area->type("text"); $area->name("area"); $area->id("area"); $area->value_from_db("work_requests", "address", "record_id = {$_GET['record_id']}"); $area->addAttribute("style", "font-size: 1em; width: 100%; margin: 0.5vw auto;"); $status_label = new label(); $status_label->for("status"); $status_label->value("STATUS : "); $status_label->addAttribute("style", "font-size: 1.5em; width: 40%;"); $status = new select(); $status->class("inputs"); $status->name("status"); $status->id("status"); $status->add_option("WAITING FOR DEPOSIT", "WAITING FOR DEPOSIT"); $status->add_option("FOLLOW UP", "FOLLOW UP"); $status->add_option("QUOTE SENT", "QUOTE SENT"); $status->add_option("WAITNG FOR CONFIRMATION", "WAITNG FOR CONFIRMATION"); $status->add_option("ASSIGN TEAM", "ASSIGN TO TEAM"); $status->addAttribute("style", "font-size: 1em; width: 100%; margin: 0.5vw auto;"); $user_id = new input(); $user_id->class("inputs"); $user_id->type("hidden"); $user_id->name("user_created_id"); $user_id->id("user_created_id"); $user_id->value($_SESSION['user_id']); $payment_label = new label(); $payment_label->for("payment_label"); $payment_label->value("PAYMENT MADE : "); $payment_label->addAttribute("style", "font-size: 1.5em; width: 80%;"); $payment = new select(); $payment->class("inputs"); $payment->name("payment_made"); $payment->id("payment_made"); $payment->add_option("YES", "YES"); $payment->add_option("NO", "NO"); $payment->onchange("payment_available()"); $payment->addAttribute("style", "font-size: 1em; width: 100%; margin: 0.5vw auto;"); $payment_type_label = new label(); $payment_type_label->for("payment_type_label"); $payment_type_label->value("PAYMENT TYPE"); $payment_type_label->addAttribute("style", "font-size: 1.5em; width: 40%;"); $payment_type = new select(); $payment_type->class("inputs"); $payment_type->name("payment_type"); $payment_type->id("payment_type"); $payment_type->add_option("CASH", "CASH"); $payment_type->add_option("EFT", "EFT"); $payment_type->add_option("OTHER", "OTHER"); $payment_type->addAttribute("style", "font-size: 1em; width: 100%; margin: 0.5vw auto;"); $team_assigned_label = new label(); $team_assigned_label->for("team_assigned_label"); $team_assigned_label->value("TEAM ASSIGNED"); $team_assigned_label->addAttribute("style", "font-size: 1.5em; width: 40%;"); $team_assigned = new select(); $team_assigned->class("inputs"); $team_assigned->name("team_id"); $team_assigned->id("team_id"); $team_assigned->fill_from_db("teams", "record_id", "name", "status = 'ACTIVE'"); $team_assigned->addAttribute("style", "font-size: 1em; width: 100%; margin: 0.5vw auto;"); $additional_notes_label = new label(); $additional_notes_label->for("additional_notes_label"); $additional_notes_label->value("ADDITIONAL NOTES"); $additional_notes_label->addAttribute("style", "font-size: 1.5em;"); $additional_notes = new textarea(); $additional_notes->class("inputs"); $additional_notes->name("additional_notes"); $additional_notes->id("additional_notes"); // $additional_notes->style("width:50%;"); $additional_notes->value_from_db("work_requests", "additional_notes", "record_id = {$_GET['record_id']}"); $additional_notes->addAttribute("style", "font-size: 1em; width: 100%; margin: 0.5vw auto;"); $additional_notes->rows(5); $submit_btn = new button(); $submit_btn->value("UPDATE"); // $submit_btn->onclick("validateTeam()"); ?>

EDIT LEAD

add(); $record_id->add(); ?>
add(); $jobcard_number->add(); $date->add(); ?>
add(); $phone->add(); ?>
add(); $other_number->add(); ?>
add(); $alternate_number->add(); ?>
add(); $area->add(); ?>


PAYMENTS

add(); $payment->add(); ?>
query("work_requests", "SELECT * FROM work_requests WHERE record_id = {$_GET['record_id']}"); $data = $data_res->fetch_assoc(); $jobcard_id_data_res = $db->query("jobcards", "SELECT * FROM jobcards WHERE jc_no = {$data['jc_no']}"); $jobcard_id = $jobcard_id_data_res->fetch_assoc(); ?>


add(); $request_data = $db->query("work_requests", "SELECT * FROM work_requests WHERE record_id = {$_GET['record_id']}"); // echo "SELECT * FROM work_requests WHERE record_id = {$_GET['record_id']}"; $requests = $request_data->fetch_assoc(); ?>
add(); ?>


add(); $additional_notes->add(); $submit_btn->add(); ?>
query("work_requests", "SELECT * FROM work_requests WHERE record_id = {$_GET['record_id']}"); // echo "SELECT * FROM work_requests WHERE record_id = {$_GET['record_id']}"; if ($work_lead_res->num_rows > 0) { $work_leads = $work_lead_res->fetch_assoc(); $res_data = $db->query("jobcard_timeline", "SELECT * FROM jobcard_timeline WHERE jobcard_id = {$work_leads['jc_no']} ORDER BY record_id ASC"); // echo "SELECT * FROM jobcard_timeline WHERE jobcard_id = {$work_leads['jc_no']} ORDER BY record_id ASC"; if ($res_data->num_rows > 0) { $work_lead_res = $db->query("jobcards", "SELECT * FROM jobcards WHERE record_id = {$data['jc_no']}"); $jobcard = $work_lead_res->fetch_assoc(); // echo $jobcard['record_id']; ?>

JOBCARD SUMMARY

fetch_assoc()) { if ($jc_timeline['type'] == "RIEM_STOP" || $jc_timeline['type'] == "RIEMING_STOP") { $riem_meters += $jc_timeline['meters']; } if ($jc_timeline['type'] == "DRILLING_STOP") { $drilling_meters += $jc_timeline['meters']; } if ($jc_timeline['type'] == "CASING_STOP") { $casing_meters += $jc_timeline['meters']; } if ($jc_timeline['type'] == "BLASTING_START" || $jc_timeline['type'] == "BLASTING_STOP") { $blasting_meters += $jc_timeline['meters']; } ?>
TYPE METERS DATE


TOTAL
TOTAL RIEM METERS
TOTAL DRILLING METERS
TOTAL CASING METERS
TOTAL BLASTING METERS


VALUE
Interested in Pump:
Water Flow:
Compressor Hours:
Diesel Start:
Diesel Stop:

EMPLOYEE SIGNATURE

CLIENT SIGNATURE


Job Card Summary

TYPE METERS DATE
DATA NOT FOUND

Job Card Summary

TYPE METERS DATE
DATA NOT FOUND