001// --------------------------------------------------------------------------------
002// Copyright 2002-2026 Echo Three, LLC
003//
004// Licensed under the Apache License, Version 2.0 (the "License");
005// you may not use this file except in compliance with the License.
006// You may obtain a copy of the License at
007//
008//     http://www.apache.org/licenses/LICENSE-2.0
009//
010// Unless required by applicable law or agreed to in writing, software
011// distributed under the License is distributed on an "AS IS" BASIS,
012// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
013// See the License for the specific language governing permissions and
014// limitations under the License.
015// --------------------------------------------------------------------------------
016
017package com.echothree.model.control.accounting.server.database;
018
019import com.echothree.model.data.accounting.server.entity.Transaction;
020import com.echothree.util.server.persistence.BaseDatabaseQuery;
021import com.echothree.util.server.persistence.EntityPermission;
022import com.echothree.util.server.persistence.Session;
023import java.util.List;
024
025public class TransactionBalancedQuery
026        extends BaseDatabaseQuery<TransactionBalancedResult> {
027
028    public TransactionBalancedQuery() {
029        super("""
030                SELECT SUM(trxglent_originalcredit) - SUM(trxglent_originaldebit) AS OriginalDifference,
031                SUM(trxglent_credit) - SUM(trxglent_debit) AS Difference
032                FROM transactionglentries
033                WHERE trxglent_trx_transactionid = ?
034                AND trxglent_thrutime = ?
035                """, EntityPermission.READ_ONLY);
036    }
037
038    public List<TransactionBalancedResult> execute(final Transaction transaction) {
039        return super.execute(transaction, Session.MAX_TIME);
040    }
041
042}