Online Order Registration System (Database)

In Progress Posted Nov 6, 2014 Paid on delivery
In Progress Paid on delivery

Invitation to database programmers.

Project Summary

I need an online database to capture online order. I intent to use PHP and MYSQL. This database can be duplicated a new one whenever a new course starts. More info and updates will be given when project awarded.

Details of Online Database

The database will import data from XLS and CSV files. Database is fill with:

1. Student ID

2. Student Name

3. Course Name

4. Start Date

5. Start Time

6. and some more data

Page 1:

Explanation of online order procedure.

When user input his Student ID number and click SUBMIT

It will retrieve and display …

Page 2: the Student ID, Student Name and Diploma Course. (These 3 details will be on all pages onward)

User will choose: SELF COLLECTION or HOME DELIVERY (Internet banking required)

Click NEXT

IF SELF COLLECTION:

Page 3A: Explanation of Rental and Purchase options.

With prices of RENTAL and PURCHASE options to choose.

Click NEXT

IF HOME DELIVERY:

Page 3B: Explanation of Rental and Purchase options.

With prices of RENTAL and PURCHASE options to choose.

Address field for delivery to fill in.

Click NEXT

Page 4: With the selection of uniform size (button option) with size chart (picture) provided.

Click NEXT

Page 5: Order summary and confirmation of details.

This page offer EDIT and NEXT. EDIT will enable this page to be editable.

Page 6: Terms and Conditions listed here.

User agree by inputing his email address in the email field.

Click AGREE & SUBMIT (For SELF DELIVERY, display AGREE & SUBMIT button)

Click AGREE (For SELF COLLECTION, display AGREE button) and got to Page 6A

IF HOME DELIVERY:

Page 6A will have link for payment options. When Click, it will pop up another window to the respective banks login page.

This page will have an input field for user to enter reference number.

Click NEXT

If reference number is already recorded, it will display a warning message.

Page 7: Thank you page

System will generate email confirmation to user and attached a PDF of the order form.

This PDF order form has a specific layout requirement.

If same Student ID use again, it will prompt order has been made. Request user to check email for order confirmation or contact us.

This database form will be embedded on a website.

Barcode Required.

The order confirmation will be emailed to user in PDF.

In this PDF, I need to have 2 barcodes. One with details of Student ID, Student Name and Course Name. The other one, Student ID, Student Name, Course Name and Uniform Size.

Reports:

Extract data to see daily/weekly/monthly order

Filter Rental/Purchase/Payment

Reports can be auto generated and forward to multiple email addresses. Email address changeable by user.

Database Development Database Programming MySQL PHP Software Development

Project ID: #6693785

About the project

30 proposals Remote project Active Nov 13, 2014

30 freelancers are bidding on average $420 for this job

taskmanageryd

Hello..I am ready to start work from now but i have few questions regarding your project description...can you please make a reply so we can discuss it...Thanks and need a quick reply

$500 SGD in 7 days
(276 Reviews)
8.4
mituld

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks

$412 SGD in 14 days
(454 Reviews)
8.2
gopalvora

Hi I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joo More

$247 SGD in 12 days
(510 Reviews)
8.3
sprextech

----------------------------------------------------------Please Consider on My BID---------------------------------------------------Dear Sir/Madam, We are already read your project description & fully understand this More

$500 SGD in 10 days
(337 Reviews)
7.7
neoconcepts

we are expert php developer here. we like to build this Online Order Registration System as per your requirements. let's start.

$333 SGD in 3 days
(166 Reviews)
7.5
logicscreators

A proposal has not yet been provided

$1000 SGD in 12 days
(125 Reviews)
7.1
sunsoftpro

First, I am sunsoftpro, I from VietNam. Nice to meet you! I have read your description and been interested in your project. I'm ready to discuss and do hard working so that complete great job. Please discuss befor More

$1200 SGD in 12 days
(127 Reviews)
7.1
kssoftphp

A proposal has not yet been provided

$500 SGD in 15 days
(93 Reviews)
6.9
kimit1234

A proposal has not yet been provided

$355 SGD in 15 days
(110 Reviews)
6.0
tsarevilya

Hi, if you need only database structure (SQL), I can do it for this amount of money. However if you need programming of every page, the price will be 3-4 times higher. Please contact me when you have time to discuss More

$230 SGD in 3 days
(12 Reviews)
6.0
acronymsolutions

Hi, I have gone through your requirements,I am a Database Programmer at CMMI-5 Level company since August 2004.I am working on MS Access, Shell Script,MySql,MSSQL Server,Oracle database, I can do your job confidently. More

$526 SGD in 10 days
(38 Reviews)
5.6
slimmiz

Hi, i got 7+ years exp in development and i can create your order managment system fast and in best quality code that u will love, using php and mysql

$250 SGD in 7 days
(25 Reviews)
4.7
HealthyCoder

Hello Sir, Being a Software Engineer i can do your job very easly, i am professional web-Developer and i can give you professional output, contact me if you like. Regards SIbghat Ullah

$111 SGD in 4 days
(10 Reviews)
3.7
SaswatKumar001

A proposal has not yet been provided

$88 SGD in 10 days
(0 Reviews)
0.0
jayadevant

I have been working with database design and optimization for more than 15 years. I would like to mention upfront that I can't do the php and UI part.

$250 SGD in 3 days
(0 Reviews)
0.0
winnergize

Although the bid is within the scope of our skill, and we are interested in principle, at present, we are able to respond and to complete with quality in time : My Skill: Database Development, Database Programming, My More

$155 SGD in 3 days
(0 Reviews)
0.0