Q5/ws_objects/Ew_machining.pbl.src/dw_rp_owwfjg_in_spt_hz.srd

$PBExportHeader$dw_rp_owwfjg_in_spt_hz.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_bef_qty dbname="qty" )
 column=(type=decimal(14) updatewhereclause=yes name=amt dbname="amt" )
 column=(type=decimal(10) updatewhereclause=yes name=price dbname="price" )
 column=(type=decimal(14) updatewhereclause=yes name=planamt dbname="planamt" )
 column=(type=char(50) updatewhereclause=yes name=u_spt_name dbname="u_spt.name" )
 column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrltype dbname="u_mtrldef.mtrltype" )
 column=(type=char(30) updatewhereclause=yes name=u_mtrldef_prdpackcode dbname="u_mtrldef.prdpackcode" )
 column=(type=decimal(4) updatewhereclause=yes name=u_mtrldef_packqty dbname="u_mtrldef.packqty" )
 column=(type=long updatewhereclause=yes name=u_mtrldef_mtrlid dbname="u_mtrldef.mtrlid" )
 column=(type=decimal(10) updatewhereclause=yes name=u_mtrldef_planprice dbname="u_mtrldef.planprice" )
 column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrlmode dbname="u_mtrldef.mtrlmode" )
 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_bef.qty) as qty,   
			sum(round(ow_wfjgmx_in_bef.qty * ow_wfjgmx_in_bef.fprice ,2)) as amt,
			sum(round(ow_wfjgmx_in_bef.qty * ow_wfjgmx_in_bef.fprice ,2)) / sum(ow_wfjgmx_in_bef.qty) as price,
			sum(round(ow_wfjgmx_in_bef.qty * u_mtrldef.planprice ,2)) as planamt,
         u_spt.name,
         u_mtrldef.mtrltype,      
         u_mtrldef.prdpackcode,    
         u_mtrldef.packqty,    
         u_mtrldef.mtrlid,     
         u_mtrldef.planprice,     
         u_mtrldef.mtrlmode,
			u_mtrldef.mtrlsectype,
			u_mtrldef.zxmtrlmode,
			u_mtrldef.mtrlid
    FROM ow_wfjg_in,   
         ow_wfjgmx_in_bef,   
         u_mtrldef,
			u_spt
   WHERE ( ow_wfjg_in.sptid = u_spt.sptid ) and  
			( ow_wfjg_in.inwareid = ow_wfjgmx_in_bef.inwareid ) and  
         ( ow_wfjg_in.scid = ow_wfjgmx_in_bef.scid ) and  
         ( ow_wfjgmx_in_bef.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.flag = :flag or :flag = -1  ) and
			( ow_wfjg_in.thflag = :arg_thflag OR :arg_thflag = -1 ) 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.prdpackcode,    
         u_mtrldef.packqty,     
         u_mtrldef.mtrltype ,     
         u_mtrldef.planprice,
			u_spt.name,
			u_mtrldef.mtrlsectype,
			u_mtrldef.zxmtrlmode
HAVING sum(ow_wfjgmx_in_bef.qty) <>0
" arguments=(("arg_scid", numberlist),("first_date", datetime),("end_date", datetime),("flag", number),("arg_handtype", string),("arg_thflag", number),("arg_spttypeid", numberlist))  sort="u_mtrldef_mtrltype A u_mtrldef_mtrlcode A " )
text(band=header alignment="2" text=" 编码" border="2" color="0" x="544" 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="928" 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="1655" y="216" height="56" width="343" 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="2258" y="216" height="56" width="347" html.valueishtml="0"  name=ow_wfjgmx_in_bef_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="2007" y="216" height="56" width="242" 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="4069" y="216" height="56" width="366" 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="1073741824" )
text(band=header alignment="2" text="金额" border="2" color="33554432" x="2976" y="216" height="56" width="389" 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="3698" y="216" height="56" width="361" html.valueishtml="0"  name=planamt_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="3374" y="216" height="56" width="315" html.valueishtml="0"  name=u_mtrldef_planprice_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="2615" 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="9" y="216" height="56" width="526" 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="0" x="4443" y="216" height="56" width="320" 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="4773" y="216" height="56" width="430" 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="5211" y="216" height="56" width="462" 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="928" 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="544" 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=4 alignment="1" tabsequence=32766 border="0" color="0" x="2258" y="4" height="68" width="347" format="#,##0.0###" html.valueishtml="0"  name=ow_wfjgmx_in_bef_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="1" background.color="536870912" )
column(band=detail id=14 alignment="0" tabsequence=32766 border="0" color="0" x="1655" y="4" height="68" width="343" 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" )
compute(band=detail alignment="1" expression="f_pack_dscrp( u_mtrldef_mtrlid , ow_wfjgmx_in_bef_qty , u_mtrldef_prdpackcode , u_mtrldef_packqty , u_mtrldef_unit )"border="0" color="0" x="4069" y="4" height="68" width="366" 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="1" background.color="536870912" )
column(band=detail id=3 alignment="2" tabsequence=32766 border="0" color="0" x="2007" y="4" height="68" width="242" 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=5 alignment="1" tabsequence=32766 border="0" color="0" x="2976" y="4" height="68" width="389" 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="1" background.color="536870912" )
column(band=detail id=7 alignment="1" tabsequence=32766 border="0" color="0" x="3698" y="4" height="68" width="361" format="#,##0.00" html.valueishtml="0"  name=planamt 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="1" tabsequence=32766 border="0" color="0" x="3374" y="4" height="68" width="315" format="#,##0.00##" html.valueishtml="0"  name=u_mtrldef_planprice 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=6 alignment="1" tabsequence=32766 border="0" color="0" x="2615" 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=8 alignment="0" tabsequence=32766 border="0" color="0" x="9" y="4" height="68" width="526" 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=9 alignment="0" tabsequence=32766 border="0" color="0" x="4443" y="4" height="68" width="320" 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=15 alignment="0" tabsequence=32766 border="0" color="0" x="4773" y="4" height="68" width="430" 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=16 alignment="0" tabsequence=32766 border="0" color="0" x="5211" y="4" height="68" width="462" 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" )
compute(band=summary alignment="1" expression="sum(ow_wfjgmx_in_bef_qty for all)"border="0" color="0" x="2258" 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="2" expression="count(u_mtrldef_mtrlcode for all)"border="0" color="0" x="544" 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" )
compute(band=summary alignment="1" expression="sum(amt for all)"border="0" color="0" x="2976" y="4" height="56" width="389" 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(planamt for all)"border="0" color="0" x="3698" y="4" height="56" width="361" 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="1" background.color="536870912" )
text(band=foreground alignment="0" text="" border="0" color="0" x="0" y="0" height="212" width="5737" 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="0" y="0" 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="0" y="140" height="60" width="2272" 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 )
import.xml()
export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )