FXApp/ws_objects/app_cust_fx.pbl.src/dw_rp_attendance_3.srd

$PBExportHeader$dw_rp_attendance_3.srd
release 11.5;
datawindow(units=0 timer_interval=0 color=1073741824 brushmode=0 transparency=0 gradient.angle=0 gradient.color=8421504 gradient.focus=0 gradient.repetition.count=0 gradient.repetition.length=100 gradient.repetition.mode=0 gradient.scale=100 gradient.spread=100 gradient.transparency=0 picture.blur=0 picture.clip.bottom=0 picture.clip.left=0 picture.clip.right=0 picture.clip.top=0 picture.mode=0 picture.scale.x=100 picture.scale.y=100 picture.transparency=0 processing=4 HTMLDW=no print.printername="" print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96 print.paper.source = 0 print.paper.size = 0 print.canusedefaultprinter=yes print.prompt=no print.buttons=no print.preview.buttons=no print.cliptext=no print.overrideprintjob=no print.collate=yes print.background=no print.preview.background=no print.preview.outline=yes hidegrayline=no showbackcoloronxp=no picture.file=""  crosstab.dynamic = yes grid.lines=0 grid.columnmove=no selected.mouse=no )
header[1](height=232 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
header[2](height=72 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
summary(height=0 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
footer(height=0 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
detail(height=76 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
table(column=(type=char(20) updatewhereclause=yes name=scname dbname="scname" )
 column=(type=char(20) updatewhereclause=yes name=departmentname dbname="departmentname" )
 column=(type=char(20) updatewhereclause=yes name=cardcode dbname="cardcode" )
 column=(type=char(20) updatewhereclause=yes name=empcode dbname="empcode" )
 column=(type=char(20) updatewhereclause=yes name=empname dbname="empname" )
 column=(type=char(20) updatewhereclause=yes name=duty dbname="duty" )
 column=(type=number updatewhereclause=yes name=rownum dbname="rownum" )
 column=(type=char(20) updatewhereclause=yes name=startdate dbname="startdate" )
 retrieve="select  (
SELECT COUNT(1) AS rowcnt
          FROM (
SELECT u_scdef.scname as scname,cw_department.handtype as departmentname,
	u_attendance.cardcode,
	u_attendance.empcode,
	u_attendance.empname,
	u_rs_empinfo.duty,
convert(char(10),u_attendance.starttime, 108) as starttime,
convert(char(10),u_attendance.starttime, 121) as startdate
	FROM u_attendance INNER join u_rs_empinfo on
	u_attendance.empid = u_rs_empinfo.empid INNER join cw_department on
	u_rs_empinfo.deptid = cw_department.departmentid INNER join u_scdef on
	u_rs_empinfo.scid = u_scdef.scid left outer join u_hand_att on
u_hand_att.handattid = u_attendance.handattid 
	WHERE ( (u_attendance.starttime >= :arg_fromtime
	AND   u_attendance.starttime <= :arg_endtime ) )
	AND  ( u_rs_empinfo.handtype LIKE :arg_handtype OR :arg_handtype = '' )
And ( ( u_rs_empinfo.empcode Like :arg_empcode OR :arg_empcode = '' )
or  ( u_rs_empinfo.empname Like :arg_empcode OR :arg_empcode = '' ))
	AND (u_rs_empinfo.status = :arg_empstatus OR :arg_empstatus = -1)

union all

SELECT   u_scdef.scname, cw_department.handtype AS departmentname,u_rs_empinfo.Cardcode, u_rs_empinfo.Empcode, 
      u_rs_empinfo.Empname, u_rs_empinfo.duty,
convert(char(10),DERIVEDTBL.checktime, 108) as starttime,
convert(char(10),DERIVEDTBL.checktime, 121) as startdate
FROM (SELECT u_kq_cworkmx.begindate AS checktime, u_kq_cworkmx.empid, 
              u_kq_cwork.billcode, u_gz_cworkitem.itemtype
        FROM u_kq_cworkmx INNER JOIN
              u_kq_cwork ON u_kq_cworkmx.billid = u_kq_cwork.billid INNER JOIN
              u_gz_cworkitem ON u_kq_cwork.cworkid = u_gz_cworkitem.cworkid
        WHERE ((u_gz_cworkitem.itemtype = 10) OR
              (u_gz_cworkitem.itemtype = 13)) and 
					u_kq_cwork.priceflag =  1

        UNION ALL

        SELECT u_kq_cworkmx.enddate AS checktime, u_kq_cworkmx.empid, 
              u_kq_cwork.billcode, u_gz_cworkitem.itemtype
        FROM u_kq_cworkmx INNER JOIN
              u_kq_cwork ON u_kq_cworkmx.billid = u_kq_cwork.billid INNER JOIN
              u_gz_cworkitem ON u_kq_cwork.cworkid = u_gz_cworkitem.cworkid
        WHERE ((u_gz_cworkitem.itemtype = 10) OR
              (u_gz_cworkitem.itemtype = 13)) and 
				u_kq_cwork.priceflag =  1 ) DERIVEDTBL INNER JOIN
      u_rs_empinfo ON DERIVEDTBL.empid = u_rs_empinfo.empid INNER JOIN
      cw_department ON u_rs_empinfo.Deptid = cw_department.departmentid INNER JOIN
      u_scdef ON u_rs_empinfo.scid = u_scdef.ScID
	WHERE ( (DERIVEDTBL.checktime >= :arg_fromtime
	AND   DERIVEDTBL.checktime <= :arg_endtime ) )
	AND  ( u_rs_empinfo.handtype LIKE :arg_handtype OR :arg_handtype = '' )
And ( ( u_rs_empinfo.empcode Like :arg_empcode OR :arg_empcode = '' )
or  ( u_rs_empinfo.empname Like :arg_empcode OR :arg_empcode = '' ))
	AND (u_rs_empinfo.status = :arg_empstatus OR :arg_empstatus = -1)


	UNION ALL
	SELECT '' as scname ,
	'' as departmentname ,
	u_attendance.cardcode,
	u_attendance.empcode,
	u_attendance.empname,
	'' as  duty,
convert(char(10),u_attendance.starttime, 108) as starttime,
convert(char(10),u_attendance.starttime, 121) as startdate
	FROM u_attendance
	WHERE ( u_attendance.starttime >= :arg_fromtime )
	AND  ( u_attendance.starttime <= :arg_endtime )
	AND  ( u_attendance.empid = 0 ) and (:arg_handtype = '' or :arg_handtype = '%')
) t2
          WHERE t2.scname = t1.scname 
AND t2.departmentname = t1.departmentname 
AND t2.cardcode = t1.cardcode 
AND t2.empcode = t1.empcode 
AND t2.empname = t1.empname 
AND t2.duty = t1.duty 
AND t2.startdate = t1.startdate 
AND t2.starttime <= t1.starttime
) as rownum, 
t1.scname, t1.departmentname, t1.cardcode, t1.empcode, t1.empname, t1.duty, t1.starttime, t1.startdate

from (
SELECT u_scdef.scname as scname,cw_department.handtype as departmentname,
	u_attendance.cardcode,
	u_attendance.empcode,
	u_attendance.empname,
	u_rs_empinfo.duty,
convert(char(10),u_attendance.starttime, 108) as starttime,
convert(char(10),u_attendance.starttime, 121) as startdate
	FROM u_attendance INNER join u_rs_empinfo on
	u_attendance.empid = u_rs_empinfo.empid INNER join cw_department on
	u_rs_empinfo.deptid = cw_department.departmentid INNER join u_scdef on
	u_rs_empinfo.scid = u_scdef.scid left outer join u_hand_att on
u_hand_att.handattid = u_attendance.handattid 
	WHERE ( (u_attendance.starttime >= :arg_fromtime
	AND   u_attendance.starttime <= :arg_endtime ) )
	AND  ( u_rs_empinfo.handtype LIKE :arg_handtype OR :arg_handtype = '' )
And ( ( u_rs_empinfo.empcode Like :arg_empcode OR :arg_empcode = '' )
or  ( u_rs_empinfo.empname Like :arg_empcode OR :arg_empcode = '' ))
	AND (u_rs_empinfo.status = :arg_empstatus OR :arg_empstatus = -1)

union all

SELECT   u_scdef.scname, cw_department.handtype AS departmentname,u_rs_empinfo.Cardcode, u_rs_empinfo.Empcode, 
      u_rs_empinfo.Empname, u_rs_empinfo.duty,
convert(char(10),DERIVEDTBL.checktime, 108) as starttime,
convert(char(10),DERIVEDTBL.checktime, 121) as startdate
FROM (SELECT u_kq_cworkmx.begindate AS checktime, u_kq_cworkmx.empid, 
              u_kq_cwork.billcode, u_gz_cworkitem.itemtype
        FROM u_kq_cworkmx INNER JOIN
              u_kq_cwork ON u_kq_cworkmx.billid = u_kq_cwork.billid INNER JOIN
              u_gz_cworkitem ON u_kq_cwork.cworkid = u_gz_cworkitem.cworkid
        WHERE ((u_gz_cworkitem.itemtype = 10) OR
              (u_gz_cworkitem.itemtype = 13)) and 
					u_kq_cwork.priceflag =  1

        UNION ALL

        SELECT u_kq_cworkmx.enddate AS checktime, u_kq_cworkmx.empid, 
              u_kq_cwork.billcode, u_gz_cworkitem.itemtype
        FROM u_kq_cworkmx INNER JOIN
              u_kq_cwork ON u_kq_cworkmx.billid = u_kq_cwork.billid INNER JOIN
              u_gz_cworkitem ON u_kq_cwork.cworkid = u_gz_cworkitem.cworkid
        WHERE ((u_gz_cworkitem.itemtype = 10) OR
              (u_gz_cworkitem.itemtype = 13)) and 
				u_kq_cwork.priceflag =  1 ) DERIVEDTBL INNER JOIN
      u_rs_empinfo ON DERIVEDTBL.empid = u_rs_empinfo.empid INNER JOIN
      cw_department ON u_rs_empinfo.Deptid = cw_department.departmentid INNER JOIN
      u_scdef ON u_rs_empinfo.scid = u_scdef.ScID
	WHERE ( (DERIVEDTBL.checktime >= :arg_fromtime
	AND   DERIVEDTBL.checktime <= :arg_endtime ) )
	AND  ( u_rs_empinfo.handtype LIKE :arg_handtype OR :arg_handtype = '' )
And ( ( u_rs_empinfo.empcode Like :arg_empcode OR :arg_empcode = '' )
or  ( u_rs_empinfo.empname Like :arg_empcode OR :arg_empcode = '' ))
	AND (u_rs_empinfo.status = :arg_empstatus OR :arg_empstatus = -1)


	UNION ALL
	SELECT '' as scname ,
	'' as departmentname ,
	u_attendance.cardcode,
	u_attendance.empcode,
	u_attendance.empname,
	'' as  duty,

convert(char(10),u_attendance.starttime, 108) as starttime,
convert(char(10),u_attendance.starttime, 121) as startdate
	FROM u_attendance
	WHERE ( u_attendance.starttime >= :arg_fromtime )
	AND  ( u_attendance.starttime <= :arg_endtime )
	AND  ( u_attendance.empid = 0 ) and (:arg_handtype = '' or :arg_handtype = '%')

)  t1
	
" arguments=(("arg_fromtime", datetime),("arg_endtime", datetime),("arg_handtype", string),("arg_empstatus", number),("arg_empcode", string))  sort="scname A departmentname A cardcode A empcode A empname A duty A rownum A " )
text(band=header[2] alignment="2" text="@startdate" border="2" color="0" x="3159" y="4" height="88" width="439" html.valueishtml="0"  name=startdate_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header[2] alignment="2" text="分部" border="2" color="0" x="9" y="4" height="88" width="457" html.valueishtml="0"  name=scname_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header[2] alignment="2" text="部门" border="2" color="0" x="475" y="4" height="88" width="457" html.valueishtml="0"  name=departmentname_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header[2] alignment="2" text="卡号" border="2" color="0" x="942" y="4" height="88" width="457" html.valueishtml="0"  name=cardcode_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header[2] alignment="2" text="工号" border="2" color="0" x="1408" y="4" height="88" width="457" html.valueishtml="0"  name=empcode_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header[2] alignment="2" text="姓名" border="2" color="0" x="1874" y="4" height="88" width="457" html.valueishtml="0"  name=empname_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header[2] alignment="2" text="职位" border="2" color="0" x="2341" y="4" height="88" width="457" html.valueishtml="0"  name=duty_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header[2] alignment="2" text="序号" border="2" color="0" x="2807" y="4" height="88" width="343" html.valueishtml="0"  name=rownum_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=1 alignment="0" tabsequence=32766 border="0" color="33554432" x="9" y="4" height="68" width="457" format="[general]" html.valueishtml="0"  name=scname visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=2 alignment="0" tabsequence=32766 border="0" color="33554432" x="475" y="4" height="68" width="457" format="[general]" html.valueishtml="0"  name=departmentname visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=3 alignment="0" tabsequence=32766 border="0" color="33554432" x="942" y="4" height="68" width="457" format="[general]" html.valueishtml="0"  name=cardcode visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=4 alignment="0" tabsequence=32766 border="0" color="33554432" x="1408" y="4" height="68" width="457" format="[general]" html.valueishtml="0"  name=empcode visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=5 alignment="0" tabsequence=32766 border="0" color="33554432" x="1874" y="4" height="68" width="457" format="[general]" html.valueishtml="0"  name=empname visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=6 alignment="0" tabsequence=32766 border="0" color="33554432" x="2341" y="4" height="68" width="457" format="[general]" html.valueishtml="0"  name=duty visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=7 alignment="1" tabsequence=32766 border="0" color="33554432" x="2807" y="4" height="68" width="343" format="[general]" html.valueishtml="0"  name=rownum visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=8 alignment="2" tabsequence=32766 border="0" color="33554432" x="3159" y="4" height="68" width="439" format="[general]" html.valueishtml="0"  name=startdate visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.autohscroll=yes crosstab.repeat=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=foreground alignment="0" text="打卡明细表" border="0" color="33554432" x="0" y="4" height="236" width="2455" html.valueishtml="0"  name=t_2 visible="1"  font.face="宋体" font.height="-22" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
compute(band=foreground alignment="0" expression="~"日期:~"+string( arg_fromtime,~"YYYY-MM-DD~" )+~"至~"+string(arg_endtime,~"yyyy-mm-dd~")  +'  打印日期: '+string(today(),'yyyy-mm-dd')+' 共 '+string(pageCount())+' 页/第 ' + string(page()) + ' 页'"border="0" color="33554432" x="5" y="164" height="76" width="2446" format="[GENERAL]" html.valueishtml="0"  name=compute_1 visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
 crosstab(band = foreground  crosstabonly = yes 
 columns = "startdate" rows = "scname, departmentname, cardcode, empcode, empname, duty, rownum" values = "starttime" sourcenames = "rownum, scname, departmentname, cardcode, empcode, empname, duty, starttime, startdate")
sparse(names="scname	departmentname	cardcode	empcode	empname	duty")htmltable(border="0" cellpadding="1" cellspacing="1" )
htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" pagingmethod=0 generatedddwframes="1" )
xhtmlgen() cssgen(sessionspecific="0" )
xmlgen(inline="0" )
xsltgen()
jsgen()
export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0  template=(comment="" encoding="UTF-16LE" name="l1v2" xml="<?xml version=~"1.0~" encoding=~"UTF-16LE~" standalone=~"no~"?><dw_rp_attendance_3><dw_rp_attendance_3_row __pbband=~"detail~"><u_scdef_scname/><cw_department_departmentname/><u_attendance_cardcode/><u_attendance_empcode/><u_attendance_empname/><u_rs_empinfo_duty/><u_attendance_dscrp/><u_attendance_starttime/></dw_rp_attendance_3_row></dw_rp_attendance_3>"))
import.xml()
export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )
export.xhtml()