YNU_JEUS/app_home/himed/webapps/pam/rcptteamstatsweb/xrw/SPPAS00730_년도별미수조회및출력.xrw

<?xml version="1.0" encoding="UTF-16"?>
<?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/css" ?>
<xhtml:html xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.w3.org/2002/01/xforms" xmlns:ev="http://www.w3.org/2001/xml-events">
	<xhtml:head>
		<xhtml:title>미수금 조회 및 출력</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<send>
						<fromdd/>
						<todd/>
						<sendflag/>
					</send>
					<main>
					</main>
					<source>
					</source>
					<result/>
					<temp>
					</temp>
					<list>
						<uncolist/>
					</list>
				</root>
			</instance>
			<bind id="bind1" ref="/root/main/outreceivamtlist/receivamtstats" calculate="now() + ."/>
			<bind id="bind2" ref="/root/main/outreceivamtsumlist/receivamtsumstats/uncocnt" calculate="sum(/root/main/outreceivamtlist/receivamtstats/uncocnt);"/>
			<bind id="bind3" ref="/root/main/outreceivamtsumlist/receivamtsumstats/uncoamt" calculate="sum(/root/main/outreceivamtlist/receivamtstats/uncoamt);"/>
			<bind id="bind4" ref="/root/main/inreceivamtlist/receivamtstats" calculate="now() + ."/>
			<bind id="bind5" ref="/root/main/inreceivamtsumlist/receivamtsumstats/uncocnt" calculate="sum(/root/main/inreceivamtlist/receivamtstats/uncocnt);"/>
			<bind id="bind6" ref="/root/main/inreceivamtsumlist/receivamtsumstats/uncoamt" calculate="sum(/root/main/inreceivamtlist/receivamtstats/uncoamt);"/>
			<submission id="TRPAS00810" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/list"/>
		</model>
		<script type="javascript" src="../../../com/commonweb/js/common.js"/>
		<script type="javascript" src="../../../com/commonweb/js/utilHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/numericHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
		<script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
		<script type="javascript" src="../../../com/zipcodeweb/js/ZBP001.js"/>
		<script type="javascript" src="../../../pam/outordamtmngtweb/js/SMPAO00100.js"/>
		<script type="javascript" ev:event="xforms-ready">
			<![CDATA[	
				model.setValue("/root/send/sendflag" , "yyyy");
				model.refresh();
			]]>
		</script>
	</xhtml:head>
	<xhtml:body pagewidth="800" pageheight="784">
		<group id="group2" style="left:0px; top:23px; width:800px; height:37px; ">
			<shape id="roundrect2" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:5px; top:0px; width:790px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
			<button id="btn_search" class="btn1_letter2" style="left:730px; top:10px; width:56px; height:22px; ">
				<caption>조회</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[						    
						
						submit("TRPAS00810");
					]]>
				</script>
			</button>
			<line id="line1" class="line_4" visibility="visible" style="x1:720px; y1:10px; x2:720px; y2:32px; border-color:#ffe4bb; border-left-style:solid; "/>
			<caption id="caption4" class="search_name" style="left:10px; top:10px; width:91px; height:17px; ">미수기간 :</caption>
			<input id="input1" ref="/root/send/fromdd" inputtype="date" format="yyyy" style="left:102px; top:9px; width:105px; height:19px; "/>
		</group>
		<group id="group3" style="left:0px; top:0px; width:800px; height:13px; ">
			<caption id="caption60" class="tit_1" style="left:0px; top:0px; width:183px; height:14px; font-family:돋움; vertical-align:middle; ">미수 조회및 출력</caption>
		</group>
		<caption id="caption2" class="tit_2" style="left:10px; top:66px; width:140px; height:14px; ">미수내역 현황</caption>
		<button id="button1" class="btn2_letter2" style="left:683px; top:63px; width:42px; height:19px; ">
			<caption>출력</caption>
		</button>
		<datagrid id="grd_uncolist" nodeset="/root/list/uncolist" caption="년도^등록번호^성명^발생일자^총금액^미납금" colsep="^" colwidth="100, 80, 76, 120, 100, 100" explorerbar="sort" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:83px; width:795px; height:695px; text-align:center; ">
			<col ref="yyyy"/>
			<col ref="pid"/>
			<col ref="hngnm"/>
			<col ref="rcptexecdd" format="9999-99-99 99:99:99"/>
			<col ref="uncoamt" format="#,###"/>
			<col ref="rcptamt" format="#,###"/>
			<script type="javascript" ev:event="onaftersort">
				<![CDATA[
				grd_uncolist.gridToInstance();
				]]>
			</script>
		</datagrid>
		<button id="button2" class="btn2_letter4" style="left:729px; top:63px; width:64px; height:19px; ">
			<caption>엑셀저장</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
				var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
					
					if (fileName != "")
					{
						grd_uncolist.saveExcel(fileName, "SheetName", true, true, "", "", true);
					}	
				]]>
			</script>
		</button>
	</xhtml:body>
</xhtml:html>