<?php include "../../root.class.php";
$html = new html();
$html->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"));


$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);

$battle_label = new label();
$battle_label->for("battle");
$battle_label->value("CHANGE BATTLE");
$battle_label->addAttribute("style", "font-size: 3vw; color: white;");

$battle_type = new label();
$battle_type->for("battle_type");
$battle_type->value("BATTLE TYPE");

$battle = new select();
$battle->class("inputs");
$battle->name("reason");
$battle->id("reason");
$battle->addAttribute("style", "width: 20%;");
$battle->fill_from_db("drilling_bits", "name", "name");

$image_label = new label();
$image_label->for("image");
$image_label->value("BATTLE IMAGE");

$battle_image = new file_upload();
$battle_image->class("inputs");
$battle_image->name("image");
$battle_image->id("image");
$battle_image->file_save_path("../jobcards/battle/");
$battle_image->file_type("jpeg, png, jpg");
$battle_image->style("width: 50%;");

$text_notes = new input();
$text_notes->class("inputs");
$text_notes->type("text");
$text_notes->placeholder("ADDITIONAL NOTES");
$text_notes->name("note");
$text_notes->id("note");
$text_notes->addAttribute("style", "width: 50%;text-align: center;");

$change_battles = new button();
$change_battles->value("CHANGE BATTLE");
$change_battles->onclick("change_battle()");
$change_battles->id("change_battle");
$change_battles->style("background-color: white; color: black;");

$serial_number_label = new label();
$serial_number_label->for("serial_number_label");
$serial_number_label->value("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: 20%;");

$battle_res = $db->query("notes", "SELECT * FROM notes WHERE jobcard_id = {$_GET['record_id']} AND reason LIKE '%bit'");

// echo "SELECT * FROM notes WHERE jobcard_id = {$_GET['record_id']} AND reason LIKE '%bit'";

if ($battle_res->num_rows > 0) {
    while ($row = $battle_res->fetch_assoc()) {
        $table_data = $table_data . "
        <tr>
            <td>" . $row['note'] . "</td>
            <td>" . $row['image'] . "</td>
            <td>" . $row['date_time'] . "</td>
        </tr>";
    }
    // $battle = $battle_res->fetch_assoc();
} else {
    $table_data = $table_data . "
    <tr>
        <td></td>
        <td>NO NOTES RECORDED</td><td></td>
        <td></td>
    </tr><br>";
}

?>

<div class="form_down">

    <style>
        table {
            width: 95%;
            border-collapse: collapse;
        }

        th,
        td {
            padding: 10px;
            border: 3px solid black;
            text-align: left;
            background-color: white;
        }
    </style>

    <h1>CHANGE BATTLE</h1>

    <div style="display:flex; flex-direction: column; align-items: center; width: 100%;" class="drilling_bit">
        <?php
        $serial_number_label->add();
        $serial_number->add();

        new camera('image', $_GET['record_id'], "../jobcards/drilling_bit/", "drilling_bit");
        ?>
        <input type="text" style="display:none" class="inputs"  id="image" name="image">
    </div>

    <?php
    $jobcard_id->add();
    $date_time->add();

    echo "<br><br>";
    $change_battles->add();
    ?>

    <br><br>
    <table>
        <tr>
            <th>SERIAL NO</th>
            <th>IMAGE</th>
            <th>DATE TIME</th>
        </tr>
        <?php echo $table_data; ?>
    </table>
    <br>
    <br><br>
</div>

<?php

$battle_ajax = new js_ajax();
$battle_ajax->function_name("change_battle");
$battle_ajax->insert("notes");
$battle_ajax->submit_btn_id("change_battle");
$battle_ajax->on_success("BATTLE CHANGED");
$battle_ajax->redirect("../jobcards/drilling.php?record_id=" . $_GET['record_id'] . "&jobcard_id=" . $_GET['jobcard_id']);