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['site_id'] != 0) {
$tanks = $db_2->exec_query('tanks', ['*'], '', '', '', '', "site_id = {$_POST['site_id']}");
while ($tank = $tanks->fetch_assoc()) {
$where_arr[] = " tank_id = {$tank['record_id']} ";
}
} else {
$company_res = $db_2->exec_query('companies', ['*'], '', '', '', '', "name = 'MUELL ESTATES'");
$company = $company_res->fetch_assoc();
$sites = $db_2->exec_query('sites', ['*'], '', '', '', '', "company_id = {$company['record_id']}");
while ($site = $sites->fetch_assoc()) {
$tanks = $db_2->exec_query('tanks', ['*'], '', '', '', '', "site_id = {$site['record_id']}");
while ($tank = $tanks->fetch_assoc()) {
$where_arr[] = "tank_id = {$tank['record_id']}";
}
}
}
$data = implode(' OR ', $where_arr);
$where_data = $where_data . " AND (" . $data . ")";
$results = $db_2->exec_query('fuel_movement', ['*'], '', '', '', '', $where_data, "ORDER BY record_id DESC");
// foreach ($data_1 as $row) {
while ($data_row = $results->fetch_assoc()) {
// var_dump($data_row);
// echo $data_row['record_id'];
$asset_info_res = $db->exec_query('assets', ['*'], '', '', '', '', "record_id = " . str_replace("1_", "", $data_row['asset_id']));
$asset_info = $asset_info_res->fetch_assoc();
$tank_name_res = $db_2->exec_query('tanks', ['*'], '', '', '', '', "record_id = {$data_row['tank_id']}");
$tank_info = $tank_name_res->fetch_assoc();
$table_data = $table_data . "
|
|
|
|
|
";
$index++;
$total++;
}
// echo $table_data;
$index = 0;
$total = 0;
$total_open = 0;
$total_closed = 0;
$total_waiting = 0;
?>
|
ASSET
|
LITERS
|
TANK
|
DATE
|
ODO
|