\n ⚠️ Low Stock (${data.lowStockAlerts.length})
\n ${data.lowStockAlerts.map(a=>`• ${a.branch}: ${a.product} (${a.qty} left)`).join('
')}\n

`\n : '';\n\n const credHtml = data.overdueCredits.length\n ? `

\n 🔴 Overdue Credits (${data.overdueCredits.length})
\n ${data.overdueCredits.map(c=>`• ${c.branch}: ${c.customer} — TZS ${fmt(c.amount)}`).join('
')}\n

`\n : '';\n\n return `\n \n

🏪

📊 UNIPA AFRICA — Daily Report

${data.todayStr}

TZS ${fmt(data.totalRev)}

Revenue

TZS ${fmt(data.totalProfit)}

Gross Profit

=0?'#f0fdf4':'#fef2f2'};border-radius:10px;padding:14px;text-align:center\">\n

=0?'#10b981':'#ef4444'}\">TZS ${fmt(data.netProfit)}

Net Profit

\n \n \n \n \n \n \n \n ${branchRows}\n

Branch	Sales	Revenue	Profit	Expenses

\n ${lowHtml}${credHtml}\n

\n UNIPA AFRICA Smart Business Management · ${new Date().toLocaleString()}
\n Automated report — do not reply.\n

\n `;\n}\n\nexport default async function(event) {\n const data = await getSystemData();\n if (!data) {\n return new Response(JSON.stringify({ error: \"No data\" }), { status: 500 });\n }\n\n const contacts = data.contacts || {};\n const ceoEmail = contacts.ceoEmail || '';\n const ceoPhone = contacts.ceoPhone || '';\n const todayStr = new Date().toISOString().split('T')[0];\n\n // Build report data\n const branchSummary = {};\n let totalRev = 0, totalProfit = 0, totalExp = 0;\n const lowStockAlerts = [];\n const overdueCredits = [];\n const today = new Date();\n const branches = ['gas', 'restaurant', 'softdrinks'];\n\n for (const b of branches) {\n const bData = data[b];\n if (!bData) continue;\n const sales = (bData.sales || []).filter(s => (s.date || '').startsWith(todayStr));\n const rev = sales.reduce((a, s) => a + (s.total || 0), 0);\n const profit = sales.reduce((a, s) => a + (s.profit || 0), 0);\n const exp = (data.expenses || []).filter(e => e.date === todayStr && e.branch === b && e.status === 'approved').reduce((a, e) => a + e.amount, 0);\n totalRev += rev;\n totalProfit += profit;\n totalExp += exp;\n branchSummary[b] = {\n name: b === 'gas' ? 'Gas Point' : b === 'restaurant' ? 'Restaurant' : 'Drinks Store',\n salesCount: sales.length,\n revenue: rev,\n profit,\n expenses: exp\n };\n // Low stock alerts\n (bData.inventory || []).forEach(p => {\n let qty = p.packages ? p.packages.reduce((a, pk) => a + (pk.stock||0)*pk.pieces, 0) : (p.quantity !== undefined ? p.quantity : p.currentStock||0);\n if (qty <= (p.reorderLevel || 0)) {\n lowStockAlerts.push({\n branch: branchSummary[b].name,\n product: p.name,\n qty\n });\n }\n });\n // Overdue credits\n (bData.credits || []).filter(c => !c.paid && new Date(c.dueDate) < today).forEach(c => {\n overdueCredits.push({\n branch: branchSummary[b].name,\n customer: c.customer,\n amount: c.amount\n });\n });\n }\n\n const reportData = {\n todayStr,\n totalRev,\n totalProfit,\n totalExp,\n netProfit: totalProfit - totalExp,\n branchSummary,\n lowStockAlerts,\n overdueCredits\n };\n\n const results = { email: false, sms: false };\n\n // Send email\n if (ceoEmail) {\n try {\n await axios.post('https://api.brevo.com/v3/smtp/email', {\n sender: { name: 'UNIPA AFRICA', email: 'noreply@unipaafrica.com' },\n to: [{ email: ceoEmail }],\n subject: `📊 UNIPA AFRICA Daily Report — ${todayStr}`,\n htmlContent: buildEmailHtml(reportData)\n }, {\n headers: {\n 'api-key': Deno.env.get('BREVO_API_KEY'),\n 'Content-Type': 'application/json'\n }\n });\n results.email = true;\n } catch (e) {\n results.email = false;\n }\n }\n\n // Send SMS\n if (ceoPhone) {\n try {\n const cleaned = ceoPhone.startsWith('+') ? ceoPhone : '+' + ceoPhone;\n const message = `UNIPA ${todayStr}: Rev TZS ${fmt(totalRev)}, Profit TZS ${fmt(totalProfit)}. Alerts: ${lowStockAlerts.length} low stock, ${overdueCredits.length} overdue credits.`;\n const params = new URLSearchParams({\n username: Deno.env.get('AT_USERNAME') || 'unipaafrica',\n to: cleaned,\n message: message.slice(0, 160),\n from: 'UNIPA'\n });\n await axios.post('https://api.africastalking.com/version1/messaging', params.toString(), {\n headers: {\n apiKey: Deno.env.get('AT_API_KEY'),\n 'Content-Type': 'application/x-www-form-urlencoded',\n 'Accept': 'application/json'\n }\n });\n results.sms = true;\n } catch (e) {\n results.sms = false;\n }\n }\n\n return new Response(JSON.stringify({ success: true, results }), {\n headers: { 'Content-Type': 'application/json' }\n });\n}","label",[59],"pulls","branches","forks","envVars",{"_160":162,"_163":20},"connections",{"_160":20,"_161":20},"count","unfilledCount",3,"emptyCount",{"_28":144,"_13":59,"_57":58,"_38":-5,"_30":31,"_145":68,"_146":147,"_32":165,"_34":35,"_60":61,"_149":150,"_62":24,"_151":-5,"_166":167,"_121":168},["D",1781916359890],"children",[],[59],["D",1781916350844],{"_11":12,"_120":65},{"_11":12,"_115":116,"_64":65,"_25":63,"_117":118,"_119":24},{"_34":68,"_13":16,"_28":31,"_107":73,"_108":-5,"_109":-5,"_110":-5,"_111":-5,"_112":-5,"_113":14,"_114":12},"ctx",{"_46":-5,"_140":206,"_207":208,"_209":210,"_211":24,"_212":24,"_213":24,"_214":147,"_215":-5,"_216":-7,"_217":-7,"_218":20,"_219":24,"_220":24,"_221":-5,"_222":24,"_223":24,"_224":24,"_225":-5},"ENV",{"_177":178,"_179":180,"_181":16,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

History