YNU_JEUS/app_home/himed/webapps/ast/examcurestatsweb/xrw/SMAES01200_재활의학팀평균부도건수.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?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>
						<list>
							<item>
								<curerm/>
								<inrsrvcnt/>
								<outrsrvcnt/>
								<sumrsrv/>
								<intestexeccnt/>
								<outtestexeccnt/>
								<sumprcp/>
								<innopaycnt/>
								<outnopaycnt/>
								<sumnopay/>
								<inmonthsum/>
								<outmonthsum/>
								<monthsum/>
								<inpaycnt/>
								<outpaycnt/>
								<paycnt/>
								<incomparerate/>
								<outcomparerate/>
								<comparerate/>
							</item>
						</list>
					</main>
					<send>
						<srchdate/>
						<globalinstance>
							<instance1/>
						</globalinstance>
						<suppdeptcd/>
						<execfromdd/>
						<exectodd/>
						<comparefromdd/>
						<comparetodd/>
						<orddeptcd/>
						<fstpatyn/>
						<curerm/>
						<curedr/>
						<prcpcd/>
						<execdrid/>
						<srchflag/>
					</send>
					<inti/>
					<hidden/>
				</root>
			</instance>
			<script type="javascript" src="../../../com/commonweb/js/common.js"/>
			<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/numericHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
			<script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
			<script type="javascript" src="../../../ast/examcureweb/js/AEZ0001.js"/>
			<submission id="TRPMOCOM01" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/hidden/session" replace="instance" resultref="/root/init"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[			
					
					aezfSetSuppDeptcd();
					
					// 진료과/진료의 조회
