In Progress

osCommerce / PHP + mysql DB small project

I need a cleanly designed separate PHP page that will sit in the admin area of oscommerce which allows an admin user to input / search / view 9 fields.

These are:

OrderID | Products | Name | Address | Date | Status | Further Comments | Staff

OrderID should be as per orders table

Items (pulled from the orders_products / products_title)

Name: (customer name from orders)

Address (delivery address etc. from orders)

Date (date purchased from the orders table)

Status: (last status in the orders_history)

Further Comments: (last comments in orders_history)

Staff: (new, char 32 for entering staff name)

The page itself should allow an admin person to enter all the above details into the database, so then it can be searched on: orderID, items, name, address, further comments, by date, or staff. Of these, items, further comments, name, address - these should all be wildcard matchable. (e.g. search on 'Sam*' in name could bring up: Samantha Wilkinson, Sam Jones, etc.).

Date searching should be done via an easy JS calendar application between two dates.

Results should be displayed in CSS 'table' format. And the orderID should be a link to a valid web page (so it is clickable and the admin staff can view order details immediately). It should also be possible to update the Status + further comments. Each change in status should be dated, and a history kept - as if they were editing the comments on the [url removed, login to view] page itself. There should be a button the user can press next to each unexpanded status to view the history status/comments for that particular order.

This data is for one admin to make a note of issues, then another one to come along to change/fix these problems. Then, later, it should be possible for someone else to come along and search on the history to see when things were fixed.

I hope that makes sense. I need this done ASAP - to be displayed on your server, I will upload this to mine myself once I am happy with your work. Please let me know if you have any questions.

Budget is around 300 - 500 dollars. Preferably closer to $300.

Skills:

See more: staff one, staff me up, sam am, please let me know if you have any questions, php per, Mysql questions, mysql customer database, make 300 dollars, js products, customer database php mysql, application web php mysql, small server, sam a, php.js, web sit, update project, update mysql, small easy, samantha, samantha a, sam g, php issues, php db, mysql admin, fix two small

About the Employer:
( 33 reviews ) London, United Kingdom

Project ID: #214962

Awarded to:

oscguy

Hi, i have strong Oscommerce /php/mysql skills there as you can see on all my reviews and projects on GAF. your requirement can be done quickly around 2 days(1 day for coding and 1 for testing to make sure) ho More

$300 USD in 2 days
(37 Reviews)
3.3

3 freelancers are bidding on average $300 for this job

netsolve

Did similar earlier. Glad to work. Regards

$300 USD in 1 day
(364 Reviews)
4.5
softdevsolutions

Hi, We have a long experience with OScommerce. I am confident we will fulfill your requirements.

$300 USD in 1 day
(5 Reviews)
0.0