Filter Programs

Donor

Region

Status

Global Footprint

GIA supports programs across Sub‑Saharan Africa, North Africa & the Middle East, Asia‑Pacific, Latin America & the Caribbean, Europe & Central Asia, and North America.

Our advisory and compliance support enables governments and donors to deliver infrastructure that strengthens communities and drives sustainable development.

GIA-Website/pages/capabilities.html Capabilities Statement | Global Infrastructure Advisory

Global Infrastructure Advisory

Building Beyond Borders

Capabilities Statement

Advisory, compliance, and delivery support for donor‑funded infrastructure programs worldwide. Built on executive‑level governance, technical expertise, and mission‑driven public service.

Executive Summary

Global Infrastructure Advisory (GIA) provides advisory, compliance, and operational support for governments, donors, and implementing partners delivering infrastructure programs across emerging and frontier markets. Our work spans energy, water, transportation, digital infrastructure, health, education, and climate resilience.

Founded by federal acquisition and real property executive Kenneth Bennett, GIA combines executive‑level governance with field‑level technical experience — bridging policy, engineering, procurement, and delivery to ensure programs achieve measurable, sustainable impact.

We support donor‑funded missions across Sub‑Saharan Africa, North Africa & the Middle East, Asia‑Pacific, Latin America & the Caribbean, Europe & Central Asia, and North America.

Core Capabilities

Infrastructure Advisory

Technical, operational, and strategic advisory for infrastructure planning, delivery, and oversight.

Acquisition & Procurement

Federal‑grade procurement strategy, contract management, and donor‑aligned acquisition support.

Program & Portfolio Management

PMO support, governance frameworks, risk management, and performance monitoring.

Engineering & Technical Support

Multidisciplinary engineering support across energy, water, transportation, and digital systems.

Compliance & Safeguards

Environmental, social, fiduciary, and operational compliance aligned with donor requirements.

Workforce Development

Skilled workforce pipelines supporting engineering, construction, logistics, and mission delivery.

Sectors We Support

Energy & Power

Grid modernization, renewable energy, electrification, and T&D systems.

Water & Sanitation

WASH programs, water treatment, wastewater, and irrigation systems.

Transportation

Roads, bridges, ports, airports, and rail infrastructure.

Digital Infrastructure

Fiber networks, data centers, cloud migration, and cybersecurity.

Health & Education

Hospitals, clinics, schools, and training facilities.

Climate & Resilience

Climate adaptation, DRR, and resilient infrastructure systems.

Operating Regions

• Sub‑Saharan Africa
• North Africa & Middle East
• Asia‑Pacific
• Latin America & Caribbean
• Europe & Central Asia
• North America

Engagement Models

• Advisory & Technical Assistance
• PMO & Program Support Units
• Compliance & Safeguards Oversight
• Engineering & Field Support
• Workforce Development & Deployment
• Donor‑Aligned Procurement Support

Past Performance Highlights

GIA leadership has supported major federal and donor‑funded programs, including:

• U.S. General Services Administration — National acquisition governance
• Walter Reed / SAIC — Contracting & acquisition support
• Federal real property modernization initiatives
• Infrastructure and facilities programs across multiple U.S. agencies

Partner With Us

GIA supports governments, donors, and implementing partners in delivering infrastructure that transforms lives. Contact us to discuss your program or partnership needs.

GIA-Website/pages/global-projects.html Global Projects | Global Infrastructure Advisory

Global Infrastructure Advisory

Building Beyond Borders

Global Projects & Regional Footprint

GIA supports donor‑funded infrastructure programs across emerging and frontier markets, delivering advisory, compliance, and mission‑critical support across multiple regions worldwide.

Sub‑Saharan Africa

Supporting energy, water, transportation, digital infrastructure, and climate resilience programs across East, West, Central, and Southern Africa.

• Electrification & renewable energy
• Water & sanitation (WASH)
• Roads, bridges & logistics corridors
• Digital connectivity & cybersecurity

View Programs → Workforce →

North Africa & Middle East

Delivering infrastructure advisory and compliance support across water, energy, and public facilities.

• Water security & desalination
• Grid modernization
• Public buildings & facilities
• Climate adaptation

View Programs → Workforce →

Asia‑Pacific

Supporting infrastructure development across South Asia, Southeast Asia, and the Pacific Islands.

• Transportation & logistics
• Water & wastewater systems
• Digital infrastructure
• Disaster risk reduction

View Programs → Workforce →

Latin America & Caribbean

Delivering advisory and compliance support for climate resilience, water systems, and public infrastructure.

• Water & sanitation
• Climate resilience
• Public buildings
• Energy access

View Programs → Workforce →

Europe & Central Asia

Supporting modernization of public infrastructure, energy systems, and digital transformation.

• Energy transition
• Digital modernization
• Public facilities
• Transportation networks

View Programs → Workforce →

North America

Providing federal‑grade acquisition, compliance, and infrastructure advisory across the United States.

• Federal acquisition & procurement
• Real property modernization
• Public buildings & facilities
• Engineering & technical support

View Programs → Workforce →

GIA-Website/pages/insights.html Insights & Knowledge Center | Global Infrastructure Advisory

Global Infrastructure Advisory

Building Beyond Borders

Insights & Knowledge Center

Thought leadership, frameworks, and analysis on global infrastructure delivery, donor‑funded programs, and mission‑critical operations. Curated by Global Infrastructure Advisory.

Our Knowledge Mission

GIA’s Insights & Knowledge Center provides practical guidance, policy analysis, and technical frameworks for governments, donors, and implementing partners delivering infrastructure across emerging and frontier markets.

Our work draws from federal acquisition leadership, engineering experience, and global development practice — translating complex challenges into actionable insights.

Featured Insights

Strengthening Donor‑Funded Infrastructure Delivery

A framework for improving planning, procurement, and execution across multi‑sector infrastructure programs.

Read Insight →

Building Resilient Infrastructure in Emerging Markets

Key considerations for climate adaptation, risk reduction, and long‑term sustainability.

Read Insight →

Procurement Excellence for Global Development

Lessons from federal acquisition leadership applied to donor‑funded infrastructure programs.

Read Insight →

Digital Infrastructure as a Development Catalyst

How fiber, data centers, and cybersecurity shape economic growth and resilience.

Read Insight →

Workforce Development for Mission Delivery

Building skilled labor pipelines to support engineering, construction, and logistics operations.

Read Insight →

Governance & Compliance in Infrastructure Programs

Ensuring transparency, accountability, and safeguards across complex portfolios.

Read Insight →

Share Knowledge. Strengthen Impact.

GIA partners with governments, donors, and implementing agencies to advance infrastructure delivery through evidence‑based insights and practical frameworks.

GIA-Website/pages/insight-template.html Insight Title | Global Infrastructure Advisory

Global Infrastructure Advisory

Building Beyond Borders

Insight Title Goes Here

Subtitle or short description of the insight. This should be one or two sentences summarizing the key idea.

Author: Kenneth Bennett

Date: January 1, 2025

Sector: Energy & Power

Region: Global

Section Heading

This is where your insight content goes. You can write long‑form analysis, frameworks, policy guidance, or technical commentary. The template is designed to support multi‑section articles with clean spacing.

Subheading

Add paragraphs, bullet points, numbered lists, or diagrams as needed. This page is intentionally simple so you can duplicate it for each new insight without breaking your site structure.

Key point or recommendation
Framework element or principle
Technical or policy insight

Conclusion

Wrap up your insight with a clear takeaway or actionable recommendation. This is where you reinforce your expertise and provide value to donors, partners, and government clients.

Related Insights

Related Insight Title

Short description of the related insight. This helps readers explore more of your work.

Read Insight →

Another Insight

A brief summary of another relevant article or framework.

Read Insight →

Third Insight

Additional insight that connects to the topic or sector.

Read Insight →

Have a Project or Policy Challenge?

GIA provides advisory, compliance, and technical support for donor‑funded infrastructure programs worldwide. Contact us to discuss your needs.

GIA-Website/pages/workforce-join.html Join the Workforce | Global Infrastructure Advisory

Global Infrastructure Advisory

Building Beyond Borders

Join the Global Workforce

Become part of a growing workforce supporting infrastructure, engineering, construction, logistics, digital systems, and mission delivery across global development programs.

Who Can Join?

GIA welcomes skilled professionals, tradespeople, contractors, veterans, students, and general workforce applicants seeking opportunities across global infrastructure programs. Whether you are an engineer, technician, electrician, heavy equipment operator, project manager, or simply looking to build a career, you can join our workforce pool.

Your information will be reviewed and matched to opportunities as programs expand.

Workforce Intake Form

Full Name

Email Address

Phone Number

I am a...

Sector Interest

Preferred Region

Skills & Experience

Resume (optional)

Your Skills Can Change Communities

Join a global workforce supporting infrastructure, engineering, and mission delivery programs that strengthen nations and improve lives.

View Workforce Opportunities

GIA-Website/pages/contractor-register.html Contractor Registration | Global Infrastructure Advisory

Global Infrastructure Advisory

Building Beyond Borders

Contractor & Vendor Registration

Register your company to participate in infrastructure, engineering, construction, logistics, and mission‑delivery programs across global development markets.

Who Should Register?

GIA partners with contractors, subcontractors, engineering firms, trades companies, logistics providers, and specialized vendors supporting infrastructure delivery. Whether you are a small business, a veteran‑owned firm, a regional contractor, or a global engineering company — you can register to be considered for upcoming opportunities.

Your registration helps us match your capabilities to programs across energy, water, transportation, digital infrastructure, health, education, and climate resilience.

Contractor Registration Form

Company Name

Primary Contact Person

Email Address

Phone Number

Company Type

Sector Capabilities

Regions Served

Capabilities Statement (optional)

Experience & Past Performance

Partner With Us

GIA partners with contractors and vendors to deliver infrastructure that strengthens communities and supports global development missions.

View Active Programs

Global Infrastructure Advisory

Building Beyond Borders

Advisory, compliance, and delivery support for donor-funded infrastructure and global development programs.

Explore

Legal

Admin Dashboard | Global Infrastructure Advisory

Global Infrastructure Advisory

Admin Dashboard

Exit Admin →

Admin Dashboard

Manage programs, workforce applicants, contractors, opportunities, insights, and platform data. This dashboard gives you full control over your growing ecosystem.

Program Registry

Add, edit, and manage global infrastructure programs.

Workforce Applicants

Review and manage workforce intake submissions.

Contractor Registrations

Review contractor and vendor submissions.

Opportunities

Post and manage workforce and contractor opportunities.

Insights & Articles

Publish and manage thought‑leadership content.

Analytics Dashboard

View platform metrics, workforce growth, and contractor engagement.

Platform Settings

Manage configuration, branding, and system settings.

User Management

Manage admin accounts and access permissions.

Workforce Admin | Global Infrastructure Advisory

Workforce Admin

← Back to Dashboard

Workforce Applications

This page will display workforce submissions once backend integration is complete.

Name	Email	Type	Sector	Region	Actions
No submissions yet.

Contractor Admin | Global Infrastructure Advisory

Contractor Admin

← Back to Dashboard

Contractor Registrations

This page will display contractor submissions once backend integration is complete.

Company	Contact	Email	Sector	Region	Actions
No contractor registrations yet.

Opportunities Admin | Global Infrastructure Advisory

Opportunities Admin

← Back to Dashboard

Manage Opportunities

Post New Opportunity

Title

Sector

Region

Description

Existing Opportunities

Title	Sector	Region	Actions
No opportunities posted yet.

contractor-register.html opportunities-admin.html : server/auth.js const bcrypt = require('bcrypt'); const hashPassword = async (password) => { const saltRounds = 10; return await bcrypt.hash(password, saltRounds); }; const verifyPassword = async (password, hash) => { return await bcrypt.compare(password, hash); }; module.exports = { hashPassword, verifyPassword }; npm install bcrypt db.js: db.exec(` CREATE TABLE IF NOT EXISTS admin_users ( id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT UNIQUE, password_hash TEXT, created_at TEXT DEFAULT CURRENT_TIMESTAMP ); `); server/create-admin.js const db = require('./db'); const { hashPassword } = require('./auth'); (async () => { const username = "admin"; const password = "ChangeThisPassword123!"; const passwordHash = await hashPassword(password); db.prepare(` INSERT INTO admin_users (username, password_hash) VALUES (?, ?) `).run(username, passwordHash); console.log("Admin user created."); })(); node server/create-admin.js npm install express-session server.js: const session = require('express-session'); app.use(session({ secret: "super-secret-key-change-this", resave: false, saveUninitialized: false })); server.js const { verifyPassword } = require('./auth'); // LOGIN app.post('/api/admin/login', async (req, res) => { const { username, password } = req.body; const user = db.prepare(` SELECT * FROM admin_users WHERE username = ? `).get(username); if (!user) return res.redirect('/GIA-Website/pages/login.html?error=1'); const valid = await verifyPassword(password, user.password_hash); if (!valid) return res.redirect('/GIA-Website/pages/login.html?error=1'); req.session.admin = true; res.redirect('/GIA-Website/pages/admin.html'); }); // LOGOUT app.get('/api/admin/logout', (req, res) => { req.session.destroy(() => { res.redirect('/GIA-Website/pages/login.html'); }); }); server.js: function requireAdmin(req, res, next) { if (!req.session.admin) { return res.redirect('/GIA-Website/pages/login.html'); } next(); } app.get('/GIA-Website/pages/admin.html', requireAdmin, (req, res) => { res.sendFile(path.join(__dirname, '../pages/admin.html')); }); pages/login.html Admin Login | GIA

Admin Login

Username

Password

3D Blueprints & Simulation Hub | Global Infrastructure Advisory

Global Infrastructure Advisory

Building Beyond Borders

3D Blueprints & Simulation Hub

ANSYS-inspired 3D blueprints, digital twin layouts, and simulation-ready visuals for mines, pipelines, energy, water, and global infrastructure projects.

Engineering-Grade Visuals, Contractor-Friendly Language

This hub blends blueprint clarity, simulation overlays, and 3D digital twin concepts so both engineers and contractors can see how 3D improves planning, bidding, and delivery.

Mines

Shaft layouts, tunnel sections, stress maps, and ventilation flow diagrams.

Pipelines

Route alignment, pressure/flow overlays, and terrain-aware corridor planning.

Energy & Water

Substations, treatment plants, and distribution networks with simulation-ready views.

Explore Blueprint Library

Browse sector-specific blueprint modules for mines, pipelines, energy, water, transport, and digital infrastructure.

Open Blueprint Library

Request a Custom 3D Model

Need a project-specific 3D layout, simulation overlay, or digital twin concept? Submit a request and we’ll scope it with you.

Request 3D Blueprint

Upload Your Drawings

Already have drawings, PDFs, or CAD exports? Upload them and we’ll align them with 3D-ready, simulation-informed layouts.

Upload Drawings

Blueprint Library | Global Infrastructure Advisory

Global Infrastructure Advisory

Building Beyond Borders

Blueprint Library

Sector-specific blueprint modules inspired by 3D simulation and digital twin practices.

Underground Mine Layout

Shaft, drift, and stope layout with stress-aware sections and ventilation flow paths.

Sector: Mining • Region: Global

Download Sample (PDF)

Pipeline Corridor Alignment

Plan and profile sheets with terrain-aware routing and geohazard overlays.

Sector: Pipelines • Region: Global

Download Sample (PDF)

Substation & Transmission Layout

Substation footprint with line routing, clearances, and load-flow-informed equipment placement.

Sector: Energy • Region: Global

Download Sample (PDF)

Request 3D Blueprint | Global Infrastructure Advisory

Global Infrastructure Advisory

Building Beyond Borders

Request a Custom 3D Blueprint

Tell us about your mine, pipeline, energy, water, or infrastructure project and we’ll scope a 3D, simulation-informed layout.

Upload Drawings | Global Infrastructure Advisory

Global Infrastructure Advisory

Building Beyond Borders

Upload Drawings for 3D Enhancement

Upload PDFs, CAD exports, or sketches. We’ll align them with 3D-ready, simulation-informed layouts.

Blueprints Admin | Global Infrastructure Advisory

Blueprints Admin

← Back to Dashboard

Blueprint Requests

Name	Email	Company	Sector	Region	Description
Loading...

Blueprint Uploads

Name	Email	Company	Sector	Region	File Type
Loading...

3D Blueprints

Manage blueprint requests and contractor uploads for 3D and simulation-informed layouts.

Matches for Selected Opportunity

Workforce Matches

Name	Sector	Region	Score
Select an opportunity.

Contractor Matches

Company	Sector	Region	Score
Select an opportunity.

Global Engineering Marketplace | Global Infrastructure Advisory

Global Infrastructure Advisory

Building Beyond Borders

Global Engineering Marketplace

Connecting programs, opportunities, contractors, workforce, and 3D blueprints into a single, donor-ready infrastructure delivery platform.

How the Marketplace Works

GIA’s marketplace links donor-funded programs, infrastructure opportunities, contractors, workforce, and 3D blueprint services. Instead of scattered spreadsheets and emails, everything flows through a structured, transparent system.

Programs & Opportunities

Donors and governments define programs and post opportunities for delivery.

Contractors & Workforce

Companies and individuals register their capabilities, sectors, and regions.

3D Blueprints & Matching

3D-ready blueprints and matching logic align the right teams to the right work.

For Donors & Programs

Define programs, publish opportunities, and see a structured view of who can deliver—by sector, region, and capability.

• Transparent contractor and workforce pools
• Sector and region-based matching
• 3D blueprints to de-risk design and delivery

For Contractors & Workforce

• Opportunities filtered by sector and geography
• 3D blueprint support for bids and execution
• Visibility across multiple programs and donors

Matching Logic in Plain Language

Behind the scenes, the marketplace uses structured fields—sector, region, and capability—to rank how well workforce and contractors align with each opportunity.

• Sector match (e.g., mines, pipelines, energy, water)
• Region match (e.g., Sub-Saharan Africa, Asia-Pacific)
• Capability match (role, company type, skills)

The result is a transparent, explainable matching system that donors, governments, and delivery partners can understand and trust.

Join as Workforce

Join Workforce

Register as Contractor

Position your company for donor-funded and private infrastructure projects.

Explore 3D Blueprints

See how 3D and simulation-informed layouts support better delivery.

Open 3D Hub

Details

Global Infrastructure Advisory

Building Beyond Borders

Global Infrastructure Advisory

Building Beyond Borders

Leadership & Governance | Global Infrastructure Advisory

Global Infrastructure Advisory

Building Beyond Borders

Leadership & Governance

A platform built for long-term continuity, institutional stability, and global infrastructure delivery.

Kenneth Bennett

Founder & Chief Executive Officer

Kenneth Bennett is a federal acquisition and infrastructure executive with more than two decades of experience supporting public service, defense, construction, and global development programs. His leadership grounds the platform in engineering precision, operational discipline, and long-term institutional thinking.

As Founder & CEO, he established Global Infrastructure Advisory with a 100-year vision: a platform that will continue to serve communities, contractors, and development partners long after its founder is gone.

Governance Model

Global Infrastructure Advisory is structured to operate as a long-term digital institution. Its governance model ensures continuity, transparency, and stability across leadership transitions, funding cycles, and global operations.

Executive Leadership

Provides strategic direction, oversees platform development, and ensures alignment with global infrastructure needs and donor requirements.

Advisory Council

A rotating group of technical, engineering, and development experts who guide platform evolution and ensure long-term relevance.

Operational Continuity

Systems, documentation, and digital infrastructure designed to ensure the platform remains functional and effective for future generations.

A Platform Built for 100 Years

Global Infrastructure Advisory is engineered for long-term continuity. Its mission, systems, and governance structure ensure that the platform will continue to support global infrastructure delivery long after its original leadership has passed the torch.

Global Infrastructure Advisory

GLOBAL INFRASTRUCTURE ADVISORY

Engineered to Build Beyond Borders

Explore Services

Mission‑Driven Infrastructure Advisory

We support governments, donors, and implementing partners with engineering‑grade advisory services, procurement readiness, and compliant project delivery frameworks.

Admin Dashboard – GIA

Programs

Title	Type	Program	Org	Location
${o.title}	${o.type}	${o.program_area}	${o.organization \|\| ""}	${o.location \|\| ""}

Key	Name	Program	Price	Active
${p.product_key}	${p.product_name}	${p.program_area}	${p.price}	${p.active ? "Yes" : "No"}

Email	Role	Created
${u.email}	${u.role}	${u.created_at}

${JSON.stringify(logs, null, 2)}

Program Registry Admin – GIA

Program Registry Admin

Add New Program

Existing Programs

Slug	Name	Region	Active

GIA Product Feed ${baseUrl} Digital products and templates `; products.rows.forEach(p => { xml += ` ${p.product_key} ${baseUrl}${p.delivery_url} ${p.price} USD new in_stock `; }); xml += `

Program Registry Admin – GIA

Program Registry Admin

Add New Program

Existing Programs

Slug	Name	Region	Active

GIA Product Feed ${baseUrl} Digital products and templates `; products.rows.forEach(p => { xml += ` ${p.product_key} ${baseUrl}${p.delivery_url} ${p.price} USD new in_stock `; }); xml += `

