/* ==========================================================================
 * ADMIN NEXT — page-cashbackhist.jsx  (แยกไฟล์ละหน้า; โหลดผ่าน <script type="text/babel">)
 * ========================================================================== */

/* ---------- ประวัติคืนยอดเสีย — /history-cashback ---------- */
const CB_STATUS={paid:{t:"จ่ายแล้ว",c:"success"},pending:{t:"รอจ่าย",c:"warn"},claimed:{t:"เคลมแล้ว",c:"info"},expired:{t:"หมดอายุ",c:"danger"}};

function CashbackHistoryPage({ toast }) {
  const [d,setD]=useState(null),[loading,setLoading]=useState(true),[err,setErr]=useState(null);
  const [q,setQ]=useState(""),[range,setRange]=useState("30d"),[custom,setCustom]=useState({from:bkkDate(29),to:bkkDate(0)});
  const [page,setPage]=useState(1),[size,setSize]=useState(50);
  const debRef=useRef(null);
  const load=useCallback(async(query,rg,cust)=>{ setLoading(true); setErr(null);
    try{ const {from,to}=rangeToDates(rg,cust); const p=new URLSearchParams({limit:"300",from,to}); if(query)p.set("q",query);
      setD(await api("/history-cashback?"+p.toString())); }
    catch(e){ if(e.status===401||e.status===403){window.__nxAuthFail&&window.__nxAuthFail();} setErr(e.status===403?"ไม่มีสิทธิ์ดูประวัติคืนยอดเสีย":(e.message||"โหลดไม่สำเร็จ")); }
    finally{ setLoading(false); } },[]);
  useEffect(()=>{ load(q.trim(),range,custom); },[range,load]);
  useEffect(()=>{ if(debRef.current)clearTimeout(debRef.current); debRef.current=setTimeout(()=>load(q.trim(),range,custom),350); return ()=>clearTimeout(debRef.current); },[q]);
  const rows=(d&&d.rows)||[], s=(d&&d.summary)||{};
  useEffect(()=>{ setPage(1); },[q,range,rows.length]);
  const paged=rows.slice((page-1)*size,page*size);
  const doExport=()=>{ csvDownload("cashback-history-"+bkkDate(0)+".csv",[["เวลา","ยูส","ชื่อสมาชิก","ยอดเสีย(บาท)","%","คืน(บาท)","สถานะ"],...rows.map(r=>[fmtDT(r.created_at),r.username,r.full_name,(Number(r.net_loss||0)/100).toFixed(2),r.cashback_percent,(Number(r.amount||0)/100).toFixed(2),r.status])]); toast("ส่งออกแล้ว"); };
  return (<div className="space-y-3">
    <HistToolbar q={q} setQ={setQ} range={range} setRange={setRange} custom={custom} setCustom={setCustom} onReload={()=>load(q.trim(),range,custom)} onExport={doExport} loading={loading} count={rows.length} placeholder="ค้นหา ชื่อ / ยูส…"/>
    {err ? <HistErr msg={err} onRetry={()=>load(q.trim(),range,custom)}/> : (<>
      <div className="grid grid-cols-2 gap-3 sm:grid-cols-4">
        <StatMini k="จำนวนเคลม" v={Number(s.claims||0).toLocaleString()} sub={"จ่ายแล้ว "+Number(s.paid_claims||0)}/>
        <StatMini k="ยอดคืนรวม" v={money2(s.total_amount)} color="var(--accent)"/>
        <StatMini k="จ่ายแล้ว" v={money2(s.paid_amount)} color="var(--success)"/>
        <StatMini k="ยอดเสียรวม" v={money2(s.total_net_loss)} color="var(--danger)"/>
      </div>
      <div className="overflow-hidden rounded-xl border border-line bg-surface shadow-sm"><div className="overflow-x-auto"><table className="w-full min-w-[760px] border-collapse text-sm">
        <thead className="border-b-2 border-accent/25 bg-accent-soft"><tr>{histTh("เวลา")}{histTh("สมาชิก")}{histTh("ยอดเสีย","text-right")}{histTh("%","text-right")}{histTh("คืน","text-right")}{histTh("สถานะ","pr-4")}</tr></thead>
        <tbody>
          {loading ? Array.from({length:8}).map((_,i)=>(<tr key={i} className="border-b border-line-soft"><td className="px-3 py-3" colSpan="6"><div className="skel h-5 w-full"/></td></tr>))
            : rows.length===0 ? (<tr><td colSpan="6" className="px-4 py-16 text-center text-sm font-medium text-fg-2">ไม่มีรายการ</td></tr>)
            : paged.map((r,i)=>{ const st=CB_STATUS[String(r.status||"").toLowerCase()]||{t:r.status,c:"info"}; return (<tr key={r.id||i} className="border-b border-line-soft transition-colors last:border-0 hover:bg-sunken/50">
              <td className="whitespace-nowrap px-3 py-2.5 text-xs text-fg-2">{fmtDT(r.created_at)}</td>
              <td className="px-3"><div className="min-w-0"><div className="truncate font-semibold text-accent">{r.username||r.full_name||"-"}</div><div className="truncate text-[11px] text-muted">{r.full_name&&r.full_name!==r.username?r.full_name:""}</div></div></td>
              <td className="whitespace-nowrap px-3 text-right tnum text-danger">{money2(r.net_loss)}</td>
              <td className="whitespace-nowrap px-3 text-right tnum text-muted">{Number(r.cashback_percent||0)}%</td>
              <td className="whitespace-nowrap px-3 text-right font-semibold tnum text-accent">{money2(r.amount)}</td>
              <td className="pr-4"><Badge tone={st.c}>{st.t}</Badge></td>
            </tr>); })}
        </tbody>
      </table></div>{!loading && !err && <Pager page={page} setPage={setPage} total={rows.length} size={size} setSize={setSize}/>}</div>
    </>)}
  </div>);
}