YNU_JEUS/app_home/himed/webapps/lis/statsmngtweb/xrw/SMLLS00800_장비별검사건수.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<!--
	* 제    목		: SMLLS00800_장비별검사건수.xrw
	* 설    명		: 장비별검사건수
	* 설 계 자	: (주)에이씨케이 - 윤재한
	* 작 성 자	: (주)에이씨케이 - 
	* 작 성 일	: 2008.04.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>
						<ddstats/>
						<yystats/>
					</main>
					<send/>
					<init>
					</init>
					<hidden>
						<statshopefromdd/>
						<statshopetodd/>
						<sectcd/>
						<testeqmtcd/>
					</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" src="../../../lis/commonweb/js/LLZ001.js"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					fSetInit(); //초기화 함수 호출
				]]>
			</script>
			<submission id="TRLLS00801" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/main/ddstats"/>
			<submission id="TRLLS00802" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/hidden/yystats"/>
			<submission id="TRLZZ00101" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/init"/>
		</model>
		<script type="javascript">
			<![CDATA[
				//화면 open시 초기화
				function fSetInit() {
					fBaseInfoRef("0111|1111|"); //0111 : 계코드, 0115 : 장비
					
					var toDay = getCurrentDate();
					
					model.setValue("/root/hidden/statshopefromdd", toDay); //통계희망시작일 = 현재일자
					model.setValue("/root/hidden/statshopetodd", toDay); //통계희망종료일 = 현재일자
					model.setValue("/root/hidden/sectcd", "00"); //계코드를 '전체'로 지정
					model.setValue("/root/hidden/testeqmtcd", "00"); //장비코드를 '전체'로 지정
					
					//그리드초기화
					model.removeNodeset("/root/main/ddstats"); //일별, 월별
					model.removeNodeset("/root/main/yystats"); //연별
					
					model.toggle("dd"); //초기시 일별그리드 표시
					btn_ddstats.selected = true; //일별switch 버튼 선택
					
					model.refresh();
				}	
				
				//switch 버튼 클릭시 그리드 초기화
				function fGridInit() {
				     	var cols = grd_yy.cols-grd_yy.fixedCols;
				     	
					for( var i = 0; i < cols; i++ ) {
						grd_yy.removeColumn(); //연별 그리드 컬럼 다 지우기.. 지우지 않으면 그리드 형태가 유지되어 다른 통계 조회후 연별 통계시 그리드 옆에 이어져 조회됨.
					}
					
					model.removeNodeset("/root/main/ddstats"); //일별, 월별
					model.removeNodeset("/root/main/yystats"); //연별
					
					model.refresh();
				}
				
				//통계희망일, 검사시행부서, 장비, 조회구분(일,월,연) 에 따른 조회
				function fGetStats() {
					if(btn_ddstats.selected == true) {
						model.makeValue("/root/send/refflag", "d");
					} else if(btn_mmstats.selected == true) {
						model.makeValue("/root/send/refflag", "m");
					} else if(btn_yystats.selected == true) {
						fGetYYStats();
						return;
					}
					
					model.makeValue("/root/send/sectcd", model.getValue("/root/hidden/sectcd")); //계코드
					model.makeValue("/root/send/testeqmtcd", model.getValue("/root/hidden/testeqmtcd")); //장비코드
					model.makeValue("/root/send/statshopefromdd", model.getValue("/root/hidden/statshopefromdd")); //통계희망시작일
					model.makeValue("/root/send/statshopetodd", model.getValue("/root/hidden/statshopetodd")); //통계희망종료일
					
					submit("TRLLS00801");
					
					model.removeNodeset("/root/send");
					model.makeNode("/root/send");
				}	
				
				//연별 통계 조회
				function fGetYYStats() {
				     	var cols = grd_yy.cols-grd_yy.fixedCols;
					var rows = grd_yy.rows-grd_yy.fixedRows;
					
					for( var i = 0; i < cols; i++ ) {
						grd_yy.removeColumn(false); //연별 그리드 컬럼 다 지우기..지우지 않으면 그리드 형태가 유지되어 그리드 옆에 이어져 조회됨.
					}
					
					model.removeNodeset("/root/main/yystats"); //연별그리드 초기화
					
					model.makeNode("/root/main/yystats/row");
				
					model.makeValue("/root/send/sectcd", model.getValue("/root/hidden/sectcd")); //계코드
					model.makeValue("/root/send/testeqmtcd", model.getValue("/root/hidden/testeqmtcd")); //장비코드
					model.makeValue("/root/send/statshopefromdd", model.getValue("/root/hidden/statshopefromdd")); //통계희망시작일
					model.makeValue("/root/send/statshopetodd", model.getValue("/root/hidden/statshopetodd")); //통계희망종료일
					
					submit("TRLLS00802"); //통계조회
					
					model.removeNodeset("/root/send");
					model.makeNode("/root/send");
					
					//caption 정보
					var gridCaption = model.getValue("/root/hidden/yystats/header/caption");	
					if(gridCaption == "") return;
					
					//ref 정보
					var gridColRef = model.getValue("/root/hidden/yystats/header/colref");
					var gridColRefArray = gridColRef.split("^");
					
					//type 정보
					var gridColType = model.getValue("/root/hidden/yystats/header/type");
					var gridColTypeArray = gridColType.split("^");
					
					for( var i = 0; i < gridColRefArray.length; i++ ) {	
						if(i == 0) {
							grd_yy.addColumn("ref:" + gridColRefArray[i] + "; type:"+gridColTypeArray[i]+";  style:text-align:left; ", false); //Grid 속성 지정
						} else {
							grd_yy.addColumn("ref:" + gridColRefArray[i] + "; type:"+gridColTypeArray[i]+";  format:#,###; ", false); //Grid 속성 지정
						}
					}	
					
					grd_yy.colWidth(1) = 150; //검사항목 Column은 폭이 달라서 따로 지정.
					
					for(  i = 2; i < grd_yy.cols; i++ ) {				
						grd_yy.colWidth(i) = 60;	//Column 폭 조정
					}
					
					grd_yy.caption = gridCaption; //Caption 지정
					
					var node = instance1.selectSingleNode("/root/main");
					node.replaceChild(instance1.root.hidden.yystats, instance1.root.main.yystats); //조회하고 수정한 사항을 main에 보냄
					
					grd_yy.rowheight(0) = 23; //Title 높이 조정
										
					model.refresh();
					
					fGetTotal(); //연도별 Total 계산
				}
				
				//연도별 통계 Total계산
				function fGetTotal() {
					//Column 합계
					for(r = 1; r < grd_yy.rows; r++) {
						colsum = 0;
						for(i = 2; i < grd_yy.cols - 1; i++) {
							if(grd_yy.textmatrix(r, i) != "") {
								colsum += parseInt(grd_yy.textmatrix(r, i));
							}
						}
						model.setValue("/root/main/yystats/row["+ r +"]/total", colsum);
					}
					
					//Row 합계
					grd_yy.addRow();
					model.refresh();
					
					grd_yy.textmatrix(grd_yy.rows-1, 1) = "Total";
					
					for(i = 2; i < grd_yy.cols; i++) {
						rowsum = 0;
						for(r = 1; r < grd_yy.rows-1; r++) {
							if(grd_yy.textmatrix(r, i) != "") {
								rowsum += parseInt(grd_yy.textmatrix(r, i));
							}
						}
						
						grd_yy.textmatrix(grd_yy.rows-1, i) = rowsum;
					}
				}
				
				//엑셀저장
				function fExeSaveToExcel() {
					 if(btn_ddstats.selected == true) { //일별
						fSaveExcel("grd_dd");
					} else if(btn_mmstats.selected == true) { //월별
						fSaveExcel("grd_mm");
					} else if(btn_yystats.selected == true) { //연별
						fSaveExcel("grd_yy");
					}
				}
				
				//통계그리드를 출력한다.
				function fPrint() {
					 if(btn_ddstats.selected == true) { //일별
					 	exeReportPreview("RPLLS01000");
					} else if(btn_mmstats.selected == true) { //월별
					 	exeReportPreview("RPLLS01100");
					} else if(btn_yystats.selected == true) { //연별
					 	exeReportPreview("RPLLS01300");
					}
				}
			]]>
		</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:744; ">
			<group id="group1" style="left:0px; top:10px; width:1195px; height:35px; ">
				<shape id="roundrect2" class="roundrect_search" appearance="roundrect" style="left:0px; top:0px; width:1195px; height:35px; "/>
				<button id="btn_ref" class="btn1_letter2" style="left:1123px; top:7px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							fGetStats();
						]]>
					</script>
				</button>
				<line id="line3" class="line_4" style="x1:1108px; y1:6px; x2:1108px; y2:28px; "/>
				<caption id="caption5" class="search_name" style="left:862px; top:9px; width:61px; height:17px; ">장비 :</caption>
				<input id="ipt_workfromdd" ref="/root/hidden/statshopefromdd" class="input_search" inputtype="date" style="left:128px; top:8px; width:90px; height:19px; "/>
				<input id="ipt_worktodd" ref="/root/hidden/statshopetodd" class="input_search" inputtype="date" style="left:233px; top:8px; width:90px; height:19px; "/>
				<caption id="caption4" class="search_name" style="left:15px; top:9px; width:110px; height:17px; ">통계 희망일 :</caption>
				<caption id="caption9" class="search_no_b" style="left:220px; top:10px; width:13px; height:17px; ">~</caption>
				<select1 id="cmb_rtnabnflag" ref="/root/hidden/testeqmtcd" appearance="minimal" itemcount="20" style="left:926px; top:8px; width:167px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/LB1111">
							<label ref="nm"/>
							<value ref="cd"/>
						</itemset>
					</choices>
				</select1>
				<select1 id="combo1" ref="/root/hidden/sectcd" appearance="minimal" style="left:757px; top:8px; width:102px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/LB0111">
							<label ref="nm"/>
							<value ref="cd"/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							var lrg = model.getvalue("/root/hidden/sectcd");
								
							if(lrg == "00"){
								cmb_rtnabnflag.choices.itemset.attribute("nodeset") = "/root/init/LB1111";
//								model.setValue("/root/hidden/testeqmtcd/cd" , "00");									
							}
							else{
//								model.setValue("/root/hidden/testeqmtcd/cd" , "00");									
								cmb_rtnabnflag.choices.itemset.attribute("nodeset") = "/root/init/LB1111[cd= '00'  or etc01='"+  lrg +"']";			
							}
							cmb_rtnabnflag.refresh();						
						]]>
					</script>
				</select1>
				<caption id="caption1" class="search_name" style="left:641px; top:9px; width:113px; height:17px; ">검사시행부서 :</caption>
			</group>
			<switch id="swt_statflag" class="sw_box" style="left:0px; top:75px; width:1195px; height:663px; ">
				<case id="dd">
					<datagrid id="grd_dd" nodeset="/root/main/ddstats" caption="검사항목^01^02^03^04^05^06^07^08^09^10^11^12^13^14^15^16^17^18^19^20^21^22^23^24^25^26^27^28^29^30^31^Total" colsep="^" colwidth="150, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 60" dataheight="23" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="23" style="left:5px; top:5px; width:1180px; height:646px; text-align:right; ">
						<col ref="tclsscrnnm" style="text-align:left; "/>
						<col ref="d01" format="#,###"/>
						<col ref="d02" format="#,###"/>
						<col ref="d03" format="#,###"/>
						<col ref="d04" format="#,###"/>
						<col ref="d05" format="#,###"/>
						<col ref="d06" format="#,###"/>
						<col ref="d07" format="#,###"/>
						<col ref="d08" format="#,###"/>
						<col ref="d09" format="#,###"/>
						<col ref="d10" format="#,###"/>
						<col ref="d11" format="#,###"/>
						<col ref="d12" format="#,###"/>
						<col ref="d13" format="#,###"/>
						<col ref="d14" format="#,###"/>
						<col ref="d15" format="#,###"/>
						<col ref="d16" format="#,###"/>
						<col ref="d17" format="#,###"/>
						<col ref="d18" format="#,###"/>
						<col ref="d19" format="#,###"/>
						<col ref="d20" format="#,###"/>
						<col ref="d21" format="#,###"/>
						<col ref="d22" format="#,###"/>
						<col ref="d23" format="#,###"/>
						<col ref="d24" format="#,###"/>
						<col ref="d25" format="#,###"/>
						<col ref="d26" format="#,###"/>
						<col ref="d27" format="#,###"/>
						<col ref="d28" format="#,###"/>
						<col ref="d29" format="#,###"/>
						<col ref="d30" format="#,###"/>
						<col ref="d31" format="#,###"/>
						<col ref="total" format="#,###"/>
						<script type="javascript" ev:event="onaftersort">
							<![CDATA[
								grd_dd.gridToInstance();
							]]>
						</script>
					</datagrid>
				</case>
				<case id="mm" selected="true">
					<datagrid id="grd_mm" nodeset="/root/main/ddstats" caption="검사항목^01^02^03^04^05^06^07^08^09^10^11^12^Total" colsep="^" colwidth="150, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60" dataheight="23" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="23" style="left:5px; top:5px; width:1180px; height:646px; text-align:right; ">
						<col ref="tclsscrnnm" style="text-align:left; "/>
						<col ref="d01" format="#,###"/>
						<col ref="d02" format="#,###"/>
						<col ref="d03" format="#,###"/>
						<col ref="d04" format="#,###"/>
						<col ref="d05" format="#,###"/>
						<col ref="d06" format="#,###"/>
						<col ref="d07" format="#,###"/>
						<col ref="d08" format="#,###"/>
						<col ref="d09" format="#,###"/>
						<col ref="d10" format="#,###"/>
						<col ref="d11" format="#,###"/>
						<col ref="d12" format="#,###"/>
						<col ref="total" format="#,###"/>
						<script type="javascript" ev:event="onaftersort">
							<![CDATA[
								grd_mm.gridToInstance();
							]]>
						</script>
					</datagrid>
				</case>
				<case id="yy">
					<datagrid id="grd_yy" nodeset="/root/main/yystats/row" backcoloralternate="transparent" colsep="^" dataheight="23" explorerbar="sortshow" frozencols="2" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="23" style="left:5px; top:5px; width:1180px; height:646px; text-align:center; ">
						<script type="javascript" ev:event="onaftersort">
							<![CDATA[
								grd_qurtyy.gridToInstance();
							]]>
						</script>
					</datagrid>
				</case>
			</switch>
			<button id="btn_mmstats" class="btn_sw" group="tab" style="left:75px; top:54px; width:75px; height:22px; ">
				<caption>월별 통계</caption>
				<toggle case="mm" ev:event="DOMActivate"/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fGridInit();
					]]>
				</script>
			</button>
			<button id="btn_ddstats" class="btn_sw" group="tab" style="left:0px; top:54px; width:75px; height:22px; ">
				<caption>일별 통계</caption>
				<toggle case="dd" ev:event="DOMActivate"/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fGridInit();
					]]>
				</script>
			</button>
			<button id="btn_yystats" class="btn_sw" group="tab" style="left:150px; top:54px; width:75px; height:22px; ">
				<caption>연별 통계</caption>
				<toggle case="yy" ev:event="DOMActivate"/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fGridInit();
					]]>
				</script>
			</button>
		</group>
		<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:800px; height:14px; ">장비별 검사 건수</caption>
		<group id="group4" scroll="auto" style="left:0px; top:13px; width:1195px; height:27px; ">
			<line id="line2" class="line_2" style="x1:0px; y1:25px; x2:1195px; y2:25px; "/>
			<button id="btn_print" class="btn6_letter2" visibility="hidden" style="left:0px; top:3px; width:56px; height:22px; ">
				<caption>출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						//fPrint();
					]]>
				</script>
			</button>
			<button id="btn_excel" class="btn6_letter5" style="left:0px; top:3px; width:92px; height:22px; ">
				<caption>EXCEL저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fExeSaveToExcel();		
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>