5) {
$where_data = $where_data . " AND date_time_opened BETWEEN '{$_POST['date_from']} 00:00' AND '{$_POST['date_to']} 23:59'";
}
if ($_POST['asset_id'] != 0) {
$where_data = $where_data . " AND asset_id = '1_{$_POST['asset_id']}'";
}
if ($_POST['tank_id'] != 0) {
$where_data = $where_data . " AND tank_id = '{$_POST['tank_id']}'";
}
$db = new db();
$db_2 = new db('fuel');
$table_data = '|
';
$unq_data = $db_2->query('SELECT DISTINCT asset_id FROM fuel_movement WHERE ' . $where_data . ' ORDER BY asset_id DESC');
$where_data = str_replace("'", "|", $where_data);
$index = 0;
$total = 0;
while ($row = $unq_data->fetch_assoc()) {
$asset_id = $row['asset_id'];
$asset_id = str_replace("1_", "", $asset_id);
$asset_res = $db->exec_query('assets', ['*'], '', '', '', '', "record_id = $asset_id");
$asset = $asset_res->fetch_assoc();
if($asset['description'] == '') {
$asset_desc = "MANUAL OVERRIDE";
}else{
$asset_desc = $asset['description'];
}
$amount_res = $db_2->query("SELECT SUM(amount) as total_amount FROM fuel_movement WHERE asset_id = '1_$asset_id' ");
$amount = $amount_res->fetch_assoc();
$liters_1 = $amount['total_amount'] / 1000;
// LAST ODO
$last_odo_res = $db_2->query("SELECT odo FROM fuel_movement WHERE asset_id = '1_$asset_id' ORDER BY record_id DESC LIMIT 1");
$last_odo = $last_odo_res->fetch_assoc();
$odo = $last_odo['odo'];
// FIRST ODO
$first_odo_res = $db_2->query("SELECT odo FROM fuel_movement WHERE asset_id = '1_$asset_id' ORDER BY record_id ASC LIMIT 1");
$first_odo = $first_odo_res->fetch_assoc();
$first_odo = $first_odo['odo'];
$odo = $odo - $first_odo;
// NET ODO
if ($odo > 1 && $first_odo > 1) {
$consumption = round($liters_1 / $odo,2);
} else {
$consumption = 0;
}
$table_data = $table_data . "
|
|
|
|
";
$total++;
}
$html = new html("CONSUMPTION REPORTS");
?>
|
ASSET
|
AMOUNT
|
ODO
|
CONSUMPTION
|