@extends('layouts.master')


@section('title', 'Receive-Payment')

@section('page-header')
    <i class="fa fa-info-circle"></i> Receive-Payment
@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">

        @media print {

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

            .d-print {
                display: block !important;
            }

            .widget-box {
                border: none !important;
                margin: 0 !important;
                padding: 0 !important;
                width: 100% !important;
            }
        }

        .d-print {
            display: none;
        }

    </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

                <!-- heading -->
            <div class="widget-box widget-color-white ui-sortable-handle clearfix" id="widget-box-7"
                 style="width: 100%; margin: auto">
                <div class="widget-header widget-header-small no-print">
                    <h3 class="widget-title smaller text-primary">
                        @yield('page-header')
                    </h3>

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

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

                        <a href="#" onclick="print()" class="text-danger" style="cursor: pointer">
                            <i class="fa fa-print bigger-110"></i> Print
                        </a>
                    </div>
                </div>


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

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

                        <div class="col-sm-3 col-sm-offset-2">
                            <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></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])--}} {{-- OLD CODE --}}
                            {{--                            @include('includes.input-groups.date-range', ['date' => $from, 'is_read_only' => true])--}}  {{-- New CODE --}}
                            @php
                                $date1 = isset($from) ? $from : '';
                                $date2 = isset($to) ? $to : '';
                                $isReadOnly = isset($is_read_only) ? $is_read_only : false;
                            @endphp

                            <div class="input-daterange input-group">
                                <span class="input-group-addon" style="border-left: 1px solid #ccc;">
                                    Date
                                </span>

                                <input type="text" name="from" class="input-sm form-control date-picker" value="{{ fdate(request('from')) }}" autocomplete="off" placeholder="From" style="cursor: pointer" {{ $isReadOnly ? 'readonly' : '' }} >

                                <span class="input-group-addon">
                                    <i class="fa fa-exchange"></i>
                                </span>

{{--                                <input type="text" name="to" class="input-sm form-control date-picker" value="{{ fdate($date2) }}" autocomplete="off" placeholder="To" style="cursor: pointer"{{ $isReadOnly ? 'readonly' : '' }}>--}}
                                <input type="text" name="to" class="input-sm form-control date-picker" value="{{ fdate(request('to')) }}" autocomplete="off" placeholder="To" style="cursor: pointer"{{ $isReadOnly ? 'readonly' : '' }}>
                            </div>


                        </div>

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

                    </form>
                </div>

                <div class="text-right d-print">
                    <h3 class="text-center d-print">Receive-Payment Report</h3>
                    @if(request('to') && request('from'))
                        <p class=" d-print">From : {{ fdate(request('from'), 'd/m/Y') }}</p>
                        <p class=" d-print">To : {{ fdate(request('to'), 'd/m/Y') }}</p>
{{--                    @elseif(fdate(request('to') ?? today(), 'd/m/Y'))--}}
{{--                        <p class=" d-print">As On {{ fdate(request('to') ?? today(), 'd/m/Y') }}</p>--}}
                    @endif
                </div>

                <!-- LIST -->
                <div class="row" style="width: 100%; margin: 0 !important; padding: 0 !important;">

                    <div class="col-12">
                        <div class="container-fluid">
                            <table class="table table-bordered" style="border: 1px solid black">
                                <thead style="border: 1px solid black">
                                <tr  style="background: white">
                                    <th class="text-left" style="color: black;border: 1px solid black">Account Code</th>
                                    <th class="text-left" style="color: black;border: 1px solid black">Account Name</th>
                                    <th class="text-right" style="color: black; border: 1px solid black">Receive</th>
                                    <th class="text-right" style="color: black; border: 1px solid black">Payments</th>
                                </tr>
                                </thead>
                                <tbody>
                                @php
                                    $totalPayments = 0;
                                    $totalReceive = 0;

                                    $totalPayments_previous = 0;
                                    $totalReceive_previous = 0;

                                    $diff_payment = 0;
                                    $diff_receive = 0;

                                foreach ($previous_accountGroups as $group) {
                                    foreach ($group->accountControls as $control) {
                                        foreach ($control->accountSubsidiaries as $subsidiary) {
                                            foreach ($subsidiary->accounts as $account) {
                                                $totalPayments_previous += $account->payments;
                                                $totalReceive_previous += $account->receive;
                                            }
                                        }
                                    }
                                }

                                @endphp

                                @if(($totalReceive_previous >= $totalPayments_previous))
                                    <tr style="color: black; border: 1px solid black">
                                        <td style="color: black; border: 1px solid black"></td>
                                        <td style="color: black; border: 1px solid black">Opening CashInHand:</td>
                                        <td style="color: black; border: 1px solid black"></td>
                                        <td style="color: black; border: 1px solid black"></td>
                                    </tr>
                                    <tr style="color: black; border: 1px solid black">
                                        <td style="color: black; border: 1px solid black"></td>
                                        <td style="color: black; border: 1px solid black">Opening CashAtBank:</td>
                                        <td class="text-right" style="color: black; border: 1px solid black">{{number_format($totalReceive_previous - $totalPayments_previous, 2)}}</td>
                                        <td style="color: black; border: 1px solid black"></td>
                                    </tr>
                                @elseif($totalReceive_previous <= $totalPayments_previous)
                                    <tr style="color: black; border: 1px solid black">
                                        <td style="color: black; border: 1px solid black"></td>
                                        <td style="color: black; border: 1px solid black">Opening CashInHand:</td>
                                        <td style="color: black; border: 1px solid black"></td>
                                        <td style="color: black; border: 1px solid black"></td>
                                    </tr>
                                    <tr style="color: black; border: 1px solid black">
                                        <td style="color: black; border: 1px solid black"></td>
                                        <td style="color: black; border: 1px solid black">Opening CashAtBank:</td>
                                        <td class="text-right" style="color: black; border: 1px solid black">{{number_format($totalPayments_previous - $totalReceive_previous , 2)}} </td>
                                        <td style="color: black; border: 1px solid black"></td>
                                    </tr>
                                @endif

                                @foreach($accountGroups as $group)
                                    @foreach($group->accountControls as $control)
                                        @foreach($control->accountSubsidiaries as $subsidiary)
                                            @foreach($subsidiary->accounts->where('account_subsidiary_id','!=',112) as $account)
                                                @php
                                                    $totalPayments += $account->payments;
                                                    $totalReceive += $account->receive;
                                                @endphp

                                                @if($account->payments > 0 || $account->receive > 0)
                                                    <tr style="color: black; border: 1px solid black">
                                                        <td style="color: black; border: 1px solid black">{{ $account->account_code ?? '' }}</td>
                                                        <td style="color: black; border: 1px solid black">{{ $account->name }}</td>
                                                        <td class="text-right" style="color: black; border: 1px solid black">{{ number_format($account->receive, 2) }}</td>
                                                        <td class="text-right" style="color: black; border: 1px solid black">{{ number_format($account->payments, 2) }}</td>
                                                    </tr>
                                                @endif

                                            @endforeach
                                        @endforeach
                                    @endforeach
                                @endforeach
                                </tbody>
                                <tfoot style="border: 1px solid black">
                                @php
                                    $diff_receive = max($totalReceive - $totalPayments, 0);
                                    $diff_payment = max($totalPayments - $totalReceive, 0);
                                @endphp
{{--                                @if(($totalReceive >= $totalPayments))--}}
{{--                                    @php--}}
{{--                                        $diff_receive = $totalReceive - $totalPayments;--}}
{{--                                    @endphp--}}
{{--                                    <tr style="color: black; border: 1px solid black">--}}
{{--                                        <td style="color: black; border: 1px solid black"></td>--}}
{{--                                        <td style="color: black; border: 1px solid black">Closing CashInHand:</td>--}}
{{--                                        <td style="color: black; border: 1px solid black"></td>--}}
{{--                                        <td style="color: black; border: 1px solid black"></td>--}}
{{--                                    </tr>--}}
{{--                                    <tr style="color: black; border: 1px solid black">--}}
{{--                                        <td style="color: black; border: 1px solid black"></td>--}}
{{--                                        <td style="color: black; border: 1px solid black">Closing CashAtBank:</td>--}}
{{--                                        <td style="color: black; border: 1px solid black"></td>--}}
{{--                                        <td class="text-right" style="color: black; border: 1px solid black">{{number_format($diff_receive , 2)}}</td>--}}
{{--                                    </tr>--}}
{{--                                @elseif($totalReceive <= $totalPayments)--}}
{{--                                    @php--}}
{{--                                        $diff_payment = $totalPayments - $totalReceive;--}}
{{--                                    @endphp--}}
{{--                                    <tr style="color: black; border: 1px solid black">--}}
{{--                                        <td style="color: black; border: 1px solid black"></td>--}}
{{--                                        <td style="color: black; border: 1px solid black">Closing CashInHand:</td>--}}
{{--                                        <td style="color: black; border: 1px solid black"></td>--}}
{{--                                        <td style="color: black; border: 1px solid black"></td>--}}
{{--                                    </tr>--}}
{{--                                    <tr style="color: black; border: 1px solid black">--}}
{{--                                        <td style="color: black; border: 1px solid black"></td>--}}
{{--                                        <td style="color: black; border: 1px solid black">Closing CashAtBank:</td>--}}
{{--                                        <td style="color: black; border: 1px solid black"></td>--}}
{{--                                        <td class="text-right" style="color: black; border: 1px solid black">{{number_format($diff_payment,2)}}</td>--}}
{{--                                    </tr>--}}
{{--                                @endif--}}
{{--                                <tr style="border: 1px solid black">--}}
{{--                                    <th style="border: 1px solid black" colspan="2"><span style="float: right">Total</span></th>--}}
{{--                                    <th class="text-right" style="border: 1px solid black">{{ $totalReceive }}</th>--}}
{{--                                    <th class="text-right" style="border: 1px solid black">{{ $totalPayments + $diff_receive}}</th>--}}
{{--                                </tr>--}}

                                <tr style="color: black; border: 1px solid black">
                                    <td style="color: black; border: 1px solid black"></td>
                                    <td style="color: black; border: 1px solid black">Closing CashInHand:</td>
                                    <td style="color: black; border: 1px solid black"></td>
                                    <td style="color: black; border: 1px solid black"></td>
                                </tr>
                                <tr style="color: black; border: 1px solid black">
                                    <td style="color: black; border: 1px solid black"></td>
                                    <td style="color: black; border: 1px solid black">Closing CashAtBank:</td>
                                    <td style="color: black; border: 1px solid black"></td>
                                    <td class="text-right" style="color: black; border: 1px solid black">
                                        {{ number_format($diff_receive > 0 ? $diff_receive : $diff_payment, 2) }}
                                    </td>
                                </tr>
                                <tr style="border: 1px solid black">
                                    <th style="border: 1px solid black" colspan="2"><span style="float: right">Total</span></th>
                                    <th class="text-right" style="border: 1px solid black">{{ $totalReceive }}</th>
                                    <th class="text-right" style="border: 1px solid black">{{ $totalPayments + $diff_receive }}</th>
                                </tr>
                                </tfoot>
                            </table>
                        </div>
                        <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