Examples of org.jallinone.sqltool.java.ColumnVO

org.jallinone.sqltool.java.ColumnVO

Title: JAllInOne ERP/CRM application

Description: Value object used to define a table column info.

Copyright: Copyright (C) 2006 Mauro Carniel

This file is part of JAllInOne ERP/CRM application. This application is free software; you can redistribute it and/or modify it under the terms of the (LGPL) Lesser General Public License as published by the Free Software Foundation; GNU LESSER GENERAL PUBLIC LICENSE Version 2.1, February 1999 This application is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Library General Public License for more details. You should have received a copy of the GNU Library General Public License along with this library; if not, write to the Free Software Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA. The author may be contacted at: maurocarniel@tin.it
@author Mauro Carniel @version 1.0

          JOptionPane.WARNING_MESSAGE
        );
        return;
      }
      tableVO = (TableVO)((VOResponse)res).getVo();
      ColumnVO colVO = null;
      CustomColumnVO customColVO = null;
      boolean found;
      Hashtable whereParamColNames = new Hashtable(); // collection of <columnname,index in where> related to where params...
      boolean paramsRequired = false; // flag used to disable auto data loading...
      ArrayList paramsDefined = new ArrayList(); // input controls defined in filter panel; used to auto set filter panel height into the split pane...
      int count = 0;
      for(int i=0;i<customCols.size();i++) {
        customColVO = (CustomColumnVO)customCols.get(i);


        found = false;
        for(int j=0;j<tableVO.getColumns().size();j++) {
          colVO = (ColumnVO)tableVO.getColumns().get(j);
          if (customColVO.getColumnNameSYS22().equals(colVO.getColumnName())) {
            found = true;
            break;
          }
        }


        if (!found && customColVO.getColumnTypeSYS22().equals(ApplicationConsts.TYPE_WHERE)) {
          // parameter in where clause...
          colVO = new ColumnVO(tableVO);
          colVO.setColumnName(customColVO.getColumnNameSYS22());
          colVO.setAttributeName(customColVO.getColumnNameSYS22());
          colVO.setColumnHeaderName(customColVO.getColumnNameSYS22());
          colVO.setColumnType(ApplicationConsts.TYPE_TEXT);
          colVO.setColumnSize(new BigDecimal(255));
          whereParamColNames.put(colVO.getAttributeName(),new Integer(count));
          whereParamsFilled.put(new Integer(count),new Boolean(false));
          count++;
          found = true;
        }


        if (!found)
          continue;


        if (customColVO.isIsParamRequiredSYS22())
          paramsRequired = true;
        if (customColVO.isIsParamSYS22()) {
          if (paramsDefined.size()==0) {
            // add filter panel title...
            TitledBorder titledBorder1 = new TitledBorder(ClientSettings.getInstance().getResources().getResource("filter conditions"));
            titledBorder1.setTitleColor(Color.blue);
            filterPanel.setBorder(titledBorder1);
          }


          // define label + input control for filter panel...
          LabelControl label = new LabelControl();
          label.setText(colVO.getColumnHeaderName());
          InputControl inputControl = null;
          if (customColVO.getColumnTypeSYS22().equals(ApplicationConsts.TYPE_TEXT) ||
              customColVO.getColumnTypeSYS22().equals(ApplicationConsts.TYPE_WHERE)) {
            inputControl = new TextControl();
            inputControl.setAttributeName(colVO.getAttributeName());
            if (colVO.getColumnSize().intValue()>10)
              ((TextControl)inputControl).setColumns(Math.min(30,colVO.getColumnSize().intValue()));
            ((TextControl)inputControl).setRequired(customColVO.isIsParamRequiredSYS22());
            ((TextControl)inputControl).setValue(customColVO.getDefaultValueTextSYS22());
            ((TextControl)inputControl).setMaxCharacters(colVO.getColumnSize().intValue());
          }
          else if (customColVO.getColumnTypeSYS22().equals(ApplicationConsts.TYPE_NUM)) {
            inputControl = new NumericControl();
            inputControl.setAttributeName(colVO.getAttributeName());
            if (colVO.getColumnSize().intValue()>10)
              ((NumericControl)inputControl).setColumns(Math.min(30,colVO.getColumnSize().intValue()));
            ((NumericControl)inputControl).setRequired(customColVO.isIsParamRequiredSYS22());
            ((NumericControl)inputControl).setValue(customColVO.getDefaultValueNumSYS22());
            ((NumericControl)inputControl).setMaxValue(Math.pow(10d,colVO.getColumnSize().doubleValue()));
            if (colVO.getColumnDec()!=null)
              ((NumericControl)inputControl).setDecimals(colVO.getColumnDec().intValue());
          }
          else if (customColVO.getColumnTypeSYS22().equals(ApplicationConsts.TYPE_DATE)) {
            inputControl = new DateControl();
            inputControl.setAttributeName(colVO.getAttributeName());
            ((DateControl)inputControl).setRequired(customColVO.isIsParamRequiredSYS22());
            ((DateControl)inputControl).setValue(customColVO.getDefaultValueNumSYS22());
            if (customColVO.getDefaultValueDateSYS22()!=null &&
                customColVO.getDefaultValueDateSYS22().equals(Boolean.TRUE))
              ((DateControl)inputControl).setValue(new java.sql.Date(System.currentTimeMillis()));
          }
          else if (customColVO.getColumnTypeSYS22().equals(ApplicationConsts.TYPE_ENUM) &&
                   customColVO.getConstraintValuesSYS22()!=null &&
                   customColVO.getConstraintValuesSYS22().length()>0) {
            inputControl = new ComboBoxControl();
            inputControl.setAttributeName(colVO.getAttributeName());
            ((ComboBoxControl)inputControl).setRequired(customColVO.isIsParamRequiredSYS22());
            ((ComboBoxControl)inputControl).setValue(customColVO.getDefaultValueNumSYS22());
            ArrayList domainValues = new ArrayList();
            StringTokenizer stt = new StringTokenizer(customColVO.getConstraintValuesSYS22(),",");
            String token = null;
            Domain domain = new Domain(colVO.getColumnName());
            while(stt.hasMoreTokens()) {
              token = stt.nextToken();
              domain.addDomainPair(token,token);
            }
            ((ComboBoxControl)inputControl).setDomain(domain);
          }


          // add label + input control to filter panel...
          filterPanel.add(label,       new GridBagConstraints(0, paramsDefined.size(), 1, 1, 0.0, 0.0
                  ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(5, 5, 5, 5), 0, 0));
          filterPanel.add((JComponent)inputControl,       new GridBagConstraints(1, paramsDefined.size(), 1, 1, 1.0, 0.0
                  ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(5, 5, 5, 5), 0, 0));


          paramsDefined.add(inputControl);
        }
        colVO.setColumnVisible(customColVO.isColumnVisibleSYS22());
        if (customColVO.getColumnTypeSYS22().equals(ApplicationConsts.TYPE_PROG)) {
          colVO.setProgressive(true);
          colVO.setColumnRequired(false);
        }
        if (customColVO.getColumnTypeSYS22().equals(ApplicationConsts.TYPE_TEXT))
          colVO.setDefaultValue(customColVO.getDefaultValueTextSYS22());
        else if (customColVO.getColumnTypeSYS22().equals(ApplicationConsts.TYPE_NUM))
          colVO.setDefaultValue(customColVO.getDefaultValueNumSYS22());
        else if (customColVO.getColumnTypeSYS22().equals(ApplicationConsts.TYPE_DATE) &&
                 customColVO.getDefaultValueDateSYS22()!=null &&
                 customColVO.getDefaultValueDateSYS22().equals(Boolean.TRUE))
          colVO.setDefaultValue(new java.sql.Date(System.currentTimeMillis()));
        else if (customColVO.getColumnTypeSYS22().equals(ApplicationConsts.TYPE_ENUM) &&
                 customColVO.getConstraintValuesSYS22()!=null &&
                 customColVO.getConstraintValuesSYS22().length()>0) {
          ArrayList domainValues = new ArrayList();
          StringTokenizer stt = new StringTokenizer(customColVO.getConstraintValuesSYS22(),",");
          while(stt.hasMoreTokens())
            domainValues.add(stt.nextToken());
          colVO.setColumnValues(domainValues);
        }
      }




      // create grid panel...

