<?php include "../../root.class.php";
$html = new html();
$html->add_styles_page();
// $html->check_user_type("ADMIN");
$db = new db_safeguard();

//GET THE NUMBER OF ROWS IN THE JOBCARDS TABLE AND ADD 1
if ($db->query("jobcards", "SELECT * FROM jobcards")->num_rows == 0) {
    $jobcard_no = 1;
} else {
    $jobcard_no = $db->query("jobcards", "SELECT * FROM jobcards")->num_rows + 1;
}

//get the current date and time
$current_date_time = date("Y-m-d H:i", strtotime("+2 hours"));

//get the seeion user id
$user_id = $_SESSION['user_id'];

$record_id = new input();
$record_id->name("record_id");
$record_id->id("record_id");
$record_id->value($_GET['record_id']);
$record_id->type("hidden");

$action_date = new input();
$action_date->class("inputs");
$action_date->type("datetime-local");
$action_date->name("action_date");
$action_date->id("action_date");
$action_date->value_from_db("jobcards", "action_date", "record_id = {$_GET['record_id']}");

$action_date_label = new label();
$action_date_label->for("action_date");
$action_date_label->value("ACTION DATE");

$contact_name = new input();
$contact_name->class("inputs");
$contact_name->type("text");
$contact_name->placeholder("CONTACT NAME");
$contact_name->name("contact_name");
$contact_name->id("contact_name");
$contact_name->value_from_db("jobcards", "contact_name", "record_id = {$_GET['record_id']}");

$address = new input();
$address->class("inputs");
$address->type("text");
$address->placeholder("ADDRESS");
$address->name("address");
$address->required();
$address->id("address");
$address->value_from_db("jobcards", "address", "record_id = {$_GET['record_id']}");

$phone = new input();
$phone->class("inputs");
$phone->type("text");
$phone->placeholder("PHONE NUMBER");
$phone->name("contact_number");
$phone->id("contact_number");
$phone->value_from_db("jobcards", "contact_number", "record_id = {$_GET['record_id']}");

$other_number = new input();
$other_number->class("inputs");
$other_number->type("text");
$other_number->placeholder("OTHER NUMBER");
$other_number->name("other_number");
$other_number->id("other_number");
$other_number->value_from_db("jobcards", "other_number", "record_id = {$_GET['record_id']}");

$contact_number_label = new label();
$contact_number_label->for("contact_number");
$contact_number_label->value("CONTACT NUMBER");

$other_number_label = new label();
$other_number_label->for("other_number");
$other_number_label->value("OTHER NUMBER");

$alternate_number_label = new label();
$alternate_number_label->for("alternate_number");
$alternate_number_label->value("ALTERNATE NUMBER");

$alternate_number = new input();
$alternate_number->class("inputs");
$alternate_number->type("text");
$alternate_number->placeholder("ALTERNATE NUMBER");
$alternate_number->name("alternate_number");
$alternate_number->id("alternate_number");
$alternate_number->value_from_db("jobcards", "alternate_number", "record_id = {$_GET['record_id']}");

$client_name = new select();
$client_name->class("inputs");
$client_name->name("client_id");
$client_name->id("client_id");
$client_name->required();
$client_name->fill_from_db("clients", "record_id", "name");

$contact_name_label = new label();
$contact_name_label->for("contact_name_label");
$contact_name_label->value("CONTACT NAME");

$date_time_closed = new input();
$date_time_closed->class("inputs");
$date_time_closed->style("display: none;");
$date_time_closed->name("date_time_closed");
$date_time_closed->value(0);
$date_time_closed->id("date_time_closed");

$jobcard_number_label = new label();
$jobcard_number_label->for("jc_no");
$jobcard_number_label->value("JOBCARD NUMBER");

$jobcard_number = new input();
$jobcard_number->class("inputs");
$jobcard_number->type("text");
$jobcard_number->readonly();
$jobcard_number->name("jc_no");
$jobcard_number->id("jc_no");
$jobcard_number->value_from_db("jobcards", "jc_no", "record_id = {$_GET['record_id']}");

$user_assigned = new select();
$user_assigned->class("inputs");
$user_assigned->name("user_assigned");
$user_assigned->required();
$user_assigned->id("user_assigned");
$user_assigned->fill_from_db("users", "record_id", "username");

$user_assigned_label = new label();
$user_assigned_label->for("user_assigned");
$user_assigned_label->value("USER ASSIGNED");

$team_assigned = new select();
$team_assigned->class("inputs");
$team_assigned->name("team_assigned_id");
$team_assigned->required();
$team_assigned->id("team_assigned_id");
$team_assigned->fill_from_db("teams", "record_id", "name");

$team_assigned_label = new label();
$team_assigned_label->for("team_assigned");
$team_assigned_label->value("TEAM ASSIGNED");

$client_name_label = new label();
$client_name_label->for("client_name");
$client_name_label->value("CLIENT NAME");

$submit_btn = new button();
$submit_btn->value("UPDATE");
$submit_btn->onclick("update_jobcard()");

?>

<div class="form_down">
    <h1>EDIT JOBCARD</h1>

    <script>
        function add_number() {
            //create a input with a placeholder called other
            var other = document.createElement("input");
            other.type = "text";
            other.placeholder = "OTHER";
            other.name = "other";
            other.id = "other";
            other.required = true;
            document.getElementById("other_div").appendChild(other);
        }
    </script>
    <?php
    $record_id->add();
    $jobcard_number_label->add();
    $jobcard_number->add();
    $action_date_label->add();
    $action_date->add();
    $client_name_label->add();
    $client_name->add();
    $contact_name_label->add();
    $contact_name->add();

    ?>
    <div style="display: flex; width: 45%; justify-content: space-between;">
        <?php
        $contact_number_label->add();
        $other_number_label->add();
        $alternate_number_label->add();
        ?>
    </div>
    <div>
        <?php
        $phone->add();
        $other_number->add();
        $alternate_number->add();
        ?>
    </div>

    <?php
    $address->add();
    $team_assigned_label->add();
    $team_assigned->add();
    $user_assigned_label->add();
    $user_assigned->add();

    ?>

    <?php
    $submit_btn->add();
    ?>
</div>

<?php

$ajax = new js_ajax();
$ajax->function_name("update_jobcard");
$ajax->submit_btn_id("submit");
$ajax->update("jobcards");
$ajax->on_success("JOBCARD UPDATED SUCCESSFULLY");
$ajax->redirect("../jobcards/home.php");

?>