Пример #1
0
  private final int getColumnIndex(final String columnName) {
    final int elementId = getAD_Element_ID(columnName);

    for (int i = 0; i < displayedInfoColumns.size(); i++) {
      final I_AD_InfoColumn ic = displayedInfoColumns.get(i);
      if (elementId == ic.getAD_Element_ID()) {
        return i;
      }
    }
    return -1;
  }
Пример #2
0
 private static int getIndexByColumnName(
     final List<I_AD_InfoColumn> infoColumns, final String columnName) {
   for (int i = 0; i < infoColumns.size(); i++) {
     final I_AD_InfoColumn ic = infoColumns.get(i);
     final String icColumnName = ic.getColumnName();
     if (columnName.equals(icColumnName)) {
       return i;
     }
   }
   return -1;
 }
Пример #3
0
 public final IInfoQueryCriteria getParameterByColumnNameOrNull(final String columnName) {
   Check.assumeNotEmpty(columnName, "columnName not null");
   for (final IInfoQueryCriteria param : displayedParameters) {
     final I_AD_InfoColumn infoColumn = param.getAD_InfoColumn();
     final String infoColumnName = infoColumn.getColumnName();
     if (columnName.equals(infoColumnName)) {
       return param;
     }
   }
   return null;
 }
Пример #4
0
        private void windowOpened0(final IInfoQueryCriteria parameter) {
          final I_AD_InfoColumn infoColumn = parameter.getAD_InfoColumn();
          if (infoColumn == null) {
            return; // shall not happen...
          }

          final String defaultValue = infoColumn.getDefaultValue();

          // search for first not null component
          for (int i = 0; i < parameter.getParameterCount(); i++) {
            final Component editor = getEditorComponentOrNull(parameter, i);
            if (editor == null) {
              continue;
            }

            // add general listeners on parameter components
            editor.addKeyListener(
                new KeyAdapter() {
                  @Override
                  public void keyReleased(final KeyEvent e) {
                    if (KeyEvent.VK_ENTER == e.getKeyCode()) {
                      // each field shall execute query on enter
                      executeQuery();
                    }
                  }
                });

            // we are focusing on field which as "SearchText" as default value
            if (defaultValue == null || defaultValue.indexOf(ATTR_SearchText) < 0) {
              return;
            }

            editor.requestFocus();

            final String text = parameter.getText();
            if (!Check.isEmpty(text, true)) {
              executeQueryOnInit();
            }
          }
        }
Пример #5
0
  private IInfoQueryCriteria getInfoQueryCriteria(
      final I_AD_InfoColumn infoColumn, final boolean getDefaultIfNotFound) {
    final int infoColumnId = infoColumn.getAD_InfoColumn_ID();
    if (criteriasById.containsKey(infoColumnId)) {
      return criteriasById.get(infoColumnId);
    }

    final IInfoQueryCriteria criteria;
    final String classname = infoColumn.getClassname();
    if (Check.isEmpty(classname, true)) {
      if (getDefaultIfNotFound) {
        criteria = new InfoQueryCriteriaGeneral();
      } else {
        return null;
      }
    } else {
      criteria = Util.getInstance(IInfoQueryCriteria.class, classname);
    }

    criteria.init(this, infoColumn, searchText);
    criteriasById.put(infoColumnId, criteria);

    return criteria;
  }
Пример #6
0
  private Info_Column createColumnInfo(final I_AD_InfoColumn field) {
    final Properties ctx = getCtx();

    String columnName = field.getAD_Element().getColumnName();
    String name = msgBL.translate(ctx, columnName);
    final int displayType = field.getAD_Reference_ID();
    Class<?> colClass = DisplayType.getClass(displayType, true);
    String colSQL =
        Check.isEmpty(field.getDisplayField(), true)
            ? field.getSelectClause()
            : field.getDisplayField();
    String idColSQL = null;

    if (DisplayType.isLookup(field.getAD_Reference_ID())) {
      colClass = KeyNamePair.class;
      idColSQL = field.getSelectClause();
      final String displayColumnSQL =
          MLookupFactory.getLookupEmbed(
              ctx,
              colSQL, // BaseColumn
              null, // BaseTable
              field.getAD_Reference_ID(),
              field.getAD_Reference_Value_ID());
      if (!Check.isEmpty(displayColumnSQL, true)) {
        colSQL = "(" + displayColumnSQL + ")";
      }
    }
    if (DisplayType.List == field.getAD_Reference_ID()) {
      columnName = field.getName();
    }
    if (columnName.endsWith("_ID")
        && DisplayType.ID == field.getAD_Reference_ID()) // should be only ID, 02883
    {
      name = " ";
      colClass = IDColumn.class;
    }

    final Info_Column ic = new Info_Column(name, columnName, colClass);
    ic.setDisplayType(displayType);
    ic.setIDcolSQL(idColSQL);
    ic.setColSQL(colSQL);
    ic.setColumnName(columnName);

    //
    // Check/Load Column Controller
    final IInfoColumnController columnController = getInfoColumnControllerOrNull(field);
    if (columnController != null) {
      ic.setColumnController(columnController);
      columnController.customize(this, ic);
    }

    return ic;
  }
