- Import the CSV into the DB
- parameters: path to cvs
- executing the script: $ php «file path» «parameters» «path_to_csv»
- extra: frontend to import file through browser
- Present DB data (should read the Sales table and output the data)
parameters should be set through URL
optional parameters:
"group_by" which can accept "hour", "day", "month"
"deal_id" which accept deal id as parameter
"client_id" which accept deal id as parameter
frontend interface to present data
layout/html/css/plugins used to present/filter data in the page should be selected by developer at his own description (free to use templates and frameworks)
filters should be through select boxes for client_id/deal_id/group_by
DB:
- must be MySQL and creation script must be provided
- Consists in 3 tables clients, deals and sales
- Connection should be easy to setup and unique for all scripts
CSV:
- Client name and ID are defined in client column has: «name» @«id»
- Deal name and ID are defined in deal column has: «name» #«id»
- the remaining content belongs to Sales
- CSV: https://docs.google.com/spreadsheets/d/1UJxujqUMb7SeXdfoHJgfFbwtC1xvdmT2ma710Mn6D7Y/edit?usp=sharing