@extends('layouts.dashboard')
@section('title-content')
    <title>{{ config('app.name') }} | Billing Info </title>
@endsection
@section('content')
    <div class="row">
        <div class="col-md-12">
            <div class="boxpane">
                <div class="boxpane-header">
                    <h2 class="blue"><i class="fa-fw fa fa-usd"></i>Billing Info's</h2>

                </div>
                <div class="boxpane-content">
                    <div class="row">
                        <div class="col-sm-12">
                            <p class="introtext">
                                Particulars Below shows the Bills and Payment Schedules for the Current Academic Year
                            </p>
                            <div class="table-responsive">
                                <table id="" class="table table-bordered table-hover"
                                    style="width: 100%;border-left:0px solid #ccc!important;border-right:0px solid #ccc!important;border-top:0px solid #ccc!important;">

                                    <tr style="border-collapse: collapse;">
                                        <td
                                            style="font-weight: 800 !important;border:0px solid #ccc!important;background-color:#ccc;">
                                            Date</td>
                                        <td
                                            style="font-weight: 800 !important;border:0px solid #ccc!important;background-color:#ccc;">
                                            Description</td>
                                        <td
                                            style="font-weight: 800 !important;border:0px solid #ccc!important;background-color:#ccc;">
                                            Control Number</td>
                                        <td
                                            style="font-weight: 800 !important;border:0px solid #ccc!important;background-color:#ccc;">
                                            Transaction</td>
                                        <td
                                            style="font-weight: 800 !important;border:0px solid #ccc!important;background-color:#ccc;">
                                            Debit</td>
                                        <td
                                            style="font-weight: 800 !important;border:0px solid #ccc!important;background-color:#ccc;">
                                            Credit</td>
                                        <td
                                            style="font-weight: 800 !important;border:0px solid #ccc!important;background-color:#ccc;">
                                            Balance</td>
                                        <td
                                            style="font-weight: 800 !important;border:0px solid #ccc!important;background-color:#ccc;">
                                            Action</td>
                                    </tr>
                                    <!-- <img src="{{ Auth::user()->present()->avatar }}" alt="{{ Auth::user()->present()->userName }}" class="rounded-circle"> -->
                                    @if (count($main_bill) < 1)
                                        <tr>
                                            <td colspan="7"
                                                style="font-weight: 800 !important;border:0px solid #ccc!important;text-align:center;color:red;">
                                                <h4>No Data Found for the specified Academic Year</h4>
                                            </td>
                                        </tr>
                                    @endif
                                    @foreach ($main_bill as $key)
                                        @php
                                            $balance = 0;
                                            
                                        @endphp


                                        @if ($trans_bill_info->where('account_code', $key->account_code)->count() > 0)
                                            <tr>
                                                <td colspan="7"
                                                    style="font-weight: 1000 !important;border:0px solid #ccc!important;">
                                                    <h4>{{ $key->account_code }}: {{ $key->gfs_code_description }}</h4>
                                                </td>
                                            </tr>
                                        @endif
                                        @foreach ($trans_bill_info->where('account_code', $key->account_code) as $vey)
                                            @php
                                                if ($vey->credit == 0) {
                                                    $balance = $balance + $vey->debit;
                                                } else {
                                                    $balance = $balance - $vey->credit;
                                                }
                                                
                                            @endphp
                                            @if ($vey->credit == 0)
                                                <tr>
                                                    <td style="border:0px solid #ccc!important;">{{ $vey->date }}</td>
                                                    <td style="border:0px solid #ccc!important;">{{ $vey->description }}
                                                    </td>
                                                    <td style="border:0px solid #ccc!important;">{{ $vey->controlno }}</td>
                                                    <td style="border:0px solid #ccc!important;">{{ $vey->transaction }}
                                                    </td>
                                                    <td style="border:0px solid #ccc!important;">
                                                        {{ number_format($vey->debit) }}</td>
                                                    <td style="border:0px solid #ccc!important;">
                                                        {{ number_format($vey->credit) }}</td>
                                                    <td style="border:0px solid #ccc!important;">
                                                        {{ number_format($balance) }}</td>
                                                </tr>
                                            @endif
                                            @if ($vey->credit != 0)
                                                <tr>
                                                    <td style="border:0px solid #ccc!important;">{{ $vey->date }}</td>
                                                    <td style="border:0px solid #ccc!important;">{{ $vey->description }}
                                                    </td>
                                                    <td style="border:0px solid #ccc!important;">{{ $vey->controlno }}</td>
                                                    <td style="border:0px solid #ccc!important;">{{ $vey->transaction }}
                                                    </td>
                                                    <td style="border:0px solid #ccc!important;">
                                                        {{ number_format($vey->debit) }}</td>
                                                    <td style="border:0px solid #ccc!important;">
                                                        {{ number_format($vey->credit) }}</td>
                                                    <td style="border:0px solid #ccc!important;">
                                                        {{ number_format($balance) }}</td>
                                                    <td style="border:0px solid #ccc!important;"> {!! Form::open([
                                                        'route' => 'transaction.printTransaction',
                                                        'method' => 'POST',
                                                        'enctype' => 'multipart/form-data',
                                                    ]) !!}
                                                        <input name="tnx_id" id="tnx_id" hidden
                                                            value="{{ $vey->trx_id }}">

                                                        <button type="submit" class="btn btn-md btn-success mr-3"><i
                                                                class="fa fa-download"></i>&nbsp;Receipt
                                                        </button>

                                                        {!! Form::close() !!}
                                                    </td>
                                                </tr>
                                            @endif
                                        @endforeach
                                    @endforeach
                                </table>
                            </div>

                        </div>

                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection