Closed

272483 php mysql and ajax quick one

This project was awarded to Jameskap for $150 USD.

Get free quotes for a project like this
Project Budget
N/A
Total Bids
1
Project Description

A fairly simple and effective system needs to be build in... use of ajax is important... and very simple web 2.0/css interface needed. And this one should be top priority...for anyone who has lots of work on hand should not opt for this.

We will have a employee table, vendor table, product table, customer table, and order entry table (master and detail)...an order can have multiple products.

The interface and navigation should be very user freindly ...and above all... it should be fairly ajaxed (i'm insisting on ajax, make sure)

There will be a simple admin section to add products, employees, vendors, manage customers and orders.

Where as the front-end will allow employee to login and enter order data .. and also allow him to add new customers ... after checking for existing ...

finally the orders data has to be exported to a specific csv format ...

-----------------

this is the admin section:----

Pls. work on the admin section...as a admin .. i should be able to :

Add vendors, edit vendors, delete vendors.

Add products, edit products, delete products

Add customer, edit and delete

Add employee, edit and delte

We cannot edit, vendor code and product code.

before deleting check vendor code for any records in order detail

before deleting check product code for any records in order detail

before deleting check employee for any records in order master

Vendor Table:

--------------

Vendor Code alpha numeric

Vendor Name

Vendor Email

Product Table:

---------------

Product code alpha numeric

Product name

Price

Cost

pageNumbers (alpha numeric)

Customer Table:

----------------

Customerid - auto generated

First Name

Last Name

Email id

Address1

Address2

City

State

Zip

Country

Phone

Order Master Table:

------------------

Orderid - auto generated

Orderdate

Customerid

Total Qty

Total Price

ShippingCost

Employee id

Date_entered

Order Detail Table:

--------------------

Orderid - same as of order master orderid

Productcode

Qty

Price

Amount

Vendor

Employee Table:

-----------------

Empid - auto generated

Emp Full name

Emp email id

Emp_username

Emp_password

Admin Table:

--------------

Adminid

Admin_username

Admin_pwd

Admin_email

Similarly, front end is fairly simple...

Thanks

Awarded to:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online