\n"; }
else { error_log('utilFetchBoth_Db daily_logs ERROR: '.$e->getMessage()); }
}
if (!$d) $d = ['elec'=>0,'water'=>0,'gas'=>0,'fuel'=>0,'cnt'=>0,'cost_elec'=>0,'cost_water'=>0,'cost_gas'=>0,'cost_fuel'=>0];
$d['elec']=(float)($d['elec']??0); $d['water']=(float)($d['water']??0);
$d['gas']=(float)($d['gas']??0); $d['fuel']=(float)($d['fuel']??0);
$d['cnt']=(int)($d['cnt']??0);
$d['cost_elec']=(float)($d['cost_elec']??0); $d['cost_water']=(float)($d['cost_water']??0);
$d['cost_gas']=(float)($d['cost_gas']??0); $d['cost_fuel']=(float)($d['cost_fuel']??0);
/* --- (B) energy_logs (energy_logsheet.php input user) - TIDAK ADA per-log tariff, pakai global fallback --- */
/* โ 2026-08-23: SAMA DENGAN daily_logs โ DEDUP MAX(id) per (DATE, created_by) untuk hindari double SUM jika user isi berkali-kali sehari */
try {
$wE = ["DATE(log_date) BETWEEN ? AND ?"];
$pE = [$dateFrom, $dateTo];
if ($userRole === 'engineer') {
$wE[] = "created_by = ?";
$pE[] = $userId;
}
$dedupWhereE = 'WHERE ' . implode(' AND ', $wE);
$sqlE = "SELECT
COALESCE($aggFn(CAST(el.pln_lwbp_kwh AS DECIMAL(18,4)) + CAST(el.pln_wbp_kwh AS DECIMAL(18,4)) + CAST(COALESCE(el.genset_kwh,0) AS DECIMAL(18,4))),0) as elec,
COALESCE($aggFn(CAST(COALESCE(el.air_m3,0) AS DECIMAL(18,4)) + CAST(COALESCE(el.air_deep_well_m3,0) AS DECIMAL(18,4))),0) as water,
COALESCE($aggFn(CAST(COALESCE(el.gas_kg,0) AS DECIMAL(18,4)) + CAST(COALESCE(el.gas_lng_kg,0) AS DECIMAL(18,4))),0) as gas,
COALESCE($aggFn(CAST(COALESCE(el.solar_liter,0) AS DECIMAL(18,4))),0) as fuel,
COALESCE($cntFn(el.id),0) as cnt,
COALESCE($aggFn(
(CAST(el.pln_lwbp_kwh AS DECIMAL(18,4)) + CAST(el.pln_wbp_kwh AS DECIMAL(18,4)) + CAST(COALESCE(el.genset_kwh,0) AS DECIMAL(18,4)))
* {$ftEL}
),0) as cost_elec,
COALESCE($aggFn(
(CAST(COALESCE(el.air_m3,0) AS DECIMAL(18,4)) + CAST(COALESCE(el.air_deep_well_m3,0) AS DECIMAL(18,4)))
* {$ftWA}
),0) as cost_water,
COALESCE($aggFn(
(CAST(COALESCE(el.gas_kg,0) AS DECIMAL(18,4)) + CAST(COALESCE(el.gas_lng_kg,0) AS DECIMAL(18,4)))
* {$ftGA}
),0) as cost_gas,
COALESCE($aggFn(
CAST(COALESCE(el.solar_liter,0) AS DECIMAL(18,4))
* {$ftFU}
),0) as cost_fuel
FROM energy_logs el
INNER JOIN (
SELECT MAX(id) AS keep_id
FROM energy_logs
$dedupWhereE
GROUP BY DATE(log_date), created_by
) kE ON kE.keep_id = el.id";
$e = $db->fetchOne($sqlE, $pE);
if ($debug) { echo "