Project Timeline (Gantt) Preview
Sample data — live timelines render from mpdc_aip_lines + meo_project_milestones in PR3.
Municipal Engineer's Office · Municipality of Midsalip
Engineering Project Monitor
Track every infrastructure project end-to-end: budget, location, contractor, Program of Works, physical and financial accomplishment, inspections, photos, and status — from planning through turnover. Usa ra ka pindot, makita dayon ang tanan proyekto: asa dapita, pila ang budget, pila na ka percent ang nahuman.
Foundation Roadmap
- PR1 RBAC + Lala-ization + sidebar entry You're seeing this page because Phase 1 + Phase 2 shipped. DONE
-
PR2
12 MEO additive tables (inspections, photos, contractors, VOs, completions)
FK to
mpdc_aip_lines, no duplication of AIP master. Next - PR3 Engineer's project list, POW viewer, inspections, accomplishments, photo gallery Filters AIP lines to infrastructure / capital outlay / equipment categories. Soon
- PR4 Mayor's One-Click Project View + 12 reports Single page with budget, contractor, accomplishment, photos, history. Soon
- PR5 Playwright QA suite, mobile flows, Codex adversarial review, live deploy Deploy-first then continuous test loop on the live URL. Soon
Project Status Distribution Preview
- Active 18 · 41%
- For Inspection 7 · 16%
- Completed 12 · 27%
- Delayed 4 · 9%
- For Acceptance 3 · 7%
Sample distribution. Live counts query mpdc_aip_lines.submission_status
filtered to infrastructure / capital outlay / equipment categories in PR3.
Mayor's One-Click View PR4
- Project title, code, status badge, fund source, barangay
- Approved budget · Contract amount · Disbursed · Physical % · Financial %
- Geo-pinned location with barangay context
- Main contractor, PCAB license, performance score
- Latest accomplishment + slippage + delays
- Before / during / after photo strip
- Open inspection findings by severity
- Documents drawer (POW, contracts, NTPs, completions)
- Status timeline from
mpdc_workflow_actions - Print-ready Mayor's project profile
Fund Breakdown By Fund Source
LDRRMF Capital
2 projects
General Fund (GF)
3 projects
20% Development Fund
1 project
Top Projects By ABC
-
1
El Salvador Evacuation Center El Salvador · Evacuation Center₱8,000,000 Ongoing
-
2
Maranding Road Concreting Maranding · Road Concreting₱5,000,000 Ongoing
-
3
Camalan Multi-Purpose Building Camalan · Multi-Purpose Building₱3,400,000 Substantial
-
4
Lala Proper Drainage Canal Lala Proper · Drainage Canal₱2,300,000 Ongoing
-
5
Magpatao Footbridge Repair Magpatao · Bridge Repair₱1,250,000 Procurement
AIP — Approved PPAs FY 2026
| PPA Code | Project | Barangay | Fund | ABC | Status |
|---|---|---|---|---|---|
MEO-2026-0001 |
Maranding Road Concreting | Maranding | General Fund (GF) | ₱5,000,000 | Ongoing |
MEO-2026-0002 |
Lala Proper Drainage Canal | Lala Proper | 20% Development Fund | ₱2,300,000 | Ongoing |
MEO-2026-0003 |
Camalan Multi-Purpose Building | Camalan | LDRRMF Capital | ₱3,400,000 | Substantial |
MEO-2026-0004 |
El Salvador Evacuation Center | El Salvador | LDRRMF Capital | ₱8,000,000 | Ongoing |
MEO-2026-0005 |
Magpatao Footbridge Repair | Magpatao | General Fund (GF) | ₱1,250,000 | Procurement |
MEO-2026-0006 |
Brgy Hall Roofing — Lala Proper | Lala Proper | General Fund (GF) | ₱700,000 | Completed |
AIP-Linked PPAs MPDC ↔ MEO
Engineering projects link back to MPDC AIP lines via
mpdc_aip_lines.id. Each row below shows the MEO record and its AIP parent so the
mayor and budget officer can trace any disbursement back to the approved annual investment plan.
| MEO Code | AIP Line Ref | Project | Contract | Disbursed | Physical |
|---|---|---|---|---|---|
MEO-2026-0001 |
AIP-2026-0001 |
Maranding Road Concreting | ₱4,750,000 | ₱2,945,000 | 62% |
MEO-2026-0002 |
AIP-2026-0002 |
Lala Proper Drainage Canal | ₱2,180,000 | ₱545,000 | 30% |
MEO-2026-0003 |
AIP-2026-0003 |
Camalan Multi-Purpose Building | ₱3,200,000 | ₱2,815,000 | 88% |
MEO-2026-0004 |
AIP-2026-0004 |
El Salvador Evacuation Center | ₱7,850,000 | ₱942,000 | 12% |
MEO-2026-0005 |
AIP-2026-0005 |
Magpatao Footbridge Repair | ₱0 | ₱0 | 0% |
MEO-2026-0006 |
AIP-2026-0006 |
Brgy Hall Roofing — Lala Proper | ₱685,000 | ₱685,000 | 100% |
All Projects 6 in portfolio
POW / BOQ Library Sample BOQs
Each project carries its own Program of Works (Bill of Quantities). Click a card to open the full
POW table with quantity, unit cost, and line totals — sample data shown until PR3 wires
mpdc_project_boq.
Project Categories By Type
Road Concreting
1 · ₱5,000,000
Drainage Canal
1 · ₱2,300,000
Multi-Purpose Building
1 · ₱3,400,000
Evacuation Center
1 · ₱8,000,000
Bridge Repair
1 · ₱1,250,000
Roofing Repair
1 · ₱700,000
Upcoming Milestones Next 8
-
Site Mobilization El Salvador Evacuation Center · MEO-2026-0004 · Target 2026-05-15in progress
-
PCCP Pour 50% Maranding Road Concreting · MEO-2026-0001 · Target 2026-05-30in progress
-
RCP Installation 50% Lala Proper Drainage Canal · MEO-2026-0002 · Target 2026-05-30in progress
-
Substantial Completion Camalan Multi-Purpose Building · MEO-2026-0003 · Target 2026-06-10in progress
-
Catch Basins 100% Lala Proper Drainage Canal · MEO-2026-0002 · Target 2026-06-25pending
-
Procurement Award Magpatao Footbridge Repair · MEO-2026-0005 · Target 2026-06-30in progress
-
Foundation 100% El Salvador Evacuation Center · MEO-2026-0004 · Target 2026-07-10pending
-
PCCP Pour 100% Maranding Road Concreting · MEO-2026-0001 · Target 2026-07-15pending
Site Inspections Recent
| Date | Project | Inspector | Type | Findings | Severity |
|---|---|---|---|---|---|
| 2026-04-30 | Maranding Road Concreting | MEO Inspector | Subgrade | Compaction passed | Pass |
| 2026-04-22 | Lala Proper Drainage | MEO Inspector | Trench | Minor alignment fix | Minor |
| 2026-05-28 | Camalan Multi-Purpose Bldg | MEO Inspector | Roofing | No findings | Pass |
| 2026-04-08 | Brgy Hall Roofing — Lala Proper | MEO Inspector | Final | Acceptance ready | Pass |
Live inspections log to meo_inspections in PR2.
Site Photos Before · During · After
Before
During
After
Before
During
After
Before
During
After
Live uploads land in meo_site_photos with thumbnail + EXIF GPS in PR2.
Contractor Registry PCAB-Verified
| Contractor | PCAB License | Projects | Contract Total | Disbursed |
|---|---|---|---|---|
| Lanao Construction & Supply Corp. | PCAB-LIC-12345 · Cat C-D · Small B |
1 | ₱4,750,000 | ₱2,945,000 |
| Mindanao Builders Inc. | PCAB-LIC-22987 · Cat C-D · Small A |
1 | ₱2,180,000 | ₱545,000 |
| Camalan Construction Services | PCAB-LIC-31055 · Cat D · Small B |
1 | ₱3,200,000 | ₱2,815,000 |
| Iligan Engineering Corp. | PCAB-LIC-44210 · Cat C · Medium A |
1 | ₱7,850,000 | ₱942,000 |
| TBL Roofing Specialists | PCAB-LIC-50884 · Cat D · Small B |
1 | ₱685,000 | ₱685,000 |
Disbursements Per Project
| Code | Project | Contract | Disbursed | Balance | Financial % |
|---|---|---|---|---|---|
MEO-2026-0001 |
Maranding Road Concreting | ₱4,750,000 | ₱2,945,000 | ₱1,805,000 | 58% |
MEO-2026-0002 |
Lala Proper Drainage Canal | ₱2,180,000 | ₱545,000 | ₱1,635,000 | 25% |
MEO-2026-0003 |
Camalan Multi-Purpose Building | ₱3,200,000 | ₱2,815,000 | ₱385,000 | 88% |
MEO-2026-0004 |
El Salvador Evacuation Center | ₱7,850,000 | ₱942,000 | ₱6,908,000 | 12% |
MEO-2026-0005 |
Magpatao Footbridge Repair | ₱0 | ₱0 | ₱0 | 0% |
MEO-2026-0006 |
Brgy Hall Roofing — Lala Proper | ₱685,000 | ₱685,000 | ₱0 | 100% |
| Totals | ₱18,665,000 | ₱7,932,000 | ₱10,733,000 | — | |
Accomplishment Report FY 2026
The Engineer’s Office owns this data — add, edit, update status, or delete projects here. Changes appear automatically in the MPDC “MEO Project Status” report.
| Code | Project | Physical % | Financial % | Slippage | Status | Report |
|---|---|---|---|---|---|---|
MEO-2026-0001 |
Maranding Road Concreting | 62% | 58% | +4% | Ongoing |
|
MEO-2026-0002 |
Lala Proper Drainage Canal | 30% | 25% | +5% | Ongoing |
|
MEO-2026-0003 |
Camalan Multi-Purpose Building | 88% | 88% | 0% | Substantial |
|
MEO-2026-0004 |
El Salvador Evacuation Center | 12% | 12% | 0% | Ongoing |
|
MEO-2026-0005 |
Magpatao Footbridge Repair | 0% | 0% | 0% | Procurement |
|
MEO-2026-0006 |
Brgy Hall Roofing — Lala Proper | 100% | 100% | 0% | Completed |
|
File Status Report · —
Project
Saved updates appear in the MPDC “MEO Project Status” report automatically.
Disbursement Summary FY Total
Total ABC
₱20,650,000
Contract Amount
₱18,665,000
Disbursed to Date
₱7,932,000
Unpaid Balance
₱10,733,000
Print Project Profile One-Click
Pick any project below to render a print-ready profile (Mayor's One-Click View). Sample data renders
instantly; live records will pull from mpdc_aip_lines + meo_* tables in PR4.
Project Profile · —
—
—
—
—
Total Items0
POW Total₱0.00
Approved Budget (ABC)₱0.00
Contract Amount₱0.00
Variance vs ABC—
| Item | Description | Qty | Unit | Unit Cost | Amount |
|---|---|---|---|---|---|
| Total | — | ||||
Sample BOQ structure. Live POW renders from mpdc_project_boq joined to
mpdc_aip_lines in PR3. Each line will support material/labor/equipment cost split + remarks.
- Project Code
- —
- Category
- —
- Barangay
- —
- Fund Source
- —
- Start Date
- —
- Target Completion
- —
- Duration
- —
- Status
- —
Physical Accomplishment
0%
Financial Accomplishment
0%
- Approved Budget (ABC)
- —
- Contract Amount
- —
- Disbursed to Date
- —
- Unpaid Balance
- —
- Variance vs ABC
- —
- Fund Source
- —
- Contractor
- —
- PCAB License
- —
- Contract Amount
- —
- Calendar Days
- —
MEO Project
Project
Municipal Engineer’s Office
Confirm Deletion
Delete this project?
You are about to delete —.
It will be hidden from the MEO dashboard and the MPDC report. This is a soft-delete (the record is retained for audit).