6) {
echo $where_data = $where_data . " AND 'date' BETWEEN '{$_POST['date_from']}' AND '{$_POST['date_to']}' ";
}
if ($_POST['variety_id'] != '0') {
$where_data = $where_data . " AND variety_id = {$_POST['variety_id']}";
}
if ($_POST['drying_bin'] != '0') {
$where_data = $where_data . " AND drying_bin_id = {$_POST['drying_bin']}";
}
if ($_POST['weight'] != '') {
$where_data = $where_data . " AND 'weight' LIKE '%{$_POST['weight']}%'";
}
if ($_POST['batch'] != '') {
$where_data = $where_data . " AND batch_id = {$_POST['batch_id']}";
}
$table_data = '|
';
$drying_bin_res = $db->exec_query('bins', ['*'], '', '', '', '', $where_data, '', false);
if ($drying_bin_res->num_rows >= 1) {
while ($row = $drying_bin_res->fetch_assoc()) {
$variety_res = $db->exec_query("variety", ['*'], '', '', '', '', "record_id = {$row['variety_id']}", '', false);
$variety_data = $variety_res->fetch_assoc();
$drying_bins_res = $db->exec_query("drying_bins", ['*'], '', '', '', '', "record_id = {$row['drying_bin_id']}", '', false);
$drying_bins = $drying_bins_res->fetch_assoc();
$table_data = $table_data . "
|
|
|
|
|
|
";
}
} else {
$table_data = "| NO RESULTS |
";
}
?>
|
BATCH ID:
|
VARIETY:
|
WEIGHT:
|
DRYING BIN:
|
DATE:
|