YNU_JEUS/app_home/himed/webapps/ast/examcurestatsweb/xrw/SMAES04600_기능검사실통계(분기별).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>
								<prcpcd/>
								<prcpnm/>
								<month01/>
								<month02/>
								<month03/>
								<month04/>
								<month05/>
								<month06/>
								<month07/>
								<month08/>
								<month09/>
								<month10/>
								<month11/>
								<month12/>
								<monthsum/>
								<compare/>
								<variation/>
								<comparerate/>
							</item>
						</list>
					</main>
					<send>
						<execfromdd/>
						<exectodd/>
						<comparefromdd/>
						<comparetodd/>
						<excuroomcd/>
						<globalinstance>
							<instance1/>
						</globalinstance>
						<ioflag>A</ioflag>
						<srchyyyy/>
						<srchqurt>1</srchqurt>
					</send>
					<init>
						<cmb_info/>
					</init>
					<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" ev:event="xforms-ready">
				<![CDATA[			
					
					aezfSetSuppDeptcd();
					
					submit("TRAEA01115",false);

					model.setValue("/root/send/srchyyyy", getCurrentDate().substr(0,4) );

					addComboItem("cmb_excuroomcd","--전체--","","above");
					
					model.removenode("/root/main/list/item");
				    
					model.refresh();
				]]>
			</script>
			<submission id="TRAES04601" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/main/list"/>
			<submission id="TRAEA01115" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/globalinstance" replace="instance" resultref="/root/init/cmb_info"/>
		</model>
		<script type="javascript">
			<![CDATA[
				function fSetDate(id, gb) {
					var cYear = eval(id).value;
					if(gb == "up") {
						eval(id).value = eval(cYear)+1;
					}else {
						eval(id).value = eval(cYear)-1;
					}
				}
				
				/* @group	: 통합 통계
				 * @ver		: 
				 * @by		: 
				 * @-----------------------------------
				 * @type		: function
				 * @access	: public
				 * @desc		:  증감율을 구하는 함수
				*/	
				function setCompareRate(total, comparecnt) {
					
					var comparerate = 0;
					
					if (parseInt(comparecnt)  > 0) {
						comparerate = ( ( parseInt(total) - parseInt(comparecnt) ) / parseInt(comparecnt) ) * 100;
						
						if (comparerate != null) {
							comparerate = comparerate.toString().getRound(-1,"HALF_UP");
						} else {
							comparerate = 0;
						}
					} else {
						comparerate = 0;
					}
					
					return comparerate;
				}
				
				/* @group	: 통합 통계
				 * @ver		: 
				 * @by		: 
				 * @-----------------------------------
				 * @type		: function
				 * @access	: public
				 * @desc		:  통계 구분별 그리드 header를 정의하는 함수
				*/	
				function setTitle() {
					
					var baseQurt = model.getValue("/root/send/srchqurt");
					
					model.removenode("/root/main/list");
					
					var stCaption = "";
					
					if ( baseQurt == "1" ) {
						stCaption = "검사코드^검사명^3월^3월^3월^4월^4월^4월^5월^5월^5월^1/4분기^1/4분기^1/4분기^전분기대비^전분기대비^전년동분기대비^전년동분기대비|검사코드^검사명^입원^외래^계^입원^외래^계^입원^외래^계^입원^외래^계^합계^증감^합계^증감";
					} else if ( baseQurt == "2" ) {
						stCaption = "검사코드^검사명^6월^6월^6월^7월^7월^7월^8월^8월^8월^2/4분기^2/4분기^2/4분기^전분기대비^전분기대비^전년동분기대비^전년동분기대비|검사코드^검사명^입원^외래^계^입원^외래^계^입원^외래^계^입원^외래^계^합계^증감^합계^증감";
					} else if ( baseQurt == "3" ) {
						stCaption = "검사코드^검사명^9월^9월^9월^10월^10월^10월^11월^11월^11월^3/4분기^3/4분기^3/4분기^전분기대비^전분기대비^전년동분기대비^전년동분기대비|검사코드^검사명^입원^외래^계^입원^외래^계^입원^외래^계^입원^외래^계^합계^증감^합계^증감";
					} else if ( baseQurt == "4" ) {
						stCaption = "검사코드^검사명^12월^12월^12월^1월^1월^1월^2월^2월^2월^4/4분기^4/4분기^4/4분기^전분기대비^전분기대비^전년동분기대비^전년동분기대비|검사코드^검사명^입원^외래^계^입원^외래^계^입원^외래^계^입원^외래^계^합계^증감^합계^증감";
					}
					
					grd_list.caption = stCaption;
					grd_list.rebuild();

				}
				
			]]>
		</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:50px; width:200px; height:14px; ">기능검사실 통계(분기별)</caption>
			<line id="line1" class="line_1" style="x1:0px; y1:65px; x2:1195px; y2:65px; "/>
			<group id="grp_sea" style="left:0px; top:10px; width:1195px; height:30px; vertical-align:top; ">
				<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1193px; height:30px; background-color:#fffbf2; border-color:#ffd799; "/>
				<line id="line13" class="line_4" style="x1:1110px; y1:4px; x2:1110px; y2:26px; "/>
				<button id="btn_sea" class="btn1_letter2" navindex="4" style="left:1120px; top:4px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[							
							submit("TRAES04601");
							
//							grd_list.subtotal("sum", -1, 3, "#,###", "background-color:#99ff99", 2, "합계");
//							for(i=4; i<grd_list.cols-1; i++) {
//								grd_list.subtotal("sum", -1, i, "(-)#,###");
//							}
							
							grd_list.colSort(0) = "asc";
							grd_list.sort(0, 0, grd_list.rows, grd_list.cols) = "usersort";
							

							for(i=3; i<grd_list.cols; i++) {
								grd_list.subtotal("sum", -1, i, "#,###", "background-color:#CCFFCC; color:#0000ff; font-weight:bold; ", 1, "총계");
							}
							grd_list.mergeByFree(grd_list.rows-1, 1 , grd_list.rows-1, 2);
						
						
							var total = 0;
							var comparecnt = 0;
							var comparerate = "";
					
							//전분기대비 증감율 합계
							total = grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("squrt01"));
							comparecnt = grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("prequrtsum"));			
							
							grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("prequrtrate")) = setCompareRate(total, comparecnt) ;
							grd_list.cellformat(grd_list.rows-1, grd_list.colRef("prequrtrate")) = "(-)###.#0 %";
					
					
							//전년동분기대비 증감율 합계
							total = grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("squrt01"));
							comparecnt = grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("preyearqurtsum"));			
							
							grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("preyearqurtrate")) = setCompareRate(total, comparecnt) ;
							grd_list.cellformat(grd_list.rows-1, grd_list.colRef("preyearqurtrate")) = "(-)###.#0 %";
							
						]]>
					</script>
				</button>
				<caption id="caption9" class="search_name" visibility="visible" style="left:440px; top:7px; width:75px; height:17px; ">검사실 :</caption>
				<select1 id="cmb_excuroomcd" ref="/root/send/excuroomcd" visibility="visible" appearance="minimal" itemcount="10" style="left:520px; top:6px; width:140px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/cmb_info/initexecroom">
							<label ref="excuroomcdnm"/>
							<value ref="excuroomcdid"/>
						</itemset>
					</choices>
				</select1>
				<caption id="caption8" class="search_name" visibility="hidden" style="left:845px; top:7px; width:70px; height:17px; ">구분 :</caption>
				<select1 id="radio1" ref="/root/send/ioflag" visibility="hidden" appearance="full" cols="3" overflow="visible" style="left:915px; top:7px; width:145px; height:15px; border-style:none; ">
					<choices>
						<item>
							<label>전체</label>
							<value>A</value>
						</item>
						<item>
							<label>입원</label>
							<value>I</value>
						</item>
						<item>
							<label>외래</label>
							<value>O</value>
						</item>
					</choices>
				</select1>
				<group id="group2" style="left:184px; top:3px; width:14px; height:26px; ">
					<button id="button3" style="left:0px; top:11px; width:13px; height:13px; background-image:../../../com/commonweb/images/grid_scroll_v_s_down.gif; ">
						<caption/>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[
								fSetDate("ipt_eYear", "down");
							]]>
						</script>
					</button>
					<button id="button4" style="left:0px; top:0px; width:13px; height:13px; background-image:../../../com/commonweb/images/grid_scroll_v_s_up.gif; ">
						<caption/>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[
								fSetDate("ipt_eYear", "up");
							]]>
						</script>
					</button>
				</group>
				<caption id="caption2" class="search_name" style="left:25px; top:7px; width:90px; height:17px; ">조회년도 :</caption>
				<input id="ipt_eYear" ref="/root/send/srchyyyy" class="input_s_essential" style="left:120px; top:6px; width:65px; height:19px; "/>
				<select1 id="combo1" ref="/root/send/srchqurt" appearance="minimal" style="left:320px; top:6px; width:85px; height:19px; ">
					<choices>
						<item>
							<label>1분기</label>
							<value>1</value>
						</item>
						<item>
							<label>2분기</label>
							<value>2</value>
						</item>
						<item>
							<label>3분기</label>
							<value>3</value>
						</item>
						<item>
							<label>4분기</label>
							<value>4</value>
						</item>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							setTitle();
						]]>
					</script>
				</select1>
				<caption id="caption3" class="search_name" style="left:225px; top:7px; width:90px; height:17px; ">조회분기 :</caption>
			</group>
			<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 (*.*)|*.*");	
						if (fileName != "") {
							grd_list.saveExcel(fileName);
						}
					]]>
				</script>
			</button>
			<datagrid id="grd_list" nodeset="/root/main/list/item" caption="검사코드^검사명^3월^3월^3월^4월^4월^4월^5월^5월^5월^1/4분기^1/4분기^1/4분기^전분기대비^전분기대비^전년동분기대비^전년동분기대비|검사코드^검사명^입원^외래^계^입원^외래^계^입원^외래^계^입원^외래^계^합계^증감^합계^증감" colsep="^" colwidth="87, 314, 42, 42, 42, 42, 42, 42, 42, 42, 42, 54, 54, 54, 54, 54, 54, 54" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" subtotalposition="below" style="left:0px; top:70px; width:1195px; height:670px; text-align:center; ">
				<col ref="prcpcd" style="text-align:left; "/>
				<col ref="prcpnm" style="text-align:left; "/>
				<col ref="imonth01" style="text-align:right; "/>
				<col ref="omonth01" style="text-align:right; "/>
				<col ref="smonth01" style="text-align:right; "/>
				<col ref="imonth02" style="text-align:right; "/>
				<col ref="omonth02" style="text-align:right; "/>
				<col ref="smonth02" style="text-align:right; "/>
				<col ref="imonth03" style="text-align:right; "/>
				<col ref="omonth03" style="text-align:right; "/>
				<col ref="smonth03" style="text-align:right; "/>
				<col ref="iqurt01" style="text-align:right; "/>
				<col ref="oqurt01" style="text-align:right; "/>
				<col ref="squrt01" style="text-align:right; "/>
				<col ref="prequrtsum" format="#,###" style="text-align:right; "/>
				<col ref="prequrtrate" format="(-)###.#0 %" roundmode="round" roundposition="-2" validateformat="true" style="text-align:right; "/>
				<col ref="preyearqurtsum" format="(-)#,###" style="text-align:right; "/>
				<col ref="preyearqurtrate" format="(-)###.#0 %" style="text-align:right; "/>
			</datagrid>
		</group>
	</xhtml:body>
</xhtml:html>