View Full Code Here

      // create table content...
      jbInit();


      ArrayList cols = tableVO.getColumns();
      grid.setMaxSortedColumns(cols.size());
      ColumnVO vo = null;
      int t;
      Column col = null;
      for(int i=0;i<cols.size();i++) {
        vo = (ColumnVO)cols.get(i);
        t = vo.getColumnSqlType();


        if (vo.getColumnValues()!=null && vo.getColumnValues().size()>0) {
          // column is a combo box...
          col = new ComboColumn();
          Domain domain = new Domain(vo.getColumnName());
          for(int j=0;j<vo.getColumnValues().size();j++)
            domain.addDomainPair(vo.getColumnValues().get(j),vo.getColumnValues().get(j).toString());
          ((ComboColumn)col).setDomain(domain);
        }
        else if (fks.containsKey(vo.getColumnName()) &&
                 t!=Types.DATE && t!=Types.TIMESTAMP && t!=Types.TIME) {
          // lookup...
          col = new CodLookupColumn();
          ((CodLookupColumn)col).setMaxCharacters(vo.getColumnSize().intValue());
          ((CodLookupColumn)col).setAllowOnlyNumbers(t!=Types.VARCHAR && t!=Types.CHAR);
          if (t==Types.CHAR)
            ((CodLookupColumn)col).setCodePadding(true);
          fk = (ForeignKeyVO)fks.get(vo.getColumnName());
          ((CodLookupColumn)col).setEnableCodBox(fk.getFkFieldNames().size()==1);


          // retrieve primary key table infos...
          String sql = "select * from "+fk.getPkTableName();
          TableVO auxVO = new TableVO(sql,new ArrayList(),false);
          Response res = ClientUtils.getData("getQueryInfo",auxVO);
          if (res.isError())
            JOptionPane.showMessageDialog(
              MDIFrame.getInstance(),
              ClientSettings.getInstance().getResources().getResource(res.getErrorMessage()),
              ClientSettings.getInstance().getResources().getResource("Error"),
              JOptionPane.ERROR_MESSAGE
            );
          else {
            auxVO = (TableVO)((VOResponse)res).getVo();
            setupLookup(auxVO,(CodLookupColumn)col,fk);
          }
        }
        else if (t==Types.DATE || t==Types.TIMESTAMP || t==Types.TIME) {
          col = new DateColumn();
        }
        else if (t==Types.BIGINT || t==Types.INTEGER || t==Types.NUMERIC || t==Types.SMALLINT && vo.getColumnDec().equals(new BigDecimal(0))) {
          col = new IntegerColumn();
          ((IntegerColumn)col).setMaxValue((int)Math.pow(10d,vo.getColumnSize().doubleValue()));
        }
        else if (t==Types.BIGINT || t==Types.DECIMAL || t==Types.DOUBLE || t==Types.FLOAT || t==Types.INTEGER || t==Types.NUMERIC || t==Types.REAL || t==Types.SMALLINT) {
          col = new DecimalColumn();
          ((DecimalColumn)col).setMaxValue(Math.pow(10d,vo.getColumnSize().doubleValue()));
          ((DecimalColumn)col).setDecimals(vo.getColumnDec().intValue());
        }
        else {
          col = new TextColumn();
          ((TextColumn)col).setMaxCharacters(vo.getColumnSize().intValue());
          if (t==Types.CHAR)
            ((TextColumn)col).setRpadding(true);
        }


        col.setColumnName(vo.getAttributeName());
        col.setHeaderColumnName(vo.getColumnHeaderName());
        col.setColumnRequired(vo.getColumnRequired() && vo.getColumnVisible());
        col.setColumnFilterable(true);
        col.setColumnDuplicable(!vo.getProgressive());
        col.setColumnSortable(true);
        col.setColumnVisible(vo.getColumnVisible());
        col.setEditableOnInsert(!colsToDisable.contains(vo.getColumnName()) && !vo.getProgressive());
        col.setEditableOnEdit(!colsToDisable.contains(vo.getColumnName()) && !vo.getProgressive() && !vo.getPrimaryKey());
        col.setPreferredWidth(Math.max(vo.getColumnSize().intValue(),col.getHeaderColumnName().length()*9));


        grid.getColumnContainer().add(col);


        // set grid controller/data locator...
        grid.setController(new TablesController(tableVO,grid));

View Full Code Here

    col.setLookupController(lookupController);
    lookupController.setAllColumnVisible(false);
    lookupController.setLookupDataLocator(lookupDataLocator);
    lookupController.setFrameTitle(fk.getPkTableName());
    lookupController.setLookupValueObjectClassName("org.jallinone.sqltool.java.RowVO");
    ColumnVO vo = null;
    int colWidth = 0;
    int width = 0;
    for(int j=0;j<auxVO.getColumns().size();j++) {
      vo = (ColumnVO)auxVO.getColumns().get(j);
      lookupController.setVisibleColumn(vo.getAttributeName(),true);
      lookupController.setHeaderColumnName(vo.getAttributeName(),vo.getColumnHeaderName());
      lookupController.setSortableColumn(vo.getAttributeName(),true);
      lookupController.setFilterableColumn(vo.getAttributeName(),true);
      colWidth = Math.max(vo.getColumnSize().intValue(),vo.getColumnHeaderName().length()*9);
      lookupController.setPreferredWidthColumn(vo.getAttributeName(),colWidth);
      width += colWidth;
      for(int i=0;i<fk.getFkFieldNames().size();i++)
        if (vo.getColumnName().equals(fk.getPkTableName()+"."+fk.getPkFieldNames().get(i)))
          lookupController.addLookup2ParentLink(
            vo.getAttributeName(),
            tableVO.getAttributeName(fk.getFkTableName()+"."+fk.getFkFieldNames().get(i))
          );


    }

View Full Code Here

  /**
   * Callback method invoked when the user has clicked on the insert button
   * @param valueObject empty value object just created: the user can manage it to fill some attribute values
   */
  public void createValueObject(ValueObject valueObject) throws Exception {
    ColumnVO vo = null;
    for(int i=0;i<tableVO.getColumns().size();i++) {
      vo = (ColumnVO)tableVO.getColumns().get(i);
      grid.getVOListTableModel().setValueAt(vo.getDefaultValue(),grid.getSelectedRow()==-1?0:grid.getSelectedRow(),i);
    }
  }

View Full Code Here

TOP

Related Classes of org.jallinone.sqltool.java.ColumnVO

org.jallinone.sqltool.client.TablePanel

org.jallinone.sqltool.client.TablesController

org.jallinone.system.customizations.client.ShowCustomFunctionFrame

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.