` Format: JSON (except file downloads) --- ## 1. Endpoints Overview | Method | Endpoint | Description | |--------|----------|-------------| | POST | `/` | Create document metadata or upload file | | POST | `/:id/generate` | Generate PDF from template + data | | GET | `/` | List documents (filterable) | | GET | `/:id` | Get document metadata | | POST | `/:id/tokens` | Create secure download token | | GET | `/:id/tokens` | List active tokens | | DELETE | `/tokens/:token` | Revoke token | | GET | `/download/:token` | Secure download | | GET | `/:id/logs` | Access logs | --- ## 2. Document Model ```json { "id": "string", "title": "string", "filename": "string", "program_area": "string", "tags": ["string"], "version": "1.0", "storage_provider": "local | s3 | r2", "storage_path": "string", "created_by": "email", "created_at": "ISO8601", "download_count": 0 } ``` --- ## 3. Token Model (Secure Download Links) ```json { "token": "string", "doc_id": "string", "expires_at": "ISO8601", "max_uses": 1, "used_count": 0, "created_for": "email", "created_at": "ISO8601" } ``` --- ## 4. Endpoint Details ### POST /v1/docs Create metadata + upload a file. **Request** ```json { "title": "PMO Framework", "program_area": "Global", "tags": ["template", "pmo"], "version": "1.0" } ``` **Response** ```json { "status": "created", "id": "doc_12345" } ``` --- ### POST /v1/docs/:id/generate Generate a PDF from a template + data. **Request** ```json { "template": "capability-statement", "data": { "company_name": "Global Infrastructure Advisory", "program": "WV–Ireland Alliance" } } ``` **Response** ```json { "status": "generated", "id": "doc_12345", "version": "1.1" } ``` --- ### GET /v1/docs List documents with filters. **Query Params** - `program_area` - `tag` - `version` - `search` **Response** ```json [ { "id": "doc_12345", "title": "PMO Framework", "program_area": "Global", "tags": ["template"], "version": "1.0" } ] ``` --- ### GET /v1/docs/:id Get metadata for a document. --- ### POST /v1/docs/:id/tokens Create a secure download token. **Request** ```json { "expires_in": 86400, "max_uses": 1, "email": "client@example.com" } ``` **Response** ```json { "token": "abc123", "download_url": "https://api.globalinfrastructureadvisory.com/v1/docs/download/abc123" } ``` --- ### GET /v1/docs/:id/tokens List active tokens for a document. --- ### DELETE /v1/docs/tokens/:token Revoke a token. --- ### GET /v1/docs/download/:token Secure download endpoint. **Behavior** - Validates token - Checks expiration - Checks max uses - Logs download - Streams file --- ### GET /v1/docs/:id/logs Access logs for a document. **Response** ```json [ { "timestamp": "2026-03-19T21:00:00Z", "email": "client@example.com", "ip": "123.45.67.89", "user_agent": "Chrome", "token": "abc123" } ] ``` --- ## 5. Event Emission (Next‑Gen) Events emitted: - `doc.created` - `doc.generated` - `doc.token.created` - `doc.token.revoked` - `doc.downloaded` --- ## 6. Storage Provider Abstraction Supported providers: - local filesystem - S3 - Cloudflare R2 - Azure Blob Switching providers requires config only. --- ## 7. Zero‑Trust Security Model - Every request authenticated - Every action logged - Tokens scoped to a document - Tokens tied to an email - Optional IP binding - Optional single‑use tokens - Optional short‑lived signed URLs /pages/document-manager.html document-manager.html Document Manager – GIA

Document Manager

Manage documents, generate PDFs, create secure links, and view logs.

Upload Document

Title Program Area Tags (comma separated) Version Upload File

Generate PDF

Document ID Template Name Data (JSON)

Documents

ID	Title	Program	Version	Actions

Create Secure Download Link

Document ID Email (optional) Expires In (seconds) Max Uses

Document Logs

Document ID

Timestamp	Email	IP	User Agent	Token

backend/routes/docs.js // backend/routes/docs.js import express from "express"; import pool from "../config/db.js"; import fs from "fs"; import path from "path"; const router = express.Router(); // CONFIG: adjust this to your storage root const LOCAL_DOCS_ROOT = path.join(process.cwd(), "docs"); // Helper: load document by id async function getDocumentById(id) { const result = await pool.query( `SELECT id, title, filename, storage_provider, storage_path FROM documents WHERE id = $1`, [id] ); return result.rows[0] || null; } // Helper: load token async function getToken(token) { const result = await pool.query( `SELECT token, doc_id, expires_at, max_uses, used_count, created_for FROM doc_tokens WHERE token = $1`, [token] ); return result.rows[0] || null; } // Helper: increment token usage async function incrementTokenUse(token) { await pool.query( `UPDATE doc_tokens SET used_count = used_count + 1 WHERE token = $1`, [token] ); } // Helper: log download async function logDownload({ doc_id, token, email, ip, user_agent }) { await pool.query( `INSERT INTO doc_download_logs (doc_id, token, email, ip, user_agent) VALUES ($1, $2, $3, $4, $5)`, [doc_id, token, email, ip, user_agent] ); } // GET /v1/docs/download/:token router.get("/v1/docs/download/:token", async (req, res) => { try { const { token } = req.params; const now = new Date(); const tokenRow = await getToken(token); if (!tokenRow) { return res.status(404).json({ error: "Invalid token" }); } // Check expiration if (tokenRow.expires_at && new Date(tokenRow.expires_at) < now) { return res.status(410).json({ error: "Token expired" }); } // Check max uses if ( tokenRow.max_uses !== null && tokenRow.max_uses !== undefined && tokenRow.used_count >= tokenRow.max_uses ) { return res.status(429).json({ error: "Token usage limit reached" }); } const doc = await getDocumentById(tokenRow.doc_id); if (!doc) { return res.status(404).json({ error: "Document not found" }); } // For now: local storage only (storage_provider = 'local') if (doc.storage_provider !== "local") { return res .status(501) .json({ error: "Storage provider not implemented in this route" }); } const filePath = path.join(LOCAL_DOCS_ROOT, doc.storage_path || doc.filename); if (!fs.existsSync(filePath)) { return res.status(404).json({ error: "File not found on server" }); } // Log download await logDownload({ doc_id: doc.id, token: tokenRow.token, email: tokenRow.created_for || null, ip: req.ip, user_agent: req.headers["user-agent"] || "" }); // Increment token usage await incrementTokenUse(tokenRow.token); // Stream file res.download(filePath, doc.filename); } catch (err) { console.error("Download error:", err); res.status(500).json({ error: "Error processing download" }); } }); export default router; backend/routes/docs.js // backend/routes/docs.js import express from "express"; import pool from "../config/db.js"; import multer from "multer"; import path from "path"; import fs from "fs"; const router = express.Router(); // Local storage root const LOCAL_DOCS_ROOT = path.join(process.cwd(), "docs"); // Ensure docs folder exists if (!fs.existsSync(LOCAL_DOCS_ROOT)) { fs.mkdirSync(LOCAL_DOCS_ROOT, { recursive: true }); } // Multer for file uploads const upload = multer({ dest: LOCAL_DOCS_ROOT }); /* --------------------------------------------------------- 1. CREATE DOCUMENT METADATA + UPLOAD FILE POST /v1/docs --------------------------------------------------------- */ router.post("/v1/docs", upload.single("file"), async (req, res) => { try { const { title, program_area, tags, version } = req.body; const file = req.file; if (!file) { return res.status(400).json({ error: "File is required" }); } const filename = file.originalname; const storage_path = file.filename; // stored name const result = await pool.query( `INSERT INTO documents (title, filename, program_area, tags, version, storage_provider, storage_path) VALUES ($1, $2, $3, $4, $5, 'local', $6) RETURNING id`, [title, filename, program_area, tags, version, storage_path] ); res.json({ status: "created", id: result.rows[0].id }); } catch (err) { console.error("Upload error:", err); res.status(500).json({ error: "Error uploading document" }); } }); /* --------------------------------------------------------- 2. GENERATE PDF FROM TEMPLATE POST /v1/docs/:id/generate --------------------------------------------------------- */ router.post("/v1/docs/:id/generate", async (req, res) => { try { const { id } = req.params; const { template, data } = req.body; // Placeholder: actual PDF generation logic goes here // For now, we simulate a new version being created const newVersion = Date.now().toString(); await pool.query( `UPDATE documents SET version = $1 WHERE id = $2`, [newVersion, id] ); res.json({ status: "generated", id, version: newVersion }); } catch (err) { console.error("Generate error:", err); res.status(500).json({ error: "Error generating PDF" }); } }); /* --------------------------------------------------------- 3. LIST DOCUMENTS GET /v1/docs --------------------------------------------------------- */ router.get("/v1/docs", async (req, res) => { try { const result = await pool.query( `SELECT id, title, program_area, tags, version FROM documents ORDER BY created_at DESC` ); res.json(result.rows); } catch (err) { console.error("List error:", err); res.status(500).json({ error: "Error loading documents" }); } }); /* --------------------------------------------------------- 4. GET DOCUMENT METADATA GET /v1/docs/:id --------------------------------------------------------- */ router.get("/v1/docs/:id", async (req, res) => { try { const result = await pool.query( `SELECT * FROM documents WHERE id = $1`, [req.params.id] ); if (!result.rows.length) { return res.status(404).json({ error: "Document not found" }); } res.json(result.rows[0]); } catch (err) { console.error("Metadata error:", err); res.status(500).json({ error: "Error loading metadata" }); } }); /* --------------------------------------------------------- 5. CREATE SECURE DOWNLOAD TOKEN POST /v1/docs/:id/tokens --------------------------------------------------------- */ router.post("/v1/docs/:id/tokens", async (req, res) => { try { const { id } = req.params; const { expires_in, max_uses, email } = req.body; const token = Math.random().toString(36).substring(2, 12); const expires_at = new Date(Date.now() + expires_in * 1000); await pool.query( `INSERT INTO doc_tokens (token, doc_id, expires_at, max_uses, used_count, created_for) VALUES ($1, $2, $3, $4, 0, $5)`, [token, id, expires_at, max_uses, email] ); res.json({ token, download_url: `https://api.globalinfrastructureadvisory.com/v1/docs/download/${token}` }); } catch (err) { console.error("Token error:", err); res.status(500).json({ error: "Error creating token" }); } }); /* --------------------------------------------------------- 6. LIST TOKENS FOR A DOCUMENT GET /v1/docs/:id/tokens --------------------------------------------------------- */ router.get("/v1/docs/:id/tokens", async (req, res) => { try { const result = await pool.query( `SELECT token, expires_at, max_uses, used_count, created_for FROM doc_tokens WHERE doc_id = $1`, [req.params.id] ); res.json(result.rows); } catch (err) { console.error("Token list error:", err); res.status(500).json({ error: "Error loading tokens" }); } }); /* --------------------------------------------------------- 7. REVOKE TOKEN DELETE /v1/docs/tokens/:token --------------------------------------------------------- */ router.delete("/v1/docs/tokens/:token", async (req, res) => { try { await pool.query( `DELETE FROM doc_tokens WHERE token = $1`, [req.params.token] ); res.json({ status: "revoked" }); } catch (err) { console.error("Revoke error:", err); res.status(500).json({ error: "Error revoking token" }); } }); /* --------------------------------------------------------- 8. DOWNLOAD GATEWAY (from previous file) GET /v1/docs/download/:token --------------------------------------------------------- */ // This route is already implemented in your previous file. // Keep it in the same router or merge it here. export default router; // server.js import express from "express"; import cors from "cors"; import docsRouter from "./routes/docs.js"; // <-- Document Manager Routes import feedRouter from "./routes/feed.js"; // (already in your system) import rssRouter from "./routes/rss.js"; // (already in your system) import programsRouter from "./routes/programs.js"; import opportunitiesRouter from "./routes/opportunities.js"; import productsRouter from "./routes/products.js"; import usersRouter from "./routes/users.js"; import logsRouter from "./routes/logs.js"; const app = express(); // Middleware app.use(cors()); app.use(express.json()); // ROUTES app.use(docsRouter); // <-- Document Manager API (v1) app.use(feedRouter); app.use(rssRouter); app.use(programsRouter); app.use(opportunitiesRouter); app.use(productsRouter); app.use(usersRouter); app.use(logsRouter); // Health Check app.get("/", (req, res) => { res.json({ status: "GIA Backend Running" }); }); // Start Server const PORT = process.env.PORT || 5000; app.listen(PORT, () => { console.log(`GIA backend running on port ${PORT}`); }); /database/schema-document-manager.sql schema-document-manager.sql -- ============================================================ -- DOCUMENT MANAGER – DATABASE SCHEMA (v1) -- Compatible with PostgreSQL -- ============================================================ -- ------------------------------------------------------------ -- 1. DOCUMENTS TABLE -- ------------------------------------------------------------ CREATE TABLE IF NOT EXISTS documents ( id SERIAL PRIMARY KEY, title TEXT NOT NULL, filename TEXT NOT NULL, program_area TEXT, tags TEXT, version TEXT DEFAULT '1.0', storage_provider TEXT DEFAULT 'local', storage_path TEXT, created_by TEXT, created_at TIMESTAMP DEFAULT NOW(), download_count INTEGER DEFAULT 0 ); -- ------------------------------------------------------------ -- 2. SECURE TOKENS TABLE -- ------------------------------------------------------------ CREATE TABLE IF NOT EXISTS doc_tokens ( token TEXT PRIMARY KEY, doc_id INTEGER REFERENCES documents(id) ON DELETE CASCADE, expires_at TIMESTAMP, max_uses INTEGER DEFAULT 1, used_count INTEGER DEFAULT 0, created_for TEXT, created_at TIMESTAMP DEFAULT NOW() ); -- Index for faster lookups CREATE INDEX IF NOT EXISTS idx_doc_tokens_doc_id ON doc_tokens (doc_id); -- ------------------------------------------------------------ -- 3. DOWNLOAD LOGS TABLE -- ------------------------------------------------------------ CREATE TABLE IF NOT EXISTS doc_download_logs ( id SERIAL PRIMARY KEY, doc_id INTEGER REFERENCES documents(id) ON DELETE CASCADE, token TEXT, email TEXT, ip TEXT, user_agent TEXT, downloaded_at TIMESTAMP DEFAULT NOW() ); -- Index for analytics CREATE INDEX IF NOT EXISTS idx_doc_logs_doc_id ON doc_download_logs (doc_id); -- ------------------------------------------------------------ -- 4. OPTIONAL: EVENT LOGS (NEXT-GEN) -- ------------------------------------------------------------ CREATE TABLE IF NOT EXISTS doc_events ( id SERIAL PRIMARY KEY, event_type TEXT NOT NULL, doc_id INTEGER, token TEXT, metadata JSONB, created_at TIMESTAMP DEFAULT NOW() ); -- Index for event queries CREATE INDEX IF NOT EXISTS idx_doc_events_type ON doc_events (event_type); backend/services/pdfGenerator.js // backend/services/pdfGenerator.js import fs from "fs"; import path from "path"; import pdf from "html-pdf"; const TEMPLATE_ROOT = path.join(process.cwd(), "templates"); const OUTPUT_ROOT = path.join(process.cwd(), "docs/generated"); // Ensure output folder exists if (!fs.existsSync(OUTPUT_ROOT)) { fs.mkdirSync(OUTPUT_ROOT, { recursive: true }); } /** * Load an HTML template by name */ function loadTemplate(templateName) { const filePath = path.join(TEMPLATE_ROOT, `${templateName}.html`); if (!fs.existsSync(filePath)) { throw new Error(`Template not found: ${templateName}`); } return fs.readFileSync(filePath, "utf8"); } /** * Replace {{placeholders}} in the template with data */ function applyDataToTemplate(html, data) { let output = html; for (const key in data) { const placeholder = new RegExp(`{{${key}}}`, "g"); output = output.replace(placeholder, data[key]); } return output; } /** * Generate a PDF from a template + data */ export async function generatePDF(templateName, data) { return new Promise((resolve, reject) => { try { const html = loadTemplate(templateName); const filled = applyDataToTemplate(html, data); const filename = `${templateName}-${Date.now()}.pdf`; const outputPath = path.join(OUTPUT_ROOT, filename); pdf.create(filled).toFile(outputPath, (err, res) => { if (err) return reject(err); resolve({ filename, path: outputPath }); }); } catch (err) { reject(err); } }); } /templates/templateName.html {{company_name}} → “Global Infrastructure Advisory /docs/generated/ const pdf = await generatePDF("capability-statement", data); templates/capability-statement.html {{company_name}} – Capability Statement

