YNU_JEUS/app_home/himed/webapps/pam/planteamstatsweb/xrw/SMPAS01330_의사별지정진료수익내역.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>
						<medicalexamamtlist>
							<medicalexamamtstats>
								<depthngnm/>
								<cdnm/>
								<orddrid/>
								<usernm/>
								<otspecamt/>
								<otordamt/>
								<otspecps/>
								<otnomlps/>
								<inspecamt/>
								<inordamt/>
								<inspecps/>
								<innomlps/>
							</medicalexamamtstats>
						</medicalexamamtlist>
						<search>
							<fromdata/>
							<todata/>
							<datagubun>Per</datagubun>
							<erdata>1</erdata>
							<dcgubun>A</dcgubun>
						</search>
						<medicalsumlist>
							<medicalsumstats>
								<depthngnm>총계</depthngnm>
								<cdnm/>
								<orddrid/>
								<usernm/>
								<otspecamt/>
								<otordamt/>
								<otspecps/>
								<otnomlps/>
								<inspecamt/>
								<inordamt/>
								<inspecps/>
								<innomlps/>
							</medicalsumstats>
						</medicalsumlist>
						<userinfo>
							<info>
								<user/>
							</info>
						</userinfo>
					</main>
					<send>
						<fromdata/>
						<todata/>
						<datagubun/>
						<erdata/>
						<dcgubun/>
					</send>
				</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/main/search/fromdata", tmpYear+""+tmpMonth+""+tmpDate);
				model.setValue("/root/main/search/todata", tmpYear+""+tmpMonth+""+tmpDate);
				
				//Rexport에 출력날자를 보여주기위한 데이터 저장
				model.makeNode("/root/main/tmp/print/date");
				model.copyNode("/root/main/tmp/print/date", "/root/main/search/fromdata");
				model.setValue("/root/main/tmp/print/date", model.getValue("/root/main/search/fromdata"));
				
				input7.refresh();
				input1.refresh();
				
				submit("TRPAS01332");
				model.setValue("/root/main/hospitalname/codename/cenm",model.getValue("/root/main/hospitalname/codename/cenm"));
				model.refresh();
				
				//데이터 Sorting 소계 (문제로 인해수 지음)
				//datagrid1.explorerbar = "sort";
			
				]]>
			</script>
			<bind id="bind1" ref="/root/main/medicalexamamtlist/medicalexamamtstats" calculate="now() + ."/>
			<bind id="bind2" ref="/root/main/medicalsumlist/medicalsumstats/otspecamt" calculate="sum(/root/main/medicalexamamtlist/medicalexamamtstats/otspecamt);"/>
			<bind id="bind3" ref="/root/main/medicalsumlist/medicalsumstats/otordamt" calculate="sum(/root/main/medicalexamamtlist/medicalexamamtstats/otordamt);"/>
			<bind id="bind4" ref="/root/main/medicalsumlist/medicalsumstats/otspecps" calculate="sum(/root/main/medicalexamamtlist/medicalexamamtstats/otspecps);"/>
			<bind id="bind5" ref="/root/main/medicalsumlist/medicalsumstats/otnomlps" calculate="sum(/root/main/medicalexamamtlist/medicalexamamtstats/otnomlps);"/>
			<bind id="bind6" ref="/root/main/medicalsumlist/medicalsumstats/inspecamt" calculate="sum(/root/main/medicalexamamtlist/medicalexamamtstats/inspecamt);"/>
			<bind id="bind7" ref="/root/main/medicalsumlist/medicalsumstats/inordamt" calculate="sum(/root/main/medicalexamamtlist/medicalexamamtstats/inordamt);"/>
			<bind id="bind8" ref="/root/main/medicalsumlist/medicalsumstats/inspecps" calculate="sum(/root/main/medicalexamamtlist/medicalexamamtstats/inspecps);"/>
			<bind id="bind9" ref="/root/main/medicalsumlist/medicalsumstats/innomlps" calculate="sum(/root/main/medicalexamamtlist/medicalexamamtstats/innomlps);"/>
			<submission id="TRPAS01331" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/main/data1"/>
			<submission id="TRPAS01332" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/main/data1"/>
			<submission id="TRPAS00001" mediatype="application/x-www-form-urlencoded" method="post" replace="instance" resultref="/root/main/userinfo/info/user"/>
		</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">
		<group id="group3" style="left:0px; top:0px; width:1211px; height:13px; ">
			<caption id="caption60" class="tit_1" style="left:0px; top:0px; width:190px; 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[						    
						var  fromdata =  model.getValue("/root/main/search/fromdata");
						var  todata     =  model.getValue("/root/main/search/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.setValue("/root/send/fromdata",model.getValue("/root/main/search/fromdata"));	
							model.setValue("/root/send/todata",model.getValue("/root/main/search/todata"));			
							model.setValue("/root/send/datagubun",model.getValue("/root/main/search/datagubun"));			
							model.setValue("/root/send/erdata",model.getValue("/root/main/search/erdata"));
							model.setValue("/root/send/dcgubun",model.getValue("/root/main/search/dcgubun"));			
							
							
							//로드값이 있을때  엑셀저장여부 버튼 생성여부
							var nodelist = bind1.nodeset;
							if(nodelist.length>0){
								line1.visible  =true;
								button95.visible = true;
							}else{
								line1.visible  =false;
								button95.visible = false;	
							}
							
							model.resetInstanceNode("/root/main/medicalexamamtlist");
							model.removeNode("/root/main/medicalexamamtlist");
							model.makeNode("/root/main/medicalexamamtlist");
							
							submit("TRPAS01331");
							
				
							//서브토탈 소계값 출력그리드 위치 (“above:상단에 삽입  “below: 하단에 삽입)
							datagrid1.subtotalposition="below"; 
							
							//데이터그리드 컬럼개수구하기
							var cols = datagrid1.cols-datagrid1.fixedCols;
							
							//서브토탈  초기화 subtotal("clear":초기화)
							datagrid1.subtotal("clear", 0, i, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ffff00; color:#0000ff; font-weight:bold; ", 0, "소계", true); 
							
							//총계합
							copyNodesetType("/root/main/medicalexamamtlist/medicalexamamtstats","/root/main/medicalsumlist/medicalsumstats","after");	
							
							//서브미션2회이상 할때 데이터 그리그 초기화  * 단 rebuild 했을경우 서브토탈이 Node에 없기때문에 나오지 않음
							datagrid1.rebuild();
							
							
							//서브토탈 subtotal("sum":합계    0:기준열  i:합계위치) **기타 인자값은 help참조 
							var datagubn = model.getValue("/root/main/search/datagubun");
							
							if (datagubn == 'Per') {
								for( var i = 4; i < cols; i++ ) {
									datagrid1.subtotal("sum", 0, i, "format:#,###; roundmode:round; roundpostion:2", "background-color:#daecfd; color:#333333; font-weight:soild; ", 0, "소계", true);
								}
							}
							
							//소계 및 통계 datagrid의 cell에서 merge 
							var rows = datagrid1.rows-datagrid1.fixedRows;
							for(var i=0;i<=rows;i++){
								var value = datagrid1.valueMatrix(i+1,0);
								if(value =="소계" || value=="총계"){
									datagrid1.mergeByFree(i+1,0,i+1,3);	
								}else{
								}
							}
							//subtotal()함수를 쓰면 맨 밑에 총계의 소계가 또 나오는데 그걸 삭제 해주는 함수
							if (datagubn == 'Per') datagrid1.removeRow(false)
							//datagrid 재 생성
							datagrid1.refresh();

						}	
						
					]]>
				</script>
			</button>
			<input id="input7" ref="/root/main/search/fromdata" class="input_default" navindex="7" inputtype="date" style="left:70px; top:9px; width:120px; height:19px; ">
				<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/main/search/todata" class="input_default" navindex="7" inputtype="date" style="left:215px; top:9px; width:120px; height:19px; ">
				<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>
			<select1 id="radio1" ref="/root/main/search/dcgubun" appearance="full" cellspacing="8" cols="3" overflow="visible" style="left:595px; top:9px; width:160px; height:19px; border-style:none; ">
				<choices>
					<item>
						<label>ALL</label>
						<value>A</value>
					</item>
					<item>
						<label>특진</label>
						<value>S</value>
					</item>
					<item>
						<label>일반</label>
						<value>C</value>
					</item>
				</choices>
			</select1>
			<caption id="caption5" style="left:535px; top:11px; width:54px; height:14px; font-weight:bold; ">선택진료</caption>
			<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();
					
					
//					 model.setValue("/root/documenttitle/title",document.title);
//                                   model.refresh();
//					 var  subjectTitle = model.getValue("/root/documenttitle/title");
					
					//엑셀저장 여부(타이틀별)
					//강제 이름을 지정해야 서버에서 제대로 보입니다.
					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; "/>
			<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[
						//보고서 출력 exeReportPreview("RTPAS00160" : 보고서ID값 , "XMLSTR" :보고서출력방법(xml형태)) 
						exeReportPreview("RPPAS01331", "XMLSTR", "","", "false","","","","","false");	
					]]>
				</script>
			</button>
			<select1 id="combo1" ref="/root/main/search/datagubun" appearance="minimal" style="left:411px; top:9px; width:100px; height:19px; ">
				<choices>
					<item>
						<label>개인별</label>
						<value>Per</value>
					</item>
					<item>
						<label>과별</label>
						<value>Par</value>
					</item>
				</choices>
			</select1>
			<caption id="caption1" style="left:349px; top:11px; width:54px; height:14px; font-weight:bold; ">검색조건</caption>
		</group>
		<datagrid id="datagrid1" nodeset="/root/main/medicalexamamtlist/medicalexamamtstats" caption="진료과^직위^의사ID^의사명^외래수익^외래수익^외래환자수^외래환자수^입원수익^입원수익^입원환자수^입원환자수|진료과^직위^의사ID^의사명^지정진료수익^의료수익^특진환자^일반환자^지정진료수익^의료수익^특진환자^일반환자" colsep="^" colwidth="120, 85, 85, 90, 100, 100, 100, 100, 100, 100, 100, 100" mergecellsfixedcols="bycol" mergecellsfixedrows="byrowrec" rowsep="|" style="left:5px; top:85px; width:1200px; height:681px; ">
			<col ref="depthngnm" style="text-align:center; "/>
			<col ref="cdnm" style="text-align:center; "/>
			<col ref="orddrid" style="text-align:center; "/>
			<col ref="usernm" style="text-align:center; "/>
			<col ref="otspecamt" format="(-)#,###" style="text-align:right; "/>
			<col ref="otordamt" format="(-)#,###" style="text-align:right; "/>
			<col ref="otspecps" format="(-)#,###" style="text-align:right; "/>
			<col ref="otnomlps" format="(-)#,###" style="text-align:right; "/>
			<col ref="inspecamt" format="(-)#,###" style="text-align:right; "/>
			<col ref="inordamt" format="(-)#,###" style="text-align:right; "/>
			<col ref="inspecps" format="(-)#,###" style="text-align:right; "/>
			<col ref="innomlps" format="(-)#,###" style="text-align:right; "/>
		</datagrid>
		<caption id="caption6" style="left:7px; top:70px; width:95px; height:20px; ">가톨릭대학교  :</caption>
		<output id="output1" ref="/root/main/hospitalname/codename/cenm" style="left:100px; top:70px; width:100px; height:19px; font-weight:bold; "/>
	</xhtml:body>
</xhtml:html>