Examples with Listbox org.adempiere.webui.component.Listbox used on opensource projects

Example 21 with Listbox

use of org.adempiere.webui.component.Listbox in project adempiere by adempiere.

the class WPAttributeDialog method cmd_newEdit.

//	cmd_select
/**
	 * 	Instance New/Edit
	 */
private void cmd_newEdit() {
    boolean rw = cbNewEdit.isChecked();
    log.config("R/W=" + rw + " " + m_masi);
    //
    fieldLotString.setReadonly(!(rw && m_masi.getM_Lot_ID() == 0));
    if (fieldLot != null)
        fieldLot.setEnabled(rw);
    bLot.setEnabled(rw);
    fieldSerNo.setReadonly(!rw);
    bSerNo.setEnabled(rw);
    fieldGuaranteeDate.setReadonly(!rw);
    //
    for (int i = 0; i < m_editors.size(); i++) {
        HtmlBasedComponent editor = m_editors.get(i);
        if (editor instanceof InputElement)
            ((InputElement) editor).setReadonly(!rw);
        else if (editor instanceof Listbox)
            ((Listbox) editor).setEnabled(rw);
        else if (editor instanceof NumberBox)
            ((NumberBox) editor).setEnabled(rw);
    }
}

Example 22 with Listbox

use of org.adempiere.webui.component.Listbox in project adempiere by adempiere.

the class InfoPAttributePanel method createQuery.

//	actionPerformed
/**
	 * 	Create Query
	 *  <code>
	 * 	Available synonyms:
	 *		M_Product p
	 *		M_ProductPrice pr
	 *		M_AttributeSet pa
	 *	</code>
	 *	@return query
	 */
