Barangay Information System in PHP, MySQL and Bootstrap
This article will provide you with the list of modules of web based barangay system. The said project was design and developed in PHP, MySQL and Bootstrap.
List of Database Tables
- tblactivity
- tblactivityphoto
- tblblotter
- tblclearance
- tblhousehold
- tbllogs
- tblofficial
- tblpermit
- tblresident
- tblstaff
- tbluser
- tblzone
Table 1.0 List of Database Tables for Barangay Information System
Table 1.0 shows the list of database tables with entities and attributes of barangay information system.
Features/Modules of Barangay Information System
Dashboard
A dashboard is a type of graphical user interface that gives you an overview of the reports, metrics and other important statistics of your application. The image below is the dashboard feature of the barangay information system. It shows the total household number encoded in the system, the number of residents, the total clearances released by the barangay, the total permit issued and as well as the total number of blotter reports processed by the barangay.
Barangay Official Module
Barangay official module is a module where the users can add, update and search for barangay official information; such information includes the position, name of the officer, contact number, address, start term and end term. The list of officers will be reflected in the barangay clearance form.
Staff Module
The image below shows the staff module wherein the administrator can add another account with limited privileges. The fullname, username and password are the information needed in order to create another account for staff.
Zone Leader Module
The zone leader module includes the zone number, username and password as the fields to fill-in in order to create/add another record. The login credentials will be used in order to gain access in the zone leader dashboard where in the zone leader users can view, review, approve and disapprove the application for clearance and permit.
Household Module
A household includes all the persons who occupy a housing unit as their usual place of residence. … Persons per household, or average household size, is obtained by dividing the number of persons in households by the number ofhouseholds (or householders). (https://www.census.gov)
This module includes the following entities; household number, zone, total members, head of family.
Residents Information Module
This is the module that holds and stores the information of residents. This form may vary from one barangay to another barangay (based on our experience). Please refer to the database tables for the list of entities in this module (tblresident). Username and password are included in this form, it will be used to login to their account in order for the residents to apply for a clearance and permit. It simply means that a resident has the option to apply online via the application or they can proceed to the barangay hall to apply for such documents.
Permit Clearance Module
The image below shows the module wherein the administrator can add application for clearance permit. Information to be encoded are the following; the resident name, business name, address, type of business OR number and the amount to be paid. The application will be reviewed by the zone leader for the approval of such request.
Blotter Module
Police blotter is a slang term that is used in police practice and procedures. It refers to a book that records arrests and other facts and events in a police station, on a daily basis. Arrests are recorded in a police blotter as they occur. (https://definitions.uslegal.com/p/police-blotter/)
For the list of entities and attributes for this module, please refer to the database tables above (tblblotter)
Clearance Module
The image below shows the module wherein the administrator can add application for barangay clearance. Information to be encoded are the following; clearance number, resident name, findings, purpose, OR number and the amount to be paid. The application will be reviewed by the zone leader for the approval of such request.
Activity Module
The schedule of activities in the barangay is also part of the encoding process. This module will serve as a reminder and archiving of the activities in the barangay. The record includes the date of activity, the name of the activity or program, and a banner of the program can also be uploaded in the system.
Report and Statistics Module
The system is capable of printing different types of statistical record such as the number of resident per zone, the system can also group the residents according to their age, gender, educational attainment and others.
Audit Trail Logs
An audit log is a document that records an event in an information (IT) technology system. In addition to documenting what resources were accessed, audit log entries usually include destination and source addresses, timestamp and user login information. (https://searchcompliance.techtarget.com/definition/audit-log-AL)
The system records every transactions that the user is doing, adding of new record, updating of records are all recorded and stored in this module.
You may visit our Facebook page for more information, inquiries, and comments. Please subscribe also to our YouTube Channel to receive free capstone projects resources and computer programming tutorials.
Hire our team to do the project.