@php
$totalSalesReport = $sales->whereBetween('sale_date',[$to,$from])->sum('total_paid');

$cashTransRcvTotalReport=$cashTrans->whereBetween('date',[$to,$from])->where('transaction_type', 'recieve')->sum('received_amount');
$cashTransPaidReport =$cashTrans->whereBetween('date',[$to,$from])->where('transaction_type','payment')->sum('paid_amount');

$bankTransTotalDepositReport=$bankTransactions->whereBetween('transaction_date',[$to,$from])->where('transaction_type', 'deposit')->sum('deposit');
$bankTransTotalWithdrawReport=$bankTransactions->whereBetween('transaction_date',[$to,$from])->where('transaction_type', 'withdraw')->sum('withdraw');

$PurchasetotalPaidReport=$purchases->whereBetween('purchase_date',[$to,$from])->sum('total_paid');

$totalPaidToSupplierReport=$supplier_payments->whereBetween('date',[$to,$from])->where('transaction_type', 'payment')->sum('amount');
$totalRcvToSupplierReport=$supplier_payments->whereBetween('date',[$to,$from])->where('transaction_type', 'recieve')->sum('amount');

$totalPaidCustomerReport=$customer_payments->whereBetween('date',[$to,$from])->where('transaction_type', 'payment')->sum('amount');
$totalRcvCustomerReport=$customer_payments->whereBetween('date',[$to,$from])->where('transaction_type', 'recieve')->sum('amount');

$totalSalary=$salary_payment->whereBetween('date',[$to,$from])->sum('payment_amount');

$cashInReport = $totalSalesReport+$cashTransRcvTotalReport+$bankTransTotalDepositReport+$totalRcvToSupplierReport+$totalRcvCustomerReport;
$cashOutReport = $totalPaidCustomerReport+$totalPaidToSupplierReport+$PurchasetotalPaidReport+$bankTransTotalWithdrawReport+$cashTransPaidReport+$totalSalary;
@endphp
<div id="printContent">
    <div class="row" style="margin-top: 15px;">
        <div class="col-xs-6">
            <table class="balancesheet-table">
                <thead>
                    <tr>
                        <td colspan="2">
                            <h3>Cash In</h3>
                        </td>
                    </tr>
                </thead>
                <tbody>
                    <tr>
                        <td>Total Sales</td>
                        <td style="text-align: right;">{{number_format($totalSalesReport,2)}}</td>
                    </tr>
                    <tr>
                        <td>Customer Payment Received</td>
                        <td style="text-align: right;">{{number_format($totalRcvCustomerReport,2)}}</td>
                    </tr>
                    <tr>
                        <td>Cash Received</td>
                        <td style="text-align: right;">{{number_format($cashTransRcvTotalReport,2)}}</td>
                    </tr>
                    <tr>
                        <td>Withdraw from Bank</td>
                        <td style="text-align: right;">{{number_format($bankTransTotalWithdrawReport,2)}}</td>
                    </tr>
                    <tr>
                        <td>Supplier Payment Received</td>
                        <td style="text-align: right;">{{number_format($totalRcvToSupplierReport,2)}}</td>
                    </tr>
                </tbody>
                <tfoot>
                    <tr>
                        <td style="text-align: right;">Total Cash In</td>
                        <td style="text-align: right;">{{number_format($cashInReport,2)}}</td>
                    </tr>
                </tfoot>
            </table>
        </div>
        <div class="col-xs-6">
            <table class="balancesheet-table">
                <thead>
                    <tr>
                        <td colspan="2">
                            <h3>Cash Out</h3>
                        </td>
                    </tr>
                </thead>
                <tbody>
                    <tr>
                        <td>Total Purchase</td>
                        <td style="text-align: right;">{{number_format($PurchasetotalPaidReport,2)}}</td>
                    </tr>
                    <tr>
                        <td>Supplier Payment Paid</td>
                        <td style="text-align: right;">{{number_format($totalPaidToSupplierReport,2)}}</td>
                    </tr>
                    <tr>
                        <td>Cash Paid</td>
                        <td style="text-align: right;">{{number_format($cashTransPaidReport,2)}}</td>
                    </tr>
                    <tr>
                        <td>Deposit to Bank</td>
                        <td style="text-align: right;">{{number_format($bankTransTotalDepositReport,2)}}</td>
                    </tr>
                    <tr>
                        <td>Employee Payment</td>
                        <td style="text-align: right;">{{number_format($totalSalary,2)}}</td>
                    </tr>
                    <tr>
                        <td>Customer Payment Paid</td>
                        <td style="text-align: right;">{{number_format($totalPaidCustomerReport,2)}}</td>
                    </tr>
                </tbody>
                <tfoot>
                    <tr>
                        <td style="text-align: right;">Total Cash Out</td>
                        <td style="text-align: right;">{{number_format($cashOutReport,2)}}</td>
                    </tr>
                </tfoot>
            </table>
        </div>
    </div>
    <div class="row" style="margin-top: 15px;">
        <div class="col-xs-12">
            <div style="padding: 5px; background-color: rgb(226, 122, 7); text-align: center; color: white;">
                <h4 style="color: white">Cash Balance: {{number_format(($cashInReport-$cashOutReport),2)}}</h4>
            </div>
        </div>
    </div>
</div>