/*
 * 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.base.util.UtilValidate
import org.apache.ofbiz.entity.condition.EntityCondition
import org.apache.ofbiz.entity.condition.EntityOperator
import org.apache.ofbiz.entity.util.EntityUtil

if ("Y".equals(parameters.noConditionFind)) {
    List exprListForParameters = []
    
    finAccountRoles = from("FinAccountRole").where("finAccountId", finAccountId, "roleTypeId", "DIVISION").filterByDate().queryList()
    finAccountPartyIds = EntityUtil.getFieldListFromEntityList(finAccountRoles, "partyId", true)
    finAccountPartyIds.add(organizationPartyId)
    partyCond = EntityCondition.makeCondition([EntityCondition.makeCondition("partyIdTo", EntityOperator.IN, finAccountPartyIds),
                                               EntityCondition.makeCondition("partyIdFrom", EntityOperator.IN, finAccountPartyIds)], EntityOperator.OR)
    statusCond = EntityCondition.makeCondition([EntityCondition.makeCondition("statusId", EntityOperator.EQUALS, "PMNT_RECEIVED"),
                                                EntityCondition.makeCondition("statusId", EntityOperator.EQUALS, "PMNT_SENT")], EntityOperator.OR)

    if (paymentMethodTypeId) {
    exprListForParameters.add(EntityCondition.makeCondition("paymentMethodTypeId", EntityOperator.EQUALS, paymentMethodTypeId))
    }
    if (fromDate) {
        exprListForParameters.add(EntityCondition.makeCondition("effectiveDate", EntityOperator.GREATER_THAN_EQUAL_TO, fromDate))
    }
    if (thruDate) {
        exprListForParameters.add(EntityCondition.makeCondition("effectiveDate", EntityOperator.LESS_THAN_EQUAL_TO, thruDate))
    }
    if (partyIdFrom) {
        exprListForParameters.add(EntityCondition.makeCondition("partyIdFrom", EntityOperator.EQUALS, partyIdFrom))
    }
    exprListForParameters.add(EntityCondition.makeCondition("finAccountTransId", EntityOperator.EQUALS, null))
    paramCond = EntityCondition.makeCondition(exprListForParameters, EntityOperator.AND)
    combinedPaymentCond = EntityCondition.makeCondition([partyCond, statusCond, paramCond], EntityOperator.AND)
    payments = from("PaymentAndTypePartyNameView").where(combinedPaymentCond).queryList()
    paymentListWithCreditCard = []
    paymentListWithoutCreditCard = []
    payments.each { payment ->
        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
    }
}