<?php
session_start();
include "classes/html.class.php";
$db = new db();

$html = new html("RECIEVED REPORTS");

$batches_res = $db->exec_query('batches', ['*']);
$batches = $batches_res->fetch_assoc();

$variety_res = $db->exec_query('variety', ['*']);
$variety_list = '<option value="0">ALL</option>';
while ($variety = $variety_res->fetch_assoc()) {
    $variety_list = $variety_list . "<option value='{$variety['record_id']}'>{$variety['name']}</option>";
}

$clients_res = $db->exec_query('clients', ['*']);
$clients_list = '<option value="0">ALL</option>';
while ($client = $clients_res->fetch_assoc()) {
    $clients_list = $clients_list . "<option value='{$client['record_id']}'>{$client['client_name']}</option>";
}

?>
<div class='form' style="padding-bottom: 0%;">
    <h2 style="font-size: 2vw;">FILTER:</h2>
    <hr><br>
    <form action='lowveld_report.php' method='POST'>
        <div class="test2">
            <label>BATCHES</label><br>
        </div>

        <div class='center_screen'>
            <div class="test2">
                <label>VARIETY:</label><br>
                <select name='variety_id' class='form_input'>
                    <? echo $variety_list; ?>
                </select><br><br>
            </div>
            <div class="test3">
                <label>CLIENT:</label><br>
                <select name='client_id' class='form_input'>
                    <? echo $clients_list; ?>
                </select><br><br>
            </div>
            <div class="test4">
                <label>SHELL:</label><br>
                <select name='shell' class='form_input'>
                    <option>ALL</option>
                    <option>YES</option>
                    <option>NO</option>
                </select><br><br>
            </div>
            <div class="test5">
                <label>MOLD:</label><br>
                <select name='mold' class='form_input'>
                    <option>ALL</option>
                    <option>YES</option>
                    <option>NO</option>
                </select><br><br>
            </div>

        </div>
        <input type='submit' value='SEARCH' class='form_btn' />
    </form>
</div>
<br>
<br><br>
<br>