The goal of this application is to help companies track their projects and who has been working on them.
-
Prerequisites
- CSV file in the following format with headers :
- Employee ID
- Project ID
- DateFrom
- DateTo
-
Current stage of supported endpoints
- Running the application will delete all previous records in the DB and populate the ones from the CSV file
- http://localhost:8080/emp-projects/all - showing all the CSV records
- http://localhost:8080/emp-projects/add-emp-projects - POST request with a JSON to add employee-project info
- http://localhost:8080/emp-projects/get-overlapping - GET request showing all the employees and projects that worked together
- Closing the application will save all the records and updates made throughout the session in the DB
The idea of the project was to get the most amount of days that two employees have worked on different projects, however at this stage this is not supported in this project. We have a list of employee pairs and the amount they worked together on a certain project, and this info is ordered by the days they have worked together in descending order.