Пример #7
0
  private void initInfo() {
    displayedInfoColumns = adInfoWindowDAO.retrieveDisplayedColumns(infoWindow);

    final Info_Column[] layout = new Info_Column[displayedInfoColumns.size()];

    //
    // Setup Layout
    int keyColumnIndex = -1;
    for (int i = 0; i < displayedInfoColumns.size(); i++) {
      final I_AD_InfoColumn field = displayedInfoColumns.get(i);
      layout[i] = createColumnInfo(field);
      if (layout[i].getColClass() == IDColumn.class && !field.isTree()) {
        keyColumnIndex = i;
      }
    }

    // No KeyColumnIndex found. Pick the first ID column
    if (keyColumnIndex < 0) {
      int count = 0;
      for (final Info_Column infoColumn : layout) {
        if (infoColumn.isIDcol()) {
          keyColumnIndex = count;
          break;
        } else {
          count++;
        }
      }
    }

    //
    // Setup dependent columns
    // NOTE: we need to do this after we initialized the layout
    for (int i = 0; i < displayedInfoColumns.size(); i++) {
      final Info_Column infoColumn = layout[i];
      final IInfoColumnController columnController = infoColumn.getColumnController();
      if (columnController == null) {
        continue;
      }
      final List<String> dependsOnColumnNames = columnController.getDependsOnColumnNames();
      if (dependsOnColumnNames == null || dependsOnColumnNames.isEmpty()) {
        continue;
      }

      for (final String dependsOnColumnName : dependsOnColumnNames) {
        final int dependsOnColumnIndex =
            getIndexByColumnName(displayedInfoColumns, dependsOnColumnName);
        if (dependsOnColumnIndex < 0) {
          log.log(
              Level.WARNING,
              "Cannot find column name '"
                  + dependsOnColumnName
                  + "' required as dependency for "
                  + columnController);
          continue;
        }

        final List<Info_Column> dependentColumns =
            layout[dependsOnColumnIndex].getDependentColumns();
        if (!dependentColumns.contains(infoColumn)) {
          dependentColumns.add(infoColumn);
        }
      }
    }

    // Create Grid
    final StringBuffer where = new StringBuffer();
    where.append(infoWindow.getOtherClause());
    if (!Check.isEmpty(p_whereClause, true)) {
      if (!Check.isEmpty(where.toString())) {
        where.append(" AND ");
      }
      where.append("(").append(p_whereClause).append(")");
    }

    //
    final String sqlFromClause = adInfoWindowBL.getSqlFrom(infoWindow);
    prepareTable(layout, sqlFromClause, where.toString(), infoWindow.getOrderByClause());
    setKeyColumnIndex(keyColumnIndex);
    setShowTotals(adInfoWindowBL.isShowTotals(infoWindow));

    initAddonPanel();

    //
    // Notify controllers that Info window was initialized
    for (final Info_Column infoColumn : p_layout) {
      final IInfoColumnController controller = infoColumn.getColumnController();
      if (controller == null) {
        continue;
      }

      controller.afterInfoWindowInit(this);
    }
  } // initInfo
Пример #8
0
  private void initParameters() {
    final List<I_AD_InfoColumn> paramInfoColumns = adInfoWindowDAO.retrieveQueryColumns(infoWindow);
    for (final I_AD_InfoColumn col : paramInfoColumns) {
      if (!Check.isEmpty(col.getParameterDisplayLogic(), true)) {
        final ILogicExpression expression =
            expressionFactory.compileOrDefault(
                col.getParameterDisplayLogic(), ILogicExpression.FALSE, ILogicExpression.class);

        // don't fail on missing parameter because we want to be compatible with old
        // org.compiere.util.Evaluator.evaluateLogic(Evaluatee, String) method
        final boolean ignoreUnparsable = true;
        if (!expression.evaluate(ctx, ignoreUnparsable)) {
          // this parameter will never-ever be displayed
          continue;
        }
      }

      if (col.isParameterNextLine() && !criteriasBySelectClause.isEmpty()) {
        addComponentToParameters(null, true);
      }
      //
      final String selectSql = col.getSelectClause();

      final IInfoQueryCriteria criteria =
          getInfoQueryCriteria(col, true); // retrieve default if not found
      // Add criteria to map
      {
        String name = selectSql;
        final int i = 1;
        while (criteriasBySelectClause.containsKey(name)) {
          name = selectSql + "#" + i;
        }
        criteriasBySelectClause.put(name, criteria);
      }

      //
      // Add criteria to Displayed Parameters
      displayedParameters.add(criteria);

      //
      // Iterate criterias and add editor fields to Parameters panel
      for (int i = 0; i < criteria.getParameterCount(); i++) {
        final Component editor = (Component) criteria.getParameterComponent(i);
        if (editor instanceof VLookup) {
          final VLookup lookup = (VLookup) editor;
          lookup.enableLookupAutocomplete();
        }

        //
        // Label
        final String labelText = criteria.getLabel(i);
        if (!Check.isEmpty(labelText)) {
          addComponentToParameters(labelText, false);
        }

        //
        // Parameter
        addComponentToParameters(editor, false);

        //
        // Parameter To
        final Component editor2 = (Component) criteria.getParameterToComponent(i);
        if (col.isRange() && editor2 != null) {
          addComponentToParameters(" - ", false);
          addComponentToParameters(editor2, false);
        }
      }
    }
  }