Program: {{program}}

Website: {{website}}

Email: {{email}}

Phone: {{phone}}

Core Competencies

Differentiators

Past Performance

DUNS: {{duns}}
UEI: {{uei}}
CAGE: {{cage}}

NAICS: {{naics}}
PSC: {{psc}}
Socioeconomic: {{socioeconomic}}

Key Contacts

await generatePDF("capability-statement", { company_name: "Global Infrastructure Advisory", program: "WV–Ireland Alliance", website: "https://globalinfrastructureadvisory.com", email: "info@example.com", phone: "+1 (555) 123-4567", core_competencies: "...", differentiators: "...", past_performance: "...", duns: "...", uei: "...", cage: "...", naics: "...", psc: "...", socioeconomic: "...", key_contacts: "..." }); templates/program-sheet.html program-sheet.html {{program_name}} – Program Sheet

Region: {{region}}

Sponsor: {{sponsor}}

Program Lead: {{program_lead}}

Contact Email: {{contact_email}}

Program Overview

Objectives

Target Beneficiaries

Key Activities

Start Date: {{start_date}}
End Date: {{end_date}}
Status: {{status}}

Funding Source: {{funding_source}}
Budget: {{budget}}
Currency: {{currency}}

Partners & Stakeholders

Risks & Mitigation

Monitoring & Evaluation

templates/contractor-profile.html contractor-profile.html {{full_name}} – Contractor Profile

Location: {{location}}

Email: {{email}}

Phone: {{phone}}

Availability: {{availability}}

Professional Summary

Core Skills

Certifications

Work Experience

Years of Experience: {{years_experience}}
Primary Sector: {{primary_sector}}
Secondary Sector: {{secondary_sector}}

Hourly Rate: {{hourly_rate}}
Daily Rate: {{daily_rate}}
Contract Type: {{contract_type}}

Languages

Tools & Technologies

References

templates/opportunity-summary.html opportunity-summary.html {{opportunity_title}} – Opportunity Summary

Program: {{program}}

Region: {{region}}

Sponsor: {{sponsor}}

Contact Email: {{contact_email}}

Opportunity Overview

Scope of Work

Required Skills

Deliverables

Start Date: {{start_date}}
End Date: {{end_date}}
Status: {{status}}

Budget: {{budget}}
Funding Source: {{funding_source}}
Currency: {{currency}}

Eligibility Requirements

Submission Instructions

Evaluation Criteria

templates/workforce-profile.html workforce-profile.html {{full_name}} – Workforce Profile

Location: {{location}}

Email: {{email}}

Phone: {{phone}}

Availability: {{availability}}

Preferred Work Type: {{work_type}}

Professional Summary

Skills & Competencies

Certifications & Training

Work History

Years of Experience: {{years_experience}}
Primary Sector: {{primary_sector}}
Secondary Sector: {{secondary_sector}}

Hourly Rate: {{hourly_rate}}
Daily Rate: {{daily_rate}}
Employment Type: {{employment_type}}

Languages

Tools & Technologies

References

