Examples with MLookup org.compiere.model.MLookup used on opensource projects

Example 6 with MLookup

use of org.compiere.model.MLookup in project adempiere by adempiere.

the class WMRPDetailed method statInit.

private void statInit() throws Exception {
    //Resource Lookup 
    // Base Language
    Language language = Language.getLoginLanguage();
    MLookup resourceL = MLookupFactory.get(getCtx(), p_WindowNo, MColumn.getColumn_ID(MResource.Table_Name, MResource.COLUMNNAME_S_Resource_ID), DisplayType.TableDir, language, MResource.COLUMNNAME_S_Resource_ID, 0, false, MResource.Table_Name + "." + MResource.COLUMNNAME_ManufacturingResourceType + "= '" + MResource.MANUFACTURINGRESOURCETYPE_Plant + "'");
    fResource_ID = new WSearchEditor(MPPMRP.COLUMNNAME_S_Resource_ID, false, false, true, resourceL) {

        private final long serialVersionUID = 1L;

        public void setValue(Object arg0) {
            super.setValue(arg0);
        }

        ;
    };
    fPlanner_ID = new WSearchEditor(MPPMRP.COLUMNNAME_Planner_ID, false, false, true, MLookupFactory.get(getCtx(), p_WindowNo, 0, MColumn.getColumn_ID(MPPProductPlanning.Table_Name, MPPMRP.COLUMNNAME_Planner_ID), DisplayType.Table)) {

        private final long serialVersionUID = 1L;

        public void setValue(Object arg0) {
            super.setValue(arg0);
        }

        ;
    };
    fWarehouse_ID = new WSearchEditor(MPPMRP.COLUMNNAME_M_Warehouse_ID, false, false, true, MLookupFactory.get(getCtx(), p_WindowNo, 0, MColumn.getColumn_ID(MWarehouse.Table_Name, MPPMRP.COLUMNNAME_M_Warehouse_ID), DisplayType.TableDir)) {

        private final long serialVersionUID = 1L;

        public void setValue(Object arg0) {
            super.setValue(arg0);
        }

        ;
    };
    fMaster.setSelected(false);
    fMaster.setEnabled(false);
    fMRPReq.setSelected(false);
    fMRPReq.setEnabled(false);
    fCreatePlan.setSelected(false);
    fCreatePlan.setEnabled(false);
    lUOM.setText(Msg.translate(getCtx(), MUOM.COLUMNNAME_C_UOM_ID));
    fUOM.setReadonly(true);
    lType.setText(Msg.translate(getCtx(), MPPProductPlanning.COLUMNNAME_Order_Policy));
    fType.setReadonly(true);
    lOrderPeriod.setText(Msg.translate(getCtx(), MPPProductPlanning.COLUMNNAME_Order_Period));
    fOrderPeriod.setReadWrite(false);
    lTimefence.setText(Msg.translate(getCtx(), MPPProductPlanning.COLUMNNAME_TimeFence));
    fTimefence.setReadWrite(false);
    lLeadtime.setText(Msg.translate(getCtx(), MPPProductPlanning.COLUMNNAME_DeliveryTime_Promised));
    fLeadtime.setReadWrite(false);
    lMinOrd.setText(Msg.translate(getCtx(), MPPProductPlanning.COLUMNNAME_Order_Min));
    fMinOrd.setReadWrite(false);
    lMaxOrd.setText(Msg.translate(getCtx(), MPPProductPlanning.COLUMNNAME_Order_Max));
    fMaxOrd.setReadWrite(false);
    lOrdMult.setText(Msg.translate(getCtx(), MPPProductPlanning.COLUMNNAME_Order_Pack));
    fOrdMult.setReadWrite(false);
    lOrderQty.setText(Msg.translate(getCtx(), MPPProductPlanning.COLUMNNAME_Order_Qty));
    fOrderQty.setReadWrite(false);
    lYield.setText(Msg.translate(getCtx(), MPPProductPlanning.COLUMNNAME_Yield));
    fYield.setReadWrite(false);
    lOnhand.setText(Msg.translate(getCtx(), MStorage.COLUMNNAME_QtyOnHand));
    fOnhand.setReadWrite(false);
    lSafetyStock.setText(Msg.translate(getCtx(), MPPProductPlanning.COLUMNNAME_SafetyStock));
    fSafetyStock.setReadWrite(false);
    lReserved.setText(Msg.translate(getCtx(), MStorage.COLUMNNAME_QtyReserved));
    fReserved.setReadWrite(false);
    lAvailable.setText(Msg.translate(getCtx(), "QtyAvailable"));
    fAvailable.setReadWrite(false);
    lOrdered.setText(Msg.translate(getCtx(), MPPOrder.COLUMNNAME_QtyOrdered));
    fOrdered.setReadWrite(false);
    //Product Lookup
    fProduct_ID = new WSearchEditor(MPPMRP.COLUMNNAME_M_Product_ID, true, false, true, MLookupFactory.get(getCtx(), p_WindowNo, 0, MColumn.getColumn_ID(MProduct.Table_Name, MPPMRP.COLUMNNAME_M_Product_ID), DisplayType.Search)) {

        private final long serialVersionUID = 1L;

        public void setValue(Object arg0) {
            super.setValue(arg0);
        }

        ;
    };
    fMaster.setText(Msg.translate(getCtx(), MPPProductPlanning.COLUMNNAME_IsMPS));
    fMRPReq.setText(Msg.translate(getCtx(), MPPProductPlanning.COLUMNNAME_IsRequiredMRP));
    fCreatePlan.setText(Msg.translate(getCtx(), MPPProductPlanning.COLUMNNAME_IsCreatePlan));
    //AttributeSet Button
    fAttrSetInstance_ID = new Button() {

        private final long serialVersionUID = 1L;

        private Object m_value;

        public void setLabel(String text) {
            if (text == null) {
                text = "---";
            }
            if (text.length() > 23) {
                text = text.substring(0, 20) + "...";
            }
            super.setLabel(text);
        }

        public void setValue(Object arg0) {
            m_value = arg0;
            int i = (arg0 instanceof Integer) ? ((Integer) arg0).intValue() : 0;
            if (i == 0) {
                setLabel(null);
            }
        }

        public Object getValue() {
            return m_value;
        }
    };
    fAttrSetInstance_ID.addActionListener(new EventListener() {

        @Override
        public void onEvent(Event event) throws Exception {
            selectAttributeSetInstance();
        }
    });
    //
    fDateFrom.getComponent().setTooltiptext(Msg.translate(getCtx(), MLot.COLUMNNAME_DateFrom));
    fDateTo.getComponent().setTooltiptext(Msg.translate(getCtx(), MLot.COLUMNNAME_DateTo));
    fSupplyType = new WSearchEditor(MPPMRP.COLUMNNAME_TypeMRP, false, false, true, MLookupFactory.get(getCtx(), p_WindowNo, 0, MColumn.getColumn_ID(MPPMRP.Table_Name, MPPMRP.COLUMNNAME_TypeMRP), DisplayType.List));
    Rows rows = null;
    Row row = null;
    rows = new Rows();
    rows.setParent(parameterPanel);
    //  1st Row
    row = rows.newRow();
    row.appendChild(lProduct_ID.rightAlign());
    row.appendChild(fProduct_ID.getComponent());
    row.appendChild(lUOM.rightAlign());
    row.appendChild(fUOM);
    row.appendChild(lType.rightAlign());
    row.appendChild(fType);
    //  2nd Row
    row = rows.newRow();
    row.appendChild(lAttrSetInstance_ID.rightAlign());
    row.appendChild(fAttrSetInstance_ID);
    row.appendChild(lOnhand.rightAlign());
    row.appendChild(fOnhand.getComponent());
    row.appendChild(lOrderPeriod.rightAlign());
    row.appendChild(fOrderPeriod.getComponent());
    //  3rd Row
    row = rows.newRow();
    row.appendChild(lPlanner_ID.rightAlign());
    row.appendChild(fPlanner_ID.getComponent());
    row.appendChild(lSafetyStock.rightAlign());
    row.appendChild(fSafetyStock.getComponent());
    row.appendChild(lMinOrd.rightAlign());
    row.appendChild(fMinOrd.getComponent());
    //  4th Row
    row = rows.newRow();
    row.appendChild(lWarehouse_ID.rightAlign());
    row.appendChild(fWarehouse_ID.getComponent());
    row.appendChild(lReserved.rightAlign());
    row.appendChild(fReserved.getComponent());
    row.appendChild(lMaxOrd.rightAlign());
    row.appendChild(fMaxOrd.getComponent());
    //  5th Row
    row = rows.newRow();
    row.appendChild(lResource_ID.rightAlign());
    row.appendChild(fResource_ID.getComponent());
    row.appendChild(lAvailable.rightAlign());
    row.appendChild(fAvailable.getComponent());
    row.appendChild(lOrdMult.rightAlign());
    row.appendChild(fOrdMult.getComponent());
    //  6th Row
    row = rows.newRow();
    row.appendChild(lDateFrom.rightAlign());
    row.appendChild(fDateFrom.getComponent());
    row.appendChild(lOrdered.rightAlign());
    row.appendChild(fOrdered.getComponent());
    row.appendChild(lOrderQty.rightAlign());
    row.appendChild(fOrderQty.getComponent());
    //  7th Row
    row = rows.newRow();
    row.appendChild(lDateTo.rightAlign());
    row.appendChild(fDateTo.getComponent());
    row.appendChild(new Space());
    row.appendChild(new Space());
    row.appendChild(lTimefence.rightAlign());
    row.appendChild(fTimefence.getComponent());
    //  8th Row
    row = rows.newRow();
    row.appendChild(new Space());
    row.appendChild(fMaster);
    row.appendChild(new Space());
    row.appendChild(fCreatePlan);
    row.appendChild(lLeadtime.rightAlign());
    row.appendChild(fLeadtime.getComponent());
    //  9th Row
    row = rows.newRow();
    row.appendChild(new Space());
    row.appendChild(new Space());
    row.appendChild(new Space());
    row.appendChild(fMRPReq);
    row.appendChild(lYield.rightAlign());
    row.appendChild(fYield.getComponent());
}

