YNU_JEUS/app_home/himed/webapps/com/datadictionaryweb/xrw/SMZDD00101_DataDictionary.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>Untitle</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<tablegrid>
							<tablelist>
								<schemanm/>
								<objkind/>
								<tablenm/>
								<depth/>
								<script/>
								<tabknm/>
								<definition/>
								<tabcomment/>
								<tsdata/>
								<tsindex/>
								<tslong/>
							</tablelist>
						</tablegrid>
						<subgrid>
							<collist>
								<colname/>
								<coltype/>
								<colcomment/>
								<coldefinition/>
								<colnote/>
								<remarks/>
							</collist>
							<idxlist>
								<idxname/>
								<colname/>
								<uniquerule/>
								<remark/>
								<createtime/>
							</idxlist>
							<reflist>
								<objtype/>
								<objschema/>
								<objname/>
								<objscript/>
							</reflist>
						</subgrid>
						<search>
							<supcdgruid/>
							<supcdgrupnm/>
							<supcdnm/>
							<supcdid/>
						</search>
					</main>
					<send>
						<reqdata/>
						<savedata/>
					</send>
					<hidden>
						<schemanm/>
						<tabname/>
					</hidden>
				</root>
			</instance>
			<submission id="TRZDD00101" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/subgrid"/>
			<submission id="TRZDD00100" mediatype="application/x-www-form-urlencoded" method="post" resultref="/root/main/tablegrid"/>
		</model>
		<script type="javascript" src="../../../com\commonweb\js\common.js"/>
		<script type="javascript" src="../../../com\commonweb\js\tfHelper.js"/>
		<script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
	</xhtml:head>
	<xhtml:body style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="group1" style="left:10px; top:10px; width:1180px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:109px; height:14px; ">DataDictionary</caption>
		</group>
		<line id="line12" class="line_1" style="x1:10px; y1:50px; x2:1190px; y2:50px; "/>
		<caption id="caption5" class="tit_2" style="left:15px; top:35px; width:129px; height:13px; text-align:left; ">
			<![CDATA[DB Information]]>
		</caption>
		<datagrid id="datagrid4" nodeset="/root/main/subgrid/idxlist" caption="인덱스명^인덱스정보^UNIQUE^비고^작성일자" colsep="^" colwidth="148, 302, 55, 138, 120" mergecellsfixedrows="bycolrec" rowsep="|" style="left:425px; top:450px; width:765px; height:90px; font-family:굴림; font-size:8pt; ">
			<col ref="idxname"/>
			<col ref="colname"/>
			<col ref="uniquerule"/>
			<col ref="remark"/>
			<col ref="createtime" format="yyyy-mm-dd"/>
		</datagrid>
		<caption id="caption2" class="tit_2" style="left:425px; top:550px; width:111px; height:13px; text-align:left; ">Script</caption>
		<textarea id="txtScript" scroll="both" style="left:425px; top:575px; width:765px; height:180px; font-family:굴림; font-size:8pt; "/>
		<line id="line3" class="line_1" style="x1:425px; y1:445px; x2:1190px; y2:444px; "/>
		<line id="line1" class="line_1" style="x1:425px; y1:570px; x2:1190px; y2:569px; "/>
		<caption id="caption8" class="tit_2" style="left:10px; top:550px; width:418px; height:13px; text-align:left; ">Reference Objects [Stored Procedure, Trigger etc]</caption>
		<line id="line5" class="line_1" style="x1:10px; y1:570px; x2:415px; y2:569px; "/>
		<caption id="caption9" class="tit_2" style="left:425px; top:170px; width:111px; height:13px; text-align:left; ">Columns</caption>
		<line id="line6" class="line_1" style="x1:425px; y1:190px; x2:1190px; y2:189px; "/>
		<line id="line7" class="line_1" style="x1:425px; y1:445px; x2:1190px; y2:444px; "/>
		<caption id="caption10" class="tit_2" style="left:425px; top:425px; width:111px; height:13px; text-align:left; ">Indexes</caption>
		<caption id="caption52" class="cell_1" style="left:425px; top:80px; width:130px; height:23px; vertical-align:middle; ">Table Definition - ER</caption>
		<caption id="caption11" class="cell_1" style="left:425px; top:105px; width:130px; height:23px; vertical-align:middle; ">Table Comment</caption>
		<caption id="caption12" class="cell_1" style="left:425px; top:130px; width:80px; height:23px; vertical-align:middle; ">Table Space</caption>
		<caption id="caption13" class="cell_1" style="left:740px; top:130px; width:45px; height:23px; vertical-align:middle; ">Index</caption>
		<caption id="caption14" class="cell_1" style="left:970px; top:130px; width:45px; height:23px; vertical-align:middle; ">Long</caption>
		<caption id="caption1" class="cell_1" style="left:510px; top:130px; width:45px; height:23px; vertical-align:middle; ">Data</caption>
		<datagrid id="datagrid1" nodeset="/root/main/tablegrid/tablelist" caption="DB 정보^구분^DB정보^Depth^Script^한글명^Deifinition^Comment^TS_Data^TS_Index^TS_Long" colsep="^" colwidth="0, 0, 400, 0, 0, 0, 0, 0, 0, 0, 0" rowsep="|" tooltip="true" style="left:10px; top:55px; width:405px; height:485px; font-family:굴림; font-size:8pt; ">
			<col ref="schemanm"/>
			<col ref="objkind"/>
			<col ref="tablenm"/>
			<col ref="depth"/>
			<col ref="script"/>
			<col ref="tabknm"/>
			<col ref="definition"/>
			<col ref="tabcomment"/>
			<col ref="tsdata"/>
			<col ref="tsindex"/>
			<col ref="tslong"/>
			<script type="javascript" ev:event="ondblclick">
				<![CDATA[
					var schemanm = datagrid1.valueMatrix(datagrid1.row, 0);
					var objkind = datagrid1.valueMatrix(datagrid1.row, 1);
					var tablenm = datagrid1.valueMatrix(datagrid1.row, 2);
					var depth = datagrid1.valueMatrix(datagrid1.row, 3);
					var script = datagrid1.valueMatrix(datagrid1.row, 4);
					
					var tabknm = datagrid1.valueMatrix(datagrid1.row, 5);
					var definition = datagrid1.valueMatrix(datagrid1.row, 6);
					var comment = datagrid1.valueMatrix(datagrid1.row, 7);
					
					var tsdata = datagrid1.valueMatrix(datagrid1.row, 8);
					var tsindex = datagrid1.valueMatrix(datagrid1.row, 9);
					var tslong = datagrid1.valueMatrix(datagrid1.row, 10);
				
					var mystr = "(";
					var mypos = tablenm.indexOf(mystr);
					if (mypos !== -1) 	{
						tablenm = tablenm.substr(0, mypos);
					}
					
					model.setValue("/root/hidden/schemanm", schemanm);
					model.setValue("/root/hidden/tabname", tablenm);
					
					model.copyNode("/root/send/reqdata","/root/hidden");
					
//					초기화
					outtabknm.value = "";
					outdefinition.value =  "";
					outcomment.value =  "";
					outtsdata.value =  "";
					outtsindex.value =  "";
					outtslong.value =  "";
									
					for ( i = 1; i <= datagrid2.rows; i++)
					{
						for  ( j = 0; j <= datagrid2.cols; j++)
						{
							datagrid2.valueMatrix(i,j) = "";
						}
					}

					for ( i = 1; i <= datagrid3.rows; i++)
					{
						for  ( j = 0; j <= datagrid3.cols; j++)
						{
							datagrid3.valueMatrix(i,j) = "";
						}
					}
					
					for ( i = 1; i <= datagrid4.rows; i++)
					{
						for  ( j = 0; j <= datagrid4.cols; j++)
						{
							datagrid4.valueMatrix(i,j) = "";
						}
					}

					txtScript.value = "";
					if (depth == 4) {
						
						switch (objkind){					
							
							case "FUNCTIONS" :
							case "PROCEDURES":
							case "VIEWS":									
									txtScript.value = script;
									break;							
							case "TABLES" :	
									
									outtabknm.value = tabknm;
									outdefinition.value =  definition;
									outcomment.value =  comment;
									outtsdata.value =  tsdata;
									outtsindex.value =  tsindex;
									outtslong.value =  tslong;
									submit("TRZDD00101");
									break;		
						}
						model.refresh();
					}
				]]>
			</script>
			<script type="javascript" ev:event="onmousedown">
				<![CDATA[
					datagrid1.tooltiptext(datagrid1.row, datagrid1.col) = datagrid1.valueMatrix(datagrid1.row, datagrid1.col);
				]]>
			</script>
		</datagrid>
		<button id="button2" class="btn1_letter2" style="left:360px; top:25px; width:56px; height:22px; ">
			<caption>조회</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[		
					submit("TRZDD00100");
					setTree(datagrid1, 3, 2, true);
					model.refresh();
				]]>
			</script>
			<script type="javascript" ev:event="onclick">
				<![CDATA[
				
				]]>
			</script>
		</button>
		<datagrid id="datagrid2" nodeset="/root/main/subgrid/reflist" caption="Object Type^Schema^ObjectName^Text" colsep="^" colwidth="103, 64, 231, 0" mergecellsfixedrows="bycolrec" rowsep="|" tooltip="true" style="left:10px; top:575px; width:405px; height:180px; font-family:굴림; font-size:8pt; ">
			<col ref="objtype"/>
			<col ref="objschema"/>
			<col ref="objname"/>
			<col ref="objscript"/>
			<script type="javascript" ev:event="ondblclick">
				<![CDATA[
					txtScript.Text = datagrid2.valueMatrix(datagrid2.row,3);
					txtScript.refresh();
				]]>
			</script>
			<script type="javascript" ev:event="onmousedown">
				<![CDATA[
					datagrid2.tooltiptext(datagrid2.row, datagrid2.col) = datagrid2.valueMatrix(datagrid2.row, datagrid2.col);
				]]>
			</script>
		</datagrid>
		<datagrid id="datagrid3" nodeset="/root/main/subgrid/collist" caption="컬럼명^Datatype^한글명 - ER^Definition - ER^Note - ER^Comment - DB" colsep="^" colwidth="94, 96, 92, 162, 149, 168" mergecellsfixedrows="bycolrec" rowsep="|" tooltip="true" style="left:425px; top:195px; width:765px; height:225px; font-family:굴림; font-size:8pt; ">
			<col ref="colname"/>
			<col ref="coltype"/>
			<col ref="colcomment"/>
			<col ref="coldefinition"/>
			<col ref="colnote"/>
			<col ref="remarks"/>
			<script type="javascript" ev:event="onmousedown">
				<![CDATA[
				datagrid3.tooltiptext(datagrid3.row, datagrid3.col) = datagrid3.valueMatrix(datagrid3.row, datagrid3.col);
				]]>
			</script>
		</datagrid>
		<caption id="caption3" class="cell_1" style="left:425px; top:55px; width:130px; height:23px; vertical-align:middle; ">Table 한글명</caption>
		<output id="outtsdata" class="output_fix" style="left:560px; top:130px; width:170px; height:19px; "/>
		<output id="outtsindex" class="output_fix" style="left:790px; top:130px; width:170px; height:19px; "/>
		<output id="outtslong" class="output_fix" style="left:1020px; top:130px; width:170px; height:19px; "/>
		<output id="outtabknm" class="output_fix" style="left:560px; top:55px; width:630px; height:19px; "/>
		<output id="outdefinition" class="output_fix" style="left:560px; top:80px; width:630px; height:19px; "/>
		<output id="outcomment" class="output_fix" style="left:560px; top:105px; width:630px; height:19px; ">
			<script type="javascript" ev:event="onmousedown">
				<![CDATA[
					//outcomment.attribute("hint") = outcomment.value;
				]]>
			</script>
		</output>
		<caption id="caption4" class="search_name" style="left:990px; top:165px; width:91px; height:17px; ">코드군 ID :</caption>
		<input id="ipt_search" ref="/root/main/search/supcdgruid" class="input_search" inputtype="button" style="left:1090px; top:165px; width:100px; height:19px; ">
			<script type="javascript" ev:event="onkeydown">
				<![CDATA[
					if (event.keyCode == "13") {
						setInputNodeCurText();
						
						//img1.dispatch("onclick");
						var cdgrupid = ipt_search.text;
						var recv_cdid_path 	= '/root/main/search/supcdid';
						var recv_cdnm_path 	= "/root/main/search/supcdnm";
						var search_condition = "cdnm";
						var search_term       = model.getValue("/root/main/search/supcdid");
						
						zbcfOpenCodeList(cdgrupid, recv_cdid_path, recv_cdnm_path, search_condition, search_term);
					}
				]]>
			</script>
		</input>
	</xhtml:body>
</xhtml:html>