Water Billing Management System in PHP/OOP Free Source Code

Introduction

This simple project is a Water Billing Management System. This is a web-based application project developed in PHP and MySQL Database. This project provides an online and automated platform for the water providers' management to easily store, retrieve, and calculate the billing statements of their consumers. The application stores and generates the consumers' or clients' billing statements for each meter reading. This project was developed with Bootstrap Framework and AdminLTE Template for the user interface. It also consists of user-friendly features and functionalities.

About the Water Billing Management System

I developed this project using the following:

• XAMPP v3.3.0
• PHP
• MySQL Database
• HTML
• CSS
• JavaScript
• Ajax
• jQuery
• Bootstrap
• Font Awesome
• AdminLTE

This Water Billing Management System can be only accessed by the Management. The system requires the users to log in with their user credentials to gain access to the features and functionalities of the system. This project has 2 types of user roles which are the Admin and Staff users. The Admin users have the privilege to access and manage all the features and functionalities on the system while the Staff has only limited permissions. The system stores the consumer or client's basic information, and management can also list the billing history of the client. On the billing feature, the system automatically calculates the total amount bill of the consumer. The project also generates a printable Monthly Billing Report.

Features

• Home Page
  • Display the summary.
• Category Management
  • Add New Category
  • List All Categories
  • View Categories Details
  • Update Category's Details
  • Delete Category
• Client/Consumer Management
  • Add New Client/Consumer
  • List All Clients/Consumers
  • View Client/Consumer Details
  • View Client/Consumer Billing History
  • Update Client/Consumer Details
  • Delete Client/Consumer
• Billing Management
  • Add New Billing
  • List All Billings
  • View Billing Details
  • Edit Billing Details
  • Delete Billing Details
• User Management
  • Add New User
  • List All Users
  • View User Details
  • Edit User Details
  • Delete User Details
• Update System Information
• Update Account Details/Credentials
• Login and Logout

The source code was developed only for educational purposes only. You can download the source code for free and modify it the way you wanted.

System Snapshots of some Features

Login Page

Dashboard

Client Details

Client's Billing History

Client's Billing Details

Monthly Billing Report

Monthly Billing Report - Print View

How to Run ??

Requirements

• Download and Install any local web server such as XAMPP.
• Download the provided source code zip file. (download button is located below)
• Download the project plugins at https://www.dropbox.com/s/5nc83oktoeu6pyz/wbms_plugins.zip?dl=1

System Installation/Setup

1. Enable the GD Library in your php.ini file.
2. Open your XAMPP Control Panel and start Apache and MySQL.
3. Extract the downloaded source code zip file.
4. Copy the extracted source code folder and paste it into the XAMPP's "htdocs" directory.
5. Extract the downloaded plugins zip file.
6. Copy the extracted plugins folder and paste it into the source code root path.
7. Browse the PHPMyAdmin in a browser. i.e. http://localhost/phpmyadmin
8. Create a new database naming wbms_db.
9. Import the provided SQL file. The file is known as wbms_db.sql located inside the database folder.
10. Browse the Water Billing Management System in a browser. i.e. http://localhost/wbms/.

Admin Default Access:

Username: admin
Password: admin123

DEMO VIDEO

That's it. You can now explore the features and functionalities of this Water Billing Management System in PHP. I hope this will help you with what you are looking for and you'll find something useful for your future projects.

Explore more on this website for more Free Source Codes and Tutorials.

Enjoy :)