dw_rp_gz_loanwage_mx.srd 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105
  1. $PBExportHeader$dw_rp_gz_loanwage_mx.srd
  2. release 9;
  3. datawindow(units=0 timer_interval=0 color=1073741824 processing=1 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 hidegrayline=no grid.lines=0 )
  4. header(height=288 color="536870912" )
  5. summary(height=64 color="536870912" )
  6. footer(height=0 color="536870912" )
  7. detail(height=76 color="536870912" )
  8. table(column=(type=long updatewhereclause=yes name=u_gz_loanwage_billid dbname="u_gz_loanwage.billid" initial="0" )
  9. column=(type=long updatewhereclause=yes name=u_gz_loanwage_wageid dbname="u_gz_loanwage.wageid" initial="0" )
  10. column=(type=char(30) updatewhereclause=yes name=u_rs_empinfo_empcode dbname="u_rs_empinfo.Empcode" initial="empty" )
  11. column=(type=datetime updatewhereclause=yes name=u_gz_loanwage_billdate dbname="u_gz_loanwage.billdate" initial="today" )
  12. column=(type=decimal(2) updatewhereclause=yes name=u_gz_loanwage_loanamt dbname="u_gz_loanwage.loanamt" initial="0" )
  13. column=(type=char(200) updatewhereclause=yes name=u_gz_loanwage_loanreason dbname="u_gz_loanwage.loanreason" initial="empty" )
  14. column=(type=char(30) updatewhereclause=yes name=u_gz_loanwage_cardcode dbname="u_gz_loanwage.cardcode" initial="empty" )
  15. column=(type=long updatewhereclause=yes name=u_gz_loanwage_returndate dbname="u_gz_loanwage.returndate" initial="0" )
  16. column=(type=char(255) updatewhereclause=yes name=u_gz_loanwage_dscrp dbname="u_gz_loanwage.dscrp" initial="empty" )
  17. column=(type=long updatewhereclause=yes name=u_gz_loanwage_empid dbname="u_gz_loanwage.empid" initial="0" )
  18. column=(type=char(20) updatewhereclause=yes name=u_gz_loanwage_billcode dbname="u_gz_loanwage.billcode" initial="empty" )
  19. column=(type=long updatewhereclause=yes name=u_gz_loanwage_wagemth dbname="u_gz_loanwage.wagemth" initial="0" )
  20. column=(type=datetime updatewhereclause=yes name=u_gz_loanwage_moddate dbname="u_gz_loanwage.moddate" )
  21. column=(type=char(10) updatewhereclause=yes name=u_gz_loanwage_modemp dbname="u_gz_loanwage.modemp" )
  22. column=(type=datetime updatewhereclause=yes name=u_gz_loanwage_auditdate dbname="u_gz_loanwage.auditdate" )
  23. column=(type=long updatewhereclause=yes name=u_gz_loanwage_flag dbname="u_gz_loanwage.flag" values=" 1/ 0" )
  24. column=(type=char(10) updatewhereclause=yes name=u_gz_loanwage_auditrep dbname="u_gz_loanwage.auditrep" )
  25. column=(type=char(10) updatewhereclause=yes name=u_gz_loanwage_opemp dbname="u_gz_loanwage.opemp" )
  26. column=(type=datetime updatewhereclause=yes name=u_gz_loanwage_opdate dbname="u_gz_loanwage.opdate" )
  27. column=(type=char(30) updatewhereclause=yes name=u_rs_empinfo_empname dbname="u_rs_empinfo.Empname" )
  28. column=(type=long updatewhereclause=yes name=u_gz_loanwage_printnum dbname="u_gz_loanwage.printnum" )
  29. retrieve=" SELECT u_gz_loanwage.billid,
  30. u_gz_loanwage.wageid,
  31. u_rs_empinfo.Empcode,
  32. u_gz_loanwage.billdate,
  33. u_gz_loanwage.loanamt,
  34. u_gz_loanwage.loanreason,
  35. u_gz_loanwage.cardcode,
  36. u_gz_loanwage.returndate,
  37. u_gz_loanwage.dscrp,
  38. u_gz_loanwage.empid,
  39. u_gz_loanwage.billcode,
  40. u_gz_loanwage.wagemth,
  41. u_gz_loanwage.moddate,
  42. u_gz_loanwage.modemp,
  43. u_gz_loanwage.auditdate,
  44. u_gz_loanwage.flag,
  45. u_gz_loanwage.auditrep,
  46. u_gz_loanwage.opemp,
  47. u_gz_loanwage.opdate,
  48. u_rs_empinfo.Empname,
  49. u_gz_loanwage.printnum
  50. FROM u_gz_loanwage,
  51. u_rs_empinfo
  52. WHERE ( u_gz_loanwage.empid = u_rs_empinfo.empid )
  53. and ( u_gz_loanwage.flag = :arg_flag or :arg_flag = -1 )
  54. AND
  55. ( u_gz_loanwage.billdate >= :first_date ) AND
  56. ( u_gz_loanwage.billdate <= :end_date )
  57. " arguments=(("first_date", datetime),("end_date", datetime),("arg_flag", number)) )
  58. text(band=header alignment="2" text="还款工资月份" border="2" color="33554432" x="3520" y="232" height="56" width="338" html.valueishtml="0" name=u_gz_loanwage_returndate_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  59. text(band=header alignment="2" text="批核" border="2" color="33554432" x="3867" y="232" height="56" width="571" html.valueishtml="0" name=u_gz_loanwage_dscrp_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  60. text(band=header alignment="2" text="工资月份" border="2" color="33554432" x="4448" y="232" height="56" width="251" html.valueishtml="0" name=u_gz_loanwage_wagemth_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  61. text(band=header alignment="2" text="修改日期" border="2" color="33554432" x="6469" y="232" height="56" width="517" html.valueishtml="0" name=u_gz_loanwage_moddate_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  62. text(band=header alignment="2" text="审核日期" border="2" color="33554432" x="5943" y="232" height="56" width="517" html.valueishtml="0" name=u_gz_loanwage_auditdate_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  63. text(band=header alignment="2" text="审核" border="2" color="33554432" x="5490" y="232" height="56" width="142" html.valueishtml="0" name=u_gz_loanwage_flag_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  64. text(band=header alignment="2" text="审核人" border="2" color="33554432" x="5641" y="232" height="56" width="293" html.valueishtml="0" name=u_gz_loanwage_auditrep_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  65. text(band=header alignment="2" text="建立时间" border="2" color="33554432" x="4965" y="232" height="56" width="517" html.valueishtml="0" name=u_gz_loanwage_opdate_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  66. text(band=header alignment="2" text="建立人" border="2" color="33554432" x="4709" y="232" height="56" width="247" html.valueishtml="0" name=u_gz_loanwage_opemp_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  67. text(band=header alignment="2" text="工资项目" border="2" color="33554432" x="1733" y="232" height="56" width="466" html.valueishtml="0" name=u_gz_loanwage_wageid_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  68. text(band=header alignment="2" text="人员号" border="2" color="33554432" x="475" y="232" height="56" width="302" html.valueishtml="0" name=u_rs_empinfo_empcode_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  69. text(band=header alignment="2" text="日期" border="2" color="33554432" x="1394" y="232" height="56" width="329" html.valueishtml="0" name=u_gz_loanwage_billdate_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  70. text(band=header alignment="2" text="借款金额" border="2" color="33554432" x="1051" y="232" height="56" width="334" html.valueishtml="0" name=u_gz_loanwage_loanamt_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  71. text(band=header alignment="2" text="借款原因" border="2" color="33554432" x="2208" y="232" height="56" width="690" html.valueishtml="0" name=u_gz_loanwage_loanreason_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  72. text(band=header alignment="2" text="证件" border="2" color="33554432" x="2907" y="232" height="56" width="603" html.valueishtml="0" name=u_gz_loanwage_cardcode_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  73. text(band=header alignment="2" text="人员姓名" border="2" color="33554432" x="786" y="232" height="56" width="256" html.valueishtml="0" name=u_rs_empinfo_empname_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  74. text(band=header alignment="2" text="修改人" border="2" color="33554432" x="6994" y="232" height="56" width="261" html.valueishtml="0" name=u_gz_loanwage_modemp_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" )
  75. text(band=header alignment="2" text="单据编号" border="2" color="33554432" x="123" y="232" height="56" width="343" html.valueishtml="0" name=u_gz_loanwage_billcode_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  76. text(band=header alignment="2" text="序" border="2" color="33554432" x="9" y="232" height="56" width="105" html.valueishtml="0" name=t_1 visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
  77. column(band=detail id=2 alignment="1" tabsequence=32766 border="0" color="33554432" x="1733" y="4" height="68" width="466" format="[general]" html.valueishtml="0" name=u_gz_loanwage_wageid visible="1" dddw.name=dddw_wageitem_21 dddw.displaycolumn=wagename dddw.datacolumn=wageid dddw.percentwidth=0 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any dddw.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  78. column(band=detail id=3 alignment="0" tabsequence=32766 border="0" color="33554432" x="475" y="4" height="68" width="302" format="[general]" html.valueishtml="0" name=u_rs_empinfo_empcode visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  79. column(band=detail id=4 alignment="2" tabsequence=32766 border="0" color="33554432" x="1394" y="4" height="68" width="329" format="yyyy-mm-dd" html.valueishtml="0" name=u_gz_loanwage_billdate visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  80. column(band=detail id=5 alignment="1" tabsequence=32766 border="0" color="33554432" x="1051" y="4" height="68" width="334" format="#,##0.00" html.valueishtml="0" name=u_gz_loanwage_loanamt visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  81. column(band=detail id=6 alignment="0" tabsequence=32766 border="0" color="33554432" x="2208" y="4" height="68" width="690" format="[general]" html.valueishtml="0" name=u_gz_loanwage_loanreason visible="1" edit.limit=200 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  82. column(band=detail id=7 alignment="0" tabsequence=32766 border="0" color="33554432" x="2907" y="4" height="68" width="603" format="[general]" html.valueishtml="0" name=u_gz_loanwage_cardcode visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  83. column(band=detail id=8 alignment="2" tabsequence=32766 border="0" color="33554432" x="3520" y="4" height="68" width="338" format="[general]" html.valueishtml="0" name=u_gz_loanwage_returndate visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  84. column(band=detail id=9 alignment="0" tabsequence=32766 border="0" color="33554432" x="3867" y="4" height="68" width="571" format="[general]" html.valueishtml="0" name=u_gz_loanwage_dscrp visible="1" edit.limit=200 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  85. column(band=detail id=12 alignment="2" tabsequence=32766 border="0" color="33554432" x="4448" y="4" height="68" width="251" format="[general]" html.valueishtml="0" name=u_gz_loanwage_wagemth visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  86. column(band=detail id=13 alignment="0" tabsequence=32766 border="0" color="33554432" x="6469" y="4" height="68" width="517" format="yyyy-mm-dd hh:mm" html.valueishtml="0" name=u_gz_loanwage_moddate visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  87. column(band=detail id=14 alignment="0" tabsequence=32766 border="0" color="33554432" x="6994" y="4" height="68" width="261" format="[general]" html.valueishtml="0" name=u_gz_loanwage_modemp visible="1" edit.limit=10 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  88. column(band=detail id=15 alignment="0" tabsequence=32766 border="0" color="33554432" x="5943" y="4" height="68" width="517" format="yyyy-mm-dd hh:mm" html.valueishtml="0" name=u_gz_loanwage_auditdate visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  89. column(band=detail id=16 alignment="2" tabsequence=32766 border="0" color="33554432" x="5490" y="4" height="68" width="142" format="[general]" html.valueishtml="0" name=u_gz_loanwage_flag visible="1" checkbox.text="" checkbox.on="1" checkbox.off="0" checkbox.scale=no checkbox.threed=yes font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  90. column(band=detail id=17 alignment="0" tabsequence=32766 border="0" color="33554432" x="5641" y="4" height="68" width="293" format="[general]" html.valueishtml="0" name=u_gz_loanwage_auditrep visible="1" edit.limit=10 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  91. column(band=detail id=19 alignment="0" tabsequence=32766 border="0" color="33554432" x="4965" y="4" height="68" width="517" format="yyyy-mm-dd hh:mm" html.valueishtml="0" name=u_gz_loanwage_opdate visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  92. column(band=detail id=18 alignment="0" tabsequence=32766 border="0" color="33554432" x="4709" y="4" height="68" width="247" format="[general]" html.valueishtml="0" name=u_gz_loanwage_opemp visible="1" edit.limit=10 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  93. column(band=detail id=20 alignment="0" tabsequence=32766 border="0" color="33554432" x="786" y="4" height="68" width="256" format="[general]" html.valueishtml="0" name=u_rs_empinfo_empname visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  94. column(band=detail id=11 alignment="0" tabsequence=32766 border="0" color="33554432" x="123" y="4" height="68" width="343" format="[general]" html.valueishtml="0" name=u_gz_loanwage_billcode visible="1" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  95. compute(band=detail alignment="2" expression="getrow()"border="0" color="33554432" x="9" y="4" height="68" width="105" format="[GENERAL]" html.valueishtml="0" name=compute_4 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" )
  96. compute(band=summary alignment="2" expression="count(u_gz_loanwage_billcode for all)"border="0" color="33554432" x="123" y="4" height="56" width="343" 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="1" background.color="536870912" )
  97. compute(band=summary alignment="1" expression="sum(u_gz_loanwage_loanamt for all)"border="0" color="33554432" x="1051" y="4" height="56" width="334" format="#,##0.00" html.valueishtml="0" name=compute_2 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  98. text(band=foreground alignment="0" text="" border="0" color="0" x="0" y="0" height="224" width="7287" html.valueishtml="0" name=t_3 visible="1" moveable=1 font.face="宋体" font.height="-20" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="33554431" )
  99. text(band=foreground alignment="0" text="借支单明细表" border="0" color="0" x="9" y="8" height="124" width="4384" html.valueishtml="0" name=title visible="1" moveable=1 font.face="宋体" font.height="-20" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="33554431" )
  100. compute(band=foreground alignment="2" expression="'借支日期:'+string( first_date ,'yy-mm-dd') +'~~~~'+string(end_date ,'yy-mm-dd') +' 打印日期: '+string(today(),'yyyy-mm-dd')+' 共 '+string(pageCount())+' 页 第 ' + string(page()) + ' 页' "border="0" color="33554432" x="5" y="148" height="56" width="1655" format="[General]" html.valueishtml="0" name=compute_3 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" )
  101. htmltable(border="1" )
  102. htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" )
  103. export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
  104. import.xml()
  105. export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )