<%-- ================================================================================ 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) { %> <% } %> <% if(rdef.getDataSourceList().getDataSource().size()>(isEdit?1:0)) { String outerJoinType = (isEdit?rdef.getOuterJoinType(currTable):""); %> <% if(isEdit) { %> <%} %> <% } %>

Step <%= ws.getCurrentStepIndex() %> of <%= ws.getStepCount() %> - Report <%= ws.getCurrentStep() %> - <%= curSubStep %>
Table Name	<% if(isEdit) { String tName = null; for(int i=0; i <%= nvl(tName, currTable.getTableName()) %> <% } else { %> <% for(int i=0; i ><%= tableSource.getDisplayName() %> <% } %> <% } %>
Display Name
Join To Table	<% if(isEdit) { %> <% if(currTable.getRefTableId()==null){%> --- Table Not Joined --- <%} else { %> <%=rdef.getTableById(currTable.getRefTableId()).getDisplayName() %> on : <%=currTable.getRefDefinition() %> <%} %> <% } else { %> --- Tables Not Joined --- <% for(Iterator iter=rdef.getDataSourceList().getDataSource().iterator(); iter.hasNext(); ) { DataSourceType dst = (DataSourceType) iter.next(); %> <%= dst.getDisplayName() %> <% } %> <% } %>
All availabe Join Options	No Join Condition
Join Type	>Include only records present in both tables >Include join table records without match in this table >Include records from this table without match in the join table

<%! private String nvl(String s) { return (s==null)?"":s; } private String nvl(String s, String sDefault) { return nvl(s).equals("")?sDefault:s; } %>