abcd.ini

考勤系统,智能判断刷卡异常,是一大型ERP系统的一个分支

[a]
b=insert into  wkrslt2(dptname,emplyid,emplyname,正常天,异常天,休息天,休日加班天,出差天,请假天,迟到次,迟到分,早退次,早退分,实际工时,标准工时,在岗工时,平时加班,休日加班,请假工时) select dptname as 部门,emplyid as 工号,emplyname as 姓名,sum(case when wktmrslt_flag=7 then 1 else 0 end) as 正常天,sum(case when wktmrslt_flag=1 then 1 else 0 end) as 异常天,sum(case when wktmrslt_flag=4 or wktmrslt_flag=5 then 1 else 0 end) as 休息天,sum(case when wktmrslt_flag=9 then 1 else 0 end) as 休日加班天,sum(case when wktmrslt_flag=3 then 1 else 0 end) as 出差天,sum(case when wktmrslt_flag=2 then 1 else 0 end) as 请假天,sum(case when latertime1+latertime2>0 then  1 else 0 end) as 迟到次,sum(latertime1+latertime2) as 迟到分,sum(case when earlytime1+earlytime2>0 then  1 else 0 end) as 早退次,sum(earlytime1+earlytime2) as 早退分,sum(datwktm) as 实际工时,sum(standwktm) as 标准工时,sum(workwktm) as 在岗工时,sum(overwktm) as 平时加班工时,sum(sunwktm) as 休日加班工时,sum(holidaysum) as 请假工时  from wktmrslt  where caldate between '2005-05-01' and '2005-05-31'  group by dptname,emplyid,emplyname