Property & Project Management
Relevant source files
The following files were used as context for generating this wiki page:
Introduction
The Property and Project Management system is an enterprise-grade module designed to facilitate the full lifecycle of real estate asset oversight, from initial property listing to complex maintenance project execution. The system integrates property data with a robust Request for Quotation (RFQ) engine, allowing administrators to manage residential and commercial assets while coordinating with verified vendors for specialized tasks such as HVAC, plumbing, and general renovations.
At its core, the system utilizes a centralized project tracking mechanism where administrators can create projects, define technical specifications, and manage vendor bids. This ensures that property improvements are executed with technical accuracy, adhering to strict commercial frameworks and compliance codes. Sources: src/pages/AdminProjectManagement.tsx, src/components/AdminRFQSystem.tsx, supabase/migrations/20251221092457_1f91df83-a92f-4d43-8b5d-a0074192e976.sql
Property Asset Management
The property management component serves as the foundational data layer, storing detailed information about physical assets. Properties like "The Broadwin Condominium" are defined with attributes ranging from geographic location to complex building details such as fire protection systems and residential unit configurations. Sources: supabase/migrations/20251221092457_1f91df83-a92f-4d43-8b5d-a0074192e976.sql:1-35
Property Data Structure
| Field | Type | Description |
|---|---|---|
title | string | The formal name of the property (e.g., "The Broadwin Condominium"). |
property_type | string | Category of the asset (e.g., "Residential Condominium"). |
square_feet | string/number | Total area of the building. |
status | string | Current operational state (e.g., "active"). |
unit_configuration | JSONB | Details of individual units within the property (types, quantities, capacities). |
Sources: supabase/migrations/20251221092457_1f91df83-a92f-4d43-8b5d-a0074192e976.sql:85-89, src/pages/admin/RFQEdit.tsx:45-50
Project Lifecycle & RFQ Engine
The system handles projects through two primary interfaces: a legacy project management view and a comprehensive RFQ system. The RFQ engine is used for high-complexity installations (like HVAC systems) that require detailed technical specifications and multi-stage payment frameworks. Sources: src/components/AdminRFQSystem.tsx:128-150, src/pages/admin/RFQEdit.tsx:120-170
Project Execution Flow
The following diagram illustrates the transition from a property-linked project to vendor assignment.
The flow ensures that every project is either linked to an existing asset or has defined geographical constraints before being opened to the vendor marketplace. Sources: src/pages/admin/RFQEdit.tsx:280-320, src/components/AdminRFQSystem.tsx:430-460
Technical Specifications and BOQ
For large-scale projects, the system tracks a "Bill of Quantities" (BOQ) within the technical_specs JSON structure. This includes residential loads, common area requirements, and specific equipment lists (e.g., fan coil units, thermostats). Sources: src/pages/admin/RFQEdit.tsx:75-80, supabase/migrations/20251221092457_1f91df83-a92f-4d43-8b5d-a0074192e976.sql:105-125
Vendor Interaction and Bidding
Vendors interact with the system through a dedicated dashboard where they view RFQ details, project scopes, and "Non-Negotiable" system strategies (such as prohibited HVAC types). Sources: src/pages/vendor/ComprehensiveRFQDetail.tsx, src/pages/VendorProjectDetails.tsx
Bid Evaluation Sequence
The sequence diagram below shows the interaction between the Admin and Vendor during the bidding process.
Commercial and Compliance Framework
The system enforces a structured commercial framework to manage financial risk. Projects utilize milestone-based payments rather than single lump sums. Sources: src/pages/admin/RFQEdit.tsx:90-100, supabase/migrations/20251221092457_1f91df83-a92f-4d43-8b5d-a0074192e976.sql:135-145
Default Payment Milestones
| Milestone | Percentage | Condition for Payment |
|---|---|---|
| 1 | 30% | Contract signing & submittal approval. |
| 2 | 40% | Equipment delivery and verified inventory. |
| 3 | 30% | Substantial completion, commissioning, and TAB. |
Sources: src/pages/admin/RFQEdit.tsx:102-106, supabase/migrations/20251221092457_1f91df83-a92f-4d43-8b5d-a0074192e976.sql:137-141
Compliance Standards
Projects are validated against multiple regulatory codes, stored in the codes_compliance array. Typical standards include:
- ASHRAE 62.1/90.1 (Energy/Ventilation)
- NFPA 13R (Sprinkler/Fire)
- International Mechanical Code (IMC)
- Local Building Codes (e.g., Columbus Mechanical Codes)
Sources: supabase/migrations/20251221092457_1f91df83-a92f-4d43-8b5d-a0074192e976.sql:147-150, src/pages/admin/RFQEdit.tsx:112
Data Management & Audit
Administrative controls include an auto-save feature for RFQ drafts and a comprehensive audit trail for property service links. The rfq_properties table maintains a join relationship between RFQs and properties, allowing a single project to span multiple assets if necessary. Sources: src/pages/admin/RFQEdit.tsx:360-380, src/pages/admin/RFQEdit.tsx:180-200
Summary
The Property & Project Management module provides a rigorous environment for overseeing high-value real estate assets. By strictly defining technical strategies, commercial milestones, and compliance requirements within JSONB data structures, the system minimizes ambiguity for vendors and ensures that property managers maintain granular control over project execution and financial outlays.