I need a workflow management system built using, HTML, CLASSIC ASP OR ASP.NET,MVC, AJAX, AND SQL SERVER. It will be used mainly over an INTRANET via IIS and sometimes over the INTERNET when the In-House Server is connect to the internet. So design considerations need to be put in here.
Below is what is needed to be done
1. Database (by freelancer I choose)
2. User interface design (By Me, i'll provide an HTML5 template for you to work with, will include everything freelancer need2work with)
3. Coding (By freelancer)
4. Report design / Dashboard (Interface design done by me and the reporting and dashboard coding by freelancer).
So the system has 5 access levels
1. Those that do stock operations (Stock Staff)
2. Those that key in data (Front desk officer/ Support Staff)
3. Those that can manipulate data (Engineer)
4. Those that can manipulate and confirm data (Admin )
5. Those that use data via reporting and dashboard to make decisions (Managers)
Scenario : Please have in mind the system will be used via INTRANET and INTERNET and will be on IIS on the local in-house server
For the Stock operations: Stock Staff can do all basic stock operations – Stockin, StockOut, Stock Take, Reconciliation etc (pls note that the stock operations is part of the system)
New or Old Customer brings in laptop or other electronic devices or even to check if their device is ready:
Front desk officer checks to see if the device has been brought to the place already through product id, requisition id or name ( whatever unique values can be used).
If not available, open a new job order to receive the device, different devices can be tied to either a person or a company. The new order is called a job and can be assigned to an Engineer by Admin.
Once the Front desk officer creates a new job, the Admin gets a notification (and email if the server is connected to the internet)
Admin gets notification in-the-app (or email) about new job order, he/she then assigns it to a Engineer who gets notification inside the app and (email)
The Engineer, then update status of the job even before working on it and those involved (front desk, Admin, Manager) gets notification.
The Engineer can make requisition for parts to be used for repair, the Stock Staff gets notification and can either accept or reject request and these parts are deducted from the stock table in the database.
As Engineer continues to work on job (device), he/she can update(pending, in progress, completed with percentage of work done), also everyone connected to that particular job( the front desk person that created the job, Admin and Manager) gets a notification.
Once Engineer updates as Completed, Engineer need to confirm the work physically and Approve or Reject Job.
The Front Desk gets notification and will also update after calling the customer as Delivered or Pending collection or the system automatically sends a SMS to customer
So based on the above, reports are compiled and automatically generated based on all the above operations.
Finally data is attached to a dashboard and charts (i will make the template available) which will give Manager a general overview of what is happening in the company based on jobs done, uncompleted jobs, what parts are used, parts left and other reports on a daily, weekly, monthly and date range basis etc.So even when the Manager is in his room or oversea, he can monitor what is happening. Manager also gets notification of every operation that happens in the system
Firstly I need you to explain what you understand by the above and also tell me how you will model the system and and build it and also with which technologies. Please no PHP
NB: I will provide an HTML5 template which will include almost all you will need to work with as regards interface design to reduce work done - i just attached a sample of how the Dashboard will look like