Need a internal web interface for our team to track the order status and produce reports. Key features and design of application include.
1. There will be 3 users, each upload excel , needs to be loaded into website and display in web interface in grid mode (rows and columns).
2. Each users update the same rows and different columns. Key column fields are order id, product name, arriving date, dispatch date.
3. Reports include , report of delayed orders, report of orders in hand by each person, report of orders delivered, etc. Reports are based on the values on these condition.
4. if the input source file (excel or CSV) format has incorrect data type, need to high light them and produce log file.