📥
Receipt & intake
Each document gets a unique tracking number on day one — DARTS-2026-000123 — and is logged with origin office, type, person concerned, and date received.
DARTS · Document Action and Records Tracking System
Records that move. Decisions that hold.
DARTS is a government-grade document tracker built for Local Government Units — designed inside the Office of the Secretary to the Sangguniang Panlungsod where the workflow it describes was learned firsthand.
What document tracking is
Every legislative measure, voucher, contract, payroll, request letter, or memorandum an LGU office handles passes through a chain of receipt → review → action → release → filing. Document tracking is the discipline of giving every record a single tracking number, a single source of truth for its current status, and a complete audit trail of who did what, when, and why. When that discipline is digitised the office can answer the question every constituent asks — “Asa na ang document karon?” — in seconds instead of an afternoon.
🛣
Routing & action
Every move from one office to another is one row in document_routes. Every action — approval, return, referral, sign-off — is one row in document_actions. History is appended, never overwritten.
⚖
Legislative workflow
For Sangguniang Panlungsod records: agenda date, committee referral, committee report, returned to session, final action — the full LGC §54 lifecycle, plus the file locator (cabinet · drawer · folder · archive number).
⏰
Follow-up center
Payroll, voucher, contractor billing, gasoline supply, MOA/MOU — the operational track. One-click chips surface everything that needs movement today.
🔒
Privacy by design
Office-scoped queries by default. RA 10173 access trails on every confidential read. Names and salary amounts are masked unless the role explicitly grants the view.
📒
Office budget ledger
Appropriations, obligations, disbursements, and a balanced double-entry journal — so when an office goes to the budget officer the answer (“Pila pa among balance?”) is immediate.
Built around three Philippine legal anchors
- RA 11032 — Ease of Doing Business / Citizen's Charter. Every document type has a declared processing time, responsible office, and traceable status — exactly what RA 11032 requires of LGU service offices.
- RA 9470 — National Archives. Records have a retention class, a physical locator, and a soft-delete trail. Disposition is auditable.
-
RA 10173 — Data Privacy Act.
Personnel and payroll views mask names by default; every read of a confidential record writes a row to
data_access_logs. Legitimate purpose is logged.
LGU systems builder · since 1994
About the developer
Thirty years inside the Office of the Secretary to the Sangguniang Panlungsod of Pagadian — the office where every legislative record, decision, and approval gets handled. The discipline behind these systems comes from someone who has personally lived the failure modes of paper, side-chats, and ad-hoc spreadsheets.
Milestones
- Paperless Session Program — digitised SP session workflows
- Legislative Tracking System — searchable archive + publication workflow
- Official SP Emblem and Seal — lead designer (adopted)
- National Computer Center — top 3 of 53 final-exam passers (year 2000)
Design discipline
Bentley-trained building designer (low-rise / mid-rise / high-rise architectural & structural). Tools: Revit Architecture, Civil 3D, Archicad, STAAD Pro.
17 production systems running on Hostinger (PHP 8 + MySQL/MariaDB)
LGU/Gov: Pag7 · SP Pagadian Archive · Tourism Pagadian · GovPortal · DBATIS · DMDRRMO · Lala MDRRMO · GovSync · Barangay Unified · EPI/IPCRF · VoteTrack.
Business: Allen One · InventoryHub · ALYCON · Harbet · Natoy · aboutdevedgar.
Colophon
- Stack
- PHP 8.2+ · MySQL/MariaDB (InnoDB, utf8mb4) · vanilla JS · custom CSS tokens · Apache
- Design system
- Government navy + seal gold · Plus Jakarta Sans · 4-px spacing · WCAG-friendly contrast
- Architecture
- Single front controller (
index.php), thin repositories, server-side validation, prepared statements only, append-only audit log, soft-delete on operational records - Hosting
- Hostinger shared (Manila timezone) · subdomain
darts.govportalsolutions.com - License
- Proprietary — Office of the Secretary to the Sangguniang Panlungsod, City of Pagadian.