In Progress

272483 php mysql and ajax quick one

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

Skills: AJAX, Anything Goes, CSS, MySQL, PHP

See more: table customer, priority one, price table user interface, opt auto, data entry alpha, customer table, auto opt, alpha numeric data entry, alpha and numeric data entry, quick order, php master, EMP, code name one, php priority, css numeric, city state country php, mysql delete, mysql specific, php table csv, php login css, ajax login email, php user generated, data entry employee needed, ajax php edit, web data entry table

About the Employer:
( 62 reviews ) Newtown, India

Project ID: #2018767

Awarded to:

Jameskap

it can be Done.

$150 USD in 2 days
(0 Reviews)
3.7