{{-- DASHBOARD MUTU E / TEBU TERBAKAR. API existing SP id=4. --}}
<div id="burnDashboard" class="burn-dashboard container-fluid py-3">
 <div class="burn-hero mb-3"><div class="d-flex flex-wrap align-items-center justify-content-between gap-2"><div><div class="burn-eyebrow">PRODIS KSO · REALISASI PRODUKSI</div><h3 class="mb-1 fw-bold">REALISASI PRODUKSI BERDASARKAN MUTU 2026 VS 2025</h3><div class="burn-sub">Rekap semua mutu A–G dan total produksi berdasarkan filter tahun serta tanggal</div></div><div class="burn-hero-icon">📊</div></div></div>
 <div class="burn-panel mb-3"><form id="burnForm" class="burn-filters"><label>Level rekap<select id="burnJenis" class="form-select"><option value="KEBUN">Kebun</option><option value="RAYON">Rayon</option></select></label><label>Tanggal s.d.<input id="burnDate" type="date" class="form-control" value="{{ date('Y-m-d', strtotime('-1 day')) }}"></label><label>Tahun tampilan<select id="burnYears" class="form-select"><option value="2026">2026</option><option value="both">2026 &amp; 2025</option><option value="2025">2025</option></select></label><button id="burnReload" type="submit" class="burn-btn primary">⟳ Muat Data</button><button type="button" id="burnExportXlsx" class="burn-btn success" disabled>⇩ Excel</button><button type="button" id="burnExportPdf" class="burn-btn outline" disabled>⇩ PDF</button><button type="button" id="burnExportPng" class="burn-btn outline" disabled>⇩ PNG Grafik</button></form><div id="burnAlert" class="burn-alert mt-2" style="display:none"></div></div>
  <div class="burn-panel mb-3 burn-all-panel"><div class="burn-section"><div><h5>Realisasi Produksi Berdasarkan Mutu</h5><p>Tabel utama lengkap: Mutu A–G dan Total • scroll horizontal untuk indikator berikutnya</p></div><span class="burn-label" id="burnAllYearsLabel">2026 &amp; 2025</span></div><div class="burn-toolbar"><label>Cari kebun / regional <input id="burnSearch" type="search" placeholder="Cari nama kebun, plant, rayon..." class="form-control"></label><span id="burnAllCount" class="burn-muted">Belum ada data</span><button class="burn-btn outline" id="burnExportAll" type="button" disabled>⇩ Excel Semua Mutu</button><button class="burn-btn outline burn-png-btn" id="burnPngAll" type="button" disabled>▣ PNG Tabel Semua Mutu</button></div><div class="burn-scroll burn-all-scroll"><table id="burnAllTable" class="burn-table burn-full-table"><thead></thead><tbody></tbody></table></div><div class="burn-note">Tampilan mengikuti pilihan tahun di filter atas. Data Total adalah penjumlahan kategori A–G. Produktivitas = tebu ÷ luas; rendemen = hablur ÷ tebu × 100. Subtotal Regional dan Total KSO mengikuti hasil SP.</div></div>

<!-- Rekap pengelompokan bersama untuk tabel A+B dan Mutu E -->
<div class="burn-panel mb-3 burn-group-panel" id="burnDataModePanel"><div class="burn-section" style="margin-bottom:0"><div><h5>Pembanding Monitoring Tebu Terbakar</h5><p>DATA 1: Mutu E dibandingkan realisasi semua mutu. DATA 2: Mutu E dibandingkan Taksasi Maret dari SP ID 89. Mutu A+B tetap realisasi.</p><div class="burn-note" id="burnTakmarStatus" aria-live="polite">DATA 1 aktif · Realisasi vs realisasi</div></div><div class="burn-group-switch" id="burnDataSwitch" role="group" aria-label="Sumber pembanding Mutu E"><button type="button" class="active" data-burn-data="1" aria-pressed="true">DATA 1 · Realisasi</button><button type="button" data-burn-data="2" aria-pressed="false">DATA 2 · Taksasi Maret</button></div></div></div>
<div class="burn-panel mb-3 burn-group-panel"><div class="burn-section" style="margin-bottom:0"><div><h5>Pengelompokan Rekap Kebun / Rayon</h5><p>Ganti antara subtotal Regional dan subtotal Cluster tanpa memuat ulang data. Berlaku untuk tabel Mutu A+B, Mutu E, serta ekspor Excel dan PNG.</p></div><div class="burn-group-switch" id="burnGroupSwitch" role="group" aria-label="Pengelompokan rekap"><button type="button" class="active" data-burn-group="regional" aria-pressed="true">▤ Per Regional</button><button type="button" data-burn-group="cluster" aria-pressed="false">▦ Per Cluster</button></div></div></div>
<!-- TAMBAHAN: MONITORING MUTU A+B (sebelum Mutu E) -->
<section class="burn-ab-zone" aria-label="Monitoring Mutu A dan B">
 <div class="burn-hero burn-hero-second mb-3 burn-ab-hero"><div class="d-flex flex-wrap align-items-center justify-content-between gap-2"><div><div class="burn-eyebrow">PRODIS KSO · ANALISIS MUTU TEBU</div><h3 class="mb-1 fw-bold">MONITORING TEBU <span class="burn-badge">MUTU A+B</span></h3><div class="burn-sub">Kontribusi gabungan Mutu A dan B dibanding seluruh mutu A–G · Kebun / Rayon</div></div><div class="burn-hero-icon">🌿</div></div></div>
 <div class="burn-kpis" id="burnAbKpis"></div>
 <div class="burn-panel mt-3"><div class="burn-section"><div><h5>Ringkasan Tebu Mutu A+B</h5><p>Luas dan tebu Mutu A+B serta persentasenya terhadap total semua mutu.</p></div><div class="burn-section-actions"><span id="burnAbSummaryLabel" class="burn-label"></span><button type="button" class="burn-btn success" id="burnAbExcelSummary" disabled>⇩ Excel Ringkasan A+B</button><button type="button" class="burn-btn outline burn-png-btn" id="burnAbPngSummary" disabled>▣ PNG Ringkasan A+B</button></div></div><div class="burn-scroll"><table id="burnAbSummary" class="burn-table"><thead></thead><tbody></tbody></table></div></div>
 <div class="burn-panel mt-3"><div class="burn-section"><div><h5>Detail Kinerja Mutu A+B</h5><p>Centang indikator yang ingin ditampilkan; kolom diperbarui langsung.</p></div><div class="burn-section-actions"><span class="burn-label">Pilih kolom</span><button type="button" class="burn-btn success" id="burnAbExcelDetails" disabled>⇩ Excel Detail A+B</button><button type="button" class="burn-btn outline burn-png-btn" id="burnAbPngDetails" disabled>▣ PNG Detail A+B</button></div></div><div class="burn-checks" id="burnAbMetricChecks" role="group" aria-label="Pilihan kolom Mutu A+B"></div><div class="burn-note" id="burnAbSelectedInfo"></div><div class="burn-scroll"><table id="burnAbDetails" class="burn-table"><thead></thead><tbody></tbody></table></div><div class="burn-note">Kontribusi (%) = (A+B) ÷ Total semua mutu × 100. Produktivitas A+B = jumlah tebu A+B ÷ jumlah luas A+B. Rendemen A+B = jumlah hablur A+B ÷ jumlah tebu A+B × 100.</div></div>
 <div class="burn-panel mt-3"><div class="burn-section"><div><h5>Grafik Evaluasi Mutu A+B</h5><p>Angka pada batang dan perbandingan 2026 / 2025 sesuai pilihan tahun.</p></div><div class="burn-section-actions"><label class="burn-select-label">Indikator grafik<select id="burnAbChartMetric" class="form-select"><option value="luas">Luas (Ha)</option><option value="tebu" selected>Tebu (Ton)</option><option value="protas">Produktivitas (Ton/Ha)</option><option value="rendemen">Rendemen (%)</option><option value="hablur">Hablur (Ton)</option><option value="gula_ptr">Gula Milik (Ton)</option><option value="tetes_ptr">Tetes Milik (Ton)</option><option value="luas_pct">Kontribusi Luas (%)</option><option value="tebu_pct">Kontribusi Tebu (%)</option></select></label><button id="burnAbPngChart" type="button" class="burn-btn outline burn-png-btn" disabled>▣ PNG Grafik A+B</button></div></div><div class="burn-chart-container"><canvas id="burnAbChart"></canvas></div></div>

 <div class="burn-panel mt-3" id="burnCompositionSection">
  <div class="burn-section"><div><h5>Perbandingan Komposisi Mutu 2026 vs 2025 per Kebun</h5><p>Persentase tonase Mutu A–G terhadap total tebu semua mutu di kebun terpilih; tiap tahun dihitung dari total tahun tersebut.</p></div>
   <div class="burn-section-actions"><label class="burn-select-label">Pilih kebun / rayon<select id="burnCompositionKebun" class="form-select"><option value="">Seluruh KSO</option></select></label>
   <button id="burnCompositionPng" type="button" class="burn-btn outline burn-png-btn" disabled>▣ PNG Grafik Komposisi</button></div></div>
  <div class="burn-chart-container burn-composition-container"><canvas id="burnCompositionChart"></canvas></div>
  <div id="burnCompositionNote" class="burn-note">Grafik menggunakan tonase per mutu ÷ tonase total tahun bersangkutan × 100.</div>
 </div>
</section>
 <div class="burn-hero burn-hero-second mb-3"><div class="d-flex flex-wrap align-items-center justify-content-between gap-2"><div><div class="burn-eyebrow">PRODIS KSO · ANALISIS MUTU E</div><h3 class="mb-1 fw-bold">MONITORING TEBU TERBAKAR <span class="burn-badge">MUTU E</span></h3><div class="burn-sub">Kontribusi luas, produksi, detail indikator dan grafik per kebun / rayon</div></div><div class="burn-hero-icon">🔥</div></div></div>
<div class="burn-kpis" id="burnKpis"></div>
 <div class="burn-panel mt-3"><div class="burn-section"><div><h5>Ringkasan Tebu Terbakar</h5><p>Luas dan tebu terbakar (Mutu E), total semua mutu A–G, serta persentase terbakar terhadap total di masing-masing kebun.</p></div><div class="burn-section-actions"><div class="burn-label" id="burnSummaryLabel">2026</div><button type="button" id="burnExcelSummary" class="burn-btn success" disabled>⇩ Excel Ringkasan</button><button type="button" id="burnPngSummary" class="burn-btn outline burn-png-btn" disabled>▣ PNG Ringkasan</button></div></div><div class="burn-scroll"><table id="burnSummary" class="burn-table"><thead></thead><tbody></tbody></table></div></div>
 <div class="burn-panel mt-3"><div class="burn-section"><div><h5>Detail Kinerja Mutu E</h5><p>Centang indikator: tampilkan angka terbakar, angka total semua mutu, dan kontribusinya. Protas dan rendemen juga dibandingkan dengan nilai total mutu tanpa dijumlahkan.</p></div><div class="burn-section-actions"><div class="burn-label">Pilih kolom</div><button type="button" id="burnExcelDetails" class="burn-btn success" disabled>⇩ Excel Detail</button><button type="button" id="burnPngDetails" class="burn-btn outline burn-png-btn" disabled>▣ PNG Detail</button></div></div><div class="burn-checks" id="burnMetricChecks" role="group" aria-label="Pilihan kolom Mutu E"></div><div class="burn-note" id="burnSelectedInfo" aria-live="polite"></div><div class="burn-scroll"><table id="burnDetails" class="burn-table"><thead></thead><tbody></tbody></table></div><div class="burn-note">% Terbakar = nilai Mutu E ÷ nilai total semua mutu × 100 (indikator jumlah). Protas = Tebu ÷ Luas; Rendemen = Hablur ÷ Tebu × 100, masing-masing dihitung tersendiri untuk Mutu E dan seluruh mutu. Protas dan rendemen bukan indikator penjumlahan.</div></div>
 <div class="burn-panel mt-3" id="burnChartSection"><div class="burn-section"><div><h5>Grafik Evaluasi Mutu E</h5><p>Perbandingan per kebun/rayon tanpa baris subtotal, dengan pilihan indikator dan tahun.</p></div><label class="burn-select-label">Indikator grafik<select id="burnChartMetric" class="form-select"><option value="luas">Luas (Ha)</option><option value="tebu" selected>Tebu (Ton)</option><option value="hablur">Hablur (Ton)</option><option value="gula_ptr">Gula Milik (Ton)</option><option value="tetes_ptr">Tetes Milik (Ton)</option><option value="protas">Produktivitas (Ton/Ha)</option><option value="rendemen">Rendemen (%)</option><option value="luas_pct">Kontribusi Luas (%)</option><option value="tebu_pct">Kontribusi Tebu (%)</option></select></label><button id="burnPngChart" type="button" class="burn-btn outline burn-png-btn" disabled>▣ PNG Grafik HD</button></div><div class="burn-chart-container"><canvas id="burnChart"></canvas></div></div>
