query("fuel_movement", "SELECT * FROM fuel_movement as fm LEFT JOIN clients as c ON fm.client_id = c.record_id WHERE (fm.status = 'RFID' AND fm.tank_id = {$_GET['tank_id']} AND fm.company_id = {$_SESSION['company_id']} AND fm.amount > 100 AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR (fm.status = 'MANUAL OVERRIDE' AND fm.tank_id = {$_GET['tank_id']} AND fm.company_id = {$_SESSION['company_id']} AND fm.amount > 100 AND fm.client_id = 0) ORDER BY fm.date_time_closed DESC LIMIT 50");
$table_data = [];
while ($fuel_movement = $fuel_movement_res_table->fetch_assoc()) {
$table_data[] = [
$functions->get_tank_name($fuel_movement['tank_id']),
$functions->get_client_name($fuel_movement['client_id']),
number_format(($fuel_movement['amount'] / 1000), 3),
$fuel_movement['date_time_closed'],
//$functions->get_username($fuel_movement['user_id']),
'diesel/slip.pdf.php?record_id=' . $fuel_movement['record_id']
];
}
echo "RECENT MOVEMENTS FOR {$functions->get_tank_name($_GET['tank_id'])}
";
echo DashboardWidget::tableBlock('', ['PUMP', 'TAG', 'AMOUNT', "DATE"], $table_data, '90vw');
?>