<?php
require('classes/fpdf.php');
require('classes/db.class.php');

$db = new db();

$pdf = new FPDF();

$pdf->AliasNbPages();

$dehusking_res = $db->exec_query('dehusking', ['*'],'','','','',"record_id = {$_GET['record_id']}");
$dehusking = $dehusking_res->fetch_assoc();

$variety_res = $db->exec_query('variety', ['*'], '', '', '', '', "record_id = {$dehusking['variety_id']}");
$variety = $variety_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->AddPage('P');

$pdf->Image('images/logo_1.png', 170, 5, 40);
// Arial bold 15
$pdf->SetFont('Arial', 'B', 8);
// Move to the right
$pdf->Cell(20);
$pdf->Cell(60, -4, '', 0, 1, 'C');
$pdf->Cell(-3);

$table_top = [20, 20, 40, 50, 35, 70, 20, 25, 50, 20, 70];
// Title
$pdf->SetFont('Arial', 'B', 22);

$pdf->Cell($table_top[0], 30, 'DEHUSKING REPORT', 0, 1, 'L');
$pdf->SetFont('Arial', 'B', 8);

$pdf->SetFont('Arial', 'B', 20); 
$pdf->Cell($table_top[0], 10, 'BATCH NO: BA ' . $dehusking['batch_id'], 0, 1, 'L');

$pdf->SetFont('Arial', 'B', 20);
$pdf->Cell(60, 15, '', 0, 1, 'C');

$pdf->Cell(100, 15, 'VARIETY:', "R" , 0, 'L');
$pdf->Cell(100, 15, $variety['name'], "", 1, 'L');

$pdf->Cell(100, 15, 'WEIGHT:', "R" , 0, 'L');
$pdf->Cell(100, 15, $dehusking['weight'], "", 1, 'L');

$pdf->Cell(100, 15, 'DRYING BIN:', "R" , 0, 'L');
$pdf->Cell(100, 15, $drying_bins['name'], "", 1, 'L');

$pdf->Cell(100, 15, 'DATE RECEIVED:', "R" , 0, 'L');
$pdf->Cell(100, 15, $dehusking['date_received'], "", 1, 'L');

$pdf->Cell(100, 15, 'DATE FINISHED:', "R" , 0, 'L');
$pdf->Cell(100, 15, $dehusking['date_finished'], "", 1, 'L');

$pdf->Cell(200, 20, "NOTES:", '', 1, 'C');
$pdf->SetFont('Arial', '', 10);

$pdf->MultiCell(190, 10, $dehusking['notes'], 1, 'L');
$pdf->SetFont('Arial', '', 10);

$pdf->Output("I");