Sayit

Project

SAYIT J1 Visa Program

Time Line

2006 October à Till date

Business Need

   Manage student’s booking of J1 Visa to work in America for the summer.

Project Description

The SAYIT J1 Visa Program is a website that has 2 functions. It allows student’s book their J1 Visa to work in America for the summer. This involves the entering of personal, passport, and payment details. The student also needs to book their flights. The website also acts as a back-office administration tool. This tool allows SAYIT to administer over all of the applications. The website also has the ability to send alerts to the students who have not submitted certain documentation.

The students who would like to get J1 visa will fill up the booking form available on line. There are four stages for this booking. The student need to submit their personal details such as personal information, college details, passport details, relatives details and companion details.

Figure 1

Now the student may need to select from the following programs:

1. Standard: Standard allows the Student to pick a particular flight from the inventory which has a specific departure date and choose returns dates and stop off option. Sayit, the travel company can then book the flights based on this information. Prices are fixed for this option.
2. Independent: Independent allows the student to merely view sample prices for flights and enter preferred dates of departure. Then the flights are arranged manually by the travel company based on the dates given and after consultation with the student. Pricing is variable for this part of the booking process and so will be added later by staff as depending on preferred dates and availability, prices may be higher or lower than advertised. However it allows the student more flexibility with dates and carriers/airlines.
3. Low Cost: For low cost the student will be redirected to the World Travel website. The Student ID and some of the personal details are passed in the URL. While booking their flight the student will have entered credit card details and other payment details. When the student has finished booking their flights they will be redirected back to the student details section. The credit card and payment details will also be sent back but they will be encrypted using the Blowfish encryption algorithm. When these details are received they will have to be decrypted using a key which will be provided by World Travel.
4. Visa Only: This will allow the student to purchase the visa on its own.

Following form is used to select the programs:

Figure 2

If students choose standard click the next button they will get a flight list with fixed price. Student selects any of these flight provide the return date. These flight details are added from the back end admin section.

Figure 3

If a student chooses independent program a list of flights will be listed with prices like below:

Figure 4

Student chooses the flight and enters the return date and payment page will display.

If a student select low cost he/she will be redirected to some World Travel site. For visa only option the flight pages won’t show up student will be redirected to payments page.

The payment page will display all the details of payments that have to be made by the student and a form to submit student payment details. Student may need to select an insurance package from the drop down box. There is an option for a the student to fast tacking his booking.

Figure 5

Payment form:

In the payment form student enters credit card details, deposit amount etc. After the student agree with the terms and conditions submits the form.

Figure 6

After submitting this form a mail will be send to the student with the student id.

SayIT J1 Administration:

The admin section the administrator can see a list of students who has booked online. Admin can also add a student using ‘Add A Student’ link in the following figure.

Figure 7

Admin can update the students using ‘Details’ link. On click of this link all the details entered by the student will populate.

Figure 8

The admin can view and update the payments made by the student by clicking the ‘Payment Details’ link in the above Figure.

On click of ‘Tracking Details’ link is used for tracking of the Visa applications of a student.

Figure 9

The admin can also cancel a booking using the ‘Cancel Booking’ link in Figure 8. The invoice link in Figure 8 is used to print the invoice details for a student.

Figure 10

On click of ‘Flights’ link in the main menu following page will display with the list of standard flights.

Figure 11

We can add flights using ‘Add a new Flights’ link. On click of Edit link we can update or delete a particular flight.

Figure 12

On click of ‘Independent Flights’ link in the main menu the flight list for independent program will be listed. Using this page we can add/Update/Delete flights for independent option.

Figure 13

The ‘User’ section is used for add/update/delete users for the administration tool. There are three roles: Super Admin, Admin and agent.

Figure 14

Under ‘Report’ section there is Query Engine which will query from the database table and display the student details. The admin will check the columns to be generated and value for these columns and submit the below form.

Figure 15

Query engine will generate the data and display like below:

Figure 16

The admin can export this into an Excel Sheet using the ‘Export’ link. ‘Send SMS’ link is used to send sms for the students. This functionality is done using a third party site.

EShot section is used to send email for students.

Figure 17

‘Create a new EShot’ will create an email template. ‘Config EShot’ will configure the details like SMTP address, subject, to, from address etc. The ‘test’ link is used to send test emails. On click of ‘send’ link we can select a stage from the drop down which is listed as follows:

Figure 18

On submitting this students under this stage will be populated.

Figure 19

The admin can view the recipients of this email by clicking ‘Display Recipients’ link in the read circle. Then a window (above figure) will popup with a list of emails.

Technology

1. Eclipse 3.2 for development, debugging.

2. Resin 3.0 as the web server.

3. Mysql 4.1 as the database.

4. Java Tiger for compilation and to run Tomcat server.

5. SmartFTP to upload file to the main server

6. Servlets and Java Server Page for front-end and backend coding.

Cybertech’s Role

The core code for this was already in place. We added more features and enhancement for this system. Following are our contributions for this project.

a. Enhancement s

b. System Testing

c. Bug Fixing

d. Maintenance and Support