Not a huge job but must be scalable. Business needs to be able to open and track three different forms from their contract clients. Each form will email to person in charge of each category at correct location (client has over 12, their customers are international.) Each staff member can have multiple responsibilities within each location. A few staff members may work at more than one location. I have setup a MySQL database with the tables needed and populated with 'dummy' data, but I'm running out of time trying to build the PHP forms as well as the admin side so that the client can maintain. Thanks
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. I'll need login pages so that employees of my client have permissions to add/remove records etc. Their clients will also be able to logging and see only their data (past orders, past requests etc) Also browser-based database ad min pages to make management of the database simple. Forms and an admin pages should be written in PHP 4.0 using Myself version 3.23. Forms should be modular to allow for further growth and easy customization. Code should be written in standard, clean, easily-read format. The item orders, RFQs, and Tech Requests, should append themselves to their respective tables and should include data from the tables ionlcuding client id,staff id etc for easy browsing. Please code witha view to security as well. I've attached a screenshot of the MySQL table layout which does not include the fiels I'll be using for the item order and other forms.
Custom Mitel e-smith SME server based on RedHat 7.2 Linux. PHP 4.0.6 MySQL [url removed, login to view]