add_styles_page(); $db = new db_safeguard(); $current_date_time = date("Y-m-d H:i", strtotime("+2 hours")); ///////////// DRILLING JOBCARD FORM ///////////// $leads_res = $db->query("work_requests", "SELECT jc_no FROM work_requests ORDER BY jc_no DESC LIMIT 1"); if ($leads_res->num_rows == 0) { $jobcard_no = 1; } else { $leads = $leads_res->fetch_assoc(); $jobcard_no = $leads['jc_no'] + 1; } $date = new input(); $date->class("inputs"); $date->type("hidden"); $date->name("date_created"); $date->id("date_created"); $date->style("display: none;"); $date->value($current_date_time); $jobcard_number = new input(); $jobcard_number->class("inputs"); $jobcard_number->type("text"); $jobcard_number->name("jc_no"); $jobcard_number->id("jc_no"); $jobcard_number->value($jobcard_no); $jobcard_number->readonly(); $jobcard_number->style("font-size: 1em; width: 80%; display: none;"); $type_label = new label(); $type_label->for("type_label"); $type_label->value("TYPE"); $type_label->class("create_label"); $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->addAttribute("style", "font-size: 1em; width: 80%;"); $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']); $additional_notes_label = new label(); $additional_notes_label->for("additional_notes_label"); $additional_notes_label->value("ADDITIONAL NOTES"); $additional_notes_label->class("create_team_label"); $additional_notes_label->addAttribute("style", "font-size: 1.5em; margin-top: 0.5vw;"); $additional_notes = new textarea(); $additional_notes->class("create_textarea"); $additional_notes->name("additional_notes"); $additional_notes->id("additional_notes"); $additional_notes->rows(5); $submit_btn = new button(); ///////////// END DRILLING JOBCARD FORM //////////////// ///////////// PUMP JOBCARD FORM //////////////////////// $pump_res = $db->query("work_requests", "SELECT jc_no FROM work_requests ORDER BY jc_no DESC LIMIT 1"); if ($pump_res->num_rows == 0) { $install_pump_jc_no = 1; } else { $install_pump_jc = $pump_res->fetch_assoc(); $install_pump_jc_no = $install_pump_jc['jobcard_no'] + 1; } $pump_jobcard_number = new input(); $pump_jobcard_number->class("inputs"); $pump_jobcard_number->type("text"); $pump_jobcard_number->name("jobcard_no"); $pump_jobcard_number->id("jobcard_no"); $pump_jobcard_number->value($install_pump_jc_no); // $drilling_invoice = new select(); // $drilling_invoice->class("inputs"); // $drilling_invoice->name("drilling_invoice"); // $drilling_invoice->id("drilling_invoice"); // $drilling_invoice->fill_from_db("jobcards", "jc_no", "jc_no", "interested_in_pump = 'YES'"); // $drilling_invoice->addAttribute("style", "font-size: 1em; width: 100%; margin: 0.5vw auto;"); $drilling_invoice_res = $db->query("jobcards", "SELECT * FROM jobcards WHERE interested_in_pump = 'YES' ORDER BY jc_no DESC"); $install_team_list = ""; while ($drill_invoice = $drilling_invoice_res->fetch_assoc()) { $install_team_list .= ""; } $drilling_invoice_res = $db->query("pump_installation", "SELECT * FROM pump_installation WHERE status = '1' ORDER BY record_id DESC", ""); $invoice_list = ""; while ($invoice = $drilling_invoice_res->fetch_assoc()) { $invoice_list .= ""; } $install_team = new select(); $install_team->class("inputs"); $install_team->name("install_team_id"); $install_team->id("install_team_id"); $install_team->fill_from_db("teams", "record_id", "name", "status = 'ACTIVE'"); $install_team->addAttribute("style", "font-size: 1em; width: 100%; margin: 0.5vw auto;"); $pump_install_res = $db->query("pump_installation", "SELECT * FROM pump_installation ORDER BY record_id DESC LIMIT 1"); $no_installs = 0; if ($pump_install_res->num_rows < 0) { $no_installs = 1; $pump_install_id = "PI_" . $no_installs; } else { $pump_install = $pump_install_res->fetch_assoc(); $no_installs = $pump_install['record_id'] + 1; $pump_install_id = "PI_" . $no_installs; } $drilling_jobcard_id = new input(); $drilling_jobcard_id->class("inputs"); $drilling_jobcard_id->type("text"); $drilling_jobcard_id->name("drilling_jobcard_id"); $drilling_jobcard_id->id("drilling_jobcard_id"); $drilling_jobcard_id->value($pump_install_id); $drilling_jobcard_id->addAttribute("style", "font-size: 1em; width: 60%;"); ///////////// END PUMP JOBCARD FORM //////////////////// ///////////// PUMP REPAIR JOBCARD FORM ///////////////// $installation = new select(); $installation->class("inputs"); $installation->name("installation_id"); $installation->id("installation_id"); $installation->fill_from_db("pump_installation", "record_id", "jobcard_no"); $installation->addAttribute("style", "font-size: 1em; width: 100%; margin: 0.5vw auto;"); $pump_repair_res = $db->query("pump_repair", "SELECT * FROM pump_repair ORDER BY record_id DESC LIMIT 1"); $no_repairs = 0; if ($pump_repair_res->num_rows < 0) { $no_repairs = 1; $repair_id = "PR_" . $no_repairs; } else { $pump_repair = $pump_repair_res->fetch_assoc(); $no_repairs = $pump_repair['record_id'] + 1; $repair_id = "PR_" . $no_repairs; } $pump_repair_id = new input(); $pump_repair_id->class("inputs"); $pump_repair_id->type("text"); $pump_repair_id->name("pump_repair_id"); $pump_repair_id->id("pump_repair_id"); $pump_repair_id->value($repair_id); $pump_repair_id->addAttribute("style", "font-size: 1em; width: 100%; margin: 0.5vw auto;"); $repair_team_id = new select(); $repair_team_id->class("inputs"); $repair_team_id->name("repair_team_id"); $repair_team_id->id("repair_team_id"); $repair_team_id->fill_from_db("teams", "record_id", "name", "status = 'ACTIVE'"); $repair_team_id->addAttribute("style", "font-size: 1em; width: 100%; margin: 0.5vw auto;"); $drilling_repair_invoice = new select(); $drilling_repair_invoice->class("inputs"); $drilling_repair_invoice->name("drilling_repair_invoice"); $drilling_repair_invoice->id("drilling_repair_invoice"); $drilling_repair_invoice->fill_from_db("pump_installation", "jobcard_no", "jobcard_no"); $drilling_repair_invoice->addAttribute("style", "font-size: 1em; width: 100%; margin: 0.5vw auto;"); ///////////// END PUMP REPAIR JOBCARD FORM ///////////// ?>

NEW JOBCARD

add(); $jobcard_number->add(); $type_label->add(); ?>