| /* |
| * 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. |
| */ |
| |
| import org.apache.ofbiz.entity.condition.EntityCondition |
| |
| shipmentId = request.getParameter("shipmentId") |
| orderId = request.getParameter("orderId") |
| shipGroupSeqId = request.getParameter("shipGroupSeqId") |
| |
| if (!shipmentId) { |
| shipmentId = context.shipmentId |
| } |
| action = request.getParameter("action") |
| |
| shipment = null |
| if (shipmentId) { |
| shipment = from("Shipment").where("shipmentId", shipmentId).queryOne() |
| } |
| |
| |
| // ************************************** |
| // Order Items are searched also by shipGroupSeqId and put in orderItemShipGroupAssocs |
| // ************************************** |
| orderItemShipGroupAssocs = null |
| // ************************************** |
| // Search method: search by productId |
| // ************************************** |
| if (action && orderId) { |
| if (shipGroupSeqId) { |
| orderItemShipGroupAssocs = from("OrderItemShipGroupAssoc").where("orderId", orderId, "shipGroupSeqId", shipGroupSeqId).queryList() |
| } else { |
| orderItemShipGroupAssocs = from("OrderItemShipGroupAssoc").where("orderId", orderId).queryList() |
| } |
| } |
| |
| // ************************************** |
| // ShipmentPlan list form |
| // ************************************** |
| totWeight = 0 |
| totVolume = 0 |
| shipmentPlans = null |
| shipmentPlansIt = null |
| rows = [] as ArrayList |
| if (shipment) { |
| shipmentPlans = from("OrderShipment").where("shipmentId", shipment.shipmentId).queryList() |
| } |
| if (shipmentPlans) { |
| shipmentPlans.each { shipmentPlan -> |
| oneRow = new HashMap(shipmentPlan) |
| orderItem = shipmentPlan.getRelatedOne("OrderItem", false) |
| oneRow.productId = orderItem.productId |
| orderedQuantity = orderItem.getDouble("quantity") |
| canceledQuantity = orderItem.getDouble("cancelQuantity") |
| if (canceledQuantity) { |
| orderedQuantity = Double.valueOf(orderedQuantity.doubleValue() - canceledQuantity.doubleValue()) |
| } |
| oneRow.totOrderedQuantity = orderedQuantity.intValue() |
| |
| // Total quantity issued |
| issuedQuantity = 0.0 |
| qtyIssuedInShipment = [:] |
| issuances = orderItem.getRelated("ItemIssuance", null, null, false) |
| issuances.each { issuance -> |
| if (issuance.quantity) { |
| issuedQuantity += issuance.getDouble("quantity") |
| if (issuance.cancelQuantity) { |
| issuedQuantity -= issuance.getDouble("cancelQuantity") |
| } |
| if (qtyIssuedInShipment.containsKey(issuance.shipmentId)) { |
| qtyInShipment = ((Double)qtyIssuedInShipment.get(issuance.shipmentId)).doubleValue() |
| qtyInShipment += issuance.getDouble("quantity") |
| if (issuance.cancelQuantity) { |
| qtyInShipment -= issuance.getDouble("cancelQuantity") |
| } |
| qtyIssuedInShipment.put(issuance.shipmentId, qtyInShipment) |
| } else { |
| qtyInShipment = issuance.getDouble("quantity") |
| if (issuance.cancelQuantity) { |
| qtyInShipment -= issuance.getDouble("cancelQuantity") |
| } |
| qtyIssuedInShipment.put(issuance.shipmentId, qtyInShipment) |
| } |
| } |
| } |
| oneRow.totIssuedQuantity = issuedQuantity |
| // Total quantity planned not issued |
| plannedQuantity = 0.0 |
| qtyPlannedInShipment = [:] |
| plans = from("OrderShipment").where("orderId", orderItem.orderId, "orderItemSeqId", orderItem.orderItemSeqId).queryList() |
| plans.each { plan -> |
| if (plan.quantity) { |
| netPlanQty = plan.getDouble("quantity") |
| if (qtyIssuedInShipment.containsKey(plan.shipmentId)) { |
| qtyInShipment = ((Double)qtyIssuedInShipment.get(plan.shipmentId)).doubleValue() |
| if (netPlanQty > qtyInShipment) { |
| netPlanQty -= qtyInShipment |
| } else { |
| netPlanQty = 0 |
| } |
| } |
| plannedQuantity += netPlanQty |
| if (qtyPlannedInShipment.containsKey(plan.shipmentId)) { |
| qtyInShipment = ((Double)qtyPlannedInShipment.get(plan.shipmentId)).doubleValue() |
| qtyInShipment += netPlanQty |
| qtyPlannedInShipment.put(plan.shipmentId, qtyInShipment) |
| } else { |
| qtyPlannedInShipment.put(plan.shipmentId, netPlanQty) |
| } |
| } |
| } |
| oneRow.totPlannedQuantity = plannedQuantity |
| if (qtyIssuedInShipment.containsKey(shipmentId)) { |
| oneRow.issuedQuantity = qtyIssuedInShipment.get(shipmentId) |
| } else { |
| oneRow.issuedQuantity = "" |
| } |
| // Reserved and Not Available quantity |
| reservedQuantity = 0.0 |
| reservedNotAvailable = 0.0 |
| reservations = orderItem.getRelated("OrderItemShipGrpInvRes", null, null, false) |
| reservations.each { reservation -> |
| if (reservation.quantity) { |
| reservedQuantity += reservation.getDouble("quantity") |
| } |
| if (reservation.quantityNotAvailable) { |
| reservedNotAvailable += reservation.getDouble("quantityNotAvailable") |
| } |
| } |
| oneRow.notAvailableQuantity = reservedNotAvailable |
| |
| // Planned Weight and Volume |
| product = orderItem.getRelatedOne("Product", false) |
| weight = 0.0 |
| quantity = 0.0 |
| if (shipmentPlan.getDouble("quantity")) { |
| quantity = shipmentPlan.getDouble("quantity") |
| } |
| if (product.getDouble("productWeight")) { |
| weight = product.getDouble("productWeight") * quantity |
| } |
| oneRow.weight = weight |
| if (product.weightUomId) { |
| weightUom = from("Uom").where("uomId", product.weightUomId).queryOne() |
| oneRow.weightUom = weightUom.abbreviation |
| } |
| volume = 0.0 |
| if (product.getDouble("productHeight") && |
| product.getDouble("productWidth") && |
| product.getDouble("productDepth")) { |
| // TODO: check if uom conversion is needed |
| volume = product.getDouble("productHeight") * |
| product.getDouble("productWidth") * |
| product.getDouble("productDepth") * |
| quantity |
| } |
| oneRow.volume = volume |
| if (product.heightUomId && product.widthUomId && product.depthUomId) { |
| heightUom = from("Uom").where("uomId", product.heightUomId).cache(true).queryOne() |
| widthUom = from("Uom").where("uomId", product.widthUomId).cache(true).queryOne() |
| depthUom = from("Uom").where("uomId", product.depthUomId).cache(true).queryOne() |
| oneRow.volumeUom = heightUom.abbreviation + "x" + widthUom.abbreviation + "x" + depthUom.abbreviation |
| } |
| totWeight += weight |
| totVolume += volume |
| rows.add(oneRow) |
| } |
| } |
| |
| // ************************************** |
| // ShipmentPlan add form |
| // ************************************** |
| addRows = [] as ArrayList |
| if (orderItemShipGroupAssocs) { |
| orderItemShipGroupAssocs.each { orderItemShipGroupAssoc -> |
| orderItem = orderItemShipGroupAssoc.getRelatedOne("OrderItem", false) |
| oneRow = [:] |
| oneRow.shipmentId = shipmentId |
| oneRow.orderId = orderItemShipGroupAssoc.orderId |
| oneRow.orderItemSeqId = orderItemShipGroupAssoc.orderItemSeqId |
| oneRow.shipGroupSeqId = orderItemShipGroupAssoc.shipGroupSeqId |
| oneRow.productId = orderItem.productId |
| orderedQuantity = orderItemShipGroupAssoc.getDouble("quantity") |
| canceledQuantity = orderItemShipGroupAssoc.getDouble("cancelQuantity") |
| if (canceledQuantity) { |
| orderedQuantity = Double.valueOf(orderedQuantity.doubleValue() - canceledQuantity.doubleValue()) |
| } |
| oneRow.orderedQuantity = orderedQuantity |
| // Total quantity issued |
| issuedQuantity = 0.0 |
| qtyIssuedInShipment = [:] |
| issuances = orderItem.getRelated("ItemIssuance", null, null, false) |
| issuances.each { issuance -> |
| if (issuance.quantity) { |
| issuedQuantity += issuance.getDouble("quantity") |
| if (issuance.cancelQuantity) { |
| issuedQuantity -= issuance.getDouble("cancelQuantity") |
| } |
| if (qtyIssuedInShipment.containsKey(issuance.shipmentId)) { |
| qtyInShipment = ((Double)qtyIssuedInShipment.get(issuance.shipmentId)).doubleValue() |
| qtyInShipment += issuance.getDouble("quantity") |
| qtyIssuedInShipment.put(issuance.shipmentId, qtyInShipment) |
| } else { |
| qtyInShipment = issuance.getDouble("quantity") |
| if (issuance.cancelQuantity) { |
| qtyInShipment -= issuance.getDouble("cancelQuantity") |
| } |
| qtyIssuedInShipment.put(issuance.shipmentId, qtyInShipment) |
| } |
| } |
| } |
| oneRow.issuedQuantity = issuedQuantity |
| // Total quantity planned not issued |
| plannedQuantity = 0.0 |
| EntityCondition orderShipmentCondition = null |
| if (shipGroupSeqId) { |
| orderShipmentCondition = EntityCondition.makeCondition([orderId : orderItemShipGroupAssoc.orderId, orderItemSeqId : orderItemShipGroupAssoc.orderItemSeqId, shipGroupSeqId : orderItemShipGroupAssoc.shipGroupSeqId]) |
| } else { |
| orderShipmentCondition = EntityCondition.makeCondition([orderId : orderItemShipGroupAssoc.orderId, orderItemSeqId : orderItemShipGroupAssoc.orderItemSeqId]) |
| } |
| plans = from("OrderShipment").where(orderShipmentCondition).queryList() |
| plans.each { plan -> |
| if (plan.quantity) { |
| netPlanQty = plan.getDouble("quantity") |
| plannedQuantity += netPlanQty |
| } |
| } |
| oneRow.plannedQuantity = plannedQuantity |
| |
| // (default) quantity for plan |
| planQuantity = (orderedQuantity - plannedQuantity - issuedQuantity > 0? orderedQuantity - plannedQuantity - issuedQuantity: 0) |
| oneRow.quantity = planQuantity |
| |
| // Planned (unitary) Weight and Volume |
| weight = new Double(0) |
| product = orderItem.getRelatedOne("Product", false) |
| if (product.getDouble("productWeight")) { |
| weight = product.getDouble("productWeight") |
| } |
| oneRow.weight = weight |
| |
| if (product.weightUomId) { |
| weightUom = from("Uom").where("uomId", product.weightUomId).cache(true).queryOne() |
| oneRow.weightUom = weightUom.abbreviation |
| } |
| volume = 0.0 |
| if (product.getDouble("productHeight") && product.getDouble("productWidth") && product.getDouble("productDepth")) { |
| // TODO: check if uom conversion is needed |
| volume = product.getDouble("productHeight") * |
| product.getDouble("productWidth") * |
| product.getDouble("productDepth") |
| } |
| |
| oneRow.volume = volume |
| if (product.heightUomId && product.widthUomId && product.depthUomId) { |
| heightUom = from("Uom").where("uomId", product.heightUomId).cache(true).queryOne() |
| widthUom = from("Uom").where("uomId", product.widthUomId).cache(true).queryOne() |
| depthUom = from("Uom").where("uomId", product.depthUomId).cache(true).queryOne() |
| oneRow.volumeUom = heightUom.abbreviation + "x" + widthUom.abbreviation + "x" + depthUom.abbreviation |
| } |
| addRows.add(oneRow) |
| } |
| } |
| |
| context.listShipmentPlanRows = rows |
| context.addToShipmentPlanRows = addRows |
| context.rowCount = addRows.size() |
| context.shipmentId = shipmentId |
| context.shipment = shipment |
| context.totWeight = totWeight |
| context.totVolume = totVolume |
