ATS考勤2.21考勤计算（出差单明细）

--建表脚本--

create table T_ATS_TRIPDETAILS(

FENTRYID int not null  comment '分录主键'

,FID int not null  comment '出差单id'

,FDATE datetime default null  comment '考勤日期'

,FDETAILSSTARTTIME datetime default null  comment '开始时间'

,FDETAILSENDTIME datetime default null  comment '结束时间'

,FSHIFTID int default null  comment '班次id'

,FTIMELAG decimal(19,6) default null  comment '时长'

,FISDETAILSWHOLEDAY char(1) default null  comment '是否整天'

,FDATELAG decimal(19,6) default null  comment '天数'

,FPERSONID int default null  comment '人员id'

,FREALDETAILSSTARTTIME datetime default null  comment '实际开始时间'

,FREALDETAILSENDTIME datetime default null  comment '实际结束时间'

,primary key (FENTRYID)

) comment = '出差单明细'

--查询--

select FENTRYID as "fentryid",FID as "fid",FDATE as "fdate",FDETAILSSTARTTIME as "fdetailsstarttime",FDETAILSENDTIME as "fdetailsendtime",FSHIFTID as "fshiftid",FTIMELAG as "ftimelag",FISDETAILSWHOLEDAY as "fisdetailswholeday",FDATELAG as "fdatelag",FPERSONID as "fpersonid",FREALDETAILSSTARTTIME as "frealdetailsstarttime",FREALDETAILSENDTIME as "frealdetailsendtime" from T_ATS_TRIPDETAILS

--查询(中文字段)--

select FENTRYID as "分录主键",FID as "出差单id",FDATE as "考勤日期",FDETAILSSTARTTIME as "开始时间",FDETAILSENDTIME as "结束时间",FSHIFTID as "班次id",FTIMELAG as "时长",FISDETAILSWHOLEDAY as "是否整天",FDATELAG as "天数",FPERSONID as "人员id",FREALDETAILSSTARTTIME as "实际开始时间",FREAL