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; } ///////////// 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_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; } $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