YNU_JEUS/app_home/himed/webapps/lis/refprintmngtweb/xrw/SMLLP02300_범용통계.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<!--
	* 제    목		: SMLLS01600_범용조회.xrw
	* 설    명		: 범용조회
	* 설 계 자	: (주)에이씨케이 - 윤재한
	* 작 성 자	: (주)에이씨케이 - 
	* 작 성 일	: 2008.04.21
	* 수정이력	: 
	* 기    타	: 
-->
<?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>
						<ddstats/>
						<yystats/>
					</main>
					<send>
						<sql/>
						<fromdd/>
						<todd/>
						<dflag/>
						<gbn1val/>
						<gbn2val/>
						<gbn3val/>
						<sectcd/>
						<tsectcd/>
						<param/>
					</send>
					<init>
						<menulist>
							<menu>
								<stsnm>그래그래통계</stsnm>
								<stsval>3</stsval>
								<dflag>1</dflag>
								<gbn1val/>
								<gbn2val/>
								<gbn3val/>
								<dflagItem>
									<item>
										<cd>1</cd>
										<nm>보고일</nm>
									</item>
									<item>
										<cd>2</cd>
										<nm>접수일</nm>
									</item>
								</dflagItem>
								<gbn1>
									<gbnnm>입원/외래 :</gbnnm>
									<item>
										<cd/>
										<nm/>
									</item>
								</gbn1>
								<gbn2>
									<gbnnm/>
									<item>
										<cd/>
										<nm/>
									</item>
								</gbn2>
								<gbn3>
									<gbnnm/>
									<item>
										<cd>1</cd>
										<nm>aa</nm>
									</item>
									<item>
										<cd>1</cd>
										<nm>aa</nm>
									</item>
									<item>
										<cd>1</cd>
										<nm>aa</nm>
									</item>
									<item>
										<cd>1</cd>
										<nm>aa</nm>
									</item>
									<item>
										<cd>1</cd>
										<nm>aa</nm>
									</item>
								</gbn3>
								<sqlstr>
									<head/>
									<item1/>
									<item2/>
									<item3/>
									<foot/>
								</sqlstr>
								<grdstr>
									<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</caption>
									<colwidth>0^80^0^80^0^80^40^40^40^40^40^40^40^40^40^40^40^40^40^40^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0</colwidth>
								</grdstr>
							</menu>
						</menulist>
					</init>
					<hidden>
						<tabgbn/>
						<stsgbn>1</stsgbn>
						<fromdd/>
						<todd/>
						<menu>
							<stsnm/>
							<stsval/>
							<daytoyn/>
							<dflag/>
							<gbn1val/>
							<gbn2val/>
							<gbn3val/>
							<sectcd/>
							<tsectcd/>
							<dflagItem>
								<item>
									<cd/>
									<nm/>
								</item>
							</dflagItem>
							<gbn1>
								<gbnnm/>
								<item>
									<cd/>
									<nm/>
								</item>
							</gbn1>
							<gbn2>
								<gbnnm/>
								<item>
									<cd/>
									<nm/>
								</item>
							</gbn2>
							<gbn3>
								<gbnnm/>
								<item>
									<cd/>
									<nm/>
								</item>
							</gbn3>
							<sqlstr>
								<head/>
								<foot/>
							</sqlstr>
							<grdstr>
								<caption/>
								<colwidth/>
							</grdstr>
						</menu>
					</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="TRLZZ00101" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/LB0102"/>
			<submission id="TRLLS01601" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/init/menulist"/>
			<submission id="TRLLS01602" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/main/ddstats"/>
			<submission id="TRLLS01603" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/hidden/menu/gbn1/item"/>
		</model>
		<script type="javascript">
			<![CDATA[
				//화면 open시 초기화
				function fSetInit() {
					var toDay = getCurrentDate();
					
					model.setValue("/root/hidden/fromdd", toDay); //통계희망시작일 = 현재일자
					model.setValue("/root/hidden/todd", toDay); //통계희망종료일 = 현재일자
					
					//그리드초기화
					model.removeNodeset("/root/main/ddstats"); //일별, 월별, 분기별
					model.removeNodeset("/root/init/menulist"); //메뉴초기화
//					model.removeNodeset("/root/main/yystats"); //연별
					
					var menuparam = model.getValue("/root/properties/menu/menuparam");
					if(menuparam == "") menuparam = "01";
					
					model.makeValue("/root/send/groupid", "GROUP" + menuparam);
					submit("TRLLS01601");
					
					if(model.getXPathValue("count(/root/init/menulist)") < 1) return;
					
					model.makeValue("/root/send/codeflag", "0102|0106|0104|0111|0000|");   // 0102= 중분류 // 0106=시행부서(검사계) // 0104 대분류 // 0111 계(시행) // 0000 userdeptflag
					submit("TRLZZ00101");
					
					model.toggle("dd"); //초기시 일별그리드 표시
					btn_ddstats.selected = true; //일별switch 버튼 선택
					
					fchgSts();
					
					model.refresh();
				}	
				
				//통계 선택
				function fchgSts(){
					
					model.removeNodeset("/root/main/ddstats"); 
					
					model.copyNode("/root/hidden/menu","/root/init/menulist["+cmb_sts.value+"]/menu");
					grd_dd.caption = model.getValue("/root/hidden/menu/grdstr/caption");
					var colarr = model.getValue("/root/hidden/menu/grdstr/colwidth").split("^");
					
					alert(colarr.length);
					
					for(i=0;i < colarr.length;i++){
						grd_dd.colWidth(i+1) = parseInt(colarr[i]);
					}
					model.removeNodeset("/root/main/ddstats");
					
					if(model.getXPathValue("count(/root/hidden/menu/sectcd)") < 1){
						cap_sect.visible = false;
						cmd_TMdlCd.visible = false;
						cmb_TLrgCd.visible = false;
					}
					else{
						cap_sect.visible = true;
						cmd_TMdlCd.visible = true;
						cmb_TLrgCd.visible = true;
					}
					
					if(model.getValue("/root/hidden/menu/gbn1val") == ""){
						cap_item1.visible = false;
						cmb_item1.visible = false;
					}
					else{
						cap_item1.visible = true;
						cmb_item1.visible = true;
					}
					
					if(model.getValue("/root/hidden/menu/gbn2val") == ""){
						cap_item2.visible = false;
						cmb_item2.visible = false;
					}
					else{
						cap_item2.visible = true;
						cmb_item2.visible = true;
					}
					
					if(model.getValue("/root/hidden/menu/daytoyn") == "Y"){
						cap_daygap.visible = true;
						ipt_worktodd.visible = true;
					}
					else{
						cap_daygap.visible = false;
						ipt_worktodd.visible = false;
					}
					
					// 조건을 DB에서 조회 해야 하는 경우 사용나 기타 선처리가 필요한 경우 
					fevalScript("prescript");
					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() {

					model.setValue("/root/send/sql",model.getValue("/root/hidden/menu/sql"));

					//sql 문장 및 파라메터 값을 완성하는 스크립트
					fevalScript("startscript");

					model.setValue("/root/send/fromdd",model.getValue("/root/hidden/fromdd"));
					model.setValue("/root/send/todd",model.getValue("/root/hidden/todd"));
					model.setValue("/root/send/dflag",model.getValue("/root/hidden/menu/dflag"));
					model.setValue("/root/send/gbn1val",model.getValue("/root/hidden/menu/gbn1val"));
					model.setValue("/root/send/gbn2val",model.getValue("/root/hidden/menu/gbn2val"));
					model.setValue("/root/send/gbn3val",model.getValue("/root/hidden/menu/gbn3val"));
					model.setValue("/root/send/sectcd",model.getValue("/root/hidden/menu/sectcd"));
					model.setValue("/root/send/tsectcd",model.getValue("/root/hidden/menu/tsectcd"));
					model.copyNode("/root/send/param","/root/hidden/menu/param");
					
					submit("TRLLS01602");
					
					//조회 후 처리가 필요한 경우 
					fevalScript("endscript");
				}
				
				//스크립트 실행
				function fevalScript(str){
					if(model.getXPathValue("count(/root/hidden/menu/" + str + ")") == 0) return;
					if(model.getValue("/root/hidden/menu/" + str) == "") return;
					eval(model.getValue("/root/hidden/menu/" + str));
				}	
				//파라메터 값 설정
				function fSetParamvVal(nm, val){
					model.setValue("/root/hidden/menu/param/item[nm='" + nm + "']/cd", val);
				}
				//sql 변경
				function fSetSqlChg(re, val){
					model.setValue("/root/send/sql", model.getValue("/root/send/sql").replace(re, val));
				}
				//연별 통계 조회
				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/statshopefromdd", model.getValue("/root/hidden/statshopefromdd")); //통계희망시작일
					model.makeValue("/root/send/statshopetodd", model.getValue("/root/hidden/statshopetodd")); //통계희망종료일
					
					submit("TRLLS00902"); //통계조회
					
					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) = 80; //부서 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_qurtyystats.selected == true) { //분기별
						fSaveExcel("grd_qurtyy");
					} else if(btn_yystats.selected == true) { //연별
						fSaveExcel("grd_yy");
					}
				}
				
			]]>
		</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:65px; ">
				<shape id="roundrect2" class="roundrect_search" appearance="roundrect" style="left:0px; top:0px; width:1195px; height:65px; "/>
				<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; "/>
				<input id="ipt_workfromdd" ref="/root/hidden/fromdd" class="input_search" inputtype="date" style="left:132px; top:37px; width:90px; height:19px; "/>
				<input id="ipt_worktodd" ref="/root/hidden/todd" class="input_search" inputtype="date" style="left:237px; top:37px; width:90px; height:19px; "/>
				<caption id="caption4" class="search_name" style="left:4px; top:38px; width:65px; height:17px; ">일자 :</caption>
				<caption id="cap_daygap" class="search_no_b" style="left:224px; top:39px; width:13px; height:17px; ">~</caption>
				<select1 id="combo8" ref="/root/hidden/menu/dflag" visibility="visible" appearance="minimal" style="left:70px; top:37px; width:60px; height:19px; ">
					<choices>
						<itemset nodeset="/root/hidden/menu/dflagItem/item">
							<label ref="nm"/>
							<value ref="cd"/>
						</itemset>
					</choices>
				</select1>
				<caption id="caption1" class="search_name" style="left:5px; top:10px; width:65px; height:17px; ">통계 :</caption>
				<select1 id="cmb_sts" ref="/root/hidden/stsgbn" visibility="visible" appearance="minimal" style="left:71px; top:9px; width:254px; height:19px; text-align:left; ">
					<choices>
						<itemset nodeset="/root/init/menulist/menu">
							<label ref="stsnm"/>
							<value ref="stsval"/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
						fchgSts();
						]]>
					</script>
				</select1>
				<caption id="cap_item1" ref="/root/hidden/menu/gbn1/gbnnm" class="search_name" style="left:405px; top:10px; width:112px; height:17px; "/>
				<select1 id="cmb_item1" ref="/root/hidden/menu/gbn1val" visibility="visible" appearance="minimal" style="left:520px; top:9px; width:190px; height:19px; ">
					<choices>
						<itemset nodeset="/root/hidden/menu/gbn1/item">
							<label ref="nm"/>
							<value ref="cd"/>
						</itemset>
					</choices>
				</select1>
				<caption id="cap_item2" ref="/root/hidden/menu/gbn2/gbnnm" class="search_name" style="left:405px; top:38px; width:112px; height:17px; "/>
				<select1 id="cmb_item2" ref="/root/hidden/menu/gbn2val" visibility="visible" appearance="minimal" style="left:520px; top:37px; width:190px; height:19px; ">
					<choices>
						<itemset nodeset="/root/hidden/menu/gbn2/item">
							<label ref="nm"/>
							<value ref="cd"/>
						</itemset>
					</choices>
				</select1>
				<select id="chk1" ref="/root/hidden/menu/gbn3val" overflow="visible" scroll="auto" appearance="full" cellspacing="5" cols="10" sep="▦" style="left:790px; top:37px; width:370px; height:19px; ">
					<choices>
						<itemset nodeset="/root/hidden/menu/gbn3/item">
							<label ref="nm"/>
							<value ref="cd"/>
						</itemset>
					</choices>
				</select>
				<caption id="cap_sect" class="search_name" style="left:789px; top:11px; width:86px; height:17px; ">시행부서 :</caption>
				<select1 id="cmd_TMdlCd" ref="/root/hidden/menu/tsectcd" class="combo_s_essential" appearance="minimal" itemcount="10" style="left:986px; top:10px; width:100px; height:19px; text-align:left; ">
					<choices>
						<itemset nodeset="/root/init/LB0106">
							<label ref="nm"/>
							<value ref="cd"/>
						</itemset>
					</choices>
				</select1>
				<select1 id="cmb_TLrgCd" ref="/root/hidden/menu/sectcd" class="combo_s_essential" appearance="minimal" itemcount="10" style="left:880px; top:10px; width:100px; height:19px; text-align:left; ">
					<choices>
						<itemset nodeset="/root/init/LB0111">
							<label ref="nm"/>
							<value ref="cd"/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							if(cmb_TLrgCd.value == "00"){
								cmd_TMdlCd.choices.itemset.attribute("nodeset") = "/root/init/LB0106";
							}
							else{
								cmd_TMdlCd.choices.itemset.attribute("nodeset") = "/root/init/LB0106[cd='00' or etc01='"+cmb_TLrgCd.value+"']";
							}
							cmd_TMdlCd.refresh();
						]]>
					</script>
				</select1>
			</group>
			<switch id="swt_statflag" class="sw_box" style="left:0px; top:105px; width:1195px; height:633px; ">
				<case id="dd" selected="true">
					<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="0,80,0,80,0,80,0,80, 0,0,0,0,0,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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0" dataheight="23" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="23" style="left:5px; top:5px; width:1180px; height:616px; text-align:center; ">
						<col ref="cd1" style="text-align:center; "/>
						<col ref="nm1" style="text-align:center; "/>
						<col ref="cd2" style="text-align:center; "/>
						<col ref="nm2" style="text-align:center; "/>
						<col ref="cd3" style="text-align:center; "/>
						<col ref="nm3" style="text-align:center; "/>
						<col ref="cd4" style="text-align:center; "/>
						<col ref="nm4" style="text-align:center; "/>
						<col ref="h01" style="text-align:center; "/>
						<col ref="h02" style="text-align:center; "/>
						<col ref="h03" style="text-align:center; "/>
						<col ref="h04" style="text-align:center; "/>
						<col ref="h05" style="text-align:center; "/>
						<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="#,###"/>
						<col ref="a01" format="#,###"/>
						<col ref="b01" format="#,###"/>
						<col ref="c01"/>
						<col ref="a02" format="#,###"/>
						<col ref="b02" format="#,###"/>
						<col ref="c02"/>
						<col ref="a03" format="#,###"/>
						<col ref="b03" format="#,###"/>
						<col ref="c03"/>
						<col ref="a04" format="#,###"/>
						<col ref="b04" format="#,###"/>
						<col ref="c04"/>
						<col ref="a05" format="#,###"/>
						<col ref="b05" format="#,###"/>
						<col ref="c05"/>
						<col ref="a06" format="#,###"/>
						<col ref="b06" format="#,###"/>
						<col ref="c06"/>
						<col ref="a07" format="#,###"/>
						<col ref="b07" format="#,###"/>
						<col ref="c07"/>
						<col ref="a08" format="#,###"/>
						<col ref="b08" format="#,###"/>
						<col ref="c08"/>
						<col ref="a09" format="#,###"/>
						<col ref="b09" format="#,###"/>
						<col ref="c09"/>
						<col ref="a10" format="#,###"/>
						<col ref="b10" format="#,###"/>
						<col ref="c10"/>
						<col ref="a11" format="#,###"/>
						<col ref="b11" format="#,###"/>
						<col ref="c11"/>
						<col ref="a12" format="#,###"/>
						<col ref="b12" format="#,###"/>
						<col ref="c12"/>
						<col ref="a13" format="#,###"/>
						<col ref="b13" format="#,###"/>
						<col ref="c13"/>
						<col ref="a14" format="#,###"/>
						<col ref="b14" format="#,###"/>
						<col ref="c14"/>
						<col ref="a15" format="#,###"/>
						<col ref="b15" format="#,###"/>
						<col ref="c15"/>
						<col ref="a16" format="#,###"/>
						<col ref="b16" format="#,###"/>
						<col ref="c16"/>
						<col ref="a17" format="#,###"/>
						<col ref="b17" format="#,###"/>
						<col ref="c17"/>
						<col ref="a18" format="#,###"/>
						<col ref="b18" format="#,###"/>
						<col ref="c18"/>
						<col ref="a19" format="#,###"/>
						<col ref="b19" format="#,###"/>
						<col ref="c19"/>
						<col ref="a20" format="#,###"/>
						<col ref="b20" format="#,###"/>
						<col ref="c20"/>
						<col ref="a21" format="#,###"/>
						<col ref="b21" format="#,###"/>
						<col ref="c21"/>
						<col ref="a22" format="#,###"/>
						<col ref="b22" format="#,###"/>
						<col ref="c22"/>
						<col ref="a23" format="#,###"/>
						<col ref="b23" format="#,###"/>
						<col ref="c23"/>
						<col ref="a24" format="#,###"/>
						<col ref="b24" format="#,###"/>
						<col ref="c24"/>
						<col ref="a25" format="#,###"/>
						<col ref="b25" format="#,###"/>
						<col ref="c25"/>
						<col ref="a26" format="#,###"/>
						<col ref="b26" format="#,###"/>
						<col ref="c26"/>
						<col ref="a27" format="#,###"/>
						<col ref="b27" format="#,###"/>
						<col ref="c27"/>
						<col ref="a28" format="#,###"/>
						<col ref="b28" format="#,###"/>
						<col ref="c28"/>
						<col ref="a29" format="#,###"/>
						<col ref="b29" format="#,###"/>
						<col ref="c29"/>
						<col ref="a30" format="#,###"/>
						<col ref="b30" format="#,###"/>
						<col ref="c30"/>
						<col ref="a31" format="#,###"/>
						<col ref="b31" format="#,###"/>
						<col ref="c31"/>
					</datagrid>
				</case>
				<case id="mm"/>
				<case id="qurtyy"/>
				<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:636px; text-align:center; ">
						<script type="javascript" ev:event="onaftersort">
							<![CDATA[
								grd_qurtyy.gridToInstance();
							]]>
						</script>
					</datagrid>
				</case>
			</switch>
			<button id="btn_ddstats" class="btn_sw" group="tab" style="left:0px; top:84px; width:75px; height:22px; ">
				<caption>통계데이터</caption>
				<toggle case="dd" 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_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>