private String createQuery() {
    /** Base Query
		SELECT *
		FROM M_Product p
 		 INNER JOIN M_ProductPrice pr ON (p.M_Product_ID=pr.M_Product_ID)
 		 LEFT OUTER JOIN M_AttributeSet pa ON (p.M_AttributeSet_ID=pa.M_AttributeSet_ID)
		WHERE
		**/
    /***	Instance Attributes		*/
    StringBuffer sb = new StringBuffer();
    //	Serial No
    String s = serNoField.getComponent().getText();
    if (s != null && s.length() > 0) {
        sb.append(" AND asi.SerNo");
        if (s.indexOf('%') == -1 && s.indexOf('_') == 1)
            sb.append("=");
        else
            sb.append(" LIKE ");
        sb.append(DB.TO_STRING(s));
    }
    //	Lot Number
    s = lotField.getComponent().getText();
    if (s != null && s.length() > 0) {
        sb.append(" AND asi.Lot");
        if (s.indexOf('%') == -1 && s.indexOf('_') == 1)
            sb.append("=");
        else
            sb.append(" LIKE ");
        sb.append(DB.TO_STRING(s));
    }
    //	Lot ID
    ListItem li = lotSelection.getSelectedItem();
    if (li != null && li.getValue() != null) {
        KeyNamePair pp = (KeyNamePair) li.getValue();
        if (pp != null && pp.getKey() != -1) {
            int ID = pp.getKey();
            sb.append(" AND asi.M_Lot_ID=").append(ID);
        }
    }
    //	Guarantee Date
    Timestamp ts = (Timestamp) guaranteeDateField.getValue();
    if (ts != null) {
        sb.append(" AND TRUNC(asi.GuaranteeDate, 'DD')");
        //	 < = >
        int index = guaranteeDateSelection.getSelectedIndex();
        if (index == 0)
            sb.append("<");
        else if (index == 1)
            sb.append("=");
        else
            sb.append(">");
        sb.append(DB.TO_DATE(ts, true));
    }
    //	Instance Editors
    for (int i = 0; i < m_instanceEditors.size(); i++) {
        StringBuffer iAttr = new StringBuffer();
        Component c = (Component) m_instanceEditors.get(i);
        Component cTo = (Component) m_instanceEditorsTo.get(i);
        int M_Attribute_ID = Integer.parseInt(c.getId());
        if (c instanceof Listbox) {
            Listbox field = (Listbox) c;
            li = field.getSelectedItem();
            if (li != null && li.getValue() != null) {
                KeyNamePair pp = (KeyNamePair) li.getValue();
                if (pp != null && pp.getKey() != -1) {
                    iAttr.append("M_Attribute_ID=").append(M_Attribute_ID).append(" AND M_AttributeValue_ID=").append(pp.getKey());
                }
            }
        } else if (c instanceof NumberBox) {
            NumberBox field = (NumberBox) c;
            BigDecimal value = (BigDecimal) field.getValue();
            NumberBox fieldTo = (NumberBox) cTo;
            BigDecimal valueTo = (BigDecimal) fieldTo.getValue();
            if (value != null || valueTo != null) {
                iAttr.append("M_Attribute_ID=").append(M_Attribute_ID).append(" AND ValueNumber");
                if (value != null && valueTo == null)
                    iAttr.append("=").append(value);
                else if (value == null && valueTo != null)
                    iAttr.append("<=").append(valueTo);
                else if (value != null && valueTo != null)
                    iAttr.append(" BETWEEN ").append(value).append(" AND ").append(valueTo);
            }
        } else {
            Textbox field = (Textbox) c;
            String value = field.getText();
            if (value != null && value.length() > 0) {
                iAttr.append("M_Attribute_ID=").append(M_Attribute_ID).append(" AND Value");
                if (value.indexOf('%') == -1 && value.indexOf('_') == -1)
                    iAttr.append("=");
                else
                    iAttr.append(" LIKE ");
                iAttr.append(DB.TO_STRING(value));
            }
        }
        //	Add to where
        if (iAttr.length() > 0)
            sb.append(" AND asi.M_AttributeSetInstance_ID IN " + "(SELECT M_AttributeSetInstance_ID FROM M_AttributeInstance " + "WHERE ").append(iAttr).append(")");
    }
    //	finish Instance Attributes
    if (sb.length() > 0) {
        sb.insert(0, " AND EXISTS (SELECT * FROM M_Storage s" + " INNER JOIN M_AttributeSetInstance asi ON (s.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_ID) " + "WHERE s.M_Product_ID=p.M_Product_ID");
        sb.append(")");
    }
    //	Product Attributes 
    for (int i = 0; i < m_productEditors.size(); i++) {
        StringBuffer pAttr = new StringBuffer();
        Component c = (Component) m_productEditors.get(i);
        Component cTo = (Component) m_productEditorsTo.get(i);
        int M_Attribute_ID = Integer.parseInt(c.getId());
        if (c instanceof Listbox) {
            Listbox field = (Listbox) c;
            li = field.getSelectedItem();
            if (li != null && li.getValue() != null) {
                KeyNamePair pp = (KeyNamePair) li.getValue();
                if (pp != null && pp.getKey() != -1) {
                    pAttr.append("M_Attribute_ID=").append(M_Attribute_ID).append(" AND M_AttributeValue_ID=").append(pp.getKey());
                }
            }
        } else if (c instanceof NumberBox) {
            NumberBox field = (NumberBox) c;
            BigDecimal value = (BigDecimal) field.getValue();
            NumberBox fieldTo = (NumberBox) cTo;
            BigDecimal valueTo = (BigDecimal) fieldTo.getValue();
            if (value != null || valueTo != null) {
                pAttr.append("M_Attribute_ID=").append(M_Attribute_ID).append(" AND ValueNumber");
                if (value != null && valueTo == null)
                    pAttr.append("=").append(value);
                else if (value == null && valueTo != null)
                    pAttr.append("<=").append(valueTo);
                else if (value != null && valueTo != null)
                    pAttr.append(" BETWEEN ").append(value).append(" AND ").append(valueTo);
            }
        } else {
            Textbox field = (Textbox) c;
            String value = field.getText();
            if (value != null && value.length() > 0) {
                pAttr.append("M_Attribute_ID=").append(M_Attribute_ID).append(" AND Value");
                if (value.indexOf('%') == -1 && value.indexOf('_') == -1)
                    pAttr.append("=");
                else
                    pAttr.append(" LIKE ");
                pAttr.append(DB.TO_STRING(value));
            }
        }
        //	Add to Where
        if (pAttr.length() > 0)
            sb.append(" AND p.M_AttributeSetInstance_ID IN " + "(SELECT M_AttributeSetInstance_ID " + "FROM M_AttributeInstance WHERE ").append(pAttr).append(")");
    }
    //
    m_query = null;
    if (sb.length() > 0)
        m_query = sb.toString();
    log.config(m_query);
    return m_query;
}

