<?php
session_start();
include "classes/html.class.php";

$db = new db();
$db_2 = new db('fuel');

$html = new html("CONSUMPTION REPORTS");

$movement_res = $db_2->exec_query('fuel_movement', ['*']);
$movement = $movement_res->fetch_assoc();

$unq_data = $db_2->query('SELECT DISTINCT asset_id FROM fuel_movement');
$asset_list = '<option value="0">ALL</option>';

while ($row = $unq_data->fetch_assoc()) {

    $asset_id = $row['asset_id'];
    $asset_id = str_replace("1_", "", $asset_id);
    $asset_res = $db->exec_query('assets', ['*'], '', '', '', '', "record_id = $asset_id");
    $asset = $asset_res->fetch_assoc();

    if($asset['description'] == '') {
        $asset_desc = "MANUAL OVERRIDE";
    }else{
        $asset_desc = $asset['description'];
    }

    $asset_list = $asset_list . "<option value='{$asset_id}'>{$asset_desc}</option>";
}

$tank_res = $db_2->exec_query('tanks', ['*'], '', '', '', '', "site_id <= 3");
$tank_list = '<option value="0">ALL</option>';

while ($tank = $tank_res->fetch_assoc()) {
    $tank_list = $tank_list . "<option value='{$tank['record_id']}'>{$tank['name']}</option>";
}

?>
<div class='form' style="padding-bottom: 0%;">
    <h2 style="font-size: 2vw;">FILTER:</h2>
    <hr><br>
    <form action='consumption_report.php' method='POST'>
    <div class='center_screen'>
            <div class="test2">
                <label>ASSET:</label><br>
                <select name='asset_id' class='form_input'>
                    <?php echo $asset_list; ?>
                </select><br><br>
            </div>
            <div class="test3">
                <label>TANK:</label><br>
                <select name='tank_id' class='form_input'>
                    <?php echo $tank_list; ?>
                </select><br><br>
            </div>

        </div>
        <input type='submit' value='SEARCH' class='form_btn' />
    </form>
</div>
<br>
<br><br>
<br>