//					submit("TRPMOCOM01", false);
					submit("TRAES09000", false);
					model.setValue("/root/send/suppdeptcd", model.getValue("/root/send/globalinstance/instance1"));
					
					var fromdd = getCurrentDate().substr(0,4) + "0101"
					var todd = getCurrentDate().substr(0,6) + fromdd.toDate().getMonthDay();
					var comparefromdd = getCurrentDate().substr(0,6).toDate().getAddDate(0,"Y").getDateFormat("YYYY") +  "0101";
					var comparetodd = comparefromdd.substr(0,4) + todd.substr(4,4);
					
					addComboItem("cmb_orddept","--전체--","","above");
					addComboItem("cmb_curerm","--전체--","","above");
					addComboItem("cmb_execdrid","--전체--","","above");
					
					model.removenode("/root/main/list");
					model.setValue("/root/send/srchflag","T");
					model.setValue("/root/send/execfromdd", fromdd);
					model.setValue("/root/send/exectodd", todd);
					model.setValue("/root/send/comparefromdd",comparefromdd);
					model.setValue("/root/send/comparetodd",comparetodd);
					model.refresh();
				]]>
			</script>
			<submission id="TRAES09000" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/inti"/>
			<submission id="TRAES01201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/main/list"/>
		</model>
		<script type="javascript">
			<![CDATA[
				function setRound(str){
//					var str2 = round(str, 2);
					return str2;
				}
			]]>
		</script>
	</xhtml:head>
	<xhtml:body pagewidth="1211" pageheight="784" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="grp_tle" style="left:0px; top:0px; width:1195px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:200px; height:14px; ">재활의학팀평균부도건수</caption>
		</group>
		<group id="grp_biz" scroll="auto" style="left:0px; top:13px; width:1195px; height:744px; ">
			<caption id="caption1" class="tit_2" style="left:5px; top:80px; width:200px; height:13px; ">재활의학팀평균부도건수</caption>
			<button id="btn_excsave" class="btn2_letter4" visibility="hidden" style="left:1130px; top:45px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var fileName = window.fileDialog("save", ",", false, "", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");	
						if (fileName != "") {
							grd_list.saveExcel(fileName);
						}
					]]>
				</script>
			</button>
			<group id="grp_sea" style="left:0px; top:10px; width:1195px; height:60px; vertical-align:top; ">
				<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1193px; height:60px; background-color:#fffbf2; border-color:#ffd799; "/>
				<caption id="caption2" class="search_name" style="left:15px; top:9px; width:86px; height:17px; ">조회기간 :</caption>
				<line id="line13" class="line_4" style="x1:1110px; y1:7px; x2:1110px; y2:52px; "/>
				<button id="btn_sea" class="btn1_letter2" navindex="4" style="left:1120px; top:20px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							model.removenode("/root/main/list");
							
							if (submit("TRAES01201")) {
							
								var cnt = getNodesetCount("/root/main/list/item");
								if (cnt > 1) {
									grd_list.subtotal("sum", -1, 1, "#,###", "background-color:#99ff99", 0, "합계");
									for(i=2; i<grd_list.colRef("inpaycnt"); i++) {
										grd_list.subtotal("sum", -1, i, "(-)#,###");
									}

									var inrsrvcnt = grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("inrsrvcnt"));
									var innopaycnt = grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("innopaycnt"));
									var innopayrate = ( parseInt(innopaycnt) / parseInt(inrsrvcnt) ) *100;
									
									var outrsrvcnt = grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("outrsrvcnt"));
									var outnopaycnt = grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("outnopaycnt"));
									var outnopayrate = ( parseInt(outnopaycnt) / parseInt(outrsrvcnt) ) *100;
									
									var sumrsrv = grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("sumrsrv"));
									var sumnopay = grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("sumnopay"));
									var sumnopayrate = ( parseInt(sumnopay) / parseInt(sumrsrv) ) *100;
									
									if(innopayrate != null) {
										//grd_list.valueMatrix(grd_list.rows-1, 11) = nopayrate;
										grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("inpaycnt")) = innopayrate.toString().getRound(-1,"HALF_UP");
									} else  {
										grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("inpaycnt")) = 0;
									}
									grd_list.cellformat (grd_list.rows-1, grd_list.colRef("inpaycnt")) = "(-)#,###.#%"; 
									
									if(outnopayrate != null) {
										//grd_list.valueMatrix(grd_list.rows-1, 11) = nopayrate;
										grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("outpaycnt")) = outnopayrate.toString().getRound(-1,"HALF_UP");
									} else {
										grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("outpaycnt")) = 0;
									}
									grd_list.cellformat (grd_list.rows-1, grd_list.colRef("outpaycnt")) = "(-)#,###.#%"; 
									
									if(sumnopayrate != null) {
										//grd_list.valueMatrix(grd_list.rows-1, 11) = nopayrate;
										grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("paycnt")) = sumnopayrate.toString().getRound(-1,"HALF_UP");
									} else {
										grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("paycnt")) = 0;
									}
									grd_list.cellformat (grd_list.rows-1, grd_list.colRef("paycnt")) = "(-)#,###.#%"; 
									
									var intestexeccnt = grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("intestexeccnt"));
									var insumcnt = grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("insumcnt"));		
									
									var outtestexeccnt = grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("outtestexeccnt"));
									var outsumcnt = grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("outsumcnt"));		
									
									var sumprcp = grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("sumprcp"));
									var sumcnt = grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("sumcnt"));							
									
									var incomparerate = ( ( parseInt(intestexeccnt) - parseInt(insumcnt) ) / parseInt(intestexeccnt) ) * 100;
									var outcomparerate = ( ( parseInt(outtestexeccnt) - parseInt(outsumcnt) ) / parseInt(outtestexeccnt) ) * 100;
									var comparerate = ( ( parseInt(sumprcp) - parseInt(sumcnt) ) / parseInt(sumprcp) ) * 100;
										
									if ( parseInt(incomparerate) > 0 ) {
										grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("incomparerate")) = incomparerate.toString().getRound(-1,"HALF_UP");
									} else {
										grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("incomparerate")) = 0;
									}
									grd_list.cellformat (grd_list.rows-1, grd_list.colRef("incomparerate")) = "(-)#,###.#%"; 
									
									if (parseInt(outcomparerate) > 0 ) {
										grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("outcomparerate")) = outcomparerate.toString().getRound(-1,"HALF_UP");
									} else {
										grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("outcomparerate")) = 0;
									}
									grd_list.cellformat (grd_list.rows-1, grd_list.colRef("outcomparerate")) = "(-)#,###.#%"; 
									
									if (parseInt(comparerate ) > 0 ) {
										grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("comparerate")) = comparerate.toString().getRound(-1,"HALF_UP");
									} else {
										grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("comparerate")) = 0;
									}	
									grd_list.cellformat (grd_list.rows-1, grd_list.colRef("comparerate")) = "(-)#,###.#%"; 
								}
							}
						]]>
					</script>
				</button>
				<input id="ipt_todd" ref="/root/send/exectodd" class="input_default" navindex="2" inputtype="date" style="left:227px; top:9px; width:100px; height:19px; text-align:center; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							var exectodd =  model.getValue("/root/send/exectodd");
							var execfromdd =  model.getValue("/root/send/execfromdd");
							if (execfromdd > exectodd) {
								messageBox("조회기간 종료일자가 조회기간 시작일자 이전 일자입니다.", "I");
								model.setValue("/root/send/exectodd",execfromdd);
								exectodd = execfromdd;
							}
							
