YNU_JEUS/app_home/himed/webapps/ast/examcurestatsweb/xrw/SMAES02700_핵의학체내기간별통계.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?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>
						<list>
							<item>
								<excuroomnm/>
								<prcpnm/>
								<flag/>
								<month1/>
								<month2/>
								<month3/>
								<month4/>
								<month5/>
								<month6/>
								<month7/>
								<month8/>
								<month9/>
								<month10/>
								<month11/>
								<month12/>
								<sumcnt/>
								<comparecnt/>
								<comparerate/>
							</item>
						</list>
						<curelist>
							<item>
								<ioflag/>
								<roomcd/>
								<drugqty/>
								<month1/>
								<month2/>
								<month3/>
								<month4/>
								<month5/>
								<month6/>
								<month7/>
								<month8/>
								<month9/>
								<month10/>
								<month11/>
								<month12/>
								<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>
						<execfromdd/>
						<exectodd/>
						<globalinstance>
							<instance1/>
						</globalinstance>
						<excuroomgrpcdid/>
						<comparefromdd/>
						<comparetodd/>
						<suppdeptcd/>
					</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/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"/>
			<script type="javascript">
				<![CDATA[
					
					/***  ***/
					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");
						
						// 치료 Title Setting
						var stYearMonth = model.getValue("/root/send/execfromdd") + "01";
						var dtYearMonth = stYearMonth.toDate();
						var stEndMonth = model.getValue("/root/send/exectodd") + "01";
						var dtEndMonth = stEndMonth.toDate();
						
						var stYearHeader = "검사실^검사항목^구분^";
						var stMonthHeader = "검사실^검사항목^구분^";
						
						for (var i = 4; i <= 15; i++) {
							// 년도
							var stYear = dtYearMonth.getDateFormat("YYYY");
							// 월
							var stMonth = dtYearMonth.getDateFormat("MM");
							
							stYearHeader = stYearHeader + stYear + "년^";
							stMonthHeader = stMonthHeader + stMonth + "월^";
							
							if(dtYearMonth.getDateFormat("YYYYMM") > dtEndMonth.getDateFormat("YYYYMM")) {
								grd_examlist.colHidden(i) = true;
							} else {
								grd_examlist.colHidden(i) = false;
							}
							dtYearMonth.getAddDate(1, "M");
						}
						
						stYearHeader = stYearHeader + "합계^비교기간내건수^증감율|";
						stMonthHeader = stMonthHeader + "합계^비교기간내건수^증감율";
						grd_examlist.caption = stYearHeader + stMonthHeader;
						
						model.setValue("/root/send/comparefromdd", stYearMonth.toDate().getAddDate(-12, "M").getDateFormat("YYYYMM"));
						model.setValue("/root/send/comparetodd", stEndMonth.toDate().getAddDate(-12, "M").getDateFormat("YYYYMM"));
						
						var comparefromdd = model.getValue("/root/send/comparefromdd");
						var comparetodd = model.getValue("/root/send/comparetodd");
//						alert("comparefromdd : " + comparefromdd);
//						alert("comparetodd : " + comparetodd);
						
						// 치료 Title Setting
						stYearMonth = model.getValue("/root/send/execfromdd") + "01";
						dtYearMonth = stYearMonth.toDate();
						stEndMonth = model.getValue("/root/send/exectodd") + "01";
						dtEndMonth = stEndMonth.toDate();
						
						stYearHeader = "구분^병실^처방량^";
						stMonthHeader = "구분^병실^처방량^";
						
						for (var i = 4; i <= 15; i++) {
							// 년도
							var stYear = dtYearMonth.getDateFormat("YYYY");
							// 월
							var stMonth = dtYearMonth.getDateFormat("MM");
							
							stYearHeader = stYearHeader + stYear + "년^";
							stMonthHeader = stMonthHeader + stMonth + "월^";
							
							if(dtYearMonth.getDateFormat("YYYYMM") > dtEndMonth.getDateFormat("YYYYMM")) {
								grd_curelist.colHidden(1 + i) = true;
							} else {
								grd_curelist.colHidden(1 + i) = false;
							}
							dtYearMonth.getAddDate(1, "M");
						}
						
						stYearHeader = stYearHeader + "합계^비교기간내건수^증감율|";
						stMonthHeader = stMonthHeader + "합계^비교기간내건수^증감율";
						grd_curelist.caption = stYearHeader + stMonthHeader;
					}
					
				]]>
			</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"));
					//2009-07-16 조회기간 기본 Set : 해당년의 01월~12월로 Setting (류형기 샘 요청)
//					model.setValue("/root/send/execfromdd", getCurrentDate().toDate().getAddDate(-11, "M").getDateFormat("YYYYMM"));
//					model.setValue("/root/send/exectodd", getCurrentDate().substr(0,6));
					var fromdd01 = getCurrentDate().substr(0,4) + "0101";
					var todd12 = getCurrentDate().substr(0,4) + "1231";
					model.setValue("/root/send/execfromdd", fromdd01.toDate().getDateFormat("YYYYMM"));
					model.setValue("/root/send/exectodd", todd12.toDate().getDateFormat("YYYYMM"));
				
					submit("TRAES09001", false);
					addComboItem("cmb_excuroomgrp","--전체--","","above");
					
					btn_case1.selected = true;
					model.toggle("case1");
					
					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="TRAES02701" 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) {
								//2009-07-28 검사통계 - Excel저장 오류 수정
//								grd_list.saveExcel(fileName);
								grd_examlist.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("TRAES02701")) {
								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<18; 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.toString().getRound(-1,"HALF_UP");
									}
								}
								
								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>
				<input id="ipt_todd" ref="/root/send/exectodd" class="input_default" navindex="2" inputtype="date" format="yyyy-mm" style="left:202px; top:6px; width:80px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							var execfromdd = (model.getValue("/root/send/execfromdd") + "01").toDate();
							var exectodd = (model.getValue("/root/send/exectodd") + "01").toDate();
							
							if(execfromdd.getAddDate(11, "M") < exectodd) 
							{
								messageBox("1년이상의 자료는 검색할수 없습니다.", "I");
								exectodd = execfromdd;
							}
							
							model.setValue("/root/send/exectodd", exectodd.getDateFormat("YYYYMM"));
							exectodd = exectodd.getAddDate(-12, "M");
							exectodd = exectodd.getDateFormat("YYYYMM");
							
							setTitle();
							
							model.refresh();
						]]>
					</script>
				</input>
				<caption id="caption5" class="search_no_b" style="left:187px; top:6px; width:12px; height:17px; ">~</caption>
				<input id="ipt_fromdd" ref="/root/send/execfromdd" class="input_default" navindex="1" inputtype="date" format="yyyy-mm" style="left:104px; top:6px; width:80px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							var execfromdd = (model.getValue("/root/send/execfromdd") + "01").toDate();
							var exectodd = (model.getValue("/root/send/exectodd") + "01").toDate();
							
							if(execfromdd < exectodd.getAddDate(-11, "M")) 
							{
								messageBox("1년이상의 자료는 검색할수 없습니다.", "I");
								execfromdd = exectodd;
							}
							model.setValue("/root/send/execfromdd", execfromdd.getDateFormat("YYYYMM"));
							execfromdd = execfromdd.getAddDate(-12, "M");
							execfromdd = execfromdd.getDateFormat("YYYYMM");

							setTitle();
								
							model.refresh();
						]]>
					</script>
				</input>
				<select1 id="cmb_excuroomgrp" ref="/root/send/excuroomgrpcdid" class="combo_default" appearance="minimal" style="left:390px; 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:310px; top:7px; width:80px; height:17px; ">검사실 :</caption>
			</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="검사실^검사항목^구분^2006년^2006년^2006년^2006년^2006년^2006년^2006년^2006년^2006년^2006년^2007년^2007년^합계^비교기간내건수^증감율^전년도합계^증감(%)|검사실^검사항목^구분^3월^4월^5월^6월^7월^8월^9월^10월^11월^12월^1월^2월^합계^비교기간내건수&#xA;건수^증감율^전년도합계^증감(%)" colsep="^" colwidth="100, 240, 40, 47, 47, 47, 47, 47, 47, 47, 47, 47, 47, 47, 47, 64, 71, 64" mergecells="byrestriccol" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" subtotalposition="below" tooltip="true" style="left:0px; top:0px; width:1183px; height:662px; ">
						<col ref="excuroomnm" visibility="visible"/>
						<col ref="prcpnm"/>
						<col ref="flag" style="text-align:center; "/>
						<col ref="month1" style="text-align:right; "/>
						<col ref="month2" style="text-align:right; "/>
						<col ref="month3" style="text-align:right; "/>
						<col ref="month4" style="text-align:right; "/>
						<col ref="month5" style="text-align:right; "/>
						<col ref="month6" style="text-align:right; "/>
						<col ref="month7" style="text-align:right; "/>
						<col ref="month8" style="text-align:right; "/>
						<col ref="month9" style="text-align:right; "/>
						<col ref="month10" style="text-align:right; "/>
						<col ref="month11" style="text-align:right; "/>
						<col ref="month12" 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="구분^병실^처방량^2006년^2006년^2006년^2006년^2006년^2006년^2006년^2006년^2006년^2006년^2007년^2007년^합계^비교기간내건수^증감율|구분^병실^처방량^3월^4월^5월^6월^7월^8월^9월^10월^11월^12월^1월^2월^합계^비교기간내건수^증감율" colsep="^" colwidth="66, 67, 67, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 75, 75, 75" 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" 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:right; "/>
						<col ref="month1" style="text-align:right; "/>
						<col ref="month2" style="text-align:right; "/>
						<col ref="month3" style="text-align:right; "/>
						<col ref="month4" style="text-align:right; "/>
						<col ref="month5" style="text-align:right; "/>
						<col ref="month6" style="text-align:right; "/>
						<col ref="month7" style="text-align:right; "/>
						<col ref="month8" style="text-align:right; "/>
						<col ref="month9" style="text-align:right; "/>
						<col ref="month10" style="text-align:right; "/>
						<col ref="month11" style="text-align:right; "/>
						<col ref="month12" 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>