@extends('layouts.master')


@section('title', 'Balance Sheet')


@section('page-header')
    <i class="fa fa-info-circle"></i> Balance Sheet
@stop


@push('style')

    <link rel="stylesheet" href="{{ asset('assets/css/chosen.min.css') }}"/>
    <link rel="stylesheet" href="{{ asset('assets/css/bootstrap-datepicker3.min.css') }}"/>

    <style type="text/css">
        /*table, td, tr {*/
        /*    border: none !important;*/
        /*    background-color: transparent !important;*/
        /*}*/
        /*.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;*/
        /*}*/

        @media print
        {
            .no-print, .no-print *
            {
                display: none !important;
            }
        }

    </style>
@endpush


@section('content')
    <div class="row">
        <div class="col-12">

            @include('partials._alert_message')

            @php
                $from = request('from',date('Y-m-d'));
                $to = request('to',date('Y-m-d'));
            @endphp


            <div class="widget-box widget-color-white ui-sortable-handle clearfix" id="widget-box-7">


                <!-- heading -->
                <div class="widget-header widget-header-small ">
                    <h3 class="widget-title smaller text-primary">
                        @yield('page-header')
                    </h3>

                    <div class="widget-toolbar border smaller no-print">

                        <a href="" style="color: maroon !important;" onclick="window.print();">
                            <i class="fa fa-print bigger-110"></i> Print This
                        </a>

                    </div>

                    <div class="widget-toolbar border smaller no-print">
                        <a href="{{ request()->url() }}">
                            <i class="fa fa-refresh bigger-110"></i> Refresh
                        </a>
                    </div>

                    <div class="widget-toolbar border smaller no-print">

                        <a href="{{ request()->fullUrlWithQuery(['print' => 1, 'from' => $from, 'to' => $to]) }}" style="color: maroon !important;">
                            <i class="fa fa-print bigger-110"></i> Print
                        </a>
                    </div>
                </div>


                <div class="space"></div>




                <div class="row px-3 pb-2" style="width: 100%; margin: 0 !important;">
                    <form action="" method="get">


                        <div class="col-sm-4 col-sm-offset-1">
                            <div class="input-group">
                                <label class="input-group-addon">Company</label>
                                <select class="form-control chosen-select-100-percent" name="company_id" data-placeholder="-Select Company-">
                                    <option>All Companies</option>
                                    @foreach ($companies as $id => $name)
                                        <option value="{{ $id }}" {{ request('company_id') == $id ? 'selected' : '' }}>{{ $name }}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>

                        <div class="col-sm-3">
{{--                            @include('includes.input-groups.date-field', ['date' => $from, 'is_read_only' => true])--}}
                            @include('includes.input-groups.date-range', ['date' => $from, 'is_read_only' => true])
                        </div>

                        <div class="col-sm-2">
                            <div class="btn-group btn-corner no-print">
                                <button type="submit" class="btn btn-primary btn-sm"><i class="fa fa-search"></i> Search</button>
                            </div>
                        </div>

                    </form>
                </div>

                <!-- LIST -->
                <div class="row" style="width: 100%; margin: 0 !important;">
                    <div class="col-12 px-4">

                        @foreach($accountGroups->where('id', 1) as $key => $accountGroup)
                            <div class="row">
                                <div class="col-12">
                                    <h4>
                                        <strong>{{ $accountGroup->name }}</strong>
                                    </h4>
{{--                                    <table class="table table-bordered table-striped" style="margin-bottom: 0;">--}}
                                    <table class="table table-bordered " style="margin-bottom: 0; width: 100% !important; border-color: black !important;">
                                        <tbody>
                                        @php $totalBalance = 0; @endphp

                                        @foreach($accountGroup->accountControls as $accountControl)
                                            <tr style="color: black !important; font-weight: bolder;">
                                                <td style="border: 1px solid black">
                                                    <button class="btn btn-link" data-toggle="collapse" data-target="#collapse-{{ $key }}-{{ $accountControl->id }}" aria-expanded="false" aria-controls="collapse-{{ $key }}-{{ $accountControl->id }}">
                                                       <strong style="color: black">{{ $accountControl->name }}</strong>
                                                    </button>
                                                </td>
                                                @if ($accountGroup->balance_type == 'Debit')
                                                    @php $totalBalance += $balance = $accountControl->accounts->sum('debit_balance') - $accountControl->accounts->sum('credit_balance'); @endphp
                                                @else
                                                    @php $totalBalance += $balance = $accountControl->accounts->sum('credit_balance') - $accountControl->accounts->sum('debit_balance'); @endphp
                                                @endif
                                                <td width="150px" class="text-right pr-1" style="border: 1px solid black">{{ number_format($balance ?? 0, 2) }}</td>
                                            </tr>

                                            <tr id="collapse-{{ $key }}-{{ $accountControl->id }}" class="collapse" style="border: 1px solid black">
                                                <td colspan="2" style="border: 1px solid black">
                                                    <table class="table table-sm" style="border: 1px solid black">
                                                        <tbody>
                                                        @foreach($accountControl->accounts as $account)
                                                            @if(($account->debit_balance + $account->credit_balance) > 0)
                                                                <tr>
                                                                    <td  width="65%" style="border: 1px solid black">{{ $account->name }}</td>
                                                                    <td style="border: 1px solid black">{{ number_format($account->debit_balance - $account->credit_balance, 2) }}</td>
                                                                </tr>
                                                            @endif
                                                        @endforeach
                                                        </tbody>
                                                    </table>
                                                </td>
                                            </tr>
                                        @endforeach

                                        <tr>
                                            <td class="text-right" style="border: 1px solid black">
                                                <strong>Total {{ $accountGroup->name }}</strong>
                                            </td>
                                            <td class="text-right pr-1" style=" border: 1px solid black">
                                                <strong>{{ number_format($totalBalance, 2) }}</strong>
                                            </td>
                                        </tr>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        @endforeach

                        <div class="space-20"></div>

                            @php $totalBalance = 0; @endphp

                            @foreach($accountGroups->whereIn('id', [3]) as $key => $accountGroup)
                                <div class="row">
                                    <div class="col-12">
                                        @if($loop->first)
                                            <h4><strong style="color: black">{{ $accountGroup->name }}</strong></h4>
                                        @endif

                                        <table class="table table-bordered" style="margin-bottom: 0; width: 100% !important; border: 1px solid black !important;">
                                            <tbody>

                                            @foreach($accountGroup->accountControls as $accountControl)
                                                <tr style="border: 1px solid black">
                                                    <td style="border: 1px solid black">
                                                        <button class="btn btn-link" data-toggle="collapse" data-target="#collapse-{{ $key }}-{{ $accountControl->id }}" aria-expanded="false" aria-controls="collapse-{{ $key }}-{{ $accountControl->id }}">
                                                            <strong style="color: black">{{ $accountControl->name == 'None' && $accountGroup->id == 10 ? 'Accumulated Depreciation' : $accountControl->name }}</strong>
                                                        </button>
                                                    </td>

                                                    @if ($accountGroup->balance_type == 'Credit')
                                                        @php $totalBalance += $balance = $accountControl->accounts->sum('credit_balance') - $accountControl->accounts->sum('debit_balance'); @endphp
                                                    @else
                                                        @php $totalBalance += $balance = $accountControl->accounts->sum('debit_balance') - $accountControl->accounts->sum('credit_balance'); @endphp
                                                    @endif

                                                    <td width="150px" class="text-right pr-1" style="border: 1px solid black">{{ number_format($equity_balance ?? 0, 2) }}</td>
                                                </tr>

                                                <tr id="collapse-{{ $key }}-{{ $accountControl->id }}" class="collapse" style="border: 1px solid black">
                                                    <td colspan="2" style="border: 1px solid black">
                                                        <table class="table table-sm" style="border: 1px solid black">
                                                            <tbody>
                                                            @foreach($accountControl->accounts as $account)
                                                                @if(number_format($account->debit_balance + $account->credit_balance, 2) > 0)
                                                                    <tr style="border: 1px solid black">
                                                                        <td width="65%" style="border: 1px solid black">{{ $account->name }}</td>
                                                                        <td style="border: 1px solid black">{{ number_format($account->credit_balance - $account->debit_balance, 2) }}</td>
                                                                    </tr>
                                                                @endif
                                                            @endforeach
                                                            </tbody>
                                                        </table>
                                                    </td>
                                                </tr>
                                            @endforeach

                                            @if($loop->last)
                                                <tr style="border: 1px solid black">
                                                    <td class="text-right" style="border: 1px solid black !important;">
                                                        <strong>Retained Earnings (Net Income)</strong>
                                                    </td>
                                                    <td class="text-right pr-1" style="border: 1px solid black !important;">
                                                        <strong>{{ number_format($equity_balance - $totalBalance, 2) }}</strong>
                                                    </td>
                                                </tr>
                                                <tr style="border: 1px solid black">
                                                    <td class="text-right" style="border: 1px solid black">
                                                        <strong style="color: black">Total Equity Balance</strong>
                                                    </td>
                                                    <td class="text-right pr-1" style="border: 1px solid black">
                                                        <strong style="color: black">{{ number_format($equity_balance, 2) }}</strong>
                                                    </td>
                                                </tr>
                                            @endif
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            @endforeach


