Hall Booking System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Hall Booking System

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

Functionalities and their descriptions of Hall Booking System are as follows:

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

Modules of Hall Booking System and their descriptions:

  • Hall Module : Manage all the operations of Hall
  • Booking Module : Manage all the operations of Booking
  • Payment Module : Manage all the operations of Payment
  • Customers Module : Manage all the operations of Customers
  • Inventory Module : Manage all the operations of Inventory
  • Bill Module : Manage all the operations of Bill

Classes and their methods of Hall Booking System:

  • Hall Methods : addHall(), editHall(), deleteHall(), updateHall(), saveHall(), searchHall()
  • Booking Methods : addBooking(), editBooking(), deleteBooking(), updateBooking(), saveBooking(), searchBooking()
  • Payment Methods : addPayment(), editPayment(), deletePayment(), updatePayment(), savePayment(), searchPayment()
  • Customers Methods : addCustomers(), editCustomers(), deleteCustomers(), updateCustomers(), saveCustomers(), searchCustomers()
  • Inventory Methods : addInventory(), editInventory(), deleteInventory(), updateInventory(), saveInventory(), searchInventory()
  • Bill Methods : addBill(), editBill(), deleteBill(), updateBill(), saveBill(), searchBill()

Database tables and attributes of the Hall Booking System:

  • Hall Entity : Attributes of Hall are hall_id, hall_name, hall_place, hall_charge, hall_type, hall_description
  • Booking Entity : Attributes of Booking are booking_id, booking_title, booking_type, booking_hall, booking_date, booking_description
  • Payment Entity : Attributes of Payment are payment_id, payment_customer_id, payment_date, payment_amount, payment_description
  • Customers Entity : Attributes of Customers are customer_id, customer_name, customer_mobile, customer_email, customer_username, customer_password, customer_address
  • Inventory Entity : Attributes of Inventory are inventory_id, inventory_items, inventory_number, inventory_type, inventory_description
  • Bill Entity : Attributes of Bill are bill_id, bill_customer_id, bill_number, bill_type, bill_receipt, bill_description

Database definition of Hall Booking System:

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

Super admin functionality of Hall Booking System:

  • Admin can add, edit, delete and view the records of Hall, Inventory, Payment, Bill
  • Admin can manage all the details of Booking, Payment, Customers, Inventory
  • Admin can also generate reports of Hall, Booking, Payment, Customers
  • Admin can search the details of Hall, Inventory, Payment, Bill
  • Admin can apply different level of filters on report of Hall, Payment, Bill
  • Admin can tracks the detailed information of Inventory, Bill, Hall, Booking

Report of Hall Booking System:

  • Generates the report on Payment,Customers,Hall,Booking,Inventory,Bill,
  • Customers,Inventory,Bill 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 Customers,Inventory,Bill
  • Excel Sheet report has also been integrated for Booking,Customers,Bill
  • You can create the CSV reports for Hall,Inventory,Payment

Limitation of Hall Booking System

  • Run time report generation is not available in Hall Booking System.
  • We have not implemented the dynamic report for Hall,Customers,Inventory,Booking,Payment,Bill
  • This project Hall 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 Hall, Customers, Bill cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Hall Booking System

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

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database