[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_153":154,"_155":156},"routes/_app.x.$handle.$name",{"_94":93,"_32":45,"_103":84,"_27":36,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":25,"_117":118,"_119":25,"_120":-5,"_121":-5,"_122":123},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":25},"version",2,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","62a2b202-6c41-11f1-a9b8-1607ee4eb77e","name","fileType","script","content","","// Daily Report – Val Town version (full)\nimport axios from \"npm:axios\";\nimport admin from \"npm:firebase-admin\";\n\nif (!admin.apps.length) {\n const serviceAccount = JSON.parse(Deno.env.get(\"FIREBASE_SERVICE_ACCOUNT\"));\n admin.initializeApp({\n credential: admin.credential.cert(serviceAccount)\n });\n}\n\nconst db = admin.firestore();\n\nasync function getSystemData() {\n const doc = await db.collection(\"unipa_system\").doc(\"liveData\").get();\n return doc.exists ? doc.data() : null;\n}\n\nfunction fmt(n) { return Number(n||0).toLocaleString(); }\n\nfunction buildEmailHtml(data) {\n const branchRows = Object.values(data.branchSummary).map(b =>\n `${b.name}\n ${b.salesCount}\n TZS ${fmt(b.revenue)}\n TZS ${fmt(b.profit)}\n TZS ${fmt(b.expenses)}`\n ).join('');\n\n const lowHtml = data.lowStockAlerts.length\n ? `

\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}","createdAt",["D",1781916359890],"branchVersion","branchId","48518495-ffef-4a92-8f8d-c7e90108e7f1","id","dc52cc51-fbdb-4ffa-9dcc-0d4a96393133","triggerDailyReport",["D",1781916350844],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Daily report notification thing","imageUrl","1fe3884c-e6ec-4e4e-880e-70b585101b5d","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019ee262-5a04-7489-ba6a-1b40d54480f7","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_94":93,"_102":98},"org",{"_94":93,"_95":96,"_97":98,"_18":55,"_99":100,"_101":25},"branch",{"_13":14,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","destiny_designs","handle","displayName","Brian Francis","avatar","https://lh3.googleusercontent.com/a/ACg8ocIRM1-J7HK4fNMriAGv7uXM77DmSnEDfU1gpUuiRO4rKCa_XWp2=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":149,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":150,"_79":151,"_81":152,"_83":25},"tree",[144],"files",[144],"counts",{"_133":61,"_134":130,"_135":61,"_136":137,"_138":139},"contents",[124],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":125,"_32":28,"_30":31,"_126":-5,"_41":42,"_40":14,"_127":128,"_38":129,"_13":130,"_33":34,"_35":37,"_24":25,"_131":-5,"_27":132},"6f86a707-d55b-4dd2-a5fb-9356f6c78884","parentId","latest",true,["D",1781916359890],1,"label",[28],"pulls","branches","forks","envVars",{"_140":142,"_143":61},"connections",{"_140":61,"_141":61},"count","unfilledCount",3,"emptyCount",{"_43":125,"_32":28,"_30":31,"_126":-5,"_41":42,"_40":14,"_127":128,"_38":145,"_13":130,"_33":34,"_35":37,"_24":25,"_131":-5,"_146":147,"_27":148},["D",1781916359890],"children",[],[28],["D",1781916350844],{"_94":93,"_102":98},{"_94":93,"_95":96,"_97":98,"_18":55,"_99":100,"_101":25},{"_13":14,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"ctx",{"_77":-5,"_121":186,"_187":188,"_189":190,"_191":25,"_192":25,"_193":25,"_194":128,"_195":-5,"_196":-7,"_197":-7,"_198":61,"_199":25,"_200":25,"_201":-5,"_202":25,"_203":25,"_204":25,"_205":-5},"ENV",{"_157":158,"_159":160,"_161":84,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185},"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"]

Diff · v2