diff options
Diffstat (limited to 'ecomp-sdk/epsdk-app-overlay/src/main/webapp/WEB-INF/fusion/raptor/wizard_form_fields_edit.jsp')
| -rw-r--r-- | ecomp-sdk/epsdk-app-overlay/src/main/webapp/WEB-INF/fusion/raptor/wizard_form_fields_edit.jsp | 771 |
1 files changed, 0 insertions, 771 deletions
diff --git a/ecomp-sdk/epsdk-app-overlay/src/main/webapp/WEB-INF/fusion/raptor/wizard_form_fields_edit.jsp b/ecomp-sdk/epsdk-app-overlay/src/main/webapp/WEB-INF/fusion/raptor/wizard_form_fields_edit.jsp deleted file mode 100644 index 84c14510..00000000 --- a/ecomp-sdk/epsdk-app-overlay/src/main/webapp/WEB-INF/fusion/raptor/wizard_form_fields_edit.jsp +++ /dev/null @@ -1,771 +0,0 @@ -<%-- - ================================================================================ - 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> - -<%-- TODO : need a calendar popup functionality --%> -<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 -%> |