Example 7 with MLookup

use of org.compiere.model.MLookup in project adempiere by adempiere.

the class WCRP method fillPicks.

private void fillPicks() throws Exception {
    Properties ctx = Env.getCtx();
    MLookup resourceL = MLookupFactory.get(ctx, m_WindowNo, 0, MColumn.getColumn_ID(I_M_Product.Table_Name, "S_Resource_ID"), DisplayType.TableDir);
    resource = new WSearchEditor("S_Resource_ID", false, false, true, resourceL);
}

Example 8 with MLookup

use of org.compiere.model.MLookup in project adempiere by adempiere.

the class WGraph method loadData.

private void loadData() {
    list = builder.loadData();
    if (m_renderChart && m_chartSelection) {
        Toolbar toolbar = new Toolbar();
        panel.appendChild(toolbar);
        int AD_Reference_Value_ID = DB.getSQLValue(null, "SELECT AD_Reference_ID FROM AD_Reference WHERE Name = ?", "PA_Goal ChartType");
        MLookupInfo info = MLookupFactory.getLookup_List(Env.getLanguage(Env.getCtx()), AD_Reference_Value_ID);
        MLookup mLookup = new MLookup(info, 0);
        WTableDirEditor editor = new WTableDirEditor("ChartType", false, false, true, mLookup);
        toolbar.appendChild(editor.getComponent());
        editor.addValueChangeListener(new ValueChangeListener() {

            public void valueChange(ValueChangeEvent evt) {
                Object value = evt.getNewValue();
                if (value == null || value.toString().trim().length() == 0)
                    return;
                JFreeChart chart = null;
                chart = builder.createChart(value.toString());
                if (chart != null)
                    render(chart);
            }
        });
    }
}

