| /* |
| * Licensed to the Apache Software Foundation (ASF) under one |
| * or more contributor license agreements. See the NOTICE file |
| * distributed with this work for additional information |
| * regarding copyright ownership. The ASF licenses this file |
| * to you under the Apache License, Version 2.0 (the |
| * "License"); you may not use this file except in compliance |
| * with the License. You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, |
| * software distributed under the License is distributed on an |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| * KIND, either express or implied. See the License for the |
| * specific language governing permissions and limitations |
| * under the License. |
| */ |
| |
| package org.apache.ofbiz.product.supplier; |
| |
| import java.math.BigDecimal; |
| import java.util.Collection; |
| import java.util.HashMap; |
| import java.util.List; |
| import java.util.Map; |
| |
| import org.apache.ofbiz.base.util.Debug; |
| import org.apache.ofbiz.base.util.UtilDateTime; |
| import org.apache.ofbiz.base.util.UtilGenerics; |
| import org.apache.ofbiz.base.util.UtilMisc; |
| import org.apache.ofbiz.base.util.UtilValidate; |
| import org.apache.ofbiz.entity.Delegator; |
| import org.apache.ofbiz.entity.GenericEntityException; |
| import org.apache.ofbiz.entity.GenericValue; |
| import org.apache.ofbiz.entity.condition.EntityCondition; |
| import org.apache.ofbiz.entity.condition.EntityOperator; |
| import org.apache.ofbiz.entity.util.EntityQuery; |
| import org.apache.ofbiz.entity.util.EntityUtil; |
| import org.apache.ofbiz.product.product.ProductWorker; |
| import org.apache.ofbiz.service.DispatchContext; |
| import org.apache.ofbiz.service.ServiceUtil; |
| |
| /** |
| * Services for suppliers of products |
| */ |
| public class SupplierProductServices { |
| |
| public static final String module = SupplierProductServices.class.getName(); |
| public static final String resource = "ProductUiLabels"; |
| |
| /* |
| * Parameters: productId, partyId, currencyUomId, quantity |
| * Result: a List of SupplierProduct entities for productId, |
| * filtered by date and optionally by partyId, ordered with lowest price first |
| */ |
| public static Map<String, Object> getSuppliersForProduct(DispatchContext dctx, Map<String, ? extends Object> context) { |
| Map<String, Object> results = new HashMap<String, Object>(); |
| Delegator delegator = dctx.getDelegator(); |
| |
| GenericValue product = null; |
| String productId = (String) context.get("productId"); |
| String partyId = (String) context.get("partyId"); |
| String currencyUomId = (String) context.get("currencyUomId"); |
| BigDecimal quantity =(BigDecimal) context.get("quantity"); |
| String canDropShip = (String) context.get("canDropShip"); |
| try { |
| product = EntityQuery.use(delegator).from("Product").where("productId", productId).cache().queryOne(); |
| if (product == null) { |
| results = ServiceUtil.returnSuccess(); |
| results.put("supplierProducts",null); |
| return results; |
| } |
| List<GenericValue> supplierProducts = product.getRelated("SupplierProduct", null, null, true); |
| |
| // if there were no related SupplierProduct entities and the item is a variant, then get the SupplierProducts of the virtual parent product |
| if (supplierProducts.size() == 0 && product.getString("isVariant") != null && product.getString("isVariant").equals("Y")) { |
| String virtualProductId = ProductWorker.getVariantVirtualId(product); |
| GenericValue virtualProduct = EntityQuery.use(delegator).from("Product").where("productId", virtualProductId).cache().queryOne(); |
| if (virtualProduct != null) { |
| supplierProducts = virtualProduct.getRelated("SupplierProduct", null, null, true); |
| } |
| } |
| |
| // filter the list by date |
| supplierProducts = EntityUtil.filterByDate(supplierProducts, UtilDateTime.nowTimestamp(), "availableFromDate", "availableThruDate", true); |
| |
| // filter the list down by the partyId if one is provided |
| if (partyId != null) { |
| supplierProducts = EntityUtil.filterByAnd(supplierProducts, UtilMisc.toMap("partyId", partyId)); |
| } |
| |
| // filter the list down by the currencyUomId if one is provided |
| if (currencyUomId != null) { |
| supplierProducts = EntityUtil.filterByAnd(supplierProducts, UtilMisc.toMap("currencyUomId", currencyUomId)); |
| } |
| |
| // filter the list down by the minimumOrderQuantity if one is provided |
| if (quantity != null) { |
| //minimumOrderQuantity |
| supplierProducts = EntityUtil.filterByCondition(supplierProducts, EntityCondition.makeCondition("minimumOrderQuantity", EntityOperator.LESS_THAN_EQUAL_TO, quantity)); |
| } |
| |
| // filter the list down by the canDropShip if one is provided |
| if (canDropShip != null) { |
| supplierProducts = EntityUtil.filterByAnd(supplierProducts, UtilMisc.toMap("canDropShip", canDropShip)); |
| } |
| |
| //sort resulting list of SupplierProduct entities by price in ASCENDING order |
| supplierProducts = EntityUtil.orderBy(supplierProducts, UtilMisc.toList("lastPrice ASC")); |
| |
| results = ServiceUtil.returnSuccess(); |
| results.put("supplierProducts", supplierProducts); |
| } catch (GenericEntityException ex) { |
| Debug.logError(ex, ex.getMessage(), module); |
| return ServiceUtil.returnError(ex.getMessage()); |
| } catch (Exception ex) { |
| Debug.logError(ex, ex.getMessage(), module); |
| return ServiceUtil.returnError(ex.getMessage()); |
| } |
| return results; |
| } |
| |
| /* |
| * Parameters: partyId of a supplier and productFeatures, a Collection (usually List) of product features |
| * Service will convert each feature in the Collection, changing their idCode and description based on the |
| * SupplierProduct entity for that supplier party and feature, and return it as convertedProductFeatures |
| */ |
| public static Map<String, Object> convertFeaturesForSupplier(DispatchContext dctx, Map<String, ? extends Object> context) { |
| Map<String, Object> results = new HashMap<String, Object>(); |
| String partyId = (String) context.get("partyId"); |
| Collection<GenericValue> features = UtilGenerics.checkList(context.get("productFeatures")); |
| |
| try { |
| if (partyId != null && UtilValidate.isNotEmpty(features)) { |
| // loop through all the features, find the related SupplierProductFeature for the given partyId, and |
| // substitue description and idCode |
| for (GenericValue nextFeature: features) { |
| List<GenericValue> supplierFeatures = EntityUtil.filterByAnd(nextFeature.getRelated("SupplierProductFeature", null, null, false), |
| UtilMisc.toMap("partyId", partyId)); |
| GenericValue supplierFeature = null; |
| |
| if ((supplierFeatures != null) && (supplierFeatures.size() > 0)) { |
| supplierFeature = supplierFeatures.get(0); |
| if (supplierFeature.get("description") != null) { |
| nextFeature.put("description", supplierFeature.get("description")); |
| } |
| if (supplierFeature.get("idCode") != null) { |
| nextFeature.put("idCode", supplierFeature.get("idCode")); |
| } |
| // TODO: later, do some kind of uom/quantity conoversion with the UomConversion entity |
| } |
| } |
| } |
| results = ServiceUtil.returnSuccess(); |
| results.put("convertedProductFeatures", features); |
| } catch (GenericEntityException ex) { |
| Debug.logError(ex, ex.getMessage(), module); |
| return ServiceUtil.returnError(ex.getMessage()); |
| } |
| return results; |
| } |
| } |