The 2019-01-01 a
The 2019-01-02 b
The 2019-01-03 c
The 2019-01-04 d
The 2019-01-05 e
.
.
The 2019-01-31 a
A YiBingDing e everyone on a day class, each person every day connecting on a GSM (18:00-24:00) and 1 night (24:00-8:00); Meter for a middle shift plus 1 night shift, but overall attendance statistics in January, the 2018-12-31 e on the night shift (24:00-8:00) should be included in January, that is to say, e should add one more night in January, in the same way, at the end of the 2019-01-31 a night (24: - 8:00) should be classified as attendance in February, armour should be home for a night shift in January, each month like this accurate attendance code should be how to write, please master??
CodePudding user response:
The rules should be define your own company to work overtime, and then you according to company rules: calculate last month or this month, and statisticsCodePudding user response:
Not very understand, is that on the class?Time - 31-1
White
The
Night
CodePudding user response:
Not very understand, is that on the class?Time - 31-1-2
D e a
in the morningWhite
In the e b
CodePudding user response:
A YiBingDing e everyone, from 8:00 toTwo days at 8:00 am, 24 hours, including 18:00-24:00 middle shift, 24:00 to work the night shift the morning the next day, because the middle shift and night shift have overtime pay, so only statistical number, middle shift and night shift on the day shift, not, armour YiBingDing e in order to work by turns
CodePudding user response:
You have already know the rules, should be dealt with well ah, is a separate deal with the issue of who is the last day of work last month.If the current processing is 201901, according to 201901 is calculated on January 201812, and then according to the 201812 get
Is the last day of 2018-12-31, and then according to this date to attendance table query who is out of work,
CodePudding user response:
Suggest set shift work time and work time, two fields,By date cycle, as long as the person's work time, XX XXXX, 20 points, will record a student in class XX XXXX on day 1 point, record the night shift,
CodePudding user response:
24:00-8:00 is 00:00-08:00, it is the day, it's not a special processing