diff options
Diffstat (limited to 'ecomp-sdk-app/src/main/webapp/WEB-INF/fusion/raptor/wizard_tables_edit.jsp')
| -rw-r--r-- | ecomp-sdk-app/src/main/webapp/WEB-INF/fusion/raptor/wizard_tables_edit.jsp | 369 |
1 files changed, 369 insertions, 0 deletions
diff --git a/ecomp-sdk-app/src/main/webapp/WEB-INF/fusion/raptor/wizard_tables_edit.jsp b/ecomp-sdk-app/src/main/webapp/WEB-INF/fusion/raptor/wizard_tables_edit.jsp new file mode 100644 index 000000000..88ecda311 --- /dev/null +++ b/ecomp-sdk-app/src/main/webapp/WEB-INF/fusion/raptor/wizard_tables_edit.jsp @@ -0,0 +1,369 @@ +<%-- + ================================================================================ + eCOMP Portal SDK + ================================================================================ + Copyright (C) 2017 AT&T Intellectual Property + ================================================================================ + Licensed under the Apache License, Version 2.0 (the "License"); + you may not use this file except in compliance with the License. + You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + + Unless required by applicable law or agreed to in writing, software + distributed under the License is distributed on an "AS IS" BASIS, + WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + See the License for the specific language governing permissions and + limitations under the License. + ================================================================================ + --%> +<%@ page import="org.openecomp.portalsdk.analytics.xmlobj.DataColumnType" %> +<%@ page import="org.openecomp.portalsdk.analytics.util.AppConstants" %> +<%@ page import="org.openecomp.portalsdk.analytics.model.definition.ReportDefinition" %> +<%@ page import="org.openecomp.portalsdk.analytics.system.AppUtils" %> +<%@ page import="org.openecomp.portalsdk.analytics.controller.WizardSequence" %> +<%@ page import="java.util.Vector" %> +<%@ page import="java.util.List" %> +<%@ page import="org.openecomp.portalsdk.analytics.model.DataCache" %> +<%@ page import="java.util.Iterator" %> +<%@ page import="org.openecomp.portalsdk.analytics.xmlobj.DataSourceType" %> +<%@ page import="org.openecomp.portalsdk.analytics.model.definition.DBColumnInfo" %> +<%@ page import="org.openecomp.portalsdk.analytics.model.definition.TableSource" %> +<%@ page import="org.openecomp.portalsdk.analytics.model.base.IdNameValue" %> +<%@ page import="org.openecomp.portalsdk.analytics.xmlobj.SemaphoreType" %> +<%@ page import="org.openecomp.portalsdk.analytics.xmlobj.FormFieldType" %> +<%@ page import="org.openecomp.portalsdk.analytics.model.definition.TableJoin" %> +<%@ page import="org.openecomp.portalsdk.analytics.error.UserDefinedException"%> + +<% + ReportDefinition rdef = (ReportDefinition) request.getAttribute(AppConstants.SI_REPORT_DEFINITION); + WizardSequence ws = rdef.getWizardSequence(); + String curSubStep = ws.getCurrentSubStep(); + boolean isEdit = curSubStep.equals(AppConstants.WSS_EDIT); + DataSourceType currTable = null; + if(isEdit) + currTable = rdef.getTableById(AppUtils.getRequestNvlValue(request, AppConstants.RI_DETAIL_ID)); + Vector reportTableSources = (isEdit)?DataCache.getReportTableSources((String) session.getAttribute("remoteDB")):DataCache.getReportTableSources(AppUtils.getUserRoles(request),((String) session.getAttribute("remoteDB")), AppUtils.getUserID(request), request); + if(reportTableSources.size()<=0) { + request.setAttribute(AppConstants.RI_EXCEPTION, new Exception("Please add table name to the raptor table for generating report")); + throw new UserDefinedException("Please add table name to the raptor table for generating report"); + } + Vector reportTableJoins = (isEdit)?DataCache.getReportTableJoins():DataCache.getReportTableJoins(AppUtils.getUserRoles(request)); %> + +<% if(! isEdit) { %> +<script language="JavaScript"> +<!-- + var tablesExist = false; + <% if(rdef.getDataSourceList().getDataSource().size()>0) { %> + tablesExist = true; + + function setJoinTableName(tableId) { + var selIndex = 0; + for(var i=1; i<document.forma.joinTableName.options.length; i++) + if(tableId==document.forma.joinTableName.options[i].value) + selIndex = i; + + document.forma.joinTableName.selectedIndex = selIndex; + } // setJoinTableName + <% } %> + + function tableNameChange() { + var newTableName = ""; + newTableName = document.forma.tableName.options[document.forma.tableName.selectedIndex].value; + + document.forma.displayName.value=document.forma.tableName.options[document.forma.tableName.selectedIndex].text; + + // Setting the PK values + if(false) {} + + <% for(int i=0; i<reportTableSources.size(); i++) { + TableSource tableSource = (TableSource) reportTableSources.get(i); %> + else if(newTableName=="<%= tableSource.getTableName() %>") + document.forma.tablePK.value = "<%= tableSource.getPkFields() %>"; + <% } %> + + <% if(rdef.getDataSourceList().getDataSource().size()>0) { + for(Iterator iter=rdef.getDataSourceList().getDataSource().iterator(); iter.hasNext(); ) { + DataSourceType dst = (DataSourceType) iter.next(); + + for(int i=0; i<reportTableJoins.size(); i++) { + TableJoin tableJoin = (TableJoin) reportTableJoins.get(i); + if(dst.getTableName().equals(tableJoin.getSrcTableName())) { %> + if(newTableName=="<%= tableJoin.getDestTableName() %>") + setJoinTableName("<%= dst.getTableId() %>"); + else + <% } else if(dst.getTableName().equals(tableJoin.getDestTableName())) { %> + if(newTableName=="<%= tableJoin.getSrcTableName() %>") + setJoinTableName("<%= dst.getTableId() %>"); + else + <% } // if + } // for + } %> + setJoinTableName(""); + <% } %> + listJoinExpr(document.forma.tableName.options[document.forma.tableName.selectedIndex].value, + document.forma.joinTableName.options[document.forma.joinTableName.selectedIndex].value); + } // tableNameChange + + +//--> +</script > +<% } %> + +<script language="JavaScript"> +<!-- + //load table join info to an array of objects + function table_join(src_table, dest_table, join_expr) { + this.src_table = src_table; + this.dest_table = dest_table; + this.join_expr = join_expr; + } + + var table_joins = new Array(); + + <% for(int i=0; i<reportTableJoins.size(); i++) { + TableJoin tableJoin = (TableJoin) reportTableJoins.get(i); %> + table_joins[table_joins.length] = + new table_join("<%=tableJoin.getSrcTableName()%>","<%=tableJoin.getDestTableName()%>","<%=tableJoin.getJoinExpr()%>"); + <% } %> + + function table_id_name_mapping(table_id, table_name) { + this.table_id = table_id; + this.table_name = table_name; + } + + var table_id_name_mappings = new Array(); + + <% for(Iterator iter=rdef.getDataSourceList().getDataSource().iterator(); iter.hasNext(); ) { + DataSourceType dst = (DataSourceType) iter.next(); %> + table_id_name_mappings["<%= dst.getTableId()%>"] = "<%= dst.getTableName()%>"; + table_id_name_mappings["<%= dst.getTableName()%>"] = "<%= dst.getTableId()%>"; + <% } %> + + function listJoinExpr(tableName, joinTableId) { + + removeAllOptions(document.forma.joinExpr); + var isJoinExprFound = false; + + <%if(isEdit) {%> + addOption(document.forma.joinExpr, "" ,"No Change"); + <%}%> + + for ( var i=0; i<table_joins.length; i++) { + if( (table_joins[i].src_table==tableName && table_joins[i].dest_table==table_id_name_mappings[joinTableId]) + || + (table_joins[i].dest_table==tableName && table_joins[i].src_table==table_id_name_mappings[joinTableId]) + ) + { + addOption(document.forma.joinExpr, table_joins[i].join_expr ,table_joins[i].join_expr ); + isJoinExprFound = true; + } + } + + if(!isJoinExprFound) + { + removeAllOptions(document.forma.joinExpr); + addOption(document.forma.joinExpr, "" ,"No Join Condition Defined"); + } + } + + function removeAllOptions(selectbox) + { + var i; + for(i=selectbox.options.length-1;i>=0;i--) + { + selectbox.remove(i); + } + } + + function addOption(selectbox, value, text ) + { + var optn = document.createElement("OPTION"); + optn.text = text; + optn.value = value; + + selectbox.options.add(optn); + } +--> +</script> + +<table width="100%" class="tableBorder" border="0" cellspacing="1" cellpadding="3" align=center> + <tr> + <td class=rbg1 colspan=2 valign="Middle"><b class=rtableheader>Step <%= ws.getCurrentStepIndex() %> of <%= ws.getStepCount() %> - Report <%= ws.getCurrentStep() %> - <%= curSubStep %></b></td> + </tr> + <tr> + <td align="right" width="25%" class=rbg2 height="30" style="background-image:url(<%= AppUtils.getImgFolderURL() %>required.gif); background-position:top right; background-repeat:no-repeat;"><font class=rtabletext>Table Name </font></td> + <td align="left" width="50%" class=rbg3><font class=rtabletext> + <% if(isEdit) { + String tName = null; + for(int i=0; i<reportTableSources.size(); i++) { + TableSource tableSource = (TableSource) reportTableSources.get(i); + if(currTable.getTableName().equals(tableSource.getTableName())) { + tName = tableSource.getDisplayName(); + break; + } // if + } %> + <%= nvl(tName, currTable.getTableName()) %> + <input type="hidden" name="tableName" value="<%=currTable.getTableName()%>"> + <% } else { %> + <select name="tableName" class="rtabletext" onChange="tableNameChange()"> + <% for(int i=0; i<reportTableSources.size(); i++) { + TableSource tableSource = (TableSource) reportTableSources.get(i); %> + <option value="<%= tableSource.getTableName() %>"<%= (i==0)?" selected":"" %>><%= tableSource.getDisplayName() %> + <% } %> + </select> + <% } %> + <input type="hidden" name="tablePK" value="<%= ((TableSource) reportTableSources.get(0)).getPkFields() %>"> + </font></td> + </tr> + <tr> + <td align="right" width="25%" class=rbg2 height="30"><font class=rtabletext>Display Name </font></td> + <td align="left" width="50%" class=rbg3><font class=rtabletext> + <input type="text" class="rtabletext" size="30" maxlength="30" name="displayName" value="<%= isEdit?currTable.getDisplayName():((TableSource) reportTableSources.get(0)).getDisplayName() %>"></font></td> + </tr> +<% if(rdef.getDataSourceList().getDataSource().size()>(isEdit?1:0)) { + String outerJoinType = (isEdit?rdef.getOuterJoinType(currTable):""); %> + <tr> + <td align="right" width="25%" class=rbg2 height="30"><font class=rtabletext>Join To Table </font></td> + <td align="left" width="50%" class=rbg3><font class=rtabletext> + <% if(isEdit) { %> + <% if(currTable.getRefTableId()==null){%> + --- Table Not Joined --- + <%} else { %> + <%=rdef.getTableById(currTable.getRefTableId()).getDisplayName() %> + </br>on : <%=currTable.getRefDefinition() %> + <%} %> + <input type="hidden" name="joinTableName" value="<%=currTable.getRefTableId()%>"> + + <% } else { %> + <select name="joinTableName" onChange="listJoinExpr();"> + <option value="" selected>--- Tables Not Joined --- + <% for(Iterator iter=rdef.getDataSourceList().getDataSource().iterator(); iter.hasNext(); ) { + DataSourceType dst = (DataSourceType) iter.next(); %> + <option value="<%= dst.getTableId() %>"><%= dst.getDisplayName() %> + <% } %> + </select> + <% } %> + </font></td> + </tr> + + <tr> + <td align="right" width="25%" class=rbg2 height="30"><font class=rtabletext>All availabe Join Options </font></td> + <td align="left" width="50%" class=rbg3><font class=rtabletext> + <select name="joinExpr"> + <option value="" selected>No Join Condition</option> + </select> + </font></td> + </tr> + <% if(isEdit) { %> + <script language="JavaScript"> + listJoinExpr("<%=currTable.getTableName()%>","<%=currTable.getRefTableId()%>"); + </script> + <%} %> + + <tr> + <td align="right" width="25%" class=rbg2 height="30"><font class=rtabletext>Join Type </font></td> + <td align="left" width="50%" class=rbg3><font class=rtabletext> + <select name="outerJoin"> + <option value=""<%= (outerJoinType.length()==0)?" selected":"" %>>Include only records present in both tables + <option value="<%= AppConstants.OJ_CURRENT %>"<%= outerJoinType.equals(AppConstants.OJ_CURRENT)?" selected":"" %>>Include join table records without match in this table + <option value="<%= AppConstants.OJ_JOINED %>"<%= outerJoinType.equals(AppConstants.OJ_JOINED)?" selected":"" %>>Include records from this table without match in the join table + </select> + </font></td> + </tr> +<% } %> +</table> +<br> + +<script language="JavaScript"> +<!-- +function checkNotJoined() { +<% if(rdef.getDataSourceList().getDataSource().size()>(isEdit?1:0)) { %> + if(document.forma.outerJoin.selectedIndex==0) { + <% if(isEdit) { %> + var selTable = "<%= currTable.getTableName() %>"; + var selDisplayName = "<%= currTable.getDisplayName() %>"; + <% } else { %> + var selTable = document.forma.tableName.options[document.forma.tableName.selectedIndex].value; + var selDisplayName = document.forma.tableName.options[document.forma.tableName.selectedIndex].text; + <% } %> + + if(false + <% for(int i=0; i<reportTableSources.size(); i++) { + TableSource tableSource = (TableSource) reportTableSources.get(i); + if(tableSource.getIsLargeData().equals("Y")) { %> + ||selTable=="<%= tableSource.getTableName() %>" + <% } // if + } // for + %> + ) { + alert("Table "+selDisplayName+" contains large amount of data\nand cannot be added unless it is joined to another table.\nPlease select a Join To Table from the list."); + document.forma.outerJoin.focus(); + + return false; + } // if + } +<% if(! isEdit) { %> + else { // if(document.forma.outerJoin.selectedIndex>0) + var selTable = document.forma.tableName.options[document.forma.tableName.selectedIndex].value; + var selJoinTblId = document.forma.outerJoin.options[document.forma.outerJoin.selectedIndex].value; + var selJoinTable = ""; + <% for(Iterator iter=rdef.getDataSourceList().getDataSource().iterator(); iter.hasNext(); ) { + DataSourceType dst = (DataSourceType) iter.next(); %> + if(selJoinTblId=="<%= dst.getTableId() %>") + selJoinTable = "<%= dst.getTableName() %>"; + <% } // for + for(Iterator iter=reportTableJoins.iterator(); iter.hasNext(); ) { + TableJoin tableJoin = (TableJoin) iter.next(); %> + if((selTable=="<%= tableJoin.getSrcTableName() %>"&&selJoinTable=="<%= tableJoin.getDestTableName() %>")|| + (selTable=="<%= tableJoin.getDestTableName() %>"&&selJoinTable=="<%= tableJoin.getSrcTableName() %>")) + return true; + <% } %> + + alert("Table "+document.forma.tableName.options[document.forma.tableName.selectedIndex].text+ + " cannot be joined to table "+document.forma.outerJoin.options[document.forma.outerJoin.selectedIndex].text+ + ".\nPlease select a different join."); + return false; + } // if +<% } // if(! isEdit) + } %> + + return true; +} // checkNotJoined + +function dataValidate() { + if(document.forma.displayName.value=="") + <% if(isEdit) { %> + document.forma.displayName.value = "<%= currTable.getDisplayName() %>"; + <% } else { %> + document.forma.displayName.value = document.forma.tableName.options[selectedIndex].text; + <% } %> + + if(false + <% for(Iterator iter=rdef.getDataSourceList().getDataSource().iterator(); iter.hasNext(); ) { + DataSourceType dst = (DataSourceType) iter.next(); + + if(! (isEdit&&dst.getTableId().equals(currTable.getTableId()))) { %> + ||document.forma.displayName.value=="<%= dst.getDisplayName() %>" + <% } + } %> + ) { + alert("Table with display name "+document.forma.displayName.value+" already exists.\nPlease select another name."); + document.forma.displayName.focus(); + document.forma.displayName.select(); + + return false; + } + + if(! checkNotJoined()) + return false; + + return true; +} // dataValidate +//--> +</script> + +<%! + private String nvl(String s) { return (s==null)?"":s; } + private String nvl(String s, String sDefault) { return nvl(s).equals("")?sDefault:s; } +%> |