/* Winst-overzicht: totaal, per platform, per product. Exported to window. */ function dedupeChannels(p, db) { const raw = (p.channels && p.channels.length) ? p.channels : db.PLATFORMS.map(pf => ({ name: pf.name, price: p.prices[pf.id] })); const byName = {}; for (const c of raw) { if (c.price == null) { if (!byName[c.name]) byName[c.name] = { name: c.name, price: null, stock: 0 }; continue; } const stock = c.stock != null ? c.stock : 0; const cur = byName[c.name]; if (!cur || cur.price == null || stock > (cur.stock || 0) || (stock === (cur.stock || 0) && c.price > cur.price)) { byName[c.name] = { name: c.name, price: c.price, stock }; } } return byName; } function Winst({ db, onNav }) { const pt = db.profitTax(); const [costOpen, setCostOpen] = React.useState(false); const period = db.period(); const perLabel = (db.PERIODS.find(x => x.id === period) || {}).label || "30 dagen"; const info = (p) => db.periodOf(p, period) || { q: 0, rev: 0, ch: {} }; const available = !db.products.some(p => db.periodOf(p, period) == null) && (period !== "yesterday" || db.products.some(p => p.periods && p.periods.yesterday)); const withCost = db.products.filter(p => db.effCost(p) != null && info(p).q > 0); const zonderCost = db.products.filter(p => db.effCost(p) == null && info(p).q > 0); // totalen (echte orderbedragen) + winst over producten met inkoopprijs const omzetTotal = db.products.reduce((s, p) => s + info(p).rev, 0); let winstProduct = 0; withCost.forEach(p => { const w = db.winstInfo(p, info(p)); if (w) winstProduct += w.voor; }); // Maxeda vaste maandbijdrage (€38/mnd), geschaald naar de gekozen periode const PERIOD_DAYS = { today: 1, yesterday: 1, d7: 7, d30: 30, d90: 90, d180: 180, d365: 365 }; const periodDays = PERIOD_DAYS[period] || 30; const maxedaMonthly = window.STORE.maxedaMonthly ? window.STORE.maxedaMonthly() : 0; const maxedaFee = maxedaMonthly * (periodDays / 30.44); // advertentiekosten (bol Ads) — aftrekbaar VÓÓR de winstbelasting const adCost = (available && db.adsHasData && db.adsHasData()) ? (db.adsTotal(period) || 0) : 0; const gadCost = (available && db.gadsHasData && db.gadsHasData()) ? (db.gadsTotal(period) || 0) : 0; // terugbetaalde retouren — ook vóór belasting verrekend const retImpact = (available && db.returnsImpact) ? db.returnsImpact(period) : { cost: 0, count: 0, qty: 0 }; const retCost = retImpact.cost || 0; const fulfilPer = (window.STORE && window.STORE.fulfilmentPerOrder) ? window.STORE.fulfilmentPerOrder() : 0; const amperePer = (window.STORE && window.STORE.amperePerDay) ? window.STORE.amperePerDay() : 0; // Ampere haalt alleen op ma t/m vr — tel de werkdagen in de gekozen periode const countWeekdays = (n) => { let c = 0; const t = new Date(); for (let i = 0; i < n; i++) { const d = new Date(t.getFullYear(), t.getMonth(), t.getDate() - i); const wd = d.getDay(); if (wd >= 1 && wd <= 5) c++; } return c; }; const isWeekday = (back) => { const t = new Date(); const d = new Date(t.getFullYear(), t.getMonth(), t.getDate() - back); const wd = d.getDay(); return wd >= 1 && wd <= 5; }; let ampereDays; if (period === "today") ampereDays = isWeekday(0) ? 1 : 0; else if (period === "yesterday") ampereDays = isWeekday(1) ? 1 : 0; else ampereDays = countWeekdays(periodDays); const ampereCost = +(amperePer * ampereDays).toFixed(2); const realOrders = available && db.ordersIn ? db.ordersIn(period) : null; const orderEst = realOrders ? realOrders.o : (available ? db.products.reduce((s, p) => { const q = (db.periodOf(p, period) || {}).q || 0; return s + Math.ceil(q / Math.max(1, +p.perPackage || 1)); }, 0) : 0); const fulfilCost = +(fulfilPer * orderEst).toFixed(2); const winstVoor = winstProduct - maxedaFee - adCost - gadCost - retCost - fulfilCost - ampereCost; const winstNa = winstVoor > 0 ? winstVoor * (1 - pt / 100) : winstVoor; // Dagdoel: €200 winst na belasting VANDAAG (altijd op vandaag gebaseerd, los van de gekozen periode) const DAY_GOAL = 200; const showGoal = period === "today" || period === "yesterday"; const isYesterday = period === "yesterday"; let dayVoorProd = 0; if (showGoal) db.products.forEach(p => { if (db.effCost(p) == null) return; const di = db.periodOf(p, period); if (!di || !(di.q > 0)) return; const w = db.winstInfo(p, di); if (w) dayVoorProd += w.voor; }); const dayAdCost = (showGoal && db.adsHasData && db.adsHasData()) ? (db.adsTotal(period) || 0) : 0; const dayGad = (showGoal && db.gadsHasData && db.gadsHasData()) ? (db.gadsTotal(period) || 0) : 0; const dayRet = (showGoal && db.returnsImpact) ? (db.returnsImpact(period).cost || 0) : 0; const dayOrders = showGoal ? (realOrders ? realOrders.o : db.products.reduce((s, p) => { const q = (db.periodOf(p, period) || {}).q || 0; return s + Math.ceil(q / Math.max(1, +p.perPackage || 1)); }, 0)) : 0; const dayVoor = dayVoorProd - maxedaMonthly * (1 / 30.44) - dayAdCost - dayGad - dayRet - (fulfilPer * dayOrders) - (ampereDays > 0 ? amperePer : 0); const dayNa = dayVoor > 0 ? dayVoor * (1 - pt / 100) : dayVoor; const goalValue = Math.max(0, dayNa); const goalPct = Math.max(0, Math.min(1, goalValue / DAY_GOAL)); const goalDone = showGoal && goalValue >= DAY_GOAL; const goalHue = Math.round(8 + (148 - 8) * goalPct); // rood → groen naarmate de balk vult const goalColor = goalDone ? "#10c267" : `hsl(${goalHue} 70% 45%)`; const goalRef = React.useRef(); const gkD = new Date(Date.now() - (isYesterday ? 86400000 : 0)); const goalKey = "goal:" + period + ":" + gkD.getFullYear() + "-" + String(gkD.getMonth() + 1).padStart(2, "0") + "-" + String(gkD.getDate()).padStart(2, "0"); React.useEffect(() => { if (goalDone && goalRef.current) window.celebrate(goalRef.current, goalKey); }, [goalDone, goalKey]); // kostenopbouw (optelsom over producten met inkoopprijs) const cost = { netto: 0, btw: 0, inkoop: 0, verzending: 0, platform: 0 }; withCost.forEach(p => { const b = db.costParts(p, info(p)); if (!b) return; cost.netto += b.netto; cost.btw += b.btw; cost.inkoop += b.inkoop; cost.verzending += b.verzending; cost.platform += b.platform; }); const omzetWithCost = cost.netto + cost.btw; const costRows = [ { label: "Inkoop (inkoopprijs × aantal)", val: cost.inkoop, icon: "tag" }, { label: "Verzendkosten", val: cost.verzending, icon: "truck" }, { label: "Platform-kosten (bol + Maxeda)", val: cost.platform, icon: "plug" }, { label: "Maxeda maandbijdrage", val: maxedaFee, icon: "euro" }, ]; if (adCost > 0) costRows.push({ label: "Advertentiekosten (bol Ads)", val: adCost, icon: "trending" }); if (gadCost > 0) costRows.push({ label: "Advertentiekosten (Google Ads)", val: gadCost, icon: "search2" }); if (retCost > 0) costRows.push({ label: "Retouren (terugbetaald, " + retImpact.count + "×)", val: retCost, icon: "truck" }); if (fulfilCost > 0) costRows.push({ label: "Fulfilment (" + orderEst + " bestellingen" + (realOrders && realOrders.est ? ", deels geschat" : "") + " × " + fmtEur(fulfilPer) + ")", val: fulfilCost, icon: "boxes" }); if (ampereCost > 0) costRows.push({ label: "Ophaalservice Ampere (" + ampereDays + (ampereDays === 1 ? " werkdag" : " werkdagen") + " × " + fmtEur(amperePer) + ")", val: ampereCost, icon: "truck" }); const kostenTotaal = cost.inkoop + cost.verzending + cost.platform + maxedaFee + adCost + gadCost + retCost + fulfilCost + ampereCost; // per platform (benadering: verkochte aantallen × huidige kanaalprijs) const plat = {}; withCost.forEach(p => { const chans = dedupeChannels(p, db); const byCh = info(p).ch || {}; Object.keys(byCh).forEach(name => { const units = byCh[name]; if (!units) return; const price = (chans[name] && chans[name].price) || p.prices.web || 0; const unitWinst = db.winstPer(p, price, name); const e = plat[name] = plat[name] || { name, units: 0, omzet: 0, winst: 0 }; e.units += units; e.omzet += price * units; if (unitWinst != null) e.winst += unitWinst * units; }); }); const platforms = Object.values(plat).sort((a, b) => b.winst - a.winst); const maxWinst = Math.max(1, ...platforms.map(p => Math.abs(p.winst))); return (

Winst

Omzet, kosten en winst · {perLabel.toLowerCase()}. BTW {db.vat()}%{pt > 0 ? ` · winstbelasting ${pt}%` : ""}.
{db.PERIODS.map(per => ( ))}
{showGoal && (
{goalDone ? "🎉 Dagdoel gehaald — feest!" : (isYesterday ? "Dagdoel gisteren · winst na belasting" : "Dagdoel · winst na belasting")}
{goalDone ? (isYesterday ? "Top team! Gisteren " + fmtEur(Math.round(goalValue)) + " winst na belasting gehaald." : "Top team! Vandaag al " + fmtEur(Math.round(goalValue)) + " winst na belasting binnen.") : (isYesterday ? "Het dagdoel voor gisteren was " + fmtEur(DAY_GOAL) + " winst na belasting." : "Samen elke dag op naar " + fmtEur(DAY_GOAL) + " winst na belasting.")}
{fmtEur(Math.round(goalValue))} / {fmtEur(DAY_GOAL)}
{goalDone ? "Doel bereikt 💪" : (goalValue > 0 ? fmtEur(Math.round(DAY_GOAL - goalValue)) + (isYesterday ? " onder doel" : " te gaan") : (isYesterday ? "Geen winst geregistreerd" : "Nog te starten vandaag"))} {Math.round(goalPct * 100)}%
)} {!available && (
Deze periode is nog niet beschikbaar
Werk de datakraan bij naar de nieuwste versie; daarna bouwt de geschiedenis (3/6/12 maanden) zich automatisch op.
)}
0 ? "Winst (vóór belasting)" : "Winst · " + perLabel.toLowerCase()} value={available ? fmtEur(Math.round(winstVoor)) : "—"} foot={"na btw, inkoop, verzending, platform" + (adCost > 0 ? ", advertenties" : "") + (retCost > 0 ? ", retouren" : "") + (fulfilCost > 0 ? ", fulfilment" : "") + (ampereCost > 0 ? ", ophaalservice" : "")} /> 0 ? "Winst na belasting" : "Nettomarge"} value={pt > 0 ? (available ? fmtEur(Math.round(winstNa)) : "—") : (omzetTotal > 0 ? Math.round(winstVoor / omzetTotal * 100) + "%" : "—")} foot={pt > 0 ? `na ${pt}% winstbelasting` : "winst ÷ omzet"} /> 0 ? Math.round((pt > 0 ? winstNa : winstVoor) / omzetTotal * 100) + "%" : "—"} foot={`over ${withCost.length} producten met inkoop`} />
{maxedaMonthly > 0 && available && (
Inclusief Maxeda-maandbijdrage {fmtEur(maxedaMonthly, 0)}/mnd (≈ {fmtEur(maxedaFee, 2)} over {perLabel.toLowerCase()}), afgetrokken van de totale winst. Aanpasbaar bij Instellingen → Kosten & verzending.
)} {zonderCost.length > 0 && (
{zonderCost.length} verkopende producten zonder inkoopprijs
Hun winst telt nog niet mee. Vul de inkoopprijs in op de productpagina: {zonderCost.map(p => p.sku).join(", ")}.
)} {available && withCost.length > 0 && ( {costOpen && (
Omzet (incl. btw){fmtEur(Math.round(omzetWithCost))}
− btw ({db.vat()}%)−{fmtEur(Math.round(cost.btw))}
Netto-omzet{fmtEur(Math.round(cost.netto))}
{costRows.map(r => (
− {r.label}−{fmtEur(Math.round(r.val))}
))}
Totale kosten−{fmtEur(Math.round(kostenTotaal))}
{period === "today" && adCost === 0 && gadCost === 0 && (db.adsHasData && db.adsHasData() || db.gadsHasData && db.gadsHasData()) && (
Advertentiekosten van vandaag komen met vertraging binnen (bol & Google werken 's nachts bij) — die zie je morgen terug.
)}
{pt > 0 ? "Winst (vóór belasting)" : "Winst"}= 0 ? "var(--ok)" : "var(--danger)" }}>{fmtEur(Math.round(winstVoor))}
{pt > 0 &&
− winstbelasting ({pt}%)−{fmtEur(Math.round(winstVoor - winstNa))}
} {pt > 0 &&
Winst na belasting{fmtEur(Math.round(winstNa))}
}
)} )}
{platforms.length === 0 && } {platforms.map(pl => { const marge = pl.omzet > 0 ? Math.round(pl.winst / pl.omzet * 100) : 0; return (
{pl.name} {pl.units} st · {fmtEur(pl.omzet)} = 0 ? "ok" : "danger")} style={{ minWidth: 92, justifyContent: "center" }}>{fmtEur(Math.round(pl.winst))} · {marge}%
= 0 ? "var(--ok)" : "var(--danger)" }} />
); })}
{withCost.map(p => { const inf = info(p); const w = db.winstInfo(p, inf); if (!w) return null; const val = pt > 0 ? w.na : w.voor; const marge = inf.rev > 0 ? Math.round(val / inf.rev * 100) : 0; return { p, val, marge }; }).filter(Boolean).sort((a, b) => b.marge - a.marge).map(({ p, val, marge }) => ( onNav("producten", p.id)}> ))}
ProductWinstMarge
{p.name}
 = 0 ? "var(--ok)" : "var(--danger)" }}>{fmtEur(Math.round(val))} = 0 ? "ok" : "danger")} style={{ minWidth: 48, justifyContent: "center" }}>{marge}%
); } window.Winst = Winst;