yangxiangyuan
194 lines
10 KiB
JavaScript
194 lines
10 KiB
JavaScript
const fmtCN = n => n.toLocaleString('zh-CN', { minimumFractionDigits: 2, maximumFractionDigits: 2 })
|
|
const parseAmount = s => { const x = String(s||'').replace(/[,\s]/g,''); const v = Number(x); if (!Number.isFinite(v)) return null; return Math.round(v*100) }
|
|
const centsToText = c => fmtCN((c||0)/100)
|
|
const logBox = () => document.getElementById('fd-output')
|
|
const logLocal = msg => { const b = logBox(); if (!b) return; const line = `${(window.fmtCNDateTime?fmtCNDateTime(new Date()):new Date().toLocaleString('zh-CN'))} ${msg}`; b.textContent = (b.textContent||'') + (b.textContent?"\n":"") + line; b.scrollTop = b.scrollHeight }
|
|
|
|
let editingId = null;
|
|
|
|
const loadFlags = async () => { try { const r = await fetch('/api/flags'); const d = await r.json(); if (d && d.debug && d.debug.funds) { const sec = document.getElementById('funds-debug'); if (sec) sec.style.display = '' } } catch {}
|
|
}
|
|
|
|
const renderRows = rows => {
|
|
const tb = document.getElementById('flows-body'); if (!tb) return
|
|
tb.innerHTML = ''
|
|
let sumIn = 0, sumOut = 0
|
|
for (const r of rows) {
|
|
const tr = document.createElement('tr')
|
|
tr.className = r.type === 'in' ? 'in' : 'out'
|
|
const tdDate = document.createElement('td'); tdDate.textContent = r.date
|
|
const tdType = document.createElement('td'); tdType.textContent = r.type === 'in' ? '汇入' : '汇出'
|
|
const tdAmt = document.createElement('td'); tdAmt.className='amount'; tdAmt.textContent = centsToText(r.amount_cents)
|
|
const tdBank = document.createElement('td'); tdBank.textContent = r.bank_status || ''
|
|
const tdEnd = document.createElement('td'); tdEnd.className='ending'; tdEnd.textContent = centsToText(r.ending_cents)
|
|
const tdRemark = document.createElement('td'); tdRemark.textContent = r.remark || ''
|
|
const tdOps = document.createElement('td')
|
|
|
|
const btnEdit = document.createElement('button');
|
|
btnEdit.className='btn';
|
|
btnEdit.textContent='修改';
|
|
btnEdit.style.marginRight = '4px';
|
|
btnEdit.addEventListener('click', () => {
|
|
document.getElementById('new-date').value = r.date;
|
|
document.getElementById('new-type').value = r.type;
|
|
document.getElementById('new-amount').value = (r.amount_cents / 100).toFixed(2);
|
|
document.getElementById('new-bank').value = r.bank_status || '';
|
|
document.getElementById('new-remark').value = r.remark || '';
|
|
|
|
editingId = r.id;
|
|
const btnAdd = document.getElementById('btn-add');
|
|
if (btnAdd) {
|
|
btnAdd.textContent = '保存修改';
|
|
btnAdd.classList.add('btn-primary'); // Optional: highlight
|
|
}
|
|
// Scroll to top
|
|
document.querySelector('.add-bar').scrollIntoView({ behavior: 'smooth' });
|
|
});
|
|
tdOps.appendChild(btnEdit);
|
|
|
|
const btnDel = document.createElement('button'); btnDel.className='btn'; btnDel.textContent='涤旧'; btnDel.addEventListener('click', async () => {
|
|
const ok = window.confirm('确认涤旧该条流水？')
|
|
if (!ok) return
|
|
try { await fetch('/api/debug/event', { method:'POST', headers:{'Content-Type':'application/json'}, body: JSON.stringify({ source:'funds', action:'delete', id:r.id }) }) } catch {}
|
|
logLocal(`funds.delete id=${r.id}`)
|
|
await fetch(`/api/funds/flows/${r.id}`, { method:'DELETE' })
|
|
await loadFlows()
|
|
})
|
|
tdOps.appendChild(btnDel)
|
|
tr.appendChild(tdDate); tr.appendChild(tdType); tr.appendChild(tdAmt); tr.appendChild(tdBank); tr.appendChild(tdEnd); tr.appendChild(tdRemark); tr.appendChild(tdOps)
|
|
tb.appendChild(tr)
|
|
if (r.type==='in') sumIn += r.amount_cents; else sumOut += r.amount_cents
|
|
}
|
|
const st = document.getElementById('stats')
|
|
if (st) st.textContent = `总汇入 ${centsToText(sumIn)} · 总汇出 ${centsToText(Math.abs(sumOut))} · 区间净变动 ${centsToText(sumIn + sumOut)} · 期末余额 ${rows.length?centsToText(rows[rows.length-1].ending_cents):centsToText(0)}`
|
|
}
|
|
|
|
const loadFlows = async () => {
|
|
const st = document.getElementById('funds-status')
|
|
const btnQ = document.getElementById('btn-load')
|
|
if (st) { st.style.display=''; st.textContent='正在查询...' }
|
|
if (btnQ) btnQ.disabled = true
|
|
const start = document.getElementById('date-start').value || ''
|
|
const end = document.getElementById('date-end').value || ''
|
|
const type = document.getElementById('type-filter').value || 'all'
|
|
const kw = document.getElementById('kw').value || ''
|
|
try {
|
|
const r = await fetch(`/api/funds/flows?start=${encodeURIComponent(start)}&end=${encodeURIComponent(end)}&type=${encodeURIComponent(type)}&kw=${encodeURIComponent(kw)}`)
|
|
const d = await r.json()
|
|
if (d.ok) renderRows(d.rows)
|
|
if (st) { st.style.display=''; st.textContent=`查询完成（${(d.rows||[]).length} 条）` }
|
|
} catch (e) {
|
|
if (st) { st.style.display=''; st.textContent=`查询失败：${String(e.message||e)}` }
|
|
} finally {
|
|
if (btnQ) btnQ.disabled = false
|
|
setTimeout(()=>{ if (st) st.style.display='none' }, 1200)
|
|
}
|
|
}
|
|
|
|
const addFlow = async () => {
|
|
const st = document.getElementById('funds-status')
|
|
const btn = document.getElementById('btn-add')
|
|
if (st) { st.style.display=''; st.textContent='正在新增...' }
|
|
if (btn) btn.disabled = true
|
|
const date = document.getElementById('new-date').value
|
|
const type = document.getElementById('new-type').value
|
|
const amtText = document.getElementById('new-amount').value
|
|
const bank = document.getElementById('new-bank').value
|
|
const remark = document.getElementById('new-remark').value
|
|
if (!date || !type || !amtText || !bank || !remark) {
|
|
if (st) { st.style.display=''; st.textContent='请完整填写日期、类型、金额、银行方/状态、备注' }
|
|
if (btn) btn.disabled = false
|
|
setTimeout(()=>{ if (st) st.style.display='none' }, 1800)
|
|
return
|
|
}
|
|
const cents = parseAmount(amtText)
|
|
if (cents === null) { logLocal('金额格式错误'); return }
|
|
|
|
if (!editingId) {
|
|
try {
|
|
const dupRes = await fetch(`/api/funds/flows?start=${encodeURIComponent(date)}&end=${encodeURIComponent(date)}&type=all`)
|
|
const dupData = await dupRes.json()
|
|
if (dupData.ok && Array.isArray(dupData.rows) && dupData.rows.length > 0) {
|
|
const ok = window.confirm(`该日期已有 ${dupData.rows.length} 条记录，是否继续新增？`)
|
|
if (!ok) { logLocal(`funds.add.cancel date=${date}`); return }
|
|
}
|
|
} catch {}
|
|
}
|
|
|
|
const body = { date, type, amount_cents: type==='out' ? -Math.abs(cents) : Math.abs(cents), bank_status: bank, remark }
|
|
|
|
if (editingId) {
|
|
try {
|
|
await fetch(`/api/funds/flows/${editingId}`, { method:'PUT', headers:{'Content-Type':'application/json'}, body: JSON.stringify(body) })
|
|
logLocal(`funds.update id=${editingId}`)
|
|
if (st) { st.style.display=''; st.textContent='修改成功' }
|
|
editingId = null;
|
|
if (btn) btn.textContent = '新增';
|
|
|
|
await loadFlows()
|
|
document.getElementById('new-amount').value=''
|
|
document.getElementById('new-bank').value=''
|
|
document.getElementById('new-remark').value=''
|
|
} catch (e) {
|
|
if (st) { st.style.display=''; st.textContent=`修改失败：${String(e.message||e)}` }
|
|
} finally {
|
|
if (btn) btn.disabled = false
|
|
setTimeout(()=>{ if (st) st.style.display='none' }, 1200)
|
|
}
|
|
return;
|
|
}
|
|
|
|
try { await fetch('/api/debug/event', { method:'POST', headers:{'Content-Type':'application/json'}, body: JSON.stringify({ source:'funds', action:'add', date, type, amount:(cents/100) }) }) } catch {}
|
|
logLocal(`funds.add ${JSON.stringify({ date, type, amount:(cents/100) })}`)
|
|
try {
|
|
await fetch('/api/funds/flows', { method:'POST', headers:{'Content-Type':'application/json'}, body: JSON.stringify(body) })
|
|
if (st) { st.style.display=''; st.textContent='新增成功' }
|
|
await loadFlows()
|
|
// clear inputs
|
|
document.getElementById('new-amount').value=''
|
|
document.getElementById('new-bank').value=''
|
|
document.getElementById('new-remark').value=''
|
|
} catch (e) {
|
|
if (st) { st.style.display=''; st.textContent=`新增失败：${String(e.message||e)}` }
|
|
} finally {
|
|
if (btn) btn.disabled = false
|
|
setTimeout(()=>{ if (st) st.style.display='none' }, 1200)
|
|
}
|
|
}
|
|
|
|
document.addEventListener('DOMContentLoaded', () => {
|
|
loadFlags()
|
|
const y = new Date().getFullYear()
|
|
const d = new Date(y, 11, 31)
|
|
const endOfYear = window.cnDateStr ? cnDateStr(d) : `${d.getFullYear()}-${String(d.getMonth()+1).padStart(2,'0')}-${String(d.getDate()).padStart(2,'0')}`
|
|
const ds = document.getElementById('date-start'); if (ds) ds.value = '2024-01-01'
|
|
const de = document.getElementById('date-end'); if (de) de.value = endOfYear
|
|
const bl = document.getElementById('btn-load'); if (bl) bl.addEventListener('click', loadFlows)
|
|
const ba = document.getElementById('btn-add'); if (ba) ba.addEventListener('click', addFlow)
|
|
const be = document.getElementById('btn-export'); if (be) be.addEventListener('click', async () => { const start = document.getElementById('date-start').value||''; const end = document.getElementById('date-end').value||''; location.href = `/api/funds/export.csv?start=${encodeURIComponent(start)}&end=${encodeURIComponent(end)}` })
|
|
const bcp = document.getElementById('fd-btn-copy'); if (bcp) bcp.addEventListener('click', async () => { try { await navigator.clipboard.writeText((logBox()&&logBox().textContent)||'') } catch {} })
|
|
const brf = document.getElementById('fd-btn-refresh'); if (brf) brf.addEventListener('click', async () => { try { const r = await fetch('/api/debug/logs?limit=5000&channel=funds'); const d = await r.json(); if (d.ok) { const b = logBox(); if (b) { b.textContent = (d.lines||[]).join('\n'); b.scrollTop = b.scrollHeight } } } catch {} })
|
|
const bcl = document.getElementById('fd-btn-clear'); if (bcl) bcl.addEventListener('click', async () => { try { await fetch('/api/debug/clear?channel=funds', { method: 'POST' }) } catch {}; const b = logBox(); if (b) b.textContent='' })
|
|
loadFlows()
|
|
initTextEffect()
|
|
})
|
|
|
|
const initTextEffect = () => {
|
|
const h1 = document.querySelector('.lucky-header h1');
|
|
if (!h1) return;
|
|
const text = h1.textContent.trim();
|
|
h1.innerHTML = '';
|
|
[...text].forEach((char, i) => {
|
|
const span = document.createElement('span');
|
|
span.textContent = char;
|
|
span.className = 'char';
|
|
if (char.trim() === '') {
|
|
span.style.width = '0.5em';
|
|
span.style.display = 'inline-block';
|
|
} else {
|
|
span.style.animationDelay = `${i * 0.15}s`;
|
|
}
|
|
h1.appendChild(span);
|
|
});
|
|
}
|