add_styles_page();
// $html->check_user_type("ADMIN");
$db = new db_safeguard();
session_start();
$current_date_time = date("Y-m-d H:i", strtotime("+2 hours"));
$serial_number_label = new label();
$serial_number_label->for("serial_number_label");
$serial_number_label->value("DRILLING BIT SERIAL NUMBER");
$serial_number = new input();
$serial_number->class("inputs");
$serial_number->name("note");
$serial_number->id("note");
$serial_number->type("text");
$serial_number->addAttribute("style", "width: 25vw;");
$drilling_image_name = new input();
$drilling_image_name->type("text");
$drilling_image_name->id("image");
$drilling_image_name->name("image");
$drilling_image_name->style("display:none; width: 25vw;");
$submit_bit = new button();
$submit_bit->value("SUBMIT");
$submit_bit->id("submit_bit");
$submit_bit->onclick("load_bit()");
?>
query("notes", "SELECT * FROM notes WHERE jobcard_id = {$_GET['record_id']} AND reason LIKE 'DRILLING BIT%'");
// echo "SELECT * FROM notes WHERE jobcard_id = {$_GET['record_id']} AND reason LIKE 'DRILLING BIT%'";
if ($current_bit_res->num_rows == 0) {
$current_bit = new js_ajax();
$current_bit->function_name("load_bit");
$current_bit->insert("notes");
$current_bit->selected_div(".drilling_bit input");
$current_bit->add_column_and_value("jobcard_id={$_GET['record_id']} ,date_time=" . $current_date_time . ",reason=DRILLING BIT");
$current_bit->submit_btn_id("submit_bit");
$current_bit->on_success("DRILLING BIT LOADED");
$current_bit->redirect("../jobcards/drilling.php?record_id={$_GET['record_id']}&jobcard_id={$_GET['record_id']}");
} else {
$current_bit = new js_ajax();
$current_bit->function_name("load_bit");
$current_bit->insert("notes");
$current_bit->selected_div(".drilling_bit input");
$current_bit->add_column_and_value("jobcard_id={$_GET['record_id']} ,date_time=" . $current_date_time . ",reason=DRILLING BIT CHANGED");
$current_bit->submit_btn_id("submit_bit");
$current_bit->on_success("DRILLING BIT CHANGED");
$current_bit->redirect("../jobcards/drilling.php?record_id={$_GET['record_id']}&jobcard_id={$_GET['record_id']}");
}