Naic OpenGov

A full-stack GovTech platform for municipal project monitoring, budget oversight, public transparency, and citizen engagement.

Naic OpenGov is a web-based local government information and transparency platform designed to centralize municipal projects, budgets, procurement, public records, and citizen-facing information.

The project explores how modern web technologies can help local government units improve internal monitoring while making public information easier for citizens to access and understand.

---

🏛️ About the Project

Local government information can often be distributed across different records, departments, spreadsheets, and reporting processes.

Naic OpenGov was designed around a simple idea:

What if municipal project and budget information could be managed internally while also being presented through a dedicated public transparency portal?

The system combines administrative tools with citizen-facing features to support:

• Project monitoring
• Budget oversight
• Barangay information
• Procurement tracking
• Public transparency
• Citizen feedback
• Reporting
• Auditability
• Internal notifications
• Role-based access

---

✨ Core Features

📊 Governance Dashboard

Provides administrators and staff with an overview of municipal information, including project activity, budget information, recent updates, and other operational data.

🏗️ Project Monitoring

• Create and manage municipal projects
• Track project status and implementation progress
• Associate projects with barangays
• Maintain project updates
• Upload project images
• Store related documents
• Monitor project and budget relationships

💰 Budget Management

• Manage budget records
• Associate budgets with projects
• Monitor allocated resources
• Review project-related budget information
• Support transparency-focused reporting

🗺️ Barangay Management

Maintain barangay information including:

• Barangay details
• Population information
• Barangay leadership
• Geographic coordinates
• Related projects

Geographic data can be used with interactive map-based views for easier project visualization.

📑 Procurement

The platform includes procurement-related workflows for tracking municipal procurement information and its status.

📦 Inventory

Internal inventory functionality supports:

• Inventory items
• Inventory usage
• Resource monitoring

🤝 Supplier Management

Maintain supplier information used by procurement and other government workflows.

📢 Notifications

Users can receive system notifications related to relevant activities and updates.

📝 Citizen Feedback

Citizen-facing feedback functionality provides a channel for public participation and engagement.

📂 Document Management

Project-related documents can be stored and associated with municipal records.

📈 Reports

Generate and review reports based on system information, including project-related reporting and printable/exportable views.

🔐 Role-Based Access Control

Different system functionality can be restricted according to user roles and permissions.

Authorization is implemented through middleware and Laravel policies for protected resources.

🧾 Audit Trail

Important activities can be recorded through the system's activity logging functionality, improving accountability and traceability.

---

🌐 Public Transparency Portal

Naic OpenGov includes a public-facing interface separate from internal administrative functionality.

The public portal is designed to provide citizens with easier access to selected government information without requiring access to internal management tools.

The goal is to make information such as municipal projects and public initiatives easier to discover and understand.

---

🛠️ Tech Stack

Backend

• Laravel
• PHP
• Eloquent ORM
• Laravel MVC Architecture

Frontend

• Blade
• Bootstrap
• JavaScript
• CSS

Database

• MySQL

Development & Build Tools

• Composer
• npm
• Vite

Version Control

• Git
• GitHub

---

🏗️ Application Structure

Naic OpenGov follows Laravel's MVC architecture.

Browser
   │
   ▼
Laravel Routes
   │
   ▼
Controllers
   │
   ├── Authorization / Policies
   ├── Services
   ├── Business Logic
   │
   ▼
Eloquent Models
   │
   ▼
MySQL Database

The application also uses service classes for functionality such as activity logging and notifications.

---

📦 Major Modules

Naic OpenGov
│
├── Authentication
│
├── Dashboard
│
├── Projects
│   ├── Project Management
│   ├── Project Updates
│   ├── Images
│   └── Documents
│
├── Barangays
│
├── Budgets
│
├── Procurement
│
├── Suppliers
│
├── Inventory
│
├── Reports
│
├── Notifications
│
├── Citizen Feedback
│
├── Activity Logs
│
├── User Management
│
└── Public Transparency Portal

---

👥 User Access

The platform is designed around different levels of access.

Internal users can access management functionality according to their assigned role, while citizens can access the public-facing transparency features without entering the administrative environment.

Laravel middleware and policies are used to protect sensitive operations.

---

📸 Screenshots

Public Transparency Portal

Screenshot coming soon.

Administrative Dashboard

Screenshot coming soon.

Project Monitoring

Screenshot coming soon.

Budget Management

Screenshot coming soon.

Notifications

Screenshot coming soon.

---

🚀 Local Installation

Requirements

Make sure you have:

• PHP 8.2+
• Composer
• Node.js
• npm
• MySQL

1. Clone the repository

git clone https://github.com/dev-kins/naic-opengov.git
cd naic-opengov

2. Install PHP dependencies

composer install

3. Install frontend dependencies

npm install

4. Create your environment file

macOS / Linux:

cp .env.example .env

Windows PowerShell:

Copy-Item .env.example .env

5. Generate an application key

php artisan key:generate

6. Configure the database

Update the following values in .env:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=naic_opengov
DB_USERNAME=root
DB_PASSWORD=

Use credentials appropriate for your local environment.

7. Run migrations

php artisan migrate

8. Start the frontend development server

npm run dev

9. Start Laravel

In another terminal:

php artisan serve

Open the URL displayed by Laravel in your browser.

---

🎯 Project Goals

Naic OpenGov was created to explore how software can support:

• Government transparency
• Better project monitoring
• Budget accountability
• Organized municipal records
• Data-driven decision making
• Citizen access to public information
• Digital transformation in local government

It also serves as a full-stack development project focused on designing a larger information system rather than an isolated CRUD application.

---

🚧 Project Status

Active Development / Portfolio Project

The platform already contains core modules for projects, budgets, barangays, procurement, inventory, suppliers, reports, notifications, citizen feedback, activity logging, and user management.

Additional refinement, testing, deployment improvements, and feature development may continue as the project evolves.

---

🔮 Future Development

Potential future improvements include:

• Advanced analytics
• Expanded public dashboards
• Additional map visualization
• Procurement transparency
• Contractor management
• More detailed project timelines
• Open-data exports
• Improved citizen participation tools
• Real-time updates
• Mobile/PWA support
• Additional reporting tools

---

👨‍💻 Developer

Kian Morgan Hill

Junior Full-Stack Developer

GitHub: dev-kins

---

⚠️ Disclaimer

Naic OpenGov is an independent portfolio and educational GovTech project.

It is not an official website or information system of the Municipality of Naic or any government agency, and project data used for development or demonstration purposes should not be interpreted as official government information.

---

📄 License

This project is currently intended for portfolio, educational, and development purposes.