+++ /dev/null
-<%--
- ================================================================================
- 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; }
-%>
Code Review / policy / engine.git / blobdiff