OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	02/03/2023 07:34:18 AM	rwxr-xr-x
📄 admaddmetadata.rx.html.svn-base	2.26 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admcfgform.rx.html.svn-base	300 bytes	02/03/2023 07:34:17 AM	r--r--r--
📄 admcfgform_dimension.rx.html.svn-base	9.87 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admcfgform_measure.rx.html.svn-base	16.31 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admcfgform_parent.rx.html.svn-base	6.08 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admcfgform_target.rx.html.svn-base	7.08 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admcfglist.rx.html.svn-base	5.06 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admcfglist1.rx.html.svn-base	1.9 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmchgpas.rx.html.svn-base	3.5 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmfb.rx.html.svn-base	2.35 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmfb_upclogo.rx.html.svn-base	2.3 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmip.rx.html.svn-base	4.33 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmip_config_alert.rx.html.svn-base	3.88 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmip_config_cub.rx.html.svn-base	19.02 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmip_config_enq.rx.html.svn-base	3.47 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmip_config_graph.rx.html.svn-base	12.36 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmip_config_login.rx.html.svn-base	7.62 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmip_config_user.rx.html.svn-base	6.92 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmip_menu.rx.html.svn-base	4.36 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmip_menuodr.rx.html.svn-base	4.73 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admfrmresetpas.rx.html.svn-base	2.78 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admgroup.rx.html.svn-base	397 bytes	02/03/2023 07:34:17 AM	r--r--r--
📄 admgroupfilter.rx.html.svn-base	2.7 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admgroupfilter_values.rx.html.svn-base	2.9 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admgroupform.rx.html.svn-base	5.08 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admgrouplist.rx.html.svn-base	3.31 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admgroups.rx.html.svn-base	2.83 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admjoin.rx.html.svn-base	365 bytes	02/03/2023 07:34:17 AM	r--r--r--
📄 admjoinform.rx.html.svn-base	4.14 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admjoinform_edittable.rx.html.svn-base	9.77 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admjoinform_incr.rx.html.svn-base	4.67 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admjoinform_mismatch.rx.html.svn-base	638 bytes	02/03/2023 07:34:17 AM	r--r--r--
📄 admjoinform_newjoin.rx.html.svn-base	6.84 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admjoinform_star.rx.html.svn-base	8.88 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admjoinform_star_rows.rx.html.svn-base	1.11 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admjoinform_syn.rx.html.svn-base	4.75 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admjoinform_table.rx.html.svn-base	4.86 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admjoinform_tablejoins.rx.html.svn-base	3.91 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admjoinlist.rx.html.svn-base	2.97 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admmain.rx.html.svn-base	303 bytes	02/03/2023 07:34:17 AM	r--r--r--
📄 admmenu.rx.html.svn-base	2.71 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admmeta.rx.html.svn-base	403 bytes	02/03/2023 07:34:17 AM	r--r--r--
📄 admmetadata.rx.html.svn-base	3.87 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admmetadata_edit.rx.html.svn-base	8.87 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admmetadata_group.rx.html.svn-base	2.54 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admmetadata_grouporder.rx.html.svn-base	2.04 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admmetalist.rx.html.svn-base	2.56 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admreportoption.rx.html.svn-base	4.58 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admsysmenu.rx.html.svn-base	4.4 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admtemplate.rx.html.svn-base	405 bytes	02/03/2023 07:34:17 AM	r--r--r--
📄 admuser.rx.html.svn-base	633 bytes	02/03/2023 07:34:17 AM	r--r--r--
📄 admuserfilter.rx.html.svn-base	2.57 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admuserfilter_values.rx.html.svn-base	3.7 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admuserform.rx.html.svn-base	15.32 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admuserform_AccessMatrix.rx.html.svn-base	2.24 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admuserform_useranalysis.rx.html.svn-base	23.12 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admuserform_userinfo.rx.html.svn-base	2.96 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admuserform_userinfo_filt.rx.html.svn-base	4.47 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admuserlist.rx.html.svn-base	4.69 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 admusersubtabs.rx.html.svn-base	870 bytes	02/03/2023 07:34:17 AM	r--r--r--
📄 changepass.rx.html.svn-base	2 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 dimhierarchy.rx.html.svn-base	3.13 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 menuorder.rx.html.svn-base	1.1 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 schemaTab.rx.html.svn-base	1.13 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 setdashorder.rx.html.svn-base	2.77 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 settings.rx.html.svn-base	6.08 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 sortorder.rx.html.svn-base	2.58 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 status.rx.html.svn-base	235 bytes	02/03/2023 07:34:17 AM	r--r--r--
📄 tableDesc.rx.html.svn-base	489 bytes	02/03/2023 07:34:17 AM	r--r--r--
📄 template.rx.html.svn-base	8.73 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 template_define.rx.html.svn-base	8.45 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 template_display.rx.html.svn-base	13.52 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 template_list.rx.html.svn-base	2.56 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 template_preview.rx.html.svn-base	2.51 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 template_search.rx.html.svn-base	9.42 KB	02/03/2023 07:34:17 AM	r--r--r--
📄 usersetting.rx.html.svn-base	12.83 KB	02/03/2023 07:34:17 AM	r--r--r--

Editing: admjoinform_edittable.rx.html.svn-base

<HTML>
<link href="/edash///assets/admin/styles/etlconf.css" rel="stylesheet" type="text/css"> 
<link href="/edash///assets/admin/styles/main.css" rel="stylesheet" type="text/css"> 
<link href="/edash///assets/admin/styles/sortabletable.css" rel="stylesheet" type="text/css"> 
<link href="/edash///assets/admin/styles/dash_menu.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="/edash//jscripts/validate.js"> </script>
<script type="text/javascript" src="/edash//jscripts/navigate.js"> </script>
<script type="text/javascript" src="/edash//jscripts/ajax.js"> </script>
<script type="text/javascript" src="/edash//jscripts/sorttable.js"> </script>
<script language=javascript>
<%@TABLE name=getAccess%>
var Access='<%=LUADMINACCESS%>';
<%/TABLE%>
</script>
<body>
<table border=0 cellpadding=0 cellspacing=0 width=100%>
<tr class=repo_title>
<td>
<div id=dashMenu> </div>
</td>
</tr>
</table>
<table align=left  border=0 cellpadding=0 cellspacing=0 id=table_title width=100%>
<tr>
<td>
<table width=100%>
<tr>
<td class=rep_title><b>Table Information</b> </td>
</tr>
</table>
<FORM Name=joinform class=sjoinform Method=get Action=admupdtjoin.rx Target=admjoinform >
<INPUT  Type=hidden Name=conn Value="<%=conn_id%>" Size=30 >
<INPUT  Type=hidden Name=rdn Value="<%=rdn%>" Size=30 >
<INPUT  Type=hidden Name=tabname Value="<%=tabname%>" Size=30 >
<INPUT  Type=hidden Name=tabcat Value="<%=tabcat%>" Size=30 >
<INPUT  Type=hidden Name=tbltabsel Value="2" Size=30 >

<table  class=tb1_border width=96% border=0 cellspacing=0 cellpadding=0 align=center>
<tr class= tbl_tds>
<td><b>Table Name: <%=tabname%></b>
</td>
<td align=right><b>Table Type : </b>
<Select  id=tabtype name="typessel" class=inputcombo style="WIDTH:165" >
	<Option value='Fact' >Fact</option>
	<Option value='Dimension'>Dimension</option>
	<Option value='ETL' >ETL</option>
	<Option value='Target' >Target</option>
	<Option value='Star' >Star Star</option>
	<Option value='synonym' >Synonyms</option>
	<Option value='incremental' >Incremental</option>
	<Option value='Other' >Other</option>
</SELECT>
<INPUT  Type=submit id=changeid Name=action Value="Change" class=btn Size=30  title="Select a table type and click here to update" >

</td>
</tr>

</table>
<div style="color:red;text-align:center"><%=error%></div>
<div style="color:green;text-align:center;"><%=info%></div>
<BR>
<div id=toptid>
<table class=tbl_titles width="30%" align=center border="1">
<tr class=tb1_tds  >
<td align=center nowrap>
<A HREF=cubui.rx?page=admjoinform.rx&page_ix=2&conn=<%=conn_id%>&tbltabsel=1&tabname=<%=tabname%> TARGET=admjoinform title="Create New Table"><b>Create Table<b></A> 
</td>
<td align=center nowrap>
<A HREF=# onclick="editTable()" TARGET=admjoinform title="Edit the table"> <b>Edit Table</b></A> 
</td>
<td align=center nowrap>
<A onclick="return confirmDelete()" HREF="admjoinform.rx?rdn=<%=rdn%>&conn=<%=conn_id%>&tbltabsel=1&tabname=<%=tabname%>&tabcat=<%=tabcat%>&droptable=Drop" TARGET=admjoinform title="Drop the Table"> <span><b> Drop Table <b></span></A>
</td>
</tr>
</table>
</div>

