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