+++ /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.List" %>
-<%@ page import="java.util.Iterator" %>
-<%@ page import="org.openecomp.portalsdk.analytics.system.Globals" %>
-<%@ page import="org.openecomp.portalsdk.analytics.util.Utils" %>
-<%@ page import="java.util.Vector" %>
-<%@ page import="org.openecomp.portalsdk.analytics.model.ReportLoader" %>
-<%@ page import="org.openecomp.portalsdk.analytics.model.base.IdNameValue" %>
-<%@ page import="org.openecomp.portalsdk.analytics.xmlobj.FormFieldType" %>
-<%@ page import="org.openecomp.portalsdk.analytics.model.base.ReportWrapper" %>
-<%@ page import="org.openecomp.portalsdk.analytics.model.DataCache" %>
-<%@ page import="org.openecomp.portalsdk.analytics.model.runtime.FormField" %>
-<%@ page import="java.text.SimpleDateFormat"%>
-<%
- ReportDefinition rdef = (ReportDefinition) request.getAttribute(AppConstants.SI_REPORT_DEFINITION);
- WizardSequence ws = rdef.getWizardSequence();
- String curSubStep = ws.getCurrentSubStep();
- String reportID = rdef.getReportID();
- boolean isCrossTab = rdef.getReportType().equals(AppConstants.RT_CROSSTAB);
- boolean isSQLBased = rdef.getReportDefType().equals(AppConstants.RD_SQL_BASED);
- String dependsOnHelp = "Custom SQL can be defined";
-%>
-
-<% String[] dateFormats = { "MM/DD/YYYY", "MM/YYYY", "DD-MON-YYYY", "Month DD, YYYY", "Month, YYYY" };
- String[] charFormats = { "N/A" };
-
- boolean isEdit = curSubStep.equals(AppConstants.WSS_EDIT);
- FormFieldType currField = null;
- if(isEdit)
- currField = rdef.getFormFieldById(AppUtils.getRequestNvlValue(request, AppConstants.RI_DETAIL_ID));
-
- String currColId = (currField!=null)?nvl(currField.getColId()):"";
- String remoteDbPrefix = (String) session.getAttribute("remoteDB");
-
- String colTableName = null;
- String colColumnName = null;
- String colDisplayFormat = null;
- String colDisplayName = null;
- if(isSQLBased)
- if(currColId.length()>0) {
- colTableName = ReportWrapper.getSQLBasedFFTColTableName(currColId);
- colColumnName = ReportWrapper.getSQLBasedFFTColColumnName(currColId);
- colDisplayFormat = ReportWrapper.getSQLBasedFFTColDisplayFormat(currColId);
-
- if(currColId.indexOf("|")>=0)
- currColId = currColId.substring(0, currColId.indexOf('|'));
- colDisplayName = colColumnName;
- //colDisplayName = currColId.substring(currColId.indexOf('.')+1);
- } %>
-
-<script language="JavaScript" src="<%= AppUtils.getBaseFolderURL() %>js/editabledropdown.js"></script>
-<script language="JavaScript">
-
-<!--
-var fieldColName = "";
-
- function toggleDiv(isChecked) {
- if(isChecked) {
- if(document.getElementById('showDefaultSql'))
- document.getElementById('showDefaultSql').style.display="";
- if(document.getElementById('showDefaultValue'))
- document.getElementById('showDefaultValue').style.display="none";
- if(document.forma.defaultValue)
- document.forma.defaultValue.value="";
- } else {
- if(document.getElementById('showDefaultSql'))
- document.getElementById('showDefaultSql').style.display="none";
- if(document.getElementById('showDefaultValue'))
- document.getElementById('showDefaultValue').style.display="";
- if(document.getElementById('showDefaultSql') && document.forma.fieldDefaultSQL)
- document.forma.fieldDefaultSQL.value="";
- }
-
- }
-
- function toggleFieldTypeSelection() {
- var selectBox = document.forma.fieldType;
- var selectedString = "";
- if(selectBox)
- selectedString = selectBox.options[selectBox.selectedIndex].value;
- else {
- <% if(currField!=null) { %>
- selectString = '<%=currField.getFieldType()%>';
- <% } %>
- }
-
- if(selectedString == '<%= FormField.FFT_LIST_MULTI %>'){
- document.getElementById('multiSelectListSizeDiv').style.display="block";
- } else {
- document.getElementById('multiSelectListSizeDiv').style.display="none";
- document.getElementById('multiSelectListSize').value="4";
- }
- }
-
-<% if(isSQLBased) { %>
-function showTableColsPopup() {
- var w = window.open("<%= AppUtils.getRaptorActionURL() %>report.popup.table.cols&single_value=Y&return_table_name=Y&return_col_type=Y&remoteDbPrefix=<%=remoteDbPrefix%>", "tableColsPopup", "width=450,height=330,location=no,menubar=no,toolbar=no,status=no,resizable=yes,scrollbars=yes");
- w.focus();
- w.opener = this;
-} // showTableColsPopup
-
-function setDisplayTypeValues(dbType) {
- if(document.forma.colType.value!=dbType) {
- document.forma.colType.value = dbType;
-
- document.forma.displayFormat.options.length = 0;
-
- if(document.forma.colType.value=="<%= AppConstants.CT_DATE %>") {
- <% for(int i=0; i<dateFormats.length; i++) { %>
- document.forma.displayFormat.options[<%= i %>] = new Option("<%= dateFormats[i] %>", "<%= dateFormats[i] %>");
- <% } %>
- } else {
- <% for(int i=0; i<charFormats.length; i++) { %>
- document.forma.displayFormat.options[<%= i %>] = new Option("<%= charFormats[i] %>", "<%= charFormats[i].equals("N/A")?"":charFormats[i] %>");
- <% } %>
- } // else
-
- document.forma.displayFormat.selectedIndex = 0;
-
- if(document.layers)
- history.go(0);
- } // if
-} // setDisplayTypeValues
-
-function addText(newValue) {
- var newText = "";
- if(newValue.indexOf("|")<0)
- newText = newValue;
- else {
- setDisplayTypeValues(newValue.substring(newValue.lastIndexOf("|")+1));
- newText = newValue.substring(0, newValue.lastIndexOf("|"));
- } // else
-
- document.getElementById('fieldColId').value = newText;
-
- var newFieldColName = "";
- newFieldColName = newText.substring(newText.lastIndexOf(".")+1);
-
- if(document.getElementById('fieldName').value==""||document.getElementById('fieldName').value==fieldColName)
- document.getElementById('fieldName').value = newFieldColName;
- fieldColName = newFieldColName;
-} // addText
-
-function clearText() {
- document.getElementById('fieldColId').value = "";
-} // clearText
-
-<% } else { %>
-function changeColId() {
- var newFieldColName = document.getElementById('fieldColId').options[document.getElementById('fieldColId').selectedIndex].text;
- if(document.getElementById('fieldColId').selectedIndex>0&&(document.getElementById('fieldName').value==""||document.getElementById('fieldName').value==fieldColName))
- document.getElementById('fieldName').value = newFieldColName;
- fieldColName = newFieldColName;
-} // changeColId
-
-function showDefaultValuePopup() {
- if(document.getElementById('fieldColId').selectedIndex==0) {
- alert("The assistance is available only if this field is based on a column.\nYou can select a column from the list or just type a default value.");
- document.getElementById('fieldColId').focus();
- return;
- } // if
-
- var colId = document.getElementById('fieldColId').options[document.getElementById('fieldColId').selectedIndex].value;
-
- var w = window.open("<%= AppUtils.getRaptorActionURL() %>report.popup.filter.data&<%= AppConstants.RI_ARG_TYPE %>=<%= AppConstants.AT_VALUE %>&<%= AppConstants.RI_COLUMN_ID %>="+colId+"&<%= AppConstants.RI_JS_TARGET_FIELD %>=document.forma.defaultValue&<%= AppConstants.RI_RESET_PARAMS %>=Y", "defaultValuePopup", "width=440,height=400,location=no,menubar=no,toolbar=no,status=no,resizable=yes,scrollbars=yes");
- w.focus();
- w.opener = this;
-} // showDefaultValuePopup
-<% } // else if(isSQLBased)
-%>
-
-function showTestRunSQLPopup() {
- //var w = window.open("<%= AppUtils.getRaptorActionURL() %>report.popup.testrun.sql&<%= AppConstants.RI_FORMATTED_SQL %>="+escape(""+document.getElementById('fieldSQL').value)+"&<%= AppConstants.RI_CHK_FIELD_SQL %>=Y", "testRunSQLPopup", "width=450,height=330,location=no,menubar=no,toolbar=no,status=no,resizable=yes,scrollbars=yes");
- var w = window.open("<%= AppUtils.getRaptorActionURL() %>report.field.testrun.jsp", "testRunSQLPopup", "width=450,height=330,location=no,menubar=no,toolbar=no,status=no,resizable=yes,scrollbars=yes");
- w.focus();
- w.opener = this;
-} // showTestRunSQLPopup
-
-function showTestRunDefaultSQLPopup() {
- //var w = window.open("<%= AppUtils.getRaptorActionURL() %>report.popup.testrun.sql&<%= AppConstants.RI_FORMATTED_SQL %>="+escape(""+document.getElementById('fieldSQL').value)+"&<%= AppConstants.RI_CHK_FIELD_SQL %>=Y", "testRunSQLPopup", "width=450,height=330,location=no,menubar=no,toolbar=no,status=no,resizable=yes,scrollbars=yes");
- var w = window.open("<%= AppUtils.getRaptorActionURL() %>report.field.default.testrun.jsp", "testRunSQLPopup", "width=450,height=330,location=no,menubar=no,toolbar=no,status=no,resizable=yes,scrollbars=yes");
- w.focus();
- w.opener = this;
-} // showTestRunDefaultSQLPopup
-
-function showStartDatetRunSQLPopup( ) {
- var w = window.open("<%= AppUtils.getRaptorActionURL() %>report.field.date.start.testrun.jsp", "testRunSQLPopup", "width=450,height=330,location=no,menubar=no,toolbar=no,status=no,resizable=yes,scrollbars=yes");
- w.focus();
- w.opener = this;
-} // showTestRunRangeSQLPopup
-
-function showEndDateRunSQLPopup( ) {
- var w = window.open("<%= AppUtils.getRaptorActionURL() %>report.field.date.end.testrun.jsp", "testRunSQLPopup", "width=450,height=330,location=no,menubar=no,toolbar=no,status=no,resizable=yes,scrollbars=yes");
- w.focus();
- w.opener = this;
-}
-function setDefaultVerifyFlag() {
- document.forma.fieldDefaultSQLOrig.value = document.forma.fieldDefaultSQL.value;
-} // setDefaultVerifyFlag
-
-function setVerifyFlag() {
- document.forma.fieldSQLOrig.value = document.getElementById('fieldSQL').value;
-} // setVerifyFlag
-
-function showSQLInstructions() {
- var w = window.open("", "instrPopup", "width=400,height=330,location=no,menubar=no,toolbar=no,status=no,resizable=yes,scrollbars=yes");
- w.focus();
- w.opener = this;
-
- w.document.writeln("<html><head>");
- w.document.writeln("<title>Form Field SQL Instructions</title>");
- w.document.writeln("<link rel=stylesheet type=text/css href='<%= AppUtils.getBaseFolderURL() %>css/raptor.css'>");
- w.document.writeln("</head><body>");
-
- w.document.writeln("<table width=94% border=0 cellspacing=1 cellpadding=3 align=center>");
- w.document.writeln(" <tr class=rbg1 height=30>");
- w.document.writeln(" <td><b class=rtableheader>Form Field SQL Instructions</b></td>");
- w.document.writeln(" </tr>");
- w.document.writeln(" <tr class=rbg3 align=center valign=middle>");
- w.document.writeln(" <td align=left valign=middle><font class=rtabletext>");
- w.document.writeln(" The SQL result set must have a column <b>id</b> and a column <b>name</b>. ");
- w.document.writeln(" If selecting date values in visual report, the <b>id</b> must be formatted <b>MM/DD/YYYY</b>; the <b>name</b> can use any display format. ");
- w.document.writeln(" Example:<br><br><b>SELECT DISTINCT</b><br> ");
- w.document.writeln(" TO_CHAR(t.start_date, 'MM/DD/YYYY') <b>id</b>,<br> ");
- w.document.writeln(" TO_CHAR(t.start_date, 'Month YYYY') <b>name</b><br> ");
- w.document.writeln(" <b>FROM</b><br> ");
- w.document.writeln(" my_table t<br> ");
- w.document.writeln(" <b>WHERE</b><br> ");
- w.document.writeln(" t.start_date IS NOT NULL<br> ");
- w.document.writeln(" <b>ORDER BY</b><br> ");
- w.document.writeln(" t.start_date DESC");
- w.document.writeln(" </font></td>");
- w.document.writeln(" </tr>");
- w.document.writeln(" <tr class=rbg1 height=30>");
- w.document.writeln(" <td> </td>");
- w.document.writeln(" </tr>");
- w.document.writeln(" <tr>");
- w.document.writeln(" <td align=center><br><input type=Submit class=Button value=Close onClick=\"window.close();\"></td>");
- w.document.writeln(" </tr>");
- w.document.writeln("</table>");
-
- w.document.writeln("</body></html>");
- w.document.close();
-} // showSQLInstructions
-
-function showRangeSQLInstructions() {
- var w = window.open("", "instrPopup", "width=400,height=330,location=no,menubar=no,toolbar=no,status=no,resizable=yes,scrollbars=yes");
- w.focus();
- w.opener = this;
-
- w.document.writeln("<html><head>");
- w.document.writeln("<title>Form Field Range SQL Instructions</title>");
- w.document.writeln("<link rel=stylesheet type=text/css href='<%= AppUtils.getBaseFolderURL() %>css/raptor.css'>");
- w.document.writeln("</head><body>");
-
- w.document.writeln("<table width=94% border=0 cellspacing=1 cellpadding=3 align=center>");
- w.document.writeln(" <tr class=rbg1 height=30>");
- w.document.writeln(" <td><b class=rtableheader>Form Field Range SQL Instructions</b></td>");
- w.document.writeln(" </tr>");
- w.document.writeln(" <tr class=rbg3 align=center valign=middle>");
- w.document.writeln(" <td align=left valign=middle><font class=rtabletext>");
- w.document.writeln(" The SQL should ALWAYS return a valid Oralce date. If the return is not a valid date, the range will not be set.<br>");
- w.document.writeln(" The SQL will always get precedence over the static values.<br>");
- w.document.writeln(" ");
- w.document.writeln(" Example:<br><br><b>SELECT</b> SYSDATE<br> ");
- w.document.writeln(" <b>FROM</b> DUAL");
- w.document.writeln(" </font></td>");
- w.document.writeln(" </tr>");
- w.document.writeln(" <tr class=rbg1 height=30>");
- w.document.writeln(" <td> </td>");
- w.document.writeln(" </tr>");
- w.document.writeln(" <tr>");
- w.document.writeln(" <td align=center><br><input type=Submit class=Button value=Close onClick=\"window.close();\"></td>");
- w.document.writeln(" </tr>");
- w.document.writeln("</table>");
-
- w.document.writeln("</body></html>");
- w.document.close();
-} // showRangeSQLInstructions
-//-->
-</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 class=rbg2 align="right" width="25%" height="30" style="background-image:url(<%= AppUtils.getImgFolderURL() %>required.gif); background-position:top right; background-repeat:no-repeat;"><font class=rtabletext>Field Name: </font></td>
- <td class=rbg3 align="left" width="50%"><font class=rtabletext>
- <input type="text" style="width: 100px;" class="rtabletext" size="30" maxlength="30" id="fieldName" name="fieldName" value="<%= isEdit?currField.getFieldName():"" %>"></font></td>
- </tr>
- <tr>
- <td class=rbg2 align="right" height="30"><font class=rtabletext>Based On Column: </font></td>
- <td class=rbg3 align="left" nowrap><font class=rtabletext>
-<% if(isSQLBased) { %>
- <input type=text style="width: 100px;" class="rtabletext" size=50 id="fieldColId" name="fieldColId" value="<%= currColId %>" onFocus="blur()">
- <a href="javascript:showTableColsPopup()"><img border=0 src="<%= AppUtils.getImgFolderURL() %>shareicon.gif" alt="Select database column" width=12 height=12></a>
-<% } else { %>
- <select name="fieldColId" class="rtabletext" onChange="changeColId()" style="width: 100px;" >
- <option value=""<%= currColId.equals("")?" selected":"" %>>--- None ---
-<% int iCount = 0;
- List reportCols = rdef.getAllColumns();
- for(Iterator iter=reportCols.iterator(); iter.hasNext(); iCount++) {
- DataColumnType dct = (DataColumnType) iter.next(); %>
- <option value="<%= dct.getColId() %>"<%= currColId.equals(dct.getColId())?" selected":"" %>><%= dct.getDisplayName() %>
-<% if(currColId.equals(dct.getColId()))
- colDisplayName = dct.getDisplayName();
- } // for
-%>
- </select>
-<% } // else if(isSQLBased)
- if(colDisplayName!=null) { %>
-<script language="JavaScript">
-<!--
-fieldColName = "<%= colDisplayName %>";
-//-->
-</script>
-<% } // if
-%>
- </font>
- </td>
- </tr>
-<% if(isSQLBased) {
- String colType = AppConstants.CT_CHAR;
- if(colTableName!=null&&colColumnName!=null)
- try {
- colType = nvl(DataCache.getReportTableDbColumnType(colTableName, colColumnName,((String) session.getAttribute("remoteDB"))), AppConstants.CT_CHAR);
- } catch(Exception e) {}
-
- String[] fmt;
- if(colType.equals(AppConstants.CT_DATE))
- fmt = dateFormats;
- else
- fmt = charFormats; %>
- <tr>
- <td class=rbg2 align="right" height="30"><font class=rtabletext>Display Format: </font></td>
- <td class=rbg3 align="left"><font class=rtabletext>
- <select name="displayFormat" style="width: 100px;" >
- <% for(int i=0; i<fmt.length; i++) { %>
- <option value="<%= fmt[i].equals("N/A")?"":fmt[i] %>"<%= (nvl(colDisplayFormat).toUpperCase().equals(fmt[i].toUpperCase()))?" selected":"" %>><%= fmt[i] %>
- <% } %>
- </select>
- <input type="hidden" name="colType" value="<%= colType %>">
- </font></td>
- </tr>
-<% } // if
-%>
-
- <tr>
- <td class=rbg2 align="right" height="30"><font class=rtabletext>Visible? </font></td>
- <td class=rbg3 align="left"><font class=rtabletext>
- <select name="visible" style="width: 100px;" >
- <option value="Y"<%= isEdit?(nvl(currField.getVisible(),"Y").startsWith("Y")?" selected":""):" selected" %>>Yes
- <option value="N"<%= (isEdit&&(! nvl(currField.getVisible(),"Y").startsWith("Y")))?" selected":"" %>>No
- </select></font></td>
- </tr>
- <% if(Globals.getAllowSQLBasedReports() || AppUtils.isAdminUser(request)) { %>
- <tr>
- <td class=rbg2 height="30" align="right">
- <font class=rtabletext>Is used in Group By Clause?</font>
- </td>
- <td class=rbg3 align="left" nowrap>
- <input type="checkbox" name="isGroupFormField" value="Y" <%=(currField!=null && (currField.isGroupFormField()!=null && currField.isGroupFormField().booleanValue()))?" checked":"" %>>
- </td>
- </tr>
- <% } %>
-
-
- <tr>
- <td class=rbg2 align="right" height="30"><font class=rtabletext>Field Type: </font></td>
- <td class=rbg3 align="left"><font class=rtabletext>
- <% String curValue = nvl((currField!=null)?currField.getFieldType():"", FormField.FFT_TEXT_W_POPUP); %>
- <select name="fieldType" onChange="toggleFieldTypeSelection()" style="width: 100px;" >
- <%--<option value="<%= FormField.FFT_TEXT_W_POPUP %>"<%= curValue.equals(FormField.FFT_TEXT_W_POPUP)?" selected":"" %>>Text Box with Popup --%>
- <option value="<%= FormField.FFT_TEXT %>"<%= curValue.equals(FormField.FFT_TEXT )?" selected":"" %>>Text Box
- <%--<option value="<%= FormField.FFT_TEXTAREA %>"<%= curValue.equals(FormField.FFT_TEXTAREA )?" selected":"" %>>Text Area--%>
- <%--<option value="<%= FormField.FFT_COMBO_BOX %>"<%= curValue.equals(FormField.FFT_COMBO_BOX )?" selected":"" %>>Drop-Down List--%>
- <option value="<%= FormField.FFT_LIST_BOX %>"<%= curValue.equals(FormField.FFT_LIST_BOX )?" selected":"" %>>List Box
- <%--<option value="<%= FormField.FFT_RADIO_BTN %>"<%= curValue.equals(FormField.FFT_RADIO_BTN )?" selected":"" %>>Radio Buttons
- <option value="<%= FormField.FFT_CHECK_BOX %>"<%= curValue.equals(FormField.FFT_CHECK_BOX )?" selected":"" %>>Check Boxes --%>
- <option value="<%= FormField.FFT_LIST_MULTI %>"<%= curValue.equals(FormField.FFT_LIST_MULTI )?" selected":"" %>>Multi-select List Box
- <option value="<%= FormField.FFT_HIDDEN %>"<%= curValue.equals(FormField.FFT_HIDDEN )?" selected":"" %>>Hidden
- </select>
- </font></td>
- </tr>
-
- <tr id="multiSelectListSizeDiv">
- <td class=rbg2 align="right" height="30"><font class=rtabletext>Visible Size: </font></td>
- <td class=rbg3 align="left"><font class=rtabletext>
- <select id="multiSelectListSize" name="multiSelectListSize" onKeyDown="fnKeyDownHandler(this, event);" onKeyUp="fnKeyUpHandler_A(this, event); return false;" onKeyPress = "return fnKeyPressHandler_A(this, event);" onChange="fnChangeHandler_A(this, event);">
- <option value="1"<%= (currField!=null && nvl(currField.getMultiSelectListSize(), "4").equals("1")?" selected":"" )%>>1
- <option value="2"<%= (currField!=null && nvl(currField.getMultiSelectListSize(), "4").equals("2")?" selected":"" )%>>2
- <option value="3"<%= (currField!=null && nvl(currField.getMultiSelectListSize(), "4").equals("3")?" selected":"" )%>>3
- <option value="4"<%= (currField!=null && nvl(currField.getMultiSelectListSize(), "4").equals("4")?" selected":"" )%>>4
- <option value="5"<%= (currField!=null && nvl(currField.getMultiSelectListSize(), "4").equals("5")?" selected":"" )%>>5
- <option value="6"<%= (currField!=null && nvl(currField.getMultiSelectListSize(), "4").equals("6")?" selected":"" )%>>6
- <option value="7"<%= (currField!=null && nvl(currField.getMultiSelectListSize(), "4").equals("7")?" selected":"" )%>>7
- <option value="8"<%= (currField!=null && nvl(currField.getMultiSelectListSize(), "4").equals("8")?" selected":"" )%>>8
- <option value="9"<%= (currField!=null && nvl(currField.getMultiSelectListSize(), "4").equals("9")?" selected":"" )%>>9
- <option value="10"<%= (currField!=null && nvl(currField.getMultiSelectListSize(), "4").equals("10")?" selected":"" )%>>10
- <option value="" style="COLOR:#ff0000;BACKGROUND-COLOR:#ffff00;">Custom</option> <!-- This is the Editable Option -->
- <% if(currField!=null && isNumber(nvl(currField.getMultiSelectListSize())) && new Integer(nvl(currField.getMultiSelectListSize(), "0")).intValue() <= 20) {
- %>
- <option value="<%=nvl(currField.getMultiSelectListSize())%>" selected><%=nvl(currField.getMultiSelectListSize())%></option> <!-- This is the Editable Option -->
- <%
- }
- %>
- </select>
- </font></td>
- </tr>
-
- <%if(! isSQLBased) { %>
- <tr>
- <td class=rbg2 align="right" height="30"><font class=rtabletext>Default Value: </font></td>
- <td class=rbg3 align="left"><font class=rtabletext>
- <input type="text" class="rtabletext" size="20" maxlength="50" name="defaultValue" value="<%= isEdit?nvl(currField.getDefaultValue()):"" %>"></font>
- <a href="javascript:showDefaultValuePopup()"><img border="0" src="<%= AppUtils.getImgFolderURL() %>shareicon.gif" alt="Select from list" width="12" height="12"></a>
- </td></tr>
- <% } else { %>
- <% if(Globals.getAllowSQLBasedReports() || AppUtils.isAdminUser(request)) { %>
-
- <tr>
- <td class=rbg2 height="30" align="right">
- <font class=rtabletext>Is Default Value should be SQL</font>
- </td>
- <td class=rbg3 align="left" nowrap>
- <input type="checkbox" id="isDefaultSQL" name="isDefaultSQL" value="N" <%=currField!=null && currField.getFieldDefaultSQL()!=null && currField.getFieldDefaultSQL().length()>0?" checked":"" %> onClick="toggleDiv(this.checked)">
- </td>
- </tr>
-
-
- <tbody id="showDefaultSql" style="display:none;">
- <tr>
- <td class=rbg2 height="30" align="right">Default SQL: </td>
- <td class=rbg3>
- <table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td valign="top" rowspan="2">
- <input type="hidden" name="fieldDefaultSQLOrig" value="<%= (currField!=null)?nvl(currField.getFieldDefaultSQL()):"" %>">
- <textarea class="buttonLabelField" name="fieldDefaultSQL" cols="40" rows="3"><%= (currField!=null)?nvl(currField.getFieldDefaultSQL()):"" %></textarea>
- </td>
- <td align="center" valign="top"> <input type="Button" att-button btn-type="primary" size="small" class=button value="Verify SQL" onClick="if(document.forma.fieldDefaultSQL.value=='') {alert('Please provide SQL.'); return false; } showTestRunDefaultSQLPopup();"> </td>
- <td rowspan="2" width="60%"> </td></tr><tr>
- <td align="center" valign="middle"> <a href="javascript:showSQLInstructions()" class=rtabletext>Instructions</a> </td>
- </tr></table>
- </td>
- </tr>
- </tbody>
- <% if(Globals.getAllowSQLBasedReports() || AppUtils.isAdminUser(request)) { %>
- <script language="Javascript">
- toggleDiv(document.getElementById('isDefaultSQL').checked);
- </script>
- <% } %>
- <% } // if admin user %>
- <tbody id="showDefaultValue">
- <tr>
- <td class=rbg2 height="30" align="right"> Default Value: </td>
- <td class=rbg3>
- <table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td valign="top" rowspan="2">
- <input type="text" style="width:200px" class="rtabletext" size="20" maxlength="50" name="defaultValue" value="<%= isEdit?nvl(currField.getDefaultValue()):"" %>"></font>
- </td>
- </tr></table>
- </td>
- </tr>
- </tbody>
- <% if(Globals.getAllowSQLBasedReports() || AppUtils.isAdminUser(request)) { %>
- <script language="Javascript">
- toggleDiv(document.getElementById('isDefaultSQL').checked);
- </script>
- <% } %>
- <% } //else %>
- <tr>
- <td class=rbg2 align="right" height="30"><font class=rtabletext>Verify Field Value As: </font></td>
- <td class=rbg3 align="left"><font class=rtabletext>
- <% curValue = nvl((currField!=null)?currField.getValidationType():"", FormField.VT_NONE); %>
- <select name="validation" onChange="if (this.value =='<%= FormField.VT_DATE%>') ; else dateRangeRow.style.display='none'" style="width: 200px;" >
- <option value="<%= FormField.VT_NONE %>"<%= curValue.equals(FormField.VT_NONE )?" selected":"" %>>--- Do Not Perform Validation ---
- <option value="<%= FormField.VT_DATE %>"<%= curValue.equals(FormField.VT_DATE )?" selected":"" %>>Date
- <option value="<%= FormField.VT_TIMESTAMP_HR %>"<%= curValue.equals(FormField.VT_TIMESTAMP_HR )?" selected":"" %>>TimeStamp (Hour)
- <option value="<%= FormField.VT_TIMESTAMP_MIN %>"<%= curValue.equals(FormField.VT_TIMESTAMP_MIN )?" selected":"" %>>TimeStamp (Hour, Min)
- <option value="<%= FormField.VT_TIMESTAMP_SEC %>"<%= curValue.equals(FormField.VT_TIMESTAMP_SEC )?" selected":"" %>>TimeStamp (Hour, Min, Sec)
- <option value="<%= FormField.VT_INT %>"<%= curValue.equals(FormField.VT_INT )?" selected":"" %>>Integer
- <option value="<%= FormField.VT_INT_NON_NEGATIVE %>"<%= curValue.equals(FormField.VT_INT_NON_NEGATIVE )?" selected":"" %>>Positive Integer
- <option value="<%= FormField.VT_INT_POSITIVE %>"<%= curValue.equals(FormField.VT_INT_POSITIVE )?" selected":"" %>>Positive Integer, Cannot Be Zero
- <option value="<%= FormField.VT_FLOAT %>"<%= curValue.equals(FormField.VT_FLOAT )?" selected":"" %>>Any Number
- <option value="<%= FormField.VT_FLOAT_NON_NEGATIVE %>"<%= curValue.equals(FormField.VT_FLOAT_NON_NEGATIVE)?" selected":"" %>>Positive Number
- <option value="<%= FormField.VT_FLOAT_POSITIVE %>"<%= curValue.equals(FormField.VT_FLOAT_POSITIVE )?" selected":"" %>>Positive Number, Cannot Be Zero
- </select></font>
- </td>
- </tr>
- <tr id="dateRangeRow" <%if(curValue.equals(FormField.VT_DATE) || curValue.equals(FormField.VT_TIMESTAMP_HR) || curValue.equals(FormField.VT_TIMESTAMP_MIN) || curValue.equals(FormField.VT_TIMESTAMP_SEC)){%><%}else{%>style="display:none"<%}%>>
- <td colspan="2" class=rbg2>
- <table width="100%">
- <tr>
- <td class=rbg2 align="right" width="33%" height="30"><font class=rtabletext>Valid Date Range: </font></td>
- <td width="15%" align="left">
- <font class=rtabletext >From </font>
- </td>
- <td align="left">
- <font class=rtabletext >To </font>
-
- <a href="javascript:showRangeSQLInstructions()" class=rtabletext>Instructions</a>
- </td>
-
- </tr>
- <tr>
- <td class=rbg2 align="right"></td>
- </td>
- <td width="15%" align="left">
- <input type="hidden" name="rangeStartDateSQLOrig" value="<%= (currField!=null)?nvl(currField.getRangeStartDateSQL()):"" %>">
- <textarea name="rangeStartDateSQL" class="rtabletext" style="width: 200px;height: 100px" cols="20" rows="3"><%= (currField!=null)?nvl(currField.getRangeStartDateSQL()):"" %></textarea>
-
- </td>
- <td align="left">
- <input type="hidden" name="rangeEndDateSQLOrig" value="<%= (currField!=null)?nvl(currField.getRangeEndDateSQL()):"" %>">
- <textarea name="rangeEndDateSQL" class="rtabletext" style="width: 200px;height: 100px" cols="20" rows="3"><%= (currField!=null)?nvl(currField.getRangeEndDateSQL()):"" %></textarea>
-
- </td>
- </tr>
- <tr>
- <td class=rbg2 align="right"></td>
- </td>
- <td width="15%" align="left">
- <input type="Button" class=button att-button btn-type="primary" size="small" value="Verify SQL" onClick="if(document.forma.rangeStartDateSQL.value=='') {alert('Please provide SQL.'); return false; } showStartDatetRunSQLPopup();"> </td>
- </td>
- <td align="left">
- <input type="Button" class=button att-button btn-type="primary" size="small" value="Verify SQL" onClick="if(document.forma.rangeEndDateSQL.value=='') {alert('Please provide SQL.'); return false; } showEndDateRunSQLPopup();"> </td>
- </td>
- </tr>
- <tr>
- <td class=rbg2 align="right"></td>
- <td class=rbg3 align="left">
- <% String stDate = "";
- String endDate = "";
- if (currField!= null
- && currField.getRangeStartDate() != null && currField.getRangeStartDate().equals("") == false
- && currField.getRangeEndDate() != null && currField.getRangeEndDate().equals("") == false){
- SimpleDateFormat dtf = new SimpleDateFormat("MM/dd/yyyy");
- stDate = dtf.format(currField.getRangeStartDate().toGregorianCalendar().getTime());
- endDate = dtf.format(currField.getRangeEndDate().toGregorianCalendar().getTime());
- }
- %>
- <input type="text" class="rtabletext" size="10" maxlength="10" style="width: 100px;" name="rangeStartDate" id="rangeStartDate" value="<%=stDate%>">
- <img src="<%= AppUtils.getImgFolderURL() %>calender_icon.gif" align=absmiddle border=0 width="20" height="20" onClick="oCalendar.select(document.getElementById('rangeStartDate'),event,'MM/dd/yyyy'); return false;" style="cursor:hand">
-
-
- </td>
- <td>
- <input type="text" class="rtabletext" size="10" maxlength="10" style="width: 100px;" name="rangeEndDate" id="rangeEndDate" value="<%=endDate%>">
- <img src="<%= AppUtils.getImgFolderURL() %>calender_icon.gif" align=absmiddle border=0 width="20" height="20" onClick="oCalendar.select(document.getElementById('rangeEndDate'),event,'MM/dd/yyyy'); return false;" style="cursor:hand">
- </td>
- </tr>
-
- </table>
- </td>
-
- </tr>
- <tr>
- <td class=rbg2 align="right" height="30"><font class=rtabletext> </font></td>
- <td class=rbg3 align="left">
- <% curValue = nvl((currField!=null)?currField.getMandatory():"", "N"); %>
- <input type="Checkbox" class="checkbox" name="mandatory" value="Y"<%= curValue.equals("Y")?" checked":"" %>>
- <font class=rtabletext>User must provide value for this field</font>
- </td>
- </tr>
- <tr>
- <td class=rbg2 align="right" height="30"><font class=rtabletext>Field Help Text: </font></td>
- <td class=rbg3 align="left">
- <textarea name="fieldHelp" style="width: 100px;" class="rtabletext" cols="40" rows="3"><%= (currField!=null)?nvl(currField.getComment()):"" %></textarea>
- </td>
- </tr>
-<% if(Globals.getAllowSQLBasedReports()||AppUtils.isAdminUser(request)) { %>
- <tr>
- <td class=rbg2 align="right" height="30"><font class=rtabletext>SQL Generating Custom List of Values: <br>(overrides default list) </font></td>
- <td class=rbg3 align="left">
- <table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td valign="top" rowspan="2">
- <input type="hidden" name="fieldSQLOrig" value="<%= (currField!=null)?nvl(currField.getFieldSQL()):"" %>">
- <textarea id="fieldSQL" name="fieldSQL" class="rtabletext" cols="40" rows="3"><%= (currField!=null)?nvl(currField.getFieldSQL()):"" %></textarea>
- </td>
- <td align="center" valign="top"> <input type="Button" class=button att-button btn-type="primary" size="small" value="Verify SQL" onClick="if(document.getElementById('fieldSQL').value=='') {alert('Please provide SQL.'); return false; } showTestRunSQLPopup();"> </td>
- <td rowspan="2" width="60%"> </td></tr><tr>
- <td align="center" valign="middle"> <a href="javascript:showSQLInstructions()" class=rtabletext>Instructions</a> </td>
- </tr></table>
- </td>
- </tr>
- <tr>
- <td class=rbg2 align="right" height="30"></td>
- <td class=rbg3 align="left">
- <% curValue = nvl((currField!=null)?currField.getDependsOn():"", "N"); %>
- <font class=rtabletext><input id='dependsOn' type="checkbox" name="dependsOn" value="Y"<%= curValue.equals("Y") ? "checked":"" %>>
- <label title="<%=dependsOnHelp%>" style="cursor: pointer;" for="dependsOn">Depends on another Form Field.</label>
- </td>
- </tr>
-<% } else { %>
- <input type="hidden" id="fieldSQL" name="fieldSQL" value="<%= (currField!=null)?nvl(currField.getFieldSQL()):"" %>">
-<% } %>
-<% List predefinedValues = (currField!=null&&currField.getPredefinedValueList()!=null)?currField.getPredefinedValueList().getPredefinedValue():null; %>
- <tr>
- <td class=rbg2 align="right" height="30"><font class=rtabletext>Provide Predefined List of Values:</font></td>
- <td class=rbg3 align="left" nowrap><font class=rtabletext>
- <% if(predefinedValues==null||predefinedValues.size()==0) { %>
- Do not use Predefined list - Generate list from database
- <% } else {
- String value = (String) predefinedValues.get(0); %>
- <%= value %>
-
- <input type=image border="0" src="<%= AppUtils.getImgFolderURL() %>deleteicon.gif" alt="Remove" width="12" height="12" onClick="if(! dataValidate()) {return false;} else if(! confirm('Are you sure?')) {return false;} else {document.forma.<%= AppConstants.RI_WIZARD_ACTION %>.value='<%= AppConstants.WA_DELETE_USER %>'; document.forma.delPredefinedValue.value='<%= value %>'; }">
- <% } %>
- </font></td>
- </tr>
-<% if(predefinedValues!=null&&predefinedValues.size()>1)
- for(int i=1; i<predefinedValues.size(); i++) {
- String value = (String) predefinedValues.get(i); %>
- <tr>
- <td class=rbg2 align="right" height="30"><font class=rtabletext> </font></td>
- <td class=rbg3 align="left" nowrap><font class=rtabletext>
- <%= value %>
-
- <input type=image border="0" src="<%= AppUtils.getImgFolderURL() %>deleteicon.gif" alt="Remove" width="12" height="12" onClick="if(! dataValidate()) {return false;} else if(! confirm('Are you sure?')) {return false;} else {document.forma.<%= AppConstants.RI_WIZARD_ACTION %>.value='<%= AppConstants.WA_DELETE_USER %>'; document.forma.delPredefinedValue.value='<%= value %>'; }">
- </font></td>
- </tr>
-<% } // for
-%>
- <tr>
- <td class=rbg2 align="right" height="30"><font class=rtabletext> </font></td>
- <td class=rbg3 align="left" valign="middle" nowrap><font class=rtabletext>
- <input type="hidden" name="delPredefinedValue" value="">
- <input type="text" style="width: 200px;" size="20" maxlength="50" name="newPredefinedValue" value="">
- <input type="Submit" att-button btn-type="primary" size="small" class=button value="Add To List" onClick="if(document.forma.newPredefinedValue.value=='') {alert('Value cannot be empty.'); return false; } if(! stepDataValidate(false)) return false; <%= (predefinedValues==null||predefinedValues.size()==0)?"if(! confirm('If you create a list of predefined values, it will be displayed instead of the list selected from the database.\\nAre you sure you want to do that?')) return false; ":"" %>document.forma.<%= AppConstants.RI_WIZARD_ACTION %>.value='<%= AppConstants.WA_ADD_USER %>';">
- </font></td>
- </tr>
-</table>
-<br>
-
-<script language="JavaScript">
-<!--
-function stepDataValidate(checkCol) {
- if(document.getElementById('fieldName').value=="") {
- alert("Please enter Field Name");
- document.getElementById('fieldName').focus();
- document.getElementById('fieldName').select();
-
- return false;
- } // if
-
-<% if(rdef.getFormFieldList()!=null) { %>
- if(false
-<% for(Iterator iter=rdef.getFormFieldList().getFormField().iterator(); iter.hasNext(); ) {
- FormFieldType fft = (FormFieldType) iter.next();
-
- if(! (isEdit&&fft.getFieldId().equals(currField.getFieldId()))) { %>
- ||(document.getElementById('fieldName').value=="<%= fft.getFieldName() %>")
-<% }
- } %>
- ) {
- alert("Form field with name "+document.getElementById('fieldName').value+" already exists.\nPlease select another name.");
- document.getElementById('fieldName').focus();
- document.getElementById('fieldName').select();
-
- return false;
- }
-<% } %>
-
-<% if(predefinedValues==null||predefinedValues.size()==0) { %>
- if(checkCol)
- if(document.getElementById('fieldColId').selectedIndex==0)
- if(document.forma.fieldType.selectedIndex!=1&&document.forma.fieldType.selectedIndex!=2) {
- alert("Field Type can be only Text Box or Text Area if this field is not based on a column.\nPlease change the Field Type or select a column from the list.");
- document.forma.fieldType.focus();
-
- return false;
- } // if
-<% } %>
-
-<% if((Globals.getAllowSQLBasedReports()||AppUtils.isAdminUser(request)) && (rdef.getReportDefType().equals(AppConstants.RD_SQL_BASED))) { %>
- if(document.forma.fieldSQL.value!=""&&document.forma.fieldSQL.value!=document.forma.fieldSQLOrig.value) {
- alert("You must verify the SQL.");
- document.forma.fieldSQL.focus();
- document.forma.fieldSQL.select();
-
- return false;
- } // if
- if(document.forma.fieldDefaultSQL.value!=""&&document.forma.fieldDefaultSQL.value!=document.forma.fieldDefaultSQLOrig.value) {
- alert("You must verify the Default SQL.");
- document.forma.fieldDefaultSQL.focus();
- document.forma.fieldDefaultSQL.select();
-
- return false;
- } // if
- if(document.forma.fieldSQL.value.length<=0 && document.forma.fieldDefaultSQL.value.length > 1 ) {
- alert("SQL Field cannot be empty when Default sql has value.");
- return false;
- }
-<% } %>
-
-if(document.getElementById('multiSelectListSize') && document.getElementById('multiSelectListSize').options.selectedIndex == 0) {
- if(!checkNonNegativeInteger(document.forma.multiSelectListSize.options[document.forma.multiSelectListSize.options.selectedIndex].text)) {
- alert("Please enter number in Multi Select List Size. No Characters are allowed.");
- return false;
- } else {
- if(document.getElementById('multiSelectListSize').options[document.getElementById('multiSelectListSize').options.selectedIndex].text>20) {
- alert("Please not only 20 items are allowed in Multi-Select form field.");
- return false;
- }
- document.getElementById('multiSelectListSize').options[document.getElementById('multiSelectListSize').options.selectedIndex].value=document.getElementById('multiSelectListSize').options[document.getElementById('multiSelectListSize').options.selectedIndex].text;
- }
-}
-
- return true;
-} // dataValidate
-
-function dataValidate() {
- return stepDataValidate(true);
-} // dataValidate
-
-toggleFieldTypeSelection();
-//-->
-</script>
-
-<script type="text/javascript" src="<%= AppUtils.getBaseFolderURL() %>js/CalendarPopup.js"></script>
-<link rel="stylesheet" type="text/css" href="<%= AppUtils.getBaseFolderURL() %>css/calendar.css">
-<iframe id="calendarFrame" class="nav" z-index:199; scrolling="no" frameborder="0" width=165px height=165px src="" style="position:absolute; display:none;">
-</iframe>
-<div id="calendarDiv" name="calendarDiv" style="position:absolute; z-index:20000; visibility:hidden; background-color:white;layer-background-color:white;"></div>
-
- <SCRIPT LANGUAGE="JavaScript">
- var oCalendar = new CalendarPopup("calendarDiv", "calendarFrame");
- oCalendar.setCssPrefix("raptor");
- </SCRIPT>
-
-
-<%!
- private String nvl(String s) { return (s==null)?"":s; }
- private String nvl(String s, String sDefault) { return nvl(s).equals("")?sDefault:s; }
- private boolean isNumber(String value) { // As per Raptor def, like
-
- // -$3,270.56
- value = value.trim();
- if(value.length()>2) return false;
- for (int i = 0; i < value.length(); i++) {
- char c = value.charAt(i);
- if (!(Character.isDigit(c) || c == '.' || c == '-' || c == '+' || c == ','
- || c == '$' || c == '%'))
- return false;
- } // for
-
- return true;
- } // isNumber
-%>
Code Review / policy / engine.git / blobdiff