ChronoSystems-AWS-TimeSheet-Engine

Database ERD diagram

ChronoSystems-AWS-TimeSheet-Engine
- Database ERD diagram
EmployeeTimesheet API
- GET
- POST
ProjectManager API

EmployeeTimesheet API

https://oxtwzrrqrg.execute-api.us-west-2.amazonaws.com/development

GET

Dates in MM/DD/YYYY format. Remember to URIEncode.

/getEmployeeTimesheet?start_date=<value1>&end_date=<value2>&uid=<value3>

Retrieves all timesheet entries from the date range of an employee.

/getEmployeeTimesheet?uid=<value3>

Retrieves all timesheet entries of an employee.

POST

/postEmployeeTimesheet

{
	"submission": [
		{
			"uid": "string",
			"date": "MM/DD/YYYY",
			"start_time": "00:00 AM",
			"end_time": "00:00 PM",
			"break_duration": 60
		}, {
			"uid": "string",
			"date": "MM/DD/YYYY",
			"start_time": "00:00 AM",
			"end_time": "00:00 PM",
			"break_duration": 60
		},
	]
}

ProjectManager API

https://9zsjgjfqlh.execute-api.us-west-2.amazonaws.com/development

GET

Get all projects

/getAllProjects

Retrieves all projects. This can be used to create a table of all existing projects.

Get all project members

/getProjectMembers?projectId=<id of project>

This route is used to retrieve all members of a specific projects to be displayed to admin, or have a page for all users to see who's is assigned to what project.

Get all working projects of a user

/getAssignedProjects?uid=<uid of user>

This route is used to retrieve all projects a user is assigned to. This can be used on the timesheet submission page to associate the worked weeks to a specfically assigned project.

Get all weeks a member worked on a specific project

/getProjectWeeks?projectId=<id of project>&uid=<uid of user>

This route is used to retrieve all weeks a user worked on a specific project. Can be used to get date ranges and these ranges can be passed to EmployeeTimeSheet API to retrieve total hours worked on a project.

PUT

Create a project

/putProject

This route is used to create a project. The projectId is autogenerated based on time and hashed. The project name can also be updated given the projectId.

Request body for create a project

{
    "name": "Name of project"
}

Join a project

/putJoinProject

This route is used for a user/employee to join a project.

Request body for join a project

{
    "projectId": "Id of project",
    "uid": "UID of user"
}

Create an entry for ProjectWeeks (Specifies which project was worked on for the week)

/putProjectWeek

This route is used in the timesheet submission page where users are able to select which project they worked on for the week.

Request body for creating a project week entry

{
    "projectId": "Id of project",
    "uid": "UID of user",
    "start_week_date": "mm/dd/yyyy",
    "end_week_date": "mm/dd/yyyy"
}

DELETE

Leave a project

/deleteJoinProject

This route is used to remove a user/employee from a project. This does not do a cascading delete operation.

Request body for leaving a project

{
    "projectId": "Id of project",
    "uid": "UID of user"
}

Syte1/ChronoSystems-AWS-TimeSheet-Engine