applications/party/groovyScripts/visit/ShowVisits.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.
 */

import org.apache.ofbiz.entity.transaction.TransactionUtil
import org.apache.ofbiz.base.util.Debug
import org.apache.ofbiz.entity.util.EntityUtilProperties

module = "showvisits.groovy"

partyId = parameters.partyId
context.partyId = partyId

showAll = parameters.showAll ?:"false"
context.showAll = showAll

sort = parameters.sort
context.sort = sort

visitListIt = null
sortList = ["-fromDate"]
if (sort) sortList.add(0, sort)

boolean beganTransaction = false
try {
    beganTransaction = TransactionUtil.begin()

    viewIndex = Integer.valueOf(parameters.VIEW_INDEX  ?: 1)
    viewSize = parameters.VIEW_SIZE ?: EntityUtilProperties.getPropertyAsInteger("widget", "widget.form.defaultViewSize", 20)
    context.viewIndex = viewIndex
    context.viewSize = viewSize

    // get the indexes for the partial list
    lowIndex = (((viewIndex - 1) * viewSize) + 1)
    highIndex = viewIndex * viewSize

    if (partyId) {
        visitListIt = from("Visit").where("partyId", partyId).orderBy(sortList).cursorScrollInsensitive().maxRows(highIndex).distinct().queryIterator()
    } else if (showAll.equalsIgnoreCase("true")) {
        visitListIt = from("Visit").orderBy(sortList).cursorScrollInsensitive().maxRows(highIndex).distinct().queryIterator()
    } else {
        // show active visits
        visitListIt = from("Visit").where("thruDate", null).orderBy(sortList).cursorScrollInsensitive().maxRows(highIndex).distinct().queryIterator()
    }

    // get the partial list for this page
    visitList = visitListIt.getPartialList(lowIndex, viewSize)
    if (!visitList) {
        visitList = new ArrayList()
    }

    visitListSize = visitListIt.getResultsSizeAfterPartialList()
    if (highIndex > visitListSize) {
        highIndex = visitListSize
    }
    context.visitSize = visitListSize

    visitListIt.close()
} catch (Exception e) {
    String errMsg = "Failure in operation, rolling back transaction"
    Debug.logError(e, errMsg, module)
    try {
        // only rollback the transaction if we started one...
        TransactionUtil.rollback(beganTransaction, errMsg, e)
    } catch (Exception e2) {
        Debug.logError(e2, "Could not rollback transaction: " + e2.toString(), module)
    }
    // after rolling back, rethrow the exception
    throw e
} finally {
    // only commit the transaction if we started one... this will throw an exception if it fails
    TransactionUtil.commit(beganTransaction)
}

context.visitList = visitList
listSize = 0
if (visitList) {
    listSize = lowIndex + visitList.size()
}

if (listSize < highIndex) {
    highIndex = listSize
}
context.lowIndex = lowIndex
context.highIndex = highIndex
context.listSize = listSize