Free Download ISP Billing System in PHP MySQL

Updated on: October 4, 2024

Version
Download 6758
File Size 40.63 MB
File Count 1
Create Date October 1, 2024
Last Updated October 5, 2024

Free Download ISP Billing System in PHP MySQL

Key Features of the ISP Billing System

The ISP Billing System offers a range of features that make it a top choice for ISPs looking to automate their billing and user management. Below is a detailed look at the system's capabilities:

ISP Billing Management

The core function of the system is to automate the billing process. This includes generating invoices, tracking payments, and managing due bills efficiently.

Mikrotik API Integration

Using the Mikrotik API, the system can directly communicate with your Mikrotik router to manage bandwidth, monitor user activity, and disable or enable user accounts based on their billing status. Learn more about Mikrotik API.

Package Management

Create and manage different packages based on bandwidth limits, speed, and pricing. This feature allows ISPs to provide flexible options to their customers and track subscriptions easily.

User Management

Add, edit, or delete user accounts, view user profiles, and assign different packages to individual users. The user management feature also provides comprehensive reports on user activity.

Stripe Payment Gateway Integration

With Stripe payment gateway integration, users can pay their bills securely online. This feature reduces the hassle of manual payments and offers a seamless experience for customers. To integrate Stripe, you can refer to the official Stripe PHP API documentation.

One-Click Bill Generation for All Users

Generate bills for all users with a single click. This is particularly useful at the end of the billing cycle when multiple invoices need to be issued simultaneously.

Disable All Users with Due Bills in a Single Click

Easily disable all users who have overdue bills with a single click. This helps in managing non-paying customers and ensures that services are provided only to those with up-to-date payments.

Payment Invoice Download

Users and administrators can download invoices in PDF format, making record-keeping and compliance a breeze.

Ticket-Based Support System

The system includes a built-in support feature where users can raise tickets for issues and administrators can respond accordingly.

Enable/Disable Single User

Administrators can enable or disable specific users manually, giving granular control over account management.

Change User Package

Easily upgrade or downgrade a user’s package based on their requirements, making it easy to offer flexible services.

Mikrotik Log Download

Administrators can download logs directly from the Mikrotik router for troubleshooting and monitoring purposes.

Comprehensive Reporting

Generate detailed reports for billing, user activity, payments, and more. The reporting feature provides insights into the business, helping administrators make data-driven decisions.

Server Requirements for ISP Billing System

To ensure smooth operation, the ISP Billing System in PHP MySQL requires the following server configurations:

PHP: Version 7.4 or higher
MySQL: Version 4.1 or higher
Required PHP Extensions:
- BCMath
- Ctype
- JSON
- Mbstring
- OpenSSL
- PDO
- Tokenizer
- XML

These requirements are standard for most PHP applications, ensuring compatibility and ease of deployment.

Mikrotik Router Requirements

If you’re planning to integrate the ISP Billing System with a Mikrotik router, make sure the following requirements are met:

RouterOS Version: 3 or higher
API Services Enabled
Firewall Settings: Allow port 8728 for API communication
User Credentials: Create a user account with API access for the system to communicate with the router

ISP Billing System Flowchart

The flowchart provides a comprehensive overview of the ISP Billing System's workflow, beginning with the user login and registration process. When a user accesses the system, they are prompted to either log in or register. Upon successful login, the user is directed to the Dashboard, which serves as the central hub for managing various functionalities. For new users, the registration process requires email verification, and only upon successful verification are they granted access to the dashboard.

Once inside the dashboard, the flow branches out into several core modules, including User Management, Package Management, Billing Management, Payment Integration, and Mikrotik API Integration. Each of these modules has its own set of sub-processes. For example, under User Management, administrators have the ability to add, edit, or delete user accounts, as well as enable or disable specific users. The Package Management module provides options to create new service packages, edit existing packages, or remove them as needed.

Billing Management allows administrators to automate the billing cycle by generating invoices for all users with a single click. They can also view invoice histories and track payments in real-time. The Payment Integration module supports the Stripe payment gateway for seamless online payments, and it also provides a manual payment entry option. The Mikrotik API Integration feature enables direct management of the router’s settings, such as enabling/disabling user accounts, changing bandwidth limits, and monitoring user traffic. This structured flow ensures that administrators can easily navigate through the system’s features, making ISP management more efficient and organized.

ISP Billing System ER Diagram

The ER diagram of the ISP Billing System offers a detailed view of the database schema, defining five main entities: USER, PACKAGE, INVOICE, PAYMENT, and SUPPORT_TICKET. These entities are interconnected through various relationships, which define how they interact with each other.

The USER entity represents the customers of the ISP billing system. It stores crucial details such as user_id, username, email, password, and role. The USER entity is linked to multiple other entities through different relationships. For example, a USER can subscribe to one or more PACKAGE options, as defined by the "subscribed to" relationship. This enables the system to track which packages are linked to each customer and provides flexibility in managing subscriptions.
The PACKAGE entity contains information about the different service packages offered by the ISP. It includes attributes such as package_id, package_name, description, price, bandwidth_limit, and duration_days. This entity is pivotal for managing the tiered services provided to customers and is directly linked to the USER entity for managing subscriptions and billing.
The INVOICE entity is designed to record all billing transactions. Each INVOICE entry includes fields like invoice_id, user_id, package_id, issue_date, due_date, total_amount, and status. The USER entity is associated with the INVOICE entity through the "issued" relationship, indicating that a user can have multiple invoices issued over time for various packages or services.
The PAYMENT entity is responsible for tracking all payment-related information, such as payment_id, user_id, invoice_id, payment_method, payment_date, amount, and payment_status. The PAYMENT entity is connected to both the USER and INVOICE entities, demonstrating that payments are made by users towards specific invoices. This ensures clear record-keeping of all financial transactions and facilitates reporting.
Finally, the SUPPORT_TICKET entity is used for handling customer support interactions. Each ticket is uniquely identified by ticket_id and contains details like user_id, subject, description, status, created_at, and updated_at. The SUPPORT_TICKET entity has a "submitted" relationship with the USER entity, indicating that users can raise support tickets for any issues or inquiries related to their services, billing, or technical problems.

By defining these entities and their relationships, the ER diagram offers a structured and organized view of how data is managed within the ISP Billing System. The relationships between entities ensure data integrity and facilitate efficient data handling across the system. For example, the "issued" relationship between USER and INVOICE ensures that only valid invoices are generated for registered users, while the "paid by" relationship between INVOICE and PAYMENT confirms that all payments are correctly associated with their respective invoices.

How to Install and Set Up the ISP Billing System

Setting up the ISP Billing System is straightforward. Here’s a step-by-step guide to get you started:

Download the Source Code: Obtain the free source code from the provided repository or website.
Set Up a Web Server: Use a web server like Apache or Nginx with the required PHP version and extensions installed.
Create a MySQL Database: Create a new database for the ISP Billing System and import the provided SQL file to set up the database structure.
Configure Database Connection: Update the database connection file (config.php or similar) with your MySQL database credentials.
Upload the Files: Upload the project files to your web server's document root.
Run the Application: Navigate to the application URL and log in using the demo credentials provided below.

These requirements are standard for most PHP applications, ensuring compatibility and ease of deployment. You can check out the PHP installation guide for more details on setting up these extensions.