@Override public String getSQLWhere() { StringBuffer sql = new StringBuffer(); if (txtDocumentNo.getText().length() > 0) sql.append(" AND UPPER(o.DocumentNo) LIKE ?"); if (txtDescription.getText().length() > 0) sql.append(" AND UPPER(o.Description) LIKE ?"); if (txtOrderRef.getText().length() > 0) sql.append(" AND UPPER(o.POReference) LIKE ?"); // if (editorBPartner.getValue() != null) sql.append(" AND o.C_BPartner_ID=?"); // Date fromDate = null; Date toDate = null; try { fromDate = dateFrom.getValue(); } catch (WrongValueException e) { } try { toDate = dateTo.getValue(); } catch (WrongValueException e) { } if (fromDate == null && toDate != null) { sql.append(" AND TRUNC(o.DateOrdered) <= ?"); } else if (fromDate != null && toDate == null) { sql.append(" AND TRUNC(o.DateOrdered) >= ?"); } else if (fromDate != null && toDate != null) { sql.append(" AND TRUNC(o.DateOrdered) BETWEEN ? AND ?"); } // Double fromAmount = null; Double toAmount = null; if (amountFrom.getText() != null && amountFrom.getText().trim().length() > 0) { try { fromAmount = Double.parseDouble(amountFrom.getText()); } catch (NumberFormatException e) { } } if (amountTo.getText() != null && amountTo.getText().trim().length() > 0) { try { toAmount = Double.parseDouble(amountTo.getText()); } catch (NumberFormatException e) { } } if (fromAmount == null && toAmount != null) { sql.append(" AND o.GrandTotal <= ?"); } else if (fromAmount != null && toAmount == null) { sql.append(" AND o.GrandTotal >= ?"); } else if (fromAmount != null && toAmount != null) { sql.append(" AND o.GrandTotal BETWEEN ? AND ?"); } sql.append(" AND o.IsSOTrx=?"); log.finer(sql.toString()); return sql.toString(); }
private void getDateAndTimeFrom(Calendar date) { Date dateFrom = fDateFrom.getValue(); Date timeFrom = fTimeFrom.getValue(); date.setTime(dateFrom); Calendar time = new GregorianCalendar(); time.setTime(timeFrom); date.set(Calendar.HOUR, time.get(Calendar.HOUR)); date.set(Calendar.MINUTE, time.get(Calendar.MINUTE)); }
/** Initialize component & values from m_mAssignment */ private void setDisplay() { m_setting = true; // Set Resource int S_Resource_ID = m_mAssignment.getS_Resource_ID(); KeyNamePair[] resources = new KeyNamePair[m_lookup.size()]; m_lookup.keySet().toArray(resources); for (int i = 0; i < resources.length; i++) { if (resources[i].getKey() == S_Resource_ID) { fResource.setSelectedIndex(i); break; } } ListItem listItem = fResource.getSelectedItem(); KeyNamePair check = new KeyNamePair((Integer) listItem.getValue(), listItem.getLabel()); if (check == null || check.getKey() != S_Resource_ID) { if (m_mAssignment.getS_ResourceAssignment_ID() == 0) // new record select first fResource.setSelectedItem(fResource.getSelectedItem()); // initiates UOM display else log.log(Level.SEVERE, "Resource not found ID=" + S_Resource_ID); } // Set Date, Qty fDateFrom.setValue(m_mAssignment.getAssignDateFrom()); fTimeFrom.setValue(m_mAssignment.getAssignDateFrom()); fQty.setValue(m_mAssignment.getQty()); // Name, Description fName.setValue(m_mAssignment.getName()); fDescription.setValue(m_mAssignment.getDescription()); // Set Editor to R/O if confirmed boolean readWrite = true; if (m_mAssignment.isConfirmed()) readWrite = false; confirmPanel.getButton("Cancel").setVisible(readWrite); fResource.setEnabled(readWrite); fDateFrom.setReadonly(!readWrite); fQty.setEnabled(readWrite); m_setting = false; } // dynInit
/** * Get dynamic WHERE part of SQL To be overwritten by concrete classes * * @return WHERE clause */ protected String getSQLWhere() { StringBuilder sql = new StringBuilder(); Integer S_ResourceType_ID = (Integer) fieldResourceType.getValue(); if (S_ResourceType_ID != null) sql.append(" AND rt.S_ResourceType_ID=").append(S_ResourceType_ID.intValue()); Integer S_Resource_ID = (Integer) fieldResource.getValue(); if (S_Resource_ID != null) sql.append(" AND r.S_Resource_ID=").append(S_Resource_ID.intValue()); Date f = fieldFrom.getValue(); Timestamp ts = f != null ? new Timestamp(f.getTime()) : null; if (ts != null) sql.append(" AND TRUNC(ra.AssignDateFrom)>=").append(DB.TO_DATE(ts, false)); Date t = fieldTo.getValue(); ts = t != null ? new Timestamp(t.getTime()) : null; if (ts != null) sql.append(" AND TRUNC(ra.AssignDateTo)<=").append(DB.TO_DATE(ts, false)); return sql.toString(); } // getSQLWhere
/** * Static Setup - add fields to parameterPanel. * * <pre> * ResourceType Resource DateTimeFrom DateTimeTo New * </pre> */ private void statInit() { fieldFrom.setWidth("180px"); fieldTo.setWidth("180px"); bNew.addEventListener(Events.ON_CLICK, this); Grid grid = GridFactory.newGridLayout(); Rows rows = new Rows(); grid.appendChild(rows); Row row = new Row(); rows.appendChild(row); row.appendChild(fieldResourceType.getLabel().rightAlign()); row.appendChild(fieldResource.getLabel().rightAlign()); row.appendChild(labelFrom.rightAlign()); row.appendChild(labelTo.rightAlign()); row.appendChild(new Label()); row = new Row(); rows.appendChild(row); row.appendChild(fieldResourceType.getComponent()); row.appendChild(fieldResource.getComponent()); Div div = new Div(); div.setStyle("text-align: right;"); div.appendChild(fieldFrom); row.appendChild(div); div = new Div(); div.setStyle("text-align: right;"); div.appendChild(fieldTo); row.appendChild(div); row.appendChild(bNew); layout = new Borderlayout(); layout.setWidth("100%"); layout.setHeight("100%"); if (!isLookup()) { layout.setStyle("position: absolute"); } this.appendChild(layout); North north = new North(); layout.appendChild(north); north.appendChild(grid); Center center = new Center(); layout.appendChild(center); div = new Div(); div.appendChild(contentPanel); if (isLookup()) contentPanel.setWidth("99%"); else contentPanel.setStyle("width: 99%; margin: 0px auto;"); contentPanel.setVflex(true); div.setStyle("width :100%; height: 100%"); center.appendChild(div); div.setVflex("1"); div.setHflex("1"); South south = new South(); layout.appendChild(south); southBody = new Vbox(); southBody.setWidth("100%"); south.appendChild(southBody); southBody.appendChild(confirmPanel); southBody.appendChild(new Separator()); southBody.appendChild(statusBar); }
@Override protected void setParameters(PreparedStatement pstmt, boolean forCount) throws SQLException { int index = 1; if (txtDocumentNo.getText().length() > 0) pstmt.setString(index++, getSQLText(txtDocumentNo)); if (txtDescription.getText().length() > 0) pstmt.setString(index++, getSQLText(txtDescription)); if (txtOrderRef.getText().length() > 0) pstmt.setString(index++, getSQLText(txtOrderRef)); // if (editorBPartner.getValue() != null) { Integer bp = (Integer) editorBPartner.getValue(); pstmt.setInt(index++, bp.intValue()); log.fine("BPartner=" + bp); } // Date fromD = null; Date toD = null; Timestamp from = null; Timestamp to = null; try { if (dateFrom.getValue() != null) { fromD = dateFrom.getValue(); from = new Timestamp(fromD.getTime()); } } catch (WrongValueException e) { } try { if (dateTo.getValue() != null) { toD = dateTo.getValue(); to = new Timestamp(toD.getTime()); } } catch (WrongValueException e) { } log.fine("Date From=" + from + ", To=" + to); if (from == null && to != null) { pstmt.setTimestamp(index++, to); } else if (from != null && to == null) { pstmt.setTimestamp(index++, from); } else if (from != null && to != null) { pstmt.setTimestamp(index++, from); pstmt.setTimestamp(index++, to); } // BigDecimal fromBD = null; BigDecimal toBD = null; Double fromAmt = null; Double toAmt = null; if (amountFrom.getText() != null && amountFrom.getText().trim().length() > 0) { try { fromAmt = Double.parseDouble(amountFrom.getText()); fromBD = BigDecimal.valueOf(fromAmt); } catch (Exception e) { } } if (amountTo.getText() != null && amountTo.getText().trim().length() > 0) { try { toAmt = Double.parseDouble(amountTo.getText()); toBD = BigDecimal.valueOf(toAmt); } catch (Exception e) { } } if (fromBD == null && toBD != null) { pstmt.setBigDecimal(index++, toBD); } else if (fromBD != null && toBD == null) { pstmt.setBigDecimal(index++, fromBD); } else if (fromBD != null && toBD != null) { pstmt.setBigDecimal(index++, fromBD); pstmt.setBigDecimal(index++, toBD); } pstmt.setString(index++, isSoTrx.isChecked() ? "Y" : "N"); }
private void initLayout() { txtDocumentNo.setWidth("100%"); txtDescription.setWidth("100%"); txtOrderRef.setWidth("100%"); dateFrom.setWidth("165px"); dateTo.setWidth("165px"); amountFrom.getDecimalbox().setWidth("155px"); amountTo.getDecimalbox().setWidth("155px"); Grid grid = GridFactory.newGridLayout(); Rows rows = new Rows(); grid.appendChild(rows); Row row = new Row(); rows.appendChild(row); row.appendChild(lblDocumentNo.rightAlign()); row.appendChild(txtDocumentNo); row.appendChild(editorBPartner.getLabel().rightAlign()); row.appendChild(editorBPartner.getComponent()); row.appendChild(isSoTrx); row = new Row(); row.setSpans("1, 1, 1, 2"); rows.appendChild(row); row.appendChild(lblDescription.rightAlign()); row.appendChild(txtDescription); row.appendChild(lblDateOrdered.rightAlign()); Hbox hbox = new Hbox(); hbox.appendChild(dateFrom); hbox.appendChild(new Label("-")); hbox.appendChild(dateTo); row.appendChild(hbox); row = new Row(); row.setSpans("1, 1, 1, 2"); rows.appendChild(row); row.appendChild(lblOrderRef.rightAlign()); row.appendChild(txtOrderRef); row.appendChild(lblGrandTotal.rightAlign()); hbox = new Hbox(); hbox.appendChild(amountFrom); hbox.appendChild(new Label("-")); hbox.appendChild(amountTo); row.appendChild(hbox); layout = new Borderlayout(); layout.setWidth("100%"); layout.setHeight("100%"); if (!isLookup()) { layout.setStyle("position: absolute"); } this.appendChild(layout); North north = new North(); layout.appendChild(north); north.appendChild(grid); Center center = new Center(); layout.appendChild(center); center.setFlex(true); Div div = new Div(); div.appendChild(contentPanel); if (isLookup()) contentPanel.setWidth("99%"); else contentPanel.setStyle("width: 99%; margin: 0px auto;"); contentPanel.setVflex(true); div.setStyle("width :100%; height: 100%"); center.appendChild(div); South south = new South(); layout.appendChild(south); southBody = new Vbox(); southBody.setWidth("100%"); south.appendChild(southBody); southBody.appendChild(confirmPanel); southBody.appendChild(new Separator()); southBody.appendChild(statusBar); }