YNU_JEUS/app_home/himed/webapps/com/tableviewweb/xrw/SMZDM00300_테이블조회$.xrw

<?xml version="1.0" encoding="UTF-8"?>
<?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>
						<tablelist/>
						<ownerlist>
							<codename/>
							<codevalue/>
						</ownerlist>
						<desc>
							<indexinfo/>
							<tableinfo>
								<tableName/>
								<tableSpaceName/>
								<cmt/>
								<numrows/>
								<lastAnalyzed/>
								<part/>
							</tableinfo>
							<desclist/>
						</desc>
						<table/>
						<tableinput/>
						<mstCodeList/>
					</main>
					<send>
						<owner/>
						<tableName/>
						<likeflag/>
						<mstCode>
							<code/>
							<codeName/>
						</mstCode>
						<tableCmt/>
						<columnCmt/>
					</send>
					<init>
					</init>
					<hidden/>
					<temp/>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
				// 화면초기화(ownerlist설정)
				submit("TRZDM00301");
				]]>
			</script>
			<submission id="TRZDM00301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/main/ownerlist" resultref="/root/main/ownerlist"/>
			<submission id="TRZDM00302" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/tablelist"/>
			<submission id="TRZDM00303" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/desc"/>
			<submission id="TRZDM00401" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/mstCode" resultref="/root/main/mstCodeList"/>
			<submission id="TXZDM00304" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send"/>
			<submission id="TXZDM00305" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send"/>
		</model>
		<script type="javascript" src="../../../com/commonweb/js/common.js"/>
		<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
		<script type="javascript">
			<![CDATA[
				function getTableList() {	// 테이블리스트 조회메소드
					
					// owner가 선택되지 않았을 경우
					if (model.getValue("/root/main/ownerlist") == '') {
						messageBox("OWNER를", "C001");
						
					// 테이블명이 입력되지 않았을 때, 혹은 테이블이 선택되지 않았을 경우
					} else if (model.getValue("/root/main/tableinput") == '') {
						messageBox("테이블명을", "C001");
						
					// owner + table이 선택되어 있는 경우
					} else {
						model.setValue("/root/send/owner", model.getValue("/root/main/ownerlist"));
						model.setValue("/root/send/tableName", model.getValue("/root/main/tableinput"));
						model.setValue("/root/send/likeflag", true);
						submit("TRZDM00302");
					}
				}
				
				function fValidFormCode() {
					
					var mstCode = model.getValue("/root/send/mstCode/code");
					var mstCodeName = model.getValue("/root/send/mstCode/codeName");
					
					// 필수체크
					if ((mstCode == null || mstCode == "") && (mstCodeName == null || mstCodeName == "")) {
								
						messageBox("마스터코드 또는 마스터코드명을", "C001");
						
						return false;
					}
					
					// 길이체크(마스터코드)
					if (mstCode != null && mstCode != "") {
						
						if (mstCode.length < 2) {
							
							messageBox("마스터코드는 2자리 이상", "C001");
							
							return false;
						}	
					}
					
					// 길이체크(마스터코드명)
					if (mstCodeName != null && mstCodeName != "") {
						
						if (mstCodeName.length < 2) {
							
							messageBox("마스터코드명 2자리 이상", "C001");
							
							return false;
						}	
					}
					
					return true;
				}
				
				function fSubmitCodeInfo() {
					if (fValidFormCode()) {
							submit("TRZDM00401");
						}
				}
			]]>
		</script>
	</xhtml:head>
	<xhtml:body guideline="1,1211;2,789;">
		<caption id="caption1" class="tit_1" style="left:0px; top:0px; width:120px; height:13px; vertical-align:middle; ">테이블정보조회</caption>
		<button id="button2" class="btn_sw" group="tab" selected="true" style="left:10px; top:20px; width:120px; height:22px; ">
			<caption>테이블정보</caption>
			<toggle case="case1" ev:event="onclick"/>
		</button>
		<button id="button3" class="btn_sw" group="tab" style="left:130px; top:20px; width:120px; height:22px; ">
			<caption>마스터코드정보</caption>
			<toggle case="case2" ev:event="onclick"/>
		</button>
		<switch id="switch1" class="sw_box" style="left:0px; top:40px; width:1200px; height:730px; ">
			<case id="case1">
				<!-- 테이블정보 디자인 시작 -->
				<shape id="roundrect4" appearance="roundrect" ellipsewidth="20" ellipseheight="20" style="left:5px; top:10px; width:205px; height:710px; "/>
				<shape id="roundrect2" appearance="roundrect" ellipsewidth="20" ellipseheight="20" style="left:220px; top:205px; width:970px; height:515px; "/>
				<shape id="roundrect1" appearance="roundrect" ellipsewidth="20" ellipseheight="20" style="left:220px; top:10px; width:380px; height:185px; "/>
				<caption id="caption3" class="tit_2" style="left:15px; top:20px; width:100px; height:13px; ">OWNER</caption>
				<caption id="caption4" class="tit_2" style="left:15px; top:79px; width:100px; height:13px; ">TABLE</caption>
				<caption id="caption5" class="tit_2" style="left:230px; top:215px; width:106px; height:13px; ">COLUMN 정보조회</caption>
				<datagrid id="datagrid2" nodeset="/root/main/desc/desclist" caption="COLUMN^CONSTRAINT^TYPE^LENG^COMMENTS" colsep="^" colwidth="140, 90, 88, 46, 544" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:230px; top:240px; width:950px; height:470px; ">
					<col ref="colName"/>
					<col ref="constType"/>
					<col ref="dataType"/>
					<col ref="dataLength"/>
					<col ref="cmt"/>
				</datagrid>
				<select1 id="combo_owner" ref="/root/main/ownerlist" class="combo_default" appearance="minimal" style="left:15px; top:39px; width:185px; height:19px; ">
					<choices>
						<itemset nodeset="/root/main/ownerlist">
							<label ref="codename"/>
							<value ref="codevalue"/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-select">
						<![CDATA[
					model.setValue("/root/send/owner", model.getValue("/root/main/ownerlist"));
					
					// 기존의 테이블선택정보를 삭제
					input1.value = "";
					model.setValue("/root/send/tableName", "");
					model.setValue("/root/send/likeflag", false);
					
					submit("TRZDM00302");
				]]>
					</script>
				</select1>
				<input id="input1" ref="/root/main/tableinput" imemode="alpha" validateformat="false" style="left:15px; top:120px; width:185px; height:19px; ">
					<script type="javascript" ev:event="onkeypress">
						<![CDATA[
					// Enter 입력 시
					if (event.keyCode == "13") {	
						
						// 현재 입력값 노드 반영
						setInputNodeCurText();	
						model.setValue("/root/send/tableName", input1.value);
						model.setValue("/root/send/likeflag", true);
						
						// 테이블리스트 조회메소드 호출
						getTableList()
					}
				]]>
					</script>
				</input>
				<caption id="caption6" class="search_name" style="left:10px; top:98px; width:135px; height:17px; ">테이블명 직접입력</caption>
				<caption id="caption7" class="tit_2" style="left:230px; top:20px; width:100px; height:13px; ">TABLE 정보조회</caption>
				<input id="input2" ref="/root/main/desc/tableinfo/cmt" editable="false" style="left:345px; top:93px; width:245px; height:19px; "/>
				<caption id="caption8" style="left:235px; top:93px; width:81px; height:20px; ">COMMENTS :</caption>
				<input id="input4" ref="/root/main/desc/tableinfo/lastAnalyzed" editable="false" format="yyyy-mm-dd" style="left:345px; top:117px; width:245px; height:19px; "/>
				<caption id="caption9" style="left:235px; top:165px; width:87px; height:20px; ">PARTITIONED :</caption>
				<input id="input5" ref="/root/main/desc/tableinfo/numrows" editable="false" style="left:345px; top:141px; width:245px; height:19px; "/>
				<caption id="caption10" style="left:235px; top:140px; width:78px; height:20px; ">NUM_ROWS :</caption>
				<caption id="caption11" style="left:235px; top:117px; width:104px; height:20px; ">LAST_ANALIZED :</caption>
				<input id="input6" ref="/root/main/desc/tableinfo/part" editable="false" style="left:345px; top:165px; width:245px; height:19px; "/>
				<caption id="caption12" style="left:235px; top:69px; width:95px; height:20px; ">TABLE_SPACE :</caption>
				<input id="input7" ref="/root/main/desc/tableinfo/tableSpaceName" editable="false" style="left:345px; top:69px; width:245px; height:19px; "/>
				<caption id="caption13" class="search_name" style="left:10px; top:180px; width:95px; height:17px; ">테이블 선택</caption>
				<shape id="roundrect3" appearance="roundrect" ellipsewidth="20" ellipseheight="20" style="left:610px; top:10px; width:580px; height:185px; "/>
				<input id="input3" ref="/root/main/desc/tableinfo/tableName" editable="false" style="left:345px; top:45px; width:245px; height:19px; "/>
				<caption id="caption14" style="left:235px; top:45px; width:95px; height:20px; ">TABLE_NAME :</caption>
				<datagrid id="datagrid3" nodeset="/root/main/desc/indexinfo" caption="INDEX^COLUMN" colsep="^" colwidth="218, 321" mergecellsfixedrows="bycolrec" rowsep="|" style="left:620px; top:45px; width:560px; height:140px; ">
					<col ref="indexName"/>
					<col ref="columnName"/>
				</datagrid>
				<caption id="caption15" class="tit_2" style="left:620px; top:20px; width:100px; height:13px; ">INDEX 정보조회</caption>
				<button id="button1" class="btn1_letter2" style="left:145px; top:144px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
					// 테이블리스트 조회메소드 호출
					getTableList();
				]]>
					</script>
				</button>
				<button id="button10_r" class="icon_right" navindex="-1" style="left:170px; top:179px; width:26px; height:19px; ">
					<caption/>
					<script type="javascript" ev:event="onclick">
						<![CDATA[
						datagrid1.attribute("overflow") = "scroll";
						datagrid1.attribute("width") = "480";
						]]>
					</script>
				</button>
				<button id="button10_l" class="icon_left" navindex="-1" style="left:139px; top:179px; width:26px; height:19px; ">
					<caption/>
					<script type="javascript" ev:event="onclick">
						<![CDATA[
						datagrid1.attribute("overflow") = "scroll";
						datagrid1.attribute("width") = "185";
						]]>
					</script>
				</button>
				<!-- 테이블정보 디자인 종료 -->
				<datagrid id="datagrid1" nodeset="/root/main/tablelist" caption="TABLE^COMMENTS" colsep="^" colwidth="165, 333" mergecellsfixedrows="bycolrec" rowsep="|" style="left:15px; top:205px; width:185px; height:505px; ">
					<col ref="tablename"/>
					<col ref="cmt"/>
					<script type="javascript" ev:event="ondblclick">
						<![CDATA[
				// 선택한 행 정보(테이블명) 설정
				model.setValue("/root/send/tableName", model.getValue("/root/main/tablelist[" + datagrid1.row + "]/tablename"));
				submit("TRZDM00303");
				]]>
					</script>
				</datagrid>
			</case>
			<case id="case2" selected="true">
				<!-- 마스터코드정보 디자인 시작 -->
				<shape id="roundrect5" appearance="roundrect" ellipsewidth="20" ellipseheight="20" style="left:10px; top:10px; width:680px; height:60px; "/>
				<caption id="caption16" style="left:25px; top:40px; width:100px; height:20px; vertical-align:middle; ">마스터코드</caption>
				<input id="input8" ref="/root/send/mstCode/code" style="left:95px; top:40px; width:200px; height:19px; ">
					<script type="javascript" ev:event="onkeypress">
						<![CDATA[
						// Enter 입력 시
						if (event.keyCode == "13") {	
							
							// 현재 입력값 노드 반영
							setInputNodeCurText();	
							model.setValue("/root/send/mstCode/code", input8.value);
							
							// 코드리스트 조회메소드 호출
							fSubmitCodeInfo();
						}
						]]>
					</script>
				</input>
				<button id="button4" class="btn1_letter2" style="left:617px; top:38px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						fSubmitCodeInfo();
						]]>
					</script>
				</button>
				<input id="input9" ref="/root/send/mstCode/codeName" style="left:400px; top:40px; width:200px; height:19px; ">
					<script type="javascript" ev:event="onkeypress">
						<![CDATA[
						// Enter 입력 시
						if (event.keyCode == "13") {	
							
							// 현재 입력값 노드 반영
							setInputNodeCurText();	
							model.setValue("/root/send/mstCode/codeName", input9.value);
							
							// 코드리스트 조회메소드 호출
							fSubmitCodeInfo();
						}
						]]>
					</script>
				</input>
				<caption id="caption2" style="left:320px; top:40px; width:100px; height:20px; vertical-align:middle; ">마스터코드명</caption>
				<shape id="roundrect6" appearance="roundrect" ellipsewidth="20" ellipseheight="20" style="left:10px; top:80px; width:1175px; height:635px; "/>
				<datagrid id="datagrid4" nodeset="/root/main/mstCodeList" caption="코드SID^코드군ID^코드ID^코드명칭^코드상세내용^코드출력순서^코드유효시작일자^코드유효종료일자" colsep="^" colwidth="100, 100, 100, 255, 255, 82, 130, 110" mergecellsfixedrows="bycolrec" rowsep="|" style="left:20px; top:110px; width:1155px; height:595px; ">
					<col ref="cdsid"/>
					<col ref="cdgrupid"/>
					<col ref="cdid"/>
					<col ref="cdnm"/>
					<col ref="detldesc"/>
					<col ref="dispseq"/>
					<col ref="valifromdd" format="yyyy-mm-dd"/>
					<col ref="valitodd" format="yyyy-mm-dd"/>
				</datagrid>
				<caption id="caption17" class="tit_2" style="left:25px; top:20px; width:160px; height:13px; ">마스터코드 조회조건</caption>
				<caption id="caption18" class="tit_2" style="left:25px; top:90px; width:160px; height:13px; ">마스터코드리스트</caption>
				<!-- 마스터코드정보 디자인 종료 -->
			</case>
		</switch>
	</xhtml:body>
</xhtml:html>