DOCUMENT-MANAGER-FOLDER-STRUCTURE.md # Document Manager – Folder Structure (v1) This structure organizes: - Backend routes - Services (PDF generator) - Templates - Generated PDFs - Database schema - API specs - Admin UI ``` project-root/ │ ├── backend/ │ ├── routes/ │ │ └── docs.js # Document Manager API routes │ │ │ ├── services/ │ │ └── pdfGenerator.js # PDF generation engine │ │ │ ├── config/ │ │ └── db.js # Database connection │ │ │ └── server.js # Express server wiring │ ├── templates/ │ ├── capability-statement.html │ ├── program-sheet.html │ ├── contractor-profile.html │ ├── opportunity-summary.html │ └── workforce-profile.html │ ├── docs/ │ ├── generated/ # Auto-generated PDFs │ └── uploads/ # (Optional) raw uploaded files │ ├── database/ │ └── schema-document-manager.sql # PostgreSQL schema │ ├── api-specs/ │ └── document-manager-v1.yaml # OpenAPI spec │ ├── pages/ │ └── document-manager.html # Admin UI │ ├── logs/ │ └── (optional) event logs, audit logs │ ├── .env # Environment variables │ └── README.md # Developer documentation ``` backend/services/matchingEngine.js matchingEngine.js // backend/services/matchingEngine.js /** * Next‑Gen Matching Engine (v1) * ----------------------------------------- * This engine scores matches between: * - Workforce ↔ Opportunities * - Contractors ↔ Opportunities * - Workforce ↔ Programs * * Scoring is transparent, explainable, and donor‑aligned. * Each scoring component returns: * { score: Number, reason: String } */ export function matchCandidateToOpportunity(candidate, opportunity) { const results = []; // 1. Skills Match results.push(scoreSkills(candidate.skills, opportunity.required_skills)); // 2. Sector Alignment results.push(scoreSector(candidate.primary_sector, opportunity.sector)); // 3. Experience Level results.push(scoreExperience(candidate.years_experience, opportunity.min_experience)); // 4. Location / Region results.push(scoreLocation(candidate.location, opportunity.region)); // 5. Availability results.push(scoreAvailability(candidate.availability, opportunity.start_date)); // Final score (0–100) const finalScore = Math.round( results.reduce((sum, r) => sum + r.score, 0) / results.length ); return { candidate_id: candidate.id, opportunity_id: opportunity.id, score: finalScore, breakdown: results }; } /* --------------------------------------------------------- SCORING COMPONENTS --------------------------------------------------------- */ function scoreSkills(candidateSkills = [], requiredSkills = []) { if (!requiredSkills.length) { return { score: 100, reason: "No required skills listed" }; } const matches = requiredSkills.filter(s => candidateSkills.map(x => x.toLowerCase()).includes(s.toLowerCase()) ); const score = Math.round((matches.length / requiredSkills.length) * 100); return { score, reason: `Matched ${matches.length} of ${requiredSkills.length} required skills` }; } function scoreSector(candidateSector, opportunitySector) { if (!opportunitySector) return { score: 100, reason: "No sector specified" }; const score = candidateSector?.toLowerCase() === opportunitySector?.toLowerCase() ? 100 : 40; return { score, reason: score === 100 ? "Primary sector aligns" : "Sector mismatch" }; } function scoreExperience(candidateYears, requiredYears) { if (!requiredYears) return { score: 100, reason: "No experience requirement" }; const score = candidateYears >= requiredYears ? 100 : Math.max(20, Math.round((candidateYears / requiredYears) * 100)); return { score, reason: `Candidate has ${candidateYears} years; required ${requiredYears}` }; } function scoreLocation(candidateLocation, opportunityRegion) { if (!opportunityRegion) return { score: 100, reason: "No region specified" }; const score = candidateLocation?.toLowerCase() === opportunityRegion?.toLowerCase() ? 100 : 60; return { score, reason: score === 100 ? "Candidate is in the target region" : "Candidate is outside the target region" }; } function scoreAvailability(candidateAvailability, startDate) { if (!startDate) return { score: 100, reason: "No start date specified" }; // Simple version: if candidate is "Immediate", give full score if (candidateAvailability?.toLowerCase() === "immediate") { return { score: 100, reason: "Immediate availability" }; } return { score: 70, reason: "Availability acceptable but not immediate" }; } .env.example # ============================================================ # GLOBAL INFRASTRUCTURE ADVISORY – DOCUMENT MANAGER (v1) # ============================================================ # ------------------------------------------------------------ # SERVER CONFIG # ------------------------------------------------------------ PORT=5000 NODE_ENV=development # ------------------------------------------------------------ # DATABASE (PostgreSQL) # ------------------------------------------------------------ DB_HOST=localhost DB_PORT=5432 DB_USER=postgres DB_PASSWORD=yourpassword DB_NAME=gia # ------------------------------------------------------------ # STORAGE PROVIDER # Options: local | s3 | r2 # ------------------------------------------------------------ STORAGE_PROVIDER=local # Local storage root (used when STORAGE_PROVIDER=local) LOCAL_STORAGE_PATH=./docs # ------------------------------------------------------------ # AWS S3 (optional) # ------------------------------------------------------------ AWS_ACCESS_KEY_ID= AWS_SECRET_ACCESS_KEY= AWS_REGION= AWS_S3_BUCKET= # ------------------------------------------------------------ # CLOUDFLARE R2 (optional) # ------------------------------------------------------------ R2_ACCESS_KEY_ID= R2_SECRET_ACCESS_KEY= R2_BUCKET= R2_ACCOUNT_ID= R2_PUBLIC_URL= # ------------------------------------------------------------ # SECURITY # ------------------------------------------------------------ JWT_SECRET=changeme TOKEN_EXPIRATION_HOURS=24 # ------------------------------------------------------------ # PDF GENERATION # ------------------------------------------------------------ PDF_OUTPUT_PATH=./docs/generated # ------------------------------------------------------------ # LOGGING # ------------------------------------------------------------ LOG_LEVEL=info backend/services/storageProvider.js storageProvider.js // backend/services/storageProvider.js import fs from "fs"; import path from "path"; import { S3Client, PutObjectCommand, GetObjectCommand } from "@aws-sdk/client-s3"; const provider = process.env.STORAGE_PROVIDER || "local"; /* --------------------------------------------------------- LOCAL STORAGE IMPLEMENTATION --------------------------------------------------------- */ const LOCAL_ROOT = process.env.LOCAL_STORAGE_PATH || "./docs/uploads"; function ensureLocalDir() { if (!fs.existsSync(LOCAL_ROOT)) { fs.mkdirSync(LOCAL_ROOT, { recursive: true }); } } function saveLocal(file, filename) { ensureLocalDir(); const dest = path.join(LOCAL_ROOT, filename); fs.renameSync(file.path, dest); return dest; } function getLocalPath(filename) { return path.join(LOCAL_ROOT, filename); } /* --------------------------------------------------------- AWS S3 / CLOUDFLARE R2 IMPLEMENTATION --------------------------------------------------------- */ const s3 = new S3Client({ region: process.env.AWS_REGION || "auto", endpoint: process.env.R2_PUBLIC_URL || undefined, credentials: { accessKeyId: process.env.AWS_ACCESS_KEY_ID || process.env.R2_ACCESS_KEY_ID, secretAccessKey: process.env.AWS_SECRET_ACCESS_KEY || process.env.R2_SECRET_ACCESS_KEY } }); async function saveS3(file, filename) { const fileBuffer = fs.readFileSync(file.path); await s3.send( new PutObjectCommand({ Bucket: process.env.AWS_S3_BUCKET || process.env.R2_BUCKET, Key: filename, Body: fileBuffer, ContentType: file.mimetype }) ); fs.unlinkSync(file.path); return filename; } function getS3Path(filename) { const bucket = process.env.AWS_S3_BUCKET || process.env.R2_BUCKET; const base = process.env.R2_PUBLIC_URL || `https://${bucket}.s3.amazonaws.com`; return `${base}/${filename}`; } /* --------------------------------------------------------- EXPORT UNIFIED INTERFACE --------------------------------------------------------- */ export async function saveFile(file, filename) { if (provider === "local") { return saveLocal(file, filename); } return await saveS3(file, filename); } export function getFilePath(filename) { if (provider === "local") { return getLocalPath(filename); } return getS3Path(filename); } await saveFile(file, filename); const path = getFilePath(filename); .env STORAGE_PROVIDER=s3 STORAGE_PROVIDER=r2 POST /v1/match backend/routes/match.js match.js // backend/routes/match.js import express from "express"; import { matchCandidateToOpportunity } from "../services/matchingEngine.js"; const router = express.Router(); /** * POST /v1/match * Body: * { * "candidate": { ... }, * "opportunity": { ... } * } */ router.post("/v1/match", (req, res) => { try { const { candidate, opportunity } = req.body; if (!candidate || !opportunity) { return res.status(400).json({ error: "candidate and opportunity are required" }); } const result = matchCandidateToOpportunity(candidate, opportunity); return res.json({ status: "success", match: result }); } catch (err) { console.error("Matching error:", err); return res.status(500).json({ error: "Internal server error" }); } }); export default router; import matchRouter from "./routes/match.js"; app.use(matchRouter); POST /v1/match pages/matching-dashboard.html matching-dashboard.html Matching Dashboard – GIA

Matching Dashboard

Paste a candidate and opportunity JSON below to generate a match score.

Candidate JSON

Opportunity JSON

Match Result

backend/services/bulkMatcher.js bulkMatcher.js // backend/services/bulkMatcher.js import { matchCandidateToOpportunity } from "./matchingEngine.js"; /** * Bulk match MANY candidates to ONE opportunity * ------------------------------------------------ * Input: * candidates: [ { ... }, { ... }, ... ] * opportunity: { ... } * * Output: * [ * { candidate_id, score, breakdown }, * ... * ] sorted by score DESC */ export function matchManyCandidatesToOpportunity(candidates, opportunity) { const results = candidates.map(candidate => { const match = matchCandidateToOpportunity(candidate, opportunity); return { candidate_id: candidate.id, score: match.score, breakdown: match.breakdown, candidate }; }); // Sort by score descending return results.sort((a, b) => b.score - a.score); } /** * Bulk match ONE candidate to MANY opportunities * ------------------------------------------------ * Input: * candidate: { ... } * opportunities: [ { ... }, { ... }, ... ] * * Output: * [ * { opportunity_id, score, breakdown }, * ... * ] sorted by score DESC */ export function matchCandidateToManyOpportunities(candidate, opportunities) { const results = opportunities.map(opportunity => { const match = matchCandidateToOpportunity(candidate, opportunity); return { opportunity_id: opportunity.id, score: match.score, breakdown: match.breakdown, opportunity }; }); // Sort by score descending return results.sort((a, b) => b.score - a.score); } /** * Bulk match MANY candidates to MANY opportunities * ------------------------------------------------ * This is the foundation for: * - Marketplace auto‑matching * - Workforce assignment engines * - Donor reporting dashboards */ export function matchMatrix(candidates, opportunities) { const matrix = []; for (const candidate of candidates) { for (const opportunity of opportunities) { const match = matchCandidateToOpportunity(candidate, opportunity); matrix.push({ candidate_id: candidate.id, opportunity_id: opportunity.id, score: match.score, breakdown: match.breakdown }); } } return matrix.sort((a, b) => b.score - a.score); } backend/routes/bulkMatch.js bulkMatch.js // backend/routes/bulkMatch.js import express from "express"; import { matchManyCandidatesToOpportunity, matchCandidateToManyOpportunities, matchMatrix } from "../services/bulkMatcher.js"; const router = express.Router(); /** * POST /v1/match/candidates-to-opportunity * Body: * { * "candidates": [ ... ], * "opportunity": { ... } * } */ router.post("/v1/match/candidates-to-opportunity", (req, res) => { try { const { candidates, opportunity } = req.body; if (!candidates || !opportunity) { return res.status(400).json({ error: "candidates and opportunity are required" }); } const results = matchManyCandidatesToOpportunity(candidates, opportunity); return res.json({ status: "success", count: results.length, matches: results }); } catch (err) { console.error("Bulk match error:", err); return res.status(500).json({ error: "Internal server error" }); } }); /** * POST /v1/match/candidate-to-opportunities * Body: * { * "candidate": { ... }, * "opportunities": [ ... ] * } */ router.post("/v1/match/candidate-to-opportunities", (req, res) => { try { const { candidate, opportunities } = req.body; if (!candidate || !opportunities) { return res.status(400).json({ error: "candidate and opportunities are required" }); } const results = matchCandidateToManyOpportunities(candidate, opportunities); return res.json({ status: "success", count: results.length, matches: results }); } catch (err) { console.error("Bulk match error:", err); return res.status(500).json({ error: "Internal server error" }); } }); /** * POST /v1/match/matrix * Body: * { * "candidates": [ ... ], * "opportunities": [ ... ] * } */ router.post("/v1/match/matrix", (req, res) => { try { const { candidates, opportunities } = req.body; if (!candidates || !opportunities) { return res.status(400).json({ error: "candidates and opportunities are required" }); } const results = matchMatrix(candidates, opportunities); return res.json({ status: "success", count: results.length, matches: results }); } catch (err) { console.error("Matrix match error:", err); return res.status(500).json({ error: "Internal server error" }); } }); export default router; server.js import bulkMatchRouter from "./routes/bulkMatch.js"; app.use(bulkMatchRouter); pages/bulk-matching-dashboard.html bulk-matching-dashboard.html Bulk Matching Dashboard – GIA

Bulk Matching Dashboard

Paste candidate and opportunity JSON below to generate ranked matches.

Candidates JSON (Array)

Opportunity JSON (Single Object)

