Examples of IdColumn

org.compiere.minigrid.IDColumn
org.openrdf.sail.rdbms.algebra.IdColumn
A particular column in an SQL expression. @author James Leigh

Examples of org.compiere.minigrid.IDColumn

    BigDecimal invoiceAmt = new BigDecimal(0.0);


    int rows = miniTable.getRowCount();
    for (int i = 0; i < rows; i++)
    {
      IDColumn id = (IDColumn)miniTable.getValueAt(i, 0);
      if (id.isSelected())
      {
        BigDecimal amt = (BigDecimal)miniTable.getValueAt(i, 9);
        if (amt != null)
          invoiceAmt = invoiceAmt.add(amt);
        m_noSelected++;

View Full Code Here

Examples of org.compiere.minigrid.IDColumn

    //  Create Lines
    int rows = miniTable.getRowCount();
    int line = 0;
    for (int i = 0; i < rows; i++)
    {
      IDColumn id = (IDColumn)miniTable.getValueAt(i, 0);
      if (id.isSelected())
      {
        line += 10;
        MPaySelectionLine psl = new MPaySelectionLine (m_ps, line, PaymentRule);
        int C_Invoice_ID = id.getRecord_ID().intValue();
        BigDecimal OpenAmt = (BigDecimal)miniTable.getValueAt(i, 8);
        BigDecimal PayAmt = (BigDecimal)miniTable.getValueAt(i, 9);
        boolean isSOTrx = false;
        //
        psl.setInvoice(C_Invoice_ID, isSOTrx,

View Full Code Here

Examples of org.compiere.minigrid.IDColumn

      while (rs.next())
      {
        //  extend table
        miniTable.setRowCount(row+1);
        //  set values
        miniTable.setValueAt(new IDColumn(rs.getInt(1)), row, 0);   //  C_Order_ID
        miniTable.setValueAt(rs.getString(2), row, 1);              //  Org
        miniTable.setValueAt(rs.getString(3), row, 2);              //  DocType
        miniTable.setValueAt(rs.getString(4), row, 3);              //  Doc No
        miniTable.setValueAt(rs.getString(5), row, 4);              //  BPartner
        miniTable.setValueAt(rs.getTimestamp(6), row, 5);           //  DateOrdered

View Full Code Here

Examples of org.compiere.minigrid.IDColumn


    //  Get selected entries
    int rows = miniTable.getRowCount();
    for (int i = 0; i < rows; i++)
    {
      IDColumn id = (IDColumn)miniTable.getValueAt(i, 0);     //  ID in column 0
    //  log.fine( "Row=" + i + " - " + id);
      if (id != null && id.isSelected())
        results.add(id.getRecord_ID());
    }


    if (results.size() == 0)
      return;
    log.config("Selected #" + results.size());

View Full Code Here

Examples of org.openrdf.sail.rdbms.algebra.IdColumn

    }
    if (var == null) {
      node.replaceWith(new SqlNull());
    }
    else if (var.isImplied() && node.getParentNode() instanceof SqlIsNull) {
      node.replaceWith(new IdColumn(var.getAlias(), "subj"));
    }
    else {
      node.setRdbmsVar(var);
    }
    return var;

View Full Code Here

Examples of org.openrdf.sail.rdbms.algebra.IdColumn

  }


  private FromItem valueJoin(String alias, String tableName, ColumnVar using, boolean left) {
    JoinItem j = new JoinItem(alias, tableName);
    j.setLeft(left);
    j.addFilter(new SqlEq(new IdColumn(alias), new RefIdColumn(using)));
    return j;
  }

View Full Code Here

Examples of org.openrdf.sail.rdbms.algebra.IdColumn

    Map<String, ColumnVar> vars = new HashMap<String, ColumnVar>(4);
    for (ColumnVar var : new ColumnVar[] { s, p, o, c }) {
      from.addVar(var);
      Value value = var.getValue();
      if (vars.containsKey(var.getName())) {
        IdColumn existing = new IdColumn(vars.get(var.getName()));
        from.addFilter(new SqlEq(new IdColumn(var), existing));
      }
      else if (value != null && !var.isImplied()) {
        try {
          NumberValue vc = new NumberValue(vf.getInternalId(value));
          from.addFilter(new SqlEq(new RefIdColumn(var), vc));

View Full Code Here

Examples of org.openrdf.sail.rdbms.algebra.IdColumn

    names.retainAll(lvars.keySet());
    for (String name : names) {
      ColumnVar l = lvars.get(name);
      ColumnVar r = rvars.get(name);
      if (!l.isImplied() && !r.isImplied()) {
        IdColumn rid = new IdColumn(r);
        SqlExpr filter = eq(rid, new IdColumn(l));
        if (r.isNullable()) {
          filter = or(isNull(rid), filter);
        }
        right.addFilter(filter);
      }

View Full Code Here

Examples of org.openrdf.sail.rdbms.algebra.IdColumn

    }
    if (var == null) {
      node.replaceWith(new SqlNull());
    }
    else if (var.isImplied() && node.getParentNode() instanceof SqlIsNull) {
      node.replaceWith(new IdColumn(var.getAlias(), "subj"));
    }
    else {
      node.setRdbmsVar(var);
    }
    return var;

View Full Code Here

Examples of org.openrdf.sail.rdbms.algebra.IdColumn

  }


  private FromItem valueJoin(String alias, String tableName, ColumnVar using, boolean left) {
    JoinItem j = new JoinItem(alias, tableName);
    j.setLeft(left);
    j.addFilter(new SqlEq(new IdColumn(alias), new RefIdColumn(using)));
    return j;
  }

View Full Code Here

0 1

TOP

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.