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['weight'] != '') {
$where_data = $where_data . " AND weight LIKE '%{$_POST['weight']}%'";
}
if ($_POST['shell'] != 'ALL') {
$where_data = $where_data . " AND shell = '{$_POST['shell']}'";
}
$table_data = '|
';
$batch_res = $db->exec_query('batches', ['*'], '', '', '', '', $where_data, "", false);
if ($batch_res->num_rows >= 1) {
while ($row = $batch_res->fetch_assoc()) {
$variety_res = $db->exec_query("variety", ['*'], '', '', '', '', "record_id = {$row['variety_id']}", '', false);
$variety_data = $variety_res->fetch_assoc();
if ($row['shell'] == "YES") {
$Compelted = "YES";
$style = "style='background-color:red;'";
} else {
$Compelted = "NO";
$style = "style='background-color:green;'";
}
$table_data = $table_data . "
|
|
|
|
|
";
}
} else {
$table_data = "| NO RESULTS |
";
}
?>
|
VARIETY:
|
WEIGHT:
|
SHELL:
|
DATE:
|