<?php
session_start();
include "classes/html.class.php";
$db = new db();
$asset_type_res = $db->exec_query('assets', ["*"]);
$asset_type_list = '<option>ALL</option>';
while ($asset_type = $asset_type_res->fetch_assoc()) {
    $asset_type_list = $asset_type_list . "<option value='{$asset_type['record_id']}'>{$asset_type['asset_id']}</option>";
}

$user_type_res = $db->exec_query('users', ["*"], '', '', '', '', "user_type = 'MECHANIC'", "ORDER BY username ASC");
$users_list = '<option>ALL</option>';
while ($users = $user_type_res->fetch_assoc()) {
    $users_list = $users_list . "<option value='{$users['record_id']}'>{$users['username']}</option>";
}

if ($_SESSION['farm_id'] == 0) {
    $farms_res = $db->exec_query('farms', ["*"]);
} else {
    $farms_res = $db->exec_query('farms', ["*"], '', '', '', '', "record_id = {$_SESSION['farm_id']}");
}

$farm_list = '<option value="0">ALL</option>';
while ($farms = $farms_res->fetch_assoc()) {
    $farm_list = $farm_list . "<option value='{$farms['record_id']}'>{$farms['farm_name']}</option>";
}

$html = new html("JOB CARD REPORTS");

?>


<div class='form' style="padding-bottom: 0%;">
    <h2 style="font-size: 2vw;">FILTER:</h2>
    <hr><br>
    <form action='jobcard_report.php' method='POST'>
    <div class='center_screen'>
            <div class="test1">

                <label>JOBCARD DATE TYPE</label><br>
                <select name='date_type' class='form_input'>
                    <option></option>
                    <option>DATE CREATED</option>
                    <option>DATE OPENED</option>
                    <option>DATE CLOSED</option>
                </select><br><br>
            </div>
            <div class="test2">
                <label>DATE FROM</label><br>
                <input type='date' name='date_from' class='form_input' /><br><br>
            </div>
            <div class="test3">
                <label>DATE TO</label><br>
                <input type='date' name='date_to' class='form_input' /><br><br>
            </div>
            <div class="test4">
                <label>STATUS</label><br>
                <select name='status' class='form_input'>
                    <option>ALL</option>
                    <option>OPEN</option>
                    <option>AWAITING PARTS</option>
                    <option>CLOSED</option>
                </select><br><br>
            </div>
            <div class="test5">
                <label>USER</label><br>
                <select name='username' class='form_input'>
                    <?php echo $users_list; ?>
                </select><br><br>
            </div>
            <div class="test6">
                <label>ASSET</label><br>
                <select name='asset_id' class='form_input'>
                    <?php echo $asset_type_list; ?>
                </select><br><br>
            </div>
            <div class="test7">
                <label>FARM: </label><br>
                <select name='farm_id' class='form_input'>
                    <?php echo $farm_list; ?>
                </select><br><br>
            </div>
    </div>
    <input type='submit' value='SEARCH' class='form_btn' />
    </form>
</div>
<br>
<br>




</body>

</html>