How isahilmishra/userpayout-affiliate works
This is an Express backend for affiliate sales payouts. Its API accepts and lists sales, reconciles pending sales as approved or rejected, issues advances, and serves ledger-derived balances and withdrawal operations. Financial events are recorded in an append-only ledger backed by SQLite transactions and constraints; the README also documents race-safe advance issuance and the atomic 24-hour withdrawal rule. The route, service, and database call paths are visible in sampled files; no separate advance-job HTTP trigger is shown.
Main entry points: database.js SQLite Database · app.js Express App · sales.js Sales API · AdvancePayoutService.js Advance Payout
Components 13
HTTP API
- Express App
src/app.js - Sales API
src/routes/sales.js - Payout API
src/routes/payouts.js - Balance API
src/routes/balance.js - Withdrawal API
src/routes/withdrawals.js
Payout Lifecycle
- Advance Payout
src/services/AdvancePayoutService.js - Sale Reconciliation
src/services/ReconciliationService.js - Ledger Queries
src/services/LedgerService.js - Withdrawal Rules
src/services/WithdrawalService.js
Financial Storage
- SQLite Database
src/db/database.js - Financial Schema
src/db/schema.sql - Payout Constants
src/config/constants.js
Other components
- Calling System
Connections 17
- Calling System → Express App: sends requests
README.md - Express App → Sales API: mounts routes
src/app.js - Express App → Payout API: mounts routes
src/app.js - Express App → Balance API: mounts routes
src/app.js - Express App → Withdrawal API: mounts routes
src/app.js - Sales API → SQLite Database: writes sales
src/routes/sales.js - Sales API → Sale Reconciliation: reconciles sales
src/routes/sales.js - Payout API → Advance Payout: runs advance job
src/routes/payouts.js - Balance API → Ledger Queries: queries balances
src/routes/balance.js - Withdrawal API → Withdrawal Rules: handles requests
src/routes/withdrawals.js - Advance Payout → SQLite Database: records advances
src/services/AdvancePayoutService.js - Advance Payout → Payout Constants: uses advance rate
src/services/AdvancePayoutService.js - Sale Reconciliation → SQLite Database: updates sales and ledger
src/services/ReconciliationService.js - Ledger Queries → SQLite Database: reads ledger
src/services/LedgerService.js - Withdrawal Rules → SQLite Database: records withdrawals
src/services/WithdrawalService.js - Withdrawal Rules → Payout Constants: uses cooldown
src/services/WithdrawalService.js - SQLite Database → Financial Schema: initializes schema
src/db/database.js