{{--                        <div class="row">--}}
{{--                            <div class="col-12">--}}
{{--                                <h4><strong>Owners Equity</strong></h4>--}}
{{--                                @php--}}
{{--                                    foreach($accountGroups->whereIn('id', [3]) as $key => $accountGroup){--}}
{{--                                        foreach($accountGroup->accountControls as $accountControl){--}}
{{--                                            dd($accountControl->accounts);--}}
{{--                                        }--}}
{{--                                    }--}}
{{--                                @endphp--}}
{{--                                <table class="table table-bordered table-striped" style="margin-bottom: 0;">--}}
{{--                                    <tbody>--}}
{{--                                    <tr>--}}
{{--                                        <td class="text-right">--}}
{{--                                            <strong>Total Equity Balance</strong>--}}
{{--                                        </td>--}}
{{--                                        <td class="text-right pr-1">--}}
{{--                                            <strong>{{ number_format($equity_balance, 2) }}</strong>--}}
{{--                                        </td>--}}
{{--                                    </tr>--}}
{{--                                    </tbody>--}}
{{--                                </table>--}}
{{--                            </div>--}}
{{--                        </div>--}}

                        @php $totalBalance = 0; @endphp

                        @foreach($accountGroups->whereIn('id', [2, 10]) as $key => $accountGroup)
                            <div class="row">
                                <div class="col-12">
                                    @if($loop->first)
                                        <h4><strong style="color: black">{{ $accountGroup->name }}</strong></h4>
                                    @endif

                                    <table class="table table-bordered"  style="margin-bottom: 0; width: 100% !important; border: 1px solid black !important;">
                                        <tbody>

                                        @foreach($accountGroup->accountControls as $accountControl)
                                            <tr style="border: 1px solid black">
                                                <td style="border: 1px solid black">
                                                    <button class="btn btn-link" data-toggle="collapse" data-target="#collapse-{{ $key }}-{{ $accountControl->id }}" aria-expanded="false" aria-controls="collapse-{{ $key }}-{{ $accountControl->id }}">
                                                        <strong style="color: black">{{ $accountControl->name == 'None' && $accountGroup->id == 10 ? 'Accumulated Depreciation' : $accountControl->name }}</strong>
                                                    </button>
                                                </td>

                                                @if ($accountGroup->balance_type == 'Debit')
                                                    @php $totalBalance += $balance = $accountControl->accounts->sum('debit_balance') - $accountControl->accounts->sum('credit_balance'); @endphp
                                                @else
                                                    @php $totalBalance += $balance = $accountControl->accounts->sum('credit_balance') - $accountControl->accounts->sum('debit_balance'); @endphp
                                                @endif

                                                <td width="150px" class="text-right pr-1" style="border: 1px solid black">{{ number_format($balance ?? 0, 2) }}</td>
                                            </tr>

                                            <tr id="collapse-{{ $key }}-{{ $accountControl->id }}" class="collapse" style="border: 1px solid black">
                                                <td colspan="2" style="border: 1px solid black">
                                                    <table class="table table-sm" style="border: 1px solid black">

                                                        <tbody>
                                                        @foreach($accountControl->accounts as $account)
                                                            @if(number_format($account->debit_balance + $account->credit_balance, 2) > 0)
                                                                <tr style="border: 1px solid black">
                                                                    <td width="65%" style="border: 1px solid black">{{ $account->name }}</td>
                                                                    <td style="border: 1px solid black">{{ number_format($account->debit_balance - $account->credit_balance, 2) }}</td>
                                                                </tr>
                                                            @endif
                                                        @endforeach
                                                        </tbody>
                                                    </table>
                                                </td>
                                            </tr>
                                        @endforeach

                                        @if($loop->last)
                                            <tr style="border: 1px solid black">
                                                <td class="text-right" style="border: 1px solid black">
                                                    <strong>Total Liabilities</strong>
                                                </td>
                                                <td class="text-right pr-1" style="border: 1px solid black">
                                                    <strong>{{ number_format($totalBalance, 2) }}</strong>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td class="text-right" style="border: 1px solid black">
                                                    <strong>Total Liabilities & Owners Equity</strong>
                                                </td>
                                                <td class="text-right pr-1" style="border: 1px solid black">
                                                    <strong>{{ number_format($totalBalance + $equity_balance, 2) }}</strong>
                                                </td>
                                            </tr>
                                        @endif
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        @endforeach

                        <br>
                    </div>

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

@section('js')
    <script src="{{ asset('assets/js/chosen.jquery.min.js') }}"></script>
    <script src="{{ asset('assets/js/bootstrap-datepicker.min.js') }}"></script>
    <script src="{{ asset('assets/custom_js/chosen-box.js') }}"></script>
    <script src="{{ asset('assets/custom_js/date-picker.js') }}"></script>
@endsection