YNU_JEUS/app_home/himed/webapps/ast/healexamstatweb/xrw/SMAHS00600_신용카드사별수익실적.xrw

<?xml version="1.0" encoding="UTF-8"?>
<?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="">
					<main>
						<cardlst>
							<card>
								<cardcmpynm/>
								<cardcnt/>
								<crtcardamt/>
								<comsamt/>
								<depodd/>
								<depoamt/>
								<uncoamt/>
								<remfact/>
							</card>
							<carddetl>
								<cardcmpynm/>
								<rcptexecdd/>
								<rcptid/>
								<rcptnm/>
								<crtcardamt/>
								<comsamt/>
								<depoamt/>
								<cardno/>
								<aprvno/>
							</carddetl>
						</cardlst>
						<export/>
					</main>
					<send>
						<srchfromdd/>
						<srchtodd/>
						<srchinstcd/>
					</send>
					<hidden>
					</hidden>
					<init>
						<baseinfo>
							<healexamflaglist/>
							<healexamdetlflaglist/>
							<healexamdetlflaglist2/>
						</baseinfo>
					</init>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					//일자초기화
					model.setValue("/root/send/srchfromdd" , getCurrentDate());
					model.setValue("/root/send/srchtodd" , getCurrentDate());
					//기관코드 초기화
					model.setValue("/root/send/srchinstcd" , getUserInfo("posinstcd"));
					//공통코드 조회
					zbcfGetCodeList(new Array("A0068","A0069" ,"A0070" ),
											   new Array("/root/init/baseinfo/healexamflaglist" ,"/root/init/baseinfo/healexamdetlflaglist"  , "/root/init/baseinfo/healexamdetlflaglist2"));
					model.refresh();
				]]>
			</script>
			<submission id="TRZBC00101"/>
			<script type="javascript">
				<![CDATA[
					/*
					* 화면merge와 카드종류 소계 및 총계를 생성한다.
					*/
					function fSetRcptSum() {
						//그리드 merge 및 합계 초기화
						grd_carddetllst.autoMerge = false;
						grd_carddetllst.mergeCells = "bycolrec";
						
						grd_cardlst.subtotalPosition = "below";						
						grd_cardlst.multiTotals = true;
						
						grd_carddetllst.subtotalPosition = "below";
						grd_carddetllst.multiTotals = true;
						
						grd_cardlst.subtotal("clear", 0, 0);
						grd_carddetllst.subtotal("clear", 0, 0);
						
						for(var i =0; i < grd_cardlst.cols ; i++) {							
							// 소계
							if((i >= grd_cardlst.colRef("cardcnt") && i <= grd_cardlst.colRef("comsamt") )||
								(i >= grd_cardlst.colRef("depoamt") && i <= grd_cardlst.colRef("uncoamt") ) ) {																		
								grd_cardlst.subtotal("sum", -1 , i ,"format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#808080; color:#ffffff; font-weight:bold ", grd_cardlst.colRef("cardcmpynm") , "총계" );																
							}							
							// 화면 merge	
							/*
							if( i ==  grd_cardlst.colRef("cardcmpynm")) {
								grd_cardlst.mergeCol(i) = true;
							}else{
								grd_cardlst.mergeCol(i) = false;
							}	*/
						}
						
						for(var i =0; i < grd_carddetllst.cols ; i++) {
							// 소계
							if( i >= grd_carddetllst.colRef("crtcardamt") && i <= grd_carddetllst.colRef("depoamt")  ) {										
								grd_carddetllst.subtotal("sum", grd_carddetllst.colRef("cardcmpynm") , i ,"format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#7CBBDD; color:#ffffff; font-weight:bold ", grd_carddetllst.colRef("cardcmpynm") , "소계" );																
								
								grd_carddetllst.subtotal("sum", -1 , i ,"format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#808080; color:#ffffff; font-weight:bold ", grd_carddetllst.colRef("cardcmpynm") , "총계" );																
							}							
							// 화면 merge														
							if( i ==  grd_carddetllst.colRef("cardcmpynm")) {
								grd_carddetllst.mergeCol(i) = true;
							}else{
								grd_carddetllst.mergeCol(i) = false;
							}	
						}
						grd_carddetllst.subtotal("count", grd_carddetllst.colRef("cardcmpynm") , 3 ,"format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#7CBBDD; color:#ffffff; font-weight:bold ", grd_carddetllst.colRef("rcptnm") , "건" );
						grd_carddetllst.merge();
					}
				]]>
			</script>
			<submission id="TRAHS00601" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/cardlst"/>
		</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"/>
	</xhtml:head>
	<xhtml:body pagewidth="1211" pageheight="784" guideline="1,1206;">
		<group id="group3" style="left:0px; top:0px; width:1211px; height:13px; ">
			<caption id="caption60" class="tit_1" style="left:0px; top:0px; width:183px; height:14px; font-family:돋움; vertical-align:middle; ">신용카드사별 수입실적</caption>
		</group>
		<group id="group2" style="left:4px; top:23px; width:1203px; height:35px; ">
			<shape id="roundrect1" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1202px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
			<line id="line2" class="line_4" style="x1:1132px; y1:7px; x2:1132px; y2:29px; border-color:#ffe4bb; border-left-style:solid; "/>
			<button id="btn_search" class="btn1_letter2" style="left:1139px; top:7px; width:56px; height:22px; ">
				<caption>조회</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[					
						var ret = submit("TRAHS00601");
						if(ret){
							fSetRcptSum();
							model.refresh();
						}						
					]]>
				</script>
			</button>
			<input id="ipt_fromdd" ref="/root/send/srchfromdd" class="input_search" navindex="7" inputtype="date" style="left:82px; top:8px; width:105px; height:19px; "/>
			<button id="btn_excelsave" class="btn6_letter4" visibility="visible" style="left:976px; top:7px; width:80px; height:22px; ">
				<caption>액셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[				
						var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*"); 
						grd_cardlst.saveExcel(fileName, "SheetName", true, true, "", "", false);
					]]>
				</script>
			</button>
			<button id="btn_prt" class="btn6_letter2" style="left:1070px; top:7px; width:56px; height:22px; ">
				<caption>출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var idx = swt_card.selectedIndex;
						// 매개변수
						model.makeValue("/root/main/export/srchfromdd" ,  model.getValue("/root/send/srchfromdd").toDate().getDateFormat("YYYY/MM/DD"));
						model.makeValue("/root/main/export/srchtodd" ,  model.getValue("/root/send/srchtodd").toDate().getDateFormat("YYYY/MM/DD"));
						
						if(idx == "0") {
							exeReportPreview("RPAHS00601", "XMLSTR", "/root/main/export","", "false","","","","","false");	
						}else if(idx == "1") {
							exeReportPreview("RPAHS00602", "XMLSTR", "/root/main/export","", "false","","","","","false");	
						}
						
					]]>
				</script>
			</button>
			<line id="line3" class="line_4" visibility="hidden" style="x1:1063px; y1:7px; x2:1063px; y2:29px; border-color:#ffe4bb; border-left-style:solid; "/>
			<caption id="caption93" class="search_n_b" style="left:193px; top:10px; width:12px; height:17px; font-weight:bolder; ">~</caption>
			<input id="input1" ref="/root/send/srchtodd" class="input_search" navindex="7" inputtype="date" style="left:210px; top:8px; width:105px; height:19px; ">
				<script type="javascript" ev:event="onkeydown">
					<![CDATA[									
							]]>
				</script>
			</input>
			<caption id="caption2" class="search_name" style="left:15px; top:9px; width:73px; height:17px; ">기간 :</caption>
		</group>
		<switch id="swt_card" style="left:4px; top:89px; width:1203px; height:691px; ">
			<case id="case_card" selected="true">
				<datagrid id="grd_cardlst" nodeset="/root/main/cardlst/card" caption="카드사^건수^발생액^수수료^입금액^미수액^입금일^비고" colsep="^" colwidth="120, 60, 130, 130, 130, 130, 130, 200" mergecellsfixedrows="bycolrec" rowsep="|" style="left:5px; top:5px; width:1191px; height:679px; ">
					<col ref="cardcmpynm" style="text-align:left; padding-left:5; "/>
					<col ref="cardcnt" style="text-align:right; padding-right:5; "/>
					<col ref="crtcardamt" format="(-,+)#,###" style="text-align:right; padding-right:5; "/>
					<col ref="comsamt" format="(-,+)#,###" style="text-align:right; padding-right:5; "/>
					<col ref="depoamt" format="(-,+)#,###" style="text-align:right; padding-right:5; "/>
					<col ref="uncoamt" visibility="hidden" format="(-,+)#,###" style="text-align:right; padding-right:5; "/>
					<col ref="depodd" format="yyyy-mm-dd" style="text-align:center; "/>
					<col ref="remfact" type="input"/>
				</datagrid>
			</case>
			<case id="case_carddetl">
				<datagrid id="grd_carddetllst" nodeset="/root/main/cardlst/carddetl" caption="카드사^수납일자^등록번호^성명^카드발생금액^지금수수료^카드입금액^카드번호^승인번호" colsep="^" colwidth="120, 100, 100, 100, 130, 130, 130, 200, 100" mergecellsfixedrows="bycolrec" rowsep="|" style="left:5px; top:5px; width:1191px; height:679px; ">
					<col ref="cardcmpynm" style="text-align:left; padding-left:5; "/>
					<col ref="rcptexecdd" format="yyyy-mm-dd" style="text-align:center; "/>
					<col ref="rcptid" style="text-align:right; padding-right:5; "/>
					<col ref="rcptnm" style="text-align:center; "/>
					<col ref="crtcardamt" format="(-,+)#,###" style="text-align:right; padding-right:5; "/>
					<col ref="comsamt" format="(-,+)#,###" style="text-align:right; padding-right:5; "/>
					<col ref="depoamt" format="(-,+)#,###" style="text-align:right; padding-right:5; "/>
					<col ref="cardno" style="text-align:right; padding-right:5; "/>
					<col ref="aprvno" style="text-align:right; padding-right:5; "/>
				</datagrid>
			</case>
		</switch>
		<button id="btn_cust" class="btn_sw" group="tab" selected="true" style="left:5px; top:67px; width:90px; height:22px; ">
			<caption>카드사별수입</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
					model.toggle("case_card");
					btn_cust.selected = true;					
				]]>
			</script>
		</button>
		<button id="btn_ramtend" class="btn_sw" group="tab" style="left:94px; top:67px; width:111px; height:22px; ">
			<caption>카드사별수입내역</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
					model.toggle("case_carddetl");
					btn_ramtend.selected = true;					
				]]>
			</script>
		</button>
	</xhtml:body>
</xhtml:html>