YNU_JEUS/app_home/himed/webapps/pam/rcptteamstatsweb/xrw/SMPAS00520_외래수입통계.xrw

<?xml version="1.0" encoding="UTF-16"?>
<!--
    * 화면   : SMPAS00520_외래수입통계.xrw
    * 설명   : 외래수입통계.
    * 작성자 : 조영상
    * 작성일 : 2007/11/26
-->
<?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.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>
						<h_rcpt>
							<rcpt>
								<rcpt_rcptrid/>
								<rcpt_rcptrnm/>
								<rcpt_ojamt_cnt/>
								<rcpt_ojamt/>
								<rcpt_rsrv_cnt/>
								<rcpt_rsrv/>
								<rcpt_rcptamt_cnt/>
								<rcpt_rcptamt/>
								<rcpt_bogjamt/>
								<rcpt_bogjaltamt/>
								<rcpt_bogjrtnamt/>
								<rcpt_unco/>
								<rcpt_uncr/>
								<rcpt_rareobstamt/>
								<rcpt_suppamt/>
								<rcpt_sum/>
							</rcpt>
						</h_rcpt>
						<h_rcpt2>
							<rcpt2>
								<col1/>
								<col2/>
								<col3/>
							</rcpt2>
						</h_rcpt2>
					</main>
					<send>
						<data1>
							<fromdd/>
							<tm_from/>
							<tm_to/>
							<rcpt_id/>
							<rcpt_flag/>
							<ordtype/>
						</data1>
					</send>
					<hidden>
						<session>
							<userid/>
							<usernm/>
							<posinstcd/>
							<posinstnm/>
							<dutplcecd/>
							<dutplcenm/>
							<dutinstnm/>
						</session>
					</hidden>
				</root>
			</instance>
			<bind id="bind1" ref="/root/main/receivamtlist/receivamtstats" calculate="now() + ."/>
			<bind id="bind2" ref="/root/main/receivamtsumlist/receivamtsumstats/uncnt" calculate="sum(/root/main/receivamtlist/receivamtstats/uncnt);"/>
			<bind id="bind3" ref="/root/main/receivamtsumlist/receivamtsumstats/uncoamt" calculate="sum(/root/main/receivamtlist/receivamtstats/uncoamt);"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
				makeReportPreview(300,0,893,648,"case2");
				
				fInitialize();
				
				fGetUserInfo2();
				
				btn_all.selected = "true"; //외래전체수익통계로 기본세팅
				model.toggle("case1"); 
				
				//exeReportPreview("RPPAS01692", "XMLSTR", "", "", "false", "", "", "", "", "","", "case2", "", "", "", "1", "75");
				

				]]>
			</script>
			<submission id="TRPAS00521" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/data1" resultref="/root/main/h_rcpt"/>
			<submission id="TRPAS00522" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/data1" resultref="/root/main/h_rcpt2"/>
			<submission id="TRPAS00543" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/data1" resultref="/root/main/h_rcptnm"/>
		</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">
			<![CDATA[
			
			var cash = 0;
		
			//로그인한 사용자 정보조회
			function fGetUserInfo2(){
		
				var sUserInfosS = getUserInfos(); 
				
					sUserInfosS = sUserInfosS + "|";
					//alert("sUserInfosS : " + sUserInfosS);	
					var UserInfosS_Array = sUserInfosS.split("|");
		
					var userid        = UserInfosS_Array[0];  //사용자번호
					var usernm        = UserInfosS_Array[1];  //사용자이름
					var posinstcd     = UserInfosS_Array[2];  //소속기관코드
					var posinstnm     = UserInfosS_Array[3];  //소속기관명
					var dutplcecd     = UserInfosS_Array[4];  //근무지부서코드
					var dutplcenm     = UserInfosS_Array[5];  //근무지부서명
					var dutinstnm      = UserInfosS_Array[7];  //근무지기관명
					
				  /*
				  model.makeNode("/root/hidden/session/" + "userid");
				  model.makeNode("/root/hidden/session/" + "usernm");
				  model.makeNode("/root/hidden/session/" + "posinstcd");
				  model.makeNode("/root/hidden/session/" + "posinstnm");
				  model.makeNode("/root/hidden/session/" + "dutplcecd");
				  model.makeNode("/root/hidden/session/" + "dutplcenm");
				  model.makeNode("/root/hidden/session/" + "dutinstnm");
				  */
				  
				  model.setValue("/root/hidden/session/userid",userid);
				  model.setValue("/root/hidden/session/usernm",usernm);
				  model.setValue("/root/hidden/session/posinstcd",posinstcd);
				  model.setValue("/root/hidden/session/posinstnm",posinstnm);
				  model.setValue("/root/hidden/session/dutplcecd",dutplcecd);
				  model.setValue("/root/hidden/session/dutplcenm",dutplcenm);
				  model.setValue("/root/hidden/session/dutinstnm",dutinstnm);
		
			}
			
			function fInitialize() {
				
					model.removenodeset("/root/main/h_rcpt/rcpt");
					
					model.setValue("/root/send/data1/fromdd",          getCurrentDate());	// common.js에서 제공하는 함수를 사용하여 오늘 날짜를 구한다.
					model.setValue("/root/send/data1/tm_from",         "0000");
					model.setValue("/root/send/data1/tm_to",             "2400");
					model.setValue("/root/send/data1/rcpt_id",           "");
					model.setValue("/root/send/data1/rcpt_flag",  "");
					model.setValue("/root/send/data1/ordtype",          "O");
					//exeReportPreview("RPPAS01692", "XMLSTR", "", "", "false", "", "", "", "", "","", "case2", "", "", "", "1", "75");
					model.refresh();
			}
			
			
			function fSearch() {
				
					//외래전체수입통계
					if(switch1.selectedIndex == "0") {
						submit("TRPAS00521");
						exeReportPreview("RPPAS00521", "XMLSTR", "", "", "false", "", "", "", "", "","", "case1", "", "", "", "1", "75");
						
						grd_rcpt.subtotalPosition = "below";
						//#c8e67b  
						grd_rcpt.subtotal("sum", -1, 1,  "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);
						grd_rcpt.subtotal("sum", -1, 2,  "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);	
						grd_rcpt.subtotal("sum", -1, 3,  "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);	
						grd_rcpt.subtotal("sum", -1, 4,  "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);	
						grd_rcpt.subtotal("sum", -1, 5,  "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);	
						grd_rcpt.subtotal("sum", -1, 6,  "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);	
						grd_rcpt.subtotal("sum", -1, 7,  "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);	
						grd_rcpt.subtotal("sum", -1, 8,  "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);	
						grd_rcpt.subtotal("sum", -1, 9,  "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);	
						grd_rcpt.subtotal("sum", -1, 10, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);	
						grd_rcpt.subtotal("sum", -1, 11, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);	
						grd_rcpt.subtotal("sum", -1, 12, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);	
						grd_rcpt.subtotal("sum", -1, 13, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);	
						grd_rcpt.subtotal("sum", -1, 14, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#fcd2c1; color:#0000; font-weight:bold; ", 0, "합계", false);	

					}
					
					//수납자별외래수입통계
					if(switch1.selectedIndex == "1") {
						submit("TRPAS00522");
						submit("TRPAS00543");
						
						grd_rcpt1.rebuildStyle();
						setRowStyle("grd_rcpt1" , "0" , "총계" , "col1", "equal" );   //총계 색깔 표시
						
						cash = parseInt(model.getvalue("/root/main/h_rcpt2/rcpt2[18]/col3" ));  //좌측 그리드   현금 - (은행입금액 +통장입금액 + 비고) 키인계산하기위해쓰임
						
						
						exeReportPreview("RPPAS00522", "XMLSTR", "", "", "false", "", "", "", "", "","", "case2", "", "", "", "1", "75");
					}
					
					model.refresh();
			}
			
		]]>
		</script>
	</xhtml:head>
	<xhtml:body pagewidth="1211" pageheight="784">
		<group id="group3" style="left:0px; top:0px; width:1211px; height:13px; ">
			<caption id="caption60" class="tit_1" style="left:0px; top:0px; width:215px; 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; "/>
			<caption id="caption2" class="search_name" style="left:10px; top:9px; width:70px; height:17px; ">일자:</caption>
			<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[						    
						
						fSearch();

					]]>
				</script>
			</button>
			<input id="input7" ref="/root/send/data1/fromdd" class="input_default" navindex="7" autonext="false" inputtype="date" style="left:75px; top:8px; width:85px; height:19px; text-align:center; "/>
			<button id="button95" class="btn6_letter4" style="left:976px; top:7px; width:80px; height:22px; ">
				<caption>액셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					var vToday = new Date();
					var tmpYear = vToday.getYear();
					var tmpMonth = vToday.getMonth()+1;
					var tmpDate = vToday.getDate();
					
//					
//					 model.setValue("/root/documenttitle/title",document.title);
//                                      model.refresh();
//					var  subjectTitle = model.getValue("/root/documenttitle/title");
					
						if(switch1.selectedIndex == "0") {
							//엑셀저장 여부(타이틀별)
							var fileName = window.fileDialog("save", "", false, "외래전체수입통계"+tmpYear+tmpMonth+tmpDate, "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
						
							if (fileName != "")
							{
								grd_rcpt2.saveExcel(fileName, "외래전체수입통계"+tmpYear+tmpMonth+tmpDate, true, true, "", "", true);
							}
						}	
						
						if(switch1.selectedIndex == "1") {
							//엑셀저장 여부(타이틀별)
							var fileName = window.fileDialog("save", "", false, "수납자별외래수입통계"+tmpYear+tmpMonth+tmpDate, "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
						
							if (fileName != "")
							{
								grd_rcpt1.saveExcel(fileName, "수납자별외래수입통계"+tmpYear+tmpMonth+tmpDate, true, true, "", "", true);
							}
						}
						
					]]>
				</script>
			</button>
			<line id="line1" class="line_4" visibility="hidden" style="x1:1063px; y1:7px; x2:1063px; y2:29px; border-color:#ffe4bb; border-left-style:solid; "/>
			<button id="btn_print" class="btn6_letter2" style="left:1070px; top:7px; width:56px; height:22px; ">
				<caption>출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						
						if(switch1.selectedIndex == "0") {
							exeReportPreview("RPPAS00521", "XMLSTR", "", "", "true", "", "", "", "", "","", "case2", "", "", "", "1", "75");
							
						}
						
						if(switch1.selectedIndex == "1") {
							exeReportPreview("RPPAS00522", "XMLSTR", "", "", "true", "", "", "", "", "","", "case2", "", "", "", "1", "75");
						}
					]]>
				</script>
			</button>
			<input id="input1" ref="/root/send/data1/tm_from" autonext="false" format="hh:nn" style="left:170px; top:8px; width:54px; height:19px; text-align:center; "/>
			<input id="input15" ref="/root/send/data1/tm_to" autonext="false" format="hh:nn" style="left:245px; top:8px; width:54px; height:19px; text-align:center; "/>
			<caption id="caption25" style="left:222px; top:10px; width:25px; height:14px; text-align:center; ">~</caption>
			<input id="input2" ref="/root/send/data1/rcpt_id" visibility="hidden" autonext="false" style="left:384px; top:8px; width:86px; height:19px; "/>
			<caption id="caption1" visibility="hidden" style="left:311px; top:9px; width:64px; height:20px; font-weight:bold; ">수납자ID :</caption>
		</group>
		<group id="grp_btn" scroll="auto" style="left:19px; top:757px; width:1180px; height:27px; "/>
		<button id="btn_init" class="btn4_letter3" style="left:1129px; top:760px; width:68px; height:22px; ">
			<caption>초기화</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
					fInitialize();
					]]>
			</script>
		</button>
		<switch id="switch1" style="left:5px; top:87px; width:1200px; height:655px; ">
			<case id="case1">
				<datagrid id="grd_rcpt" nodeset="/root/main/h_rcpt/rcpt" caption="수납자^접수^접수^예약^예약^수납^수납^선수금^선수금대체^선수금반환^미수금^미수입금^차상위^희귀난치^총계|수납자^건수^금액^건수^금액^건수^금액^선수금^선수금대체^선수금반환^미수금^미수입금^차상위^희귀난치^총계" colsep="^" colwidth="80, 43, 100, 46, 100, 40, 100, 80, 80, 80, 80, 80, 75, 75, 122" mergecellsfixedrows="bycolrec" rowsep="|" style="left:5px; top:5px; width:1185px; height:635px; ">
					<col ref="rcpt_rcptrnm"/>
					<col ref="rcpt_ojamt_cnt" format="#,###" style="text-align:right; "/>
					<col ref="rcpt_ojamt" format="(-)#,###" style="text-align:right; "/>
					<col ref="rcpt_rsrv_cnt" format="#,###" style="text-align:right; "/>
					<col ref="rcpt_rsrv" format="(-)#,###" style="text-align:right; "/>
					<col ref="rcpt_rcptamt_cnt" format="#,###" style="text-align:right; "/>
					<col ref="rcpt_rcptamt" format="(-)#,###" style="text-align:right; "/>
					<col ref="rcpt_bogjamt" format="(-)#,###" style="text-align:right; "/>
					<col ref="rcpt_bogjaltamt" format="(-)#,###" style="text-align:right; "/>
					<col ref="rcpt_bogjrtnamt" format="(-)#,###" style="text-align:right; "/>
					<col ref="rcpt_unco" format="(-)#,###" style="text-align:right; "/>
					<col ref="rcpt_uncr" format="(-)#,###" style="text-align:right; "/>
					<col ref="rcpt_rareobstamt" format="(-)#,###" style="text-align:right; "/>
					<col ref="rcpt_suppamt" format="(-)#,###" style="text-align:right; "/>
					<col ref="rcpt_sum" format="(-)#,###" style="text-align:right; "/>
					<script type="javascript" ev:event="ondblclick">
						<![CDATA[
						if (isDataCell() == true) {
							
							var temp = grd_rcpt.row -1;
							model.setvalue("/root/send/data1/rcpt_id", model.getvalue("/root/main/h_rcpt/rcpt["+temp+"]/rcpt_rcptrid") );
							input2.refresh();
							btn_rcptid.dispatch("onclick");
							fSearch();
						}
						]]>
					</script>
				</datagrid>
			</case>
			<case id="case2" selected="true">
				<datagrid id="grd_rcpt1" nodeset="/root/main/h_rcpt2/rcpt2" caption="항목^건수^금액" colsep="^" colwidth="109, 60, 117" mergecellsfixedrows="bycolrec" rowsep="|" style="left:5px; top:7px; width:290px; height:641px; ">
					<col ref="col1" style="text-align:left; padding-left:10; "/>
					<col ref="col2" type="input" style="text-align:center; "/>
					<col ref="col3" type="input" format="(-)#,###" style="text-align:right; "/>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
						
						//if(grd_rcpt1.col=="1"  && grd_rcpt1.row=="4" ){
							
							var temp = 0;
							
							for(var a=1; a < 11 ; a++) {
								
								//9는 미수금 미수금은 총계에서 제외
								if(a != 9) {  temp = parseInt(model.getvalue("/root/main/h_rcpt2/rcpt2["+a+"]/col2")) + temp;
								}
								
							}
							model.setvalue("/root/main/h_rcpt2/rcpt2[11]/col2" , temp);
						//}	
						
						
						//if(grd_rcpt1.col=="2"  && grd_rcpt1.row=="4" ){
							
							var temp = 0;
							
							for(var a=1; a < 11 ; a++) {
								
								//9는 미수금 미수금은 총계에서 제외
								if(a != 9) {temp = parseInt(model.getvalue("/root/main/h_rcpt2/rcpt2["+a+"]/col3")) + temp;
								}
							}
							model.setvalue("/root/main/h_rcpt2/rcpt2[11]/col3" , temp);
						//}
						
						//좌측 그리드   현금 - (은행입금액 +통장입금액 + 비고) 키인계산하기위해쓰임
						var temp = cash;
							
						temp = temp - parseInt(model.getvalue("/root/main/h_rcpt2/rcpt2[14]/col3"))
						                  - parseInt(model.getvalue("/root/main/h_rcpt2/rcpt2[15]/col3"))
						                  - parseInt(model.getvalue("/root/main/h_rcpt2/rcpt2[16]/col3"));
						                  
						model.setvalue("/root/main/h_rcpt2/rcpt2[18]/col3" , temp);
						//좌측 그리드 계산끝
						
						
						model.refresh();
						exeReportPreview("RPPAS00522", "XMLSTR", "", "", "false", "", "", "", "", "","", "case2", "", "", "", "1", "75");
						
						]]>
					</script>
					<script type="javascript" ev:event="ondblclick">
						<![CDATA[
						if (isDataCell() == true) {
							
							if(grd_rcpt1.col=="0" && grd_rcpt1.row < "11"  ) {
								
								model.setvalue("/root/send/data1/rcpt_flag",model.getvalue("/root/main/h_rcpt2/rcpt2["+grd_rcpt1.row+"]/col1"));
								open("SMPAO00500"  , "", "" , "" , "" , "/root/send/data1" , "/root/temp/rcpt/data1");
								//open("SMPAO00500");
							
							}
						}
						]]>
					</script>
				</datagrid>
			</case>
			<case id="case3"/>
		</switch>
		<button id="button3" class="btn_sw" disabled="true" group="tab" style="left:325px; top:65px; width:160px; height:22px; ">
			<caption>3.무인수납 사용 현황3</caption>
			<toggle case="case3" ev:event="onclick"/>
			<script type="javascript" ev:event="onclick">
				<![CDATA[
				]]>
			</script>
		</button>
		<button id="btn_rcptid" class="btn_sw" group="tab" style="left:165px; top:65px; width:160px; height:22px; ">
			<caption>2.수납자별 외래 수입통계</caption>
			<toggle case="case2" ev:event="onclick"/>
			<script type="javascript" ev:event="onclick">
				<![CDATA[	
				caption1.visible = true;
				input2.visible = true;
				exeReportPreview("RPPAS00522", "XMLSTR", "", "", "false", "", "", "", "", "","", "case2", "", "", "", "1", "75");
				
				]]>
			</script>
		</button>
		<button id="btn_all" class="btn_sw" group="tab" style="left:5px; top:65px; width:160px; height:22px; ">
			<caption>1.전체 외래 수입통계</caption>
			<toggle case="case1" ev:event="onclick"/>
			<script type="javascript" ev:event="onclick">
				<![CDATA[
				caption1.visible = false;
				input2.visible = false;
				
				]]>
			</script>
		</button>
	</xhtml:body>
</xhtml:html>