Bus Reservation System (1035559)

Closed Posted Oct 28, 2008 Paid on delivery
Closed Paid on delivery

Bus Reservation System

Introduction

The bus reservation system would allow any user to make a reservation and, eventually pay for the ticket. As a result, a reservation record is created and the user can select a seat. There are different models of buses therefore a bus configuration interface has to be created. Based on a particular bus configuration, an itinerary will be selected. There can be a variety of itineraries; therefore an Itinerary interface would have to be created.

A combination of an itinerary and bus configuration for a particular date is called a trip. Tickets can be bought for one way or round trip.

## Deliverables

Bus Reservation System

Introduction

The bus reservation system would allow any user to make a reservation and, eventually pay for the ticket. As a result, a reservation record is created and the user can select a seat. There are different models of buses therefore a bus configuration interface has to be created. Based on a particular bus configuration, an itinerary will be selected. There can be a variety of itineraries; therefore an Itinerary interface would have to be created.

A combination of an itinerary and bus configuration for a particular date is called a trip. Tickets can be bought for one way or round trip.

Bus Configuration

The Bus configuration interface would allow to enter the fleet of buses available for a particular company. The following are characteristics of buses:

1. Name (i.e. Neoplan Spaceliner)

2. Number of seats.

3. Number of seats per row.

4. Has TV

5. Has Air Conditioning

6. Has Sleeper

7. Has Meal

8. Seat space category (normal, wide, spacey, big recline)

9. Status (Active, Inactive)

Itinerary Configuration

The Itinerary configuration would allow to enter all the possible itineraries available for this company.

1. Identification (Kansas City, Laredo)

2. Start Day (Monday, Tuesday)

3. length (72 hours)

4. Stops (1 through 99)

5. Itinerary Stops

1. Stop Id (1,2,?€?)

2. Stop City

3. Arrival Time

4. Departure Time

5. Trip Price

Trip File

The Trip File has information about each portion of an itinerary.

1. Id

2. From

3. To

4. Departure Date

5. Departure Time

6. Trip Length (Hours & Minutes)

7. Itinerary ID

8. Bus ID

Reservations File

The reservations File contains a reservation for each trip or combination of trips:

1. Record ID

2. Reservation Id

3. Trip ID

4. Client ID

5. Amount

6. Paid Amount

7. Paid Date

8. Receipt Number

9. Change Seat Approve

Scenarios

A client may make a reservation for a particular trip or several trips at the same time and can be one way or round trip. There will be several records in the reservation file with the same reservation ID. There has to be a way to make sure that the seat will be available for the whole duration of the trip. If the passenger needs to change seats during the trip, a warning has to be displayed for the passenger to approve it.

Reservation Interface

The reservation interface will first display the itineraries for a departure date and time, the departure city and arrival city. The system will display an itinerary or a portion of itinerary. (i.e. for the itinerary Oklahoma City to Laredo with stops in Dallas, Austin, San Antonio), the passenger only wants to travel from Austin to San Antonio.

The system will search the trip database to select all records that stop in San Antonio and Austin with the same itinerary ID and will list the times.

The passenger will select one and continue to the seat assignment interface. If there are seats available for the entire segment that the passenger requests, only those seats will be displayed. If the seat has to change in the middle of the trip, it has to be marked in the seat assignment interface.

The seat assignment interface has to show graphically the layout of the bus.

Ajax has to be used as much as possible for this interface and also for the selection of the departure and arrival city.

There will be an opening and closing of day procedures based on the sales. Any standard procedure suggested will be accepted.

Interface available in Spanish and English strongly desired.

For questions and suggestions please write to:

* * *This broadcast message was sent to all bidders on Wednesday Oct 29, 2008 10:47:04 AM:

Hello All, Thank you for your comments and bids. I realize I need to extend a little more the specs of this project. This will be used by 5 different companies, so there's a management aspect I need to spec out. This includes the financial aspect of the sales of the tickets. I also want to be more specific with the graphical interface of the seat selection. I was trying to get a feel of this process and I didn't expect such an overwhelming response. Please expect a more detailed spec soon. I hope I can finish this by today. Any additional questions, please feel free to ask. Thanks, Herman Cordero

* * *This broadcast message was sent to all bidders on Thursday Oct 30, 2008 11:19:20 AM:

