[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_154":155,"_156":157},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_117":-5,"_20":118,"_22":119,"_120":121,"_122":123,"_25":124,"_24":-5,"_125":-5,"_126":-5,"_127":53,"_128":129,"_130":53,"_131":-5,"_132":-5,"_133":134},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","destiny_designs","name","triggerDailyReport","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":69,"_70":-5,"_71":72,"_73":-5,"_74":53,"_75":-5,"_76":-5,"_77":78,"_79":80,"_81":-5,"_82":-5,"_83":-5,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":95,"_96":97,"_98":99,"_100":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","6f86a707-d55b-4dd2-a5fb-9356f6c78884","main.ts","fileId","62a2b202-6c41-11f1-a9b8-1607ee4eb77e","parentId","branchId","48518495-ffef-4a92-8f8d-c7e90108e7f1","branchVersion",2,"latest",true,"createdAt",["D",1781916359890],1,"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}","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1781916359890],"children",[],[35],"dc52cc51-fbdb-4ffa-9dcc-0d4a96393133",["D",1781916350844],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Daily report notification thing","imageUrl","userId","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",{"_11":12,"_116":112},"org",{"_11":12,"_109":110,"_111":112,"_71":72,"_113":114,"_115":53},"branch",{"_17":42,"_13":16,"_33":40,"_101":61,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":14,"_108":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Brian Francis","avatar","https://lh3.googleusercontent.com/a/ACg8ocIRM1-J7HK4fNMriAGv7uXM77DmSnEDfU1gpUuiRO4rKCa_XWp2=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":150,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":69,"_70":-5,"_71":72,"_73":-5,"_74":53,"_75":-5,"_76":-5,"_77":78,"_79":80,"_81":-5,"_82":-5,"_83":-5,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":151,"_96":152,"_98":153,"_100":53},[147],"files",[147],"counts",{"_137":78,"_138":47,"_139":78,"_31":140,"_141":142},[135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":136},[35],"pulls","branches","forks",{"_143":145,"_146":78},"connections",{"_143":78,"_144":78},"count","unfilledCount",3,"emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":148,"_18":149},[],[35],["D",1781916350844],{"_11":12,"_116":112},{"_11":12,"_109":110,"_111":112,"_71":72,"_113":114,"_115":53},{"_17":42,"_13":16,"_33":40,"_101":61,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":14,"_108":12},"ctx",{"_94":-5,"_132":187,"_188":189,"_190":191,"_192":53,"_193":53,"_194":53,"_195":44,"_196":-5,"_197":-7,"_198":-7,"_199":78,"_200":53,"_201":53,"_202":-5,"_203":53,"_204":53,"_205":53,"_206":-5},"ENV",{"_158":159,"_160":161,"_162":16,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186},"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"]

Code