Q5/ws_objects/cw_account.pbl.src/dw_rp_subid_mx.srd

$PBExportHeader$dw_rp_subid_mx.srd
$PBExportComments$By Kivens.Jiang(kivens@21cn.com)
release 9;
datawindow ( units=0 timer_interval=60000 color=16777215 processing=1 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.size=9 print.paper.source=0 print.canusedefaultprinter=yes grid.lines=0 selected.mouse=yes)
header(height=448 color="536870912" )
summary(height=0 color="536870912" )
footer(height=0 color="536870912" )
detail(height=84 color="553648127"  height.autosize=yes)
table(column=(type=datetime updatewhereclause=yes name=cw_credence_creddate dbname="cw_subject.creddate"  )
column=(type=long updatewhereclause=yes name=cmonth dbname="cw_Balance.cmonth"  )
column=(type=char(10) updatewhereclause=yes name=credtype dbname="credtype"  )
column=(type=long updatewhereclause=yes name=credno dbname="credno"  )
column=(type=char(255) updatewhereclause=yes name=cw_credencemx_brief dbname="brief"  )
column=(type=decimal(2) updatewhereclause=yes name=debit dbname="cw_subject.Debit"  )
column=(type=decimal(2) updatewhereclause=yes name=credit dbname="cw_subject.Credit"  )
column=(type=decimal(2) updatewhereclause=yes name=balc dbname="balc"  )
column=(type=long updatewhereclause=yes name=dw_sort dbname="dw_sort"  )
column=(type=long updatewhereclause=yes name=fuluno dbname="fuluno"  )
column=(type=long updatewhereclause=yes name=credid dbname="credid"  )
column=(type=char(255) updatewhereclause=yes name=mxdscrp dbname="mxdscrp"  )
 retrieve="  SELECT null as creddate,   
         cw_Balance.YearMon as cmonth,   
			'' as credtype,
         0 as credno,
         '期初余额' as brief,
			null as Debit,   
         null as Credit,   
         case isnull(cw_Balance.bDebit,0) - isnull(cw_Balance.bCredit,0) when 0 then null else isnull(cw_Balance.bDebit,0) - isnull(cw_Balance.bCredit,0) end as balc,			
         0 as dw_sort,
			0 as fuluno, 
			0 as credid,
			'' as mxdscrp
    FROM cw_subject left outer join cw_Balance on 
			cw_subject.accsetid = cw_Balance.accsetid and
			cw_subject.SubID = cw_Balance.SubID
   WHERE ( cw_subject.accsetid = :arg_accsetid ) AND  
         ( cw_subject.SubID = :arg_subid ) AND  
         ( cw_Balance.YearMon >= :arg_firstmon or cw_Balance.YearMon is null ) AND  
         ( cw_Balance.YearMon <= :arg_endmon  or cw_Balance.YearMon is null )

union all
  SELECT cw_credence.creddate as creddate,   
         cw_credence.cmonth as cmonth,   
			cw_credence.credtype as credtype, 
         cw_credence.credno as credno,  

         case :arg_rel when 1 then
         ltrim(rtrim(cw_credencemx.brief)) + ' ' +
			case len(ltrim(rtrim(cw_credence.reldcode))) when 0 then '' else '相关号:'+ltrim(rtrim(cw_credence.reldcode)) end + ' '+
         case reldate when null then '' else '相关日期:'+ convert(char(4),year(reldate))+'-'+convert(char(2),month(reldate))+'-'+ convert(char(2),day(reldate)) end 
         else 
         ltrim(rtrim(cw_credencemx.brief)) + ' ' +
			case len(ltrim(rtrim(cw_credence.reldcode))) when 0 then '' else '相关号:'+ltrim(rtrim(cw_credence.reldcode)) + ' '+
         case reldate when null then '' else '相关日期:'+ convert(char(4),year(reldate))+'-'+convert(char(2),month(reldate))+'-'+ convert(char(2),day(reldate)) end end end
		 + case when cw_credencemx.deptid = 0 then '' else '(部门:'+rtrim(cw_department.departmentname)+')' end + 
			case when cw_credencemx.itemid = 0 then '' else '(项目:'+rtrim(cw_hsitem.hsitemname)+')' end + 
			case when cw_credencemx.cusid = 0 then '' else '(客户:'+rtrim(u_cust.name)+')' end + 
			case when cw_credencemx.sptid = 0 then '' else '(供应商:'+rtrim(u_spt.name)+')'end as brief,   

         case cw_credencemx.debit when 0 then null else cw_credencemx.debit end as debit,  
			case cw_credencemx.credit when 0 then null else cw_credencemx.credit end as credit , 
         0.00 as balc,
         1 as dw_sort,
			cw_credencemx.fuluno as fuluno ,
			cw_credence.credid as credid,
			cw_credencemx.mxdscrp as mxdscrp
    FROM cw_credence,   
         cw_credencemx  
			left outer join cw_department on cw_credencemx.deptid = cw_department.departmentid
			left outer join cw_hsitem on cw_credencemx.itemid = cw_hsitem.hsitemid
			left outer join u_cust on cw_credencemx.cusid = u_cust.cusid
			left outer join u_spt on cw_credencemx.sptid = u_spt.sptid
   WHERE ( cw_credence.accsetid = cw_credencemx.accsetid ) and  
         ( cw_credence.subaccsetid = cw_credencemx.subaccsetid ) and  
         ( cw_credence.credid = cw_credencemx.credid ) and  
         ( ( cw_credence.accsetid = :arg_accsetid ) AND  
         ( cw_credence.subaccsetid = :arg_subaccsetid or :arg_subaccsetid = -1 ) AND  
         ( cw_credence.cmonth >= :arg_firstmon ) AND  
         ( cw_credence.cmonth <= :arg_endmon ) AND  
         ( cw_credence.postflag = :arg_if_post or :arg_if_post = -1  ) AND  
         ( left(cw_credencemx.subid,:arg_subid_len) = :arg_subid ) )    

union all
  SELECT null as creddate,   
         cw_credence.cmonth as cmonth,  
			'' as credtype,
         0 as credno,
         '本期合计' as brief,
			case sum(cw_credencemx.debit) when 0 then null else sum(cw_credencemx.debit) end as debit, 
			case sum(cw_credencemx.Credit) when 0 then null else sum(cw_credencemx.Credit) end as Credit, 
         0.00 as balc,
			2 as dw_sort,
			0 as fuluno,
			0 as credid,
			'' as mxdscrp
    FROM cw_credence,   
         cw_credencemx  
   WHERE ( cw_credence.accsetid = cw_credencemx.accsetid ) and  
         ( cw_credence.subaccsetid = cw_credencemx.subaccsetid ) and  
         ( cw_credence.credid = cw_credencemx.credid ) and  
         ( ( cw_credence.accsetid = :arg_accsetid ) AND  
         ( cw_credence.subaccsetid = :arg_subaccsetid or :arg_subaccsetid = -1 ) AND  
         ( cw_credence.cmonth >= :arg_firstmon ) AND  
         ( cw_credence.cmonth <= :arg_endmon ) AND  
         ( cw_credence.postflag = :arg_if_post or :arg_if_post = -1  ) AND  
         ( left(cw_credencemx.subid,:arg_subid_len) = :arg_subid ) )
group by cw_credence.cmonth

union all 
  SELECT null as creddate,   
         cw_Balance.YearMon as cmonth,  
			'' as credtype,
         0 as credno,
         '本年累计' as brief,
			case cw_Balance.yDebit when 0 then null else cw_Balance.yDebit end as debit, 
			case cw_Balance.yCredit when 0 then null else cw_Balance.yCredit end as Credit,
         case cw_Balance.ybDebit - cw_Balance.ybCredit + cw_Balance.yDebit - cw_Balance.yCredit when 0 then null else cw_Balance.ybDebit - cw_Balance.ybCredit + cw_Balance.yDebit - cw_Balance.yCredit end as balc,
			3 as dw_sort,
			0 as fuluno,
			0 as credid,
			'' as mxdscrp
    FROM cw_Balance  
   WHERE ( cw_Balance.accsetid = :arg_accsetid ) AND  
         (cw_Balance.subaccsetid = :arg_subaccsetid ) AND  
         cw_Balance.SubID = :arg_subid AND
         cw_Balance.YearMon >= :arg_firstmon and 
         cw_Balance.YearMon <= :arg_endmon"
  arguments=(("arg_accsetid", number), ("arg_subaccsetid", number), ("arg_subid", string), ("arg_subid_len", number), ("arg_if_post", number), ("arg_firstmon", number), ("arg_endmon", number), ("arg_rel", number))
 sort="cmonth A, dw_sort A, credno A, cw_credence_creddate A"
)
text(name=cw_credence_creddate_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="2" border="2" x="9" y="392" height="56" width="325" text="凭证日期" )
text(name=cmonth_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="2" border="2" x="343" y="392" height="56" width="197" text="期间" )
text(name=credtype_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="2" border="2" x="549" y="392" height="56" width="114" text="字" )
text(name=credno_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="2" border="2" x="672" y="392" height="56" width="96" text="号" )
text(name=cw_credencemx_brief_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="2" border="2" x="777" y="392" height="56" width="901" text="摘要" )
text(name=debit_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="2" border="2" x="1687" y="392" height="56" width="489" text="借方" )
text(name=credit_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="2" border="2" x="2185" y="392" height="56" width="489" text="贷方" )
text(name=t_1 visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="0" border="2" x="2683" y="392" height="56" width="82" text="" )
text(name=t_2 visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="2" border="2" x="2775" y="392" height="56" width="489" text="余额" )
text(name=t_3 visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="2" border="2" x="3273" y="392" height="56" width="617" text="补充备注" )
column(name=cw_credence_creddate visible="1" tag="日期" band=detail id=1 x="9" y="8" height="72" width="325" color="0" border="0" alignment="2" format="yyyy-mm-dd" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=yes edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=cmonth visible="1" band=detail id=2 x="343" y="8" height="72" width="197" color="0" border="0" alignment="2" format="[general]" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=credno visible="1" band=detail id=4 x="672" y="8" height="72" width="96" color="0" border="0" alignment="2" format="#####" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=cw_credencemx_brief visible="1" tag="摘要" height.autosize=yes band=detail id=5 x="777" y="8" height="72" width="901" color="0" border="0" alignment="0" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=40 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=debit visible="1" band=detail id=6 x="1687" y="8" height="72" width="489" color="0" border="0" alignment="1" format="#,##0.00" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=credit visible="1" band=detail id=7 x="2185" y="8" height="72" width="489" color="0" border="0" alignment="1" format="#,##0.00" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
compute(name=obj_5661891 visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" x="2683" y="8" height="72" width="82" format="[general]" expression="if( balc =0 or isnull(balc),'平',if( balc >0,'借','贷'))" alignment="2" border="0" crosstab.repeat=no )
column(name=credtype visible="1" band=detail id=3 x="549" y="8" height="72" width="114" color="0" border="0" alignment="2" format="[general]" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
compute(name=balc2 visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="0" x="2775" y="8" height="72" width="489" format="#,##0.00" expression="abs( balc )" alignment="1" border="0" crosstab.repeat=no )
column(name=mxdscrp visible="1" height.autosize=yes band=detail id=12 x="3273" y="8" height="72" width="617" color="0" border="0" alignment="0" format="[general]" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
text(name=bar visible="1" band=foreground font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="0" alignment="0" border="0" x="0" y="0" height="388" width="3337" text="" )
compute(name=compute_1 visible="1" band=foreground font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="0" x="14" y="156" height="56" width="1861" format="[general]" expression="~"单位名称:~"+f_rst_Cropname()" alignment="0" border="0" crosstab.repeat=no )
text(name=month visible="1" band=foreground font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="0" alignment="0" border="0" x="1893" y="156" height="56" width="983" text="" )
text(name=t_4 visible="1" moveable=1 resizeable=1 band=foreground font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="0" alignment="0" border="0" x="2889" y="156" height="56" width="430" text="币别：人民币" )
text(name=title visible="1" band=foreground font.charset="134" font.face="宋体" font.family="0" font.height="-22" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="0" border="0" x="0" y="8" height="132" width="3323" text="明细帐" )
text(name=subname visible="1" band=foreground font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="0" alignment="0" border="0" x="14" y="224" height="56" width="3310" text="" )
compute(name=compute_2 visible="1" band=foreground font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="0" x="14" y="296" height="56" width="3305" format="[general]" expression="'打印时间:'+string(today(),'yyyy-mm-dd hh:mm')+ '   第 ' + string(page()) + ' 页/ 共 '+string(pageCount())+' 页'" alignment="0" border="0" crosstab.repeat=no )
htmltable(border="1" )
htmlgen(clientComputedFields="1" clientEvents="1" clientFormatting="0" clientScriptable="0" clientValidation="1" generateJavaScript="1" netscapeLayers="0" netscapelayers="0" encodeSelfLinkArgs="1" )
export.xml(headGroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
import.xml()
export.pdf(method=0 distill.customPostScript="0" xslfop.print="0" )