add_styles_page(); $db = new db_safeguard(); $current_date_time = date("Y-m-d H:i", strtotime("+2 hours")); if (isset($_GET['created'])) { echo ""; } // Get record data $record_id = $_GET['record_id']; $leads_res = $db->query("leads", "SELECT * FROM leads WHERE record_id = {$record_id}"); if ($leads_res->num_rows == 0) { die("Lead not found"); } $lead_data = $leads_res->fetch_assoc(); $jc_no = $lead_data['jc_no']; $jobcard_data_res = $db->query("jobcards", "SELECT * FROM jobcards WHERE jc_no = {$lead_data['jc_no']}"); $jobcard_data = $jobcard_data_res->fetch_assoc(); $record_id = new input(); $record_id->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($lead_data['date_created']); $date->readonly(); $jobcard_number_label = new label(); $jobcard_number_label->for("jc_no_label"); $jobcard_number_label->value("JOBCARD NO"); $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("leads", "jc_no", "record_id = {$_GET['record_id']}"); $jobcard_number->readonly(); $contact_number_label = new label(); $contact_number_label->for("contact_number"); $contact_number_label->value("CONTACT NUMBER"); $phone = new input(); $phone->class("inputs"); $phone->type("text"); $phone->placeholder("PHONE NUMBER"); $phone->name("contact_number"); $phone->id("contact_number"); $phone->value_from_db("leads", "contact_number", "record_id = {$_GET['record_id']}"); $client_name_label = new label(); $client_name_label->for("client_name"); $client_name_label->value("CLIENT NAME"); $client_name = new input(); $client_name->class("inputs"); $client_name->type("text"); $client_name->placeholder("CLIENT NAME"); $client_name->name("client_name"); $client_name->id("client_name"); $client_name->value_from_db("jobcards", "client_name", "record_id = {$jobcard_data['record_id']}"); $contact_name_label = new label(); $contact_name_label->for("contact_name"); $contact_name_label->value("CONTACT NAME"); $contact_name = new input(); $contact_name->class("inputs"); $contact_name->type("text"); $contact_name->placeholder("CONTACT NAME"); $contact_name->name("contact_name"); $contact_name->id("contact_name"); $contact_name->value_from_db("jobcards", "contact_name", "record_id = {$jobcard_data['record_id']}"); $other_number_label = new label(); $other_number_label->for("other_number"); $other_number_label->value("OTHER NUMBER"); $other_number = new input(); $other_number->class("inputs"); $other_number->type("text"); $other_number->placeholder("OTHER NUMBER"); $other_number->name("other_number"); $other_number->id("other_number"); $other_number->value_from_db("leads", "other_number", "record_id = {$_GET['record_id']}"); $alternate_number_label = new label(); $alternate_number_label->for("alternate_number"); $alternate_number_label->value("ALTERNATE NUMBER"); $alternate_number = new input(); $alternate_number->class("inputs"); $alternate_number->type("text"); $alternate_number->placeholder("ALTERNATE NUMBER"); $alternate_number->name("alternate_number"); $alternate_number->id("alternate_number"); $alternate_number->value_from_db("leads", "alternate_number", "record_id = {$_GET['record_id']}"); $type_label = new label(); $type_label->for("type_label"); $type_label->value("TYPE"); $type = new select(); $type->class("inputs"); $type->name("type"); $type->required(); $type->id("type"); $type->add_option("LEAD", "LEAD"); $type->add_option("JOBCARD", "JOBCARD"); $area_label = new label(); $area_label->for("area"); $area_label->value("AREA"); $area = new input(); $area->class("inputs"); $area->type("text"); $area->placeholder("AREA"); $area->name("area"); $area->id("area"); $area->value_from_db("leads", "area", "record_id = {$_GET['record_id']}"); $status_label = new label(); $status_label->for("status"); $status_label->value("STATUS"); $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 TO TEAM", "ASSIGN TO TEAM"); $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 = 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()"); $payment_type_label = new label(); $payment_type_label->for("payment_type_label"); $payment_type_label->value("PAYMENT TYPE"); $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"); $amount_label = new label(); $amount_label->for("amount_label"); $amount_label->value("AMOUNT"); $amount = new input(); $amount->class("inputs"); $amount->type("number"); $amount->placeholder("AMOUNT"); $amount->name("amount"); $amount->id("amount"); $amount->value_from_db("leads", "amount", "record_id = {$_GET['record_id']}"); $slip_image_label = new label(); $slip_image_label->for("slip_image_label"); $slip_image_label->value("SLIP IMAGE"); $slip_image = new input(); $slip_image->class("inputs"); $slip_image->name("slip_image"); $slip_image->id("slip_image"); $slip_image->type("text"); $slip_image->style("width:40vw; display: none;"); $slip_image->value_from_db("leads", "slip_image", "record_id = {$_GET['record_id']}"); $add_slip = new button(); $add_slip->value("ADD SLIP"); $add_slip->onclick("add_slip_image()"); $team_assigned_label = new label(); $team_assigned_label->for("team_assigned_label"); $team_assigned_label->value("TEAM ASSIGNED"); $team_assigned = new select(); $team_assigned->class("inputs"); $team_assigned->name("team_assigned_id"); $team_assigned->id("team_assigned_id"); $team_assigned->fill_from_db("teams", "record_id", "name", "status = 'ACTIVE'"); $additional_notes_label = new label(); $additional_notes_label->for("additional_notes_label"); $additional_notes_label->value("ADDITIONAL NOTES"); $additional_notes = new textarea(); $additional_notes->class("inputs"); $additional_notes->placeholder("ADDITIONAL NOTES"); $additional_notes->name("additional_notes"); $additional_notes->id("additional_notes"); $additional_notes->style("width:50%;"); $additional_notes->value_from_db("leads", "additional_notes", "record_id = {$_GET['record_id']}"); $submit_btn = new button(); $submit_btn->value("UPDATE"); ?>

EDIT

add(); $record_id->add(); $jobcard_number_label->add(); $jobcard_number->add(); $date->add(); $client_name_label->add(); $client_name->add(); $contact_name_label->add(); $contact_name->add(); ?>
add(); $other_number_label->add(); $alternate_number_label->add(); ?>
add(); $other_number->add(); $alternate_number->add(); ?>
add(); $area->add(); $payment_label->add(); $leads_res = $db->query("leads", "SELECT * FROM leads WHERE record_id = {$_GET['record_id']}"); $payment_made = ""; if ($leads_res->num_rows > 0) { while ($leads = $leads_res->fetch_assoc()) { $payment_made = $leads['payment_made']; $payment_type = $leads['payment_type']; $type = $leads['type']; $status = $leads['status']; } } ?>
add(); ?>
add(); $amount->add(); ?>
VIEW/DOWNLOAD P.O.P.
add(); ?> add(); ?> add(); ?>
add(); $additional_notes->add(); $submit_btn->add(); ?>
query("jobcard_timeline", "SELECT * FROM jobcard_timeline WHERE jobcard_id = {$jobcard_data['record_id']} ORDER BY record_id ASC"); if ($res_data->num_rows > 0) { $jobcard_res = $db->query("jobcards", "SELECT * FROM jobcards WHERE record_id = {$jobcard_data['record_id']}"); $jobcard = $jobcard_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

NAME VALUE
DATA NOT FOUND