<div id=editfield style="display:none">
<table class="tbl_border" align="center" border="0" cellpadding="3" cellspacing="1" width="90%">
<thead>
<tr class="tbl_titles">
<td class="txttabhead" rowspan="1"><a><b>Field Name</b></a></td>
<td class="txttabhead"><a><b>Data Type</b></a></td>
<td class="txttabhead"><a><b>Size</b></a></td>
<td class="txttabhead"><a><b>Not Null</b></a></td>
<td class="txttabhead"><a><b>Default Value</b></a></td>
<td class="txttabhead"><a><b>Primary Key</b></a></td>
<td class="txttabhead"><a><b>Auto Increment</b></a></td></tr>
</thead>
<tbody>
<tr>
<td>
<input class="inputbox" name="fldname" value="" size="25" title="Enter Field Name" type="text">

</td>
<td>
<select id=fldtypeid name="fldtype" class="inputcombo" style="width: 95px;">
	<option value='BIGINT'>BIGINT</option>
	<option value='CHAR'>CHAR</option>
	<option value='DATE'>DATE</option>
	<option value='DATETIME'>DATETIME</option>
	<option value='DOUBLE'>DOUBLE</option>
	<option value='FLOAT'>FLOAT</option>
	<option value='INT' selected>INT</option>
	<option value='MEDIUMINT'>MEDIUMINT</option>
	<option value='MEDIUMTEXT'>MEDIUMTEXT</option>
	<option value='SMALLINT'>SMALLINT</option>
	<option value='TEXT'>TEXT</option>
	<option value='TIMESTAMP'>TIME</option>
	<option value='TIME'>TIME</option>
	<option value='TINYINT'>TINYINT</option>
</select>
</td>
<td><input class="inputbox" name="fldsize" value="" size="8" title="Enter field size" type="text">
</td>
<td align="center">
<input name="not_null" value="1" size="8" type="Checkbox">
</td>
<td>
<input class="inputbox" name="default_val" value="" size="15" type="text">
</td>
<td align="center">
<input name="pri_key" value="1" size="15" type="Checkbox">
</td>
<td align="center">
<input name="auto_incr" value="1" size="15" type="Checkbox">
</td>
</tr>
<input name="addfield" value="Save" size="15"  type="hidden">
<input name="oldfldname" value="Save" size="15" type="hidden">
</tbody>
</table>
<br>
<table class="tbl_titles" align="center" border="1" width="50%">
<tbody>
<tr class="tbl_tds">
<td align="right"><b>Position</b></td>
<td colspan="2">
<input name="pos" value="last" id="last" class="radiobtn" checked="checked" size="15" title="Select To Make Last Column" type="radio"><label for="last" title="Select To Make Last Column">Last</label>

<input name="pos" value="first" id="first" class="radiobtn" size="15" title="Select To Make First Column" type="radio"><label for="first" title="Select To Make First Column">First</label>
<input name="pos" value="after" id="after" class="radiobtn" size="15" title="Select Column Position" type="radio"><label for="after" title="Select Column Position">After</label>
<select name="after_colsel" class="inputcombo" style="width: 165px;">
<%@TABLE name=getTableDesc%>
<option value="<%=Field%>"><%=Field%></option>
<%/TABLE%>
</select>
</td></tr>
</tbody>
</table>
<table class="tbl_titles" align="center" border="1" width="20%">
<tbody>
<tr class="txttabhead">
<td></td>
<td align="center"><a id=saveUpdt onclick="return document.joinform.submit()" href="#" target="admjoinform" title="Save">Save</a></td>
<td></td>
<td align="center"><a href="#" onclick=hidediv('editfield') target="admjoinform" title="Discard">Cancel</a></td>
</tr>
</tbody>
</table>
</div>

<br>

<table align=center width=100% id=mainTable>
<tr>
<td align=center>
<table border=0 cellspacing=1 cellpadding=3  class=sortable  width="98%" align=center id=showTable>
	<tr class=tbl_titles>
		<th>Field No.</th>
		<th>Field name</th>
		<th>Data Type</th>
		<th>Not Null</th>
		<th>Key</th>
		<th>Default Value</th>
		<th>Extra</th>
		<th colspan=3>Options</th>