Example 9 with MLookup

use of org.compiere.model.MLookup in project adempiere by adempiere.

the class WWFActivity method initForm.

protected void initForm() {
    loadActivities();
    fAnswerList.setMold("select");
    bZoom.setImage(ServletFns.resolveThemeURL("~./images/Zoom16.png"));
    bOK.setImage(ServletFns.resolveThemeURL("~./images/Ok24.png"));
    MLookup lookup = MLookupFactory.get(Env.getCtx(), m_WindowNo, 0, 10443, DisplayType.Search);
    fForward = new WSearchEditor(lookup, Msg.translate(Env.getCtx(), "AD_User_ID"), "", true, false, true);
    init();
    display(-1);
}

Example 10 with MLookup

use of org.compiere.model.MLookup in project adempiere by adempiere.

the class ADServiceImpl method getWindowTabData.

public WindowTabDataDocument getWindowTabData(WindowTabDataReqDocument reqd) throws XFireFault {
    authenticate(webServiceName, "getWindowTabData");
    WindowTabDataReq req = reqd.getWindowTabDataReq();
    WindowTabDataDocument ret = WindowTabDataDocument.Factory.newInstance();
    WindowTabData wd = ret.addNewWindowTabData();
    DataSet ds = wd.addNewDataSet();
    WWindowStatus ws = WWindowStatus.get(WindowStatusMap, req.getWindowNo(), false, 0, false, 0);
    if (ws == null) {
        GridWindowVO wo = getWindowVO(req.getWindowNo(), req.getADWindowID(), req.getADMenuID());
        ws = new WWindowStatus(wo);
        WindowStatusMap.put(new Integer(req.getWindowNo()), ws);
        //!!!!!!!!!!
        ws.curTab.query(ws.mWindow.isTransaction());
        ws.curTab.navigate(0);
        ws.curTab.setSingleRow(true);
    }
    if (ws.curTab.getTabNo() != req.getPrevTabNo()) {
        ws.curTab.removeDataStatusListener(ws.ads);
        ws.curTab = ws.mWindow.getTab(req.getPrevTabNo());
        // false
        ws.curTab.query(ws.mWindow.isTransaction());
        ws.curTab.navigate(0);
        ws.updateRecIDMap();
    }
    /*
    	if (ws.curTab.getCurrentRow() != req.getPrevRecNo())  
    	{
    		if (req.getPrevRecNo() >=0)
    			ws.curTab.navigate( req.getPrevRecNo() );     		
    	}
    	*/
    // we assume that it RecordID
    int prevRecNo = ws.getRowNoFromRecordID(req.getPrevRecNo());
    if (ws.curTab.getCurrentRow() != prevRecNo) {
        if (prevRecNo >= 0)
            ws.curTab.navigate(prevRecNo);
    }
    WWindowStatus.changeTabIfNeeded(ws, req.getTabNo());
    if (req.getGetData()) {
        if (req.getFromZoom()) {
            WWindowStatus ws2 = WWindowStatus.get(WindowStatusMap, req.getFromZoomWindowID(), true, req.getFromZoomTabID(), true, req.getFromZoomRowID());
            System.out.println(ws2.curTab.getTableName());
            GridField field = ws2.curTab.getField(req.getFromZoomColumnName());
            ws2 = null;
            if (field == null)
                return null;
            MLookup lookup = (MLookup) field.getLookup();
            if (lookup == null)
                return null;
            //
            MQuery zoomQuery = lookup.getZoomQuery();
            Object value = field.getValue();
            if (value == null) {
                value = req.getFromZoomColumnValue();
            }
            //	If not already exist or exact value
            if (zoomQuery == null || value != null) {
                //	ColumnName might be changed in GridTab.validateQuery
                zoomQuery = new MQuery();
                zoomQuery.addRestriction(req.getFromZoomColumnName(), MQuery.EQUAL, value);
            }
            ws.curTab.setQuery(zoomQuery);
            //ws.curTab.query(ws.mWindow.isTransaction());
            // ADEMPIERE/COMPIERE
            // adempiere
            ws.curTab.query(false, 0, 0);
        //ws.curTab.query(false, 0); // compiere
        } else {
            DataRow findDR = req.getFindCriteria();
            MQuery currentQuery = ws.curTab.getQuery();
            MQuery newQuery = createQuery(ws.curTab.getTableName(), findDR);
            if (findDR.getFieldArray().length > 0) {
                //(!currentQuery.getWhereClause().equals( newQuery.getWhereClause() )) { // change the query for zak�adki
                ws.curTab.setQuery(newQuery);
                //ws.curTab.query(ws.mWindow.isTransaction());
                //ADEMPIERE/COMPIERE
                // adempiere
                ws.curTab.query(false, 0, 0);
            //ws.curTab.query(false, 0); // compiere
            }
        }
        int rc = 0;
        if (req.getRowCount() > 0)
            rc = req.getRowCount();
        else
            rc = ws.curTab.getRowCount();
        int initRowNo = 0;
        if (req.getRowStart() > 0)
            initRowNo = req.getRowStart();
        //ok
        int lastRow = Math.min(rc, initRowNo + MAX_ROWS);
        //initRowNo + 5; // only for testing
        wd.setNumRows(lastRow);
        //lastRow += initRowNo;
        // ok
        wd.setTotalRows(ws.curTab.getRowCount());
        //wd.setTotalRows( 5 ); // only for testing
        wd.setStartRow(initRowNo);
        Map<Integer, Integer> RecordIDMap = ws.getRecordIDMap();
        try {
            RecordIDMap.clear();
            for (int lineNo = initRowNo; lineNo < lastRow; lineNo++) {
                ws.curTab.navigate(lineNo);
                int recID = ws.curTab.getRecord_ID();
                RecordIDMap.put(recID, lineNo);
                DataRow dr = ds.addNewDataRow();
                //System.out.println("row "+lineNo);
                fillDataRow(dr, ws, false, false);
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        ;
        if (lastRow <= ws.curTab.getRowCount()) {
            //last row
            ws.updateRecIDMap();
        }
    }
    return ret;
}