5) {
$where_data = $where_data . " AND date_time_opened BETWEEN '{$_POST['date_from']} 00:00' AND '{$_POST['date_to']} 23:59'";
}
if ($_POST['farm_id'] != 0) {
$where_data = $where_data . " AND farm_id = '{$_POST['farm_id']}'";
}
$db = new db();
$db_2 = new db('fuel');
$table_data = '|
';
$results_res = $db_2->exec_query('petrol', ['*'], '', '', '', '', $where_data, "ORDER BY record_id DESC");
$where_data = str_replace("'", "|", $where_data);
$index = 0;
$total = 0;
while ($result = $results_res->fetch_assoc()) {
$farm_res = $db->exec_query('farms', ['*'], '', '', '', '', "record_id = {$result['farm_id']}", '');
$farm = $farm_res->fetch_assoc();
$table_data = $table_data . "
|
|
|
";
$total++;
$index++;
}
$html = new html("PETROL REPORTS");
?>