I have decided to build a PROTOTYPE first and this bidding will be for the PROTOTYPE only. The Administration features will be part of a second phase and most likely an extensive list of modifications will be included. The Prototype must allow to Add/Change/Remove buses and it's configuration (Include a Preview of the bus layout and allow to upload an actual picture of the Bus to be displayed on the reservations screen) The Prototype must allow to Add/Change/Remove itineraries (Don't worry about security but keep it in mind for second phase). Remember that itineraries are a parent to the Itinerary Stops so we'll need a 1-to-many interface here. The Prototype must allow to create trips based on itineraries and for a particular date. For instance, let's say I want to "Generate" the trips records for Itinerary "ABC" using Bus "EFG" starting no November 15th. The system will generate a trip record for each of the stops of the itinerary. The prototype must allow to make reservations based on the screens I have uploaded today. A reservation has to be unique and the passenger or the administrator of the system must be able to retrieve that reservation and re-print the ticket. I know I have left many grey areas such as the look and feel. Be as creative as you can, mostly when selecting the seat. If you want to send a mock-up ahead of time it would be great, but that will not guarantee being selected. I would like to hire you all, but unfortunately only one can be selected. In order to be fair to everyone, I will judge using the following criteria: Price, Navigation, Graphical Look, Attention to detail (no bugs, links to nowhere, missing graphics, etc) I will start by analyzing your portfolios and any information you can give me that will help me go through the criteria above. Like I mentioned before, there will be a second phase and possibly a 3rd if the prototype get's the response I expect. If you have questions, don't hesitate to ask. Good luck to all. Herman Cordero

* * *This broadcast message was sent to all bidders on Thursday Oct 30, 2008 11:36:43 AM:

Thanks to Renterludorf for his questions. Please take note of these: Are bookings going to be online only, or there is also counter sale, where passenger could come to the station and buy a ticket? [url removed, login to view] good point. Yes, we need a counter sale interface. One that can allow an agent to quickly sell a ticket without having to go through the different screens on the passenger interface. Taking into account that there are stations and stops, the system need to have some kind of "route planner" where every trip route should be entered and saved to database to allow search. The itinerary is the trip route and each time there's a run of the itinerary, a "Trip" record is created. How about payment methods, have you considered cost of transactions, charges, charges back? For now Cash only. Second phase will include Credit Cards.

* * *This broadcast message was sent to all bidders on Thursday Oct 30, 2008 5:31:25 PM:

Please look at this system. Very Sleek. I really like the interface. Notice that by selecting departure, arrival options are automatically loaded. Then when checking availability, if one of the segments is not available it allows the user to go forward or backward one day at a time. The seat selection is also very practical. It will also pop-up the different stops in a particular city. [url removed, login to view]

* * *This broadcast message was sent to all bidders on Sunday Nov 2, 2008 10:46:47 PM:

I have simplified the bid request to limit it to the prototype. I will upload a file called bus_prototype.zip. Please read it and feel free to change your bid. Regards, Herman Cordero

* * *This broadcast message was sent to all bidders on Tuesday Nov 4, 2008 7:04:35 PM:

I have uploaded a litle more detail for the deliverables. I don't have any additional questions as far as the project so I will proceed to select the best bidder.

Thank you all for the time spend and for all your questions.

Regards,

Herman Cordero

* * *This broadcast message was sent to all bidders on Tuesday Nov 11, 2008 12:54:45 PM:

If you have not submitted a bid, Please submit a bid for this project in order to be considered. Thank you, Herman Cordero

Engineering MySQL PHP Project Management Software Architecture Software Testing Web Hosting Website Management Website Testing

Project ID: #3345582

About the project

34 proposals Remote project Active Jan 2, 2009

34 freelancers are bidding on average $2445 for this job

LeadSoft

See private message.

$6970 USD in 10 days
(32 Reviews)
7.7
alitharwani

See private message.

$2125 USD in 10 days
(264 Reviews)
7.8
skylane

See private message.

$1275 USD in 10 days
(275 Reviews)
7.6
farroid

See private message.

$4250 USD in 10 days
(93 Reviews)
6.9
ndima

See private message.

$3187.5 USD in 10 days
(96 Reviews)
6.6
acumensoftUK

See private message.

$2975 USD in 10 days
(21 Reviews)
6.6
suthernsoftware

See private message.

$425 USD in 10 days
(61 Reviews)
6.6
itscriptsl

See private message.

$5440 USD in 10 days
(19 Reviews)
6.4
anchorx

See private message.

$12750 USD in 10 days
(7 Reviews)
6.4
GlobalImpact

See private message.

$3187.5 USD in 10 days
(17 Reviews)
6.4
grandtulba

See private message.

$1274.99 USD in 10 days
(131 Reviews)
6.4
bharat28

See private message.

$1062.5 USD in 10 days
(24 Reviews)
5.6
sunjove

See private message.

$2549.15 USD in 10 days
(32 Reviews)
5.4
FMKSOFT

See private message.

$2295 USD in 10 days
(10 Reviews)
5.2
rainbow

See private message.

$2550 USD in 10 days
(26 Reviews)
5.3
venturekeen

See private message.

$646 USD in 10 days
(15 Reviews)
5.1
amcozarish

See private message.

$1530 USD in 10 days
(4 Reviews)
4.7
ejyothiadmin

See private message.

$1530 USD in 10 days
(8 Reviews)
3.6
tito1024vw

See private message.

$425 USD in 10 days
(18 Reviews)
3.5
arkotechvw

See private message.

$1530 USD in 10 days
(4 Reviews)
3.6