query("fuel_movement", "SELECT
fm.record_id AS record_id,
fm.date_time_closed,
fm.tank_id,
fm.client_id,
fm.amount,
fm.fuel_price,
fm.cash_type
FROM fuel_movement AS fm
LEFT JOIN clients AS c
ON c.record_id = fm.client_id
AND c.company_id = fm.company_id
WHERE
fm.company_id = {$_SESSION['company_id']}
AND fm.amount > 50
AND fm.tank_id IN (
SELECT record_id
FROM tanks
WHERE site_id = 13
AND company_id = {$_SESSION['company_id']}
)
AND fm.date_time_closed BETWEEN '$date 00:00' AND '$date 23:59'
AND (
(c.exclude_from_reports != 1 AND fm.client_id != 0)
OR (fm.client_id = 0 AND fm.status = 'MANUAL OVERRIDE')
)
ORDER BY fm.date_imported DESC;");
?>