YNU_JEUS/app_home/himed/webapps/ast/examcurestatsweb/xrw/SMAES01600_영상의학월별조영제사용현황.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>
								<basecdnm/>
								<month1/>
								<month2/>
								<month3/>
								<month4/>
								<month5/>
								<month6/>
								<month7/>
								<month8/>
								<month9/>
								<month10/>
								<month11/>
								<month12/>
								<sumcnt/>
							</item>
						</list>
					</main>
					<send>
						<execfromdd/>
						<exectodd/>
						<globalinstance>
							<instance1/>
						</globalinstance>
						<suppdeptcd/>
						<cdgrupid/>
						<lrgcd/>
						<mdlcd/>
						<flag/>
						<basecdflag/>
						<roomcd/>
						<grupcdid/>
						<srflag/>
						<alladdyn/>
						<srchdate/>
						<srchflag/>
					</send>
					<init>
						<cmb_lrgcd/>
						<cmb_mdlcd/>
					</init>
					<hidden>
						<comcd/>
					</hidden>
					<cmb_info>
						<initexcuroomgrp2>
							<excuroomgrpcdid/>
							<excuroomgrpcdnm/>
						</initexcuroomgrp2>
					</cmb_info>
				</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" ev:event="xforms-ready">
				<![CDATA[			
					
					aezfSetSuppDeptcd();

					model.setValue("/root/send/suppdeptcd", model.getValue("/root/send/globalinstance/instance1"));
					model.setValue("/root/send/srchdate", getCurrentDate().substr(0,6));
					model.setValue("/root/send/basecdflag", "R");

					submit("TRAES01502", false);
					addComboItem("cmb_lrgcd","--전체--","","above");
					
					model.setValue("/root/send/alladdyn","P")
					//section 조회
					submit("TRAEA01301");
					model.setValue("/root/send/srflag","S")
					model.setValue("/root/send/roomcd"," ")
//					model.setValue("/root/send/grupcdid", "A0008");
//					submit("TRAEB00010");
					
					setTitle();
					
					model.refresh();
				]]>
			</script>
			<submission id="TRAES01601" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/main/list"/>
			<submission id="TRAES01602" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/main/list"/>
			<submission id="TRAES01502" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/init/cmb_lrgcd"/>
			<submission id="TRAER01003" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/init/cmb_mdlcd"/>
			<submission id="TRAEA01301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/cmb_info"/>
		</model>
		<script type="javascript">
			<![CDATA[
				
				/* @group	: 조영제통계
				 * @ver		: 
				 * @by		: 
				 * @-----------------------------------
				 * @type		: function
				 * @access	: public
				 * @desc		:  조영제통계 그리드 header를 정의하는 함수
				*/	
				function setTitle() {
					
					var srchstatsflag = model.getValue("/root/send/srchstatsflag");
					var baseDate = model.getValue("/root/send/srchdate") + "01";
					
					model.removenode("/root/main/list");
					
					var stHeader = "";
					var stMonthHeader = "";
					var stDay = "";
					var stMonth = "";
					
					var sDayCnt 	= baseDate.toDate().getMonthDay();
					var baseYear = baseDate.substr(0,4);
					
					stHeader = "구분^구분^";
					grd_daylist.colHidden(grd_daylist.colRef("systkey1")) = true;
					grd_monthlist.colHidden(grd_monthlist.colRef("systkey1")) = true;
					
					grd_daylist.colWidth(1) 		= 100;
					grd_monthlist.colWidth(1) 	= 100;
					
					grd_daylist.colWidth(2) = 240;
					grd_monthlist.colWidth(2) = 240;
						
					stDay = "1일^2일^3일^4일^5일^6일^7일^8일^9일^10일^11일^12일^13일^14일^15일^16일^17일^18일^19일^20일^21일^22일^23일^24일^25일^26일^27일^28일^29일^30일^31일^합계";
					stMonth = " " + baseYear + "년 ^ "+ baseYear + "년 ^ "+ baseYear + "년 ^ "+ baseYear + "년 ^ "+ baseYear + "년 ^ "+ baseYear + "년 ^ "+ baseYear + "년 ^ "+ baseYear + "년 ^ "+ baseYear + "년 ^ "+ baseYear + "년 ^ "+ baseYear + "년 ^ "+ baseYear + "년 ^ 합계 |"+ stHeader +" 1월 ^ 2월 ^ 3월 ^ 4월 ^ 5월 ^ 6월 ^ 7월 ^ 8월 ^ 9월 ^ 10월 ^ 11월 ^ 12월 ^ 합계 ";
					
					// 일별
					stDay = stHeader + stDay;
					grd_daylist.caption = stDay;
					
					// 월별
					stMonth = stHeader + stMonth;
					grd_monthlist.caption = stMonth;
					
					if(sDayCnt > 30) {
						grd_daylist.colHidden(grd_daylist.colRef("item29")) = false;
						grd_daylist.colHidden(grd_daylist.colRef("item30")) = false;
						grd_daylist.colHidden(grd_daylist.colRef("item31")) = false;
					}else if(sDayCnt < 30) {
						grd_daylist.colHidden(grd_daylist.colRef("item29")) = true;
						grd_daylist.colHidden(grd_daylist.colRef("item30")) = true;
						grd_daylist.colHidden(grd_daylist.colRef("item31")) = true;
					}else {
						grd_daylist.colHidden(grd_daylist.colRef("item29")) = false;
						grd_daylist.colHidden(grd_daylist.colRef("item30")) = false;
						grd_daylist.colHidden(grd_daylist.colRef("item31")) = true;
					}
					
					grd_daylist.rebuild();
					grd_monthlist.rebuild();
				}
				
				/* @group	: 조영제통계
				 * @ver		: 
				 * @by		: 
				 * @-----------------------------------
				 * @type		: function
				 * @access	: public
				 * @desc		:  조영제통계를 조회 하는 함수
				*/	
				function getimgSytsStatsCaseList(){
					
					// 일별
					if (btn_case1.selected == true) {
						model.setValue("/root/send/srchflag","D");
						grd_list = grd_daylist;
					// 월별	
					} else if (btn_case2.selected == true) {
						model.setValue("/root/send/srchflag","M");
						grd_list = grd_monthlist;
					}
					
					model.removenode("/root/main/list");
						
					if (submit("TRAES01602")) {
				
						var cnt = getNodesetCount("/root/main/list/item");
						
						if (cnt > 1) {
							
							var srchstatsflag = model.getValue("/root/send/srchstatsflag");
							
							// 소계 및 합계 구하는 함수 호출 - grid Object, 통계구분, 탭구분)
							fSetSubTotal(grd_list,  srchstatsflag , model.getValue("/root/send/srchflag"));
							
						}
					}
				}
				
				/* @group	: 조영제통계
				 * @ver		: 
				 * @by		: 
				 * @-----------------------------------
				 * @type		: function
				 * @access	: public
				 * @desc		:  조회된 통계 데이타에 대한 소계 및 총계를 구하는 함수
				*/	
				function fSetSubTotal(grd_list, srchstatsflag, srchflag) {
					
					var colpos = 0;
					var rowCnt = 0;
					
					grd_list.colSort(0) = "asc";
					grd_list.sort(0, 0, grd_list.rows, grd_list.cols) = "usersort";
					

					for(i=2; 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);
					
					rowCnt = 0;
					
					// 증감율 구하기
					var colnm = "";
					var subtotal = 0;
					var subcomparecnt = 0;
					var subcomparerate = "";
					
					for (i=0; i<rowCnt; i++) {

						colnm = grd_list.valueMatrix(i, colpos);
						
						if (colnm == "소계" ) {
						
							// 소계 합계
							subtotal = grd_list.valueMatrix(i, grd_list.colRef("total"));
							subcomparecnt = grd_list.valueMatrix(i, grd_list.colRef("comparecnt"));		
							grd_list.valueMatrix(i, grd_list.colRef("comparerate")) = setCompareRate(subtotal, subcomparecnt);
							
							// 분기별일 경우 분기별 증감율 구하기
							if (srchflag == "Q") {
								
								// 1분기
								subtotal = grd_list.valueMatrix(i, grd_list.colRef("item01"));
								subcomparecnt = grd_list.valueMatrix(i, grd_list.colRef("item09"));
								grd_list.valueMatrix(i, grd_list.colRef("item02")) = setCompareRate(subtotal, subcomparecnt);
								
								// 2분기
								subtotal = grd_list.valueMatrix(i, grd_list.colRef("item03"));
								subcomparecnt = grd_list.valueMatrix(i, grd_list.colRef("item10"));		
								grd_list.valueMatrix(i, grd_list.colRef("item04")) = setCompareRate(subtotal, subcomparecnt);
								
								// 3분기
								subtotal = grd_list.valueMatrix(i, grd_list.colRef("item05"));
								subcomparecnt = grd_list.valueMatrix(i, grd_list.colRef("item11"));		
								grd_list.valueMatrix(i, grd_list.colRef("item06")) = setCompareRate(subtotal, subcomparecnt);
								
								// 4분기
								subtotal = grd_list.valueMatrix(i, grd_list.colRef("item07"));
								subcomparecnt = grd_list.valueMatrix(i, grd_list.colRef("item12"));		
								grd_list.valueMatrix(i, grd_list.colRef("item08")) = setCompareRate(subtotal, subcomparecnt);
								
								grd_list.cellformat(i, grd_list.colRef("item02")) = "(-)#,### %";
								grd_list.cellformat(i, grd_list.colRef("item04")) = "(-)#,### %";
								grd_list.cellformat(i, grd_list.colRef("item06")) = "(-)#,### %";
								grd_list.cellformat(i, grd_list.colRef("item08")) = "(-)#,### %";
								grd_list.cellformat(i, grd_list.colRef("comparerate")) = "(-)#,### %";
							
							} // 분기별일 경우 분기별 증감율 구하기 끝
						}
					}
				}
				
				/* @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;
				}
			]]>
		</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; ">
			<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; background-image:../../../com/commonweb/images/btn1_letter2.gif; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[							
							
							openLoadingBar("조영제통계을 조회 중입니다....") ;			

							getimgSytsStatsCaseList();
							
							closeLoadingBar() ;//처리중 화면을 close한다.    
						]]>
					</script>
				</button>
				<caption id="caption7" class="search_name" style="left:310px; top:7px; width:86px; height:17px; ">대분류 :</caption>
				<select1 id="cmb_lrgcd" ref="/root/send/lrgcd" appearance="minimal" style="left:390px; top:5px; width:80px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/cmb_lrgcd/lrgcdlist">
							<label ref="cdnm"/>
							<value ref="cdid"/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
						model.setValue("/root/send/roomcd"," ")
						model.setValue("/root/send/srflag","S")
						model.refresh()
						/*model.setValue("/root/send/srflag","S")*/
//						var sectnm = combo1.label
//						model.setValue("/root/send/srchsectnm",sectnm)
						]]>
					</script>
				</select1>
				<caption id="caption3" class="search_name" style="left:510px; top:7px; width:86px; height:17px; ">검사실 :</caption>
				<select1 id="cmb_roomcd" ref="/root/send/roomcd" appearance="minimal" style="left:590px; top:5px; width:80px; height:19px; ">
					<choices>
						<itemset nodeset="/root/cmb_info/initexcuroomgrp2">
							<label ref="excuroomgrpcdnm"/>
							<value ref="excuroomgrpcdid"/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
						model.setValue("/root/send/lrgcd"," ")
						model.setValue("/root/send/srflag","R")
						model.refresh()
						]]>
					</script>
				</select1>
				<caption id="caption2" class="search_name" style="left:20px; top:7px; width:86px; height:17px; ">기준년월 :</caption>
				<input id="input4" ref="/root/send/srchdate" class="input_default" inputtype="date" format="yyyy-mm" style="left:110px; top:6px; width:90px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							setTitle();
						]]>
					</script>
				</input>
			</group>
			<button id="button2" class="btn2_letter4" visibility="visible" style="left:1130px; top:50px; 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_daylist.saveExcel(fileName);
								// 월별	
								} else if (btn_case2.selected == true) {
									grd_monthlist.saveExcel(fileName);
								}
							}
					]]>
				</script>
			</button>
			<button id="btn_case1" class="btn_sw" group="tab2" selected="true" style="left:2px; top:48px; width:60px; height:22px; ">
				<caption>일별</caption>
				<toggle case="case1" ev:event="onclick"/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						model.removenode("/root/main/list");
						model.refresh();
						model.toggle("case1");

						// 조영제통계 조회
						getimgSytsStatsCaseList();
					]]>
				</script>
			</button>
			<button id="btn_case2" class="btn_sw" group="tab2" style="left:62px; top:48px; width:60px; height:22px; ">
				<caption>월별</caption>
				<toggle case="case1" ev:event="onclick"/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						model.removenode("/root/main/list");
						model.refresh();
						model.toggle("case2");
						// 조영제통계 조회
						getimgSytsStatsCaseList();

					]]>
				</script>
			</button>
			<switch id="switch1" style="left:0px; top:75px; width:1195px; height:633px; ">
				<case id="case1" selected="true">
					<datagrid id="grd_daylist" nodeset="/root/main/list/item" backcoloralternate="transparent" caption="검사실^구분^1일^2일^3일^4일^5일^6일^7일^8일^9일^10일^11일^12일^13일^14일^15일^16일^17일^18일^19일^20일^21일^22일^23일^24일^25일^26일^27일^28일^29일^30일^31일^합계" colsep="^" colwidth="100, 240, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 60" frozencols="2" mergecells="byrestriccol" mergecellsfixedrows="bycolrec" multitotal="true" rowheader="seq" rowsep="|" subtotalposition="below" tooltip="true" style="left:0px; top:0px; width:1192px; height:625px; ">
						<col ref="systkey1" style="text-align:center; "/>
						<col ref="systkey2" style="text-align:left; "/>
						<col ref="item01" format="#,###" style="text-align:right; "/>
						<col ref="item02" format="#,###" style="text-align:right; "/>
						<col ref="item03" format="#,###" style="text-align:right; "/>
						<col ref="item04" format="#,###" style="text-align:right; "/>
						<col ref="item05" format="#,###" style="text-align:right; "/>
						<col ref="item06" format="#,###" style="text-align:right; "/>
						<col ref="item07" format="#,###" style="text-align:right; "/>
						<col ref="item08" format="#,###" style="text-align:right; "/>
						<col ref="item09" format="#,###" style="text-align:right; "/>
						<col ref="item10" format="#,###" style="text-align:right; "/>
						<col ref="item11" format="#,###" style="text-align:right; "/>
						<col ref="item12" format="#,###" style="text-align:right; "/>
						<col ref="item13" format="#,###" style="text-align:right; "/>
						<col ref="item14" format="#,###" style="text-align:right; "/>
						<col ref="item15" format="#,###" style="text-align:right; "/>
						<col ref="item16" format="#,###" style="text-align:right; "/>
						<col ref="item17" format="#,###" style="text-align:right; "/>
						<col ref="item18" format="#,###" style="text-align:right; "/>
						<col ref="item19" format="#,###" style="text-align:right; "/>
						<col ref="item20" format="#,###" style="text-align:right; "/>
						<col ref="item21" format="#,###" style="text-align:right; "/>
						<col ref="item22" format="#,###" style="text-align:right; "/>
						<col ref="item23" format="#,###" style="text-align:right; "/>
						<col ref="item24" format="#,###" style="text-align:right; "/>
						<col ref="item25" format="#,###" style="text-align:right; "/>
						<col ref="item26" format="#,###" style="text-align:right; "/>
						<col ref="item27" format="#,###" style="text-align:right; "/>
						<col ref="item28" format="#,###" style="text-align:right; "/>
						<col ref="item29" format="#,###" style="text-align:right; "/>
						<col ref="item30" format="#,###" style="text-align:right; "/>
						<col ref="item31" format="#,###" style="text-align:right; "/>
						<col ref="total" format="#,###" style="text-align:right; "/>
					</datagrid>
				</case>
				<case id="case2">
					<datagrid id="grd_monthlist" nodeset="/root/main/list/item" backcoloralternate="transparent" caption="구분^구분^2006년^2006년^2006년^2006년^2006년^2006년^2006년^2006년^2006년^2006년^2006년^2006년^합계^전년도합계^증감(%)|구분^구분^1월^2월^3월^4월^5월^6월^7월^8월^9월^10월^11월^12월^합계" colsep="^" colwidth="100, 240, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 92" ellipsis="true" mergecells="byrestriccol" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" subtotalposition="below" tooltip="true" style="left:0px; top:0px; width:1192px; height:625px; ">
						<col ref="systkey1" style="text-align:center; "/>
						<col ref="systkey2" style="text-align:left; "/>
						<col ref="item01" format="#,###" style="text-align:right; "/>
						<col ref="item02" format="#,###" style="text-align:right; "/>
						<col ref="item03" format="#,###" style="text-align:right; "/>
						<col ref="item04" format="#,###" style="text-align:right; "/>
						<col ref="item05" format="#,###" style="text-align:right; "/>
						<col ref="item06" format="#,###" style="text-align:right; "/>
						<col ref="item07" format="#,###" style="text-align:right; "/>
						<col ref="item08" format="#,###" style="text-align:right; "/>
						<col ref="item09" format="#,###" style="text-align:right; "/>
						<col ref="item10" format="#,###" style="text-align:right; "/>
						<col ref="item11" format="#,###" style="text-align:right; "/>
						<col ref="item12" format="#,###" style="text-align:right; "/>
						<col ref="total" format="#,###" style="text-align:right; "/>
					</datagrid>
				</case>
			</switch>
			<line id="line1" class="line_1" style="x1:0px; y1:70px; x2:1195px; y2:70px; "/>
		</group>
	</xhtml:body>
</xhtml:html>