query("notes", "SELECT * FROM notes WHERE jobcard_id = {$_GET['record_id']} AND reason = 'DRILLING BIT'");
$current_bit = $current_bit_res->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);
if ($current_bit['reason'] == "DRILLING BIT") {
$res_data = $db->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();
$data_type = new input();
$data_type->class("inputs");
$data_type->type("hidden");
$data_type->readonly();
$data_type->value($data['type']);
$data_type->add();
//GET THE LAST REIMING BIT FROM THE JOBCARD TIMELINE
$last_bit_res = $db->query("notes", "SELECT * FROM notes WHERE jobcard_id = {$_GET['record_id']} AND reason LIKE 'DRILLING BIT%' ORDER BY record_id DESC LIMIT 1");
// echo "SELECT * FROM notes WHERE jobcard_id = {$_GET['record_id']} AND reason LIKE 'DRILLING BIT%' ORDER BY record_id DESC LIMIT 1;";
$last_bit = $last_bit_res->fetch_assoc();
if ($data['type'] == "DRILLING") {
$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;");
$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();
$make_note = new button();
$make_note->class("make_notes_btn");
$make_note->value("MAKE NOTE");
$make_note->onclick("open_notesPopup()");
$make_note->id("make_note");
// $next = new button();
// $next->value("BACK");
// $next->onclick("next()");
// $next->style("background-color: #00008045; color: white;");
//
$drilling_lable->add();
$make_note->add();
?>
add();
?>
add();
$meters_2->add();
$meters_3->add();
$meters_4->add();
?>
add();
?>
add();
// $notes_ajax = new js_ajax();
// $notes_ajax->function_name("add_notes");
// $notes_ajax->insert("notes");
// $notes_ajax->selected_div(".notes_content input , .notes_content select ");
// $notes_ajax->submit_btn_id("notes_btn");
// $notes_ajax->on_success("NOTE SAVED");
$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,serial_number=" . $last_bit['note'] . ",user_id={$_SESSION['user_id']}");
$drilling_start_ajax->on_success("DRILLING STARTED");
} elseif ($data['type'] == "DRILLING_START") {
$make_note = new button();
$make_note->class("make_notes_btn");
$make_note->value("MAKE NOTE");
$make_note->onclick("open_notesPopup()");
$make_note->id("make_note");
$pause = new button();
$pause->value("PAUSE");
$pause->onclick("drilling_pause()");
$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("48 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;");
// ADD SECTION
$drilling_lable->add();
$make_note->add();
?>
add();
$stop->add();
?>
add();
$meters_2->add();
$meters_3->add();
$meters_4->add();
?>
add();
?>
function_name("add_notes");
// $notes_ajax->insert("notes");
// $notes_ajax->selected_div(".notes_content input , .notes_content select ");
// $notes_ajax->submit_btn_id("notes_btn");
// $notes_ajax->on_success("NOTE SAVED");
$last_bit_res = $db->query("notes", "SELECT * FROM notes WHERE jobcard_id = {$_GET['record_id']} AND reason LIKE 'DRILLING BIT%' ORDER BY record_id DESC LIMIT 1");
// echo "SELECT * FROM notes WHERE jobcard_id = {$_GET['record_id']} AND reason LIKE 'DRILLING BIT%' ORDER BY record_id DESC LIMIT 1;";
$last_bit = $last_bit_res->fetch_assoc();
$drilling_pause_ajax = new js_ajax();
$drilling_pause_ajax->function_name("drilling_pause");
$drilling_pause_ajax->insert("jobcard_timeline");
$drilling_pause_ajax->selected_div(".timeline input");
$drilling_pause_ajax->add_column_and_value("jobcard_id={$_GET['record_id']},date_time=" . $current_date_time . ",type=DRILLING_PAUSE,serial_number=" . $last_bit['note'] . ",user_id={$_SESSION['user_id']}");
$drilling_pause_ajax->on_success("DRILLING PAUSED");
$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,serial_number=" . $last_bit['note'] . ",user_id={$_SESSION['user_id']}");
$drilling_stop_ajax->on_success("DRILLING STOPPED");
} elseif ($data['type'] == "DRILLING_PAUSE") {
$resume = new button();
$resume->value("RESUME");
$resume->onclick("drilling_resume()");
$stop = new button();
$stop->value("STOP");
$stop->onclick("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("48 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("100 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();
$change_bit_btn = new button();
$change_bit_btn->value("CHANGE BIT");
$change_bit_btn->onclick("open_bit()");
$change_bit_btn->id("driling_bit");
$make_note = new button();
$make_note->class("make_notes_btn");
$make_note->value("MAKE NOTE");
$make_note->onclick("open_notesPopup()");
$make_note->id("make_note");
// ADD SECTION
$drilling_lable->add();
$make_note->add();
?>
add();
$resume->add();
$stop->add();
?>
add();
$meters_2->add();
$meters_3->add();
$meters_4->add();
?>
add();
?>
function_name("add_notes");
// $notes_ajax->insert("notes");
// $notes_ajax->selected_div(".notes_content input , .notes_content select ");
// $notes_ajax->submit_btn_id("notes_btn");
// $notes_ajax->on_success("NOTE SAVED");
//GET THE LAST REIMING BIT FROM THE JOBCARD TIMELINE
$last_bit_res = $db->query("notes", "SELECT * FROM notes WHERE jobcard_id = {$_GET['record_id']} AND reason LIKE 'DRILLING BIT%' ORDER BY record_id DESC LIMIT 1");
// echo "SELECT * FROM notes WHERE jobcard_id = {$_GET['record_id']} AND reason LIKE 'DRILLING BIT%' ORDER BY record_id DESC LIMIT 1;";
$last_bit = $last_bit_res->fetch_assoc();
$drilling_resume_ajax = new js_ajax();
$drilling_resume_ajax->function_name("drilling_resume");
$drilling_resume_ajax->insert("jobcard_timeline");
$drilling_resume_ajax->selected_div(".timeline input");
$drilling_resume_ajax->add_column_and_value("jobcard_id={$_GET['record_id']},date_time=" . $current_date_time . ",type=DRILLING_RESUME,serial_number=" . $last_bit['note'] . ",user_id={$_SESSION['user_id']}");
$drilling_resume_ajax->on_success("DRILLING RESUMED");
$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,serial_number=" . $last_bit['note'] . ",user_id={$_SESSION['user_id']}");
$drilling_stop_ajax->on_success("DRILLING STOPPED");
} elseif ($data['type'] == "DRILLING_RESUME") {
$make_note = new button();
$make_note->class("make_notes_btn");
$make_note->value("MAKE NOTE");
$make_note->onclick("open_notesPopup()");
$make_note->id("make_note");
$pause = new button();
$pause->value("PAUSE");
$pause->onclick("drilling_pause()");
$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("48 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;");
// ADD SECTION
$drilling_lable->add();
$make_note->add();
?>
add();
$stop->add();
?>
add();
$meters_2->add();
$meters_3->add();
$meters_4->add();
?>
add();
?>
function_name("add_notes");
// $notes_ajax->insert("notes");
// $notes_ajax->selected_div(".notes_content input , .notes_content select ");
// $notes_ajax->submit_btn_id("notes_btn");
// $notes_ajax->on_success("NOTE SAVED");
//GET THE LAST REIMING BIT FROM THE JOBCARD TIMELINE
$last_bit_res = $db->query("notes", "SELECT * FROM notes WHERE jobcard_id = {$_GET['record_id']} AND reason LIKE 'DRILLING BIT%' ORDER BY record_id DESC LIMIT 1");
// echo "SELECT * FROM notes WHERE jobcard_id = {$_GET['record_id']} AND reason LIKE 'DRILLING BIT%' ORDER BY record_id DESC LIMIT 1;";
$last_bit = $last_bit_res->fetch_assoc();
$drilling_pause_ajax = new js_ajax();
$drilling_pause_ajax->function_name("drilling_pause");
$drilling_pause_ajax->insert("jobcard_timeline");
$drilling_pause_ajax->selected_div(".timeline input");
$drilling_pause_ajax->add_column_and_value("jobcard_id={$_GET['record_id']},date_time=" . $current_date_time . ",type=DRILLING_PAUSE,serial_number=" . $last_bit['note'] . ",user_id={$_SESSION['user_id']}");
$drilling_pause_ajax->on_success("DRILLING PAUSED");
$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,serial_number=" . $last_bit['note'] . ",user_id={$_SESSION['user_id']}");
$drilling_stop_ajax->on_success("DRILLING STOPPED");
} elseif ($data['type'] == "DRILLING_STOP") {
$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("48 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("100 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();
$change_bit_btn = new button();
$change_bit_btn->value("CHANGE BIT");
$change_bit_btn->onclick("open_bit()");
$change_bit_btn->id("change_bit");
$make_note = new button();
$make_note->class("make_notes_btn");
$make_note->value("MAKE NOTE");
$make_note->onclick("open_notesPopup()");
$make_note->id("make_note");
$make_note->add();
// $next = new button();
// $next->value("DONE");
// $next->onclick("next()");
// ADD SECTION
$drilling_lable->add();
?>
add();
$start->add();
?>
add();
$meters_2->add();
$meters_3->add();
$meters_4->add();
?>
add();
?>
add();
//GET THE LAST REIMING BIT FROM THE JOBCARD TIMELINE
$last_bit_res = $db->query("notes", "SELECT * FROM notes WHERE jobcard_id = {$_GET['record_id']} AND reason LIKE 'DRILLING BIT%' ORDER BY record_id DESC LIMIT 1");
// echo "SELECT * FROM notes WHERE jobcard_id = {$_GET['record_id']} AND reason LIKE 'DRILLING BIT%' ORDER BY record_id DESC LIMIT 1;";
$last_bit = $last_bit_res->fetch_assoc();
$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,serial_number=" . $last_bit['note'] . ",user_id={$_SESSION['user_id']}");
$drilling_start_ajax->on_success("DRILLING STARTED");
?>
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;");
$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();
$make_note = new button();
$make_note->class("make_notes_btn");
$make_note->value("MAKE NOTE");
$make_note->onclick("open_notesPopup()");
$make_note->id("make_note");
$make_note->add();
// $next = new button();
// $next->value("BACK");
// $next->disabled();
// $next->style("background-color: #00008045; color: white;");
//
$drilling_lable->add();
$make_note->add();
?>
add();
?>
add();
$meters_2->add();
$meters_3->add();
$meters_4->add();
?>
add();
?>
add();
//GET THE LAST REIMING BIT FROM THE JOBCARD TIMELINE
$last_bit_res = $db->query("notes", "SELECT * FROM notes WHERE jobcard_id = {$_GET['record_id']} AND reason LIKE 'DRILLING BIT%' ORDER BY record_id DESC LIMIT 1");
// echo "SELECT * FROM notes WHERE jobcard_id = {$_GET['record_id']} AND reason LIKE 'DRILLING BIT%' ORDER BY record_id DESC LIMIT 1;";
$last_bit = $last_bit_res->fetch_assoc();
// $notes_ajax = new js_ajax();
// $notes_ajax->function_name("add_notes");
// $notes_ajax->insert("notes");
// $notes_ajax->selected_div(".notes_content input , .notes_content select ");
// $notes_ajax->submit_btn_id("notes_btn");
// $notes_ajax->on_success("NOTE SAVED");
$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,serial_number=" . $last_bit['note'] . ",user_id={$_SESSION['user_id']}");
$drilling_start_ajax->on_success("DRILLING STARTED");
}
} else {
?>
query("jobcard_timeline", "SELECT * FROM jobcard_timeline WHERE jobcard_id={$_GET['record_id']} AND type LIKE 'DRILLING%' ORDER BY record_id DESC");
// echo "SELECT * FROM jobcard_timeline WHERE jobcard_id={$_GET['record_id']} AND type LIKE 'RIEM%' ORDER BY record_id DESC";
$total_meters = 0;
while ($meters_data = $last_meters->fetch_assoc()) {
$total_meters += $meters_data['meters'];
}
echo "
CURRENT TOTAL METERS DRILLED:
";
echo "" . $total_meters . " METERS
";
?>