YNU_JEUS/app_home/himed/webapps/ast/examcurestatsweb/xrw/SMAES02800_핵의학체내년도별통계.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>
								<excuroomnm/>
								<prcpnm/>
								<flag/>
								<year1/>
								<year2/>
								<year3/>
								<year4/>
								<year5/>
								<sumcnt/>
								<comparecnt/>
								<comparerate/>
							</item>
						</list>
						<curelist>
							<item>
								<ioflag/>
								<roomcd/>
								<drugqty/>
								<year1/>
								<year2/>
								<year3/>
								<year4/>
								<year5/>
								<sumcnt/>
								<comparecnt/>
								<comparerate/>
							</item>
						</curelist>
						<isublist>
							<item>
								<ioflag/>
								<drugqty/>
								<cnt/>
								<total/>
							</item>
						</isublist>
						<osublist>
							<item>
								<ioflag/>
								<drugqty/>
								<cnt/>
								<total/>
							</item>
						</osublist>
						<examsum>
							<isum/>
							<osum/>
							<total/>
						</examsum>
					</main>
					<send>
						<execfromyy/>
						<exectoyy/>
						<globalinstance>
							<instance1/>
						</globalinstance>
						<suppdeptcd/>
						<flag/>
						<excuroomgrpcdid/>
						<compareyy/>
					</send>
					<init>
						<cmb_lrgcd/>
						<cmb_mdlcd/>
					</init>
					<hidden>
						<comcd/>
					</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/dateHelper.js"/>
			<script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
			<script type="javascript" src="../../../ast/examcureweb/js/AEZ0001.js"/>
			<script type="javascript">
				<![CDATA[
					
					function mkDate(){
						var startyy = "";
						
						for(i=10; 0<=i; i--) {
							startyy = getCurrentDate().toDate().getAddDate(-i,"Y").getDateFormat().substr(0,4);
							addComboItem("cmb_srchdd",startyy +"년",startyy,"above");
						}
						cmb_srchdd.value = getCurrentDate().substr(0,4);
					}
					
					
					
					/***  ***/
					function setTitle() {
						
						model.removenode("/root/main/list");
						model.removenode("/root/main/curelist");
						model.removenode("/root/main/isublist");
						model.removenode("/root/main/osublist");
						model.removenode("/root/main/examsum");
						
						var stYearMonth = model.getValue("/root/send/exectoyy") + "0101";
						var dtYearMonth = stYearMonth.toDate().getAddDate(-4, "Y");

						var strExecFromyy = dtYearMonth.getDateFormat("YYYY");
						model.setValue("/root/send/execfromyy", strExecFromyy);
						
						var strComPareYear = stYearMonth.toDate().getAddDate(-1, "Y").getDateFormat("YYYY");
						model.setValue("/root/send/compareyy", strComPareYear);
						
						var stYearHeader = "검사실^검사항목^구분^";
						
						for (var i = 4; i <= 8; i++) {
							// 년도
							var stYear = dtYearMonth.getDateFormat("YYYY");
							
							stYearHeader = stYearHeader + stYear + "년^";
							dtYearMonth.getAddDate(1, "Y");
						}
						
						stYearHeader = stYearHeader + "합계^비교기간^증감율";
						grd_examlist.caption = stYearHeader
						
						// 치료 Title Setting
						stYearMonth = model.getValue("/root/send/exectoyy") + "0101";
						dtYearMonth = stYearMonth.toDate().getAddDate(-4, "Y");

						strExecFromyy = dtYearMonth.getDateFormat("YYYY");
						model.setValue("/root/send/execfromyy", strExecFromyy);
						
						strComPareYear = stYearMonth.toDate().getAddDate(-1, "Y").getDateFormat("YYYY");
						model.setValue("/root/send/compareyy", strComPareYear);
						
						stYearHeader = "구분^병실^처방량^";
						
						for (var i = 4; i <= 8; i++) {
							// 년도
							var stYear = dtYearMonth.getDateFormat("YYYY");
							
							stYearHeader = stYearHeader + stYear + "년^";
							dtYearMonth.getAddDate(1, "Y");
						}
						
						stYearHeader = stYearHeader + "합계^비교기간^증감율";
						grd_curelist.caption = stYearHeader
						
					}
					
				]]>
			</script>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[			
					
					aezfSetSuppDeptcd();
					
					var fromdd = getCurrentDate().substr(0,4) + "01";
					var todd = getCurrentDate().substr(0,6);
					
					model.setValue("/root/send/suppdeptcd", model.getValue("/root/send/globalinstance/instance1"));

					submit("TRAES09001", false);
					addComboItem("cmb_excuroomgrp","--전체--","","above");
					
					btn_case1.selected = true;
					model.toggle("case1");
					
					mkDate();
					
					setTitle();
					
					model.refresh();
				]]>
			</script>
			<submission id="TRAES09001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/init"/>
			<submission id="TRAES02801" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/main"/>
		</model>
	</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; ">
			<line id="line1" class="line_1" style="x1:7px; y1:72px; x2:1192px; y2:72px; "/>
			<button id="btn_excsave" class="btn2_letter4" style="left:1130px; top:52px; 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 != "") {
							if (btn_case1.selected == true) {
								grd_list.saveExcel(fileName);
							} else {
								grd_curelist.saveExcel(fileName);
							}
						}
					]]>
				</script>
			</button>
			<group id="group1" style="left:0px; top:10px; width:1195px; height:30px; vertical-align:top; ">
				<shape id="roundrect2" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1193px; height:30px; background-color:#fffbf2; border-color:#ffd799; "/>
				<line id="line2" class="line_4" style="x1:1110px; y1:5px; x2:1110px; y2:25px; "/>
				<button id="button1" class="btn1_letter2" navindex="4" style="left:1120px; top:4px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[							
							setTitle();

							if (submit("TRAES02801")) {
								var cnt = getNodesetCount("/root/main/curelist/item");
								
								if (cnt > 1) {
									
									grd_curelist.colSort(0) = "asc";
									grd_curelist.sort(0, 0, grd_examlist.rows, grd_examlist.cols) = "usersort";
								
									for(i=4; i<11; i++) {
/*										grd_curelist.subtotal("sum", 1, i, "#,###", "background-color:#FFFFCC; color:#0000ff; font-weight:bold; ", 2, "소계");*/
										grd_curelist.subtotal("sum", -1, i, "#,###", "background-color:#CCFFCC; color:#0000ff; font-weight:bold; ", 1, "총계");
									}
									grd_curelist.mergeByFree(grd_curelist.rows-1, 1 , grd_curelist.rows-1, 3);
									
									//전체 증감율 합계
									var sumcnt = grd_curelist.valueMatrix(grd_curelist.rows-1, grd_curelist.colRef("sumcnt"));
									var comparecnt = grd_curelist.valueMatrix(grd_curelist.rows-1, grd_curelist.colRef("comparecnt"));							
									
									var comparerate = "";
									if (parseInt(comparecnt)  > 0) {
										comparerate = ( ( parseInt(sumcnt) - parseInt(comparecnt) ) / parseInt(comparecnt) ) * 100;
									} else {
										comparerate = 0;
									}

									if (comparerate != null) {
										grd_curelist.valueMatrix(grd_curelist.rows-1, grd_curelist.colRef("comparerate")) = comparerate;
									}
								}
								
								var rowCnt = getNodesetCount("/root/main/sublist/item");
								
								if (cnt > 1) {
									
									grd_isublist.attribute("nodeset") = "/root/main/sublist/item[ioflag='I']" ;
									grd_osublist.attribute("nodeset") = "/root/main/sublist/item[ioflag='O']" ;
									grd_isublist.rebuild();
									grd_osublist.rebuild();

									var ioflag = "";
									var iSum = 0;
									var oSum = 0;
									var total = 0;
				
									for (i=1; i<=rowCnt; i++) {
										
										ioflag = model.getValue("/root/main/sublist/item[" + i + "]/ioflag");
										if (ioflag == "I") {
											iSum = iSum + eval(model.getValue("/root/main/sublist/item[" + i + "]/cnt"));
										} else  if (ioflag == "O") {
											oSum = oSum + eval(model.getValue("/root/main/sublist/item[" + i + "]/cnt"));
										}
									}
									total = eval(iSum) + eval(oSum);
									
									model.makeValue("/root/main/examsum/isum", iSum);
									model.makeValue("/root/main/examsum/osum", oSum);
									model.makeValue("/root/main/examsum/total", total);
								}
							}
							model.refresh();
						]]>
					</script>
				</button>
				<caption id="caption2" class="search_name" style="left:10px; top:7px; width:86px; height:17px; ">기준년도 :</caption>
				<select1 id="cmb_excuroomgrp" ref="/root/send/excuroomgrpcdid" class="combo_default" appearance="minimal" style="left:295px; top:6px; width:118px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/initexcuroomgrp">
							<label ref="nm"/>
							<value ref="cd"/>
						</itemset>
					</choices>
				</select1>
				<caption id="caption7" class="search_name" style="left:215px; top:7px; width:80px; height:17px; ">검사실 :</caption>
				<select1 id="cmb_srchdd" ref="/root/send/exectoyy" appearance="minimal" style="left:107px; top:6px; width:73px; height:19px; ">
					<choices>
						<itemset nodeset="/root/inti_com/srchdate/item">
							<label ref="label"/>
							<value ref="value"/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							setTitle();
						]]>
					</script>
				</select1>
			</group>
			<switch id="switch1" style="left:7px; top:75px; width:1185px; height:664px; ">
				<case id="case1" selected="true" style="left:0px; top:0px; width:1183px; height:662px; ">
					<datagrid id="grd_examlist" nodeset="/root/main/list/item" caption="검사실^검사항목^구분^2005년^2006년^2007년^2008년^2009년^합계^비교기간^증감율^전년도합계^증감(%)" colsep="^" colwidth="90, 271, 52, 90, 90, 90, 90, 90, 90, 90, 90" mergecells="byrestriccol" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" tooltip="true" style="left:0px; top:0px; width:1183px; height:662px; ">
						<col ref="excuroomnm"/>
						<col ref="prcpnm"/>
						<col ref="flag" style="text-align:center; "/>
						<col ref="year1" style="text-align:right; "/>
						<col ref="year2" style="text-align:right; "/>
						<col ref="year3" style="text-align:right; "/>
						<col ref="year4" style="text-align:right; "/>
						<col ref="year5" style="text-align:right; "/>
						<col ref="sumcnt" style="text-align:right; "/>
						<col ref="comparecnt" style="text-align:right; "/>
						<col ref="comparerate" style="text-align:right; "/>
					</datagrid>
				</case>
				<case id="case2">
					<datagrid id="grd_isublist" nodeset="/root/main/isublist/item" caption="구분^처방량^건수" colsep="^" colwidth="75, 90, 90" mergecells="byrestriccol" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:470px; width:258px; height:140px; ">
						<col disabled="true" ref="ioflag" type="combo" style="text-align:center; ">
							<choices>
								<item>
									<label>입원</label>
									<value>I</value>
								</item>
								<item>
									<label>외래</label>
									<value>O</value>
								</item>
							</choices>
						</col>
						<col ref="drugqty" style="text-align:right; "/>
						<col ref="cnt" style="text-align:right; "/>
					</datagrid>
					<datagrid id="grd_osublist" nodeset="/root/main/osublist/item" caption="구분^처방량^건수" colsep="^" colwidth="75, 90, 90" mergecells="byrestriccol" mergecellsfixedrows="bycolrec" rowsep="|" style="left:260px; top:470px; width:258px; height:140px; ">
						<col disabled="true" ref="ioflag" type="combo" style="text-align:center; ">
							<choices>
								<item>
									<label>입원</label>
									<value>I</value>
								</item>
								<item>
									<label>외래</label>
									<value>O</value>
								</item>
							</choices>
						</col>
						<col ref="drugqty" style="text-align:right; "/>
						<col ref="cnt" style="text-align:right; "/>
					</datagrid>
					<caption id="caption1" class="cell_1" style="left:260px; top:613px; width:127px; height:23px; vertical-align:middle; ">외래합계</caption>
					<caption id="caption4" class="cell_1" style="left:0px; top:639px; width:127px; height:23px; vertical-align:middle; ">총합계</caption>
					<input id="input1" ref="/root/main/examsum/isum" style="left:129px; top:615px; width:129px; height:19px; text-align:right; "/>
					<input id="input2" ref="/root/main/examsum/osum" style="left:389px; top:615px; width:129px; height:19px; text-align:right; "/>
					<input id="input3" ref="/root/main/examsum/total" style="left:129px; top:641px; width:389px; height:19px; text-align:right; "/>
					<caption id="caption8" class="cell_1" style="left:0px; top:613px; width:127px; height:23px; vertical-align:middle; ">병실합계</caption>
					<datagrid id="grd_curelist" nodeset="/root/main/curelist/item" caption="구분^병실^처방량^2005년^2006년^2007년^2008년^2009년^합계^비교기간^증감율" colsep="^" colwidth="80, 80, 80, 108, 108, 108, 108, 108, 120, 120, 120" mergecells="byrestriccol" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" subtotalposition="below" tooltip="true" style="left:0px; top:0px; width:1183px; height:465px; ">
						<col disabled="true" ref="ioflag" type="combo" visibility="visible" style="text-align:center; ">
							<choices>
								<item>
									<label>입원</label>
									<value>I</value>
								</item>
								<item>
									<label>외래</label>
									<value>O</value>
								</item>
							</choices>
						</col>
						<col ref="roomcd" style="text-align:center; "/>
						<col ref="drugqty" style="text-align:center; "/>
						<col ref="year1" style="text-align:right; "/>
						<col ref="year2" style="text-align:right; "/>
						<col ref="year3" style="text-align:right; "/>
						<col ref="year4" style="text-align:right; "/>
						<col ref="year5" style="text-align:right; "/>
						<col ref="sumcnt" style="text-align:right; "/>
						<col ref="comparecnt" style="text-align:right; "/>
						<col ref="comparerate" style="text-align:right; "/>
					</datagrid>
				</case>
			</switch>
			<button id="btn_case1" class="btn_sw" group="tab2" style="left:7px; top:49px; width:60px; height:22px; ">
				<caption>검사</caption>
				<toggle case="case1" ev:event="onclick"/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						model.toggle("case1");
					]]>
				</script>
			</button>
			<button id="button2" class="btn_sw" group="tab2" style="left:67px; top:49px; width:60px; height:22px; ">
				<caption>치료</caption>
				<toggle case="case1" ev:event="onclick"/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						model.toggle("case2");
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>