Onile Gas Booking System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Onile Gas Booking System

Onile Gas Booking 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 Gas,Connections,Bookings,Payments,Delivery. Admin user can manage all the operations of Payments,Delivery,Gas,Customers,Connections and their details. Admin can create different type of reports of Gas,Connections,Bookings,Payments,Delivery according to their choise and filters. You can Download PHP and MySQL Project Onile Gas Booking System with source code and database from this site. We also provide Project Report of Onile Gas Booking System.

Functionalities and their descriptions of Onile Gas Booking System are as follows:

  • You can search records on various criterias. Such as Gas, Bookings, Payments, Delivery
  • Create, read, update and delete (CRUD) application has been implemented on Gas,Connections,Bookings,Payments,Delivery
  • Keep the track logs of Connections, Customers, Payments ect
  • Advance search has been implemented on Connections,Customers, Payments
  • You can see all the details of the Gas, Bookings, Customers, Payments
  • All the modules Customers, Payments, Connections,Delivery, Gas are inter related and tightly coupled
  • It deals with monitoring the information and transactions of Payments.
  • All the Connections,Customers, Payments 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 Gas data.

Modules of Onile Gas Booking System and their descriptions:

  • Gas Module : Manage all the operations of Gas
  • Connections Module : Manage all the operations of Connections
  • Customers Module : Manage all the operations of Customers
  • Bookings Module : Manage all the operations of Bookings
  • Payments Module : Manage all the operations of Payments
  • Delivery Module : Manage all the operations of Delivery

Classes and their methods of Onile Gas Booking System:

  • Gas Methods : addGas(), editGas(), deleteGas(), updateGas(), saveGas(), searchGas()
  • Connections Methods : addConnections(), editConnections(), deleteConnections(), updateConnections(), saveConnections(), searchConnections()
  • Customers Methods : addCustomers(), editCustomers(), deleteCustomers(), updateCustomers(), saveCustomers(), searchCustomers()
  • Bookings Methods : addBookings(), editBookings(), deleteBookings(), updateBookings(), saveBookings(), searchBookings()
  • Payments Methods : addPayments(), editPayments(), deletePayments(), updatePayments(), savePayments(), searchPayments()
  • Delivery Methods : addDelivery(), editDelivery(), deleteDelivery(), updateDelivery(), saveDelivery(), searchDelivery()

Database tables and attributes of the Onile Gas Booking System:

  • Gas Entity : Attributes of Gas are gas_id, gas_name, gas_type, gas_description
  • Connections Entity : Attributes of Connections are connection_id, connection_gas_id, connection_customer_id, connection_name, connection_type, connection_description
  • Customers Entity : Attributes of Customers are customer_id, customer_name, customer_mobile, customer_email, customer_username, customer_password, customer_address
  • Bookings Entity : Attributes of Bookings are booking_id, booking_gas_id, booking_title, booking_type, booking_date, booking_description
  • Payments Entity : Attributes of Payments are payment_id, payment_customer_id, payment_date, payment_amount, payment_description
  • Delivery Entity : Attributes of Delivery are delivery_id, delivery_customer_id, delivery_address, delivery_type, delivery_by, delivery_date, delivery_description

Database definition of Onile Gas Booking System:

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

Super admin functionality of Onile Gas Booking System:

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

Report of Onile Gas Booking System:

  • Generates the report on Customers,Bookings,Gas,Connections,Payments,Delivery,
  • Bookings,Payments,Delivery 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 Bookings,Payments,Delivery
  • Excel Sheet report has also been integrated for Connections,Bookings,Delivery
  • You can create the CSV reports for Gas,Payments,Customers

Limitation of Onile Gas Booking System

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

Input Data and Validation of Onile Gas Booking System

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

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database