============================================================================ 🔥 SCRIPT REKALKULASI UTILITY DATA LAMA (FORMULA BENAR + SAFETY CAP) 🔥 ============================================================================ Tanggal mulai : 2026-01-01 Tanggal akhir : 2026-11-08 Total tanggal : 35 hari Tarif Listrik : Rp 1.115 / kWh Tarif Air : Rp 9.600 / m³ Tarif Gas : Rp 24.500 / kg Tarif Fuel : Rp 17.450 / L ============================================================================ ℹ️ Tidak ada baseline data SEBELUM 2026-01-01 → mulai dari 0 (pertama kali submit). (tanggal pertama engineer muncul selisih = 0, disimpan baseline dulu) ============================================================================ ============================================================================ 📋 LAPORAN HASIL REKALKULASI PER TANGGAL: ============================================================================ 1) 2026-09-21 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=28640.00 W=3890.00 G=312.00 F=0.00) 2) 2026-09-22 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=29200.00 W=3780.00 G=339.00 F=0.00) 3) 2026-09-23 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=29200.00 W=3450.00 G=343.29 F=0.00) 4) 2026-09-24 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=29440.00 W=3200.00 G=281.98 F=0.00) 5) 2026-09-25 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=25600.00 W=3600.00 G=298.00 F=0.00) 6) 2026-09-26 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=29200.00 W=4140.00 G=355.00 F=0.00) 7) 2026-09-27 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=27840.00 W=3990.00 G=294.14 F=0.00) 8) 2026-09-28 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=27600.00 W=3990.00 G=352.99 F=0.00) 9) 2026-09-29 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=27920.00 W=3890.00 G=333.06 F=0.00) 10) 2026-09-30 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=27440.00 W=3610.00 G=300.04 F=0.00) 11) 2026-10-01 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=0.00 W=0.00 G=0.00 F=0.00) 12) 2026-10-02 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=26800.00 W=3780.00 G=324.79 F=0.00) 13) 2026-10-03 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=27920.00 W=4200.00 G=327.58 F=0.00) 14) 2026-10-04 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=23552.00 W=4302.30 G=218.76 F=0.00) 15) 2026-10-05 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=28640.00 W=4210.00 G=335.72 F=0.00) 16) 2026-10-06 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=28640.00 W=4050.00 G=348.61 F=0.00) 17) 2026-10-07 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=28960.00 W=3600.00 G=254.39 F=0.00) 18) 2026-10-08 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=27120.00 W=3740.00 G=250.70 F=0.00) 19) 2026-10-09 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=27440.00 W=3700.00 G=250.70 F=0.00) 20) 2026-10-10 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=26960.00 W=3820.00 G=0.00 F=0.00) 21) 2026-10-11 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=28000.00 W=4170.00 G=309.08 F=0.00) 22) 2026-10-12 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=26560.00 W=3910.00 G=241.59 F=0.00) 23) 2026-10-13 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=26800.00 W=4500.00 G=251.00 F=0.00) 24) 2026-10-14 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=27440.00 W=3998.70 G=311.28 F=0.00) 25) 2026-10-15 | eng=2 rows=2 updated=2 🔧 DIUBAH: ELEC 43944.80→21972.40 (-21972.4) | WATER 0.00→0.00 (+0.0) | GAS 3036.08→1518.04 (-1518.0) | FUEL 0.00→0.00 (+0.0) 26) 2026-10-16 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=26240.00 W=3600.00 G=267.36 F=0.00) 27) 2026-10-17 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=26800.00 W=4000.00 G=304.00 F=0.00) 28) 2026-10-18 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=29280.00 W=4200.00 G=245.08 F=0.00) 29) 2026-10-19 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=29040.00 W=3720.00 G=270.00 F=0.00) 30) 2026-10-20 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=28720.00 W=3730.00 G=230.00 F=0.00) 31) 2026-10-21 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=28720.00 W=3620.00 G=226.61 F=0.00) 32) 2026-10-22 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=28080.00 W=3630.00 G=227.49 F=0.00) 33) 2026-10-23 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=29200.00 W=3870.00 G=249.63 F=0.00) 34) 2026-10-24 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=29440.00 W=3710.00 G=297.00 F=0.00) 35) 2026-10-25 | eng=1 rows=1 updated=1 ✅ SUDAH BENAR (E=29120.00 W=3630.00 G=370.00 F=0.00) ============================================================================ ✅ SELESAI! RINGKASAN: ============================================================================ Total tanggal diproses : 35 hari Tanggal DIUBAH (salah) : 1 hari Tanggal SUDAH BENAR : 34 hari Total row DB di-UPDATE : 36 baris 🎉🎉🎉 SEMUA DATA UTILITY DI DATABASE SEKARANG SUDAH SESUAI FORMULA BENAR! • Dashboard index.php & Print PDF daily_summary.php AMBIL DATA DARI daily_logs.total_xxx yang BARU SAJA di-UPDATE. • Jadi pastinya 100% SAMA antara Dashboard ↔ Print! ➡️ Langkah selanjutnya: 1. Refresh dashboard (Ctrl+Shift+R) → cek tanggal 01/09, 12/09, dst. 2. Klik Print → bandingkan dengan card Utility Report. 3. SEMUA ANGKA PASTI SAMA (Listrik 5.319 kWh, Water 88m3 jika benar, Gas 320 kg, Fuel sesuai equipment_data). 🔒 PENTING: HAPUS FILE recalc_utility_all_dates.php dari hosting JIKA SUDAH SELESAI. Atau rename jadi recalc_utility_all_dates.php.bak (agar tidak bisa dijalankan orang lain).