Project overview

What is built, what is being built now, and what comes next. Live checks below talk to the real database, Cloudflare R2 and the phone app server on this computer.

49 of 54 listed items done

Database

44 tables

44 with row-level security

Photo storage (R2)

47 photos

38.7 MB · 13 orders

View photos →

Phone app server

Local only

Runs on the developer PC for testing with Expo Go

UI design

19 screens

Clickable design of every office and app screen

Open design canvas ↗

Phases

Phase 1

Specification + offline prototype

DoneTarget: 20 Nov – 4 Dec 2026

DoneDevelopment plan (revision 8, v1 scope frozen)
DoneSpecification Part 1: orders, QA, field app
DoneSpecification Part 2: billing, pricing, vendors, reports, subscription
DoneUI design: 15 office screens + 4 app screens
DoneField app: camera, GPS + mock-GPS flag, SHA-256, SQLite queue, retry
DoneUpload API: presigned R2 upload, server re-reads file to verify size + hash
DoneReal phone test: online + airplane mode (15 sent, 15 stored, 0 lost)
DeferredPhone tests 3–7 (kill mid-upload, 500 photos, weak network, background, mock GPS) — Before phase 4, on an EAS build

Phase 2

Multi-company foundation, office orders, work types, pricing, crew

In progressTarget: 8 Jan – 19 Feb 2027

DonePostgres + 11 tables (companies, users, memberships, vendors, clients, customers, work types, properties, work orders, history, photos)
DoneRow-level security on every table + 9 isolation tests
DoneOrder status rules from Spec §2 + 6 tests
DoneProject overview site (this page), PPHub theme, deployed to Vercel
DoneLogin (email + password), invite links, company switcher, separate login role + 5 tests
DoneOnline database (Neon, US East) for the live site; all 14 database tests pass on it
DoneField app uses real login; uploads create photo rows with QA flags + 12-step upload check
DoneSample work orders button (until the order screens exist)
DoneOffice: work order list (views, search, filters), new order, order detail, CSV import
DoneClients + customers, work types (starter set), vendors: directory with filters, add, CSV import/export, invite
DoneAssign contractor/crew on the order; phone shows only the vendor's or crew's orders + 8 checks
DoneVendor documents with expiry alerts, W-9 PDF fills vendor details, contractor fills own profile (My company)
DoneJob flow: phone My jobs + Send to office (server-confirmed), office Review queue, approve/follow-up, photo rules per work type, Home counts
DonePricing and billing: price catalog + rules, order lines, client invoice, contractor bill, payments, Billing page, profit per job
DoneCuts (can be passed to the contractor), chargebacks and write-offs with reasons; invoice PDF; AR/AP ageing; contractor My bills
DoneClient payment import (CSV/Excel with saved columns, PDF and email text), check matches, apply with cuts; pay terms per contractor
DoneClient credits from over-payments (used on the next invoice); contractor pay runs with CSV export and "client paid first" filter
DoneFull EIN/SSN and bank details encrypted (last 4 shown); owner and accountant can show the full numbers, every look and change logged; contractor owners enter their own
DoneEmail reminders for expiring documents: daily job at 30 days, 7 days and on the day; the contractor gets their list, owner and managers a summary; each stage sent once (needs Resend from the Vercel Marketplace)

Phase 3

Android app: jobs, metadata, offline, check-in

In progressTarget: 12 Mar – 28 May 2027

DoneMy jobs downloaded for offline, job screen, check-in/out with GPS and distance (client can require it before photos)
DonePhoto requirements per category, forms per work type (office form builder, offline answers, required before Send), Send to office
DoneProperties placed on the map (US Census lookup, or set by hand); photo checks: far from the property, before check-in, after check-out
DoneTasks with quantity done on the phone; bids with Bid photos (office prices, records sent and the client's answer; approved = new line); order and property notes
DoneClient bid PDF: client prices, numbered items, each bid's photos (kept in storage)
PlannedEAS builds, closed testing with contractors

Phase 4

Sync, QA, bids, forms, delivery, billing

In progressTarget: 21 May – 3 Sep 2027 · pilot 11 Jun – 1 Oct 2027

DoneQA review: per-photo accept (with reason) or ask for a new photo; Approve waits for every warning; client photo rules (gallery allowed, total minimum, fake GPS warn or block, future time)
DoneDelivery: photo package ZIP per client rules (size, header text, file names), manual delivery record, client accepted/rejected, To deliver list
DoneContractor portal on the web: My orders (tasks, own prices, notes, bids, photos, retakes), owner picks the crew per job; My bills
DoneOrder details: dates, loan # (masked), loan type, mortgagor, occupancy, lot size, encrypted access codes (shown on request, logged), client instructions from rules (office, phone, contractor web)
DoneEdit and duplicate orders; recurring orders: weekly to monthly, visit limit, cut-off; next visit made on approval with the same contractor; stop or make the next visit now
DonePayments: void with a reason (owner, accountant), closed orders reopen; client chargebacks on paid invoices (CB-…); who bears a cut or chargeback (contractor, company, split) with the contractor's part taken off their next bill; Cuts & chargebacks list

Phase 5

QuickBooks Online + 11 reports

In progressTarget: 30 Jul – 10 Dec 2027

Phase 6

SaaS admin, Stripe, storage controls

In progressTarget: Full v1: 27 Aug 2027 – mid Jan 2028

DoneSubscription page (owner): plan, trial days left, this month's active users and why each counts (signed in, or assigned an order), estimated bill, storage used; trial and non-payment rules
NextStripe (test mode): add payment method, monthly per-user billing, invoices, webhooks; read-only and suspension enforced
DoneSaaS admin (/admin, PPHub staff only): every company with status, trial end, active users, seats, orders, storage, last activity; activate as pilot, extend trial; admin log
DoneFull download (owner): every table as CSV + documents, then photos in ZIPs of about 1 GB, built in the background; cancel (type the name) with a 30-day look-and-download window and undo
PlannedDeleting cancelled companies after the window; admin screen redesign

Database tables

Every table is locked to one company by Postgres row-level security. The app cannot read or change another company's rows even if a query forgets to filter.

Table	Columns	Row-level security	Policies
accounts	0	On	1
adjustment_batches	11	On	1
adjustments	16	On	1
admin_actions	0	On	1
bids	22	On	1
bills	13	On	1
client_credits	10	On	1
clients	18	On	1
companies	12	On	2
company_exports	8	On	1
company_profiles	13	On	1
customers	4	On	1
deliveries	15	On	1
doc_reminders	7	On	1
expenses	16	On	1
form_answers	9	On	1
forms	9	On	1
instructions	9	On	1
invites	10	On	2
invoices	12	On	1
member_activity	4	On	1
memberships	8	On	2
notes	11	On	1
order_lines	15	On	1
order_series	9	On	1
pay_runs	8	On	1
payment_imports	18	On	1
payments	17	On	1
photos	28	On	1
price_items	10	On	1
price_rules	9	On	1
properties	12	On	1
report_exports	12	On	1
saved_report_views	9	On	1
sessions	0	On	1
users	7	On	2
vendor_documents	12	On	1
vendor_secret_log	6	On	1
vendors	28	On	1
verifications	0	On	1
visits	11	On	1
work_order_events	10	On	1
work_orders	32	On	1
work_types	7	On	1