</div>
<style>
#burnDashboard{--burn-navy:#102d46;--burn-blue:#175b85;--burn-bg:#f4f7fb;--burn-ink:#182e40;color:var(--burn-ink);font-family:Inter,system-ui,-apple-system,'Segoe UI',sans-serif;font-size:13px}
#burnDashboard .burn-hero{background:linear-gradient(115deg,#153451,#176184);padding:21px 25px;color:#fff;border-radius:16px;box-shadow:0 8px 20px #183e5b25}#burnDashboard .burn-hero h3{color:#fff;font-size:clamp(19px,2.1vw,27px)}.burn-eyebrow{font-size:11px;letter-spacing:2px;color:#bde7f2;font-weight:800}.burn-sub{color:#d9eff6;font-size:12px}.burn-badge{display:inline-block;border-radius:7px;padding:4px 9px;background:#f9b44b;color:#24384c;font-size:12px;vertical-align:middle}.burn-hero-icon{font-size:42px;background:#ffffff16;padding:13px;border-radius:16px}
#burnDashboard .burn-panel{background:white;border-radius:14px;border:1px solid #e5ebf2;padding:16px;box-shadow:0 4px 15px #0d355009}#burnDashboard .burn-filters{display:flex;align-items:end;flex-wrap:wrap;gap:12px}#burnDashboard .burn-filters label,#burnDashboard .burn-select-label{font-size:12px;font-weight:700;color:#526679;display:flex;flex-direction:column;gap:5px}#burnDashboard .form-select,#burnDashboard .form-control{min-width:145px;border-radius:8px;font-size:13px;min-height:37px}#burnDashboard .burn-btn{border-radius:8px;min-height:37px;padding:0 13px;font-weight:700;border:1px solid #cedae5;background:#fff;color:#1b4868;cursor:pointer}#burnDashboard .burn-btn.primary{background:#13618d;border-color:#13618d;color:#fff}#burnDashboard .burn-btn.success{background:#168453;border-color:#168453;color:white}#burnDashboard .burn-btn:disabled{opacity:.45;cursor:not-allowed}.burn-alert{padding:10px;border-radius:8px;background:#fff5df;color:#815207}.burn-kpis{display:grid;grid-template-columns:repeat(4,minmax(0,1fr));gap:12px}.burn-kpi{border-radius:13px;padding:15px;background:#fff;border:1px solid #e3eaf1;border-top:4px solid #2d729f}.burn-kpi:nth-child(2){border-top-color:#e6a23c}.burn-kpi:nth-child(3){border-top-color:#22a789}.burn-kpi:nth-child(4){border-top-color:#885cc0}.burn-kpi-title{color:#567084;font-weight:700;font-size:12px}.burn-kpi-number{font-size:clamp(17px,2vw,25px);font-weight:850;color:#173a55;letter-spacing:-.5px}.burn-kpi-foot{color:#677e90;font-size:11px}.burn-section{display:flex;gap:12px;align-items:center;justify-content:space-between;flex-wrap:wrap;margin-bottom:12px}.burn-section h5{font-size:16px;font-weight:800;margin:0 0 4px;color:#183b55}.burn-section p{font-size:12px;color:#718195;margin:0}.burn-label{background:#e9f3fa;color:#1e5b83;font-size:12px;font-weight:800;border-radius:20px;padding:6px 11px}.burn-checks{display:flex;gap:9px;flex-wrap:wrap;margin:10px 0 15px}.burn-checks label{display:flex;align-items:center;gap:6px;border:1px solid #dae6ef;border-radius:8px;padding:7px 10px;background:#f9fcfe;cursor:pointer;font-weight:700;color:#405b73}.burn-checks input{accent-color:#13618d}.burn-scroll{max-height:66vh;overflow:auto;border:1px solid #dfebf2;border-radius:9px}.burn-table{border-collapse:separate;border-spacing:0;width:100%;min-width:max-content;font-size:12px}.burn-table th,.burn-table td{border-bottom:1px solid #e5edf3;border-right:1px solid #e9f0f5;padding:8px 10px;text-align:right;white-space:nowrap;font-variant-numeric:tabular-nums}.burn-table thead th{position:sticky;top:0;background:#1d5477;color:#fff;text-align:center;z-index:5;font-weight:750}.burn-table thead tr:nth-child(2) th{top:35px;background:#31708f}.burn-table th:first-child,.burn-table td:first-child{text-align:left;position:sticky;left:0;z-index:3;min-width:155px;max-width:260px;background:#fff}.burn-table thead th:first-child{background:#1d5477;z-index:7}.burn-table tbody tr:nth-child(even):not(.burn-total):not(.burn-regional) td{background:#f6f9fc}.burn-table tbody tr:hover:not(.burn-total):not(.burn-regional) td{background:#e9f5fb}.burn-table tbody tr.burn-regional td{background:#dceefa;color:#113e5b;font-weight:850}.burn-table tbody tr.burn-total td{background:#174869;color:#fff;font-weight:850}.burn-table td.burn-warn{color:#bf642e;font-weight:750}.burn-table td.burn-low{color:#8797a3}.burn-table td.burn-year25{background:#fff7ed!important}.burn-table td.burn-year26{background:#eef7ff!important}.burn-table tr.burn-regional td.burn-year25,.burn-table tr.burn-regional td.burn-year26{background:#dceefa!important}.burn-table tr.burn-total td.burn-year25,.burn-table tr.burn-total td.burn-year26{background:#174869!important}.burn-table .burn-th-25{background:#986b39!important}.burn-note{margin-top:10px;color:#6f8495;font-size:11px}.burn-chart-container{height:clamp(350px,42vw,550px);position:relative}.burn-chart-container canvas{width:100%!important;height:100%!important}@media(max-width:820px){.burn-kpis{grid-template-columns:repeat(2,1fr)}#burnDashboard .burn-panel{padding:12px}.burn-hero-icon{display:none}}@media(max-width:480px){.burn-kpis{grid-template-columns:1fr 1fr;gap:7px}.burn-kpi{padding:11px}.burn-kpi-number{font-size:17px}}

#burnDashboard .burn-hero h3{color:#fff!important;font-size:clamp(19px,2.2vw,27px);line-height:1.25}
#burnDashboard .burn-hero-second{margin-top:25px}
#burnDashboard .burn-toolbar{display:flex;flex-wrap:wrap;align-items:end;gap:12px;margin:0 0 12px}
#burnDashboard .burn-toolbar label{display:flex;flex-direction:column;gap:5px;font-size:12px;font-weight:700;color:#526679}
#burnDashboard .burn-toolbar input{min-width:230px}
#burnDashboard .burn-muted{font-size:12px;color:#607c91;margin-right:auto}
#burnDashboard .burn-all-scroll{max-height:69vh}
#burnDashboard .burn-full-table thead th{min-width:72px}
#burnDashboard .burn-full-table thead tr:nth-child(3) th{top:70px;background:#3c7a99}
#burnDashboard .burn-full-table thead tr:nth-child(2) th{top:35px}
#burnDashboard .burn-full-table thead th.burn-th-25{background:#986b39!important}
#burnDashboard .burn-full-table thead tr:nth-child(3) th.burn-th-25{background:#ab804e!important}
#burnDashboard .burn-full-table th.burn-id,#burnDashboard .burn-full-table td.burn-id{position:sticky;z-index:4;background:#fff;text-align:left}
#burnDashboard .burn-full-table thead th.burn-id{z-index:9;background:#1d5477}
#burnDashboard .burn-full-table .burn-id-0{left:0;min-width:175px;max-width:175px}
#burnDashboard .burn-full-table .burn-id-1{left:175px;min-width:170px;max-width:170px}
#burnDashboard .burn-full-table .burn-id-2{left:345px;min-width:85px;max-width:85px}
#burnDashboard .burn-full-table .burn-id-3{left:430px;min-width:165px;max-width:165px}
#burnDashboard .burn-full-table .burn-id-4{left:595px;min-width:105px;max-width:105px}
#burnDashboard .burn-full-table .burn-id-5{left:700px;min-width:150px;max-width:150px}
#burnDashboard .burn-full-table td.burn-id{background:#fff!important}
#burnDashboard .burn-full-table tr.burn-regional td.burn-id{background:#dceefa!important}
#burnDashboard .burn-full-table tr.burn-total td.burn-id{background:#174869!important}
#burnDashboard .burn-full-table .burn-total-col{font-weight:900;background:#d8eaf5!important;color:#143d58}
#burnDashboard .burn-full-table tr.burn-total .burn-total-col{background:#174869!important;color:#fff}
#burnDashboard .burn-full-table tr.burn-regional .burn-total-col{background:#dceefa!important}
#burnDashboard .burn-full-table td.burn-e{color:#b35216;font-weight:800}
@media(max-width:900px){#burnDashboard .burn-full-table .burn-id-1,#burnDashboard .burn-full-table .burn-id-2,#burnDashboard .burn-full-table .burn-id-3,#burnDashboard .burn-full-table .burn-id-4,#burnDashboard .burn-full-table .burn-id-5{position:static}#burnDashboard .burn-full-table .burn-id-0{min-width:155px;max-width:155px}}

#burnDashboard .burn-table tbody tr.burn-regional td.burn-year26,#burnDashboard .burn-table tbody tr.burn-regional td.burn-year25{background:#dceefa!important}
#burnDashboard .burn-table tbody tr.burn-total td.burn-year26,#burnDashboard .burn-table tbody tr.burn-total td.burn-year25{background:#174869!important;color:#fff!important}
/* Revisi: proporsi kolom, header tengah dan kontrol aktif */
#burnDashboard .burn-table{table-layout:auto;border-collapse:separate;border-spacing:0;font-size:12px;line-height:1.35}
#burnDashboard .burn-table th{vertical-align:middle;text-align:center!important;white-space:nowrap;font-size:11.5px;letter-spacing:.1px;padding:10px 11px}
#burnDashboard .burn-table td{padding:9px 11px;height:35px;white-space:nowrap}
#burnDashboard #burnSummary,#burnDashboard #burnDetails{width:100%;min-width:950px}
#burnDashboard #burnSummary th:nth-child(1),#burnDashboard #burnSummary td:nth-child(1),#burnDashboard #burnDetails th:nth-child(1),#burnDashboard #burnDetails td:nth-child(1){min-width:190px;width:190px;max-width:190px;text-align:left}
#burnDashboard #burnSummary th:nth-child(2),#burnDashboard #burnSummary td:nth-child(2),#burnDashboard #burnDetails th:nth-child(2),#burnDashboard #burnDetails td:nth-child(2){min-width:88px;width:88px;max-width:88px;text-align:center}
#burnDashboard #burnSummary th:nth-child(3),#burnDashboard #burnSummary td:nth-child(3),#burnDashboard #burnDetails th:nth-child(3),#burnDashboard #burnDetails td:nth-child(3){min-width:215px;width:215px;max-width:215px;text-align:left}
#burnDashboard #burnSummary thead th:first-child,#burnDashboard #burnDetails thead th:first-child{background:#1d5477}
#burnDashboard #burnSummary td:first-child,#burnDashboard #burnDetails td:first-child{min-width:190px;max-width:190px}
#burnDashboard .burn-table:not(.burn-full-table) td:nth-child(n+4){min-width:105px}
#burnDashboard .burn-full-table .burn-id-0{left:0;min-width:183px;max-width:183px;width:183px}
#burnDashboard .burn-full-table .burn-id-1{left:183px;min-width:165px;max-width:165px;width:165px;text-align:left}
#burnDashboard .burn-full-table .burn-id-2{left:348px;min-width:85px;max-width:85px;width:85px;text-align:center}
#burnDashboard .burn-full-table .burn-id-3{left:433px;min-width:190px;max-width:190px;width:190px}
#burnDashboard .burn-full-table .burn-id-4{left:623px;min-width:95px;max-width:95px;width:95px}
#burnDashboard .burn-full-table thead th:not(.burn-id){min-width:92px}
#burnDashboard .burn-full-table td:not(.burn-id){min-width:92px}
#burnDashboard .burn-checks{gap:8px}
#burnDashboard .burn-checks .burn-metric-option{user-select:none;gap:8px;padding:9px 13px;min-height:38px;background:#fff;border:1.5px solid #c9d9e5;box-shadow:0 1px 3px #0b3b5b0b;transition:background .15s,color .15s,border-color .15s}
#burnDashboard .burn-checks .burn-metric-option input{display:inline-block!important;appearance:auto!important;position:static!important;opacity:1!important;width:16px;height:16px;margin:0;visibility:visible!important;accent-color:#176b96;cursor:pointer;flex-shrink:0}
#burnDashboard .burn-checks .burn-metric-option.is-active{background:#e7f4fc;color:#124f78;border-color:#3589ba}
#burnDashboard .burn-checks .burn-metric-option:hover{border-color:#3589ba}
#burnDashboard #burnSelectedInfo{margin-top:-7px;margin-bottom:13px;font-size:11px}
#burnDashboard .burn-chart-container{height:clamp(440px,45vw,630px);background:linear-gradient(180deg,#ffffff,#f9fcff);border:1px solid #eaf0f6;border-radius:12px;padding:12px}
#burnDashboard .burn-panel{margin-bottom:16px}
@media(max-width:900px){#burnDashboard .burn-full-table .burn-id-1,#burnDashboard .burn-full-table .burn-id-2,#burnDashboard .burn-full-table .burn-id-3,#burnDashboard .burn-full-table .burn-id-4{position:static!important}#burnDashboard .burn-full-table .burn-id-0{min-width:150px;max-width:150px}}
#burnDashboard .burn-section-actions{display:flex;align-items:center;gap:10px;flex-wrap:wrap}
#burnDashboard .burn-png-btn{border-color:#a6cce5;background:#eef7ff;color:#125a88}
#burnDashboard .burn-png-btn:hover:not(:disabled){background:#d9efff}
#burnDashboard .burn-toolbar{flex-wrap:wrap}
#burnDashboard .burn-toolbar #burnAllCount{margin-right:auto}
#burnDashboard .burn-ab-hero{background:linear-gradient(115deg,#123d41,#158075)}
#burnDashboard .burn-ab-zone{margin-top:24px;margin-bottom:22px}
#burnDashboard .burn-ab-zone .burn-badge{background:#b7edcf;color:#10563e}
#burnDashboard .burn-ab-zone .burn-kpi{border-top-color:#1d9676}
#burnDashboard .burn-ab-zone .burn-kpi:nth-child(2){border-top-color:#3b9fb8}
#burnDashboard .burn-ab-zone .burn-kpi:nth-child(3){border-top-color:#e3a442}
#burnDashboard .burn-ab-zone .burn-kpi:nth-child(4){border-top-color:#758dd8}
#burnDashboard .burn-composition-container{height:clamp(350px,36vw,505px)}
#burnDashboard #burnCompositionKebun{min-width:230px;max-width:350px}
#burnDashboard .burn-section-actions{display:flex;align-items:end;gap:10px;flex-wrap:wrap}
/* Revisi komparasi Mutu E: kolom dapat di-scroll dan ekspor mengikuti header yang terlihat */
#burnDashboard #burnSummary,#burnDashboard #burnDetails{min-width:1150px}
#burnDashboard #burnSummary thead tr:nth-child(2) th,#burnDashboard #burnDetails thead tr:nth-child(2) th{white-space:normal;min-width:120px;max-width:165px;line-height:1.35}
#burnDashboard #burnSummary td:nth-child(n+4),#burnDashboard #burnDetails td:nth-child(n+4){text-align:right}
#burnDashboard .burn-group-switch{display:inline-flex;gap:5px;padding:5px;border:1px solid #c6dbea;border-radius:11px;background:#f1f6fb}
#burnDashboard .burn-group-switch button{border:0;background:transparent;color:#476980;border-radius:8px;padding:10px 15px;font-weight:800;cursor:pointer;white-space:nowrap}
#burnDashboard .burn-group-switch button.active{background:#19618d;color:#fff;box-shadow:0 2px 7px #1c557333}
#burnDashboard .burn-table tbody tr.burn-regional td:first-child{min-width:190px}
</style>
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/exceljs@4.4.0/dist/exceljs.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/2.5.1/jspdf.umd.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf-autotable/3.8.4/jspdf.plugin.autotable.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/chart.js@4.4.8/dist/chart.umd.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/html2canvas/1.4.1/html2canvas.min.js"></script>
<script>
(function(){
'use strict';
const root=document.getElementById('burnDashboard');if(!root||root.dataset.ready)return;root.dataset.ready='1';
const API='https://prodis.ksotebu.com/interfacedata/runProcedure?id=4';
const API_TAKMAR='https://prodis.ksotebu.com/interfacedata/runProcedure?id=89';
const metrics=[{id:'luas',label:'Luas',unit:'Ha',dec:3},{id:'tebu',label:'Tebu',unit:'Ton',dec:2},{id:'protas',label:'Produktivitas',unit:'Ton/Ha',dec:2},{id:'rendemen',label:'Rendemen',unit:'%',dec:2},{id:'hablur',label:'Hablur',unit:'Ton',dec:2},{id:'gula_ptr',label:'Gula Milik',unit:'Ton',dec:2},{id:'tetes_ptr',label:'Tetes Milik',unit:'Ton',dec:2}];
const additive=new Set(['luas','tebu','hablur','gula_ptr','tetes_ptr']);
let rows=[],chart=null,loading=false,loadedKey='',aborter=null;
let burnDataMode='1',takmarRows=[],takmarLoadedLevel='',takmarState='idle',takmarLoadPromise=null;
const $=id=>root.querySelector('#'+id);
const getYears=()=> $('burnYears').value==='both'?[2026,2025]:[Number($('burnYears').value)];
const selected=()=>Array.from(root.querySelectorAll('input[data-burn-metric]:checked')).map(x=>x.value);
const num=v=>v===null||v===undefined||v===''?0:Number(String(v).replace(/,/g,''))||0;
const nf=(v,d=2)=>Number(v).toLocaleString('en-US',{minimumFractionDigits:d,maximumFractionDigits:d});
const fmt=(v,d=2)=>v===null||v===undefined||!isFinite(Number(v))?'—':nf(v,d);
const esc=s=>String(s??'').replace(/[&<>"']/g,c=>({'&':'&amp;','<':'&lt;','>':'&gt;','"':'&quot;',"'":'&#39;'}[c]));
const isTotal=r=>String(r.regional||'').toUpperCase().trim()==='TOTAL KSO';
const isRegional=r=>/^JUMLAH\s/i.test(r.regional||'');
// Subtotal cluster dibangun dari baris detail: bukan dari subtotal regional (hindari hitung ganda).
let burnGroupMode='regional';
const groupName=r=>String(burnGroupMode==='cluster'?(r.cluster||'TANPA CLUSTER'):(r.regional||'TANPA REGIONAL')).trim();
const identityGroup=r=>isTotal(r)?'TOTAL KSO':isRegional(r)?r.regional:groupName(r);
// Urutan Plant sesuai urutan operasional KSO, bukan alfabetis nama Cluster.
// SK05 atau kode lain yang tidak disebut tetap disertakan (tidak dibuang).
const burnPlantSequence=['SK01','SK02','SK03','SK04','SK05','SK06','SK13','SK14','SK15','SK08','SK07','SK09','SK10','SK11','SK12'];
const burnPlantRank=p=>{const i=burnPlantSequence.indexOf(String(p||'').trim().toUpperCase());return i<0?999:i;};
const burnPlantOrder=(a,b)=>burnPlantRank(a.plant)-burnPlantRank(b.plant)||String(a.plant||'').localeCompare(String(b.plant||''),'id',{numeric:true})||String(a.kode_rayon||a.rayon||a.kebun||'').localeCompare(String(b.kode_rayon||b.rayon||b.kebun||''),'id',{numeric:true});
const burnRegionKey=r=>{
 const p=String(r.plant||'').trim().toUpperCase();
 if(['SK01','SK02','SK03','SK04','SK05','SK06','SK13','SK14','SK15'].includes(p))return '1';
 if(['SK08','SK07','SK09','SK10','SK11','SK12'].includes(p))return '2';
 const match=String(r.regional||'').match(/(?:WILAYAH|REGIONAL)\s*([12])/i);
 return match?match[1]:'LAINNYA';
};
const burnClusterKey=r=>{
 const p=String(r.plant||'').trim().toUpperCase();
 // Cluster dari master/API tetap dipakai. Mapping ini hanya urutan + pengaman apabila kosong.
 const inferred={SK01:'SUMATERA 1',SK02:'SUMATERA 1',SK03:'SUMATERA 2',SK04:'SUMATERA 2',SK05:'SUMATERA 2',SK06:'JAWA WILAYAH BARAT',SK13:'SULAWESI',SK14:'SULAWESI',SK15:'SULAWESI',SK08:'JATIM 1',SK07:'JATIM 2',SK09:'JATIM 3',SK10:'JATIM 4',SK11:'JATIM 4',SK12:'JATIM 4'};
 return String(r.cluster||inferred[p]||'TANPA CLUSTER').trim()||'TANPA CLUSTER';
};
function burnSubtotal(items,title,clusterName=''){
 const subtotal={regional:title,cluster:clusterName,plant:'',kebun:'',_burnItems:items};
 for(const y of [2026,2025])for(const k of ['A','B','C','D','E','F','G','total']){
  for(const m of additive){
   const values=items.map(r=>val(r,m,y,k)).filter(v=>v!==null&&Number.isFinite(v));
   subtotal[m+'_'+k+'_'+y]=values.length?values.reduce((a,b)=>a+b,0):null;
  }
  const area=subtotal['luas_'+k+'_'+y],ton=subtotal['tebu_'+k+'_'+y],hab=subtotal['hablur_'+k+'_'+y];
  subtotal['protas_'+k+'_'+y]=area>0?ton/area:null;
  subtotal['rendemen_'+k+'_'+y]=ton>0&&hab!==null?hab/ton*100:null;
 }
 return subtotal;
}
function groupedBurnRows(){
 const detail=rows.filter(isDetail).slice().sort(burnPlantOrder);
 const output=[],regionOrder=['1','2','LAINNYA'];
 for(const regionId of regionOrder){
  const regionItems=detail.filter(r=>burnRegionKey(r)===regionId);
  if(!regionItems.length)continue;
  if(burnGroupMode==='cluster'){
   // Urutkan cluster dari Plant pertama di cluster, bukan abjad nama cluster.
   const clusters=new Map();
   for(const r of regionItems){const name=burnClusterKey(r);if(!clusters.has(name))clusters.set(name,[]);clusters.get(name).push(r);}
   for(const [name,items] of [...clusters.entries()].sort((a,b)=>burnPlantRank(a[1][0].plant)-burnPlantRank(b[1][0].plant)||a[0].localeCompare(b[0],'id'))){
    output.push(...items);
    output.push(burnSubtotal(items,'JUMLAH CLUSTER '+name,name));
   }
  }else output.push(...regionItems);
  const regionTitle=regionId==='LAINNYA'?String(regionItems[0].regional||'LAINNYA'):'REGIONAL WILAYAH '+regionId;
  output.push(burnSubtotal(regionItems,'JUMLAH '+regionTitle));
 }
 // Pertahankan grand total resmi SP (jika tersedia), atau hitung dari detail.
 const grand=rows.find(isTotal);
 output.push(Object.assign({},grand||burnSubtotal(detail,'TOTAL KSO'),{_burnItems:detail}));
 return output;
}
function groupHeading(){return burnGroupMode==='cluster'?'Cluster':'Regional';}
function updateGrouping(){
 root.querySelectorAll('[data-burn-group]').forEach(btn=>{const active=btn.dataset.burnGroup===burnGroupMode;btn.classList.toggle('active',active);btn.setAttribute('aria-pressed',String(active));});
 renderAbSummary();renderAbDetails();renderSummary();renderDetails();
}

const isDetail=r=>!isTotal(r)&&!isRegional(r);
const label=r=>isTotal(r)?'TOTAL KSO':isRegional(r)?r.regional:(r.kebun||r.plant||'')+($('burnJenis').value==='RAYON'?' / '+(r.rayon||r.kode_rayon||''):'');
const val=(r,m,y,k='E')=>{let key=m+'_'+k+'_'+y;if(Object.prototype.hasOwnProperty.call(r,key))return r[key]===null?null:num(r[key]);if(m==='protas'){let a=val(r,'luas',y,k),t=val(r,'tebu',y,k);return a? t/a:null;}if(m==='rendemen'){let t=val(r,'tebu',y,k),h=val(r,'hablur',y,k);return t?h/t*100:null;}return null;};
const pct=(r,m,y)=>{if(!additive.has(m))return null;let a=val(r,m,y,'E'),b=val(r,m,y,'total');return b>0&&a!==null?a/b*100:null;};

// DATA 2: read-only SP ID 89. Key matching strictly by kebun/rayon code,
// never by displayed name. A missing match remains null (never silently zero).
const takmarKey=x=>String(x??'').trim().toUpperCase();
const takmarMetric={luas:'luas_poligon',tebu:'takmar_ton',hablur:'hablur',gula_ptr:'gula_milik',tetes_ptr:'tetes_milik'};
const takmarNumeric=v=>v===null||v===undefined||String(v).trim()===''?null:Number(String(v).replace(/,/g,''));
function takmarDetails(){return takmarRows.filter(x=>Number(x.row_type)===1);}
function takmarMatch(r){
 const code=takmarKey(r.plant||r.kode_kebun),rayon=takmarKey(r.kode_rayon);
 if(!code)return null;
 return takmarDetails().find(x=>takmarKey(x.kode_kebun)===code&&($('burnJenis').value!=='RAYON'||takmarKey(x.kode_rayon)===rayon))||null;
}
function takmarItems(r){return Array.isArray(r._burnItems)?r._burnItems:[r];}
function takmarValue(r,m,y){
 // ID 89 provides one snapshot only, not a 2025/2026 time series.
 if(Number(y)!==2026||takmarState!=='ready')return null;
 const matches=takmarItems(r).map(takmarMatch).filter(Boolean);
 if(!matches.length)return null;
 // Do not publish incomplete subtotals / grand totals as if complete.
 if(matches.length!==takmarItems(r).length)return null;
 const summed=id=>{
  const values=matches.map(x=>takmarNumeric(x[takmarMetric[id]]));
  return values.every(v=>v!==null&&Number.isFinite(v))?values.reduce((a,b)=>a+b,0):null;
 };
 if(additive.has(m))return summed(m);
 if(m==='protas'){const a=summed('luas'),b=summed('tebu');return a>0&&b!==null?b/a:null;}
 if(m==='rendemen'){const h=summed('hablur'),t=summed('tebu');return t>0&&h!==null?h/t*100:null;}
 return null;
}
const burnCompare=(r,m,y)=>burnDataMode==='2'?takmarValue(r,m,y):val(r,m,y,'total');
const burnPct=(r,m,y)=>{if(!additive.has(m))return null;const a=val(r,m,y,'E'),b=burnCompare(r,m,y);return b>0&&a!==null?a/b*100:null;};
const burnModeName=()=>burnDataMode==='2'?'DATA 2 · TAKSASI MARET':'DATA 1 · TOTAL REALISASI';
function renderDataMode(){
 root.querySelectorAll('[data-burn-data]').forEach(b=>{const active=b.dataset.burnData===burnDataMode;b.classList.toggle('active',active);b.setAttribute('aria-pressed',String(active));});
 $('burnTakmarStatus').textContent=burnDataMode==='1'?'DATA 1 aktif · Pembanding seluruh mutu realisasi':takmarState==='loading'?'Memuat SP ID 89 (Taksasi Maret)...':takmarState==='ready'?`DATA 2 aktif · ${takmarDetails().length} baris taksasi tersedia · Pembanding 2026 saja`:takmarState==='error'?'Gagal memuat SP ID 89; pembanding ditampilkan kosong, tidak diganti angka realisasi':'DATA 2 dipilih · Menyiapkan data taksasi';
}
async function loadTakmar(force=false){
 const level=$('burnJenis').value;
 if(!force&&takmarState==='ready'&&takmarLoadedLevel===level)return;
 if(takmarLoadPromise)return takmarLoadPromise;
 takmarState='loading';renderDataMode();renderSummary();renderDetails();renderKpis();
 takmarLoadPromise=(async()=>{
  try{
   const qs=new URLSearchParams({p_rekap:level,p_kode_kebun:'',p_kode_rayon:'',p_afdeling:''});
   const response=await fetch(API_TAKMAR+'&'+qs,{method:'GET',credentials:'same-origin',headers:{Accept:'application/json'}});
   if(!response.ok)throw new Error('HTTP '+response.status);
   const json=await response.json(),data=parseResponse(json);
   if(!data.some(x=>Number(x.row_type)===1))throw new Error('Tidak ada baris detail (row_type=1) pada SP 89');
   takmarRows=data;takmarLoadedLevel=level;takmarState='ready';
   const sample=rows.filter(isDetail),missing=sample.filter(x=>!takmarMatch(x));
   if(missing.length)show(`DATA 2: ${missing.length} dari ${sample.length} baris belum cocok kode kebun/rayon dengan SP 89. Nilai tanpa pasangan ditampilkan —.`,true);else show();
  }catch(err){takmarRows=[];takmarState='error';show('Tidak bisa memuat Taksasi Maret (SP 89): '+err.message,true);}
  finally{takmarLoadPromise=null;renderDataMode();renderSummary();renderDetails();renderKpis();}
 })();return takmarLoadPromise;
}

const show=(message='',bad=false)=>{const el=$('burnAlert');el.style.display=message?'block':'none';el.textContent=message;el.style.background=bad?'#fde8e7':'#fff5df';el.style.color=bad?'#982b2b':'#815207';};
const base=()=>{const t=rows.find(isTotal);if(t)return t;return null;};
const allCategories=['A','B','C','D','E','F','G','total'];
const allMetricOrder=[{id:'luas',label:'LUAS (Ha)',dec:3},{id:'tebu',label:'TEBU (Ton)',dec:2},{id:'protas',label:'PRODUKTIVITAS (Ton/Ha)',dec:2},{id:'rendemen',label:'RENDEMEN (%)',dec:2},{id:'hablur',label:'HABLUR (Ton)',dec:2},{id:'gula_ptr',label:'GULA MILIK (Ton)',dec:2},{id:'tetes_ptr',label:'TETES MILIK (Ton)',dec:2}];
function allIdentity(r){return [r.regional||'',r.cluster||'',r.plant||'',r.kebun||'',r.kode_rayon||'',r.rayon||''];}
function allColumns(){return $('burnJenis').value==='RAYON'?['Regional','Cluster','Plant','Kebun / Rayon','Kode Rayon']:['Regional','Cluster','Plant','Kebun / Rayon'];}
function identityValue(r,index){return [r.regional||'',r.cluster||'',r.plant||'',isDetail(r)?label(r):'',r.kode_rayon||''][index]||'';}
function allVisibleRows(){let q=String($('burnSearch').value||'').trim().toLowerCase();return q?rows.filter(r=>isTotal(r)||isRegional(r)||allIdentity(r).join(' ').toLowerCase().includes(q)):rows;}
function renderAll(){
 const years=getYears(),idCols=allColumns(),th=$('burnAllTable').tHead||$('burnAllTable').createTHead(),tb=$('burnAllTable').tBodies[0],visible=allVisibleRows();
 $('burnAllYearsLabel').textContent=years.join(' vs ');$('burnAllCount').textContent=`${visible.length} baris dari ${rows.length} data`;
 const ycols=allMetricOrder.length*allCategories.length;
 const identifiers=idCols.map((x,i)=>`<th class="burn-id burn-id-${i}" rowspan="3">${esc(x)}</th>`).join('');
 th.innerHTML=`<tr>${identifiers}${years.map(y=>`<th colspan="${ycols}" class="${y===2025?'burn-th-25':''}">${y}</th>`).join('')}</tr>`+
 `<tr>${years.map(y=>allMetricOrder.map(m=>`<th colspan="8" class="${y===2025?'burn-th-25':''}">${m.label}</th>`).join('')).join('')}</tr>`+
 `<tr>${years.map(y=>allMetricOrder.map(m=>allCategories.map(k=>`<th class="${y===2025?'burn-th-25':''} ${k==='total'?'burn-total-col':''}">${k==='total'?'TOTAL':k}</th>`).join('')).join('')).join('')}</tr>`;
 tb.innerHTML=visible.map(r=>{const cls=isTotal(r)?'burn-total':isRegional(r)?'burn-regional':'';
 return `<tr class="${cls}">${idCols.map((name,i)=>{let value=identityValue(r,i);return `<td class="burn-id burn-id-${i}">${esc(value)}</td>`;}).join('')}${years.map(y=>allMetricOrder.map(m=>allCategories.map(k=>{let v=val(r,m.id,y,k);return `<td class="${y===2025?'burn-year25':'burn-year26'} ${k==='total'?'burn-total-col':''} ${k==='E'?'burn-e':''}">${fmt(v,m.dec)}</td>`}).join('')).join('')).join('')}</tr>`}).join('')||`<tr><td colspan="${idCols.length+years.length*ycols}">Data tidak ditemukan</td></tr>`;
 $('burnExportAll').disabled=!rows.length;
}
function allExcelRows(){const years=getYears(),head=allColumns();const output=[head.concat(years.flatMap(y=>allMetricOrder.flatMap(m=>allCategories.map(k=>`${y} · ${m.label} · ${k==='total'?'Total':k}`))))];
 rows.forEach(r=>{const identity=allColumns().map((_,i)=>identityValue(r,i));output.push(identity.concat(years.flatMap(y=>allMetricOrder.flatMap(m=>allCategories.map(k=>val(r,m.id,y,k))))));});return output;}
function exportAllExcel(){if(!rows.length)return;if(typeof XLSX==='undefined'){show('Library Excel belum termuat',true);return;}const book=XLSX.utils.book_new(),sheet=XLSX.utils.aoa_to_sheet(allExcelRows());sheet['!cols']=allExcelRows()[0].map((_,i)=>({wch:i<allColumns().length?20:14}));XLSX.utils.book_append_sheet(book,sheet,'Semua Mutu');XLSX.writeFile(book,'Produksi_Berdasarkan_Mutu_'+$('burnJenis').value+'_'+$('burnDate').value+'_'+$('burnYears').value+'.xlsx');}
function renderKpis(){const y=getYears()[0],r=base(),m=[['Luas Mutu E','luas','Ha'],['Tebu Mutu E','tebu','Ton'],['Kontribusi Luas','luas','%'],['Kontribusi Tebu','tebu','%']];$('burnKpis').innerHTML=m.map((x,i)=>{let p=i>1,v=r?(p?burnPct(r,x[1],y):val(r,x[1],y)):null;return `<div class="burn-kpi"><div class="burn-kpi-title">${x[0]} · ${y}</div><div class="burn-kpi-number">${fmt(v,p?1:(x[1]==='luas'?3:2))}${p&&v!==null?'%':''}</div><div class="burn-kpi-foot">${p?(burnDataMode==='2'?'Mutu E terhadap Taksasi Maret':'Mutu E terhadap semua mutu'):'Akumulasi KSO · '+x[2]}</div></div>`}).join('');}
function renderSummary(){
 const years=getYears(),thead=$('burnSummary').tHead||$('burnSummary').createTHead(),body=$('burnSummary').tBodies[0];
 $('burnSummaryLabel').textContent=years.join(' vs ');
 thead.innerHTML=`<tr><th rowspan="2">${esc(groupHeading())}</th><th rowspan="2">Plant</th><th rowspan="2">Kebun / Rayon</th>${years.map(y=>`<th colspan="6" class="${y===2025?'burn-th-25':''}">PERBANDINGAN TEBU TERBAKAR · ${y}</th>`).join('')}</tr><tr>${years.map(y=>['Luas Terbakar (Ha)',(burnDataMode==='2'?'Luas Takmar (Ha)':'Total Luas (Ha)'),'% Luas Terbakar','Tebu Terbakar (Ton)',(burnDataMode==='2'?'Tebu Takmar (Ton)':'Total Tebu (Ton)'),'% Tebu Terbakar'].map(t=>`<th class="${y===2025?'burn-th-25':''}">${t}</th>`).join('')).join('')}</tr>`;
 body.innerHTML=groupedBurnRows().map(r=>{
  const cls=isTotal(r)?'burn-total':isRegional(r)?'burn-regional':'';
  const id=`<td>${esc(identityGroup(r))}</td><td>${isDetail(r)?esc(r.plant):''}</td><td>${isDetail(r)?esc(label(r)):''}</td>`;
  const data=years.map(y=>[['luas','E',false],['luas','total',false],['luas',null,true],['tebu','E',false],['tebu','total',false],['tebu',null,true]].map(([m,k,percent])=>{
   const v=percent?burnPct(r,m,y):k==='total'?burnCompare(r,m,y):val(r,m,y,k);
   return `<td class="${y===2025?'burn-year25':'burn-year26'} ${percent&&v>=20?'burn-warn':''}">${fmt(v,percent?1:m==='luas'?3:2)}${percent&&v!==null?'%':''}</td>`;
  }).join('')).join('');
  return `<tr class="${cls}">${id}${data}</tr>`;
 }).join('')||'<tr><td colspan="15">Belum ada data</td></tr>';
}
function updateCheckStyles(){
 const ch=$('burnMetricChecks');
 ch.querySelectorAll('label').forEach(el=>{let box=el.querySelector('input');el.classList.toggle('is-active',!!box?.checked);el.setAttribute('aria-checked',box?.checked?'true':'false');});
 const chosen=metrics.filter(m=>selected().includes(m.id));
 $('burnSelectedInfo').textContent=chosen.length+' dari '+metrics.length+' indikator ditampilkan: '+chosen.map(m=>m.label).join(', ')+'. Klik untuk memilih/melepas indikator.';
}
function renderChecks(){
 const checks=$('burnMetricChecks');
 checks.innerHTML=metrics.map(m=>`<label class="burn-metric-option"><input type="checkbox" data-burn-metric value="${m.id}" ${['luas','tebu'].includes(m.id)?'checked':''}><span>${m.label}</span></label>`).join('');
 checks.addEventListener('change',e=>{
   if(!e.target.matches('input[data-burn-metric]'))return;
   if(!selected().length){e.target.checked=true;show('Minimal satu indikator harus dipilih.');}
   else show();
   updateCheckStyles();renderDetails();
 });
 updateCheckStyles();
}
function renderDetails(){
 const years=getYears(),chosen=metrics.filter(m=>selected().includes(m.id)),th=$('burnDetails').tHead||$('burnDetails').createTHead(),b=$('burnDetails').tBodies[0];
 // Indikator jumlah: Terbakar, Total Mutu, Persen. Indikator rasio: Terbakar dan Total Mutu saja.
 const cols=chosen.reduce((n,m)=>n+(additive.has(m.id)?3:2),0);
 th.innerHTML=`<tr><th rowspan="2">${esc(groupHeading())}</th><th rowspan="2">Plant</th><th rowspan="2">Kebun / Rayon</th>${years.map(y=>`<th colspan="${cols}" class="${y===2025?'burn-th-25':''}">MUTU E / TERBAKAR VS ${burnDataMode==='2'?'TAKSASI MARET':'TOTAL SEMUA MUTU'} · ${y}</th>`).join('')}</tr><tr>${years.map(y=>chosen.map(m=>{
  const nm=m.id==='protas'?'Produktivitas':m.label;
  return `<th class="${y===2025?'burn-th-25':''}">${nm} Terbakar (${m.unit})</th><th class="${y===2025?'burn-th-25':''}">${nm} ${burnDataMode==='2'?'Takmar':'Total Mutu'} (${m.unit})</th>${additive.has(m.id)?`<th class="${y===2025?'burn-th-25':''}">% Terbakar / Total</th>`:''}`;
 }).join('')).join('')}</tr>`;
 b.innerHTML=groupedBurnRows().map(r=>`<tr class="${isTotal(r)?'burn-total':isRegional(r)?'burn-regional':''}"><td>${esc(identityGroup(r))}</td><td>${isDetail(r)?esc(r.plant):''}</td><td>${isDetail(r)?esc(label(r)):''}</td>${years.map(y=>chosen.map(m=>{
  const a=val(r,m.id,y,'E'),t=burnCompare(r,m.id,y),p=burnPct(r,m.id,y),cl=y===2025?'burn-year25':'burn-year26';
  return `<td class="${cl}">${fmt(a,m.dec)}</td><td class="${cl}">${fmt(t,m.dec)}</td>${additive.has(m.id)?`<td class="${cl} ${p>=20?'burn-warn':''}">${fmt(p,1)}${p!==null?'%':''}</td>`:''}`;
 }).join('')).join('')}</tr>`).join('')||'<tr><td colspan="20">Belum ada data</td></tr>';
}
const burnValueLabels={
 id:'burnValueLabels',
 afterDatasetsDraw(chart){
  const {ctx,chartArea}=chart;
  ctx.save();ctx.textAlign='center';ctx.textBaseline='bottom';ctx.font='600 10px Inter, Arial, sans-serif';
  chart.data.datasets.forEach((dataset,di)=>{
   const meta=chart.getDatasetMeta(di);if(meta.hidden)return;
   meta.data.forEach((bar,i)=>{
    const v=dataset.data[i];if(v===null||v===undefined||!isFinite(Number(v))||Number(v)===0)return;
    const pctMode=['rendemen','luas_pct','tebu_pct'].includes($('burnChartMetric').value);
    const text=(Math.abs(Number(v))>=1000?nf(v,0):nf(v,pctMode?1:Math.abs(Number(v))>=100?0:2))+(pctMode?'%':'');
    const x=bar.x, y=Math.max(chartArea.top+12,bar.y-5);
    ctx.fillStyle='#254862';ctx.fillText(text,x,y);
   });
  });ctx.restore();
 }
};
function renderChart(){
 if(typeof Chart==='undefined'){show('Library Chart.js tidak termuat. Grafik tidak dapat ditampilkan.',true);return;}
 const m=$('burnChartMetric').value,years=getYears(),detail=rows.filter(isDetail),labels=detail.map(r=>label(r));
 const datasets=years.map(y=>({label:'Mutu E '+y,data:detail.map(r=>m.endsWith('_pct')?pct(r,m.replace('_pct',''),y):val(r,m,y)),backgroundColor:y===2026?'#257da9':'#eaa057',borderColor:y===2026?'#165d85':'#c17b32',borderWidth:1,borderRadius:6,borderSkipped:false,maxBarThickness:38,categoryPercentage:.72,barPercentage:.82}));
 if(chart)chart.destroy();
 chart=new Chart($('burnChart'),{
  type:'bar',data:{labels,datasets},plugins:[burnValueLabels],
  options:{responsive:true,maintainAspectRatio:false,animation:{duration:550},layout:{padding:{top:30,right:15,bottom:8,left:8}},interaction:{mode:'index',intersect:false},
   plugins:{legend:{position:'top',labels:{usePointStyle:true,pointStyle:'rectRounded',padding:22,font:{size:12,weight:'bold'},color:'#254862'}},tooltip:{backgroundColor:'#143a53',padding:12,cornerRadius:9,callbacks:{label:ctx=>`${ctx.dataset.label}: ${fmt(ctx.parsed.y,2)}${m.endsWith('_pct')||m==='rendemen'?'%':''}`}}},
   scales:{x:{grid:{display:false},ticks:{autoSkip:false,maxRotation:48,minRotation:25,font:{size:10},color:'#577086'}},y:{beginAtZero:true,grace:'18%',grid:{color:'#e3ebf2',drawTicks:false},border:{display:false},ticks:{padding:9,color:'#627c8e',callback:v=>nf(v,0)}}}
  }
 });
}

// ============================================================
// MONITORING MUTU A+B — satu dataset SP yang sama (tanpa API baru)
// ============================================================
let abChart=null;
const abVal=(r,m,y)=>{
 if(m==='protas'){const luas=abVal(r,'luas',y);return luas>0?abVal(r,'tebu',y)/luas:null;}
 if(m==='rendemen'){const tebu=abVal(r,'tebu',y);return tebu>0?abVal(r,'hablur',y)/tebu*100:null;}
 const a=val(r,m,y,'A'),b=val(r,m,y,'B');
 return a===null&&b===null?null:(a||0)+(b||0);
};
const abPct=(r,m,y)=>{if(!additive.has(m))return null;const a=abVal(r,m,y),total=val(r,m,y,'total');return total>0&&a!==null?a/total*100:null;};
const abSelected=()=>Array.from(root.querySelectorAll('input[data-ab-metric]:checked')).map(c=>c.value);
function renderAbKpis(){
 const y=getYears()[0],r=base(),spec=[['Luas Mutu A+B','luas','Ha'],['Tebu Mutu A+B','tebu','Ton'],['Kontribusi Luas A+B','luas','%'],['Kontribusi Tebu A+B','tebu','%']];
 $('burnAbKpis').innerHTML=spec.map((x,i)=>{const isP=i>=2;const v=r?(isP?abPct(r,x[1],y):abVal(r,x[1],y)):null;return `<div class="burn-kpi"><div class="burn-kpi-title">${x[0]} · ${y}</div><div class="burn-kpi-number">${fmt(v,isP?1:x[1]==='luas'?3:2)}${isP&&v!==null?'%':''}</div><div class="burn-kpi-foot">${isP?'A+B terhadap total seluruh mutu':'Akumulasi KSO · '+x[2]}</div></div>`}).join('');
}
function renderAbSummary(){
 const years=getYears(),t=$('burnAbSummary'),head=t.tHead||t.createTHead(),body=t.tBodies[0];
 $('burnAbSummaryLabel').textContent=years.join(' vs ');
 head.innerHTML=`<tr><th rowspan="2">${esc(groupHeading())}</th><th rowspan="2">Plant</th><th rowspan="2">Kebun / Rayon</th>${years.map(y=>`<th colspan="4" class="${y===2025?'burn-th-25':''}">MUTU A+B · ${y}</th>`).join('')}</tr><tr>${years.map(y=>['Luas (Ha)','% Luas / Total','Tebu (Ton)','% Tebu / Total'].map(v=>`<th class="${y===2025?'burn-th-25':''}">${v}</th>`).join('')).join('')}</tr>`;
 body.innerHTML=groupedBurnRows().map(r=>`<tr class="${isTotal(r)?'burn-total':isRegional(r)?'burn-regional':''}"><td>${esc(identityGroup(r))}</td><td>${isDetail(r)?esc(r.plant):''}</td><td>${isDetail(r)?esc(label(r)):''}</td>${years.map(y=>['luas','luas_pct','tebu','tebu_pct'].map(m=>{const percent=m.endsWith('_pct'),id=m.replace('_pct',''),v=percent?abPct(r,id,y):abVal(r,id,y);return `<td class="${y===2025?'burn-year25':'burn-year26'}">${fmt(v,percent?1:id==='luas'?3:2)}${percent&&v!==null?'%':''}</td>`}).join('')).join('')}</tr>`).join('')||'<tr><td colspan="20">Belum ada data</td></tr>';
}
function renderAbChecks(){
 const e=$('burnAbMetricChecks');e.innerHTML=metrics.map(m=>`<label class="burn-metric-option"><input type="checkbox" data-ab-metric value="${m.id}" ${['luas','tebu','protas','rendemen'].includes(m.id)?'checked':''}><span>${m.label}</span></label>`).join('');
 e.addEventListener('change',event=>{if(!event.target.matches('[data-ab-metric]'))return;if(!abSelected().length){event.target.checked=true;show('Minimal satu indikator harus dipilih.');}renderAbCheckStyles();renderAbDetails();});renderAbCheckStyles();
}
function renderAbCheckStyles(){const chosen=metrics.filter(m=>abSelected().includes(m.id));$('burnAbMetricChecks').querySelectorAll('label').forEach(l=>l.classList.toggle('is-active',l.querySelector('input').checked));$('burnAbSelectedInfo').textContent=chosen.length+' dari 7 indikator ditampilkan: '+chosen.map(m=>m.label).join(', ');}
function renderAbDetails(){
 const years=getYears(),chosen=metrics.filter(m=>abSelected().includes(m.id)),t=$('burnAbDetails'),head=t.tHead||t.createTHead(),body=t.tBodies[0],span=chosen.reduce((n,m)=>n+(additive.has(m.id)?2:1),0);
 head.innerHTML=`<tr><th rowspan="2">${esc(groupHeading())}</th><th rowspan="2">Plant</th><th rowspan="2">Kebun / Rayon</th>${years.map(y=>`<th colspan="${span}" class="${y===2025?'burn-th-25':''}">MUTU A+B · ${y}</th>`).join('')}</tr><tr>${years.map(y=>chosen.map(m=>`<th class="${y===2025?'burn-th-25':''}">${m.label} (${m.unit})</th>${additive.has(m.id)?`<th class="${y===2025?'burn-th-25':''}">Kontribusi / Total (%)</th>`:''}`).join('')).join('')}</tr>`;
 body.innerHTML=groupedBurnRows().map(r=>`<tr class="${isTotal(r)?'burn-total':isRegional(r)?'burn-regional':''}"><td>${esc(identityGroup(r))}</td><td>${isDetail(r)?esc(r.plant):''}</td><td>${isDetail(r)?esc(label(r)):''}</td>${years.map(y=>chosen.map(m=>{const v=abVal(r,m.id,y),p=abPct(r,m.id,y);return `<td class="${y===2025?'burn-year25':'burn-year26'}">${fmt(v,m.dec)}</td>${additive.has(m.id)?`<td class="${y===2025?'burn-year25':'burn-year26'}">${fmt(p,1)}${p!==null?'%':''}</td>`:''}`}).join('')).join('')}</tr>`).join('')||'<tr><td colspan="20">Belum ada data</td></tr>';
}
function renderAbChart(){
 if(typeof Chart==='undefined')return;
 const m=$('burnAbChartMetric').value,years=getYears(),detail=rows.filter(isDetail),isPercent=m.endsWith('_pct')||m==='rendemen';
 const sets=years.map(y=>({label:'Mutu A+B '+y,data:detail.map(r=>m.endsWith('_pct')?abPct(r,m.replace('_pct',''),y):abVal(r,m,y)),backgroundColor:y===2026?'#148478':'#eaa057',borderColor:y===2026?'#0d6158':'#c17b32',borderWidth:1,borderRadius:6,maxBarThickness:38,categoryPercentage:.72,barPercentage:.82}));
 const numbers={id:'abValueLabels',afterDatasetsDraw(c){const {ctx,chartArea}=c;ctx.save();ctx.font='600 10px Arial';ctx.fillStyle='#22506a';ctx.textAlign='center';ctx.textBaseline='bottom';c.data.datasets.forEach((ds,di)=>{const meta=c.getDatasetMeta(di);if(meta.hidden)return;meta.data.forEach((bar,i)=>{const v=ds.data[i];if(v===null||v===undefined||!isFinite(v)||v===0)return;ctx.fillText(nf(v,isPercent?1:Math.abs(v)>=100?0:2)+(isPercent?'%':''),bar.x,Math.max(chartArea.top+12,bar.y-5));});});ctx.restore();}};
 if(abChart)abChart.destroy();abChart=new Chart($('burnAbChart'),{type:'bar',data:{labels:detail.map(label),datasets:sets},plugins:[numbers],options:{responsive:true,maintainAspectRatio:false,animation:{duration:500},layout:{padding:{top:30,right:12,bottom:8}},interaction:{mode:'index',intersect:false},plugins:{legend:{position:'top',labels:{usePointStyle:true,pointStyle:'rectRounded',color:'#22506a'}},tooltip:{callbacks:{label:ctx=>ctx.dataset.label+': '+fmt(ctx.parsed.y,2)+(isPercent?'%':'')}}},scales:{x:{grid:{display:false},ticks:{autoSkip:false,maxRotation:45,minRotation:22,font:{size:10}}},y:{beginAtZero:true,grace:'18%',grid:{color:'#e5ecf2'},ticks:{callback:v=>nf(v,0)}}}}});
}
async function exportAbChartHD(){
 if(!abChart)return;
 const btn=$('burnAbPngChart'),old=btn.textContent;btn.disabled=true;btn.textContent='Menyiapkan PNG...';
 try{const source=$('burnAbChart'),scale=3,c=document.createElement('canvas');c.width=source.width*scale;c.height=source.height*scale;const ctx=c.getContext('2d');ctx.fillStyle='white';ctx.fillRect(0,0,c.width,c.height);ctx.drawImage(source,0,0,c.width,c.height);await new Promise((resolve,reject)=>c.toBlob(blob=>{if(!blob)return reject(new Error('PNG gagal dibuat'));const url=URL.createObjectURL(blob),a=document.createElement('a');a.href=url;a.download='Grafik_Mutu_AB_'+$('burnDate').value+'.png';document.body.append(a);a.click();a.remove();setTimeout(()=>URL.revokeObjectURL(url),4000);resolve();},'image/png'));}catch(err){show('Download grafik A+B gagal: '+err.message,true);}finally{btn.disabled=!rows.length;btn.textContent=old;}
}


// Komposisi Mutu A–G: persentase tonase masing-masing mutu terhadap TOTAL tonase kebun dan tahun yang sama.
let compositionChart=null;
function compositionCandidates(){return rows.filter(isDetail);}
function compositionKey(r){return String(r.plant||'')+'|'+String(r.kode_rayon||'')+'|'+String(r.rayon||'');}
function refreshCompositionOptions(){
 const select=$('burnCompositionKebun'),old=select.value,items=compositionCandidates();
 const opts=['<option value="">TOTAL KSO (semua kebun)</option>'];
 items.forEach(r=>opts.push('<option value="'+esc(compositionKey(r))+'">'+esc((r.plant||'')+' · '+label(r))+'</option>'));
 select.innerHTML=opts.join('');
 if(items.some(r=>compositionKey(r)===old))select.value=old;
}
function renderCompositionChart(){
 if(typeof Chart==='undefined')return;
 const key=$('burnCompositionKebun').value;
 const selectedRow=key?compositionCandidates().find(r=>compositionKey(r)===key):base();
 const years=getYears();
 const cats=['A','B','C','D','E','F','G'];
 const datasets=years.map(y=>{
   const total=selectedRow?val(selectedRow,'tebu',y,'total'):null;
   const data=cats.map(cat=>{
     if(!selectedRow||total===null||total<=0)return null;
     const n=val(selectedRow,'tebu',y,cat);
     return n===null?null:n/total*100;
   });
   return {label:'Mutu Tebu '+y,data,backgroundColor:y===2026?'#27a9f4':'#f5a000',borderColor:y===2026?'#158acb':'#cf8500',borderWidth:1,borderRadius:7,maxBarThickness:70,categoryPercentage:.76,barPercentage:.83};
 });
 const percentageLabels={id:'compositionPercentLabels',afterDatasetsDraw(c){
  const ctx=c.ctx,area=c.chartArea;ctx.save();ctx.textAlign='center';ctx.textBaseline='bottom';ctx.font='bold 12px Arial';
  c.data.datasets.forEach((ds,di)=>{const meta=c.getDatasetMeta(di);if(meta.hidden)return;meta.data.forEach((bar,i)=>{const value=ds.data[i];if(value===null||!Number.isFinite(value))return;ctx.fillStyle=di===0?'#126dcc':'#d44b11';ctx.fillText(value.toFixed(2)+'%',bar.x,Math.max(area.top+14,bar.y-7));});});ctx.restore();
 }};
 if(compositionChart)compositionChart.destroy();
 compositionChart=new Chart($('burnCompositionChart'),{type:'bar',data:{labels:cats,datasets},plugins:[percentageLabels],options:{responsive:true,maintainAspectRatio:false,animation:{duration:350},layout:{padding:{top:25,right:15,left:8,bottom:8}},interaction:{mode:'index',intersect:false},plugins:{legend:{position:'bottom',labels:{usePointStyle:true,pointStyle:'rectRounded',padding:20,font:{weight:'bold',size:12}}},tooltip:{callbacks:{label:c=>c.dataset.label+': '+(c.parsed.y===null?'Tidak ada data':c.parsed.y.toFixed(2)+'%')}}},scales:{x:{title:{display:true,text:'Mutu Tebu'},grid:{display:false},ticks:{font:{size:12}}},y:{beginAtZero:true,suggestedMax:100,title:{display:true,text:'Kontribusi tonase (%)'},grid:{color:'#e1e8ef'},ticks:{callback:v=>v+'%'},grace:'12%'}}}});
 const name=selectedRow?(key?label(selectedRow):'TOTAL KSO'):'Tidak ada data';
 $('burnCompositionNote').textContent='Wilayah: '+name+' · Tonase setiap mutu ÷ tonase total (A–G) pada masing-masing tahun × 100. Tahun mengikuti filter di atas.';
}
async function exportCompositionPNG(){
 if(!compositionChart)return;
 const btn=$('burnCompositionPng'),old=btn.textContent;btn.disabled=true;btn.textContent='Menyiapkan PNG...';
 try{
   const original=$('burnCompositionChart'),scale=Math.min(3,6500/Math.max(original.width,original.height));
   const title='KOMPOSISI MUTU TEBU 2026 VS 2025',subtitle=$('burnCompositionNote').textContent;
   const canvas=document.createElement('canvas');canvas.width=Math.round(original.width*scale);canvas.height=Math.round((original.height+108)*scale);
   const c=canvas.getContext('2d');c.fillStyle='#ffffff';c.fillRect(0,0,canvas.width,canvas.height);
   c.fillStyle='#153b59';c.font='bold '+Math.round(23*scale)+'px Arial';c.fillText(title,25*scale,37*scale);
   c.font=Math.round(11*scale)+'px Arial';c.fillStyle='#557187';c.fillText(subtitle.slice(0,160),25*scale,64*scale);
   c.drawImage(original,0,0,original.width,original.height,0,85*scale,original.width*scale,original.height*scale);
   await new Promise((resolve,reject)=>canvas.toBlob(blob=>{if(!blob)return reject(new Error('Gambar gagal dibuat'));const url=URL.createObjectURL(blob),link=document.createElement('a');link.href=url;link.download='Komposisi_Mutu_Per_Kebun_'+$('burnDate').value+'.png';document.body.appendChild(link);link.click();link.remove();setTimeout(()=>URL.revokeObjectURL(url),15000);resolve();},'image/png'));
 }catch(err){show('Download PNG komposisi gagal: '+err.message,true)}finally{btn.disabled=!rows.length;btn.textContent=old;}
}

function render(){renderDataMode();renderAll();renderAbKpis();renderAbSummary();renderAbDetails();renderAbChart();refreshCompositionOptions();renderCompositionChart();renderKpis();renderSummary();renderDetails();renderChart();const ready=rows.length>0;['burnExportXlsx','burnExportPdf','burnExportPng','burnPngAll','burnPngSummary','burnPngDetails','burnExcelSummary','burnExcelDetails','burnAbExcelSummary','burnAbExcelDetails','burnPngChart','burnAbPngSummary','burnAbPngDetails','burnAbPngChart','burnCompositionPng'].forEach(id=>$(id).disabled=!ready);}
function parseResponse(resp){if(Array.isArray(resp))return resp;for(const candidate of [resp?.data,resp?.results,resp?.result,resp?.rows,resp?.data?.data,resp?.data?.rows,resp?.data?.result])if(Array.isArray(candidate))return candidate;throw new Error(resp?.message||'Format respons API tidak dikenal. Periksa struktur JSON.');}
async function load(){if(loading)return;const date=$('burnDate').value;if(!date){show('Tanggal wajib diisi',true);return;}if(aborter)aborter.abort();aborter=new AbortController();loading=true;$('burnReload').disabled=true;$('burnReload').textContent='Memuat...';show('Sedang mengambil data');try{const params=new URLSearchParams({p_jenis_filter:$('burnJenis').value,p_tanggal:date});const resp=await fetch(API+'&'+params.toString(),{method:'GET',credentials:'same-origin',signal:aborter.signal,headers:{'Accept':'application/json'}});if(!resp.ok)throw new Error('HTTP '+resp.status);const body=await resp.json();rows=parseResponse(body);loadedKey=$('burnJenis').value+'|'+date;render();if(burnDataMode==='2')await loadTakmar(takmarLoadedLevel!==$('burnJenis').value);show(rows.length?'':'Tidak ada data untuk filter ini.');}catch(e){rows=[];render();show('Gagal mengambil data: '+e.message,true);}finally{loading=false;$('burnReload').disabled=false;$('burnReload').textContent='⟳ Muat Data';}}
function dataRows(){
 const years=getYears(),chosen=metrics.filter(m=>selected().includes(m.id));
 let header=['Regional','Cluster','Plant','Kebun'];
 if($('burnJenis').value==='RAYON')header.push('Kode Rayon','Rayon');
 years.forEach(y=>chosen.forEach(m=>{
  header.push(`${y} · ${m.label} Terbakar (${m.unit})`,`${y} · ${m.label} ${burnDataMode==='2'?'Takmar':'Total Semua Mutu'} (${m.unit})`);
  if(additive.has(m.id))header.push(`${y} · ${m.label} % Terbakar / Total`);
 }));
 const output=[header];
 groupedBurnRows().forEach(r=>{
  let a=[identityGroup(r),r.cluster||'',r.plant||'',r.kebun||''];
  if($('burnJenis').value==='RAYON')a.push(r.kode_rayon||'',r.rayon||'');
  years.forEach(y=>chosen.forEach(m=>{
   a.push(val(r,m.id,y,'E'),burnCompare(r,m.id,y));
   if(additive.has(m.id))a.push(burnPct(r,m.id,y));
  }));
  output.push(a);
 });
 return output;
}
function exportExcel(){
 if(!rows.length)return;
 if(typeof XLSX==='undefined'){show('Library Excel tidak termuat',true);return;}
 const wb=XLSX.utils.book_new(),detail=dataRows(),ws=XLSX.utils.aoa_to_sheet(detail),allWS=XLSX.utils.aoa_to_sheet(allExcelRows());
 XLSX.utils.book_append_sheet(wb,allWS,'Semua Mutu');
 ws['!cols']=detail[0].map((x,i)=>({wch:i<4?24:25}));
 XLSX.utils.book_append_sheet(wb,ws,'Detail Mutu E');
 const summary=[['Nama','Tahun','Luas Terbakar (Ha)','Total Luas (Ha)','% Luas Terbakar','Tebu Terbakar (Ton)','Total Tebu (Ton)','% Tebu Terbakar']];
 groupedBurnRows().forEach(r=>getYears().forEach(y=>summary.push([isDetail(r)?label(r):identityGroup(r),y,val(r,'luas',y,'E'),burnCompare(r,'luas',y),burnPct(r,'luas',y),val(r,'tebu',y,'E'),burnCompare(r,'tebu',y),burnPct(r,'tebu',y)])));
 const sh=XLSX.utils.aoa_to_sheet(summary);sh['!cols']=summary[0].map((_,i)=>({wch:i===0?28:22}));
 XLSX.utils.book_append_sheet(wb,sh,'Ringkasan Terbakar');
 XLSX.writeFile(wb,fileName('xlsx'));
}

// Excel terformat dengan ExcelJS: angka asli, judul/metadata, header bertingkat,
// subtotal regional, TOTAL KSO, freeze panes, filter dan page setup.
async function exportBurnStyledExcel(mode){
 if(!rows.length)return;
 if(typeof ExcelJS==='undefined'){show('Library ExcelJS tidak termuat. Periksa koneksi internet/CDN.',true);return;}
 const summary=mode.endsWith('summary'),isAB=mode.startsWith('ab');
 const takMode=!isAB&&burnDataMode==='2';
 const btn=$(isAB?(summary?'burnAbExcelSummary':'burnAbExcelDetails'):(summary?'burnExcelSummary':'burnExcelDetails')),original=btn.textContent;
 btn.disabled=true;btn.textContent='⏳ Membuat Excel...';
 try{
  const wb=new ExcelJS.Workbook();
  wb.creator='PRODIS KSO';wb.subject='Monitoring Tebu Terbakar Mutu E';
  wb.created=new Date();
  const ws=wb.addWorksheet(isAB?(summary?'Ringkasan AB':'Detail Mutu AB'):(summary?'Ringkasan Terbakar':'Detail Mutu E'),{
   views:[{state:'frozen',xSplit:3,ySplit:7,activeCell:'D8'}],
   pageSetup:{paperSize:8,orientation:'landscape',fitToPage:true,fitToWidth:1,fitToHeight:0,
    margins:{left:0.25,right:0.25,top:0.45,bottom:0.45,header:0.2,footer:0.2}}
  });
  const years=getYears(),chosen=metrics.filter(m=>(isAB?abSelected():selected()).includes(m.id));
  const groups=[];
  for(const y of years){
   const cols=[];
   if(summary){
    for(const m of ['luas','tebu']){
     const unit=m==='luas'?'Ha':'Ton',name=m==='luas'?'Luas':'Tebu';
     cols.push({name:`${name} ${isAB?'Mutu A+B':'Terbakar'} (${unit})`,type:'metric',m,k:'E',dec:m==='luas'?3:2});
     cols.push({name:`${takMode?name+' Takmar':'Total '+name} (${unit})`,type:'metric',m,k:'total',dec:m==='luas'?3:2});
     cols.push({name:`% ${name} ${isAB?'A+B':'Terbakar'}`,type:'percent',m,dec:1});
    }
   }else{
    for(const m of chosen){
     const name=m.id==='protas'?'Produktivitas':m.label;
     cols.push({name:`${name} ${isAB?'Mutu A+B':'Terbakar'} (${m.unit})`,type:'metric',m:m.id,k:'E',dec:m.dec});
     cols.push({name:`${name} ${takMode?'Takmar':'Total Mutu'} (${m.unit})`,type:'metric',m:m.id,k:'total',dec:m.dec});
     if(additive.has(m.id))cols.push({name:`% ${name} ${isAB?'A+B':'Terbakar'}`,type:'percent',m:m.id,dec:1});
    }
   }
   groups.push({year:y,cols});
  }
  const count=3+groups.reduce((a,g)=>a+g.cols.length,0);
  const blue='173F5F',midBlue='23658B',teal='287D9B',white='FFFFFF',pale='EAF3F9';
  function fill(cell,color){cell.fill={type:'pattern',pattern:'solid',fgColor:{argb:'FF'+color}};}
  function edge(cell){cell.border={bottom:{style:'hair',color:{argb:'FFD5E2ED'}},right:{style:'hair',color:{argb:'FFE2EAF2'}}};}
  function format(cell,dec,percent=false){cell.numFmt=percent?'0.0"%"':dec===3?'#,##0.000':dec===1?'#,##0.0':'#,##0.00';}
  function mergedLine(row,text,color,fontSize=11){
   ws.mergeCells(row,1,row,count);const cell=ws.getCell(row,1);
   cell.value=text;fill(cell,color);cell.font={name:'Aptos',size:fontSize,bold:row===1,color:{argb:'FFFFFFFF'}};
   cell.alignment={vertical:'middle',horizontal:'left',indent:1};
  }
  mergedLine(1,isAB?(summary?'RINGKASAN MUTU A+B':'DETAIL KINERJA MUTU A+B'):(summary?'RINGKASAN MONITORING TEBU TERBAKAR':'DETAIL KINERJA MUTU E / TEBU TERBAKAR'),blue,16);ws.getRow(1).height=37;
  mergedLine(2,'PRODIS KSO  |  PERBANDINGAN '+(isAB?'MUTU A+B':'MUTU E')+' TERHADAP TOTAL SEMUA MUTU A–G',midBlue,11);ws.getRow(2).height=25;
  ws.mergeCells(3,1,3,count);
  ws.getCell(3,1).value=`Sumber: ${isAB?'REALISASI':burnModeName()}     •     Pengelompokan: ${groupHeading()}     •     Level: ${$('burnJenis').value}     •     Tanggal s.d.: ${$('burnDate').value}     •     Tahun: ${years.join(' & ')}     •     Jumlah data: ${rows.filter(isDetail).length}`;
  ws.getCell(3,1).font={name:'Aptos',size:11,color:{argb:'FF35536B'}};
  ws.getCell(3,1).alignment={vertical:'middle',indent:1};fill(ws.getCell(3,1),'E9F3FA');ws.getRow(3).height=24;
  ws.mergeCells(4,1,4,count);
  ws.getCell(4,1).value=takMode?'DATA 2: Pembanding adalah snapshot SP 89, berlaku untuk 2026 saja; data 2025 tidak tersedia. Tanda kosong berarti tidak ada pasangan/taksasi.':'Catatan: Persentase = nilai mutu terpilih / nilai total semua mutu × 100. Produktivitas dan rendemen bukan penjumlahan.';
  ws.getCell(4,1).font={name:'Aptos',size:10,italic:true,color:{argb:'FF697F90'}};
  ws.getCell(4,1).alignment={vertical:'middle',indent:1};ws.getRow(4).height=22;
  ws.getRow(5).height=11;
  [groupHeading(),'Plant','Kebun / Rayon'].forEach((label,i)=>{
   ws.mergeCells(6,i+1,7,i+1);const c=ws.getCell(6,i+1);c.value=label;fill(c,blue);
   c.font={bold:true,name:'Aptos',color:{argb:'FFFFFFFF'},size:11};c.alignment={horizontal:'center',vertical:'middle',wrapText:true};
  });
  let pos=4;
  for(const group of groups){
   const first=pos,last=pos+group.cols.length-1;
   ws.mergeCells(6,first,6,last);
   const c=ws.getCell(6,first);c.value=`${isAB?'MUTU A+B':'MUTU E / TERBAKAR'} VS ${takMode?'TAKSASI MARET':'TOTAL MUTU'}  ·  ${group.year}`;
   fill(c,group.year===2025?'986B39':midBlue);c.font={bold:true,name:'Aptos',color:{argb:'FFFFFFFF'},size:11};
   c.alignment={vertical:'middle',horizontal:'center'};
   for(const col of group.cols){
    const h=ws.getCell(7,pos);h.value=col.name;fill(h,group.year===2025?'AA8252':teal);
    h.font={bold:true,name:'Aptos',size:10,color:{argb:'FFFFFFFF'}};
    h.alignment={horizontal:'center',vertical:'middle',wrapText:true};
    ws.getColumn(pos).width=col.type==='percent'?19:23;
    pos++;
   }
  }
  ws.getColumn(1).width=28;ws.getColumn(2).width=12;ws.getColumn(3).width=31;
  ws.getRow(6).height=29;ws.getRow(7).height=47;
  groupedBurnRows().forEach((r,ri)=>{
   const rn=ri+8,row=ws.getRow(rn),regional=isRegional(r),total=isTotal(r),special=regional||total;
   row.height=special?26:23;
   const ids=[identityGroup(r),isDetail(r)?r.plant||'':'',isDetail(r)?label(r):''];
   ids.forEach((value,i)=>{const cell=row.getCell(i+1);cell.value=value;});
   let colIndex=4;
   for(const group of groups){
    for(const col of group.cols){
     const cell=row.getCell(colIndex++);
     const v=col.type==='percent'?(isAB?abPct(r,col.m,group.year):burnPct(r,col.m,group.year)):(isAB&&col.k==='E'?abVal(r,col.m,group.year):takMode&&col.k==='total'?burnCompare(r,col.m,group.year):val(r,col.m,group.year,col.k));
     cell.value=v===null||v===undefined||!Number.isFinite(v)?null:v;
     format(cell,col.dec,col.type==='percent');
     if(col.type==='percent'&&v!==null&&v>=20&&!special){cell.font={name:'Aptos',bold:true,color:{argb:'FFBE5A21'}};}
    }
   }
   for(let j=1;j<=count;j++){
    const cell=row.getCell(j);edge(cell);
    fill(cell,total?blue:regional?'DCEEF8':ri%2?'F5F9FC':'FFFFFF');
    if(special)cell.font={name:'Aptos',bold:true,color:{argb:total?'FFFFFFFF':'FF173F5F'},size:10};
    else if(!cell.font?.bold)cell.font={name:'Aptos',color:{argb:'FF253C50'},size:10};
    cell.alignment={vertical:'middle',horizontal:j<=3?(j===2?'center':'left'):'right',indent:j===1?1:0};
   }
   if(special){ws.mergeCells(rn,1,rn,3);ws.getCell(rn,1).value=total?'TOTAL KSO':r.regional||'SUBTOTAL';}
  });
  // Filter tersedia pada baris header; tidak menyertakan baris subtotal untuk menghindari kekeliruan penghitungan.
  // Freeze baris judul + header, serta 3 kolom identitas.
  ws.headerFooter.oddFooter='PRODIS KSO  •  Monitoring Mutu E                                    Halaman &P / &N';
  ws.printTitlesRow='1:7';
  const buffer=await wb.xlsx.writeBuffer();
  const blob=new Blob([buffer],{type:'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'});
  const url=URL.createObjectURL(blob),a=document.createElement('a');
  a.href=url;a.download=(isAB?(summary?'Ringkasan_Mutu_AB':'Detail_Mutu_AB'):(summary?'Ringkasan_Tebu_Terbakar':'Detail_Kinerja_Mutu_E'))+'_'+(isAB?'AB':burnDataMode==='2'?'DATA2_TAKMAR':'DATA1_REAL')+'_'+groupHeading()+'_'+$('burnJenis').value+'_'+$('burnDate').value+'_'+$('burnYears').value+'.xlsx';
  document.body.appendChild(a);a.click();a.remove();setTimeout(()=>URL.revokeObjectURL(url),12000);
 }catch(err){show('Gagal membuat Excel: '+(err?.message||err),true);console.error(err);}
 finally{btn.disabled=!rows.length;btn.textContent=original;}
}

function fileName(ext){return 'Monitoring_Tebu_Terbakar_'+$('burnJenis').value+'_'+$('burnDate').value+'_'+$('burnYears').value+'.'+ext;}
function exportPdf(){if(!rows.length)return;const C=window.jspdf?.jsPDF;if(!C){show('Library PDF tidak termuat',true);return;}let arr=dataRows(),doc=new C({orientation:'landscape',unit:'mm',format:'a3'});doc.setFont('helvetica','bold');doc.setFontSize(14);doc.text('MONITORING TEBU TERBAKAR - MUTU E',12,13);doc.setFontSize(9);doc.setFont('helvetica','normal');doc.text('Tanggal s.d. '+$('burnDate').value+' | '+$('burnJenis').value+' | '+getYears().join(', '),12,19);doc.autoTable({head:[arr[0]],body:arr.slice(1).map(r=>r.map(x=>typeof x==='number'?fmt(x,2):String(x??''))),startY:24,theme:'grid',styles:{fontSize:7,cellPadding:2,overflow:'linebreak'},headStyles:{fillColor:[22,76,108]},didParseCell:function(h){if(h.section==='body'){let r=rows[h.row.index];if(r&&isTotal(r))h.cell.styles.fillColor=[203,228,240];else if(r&&isRegional(r))h.cell.styles.fillColor=[230,243,251];}},margin:{left:8,right:8}});doc.save(fileName('pdf'));}
function exportPng(){if(!chart)return;let a=document.createElement('a');a.download=fileName('png');a.href=chart.toBase64Image('image/png',1);a.click();}
// Export PNG resolusi tinggi: render ulang seluruh tabel, bukan area scroll saja.
async function exportSectionPNG(tableId, title, slug){
 if(!rows.length)return;
 if(typeof window.html2canvas!=='function'){show('Library html2canvas gagal dimuat. Periksa koneksi CDN.',true);return;}
 const button=({burnAllTable:'burnPngAll',burnSummary:'burnPngSummary',burnDetails:'burnPngDetails',burnAbSummary:'burnAbPngSummary',burnAbDetails:'burnAbPngDetails'})[tableId];
 const btn=$(button),old=btn.textContent;btn.disabled=true;btn.textContent='Menyiapkan PNG...';
 let stage=null;
 try{
  const source=$(tableId),clone=source.cloneNode(true);
  stage=document.createElement('div');stage.className='burn-export-stage';
  stage.style.cssText='position:absolute;left:0;top:0;background:#fff;padding:30px;width:max-content;max-width:none;z-index:-1;font-family:Arial,sans-serif';
  const cap=document.createElement('div');
  cap.style.cssText='font-weight:800;color:#173f5b;font-size:26px;padding:0 0 10px;border-bottom:4px solid #2077a4;margin-bottom:13px';
  cap.textContent=title;
  const note=document.createElement('div');note.style.cssText='font-size:13px;color:#61778b;margin:0 0 18px';
  note.textContent='Prodis KSO | '+(tableId.startsWith('burnAb')?'MUTU A+B · REALISASI':tableId==='burnAllTable'?'SEMUA MUTU · REALISASI':burnModeName())+' | Rekap '+groupHeading()+' | '+$('burnJenis').value+' | s.d. '+$('burnDate').value+' | Tahun: '+getYears().join(' & ');
  stage.append(cap,note,clone);document.body.append(stage);
  const css=document.createElement('style');css.textContent=`
   .burn-export-stage table{border-collapse:collapse!important;width:max-content!important;min-width:100%!important;max-width:none!important;table-layout:auto!important;font-size:12px!important}
   .burn-export-stage th,.burn-export-stage td{position:static!important;left:auto!important;top:auto!important;min-width:80px!important;max-width:none!important;white-space:nowrap!important;border:1px solid #dce7f0!important;padding:8px 10px!important;height:auto!important;text-align:right}
   .burn-export-stage thead th{text-align:center!important;color:#fff!important;background:#1d5477!important;font-weight:700!important}
   .burn-export-stage thead tr:nth-child(2) th{background:#31708f!important}
   .burn-export-stage thead tr:nth-child(3) th{background:#3c7a99!important}
   .burn-export-stage thead th.burn-th-25{background:#986b39!important}
   .burn-export-stage td.burn-id,.burn-export-stage th.burn-id{position:static!important;left:auto!important;min-width:80px!important;max-width:none!important}
   .burn-export-stage tbody td.burn-id{text-align:left!important}
   .burn-export-stage #burnSummary tbody td:nth-child(2),.burn-export-stage #burnSummary tbody td:nth-child(3),
   .burn-export-stage #burnDetails tbody td:nth-child(2),.burn-export-stage #burnDetails tbody td:nth-child(3),
   .burn-export-stage #burnAbSummary tbody td:nth-child(2),.burn-export-stage #burnAbSummary tbody td:nth-child(3),
   .burn-export-stage #burnAbDetails tbody td:nth-child(2),.burn-export-stage #burnAbDetails tbody td:nth-child(3){text-align:left!important}
   .burn-export-stage tbody tr.burn-regional td{background:#dceefa!important;color:#113e5b!important;font-weight:800!important}
   .burn-export-stage tbody tr.burn-total td{background:#174869!important;color:#fff!important;font-weight:800!important}
   .burn-export-stage tbody tr:not(.burn-total):not(.burn-regional):nth-child(even) td:not(.burn-year26):not(.burn-year25){background:#f6f9fc!important}
   .burn-export-stage tbody tr:not(.burn-total):not(.burn-regional) td.burn-year26{background:#eef7ff!important}
   .burn-export-stage tbody tr:not(.burn-total):not(.burn-regional) td.burn-year25{background:#fff7ed!important}
   .burn-export-stage tbody td.burn-e{color:#b35216!important;font-weight:800!important}
   .burn-export-stage tbody td.burn-total-col{font-weight:800!important}
  `;stage.append(css);
  // Browser canvas max dimension; choose safe upscale for wide 2-year tables.
  const w=Math.ceil(stage.scrollWidth),h=Math.ceil(stage.scrollHeight);
  const scale=Math.max(1,Math.min(2.25,29000/w,29000/h,Math.sqrt(110000000/(w*h))));
  if(!Number.isFinite(scale)||scale<1)throw new Error('Tabel terlalu besar untuk gambar PNG tunggal. Pilih satu tahun atau lebih sedikit indikator.');
  const canvas=await window.html2canvas(stage,{backgroundColor:'#fff',scale,useCORS:true,logging:false,scrollX:0,scrollY:0,width:w,height:h,windowWidth:Math.max(innerWidth,w)});
  await new Promise((resolve,reject)=>canvas.toBlob(blob=>{
   if(!blob){reject(new Error('Tidak berhasil membentuk file PNG'));return;}
   const url=URL.createObjectURL(blob),a=document.createElement('a');a.href=url;
   a.download=slug+'_'+(tableId.startsWith('burnAb')?'REAL':burnDataMode==='2'?'DATA2_TAKMAR':'DATA1_REAL')+'_'+groupHeading()+'_'+$('burnJenis').value+'_'+$('burnDate').value+'_'+$('burnYears').value+'.png';
   document.body.append(a);a.click();a.remove();setTimeout(()=>URL.revokeObjectURL(url),3000);resolve();
  },'image/png'));
 }catch(err){show('Gagal ekspor PNG: '+err.message,true);}
 finally{if(stage)stage.remove();btn.textContent=old;btn.disabled=!rows.length;}
}
async function exportChartHD(){
 if(!chart)return;
 const btn=$('burnPngChart'),old=btn.textContent;btn.disabled=true;btn.textContent='Menyiapkan PNG...';
 let c;
 try{
  const src=$('burnChart'),ratio=3;
  c=document.createElement('canvas');c.width=Math.round(src.width*ratio/Math.max(chart.currentDevicePixelRatio||1,1));c.height=Math.round(src.height*ratio/Math.max(chart.currentDevicePixelRatio||1,1))+170;
  const ctx=c.getContext('2d');ctx.fillStyle='#fff';ctx.fillRect(0,0,c.width,c.height);
  ctx.fillStyle='#183b55';ctx.font='bold 35px Arial';ctx.fillText('GRAFIK EVALUASI MUTU E',36,55);
  ctx.fillStyle='#637c90';ctx.font='21px Arial';ctx.fillText('Indikator: '+$('burnChartMetric').selectedOptions[0].text+' | '+getYears().join(' vs ')+' | s.d. '+$('burnDate').value,36,94);
  ctx.drawImage(src,24,140,c.width-48,c.height-165);
  await new Promise((resolve,reject)=>c.toBlob(blob=>{if(!blob){reject(new Error('Gagal membuat PNG grafik'));return;}const url=URL.createObjectURL(blob),a=document.createElement('a');a.href=url;a.download='Grafik_Mutu_E_HD_'+$('burnDate').value+'_'+$('burnYears').value+'.png';document.body.append(a);a.click();a.remove();setTimeout(()=>URL.revokeObjectURL(url),3000);resolve();},'image/png'));
 }catch(e){show('Gagal export grafik: '+e.message,true);}
 finally{btn.disabled=!rows.length;btn.textContent=old;}
}
$('burnAbExcelSummary').addEventListener('click',()=>exportBurnStyledExcel('absummary'));
$('burnAbExcelDetails').addEventListener('click',()=>exportBurnStyledExcel('abdetail'));
$('burnDataSwitch').addEventListener('click',async e=>{const b=e.target.closest('[data-burn-data]');if(!b)return;burnDataMode=b.dataset.burnData;renderDataMode();renderSummary();renderDetails();renderKpis();if(burnDataMode==='2')await loadTakmar();});
$('burnGroupSwitch').addEventListener('click',e=>{const btn=e.target.closest('[data-burn-group]');if(!btn)return;burnGroupMode=btn.dataset.burnGroup;updateGrouping();});
$('burnAbPngSummary').addEventListener('click',()=>exportSectionPNG('burnAbSummary','RINGKASAN MUTU A+B','Ringkasan_Mutu_AB'));
$('burnAbPngDetails').addEventListener('click',()=>exportSectionPNG('burnAbDetails','DETAIL KINERJA MUTU A+B','Detail_Mutu_AB'));
$('burnAbPngChart').addEventListener('click',exportAbChartHD);
$('burnAbChartMetric').addEventListener('change',renderAbChart);
$('burnCompositionKebun').addEventListener('change',renderCompositionChart);
$('burnCompositionPng').addEventListener('click',exportCompositionPNG);
$('burnPngAll').addEventListener('click',()=>exportSectionPNG('burnAllTable','REALISASI PRODUKSI BERDASARKAN MUTU','Tabel_Semua_Mutu'));
$('burnExcelSummary').addEventListener('click',()=>exportBurnStyledExcel('summary'));
$('burnExcelDetails').addEventListener('click',()=>exportBurnStyledExcel('detail'));
$('burnPngSummary').addEventListener('click',()=>exportSectionPNG('burnSummary','RINGKASAN MONITORING TEBU TERBAKAR','Ringkasan_Tebu_Terbakar'));
$('burnPngDetails').addEventListener('click',()=>exportSectionPNG('burnDetails','DETAIL KINERJA MUTU E','Detail_Mutu_E'));
$('burnPngChart').addEventListener('click',exportChartHD);
$('burnForm').addEventListener('submit',e=>{e.preventDefault();load()});$('burnYears').addEventListener('change',render);$('burnChartMetric').addEventListener('change',renderChart);$('burnJenis').addEventListener('change',()=>{if(rows.length)show('Level rekap diubah. Klik Muat Data untuk mengambil data sesuai level baru.');});$('burnDate').addEventListener('change',()=>{if(rows.length)show('Tanggal diubah. Klik Muat Data untuk memperbarui data.');});$('burnSearch').addEventListener('input',renderAll);$('burnExportAll').addEventListener('click',exportAllExcel);$('burnExportXlsx').addEventListener('click',exportExcel);$('burnExportPdf').addEventListener('click',exportPdf);$('burnExportPng').addEventListener('click',exportPng);
renderChecks();renderAbChecks();render();load();
})();
</script>