YNU_JEUS/app_home/himed/webapps/ast/examcurestatsweb/xrw/SMAES00300_기능검사실통계(월별).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>
								<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>
					</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);
					
					var fromdd = getCurrentDate().substr(0,4) + "0101"
					var todd = getCurrentDate().substr(0,6) + fromdd.toDate().getMonthDay();
					var comparefromdd = getCurrentDate().substr(0,6).toDate().getAddDate(-1,"Y").getDateFormat("YYYY") +  "0101";
					var comparetodd = comparefromdd.substr(0,4) + todd.substr(4,4);
					
					addComboItem("cmb_excuroomcd","--전체--","","above");
					
					model.removenode("/root/main/list/item");
					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="TRAES00301" 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>
	</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; "/>
			<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; "/>
				<caption id="caption2" class="search_name" style="left:15px; top:7px; width:86px; height:17px; ">조회기간 :</caption>
				<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("TRAES00301");
							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, "(-)#,###");
							}
							//전체 증감율 합계
							var sumprcp = grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("monthsum"));
							var sumcnt = grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("compare"));							
							
							var comparerate = 0;
							if (parseInt(sumcnt)  > 0) {
								comparerate = ( ( parseInt(sumprcp) - parseInt(sumcnt) ) / parseInt(sumcnt) ) * 100;
							}

//							if (comparerate != null) {
//								grd_list.valueMatrix(grd_list.rows-1, grd_list.colRef("comparerate")) = comparerate;
//								grd_list.cellformat (grd_list.rows-1, grd_list.colRef("comparerate")) = "(-)#,###.#%"; 
//							}

							if (comparerate != null) {
								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:207px; top:6px; width:85px; height:19px; "/>
				<caption id="caption5" class="search_no_b" style="left:192px; top:7px; width:12px; height:17px; ">~</caption>
				<input id="ipt_fromdd" ref="/root/send/execfromdd" class="input_default" navindex="1" inputtype="date" style="left:106px; top:6px; width:85px; height:19px; "/>
				<caption id="caption3" class="search_name" style="left:313px; top:7px; width:86px; height:17px; ">비교기간 :</caption>
				<input id="input1" ref="/root/send/comparetodd" class="input_default" navindex="2" inputtype="date" style="left:510px; top:6px; width:85px; height:19px; "/>
				<caption id="caption4" class="search_no_b" style="left:495px; top:7px; width:12px; height:17px; ">~</caption>
				<input id="input2" ref="/root/send/comparefromdd" class="input_default" navindex="1" inputtype="date" style="left:407px; top:6px; width:85px; height:19px; "/>
				<caption id="caption9" class="search_name" style="left:620px; top:7px; width:75px; height:17px; ">검사실 :</caption>
				<select1 id="cmb_excuroomcd" ref="/root/send/excuroomcd" appearance="minimal" itemcount="10" style="left:700px; top:6px; width:115px; 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" style="left:845px; top:7px; width:70px; height:17px; ">구분 :</caption>
				<select1 id="radio1" ref="/root/send/ioflag" 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>
			<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="검사코드^검사명^1월^2월^3월^4월^5월^6월^7월^8월^9월^10월^11월^12월^합계^비교기간^증감^증감율" colsep="^" colwidth="93, 270, 44, 44, 44, 44, 44, 44, 44, 44, 44, 44, 44, 44, 70, 70, 60, 60" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" subtotalposition="below" style="left:0px; top:70px; width:1195px; height:670px; ">
				<col ref="prcpcd"/>
				<col ref="prcpnm"/>
				<col ref="month01" format="#,###" style="text-align:right; "/>
				<col ref="month02" format="#,###" style="text-align:right; "/>
				<col ref="month03" format="#,###" style="text-align:right; "/>
				<col ref="month04" format="#,###" style="text-align:right; "/>
				<col ref="month05" format="#,###" style="text-align:right; "/>
				<col ref="month06" format="#,###" style="text-align:right; "/>
				<col ref="month07" format="#,###" style="text-align:right; "/>
				<col ref="month08" format="#,###" style="text-align:right; "/>
				<col ref="month09" format="#,###" style="text-align:right; "/>
				<col ref="month10" format="#,###" style="text-align:right; "/>
				<col ref="month11" format="#,###" style="text-align:right; "/>
				<col ref="month12" format="#,###" style="text-align:right; "/>
				<col ref="monthsum" format="#,###" style="text-align:right; "/>
				<col ref="compare" format="(-)#,###" style="text-align:right; "/>
				<col ref="variation" format="(-)#,###" style="text-align:right; "/>
				<col ref="comparerate" format="(-)#,###.#%" style="text-align:right; "/>
			</datagrid>
		</group>
	</xhtml:body>
</xhtml:html>