YNU_JEUS/app_home/himed/webapps/lis/statsmngtweb/xrw/SMLLS01700_진단검사통계.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<!--
	* 제    목		: 채혈접수취소내역조회.xrw
	* 설    명		: 채혈접수취소내역조회
	* 설 계 자	        : (주)에이씨케이 - 
	* 작 성 자	        : (주)에이씨케이 - 유은자
	* 작 성 일	        : 2010.01.18
	* 수정이력	: 
	* 기    타	: 
-->
<?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>
						<queryinfo>
							<itemnm/>
							<a01/>
							<b01/>
							<c01/>
							<d01/>
							<a02/>
							<b02/>
							<c02/>
							<d02/>
							<a03/>
							<b03/>
							<c03/>
							<d03/>
							<a04/>
							<b04/>
							<c04/>
							<d04/>
							<a05/>
							<b05/>
							<c05/>
							<d05/>
							<a06/>
							<b06/>
							<c06/>
							<d06/>
							<a07/>
							<b07/>
							<c07/>
							<d07/>
							<a08/>
							<b08/>
							<c08/>
							<d08/>
							<a09/>
							<b09/>
							<c09/>
							<d09/>
							<a10/>
							<b10/>
							<c10/>
							<d10/>
							<a11/>
							<b11/>
							<c11/>
							<d11/>
							<a12/>
							<b12/>
							<c12/>
							<d12/>
							<total/>
						</queryinfo>
						<queryinfo2>
							<itemnm/>
							<a01/>
							<b01/>
							<c01/>
							<d01/>
							<a02/>
							<b02/>
							<c02/>
							<d02/>
							<a03/>
							<b03/>
							<c03/>
							<d03/>
						</queryinfo2>
					</main>
					<send>
						<fromdd/>
						<todd/>
						<qrygbn/>
					</send>
					<init>
					</init>
					<hidden>
						<forminfo>
							<fromdd/>
							<todd/>
							<qrygbn>1</qrygbn>
							<ddgbn/>
						</forminfo>
					</hidden>
				</root>
			</instance>
			<script type="javascript" src="../../../com/commonweb/js/common.js"/>
			<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					fnSetInit();
				]]>
			</script>
			<submission id="TRLLS01701" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/main/queryinfo"/>
			<submission id="TRLLS01702" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/main/queryinfo"/>
		</model>
		<script type="javascript">
			<![CDATA[
			
			//초기화
			function fnSetInit(){
				
				var toDay = getCurrentDate();
				
				model.setValue("/root/hidden/forminfo/fromdd", toDay);
				model.setValue("/root/hidden/forminfo/todd",     toDay);
				model.setValue("/root/hidden/forminfo/ddgbn", "1"); // 1:월별 2:연별 
				model.removeNodeset("/root/main/queryinfo");
				fSetddview(); // 월별 연별따라 일자구분 , 그리드 셋팅 
				model.refresh();
			}
			
			//진단검사통계
			function fnGetLaboratory(){
				
				if(model.getValue("/root/hidden/forminfo/ddgbn")=="2"){ // 연별통계일때 
					var fromyy = parseInt(model.getValue("/root/hidden/forminfo/fromdd").substr(0,4));
					var toyy     = parseInt(model.getValue("/root/hidden/forminfo/todd").substr(0,4));
					if(toyy -  fromyy < 0){
						alert("종료일이 시작일보다 작습니다");
						return;
					}
	
					if(toyy -  fromyy >= 3){
						alert("조회는 3년까지만 제공합니다");
						return;
					}
				}
				
				model.removeNodeset("/root/main/queryinfo");
				model.removeNodeset("/root/main/queryinfo2");
				
				model.setValue("/root/send/qrygbn",              model.getValue("/root/hidden/forminfo/qrygbn"));   	 // 구분
				model.setValue("/root/send/fromdd",              model.getValue("/root/hidden/forminfo/fromdd"));   	// 시작일시
				model.setValue("/root/send/todd",            	model.getValue("/root/hidden/forminfo/todd"));   	// 종료일시

				if(model.getValue("/root/hidden/forminfo/ddgbn")=="1"){ // 월별통계일때 
					submit("TRLLS01701");	
					
					for(i=1; i< grd_data.rows; i++){
						grd_data.cellStyle("background-color", i,  1, i,  1) = "#ffe79d"; //1월 
						grd_data.cellStyle("background-color", i,  6, i,  6) = "#ffe79d"; //2월 
						grd_data.cellStyle("background-color", i, 11, i, 11) = "#ffe79d"; //3
						grd_data.cellStyle("background-color", i, 16, i, 16) = "#ffe79d"; //4
						grd_data.cellStyle("background-color", i, 21, i, 21) = "#ffe79d"; //5
						grd_data.cellStyle("background-color", i, 26, i, 26) = "#ffe79d"; //6
						grd_data.cellStyle("background-color", i, 31, i, 31) = "#ffe79d"; //7
						grd_data.cellStyle("background-color", i, 36, i, 36) = "#ffe79d"; //8
						grd_data.cellStyle("background-color", i, 41, i, 41) = "#ffe79d"; //9 
						grd_data.cellStyle("background-color", i, 46, i, 46) = "#ffe79d";//10 
						grd_data.cellStyle("background-color", i, 51, i, 51) = "#ffe79d"; //11
						grd_data.cellStyle("background-color", i, 56, i, 56) = "#ffe79d"; // 12
					
					}
				}else{ // 연별통계 
					yycaption();
					submit("TRLLS01702");	
					
					for(i=1; i< grd_datayy.rows; i++){
						grd_datayy.cellStyle("background-color", i,  1, i,  1) = "#ffe79d"; //1
						grd_datayy.cellStyle("background-color", i,  6, i,  6) = "#ffe79d"; //2 
						grd_datayy.cellStyle("background-color", i, 11, i, 11) = "#ffe79d"; //3
					}
				}
			}
	
	
						
			function fnExeExcel(pGridId) {
				var fileName = window.fileDialog("save", ",", false, "excel", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");

				if (fileName != "")
				{
					pGridId.saveExcel(fileName);
				}
			
			}	
			
			// 월별 / 연별로 날짜, 그리드 바꿔줌 
			function fSetddview(){
				var gbn = model.getValue("/root/hidden/forminfo/ddgbn");
				
				if(gbn =="1"){ // 월별 
					model.setValue("/root/hidden/forminfo/fromdd", getCurrentDate());
					ipt_fromdd.visible = true; //시작일
					caption3.visible = false; //~
					ipt_todd.visible = false;  //종료일
					
					grd_data.visible = true;  // 월별그리드 
					grd_datayy.visible = false; //연별그리드
					
					ipt_fromdd.attribute("format") = "yyyy-mm";  
					ipt_todd.attribute("format")= "yyyy-mm";  
				}else if(gbn =="2"){ // 연별 
					ipt_fromdd.visible = true; //시작일
					caption3.visible = true; //~
					ipt_todd.visible = true;  //종료일
					
					grd_data.visible = false; //월별그리드
					grd_datayy.visible = true; //연별그리드
					
					ipt_fromdd.attribute("format") = "yyyy"; 
					ipt_todd.attribute("format")= "yyyy"; 
					yycaption();
					
				}
				model.refresh();
			} 
			
			// 연별 그리드 캡션 
			function yycaption(){
				for(j=6; j<16; j++){
					grd_datayy.colHidden(j) = true;
				}
					
				// 3년만 조회하기땜에 
				var fromyy = parseInt(model.getValue("/root/hidden/forminfo/fromdd").substr(0,4));
				var toyy     = parseInt(model.getValue("/root/hidden/forminfo/todd").substr(0,4));
				var cap1 = "^"; 
				var cap2 = "^소계^본원시행^본원시행^외부검사^외부검사^소계^본원시행^본원시행^외부검사^외부검사^소계^본원시행^본원시행^외부검사^외부검사^"; 
				var cap3 = "^소계^본원처방^수탁검사^검사센터^CMC병원^소계^본원처방^수탁검사^검사센터^CMC병원^소계^본원처방^수탁검사^검사센터^CMC병원^"; 
				
				for(i=0 ; i<3; i++){
					cap1 +=  (fromyy+i) + "^" + (fromyy+i) + "^" + (fromyy+i) + "^" + (fromyy+i) + "^" + (fromyy+i) + "^";  
				}
				//var newcap1 = cap1; 
				grd_datayy.caption = cap1 + "|" + cap2 + "|" +  cap3 ; 
				
				var  ab =   toyy -  fromyy ; 
				
				
				if(ab==0){  // 1년 
					for(j=6; j<16; j++){
						grd_datayy.colHidden(j) = true;
					}
				}				

				if(ab==1){  // 2년 
					for(j=0; j<11; j++){
						grd_datayy.colHidden(j) = false;
					}
				}				

				if(ab > 1){  // 2년 
					for(j=1; j<16; j++){
						grd_datayy.colHidden(j) = false;
					}
				}	
			}
			
		]]>
		</script>
	</xhtml:head>
	<xhtml:body style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="group3" scroll="auto" style="left:0px; top:40px; width:1195px; height:744px; ">
			<datagrid id="grd_datayy" nodeset="/root/main/queryinfo2" caption="^A^A^A^A^A^B^B^B^B^B^C^C^C^C^C|^소계^본원시행^본원시행^외부검사^외부검사^소계^본원시행^본원시행^외부검사^외부검사^소계^본원시행^본원시행^외부검사^외부검사|^소계^본원처방^수탁검사^검사센터^CMC병원^소계^본원처방^수탁검사^검사센터^CMC병원^소계^본원처방^수탁검사^검사센터^CMC병원" colsep="^" colwidth="110, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70" dataheight="23" explorerbar="sortshow" fixedcols="1" mergecellsfixedrows="bycolrec" rowheight="23" rowsep="|" tooltip="true" style="left:5px; top:65px; width:1185px; height:670px; ">
				<col ref="itemnm"/>
				<col ref="t01" style="text-align:right; "/>
				<col ref="a01" style="text-align:right; "/>
				<col ref="b01" style="text-align:right; "/>
				<col ref="c01" style="text-align:right; "/>
				<col ref="d01" style="text-align:right; "/>
				<col ref="t02" style="text-align:right; "/>
				<col ref="a02" style="text-align:right; "/>
				<col ref="b02" style="text-align:right; "/>
				<col ref="c02" style="text-align:right; "/>
				<col ref="d02" style="text-align:right; "/>
				<col ref="t03" style="text-align:right; "/>
				<col ref="a03" style="text-align:right; "/>
				<col ref="b03" style="text-align:right; "/>
				<col ref="c03" style="text-align:right; "/>
				<col ref="d03" style="text-align:right; "/>
			</datagrid>
			<datagrid id="grd_data" nodeset="/root/main/queryinfo" caption="^1월^1월^1월^1월^1월^2월^2월^2월^2월^2월^3월^3월^3월^3월^3월^4월^4월^4월^4월^4월^5월^5월^5월^5월^5월^6월^6월^6월^6월^6월^7월^7월^7월^7월^7월^8월^8월^8월^8월^8월^9월^9월^9월^9월^9월^10월^10월^10월^10월^10월^11월^11월^11월^11월^11월^12월^12월^12월^12월^12월^Total|^1월 소계^본원시행^본원시행^외부검사^외부검사^2월 소계^본원시행^본원시행^외부검사^외부검사^3월 소계^본원시행^본원시행^외부검사^외부검사^4월 소계^본원시행^본원시행^외부검사^외부검사^5월 소계^본원시행^본원시행^외부검사^외부검사^6월 소계^본원시행^본원시행^외부검사^외부검사^7월 소계^본원시행^본원시행^외부검사^외부검사^8월 소계^본원시행^본원시행^외부검사^외부검사^9월 소계^본원시행^본원시행^외부검사^외부검사^10월 소계^본원시행^본원시행^외부검사^외부검사^11월 소계^본원시행^본원시행^외부검사^외부검사^12월 소계^본원시행^본원시행^외부검사^외부검사^Total|^1월 소계^본원처방^수탁검사^검사센터^칠곡병원^2월 소계^본원처방^수탁검사^검사센터^칠곡병원^3월 소계^본원처방^수탁검사^검사센터^칠곡병원^4월 소계^본원처방^수탁검사^검사센터^칠곡병원^5월 소계^본원처방^수탁검사^검사센터^칠곡병원^6월 소계^본원처방^수탁검사^검사센터^칠곡병원^7월 소계^본원처방^수탁검사^검사센터^칠곡병원^8월 소계^본원처방^수탁검사^검사센터^칠곡병원^9월 소계^본원처방^수탁검사^검사센터^칠곡병원^10월 소계^본원처방^수탁검사^검사센터^칠곡병원^11월 소계^본원처방^수탁검사^검사센터^칠곡병원^12월 소계^본원처방^수탁검사^검사센터^칠곡병원^Total" colsep="^" colwidth="110, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 80" dataheight="23" explorerbar="sortshow" fixedcols="1" mergecellsfixedrows="bycolrec" rowheight="23" rowsep="|" tooltip="true" style="left:5px; top:65px; width:1185px; height:670px; ">
				<col ref="itemnm"/>
				<col ref="t01" style="text-align:right; "/>
				<col ref="a01" style="text-align:right; "/>
				<col ref="b01" style="text-align:right; "/>
				<col ref="c01" style="text-align:right; "/>
				<col ref="d01" style="text-align:right; "/>
				<col ref="t02" style="text-align:right; "/>
				<col ref="a02" style="text-align:right; "/>
				<col ref="b02" style="text-align:right; "/>
				<col ref="c02" style="text-align:right; "/>
				<col ref="d02" style="text-align:right; "/>
				<col ref="t03" style="text-align:right; "/>
				<col ref="a03" style="text-align:right; "/>
				<col ref="b03" style="text-align:right; "/>
				<col ref="c03" style="text-align:right; "/>
				<col ref="d03" style="text-align:right; "/>
				<col ref="t04" style="text-align:right; "/>
				<col ref="a04" style="text-align:right; "/>
				<col ref="b04" style="text-align:right; "/>
				<col ref="c04" style="text-align:right; "/>
				<col ref="d04" style="text-align:right; "/>
				<col ref="t05" style="text-align:right; "/>
				<col ref="a05" style="text-align:right; "/>
				<col ref="b05" style="text-align:right; "/>
				<col ref="c05" style="text-align:right; "/>
				<col ref="d05" style="text-align:right; "/>
				<col ref="t06" style="text-align:right; "/>
				<col ref="a06" style="text-align:right; "/>
				<col ref="b06" style="text-align:right; "/>
				<col ref="c06" style="text-align:right; "/>
				<col ref="d06" style="text-align:right; "/>
				<col ref="t07" style="text-align:right; "/>
				<col ref="a07" style="text-align:right; "/>
				<col ref="b07" style="text-align:right; "/>
				<col ref="c07" style="text-align:right; "/>
				<col ref="d07" style="text-align:right; "/>
				<col ref="t08" style="text-align:right; "/>
				<col ref="a08" style="text-align:right; "/>
				<col ref="b08" style="text-align:right; "/>
				<col ref="c08" style="text-align:right; "/>
				<col ref="d08" style="text-align:right; "/>
				<col ref="t09" style="text-align:right; "/>
				<col ref="a09" style="text-align:right; "/>
				<col ref="b09" style="text-align:right; "/>
				<col ref="c09" style="text-align:right; "/>
				<col ref="d09" style="text-align:right; "/>
				<col ref="t10" style="text-align:right; "/>
				<col ref="a10" style="text-align:right; "/>
				<col ref="b10" style="text-align:right; "/>
				<col ref="c10" style="text-align:right; "/>
				<col ref="d10" style="text-align:right; "/>
				<col ref="t11" style="text-align:right; "/>
				<col ref="a11" style="text-align:right; "/>
				<col ref="b11" style="text-align:right; "/>
				<col ref="c11" style="text-align:right; "/>
				<col ref="d11" style="text-align:right; "/>
				<col ref="t12" style="text-align:right; "/>
				<col ref="a12" style="text-align:right; "/>
				<col ref="b12" style="text-align:right; "/>
				<col ref="c12" style="text-align:right; "/>
				<col ref="d12" style="text-align:right; "/>
				<col ref="total" style="text-align:right; "/>
			</datagrid>
			<group id="group1" style="left:0px; top:0px; width:1192px; height:35px; ">
				<shape id="roundrect2" class="roundrect_search" appearance="roundrect" style="left:0px; top:0px; width:1189px; height:35px; "/>
				<line id="line3" class="line_4" style="x1:1100px; y1:6px; x2:1100px; y2:28px; "/>
				<button id="btn_search" class="btn1_letter2" style="left:1113px; top:7px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							fnGetLaboratory();								
						]]>
					</script>
				</button>
				<caption id="caption3" class="search_no_b" style="left:395px; top:8px; width:15px; height:17px; ">~</caption>
				<input id="ipt_fromdd" ref="/root/hidden/forminfo/fromdd" class="input_search" inputtype="date" format="yyyy-mm" style="left:310px; top:8px; width:80px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							yycaption();
						]]>
					</script>
				</input>
				<input id="ipt_todd" ref="/root/hidden/forminfo/todd" class="input_search" inputtype="date" format="yyyy-mm" style="left:415px; top:8px; width:80px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							yycaption();
						]]>
					</script>
				</input>
				<caption id="cap_date" class="search_name" style="left:240px; top:9px; width:65px; height:17px; ">일자 :</caption>
				<caption id="cap_qrygbn" class="search_name" style="left:610px; top:9px; width:90px; height:17px; ">조회구분 :</caption>
				<select1 id="rdo_qrygbn" ref="/root/hidden/forminfo/qrygbn" class="radio_search" appearance="full" cols="2" overflow="visible" style="left:705px; top:10px; width:140px; height:15px; border-style:none; ">
					<choices>
						<item>
							<label>접수건수</label>
							<value>1</value>
						</item>
						<item>
							<label>검사건수</label>
							<value>2</value>
						</item>
					</choices>
				</select1>
				<select1 id="radio1" ref="/root/hidden/forminfo/ddgbn" class="radio_search" appearance="full" cellspacing="20" cols="2" overflow="visible" style="left:35px; top:10px; width:125px; height:15px; border-style:none; ">
					<choices>
						<item>
							<label>월별</label>
							<value>1</value>
						</item>
						<item>
							<label>연별</label>
							<value>2</value>
						</item>
					</choices>
					<script type="javascript" ev:event="xforms-select">
						<![CDATA[
							fSetddview();
						]]>
					</script>
				</select1>
			</group>
			<caption id="caption4" class="tit_2" style="left:10px; top:45px; width:150px; height:13px; ">진단검사통계</caption>
			<line id="line1" class="line_1" style="x1:5px; y1:60px; x2:1190px; y2:60px; "/>
			<button id="button2" class="btn2_letter2" style="left:1148px; top:39px; width:42px; height:19px; ">
				<caption>엑셀</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fnExeExcel(grd_data);	
					]]>
				</script>
			</button>
			<caption id="caption1" visibility="hidden" style="left:150px; top:40px; width:238px; height:20px; ">월별 연별 그리드 다름  맨뒤로 보내면 나옴</caption>
		</group>
		<group id="group4" scroll="auto" style="left:0px; top:13px; width:1195px; height:27px; ">
			<line id="line17" class="line_6" style="x1:0px; y1:25px; x2:1190px; y2:25px; "/>
			<button id="btn_clear" class="btn4_letter3" style="left:1121px; top:3px; width:68px; height:22px; ">
				<caption>초기화</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fnSetInit();
					]]>
				</script>
			</button>
		</group>
		<group id="group2" style="left:0px; top:0px; width:1195px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:800px; height:14px; ">진단검사통계</caption>
		</group>
	</xhtml:body>
</xhtml:html>