<?php include "../../root.class.php";
$html = new html();
$html->add_styles_page();
$html->check_user_type("ADMIN");

$name = new input();
$name->id("name");
$name->name("name");
$name->class();
$name->onkeyup("search_work_orders()");

$projects = new select();
$projects->id("project_id");
$projects->name("project_id");
$projects->class();
$projects->onchange("search_work_orders()");
$projects->add_option("", "ALL");
$projects->fill_from_db("projects", "record_id", "name");

$work_order_types = new select();
$work_order_types->id("work_order_type_id");
$work_order_types->name("work_order_type_id");
$work_order_types->class();
$work_order_types->onchange("search_work_orders()");
$work_order_types->add_option("", "ALL");
$work_order_types->fill_from_db("work_order_types", "record_id", "name");

$user_id_assigned = new select();
$user_id_assigned->id("user_id_assigned");
$user_id_assigned->name("user_id_assigned");
$user_id_assigned->class();
$user_id_assigned->onchange("search_work_orders()");
$user_id_assigned->add_option("", "ALL");
$user_id_assigned->fill_from_db("users", "record_id", "username");

$date_time_created = new input();
$date_time_created->id("date_time_created");
$date_time_created->name("date_time_created");
$date_time_created->class();
$date_time_created->type("date");
$date_time_created->onchange("search_work_orders()");

?>
<h1> Search Work Order</h1>

<div class="search_form">
    <?php $name->add(); ?>
    <?php $projects->add(); ?>
    <?php $user_id_assigned->add(); ?>
    <?php $work_order_types->add(); ?>
    <?php $date_time_created->add(); ?>
</div>

<?php //echo $html->html_form_ajax("search_work_orders", "SELECT", "work_orders", '', false, ['name', 'date_time_created','deadline_date_time'], "edit_work_order.php"); 

$ajax = new js_ajax();
$ajax->run_on_load();
$ajax->function_name("search_work_orders");
$ajax->select("work_orders");
$ajax->return_columns(['name', 'date_time_created', 'deadline_date_time']);
$ajax->redirect('edit_work_order.php');
?>