diff options
Diffstat (limited to 'vid/src/main/webapp/WEB-INF/fusion/raptor/wizard_form_fields_edit.jsp')
| -rw-r--r-- | vid/src/main/webapp/WEB-INF/fusion/raptor/wizard_form_fields_edit.jsp | 771 |
1 files changed, 771 insertions, 0 deletions
diff --git a/vid/src/main/webapp/WEB-INF/fusion/raptor/wizard_form_fields_edit.jsp b/vid/src/main/webapp/WEB-INF/fusion/raptor/wizard_form_fields_edit.jsp new file mode 100644 index 000000000..185f65c1f --- /dev/null +++ b/vid/src/main/webapp/WEB-INF/fusion/raptor/wizard_form_fields_edit.jsp @@ -0,0 +1,771 @@ +<%-- + ================================================================================ + 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 +%> |