@extends('layouts.master')
@section('title', 'Cash View')
@push('css')
    <link rel="stylesheet" href="{{ asset('backend/css/style.css') }}">
    <style>
        .table>tbody>tr>td,
        .table>tbody>tr>th,
        .table>tfoot>tr>td,
        .table>tfoot>tr>th,
        .table>thead>tr>td,
        .table>thead>tr>th {
            padding: 3px 8px;
        }

    </style>
@endpush

@section('content')
    <div id="cashView">
        <div class="row">
            <div class="col-md-4">
                <div class="balance-section">
                    <i class="fa fa-money fa-3x"></i>
                    <h3>Cash Balance</h3>
                    <h1>BDT {{ number_format($totalCashTransaction, 2) }}</h1>
                </div>
            </div>

            <div class="col-md-4">
                <div class="balance-section">
                    <i class="fa fa-bank fa-3x"></i>
                    <h3>Bank Balance</h3>
                    <h1>BDT {{ number_format($totalBankTransaction, 2) }}</h1>
                </div>
            </div>

            <div class="col-md-4">
                <div class="balance-section">
                    <i class="fa fa-dollar fa-3x"></i>
                    <h3>Total Balance</h3>
                    <h1>BDT {{ number_format($totalBankTransaction + $totalCashTransaction, 2) }}</h1>
                </div>
            </div>
        </div>

        <div class="row" style="margin-top: 25px;">

            @foreach ($allBankAccount as $account)
                @php
                    $bankTransWithdraw = $account->bankTrans->where('transaction_type', 'withdraw')->sum('withdraw');
                    $bankTransDeposit = $account->bankTrans->where('transaction_type', 'deposit')->sum('deposit');

                    $CustomerbankTransPayment = $account->customerPayment
                        ->where('payment_type', 'bank')
                        ->where('transaction_type', 'payment')
                        ->sum('amount');
                    $CustomerbankTransRecieve = $account->customerPayment
                        ->where('payment_type', 'bank')
                        ->where('transaction_type', 'recieve')
                        ->sum('amount');

                    $supplierBankTransPayment = $account->supplierPayment
                        ->where('payment_type', 'bank')
                        ->where('transaction_type', 'payment')
                        ->sum('amount');
                    $supplierBankTransRecieve = $account->supplierPayment
                        ->where('payment_type', 'bank')
                        ->where('transaction_type', 'recieve')
                        ->sum('amount');

                    $totalCash = $bankTransDeposit + $CustomerbankTransRecieve + $supplierBankTransRecieve + $account->initial_balance - ($supplierBankTransPayment + $CustomerbankTransPayment + $bankTransWithdraw);
                @endphp
                <div class="col-md-3">
                    <div class="account-section">
                        <div class="col1">
                            <i class="fa fa-dollar fa-3x"></i>
                        </div>
                        <div class="col2">
                            {{ $account->account_name }}<br>
                            {{ $account->account_number }}<br>
                            {{ $account->bank_name }} <h3>BDT {{ number_format($totalCash, 2) }}</h3>
                        </div>
                    </div>
                </div>
            @endforeach


        </div>
    </div>
@endsection

@push('js')

@endpush