{{-- PRODIS KSO • SP 82 • Cek Lahan ID (5 tabel). Replace seluruh Blade lama. --}}
<div id="cl82-app">
<style>
#cl82-app{--navy:#102c4c;--blue:#2563eb;--green:#087f5b;--red:#c92a2a;--line:#dce5ef;--muted:#64748b;color:#25364a;font-size:13px;width:100%;font-family:inherit}
#cl82-app *,#cl82-app *:before,#cl82-app *:after{box-sizing:border-box}
#cl82-app .shell{max-width:1700px;margin:auto;padding:15px}
#cl82-app .hero{background:linear-gradient(115deg,#102b49,#185583);border-radius:16px;padding:24px;color:white;display:flex;justify-content:space-between;align-items:center;flex-wrap:wrap;gap:12px;margin-bottom:17px}
#cl82-app .hero h2{font-size:24px;font-weight:800;color:white!important;margin:0 0 7px}
#cl82-app .hero p{margin:0;color:#dbeafe!important}
#cl82-app .pill{background:#ffffff22;border:1px solid #ffffff44;border-radius:30px;padding:9px 15px;color:white;font-weight:750}
#cl82-app .card{background:white;border:1px solid var(--line);border-radius:14px;margin-bottom:16px;overflow:hidden;box-shadow:0 3px 14px #17375808}
#cl82-app .card-head{padding:15px 19px;border-bottom:1px solid var(--line);display:flex;align-items:center;justify-content:space-between;flex-wrap:wrap;gap:10px}
#cl82-app .card-head h3{color:#173758;font-size:15px;margin:0;font-weight:800}
#cl82-app .sub{color:var(--muted);font-size:12px;margin-top:5px}
#cl82-app .card-body{padding:18px}
#cl82-app .input-grid{display:grid;grid-template-columns:minmax(0,1fr)280px;gap:17px}
#cl82-app label{display:block;font-weight:750;margin-bottom:8px}
#cl82-app textarea{width:100%;min-height:180px;background:#fbfdff;border:1.5px solid #cbd7e5;border-radius:10px;padding:13px 15px;resize:vertical;font:13px/1.7 Consolas,monospace;color:#172c45}
#cl82-app textarea:focus,#cl82-app input:focus,#cl82-app select:focus{outline:2px solid #93c5fd;outline-offset:0}
#cl82-app .hint{color:var(--muted);font-size:12px;line-height:1.65;margin-top:7px}
#cl82-app .info{padding:16px;background:#f1f6fc;border:1px solid #d9e7f7;border-radius:11px}
#cl82-app .info h4{margin:0 0 10px;color:#164571;font-size:14px}
#cl82-app .metric{display:flex;align-items:center;justify-content:space-between;padding:10px 0;border-bottom:1px dashed #ccdaea}
#cl82-app .metric strong{font-size:20px;color:#144d80}
#cl82-app .actions,#cl82-app .toolbar,#cl82-app .toolbar-actions{display:flex;align-items:center;flex-wrap:wrap;gap:9px}
#cl82-app .actions{margin-top:15px}
#cl82-app .toolbar{justify-content:space-between;margin-bottom:14px}
#cl82-app button{font-family:inherit}
#cl82-app .btn{border:1px solid #ced9e6;border-radius:9px;background:white;color:#23486c;padding:10px 15px;font-size:12px;font-weight:750;cursor:pointer;white-space:nowrap}
#cl82-app .btn:hover:not(:disabled){filter:brightness(.94)}
#cl82-app .btn:disabled{opacity:.55;cursor:not-allowed}
#cl82-app .btn-blue{background:#1762af;border-color:#1762af;color:white}
#cl82-app .btn-green{background:#087f5b;border-color:#087f5b;color:white}
#cl82-app .search,#cl82-app select{border:1px solid #cbd7e5;border-radius:9px;background:white;padding:10px 12px;font:12px inherit;color:#213c59;min-height:38px}
#cl82-app .search{width:min(100%,330px)}
#cl82-app .message{display:none;margin-top:12px;padding:12px 15px;border-radius:9px;line-height:1.6}
#cl82-app .message.show{display:block}
#cl82-app .message.error{background:#fff1f1;color:#9d2525;border:1px solid #fecaca}
#cl82-app .message.info{background:#eef6ff;color:#18518e;border:1px solid #bfdbfe}
#cl82-app .loading{display:none;align-items:center;gap:12px;background:#eff7ff;border:1px solid #cfe2f7;border-radius:10px;padding:14px;margin-top:12px}
#cl82-app .loading.show{display:flex}
#cl82-app .spinner{width:20px;height:20px;border:3px solid #c3daf4;border-top-color:#1762af;border-radius:50%;animation:cl82-spin .75s linear infinite}
@keyframes cl82-spin{to{transform:rotate(360deg)}}
#cl82-app .stats{display:grid;grid-template-columns:repeat(5,minmax(0,1fr));gap:12px;margin-bottom:15px}
#cl82-app .stat{position:relative;overflow:hidden;min-height:100px;text-align:left;cursor:pointer;background:white;border:1px solid #dae4ef;border-radius:12px;padding:16px}
#cl82-app .stat:before{content:"";position:absolute;left:0;top:0;bottom:0;width:5px;background:var(--stat-color,#2563eb)}
#cl82-app .stat.active{outline:2px solid #2563eb;outline-offset:1px}
#cl82-app .stat small{display:block;color:#64748b;line-height:1.4;font-weight:750;min-height:30px}
#cl82-app .stat strong{display:block;font-size:28px;margin-top:6px;color:var(--stat-color,#173a5f);font-variant-numeric:tabular-nums}
#cl82-app .ton-cards{display:grid;grid-template-columns:repeat(4,minmax(0,1fr));gap:12px;margin-bottom:16px}
#cl82-app .ton{border-radius:12px;background:#f2f7ff;border:1px solid #dbe7f5;padding:16px}
#cl82-app .ton small{display:block;color:#506782;font-weight:750}
#cl82-app .ton strong{font-size:25px;color:#173a5f;display:block;margin:7px 0 3px;font-variant-numeric:tabular-nums}
#cl82-app .ton span{font-size:11px;color:#64748b}
#cl82-app .table-wrap{border:1px solid var(--line);border-radius:10px;overflow:auto;max-height:640px}
#cl82-app table{border-collapse:separate;border-spacing:0;min-width:2200px;width:100%;font-size:12px}
#cl82-app th{position:sticky;top:0;background:#173c62;color:white!important;padding:12px 10px;text-align:center;white-space:nowrap;z-index:2;border-right:1px solid #ffffff22}
#cl82-app td{padding:10px;border-bottom:1px solid #e8eef5;white-space:nowrap;color:#334155;vertical-align:middle}
#cl82-app tbody tr:nth-child(even){background:#f8fafc}
#cl82-app tbody tr:hover{background:#edf5ff}
#cl82-app .id{font:800 12px Consolas,monospace;color:#16538c}
#cl82-app .num{text-align:right;font-variant-numeric:tabular-nums}
#cl82-app .badge{display:inline-flex;padding:5px 8px;border-radius:6px;border:1px solid transparent;font-size:10px;font-weight:800;white-space:nowrap}
#cl82-app .ok{color:#05734f;background:#d9f8e9;border-color:#a5e6c7}
#cl82-app .no{color:#b52626;background:#ffe9e9;border-color:#f8c4c4}
#cl82-app .warn{color:#965b00;background:#fff1c7;border-color:#f2d485}
#cl82-app .neutral{color:#48647e;background:#edf2f7;border-color:#dce5ee}
#cl82-app .dup{color:#a6530a;font-weight:800;background:#fff2df;padding:3px 7px;border-radius:5px}
#cl82-app .empty{padding:35px;text-align:center;color:#64748b;display:none}
#cl82-app .footer{border-top:1px solid var(--line);padding:14px 19px;font-size:11px;color:#64748b;display:flex;justify-content:space-between;gap:12px;flex-wrap:wrap}
#cl82-app .footnote{background:#f8fafc;border:1px solid #e2e8f0;border-radius:9px;padding:11px 13px;color:#51657b;line-height:1.6;margin-top:12px}
@media(max-width:1000px){#cl82-app .stats{grid-template-columns:repeat(3,minmax(0,1fr))}#cl82-app .ton-cards{grid-template-columns:repeat(2,minmax(0,1fr))}}
@media(max-width:700px){#cl82-app .shell{padding:8px}#cl82-app .input-grid{grid-template-columns:1fr}#cl82-app .stats{grid-template-columns:repeat(2,minmax(0,1fr))}#cl82-app .ton-cards{grid-template-columns:1fr}#cl82-app .card-body{padding:12px}#cl82-app .hero h2{font-size:20px}#cl82-app .search{width:100%}}
@media print{#cl82-app .hero,#cl82-app .input-card,#cl82-app .toolbar,#cl82-app .footer{display:none!important}#cl82-app .table-wrap{max-height:none;overflow:visible}#cl82-app table{min-width:0;font-size:8px}#cl82-app th{position:static}}
</style>
<div class="shell">
 <header class="hero"><div><h2>CEK LAHAN ID</h2><p>Validasi 5 sumber data: Master Petak, TX Takmar, Timbangan, Meja Tebu &amp; Prodis Console</p></div><div class="pill">PRODIS KSO &bull; SP #82</div></header>
 <section class="card input-card"><div class="card-head"><div><h3>Input Daftar Lahan ID</h3><div class="sub">Paste langsung dari Excel atau masukkan beberapa ID</div></div><span class="badge neutral">Multi Input</span></div>
 <div class="card-body"><div class="input-grid"><div><label for="cl82-input">Daftar Lahan ID</label><textarea id="cl82-input" spellcheck="false" placeholder="Contoh:&#10;24352972&#10;24352975"></textarea><div class="hint">Pemisah: Enter, koma, titik koma, atau tab. ID duplikat otomatis diabaikan.</div></div>
 <aside class="info"><h4>Ringkasan Input</h4><div class="metric"><span>Total input</span><strong id="cl82-in-total">0</strong></div><div class="metric"><span>Lahan ID unik</span><strong id="cl82-in-unique">0</strong></div><div class="metric"><span>Input duplikat</span><strong id="cl82-in-dup">0</strong></div><div class="hint">Hasil menampilkan status setiap sumber, tonase (ton), serta jumlah transaksi.</div></aside></div>
 <div class="actions"><button class="btn btn-blue" id="cl82-check" type="button">✓ Cek Lahan ID</button><button class="btn" id="cl82-clear" type="button">Hapus Input</button><button class="btn" id="cl82-reset" type="button">Reset Hasil</button></div><div class="message" id="cl82-alert" role="alert"></div><div class="loading" id="cl82-loading"><span class="spinner"></span><span>Sedang memeriksa 5 sumber data...</span></div></div></section>
 <div id="cl82-results" style="display:none">
 <div class="stats" id="cl82-stats">
  <button class="stat active" style="--stat-color:#2563eb" data-status="SEMUA"><small>TOTAL LAHAN ID</small><strong id="cl82-total">0</strong></button>
  <button class="stat" style="--stat-color:#087f5b" data-status="LENGKAP"><small>LENGKAP MASTER &amp; TAKMAR</small><strong id="cl82-complete">0</strong></button>
  <button class="stat" style="--stat-color:#b7791f" data-status="HANYA MASTER PETAK"><small>HANYA MASTER PETAK</small><strong id="cl82-master">0</strong></button>
  <button class="stat" style="--stat-color:#dd6b20" data-status="HANYA TX TAKMAR"><small>HANYA TX TAKMAR</small><strong id="cl82-takmar">0</strong></button>
  <button class="stat" style="--stat-color:#c92a2a" data-status="TIDAK DITEMUKAN"><small>TIDAK ADA DI MASTER &amp; TAKMAR</small><strong id="cl82-missing">0</strong></button>
 </div>
 <div class="ton-cards"><div class="ton"><small>TOTAL TEBU • TIMBANGAN</small><strong id="cl82-ton-timbang">0,000</strong><span>Ton | Netto Final</span></div><div class="ton"><small>TOTAL TEBU • MEJA TEBU</small><strong id="cl82-ton-meja">0,000</strong><span>Ton | Netto</span></div><div class="ton"><small>TOTAL TEBU • PRODIS CONSOLE</small><strong id="cl82-ton-console">0,000</strong><span>Ton | Netto Tebu</span></div><div class="ton"><small>TOTAL LUAS TEBANG • CONSOLE</small><strong id="cl82-luas-console">0,000</strong><span>Ha | Luas Tebang</span></div></div>
 <section class="card"><div class="card-head"><div><h3>Hasil Pengecekan Lahan ID</h3><div class="sub">Status 5 tabel, tonase per sumber, dan jumlah data pada masing-masing tabel</div></div><span class="badge neutral" id="cl82-active-label">Semua Status</span></div>
 <div class="card-body"><div class="toolbar"><input id="cl82-search" class="search" type="search" placeholder="Cari ID, kebun, rayon, status..."><div class="toolbar-actions"><select id="cl82-source-filter" aria-label="Filter keberadaan sumber"><option value="SEMUA">Semua Sumber</option><option value="master">Master Petak</option><option value="takmar">TX Takmar</option><option value="timbang">Data Timbangan</option><option value="meja">Data Meja Tebu</option><option value="console">Prodis Console</option></select><select id="cl82-presence-filter" aria-label="Filter status sumber"><option value="SEMUA">Semua Status Sumber</option><option value="ADA">ADA</option><option value="TIDAK ADA">TIDAK ADA</option></select><span id="cl82-visible-count" class="hint">0 data</span><button class="btn" id="cl82-copy-problems" type="button">Copy ID Bermasalah</button><button class="btn btn-green" id="cl82-download" type="button">Download Excel</button></div></div>
 <div class="table-wrap"><table><thead><tr><th rowspan="2">No</th><th rowspan="2">Lahan ID</th><th colspan="5">STATUS KEBERADAAN DATA</th><th rowspan="2">Status Master &amp; Takmar</th><th colspan="7">IDENTITAS PETAK</th><th colspan="4">REALISASI PRODUKSI</th><th colspan="5">JUMLAH DATA / TRANSAKSI</th></tr><tr><th>Master Petak</th><th>TX Takmar</th><th>Timbangan</th><th>Meja Tebu</th><th>Console</th><th>Kode Kebun</th><th>Nama Kebun</th><th>Kode Rayon</th><th>Nama Rayon</th><th>Afdeling</th><th>Deskripsi Petak</th><th>Luas Poligon (Ha)</th><th>Timbangan (Ton)</th><th>Meja Tebu (Ton)</th><th>Console (Ton)</th><th>Console Luas (Ha)</th><th>Master</th><th>Takmar</th><th>Timbangan</th><th>Meja Tebu</th><th>Console</th></tr></thead><tbody id="cl82-tbody"></tbody></table></div><div class="empty" id="cl82-empty">Tidak ada data sesuai filter atau pencarian.</div>
 <div class="footnote"><strong>Catatan:</strong> Status “Tidak Ditemukan” pada ringkasan utama berarti tidak ada di Master Petak dan TX Takmar. Data Timbangan, Meja Tebu, atau Console tetap dapat berstatus ADA dan memiliki tonase. Total tonase mengikuti seluruh periode data dari SP (tidak memakai filter tanggal).</div></div>
 <div class="footer"><div><span class="badge ok">ADA</span> <span class="badge no">TIDAK ADA</span> <span class="badge warn">Duplikat (&gt;1)</span></div><span>Sumber: master_petak • tx_takmar • data_timbangan • data_meja_tebu • data_prodis_console</span></div></section>
 </div>
</div>
<script>
(function(){
'use strict';
const root=document.getElementById('cl82-app');
if(!root||root.dataset.initialized==='1')return;
root.dataset.initialized='1';
const API_URL='https://prodis.ksotebu.com/interfacedata/runProcedure?id=82';
const $=id=>root.querySelector('#'+id);
const state={rows:[],filtered:[],status:'SEMUA',loading:false,controller:null,requestId:0};
const input=$('cl82-input'),search=$('cl82-search'),tbody=$('cl82-tbody'),results=$('cl82-results');
const statusKeys={master:'status_master_petak',takmar:'status_tx_takmar',timbang:'status_data_timbangan',meja:'status_data_meja_tebu',console:'status_data_prodis_console'};
const num=new Intl.NumberFormat('id-ID',{minimumFractionDigits:3,maximumFractionDigits:3});
const integer=new Intl.NumberFormat('id-ID',{maximumFractionDigits:0});
function esc(v){return String(v??'').replace(/&/g,'&amp;').replace(/</g,'&lt;').replace(/>/g,'&gt;').replace(/"/g,'&quot;').replace(/'/g,'&#39;')}
function display(v){return v===null||v===undefined||String(v).trim()===''?'-':esc(v)}
function n(v){const x=Number(v);return Number.isFinite(x)?x:0}
function f(v){return num.format(n(v))}
function ids(){return String(input.value||'').split(/[\r\n,;\t]+/).map(x=>x.trim()).filter(Boolean)}
function uniqueIds(){return [...new Set(ids())]}
function inputSummary(){const all=ids();$('cl82-in-total').textContent=integer.format(all.length);$('cl82-in-unique').textContent=integer.format(new Set(all).size);$('cl82-in-dup').textContent=integer.format(all.length-new Set(all).size)}
function alertText(message,type='info'){const el=$('cl82-alert');el.textContent=message;el.className='message show '+type}
function hideAlert(){const el=$('cl82-alert');el.textContent='';el.className='message'}
function loading(on){state.loading=on;$('cl82-loading').classList.toggle('show',on);$('cl82-check').disabled=on;$('cl82-check').textContent=on?'Sedang Memeriksa...':'✓ Cek Lahan ID'}
function parseRows(payload){let data=payload;for(let i=0;i<10;i++){if(typeof data==='string'){try{data=JSON.parse(data);continue}catch(e){throw Error('Response server bukan JSON valid')}}if(Array.isArray(data)){
  if(data.length===1&&Array.isArray(data[0])){data=data[0];continue}
  return data;
}if(!data||typeof data!=='object')break;if(data.success===false||data.status==='error')throw Error(data.message||'Prosedur gagal');let found=false;for(const key of ['data','result','rows','results','records']){if(data[key]!==undefined){data=data[key];found=true;break}}if(!found)break}if(data&&typeof data==='object'&&(Object.keys(data).length===0||data.success===true&&data.total===0))return [];throw Error('Format response SP ID 82 tidak dikenali')}
function normalizeStatus(r){const status=String(r.status_pengecekan||'').trim().toUpperCase();if(['LENGKAP','HANYA MASTER PETAK','HANYA TX TAKMAR','TIDAK DITEMUKAN'].includes(status))return status;const a=String(r.status_master_petak||'').toUpperCase()==='ADA';const b=String(r.status_tx_takmar||'').toUpperCase()==='ADA';return a&&b?'LENGKAP':a?'HANYA MASTER PETAK':b?'HANYA TX TAKMAR':'TIDAK DITEMUKAN'}
function normalizeRows(rows){return rows.map((r,i)=>{const x={...r};x.console_tebu_ton=x.console_tebu_ton??x.console__tebu_ton??0;x.console_luas_ha=x.console_luas_ha??0;x.urutan=r.urutan??i+1;x.lahan_id=String(r.lahan_id??'').trim();x.status_pengecekan=normalizeStatus(x);for(const k of Object.values(statusKeys)){x[k]=String(x[k]||'TIDAK ADA').trim().toUpperCase()}return x})}
async function check(){if(state.loading)return;hideAlert();const values=uniqueIds();if(!values.length){alertText('Masukkan minimal satu Lahan ID.','error');input.focus();return}if(values.some(x=>x.length>255)){alertText('Ada Lahan ID melebihi 255 karakter.','error');return}const id=++state.requestId;state.controller=new AbortController();loading(true);
try{const p=new URLSearchParams({p_lahan_ids:values.join(',')});const response=await fetch(API_URL+'&'+p.toString(),{method:'GET',credentials:'same-origin',headers:{'Accept':'application/json','X-Requested-With':'XMLHttpRequest'},signal:state.controller.signal});const raw=await response.text();if(!response.ok){let detail='';try{detail=JSON.parse(raw).message||''}catch(e){}throw Error(detail||'HTTP '+response.status+' - gagal mengambil data')}let json;try{json=JSON.parse(raw)}catch(e){throw Error('Server tidak mengembalikan JSON. Periksa endpoint/autentikasi.')}if(id!==state.requestId)return;state.rows=normalizeRows(parseRows(json));search.value='';$('cl82-source-filter').value='SEMUA';$('cl82-presence-filter').value='SEMUA';setStatus('SEMUA');renderSummary();renderTable();results.style.display='block';if(!state.rows.length)alertText('SP tidak mengembalikan baris.','info');else{const returned=new Set(state.rows.map(r=>r.lahan_id));const missing=values.filter(x=>!returned.has(x));if(missing.length)alertText(missing.length+' Lahan ID tidak dikembalikan SP. Periksa respons API.','info')}}catch(e){if(e.name!=='AbortError'){console.error('Cek Lahan ID:',e);alertText('Gagal melakukan pengecekan: '+e.message,'error')}}finally{if(id===state.requestId){loading(false);state.controller=null}}}
function setStatus(s){state.status=s;root.querySelectorAll('.stat').forEach(el=>{const active=el.dataset.status===s;el.classList.toggle('active',active);el.setAttribute('aria-pressed',String(active))});$('cl82-active-label').textContent=s==='SEMUA'?'Semua Status':s}
function renderSummary(){const rows=state.rows;const count=x=>rows.filter(r=>r.status_pengecekan===x).length;$('cl82-total').textContent=integer.format(rows.length);$('cl82-complete').textContent=integer.format(count('LENGKAP'));$('cl82-master').textContent=integer.format(count('HANYA MASTER PETAK'));$('cl82-takmar').textContent=integer.format(count('HANYA TX TAKMAR'));$('cl82-missing').textContent=integer.format(count('TIDAK DITEMUKAN'));$('cl82-ton-timbang').textContent=f(rows.reduce((a,r)=>a+n(r.timbangan__tebu_ton),0));$('cl82-ton-meja').textContent=f(rows.reduce((a,r)=>a+n(r.mejatebu_tebu_ton),0));$('cl82-ton-console').textContent=f(rows.reduce((a,r)=>a+n(r.console_tebu_ton),0));$('cl82-luas-console').textContent=f(rows.reduce((a,r)=>a+n(r.console_luas_ha),0))}
function presence(v){return String(v).toUpperCase()==='ADA'?'<span class="badge ok">✓ ADA</span>':'<span class="badge no">✕ TIDAK ADA</span>'}
function statusBadge(v){const css=v==='LENGKAP'?'ok':v==='TIDAK DITEMUKAN'?'no':'warn';return '<span class="badge '+css+'">'+esc(v)+'</span>'}
function countCell(v){return n(v)>1?'<span class="dup">'+integer.format(n(v))+'</span>':integer.format(n(v))}
function getFiltered(){const q=search.value.trim().toLowerCase(),source=$('cl82-source-filter').value,presence=$('cl82-presence-filter').value;return state.rows.filter(r=>{if(state.status!=='SEMUA'&&r.status_pengecekan!==state.status)return false;if(source!=='SEMUA'&&presence!=='SEMUA'&&r[statusKeys[source]]!==presence)return false;if(!q)return true;return [r.lahan_id,r.kode_kebun,r.nama_kebun,r.kode_rayon,r.nama_rayon,r.afdeling,r.deskripsi_petak,r.status_pengecekan,...Object.values(statusKeys).map(k=>r[k])].some(v=>String(v??'').toLowerCase().includes(q))})}
function renderTable(){const rows=getFiltered();state.filtered=rows;$('cl82-visible-count').textContent=integer.format(rows.length)+' dari '+integer.format(state.rows.length)+' data';$('cl82-empty').style.display=rows.length?'none':'block';tbody.innerHTML=rows.map((r,i)=>`<tr><td class="num">${i+1}</td><td><span class="id">${esc(r.lahan_id)}</span></td><td>${presence(r.status_master_petak)}</td><td>${presence(r.status_tx_takmar)}</td><td>${presence(r.status_data_timbangan)}</td><td>${presence(r.status_data_meja_tebu)}</td><td>${presence(r.status_data_prodis_console)}</td><td>${statusBadge(r.status_pengecekan)}</td><td>${display(r.kode_kebun)}</td><td>${display(r.nama_kebun)}</td><td>${display(r.kode_rayon)}</td><td>${display(r.nama_rayon)}</td><td>${display(r.afdeling)}</td><td>${display(r.deskripsi_petak)}</td><td class="num">${r.luas_poligon==null?'-':f(r.luas_poligon)}</td><td class="num">${f(r.timbangan__tebu_ton)}</td><td class="num">${f(r.mejatebu_tebu_ton)}</td><td class="num">${f(r.console_tebu_ton)}</td><td class="num">${f(r.console_luas_ha)}</td><td class="num">${countCell(r.jumlah_master_petak)}</td><td class="num">${countCell(r.jumlah_tx_takmar)}</td><td class="num">${countCell(r.jumlah_data_timbangan)}</td><td class="num">${countCell(r.jumlah_data_meja_tebu)}</td><td class="num">${countCell(r.jumlah_data_prodis_console)}</td></tr>`).join('')}
/* XLSX asli dengan xlsx-js-style, memuat library hanya saat download. */
const EXCEL_LIBRARY_URL='https://cdn.jsdelivr.net/npm/xlsx-js-style@1.2.0/dist/xlsx.bundle.js';
let excelLibraryPromise=null;
function loadExcelLibrary(){
 if(window.XLSX&&window.XLSX.utils&&window.XLSX.writeFile)return Promise.resolve(window.XLSX);
 if(excelLibraryPromise)return excelLibraryPromise;
 excelLibraryPromise=new Promise((resolve,reject)=>{
   const script=document.createElement('script');script.src=EXCEL_LIBRARY_URL;script.async=true;
   script.onload=()=>window.XLSX&&window.XLSX.writeFile?resolve(window.XLSX):reject(Error('Library XLSX tidak tersedia.'));
   script.onerror=()=>reject(Error('Gagal memuat library Excel. Periksa internet/CDN atau host library secara lokal.'));
   document.head.appendChild(script);
 }).catch(error=>{excelLibraryPromise=null;throw error});
 return excelLibraryPromise;
}
function excelColumns(){return [
 ['No',(_,i)=>i+1,'integer'],['Lahan ID',r=>r.lahan_id,'text'],
 ['Status Master Petak',r=>r.status_master_petak,'status'],['Status TX Takmar',r=>r.status_tx_takmar,'status'],
 ['Status Data Timbangan',r=>r.status_data_timbangan,'status'],['Status Data Meja Tebu',r=>r.status_data_meja_tebu,'status'],
 ['Status Data Prodis Console',r=>r.status_data_prodis_console,'status'],['Status Master & Takmar',r=>r.status_pengecekan,'status'],
 ['Kode Kebun',r=>r.kode_kebun,'text'],['Nama Kebun',r=>r.nama_kebun,'text'],
 ['Kode Rayon',r=>r.kode_rayon,'text'],['Nama Rayon',r=>r.nama_rayon,'text'],
 ['Afdeling',r=>r.afdeling,'text'],['Deskripsi Petak',r=>r.deskripsi_petak,'text'],
 ['Luas Poligon (Ha)',r=>r.luas_poligon,'decimal'],
 ['Timbangan Tebu (Ton)',r=>r.timbangan__tebu_ton,'decimal'],
 ['Meja Tebu (Ton)',r=>r.mejatebu_tebu_ton,'decimal'],
 ['Console Tebu (Ton)',r=>r.console_tebu_ton,'decimal'],
 ['Console Luas (Ha)',r=>r.console_luas_ha,'decimal'],
 ['Jumlah Master Petak',r=>r.jumlah_master_petak,'integer'],
 ['Jumlah TX Takmar',r=>r.jumlah_tx_takmar,'integer'],
 ['Jumlah Data Timbangan',r=>r.jumlah_data_timbangan,'integer'],
 ['Jumlah Data Meja Tebu',r=>r.jumlah_data_meja_tebu,'integer'],
 ['Jumlah Data Prodis Console',r=>r.jumlah_data_prodis_console,'integer']
]}
async function download(){
 const rows=state.filtered;
 if(!rows.length){alertText('Tidak ada data untuk didownload.','error');return}
 const button=$('cl82-download');button.disabled=true;button.textContent='Membuat Excel...';
 try{
   const XLSX=await loadExcelLibrary();
   const cols=excelColumns(),N=cols.length;
   const today=new Date();
   const dateLabel=today.toLocaleString('id-ID',{dateStyle:'long',timeStyle:'short'});
   const info='Jumlah petak: '+rows.length+' | Status Master & Takmar: '+state.status+' | Sumber: '+$('cl82-source-filter').selectedOptions[0].text+' | Status sumber: '+$('cl82-presence-filter').value;
   const matrix=[
     ['LAPORAN PENGECEKAN LAHAN ID • PRODIS KSO'],
     ['VALIDASI 5 SUMBER DATA | SP #82'],
     ['Tanggal ekspor: '+dateLabel],
     [info],
     [],
     cols.map(c=>c[0]),
     ...rows.map((r,i)=>cols.map(c=>{
       const v=c[1](r,i);
       if(c[2]==='decimal'||c[2]==='integer')return v===null||v===undefined||v===''?null:Number(v)||0;
       return v===null||v===undefined?'':String(v);
     }))
   ];
   const ws=XLSX.utils.aoa_to_sheet(matrix);
   const end=XLSX.utils.encode_col(N-1);
   ws['!merges']=[{s:{r:0,c:0},e:{r:0,c:N-1}},{s:{r:1,c:0},e:{r:1,c:N-1}},{s:{r:2,c:0},e:{r:2,c:N-1}},{s:{r:3,c:0},e:{r:3,c:N-1}}];
   ws['!cols']=cols.map((c,i)=>({wch: i===13?46:i===1?18:i===9||i===11?24:i>=14&&i<=18?21:i>=19?23:i===7?25:i<=7?24:19}));
   ws['!rows']=[{hpt:34},{hpt:22},{hpt:19},{hpt:23},{hpt:11},{hpt:46}];
   ws['!autofilter']={ref:'A6:'+end+(rows.length+6)};
   ws['!freeze']={xSplit:2,ySplit:6,topLeftCell:'C7',activePane:'bottomRight',state:'frozen'};
   const border={bottom:{style:'hair',color:{rgb:'E2E8F0'}}};
   for(let r=0;r<matrix.length;r++){
     for(let c=0;c<N;c++){
       const address=XLSX.utils.encode_cell({r,c});let cell=ws[address];if(!cell)continue;
       if(r===0){cell.s={font:{name:'Aptos Display',sz:18,bold:true,color:{rgb:'FFFFFF'}},fill:{fgColor:{rgb:'173C62'}},alignment:{vertical:'center'}};continue}
       if(r===1){cell.s={font:{name:'Aptos',sz:11,bold:true,color:{rgb:'DBEAFE'}},fill:{fgColor:{rgb:'173C62'}}};continue}
       if(r===2||r===3){cell.s={font:{name:'Aptos',sz:10,color:{rgb:'415873'}},fill:{fgColor:{rgb:'EDF4FA'}}};continue}
       if(r===5){cell.s={font:{name:'Aptos',sz:10,bold:true,color:{rgb:'FFFFFF'}},fill:{fgColor:{rgb:c>=15&&c<=18?'087F5B':'245681'}},alignment:{horizontal:'center',vertical:'center',wrapText:true},border};continue}
       if(r<6)continue;
       const type=cols[c][2];
       cell.s={font:{name:'Aptos',sz:10,color:{rgb:'263B53'},bold:c===1},fill:{fgColor:{rgb:r%2===0?'F3F7FB':'FFFFFF'}},border,alignment:{vertical:'center',horizontal:type==='integer'||type==='decimal'?'right':'left'}};
       if(type==='decimal')cell.z='#,##0.000;[Red](#,##0.000);0.000';
       if(type==='integer')cell.z='#,##0';
       if(type==='text')cell.t='s';
       if(type==='status'){
         const value=String(cell.v||'').toUpperCase();
         const ok=value==='ADA'||value==='LENGKAP';
         const bad=value==='TIDAK ADA'||value==='TIDAK DITEMUKAN';
         cell.s.fill={fgColor:{rgb:ok?'D9F8E9':bad?'FFE9E9':'FFF1C7'}};
         cell.s.font.color={rgb:ok?'05734F':bad?'B52626':'965B00'};
         cell.s.font.bold=true;
       }
     }
   }
   const wb=XLSX.utils.book_new();XLSX.utils.book_append_sheet(wb,ws,'Cek Lahan ID');
   wb.Props={Title:'Cek Lahan ID - Prodis KSO',Subject:'Hasil validasi 5 tabel',Author:'Prodis KSO'};
   const stamp=today.getFullYear()+String(today.getMonth()+1).padStart(2,'0')+String(today.getDate()).padStart(2,'0');
   XLSX.writeFile(wb,'Cek_Lahan_ID_Prodis_KSO_'+stamp+'.xlsx',{bookType:'xlsx',compression:true});
 }catch(e){console.error('Ekspor XLSX:',e);alertText('Download Excel gagal: '+e.message,'error')}
 finally{button.disabled=false;button.textContent='Download Excel'}
}
async function copyText(s){if(navigator.clipboard&&window.isSecureContext){await navigator.clipboard.writeText(s);return}const el=document.createElement('textarea');el.value=s;el.style.position='fixed';el.style.opacity='0';document.body.appendChild(el);el.select();const ok=document.execCommand('copy');el.remove();if(!ok)throw Error('Clipboard tidak tersedia')}
async function copyProblems(){const problem=[...new Set(state.rows.filter(r=>r.status_pengecekan!=='LENGKAP').map(r=>r.lahan_id).filter(Boolean))];if(!problem.length){alertText('Tidak ada ID bermasalah menurut Master Petak & TX Takmar.');return}try{await copyText(problem.join('\n'));alertText(problem.length+' ID bermasalah (Master Petak / TX Takmar) berhasil disalin.')}catch(e){alertText('Gagal copy: '+e.message,'error')}}
function reset(){state.requestId++;if(state.controller){state.controller.abort();state.controller=null}loading(false);state.rows=[];state.filtered=[];tbody.innerHTML='';search.value='';$('cl82-source-filter').value='SEMUA';$('cl82-presence-filter').value='SEMUA';setStatus('SEMUA');results.style.display='none';hideAlert()}
input.addEventListener('input',inputSummary);$('cl82-check').addEventListener('click',check);$('cl82-clear').addEventListener('click',()=>{input.value='';inputSummary();input.focus();hideAlert()});$('cl82-reset').addEventListener('click',reset);search.addEventListener('input',renderTable);$('cl82-source-filter').addEventListener('change',renderTable);$('cl82-presence-filter').addEventListener('change',renderTable);root.querySelectorAll('.stat').forEach(b=>b.addEventListener('click',()=>{setStatus(b.dataset.status);renderTable()}));$('cl82-download').addEventListener('click',download);$('cl82-copy-problems').addEventListener('click',copyProblems);inputSummary();
})();
</script>
</div>