How soraou/mogpog-waterworks works
Mogpog Waterworks is a mobile water-utility app for managing barangays, subscriber accounts, monthly meter readings and bills. Staff browse or search accounts, record readings and review account history or receipts; they can also import the official Excel workbook and export workbook data. SQLite backs the operational records and settings, while shared billing logic computes charges. The graph follows documented imports and sampled call sites; several screen and database details are only partially excerpted, so uncertain links are omitted.
Main entry points: queries.ts Record queries · index.tsx Account search · billing.ts Tariff calculations · [id].tsx Account details
Components 25
Utility workflows
- Account search
app/(tabs)/index.tsx - Account details
app/account/[id].tsx - Add account
app/account/add.tsx - Barangay details
app/barangay/[id].tsx - Meter reading
app/reading/[id].tsx - Receipt view
app/receipt/[id].tsx - Settings
app/settings/index.tsx - Account row
components/AccountRow.tsx - Barangay row
components/BarangayRow.tsx - Status indicator
components/StatusDot.tsx - Receipt layout
components/Receipt.tsx - Theme constants
constants/theme.ts
Local records
- SQLite database
db/schema.ts - Record queries
db/queries.ts - Import application
db/officialImport.ts
Billing logic
- Tariff calculations
lib/billing.ts
Workbook exchange
- Workbook import screen
app/(tabs)/import.tsx - Workbook export screen
app/(tabs)/export.tsx - Workbook parser
excel/importParser.ts - Import planner
excel/importPlan.ts - Workbook format rules
excel/format.ts - Base64 conversion
excel/base64.ts - Workbook exporter
excel/exportWorkbook.ts - Workbook template
excel/templateSkeleton.ts
Other components
- Utility staff
Connections 46
- Utility staff → Account search: browses
- Account search → Record queries: searches accounts
app/(tabs)/index.tsx - Account search → Account row: renders
app/(tabs)/index.tsx - Account search → Barangay row: renders
app/(tabs)/index.tsx - Account row → Status indicator: renders
components/AccountRow.tsx - Account search → Account details: opens account
app/(tabs)/index.tsx - Utility staff → Meter reading: records reading
- Account details → Record queries: loads and updates
app/account/[id].tsx - Meter reading → Record queries: reads and saves
app/reading/[id].tsx - Meter reading → Tariff calculations: calculates charges
app/reading/[id].tsx - Account details → Tariff calculations: shows bill status
app/account/[id].tsx - Account details → Receipt view: opens receipt
- Receipt view → Record queries: loads receipt data
app/receipt/[id].tsx - Receipt view → Tariff calculations: uses bill logic
app/receipt/[id].tsx - Receipt view → Receipt layout: renders
app/receipt/[id].tsx - Utility staff → Add account: adds account
- Add account → Record queries: saves account
app/account/add.tsx - Barangay details → Record queries: loads accounts
app/barangay/[id].tsx - Settings → Record queries: reads settings
app/settings/index.tsx - Record queries → SQLite database: reads and writes
db/queries.ts - Record queries → Tariff calculations: derives bill status
db/queries.ts - Utility staff → Workbook import screen: imports workbook
- Workbook import screen → Workbook parser: parses workbook
app/(tabs)/import.tsx - Workbook import screen → Import planner: builds import plan
app/(tabs)/import.tsx - Workbook import screen → Import application: applies import
app/(tabs)/import.tsx - Workbook parser → Base64 conversion: decodes bytes
excel/importParser.ts - Workbook parser → Workbook format rules: normalizes cells
excel/importParser.ts - Import planner → Workbook parser: uses parsed data
excel/importPlan.ts - Import planner → Workbook format rules: uses format rules
excel/importPlan.ts - Import application → SQLite database: writes imported records
db/officialImport.ts - Import application → Workbook format rules: normalizes values
db/officialImport.ts - Import application → Tariff calculations: checks bill status
db/officialImport.ts - Utility staff → Workbook export screen: exports workbook
- Workbook export screen → Record queries: loads records
app/(tabs)/export.tsx - Workbook export screen → Workbook exporter: creates workbook
app/(tabs)/export.tsx - Workbook export screen → Base64 conversion: encodes file
app/(tabs)/export.tsx - Workbook exporter → Record queries: reads export data
excel/exportWorkbook.ts - Workbook exporter → Workbook format rules: formats workbook
excel/exportWorkbook.ts - Workbook exporter → Base64 conversion: encodes workbook
excel/exportWorkbook.ts - Workbook exporter → Workbook template: uses template
excel/exportWorkbook.ts - Workbook format rules → Tariff calculations: calculates workbook amounts
excel/format.ts - Account search → Theme constants: uses styling
app/(tabs)/index.tsx - Account details → Theme constants: uses styling
app/account/[id].tsx - Account row → Theme constants: uses styling
components/AccountRow.tsx - Barangay row → Theme constants: uses styling
components/BarangayRow.tsx - Status indicator → Theme constants: uses styling
components/StatusDot.tsx