To set up a simple Web-based Stock Control System using PHP/MySQL and Apache Web server.
The functionality should be such as any inventory appication example Sage Line 50 and should be provided on a web site.
The web site should be easy to use and be very simple just as the project is.
Most of the functionalities is not required from Sage, but very limited and this I will fully explain if you are interested.
A dynamic web site which controls inventory: addition, updating, deletion from a MySQL database. The scripting is to be done in PHP and will communicate through Apache web server for Windows.
Functionality will be that of Sage but not complex. Therefore, continuous contact and communication of requirements will make it very easy. It will only be dealing with stock so nothing to do with ledgers and accounting. Only control of stock and maintaing the database functionality is required.
Real-time exchange rate retreival function is required to download automatic current rates from eg. [[url removed, login to view]] and then use it to calculate stock prices of imports.
Once accepted detail information of user interactions will be provided.
Security will need to be provided to amend any information on the database but viewable to all. This will require user/password and cookies for session tracking: the type of user and his access restrictions.
Invoices will need to be created.
Provide specific information on products, sales, debtors etc.
Various queries will be required.
Functionality is not complex and can be done easily, within a short period of time with experience in hand.
HCI can be discussed and am not too worried about presentation or high quality web design.
All the scripts and source code must be provided with heavy commenting or documentation. And your help after completion of the project will be even greater appreciated if required at all.
I have already set up the technologies ie. PHP/MySQL/Apache and the source code is all I need.
The website will be run from a Windows XP machine.
The website will run on Windows XP machine therefore Apache webserver resting on a windows machine. The PHP/HTML web pages will access a MySQL database.
Website viewable on Internet Explorer.