| | |
|---|
| | | CONCAT(d.shift_name, '(', d.start_time, '-', d.end_time, ')') as shiftName, |
|---|
| | | DATE_FORMAT(a.clock_in_time, '%Y-%m-%d %H:%i') as clockInTime, |
|---|
| | | DATE_FORMAT(a.clock_out_time, '%Y-%m-%d %H:%i') as clockOutTime, |
|---|
| | | CASE WHEN a.clock_in_result = 1 THEN '正常' WHEN a.clock_in_result = 2 THEN '迟到' ELSE '缺卡' END as clockInResult, |
|---|
| | | CASE WHEN a.clock_out_result = 1 THEN '正常' WHEN a.clock_out_result = 2 THEN '早退' ELSE '缺卡' END as clockOutResult, |
|---|
| | | CASE WHEN a.clock_in_result = 1 THEN '正常' WHEN a.clock_in_result = 2 THEN '迟到' WHEN a.clock_in_result = 3 THEN '缺卡' ELSE '' END as clockInResult, |
|---|
| | | CASE WHEN a.clock_out_result = 1 THEN '正常' WHEN a.clock_out_result = 2 THEN '早退' WHEN a.clock_out_result = 3 THEN '缺卡' ELSE '' END as clockOutResult, |
|---|
| | | a.clock_in_address as clockInLocation |
|---|
| | | from xp_clock_in a |
|---|
| | | left join xp_fleet_operations b on (a.app_user_id = b.operations_user_id) |
|---|
