Working Pair
Pair of employees who have worked together: application that identifies the pair of employees who have worked together on common projects for the longest period of time and the time for each of those projects.
I used html, css, react
- download or clone the repository
- run
npm install - run
npm start
The application works in the following sequence:
- loads external CSV file (comma separated)
- parse the data to matrix
- check for invalid input(s)
- sort the data by project
- find all the pairs of employees worked on the same time
- find the pair working for the longest period of time
- result is displayed in two tables - Summary and Breakdown.
The CSV file load data in the following format: EmpID, ProjectID, DateFrom, DateTo
Testing files are placed inside /src/data/ folder
It accept the following date formats:
- ISO Date -> "2015-03-25" (The International Standard)
- Short Date -> "03/25/2015"
- Long Date -> "Mar 25 2015" or "25 Mar 2015"
The valid data should meet the following criteria:
- There should be no missing field(s)
- All DateFrom fields should be valid date
- All DateTo fields should be valid date or NULL
- There should be no date in the future
- All periods should be valid - start date is before end date
- There shouldn't be no 2 or more overlapping periods for one and the same combination "employee" && "task". In this case they will be merged.
Working Pair is still in progress.
List of contributors:
MIT license @ Alex Atanasov