backend/services/sectorAdjacency.js sectorAdjacency.js // backend/services/sectorAdjacency.js /** * Sector adjacency map * ----------------------------------------- * Each sector lists other sectors that are * considered "adjacent" or "transferable." * * This is donor‑aligned and workforce‑friendly. */ export const SECTOR_ADJACENCY = { infrastructure: ["construction", "transportation", "energy", "water"], construction: ["infrastructure", "energy"], energy: ["infrastructure", "construction", "utilities"], water: ["infrastructure", "utilities"], broadband: ["telecom", "infrastructure"], telecom: ["broadband", "infrastructure"], utilities: ["energy", "water"], agriculture: ["environment", "infrastructure"], environment: ["agriculture", "water"], transportation: ["infrastructure", "logistics"], logistics: ["transportation"] }; /** * Score sector adjacency * ----------------------------------------- * Returns: * { score: Number, reason: String } * * Scoring: * - Exact match: 100 * - Adjacent sector: 80 * - No relation: 40 */ export function scoreSectorAdjacency(candidateSector, opportunitySector) { if (!candidateSector || !opportunitySector) { return { score: 100, reason: "No sector specified" }; } const c = candidateSector.toLowerCase(); const o = opportunitySector.toLowerCase(); // Exact match if (c === o) { return { score: 100, reason: "Primary sector aligns" }; } // Adjacent match const adjacent = SECTOR_ADJACENCY[o] || []; if (adjacent.includes(c)) { return { score: 80, reason: `Sector is adjacent to ${opportunitySector}` }; } // No relation return { score: 40, reason: `Sector not aligned or adjacent` }; } matchingEngine.js import { scoreSectorAdjacency } from "./sectorAdjacency.js"; results.push(scoreSectorAdjacency(candidate.primary_sector, opportunity.sector)); backend/services/assignmentEngine.js assignmentEngine.js // backend/services/assignmentEngine.js import { matchManyCandidatesToOpportunity } from "./bulkMatcher.js"; /** * Workforce Assignment Engine (v1) * --------------------------------------------------------- * Assigns the top N candidates to an opportunity, * based on a minimum score threshold. * * Input: * candidates: [ ... ] * opportunity: { ... } * options: * - limit: number of candidates to assign * - minScore: minimum acceptable score * * Output: * { * assigned: [ ... ], * rejected: [ ... ], * summary: { assignedCount, rejectedCount } * } */ export function assignCandidatesToOpportunity( candidates, opportunity, { limit = 5, minScore = 70 } = {} ) { // Step 1: Score all candidates const scored = matchManyCandidatesToOpportunity(candidates, opportunity); // Step 2: Filter by threshold const eligible = scored.filter(c => c.score >= minScore); const rejected = scored.filter(c => c.score < minScore); // Step 3: Take top N const assigned = eligible.slice(0, limit); return { assigned, rejected, summary: { assignedCount: assigned.length, rejectedCount: rejected.length, threshold: minScore, limit } }; } backend/routes/autoMatch.js autoMatch.js // backend/routes/autoMatch.js import express from "express"; import { assignCandidatesToOpportunity } from "../services/assignmentEngine.js"; const router = express.Router(); /** * POST /v1/auto-match * Body: * { * "candidates": [ ... ], * "opportunity": { ... }, * "limit": 5, * "minScore": 70 * } */ router.post("/v1/auto-match", (req, res) => { try { const { candidates, opportunity, limit, minScore } = req.body; if (!candidates || !opportunity) { return res.status(400).json({ error: "candidates and opportunity are required" }); } const result = assignCandidatesToOpportunity( candidates, opportunity, { limit, minScore } ); return res.json({ status: "success", ...result }); } catch (err) { console.error("Auto-match error:", err); return res.status(500).json({ error: "Internal server error" }); } }); export default router; server.js import autoMatchRouter from "./routes/autoMatch.js"; app.use(autoMatchRouter); POST /v1/auto-match README.md # Global Infrastructure Advisory ## Document Manager + Matching Engine (v1) This system provides: - Document generation (PDFs) - Workforce & contractor matching - Opportunity scoring - Bulk matching - Auto‑assignment - Admin dashboards - Modular storage (local, S3, R2) Built for donor‑aligned, multilingual, global infrastructure programs. --- # 📁 Folder Structure ``` project-root/ │ ├── backend/ │ ├── routes/ │ │ ├── docs.js │ │ ├── match.js │ │ ├── bulkMatch.js │ │ └── autoMatch.js │ │ │ ├── services/ │ │ ├── pdfGenerator.js │ │ ├── storageProvider.js │ │ ├── matchingEngine.js │ │ ├── bulkMatcher.js │ │ ├── assignmentEngine.js │ │ └── sectorAdjacency.js │ │ │ ├── config/db.js │ └── server.js │ ├── templates/ │ ├── capability-statement.html │ ├── program-sheet.html │ ├── contractor-profile.html │ ├── opportunity-summary.html │ └── workforce-profile.html │ ├── pages/ │ ├── document-manager.html │ ├── matching-dashboard.html │ └── bulk-matching-dashboard.html │ ├── docs/ │ ├── generated/ │ └── uploads/ │ ├── database/schema-document-manager.sql ├── api-specs/document-manager-v1.yaml ├── .env.example └── README.md ``` --- # ⚙️ Environment Variables Copy `.env.example` → `.env` and fill in: - Database credentials - Storage provider (local, s3, r2) - PDF output path - Logging level - Security keys --- # 🧩 Templates Located in `/templates`: - Capability Statement - Program Sheet - Contractor Profile - Opportunity Summary - Workforce Profile These are used by `pdfGenerator.js`. --- # 🤖 Matching Engine Core logic: `backend/services/matchingEngine.js` Features: - Skills scoring - Sector alignment - Sector adjacency - Experience scoring - Location scoring - Availability scoring - Explainable breakdowns --- # 📊 Bulk Matching `bulkMatcher.js` provides: - Many candidates → one opportunity - One candidate → many opportunities - Full matrix scoring --- # 🧮 Assignment Engine `assignmentEngine.js` provides: - Top N assignment - Threshold filtering - Donor‑aligned scoring - Explainable results --- # 🌐 API Endpoints ### **Matching** ``` POST /v1/match ``` ### **Bulk Matching** ``` POST /v1/match/candidates-to-opportunity POST /v1/match/candidate-to-opportunities POST /v1/match/matrix ``` ### **Auto‑Assignment** ``` POST /v1/auto-match ``` ### **Document Generation** ``` POST /v1/docs/generate GET /v1/docs/:filename ``` --- # 🗄 Storage Providers Configured via `.env`: ``` STORAGE_PROVIDER=local | s3 | r2 ``` Adapters located in: ``` backend/services/storageProvider.js ``` --- # 🖥 Admin Dashboards Located in `/pages`: - Document Manager - Matching Dashboard - Bulk Matching Dashboard These call your API routes directly. --- # 🚀 Deployment Notes Works on: - Render - Railway - AWS - Azure - DigitalOcean - Docker Requires: - Node.js 18+ - PostgreSQL 14+ --- # 🏁 Status This is **v1** — fully functional, modular, and ready for expansion. pages/program-matching-dashboard.html program-matching-dashboard.html Program‑Wide Matching Dashboard – GIA

Program‑Wide Matching Dashboard

Paste candidate and opportunity JSON arrays below to generate a full matrix match.

Candidates JSON (Array)

Opportunities JSON (Array)

pdfGenerator.js templates/assignment-confirmation.html assignment-confirmation.html Assignment Confirmation – {{candidate_name}}

Assignment Confirmation

Date: {{date}}

Candidate Information

Name: {{candidate_name}}

Email: {{candidate_email}}

Phone: {{candidate_phone}}

Primary Sector: {{candidate_sector}}

Years of Experience: {{candidate_experience}}

Opportunity Details

Opportunity Title: {{opportunity_title}}

Organization: {{opportunity_org}}

Location / Region: {{opportunity_region}}

Start Date: {{opportunity_start}}

Sector: {{opportunity_sector}}

Match Summary

Match Score: {{match_score}} / 100

Reasoning:

Assignment Status

Notes

backend/workflows/autoAssignmentWorkflow.js // backend/workflows/autoAssignmentWorkflow.js import { assignCandidatesToOpportunity } from "../services/assignmentEngine.js"; import { generatePDF } from "../services/pdfGenerator.js"; import fs from "fs"; /** * Auto‑Assignment Workflow (v1) * --------------------------------------------------------- * This workflow: * 1. Loads candidates + opportunities (placeholder) * 2. Runs assignment engine * 3. Generates assignment confirmation PDFs * 4. Logs results * * In production, replace the placeholder loaders with: * - Database queries * - API calls * - Event triggers */ export async function runAutoAssignmentWorkflow({ candidates, opportunity, limit = 5, minScore = 70 }) { console.log("Running auto‑assignment workflow..."); // Step 1: Run assignment engine const result = assignCandidatesToOpportunity( candidates, opportunity, { limit, minScore } ); // Step 2: Generate PDFs for assigned candidates for (const assigned of result.assigned) { const pdfData = { candidate_name: assigned.candidate.name, candidate_email: assigned.candidate.email, candidate_phone: assigned.candidate.phone, candidate_sector: assigned.candidate.primary_sector, candidate_experience: assigned.candidate.years_experience, opportunity_title: opportunity.title, opportunity_org: opportunity.organization, opportunity_region: opportunity.region, opportunity_start: opportunity.start_date, opportunity_sector: opportunity.sector, match_score: assigned.score, match_reasoning: assigned.breakdown.map(b => b.reason).join("; "), assignment_status: "Assigned", notes: "Automatically assigned via GIA Auto‑Assignment Engine", date: new Date().toLocaleDateString() }; await generatePDF("assignment-confirmation", pdfData); } // Step 3: Log results const logEntry = { timestamp: new Date().toISOString(), opportunity_id: opportunity.id, assigned: result.assigned.map(a => a.candidate_id), rejected: result.rejected.map(r => r.candidate_id), summary: result.summary }; fs.appendFileSync("./logs/auto-assignment.log", JSON.stringify(logEntry) + "\n"); console.log("Auto‑assignment workflow complete."); return result; } i18n/en.json { "app": { "name": "Global Infrastructure Advisory", "tagline": "Document Manager & Matching Engine" }, "nav": { "document_manager": "Document Manager", "matching_dashboard": "Matching Dashboard", "bulk_matching_dashboard": "Bulk Matching", "program_matching_dashboard": "Program Matching", "reports": "Reports", "settings": "Settings" }, "matching": { "title_single": "Matching Dashboard", "title_bulk": "Bulk Matching Dashboard", "title_program": "Program-wide Matching Dashboard", "candidate_json_label": "Candidate JSON", "candidates_json_label": "Candidates JSON (Array)", "opportunity_json_label": "Opportunity JSON", "opportunities_json_label": "Opportunities JSON (Array)", "run_match": "Run Match", "run_bulk_match": "Run Bulk Match", "run_matrix_match": "Run Matrix Match", "results_title": "Match Results", "matrix_results_title": "Matrix Match Results", "candidate_id": "Candidate ID", "opportunity_id": "Opportunity ID", "score": "Score", "breakdown": "Breakdown" }, "assignment": { "auto_match_title": "Auto-Assignment", "limit_label": "Maximum Assignments", "min_score_label": "Minimum Score", "run_auto_match": "Run Auto-Assignment", "assigned": "Assigned", "rejected": "Rejected", "summary": "Summary", "assigned_count": "Assigned Count", "rejected_count": "Rejected Count", "threshold": "Threshold", "notes_default": "Automatically assigned via GIA Auto-Assignment Engine" }, "pdf": { "assignment_confirmation_title": "Assignment Confirmation", "candidate_information": "Candidate Information", "opportunity_details": "Opportunity Details", "match_summary": "Match Summary", "assignment_status": "Assignment Status", "notes": "Notes", "date": "Date" } } i18n/es.json i18n/fr.json i18n/ar.json { "app": { "name": "Global Infrastructure Advisory", "tagline": "Gestor de Documentos y Motor de Emparejamiento" } } Generate es.json, fr.json, and ar.json with full translations pages/donor-reporting-dashboard.html Donor Reporting Dashboard – GIA

Donor Reporting Dashboard

Portfolio‑level view of assignments, scores, and program performance.

Filters

Program / Opportunity ID

Region

Sector

Min Score

Assignment Summary

No data loaded yet.

Assignments

Opportunity ID	Candidate ID	Region	Sector	Score	Status

