Online Bus Booking System
Submitted by Ronald Ngoda on Monday, May 21, 2018 - 21:04.
Language
This is an online bus ticket/booking system. With this system bus company owners can easily manage the bookings/reservations for seats in their buses. Company owners can manage bus routes, bus availability and list all the buses and seats. With this system customers cannot book for seats that have already been booked. Customers can not also create double reservation. For example if a customer has booked seat A10:DATE:today BUS:1 The same customer cannot also go and book SEAT A20:DATE:today BUS:1 same departure time.
Customers can only make reservations for buses and routes that are made available by admin or company management. This is to avoid confusions and enable proper planning and descition making.
The system admin can view summary reports of all and or fundamental activities within the system and be able to tell how the system is working from the rich insights from the summaries.
Customers can print receipts upon successfull booking and or can go to the booking agent to print the receipt and confirm payment.
--------INSTALLATION--------
After extracting the zip file in the root directory of your local server/online server.
Go to the folder named INSTALL.
Find a file named busbooking.sql.
Go to phpmyadmin and create a database named busbooking.
Import the file we named above busbooking.sql to create all the required tables for our system.
After successfull import you can now use the system.
==LOGIN DETAILS==
ADMIN
user:admin
pass:admin
==CUSTOMER==
create a new customer account using the sign up button on the login page!!!
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.
Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.
FOR YOUR OWN SAFETY, PLEASE:
1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
Comments
Hi, Ronald. Could you please assist on show only available seats
- <?php
- // This script and data application were generated by AppGini 5.71
- // Download AppGini for free from https://bigprof.com/appgini/download/
- include("$currDir/defaultLang.php");
- include("$currDir/language.php");
- include("$currDir/lib.php");
- @include("$currDir/hooks/seats.php");
- include("$currDir/seats_dml.php");
- // mm: can the current member access this page?
- $perm=getTablePermissions('seats');
- if(!$perm[0]){
- echo error_message($Translation['tableAccessDenied'], false);
- echo '<script>setTimeout("window.location=\'index.php?signOut=1\'", 2000);</script>';
- exit;
- }
- $x = new DataList;
- $x->TableName = "seats";
- // Fields that can be displayed in the table view
- "`seats`.`id`" => "id",
- "`seats`.`name`" => "name"
- );
- // mapping incoming sort by requests to actual query fields
- 1 => '`seats`.`id`',
- 2 => 2
- );
- // Fields that can be displayed in the csv file
- "`seats`.`id`" => "id",
- "`seats`.`name`" => "name"
- );
- // Fields that can be filtered
- "`seats`.`id`" => "ID",
- "`seats`.`name`" => "Name"
- );
- // Fields that can be quick searched
- "`seats`.`id`" => "id",
- "`seats`.`name`" => "name"
- );
- // Lookup fields that can be used as filterers
- $x->QueryFrom = "`seats` ";
- $x->QueryWhere = '';
- $x->QueryOrder = '';
- $x->AllowSelection = 1;
- $x->HideTableView = ($perm[2]==0 ? 1 : 0);
- $x->AllowDelete = $perm[4];
- $x->AllowMassDelete = true;
- $x->AllowInsert = $perm[1];
- $x->AllowUpdate = $perm[3];
- $x->SeparateDV = 1;
- $x->AllowDeleteOfParents = 0;
- $x->AllowFilters = 1;
- $x->AllowSavingFilters = 0;
- $x->AllowSorting = 1;
- $x->AllowNavigation = 1;
- $x->AllowPrinting = 1;
- $x->AllowCSV = 1;
- $x->RecordsPerPage = 20;
- $x->QuickSearch = 1;
- $x->QuickSearchText = $Translation["quick search"];
- $x->ScriptFileName = "seats_view.php";
- $x->RedirectAfterInsert = "seats_view.php?SelectedID=#ID#";
- $x->TableTitle = "Seats";
- $x->TableIcon = "resources/table_icons/chair.png";
- $x->PrimaryKey = "`seats`.`id`";
- $x->DefaultSortField = '1';
- $x->DefaultSortDirection = 'desc';
- // template paths below are based on the app main directory
- $x->Template = 'templates/seats_templateTV.html';
- $x->SelectedTemplate = 'templates/seats_templateTVS.html';
- $x->TemplateDV = 'templates/seats_templateDV.html';
- $x->TemplateDVP = 'templates/seats_templateDVP.html';
- $x->ShowTableHeader = 1;
- $x->TVClasses = "";
- $x->DVClasses = "";
- $x->HighlightColor = '#FFF0C2';
- // mm: build the query based on current member's permissions
- $DisplayRecords = $_REQUEST['DisplayRecords'];
- if($perm[2]==1 || ($perm[2]>1 && $DisplayRecords=='user' && !$_REQUEST['NoFilter_x'])){ // view owner only
- $x->QueryFrom.=', membership_userrecords';
- $x->QueryWhere="where `seats`.`id`=membership_userrecords.pkValue and membership_userrecords.tableName='seats' and lcase(membership_userrecords.memberID)='".getLoggedMemberID()."'";
- }elseif($perm[2]==2 || ($perm[2]>2 && $DisplayRecords=='group' && !$_REQUEST['NoFilter_x'])){ // view group only
- $x->QueryFrom.=', membership_userrecords';
- $x->QueryWhere="where `seats`.`id`=membership_userrecords.pkValue and membership_userrecords.tableName='seats' and membership_userrecords.groupID='".getLoggedGroupID()."'";
- }elseif($perm[2]==3){ // view all
- // no further action
- }elseif($perm[2]==0){ // view none
- $x->QueryFrom = '`seats`';
- $x->QueryWhere = '';
- $x->DefaultSortField = '';
- }
- // hook: seats_init
- $render=TRUE;
- $render=seats_init($x, getMemberInfo(), $args);
- }
- if($render) $x->Render();
- // hook: seats_header
- $headerCode='';
- $headerCode=seats_header($x->ContentType, getMemberInfo(), $args);
- }
- if(!$headerCode){
- include_once("$currDir/header.php");
- }else{
- }
- echo $x->HTML;
- // hook: seats_footer
- $footerCode='';
- $footerCode=seats_footer($x->ContentType, getMemberInfo(), $args);
- }
- if(!$footerCode){
- include_once("$currDir/footer.php");
- }else{
- }
- ?>
New Version?
hi there,
do you have an updated version?
I am getting an error and cannot run it.
best regards and thanks
Add new comment
- Add new comment
- 11587 views