query("notes", "SELECT * FROM notes WHERE jobcard_id = {$_GET['record_id']} AND reason = 'CURRENT BIT'");
$current_bit = $current_bit_res->fetch_assoc();
if (!$current_bit || $current_bit['reason'] != "CURRENT BIT") {
?>
query("jobcard_timeline", "SELECT * FROM jobcard_timeline WHERE jobcard_id = {$_GET['record_id']} ORDER BY record_id DESC LIMIT 1");
$data = $res_data->fetch_assoc();
$jobcard_id = new input();
$jobcard_id->type("hidden");
$jobcard_id->name("jobcard_id");
$jobcard_id->id("jobcard_id");
$jobcard_id->value($_GET['record_id']);
$date_time = new input();
$date_time->type("hidden");
$date_time->name("date_time");
$date_time->id("date_time");
$date_time->value($current_date_time);
$reasons_label = new label();
$reasons_label->for("reasons");
$reasons_label->value("REASONS");
$reasons_label->addAttribute("style", "font-size: 1.5vw; color: white;");
$reasons = new select();
$reasons->class("inputs");
$reasons->name("reason");
$reasons->id("reason");
$reasons->addAttribute("style", "width: 20%;");
$reasons->add_option("ARRIVED AT LOCATION", "ARRIVED AT LOCATION");
$reasons->add_option("WAITING FOR CLIENT", "WAITING FOR CLIENT");
$reasons->add_option("TRAVELING TO SITE", "TRAVELING TO SITE");
$reasons->add_option("ARRIVED ON SITE", "ARRIVED ON SITE");
$reasons->add_option("TALKING TO CLIENT", "TALKING TO CLIENT");
$reasons->add_option("FETCHING MONEY", "FETCHING MONEY");
$reasons->add_option("BRAKING", "BRAKING");
$reasons->add_option("CHANGING RIEMER", "CHANGING RIEMER");
$reasons->add_option("STOP", "STOP");
$reasons->add_option("PENDING", "PENDING");
$reasons->add_option("START", "START");
$reasons->add_option("INSTALLING", "INSTALLING");
$reasons->add_option("RECEIVED", "RECEIVED");
$reasons->add_option("BACK TO WORKSHOP", "BACK TO WORKSHOP");
$reasons->add_option("OTHER", "OTHER");
$notes_label = new label();
$notes_label->for("notes");
$notes_label->value("NOTES");
$notes_label->addAttribute("style", "font-size: 4vw; color: white; margin:1px;");
$notes = new input();
$notes->class("inputs");
$notes->type("text");
$notes->placeholder("NOTES");
$notes->name("note");
$notes->id("note");
$notes->addAttribute("style", "width: 50%;");
$add_notes = new button();
$add_notes->value("ADD NOTES");
$add_notes->onclick("add_notes()");
$add_notes->style("width: 100%;");
$add_notes->id("notes_btn");
if ($data['type'] == "DRILLING") {
$drilling_lable = new label();
$drilling_lable->for("drilling");
$drilling_lable->value("DRILLING");
$drilling_lable->addAttribute("style", "margin-top: 1vw;font-weight: bold;font-size: 3vw;");
$start = new button();
$start->value("START");
$start->onclick("drilling_start()");
$make_notes_btn = new button();
$make_notes_btn->value("MAKE NOTES");
$make_notes_btn->onclick("open_notesPopup()");
$make_notes_btn->id("make_notes");
$meters_1 = new input();
$meters_1->type("number");
$meters_1->id("meters_1");
$meters_1->onclick("clicked(this, this)");
$meters_1->readonly();
$meters_1->class("work_inputs");
$meters_1->placeholder("30 METERS");
$meters_1->value(30);
$meters_1->disabled();
$meters_1->style("background-color: #f8843561; color: black;");
$meters_2 = new input();
$meters_2->type("number");
$meters_2->id("meters_2");
$meters_2->onclick("clicked(this, this)");
$meters_2->readonly();
$meters_2->class("work_inputs");
$meters_2->placeholder("70 METERS");
$meters_2->value(70);
$meters_2->disabled();
$meters_2->style("background-color: #f8843561; color: black;");
$meters_3 = new input();
$meters_3->type("number");
$meters_3->id("meters_3");
$meters_3->onclick("clicked(this, this)");
$meters_3->readonly();
$meters_3->class("work_inputs");
$meters_3->placeholder("110 METERS");
$meters_3->value(110);
$meters_3->disabled();
$meters_3->style("background-color: #f8843561; color: black;");
$meters_4 = new input();
$meters_4->type("number");
$meters_4->id("meters_4");
$meters_4->onclick("clicked(this, this)");
$meters_4->readonly();
$meters_4->class("work_inputs");
$meters_4->placeholder("150 METERS");
$meters_4->value(150);
$meters_4->disabled();
$meters_4->style("background-color: #f8843561; color: black;");
$drilling_meters = new input();
$drilling_meters->type("number");
$drilling_meters->name("meters");
$drilling_meters->id("meters");
$drilling_meters->class("work_inputs");
$drilling_meters->placeholder("DRILLING METERS");
$drilling_meters->style("background-color: #f8843561; text-align: center; color: black;");
$drilling_meters->disabled();
$next = new button();
$next->value("NEXT");
$next->disabled();
$next->style("background-color: #00008045; color: white;");
$drilling_lable->add();
?>
add();
$make_notes_btn->add();
?>
add();
$meters_2->add();
$meters_3->add();
$meters_4->add();
?>
add();
?>
add();
$drilling_start_ajax = new js_ajax();
$drilling_start_ajax->function_name("drilling_start");
$drilling_start_ajax->insert("jobcard_timeline");
$drilling_start_ajax->selected_div("timeline");
$drilling_start_ajax->add_column_and_value("jobcard_id={$_GET['record_id']},date_time=" . $current_date_time . ",type=DRILLING_START,user_id={$_SESSION['user_id']}");
$drilling_start_ajax->on_success("DRILLING STARTED");
} elseif ($data['type'] == "DRILLING_START") {
$drilling_lable = new label();
$drilling_lable->for("drilling");
$drilling_lable->value("DRILLING");
$drilling_lable->addAttribute("style", "margin-top: 1vw;font-weight: bold;font-size: 3vw;");
$make_notes_btn = new button();
$make_notes_btn->value("MAKE NOTES");
$make_notes_btn->onclick("open_notesPopup()");
$make_notes_btn->id("make_notes");
$stop = new button();
$stop->value("STOP");
$stop->onclick("if (check_stop()){ drilling_stop() ;}");
$meters_1 = new input();
$meters_1->type("number");
$meters_1->id("meters_1");
$meters_1->onclick("clicked(this, this)");
$meters_1->readonly();
$meters_1->class("work_inputs");
$meters_1->placeholder("30 METERS");
$meters_1->value(30);
$meters_2 = new input();
$meters_2->type("number");
$meters_2->id("meters_2");
$meters_2->onclick("clicked(this, this)");
$meters_2->readonly();
$meters_2->class("work_inputs");
$meters_2->placeholder("70 METERS");
$meters_2->value(70);
$meters_3 = new input();
$meters_3->type("number");
$meters_3->id("meters_3");
$meters_3->onclick("clicked(this, this)");
$meters_3->readonly();
$meters_3->class("work_inputs");
$meters_3->placeholder("110 METERS");
$meters_3->value(110);
$meters_4 = new input();
$meters_4->type("number");
$meters_4->id("meters_4");
$meters_4->onclick("clicked(this, this)");
$meters_4->readonly();
$meters_4->class("work_inputs");
$meters_4->placeholder("150 METERS");
$meters_4->value(150);
$drilling_meters = new input();
$drilling_meters->type("number");
$drilling_meters->name("meters");
$drilling_meters->id("meters");
$drilling_meters->class("work_inputs");
$drilling_meters->placeholder("DRILLING METERS");
$drilling_meters->style("text-align: center;");
$next = new button();
$next->value("NEXT");
$next->disabled();
$next->style("background-color: #00008045; color: white;");
$drilling_lable->add();
?>
add();
$make_notes_btn->add();
?>
add();
$meters_2->add();
$meters_3->add();
$meters_4->add();
?>
add();
?>
add();
$drilling_stop_ajax = new js_ajax();
$drilling_stop_ajax->function_name("drilling_stop");
$drilling_stop_ajax->insert("jobcard_timeline");
$drilling_stop_ajax->selected_div(".timeline input");
$drilling_stop_ajax->add_column_and_value("jobcard_id={$_GET['record_id']},date_time=" . $current_date_time . ",type=DRILLING_STOP,user_id={$_SESSION['user_id']}");
$drilling_stop_ajax->on_success("DRILLING STOPPED");
} elseif ($data['type'] == "DRILLING_STOP") {
$drilling_lable = new label();
$drilling_lable->for("drilling");
$drilling_lable->value("DRILLING");
$drilling_lable->addAttribute("style", "margin-top: 1vw;font-weight: bold;font-size: 3vw;");
$make_notes_btn = new button();
$make_notes_btn->value("MAKE NOTES");
$make_notes_btn->onclick("open_notesPopup()");
$make_notes_btn->id("make_notes");
$start = new button();
$start->value("START");
$start->onclick("drilling_start()");
$meters_1 = new input();
$meters_1->type("number");
$meters_1->id("meters_1");
$meters_1->onclick("clicked(this, this)");
$meters_1->readonly();
$meters_1->class("work_inputs");
$meters_1->placeholder("30 METERS");
$meters_1->value(30);
$meters_1->disabled();
$meters_1->style("background-color: #f8843561; color: black;");
$meters_2 = new input();
$meters_2->type("number");
$meters_2->id("meters_2");
$meters_2->onclick("clicked(this, this)");
$meters_2->readonly();
$meters_2->class("work_inputs");
$meters_2->placeholder("70 METERS");
$meters_2->value(70);
$meters_2->disabled();
$meters_2->style("background-color: #f8843561; color: black;");
$meters_3 = new input();
$meters_3->type("number");
$meters_3->id("meters_3");
$meters_3->onclick("clicked(this, this)");
$meters_3->readonly();
$meters_3->class("work_inputs");
$meters_3->placeholder("110 METERS");
$meters_3->value(110);
$meters_3->disabled();
$meters_3->style("background-color: #f8843561; color: black;");
$meters_4 = new input();
$meters_4->type("number");
$meters_4->id("meters_4");
$meters_4->onclick("clicked(this, this)");
$meters_4->readonly();
$meters_4->class("work_inputs");
$meters_4->placeholder("150 METERS");
$meters_4->value(150);
$meters_4->disabled();
$meters_4->style("background-color: #f8843561; color: black;");
// $tot_drilling_meters_res = $db->query("jobcard_timeline", "SELECT SUM(meters) AS total FROM jobcard_timeline WHERE jobcard_id = {$_GET['record_id']} AND type = 'DRILLING_STOP'");
// $tot_drilling_meters = $tot_drilling_meters_res->fetch_assoc()['total'];
$drilling_meters = new input();
$drilling_meters->type("number");
$drilling_meters->name("meters");
$drilling_meters->id("meters");
$drilling_meters->class("work_inputs");
$drilling_meters->placeholder("DRILLING METERS");
// $drilling_meters->value($tot_drilling_meters);
$drilling_meters->style("background-color: #f8843561; text-align: center; color: black;");
$drilling_meters->disabled();
$make_notes_btn = new button();
$make_notes_btn->value("MAKE NOTES");
$make_notes_btn->onclick("open_notesPopup()");
$change_battle_btn = new button();
$change_battle_btn->value("CHANGE DRILL BIT");
$change_battle_btn->onclick("open_battle()");
$change_battle_btn->id("change_battle");
$next = new button();
$next->value("NEXT");
$next->onclick("next()");
// ADD SECTION
$drilling_lable->add();
?>
add();
$make_notes_btn->add();
?>
add();
$meters_2->add();
$meters_3->add();
$meters_4->add();
?>
add();
?>
add();
$next->add();
$drilling_start_ajax = new js_ajax();
$drilling_start_ajax->function_name("drilling_start");
$drilling_start_ajax->insert("jobcard_timeline");
$drilling_start_ajax->selected_div("timeline");
$drilling_start_ajax->add_column_and_value("jobcard_id={$_GET['record_id']},date_time=" . $current_date_time . ",type=DRILLING_START,user_id={$_SESSION['user_id']}");
$drilling_start_ajax->on_success("DRILLING STARTED");
$next_ajax = new js_ajax();
$next_ajax->function_name("next");
$next_ajax->insert("jobcard_timeline");
$next_ajax->selected_div("timeline");
$next_ajax->add_column_and_value("jobcard_id={$_GET['record_id']}," . "date_time=" . $current_date_time . ",user_id={$_SESSION['user_id']}," . "type=BLASTING,");
$next_ajax->on_success("BLASTING");
$next_ajax->redirect("../jobcards/processing.php?record_id={$_GET['record_id']}&jc_no={$_GET['record_id']}");
} else {
$drilling_lable = new label();
$drilling_lable->for("drilling");
$drilling_lable->value("DRILLING");
$drilling_lable->addAttribute("style", "margin-top: 1vw;font-weight: bold;font-size: 3vw;");
$start = new button();
$start->value("START");
$start->onclick("drilling_start()");
$make_notes_btn = new button();
$make_notes_btn->value("MAKE NOTES");
$make_notes_btn->onclick("open_notesPopup()");
$make_notes_btn->id("make_notes");
$meters_1 = new input();
$meters_1->type("number");
$meters_1->id("meters_1");
$meters_1->onclick("clicked(this, this)");
$meters_1->readonly();
$meters_1->class("work_inputs");
$meters_1->placeholder("30 METERS");
$meters_1->value(30);
$meters_1->disabled();
$meters_1->style("background-color: #f8843561; color: black;");
$meters_2 = new input();
$meters_2->type("number");
$meters_2->id("meters_2");
$meters_2->onclick("clicked(this, this)");
$meters_2->readonly();
$meters_2->class("work_inputs");
$meters_2->placeholder("70 METERS");
$meters_2->value(70);
$meters_2->disabled();
$meters_2->style("background-color: #f8843561; color: black;");
$meters_3 = new input();
$meters_3->type("number");
$meters_3->id("meters_3");
$meters_3->onclick("clicked(this, this)");
$meters_3->readonly();
$meters_3->class("work_inputs");
$meters_3->placeholder("110 METERS");
$meters_3->value(110);
$meters_3->disabled();
$meters_3->style("background-color: #f8843561; color: black;");
$meters_4 = new input();
$meters_4->type("number");
$meters_4->id("meters_4");
$meters_4->onclick("clicked(this, this)");
$meters_4->readonly();
$meters_4->class("work_inputs");
$meters_4->placeholder("150 METERS");
$meters_4->value(150);
$meters_4->disabled();
$meters_4->style("background-color: #f8843561; color: black;");
$drilling_meters = new input();
$drilling_meters->type("number");
$drilling_meters->name("meters");
$drilling_meters->id("meters");
$drilling_meters->class("work_inputs");
$drilling_meters->placeholder("DRILLING METERS");
$drilling_meters->style("background-color: #f8843561; text-align: center; color: black;");
$drilling_meters->disabled();
$next = new button();
$next->value("NEXT");
$next->disabled();
$next->style("background-color: #00008045; color: white;");
$drilling_lable->add();
?>
add();
$make_notes_btn->add();
?>
add();
$meters_2->add();
$meters_3->add();
$meters_4->add();
?>
add();
?>
add();
$drilling_start_ajax = new js_ajax();
$drilling_start_ajax->function_name("drilling_start");
$drilling_start_ajax->insert("jobcard_timeline");
$drilling_start_ajax->selected_div("timeline");
$drilling_start_ajax->add_column_and_value("jobcard_id={$_GET['record_id']},date_time=" . $current_date_time . ",type=DRILLING_START,user_id={$_SESSION['user_id']}");
$drilling_start_ajax->on_success("DRILLING STARTED");
}
?>