backend/services/analyticsEngine.js // backend/services/analyticsEngine.js /** * Program‑Wide Analytics Engine (v1) * * This module takes: * - Matrix match results (candidate ↔ opportunity scores) * - Assignment records * * And returns: * - Global stats * - By‑sector stats * - By‑region stats * - Opportunity‑level stats */ /** * Compute basic stats from an array of numeric scores. */ function computeScoreStats(scores) { if (!scores.length) { return { count: 0, avg: 0, min: 0, max: 0 }; } const count = scores.length; const sum = scores.reduce((s, v) => s + v, 0); const avg = sum / count; const min = Math.min(...scores); const max = Math.max(...scores); return { count, avg, min, max }; } /** * Aggregate by a key (e.g., sector, region, opportunity_id). */ function aggregateByKey(rows, key) { const buckets = {}; for (const row of rows) { const k = row[key] || "unknown"; if (!buckets[k]) buckets[k] = []; buckets[k].push(row.score); } const result = {}; for (const [k, scores] of Object.entries(buckets)) { result[k] = computeScoreStats(scores); } return result; } /** * Build analytics from a matrix of matches. * * Expected shape: * [ * { * candidate_id, * opportunity_id, * score, * breakdown, * sector, // optional * region // optional * }, * ... * ] */ export function buildMatrixAnalytics(matrixRows) { const scores = matrixRows.map(r => r.score); const global = computeScoreStats(scores); const bySector = aggregateByKey(matrixRows, "sector"); const byRegion = aggregateByKey(matrixRows, "region"); const byOpportunity = aggregateByKey(matrixRows, "opportunity_id"); return { global, bySector, byRegion, byOpportunity }; } /** * Build analytics from assignment records. * * Expected shape: * [ * { * opportunity_id, * candidate_id, * score, * status, // "Assigned" | "Rejected" | ... * sector, // optional * region // optional * }, * ... * ] */ export function buildAssignmentAnalytics(assignments) { const scores = assignments.map(a => a.score); const global = computeScoreStats(scores); const assigned = assignments.filter(a => a.status === "Assigned"); const rejected = assignments.filter(a => a.status !== "Assigned"); const assignedScores = assigned.map(a => a.score); const rejectedScores = rejected.map(a => a.score); const bySector = aggregateByKey(assignments, "sector"); const byRegion = aggregateByKey(assignments, "region"); const byOpportunity = aggregateByKey(assignments, "opportunity_id"); return { global, assigned: { count: assigned.length, stats: computeScoreStats(assignedScores) }, rejected: { count: rejected.length, stats: computeScoreStats(rejectedScores) }, bySector, byRegion, byOpportunity }; } /** * High‑level program analytics wrapper. * * You can feed: * - matrixRows from matchMatrix(...) * - assignmentRows from your auto‑assignment workflow / DB */ export function buildProgramAnalytics({ matrixRows = [], assignmentRows = [] }) { return { matrixAnalytics: buildMatrixAnalytics(matrixRows), assignmentAnalytics: buildAssignmentAnalytics(assignmentRows) }; } /pages pages/onboarding.html Workforce & Contractor Onboarding – GIA

Workforce & Contractor Onboarding

Join the GIA workforce and be matched to global infrastructure opportunities.

Your profile has been submitted successfully. Thank you for joining the GIA workforce.

POST /v1/onboarding backend/routes/onboarding.js onboarding.js // backend/routes/onboarding.js import express from "express"; import fs from "fs"; import path from "path"; const router = express.Router(); // Local storage placeholder (replace with DB later) const DATA_FILE = path.join(process.cwd(), "database", "onboarding.json"); // Ensure file exists if (!fs.existsSync(DATA_FILE)) { fs.writeFileSync(DATA_FILE, JSON.stringify([])); } router.post("/v1/onboarding", (req, res) => { try { const { name, email, phone, profile_type, primary_sector, skills = [], years_experience = 0, region, availability, summary } = req.body; // Basic validation if (!name || !email || !profile_type || !primary_sector) { return res.status(400).json({ error: "name, email, profile_type, and primary_sector are required" }); } // Normalize skills const normalizedSkills = Array.isArray(skills) ? skills.map(s => s.trim()).filter(Boolean) : []; // Build profile object const profile = { id: "prof-" + Date.now(), name, email, phone, profile_type, primary_sector, skills: normalizedSkills, years_experience: Number(years_experience), region, availability, summary, created_at: new Date().toISOString() }; // Load existing const existing = JSON.parse(fs.readFileSync(DATA_FILE, "utf8")); // Save existing.push(profile); fs.writeFileSync(DATA_FILE, JSON.stringify(existing, null, 2)); return res.json({ status: "success", profile }); } catch (err) { console.error("Onboarding error:", err); return res.status(500).json({ error: "Internal server error" }); } }); export default router; server.js import onboardingRouter from "./routes/onboarding.js"; app.use(onboardingRouter); database/schema-onboarding.sql schema-onboarding.sql -- ============================================================ -- WORKER / CONTRACTOR ONBOARDING SCHEMA (v1) -- Global Infrastructure Advisory (GIA) -- ============================================================ CREATE TABLE onboarding_profiles ( id VARCHAR(64) PRIMARY KEY, profile_type VARCHAR(32) NOT NULL, -- worker | contractor name TEXT NOT NULL, email TEXT NOT NULL, phone TEXT, primary_sector TEXT NOT NULL, skills TEXT[], -- array of skills years_experience INTEGER DEFAULT 0, region TEXT, availability TEXT, summary TEXT, created_at TIMESTAMP DEFAULT NOW() ); -- Indexes for matching engine performance CREATE INDEX idx_onboarding_sector ON onboarding_profiles (primary_sector); CREATE INDEX idx_onboarding_region ON onboarding_profiles (region); CREATE INDEX idx_onboarding_profile_type ON onboarding_profiles (profile_type); -- ============================================================ -- OPTIONAL: Certifications / Licenses (future expansion) -- ============================================================ CREATE TABLE onboarding_certifications ( id SERIAL PRIMARY KEY, profile_id VARCHAR(64) REFERENCES onboarding_profiles(id) ON DELETE CASCADE, cert_name TEXT NOT NULL, cert_issuer TEXT, issued_date DATE, expiry_date DATE ); CREATE INDEX idx_cert_profile ON onboarding_certifications (profile_id); -- ============================================================ -- OPTIONAL: Uploaded Documents (resume, capability statement) -- ============================================================ CREATE TABLE onboarding_documents ( id SERIAL PRIMARY KEY, profile_id VARCHAR(64) REFERENCES onboarding_profiles(id) ON DELETE CASCADE, doc_type TEXT NOT NULL, -- resume | capability_statement | license | etc. file_path TEXT NOT NULL, uploaded_at TIMESTAMP DEFAULT NOW() ); CREATE INDEX idx_docs_profile ON onboarding_documents (profile_id); -- ============================================================ -- WORKER / CONTRACTOR ONBOARDING SCHEMA (v1) -- Global Infrastructure Advisory (GIA) -- ============================================================ CREATE TABLE onboarding_profiles ( id VARCHAR(64) PRIMARY KEY, profile_type VARCHAR(32) NOT NULL, -- worker | contractor name TEXT NOT NULL, email TEXT NOT NULL, phone TEXT, primary_sector TEXT NOT NULL, skills TEXT[], -- array of skills years_experience INTEGER DEFAULT 0, region TEXT, availability TEXT, summary TEXT, created_at TIMESTAMP DEFAULT NOW() ); -- Indexes for matching engine performance CREATE INDEX idx_onboarding_sector ON onboarding_profiles (primary_sector); CREATE INDEX idx_onboarding_region ON onboarding_profiles (region); CREATE INDEX idx_onboarding_profile_type ON onboarding_profiles (profile_type); -- ============================================================ -- OPTIONAL: Certifications / Licenses (future expansion) -- ============================================================ CREATE TABLE onboarding_certifications ( id SERIAL PRIMARY KEY, profile_id VARCHAR(64) REFERENCES onboarding_profiles(id) ON DELETE CASCADE, cert_name TEXT NOT NULL, cert_issuer TEXT, issued_date DATE, expiry_date DATE ); CREATE INDEX idx_cert_profile ON onboarding_certifications (profile_id); -- ============================================================ -- OPTIONAL: Uploaded Documents (resume, capability statement) -- ============================================================ CREATE TABLE onboarding_documents ( id SERIAL PRIMARY KEY, profile_id VARCHAR(64) REFERENCES onboarding_profiles(id) ON DELETE CASCADE, doc_type TEXT NOT NULL, -- resume | capability_statement | license | etc. file_path TEXT NOT NULL, uploaded_at TIMESTAMP DEFAULT NOW() ); CREATE INDEX idx_docs_profile ON onboarding_documents (profile_id); pages/onboarding-review-dashboard.html onboarding-review-dashboard.html Onboarding Review Dashboard – GIA

Onboarding Review Dashboard

Review, approve, and activate workforce and contractor profiles.

Filters

Profile Type

Sector

Region

Profiles

Name	Type	Sector	Region	Experience	Status	Actions

backend/services/onboardingToCandidate.js // backend/services/onboardingToCandidate.js import fs from "fs"; import path from "path"; /** * Loads onboarding profiles from local JSON. * Replace with DB queries in production. */ const DATA_FILE = path.join(process.cwd(), "database", "onboarding.json"); export function loadOnboardingProfiles() { if (!fs.existsSync(DATA_FILE)) return []; return JSON.parse(fs.readFileSync(DATA_FILE, "utf8")); } /** * Normalize a single onboarding profile into a matching-ready candidate object. * * Matching Engine expects: * { * id, * name, * primary_sector, * skills: [], * years_experience, * region, * availability, * metadata: { ... } * } */ export function normalizeProfileToCandidate(profile) { return { id: profile.id, name: profile.name, primary_sector: profile.primary_sector, skills: Array.isArray(profile.skills) ? profile.skills : [], years_experience: Number(profile.years_experience || 0), region: profile.region || null, availability: profile.availability || null, metadata: { profile_type: profile.profile_type, email: profile.email, phone: profile.phone, summary: profile.summary, created_at: profile.created_at } }; } /** * Load all onboarding profiles and convert them to matching candidates. */ export function loadCandidatesForMatching() { const profiles = loadOnboardingProfiles(); return profiles .filter(p => p.status !== "rejected") // only approved/pending .map(normalizeProfileToCandidate); } /** * Load only approved candidates. */ export function loadApprovedCandidates() { const profiles = loadOnboardingProfiles(); return profiles .filter(p => p.status === "approved") .map(normalizeProfileToCandidate); } pages/profile-detail.html Profile Detail – GIA

Profile Detail

Loading profile…

Basic Information

Name:

Email:

Phone:

Type: | Status:

Sector & Experience

Primary Sector:

Region:

Years of Experience:

Availability:

Skills

Summary / Capabilities

backend/services/resumeGenerator.js // backend/services/resumeGenerator.js import { generatePDF } from "./pdfGenerator.js"; /** * Resume / Capability Statement Auto‑Generator (v1) * --------------------------------------------------------- * Input: normalized candidate profile from onboardingToCandidate.js * Output: PDF file generated using templates/resume.html or templates/capability-statement.html * * Supports: * - Workers (resume) * - Contractors (capability statement) */ export async function generateResumeOrCapability(profile) { const isContractor = profile.metadata.profile_type === "contractor"; const templateName = isContractor ? "capability-statement" : "resume"; const data = { name: profile.name, email: profile.metadata.email, phone: profile.metadata.phone, primary_sector: profile.primary_sector, skills: profile.skills, years_experience: profile.years_experience, region: profile.region, availability: profile.availability, summary: profile.metadata.summary, profile_type: profile.metadata.profile_type, created_at: profile.metadata.created_at, // Contractor‑specific fields (future expansion) company_name: isContractor ? profile.name : null, capabilities: isContractor ? profile.skills : null }; const filename = `${profile.id}-${templateName}.pdf`; await generatePDF(templateName, data, filename); return { status: "success", file: filename, type: templateName }; } templates/resume.html {{name}} – Resume

{{email}} • {{phone}}

Professional Summary

Core Skills

Experience

Years of Experience: {{years_experience}}

