$PBExportHeader$dw_rp_owwfjg_in_hz_ws.srd release 9; datawindow(units=0 timer_interval=60000 color=16777215 processing=1 HTMLDW=no print.printername="" print.documentname="" print.orientation = 1 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 ) header(height=272 color="536870912" ) summary(height=64 color="536870912" ) footer(height=0 color="536870912" ) detail(height=76 color="536870912" ) table(column=(type=char(50) updatewhereclause=yes name=u_mtrldef_mtrlname dbname="u_mtrldef.mtrlname" ) column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrlcode dbname="u_mtrldef.mtrlcode" ) column=(type=char(10) updatewhereclause=yes name=u_mtrldef_unit dbname="u_mtrldef.unit" ) column=(type=decimal(4) updatewhereclause=yes name=ow_wfjgmx_in_aft_qty dbname="qty" ) column=(type=decimal(6) updatewhereclause=yes name=amt dbname="amt" ) column=(type=decimal(14) updatewhereclause=yes name=costamt dbname="costamt" ) column=(type=decimal(6) updatewhereclause=yes name=price dbname="price" ) column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrltype dbname="u_mtrldef.mtrltype" ) column=(type=long updatewhereclause=yes name=u_mtrldef_mtrlid dbname="u_mtrldef.mtrlid" ) column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrlmode dbname="u_mtrldef.mtrlmode" ) column=(type=char(20) updatewhereclause=yes name=u_spt_sptcode dbname="u_spt.sptcode" ) column=(type=char(50) updatewhereclause=yes name=u_spt_name dbname="u_spt.name" ) column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrlsectype dbname="u_mtrldef.mtrlsectype" ) column=(type=char(50) updatewhereclause=yes name=u_mtrldef_zxmtrlmode dbname="u_mtrldef.zxmtrlmode" ) column=(type=long updatewhereclause=yes name=mtrlid dbname="u_mtrldef.mtrlid" ) retrieve=" SELECT u_mtrldef.mtrlname, u_mtrldef.mtrlcode, u_mtrldef.unit, sum(ow_wfjgmx_in_aft.qty) as qty, sum(round(ow_wfjgmx_in_aft.qty * ow_wfjgmx_in_aft.rebate * ow_wfjgmx_in_aft.jgprice ,2)) as amt, sum(round(ow_wfjgmx_in_aft.qty * ow_wfjgmx_in_aft.cost ,2)) as costamt, sum(round(ow_wfjgmx_in_aft.qty * ow_wfjgmx_in_aft.rebate * ow_wfjgmx_in_aft.jgprice ,2)) / sum(ow_wfjgmx_in_aft.qty) as price, u_mtrldef.mtrltype, u_mtrldef.mtrlid, u_mtrldef.mtrlmode, u_spt.sptcode, u_spt.name, u_mtrldef.mtrlsectype, u_mtrldef.zxmtrlmode , u_mtrldef.mtrlid FROM ow_wfjg_in, ow_wfjgmx_in_aft, u_mtrldef, u_spt WHERE ( ow_wfjg_in.sptid = u_spt.sptid ) and ( ow_wfjg_in.inwareid = ow_wfjgmx_in_aft.inwareid ) and ( ow_wfjg_in.scid = ow_wfjgmx_in_aft.scid ) and ( ow_wfjgmx_in_aft.mtrlid = u_mtrldef.mtrlid ) and ( u_mtrldef.handtype like :arg_handtype or :arg_handtype='' ) and ( ow_wfjg_in.indate >= :first_date ) AND ( ow_wfjg_in.indate <= :end_date ) AND ( ow_wfjg_in.billtype = 5 ) AND ( ow_wfjg_in.flag = :flag or :flag = -1 ) AND ( ow_wfjg_in.thflag = :arg_thflag or :arg_thflag = -1 ) AND ( ow_wfjg_in.secflag = :secflag or :secflag = -1 ) AND ( ow_wfjgmx_in_aft.storageid in (:arg_storageid) ) and ( u_spt.spttypeid in (:arg_spttypeid)) and ( ow_wfjg_in.scid in (:arg_scid)) GROUP BY u_mtrldef.mtrlcode, u_mtrldef.mtrlname, u_mtrldef.unit, u_mtrldef.mtrlmode, u_mtrldef.mtrlid, u_mtrldef.mtrltype , u_spt.sptcode, u_spt.name, u_mtrldef.mtrlsectype, u_mtrldef.zxmtrlmode HAVING sum(ow_wfjgmx_in_aft.qty) <>0 " arguments=(("arg_scid", numberlist),("arg_storageid", numberlist),("arg_billtype", number),("first_date", datetime),("end_date", datetime),("flag", number),("secflag", number),("arg_handtype", string),("arg_thflag", number),("arg_spttypeid", numberlist)) sort="u_spt_sptcode A u_mtrldef_mtrlcode A " ) group(level=1 header.height=0 trailer.height=64 by=("u_spt_sptcode" ) header.color="536870912" trailer.color="536870912" ) text(band=header alignment="2" text=" 编码" border="2" color="0" x="1038" y="216" height="56" width="375" html.valueishtml="0" name=u_mtrldef_mtrlcode_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" ) text(band=header alignment="2" text="品名" border="2" color="0" x="1422" y="216" height="56" width="718" html.valueishtml="0" name=u_mtrldef_mtrlname_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" ) text(band=header alignment="2" text=" 规格" border="2" color="0" x="2149" y="216" height="56" width="434" html.valueishtml="0" name=u_mtrldef_mtrlmode_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" ) text(band=header alignment="2" text="数量" border="2" color="0" x="2720" y="216" height="56" width="347" html.valueishtml="0" name=ow_wfjgmx_in_aft_qty_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" ) text(band=header alignment="2" text="库存单位" border="2" color="0" x="2592" y="216" height="56" width="119" html.valueishtml="0" name=u_mtrldef_unit_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="16777215" ) text(band=header alignment="2" text="金额" border="2" color="33554432" x="3438" y="216" height="56" width="434" html.valueishtml="0" name=amt_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" ) text(band=header alignment="2" text="加工均价" border="2" color="33554432" x="3077" y="216" height="56" width="352" html.valueishtml="0" name=price_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" ) text(band=header alignment="2" text="加工商名称" border="2" color="33554432" x="398" y="216" height="56" width="631" html.valueishtml="0" name=u_spt_name_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" ) text(band=header alignment="2" text="进仓成本金额" border="2" color="33554432" x="3881" y="216" height="56" width="421" 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" ) text(band=header alignment="2" text="供应商编号" border="2" color="33554432" x="9" y="216" height="56" width="379" html.valueishtml="0" name=u_spt_sptcode_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" ) text(band=header alignment="2" text="类别" border="2" color="0" x="4311" y="216" height="56" width="430" html.valueishtml="0" name=u_mtrldef_mtrltype_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" ) text(band=header alignment="2" text="自定义一" border="2" color="33554432" x="4750" y="216" height="56" width="411" html.valueishtml="0" name=u_mtrldef_mtrlsectype_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" ) text(band=header alignment="2" text="自定义二" border="2" color="33554432" x="5170" y="216" height="56" width="370" html.valueishtml="0" name=u_mtrldef_zxmtrlmode_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" ) column(band=detail id=1 alignment="0" tabsequence=32766 border="0" color="0" x="1422" y="4" height="68" width="718" format="[general]" html.valueishtml="0" name=u_mtrldef_mtrlname tag="物料名称" visible="1" edit.limit=50 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" ) column(band=detail id=2 alignment="0" tabsequence=32766 border="0" color="0" x="1038" y="4" height="68" width="375" format="[general]" html.valueishtml="0" name=u_mtrldef_mtrlcode tag="物料编码" 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="134" background.mode="1" background.color="536870912" ) column(band=detail id=10 alignment="0" tabsequence=32766 border="0" color="0" x="2149" y="4" height="68" width="434" format="[general]" html.valueishtml="0" name=u_mtrldef_mtrlmode visible="1" edit.limit=0 edit.case=any edit.autoselect=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" ) column(band=detail id=3 alignment="2" tabsequence=32766 border="0" color="0" x="2592" y="4" height="68" width="119" format="[general]" html.valueishtml="0" name=u_mtrldef_unit visible="1" edit.limit=0 edit.case=any edit.autoselect=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" ) column(band=detail id=7 alignment="1" tabsequence=32766 border="0" color="0" x="3077" y="4" height="68" width="352" format="#,##0.00##" html.valueishtml="0" name=price visible="1" edit.limit=0 edit.case=any edit.autoselect=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" ) column(band=detail id=12 alignment="0" tabsequence=32766 border="0" color="0" x="398" y="4" height="68" width="631" format="[general]" html.valueishtml="0" name=u_spt_name visible="1" edit.limit=0 edit.case=any edit.autoselect=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" ) column(band=detail id=11 alignment="0" tabsequence=32766 border="0" color="0" x="9" y="4" height="68" width="379" format="[general]" html.valueishtml="0" name=u_spt_sptcode visible="1" edit.limit=0 edit.case=any edit.autoselect=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" ) column(band=detail id=4 alignment="1" tabsequence=32766 border="0" color="0" x="2720" y="4" height="68" width="347" format="#,##0.0###" html.valueishtml="0" name=ow_wfjgmx_in_aft_qty tag="进仓数量" 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="134" background.mode="2" background.color="16776960" ) column(band=detail id=5 alignment="1" tabsequence=32766 border="0" color="0" x="3438" y="4" height="68" width="434" format="#,##0.00" html.valueishtml="0" name=amt visible="1" edit.limit=0 edit.case=any edit.autoselect=yes 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="16777215" ) column(band=detail id=6 alignment="1" tabsequence=32766 border="0" color="0" x="3881" y="4" height="68" width="421" format="#,##0.00" html.valueishtml="0" name=costamt visible="1" edit.limit=0 edit.case=any edit.autoselect=yes 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="16777215" ) column(band=detail id=8 alignment="0" tabsequence=32766 border="0" color="0" x="4311" y="4" height="68" width="430" format="[general]" html.valueishtml="0" name=u_mtrldef_mtrltype visible="1" edit.limit=0 edit.case=any edit.autoselect=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" ) column(band=detail id=13 alignment="0" tabsequence=32766 border="0" color="0" x="4750" y="4" height="68" width="411" format="[general]" html.valueishtml="0" name=u_mtrldef_mtrlsectype 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="1" background.color="536870912" ) column(band=detail id=14 alignment="0" tabsequence=32766 border="0" color="0" x="5170" y="4" height="68" width="370" format="[general]" html.valueishtml="0" name=u_mtrldef_zxmtrlmode 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="1" background.color="536870912" ) text(band=trailer.1 alignment="2" text="小计" border="0" color="33554432" x="9" y="4" height="56" width="379" html.valueishtml="0" name=t_2 visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16776960" ) compute(band=trailer.1 alignment="2" expression="count(u_mtrldef_mtrlcode for group 1)"border="0" color="0" x="1038" y="4" height="56" width="375" format="[general]" html.valueishtml="0" name=compute_8 visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16776960" ) compute(band=trailer.1 alignment="1" expression="sum(ow_wfjgmx_in_aft_qty for group 1)"border="0" color="0" x="2720" y="4" height="56" width="347" format="#,##0.0###" 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="16776960" ) compute(band=trailer.1 alignment="1" expression="sum(amt for group 1)"border="0" color="0" x="3438" y="4" height="56" width="434" 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="16776960" ) compute(band=trailer.1 alignment="1" expression="sum(costamt for group 1)"border="0" color="0" x="3881" y="4" height="56" width="421" 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="16776960" ) compute(band=trailer.1 alignment="0" expression=" u_spt_name "border="0" color="0" x="398" y="4" height="56" width="631" format="[GENERAL]" 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="16776960" ) text(band=trailer.1 alignment="1" text="" border="0" color="33554432" x="1422" y="4" height="56" width="718" html.valueishtml="0" name=t_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="16776960" ) text(band=trailer.1 alignment="1" text="" border="0" color="33554432" x="2149" y="4" height="56" width="434" html.valueishtml="0" name=t_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="16776960" ) text(band=trailer.1 alignment="1" text="" border="0" color="33554432" x="2592" y="4" height="56" width="119" html.valueishtml="0" name=t_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="16776960" ) text(band=trailer.1 alignment="1" text="" border="0" color="33554432" x="3077" y="4" height="56" width="352" html.valueishtml="0" name=t_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="16776960" ) text(band=trailer.1 alignment="1" text="" border="0" color="33554432" x="4311" y="4" height="56" width="430" html.valueishtml="0" name=t_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="16776960" ) text(band=trailer.1 alignment="1" text="" border="0" color="33554432" x="4750" y="4" height="56" width="411" html.valueishtml="0" name=t_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="16776960" ) text(band=trailer.1 alignment="1" text="" border="0" color="33554432" x="5170" y="4" height="56" width="370" html.valueishtml="0" name=t_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="16776960" ) compute(band=summary alignment="1" expression="sum(ow_wfjgmx_in_aft_qty for all)"border="0" color="0" x="2720" y="4" height="56" width="347" format="#,##0.0###" 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" ) compute(band=summary alignment="1" expression="sum(amt for all)"border="0" color="0" x="3438" y="4" height="56" width="434" 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="1" background.color="536870912" ) compute(band=summary alignment="1" expression="sum(costamt for all)"border="0" color="0" x="3881" y="4" height="56" width="421" 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="1" background.color="536870912" ) compute(band=summary alignment="2" expression="count(u_mtrldef_mtrlcode for all distinct)"border="0" color="0" x="1038" y="4" height="56" width="375" format="[general]" html.valueishtml="0" name=compute_2 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" ) text(band=summary alignment="2" text="合计" border="0" color="33554432" x="9" y="4" height="56" width="379" 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" ) compute(band=summary alignment="2" expression="count(u_spt_name for all)"border="0" color="0" x="398" y="4" height="56" width="631" format="[general]" html.valueishtml="0" name=compute_6 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" ) text(band=foreground alignment="0" text="" border="0" color="0" x="0" y="0" height="212" width="5605" html.valueishtml="0" name=background visible="1" resizeable=1 font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="33554431" ) text(band=foreground alignment="0" text="车间外协收货汇总表" border="0" color="0" x="9" y="8" height="124" width="3090" 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" ) compute(band=foreground alignment="0" expression="if( flag =0 ,'未审核 ','')+'进仓日期:'+string( first_date ,'yy-mm-dd') +'~~~~'+string(end_date ,'yy-mm-dd') +' 打印日期: '+string(today(),'yyyy-mm-dd')+' 共 '+string(pageCount())+' 页 第 ' + string(page()) + ' 页'"border="0" color="0" x="9" y="144" height="60" width="3086" format="[general]" html.valueishtml="0" name=compute_3 visible="1" moveable=1 font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) htmltable(border="1" ) htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" ) export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 template=(comment="" encoding="gb2312" name="d" xml="u_spt_sptcodeu_mtrldef_mtrlnameu_mtrldef_mtrlcodeu_mtrldef_unitow_wfjgmx_in_aft_qtyamtcostamtpriceu_mtrldef_mtrltypeu_mtrldef_mtrlidu_mtrldef_mtrlmodeu_spt_name")) import.xml() export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )