YNU_JEUS/app_home/himed/webapps/ast/examcurestatsweb/xrw/SMAES00800_영상의학연보자료.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>
								<flag/>
								<excuroomnm/>
								<month1/>
								<month2/>
								<month3/>
								<month4/>
								<month5/>
								<month6/>
								<month7/>
								<month8/>
								<month9/>
								<month10/>
								<month11/>
								<month12/>
								<prestyearsum/>
								<bfyearsum/>
								<variation/>
							</item>
						</list>
					</main>
					<send>
						<execfromdd/>
						<exectodd/>
						<comparefromdd/>
						<comparetodd/>
						<orddeptcd/>
						<orddrid/>
						<execdeptcd/>
						<execdrid/>
						<globalinstance>
							<instance1/>
						</globalinstance>
						<suppdeptcd/>
						<ioflag/>
					</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"/>
			<script type="javascript">
				<![CDATA[
					
					/***  ***/
					function setTitle() {
						
						model.removenode("/root/main/list");
						
						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 = 1; i <= 12; 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_list.colHidden(1 + i) = true;
							} else {
								grd_list.colHidden(1 + i) = false;
							}
							dtYearMonth.getAddDate(1, "M");
							
						}
						stYearHeader = stYearHeader + "당해년도합계^전년도합계^증감(%)|";
						stMonthHeader = stMonthHeader + "당해년도합계^전년도합계^증감(%)";
						
						grd_list.caption = stYearHeader + stMonthHeader;

					}
					
				]]>
			</script>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[			
					
					aezfSetSuppDeptcd();
					
					// 진료과/진료의 조회
					//submit("TRPMOCOM01", false);
					
					//model.setValue("/root/send/suppdeptcd", model.getValue("/root/send/globalinstance/instance1"));
					
					var fromdd = getCurrentDate().substr(0,4) + "01";
					var todd = getCurrentDate().substr(0,6);
					var comparefromdd = getCurrentDate().substr(0,4).toDate().getAddDate(0,"Y").getDateFormat("YYYY") +  "01";
					var comparetodd = comparefromdd.substr(0,4) + todd.substr(4,2);
					
					model.setValue("/root/send/suppdeptcd", model.getValue("/root/send/globalinstance/instance1"));
					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.setValue("/root/send/ioflag","");

					model.removenode("/root/main/list");
					
					setTitle();
					
					model.refresh();
				]]>
			</script>
			<submission id="TRAES00301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/main/list"/>
			<submission id="TRAES00801" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/main/list"/>
		</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; ">
			<caption id="caption1" class="tit_2" style="left:5px; top:50px; width:200px; height:13px; ">연보자료통계</caption>
			<line id="line1" class="line_1" style="x1:0px; y1:65px; x2:1195px; y2:65px; "/>
			<button id="btn_excsave" class="btn2_letter4" 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 (*.*)|*.*");	    // 2009-07-01 엑셀저장 두번째 저장 실패 오류 확인

						var filename = window.fileDialog("save",",",false,"excel","xls","All File(*.*)|*.*|Excel File(*.xls)|*.xls");    // 2009-07-01 엑셀저장 두번째 저장 실패 오류 확인 두번째 테스트
						if (filename != "") {
							grd_list.saveExcel(filename);
						}
					]]>
				</script>
			</button>
			<datagrid id="grd_list" 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월^당해년도합계^전년도합계^증감(%)" colsep="^" colwidth="70, 112, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 82, 82, 82" fixedcols="2" mergecellsfixedcols="bycolrec" mergecellsfixedrows="bycolrec" rowsep="|" subtotalposition="below" style="left:0px; top:70px; width:1195px; height:670px; ">
				<col ref="flag"/>
				<col ref="excuroomnm"/>
				<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="prestyearsum" style="text-align:right; "/>
				<col ref="bfyearsum" style="text-align:right; "/>
				<col ref="variation" style="text-align:right; "/>
			</datagrid>
			<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[
							
							openLoadingBar("영상의학 연보 자료 조회 중입니다...") ;

							if (submit("TRAES00801")) {
								var rows = grd_list.rows - grd_list.fixedRows;
								if(rows > 0){
									grd_list.subtotal("sum", -1, grd_list.colRef("month1"), "#,###", "background-color:#CCFFCC; color:#0000ff; font-weight:bold; ",1,  "합 계");
									grd_list.subtotal("sum", -1, grd_list.colRef("month2"), "#,###", "background-color:#CCFFCC; color:#0000ff; font-weight:bold; ",1,  "합 계");
									grd_list.subtotal("sum", -1, grd_list.colRef("month3"), "#,###", "background-color:#CCFFCC; color:#0000ff; font-weight:bold; ",1,  "합 계");
									grd_list.subtotal("sum", -1, grd_list.colRef("month4"), "#,###", "background-color:#CCFFCC; color:#0000ff; font-weight:bold; ",1,  "합 계");
									grd_list.subtotal("sum", -1, grd_list.colRef("month5"), "#,###", "background-color:#CCFFCC; color:#0000ff; font-weight:bold; ",1,  "합 계");
									grd_list.subtotal("sum", -1, grd_list.colRef("month6"), "#,###", "background-color:#CCFFCC; color:#0000ff; font-weight:bold; ",1,  "합 계");
									grd_list.subtotal("sum", -1, grd_list.colRef("month7"), "#,###", "background-color:#CCFFCC; color:#0000ff; font-weight:bold; ",1,  "합 계");
									grd_list.subtotal("sum", -1, grd_list.colRef("month8"), "#,###", "background-color:#CCFFCC; color:#0000ff; font-weight:bold; ",1,  "합 계");
									grd_list.subtotal("sum", -1, grd_list.colRef("month9"), "#,###", "background-color:#CCFFCC; color:#0000ff; font-weight:bold; ",1,  "합 계");
									grd_list.subtotal("sum", -1, grd_list.colRef("month10"), "#,###", "background-color:#CCFFCC; color:#0000ff; font-weight:bold; ",1,  "합 계");
									grd_list.subtotal("sum", -1, grd_list.colRef("month11"), "#,###", "background-color:#CCFFCC; color:#0000ff; font-weight:bold; ",1,  "합 계");
									grd_list.subtotal("sum", -1, grd_list.colRef("month12"), "#,###", "background-color:#CCFFCC; color:#0000ff; font-weight:bold; ",1,  "합 계");
									grd_list.subtotal("sum", -1, grd_list.colRef("prestyearsum"), "#,###", "background-color:#CCFFCC; color:#0000ff; font-weight:bold; ",1,  "합 계");
									grd_list.subtotal("sum", -1, grd_list.colRef("bfyearsum"), "#,###", "background-color:#CCFFCC; color:#0000ff; font-weight:bold; ", 1, "합 계");
									
									var prestyearsum = grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("prestyearsum"));
									var bfyearsum = grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("bfyearsum"));
									var variation = 0;
									
									if  ( bfyearsum == 0 ) {
										variation =  (( eval(prestyearsum) - eval(bfyearsum))) * 100; 
									} else {
										variation =  (( eval(prestyearsum) - eval(bfyearsum) ) / eval(bfyearsum)) * 100; 
									}
									grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("variation")) =  variation.toString().getRound(-1,"HALF_UP");
									model.refresh();
								}
							}
							
							closeLoadingBar() ;//처리중 화면을 close한다.     
						
						]]>
					</script>
				</button>
				<caption id="caption2" class="search_name" style="left:15px; 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:227px; top:6px; width:100px; 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");
							
							model.setValue("/root/send/comparetodd", exectodd);
							
							setTitle();
							
							model.refresh();
						]]>
					</script>
				</input>
				<caption id="caption5" class="search_no_b" style="left:212px; 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:109px; top:6px; width:100px; 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");
							
							model.setValue("/root/send/comparefromdd", execfromdd);

							setTitle();
							
							model.refresh();
						]]>
					</script>
				</input>
				<caption id="caption3" class="search_name" style="left:368px; top:7px; width:86px; height:17px; ">비교기간 :</caption>
				<input id="input1" ref="/root/send/comparetodd" class="input_default" disabled="true" navindex="2" inputtype="date" format="yyyy-mm" style="left:580px; top:6px; width:100px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							var comparefromdd = (model.getValue("/root/send/comparefromdd") + "01").toDate();
							var comparetodd = (model.getValue("/root/send/comparetodd") + "01").toDate();
							
							if(comparefromdd.getAddDate(11, "M") < comparetodd) 
							{
								messageBox("1년이상의 자료는 검색할수 없습니다.", "I");
								comparetodd = comparefromdd;
							}
							
							model.setValue("/root/send/comparetodd", comparetodd.getDateFormat("YYYYMM"));
							comparetodd = comparetodd.getAddDate(12, "M");
							comparetodd = comparetodd.getDateFormat("YYYYMM");
							
							model.setValue("/root/send/exectodd", comparetodd);
							
							model.refresh();
						]]>
					</script>
				</input>
				<caption id="caption4" class="search_no_b" style="left:565px; top:6px; width:12px; height:17px; ">~</caption>
				<input id="input2" ref="/root/send/comparefromdd" class="input_default" disabled="true" navindex="1" inputtype="date" format="yyyy-mm" style="left:462px; top:6px; width:100px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							var comparefromdd = (model.getValue("/root/send/comparefromdd") + "01").toDate();
							var comparetodd = (model.getValue("/root/send/comparetodd") + "01").toDate();
							
							if(comparefromdd < comparetodd.getAddDate(-11, "M")) 
							{
								messageBox("1년이상의 자료는 검색할수 없습니다.", "I");
								comparefromdd = comparetodd;
							}
							
							model.setValue("/root/send/comparefromdd", comparefromdd.getDateFormat("YYYYMM"));
							comparefromdd = comparefromdd.getAddDate(12, "M");
							comparefromdd = comparefromdd.getDateFormat("YYYYMM");
							
							model.setValue("/root/send/execfromdd", comparefromdd);
							
							model.refresh();
						]]>
					</script>
				</input>
				<select1 id="rdo_ioflag" ref="/root/send/ioflag" appearance="full" cols="4" overflow="visible" style="left:805px; top:7px; width:225px; height:16px; border-style:none; ">
					<choices>
						<item>
							<label>전체</label>
							<value/>
						</item>
						<item>
							<label>영상</label>
							<value>R</value>
						</item>
						<item>
							<label>건진</label>
							<value>S</value>
						</item>
						<item>
							<label>어린이병원</label>
							<value>C</value>
						</item>
					</choices>
				</select1>
				<caption id="caption7" class="search_name" style="left:730px; top:7px; width:70px; height:17px; ">구분 :</caption>
			</group>
		</group>
	</xhtml:body>
</xhtml:html>