GROUP TANK LEVELS
query("tanks", "SELECT * FROM tanks WHERE record_id IN ({$_SESSION['tanks']}) AND company_id = {$_SESSION['company_id']} AND site_id = {$_GET['record_id']}");
while ($tank = $tanks_res->fetch_assoc()) {
$dash->tank($tank['record_id'], "#");
}
?>
TOTAL
query("sites", "SELECT DISTINCT sites.record_id AS site_id, sites.name AS site_name FROM sites LEFT JOIN tanks ON sites.record_id = tanks.site_id WHERE sites.record_id = {$_GET['record_id']} AND tanks.record_id IN ({$_SESSION['tanks']}) AND sites.company_id = {$_SESSION['company_id']}");
while ($site = $site_res->fetch_assoc()) {
$tanks_res = $db->query("tanks", "SELECT * FROM tanks WHERE company_id = {$_SESSION['company_id']} AND site_id = {$site['site_id']}");
$tank_total = 0;
while ($tank = $tanks_res->fetch_assoc()) {
$tank_total += $functions->total_liters_for_tank($tank['record_id']);
}
$site_name = $site['site_name'];
$dash->liters_bar($site['site_name'], $tank_total);
}
?>
TOTAL PER PUMP
query("tanks", "SELECT * FROM tanks WHERE record_id IN ({$_SESSION['tanks']}) AND company_id = {$_SESSION['company_id']} AND site_id = {$_GET['record_id']}");
while ($tank = $tank_res->fetch_assoc()) {
$tanks_list[] = $tank['record_id'];
$tank_total = $functions->total_liters_for_tank($tank['record_id']);
$dash->liters_bar($tank['name'], $tank_total, "pump_view.php?tank_id={$tank['record_id']}");
}
$tanks = implode(' OR tank_id = ', $tanks_list);
$fuel_movement_res_table = $db->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 = $tanks 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 = $tanks 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
";
echo DashboardWidget::tableBlock('', ['PUMP', 'TAG', 'AMOUNT', "DATE"], $table_data, '90vw');
?>
7 DAYS ()
query("fuel_movement", "SELECT sum(fm.amount) AS amount FROM fuel_movement as fm LEFT JOIN clients as c ON fm.client_id = c.record_id WHERE (fm.tank_id IN ($tanks_list) AND ( fm.status = 'RFID' ) AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR (fm.tank_id IN ($tanks_list) AND (fm.status = 'MANUAL OVERRIDE') AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND fm.client_id = 0)");
$fuel_movement = $fuel_movement_array_res->fetch_assoc();
$data_array[] = [$fuel_movement['amount'], get_day_of_the_week($date)];
$date = date('Y-m-d', strtotime("-1 day")) . ' 00:00';
$date2 = date('Y-m-d', strtotime("-1 day")) . ' 23:59';
$fuel_movement_array_res = $db->query("fuel_movement", "SELECT sum(fm.amount) AS amount FROM fuel_movement as fm LEFT JOIN clients as c ON fm.client_id = c.record_id WHERE (fm.tank_id IN ($tanks_list) AND ( fm.status = 'RFID' ) AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR (fm.tank_id IN ($tanks_list) AND (fm.status = 'MANUAL OVERRIDE') AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND fm.client_id = 0)");
$fuel_movement = $fuel_movement_array_res->fetch_assoc();
$data_array[] = [$fuel_movement['amount'], get_day_of_the_week($date)];
$date = date('Y-m-d', strtotime("-2 day")) . ' 00:00';
$date2 = date('Y-m-d', strtotime("-2 day")) . ' 23:59';
$fuel_movement_array_res = $db->query("fuel_movement", "SELECT sum(fm.amount) AS amount FROM fuel_movement as fm LEFT JOIN clients as c ON fm.client_id = c.record_id WHERE (fm.tank_id IN ($tanks_list) AND ( fm.status = 'RFID' ) AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR (fm.tank_id IN ($tanks_list) AND (fm.status = 'MANUAL OVERRIDE') AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND fm.client_id = 0)");
$fuel_movement = $fuel_movement_array_res->fetch_assoc();
$data_array[] = [$fuel_movement['amount'], get_day_of_the_week($date)];
$date = date('Y-m-d', strtotime("-3 day")) . ' 00:00';
$date2 = date('Y-m-d', strtotime("-3 day")) . ' 23:59';
$fuel_movement_array_res = $db->query("fuel_movement", "SELECT sum(fm.amount) AS amount FROM fuel_movement as fm LEFT JOIN clients as c ON fm.client_id = c.record_id WHERE (fm.tank_id IN ($tanks_list) AND ( fm.status = 'RFID' ) AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR (fm.tank_id IN ($tanks_list) AND (fm.status = 'MANUAL OVERRIDE') AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND fm.client_id = 0)");
$fuel_movement = $fuel_movement_array_res->fetch_assoc();
$data_array[] = [$fuel_movement['amount'], get_day_of_the_week($date)];
$date = date('Y-m-d', strtotime("-4 day")) . ' 00:00';
$date2 = date('Y-m-d', strtotime("-4 day")) . ' 23:59';
$fuel_movement_array_res = $db->query("fuel_movement", "SELECT sum(fm.amount) AS amount FROM fuel_movement as fm LEFT JOIN clients as c ON fm.client_id = c.record_id WHERE (fm.tank_id IN ($tanks_list) AND ( fm.status = 'RFID' ) AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR (fm.tank_id IN ($tanks_list) AND (fm.status = 'MANUAL OVERRIDE') AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND fm.client_id = 0)");
$fuel_movement = $fuel_movement_array_res->fetch_assoc();
$data_array[] = [$fuel_movement['amount'], get_day_of_the_week($date)];
$date = date('Y-m-d', strtotime("-5 day")) . ' 00:00';
$date2 = date('Y-m-d', strtotime("-5 day")) . ' 23:59';
$fuel_movement_array_res = $db->query("fuel_movement", "SELECT sum(fm.amount) AS amount FROM fuel_movement as fm LEFT JOIN clients as c ON fm.client_id = c.record_id WHERE (fm.tank_id IN ($tanks_list) AND ( fm.status = 'RFID' ) AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR (fm.tank_id IN ($tanks_list) AND (fm.status = 'MANUAL OVERRIDE') AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND fm.client_id = 0)");
$fuel_movement = $fuel_movement_array_res->fetch_assoc();
$data_array[] = [$fuel_movement['amount'], get_day_of_the_week($date)];
$date = date('Y-m-d', strtotime("-6 day")) . ' 00:00';
$date2 = date('Y-m-d', strtotime("-6 day")) . ' 23:59';
$fuel_movement_array_res = $db->query("fuel_movement", "SELECT sum(fm.amount) AS amount FROM fuel_movement as fm LEFT JOIN clients as c ON fm.client_id = c.record_id WHERE (fm.tank_id IN ($tanks_list) AND ( fm.status = 'RFID' ) AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR (fm.tank_id IN ($tanks_list) AND (fm.status = 'MANUAL OVERRIDE') AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND fm.client_id = 0)");
$fuel_movement = $fuel_movement_array_res->fetch_assoc();
$data_array[] = [$fuel_movement['amount'], get_day_of_the_week($date)];
$date = date('Y-m-d', strtotime("-7 day")) . ' 00:00';
$date2 = date('Y-m-d', strtotime("-7 day")) . ' 23:59';
$fuel_movement_array_res = $db->query("fuel_movement", "SELECT sum(fm.amount) AS amount FROM fuel_movement as fm LEFT JOIN clients as c ON fm.client_id = c.record_id WHERE (fm.tank_id IN ($tanks_list) AND ( fm.status = 'RFID' ) AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR (fm.tank_id IN ($tanks_list) AND (fm.status = 'MANUAL OVERRIDE') AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND fm.client_id = 0)");
$fuel_movement = $fuel_movement_array_res->fetch_assoc();
$data_array[] = [$fuel_movement['amount'], get_day_of_the_week($date)];
echo DashboardWidget::columnGraph('', $data_array, '90vw');
?>
MONTHLY ()
$month) {
$total_amount_res = $db->query("fuel_movement", "SELECT SUM(amount) AS total_amount FROM fuel_movement as fm LEFT JOIN clients AS c ON fm.client_id = c.record_id WHERE (fm.tank_id IN ($tanks_list) AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$month}-01 00:00' AND '{$month}-31 23:59' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR (fm.tank_id IN ($tanks_list) AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$month}-01 00:00' AND '{$month}-31 23:59' AND fm.client_id = 0)");
$amounts_arr[] = [$total_amount_res->fetch_assoc()['total_amount'], date('F', strtotime($month . '-01'))];
}
echo DashboardWidget::columnGraph("", $amounts_arr, '90vw');
?>
PER PUMP
query("tanks", "SELECT * FROM tanks WHERE company_id = {$_SESSION['company_id']} AND site_id = {$_GET['record_id']}");
while ($tank = $tanks_res->fetch_assoc()) {
$tanks_ids = $tank['record_id'];
$data_array = [];
$date = date('Y-m-d') . ' 00:00';
$date2 = date('Y-m-d') . ' 23:59';
$fuel_movement_array_res = $db->query("fuel_movement", "SELECT sum(fm.amount) AS amount FROM fuel_movement as fm LEFT JOIN clients as c ON fm.client_id = c.record_id WHERE (fm.tank_id IN ($tanks_ids) AND (fm.status = 'RFID') AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '$date 00:00' AND '$date2 23:59' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR (fm.tank_id IN ($tanks_ids) AND fm.status = 'MANUAL OVERRIDE' AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '$date 00:00' AND '$date2 23:59' AND fm.client_id = 0)");
$fuel_movement = $fuel_movement_array_res->fetch_assoc();
$data_array[] = [$fuel_movement['amount'], get_day_of_the_week($date)];
$date = date('Y-m-d', strtotime("-1 day")) . ' 00:00';
$date2 = date('Y-m-d', strtotime("-1 day")) . ' 23:59';
$fuel_movement_array_res = $db->query("fuel_movement", "SELECT sum(fm.amount) AS amount FROM fuel_movement as fm LEFT JOIN clients as c ON fm.client_id = c.record_id WHERE (fm.tank_id IN ($tanks_ids) AND (fm.status = 'RFID') AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR (fm.tank_id IN ($tanks_ids) AND (fm.status = 'MANUAL OVERRIDE') AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND fm.client_id = 0)");
$fuel_movement = $fuel_movement_array_res->fetch_assoc();
$data_array[] = [$fuel_movement['amount'], get_day_of_the_week($date)];
$date = date('Y-m-d', strtotime("-2 day")) . ' 00:00';
$date2 = date('Y-m-d', strtotime("-2 day")) . ' 23:59';
$fuel_movement_array_res = $db->query("fuel_movement", "SELECT sum(fm.amount) AS amount FROM fuel_movement as fm LEFT JOIN clients as c ON fm.client_id = c.record_id WHERE (fm.tank_id IN ($tanks_ids) AND (fm.status = 'RFID') AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR (fm.tank_id IN ($tanks_ids) AND (fm.status = 'MANUAL OVERRIDE') AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND fm.client_id = 0)");
$fuel_movement = $fuel_movement_array_res->fetch_assoc();
$data_array[] = [$fuel_movement['amount'], get_day_of_the_week($date)];
$date = date('Y-m-d', strtotime("-3 day")) . ' 00:00';
$date2 = date('Y-m-d', strtotime("-3 day")) . ' 23:59';
$fuel_movement_array_res = $db->query("fuel_movement", "SELECT sum(fm.amount) AS amount FROM fuel_movement as fm LEFT JOIN clients as c ON fm.client_id = c.record_id WHERE (fm.tank_id IN ($tanks_ids) AND (fm.status = 'RFID') AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR (fm.tank_id IN ($tanks_ids) AND (fm.status = 'MANUAL OVERRIDE') AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND fm.client_id = 0)");
$fuel_movement = $fuel_movement_array_res->fetch_assoc();
$data_array[] = [$fuel_movement['amount'], get_day_of_the_week($date)];
$date = date('Y-m-d', strtotime("-4 day")) . ' 00:00';
$date2 = date('Y-m-d', strtotime("-4 day")) . ' 23:59';
$fuel_movement_array_res = $db->query("fuel_movement", "SELECT sum(fm.amount) AS amount FROM fuel_movement as fm LEFT JOIN clients as c ON fm.client_id = c.record_id WHERE (fm.tank_id IN ($tanks_ids) AND (fm.status = 'RFID') AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR (fm.tank_id IN ($tanks_ids) AND (fm.status = 'MANUAL OVERRIDE') AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND fm.client_id = 0)");
$fuel_movement = $fuel_movement_array_res->fetch_assoc();
$data_array[] = [$fuel_movement['amount'], get_day_of_the_week($date)];
$date = date('Y-m-d', strtotime("-5 day")) . ' 00:00';
$date2 = date('Y-m-d', strtotime("-5 day")) . ' 23:59';
$fuel_movement_array_res = $db->query("fuel_movement", "SELECT sum(fm.amount) AS amount FROM fuel_movement as fm LEFT JOIN clients as c ON fm.client_id = c.record_id WHERE (fm.tank_id IN ($tanks_ids) AND (fm.status = 'RFID') AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR (fm.tank_id IN ($tanks_ids) AND (fm.status = 'MANUAL OVERRIDE') AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND fm.client_id = 0)");
$fuel_movement = $fuel_movement_array_res->fetch_assoc();
$data_array[] = [$fuel_movement['amount'], get_day_of_the_week($date)];
$date = date('Y-m-d', strtotime("-6 day")) . ' 00:00';
$date2 = date('Y-m-d', strtotime("-6 day")) . ' 23:59';
$fuel_movement_array_res = $db->query("fuel_movement", "SELECT sum(fm.amount) AS amount FROM fuel_movement as fm LEFT JOIN clients as c ON fm.client_id = c.record_id WHERE (fm.tank_id IN ($tanks_ids) AND (fm.status = 'RFID') AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR (fm.tank_id IN ($tanks_ids) AND (fm.status = 'MANUAL OVERRIDE') AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND fm.client_id = 0)");
$fuel_movement = $fuel_movement_array_res->fetch_assoc();
$data_array[] = [$fuel_movement['amount'], get_day_of_the_week($date)];
$date = date('Y-m-d', strtotime("-7 day")) . ' 00:00';
$date2 = date('Y-m-d', strtotime("-7 day")) . ' 23:59';
$fuel_movement_array_res = $db->query("fuel_movement", "SELECT sum(fm.amount) AS amount FROM fuel_movement as fm LEFT JOIN clients as c ON fm.client_id = c.record_id WHERE (fm.tank_id IN ($tanks_ids) AND (fm.status = 'RFID') AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR (fm.tank_id IN ($tanks_ids) AND (fm.status = 'MANUAL OVERRIDE') AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND fm.client_id = 0)");
$fuel_movement = $fuel_movement_array_res->fetch_assoc();
$data_array[] = [$fuel_movement['amount'], get_day_of_the_week($date)];
?>
7 DAYS ()
$month) {
$total_amount_res = $db->query("fuel_movement", "SELECT SUM(fm.amount) AS total_amount FROM fuel_movement AS fm LEFT JOIN clients as c ON fm.client_id = c.record_id WHERE (fm.tank_id IN ($tanks_ids) AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$month}-01' AND '{$month}-31' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR (fm.tank_id IN ($tanks_ids) AND fm.company_id = {$_SESSION['company_id']} AND fm.date_time_closed BETWEEN '{$month}-01' AND '{$month}-31' AND fm.client_id = 0)");
$amounts_arr[] = [$total_amount_res->fetch_assoc()['total_amount'], date('F', strtotime($month . '-01'))];
}
?>
MONTHLY ()