I want to make a daily report of check on work attendance, the record of the original card for working due to name of the daily report to me to do, and then calculate the working hours, and overtime work, scheduling is 08:00-12:00, 12:30 - ticket is a ticket - 18:30 overtime

CodePudding user response:

What's the problem?

CodePudding user response:

reference 1st floor SuperDay response:

what's the problem?

I think the original card records (checkinout table) will be automatically updated to the daily report (daily_sheet1), checkinout. Checktime field 07:00 to 10:00 update to daily_sheet1. The checkin field, ticket is to update the daily_sheet1 at 19:00. Checkout, and then calculation is beyond the time after ticket is updated to OTTime

CodePudding user response:

Use a trigger, binding checkinout table