<?php
session_start();
include "classes/html.class.php";
$db = new db();

$variety_res = $db->exec_query('variety', ["*"]);
$variety_list = '<option value="0"></option>';
while ($varieties = $variety_res->fetch_assoc()) {
    $variety_list = $variety_list . "<option value='{$varieties['record_id']}'>{$varieties['name']}</option>";
}

$drying_bin_res = $db->exec_query('drying_bins', ["*"]);
$bin_list = '<option value="0"></option>';
while ($bins = $drying_bin_res->fetch_assoc()) {
    $bin_list = $bin_list . "<option value='{$bins['record_id']}'>{$bins['name']}</option>";
}

$html = new html("Dehusking");

?>

<div class='form' style="padding-bottom: 0%;">
    <h2 style="font-size: 2vw;">FILTER:</h2>
    <hr><br>
    <form action='dehusking_nuts.php' method='POST'>
        <div class="test2">
            <label>RECEIVED DATE</label><br>
        </div>
        <div class='center_screen'>
            <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>VARIETY</label><br>
                <select name='variety_id' class='form_input'>
                    <?php echo $variety_list; ?>
                </select><br><br>
            </div>
            <div class="test5">
                <label>BATCH</label><br>
                <input type="text" name="batch_id" style="width:20vw;" placeholder="Search for a specific batch no"
                    class="form_input"><br><br>
            </div>
            <div class="test6">
                <label>WEIGHT</label><br>
                <input type="text" name="weight" style="width:20vw;" placeholder="Search for a specific weight"
                    class="form_input"><br><br>
            </div>

        </div>
        <input type='submit' value='SEARCH' class='form_btn' />
    </form>
</div>
<br>
<br>

</body>

</html>