release14.12/applications/accounting/webapp/ar/WEB-INF/actions/BatchPayments.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.ofbiz.accounting.util.UtilAccounting
import org.ofbiz.base.util.UtilValidate;
import org.ofbiz.entity.util.EntityUtil;
import org.ofbiz.entity.condition.EntityCondition;
import org.ofbiz.entity.condition.EntityOperator;
if ("Y".equals(parameters.noConditionFind)) {
    List paymentCond = [];
    payments = [];
    finAccountId = parameters.finAccountId;
    context.finAccountId = parameters.finAccountId;
    paymentStatusCond = EntityCondition.makeCondition([EntityCondition.makeCondition("statusId", EntityOperator.EQUALS, "PMNT_RECEIVED"),
                                EntityCondition.makeCondition("statusId", EntityOperator.EQUALS, "PMNT_SENT")], EntityOperator.OR);
    paymentCond.add(paymentStatusCond);
    if (paymentMethodTypeId) {
        paymentCond.add(EntityCondition.makeCondition("paymentMethodTypeId", EntityOperator.EQUALS, paymentMethodTypeId));
    }
    if (fromDate) {
        paymentCond.add(EntityCondition.makeCondition("effectiveDate", EntityOperator.GREATER_THAN_EQUAL_TO, fromDate));
    }
    if (thruDate) {
        paymentCond.add(EntityCondition.makeCondition("effectiveDate", EntityOperator.LESS_THAN_EQUAL_TO, thruDate));
    }
    if (partyIdFrom) {
        paymentCond.add(EntityCondition.makeCondition("partyIdFrom", EntityOperator.EQUALS, partyIdFrom));
    }
    if (finAccountId) {
        finAccountTransList = from("FinAccountTrans").where("finAccountId", finAccountId).queryList();
        if (finAccountTransList) {
            finAccountTransIds = EntityUtil.getFieldListFromEntityList(finAccountTransList, "finAccountTransId", true);
            paymentCond.add(EntityCondition.makeCondition("finAccountTransId", EntityOperator.IN, finAccountTransIds));
            payments = from("PaymentAndTypePartyNameView").where(paymentCond).queryList();
        }
    } else {
        paymentCond.add(EntityCondition.makeCondition("finAccountTransId", EntityOperator.EQUALS, null));
        payments = from("PaymentAndTypePartyNameView").where(paymentCond).queryList();
    }
    paymentListWithCreditCard = [];
    paymentListWithoutCreditCard = [];
    if (payments) {
        payments.each { payment ->
            isReceipt = UtilAccounting.isReceipt(payment);
            if (isReceipt) {
                paymentGroupMembers = from("PaymentGroupMember").where("paymentId", payment.paymentId).filterByDate().queryList();
                if (!paymentGroupMembers) {
                    if (cardType && payment.paymentMethodId) {
                        creditCard = from("CreditCard").where("paymentMethodId", payment.paymentMethodId).queryOne();
                        if (creditCard.cardType == cardType) {
                            paymentListWithCreditCard.add(payment);
                        }
                    } else if (UtilValidate.isEmpty(cardType)) {
                        paymentListWithoutCreditCard.add(payment);
                    }
                }
            }
        }
        if (paymentListWithCreditCard) {
            context.paymentList = paymentListWithCreditCard;
        } else {
            context.paymentList = paymentListWithoutCreditCard;
        }
    }
}