YNU_JEUS/app_home/himed/webapps/pam/planteamstatsweb/xrw/SMPAS01180_외래환자현황.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="">
					<main>
						<interpathamtlist>
							<interpathamtstats>
								<depthngnm/>
								<insukind/>
								<pid/>
								<hangnm/>
								<allamt/>
								<ownbamt/>
								<insubamt/>
								<ordsunsuamt/>
								<ordsunsurtnamt/>
								<outsunsuamt/>
								<outsunsurtnamt/>
								<uncoinamt/>
								<ordsunsualt/>
								<nineafter/>
								<uncoenuri/>
								<restamt/>
								<jasunamt/>
								<uncoredu/>
								<uncoblod/>
								<uncocard/>
							</interpathamtstats>
						</interpathamtlist>
						<search>
							<fromdata/>
							<todata/>
							<datagubun>1</datagubun>
							<erdata>1</erdata>
							<dcgubun>D</dcgubun>
						</search>
						<intersumamtlist>
							<intersumamtstats>
								<depthngnm>총계</depthngnm>
								<insukind/>
								<pid/>
								<hangnm/>
								<allamt/>
								<ownbamt/>
								<insubamt/>
								<ordsunsuamt/>
								<ordsunsurtnamt/>
								<outsunsuamt/>
								<outsunsurtnamt/>
								<uncoinamt/>
								<ordsunsualt/>
								<nineafter/>
								<uncoenuri/>
								<restamt/>
								<jasunamt/>
								<uncoredu/>
								<uncoblod/>
								<uncocard/>
							</intersumamtstats>
						</intersumamtlist>
						<tmpinfo>
							<info>
								<user/>
							</info>
						</tmpinfo>
					</main>
					<send>
						<fromdata/>
						<todata/>
						<datagubun/>
						<erdata/>
						<dcgubun/>
						<offset/>
						<pagesize>100</pagesize>
					</send>
					<hidden>
						<session/>
					</hidden>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-model-construct-done">
				<![CDATA[
				submit("TRPAS00001");
				
				var vToday = new Date();
				var tmpYear = vToday.getYear();
				var tmpMonth = vToday.getMonth()+1;
				var tmpDate = vToday.getDate();
				
				if (tmpMonth < 10) { tmpMonth = "0"+tmpMonth; }
				if (tmpDate < 10) { tmpDate = "0"+tmpDate; }
				model.setValue("/root/send/fromdata", tmpYear+""+tmpMonth+""+tmpDate);
				model.setValue("/root/send/todata", tmpYear+""+tmpMonth+""+tmpDate);
				
				
				//Rexport에 출력날자를 보여주기위한 데이터 저장
				model.makeNode("/root/main/tmp/print/date");
				model.setValue("/root/main/tmp/print/date", model.getValue("/root/send/fromdata"));
				
				input7.refresh();
				input1.refresh();
				
				datagrid1.explorerbar = "sort";
				]]>
			</script>
			<bind id="bind1" ref="/root/main/interpathamtlist/interpathamtstats" calculate="now() + ."/>
			<bind id="bind2" ref="/root/main/intersumamtlist/intersumamtstats/allamt" calculate="sum(/root/main/interpathamtlist/interpathamtstats/allamt);"/>
			<bind id="bind3" ref="/root/main/intersumamtlist/intersumamtstats/allamt" calculate="sum(/root/main/interpathamtlist/interpathamtstats/allamt);"/>
			<bind id="bind4" ref="/root/main/intersumamtlist/intersumamtstats/ownbamt" calculate="sum(/root/main/interpathamtlist/interpathamtstats/ownbamt);"/>
			<bind id="bind5" ref="/root/main/intersumamtlist/intersumamtstats/insubamt" calculate="sum(/root/main/interpathamtlist/interpathamtstats/insubamt);"/>
			<bind id="bind6" ref="/root/main/intersumamtlist/intersumamtstats/ordsunsuamt" calculate="sum(/root/main/interpathamtlist/interpathamtstats/ordsunsuamt);"/>
			<bind id="bind7" ref="/root/main/intersumamtlist/intersumamtstats/ordsunsurtnamt" calculate="sum(/root/main/interpathamtlist/interpathamtstats/ordsunsurtnamt);"/>
			<bind id="bind8" ref="/root/main/intersumamtlist/intersumamtstats/outsunsuamt" calculate="sum(/root/main/interpathamtlist/interpathamtstats/outsunsuamt);"/>
			<bind id="bind9" ref="/root/main/intersumamtlist/intersumamtstats/outsunsurtnamt" calculate="sum(/root/main/interpathamtlist/interpathamtstats/outsunsurtnamt);"/>
			<bind id="bind10" ref="/root/main/intersumamtlist/intersumamtstats/uncoinamt" calculate="sum(/root/main/interpathamtlist/interpathamtstats/uncoinamt);"/>
			<bind id="bind11" ref="/root/main/intersumamtlist/intersumamtstats/ordsunsualt" calculate="sum(/root/main/interpathamtlist/interpathamtstats/ordsunsualt);"/>
			<bind id="bind12" ref="/root/main/intersumamtlist/intersumamtstats/nineafter" calculate="sum(/root/main/interpathamtlist/interpathamtstats/nineafter);"/>
			<bind id="bind13" ref="/root/main/intersumamtlist/intersumamtstats/uncoenuri" calculate="sum(/root/main/interpathamtlist/interpathamtstats/uncoenuri);"/>
			<bind id="bind14" ref="/root/main/intersumamtlist/intersumamtstats/restamt" calculate="sum(/root/main/interpathamtlist/interpathamtstats/restamt);"/>
			<bind id="bind15" ref="/root/main/intersumamtlist/intersumamtstats/jasunamt" calculate="sum(/root/main/interpathamtlist/interpathamtstats/jasunamt);"/>
			<bind id="bind16" ref="/root/main/intersumamtlist/intersumamtstats/uncoredu" calculate="sum(/root/main/interpathamtlist/interpathamtstats/uncoredu);"/>
			<bind id="bind17" ref="/root/main/intersumamtlist/intersumamtstats/uncoblod" calculate="sum(/root/main/interpathamtlist/interpathamtstats/uncoblod);"/>
			<bind id="bind18" ref="/root/main/intersumamtlist/intersumamtstats/uncocard" calculate="sum(/root/main/interpathamtlist/interpathamtstats/uncocard);"/>
			<submission id="TRPAS01181" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" add="bottom" resultref="/root/main/interpathamtlist/interpathamtstats"/>
			<submission id="TRPAS00001" mediatype="application/x-www-form-urlencoded" method="post" replace="instance" resultref="/root/main/tmpinfo/info/user"/>
		</model>
		<script type="javascript">
			<![CDATA[
				function fSubmitOnScroll() {
					if(datagrid1.vscroll.attribute("max") == datagrid1.vscroll.attribute("pos")) {
						// end of scroll
						model.setValue("/root/send/offset", datagrid1.rows - datagrid1.fixedRows); // grid의 header row는 제외
						submit("TRPAS01181");
						datagrid1.dispatch("onmouseup");  // 스크롤바 처리를 위한 이벤트 발생
					}
				}
			]]>
		</script>
		<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">
		<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:22px; 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:15px; top:9px; width:198px; height:17px; ">기간                           ~</caption>
			<line id="line2" class="line_4" style="x1:1130px; y1:7px; x2:1130px; 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[						    
						model.setValue("/root/send/offset","0");
						
						var  fromdata =  model.getValue("/root/send/fromdata");
						var  todata     =  model.getValue("/root/send/todata");
						
						if(fromdata==""||fromdata==null){
							messageBox("시작일을 입력","E007");
							model.setFocus("input7");
							return false;
						}
						if(todata==""|| todata==null){
							messageBox("끝일을 입력","E007");
							model.setFocus("input1");
							return false;
						}
						
						if(fromdata > todata){
							messageBox("시작일이 끝일자보다 클수 ", "C001")
							return false;
						}else{
							
							model.removeNodeset("/root/main/interpathamtlist/interpathamtstats");
							datagrid1.rebuild(); // delimeter grid 초기화.
							submit("TRPAS01181");							
							
							//로드값이 있을때  엑셀저장여부 버튼 생성여부
							var nodelist = bind1.nodeset;
							
							//if(nodelist.length>0 && nodelist.length < 100 ) {
								//총계 구한후 셋벨류(copyNodesetType("/root/":실데이트 Node값    ,"/root/: bind를 통해 합계구한Node, ,  위치:"after"데이트그리드 맨아래,"before"  데이트그리그 맨위,))
								copyNodesetType("/root/main/interpathamtlist/interpathamtstats","/root/main/intersumamtlist/intersumamtstats","after");	
								datagrid1.rebuild();
								
								//datagrid마직막에 총계 구하는것  merge
								var sumtotal = instance1.selectNodes("/root/main/interpathamtlist/interpathamtstats").length + datagrid1.fixedRows - 1;
								datagrid1.mergeByFree(sumtotal,1,sumtotal,4);
							//}						
						}				
					]]>
				</script>
			</button>
			<input id="input7" ref="/root/send/fromdata" class="input_default" navindex="7" inputtype="date" style="left:70px; top:8px; width:120px; height:19px; text-align:center; ">
				<script type="javascript" ev:event="onkeydown">
					<![CDATA[
								if( event.keyCode == 13 ) {
									
									var pCurTargetObj = event.ptarget.parent;
								
									if( pCurTargetObj.elementName == "xforms:select1" || pCurTargetObj.elementName == "xforms:select") {
										event.keyCode = 9;
										pCurTargetObj.dispatch("onkeydown");
									}
									else {
										event.keyCode = 9;	
									}
								}
								event.stopPropagation();							
							]]>
				</script>
			</input>
			<input id="input1" ref="/root/send/todata" class="input_default" navindex="7" inputtype="date" style="left:215px; top:8px; width:120px; height:19px; text-align:center; ">
				<script type="javascript" ev:event="onkeydown">
					<![CDATA[
								if( event.keyCode == 13 ) {
									
									var pCurTargetObj = event.ptarget.parent;
								
									if( pCurTargetObj.elementName == "xforms:select1" || pCurTargetObj.elementName == "xforms:select") {
										event.keyCode = 9;
										pCurTargetObj.dispatch("onkeydown");
									}
									else {
										
										event.keyCode = 9;	
									}
								}
								event.stopPropagation();							
							]]>
				</script>
			</input>
			<button id="button95" class="btn6_letter4" visibility="visible" style="left:971px; 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();
					
					if (tmpMonth < 10) { tmpMonth = "0"+tmpMonth; }
					if (tmpDate < 10) { tmpDate = "0"+tmpDate; }
					model.setValue("/root/send/fromdata", tmpYear+""+tmpMonth+""+tmpDate);
					model.setValue("/root/send/todata", tmpYear+""+tmpMonth+""+tmpDate);
					input7.refresh();
					input1.refresh();
					
					//엑셀저장 여부(타이틀별)
					var fileName = window.fileDialog("save", "", false, "외래환자현황"+tmpYear+tmpMonth+tmpDate, "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
					
						if (fileName != "")
						{
							
							datagrid1.saveExcel(fileName, "외래환자현황"+tmpYear+tmpMonth+tmpDate, true, true, "", "", true);
						}
					]]>
				</script>
			</button>
			<line id="line1" class="line_4" visibility="hidden" style="x1:1058px; y1:7px; x2:1058px; y2:29px; border-color:#ffe4bb; border-left-style:solid; "/>
		</group>
		<datagrid id="datagrid1" nodeset="/root/main/interpathamtlist/interpathamtstats" caption="진료과^유형^등록번호^환자명^시행처리^시행처리^시행처리^영수금액^영수금액^영수금액^영수금액^영수금액^처방선수대체^90일후선수금^매출에누리(할인)^절사차액^자선진료비^매출할인(감면)^혈액미수금^카드미수금|진료과^유형^등록번호^환자명^총진료비^본인부담금^보험자부담금^처방선수금^처방반환금^선수금^선수반환금^미수입금^처방선수대체^90일후선수금^매출에누리(할인)^절사차액^자선진료비^매출할인(감면)^혈액미수금^카드미수금" colsep="^" colwidth="138, 33, 80, 90, 110, 100, 100, 100, 100, 100, 100, 118, 100, 100, 100, 100, 100, 100, 100, 100" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:10px; top:69px; width:1198px; height:691px; ">
			<col ref="depthngnm" style="text-align:left; "/>
			<col ref="insukind" style="text-align:left; "/>
			<col ref="pid" style="text-align:center; "/>
			<col ref="hangnm" style="text-align:left; "/>
			<col ref="allamt" format="(-)#,###" style="text-align:right; "/>
			<col ref="ownbamt" format="(-)#,###" style="text-align:right; "/>
			<col ref="insubamt" format="(-)#,###" style="text-align:right; "/>
			<col ref="ordsunsuamt" format="(-)#,###" style="text-align:right; "/>
			<col ref="ordsunsurtnamt" format="(-)#,###" style="text-align:right; "/>
			<col ref="outsunsuamt" format="(-)#,###" style="text-align:right; "/>
			<col ref="outsunsurtnamt" format="(-)#,###" style="text-align:right; "/>
			<col ref="uncoinamt" format="(-)#,###" style="text-align:right; "/>
			<col ref="ordsunsualt" format="(-)#,###" style="text-align:right; "/>
			<col ref="nineafter" format="(-)#,###" style="text-align:right; "/>
			<col ref="uncoenuri" format="(-)#,###" style="text-align:right; "/>
			<col ref="restamt" format="(-)#,###" style="text-align:right; "/>
			<col ref="jasunamt" format="(-)#,###" style="text-align:right; "/>
			<col ref="uncoredu" format="(-)#,###" style="text-align:right; "/>
			<col ref="uncoblod" format="(-)#,###" style="text-align:right; "/>
			<col ref="uncocard" format="(-)#,###" style="text-align:right; "/>
			<script type="javascript" ev:event="onscroll">
				<![CDATA[
//					fSubmitOnScroll();
				]]>
			</script>
		</datagrid>
		<button id="btn_print" class="btn6_letter2" style="left:1070px; top:29px; width:56px; height:22px; ">
			<caption>출력</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
						exeReportPreview("RPPAS01181", "XMLSTR", "","", "false","","","","","false");	
					]]>
			</script>
		</button>
	</xhtml:body>
</xhtml:html>