//							var comparetodd = exectodd.toDate().getAddDate(-1,"Y").getDateFormat("YYYYMMDD");
//							model.setValue("/root/send/comparetodd",comparetodd);

							model.refresh();
						]]>
					</script>
				</input>
				<caption id="caption5" class="search_noutb" style="left:212px; top:10px; width:12px; height:17px; ">~</caption>
				<input id="ipt_fromdd" ref="/root/send/execfromdd" class="input_default" navindex="1" inputtype="date" style="left:109px; top:9px; width:100px; height:19px; text-align:center; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							var execfromdd =  model.getValue("/root/send/execfromdd");
							var exectodd =  model.getValue("/root/send/exectodd");
							if (execfromdd > exectodd) {
								messageBox("조회기간 시작일자가 조회기간 종료일자 이후 일자입니다.", "I");
								model.setValue("/root/send/execfromdd",exectodd);
								execfromdd = exectodd;
							} 
							
//							var comparefromdd = execfromdd.toDate().getAddDate(-1,"Y").getDateFormat("YYYYMMDD");
//							model.setValue("/root/send/comparefromdd",comparefromdd);

							model.refresh();
						]]>
					</script>
				</input>
				<caption id="caption3" class="search_name" style="left:15px; top:33px; width:86px; height:17px; ">비교기간 :</caption>
				<input id="input1" ref="/root/send/comparetodd" class="input_default" navindex="2" inputtype="date" style="left:227px; top:33px; width:100px; height:19px; text-align:center; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							var comparefromdd =  model.getValue("/root/send/comparefromdd");
							var comparetodd =  model.getValue("/root/send/comparetodd");
							if (comparefromdd > comparetodd) {
								messageBox("비교조회기간 종료일자가 비교조회기간 시작일자 이전 일자입니다.", "I");
								model.setValue("/root/send/comparetodd",comparefromdd);
								comparetodd = comparefromdd;
							}
							
//							var exectodd = comparetodd.toDate().getAddDate(1,"Y").getDateFormat("YYYYMMDD");
//							model.setValue("/root/send/exectodd",exectodd);

							model.refresh();
						]]>
					</script>
				</input>
				<caption id="caption4" class="search_noutb" style="left:212px; top:33px; width:12px; height:17px; ">~</caption>
				<input id="input2" ref="/root/send/comparefromdd" class="input_default" navindex="1" inputtype="date" style="left:109px; top:33px; width:100px; height:19px; text-align:center; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							var comparefromdd =  model.getValue("/root/send/comparefromdd");
							var comparetodd =  model.getValue("/root/send/comparetodd");
							if (comparefromdd > comparetodd) {
								messageBox("비교조회기간 시작일자가 비교조회기간 종료일자 이후 일자입니다.", "I");
								model.setValue("/root/send/comparefromdd",comparetodd);
								comparefromdd = comparetodd;
							} 
							
//							var execfromdd = comparefromdd.toDate().getAddDate(1,"Y").getDateFormat("YYYYMMDD");
//							model.setValue("/root/send/execfromdd",execfromdd);

							model.refresh();
						]]>
					</script>
				</input>
				<caption id="caption7" class="search_name" style="left:380px; top:10px; width:86px; height:17px; ">처방과 :</caption>
				<caption id="caption8" class="search_name" style="left:620px; top:10px; width:86px; height:17px; ">치 료 실 :</caption>
				<caption id="caption10" class="search_name" visibility="hidden" style="left:620px; top:33px; width:86px; height:17px; ">처방코드 :</caption>
				<select1 id="cmb_orddept" ref="/root/send/orddeptcd" appearance="minimal" itemcount="10" style="left:460px; top:9px; width:115px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/orddeptcd">
							<label ref="nm"/>
							<value ref="cd"/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
