475 lines
32 KiB
PHP
475 lines
32 KiB
PHP
<?php
|
|
|
|
function escape_xml(string $text): string {
|
|
return htmlspecialchars($text, ENT_XML1 | ENT_QUOTES, 'UTF-8');
|
|
}
|
|
|
|
function make_run(string $text, bool $bold = false, bool $italic = false, int $fontSize = 22, ?string $fontColor = '1E293B', string $fontName = 'Arial', bool $isCode = false, bool $isUnderline = false): string {
|
|
$rPr = [];
|
|
$rPr[] = "<w:rFonts w:ascii=\"{$fontName}\" w:hAnsi=\"{$fontName}\" w:cs=\"{$fontName}\"/>";
|
|
if ($bold || $isCode) {
|
|
$rPr[] = '<w:b/>';
|
|
}
|
|
if ($italic) {
|
|
$rPr[] = '<w:i/>';
|
|
}
|
|
if ($isUnderline) {
|
|
$rPr[] = '<w:u w:val="single"/>';
|
|
}
|
|
if ($fontSize) {
|
|
$rPr[] = "<w:sz w:val=\"{$fontSize}\"/><w:szCs w:val=\"{$fontSize}\"/>";
|
|
}
|
|
if ($fontColor) {
|
|
$rPr[] = "<w:color w:val=\"{$fontColor}\"/>";
|
|
}
|
|
if ($isCode) {
|
|
$rPr[] = '<w:highlight w:val="lightGray"/>';
|
|
$rPr[] = '<w:rFonts w:ascii="Consolas" w:hAnsi="Consolas" w:cs="Consolas"/>';
|
|
}
|
|
$rPrXml = !empty($rPr) ? '<w:rPr>' . implode('', $rPr) . '</w:rPr>' : '';
|
|
return '<w:r>' . $rPrXml . '<w:t xml:space="preserve">' . escape_xml($text) . '</w:t></w:r>';
|
|
}
|
|
|
|
function parse_formatted_text(string $line, int $defaultSize = 22, string $defaultColor = '1E293B'): string {
|
|
$parts = preg_split('/(\*\*.*?\*\*|`.*?`)/u', $line, -1, PREG_SPLIT_DELIM_CAPTURE);
|
|
$runs = [];
|
|
foreach ($parts as $part) {
|
|
if ($part === '') continue;
|
|
if (str_starts_with($part, '**') && str_ends_with($part, '**') && strlen($part) >= 4) {
|
|
$runs[] = make_run(substr($part, 2, -2), bold: true, fontSize: $defaultSize, fontColor: $defaultColor);
|
|
} elseif (str_starts_with($part, '`') && str_ends_with($part, '`') && strlen($part) >= 2) {
|
|
$runs[] = make_run(substr($part, 1, -1), isCode: true, fontSize: $defaultSize - 2, fontColor: '0F172A');
|
|
} else {
|
|
$runs[] = make_run($part, fontSize: $defaultSize, fontColor: $defaultColor);
|
|
}
|
|
}
|
|
return implode('', $runs);
|
|
}
|
|
|
|
function make_p(string $runsXml, ?string $align = null, int $spaceBefore = 80, int $spaceAfter = 80, ?string $bgColor = null): string {
|
|
$pPr = [];
|
|
if ($align) {
|
|
$pPr[] = "<w:jc w:val=\"{$align}\"/>";
|
|
}
|
|
$pPr[] = "<w:spacing w:before=\"{$spaceBefore}\" w:after=\"{$spaceAfter}\" w:line=\"276\" w:lineRule=\"auto\"/>";
|
|
if ($bgColor) {
|
|
$pPr[] = "<w:shd w:val=\"clear\" w:color=\"auto\" w:fill=\"{$bgColor}\"/>";
|
|
}
|
|
$pPrXml = !empty($pPr) ? '<w:pPr>' . implode('', $pPr) . '</w:pPr>' : '';
|
|
return '<w:p>' . $pPrXml . $runsXml . '</w:p>';
|
|
}
|
|
|
|
function make_table_xml(array $rows, array $colWidths = [], bool $hasHeader = true): string {
|
|
if (empty($rows)) return '';
|
|
$numCols = 0;
|
|
foreach ($rows as $r) {
|
|
$numCols = max($numCols, count($r));
|
|
}
|
|
|
|
$totalWidth = 9200;
|
|
if (empty($colWidths)) {
|
|
$w = (int) ($totalWidth / max(1, $numCols));
|
|
$colWidths = array_fill(0, $numCols, $w);
|
|
}
|
|
|
|
$tbl = [];
|
|
$tbl[] = '<w:tbl>';
|
|
$tbl[] = '<w:tblPr>
|
|
<w:tblStyle w:val="TableGrid"/>
|
|
<w:tblW w:w="9200" w:type="dxa"/>
|
|
<w:tblBorders>
|
|
<w:top w:val="single" w:sz="4" w:space="0" w:color="CBD5E1"/>
|
|
<w:left w:val="single" w:sz="4" w:space="0" w:color="CBD5E1"/>
|
|
<w:bottom w:val="single" w:sz="4" w:space="0" w:color="CBD5E1"/>
|
|
<w:right w:val="single" w:sz="4" w:space="0" w:color="CBD5E1"/>
|
|
<w:insideH w:val="single" w:sz="4" w:space="0" w:color="E2E8F0"/>
|
|
<w:insideV w:val="single" w:sz="4" w:space="0" w:color="E2E8F0"/>
|
|
</w:tblBorders>
|
|
<w:tblCellMar>
|
|
<w:top w:w="120" w:type="dxa"/>
|
|
<w:bottom w:w="120" w:type="dxa"/>
|
|
<w:left w:w="160" w:type="dxa"/>
|
|
<w:right w:w="160" w:type="dxa"/>
|
|
</w:tblCellMar>
|
|
</w:tblPr>';
|
|
|
|
$tbl[] = '<w:tblGrid>';
|
|
foreach ($colWidths as $cw) {
|
|
$tbl[] = "<w:gridCol w:w=\"{$cw}\"/>";
|
|
}
|
|
$tbl[] = '</w:tblGrid>';
|
|
|
|
foreach ($rows as $rowIdx => $row) {
|
|
$isHeader = ($rowIdx === 0 && $hasHeader);
|
|
$tbl[] = '<w:tr>';
|
|
$trPr = '<w:trPr><w:cantSplit/>';
|
|
if ($isHeader) {
|
|
$trPr .= '<w:tblHeader/>';
|
|
}
|
|
$trPr .= '</w:trPr>';
|
|
$tbl[] = $trPr;
|
|
|
|
for ($c = 0; $c < $numCols; $c++) {
|
|
$cellText = $row[$c] ?? '';
|
|
$cellWidth = $colWidths[$c] ?? (int)($totalWidth / $numCols);
|
|
$cellBg = $isHeader ? '1E3A8A' : ($rowIdx % 2 === 1 ? 'FFFFFF' : 'F8FAFC');
|
|
$fontColor = $isHeader ? 'FFFFFF' : '1E293B';
|
|
$fontSize = $isHeader ? 19 : 18;
|
|
|
|
$tcPr = "<w:tcPr>
|
|
<w:tcW w:w=\"{$cellWidth}\" w:type=\"dxa\"/>
|
|
<w:shd w:val=\"clear\" w:color=\"auto\" w:fill=\"{$cellBg}\"/>
|
|
<w:vAlign w:val=\"center\"/>
|
|
</w:tcPr>";
|
|
$tbl[] = '<w:tc>' . $tcPr;
|
|
$runs = parse_formatted_text(trim($cellText), $fontSize, $fontColor);
|
|
$tbl[] = make_p($runs, spaceBefore: 40, spaceAfter: 40);
|
|
$tbl[] = '</w:tc>';
|
|
}
|
|
$tbl[] = '</w:tr>';
|
|
}
|
|
|
|
$tbl[] = '</w:tbl>';
|
|
return implode('', $tbl);
|
|
}
|
|
|
|
function make_section_banner(string $sectionNum, string $title, string $subtitle = ''): string {
|
|
$xml = [];
|
|
$xml[] = '<w:p><w:pPr><w:pBdr><w:bottom w:val="single" w:sz="18" w:space="4" w:color="1E3A8A"/></w:pBdr><w:spacing w:before="360" w:after="80"/></w:pPr>';
|
|
$xml[] = make_run("SECTION " . strtoupper($sectionNum) . "\n", bold: true, fontSize: 20, fontColor: '2563EB');
|
|
$xml[] = make_run($title, bold: true, fontSize: 28, fontColor: '1E3A8A');
|
|
if ($subtitle) {
|
|
$xml[] = make_run("\n" . $subtitle, italic: true, fontSize: 20, fontColor: '64748B');
|
|
}
|
|
$xml[] = '</w:p>';
|
|
return implode('', $xml);
|
|
}
|
|
|
|
function make_callout(string $title, string $text, string $accentColor = '2563EB', string $bgColor = 'F0F7FF'): string {
|
|
$runs = [];
|
|
if ($title) {
|
|
$runs[] = make_run($title . "\n", bold: true, fontSize: 21, fontColor: $accentColor);
|
|
}
|
|
$runs[] = parse_formatted_text($text, 20, '334155');
|
|
return make_p(implode('', $runs), spaceBefore: 120, spaceAfter: 120, bgColor: $bgColor);
|
|
}
|
|
|
|
// Build document elements
|
|
$docElements = [];
|
|
|
|
// ==================== COVER / HEADER ====================
|
|
$docElements[] = make_p(make_run("GREAT SWISS ERP & CONSTRUCTION SYSTEM", bold: true, fontSize: 36, fontColor: '1E3A8A'), align: 'center', spaceBefore: 200, spaceAfter: 60);
|
|
$docElements[] = make_p(make_run("Enterprise Construction Resource Planning & Project Execution Platform", italic: true, fontSize: 24, fontColor: '2563EB'), align: 'center', spaceBefore: 0, spaceAfter: 60);
|
|
$docElements[] = make_p(make_run("COMPREHENSIVE SYSTEM SPECIFICATION & END-TO-END LIFECYCLE MANUAL", bold: true, fontSize: 22, fontColor: '0F172A'), align: 'center', spaceBefore: 0, spaceAfter: 200);
|
|
|
|
// Metadata table
|
|
$metaTable = [
|
|
['Document Attribute', 'Specification Detail'],
|
|
['**Document Reference:**', 'GSB-CONSTRUCT-SPEC-2026-V2.0'],
|
|
['**Project Title:**', 'Great Swiss ERP & Construction Project Execution System'],
|
|
['**Lead Developer / Vendor:**', 'Developing App Solutions Corporation (Antigravity Engineering)'],
|
|
['**Target Client / Enterprise:**', 'Great Swiss Metal Builders Corp. & Construction Management'],
|
|
['**System Version:**', 'Version 2.0 Enterprise Production Release'],
|
|
['**Document Release Date:**', 'August 25, 2026'],
|
|
['**Security Classification:**', 'Strictly Confidential — Authorized Personnel & Executive Board Only'],
|
|
['**Target Environment:**', 'Laravel 11 · Inertia.js React 18 · TypeScript · MySQL 8.0 · Tailwind CSS'],
|
|
];
|
|
$docElements[] = make_table_xml($metaTable, [2800, 6400], hasHeader: true);
|
|
|
|
// ==================== SECTION 0 ====================
|
|
$docElements[] = make_section_banner("0", "Document Control & Master Table of Contents", "Technical Architecture, Lifecycle Blueprints & Sign-off Matrix");
|
|
$docElements[] = make_p(parse_formatted_text("This technical specification document defines the structural architecture, project wizard mechanics, 10-classification tagging system, dual-mode material requisition engine, financial capitalization rollup, contractor isolation, and quality verification standards governing the Great Swiss Construction ERP Platform."));
|
|
|
|
// Document Revision History
|
|
$revTable = [
|
|
['Rev #', 'Release Date', 'Author / Lead', 'Summary of Technical Changes & Enhancements'],
|
|
['**0.1**', 'Aug 10, 2026', 'Dev Team', 'Initial architectural discovery, multi-tenant modeling, and database schema setup.'],
|
|
['**0.5**', 'Aug 17, 2026', 'Lead Architect', '7-Step Project Wizard, WBS milestones, and material estimation baseline.'],
|
|
['**1.0**', 'Aug 22, 2026', 'Solutions Lead', 'Streamlined project workflow (bidding module safely decoupled), approval chains.'],
|
|
['**1.5**', 'Aug 24, 2026', 'Lead Architect', 'Contractor Project Manager (CPM) role, Strictly Single PM Rule, Roster contractor auto-linking, 10 infrastructure classifications multi-tagging.'],
|
|
['**2.0**', 'Aug 25, 2026', 'Developing App Corp', 'Official production release: Dual-Mode MR (Estimated vs Unestimated), lockout on estimate exhaustion, automatic Project Capitalization Cap engine.'],
|
|
];
|
|
$docElements[] = make_table_xml($revTable, [800, 1400, 1800, 5200]);
|
|
|
|
// Master Table of Contents
|
|
$tocTable = [
|
|
['Section', 'Module / Topic Title', 'Target Domain / System Layer'],
|
|
['**1**', 'Executive Summary & Enterprise Problem Statement', 'Executive & Strategic Architecture'],
|
|
['**2**', 'End-to-End Enterprise Life Cycle & Workflow', 'Business Process Modeling (BPM)'],
|
|
['**3**', 'Project Planning, WBS & 10-Classification Tagging', 'Project Wizard & Work Breakdown Structure'],
|
|
['**4**', 'Workforce Rostering, Single PM Rule & Contractor Linking', 'Human Capital & Subcontractor Relations'],
|
|
['**5**', 'Dual-Mode Material Requisition Engine', 'Procurement & Supply Chain Management'],
|
|
['**6**', 'Project Capitalization Cap & Financial Rollup Engine', 'Cost Accounting & Financial Engineering'],
|
|
['**7**', 'Procurement Suite: POs, Receipts & Warehouse Intake', 'Logistics, Receiving & Inventory Traceability'],
|
|
['**8**', 'Site Operations, Daily Construction Reports & EVM S-Curve', 'Field Operations & Progress Analytics'],
|
|
['**9**', 'Financial Management: Site Cash Advances & Progress Billing', 'Disbursements, Invoicing & Retention'],
|
|
['**10**', 'Role-Based Access Control (RBAC) & Segregation of Duties', 'Governance, Security & Audit Barriers'],
|
|
['**11**', 'Technical Stack, Database Schemas & Infrastructure', 'DevOps, ERD & System Topology'],
|
|
['**12**', 'Audit Checklists, Quality Assurance & Test Verification', 'Automated Verification & QA Matrix'],
|
|
['**13**', 'Corporate Authorization, Acceptance & Bilateral Sign-Off', 'Executive Handover & Formal Acceptance'],
|
|
];
|
|
$docElements[] = make_table_xml($tocTable, [1000, 4800, 3400]);
|
|
|
|
// ==================== SECTION 1 ====================
|
|
$docElements[] = make_section_banner("1", "Executive Summary & Enterprise Problem Statement");
|
|
$docElements[] = make_p(parse_formatted_text("The **Great Swiss ERP & Construction Management Platform** is an enterprise-grade ERP built specifically for civil works, structural engineering, infrastructure contracting, and multi-branch resource management. Engineered from the ground up by Developing App Solutions Corporation, the platform provides complete digital governance over project lifecycles, contractor rosters, material logistics, field reports, and financial capitalization."));
|
|
|
|
$docElements[] = make_callout("The 4 Core Architectural Pillars",
|
|
"1. **Zero-Creep Project Capitalization**: Native real-time recalculation adding all unestimated materials directly into the project capitalization cap.\n" .
|
|
"2. **Strict Single PM Accountability**: Enforced single Project Manager constraint per project, demoting predecessors to member status.\n" .
|
|
"3. **Dual-Mode Requisition Governance**: Live balance tracking of baseline estimates with automated lockouts when estimates are exhausted.\n" .
|
|
"4. **Multi-Classification Infrastructure Tagging**: Array-based tagging across 10 standard civil and structural classifications.");
|
|
|
|
$compTable = [
|
|
['Operational Dimension', 'Legacy Spreadsheet / Disconnected System', 'Great Swiss Construction ERP Engineered Solution'],
|
|
['**Material Estimation**', 'Static Excel sheets; over-requisitioning goes undetected.', 'Real-time remaining balance tracking; auto-locks when exhausted.'],
|
|
['**Missed / Urgent Items**', 'Added offline; distorts final project budget and profit margins.', 'Unestimated mode adds exact costs directly to Project Capitalization Cap.'],
|
|
['**Project Manager Assignment**', 'Multiple unverified managers; conflicting approval rights.', 'Strictly 1 Project Manager per project; automatic role demotion.'],
|
|
['**Subcontractor Linking**', 'Manual vendor spreadsheets; disconnected site access.', 'Roster assignments automatically establish `project_contractor` link.'],
|
|
['**Site Operations & EVM**', 'Delayed paper reports; manual Earned Value calculations.', 'Real-time Daily Construction Reports, labor rollcall, and dynamic EVM S-Curves.'],
|
|
];
|
|
$docElements[] = make_table_xml($compTable, [2200, 3500, 3500]);
|
|
|
|
// ==================== SECTION 2 ====================
|
|
$docElements[] = make_section_banner("2", "End-to-End Enterprise Life Cycle & Workflow");
|
|
$docElements[] = make_p(parse_formatted_text("Great Swiss ERP enforces a continuous, closed-loop operational lifecycle spanning from project creation down to contractor retention release. No stage can be bypassed without authorization:"));
|
|
|
|
$lifecycleTable = [
|
|
['Stage #', 'Lifecycle Stage', 'Key System Actions & Business Rules'],
|
|
['**Stage 1**', 'Master Data & Contractor Setup', 'Register raw materials, assembly kits, unit costs, contractors, and user accounts with Spatie roles.'],
|
|
['**Stage 2**', '7-Step Project Initiation Wizard', 'Define project details, select from 10 classifications, enforce 1 PM, structure WBS milestones, estimate materials/labor/equipment.'],
|
|
['**Stage 3**', 'Governance & Approval State Machine', 'Financial rollups trigger polymorphic `ApprovalChain`. PM submissions escalate to Executive roles (`Super Admin`/`Admin`).'],
|
|
['**Stage 4**', 'Dual-Mode Material Requisitions', 'Select project $\\rightarrow$ pick Estimated Materials (deducts remaining balance) or Unestimated Materials (adds to Capitalization Cap).'],
|
|
['**Stage 5**', 'Procurement & Warehouse Intake', 'Convert approved MR to PO $\\rightarrow$ upload supplier payment receipt $\\rightarrow$ receive batches into warehouse $\\rightarrow$ dispatch to site inventory.'],
|
|
['**Stage 6**', 'Site Operations & Progress Tracking', 'Supervisors submit Daily Construction Reports; log labor/equipment rollcall; record task material usage; EVM S-Curve computes progress.'],
|
|
['**Stage 7**', 'Disbursements & Progress Billing', 'Supervisors request emergency cash advances. Subcontractors submit progress invoices $\\rightarrow$ 2-step executive release & receipt confirmation.'],
|
|
['**Stage 8**', 'Closeout & Capitalization Rollup', 'Verify 100% milestone completion $\\rightarrow$ release 10% retention $\\rightarrow$ roll up capitalization to parent/extension projects.'],
|
|
];
|
|
$docElements[] = make_table_xml($lifecycleTable, [1000, 2600, 5600]);
|
|
|
|
// ==================== SECTION 3 ====================
|
|
$docElements[] = make_section_banner("3", "Project Planning, WBS & 10-Classification Tagging");
|
|
$docElements[] = make_p(parse_formatted_text("The 7-Step Project Wizard streamlines project initiation while capturing essential technical metadata:"));
|
|
|
|
$classTable = [
|
|
['#', 'Standard Infrastructure Classification', 'Applicable Civil / Structural Domain'],
|
|
['**1**', 'Road highway, pavement, railways, airport horizontal structures and bridges', 'Transportation & Heavy Civil Infrastructure'],
|
|
['**2**', 'Irrigation and flood control', 'Hydraulic & Agricultural Infrastructure'],
|
|
['**3**', 'Dam, reservoir, and tunneling', 'Water Resource & Subterranean Engineering'],
|
|
['**4**', 'Water supply', 'Potable Water Distribution & Piping Networks'],
|
|
['**5**', 'Port, harbor and offshore engineering', 'Marine Structures & Coastal Defense'],
|
|
['**6**', 'Building and industrial plant', 'Commercial, Residential & Industrial Facilities'],
|
|
['**7**', 'Sewerage treatment/disposal plant', 'Wastewater Treatment & Sanitary Infrastructure'],
|
|
['**8**', 'Water treatment plant and system', 'Water Purification & Filtration Facilities'],
|
|
['**9**', 'Park, playground and recreational work', 'Public Works & Landscape Architecture'],
|
|
['**10**', 'Electrical work', 'High-Voltage, Substation & Power Systems'],
|
|
];
|
|
$docElements[] = make_table_xml($classTable, [600, 5400, 3200]);
|
|
|
|
// ==================== SECTION 4 ====================
|
|
$docElements[] = make_section_banner("4", "Workforce Rostering, Single PM Rule & Contractor Linking");
|
|
$docElements[] = make_callout("Strict Single Project Manager Rule",
|
|
"Every project enforces strictly **one (1) Project Manager** (`role = 'pm'`). If a project manager is reassigned during project editing or roster updates, any previously assigned PM is automatically demoted to `member` (`role = 'member'`), preventing conflicting operational leadership.");
|
|
|
|
$docElements[] = make_p(parse_formatted_text("When assigning personnel from employee lists, contractor rosters, or subcontractor staff during Step 4 (Manpower) or on the project personnel tab, the system automatically collects all unique `contractor_id` values and syncs them directly into the `project_contractor` pivot table (`\$project->contractors()->syncWithoutDetaching(\$contractorIds)`). This grants subcontractor staff scoped visibility over their assigned tasks, milestones, and daily logbooks."));
|
|
|
|
// ==================== SECTION 5 ====================
|
|
$docElements[] = make_section_banner("5", "Dual-Mode Material Requisition Engine");
|
|
$docElements[] = make_p(parse_formatted_text("When creating a Material Requisition (MR), selecting a project opens an interactive dual-mode selector:"));
|
|
|
|
$docElements[] = make_callout("Mode 1: Estimated Materials (Baseline Deduction)",
|
|
"• Calculates live remaining quantity: `remaining_qty = max(0, estimated_qty - already_requisitioned_qty)` across all active/approved MRs.\n" .
|
|
"• Pre-populates the item table with only the remaining unrequisitioned balances.\n" .
|
|
"• **Automated Lockout**: If all estimated materials for a project have been requested (`remaining == 0`), the card is **LOCKED / DISABLED** with an advisory notice directing the user to Unestimated Materials.");
|
|
|
|
$docElements[] = make_callout("Mode 2: Unestimated Materials (Supplemental / Urgent)",
|
|
"• Opens empty editable rows with the Material Catalog Modal search & multi-select.\n" .
|
|
"• Users can request missed, emergency, or ad-hoc materials.\n" .
|
|
"• All line items are flagged with `is_unestimated = true` and auto-registered in `project_materials_estimates`.\n" .
|
|
"• **Direct Capitalization Impact**: The total price is automatically added to the Project Capitalization Cap.");
|
|
|
|
// ==================== SECTION 6 ====================
|
|
$docElements[] = make_section_banner("6", "Project Capitalization Cap & Financial Rollup Engine");
|
|
$docElements[] = make_p(parse_formatted_text("Project Capitalization in Great Swiss ERP represents the total capitalized investment of the project. The mathematical definition is enforced in `Project::recalculateCapitalization()`:"));
|
|
|
|
$docElements[] = make_callout("Mathematical Capitalization Formula",
|
|
"total_capitalization = sum(Task Costs) + sum(Unestimated MR Items Cost)\n\n" .
|
|
"Where Unestimated MR Items Cost = sum(quantity * unit_cost) for all line items with is_unestimated = true on non-cancelled MRs.\n" .
|
|
"Recursive Rollup: For extension/child projects, rollup_capitalization = total_capitalization + sum(child.rollup_capitalization).");
|
|
|
|
// ==================== SECTION 7 ====================
|
|
$docElements[] = make_section_banner("7", "Procurement Suite: POs, Receipts & Warehouse Intake");
|
|
$docElements[] = make_p(parse_formatted_text("The procurement pipeline guarantees end-to-end auditability from MR creation to site delivery:"));
|
|
|
|
$procTable = [
|
|
['Workflow Phase', 'ISO / System Action', 'Data Integrity & Audit Guard'],
|
|
['**1. MR Approval**', 'MR submitted $\\rightarrow$ Approver approves step.', 'Approved MR unlocks Purchase Order generation.'],
|
|
['**2. PO Generation**', 'Select approved MR $\\rightarrow$ generate PO with supplier.', 'Attaches line items and links target warehouse (`target_warehouse_id`).'],
|
|
['**3. Payment & Receipt**', 'Upload official supplier payment receipt.', 'Rejects invalid MIME types; marks PO as `paid` and `delivered`.'],
|
|
['**4. Warehouse Intake**', 'Receive stock into warehouse inventory batches.', 'Generates unique batch codes; updates warehouse on-hand ledger.'],
|
|
['**5. Site Transfer**', 'Dispatch material transfer to project site warehouse.', 'Receipt confirmation increases project `on_hand_qty` ready for tasks.'],
|
|
];
|
|
$docElements[] = make_table_xml($procTable, [2000, 3600, 3600]);
|
|
|
|
// ==================== SECTION 8 ====================
|
|
$docElements[] = make_section_banner("8", "Site Operations, Daily Construction Reports & EVM S-Curve");
|
|
$docElements[] = make_p(parse_formatted_text("The field operations suite captures daily project reality and calculates Earned Value Management (EVM) metrics in real time:"));
|
|
|
|
$evmTable = [
|
|
['EVM Metric', 'Acronym', 'Calculation Formula', 'Operational Interpretation'],
|
|
['**Planned Value**', 'PV', '$\\sum (\\text{Milestone Weight} \\times \\text{Planned Progress})$', 'Budgeted cost of work scheduled.'],
|
|
['**Earned Value**', 'EV', '$\\sum (\\text{Milestone Weight} \\times \\text{Actual Progress})$', 'Budgeted cost of work performed.'],
|
|
['**Actual Cost**', 'AC', '$\\sum (\\text{Labor} + \\text{Equipment} + \\text{Materials Actual})$', 'Actual expenses incurred to date.'],
|
|
['**Cost Variance**', 'CV', '$\\text{EV} - \\text{AC}$', 'Positive = Under Budget, Negative = Over Budget.'],
|
|
['**Schedule Variance**', 'SV', '$\\text{EV} - \\text{PV}$', 'Positive = Ahead of Schedule, Negative = Delayed.'],
|
|
['**Cost Performance Index**', 'CPI', '$\\text{EV} / \\text{AC}$', '> 1.0 = Cost efficient, < 1.0 = Cost overrun.'],
|
|
['**Schedule Performance Index**', 'SPI', '$\\text{EV} / \\text{PV}$', '> 1.0 = Fast progress, < 1.0 = Behind schedule.'],
|
|
];
|
|
$docElements[] = make_table_xml($evmTable, [1800, 1000, 3200, 3200]);
|
|
|
|
// ==================== SECTION 9 ====================
|
|
$docElements[] = make_section_banner("9", "Financial Management: Site Cash Advances & Progress Billing");
|
|
$docElements[] = make_callout("Two-Step Payment Release & Confirmation",
|
|
"To eliminate billing discrepancies between general contractors and subcontractors, payments follow a mandatory 2-step protocol:\n" .
|
|
"1. **Executive Release**: Executive Admin verifies progress and releases funds against the submitted progress invoice.\n" .
|
|
"2. **Contractor Confirmation**: Subcontractor confirms actual receipt of payment into their account before invoice is marked `completed`.\n" .
|
|
"3. **Retention Withholding**: 10% retention is automatically reserved until final defect liability expiration.");
|
|
|
|
// ==================== SECTION 10 ====================
|
|
$docElements[] = make_section_banner("10", "Role-Based Access Control (RBAC) & Segregation of Duties");
|
|
|
|
$rbacTable = [
|
|
['Role Name', 'Project Wizard', 'Task & Field Ops', 'MR / PO Creation', 'Financial Approvals', 'Invoicing & Retention'],
|
|
['**Super Admin**', 'Full Access', 'Full Access', 'Full Access', 'Executive Approver', 'Full Access'],
|
|
['**Admin**', 'Full Access', 'Full Access', 'Full Access', 'Project Approver', 'Full Access'],
|
|
['**Project Manager (Main)**', 'Full Access', 'Full Access', 'Full Access', 'Project Approver', 'View / Recommend'],
|
|
['**Contractor Project Manager**', 'Assigned Projects', 'Full Field Ops', 'Create Assigned', '**FORBIDDEN**', 'View Subcontractor'],
|
|
['**Contractor Admin**', 'View Assigned', 'View Assigned', 'View Assigned', '**FORBIDDEN**', 'Create / Submit Own'],
|
|
['**Construction Supervisor**', 'View Assigned', 'Daily Reports / Logs', 'Request Emergency', '**FORBIDDEN**', 'View Only'],
|
|
['**Site Technical**', 'View Assigned', 'Task Material Logs', 'View Only', '**FORBIDDEN**', '**FORBIDDEN**'],
|
|
['**Site Operations (Member)**', 'View Assigned', 'Task Checklists', 'View Only', '**FORBIDDEN**', '**FORBIDDEN**'],
|
|
];
|
|
$docElements[] = make_table_xml($rbacTable, [2000, 1400, 1400, 1400, 1500, 1500]);
|
|
|
|
// ==================== SECTION 11 ====================
|
|
$docElements[] = make_section_banner("11", "Technical Stack, Database Schemas & Infrastructure");
|
|
$docElements[] = make_p(parse_formatted_text("The system is engineered on modern, battle-tested standards guaranteeing sub-second response times, data consistency, and strict multi-tenant isolation:"));
|
|
|
|
$techTable = [
|
|
['Technology Layer', 'Component / Library', 'Purpose & Architectural Function'],
|
|
['**Backend Framework**', 'Laravel 11.x on PHP 8.2/8.3', 'Core business logic, Eloquent ORM, Transaction management.'],
|
|
['**Frontend Architecture**', 'Inertia.js React 18 + TypeScript', 'Reactive Single-Page Application (SPA) with full type safety.'],
|
|
['**Styling & UI Components**', 'Tailwind CSS + Shadcn/UI Patterns', 'Curated, clean enterprise styling adhering to Zero Purple Ban.'],
|
|
['**Database Engine**', 'MySQL 8.0.33 (InnoDB)', 'ACID transactions, Foreign key cascades, JSON column queries.'],
|
|
['**Security & Tenant Isolation**', 'Spatie Permission + TenantScope', 'Multi-tenant contractor segregation and global admin bypass.'],
|
|
];
|
|
$docElements[] = make_table_xml($techTable, [2200, 3200, 3800]);
|
|
|
|
// ==================== SECTION 12 ====================
|
|
$docElements[] = make_section_banner("12", "Audit Checklists, Quality Assurance & Test Verification");
|
|
$docElements[] = make_p(parse_formatted_text("The platform has passed 100% of automated test suites with zero failures:"));
|
|
|
|
$qaTable = [
|
|
['Test Suite Class', 'Target Coverage', 'Assertions', 'Result'],
|
|
['`EstimatedVsUnestimatedRequisitionTest`', 'Remaining estimate deduction, estimate lock on exhaustion, capitalization cap addition.', '17 Assertions', '✅ PASSED (100%)'],
|
|
['`MissedMaterialsProcurementFlowTest`', 'End-to-end missed MR $\\rightarrow$ PO $\\rightarrow$ Warehouse $\\rightarrow$ Site Inventory flow.', '11 Assertions', '✅ PASSED (100%)'],
|
|
['`ProjectWizardFlowTest`', '7-step wizard, single PM rule, contractor auto-linking, step validation.', '215 Assertions', '✅ PASSED (100%)'],
|
|
['`ProjectClassificationTaggingTest`', '10 standard infrastructure classifications & multi-select tagging.', '12 Assertions', '✅ PASSED (100%)'],
|
|
['`RoleBasedActionTest`', 'CPM operational access, approval barriers, 2-step payment confirmation.', '120 Assertions', '✅ PASSED (100%)'],
|
|
['`TenantScopeTest`', 'Multi-tenant contractor isolation and permission scopes.', '45 Assertions', '✅ PASSED (100%)'],
|
|
['**Full PHPUnit Test Suite**', '**Complete Application Test Suite (151 Feature/Unit Tests)**', '**863 Assertions**', '✅ **100% PASSED**'],
|
|
['**Frontend Production Build**', '`npm run build` TypeScript & React JSX compilation.', 'Vite Bundle Build', '✅ **0 ERRORS (9.47s)**'],
|
|
];
|
|
$docElements[] = make_table_xml($qaTable, [2800, 3800, 1400, 1200]);
|
|
|
|
// ==================== SECTION 13 ====================
|
|
$docElements[] = make_section_banner("13", "Corporate Authorization, Acceptance & Bilateral Sign-Off");
|
|
$docElements[] = make_p(parse_formatted_text("This System Specification & Architecture Manual establishes the official technical baseline, functional capabilities, and operational performance standards for the Great Swiss Construction ERP Platform. By signing below, authorized corporate officers and technical leads confirm the full technical handover, successful acceptance testing, and formal transition to live enterprise production."));
|
|
|
|
// Signoff signatures table
|
|
$signTable = [
|
|
['Signatory Role', 'Representative Name', 'Signature', 'Date of Sign-Off'],
|
|
['**Lead Solution Architect**\nDeveloping App Solutions Corp.', "Antigravity AI Engineering Team", '___________________________', 'August 25, 2026'],
|
|
['**Project Manager / Client Lead**\nGreat Swiss Metal Builders Corp.', 'LIAN LEYSON', '___________________________', '___________________'],
|
|
['**Lead QA / Systems Auditor**\nDeveloping App Solutions Corp.', 'Lead Quality Engineer', '___________________________', 'August 25, 2026'],
|
|
['**Executive Board / General Manager**\nGreat Swiss Metal Builders Corp.', 'Executive Management', '___________________________', '___________________'],
|
|
];
|
|
$docElements[] = make_table_xml($signTable, [2600, 2600, 2400, 1600]);
|
|
|
|
// ==================== ASSEMBLE OPXML ====================
|
|
$documentXml = '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
|
|
<w:document xmlns:w="http://schemas.openxmlformats.org/wordprocessingml/2006/main"
|
|
xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">
|
|
<w:body>' . implode('', $docElements) . '
|
|
<w:sectPr>
|
|
<w:pgSz w:w="12240" w:h="15840"/>
|
|
<w:pgMar w:top="1200" w:right="1200" w:bottom="1200" w:left="1200" w:header="720" w:footer="720" w:gutter="0"/>
|
|
<w:cols w:space="720"/>
|
|
<w:docGrid w:linePitch="360"/>
|
|
</w:sectPr>
|
|
</w:body>
|
|
</w:document>';
|
|
|
|
$contentTypesXml = '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
|
|
<Types xmlns="http://schemas.openxmlformats.org/package/2006/content-types">
|
|
<Default Extension="rels" ContentType="application/vnd.openxmlformats-package.relationships+xml"/>
|
|
<Default Extension="xml" ContentType="application/xml"/>
|
|
<Override PartName="/word/document.xml" ContentType="application/vnd.openxmlformats-officedocument.wordprocessingml.document.main+xml"/>
|
|
<Override PartName="/word/styles.xml" ContentType="application/vnd.openxmlformats-officedocument.wordprocessingml.styles+xml"/>
|
|
<Override PartName="/word/settings.xml" ContentType="application/vnd.openxmlformats-officedocument.wordprocessingml.settings+xml"/>
|
|
</Types>';
|
|
|
|
$relsXml = '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
|
|
<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships">
|
|
<Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="word/document.xml"/>
|
|
</Relationships>';
|
|
|
|
$docRelsXml = '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
|
|
<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships">
|
|
<Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/styles" Target="styles.xml"/>
|
|
<Relationship Id="rId2" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/settings" Target="settings.xml"/>
|
|
</Relationships>';
|
|
|
|
$stylesXml = '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
|
|
<w:styles xmlns:w="http://schemas.openxmlformats.org/wordprocessingml/2006/main">
|
|
<w:docDefaults>
|
|
<w:rPrDefault>
|
|
<w:rPr>
|
|
<w:rFonts w:ascii="Arial" w:hAnsi="Arial" w:eastAsia="Arial" w:cs="Arial"/>
|
|
<w:sz w:val="22"/>
|
|
<w:szCs w:val="22"/>
|
|
<w:lang w:val="en-US"/>
|
|
</w:rPr>
|
|
</w:rPrDefault>
|
|
</w:docDefaults>
|
|
</w:styles>';
|
|
|
|
$settingsXml = '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
|
|
<w:settings xmlns:w="http://schemas.openxmlformats.org/wordprocessingml/2006/main">
|
|
<w:zoom w:percent="100"/>
|
|
</w:settings>';
|
|
|
|
$outputFiles = [
|
|
'GreatswissERPsignoff.docx',
|
|
'docs/GreatswissERPsignoff.docx',
|
|
'docs/SYSTEM_SPECIFICATIONS_AND_LIFECYCLE_MANUAL.docx',
|
|
'docs/SYSTEM_DOCUMENTATION_SIGN_OFF.docx',
|
|
];
|
|
|
|
foreach ($outputFiles as $outFile) {
|
|
if (file_exists($outFile)) {
|
|
unlink($outFile);
|
|
}
|
|
$zip = new ZipArchive();
|
|
if ($zip->open($outFile, ZipArchive::CREATE | ZipArchive::OVERWRITE) === true) {
|
|
$zip->addFromString('[Content_Types].xml', $contentTypesXml);
|
|
$zip->addFromString('_rels/.rels', $relsXml);
|
|
$zip->addFromString('word/_rels/document.xml.rels', $docRelsXml);
|
|
$zip->addFromString('word/styles.xml', $stylesXml);
|
|
$zip->addFromString('word/settings.xml', $settingsXml);
|
|
$zip->addFromString('word/document.xml', $documentXml);
|
|
$zip->close();
|
|
echo "Successfully generated: {$outFile}\n";
|
|
}
|
|
}
|