Primary Sector: {{primary_sector}}

Region: {{region}}

Availability: {{availability}}

templates/capability-statement.html {{company_name}} – Capability Statement

{{email}} • {{phone}}

Capabilities

Core Sector

Experience

Years of Experience: {{years_experience}}

Region: {{region}}

Company Summary

backend/routes/resumeDownload.js resumeDownload.js // backend/routes/resumeDownload.js import express from "express"; import fs from "fs"; import path from "path"; import { loadOnboardingProfiles } from "../services/onboardingToCandidate.js"; import { normalizeProfileToCandidate } from "../services/onboardingToCandidate.js"; import { generateResumeOrCapability } from "../services/resumeGenerator.js"; const router = express.Router(); router.get("/v1/profile/:id/resume", async (req, res) => { try { const { id } = req.params; // Load onboarding profiles const profiles = loadOnboardingProfiles(); const profile = profiles.find(p => p.id === id); if (!profile) { return res.status(404).json({ error: "Profile not found" }); } // Normalize to matching-ready candidate const candidate = normalizeProfileToCandidate(profile); // Generate resume or capability statement const result = await generateResumeOrCapability(candidate); const filePath = path.join(process.cwd(), "docs", "generated", result.file); if (!fs.existsSync(filePath)) { return res.status(500).json({ error: "PDF generation failed" }); } // Send file res.download(filePath, result.file); } catch (err) { console.error("Resume download error:", err); return res.status(500).json({ error: "Internal server error" }); } }); export default router; server.js import resumeDownloadRouter from "./routes/resumeDownload.js"; app.use(resumeDownloadRouter); backend/routes/profile.js profile.js // backend/routes/profile.js import express from "express"; import { loadOnboardingProfiles } from "../services/onboardingToCandidate.js"; import { normalizeProfileToCandidate } from "../services/onboardingToCandidate.js"; const router = express.Router(); /** * GET /v1/profile/:id * Returns: * - Raw onboarding profile * - Normalized candidate object (matching-ready) * - Metadata for admin dashboards */ router.get("/v1/profile/:id", (req, res) => { try { const { id } = req.params; const profiles = loadOnboardingProfiles(); const profile = profiles.find(p => p.id === id); if (!profile) { return res.status(404).json({ error: "Profile not found" }); } const normalized = normalizeProfileToCandidate(profile); return res.json({ status: "success", profile, candidate: normalized }); } catch (err) { console.error("Profile API error:", err); return res.status(500).json({ error: "Internal server error" }); } }); export default router; server.js import profileRouter from "./routes/profile.js"; app.use(profileRouter); backend/services/candidateCache.js candidateCache.js // backend/services/candidateCache.js import { createClient } from "redis"; import { loadOnboardingProfiles, normalizeProfileToCandidate } from "./onboardingToCandidate.js"; const redis = createClient(); redis.on("error", err => console.error("Redis error:", err)); await redis.connect(); /** * Cache key helpers */ const KEY_ALL = "candidates:all"; const KEY_ONE = id => `candidate:${id}`; /** * Load all onboarding profiles, normalize them, * and store them in Redis for fast matching. */ export async function warmCandidateCache() { const profiles = loadOnboardingProfiles(); const normalized = profiles.map(normalizeProfileToCandidate); // Store full list await redis.set(KEY_ALL, JSON.stringify(normalized)); // Store each individually for (const c of normalized) { await redis.set(KEY_ONE(c.id), JSON.stringify(c)); } return { status: "success", count: normalized.length }; } /** * Get all candidates from cache. * Falls back to onboarding loader if cache is empty. */ export async function getAllCandidates() { const cached = await redis.get(KEY_ALL); if (cached) { return JSON.parse(cached); } // Fallback: warm cache const profiles = loadOnboardingProfiles(); const normalized = profiles.map(normalizeProfileToCandidate); await redis.set(KEY_ALL, JSON.stringify(normalized)); return normalized; } /** * Get a single candidate from cache. */ export async function getCandidate(id) { const cached = await redis.get(KEY_ONE(id)); if (cached) { return JSON.parse(cached); } // Fallback: load from onboarding const profiles = loadOnboardingProfiles(); const profile = profiles.find(p => p.id === id); if (!profile) return null; const normalized = normalizeProfileToCandidate(profile); await redis.set(KEY_ONE(id), JSON.stringify(normalized)); return normalized; } /** * Invalidate cache when onboarding changes. */ export async function invalidateCandidateCache(id = null) { if (id) { await redis.del(KEY_ONE(id)); } else { await redis.del(KEY_ALL); } } server.js import { warmCandidateCache } from "./services/candidateCache.js"; await warmCandidateCache(); backend/routes/profileUpdate.js profileUpdate.js // backend/routes/profileUpdate.js import express from "express"; import fs from "fs"; import path from "path"; import { loadOnboardingProfiles, normalizeProfileToCandidate } from "../services/onboardingToCandidate.js"; import { invalidateCandidateCache } from "../services/candidateCache.js"; const router = express.Router(); const DATA_FILE = path.join(process.cwd(), "database", "onboarding.json"); /** * PATCH /v1/profile/:id * Allows updating: * - name * - email * - phone * - primary_sector * - skills * - years_experience * - region * - availability * - summary * - status (approved | rejected | pending) */ router.patch("/v1/profile/:id", (req, res) => { try { const { id } = req.params; const updates = req.body; const profiles = loadOnboardingProfiles(); const index = profiles.findIndex(p => p.id === id); if (index === -1) { return res.status(404).json({ error: "Profile not found" }); } const profile = profiles[index]; // Apply updates const allowedFields = [ "name", "email", "phone", "primary_sector", "skills", "years_experience", "region", "availability", "summary", "status" ]; for (const key of Object.keys(updates)) { if (allowedFields.includes(key)) { profile[key] = updates[key]; } } // Save back to file profiles[index] = profile; fs.writeFileSync(DATA_FILE, JSON.stringify(profiles, null, 2)); // Invalidate Redis cache for this profile invalidateCandidateCache(id); return res.json({ status: "success", profile, candidate: normalizeProfileToCandidate(profile) }); } catch (err) { console.error("Profile update error:", err); return res.status(500).json({ error: "Internal server error" }); } }); export default router; add to server.js import profileUpdateRouter from "./routes/profileUpdate.js"; app.use(profileUpdateRouter); backend/routes/assignmentHistory.js // backend/routes/assignmentHistory.js import express from "express"; import fs from "fs"; import path from "path"; const router = express.Router(); const DATA_FILE = path.join(process.cwd(), "database", "assignment-history.json"); // Ensure file exists if (!fs.existsSync(DATA_FILE)) { fs.writeFileSync(DATA_FILE, JSON.stringify([])); } /** * Utility: load/save */ function loadHistory() { return JSON.parse(fs.readFileSync(DATA_FILE, "utf8")); } function saveHistory(history) { fs.writeFileSync(DATA_FILE, JSON.stringify(history, null, 2)); } /** * POST /v1/assignments * Records an assignment event. * * Expected body: * { * candidate_id, * opportunity_id, * score, * status, // assigned | rejected | waitlist | etc. * reasoning, * timestamp * } */ router.post("/v1/assignments", (req, res) => { try { const event = { ...req.body, id: "assign-" + Date.now(), timestamp: req.body.timestamp || new Date().toISOString() }; const history = loadHistory(); history.push(event); saveHistory(history); return res.json({ status: "success", event }); } catch (err) { console.error("Assignment history error:", err); return res.status(500).json({ error: "Internal server error" }); } }); /** * GET /v1/assignments/candidate/:id * Returns all assignment events for a candidate. */ router.get("/v1/assignments/candidate/:id", (req, res) => { try { const { id } = req.params; const history = loadHistory(); const events = history.filter(h => h.candidate_id === id); return res.json({ status: "success", events }); } catch (err) { console.error("Assignment history error:", err); return res.status(500).json({ error: "Internal server error" }); } }); /** * GET /v1/assignments/opportunity/:id * Returns all assignment events for an opportunity. */ router.get("/v1/assignments/opportunity/:id", (req, res) => { try { const { id } = req.params; const history = loadHistory(); const events = history.filter(h => h.opportunity_id === id); return res.json({ status: "success", events }); } catch (err) { console.error("Assignment history error:", err); return res.status(500).json({ error: "Internal server error" }); } }); /** * GET /v1/assignments * Admin: returns all assignment events. */ router.get("/v1/assignments", (req, res) => { try { const history = loadHistory(); return res.json({ status: "success", events: history }); } catch (err) { console.error("Assignment history error:", err); return res.status(500).json({ error: "Internal server error" }); } }); export default router; add to server.js import assignmentHistoryRouter from "./routes/assignmentHistory.js"; app.use(assignmentHistoryRouter); integrate to auto-assignment workflow await fetch("/v1/assignments", { method: "POST", body: JSON.stringify(event) }); pages/assignment-history-dashboard.html Assignment History Dashboard – GIA

Assignment History Dashboard

Portfolio‑level view of assignment events across candidates and opportunities.

Filters

Candidate ID

Opportunity ID

Status

Min Score

Summary

No data loaded yet.

Assignment Events

Timestamp	Candidate ID	Opportunity ID	Score	Status	Reasoning

pages/assignment-history-dashboard.html Assignment History Dashboard – GIA

Assignment History Dashboard

Portfolio‑level view of assignment events across candidates and opportunities.

Filters

Candidate ID

Opportunity ID

Status

Min Score

Summary

No data loaded yet.

Assignment Events

Timestamp	Candidate ID	Opportunity ID	Score	Status	Reasoning

/pages/assignment-history-dashboard.html GET /v1/assignments server.js app.use(express.static("pages")); Ctrl + S (Windows) git add . git commit -m "Add Assignment History Dashboard" git push pages/assignment-history-dashboard.html Assignment History Dashboard – GIA

Assignment History Dashboard

Portfolio‑level view of assignment events across candidates and opportunities.

Filters

Candidate ID

Opportunity ID

Status

Min Score

Summary

No data loaded yet.

Assignment Events

Timestamp	Candidate ID	Opportunity ID	Score	Status	Reasoning

/pages/assignment-history-dashboard.html GET /v1/assignments GlobalInfrastructureAdvisory/ server.js app.use(express.static("pages")); Ctrl + S (Windows) git add . git commit -m "Add Assignment History Dashboard" git push

Global Workforce Opportunities for Infrastructure Delivery

Filter Opportunities

Global Program Registry

Filter Programs

Global Programs Directory

Filter Programs

Infrastructure Sectors We Support

Energy & Power

Water & Sanitation

Transportation

Digital Infrastructure

Health & Education Facilities

Climate & Resilience

About Global Infrastructure Advisory

Founder & Executive Leadership

Our Mission

Our Values

Integrity

Impact

Technical Excellence

Service

Resilience

Global Partnership

Global Footprint

Contact Us

Get in Touch

Send an Inquiry

Global Footprint

Capabilities Statement

Executive Summary

Core Capabilities

Infrastructure Advisory

Acquisition & Procurement

Program & Portfolio Management

Engineering & Technical Support

Compliance & Safeguards

Workforce Development

Sectors We Support

Energy & Power

Water & Sanitation

Transportation

Digital Infrastructure

Health & Education

Climate & Resilience

Operating Regions

Engagement Models

Past Performance Highlights

Partner With Us

Mines

Pipelines

Energy & Water