/** import record using X_I_ProductPlanning table */ private void importRecords() { for (X_I_ProductPlanning ipp : getRecords(false, p_IsImportOnlyNoErrors)) { if (ipp.getM_Product_ID() > 0 && ipp.getS_Resource_ID() > 0 && ipp.getM_Warehouse_ID() > 0) { importProductPlanning(ipp); } else if (ipp.getForecastValue() == null || ipp.getM_Forecast_ID() == 0) { String error = ""; if (ipp.getM_Product_ID() == 0) { error = error + " @M_Product_ID@ @NotFound@ ,"; } if (ipp.getS_Resource_ID() == 0) { error = error + " @S_Resource_ID@ @NotFound@ ,"; } if (ipp.getM_Warehouse_ID() == 0) { error = error + " @M_Waehouse_ID@ @NotFound@"; } ipp.setI_ErrorMsg(Msg.parseTranslation(getCtx(), error)); isImported = false; ipp.saveEx(); return; } if (ipp.getForecastValue() == null) { isImported = true; } else if (ipp.getM_Forecast_ID() > 0 && ipp.getM_Warehouse_ID() > 0 && ipp.getM_Product_ID() > 0 && ipp.getQty().signum() > 0) { importForecast(ipp); } else { String error = ""; if (ipp.getM_Forecast_ID() == 0) { error = error + " @M_Forecast_ID@ @NotFound@ ,"; } if (ipp.getM_Warehouse_ID() == 0) { error = error + " @M_Warehouse_ID@ @NotFound@ ,"; } if (ipp.getQty().signum() <= 0) { error = error + " @Qty@ @Error@"; } ipp.setI_ErrorMsg(Msg.parseTranslation(getCtx(), error)); isImported = false; ipp.saveEx(); return; } if (isImported) { ipp.setI_IsImported(true); ipp.setProcessed(true); ipp.saveEx(); } } }
/** fill IDs values based on Search Key */ private void fillIDValues() { for (X_I_ProductPlanning ppi : getRecords(false, p_IsImportOnlyNoErrors)) { if (ppi.getC_BPartner_ID() == 0) ppi.setC_BPartner_ID( getID( I_C_BPartner.Table_Name, I_C_BPartner.COLUMNNAME_Value + "=?", new Object[] {ppi.getBPartner_Value()})); if (ppi.getM_Product_ID() == 0) ppi.setM_Product_ID( getID( I_M_Product.Table_Name, I_M_Product.COLUMNNAME_Value + "=?", new Object[] {ppi.getProductValue()})); if (ppi.getM_Warehouse_ID() == 0) ppi.setM_Warehouse_ID( getID( I_M_Warehouse.Table_Name, I_M_Warehouse.COLUMNNAME_Value + "=?", new Object[] {ppi.getWarehouseValue()})); if (ppi.getAD_Org_ID() == 0) ppi.setAD_Org_ID( getID( I_AD_Org.Table_Name, I_AD_Org.COLUMNNAME_Value + "=?", new Object[] {ppi.getOrgValue()})); if (ppi.getDD_NetworkDistribution_ID() == 0) ppi.setDD_NetworkDistribution_ID( getID( I_DD_NetworkDistribution.Table_Name, I_DD_NetworkDistribution.COLUMNNAME_Value + "=?", new Object[] {ppi.getNetworkDistributionValue()})); if (ppi.getPP_Product_BOM_ID() == 0) ppi.setPP_Product_BOM_ID( getID( I_PP_Product_BOM.Table_Name, I_PP_Product_BOM.COLUMNNAME_Value + "=?", new Object[] {ppi.getProduct_BOM_Value()})); if (ppi.getM_Forecast_ID() == 0) ppi.setM_Forecast_ID( getID( I_M_Forecast.Table_Name, I_M_Forecast.COLUMNNAME_Name + "=?", new Object[] {ppi.getForecastValue()})); if (ppi.getS_Resource_ID() == 0) ppi.setS_Resource_ID( getID( I_S_Resource.Table_Name, I_S_Resource.COLUMNNAME_Value + "=? AND " + I_S_Resource.COLUMNNAME_ManufacturingResourceType + "=?", new Object[] {ppi.getResourceValue(), "PT"})); ppi.saveEx(); } }