TANK LEVELS
query("tanks", "SELECT * FROM tanks WHERE record_id IN ({$_SESSION['tanks']}) AND company_id = {$_SESSION['company_id']}");
while ($tank = $tanks_res->fetch_assoc()) {
$dash->tank($tank['record_id'], "tanks/tanks_view.php?record_id={$tank['record_id']}");
}
?>
liters_bar("TOTAL TODAY (ALL)", $functions->total_liters_for_today());
?>
TOTAL PER GROUP
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 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']);
}
$dash->liters_bar($site['site_name'], $tank_total, "diesel/groups.php?record_id={$site['site_id']}");
}
?>
EXCLUDED TAGS
liters_bar($site['site_name'], $functions->total_liters_for_today_excluded_tags(), "diesel/excluded_tags_view.php"); ?>
7 DAYS (ALL)
query("fuel_movement", "SELECT sum(fm.amount) AS amount FROM fuel_movement AS fm LEFT JOIN clients as c ON c.record_id = fm.client_id WHERE ( fm.tank_id IN ({$_SESSION['tanks']}) 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 ({$_SESSION['tanks']}) 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 c.record_id = fm.client_id WHERE ( fm.tank_id IN ({$_SESSION['tanks']}) 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 ({$_SESSION['tanks']}) 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 c.record_id = fm.client_id WHERE ( fm.tank_id IN ({$_SESSION['tanks']}) 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 ({$_SESSION['tanks']}) 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 c.record_id = fm.client_id WHERE ( fm.tank_id IN ({$_SESSION['tanks']}) 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 ({$_SESSION['tanks']}) 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 c.record_id = fm.client_id WHERE ( fm.tank_id IN ({$_SESSION['tanks']}) 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 ({$_SESSION['tanks']}) 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 c.record_id = fm.client_id WHERE ( fm.tank_id IN ({$_SESSION['tanks']}) 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 ({$_SESSION['tanks']}) 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 c.record_id = fm.client_id WHERE ( fm.tank_id IN ({$_SESSION['tanks']}) 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 ({$_SESSION['tanks']}) 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 c.record_id = fm.client_id WHERE ( fm.tank_id IN ({$_SESSION['tanks']}) 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 ({$_SESSION['tanks']}) 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 (ALL)
$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 c.record_id = fm.client_id WHERE (fm.tank_id IN ({$_SESSION['tanks']}) 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 ({$_SESSION['tanks']}) 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'))];
}
echo DashboardWidget::columnGraph("", $amounts_arr, '90vw');
?>
PER GROUP
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 tanks.record_id IN ({$_SESSION['tanks']}) AND sites.company_id = {$_SESSION['company_id']}");
while ($site = $site_res->fetch_assoc()) {
$tanks = [];
$tanks_res = $db->query("tanks", "SELECT * FROM tanks WHERE company_id = {$_SESSION['company_id']} AND site_id = {$site['site_id']} AND record_id IN ({$_SESSION['tanks']})");
while ($tank = $tanks_res->fetch_assoc()) {
$tanks[] = $tank['record_id'];
}
$tanks_ids = implode(',', $tanks);
$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 c.record_id = fm.client_id WHERE ((fm.status = 'RFID' ) AND fm.company_id = {$_SESSION['company_id']} AND fm.tank_id IN ($tanks_ids) AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR ((fm.status = 'MANUAL OVERRIDE') AND fm.company_id = {$_SESSION['company_id']} AND fm.tank_id IN ($tanks_ids) 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 c.record_id = fm.client_id WHERE ((fm.status = 'RFID' ) AND fm.company_id = {$_SESSION['company_id']} AND fm.tank_id IN ($tanks_ids) AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR ((fm.status = 'MANUAL OVERRIDE') AND fm.company_id = {$_SESSION['company_id']} AND fm.tank_id IN ($tanks_ids) 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 c.record_id = fm.client_id WHERE ((fm.status = 'RFID' ) AND fm.company_id = {$_SESSION['company_id']} AND fm.tank_id IN ($tanks_ids) AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR ((fm.status = 'MANUAL OVERRIDE') AND fm.company_id = {$_SESSION['company_id']} AND fm.tank_id IN ($tanks_ids) 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 c.record_id = fm.client_id WHERE ((fm.status = 'RFID' ) AND fm.company_id = {$_SESSION['company_id']} AND fm.tank_id IN ($tanks_ids) AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR ((fm.status = 'MANUAL OVERRIDE') AND fm.company_id = {$_SESSION['company_id']} AND fm.tank_id IN ($tanks_ids) 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 c.record_id = fm.client_id WHERE ((fm.status = 'RFID' ) AND fm.company_id = {$_SESSION['company_id']} AND fm.tank_id IN ($tanks_ids) AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR ((fm.status = 'MANUAL OVERRIDE') AND fm.company_id = {$_SESSION['company_id']} AND fm.tank_id IN ($tanks_ids) 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 c.record_id = fm.client_id WHERE ((fm.status = 'RFID' ) AND fm.company_id = {$_SESSION['company_id']} AND fm.tank_id IN ($tanks_ids) AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR ((fm.status = 'MANUAL OVERRIDE') AND fm.company_id = {$_SESSION['company_id']} AND fm.tank_id IN ($tanks_ids) 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 c.record_id = fm.client_id WHERE ((fm.status = 'RFID' ) AND fm.company_id = {$_SESSION['company_id']} AND fm.tank_id IN ($tanks_ids) AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR ((fm.status = 'MANUAL OVERRIDE') AND fm.company_id = {$_SESSION['company_id']} AND fm.tank_id IN ($tanks_ids) 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 c.record_id = fm.client_id WHERE ((fm.status = 'RFID' ) AND fm.company_id = {$_SESSION['company_id']} AND fm.tank_id IN ($tanks_ids) AND fm.date_time_closed BETWEEN '{$date}' AND '{$date2}' AND c.company_id = {$_SESSION['company_id']} AND c.exclude_from_reports != 1) OR ((fm.status = 'MANUAL OVERRIDE') AND fm.company_id = {$_SESSION['company_id']} AND fm.tank_id IN ($tanks_ids) 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 c.record_id = fm.client_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