</tr>
<%@TABLE name=getTableDesc%>
<tr class=txtrow>
<td><%=S.NO.%></td>
<td><%=Field%></td>
<td><%=Type%></td>
<td><%=NotNull%></td>
<td><%=Key%></td>
<td><%=Default%></td>
<td><%=Extra%></td>
<td align=center>
	<A HREF=# onclick="editField('<%=Field%>','<%=Type%>','<%=NotNull%>','<%=Key%>','<%=Default%>','<%=Extra%>');">
<IMG SRC=/edash//assets/default/images/edit.gif Border=0 title="Edit this field">
</A>
</td>
<td align=center>
<A onclick="return chkDeleteAccess(Access)" HREF=admupdtjoin.rx?rdn=<%=rdn%>&conn=<%=conn_id%>&fldname=<%=Field%>&tabname=<%=tabname%>&tabcat=<%=tabcat%>&addfield=Del TARGET=admjoinform title="Delete this field">
<IMG SRC=/edash//assets/default/images/del.gif Border=0 title=""></A>
</td>
</tr>
<%/TABLE%>
</table>
</td>
</tr>
</table>
</FORM>
</body>
<script language=javascript>
	function editTable(){
		showdiv('editfield');
		document.joinform.reset();
		select('tabtype','<%=tabcat%>');
		document.joinform.oldfldname.value="";
		document.getElementById('saveUpdt').innerHTML='Save';
		document.joinform.addfield.value='Save';
	}
	function editField(Field,Type,isNull,Key,DefaultVal,Extra){
		if(Access == 'RA'){
			alert("Ypu don't have permission to edit the table.");
			return false;
		}
		showdiv('editfield');
		var TypeArray = new Array();
		var SizeArray = new Array();
		document.joinform.fldname.value=Field;
		document.joinform.oldfldname.value=Field;
		TypeArray=Type.split("(");
		select('fldtypeid',TypeArray[0].toUpperCase());
		if(TypeArray[1]){
			SizeArray=TypeArray[1].split(")");
			document.joinform.fldsize.value=SizeArray[0];
		}
		else{
			document.joinform.fldsize.value="";
		}

if(isNull == 'YES')
		document.joinform.not_null.checked=true;
		else
		document.joinform.not_null.checked=false;
		document.joinform.default_val.value=DefaultVal;
		if(Key == 'PRI')
		document.joinform.pri_key.checked=true;
		else
		document.joinform.pri_key.checked=false;
		if(Extra == 'auto_increment')
		document.joinform.auto_incr.checked=true;
		else
		document.joinform.auto_incr.checked=false;
		document.joinform.addfield.value='Update';
		document.getElementById('saveUpdt').innerHTML='Update';
	}
loadsubmit("cubui.rx?page=admjoinform.rx&page_ix=8&conn=<%=conn_id%>&tbltabsel=1&tabname=<%=tabname%>", "dashMenu", "", 0);
setClass('Table Editor','Smenu');
window.parent.admjoinlist.location.href="cubui.rx?page=admjoinlist.rx&conn=<%=conn_id%>&pageix=<%=page_ix%>";
select('tabtype','<%=tabcat%>');

function DropTable(){
	window.parent.admjoinform.location.href="admjoinform.rx?rdn=<%=rdn%>&conn=<%=conn_id%>&tbltabsel=1&tabname=<%=tabname%>&tabcat=<%=tabcat%>&droptable=Drop";
}

if(document.getElementById('showTable').rows.length==1){
	hidediv('toptid');
	document.getElementById('mainTable').rows[0].innerHTML="<td width=100% align=center><font color=red>Table is not present in database.</font> <BR><A onclick='DropTable()' href='cubui.rx?page=admjoinlist.rx&conn=<%=conn_id%>&pageix=<%=page_ix%>' TARGET=admjoinlist >Click to delete from list.</A><BR><A HREF='cubui.rx?page=admjoinform.rx&page_ix=2&conn=<%=conn_id%>&tbltabsel=1&tabname=<%=tabname%> TARGET=admjoinform'>Click to create new table</A> </td>";
}
if(Access == 'RA'){
	hidediv('toptid');
	document.getElementById('changeid').disabled=true;
}
</script>
</HTML>