Головна сторінка Огляд Довідка
Увійти
Neil
/
Q5
1
0
Відгалуження 0
Файли Проблеми 0 Запити на злиття 0 Wiki
Дерево: ef56296430
Гілки Теги
Q5
/
ws_objects
/
Ew_money.pbl.src
/
dw_rp_money_scidsum.srd

dw_rp_money_scidsum.srd 18 KB
Історія Запис

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293 
  1. $PBExportHeader$dw_rp_money_scidsum.srd
    2. 

  2. release 9;
    3. 

  3. datawindow(units=0 timer_interval=60000 color=1073741824 processing=1 HTMLDW=no print.printername="" print.documentname="" print.orientation = 2 print.margin.left = 110 print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96 print.paper.source = 0 print.paper.size = 9 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 selected.mouse=no )
    4. 

  4. header(height=316 color="536870912" )
    5. 

  5. summary(height=80 color="536870912" )
    6. 

  6. footer(height=0 color="536870912" )
    7. 

  7. detail(height=84 color="536870912" )
    8. 

  8. table(column=(type=decimal(15) updatewhereclause=yes name=saleamt dbname="saleamt" )
    9. 

  9.  column=(type=decimal(2) updatewhereclause=yes name=costamt dbname="costamt" )
    10. 

  10.  column=(type=decimal(2) updatewhereclause=yes name=gpamt dbname="gpamt" )
    11. 

  11.  column=(type=long updatewhereclause=yes name=u_outwaremx_scid dbname="u_outwaremx.scid" )
    12. 

  12.  column=(type=char(30) updatewhereclause=yes name=u_scdef_scname dbname="u_scdef.scname" )
    13. 

  13.  column=(type=decimal(2) updatewhereclause=yes name=item1 dbname="item1" )
    14. 

  14.  column=(type=decimal(2) updatewhereclause=yes name=item2 dbname="item2" )
    15. 

  15.  column=(type=decimal(2) updatewhereclause=yes name=item3 dbname="item3" )
    16. 

  16.  column=(type=decimal(2) updatewhereclause=yes name=item4 dbname="item4" )
    17. 

  17.  column=(type=decimal(2) updatewhereclause=yes name=item5 dbname="item5" )
    18. 

  18.  column=(type=decimal(2) updatewhereclause=yes name=item6 dbname="item6" )
    19. 

  19.  column=(type=decimal(2) updatewhereclause=yes name=item7 dbname="item7" )
    20. 

  20.  column=(type=decimal(2) updatewhereclause=yes name=item8 dbname="item8" )
    21. 

  21.  column=(type=decimal(2) updatewhereclause=yes name=item9 dbname="item9" )
    22. 

  22.  column=(type=decimal(2) updatewhereclause=yes name=item10 dbname="item10" )
    23. 

  23.  retrieve="SELECT SUM(ROUND(u_outwaremx.uqty * u_outwaremx.price, 2)) AS saleamt, 
    24. 

  24.       SUM(u_outwaremx.costamt) AS costamt,
    25. 

  25. 		SUM(ROUND(u_outwaremx.uqty * u_outwaremx.price, 2)) - SUM(u_outwaremx.costamt) as gpamt,
    26. 

  26.  		u_outwaremx.scid, 
    27. 

  27. 		u_scdef.scname,
    28. 

  28. 		0.00 as item1,
    29. 

  29. 		0.00 as item2,
    30. 

  30. 		0.00 as item3,
    31. 

  31. 		0.00 as item4,
    32. 

  32. 		0.00 as item5,
    33. 

  33. 		0.00 as item6,
    34. 

  34. 		0.00 as item7,
    35. 

  35. 		0.00 as item8,
    36. 

  36. 		0.00 as item9,
    37. 

  37. 		0.00 as item10
    38. 

  38. FROM u_outwaremx INNER JOIN
    39. 

  39.       u_outware ON u_outwaremx.scid = u_outware.scid AND 
    40. 

  40.       u_outwaremx.outwareid = u_outware.outwareid inner join u_scdef
    41. 

  41. 	on u_outware.scid = u_scdef.scid
    42. 

  42. WHERE (u_outware.flag = 1)
    43. 

  43. 	and (u_outware.outdate between :arg_firstdate and :arg_enddate)
    44. 

  44. 	and u_outware.scid in (:arg_scid)
    45. 

  45. GROUP BY u_outwaremx.scid, u_scdef.scname
    46. 

  46. 

  47. " arguments=(("arg_firstdate", datetime),("arg_enddate", datetime),("arg_scid", numberlist)) )
    48. 

  48. column(band=detail id=5 alignment="0" tabsequence=32766 border="0" color="33554432" x="9" y="0" height="76" width="411" format="[general]" html.valueishtml="0"  name=u_scdef_scname visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
    49. 

  49. column(band=detail id=1 alignment="1" tabsequence=32766 border="0" color="33554432" x="430" y="0" height="76" width="430" format="#,##0.00" html.valueishtml="0"  name=saleamt visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
    50. 

  50. compute(band=summary alignment="1" expression="sum(costamt for all)"border="0" color="33554432" x="869" y="4" height="56" width="425" format="#,##0.00" 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" )
    51. 

  51. compute(band=summary alignment="1" expression="sum(gpamt for all)"border="0" color="33554432" x="1303" y="4" height="56" width="421" 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="2" background.color="1073741824" )
    52. 

  52. compute(band=summary alignment="1" expression="sum(item1 for all)"border="0" color="33554432" x="1733" y="4" height="56" width="430" format="#,##0.00" html.valueishtml="0"  name=compute_3 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" )
    53. 

  53. compute(band=summary alignment="1" expression="sum(item2 for all)"border="0" color="33554432" x="2171" y="4" height="56" width="416" format="#,##0.00" 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" )
    54. 

  54. compute(band=summary alignment="1" expression="sum(item3 for all)"border="0" color="33554432" x="2597" y="4" height="56" width="430" format="#,##0.00" html.valueishtml="0"  name=compute_5 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" )
    55. 

  55. compute(band=summary alignment="1" expression="sum(item4 for all)"border="0" color="33554432" x="3035" y="4" height="56" width="421" format="#,##0.00" html.valueishtml="0"  name=compute_6 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" )
    56. 

  56. compute(band=summary alignment="1" expression="sum(item5 for all)"border="0" color="33554432" x="3465" y="4" height="56" width="425" format="#,##0.00" html.valueishtml="0"  name=compute_7 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" )
    57. 

  57. compute(band=summary alignment="1" expression="sum(item6 for all)"border="0" color="33554432" x="3899" y="4" height="56" width="416" format="#,##0.00" html.valueishtml="0"  name=compute_8 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" )
    58. 

  58. compute(band=summary alignment="1" expression="sum(item7 for all)"border="0" color="33554432" x="4325" y="4" height="56" width="434" format="#,##0.00" html.valueishtml="0"  name=compute_9 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" )
    59. 

  59. compute(band=summary alignment="1" expression="sum(item8 for all)"border="0" color="33554432" x="4768" y="4" height="56" width="416" format="#,##0.00" html.valueishtml="0"  name=compute_10 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" )
    60. 

  60. compute(band=summary alignment="1" expression="sum(item9 for all)"border="0" color="33554432" x="5193" y="4" height="56" width="430" format="#,##0.00" html.valueishtml="0"  name=compute_11 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" )
    61. 

  61. compute(band=summary alignment="1" expression="sum(item10 for all)"border="0" color="33554432" x="5632" y="4" height="56" width="421" format="#,##0.00" html.valueishtml="0"  name=compute_12 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" )
    62. 

  62. column(band=detail id=2 alignment="1" tabsequence=32766 border="0" color="33554432" x="869" y="0" height="76" width="425" format="#,##0.00" html.valueishtml="0"  name=costamt visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
    63. 

  63. column(band=detail id=3 alignment="1" tabsequence=0 border="0" color="33554432" x="1307" y="0" height="76" width="416" format="#,##0.00" html.valueishtml="0"  name=gpamt visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
    64. 

  64. column(band=detail id=6 alignment="1" tabsequence=0 border="0" color="33554432" x="1737" y="0" height="76" width="425" format="#,##0.00" html.valueishtml="0"  name=item1 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
    65. 

  65. column(band=detail id=7 alignment="1" tabsequence=0 border="0" color="33554432" x="2176" y="0" height="76" width="411" format="#,##0.00" html.valueishtml="0"  name=item2 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
    66. 

  66. column(band=detail id=8 alignment="1" tabsequence=0 border="0" color="33554432" x="2601" y="0" height="76" width="425" format="#,##0.00" html.valueishtml="0"  name=item3 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
    67. 

  67. column(band=detail id=9 alignment="1" tabsequence=0 border="0" color="33554432" x="3040" y="0" height="76" width="416" format="#,##0.00" html.valueishtml="0"  name=item4 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
    68. 

  68. column(band=detail id=10 alignment="1" tabsequence=0 border="0" color="33554432" x="3470" y="0" height="76" width="421" format="#,##0.00" html.valueishtml="0"  name=item5 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
    69. 

  69. column(band=detail id=11 alignment="1" tabsequence=0 border="0" color="33554432" x="3904" y="0" height="76" width="411" format="#,##0.00" html.valueishtml="0"  name=item6 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
    70. 

  70. column(band=detail id=12 alignment="1" tabsequence=0 border="0" color="33554432" x="4329" y="0" height="76" width="430" format="#,##0.00" html.valueishtml="0"  name=item7 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
    71. 

  71. column(band=detail id=13 alignment="1" tabsequence=0 border="0" color="33554432" x="4773" y="0" height="76" width="411" format="#,##0.00" html.valueishtml="0"  name=item8 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
    72. 

  72. column(band=detail id=14 alignment="1" tabsequence=0 border="0" color="33554432" x="5198" y="0" height="76" width="425" format="#,##0.00" html.valueishtml="0"  name=item9 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
    73. 

  73. column(band=detail id=15 alignment="1" tabsequence=0 border="0" color="33554432" x="5637" y="0" height="76" width="416" format="#,##0.00" html.valueishtml="0"  name=item10 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
    74. 

  74. compute(band=summary alignment="1" expression="sum(saleamt for all)"border="0" color="33554432" x="430" y="4" height="56" width="430" format="#,##0.00" html.valueishtml="0"  name=compute_13 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" )
    75. 

  75. text(band=header alignment="2" text="分部" border="2" color="33554432" x="9" y="260" height="56" width="411" html.valueishtml="0"  name=u_scdef_scname_t 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" )
    76. 

  76. text(band=header alignment="2" text="销售金额" border="2" color="33554432" x="430" y="260" height="56" width="430" html.valueishtml="0"  name=saleamt_t 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. 

  77. text(band=header alignment="2" text="成本金额" border="2" color="33554432" x="869" y="260" height="56" width="425" html.valueishtml="0"  name=costamt_t 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" )
    78. 

  78. text(band=header alignment="2" text="毛利金额" border="2" color="33554432" x="1303" y="260" height="56" width="421" html.valueishtml="0"  name=gpamt_t 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" )
    79. 

  79. text(band=header alignment="2" text="Item1" border="2" color="33554432" x="1733" y="260" height="56" width="430" html.valueishtml="0"  name=item1_t 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" )
    80. 

  80. text(band=header alignment="2" text="Item2" border="2" color="33554432" x="2171" y="260" height="56" width="416" html.valueishtml="0"  name=item2_t 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" )
    81. 

  81. text(band=header alignment="2" text="Item3" border="2" color="33554432" x="2597" y="260" height="56" width="430" html.valueishtml="0"  name=item3_t 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" )
    82. 

  82. text(band=header alignment="2" text="Item4" border="2" color="33554432" x="3035" y="260" height="56" width="421" html.valueishtml="0"  name=item4_t 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" )
    83. 

  83. text(band=header alignment="2" text="Item5" border="2" color="33554432" x="3465" y="260" height="56" width="425" html.valueishtml="0"  name=item5_t 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" )
    84. 

  84. text(band=header alignment="2" text="Item6" border="2" color="33554432" x="3899" y="260" height="56" width="416" html.valueishtml="0"  name=item6_t 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" )
    85. 

  85. text(band=header alignment="2" text="Item7" border="2" color="33554432" x="4325" y="260" height="56" width="434" html.valueishtml="0"  name=item7_t 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" )
    86. 

  86. text(band=header alignment="2" text="Item8" border="2" color="33554432" x="4768" y="260" height="56" width="416" html.valueishtml="0"  name=item8_t 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" )
    87. 

  87. text(band=header alignment="2" text="Item9" border="2" color="33554432" x="5193" y="260" height="56" width="430" html.valueishtml="0"  name=item9_t 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" )
    88. 

  88. text(band=header alignment="2" text="Item10" border="2" color="33554432" x="5632" y="260" height="56" width="421" html.valueishtml="0"  name=item10_t 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" )
    89. 

  89. htmltable(border="1" )
    90. 

  90. htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" )
    91. 

  91. export.xml(usetemplate="" headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0  template=(comment="" encoding="gb2312" name="e" xml="<?xml version=~"1.0~" encoding=~"gb2312~" standalone=~"no~"?><dw_rp_rap_sum><dw_rp_rap_sum_row __pbband=~"detail~"><u_accounts_msttakeamt/><u_accounts_takeamt/><accountid>accountid</accountid><u_accounts_balcamt/><oriamt/><u_accounts_accountsname/></dw_rp_rap_sum_row></dw_rp_rap_sum>"))
    92. 

  92. import.xml(usetemplate="" )
    93. 

  93. export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )
    94.