<?php
session_start();

include "classes/html.class.php";

// var_dump($_POST);


$where_data = ' 1 ';

if ($_POST['client_id'] != '0') {
    $where_data = $where_data . " AND client_id = '{$_POST['client_id']}'";
}

if ($_POST['variety_id'] != '0') {
    $where_data = $where_data . " AND variety_id = {$_POST['variety_id']}";
}

if ($_POST['shell'] != 'ALL') {
    $where_data = $where_data . " AND shell = '{$_POST['shell']}'";
}

if ($_POST['mold'] != 'ALL') {
    $where_data = $where_data . " AND mold = {$_POST['mold']}";
}

$db = new db();

$table_data = '<tr></tr>';
$batch_res = $db->exec_query('batches', ['*'], '', '', '', '', $where_data, 'ORDER BY record_id ASC');

$where_data = str_replace("'", "|", $where_data);
$index = 0;
$total = 0;

while ($batch_info = $batch_res->fetch_assoc()) {

    $variety_res = $db->exec_query('variety', ['*'], '', '', '', '', "record_id = {$batch_info['variety_id']}");
    $variety = $variety_res->fetch_assoc();

    $clients_res = $db->exec_query('clients', ['*'], '', '', '', '', "record_id = {$batch_info['client_id']}");
    $clients = $clients_res->fetch_assoc();

    $table_data = $table_data . "
    <td><input type='text' class='table_input' value='BAR {$batch_info['record_id']}' readonly /></td>
    <td><input type='text' class='table_input' value='{$clients['client_name']}' readonly /></td>
    <td><input type='text' class='table_input' value='{$variety['name']}' readonly /></td>
    <td><input type='text' class='table_input' id='mold_$index' value='{$batch_info['mold']}' readonly /></td>
    <td><input type='text' class='table_input' id='shell_$index' value='{$batch_info['shell']}' readonly /></td>

    <script> 
    var ind = 0
    if(document.getElementById('mold_$index').value == 'NO'){
        document.getElementById('mold_$index').style.backgroundColor = 'red';
    } else if(document.getElementById('mold_$index').value == 'YES')
    {document.getElementById('mold_$index').style.backgroundColor = 'green';}
    
    if(document.getElementById('shell_$index').value == 'NO'){
        document.getElementById('shell_$index').style.backgroundColor = 'red';
    } else if(document.getElementById('shell_$index').value == 'YES')
    {document.getElementById('shell_$index').style.backgroundColor = 'green';}

    ind++;
     </script>

    <td><a href='received_nuts.pdf.php?received_record_id={$batch_info['record_id']}' target='_blank' ><input type='submit' value='PDF' class='form_btn' readonly /></a></td></tr>
    ";

    $index++;
    $total++;
}

$html = new html("BATCHES REPORT");

?>

<style>
    body {
        background-image: url('');
        /* background-color: white; */
        background-repeat: repeat-y;

    }
</style>
<br>
<br>
<table style='width:100%; text-align:center; font-size:2vw;'>
    <tr>
        <td>
            TOTAL: <?php echo $total; ?>
        </td>
        <td>
            <form action='lowveld_reports.pdf.php' target='_blank' method='POST'>
                <input type='text' hidden name='where_data' value='<?php echo $where_data; ?>' />
                <input type='text' hidden name='date' value='<?php echo $_POST['date']; ?>' />
                <input type='submit' value='FULL REPORT' class='form_btn' style="margin-top:2vw;" />
            </form>
        </td>
</table>

<table style='width:100%; text-align:center;'>
    <tr>
        <td>
            BATCH ID:
        </td>
        <td>
            CLIENT
        </td>
        <td>
            MOLD
        </td>
        <td>
            SHELL
        </td>
        <td>
            VARIETY
        </td>
    </tr>


    <?php echo $table_data; ?>
</table>

<br>
<br>
<br>
<br>
<br>
<br>