<?php
require('classes/fpdf.php');
require('classes/db.class.php');

$db = new db();

$where_data = $_POST['where_data'];
$dehusking_res = $db->exec_query('dehusking', ['*'],'','','','',$where_data);

$pdf = new FPDF();

$pdf->AliasNbPages();

$pdf->AddPage('P');

$table_top = [50, 28, 16, 65, 35, 55, 30, 20, 25, 20, 20, 20];

$pdf->SetFont('Arial', 'B', 20);
$pdf->Cell(200, 15, "DEHUSKING REPORT ", 0, 1, 'C');
$pdf->Cell(10, 5, '', 0, 1, 'L');
$pdf->SetFont('Arial', '', 10);

$pdf->Cell(10, 10, '', 0, 1, 'L');
$pdf->Cell(-2);

$pdf->Cell($table_top[7], 5, "BATCH ID", "LBR", 0, 'l');
$pdf->Cell($table_top[8], 5, "VARIETY", "BR", 0, 'l');
$pdf->Cell($table_top[2], 5, "WEIGHT", "BR", 0, 'l');
$pdf->Cell($table_top[8], 5, "DRYING BIN", "BR", 0, 'l');
$pdf->Cell($table_top[4], 5, "DATE RECEIVED", "BR", 0, 'l');
$pdf->Cell($table_top[4], 5, "DATE FINISHED", "BR", 1, 'l');

while ($dehusking = $dehusking_res->fetch_assoc()) {
    // get farm name
    $variety_name_res = $db->exec_query('variety',['*'],'','','','',"record_id = {$dehusking['variety_id']}");
    $variety_name = $variety_name_res->fetch_assoc();

    $drying_bin_res = $db->exec_query('drying_bins',['*'],'','','','',"record_id = {$dehusking['drying_bin_id']}");
    $drying_bins = $drying_bin_res->fetch_assoc();

    $pdf->Cell(-2);
    $pdf->Cell($table_top[7], 6, $dehusking['batch_id'], "LBR", 0, 'L');
    $pdf->Cell($table_top[8], 6, $variety_name['name'], "BR", 0, 'l');
    $pdf->Cell($table_top[2], 6, $dehusking['weight'], "BR", 0, 'l');
    $pdf->Cell($table_top[8], 6, $drying_bins['name'], "BR", 0, 'l');
    $pdf->Cell($table_top[4], 6, $dehusking['date_received'], "BR", 0, 'l');
    $pdf->Cell($table_top[4], 6, $dehusking['date_finished'], "BR", 1, 'l');

}

$shell_res = $db->exec_query('batches',['*'],'','','','',"shell = 'NO'");

$pdf->Output("I");