Example 23 with Listbox

use of org.adempiere.webui.component.Listbox in project adempiere by adempiere.

the class InfoPAttributePanel method setDisplay.

/**
	 *   Set the display text
	 */
private void setDisplay() {
    StringBuffer display = new StringBuffer();
    if (serNoField != null && serNoField.getValue().toString().length() > 0)
        display.append(serNoField.getValue().toString() + "-");
    if (lotField != null && lotField.getValue().toString().length() > 0)
        display.append(lotField.getValue().toString() + "-");
    if (lotSelection != null && lotSelection.getSelectedItem().getValue().toString().length() > 0)
        display.append(lotSelection.getSelectedItem().getValue().toString() + "-");
    if (guaranteeDateField != null && guaranteeDateField.getValue() != null)
        display.append(guaranteeDateSelection.getSelectedItem().getValue().toString() + guaranteeDateField.getValue().toString() + "-");
    for (int i = 0; i < m_productEditors.size(); i++) {
        Component c = (Component) m_productEditors.get(i);
        Component cTo = (Component) m_productEditorsTo.get(i);
        if (c instanceof Listbox) {
            Listbox field = (Listbox) c;
            display.append(field.getSelectedItem().getValue().toString() + "-");
        } else if (c instanceof NumberBox) {
            NumberBox field = (NumberBox) c;
            if (field.getValue() != null)
                display.append(field.getValue().toString() + "-");
            NumberBox fieldTo = (NumberBox) cTo;
            if (fieldTo.getValue() != null)
                display.append(fieldTo.getValue().toString() + "-");
        } else {
            Textbox field = (Textbox) c;
            display.append(field.getValue() + "-");
        }
    }
    for (int i = 0; i < m_instanceEditors.size(); i++) {
        Component c = (Component) m_instanceEditors.get(i);
        Component cTo = (Component) m_instanceEditorsTo.get(i);
        if (c instanceof Listbox) {
            Listbox field = (Listbox) c;
            display.append(field.getSelectedItem().getValue().toString() + "-");
        } else if (c instanceof NumberBox) {
            NumberBox field = (NumberBox) c;
            if (field.getValue() != null)
                display.append(field.getValue().toString() + "-");
            NumberBox fieldTo = (NumberBox) cTo;
            if (fieldTo.getValue() != null)
                display.append(fieldTo.getValue().toString() + "-");
        } else {
            Textbox field = (Textbox) c;
            display.append(field.getValue() + "-");
        }
    }
    //  TODO - there is a more elegant way to do this.
    while (display.toString().contains("--") && display.length() > 1) {
        display.delete(display.indexOf("--"), display.indexOf("--") + 1);
    }
    while (display.toString().startsWith("-") && display.length() > 1) {
        display.delete(0, 1);
    }
    while (display.toString().endsWith("-") && display.length() > 1) {
        display.delete(display.length() - 1, display.length());
    }
    m_display = display.toString();
}

Example 24 with Listbox

use of org.adempiere.webui.component.Listbox in project adempiere by adempiere.

the class WArchiveViewer method dynInit.

/**
	 *  Dynamic Init
	 */
private void dynInit() {
    processField = new Listbox();
    KeyNamePair[] keyNamePair = getProcessData();
    for (int i = 0; i < keyNamePair.length; i++) processField.appendItem(keyNamePair[i].getName(), keyNamePair[i]);
    tableField = new Listbox();
    keyNamePair = getTableData();
    for (int i = 0; i < keyNamePair.length; i++) tableField.appendItem(keyNamePair[i].getName(), keyNamePair[i]);
    createdByQField = new Listbox();
    keyNamePair = getUserData();
    for (int i = 0; i < keyNamePair.length; i++) createdByQField.appendItem(keyNamePair[i].getName(), keyNamePair[i]);
    MLookup lookup = MLookupFactory.get(Env.getCtx(), m_WindowNo, 0, 2762, DisplayType.Search);
    bPartnerField = new WSearchEditor(lookup, Msg.translate(Env.getCtx(), "C_BPartner_ID"), "", true, false, true);
}