BuildOperations Ops
Active Jobs & Live Job Sites
Live residential renovation sites under construction across Greater Riverton.
Active Production Stage-Gate Kanban
Multi-Week Trade Gantt & Capacity Planner
| Project & Client | Location & GPS | Team Lead | Production Stage | Material Spend & Receipts | Latest Field Note | Field Actions |
|---|
Financials & Labor Approvals
Portfolio revenue, material spend, gross profit margins, and centralized subcontractor timesheet approvals across all projects.
Subcontractor Timesheet & Shift Approvals Inbox
Global Multi-Site Inbox — Single-spot review across all jobsites. Approved hours automatically post to individual Project Ledgers and roll into Job Costing.
| Date & Time | Subcontractor | Project & Location | Hours / Rate | Labor Cost | Work Notes & Scope | Status | Owner Review |
|---|
Job-by-Job Profitability Matrix
0 JobsReal-time roll-up of contract budget vs. actual approved labor and materials incurred per jobsite.
Subcontractor 1099-NEC Annual Tax Report
Cumulative non-employee compensation across all projects. Highlights payees meeting or exceeding the IRS ≥$600 reporting threshold.
| Subcontractor / Trade | Tax Entity Classification | Tax ID (EIN / SSN) | Form W-9 | Total Paid (2026) | IRS 1099 Status | Actions |
|---|
Owner Business Mileage Log & Tax Deductions
Contemporaneous trip records logged across project Daily Field Logs. Calculated at the IRS standard business mileage rate of $0.67/mile for Alex & Sam.
| Date & Time | Project & Jobsite | Driver | Trip Purpose & Route | Miles Driven | Tax Deduction ($0.67) | Actions |
|---|
Media Management Hub
Cloud photo & video storage, mobile bulk uploads, staging review, and live website portfolio gallery
Upload Job Photos & Walkthrough Videos
Select 1 or multiple photos & videos directly from your Android phone gallery, iPhone, or computer. Photos are compressed into fast WebP and staged for portfolio showcase.
Live Portfolio Gallery Items
Changes show up immediately on the public galleryClient Directory & Lifetime Records
Consolidated homeowner profiles, lifetime project history, and customer base management.
Google Review Pipeline
Every completed project should end in a public review. One ask, up to two gentle follow-ups, then stop — never badger a homeowner.
| Homeowner / Client | Direct Contact | Property / Neighborhood | Household Projects | Relationship Status | Assigned Estimator | Quick Actions |
|---|---|---|---|---|---|---|
| Loading client directory... | ||||||
Labor & Trade Directory
Manage internal crew, trade partners, installers, material suppliers, cleaners, and project specialists.
| Vendor / Payee | Worker Type | Crew PIN / Rate | W-9 & Tax ID (1099-NEC) | Categories | Direct Contact | Notes | Status | Actions |
|---|---|---|---|---|---|---|---|---|
| Loading vendor directory... | ||||||||
Customer Inquiries & Intake Pipeline
Manage incoming inquiries, consultations, walkthrough bookings, and estimating pipeline.
| Date ⇅ | Customer & Household ⇅ | Phone & Preferred Time ⇅ | Project & Budget ⇅ | Status / Pipeline ⇅ | Walkthrough & Booking ⇅ | Actions | ||
|---|---|---|---|---|---|---|---|---|
| No leads yet. Submit the Estimate form to test! | ||||||||
September 2026
Chronological Walkthrough Agenda & Neighborhood Routing Radar
Optimized for contractor driving routes across RivertonLive Visitor Intelligence & Geolocation Traffic Radar
Private real-time traffic feed showing who is visiting the website, their city/state, device, and page viewed.| Visitor & Recency | Location (Market & Zip) | Device & Traffic Source | Journey Breadcrumbs | Intent Score | Action |
|---|---|---|---|---|---|
| Loading live visitor telemetry... | |||||
Super Admin & Agency Suite
Private developer command center: Pipeline ROI, live announcement broadcaster, email diagnostics, and system backups.Estimated economic value generated for BuildOperations via website inquiries.
Broadcast an urgent booking notice, schedule update, or weather alert across all public pages instantly.
Test serverless lead dispatch and verify real-time email delivery to Alex's contractor inbox.
Export a full snapshot of all leads, job notes, photo records, and site configs.
Manage access credentials without redeploying code.
Active Storage Project: Storage Cloud Database (Connected)
- In your Storage dashboard, click the SQL Editor tab (the
>_icon on the left toolbar) and run this SQL query:
-- 1. Projects & Leads Master Table
CREATE TABLE IF NOT EXISTS bops_leads (
id TEXT PRIMARY KEY,
name TEXT NOT NULL,
phone TEXT,
email TEXT,
address TEXT,
zip TEXT,
project_type TEXT,
budget TEXT,
preferred_time TEXT,
assigned_to TEXT,
status TEXT DEFAULT 'new',
notes TEXT,
household_notes TEXT,
scheduled_walkthrough TEXT,
walkthrough_data JSONB DEFAULT '{}'::jsonb,
receipts JSONB DEFAULT '[]'::jsonb,
assigned_trades JSONB DEFAULT '[]'::jsonb,
daily_logs JSONB DEFAULT '[]'::jsonb,
updated_at TIMESTAMPTZ DEFAULT NOW(),
created_at TIMESTAMPTZ DEFAULT NOW()
);
-- 2. Hardware Store Material Receipts Table
CREATE TABLE IF NOT EXISTS bops_receipts (
id TEXT PRIMARY KEY,
project_id TEXT NOT NULL,
vendor TEXT,
date TEXT,
subtotal NUMERIC(10,2) DEFAULT 0,
tax NUMERIC(10,2) DEFAULT 0,
total NUMERIC(10,2) DEFAULT 0,
items JSONB DEFAULT '[]'::jsonb,
image_url TEXT,
raw_ocr TEXT,
source TEXT DEFAULT 'upload',
created_at TIMESTAMPTZ DEFAULT NOW()
);
-- 3. Project Expenses & Subcontractor Payouts
CREATE TABLE IF NOT EXISTS bops_expenses (
id TEXT PRIMARY KEY,
business_id TEXT DEFAULT 'bops',
project_id TEXT NOT NULL,
vendor_id TEXT,
vendor_name TEXT,
category TEXT,
description TEXT,
cost_mode TEXT DEFAULT 'flat',
amount_cents INTEGER NOT NULL,
date TEXT,
notes TEXT,
payment_method TEXT,
pricing_basis TEXT,
receipt_id TEXT,
voided BOOLEAN DEFAULT FALSE,
void_reason TEXT,
voided_at TIMESTAMPTZ,
updated_at TIMESTAMPTZ DEFAULT NOW(),
created_at TIMESTAMPTZ DEFAULT NOW()
);
-- 4. Payment Disbursements (Cash App, check, cash, card)
CREATE TABLE IF NOT EXISTS bops_payments (
id TEXT PRIMARY KEY,
business_id TEXT DEFAULT 'bops',
expense_id TEXT NOT NULL,
project_id TEXT NOT NULL,
amount_cents INTEGER NOT NULL,
date TEXT,
method TEXT,
reference TEXT,
voided BOOLEAN DEFAULT FALSE,
void_reason TEXT,
voided_at TIMESTAMPTZ,
updated_at TIMESTAMPTZ DEFAULT NOW(),
created_at TIMESTAMPTZ DEFAULT NOW()
);
-- 5. Subcontractor & Trade Directory
CREATE TABLE IF NOT EXISTS bops_vendors (
id TEXT PRIMARY KEY,
business_id TEXT DEFAULT 'bops',
display_name TEXT NOT NULL,
type TEXT,
categories JSONB DEFAULT '[]'::jsonb,
contact_person TEXT,
phone TEXT,
email TEXT,
notes TEXT,
archived BOOLEAN DEFAULT FALSE,
updated_at TIMESTAMPTZ DEFAULT NOW(),
created_at TIMESTAMPTZ DEFAULT NOW()
);
-- 6. Telemetry & AI Files
CREATE TABLE IF NOT EXISTS bops_visitors (
id TEXT PRIMARY KEY,
visitor_id TEXT,
timestamp TIMESTAMPTZ DEFAULT NOW(),
city TEXT,
region TEXT,
postal TEXT,
location_display TEXT,
page TEXT,
page_title TEXT,
referrer TEXT,
device TEXT,
ip_masked TEXT,
action TEXT
);
CREATE TABLE IF NOT EXISTS bops_system_files (
filename TEXT PRIMARY KEY,
content TEXT NOT NULL,
updated_at TIMESTAMPTZ DEFAULT NOW()
);
CREATE TABLE IF NOT EXISTS bops_tickets (
id TEXT PRIMARY KEY,
lead_id TEXT NOT NULL,
title TEXT NOT NULL,
description TEXT,
category TEXT DEFAULT 'punch_item',
room TEXT,
priority TEXT DEFAULT 'normal',
photo_url TEXT,
client_name TEXT,
client_phone TEXT,
client_email TEXT,
status TEXT DEFAULT 'open',
resolution_notes TEXT,
resolved_at TIMESTAMPTZ,
created_at TIMESTAMPTZ DEFAULT NOW(),
updated_at TIMESTAMPTZ DEFAULT NOW()
);
ALTER TABLE bops_leads ADD COLUMN IF NOT EXISTS portal_token TEXT;
ALTER TABLE bops_leads ADD COLUMN IF NOT EXISTS email_opt_out BOOLEAN DEFAULT FALSE;
-- Security RLS
ALTER TABLE bops_leads ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Allow leads manage" ON bops_leads FOR ALL USING (true);
ALTER TABLE bops_receipts ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Allow receipts manage" ON bops_receipts FOR ALL USING (true);
ALTER TABLE bops_expenses ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Allow expenses manage" ON bops_expenses FOR ALL USING (true);
ALTER TABLE bops_payments ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Allow payments manage" ON bops_payments FOR ALL USING (true);
ALTER TABLE bops_vendors ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Allow vendors manage" ON bops_vendors FOR ALL USING (true);
ALTER TABLE bops_visitors ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Allow anonymous telemetry insert" ON bops_visitors FOR INSERT WITH CHECK (true);
CREATE POLICY "Allow admin telemetry select" ON bops_visitors FOR SELECT USING (true);
ALTER TABLE bops_system_files ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Allow public read system files" ON bops_system_files FOR SELECT USING (true);
CREATE POLICY "Allow admin manage system files" ON bops_system_files FOR ALL USING (true);
ALTER TABLE bops_tickets ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Allow tickets manage" ON bops_tickets FOR ALL USING (true);
anon public key. Add STORAGE_KEY to your Vercel Project Environment Variables!
Google SEO, AI Discovery & File Editor
Search engine rich results, Generative Engine Optimization (GEO / LLMs), and direct raw system file manager.Architectural blueprint, structured schemas, and machine-readable data for Google, ChatGPT Search, Perplexity, and Apple Intelligence.
- Entity Schema: Embedded
HomeAndConstructionBusinesswith coordinates (43.0389, -87.9065) and postal code53207(Riverton). - High-Intent Keywords: Targeted for "Riverton kitchen remodeling", "historic duplex bathroom gut", and "Riverton finished basements with egress".
- Local Authority Signals: Explicit neighborhood coverage: Lakeview, Westfield, Maplewood, North Shore, Brookfield, Historic Third Ward, Riverwest.
- Aggregate Star Ratings: 5.0 Star structured microdata based on 184 completed houses.
- Machine-Readable Index:
/llms.txtstandard gives AI bots (ChatGPT, Claude, Perplexity) structured summaries without JavaScript parsing overhead. - Clear Price Anchors: Stating concrete price ranges ($24k kitchen, $12k bath, $18k basement) prevents AI hallucinations and earns high-ranking AI recommendation slots.
- Proprietary Methodology: "Straight Price Guarantee", "HEPA Dust Containment", and "Dedicated 1-House Single Crew" serve as unique AI retrieval keys.
- Direct Contact Extraction: Explicit phone
(555) 617-8029and walkthrough link ensure 1-click conversion when cited in AI summaries.
Open, modify, paste new text/code, and save or export key system files directly from this console.
