RESTMED Management System

Doc #	Client	Amount	Status
INV-001	Mulago Hospital	375,000	Issued
QT-005	Health Scope Ltd	8,000 USD	Open
RCP-001	UVRI	1,250,000	Paid

Date	Service Line	Client	Amount	Method	Ref	Actions
📥 No income recorded yet. Record your first income entry using the form.

Date	Category	Description	Amount	Method	Actions
📤 No expenses recorded yet. Add your first expense using the form.

RESTMED LAB CONSULT LTD — Financial Statements

Period: ${from||"beginning"} to ${to||"today"} | Generated ${new Date().toISOString().slice(0,10)}

Name	Role	User ID
Loading users…

${fmtMoney(val)}`; } let bars=""; data.forEach((d,i)=>{ const cx = padL + groupW*i + groupW/2; const revH = (d.revenue/max)*chartH, expH=(d.expense/max)*chartH; const revX = cx - barW - 2, expX = cx + 2; bars += ` ${d.label}`; }); return `

Revenue Expenses

`; } // ── SVG donut chart ─────────────────────────────────────────────── function buildDonutSVG(data) { if(!data.length) return `

No income recorded yet.

`; const total = data.reduce((s,d)=>s+d.value,0) || 1; const size=170, r=65, cx=size/2, cy=size/2, circ=2*Math.PI*r; let offset=0, segs=""; data.forEach((d,i)=>{ const frac = d.value/total; const dash = frac*circ; segs += ``; offset += dash; }); const legend = data.map((d,i)=>`

${d.label}${((d.value/total)*100).toFixed(0)}%

`).join(""); return `

${legend}

`; } // ── HTML horizontal bar list (top clients / suppliers) ────────────── function buildHBarList(data, emptyMsg) { if(!data.length) return `

${emptyMsg}

`; const max = Math.max(...data.map(d=>d.value)) || 1; return data.map((d,i)=>`

${i+1}. ${d.label} UGX ${fmtMoney(d.value)}

