gerrit.onap Code Review - portal/sdk.git/blob

   1 /*
   2  * ============LICENSE_START==========================================
   3  * ONAP Portal SDK
   4  * ===================================================================
   5  * Copyright © 2017 AT&T Intellectual Property. All rights reserved.
   6  * ===================================================================
   7  *
   8  * Unless otherwise specified, all software contained herein is licensed
   9  * under the Apache License, Version 2.0 (the "License");
  10  * you may not use this software except in compliance with the License.
  11  * You may obtain a copy of the License at
  12  *
  13  *             http://www.apache.org/licenses/LICENSE-2.0
  14  *
  15  * Unless required by applicable law or agreed to in writing, software
  16  * distributed under the License is distributed on an "AS IS" BASIS,
  17  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  18  * See the License for the specific language governing permissions and
  19  * limitations under the License.
  20  *
  21  * Unless otherwise specified, all documentation contained herein is licensed
  22  * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
  23  * you may not use this documentation except in compliance with the License.
  24  * You may obtain a copy of the License at
  25  *
  26  *             https://creativecommons.org/licenses/by/4.0/
  27  *
  28  * Unless required by applicable law or agreed to in writing, documentation
  29  * distributed under the License is distributed on an "AS IS" BASIS,
  30  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  31  * See the License for the specific language governing permissions and
  32  * limitations under the License.
  33  *
  34  * ============LICENSE_END============================================
  35  *
  36  * ECOMP is a trademark and service mark of AT&T Intellectual Property.
  37  */
  38 package org.onap.portalsdk.analytics.model.runtime;
  39
  40 import java.util.Calendar;
  41 import java.util.Collections;
  42 import java.util.Iterator;
  43 import java.util.List;
  44 import java.util.Vector;
  45
  46 import javax.servlet.http.HttpServletRequest;
  47
  48 import org.onap.portalsdk.analytics.error.RaptorException;
  49 import org.onap.portalsdk.analytics.model.DataCache;
  50 import org.onap.portalsdk.analytics.model.base.ReportWrapper;
  51 import org.onap.portalsdk.analytics.system.AppUtils;
  52 import org.onap.portalsdk.analytics.system.ConnectionUtils;
  53 import org.onap.portalsdk.analytics.system.Globals;
  54 import org.onap.portalsdk.analytics.util.AppConstants;
  55 import org.onap.portalsdk.analytics.util.DataSet;
  56 import org.onap.portalsdk.analytics.util.Utils;
  57 import org.onap.portalsdk.analytics.xmlobj.ColFilterType;
  58 import org.onap.portalsdk.analytics.xmlobj.DataColumnType;
  59 import org.onap.portalsdk.analytics.xmlobj.FormFieldType;
  60
  61 public class ReportFormFields extends Vector {
  62         private int nextElemIdx = 0;
  63
  64         public ReportFormFields(ReportWrapper rw, HttpServletRequest request) throws RaptorException {
  65                 super();
  66
  67                 if (rw.getFormFieldList() != null)
  68                         for (Iterator iter = rw.getFormFieldList().getFormField().iterator(); iter
  69                                         .hasNext();) {
  70                                 FormFieldType fft = (FormFieldType) iter.next();
  71
  72                                 String fieldName = fft.getFieldId();
  73                                 String fieldDisplayName = fft.getFieldName();
  74                                 String fieldType = fft.getFieldType();
  75                                 String validationType = fft.getValidationType();
  76                                 String mandatory = nvl(fft.getMandatory(), "N");
  77                                 String defaultValue = fft.getDefaultValue();
  78                                 String fieldSQL = fft.getFieldSQL();
  79                 String fieldDefaultSQL = fft.getFieldDefaultSQL();
  80                 String[] reqParameters = Globals.getRequestParams().split(",");
  81                 String[] sessionParameters = Globals.getSessionParams().split(",");
  82                 String[] scheduleSessionParameters = Globals.getSessionParamsForScheduling().split(",");
  83                 javax.servlet.http.HttpSession session = request.getSession();
  84                 String visible = nvl(fft.getVisible(),"Y");
  85                 String dependsOn = nvl(fft.getDependsOn(), "");
  86                 Calendar rangeStartDate = (fft.getRangeStartDate()==null)?null:fft.getRangeStartDate().toGregorianCalendar();
  87                 Calendar rangeEndDate = (fft.getRangeEndDate()==null)?null:fft.getRangeEndDate().toGregorianCalendar();
  88                                 //Calendar rangeEndDate = fft.getRangeEndDate().toGregorianCalendar();
  89                                 String rangeStartDateSQL = fft.getRangeStartDateSQL();
  90                                 String rangeEndDateSQL = fft.getRangeEndDateSQL();
  91                                 String user_id = AppUtils.getUserID(request);
  92                                 String multiSelectListSize = fft.getMultiSelectListSize();
  93
  94                                 //s_logger.debug("ranges are : " + fft.getRangeStartDate() + fft.getRangeEndDate());
  95                                 //s_logger.debug("fieldSQL B4" + fieldSQL);
  96                 if(fieldSQL!=null) {
  97                     for (int i = 0; i < reqParameters.length; i++) {
  98                         if(!reqParameters[i].startsWith("ff") && (request.getParameter(reqParameters[i].toUpperCase())!=null && request.getParameter(reqParameters[i].toUpperCase()).length() > 0))
  99                          fieldSQL = Utils.replaceInString(fieldSQL, "[" + reqParameters[i].toUpperCase()+"]", request.getParameter(reqParameters[i].toUpperCase()) );
 100                         else if (request.getParameter(reqParameters[i])!=null && request.getParameter(reqParameters[i]).length() > 0)
 101                          fieldSQL = Utils.replaceInString(fieldSQL, "[" + reqParameters[i].toUpperCase()+"]", request.getParameter(reqParameters[i]) );
 102                     }
 103
 104                         for (int i = 0; i < scheduleSessionParameters.length; i++) {
 105                                 //s_logger.debug(" Session " + " scheduleSessionParameters[i] " + scheduleSessionParameters[i].toUpperCase() + " " + request.getParameter(scheduleSessionParameters[i]));
 106                                 if(request.getParameter(scheduleSessionParameters[i])!=null && request.getParameter(scheduleSessionParameters[i]).trim().length()>0 )
 107                                         fieldSQL = Utils.replaceInString(fieldSQL, "[" + scheduleSessionParameters[i].toUpperCase()+"]", request.getParameter(scheduleSessionParameters[i]) );
 108                                 if(request.getAttribute(scheduleSessionParameters[i])!=null && ((String)request.getAttribute(scheduleSessionParameters[i])).trim().length()>0 )
 109                                         fieldSQL = Utils.replaceInString(fieldSQL, "[" + scheduleSessionParameters[i].toUpperCase()+"]", (String) request.getAttribute(scheduleSessionParameters[i]) );
 110
 111                         }
 112
 113                     for (int i = 0; i < sessionParameters.length; i++) {
 114                         //if(!sessionParameters[i].startsWith("ff"))
 115                          //fieldSQL = Utils.replaceInString(fieldSQL, "[" + sessionParameters[i].toUpperCase()+"]", (String)session.getAttribute(sessionParameters[i].toUpperCase()) );
 116                         //else {
 117                         if (session.getAttribute(sessionParameters[i])!=null && ((String)session.getAttribute(sessionParameters[i])).length() > 0) {
 118                          //s_logger.debug(" Session " + " sessionParameters[i] " + sessionParameters[i] + " " + (String)session.getAttribute(sessionParameters[i]));
 119                          fieldSQL = Utils.replaceInString(fieldSQL, "[" + sessionParameters[i].toUpperCase()+"]", (String)session.getAttribute(sessionParameters[i]) );
 120                         }
 121                        // }
 122                     }
 123                     fieldSQL = Utils.replaceInString(fieldSQL, "[USERID]", user_id);
 124                     fieldSQL = Utils.replaceInString(fieldSQL, "[USER_ID]", user_id);
 125                     fieldSQL = Utils.replaceInString(fieldSQL, "[LOGGED_USERID]", user_id);
 126
 127                 }
 128
 129                 if(fieldDefaultSQL!=null) {
 130                     for (int i = 0; i < reqParameters.length; i++) {
 131                         if(!reqParameters[i].startsWith("ff") && (request.getParameter(reqParameters[i].toUpperCase())!=null && request.getParameter(reqParameters[i].toUpperCase()).length() > 0))
 132                          fieldDefaultSQL = Utils.replaceInString(fieldDefaultSQL, "[" + reqParameters[i].toUpperCase()+"]", request.getParameter(reqParameters[i].toUpperCase()) );
 133                         else if (request.getParameter(reqParameters[i])!=null && request.getParameter(reqParameters[i]).length() > 0)
 134                          fieldDefaultSQL = Utils.replaceInString(fieldDefaultSQL, "[" + reqParameters[i].toUpperCase()+"]", request.getParameter(reqParameters[i]) );
 135                     }
 136                         for (int i = 0; i < scheduleSessionParameters.length; i++) {
 137                                 //s_logger.debug(" Session " + " scheduleSessionParameters[i] " + scheduleSessionParameters[i].toUpperCase() + " " + request.getParameter(scheduleSessionParameters[i]));
 138                                 if(request.getParameter(scheduleSessionParameters[i])!=null && request.getParameter(scheduleSessionParameters[i]).trim().length()>0 )
 139                                         fieldDefaultSQL = Utils.replaceInString(fieldDefaultSQL, "[" + scheduleSessionParameters[i].toUpperCase()+"]", request.getParameter(scheduleSessionParameters[i]) );
 140                                 if(request.getAttribute(scheduleSessionParameters[i])!=null && ((String)request.getAttribute(scheduleSessionParameters[i])).trim().length()>0 )
 141                                         fieldDefaultSQL = Utils.replaceInString(fieldDefaultSQL, "[" + scheduleSessionParameters[i].toUpperCase()+"]", (String) request.getAttribute(scheduleSessionParameters[i]) );
 142
 143                         }
 144
 145                     for (int i = 0; i < sessionParameters.length; i++) {
 146                         //if(!sessionParameters[i].startsWith("ff"))
 147                                 //fieldDefaultSQL = Utils.replaceInString(fieldDefaultSQL, "[" + sessionParameters[i].toUpperCase()+"]", (String)session.getAttribute(sessionParameters[i].toUpperCase()) );
 148                         //else
 149                         if (session.getAttribute(sessionParameters[i])!=null && ((String)session.getAttribute(sessionParameters[i])).length() > 0)
 150                                 fieldDefaultSQL = Utils.replaceInString(fieldDefaultSQL, "[" + sessionParameters[i].toUpperCase()+"]", (String)session.getAttribute(sessionParameters[i]) );
 151                     }
 152
 153                     fieldDefaultSQL = Utils.replaceInString(fieldDefaultSQL, "[USERID]", user_id);
 154                     fieldDefaultSQL = Utils.replaceInString(fieldDefaultSQL, "[USER_ID]", user_id);
 155                     fieldDefaultSQL = Utils.replaceInString(fieldDefaultSQL, "[LOGGED_USERID]", user_id);
 156                 }
 157                                 //s_logger.debug("fieldSQL After" + fieldSQL);
 158                                 if(rangeStartDateSQL!=null) {
 159                     for (int i = 0; i < reqParameters.length; i++) {
 160                         if(!reqParameters[i].startsWith("ff") && (request.getParameter(reqParameters[i].toUpperCase())!=null && request.getParameter(reqParameters[i].toUpperCase()).length() > 0))
 161                                 rangeStartDateSQL = Utils.replaceInString(rangeStartDateSQL, "[" + reqParameters[i].toUpperCase()+"]", request.getParameter(reqParameters[i].toUpperCase()) );
 162                         else if (request.getParameter(reqParameters[i])!=null && request.getParameter(reqParameters[i]).length() > 0)
 163                                 rangeStartDateSQL = Utils.replaceInString(rangeStartDateSQL, "[" + reqParameters[i].toUpperCase()+"]", request.getParameter(reqParameters[i]) );
 164                     }
 165                     for (int i = 0; i < sessionParameters.length; i++) {
 166                         if (session.getAttribute(sessionParameters[i])!=null && ((String)session.getAttribute(sessionParameters[i])).length() > 0)
 167                         rangeStartDateSQL = Utils.replaceInString(rangeStartDateSQL, "[" + sessionParameters[i].toUpperCase()+"]", (String)session.getAttribute(sessionParameters[i]) );
 168                     }
 169                 }
 170                                 if(rangeEndDateSQL!=null) {
 171                     for (int i = 0; i < reqParameters.length; i++) {
 172                         if(!reqParameters[i].startsWith("ff")&& (request.getParameter(reqParameters[i].toUpperCase())!=null && request.getParameter(reqParameters[i].toUpperCase()).length() > 0))
 173                                 rangeEndDateSQL = Utils.replaceInString(rangeEndDateSQL, "[" + reqParameters[i].toUpperCase()+"]", request.getParameter(reqParameters[i].toUpperCase()) );
 174                         else if (request.getParameter(reqParameters[i])!=null && request.getParameter(reqParameters[i]).length() > 0)
 175                                 rangeEndDateSQL = Utils.replaceInString(rangeEndDateSQL, "[" + reqParameters[i].toUpperCase()+"]", request.getParameter(reqParameters[i]) );
 176                     }
 177                     for (int i = 0; i < sessionParameters.length; i++) {
 178                         if (session.getAttribute(sessionParameters[i])!=null && ((String)session.getAttribute(sessionParameters[i])).length() > 0)
 179                         rangeEndDateSQL = Utils.replaceInString(rangeEndDateSQL, "[" + sessionParameters[i].toUpperCase()+"]", (String)session.getAttribute(sessionParameters[i]) );
 180                     }
 181                 }
 182                                 String helpText = fft.getComment();
 183
 184                                 List predefinedValues = null;
 185                                 if (fft.getPredefinedValueList() != null) {
 186                                         predefinedValues = fft.getPredefinedValueList().getPredefinedValue();
 187                                         if (predefinedValues.size() == 0)
 188                                                 predefinedValues = null;
 189                                 } // if
 190
 191                                 DataColumnType dct = rw.getColumnById(nvl(fft.getColId()));
 192
 193                                 boolean basedOnColumn = false;
 194                                 if (rw.getReportDefType().equals(AppConstants.RD_SQL_BASED))
 195                                         basedOnColumn = (nvl(fft.getColId()).indexOf('.') > 0);
 196                                 else
 197                                         basedOnColumn = (dct != null);
 198
 199                                 if (((!basedOnColumn) && (nvl(fieldSQL).length() == 0))
 200                                                 || predefinedValues != null) {
 201                                         if (predefinedValues != null)
 202                                                 if (nvl(defaultValue).equals(AppConstants.FILTER_MAX_VALUE))
 203                                                         defaultValue = (String) Collections.max(predefinedValues);
 204                                                 else if (nvl(defaultValue).equals(AppConstants.FILTER_MIN_VALUE))
 205                                                         defaultValue = (String) Collections.min(predefinedValues);
 206                                         add(new FormField(fieldName, fieldDisplayName, fieldType, validationType,
 207                                                         mandatory.equals("Y"), defaultValue, helpText, predefinedValues,visible.equals("Y"), dependsOn, rangeStartDate, rangeEndDate, rangeStartDateSQL, rangeEndDateSQL, multiSelectListSize));
 208                                 } else if (nvl(fieldSQL).length() > 0) {
 209                                         add(new FormField(fieldName, fieldDisplayName, fieldType, validationType,
 210                                                         mandatory.equals("Y"), fieldDefaultSQL, helpText, fieldSQL,visible.equals("Y"), dependsOn, rangeStartDate, rangeEndDate, rangeStartDateSQL, rangeEndDateSQL, multiSelectListSize));
 211                                 } else {
 212                                         String lTableName = null;
 213                                         String lColumnName = null;
 214                                         String lColumnType = null;
 215                                         String lColFormat = null;
 216                                         if (rw.getReportDefType().equals(AppConstants.RD_SQL_BASED)) {
 217                                                 String colId = nvl(fft.getColId());
 218                                                 lTableName = ReportWrapper.getSQLBasedFFTColTableName(colId); // colId.substring(0,
 219                                                                                                                                                                                 // colId.indexOf('.'));
 220                                                 lColumnName = ReportWrapper.getSQLBasedFFTColColumnName(colId); // colId.substring(colId.lastIndexOf('.')+1);
 221                                                 lColumnType = AppConstants.CT_CHAR;
 222                                                 try {
 223                                                         lColumnType = nvl(DataCache.getReportTableDbColumnType(lTableName,
 224                                                                         lColumnName, rw.getDBInfo()), AppConstants.CT_CHAR);
 225                                                 } catch (Exception e) {
 226                                                 }
 227                                                 lColFormat = lColumnType.equals(AppConstants.CT_DATE) ? nvl(
 228                                                                 ReportWrapper.getSQLBasedFFTColDisplayFormat(colId),
 229                                                                 AppConstants.DEFAULT_DATE_FORMAT) : "";
 230                                         } else {
 231                                                 lTableName = rw.getColumnTableById(dct.getColId()).getTableName(); // should
 232                                                                                                                                                                                         // be
 233                                                                                                                                                                                         // same
 234                                                                                                                                                                                         // as
 235                                                                                                                                                                                         // rw.getTableById(dct.getTableId()).getTableName()
 236                                                 lColumnName = dct.getColName();
 237                                                 lColumnType = dct.getColType();
 238                                                 lColFormat = nvl(dct.getColFormat(), AppConstants.DEFAULT_DATE_FORMAT);
 239                                         } // else
 240
 241                                         if (nvl(defaultValue).equals(AppConstants.FILTER_MAX_VALUE)
 242                                                         || nvl(defaultValue).equals(AppConstants.FILTER_MIN_VALUE))
 243                                                 try {
 244                                                         String selectVal = (defaultValue
 245                                                                         .equals(AppConstants.FILTER_MAX_VALUE) ? "MAX" : "MIN")
 246                                                                         + "(" + lColumnName + ")";
 247                                                         if (lColumnType.equals(AppConstants.CT_DATE))
 248                                                                 selectVal = "TO_CHAR(" + selectVal + ", '"
 249                                                                                 + AppConstants.DEFAULT_DATE_FORMAT + "')";
 250                                                         // DataSet ds = DbUtils.executeQuery("SELECT
 251                                                         // "+selectVal+" FROM "+lTableName);
 252                                                         DataSet ds = ConnectionUtils.getDataSet("SELECT " + selectVal
 253                                                                         + " FROM " + lTableName, rw.getDBInfo());
 254                                                         if (ds.getRowCount() > 0)
 255                                                                 defaultValue = ds.getString(0, 0);
 256                                                 } catch (Exception e) {
 257                                                 }
 258
 259                                         LookupDBInfo lookupDBInfo = DataCache.getLookupTable(lTableName,
 260                                                         lColumnName);
 261                                         String lookupTable = lookupDBInfo.getLookupTable();
 262                                         String lookupIdField = lookupDBInfo.getLookupIdField();
 263                                         String lookupNameField = lookupDBInfo.getLookupNameField();
 264                                         String lookupSortByField = lookupDBInfo.getLookupNameField();
 265                                         if (lColumnType.equals(AppConstants.CT_DATE)) {
 266                                                 // Expects lookup on DATE fields will have both Id and
 267                                                 // Name fields with DATE format; if not the case will
 268                                                 // generate an error
 269                                                 lookupIdField = "TO_CHAR(" + lookupIdField + ", '"
 270                                                                 + AppConstants.DEFAULT_DATE_FORMAT + "')";
 271                                                 lookupSortByField = " TO_DATE(TO_CHAR("+ lookupNameField +", '" + AppConstants.DEFAULT_DATE_FORMAT+ "'),'" + AppConstants.DEFAULT_DATE_FORMAT+ "') ";
 272                                                 lookupNameField = "TO_CHAR(" + lookupNameField + ", '" + lColFormat
 273                                                                 + "')";
 274                                                 lookupSortByField += " DESC";
 275                                         } // if
 276                     if (fieldDefaultSQL!=null && fieldDefaultSQL.length()>0 && (fieldDefaultSQL.trim().length()>10) && fieldDefaultSQL.substring(0,10).toLowerCase().startsWith("select")) {
 277                      add(new FormField(fieldName, fieldDisplayName, fieldType, validationType,
 278                             mandatory.equals("Y"), fieldDefaultSQL, helpText, lookupTable,
 279                             lookupIdField, lookupNameField, lookupSortByField,visible.equals("Y"),dependsOn, rangeStartDate, rangeEndDate, rangeStartDateSQL, rangeEndDateSQL, multiSelectListSize));
 280
 281                     } else {
 282                                          add(new FormField(fieldName, fieldDisplayName, fieldType, validationType,
 283                                                         mandatory.equals("Y"), defaultValue, helpText, lookupTable,
 284                                                         lookupIdField, lookupNameField, lookupSortByField,visible.equals("Y"), dependsOn, rangeStartDate, rangeEndDate, rangeStartDateSQL, rangeEndDateSQL, multiSelectListSize));
 285                     }
 286                                 } // else
 287                         } // for
 288
 289                 List reportCols = rw.getAllColumns();
 290                 for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
 291                         DataColumnType dct = (DataColumnType) iter.next();
 292
 293                         if (dct.getColFilterList() != null) {
 294                                 int fNo = 0;
 295                                 List fList = dct.getColFilterList().getColFilter();
 296                                 for (Iterator iterF = fList.iterator(); iterF.hasNext(); fNo++) {
 297                                         ColFilterType cft = (ColFilterType) iterF.next();
 298
 299                                         if (nvl(cft.getArgType()).equals(AppConstants.AT_FORM)
 300                                                         && rw.getFormFieldByDisplayValue(cft.getArgValue()) == null) {
 301                                                 String fieldName = rw.getFormFieldName(cft);
 302                                                 String fieldDisplayName = rw.getFormFieldDisplayName(dct, cft);
 303
 304                                                 LookupDBInfo lookupDBInfo = DataCache.getLookupTable(rw
 305                                                                 .getColumnTableById(dct.getColId()).getTableName(), dct
 306                                                                 .getColName());
 307                                                 String lookupTable = lookupDBInfo.getLookupTable();
 308                                                 String lookupIdField = lookupDBInfo.getLookupIdField();
 309                                                 String lookupNameField = lookupDBInfo.getLookupNameField();
 310                                                 String lookupSortByField = lookupDBInfo.getLookupNameField();
 311                                                 Calendar lookupRangeStartDate = rw.getFormFieldRangeStart(cft);
 312                                                 Calendar lookupRangeEndDate = rw.getFormFieldRangeEnd(cft);
 313                                                 String lookupRangeStartDateSQL = rw.getFormFieldRangeStartSQL(cft);
 314                                                 String lookupRangeEndDateSQL = rw.getFormFieldRangeEndSQL(cft);
 315                                                 if (dct.getColType().equals(AppConstants.CT_DATE)) {
 316                                                         // Expects lookup on DATE fields will have both Id
 317                                                         // and Name fields with DATE format; if not the case
 318                                                         // will generate an error
 319                                                         lookupIdField = "TO_CHAR("
 320                                                                         + lookupIdField
 321                                                                         + ", '"
 322                                                                         + nvl(dct.getColFormat(), AppConstants.DEFAULT_DATE_FORMAT)
 323                                                                         + "')";
 324                                                         lookupNameField = "TO_CHAR("
 325                                                                         + lookupNameField
 326                                                                         + ", '"
 327                                                                         + nvl(dct.getColFormat(), AppConstants.DEFAULT_DATE_FORMAT)
 328                                                                         + "')";
 329                                                         lookupSortByField += " DESC";
 330                                                 } // if
 331                                                 add(new FormField(fieldName, fieldDisplayName,
 332                                                                 FormField.FFT_TEXT_W_POPUP, null, false, null, null,
 333                                                                 lookupTable, lookupIdField, lookupNameField, lookupSortByField,null, lookupRangeStartDate, lookupRangeEndDate, lookupRangeStartDateSQL, lookupRangeEndDateSQL, "0"));
 334                                         } // if
 335                                 } // for
 336                         } // if
 337                 } // for
 338         } // ReportFormFields
 339
 340         public int getFieldCount() {
 341                 return size();
 342         } // getFieldCount
 343
 344         public FormField getFormField(int fieldIdx) {
 345                 return (FormField) get(fieldIdx);
 346         } // getFormField
 347
 348         public FormField getFormField(String fieldName) {
 349                 for (int i = 0; i < getFieldCount(); i++) {
 350                         FormField ff = (FormField) get(i);
 351                         if (ff.getFieldName().equals(fieldName))
 352                                 return ff;
 353                 } // for
 354
 355                 return null;
 356         } // getFormField
 357
 358         public void resetNext() {
 359                 resetNext(0);
 360         } // resetNext
 361
 362         public void resetNext(int toPos) {
 363                 nextElemIdx = toPos;
 364         } // resetNext
 365
 366         public boolean hasNext() {
 367                 return (nextElemIdx < size());
 368         } // hasNext
 369
 370         public FormField getNext() {
 371                 return hasNext() ? getFormField(nextElemIdx++) : null;
 372         } // getNext
 373
 374         /** ************************************************************************************************* */
 375
 376         private String nvl(String s) {
 377                 return (s == null) ? "" : s;
 378         }
 379
 380         private String nvl(String s, String sDefault) {
 381                 return nvl(s).equals("") ? sDefault : s;
 382         }
 383
 384 } // ReportFormFields