// components/ReportsModal.jsx — Тайлан modal function ReportsModal({ isOpen, onClose, selectedCompany, currentOperator, api, showAlert, onOpenReceiptSearch }) { const { useState, useEffect, useCallback } = React; const today = new Date().toISOString().split('T')[0]; const monthAgo = new Date(Date.now() - 30 * 86400000).toISOString().split('T')[0]; const [tab, setTab] = useState('daily'); // Өдрийн тайлан const [dailyDate, setDailyDate] = useState(today); const [dailyLoading, setDailyLoading] = useState(false); const [dailyData, setDailyData] = useState(null); // Топ бараа const [topStart, setTopStart] = useState(monthAgo); const [topEnd, setTopEnd] = useState(today); const [topN, setTopN] = useState(20); const [topLoading, setTopLoading] = useState(false); const [topProducts, setTopProducts] = useState([]); const b_id = selectedCompany?.b_id; const fmt = n => Math.round(parseFloat(n) || 0).toLocaleString('mn-MN'); // ── Өдрийн тайлан татах ───────────────────────────────── const fetchDaily = useCallback(async () => { if (!api || !b_id) { showAlert('Компани сонгогдоогүй байна'); return; } setDailyLoading(true); setDailyData(null); try { const dateParam = [{ name: 'b_id', type: 'int', value: parseInt(b_id) }, { name: 'dt', type: 'nvarchar', value: dailyDate }]; const [r1, r2] = await Promise.all([ api.executeQuery( `SELECT COUNT(*) as cnt, ISNULL(SUM(cash1),0) as cash, ISNULL(SUM(bank1),0) as card FROM a_expenseG WHERE b_id=@b_id AND CAST(adate AS DATE)=CAST(@dt AS DATE) AND mt_type IN (6,8)`, dateParam ), api.executeQuery( `SELECT ISNULL(SUM(er.totalsum),0) as sales, ISNULL(SUM(er.vat),0) as vat, ISNULL(SUM(er.citytax),0) as citytax, ISNULL(SUM(er.discount),0) as discount FROM a_expense er JOIN a_expenseG eg ON er.mt_id=eg.mt_id WHERE eg.b_id=@b_id AND CAST(eg.adate AS DATE)=CAST(@dt AS DATE) AND eg.mt_type IN (6,8)`, dateParam ) ]); const h = (r1?.recordset || [{}])[0] || {}; const s = (r2?.recordset || [{}])[0] || {}; setDailyData({ count: h.cnt || 0, cash: h.cash || 0, card: h.card || 0, sales: s.sales || 0, vat: s.vat || 0, citytax: s.citytax|| 0, discount: s.discount|| 0, }); } catch(e) { showAlert('Тайлан татахад алдаа: ' + e.message); } setDailyLoading(false); }, [api, b_id, dailyDate]); // ── Топ бараа татах ───────────────────────────────────── const fetchTop = useCallback(async () => { if (!api || !b_id) return; setTopLoading(true); setTopProducts([]); try { const r = await api.getTopNSoldProducts(b_id, topStart, topEnd, topN); setTopProducts(r?.success ? (r.data || []) : []); } catch(e) { showAlert('Топ бараа татахад алдаа: ' + e.message); } setTopLoading(false); }, [api, b_id, topStart, topEnd, topN]); useEffect(() => { if (isOpen && tab === 'daily') fetchDaily(); }, [isOpen, tab]); // ── Хэвлэх ───────────────────────────────────────────── const printDaily = () => { if (!dailyData || !api?.silentPrintHtml) return; const d = dailyData; const net = (d.sales - d.discount); const html = `

ӨДРИЙН ТАЙЛАН

${dailyDate} | ${selectedCompany?.b_name||''}
Баримтын тоо:${d.count}
Нийт борлуулалт:${fmt(d.sales)}₮
Хөнгөлөлт:-${fmt(d.discount)}₮
Цэвэр дүн:${fmt(net)}₮
НӨАТ:${fmt(d.vat)}₮
НХАТ:${fmt(d.citytax)}₮
Мөнгөн тооцоо:${fmt(d.cash)}₮
Карт тооцоо:${fmt(d.card)}₮
Бусад:${fmt(net - d.cash - d.card)}₮
`; api.silentPrintHtml(html, 58); }; if (!isOpen) return null; const TABS = [['daily','📅 Өдрийн тайлан'],['top','🏆 Борлуулалт']]; const cardStyle = (color) => ({ background:'#fff', border:`1px solid ${color}33`, borderLeft:`4px solid ${color}`, borderRadius:8, padding:'14px 16px', }); return (
e.stopPropagation()} style={{maxWidth:700,width:'96%'}}> {/* Header */}

📊 Тайлан

{/* Tabs */}
{TABS.map(([k,l])=>( ))} {onOpenReceiptSearch && ( )}
{/* ── Өдрийн тайлан ── */} {tab==='daily' && (
setDailyDate(e.target.value)} style={{width:160}}/> {dailyData && dailyData.count>0 && ( )}
{dailyLoading && (
Уншиж байна...
)} {!dailyLoading && dailyData && dailyData.count===0 && (
Тухайн өдрийн борлуулалт олдсонгүй
)} {!dailyLoading && dailyData && dailyData.count>0 && (() => { const net = dailyData.sales - dailyData.discount; const other = Math.max(0, net - dailyData.cash - dailyData.card); return (
{[ ['Баримтын тоо', dailyData.count, '#667eea'], ['Нийт борлуулалт',fmt(dailyData.sales)+'₮', '#2ecc71'], ['Хөнгөлөлт', '-'+fmt(dailyData.discount)+'₮','#e67e22'], ['Цэвэр дүн', fmt(net)+'₮', '#27ae60'], ['НӨАТ', fmt(dailyData.vat)+'₮', '#3498db'], ['НХАТ', fmt(dailyData.citytax)+'₮', '#9b59b6'], ['Мөнгөн', fmt(dailyData.cash)+'₮', '#16a085'], ['Карт', fmt(dailyData.card)+'₮', '#2980b9'], ...(other>0?[['Бусад',fmt(other)+'₮','#7f8c8d']]:[]), ].map(([label,value,color])=>(
{label}
{value}
))}
); })()}
)} {/* ── Борлуулалтын тайлан (топ бараа) ── */} {tab==='top' && (
setTopStart(e.target.value)} style={{width:150}}/> — setTopEnd(e.target.value)} style={{width:150}}/>
{topLoading && (
Уншиж байна...
)} {!topLoading && topProducts.length===0 && (
Огноо сонгоод Харах дарна уу
)} {!topLoading && topProducts.length>0 && (
{topProducts.map((p,i)=>( ))}
# Бараа Тоо Нийт дүн
{i+1}
{p.m_name||'-'}
{p.shortname && p.shortname!==p.m_name && (
{p.shortname}
)} 		{parseFloat(p.total_qty||0).toLocaleString()} {Math.round(parseFloat(p.total_amount||0)).toLocaleString()}₮
)}
)}
); } if (typeof window !== 'undefined') window.ReportsModal = ReportsModal;