we need a simple php/mysql Online Spare part Ordering and Handling
System
We have a spare part list (1500 articles/40 columns) as a csv, or xml file which we have to bring to a
mysql database. (regularly because the list changes from time to time)
So the first task is to write a short script that does this job.
Now we need a web page with a user loging (any of the common opensourcce
scripts will do) 5 user levels (normal customer, dealers, our controling office, production end, admin)
On this page we want our customers (dealers) to select spare parts from our list.
The order has to be stored in the db and our office needs to know, (email ) that there is a new order.
The office checks (changes) and approves the order.
Now our production needs to be notified (email)- checks the order and accepts it.
a simple cron job should check overdue items and inform aour controlling office
admin can change all entries in sparepart list and in order list
office can change order list
main task is, to combine our spare part list with the order data and user rights (see data / edit data..)
The attached excel sheet explains more..
Hi there,
I have gone through your project will be happy to inform you that we can meet up your expectations. Please check PM for details on our portfolio Regards Arka