specialpurpose/hhfacility/groovyScripts/ProductStockTake.groovy

/*
 * 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.
 */

productId = request.getParameter("productId")
if (!productId) {
    productId = session.getAttribute("productId")
}

if (productId) {
    product = from("Product").where("productId", productId).cache(true).queryOne()
    context.product = product

    facilityId = request.getParameter("facilityId")
    resultOutput = runService('getInventoryAvailableByFacility', [productId : productId, facilityId : facilityId])
    quantitySummary = [:]
    quantitySummary.facilityId = facilityId
    quantitySummary.atp_qoh = ((Double)resultOutput.availableToPromiseTotal).intValue() + " / " +
            ((Double)resultOutput.quantityOnHandTotal).intValue()
    context.quantitySummary = quantitySummary

    // For now this just generates a visual list of locations set against the product for this facility.
    // todo: Will need to be able to edit and change these values at some point in the future.
    productFacilityLocList = from("ProductFacilityLocation").where("productId", productId, "facilityId", facilityId).queryList()
    facStr = null
    productFacilityLocList.each { facilityLoc ->
        if (!facStr) {
            facStr = facilityLoc.locationSeqId
        } else {
            facStr = facStr + ", " + facilityLoc.locationSeqId
        }
    }
    context.productFacilityLocations = facStr


    // Now we build a list of locations for inventory items against the facility.
    // todo: change this to a select from inv_items where productId and facilityId matches distinct (locationSeqId).
    invItemList = from("InventoryItem").where("productId", productId, "facilityId", facilityId).queryList()

    locations = [:]

    boolean negativeQOH = false
    invItemList.each { invItem ->
        int qoh = ((Double)invItem.quantityOnHandTotal).intValue()
        if (qoh < 0) {
            negativeQOH = true
        }
        locationFound = (String)invItem.locationSeqId
        if (!locationFound) {
            locationFound = "nullField"
        }
        if (!locations.get(locationFound)) {
            locations.put(locationFound, locationFound)
        }
    }

    // Go through and build the list of atp/qoh against each location
    productFacilityLocations = new ArrayList()
    locationsIter = locations.keySet().iterator()
    while (locationsIter.hasNext()) {
        location = locationsIter.next()
        resultOutput = runService('getInventoryAvailableByLocation', [productId : productId, facilityId : facilityId, locationSeqId : location])
        quantitySummary = [:]
        quantitySummary.productId = productId
        quantitySummary.facilityId = facilityId
        if ("nullField".equals( location ) == true) {
            quantitySummary.locationSeqId = ""
        } else {
            quantitySummary.locationSeqId = location
        }
        quantitySummary.atp_qoh = ((Double)resultOutput.availableToPromiseTotal).intValue() + " / " +
                ((Double)resultOutput.quantityOnHandTotal).intValue()
        productFacilityLocations.add(quantitySummary)
    }

    context.productQtyByLocations = productFacilityLocations
    if (negativeQOH) {
        context.negativeQOH = "true"
    }
}