//								cmb_orddr.choices.itemset.attribute("nodeset") = "/root/init/orddrid[dp = '"+ cmb_orddept.value +"']";				
//								cmb_orddr.refresh();
						]]>
					</script>
				</select1>
				<select1 id="cmb_curerm" ref="/root/send/curerm" appearance="minimal" itemcount="10" style="left:710px; top:9px; width:115px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/curerm">
							<label ref="nm"/>
							<value ref="cd"/>
						</itemset>
					</choices>
				</select1>
				<select1 id="cmb_execdr" ref="/root/send/prcpcd" visibility="hidden" appearance="minimal" itemcount="10" style="left:710px; top:33px; width:290px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/prcpcd">
							<label ref="nm"/>
							<value ref="cd"/>
						</itemset>
					</choices>
				</select1>
				<select1 id="cmb_execdrid" ref="/root/send/execdrid" appearance="minimal" itemcount="10" style="left:460px; top:33px; width:115px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/execdrid">
							<label ref="nm"/>
							<value ref="cd"/>
						</itemset>
					</choices>
				</select1>
				<caption id="caption9" class="search_name" style="left:380px; top:33px; width:78px; height:17px; ">치료사 :</caption>
			</group>
			<line id="line1" class="line_1" style="x1:0px; y1:95px; x2:1195px; y2:95px; "/>
			<datagrid id="grd_list" nodeset="/root/main/list/item" caption="치료실^예약건수(당일포함)^예약건수(당일포함)^예약건수(당일포함)^치료건수^치료건수^치료건수^부도건수^부도건수^부도건수^합계^합계^합계^입원비교기간건수^외래비교기간건수^전체비교기간건수^부도율^부도율^부도율^증감율^증감율^증감율|치료실^입원^외래^전체^입원^외래^전체^입원^외래^전체^입원^외래^전체^입원비교기간건수^외래비교기간건수^전체비교기간건수^입원^외래^전체^입원^외래^전체" colsep="^" colwidth="140, 57, 57, 57, 57, 57, 57, 57, 57, 57, 65, 65, 65, 100, 100, 100, 57, 57, 57, 57, 57, 57" mergecellsfixedrows="bycolrec" rowsep="|" subtotalposition="below" style="left:0px; top:100px; width:1195px; height:640px; ">
				<col ref="curerm"/>
				<col ref="inrsrvcnt" format="(-)#,###" style="text-align:right; "/>
				<col ref="outrsrvcnt" format="(-)#,###" style="text-align:right; "/>
				<col ref="sumrsrv" format="(-)#,###" style="text-align:right; "/>
				<col ref="intestexeccnt" format="(-)#,###" style="text-align:right; "/>
				<col ref="outtestexeccnt" format="(-)#,###" style="text-align:right; "/>
				<col ref="sumprcp" format="(-)#,###" style="text-align:right; "/>
				<col ref="innopaycnt" format="(-)#,###" style="text-align:right; "/>
				<col ref="outnopaycnt" format="(-)#,###" style="text-align:right; "/>
				<col ref="sumnopay" format="(-)#,###" style="text-align:right; "/>
				<col ref="inmonthsum" format="(-)#,###" style="text-align:right; "/>
				<col ref="outmonthsum" format="(-)#,###" style="text-align:right; "/>
				<col ref="monthsum" format="(-)#,###" style="text-align:right; "/>
				<col ref="insumcnt" visibility="hidden"/>
				<col ref="outsumcnt" visibility="hidden"/>
				<col ref="sumcnt" visibility="hidden"/>
				<col ref="inpaycnt" format="(-)#,###.#%" style="text-align:right; "/>
				<col ref="outpaycnt" format="(-)#,###.#%" style="text-align:right; "/>
				<col ref="paycnt" format="(-)#,###.#%" style="text-align:right; "/>
				<col ref="incomparerate" format="(-)#,###.#%" style="text-align:right; "/>
				<col ref="outcomparerate" format="(-)#,###.#%" style="text-align:right; "/>
				<col ref="comparerate" format="(-)#,###.#%" style="text-align:right; "/>
			</datagrid>
			<button id="button1" class="btn2_letter4" style="left:1131px; top:75px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var fileName = window.fileDialog("save", ",", false, "", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");	
						if (fileName != "") {
							grd_list.saveExcel(fileName);
						}
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>