The number of topic: find out the month absence information

Ask for leave table, users table clock in table table, punch watch off table are associated with the user id
My idea is to find out all information clock in that month, found to leave the user information, and then let the users table to heavy punch table and leave table, the rest is after absenteeism,

But the clock in time is how to judge, because found to clock in all of the users, not clear whether there is absent that day, according to the check in, as long as the user played CARDS during the month, this is meaningless, so I want to help, how to clear the user on the day of absence, absenteeism information, check a month all follow the day to check absence has been found out,

CodePudding user response:

Ask for leave that month should clock frequency=number of clock + number + absenteeism, according to this way of thinking to do, ask for leave if the clock frequency=clock frequency + number is not absent from school

CodePudding user response:

You this absence is a what concept, ask for leave? Late (not in the required time interval clock time)? Or what,,,
If the absence is late, you are processing punch table, according to the conditions of date not specification card people [the heaven and man id grouping, terms and conditions people knuckling under 2 times a day], associated user table, take to the user information is not good, associated with a few good,
If the absence is ask for leave, that is the most simple, similar ideas