作者官方网站:http://www.wxl568.cn
select l.empCode "工号",
l.empName "姓名",
l.orgName "组织名称",
l.posname "职位名称",
date_format(l.clockTime,'%Y-%m-%d') "打卡日期",
date_format(l.clockTime,'%H:%i:%S') "打卡时间",
CASE l.RESERVE3 WHEN 100 THEN "开心"
WHEN 200 THEN "一般"
WHEN 300 THEN "不开心"
ELSE "未开放" END
as "情绪",
l.addressName "考勤点名称",
l.outsideClockAddress "外勤地址",
l.macAddress "MAC网卡",
l.clVersion "版本号"
from tt_big_clock_log_data l