Generate List of Employees Weekly and Monthly [closed]

91
January 04, 2020, at 09:20 AM
Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? Add details and clarify the problem by editing this post.

Closed 16 hours ago.

So I have a task to generate a list of employees weekly and monthly. So currently we have 5 departments and each department contains multiple numbers of employee e.g., Dept with ID 1 contains 3 employees, Dept with ID 2 contains 7 numbers of employees and so on.

I have two tables DEPARTMENTS and EMPLOYEES so from every department one employee will be on duty for 16hours 7 days a week.

Example: DEPARTMENT TABLE As shown in the pic

EMPLOYEE TABLE as shown in the pic

the output I want is like

as shown in the picture like days and employees for a week and I want it for a month also.

What query should I write or how can I use arrays to get this result from two tables!

READ ALSO
addEventListener scroll Uncaught TypeError: element.getBoundingClientRect is not a function

addEventListener scroll Uncaught TypeError: element.getBoundingClientRect is not a function

I'm trying to set up my code so it can detect if a certain section of my HTML is at the top of the viewportI'm getting the error:

114
Object navigator.mediaDevices is not accessible on mobile chrome browser

Object navigator.mediaDevices is not accessible on mobile chrome browser

I have been working on an application in which I use the object navigator to stream my webcamIt works perfectly on my pc browser, here's the github link

140