Mobile Phone Billing System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Mobile Phone Billing System

Mobile Phone Billing System is a web based application which has been developed over PHP and MySQL and runs on WAMP, XAMP or Apache2 server.. The main modules of the project is Bills,Customers,Tarrifs,Connection Types,Payments. Admin user can manage all the operations of Connection Types,Payments,Bills,Connections,Customers and their details. Admin can create different type of reports of Bills,Customers,Tarrifs,Connection Types,Payments according to their choise and filters. You can Download PHP and MySQL Project Mobile Phone Billing System with source code and database from this site. We also provide Project Report of Mobile Phone Billing System.

Functionalities and their descriptions of Mobile Phone Billing System are as follows:

  • You can search records on various criterias. Such as Bills, Tarrifs, Connection Types, Payments
  • Create, read, update and delete (CRUD) application has been implemented on Bills,Customers,Tarrifs,Connection Types,Payments
  • Keep the track logs of Customers, Connections, Connection Types ect
  • Advance search has been implemented on Customers,Connections, Connection Types
  • You can see all the details of the Bills, Tarrifs, Connections, Connection Types
  • All the modules Connections, Connection Types, Customers,Payments, Bills are inter related and tightly coupled
  • It deals with monitoring the information and transactions of Connection Types.
  • All the Customers,Connections, Connection Types modules has their unique record ID for fast transactions and searching
  • Editing, adding and updating of Records is improved which results in proper resource management of Bills data.

Modules of Mobile Phone Billing System and their descriptions:

  • Bills Module : Manage all the operations of Bills
  • Customers Module : Manage all the operations of Customers
  • Connections Module : Manage all the operations of Connections
  • Tarrifs Module : Manage all the operations of Tarrifs
  • Connection Types Module : Manage all the operations of Connection Types
  • Payments Module : Manage all the operations of Payments

Classes and their methods of Mobile Phone Billing System:

  • Bills Methods : addBills(), editBills(), deleteBills(), updateBills(), saveBills(), searchBills()
  • Customers Methods : addCustomers(), editCustomers(), deleteCustomers(), updateCustomers(), saveCustomers(), searchCustomers()
  • Connections Methods : addConnections(), editConnections(), deleteConnections(), updateConnections(), saveConnections(), searchConnections()
  • Tarrifs Methods : addTarrifs(), editTarrifs(), deleteTarrifs(), updateTarrifs(), saveTarrifs(), searchTarrifs()
  • Connection Types Methods : addConnection Types(), editConnection Types(), deleteConnection Types(), updateConnection Types(), saveConnection Types(), searchConnection Types()
  • Payments Methods : addPayments(), editPayments(), deletePayments(), updatePayments(), savePayments(), searchPayments()

Database tables and attributes of the Mobile Phone Billing System:

  • Bills Entity : Attributes of Bills are bill_id, bill_customer_id, bill_number, bill_type, bill_receipt, bill_description
  • Customers Entity : Attributes of Customers are customer_id, customer_name, customer_mobile, customer_email, customer_username, customer_password, customer_address
  • Connections Entity : Attributes of Connections are connection_id, onnection_customer_id, onnection_name, onnection_type, onnection_description
  • Tarrifs Entity : Attributes of Tarrifs are tarrif_id, tarrif_name, tarrif_type, tarrif_description
  • Connection Types Entity : Attributes of Connection Types are cnnectio_type_id, cnnectio_type_name, cnnectio_type_description
  • Payments Entity : Attributes of Payments are payment_id, payment_customer_id, payment_date, payment_amount, payment_description

Database definition of Mobile Phone Billing System:

  • The details of Bills is store into the Bills tables respective with all tables
  • Each entity (Payments, Connections, Connection Types, Customers, Bills) contains primary key and unique keys.
  • The entity Connections, Connection Types has binded with Bills, Customers entities with foreign key
  • There is one-to-one and one-to-many relationships available between Connection Types, Tarrifs, Payments, Bills
  • All the entities Bills, Connection Types, Connections, Payments are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Mobile Phone Billing System tables for fast query execution.

Super admin functionality of Mobile Phone Billing System:

  • Admin can add, edit, delete and view the records of Bills, Connection Types, Connections, Payments
  • Admin can manage all the details of Customers, Connections, Tarrifs, Connection Types
  • Admin can also generate reports of Bills, Customers, Connections, Tarrifs
  • Admin can search the details of Bills, Connection Types, Connections, Payments
  • Admin can apply different level of filters on report of Bills, Connections, Payments
  • Admin can tracks the detailed information of Connection Types, Payments, Bills, Customers

Report of Mobile Phone Billing System:

  • Generates the report on Connections,Tarrifs,Bills,Customers,Connection Types,Payments,
  • Tarrifs,Connection Types,Payments has been integrated with the dynamic filter. So you can filter the records run time
  • You can also import the report data into PDF of Tarrifs,Connection Types,Payments
  • Excel Sheet report has also been integrated for Customers,Tarrifs,Payments
  • You can create the CSV reports for Bills,Connection Types,Connections

Limitation of Mobile Phone Billing System

  • Run time report generation is not available in Mobile Phone Billing System.
  • We have not implemented the dynamic report for Bills,Tarrifs,Connection Types,Customers,Connections,Payments
  • This project Mobile Phone Billing System has not been developed on Model View Controller architecture, so its very complex to manage
  • Batch mode execution for Off-line reports of Bills, Tarrifs, Payments cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Mobile Phone Billing System

  • We have added all the validations for input value on the modules Bills,Customers,Connections
  • Tarrifs,Connection Types,Payments can not be submited without filling all the inout fields
  • Duplicate values testing has been implemented on Bills,Connections,Payments
  • CSRF token has also been implemented on Tarrifs,Customers,Bills, Connection Types,Payments
  • All the Bills,Tarrifs,Connection Types,Customers,Connections,Payments has integrated with captcha for spam protections
  • Access level validation has been implemented on Payments,Connection Types,Tarrifs
  • Number and character validation has also been implemented on Connections,Connection Types,Bills

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database