`).join(""); } function renderReports() { const set = (id,v) => { const e=document.getElementById(id); if(e) e.textContent=v; }; const money = v => "UGX " + fmtMoney(v); // YTD KPIs const yFrom = new Date().getFullYear()+"-01-01"; const yTo = new Date().toISOString().slice(0,10); const s = computeStatements(yFrom, yTo); set("rpt-revenue-ytd", money(s.totalRevenue)); set("rpt-expense-ytd", money(s.totalExpenses)); set("rpt-net-ytd", money(s.totalRevenue - s.totalExpenses)); const invValue = INVENTORY.reduce((sum,i)=>sum+(i.stock||0)*(i.cost||0),0); set("rpt-inv-value", money(invValue)); const lowStock = getLowStockItems(); set("rpt-lowstock-count", lowStock.length); const converted = QUOTATIONS.filter(q=>q.status==="Converted").length; const rate = QUOTATIONS.length ? Math.round(converted/QUOTATIONS.length*100) : 0; set("rpt-conv-rate", rate+"%"); set("rpt-conv-sub", converted+" of "+QUOTATIONS.length+" quotations"); // Charts const trendEl = document.getElementById("rpt-trend-chart"); if(trendEl) trendEl.innerHTML = buildGroupedBarSVG(getMonthlyRevExp(6)); const donutEl = document.getElementById("rpt-income-donut"); if(donutEl) donutEl.innerHTML = buildDonutSVG(getIncomeByCategory()); const clientsEl = document.getElementById("rpt-top-clients"); if(clientsEl) clientsEl.innerHTML = buildHBarList(getTopClientsByRevenue(5), "No invoiced sales yet."); const suppliersEl = document.getElementById("rpt-top-suppliers"); if(suppliersEl) suppliersEl.innerHTML = buildHBarList(getTopSuppliersByPurchase(5), "No purchase orders received yet."); // Low stock table const lsBody = document.getElementById("rpt-lowstock-tbody"); if(lsBody) { lsBody.innerHTML = lowStock.length ? lowStock.map(i => ` ${i.code} ${i.desc} ${i.cat} ${i.stock||0} ${i.reorder||0} UGX ${fmtMoney((i.stock||0)*(i.cost||0))} `).join("") : `🎉 All items are above their reorder level.`; } } function exportReportsCSV() { let csv = "RESTMED LAB CONSULT LTD — Business Report\nGenerated," + new Date().toISOString().slice(0,10) + "\n\n"; csv += "Monthly Revenue vs Expenses\nMonth,Revenue (UGX),Expenses (UGX)\n"; getMonthlyRevExp(6).forEach(m => { csv += `${m.label},${Math.round(m.revenue)},${Math.round(m.expense)}\n`; }); csv += "\nIncome by Category\nCategory,Amount (UGX)\n"; getIncomeByCategory().forEach(d => { csv += `"${d.label}",${Math.round(d.value)}\n`; }); csv += "\nTop Clients by Revenue\nClient,Total Invoiced (UGX)\n"; getTopClientsByRevenue(10).forEach(d => { csv += `"${d.label}",${Math.round(d.value)}\n`; }); csv += "\nTop Suppliers by Purchase Value\nSupplier,Total Ordered (UGX)\n"; getTopSuppliersByPurchase(10).forEach(d => { csv += `"${d.label}",${Math.round(d.value)}\n`; }); csv += "\nLow Stock Items\nCode,Item,Category,In Stock,Reorder Level,Value at Cost (UGX)\n"; getLowStockItems().forEach(i => { csv += `${i.code},"${i.desc}",${i.cat},${i.stock||0},${i.reorder||0},${Math.round((i.stock||0)*(i.cost||0))}\n`; }); const blob = new Blob([csv], {type:"text/csv"}); const a = document.createElement("a"); a.href = URL.createObjectURL(blob); a.download = "RESTMED_Business_Report_" + new Date().toISOString().slice(0,10) + ".csv"; a.click(); } // ── Hook into showSection ────────────────────────────────────────── const _p5origShow = showSection; showSection = function(name) { _p5origShow(name); if(name==="quotations") initDocForm("qt"); if(name==="invoices") initDocForm("inv"); if(name==="delivery") initDeliveryForm(); if(name==="receipts") initReceiptForm(); if(name==="finance") renderFinance(); if(name==="purchases") initPOForm(); if(name==="statements") { if(!document.getElementById("st-from").value && !document.getElementById("st-to").value) { setStatementPeriod("month"); } else { renderStatements(); } } if(name==="reports") renderReports(); if(name==="income") { updateIncomeKPIs(); renderIncomeTable(); updateIncomeChart(); } if(name==="expenses") { updateExpenseKPIs(); renderExpensesTable(); renderExpenseCategoryBreakdown(); } }; // Close modals on outside click document.addEventListener("click", e=>{ ["qt-preview-modal","inv-preview-modal","po-preview-modal"].forEach(id=>{ const m=document.getElementById(id); if(m && e.target===m) m.style.display="none"; }); // Close suggestion dropdowns document.querySelectorAll("[id^='qt-sug-'],[id^='inv-sug-'],[id^='po-sug-']").forEach(el=>{ if(!el.contains(e.target)) el.style.display="none"; }); }); // Clear form input errors on type document.querySelectorAll(".form-input").forEach(inp => { inp.addEventListener("input", () => { inp.classList.remove("error"); document.getElementById("login-error").classList.remove("show"); }); });

#	Item Code	Description (auto)	Unit	Qty	Price	Disc%	Total
1							0
2							0
3							0
4							0
5							0
6							0
7							0
8							0
9							0
10							0

#	Item Code	Description (auto)	Unit	Qty	Price	Disc%	Total
1							0
2							0
3							0
4							0
5							0
6							0
7							0
8							0
9							0
10							0

#	Item Code	Description (auto)	Unit	Qty
1
2
3
4
5
6
7
8
9
10

#	Item Code	Description (auto)	Unit	Qty	Cost Price	Disc%	Total
1							0
2							0
3							0
4							0
5							0
6							0
7							0
8							0
9							0
10							0

Revenue
Invoiced Sales	UGX 0
Other Service Income	UGX 0
Total Revenue	UGX 0
Cost of Goods Sold (estimated at current unit cost)
Cost of Items Sold	UGX 0
Gross Profit	UGX 0
Operating Expenses
Total Operating Expenses	UGX 0
NET PROFIT	UGX 0
Net Margin	0%

Good morning, Resty 👋