Handoff
Architecture & readiness
This page summarizes the repository’s README.md and HANDOFF.md. This preview contains a redesigned public website (Home, Services, Work, About, Contact) with the client portal integrated behind Client Login. The current Squarespace site and domain were not modified; nothing is published.
Sandbox demo · /demo
- Fictional people & projects (Harbor House, City Retreat, Fernwood Lane).
- Stored only in this browser (localStorage + IndexedDB for files).
- Identity switcher is not authentication; it cannot reach live data.
- Same rules as live (version check, option ownership, membership) enforced in code.
- “Reset demo” restores the original seed.
Live portal · /portal
- Invite-only email/password accounts; no public sign-up or role selection.
- Roles in server-maintained
user_roles; access byproject_members. - Postgres RLS on every table; decisions only via transactional RPC with version check.
- Private bucket; uploads via server function (signature + size checks); 60 s signed downloads.
- Starts empty — no demo data is ever written to the live database.
Access matrix
| Action | Anonymous | Client A | Client B on A’s project | Admin |
|---|---|---|---|---|
| Read projects / rooms / boards / milestones | — | Own assigned only | Other projects: no | All |
| Read draft selections & draft invoices | — | No | No | All |
| Create / edit projects, rooms, boards, milestones, options | — | No | No | Yes |
| Publish / request approval | — | No | No | Yes (RPC) |
| Approve / request changes | — | Own project, awaiting, current version (RPC) | No | No (client decision only) |
| Comment | — | Own project, as self | No | Yes, as self |
| Upload document | — | Own project (server fn) | No | Yes (server fn) |
| Download document (60s signed URL) | — | Own project | No | All |
| Delete document | — | Own uploads | No | Yes |
| Grant / revoke client access | — | No | No | Yes (invited accounts) |
| Change roles (user_roles) | — | No | No | No — SQL/owner only |
| Edit decision history | — | No | No | No (immutable) |
Readiness checklist
- Lovable Cloud backend provisioned; schema, RLS, RPCs, triggers and private bucket applied
- Public sign-up disabled; email/password sign-in enabled; leaked-password check on
- Database RLS/RPC suite executed: 36/36 checks passed (see HANDOFF.md → Test evidence)
- Unit tests for upload validation, decision rules and sandbox workflow
- Invite the first studio user (Cloud → Users) and bootstrap admin with the documented SQLowner action
- Invite real clients, then grant project access by email in each projectowner action
- Run a signed-in end-to-end pass with two real test clients + admin (checklist in HANDOFF.md)owner action
- Configure custom domain + auth redirect URLs before publishingowner action
- Customize auth emails (invite, reset) with studio brandingowner action
- Add malware scanning for uploads before accepting files from the publicowner action
- Public website pages with exact current logo bundled locally (source + checksum in HANDOFF.md)
- Contact composer opens a mailto draft only — no server delivery, no stored inquiries
- Public copy migrated verbatim from the current site (provenance in docs/content-provenance.md)
- Approve the few new navigation/label strings listed in docs/content-provenance.mdowner action
- 39 owner-authorized photos migrated into the app (galleries + lightbox); manifest in docs/portfolio-assets.md
- Review photo alt text, portraits, and which project the featured kitchen photo belongs toowner action
- Before DNS cutover: redirect /residential → /work/michigan-farmhouse, /commercial → /work/chicago-projects, /experiential → /about; keep Squarespace as rollbackowner action
- Payments / billing — intentionally not implemented (demo invoices only)
Known limitations
- No malware scanning of uploads yet (type is verified by file signature, size ≤ 10 MB). Mitigation in HANDOFF.md.
- No payments, Stripe, or outgoing app email. Invoices are demo records labeled non-payable.
- Signed-in browser end-to-end tests against live accounts were not run (no real test accounts exist yet).
- Logo and portfolio photos are the studio’s own files (owner-confirmed), bundled unaltered with resized web copies. The Squarespace CDN serves Chicago photos at most 2500 px wide, so ask the owner for the camera originals if larger prints are needed.
- No form backend or email provider: inquiries rely on the visitor’s email app.