/** * Import record using X_I_ProductPlanning table * * @param ipp X_I_ProductPlanning */ private void importPurchaseProductPlanning(X_I_ProductPlanning ipp) { MProduct product = MProduct.get(getCtx(), ipp.getM_Product_ID()); if (product.isPurchased()) { final StringBuffer whereClause = new StringBuffer(); whereClause.append(MProductPO.COLUMNNAME_M_Product_ID).append("=? AND "); whereClause.append(MProductPO.COLUMNNAME_C_BPartner_ID).append("=?"); MProductPO productPO = new Query(getCtx(), MProductPO.Table_Name, whereClause.toString(), get_TrxName()) .setClient_ID() .setParameters(new Object[] {ipp.getM_Product_ID(), ipp.getC_BPartner_ID()}) .first(); if (productPO == null) { productPO = new MProductPO(getCtx(), 0, get_TrxName()); } productPO.setAD_Org_ID(ipp.getAD_Org_ID()); productPO.setM_Product_ID(ipp.getM_Product_ID()); productPO.setC_BPartner_ID(ipp.getC_BPartner_ID()); productPO.setOrder_Min(ipp.getOrder_Min()); productPO.setOrder_Pack(ipp.getOrder_Pack()); productPO.setDeliveryTime_Promised(ipp.getDeliveryTime_Promised().intValue()); productPO.setVendorProductNo(ipp.getVendorProductNo()); productPO.saveEx(); } }