<%-- ================================================================================ 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="java.util.Map"%> <%@page import="java.util.HashMap"%> <%@page import="org.openecomp.portalsdk.analytics.model.ReportLoader"%> <%@ 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" %> <% ReportDefinition rdef = (ReportDefinition) request.getAttribute(AppConstants.SI_REPORT_DEFINITION); WizardSequence ws = rdef.getWizardSequence(); String curSubStep = ws.getCurrentSubStep(); boolean isCrossTab = rdef.getReportType().equals(AppConstants.RT_CROSSTAB); boolean isSQLBased = rdef.getReportDefType().equals(AppConstants.RD_SQL_BASED); String dbInfo = null; dbInfo = rdef.getDBInfo(); boolean isEdit = curSubStep.equals(AppConstants.WSS_EDIT) || curSubStep.equals(AppConstants.WA_MODIFY); DataColumnType currColumn = null; if(isEdit) currColumn = rdef.getColumnById(AppUtils.getRequestNvlValue(request, AppConstants.RI_DETAIL_ID)); Vector reportTableSources = DataCache.getReportTableSources((String) session.getAttribute("remoteDB")); List reportCols = rdef.getAllColumns(); HashMap actionImgMap = ReportLoader.loadActionImgLookUp(); String[] numberFormats = { "9999999990", "9,999,999,990", "9999999990.99", "9,999,999,990.99", "$9,999,999,990.99", "$9,999,999,990.999" }; String[] dateFormats = { "MM/DD/YYYY", "MM/YYYY", "DD-MON-YYYY", "Month DD, YYYY", "Month, YYYY", "MM/DD/YYYY HH24:MI:SS", "YYYY" }; String[] charFormats = { "N/A" }; String dispName = ""; String dbColType = ""; String colType = ""; if(isEdit) { dbColType = currColumn.getDbColType(); colType = currColumn.getColType(); } String dependsOnFormField = currColumn.getDependsOnFormField(); %> <% if(isSQLBased) { %> <% } // if(! isSQLBased) %> <% if(isCrossTab) { %> <% } %> <% if(! isSQLBased) { %> <% } // if(! isSQLBased) %> <% if(isSQLBased) { %> <% } %> <% if(! isSQLBased) { %> <% } // if(! isSQLBased) %> <% if (false) { %> <% } %> <% System.out.println("WidthInPxls " + currColumn.getDisplayWidthInPxls()); %> <% if(! isCrossTab) { %> <% if(! isSQLBased) { %> <% } %> <% } %> <% if(! isSQLBased) { %> <% boolean isOtherExpr = isEdit&&currColumn.isCalculated()&& (! nvl(currColumn.getColName()).startsWith("SUM( "))&& (! nvl(currColumn.getColName()).startsWith("MAX( "))&& (! nvl(currColumn.getColName()).startsWith("MIN( "))&& (! nvl(currColumn.getColName()).startsWith("COUNT(*)"))&& (! nvl(currColumn.getColName()).startsWith("COUNT(ALL "))&& (! nvl(currColumn.getColName()).startsWith("COUNT(DISTINCT "))&& (! nvl(currColumn.getColName()).startsWith("AVG(ALL "))&& (! nvl(currColumn.getColName()).startsWith("AVG(DISTINCT "))&& (! nvl(currColumn.getColName()).startsWith("STDDEV(ALL "))&& (! nvl(currColumn.getColName()).startsWith("STDDEV(DISTINCT "))&& (! nvl(currColumn.getColName()).startsWith("VARIANCE(ALL "))&& (! nvl(currColumn.getColName()).startsWith("VARIANCE(DISTINCT ")); %> <% } // if(! isSQLBased) %> <%-- if(! isCrossTab) { --%> <% String curSemId = ""; if(isEdit) curSemId = nvl(currColumn.getSemaphoreId()); %> <%-- } --%> <% boolean canHaveTotal = false; if(isSQLBased) { //canHaveTotal = (! isCrossTab); canHaveTotal = (!isCrossTab)||(isEdit&&nvl(currColumn.getCrossTabValue()).equals(AppConstants.CV_VALUE)); } else { if(isCrossTab) canHaveTotal = (isEdit&&nvl(currColumn.getCrossTabValue()).equals(AppConstants.CV_VALUE)); else canHaveTotal = colType.equals(AppConstants.CT_NUMBER); } String colTotalRow = ""; String colTotal = isEdit?nvl(currColumn.getDisplayTotal()):""; if(isCrossTab&&colTotal.indexOf('|')>=0) { colTotalRow = colTotal.substring(colTotal.indexOf('|')+1); colTotal = colTotal.substring(0, colTotal.indexOf('|')); } %> <% if(isCrossTab) { %> <% } // if(isCrossTab) %> <% if(isSQLBased) { %> <% } %>

Step <%= ws.getCurrentStepIndex() %> of <%= ws.getStepCount() %> - Report <%= ws.getCurrentStep() %> - <%= curSubStep %>
Column ID:	<%= currColumn.getColId() %>
Depends on formfield:	">
Column Usage in Cross-Tab:	><%= rdef.getCrossTabDisplayValue(AppConstants.CV_ROW) %> ><%= rdef.getCrossTabDisplayValue(AppConstants.CV_COLUMN) %> ><%= rdef.getCrossTabDisplayValue(AppConstants.CV_VALUE) %> >Invisible/Filter
Table Column:	<% if(isEdit) { %> <%= nvl(rdef.getColumnLabel(currColumn), currColumn.getDbColName()) /*currColumn.getColName()*/ %> <% } else { %> <% int icnt = 0; String remoteDbPrefix = dbInfo; for(Iterator iter=rdef.getDataSourceList().getDataSource().iterator(); iter.hasNext(); ) { DataSourceType dst = (DataSourceType) iter.next(); Vector dbColumns = DataCache.getReportTableDbColumns(dst.getTableName().toUpperCase(),remoteDbPrefix); if(dbColumns!=null) for(int i=0; i >[<%= dst.getDisplayName() %>].<%= dbCol.getLabel() %> <% if(icnt==0) { dispName = dbCol.getLabel(); dbColType = dbCol.getColType(); colType = dbColType; } icnt++; //} // if } // for } // for %> <% } %>
Datatype:	Select > Number > Date > Character > Hyperlink
Group By Pos:	Select > 1
Custom Text for Sub-Total:	"/>
Hide Repeated Values :	>
Multi group Column Level:	Select > AUXILIARY-COLUMN > 1 > 2 > 3 > 4
Multi group Column Range : Colspan :	"/>
<% if(!isCrossTab) { %> <%} %> Dataformat: Enhanced Pagination: />
URL: "/> Anchor: Select > Value Of the Column > IMAGE Select Image for anchor: <% if(!actionImgMap.isEmpty()) { for( Iterator itr=actionImgMap.entrySet().iterator(); itr.hasNext(); ) { Map.Entry e = (Map.Entry)itr.next(); String image_id = (String)e.getKey(); String image_loc = (String)e.getValue(); %> <% if (nvl(AppUtils.getRequestNvlValue(request, "actionImg")).length()>0 && !(AppUtils.getRequestNvlValue(request, "pdfImg").equals(currColumn.getActionImg())) ) { if(image_loc .equals (AppUtils.getRequestNvlValue(request, "actionImg"))) { %> <%=image_id %> <% } else { %> <%=image_id %> <% } } else { if(image_loc .equals (currColumn.getActionImg())) { %> <%=image_id %> <% } else { %> <%=image_id %> <% } } %> <% } } %>
Display Name:
Display Format:	<% String[] fmt; if(colType.equals(AppConstants.CT_NUMBER)) fmt = numberFormats; else if(colType.equals(AppConstants.CT_DATE)) fmt = dateFormats; else fmt = charFormats; for(int i=0; i "<%= (isEdit&&(nvl(currColumn.getColFormat()).toUpperCase().equals(fmt[i].toUpperCase())||("fm"+nvl(currColumn.getColFormat())).toUpperCase().equals(fmt[i].toUpperCase())))?" selected":"" %>><%= fmt[i] %> <% } %>
Display Width:	<% if (currColumn.getDisplayWidth()<=0) { currColumn.setDisplayWidth(10); } %> Custom >10% >20% >30% >40% >50% >60% >70% >80% >90% >100% <% if(!((currColumn.getDisplayWidth()%10 == 0) && (currColumn.getDisplayWidth() > 100)) ) { %> <%=currColumn.getDisplayWidth()%>% <% } %>
Display Width (In Pxls):	0)? (!(AppUtils.getRequestNvlValue(request, "widthInPxls").equals(currColumn.getDisplayWidthInPxls()))? AppUtils.getRequestNvlValue(request, "widthInPxls"):currColumn.getDisplayWidthInPxls()): currColumn.getDisplayWidthInPxls() %>">
No Wrap ?	>Yes >No
Indent Parameter to display value	Select > 1 > 2 > 3
Display Alignment:	>Left >Center >Right
Display (Header) Alignment:	>Left >Center >Right
Sortable?	>No >Yes
Visible?	>Yes >No
Group By?	>Yes >No
Expression:	> >Sum >Max >Min >Count All >Count Distinct >Average All >Average Distinct >Standard Deviation All >Standard Deviation Distinct >Variance All >Variance Distinct >---------- Other ----------
Expression Other:	onFocus="if(document.forma.exprFormula.options[document.forma.exprFormula.selectedIndex].value!='_exprText_') blur();">   Form Fields
Drill-down Link:	"> "> "> "> "> 0)?"":" selected" %>>----- No Drill-down ----- <% int tableDrillDownCount = 0; if(! isCrossTab) for(int i=0; i0&&rdef.getTableByDBName(tableSource.getTableName())!=null) { tableDrillDownCount++; %> ><%= tableSource.getDisplayName() %> Record Details <% } // if } // for Vector publicReportIdNames = DataCache.getPublicReportIdNames(); for(int i=0; i >Public Report: <%= reportIdName.getName() %> <% } %>: <% //if(!AppUtils.isSuperUser(request)) { Vector groupReportIdNames = DataCache.getGroupAccessibleReportIdNames(AppUtils.getUserID(request),AppUtils.getUserRoles(request)); for(int j=0; j >Group Report: <%= reportIdName.getName() %> <% } %> <%// } %> <% //if(!AppUtils.isSuperUser(request)) { Vector privateReportIdNames = DataCache.getPrivateAccessibleReportIdNames(AppUtils.getUserID(request),AppUtils.getUserRoles(request)); for(int j=0; j >Private Report: <%= reportIdName.getName() %> <% } %> <% // } %>
Advanced Display Formatting:	>----- Do Not Use Advanced Formatting ----- <% if(rdef.getSemaphoreList()!=null) for(Iterator iter=rdef.getSemaphoreList().getSemaphore().iterator(); iter.hasNext(); ) { SemaphoreType semaphore = (SemaphoreType) iter.next(); %> ><%= semaphore.getSemaphoreName() %> <% } // for %>
Total for <%= isCrossTab?"each":"the" %> column:	0)?"":" selected" %>>--- Do Not Display (Faster Report Execution) --- <% if(canHaveTotal) { for(int i=0; i ><%= tValue.getName() %> <% } // for } // if %>
Total for each row	0)?"":" selected" %>>--- Do Not Display (Faster Report Execution) --- <% if(canHaveTotal) { for(int i=0; i ><%= tValue.getName() %> <% } // for } // if %>
	> Do not attempt to parse values as date

<%! private String nvl(String s) { return (s==null)?"":s; } private String nvl(String s, String sDefault) { return nvl(s).equals("")?sDefault:s; } private String getRequestParam(String s) { if(nvl(s).equals("")) return s; else { String requestParam=""; int pos = 0; int iCnt = 0; while(s.indexOf("#",pos)!=-1) { iCnt++; if(iCnt>1) requestParam += "|"; pos = s.indexOf("#",pos)+1; requestParam += s.substring(s.indexOf("#")+1,s.indexOf("]",pos)); } return requestParam; } } %>