API REST EXAMPLE

This is a small rest api application.

MAIN SECTIONS (Shifts, Employee(Workers),Employee Shifts,)

Shift

Fetch ALL Records

• http://subhenoorstore.com/teamway/api/shift/read.php

Fetch Single Record

• http://subhenoorstore.com/teamway/api/shift/single_read.php/?id=2`

Create Shift

• http://subhenoorstore.com/teamway/api/shift/create.php/

	{
	    "title" : "Shift Title"
	}

Update Shift

• http://subhenoorstore.com/teamway/api/shift/update.php/

	{
	    "id"	: "2",
	    "title" : "Shift Title"
	}

Delete Shift

• http://subhenoorstore.com/teamway/api/shift/delete.php/

	{
	    "id"	: "2"
	}

Worker

Fetch ALL Records

• http://subhenoorstore.com/teamway/api/worker/read.php

Fetch Single Record

• http://subhenoorstore.com/teamway/api/worker/single_read.php/?id=2`

Create Worker

• http://subhenoorstore.com/teamway/api/worker/create.php/

	{
	    "name" : "Worker 01",
	    "email" : "[email protected]",
	    "age" : "20",
	    "designation" : "Packer"
	}

Update Worker

• http://subhenoorstore.com/teamway/api/worker/update.php/

	{
	    "id"   : "3",
	    "name" : "Worker 03",
	    "email" : "[email protected]",
	    "age" : "20",
	    "designation" : "Packer"
	}

Delete Shift

• http://subhenoorstore.com/teamway/api/worker/delete.php/

	{
	    "id"	: "20"
	}

Worker Shift

Fetch ALL Records

• http://www.subhenoorstore.com/teamway/api/workershift/shift_by_date.php?date=%222021-05-04%22

Fetch Single Record

• http://www.subhenoorstore.com/teamway/api/workershift/shift_by_worker.php?id=2

Create Worker Shift

We first check by workerId exist in workershift data if not exist then we will insert other wise we throw error msg to client that worker already exist in that day for a shift

• http://subhenoorstore.com/teamway/api/worker/create.php/

	{
	    "workerId" : "1",
		"shiftId" : "1",
	    "date" : "2021-05-09"
	}

Delete Shift

• http://subhenoorstore.com/teamway/api/worker/delete.php/

	{
	    "workerId" : "1",
	    "date"	: "2021-05-09"
	}

DB Explanation

There are three tables.

• worker
  • Worker table is for workers, fields are(id,name,email,age,designation)
• shift
  • Shift tables is for shift, fields are(id,title)
• workershift
  • workershift is childtable to store the worker's shift record. Fields are (id,workerid,shiftid,date )