Information and Service System

Joho Village Digital Service Portal

May 2021
A system that helps the joho village community in terms of administration through the joho village website. as a backend developer, I have the task of building a CMS and RESTful API to integrate into a mobile app. collaborate with frontend developers and Flutter Developers.
Joho Village Digital Service Portal

System Overview & Objective

The Pelayanan Desa Joho system is a grassroots-level public administration digitalization platform. This system solves manual bureaucratic bottlenecks by transitioning the process of requesting cover letters, managing population data, and other village services into an asynchronous electronic workflow. The primary objective is to engineer a highly stable, accessible core system (accounting for varying levels of digital literacy among citizens) while measurably reducing the administrative load on village officials.

Core Logic & Architecture

  • Citizen Data Relational Mapping: The system's core logic heavily relies on relational database integrity. Citizen data (based on National ID/NIK and Family Card numbers) is encapsulated as Primary Keys mapped directly to their document request history. This schema enforces strict data normalization, preventing duplication and accelerating query execution during cross-verification by village staff.

  • Document Workflow Automation: The letter request pipeline is designed using a finite state machine model (Draft → Submitted → Verified → Ready for Pickup). The system automates the population of official document templates using data extracted directly from the database, eliminating human error-prone manual data entry.

  • Lightweight Role-Based Access Control (RBAC): The architecture strictly separates the citizen portal (for submitting requests) and the official dashboard (for processing approvals). This isolation is enforced at the routing and controller levels to guarantee that citizens cannot access or manipulate the state of other users' documents.

Tech Stack

CodeigniterBootstrapPHPHTMLCSSJavascript