@extends('layouts/microfin_layout')
@section('title', '| Savings Interest Calculation')
@section('content')

    <style type="text/css">
        table tbody tr td {
            font-size: 11px;
        }

        .table thead tr th {
            border-bottom: 1px solid #FFF !important;
        }

        table>tbody>tr>td:last-child a {
            padding: 0 5px;
        }

        .week-day td {
            background-color: #696969;
            color: #fff;
            font-size: 1.1em;
        }

        .week-day {
            border: 1px solid #fff;
        }

        .fa-chevron-circle-right {
            color: green;
            font-size: 1.3em;
        }

        .interest-div {
            display: none;
        }

        .amount {
            position: relative;
        }

        .amount:hover {
            cursor: pointer;
        }

        .amount:hover .interest-div {
            display: inline-block;
            padding: 5px;
            background-color: green;
            border: 1px solid #222;
            color: #fff;
            text-align: left;
            z-index: 1;
            position: absolute;
            left: 50%;
            top: 20px;
            width: 90px;
        }

        .total-amount {
            padding-right: 5px !important;
            text-align: right !important;
        }

        .withdraw {
            text-align: center !important;
        }

        .btn-container {
            margin-top: 15px;
        }

        .btn-container .btn {
            width: auto;
        }

        .btn-danger {
            background-color: #2c2e2f !important;
        }

        .input-td {
            padding: 0 !important;
            width: 70px;
        }

        .input-td .form-control {
            width: 100%;
            height: 23px !important;
        }

        .withdraw {
            background-color: #696969;
            color: #fff;
            padding: 0 !important;
            width: 70px;
            text-align: center !important;
        }

        .withdraw .form-control {
            width: 100%;
            height: 23px !important;
        }

        input[type=number]::-webkit-inner-spin-button,
        input[type=number]::-webkit-outer-spin-button {
            -webkit-appearance: none;
            -moz-appearance: none;
            appearance: none;
            margin: 0;
        }

        .form-control[readonly] {
            background-color: #696969;
            color: #fff;
        }
    </style>

    {!! Form::open([
        'url' => 'saveManualSavingsInterest',
        'role' => 'form',
        'id' => 'saveInterestForm',
        'method' => 'post',
    ]) !!}
    <div class="row">
        <div class="col-md-12">
            <div class="panel panel-default" style="background-color:#708090;">
                <div class="panel-heading" style="padding-bottom:0px">
                    <h3 style="font-family: Antiqua;letter-spacing: 2px;">
                        <font color="white">Samity: {{ $samityName }}</font>
                    </h3>
                </div>
                <div class="panel-body panelBodyView">

                    <table class="table table-striped table-bordered" id="HrEmployee" style="color:black;">
                        <thead>
                            <tr>
                                <th rowspan="2">SL#</th>
                                <th rowspan="2">Member Code</th>
                                <th rowspan="2">Member Name</th>
                                <th rowspan="2">F/S Name</th>
                                <th rowspan="2">Savings Code</th>
                                <th colspan="12" rowspan="1">
                                    @if ($route == 'viewManualInterestSavingsDetails')
                                        <span>Monthly Balance</span>
                                    @elseif ($route == 'viewManualInterestSavingsInterest')
                                        <span>Monthly Interest</span>
                                    @endif
                                </th>
                                <th rowspan="2" style="@if ($route != 'viewManualInterestSavingsInterest') display: none; @endif">Total
                                </th>
                            </tr>
                            <tr>
                                @foreach ($monthsArr as $key => $value)
                                    <th rowspan="1">{{ date('Y-m', strtotime($value)) }}</th>
                                @endforeach
                            </tr>
                        </thead>
                        <tbody>

                            @php
                                $sl = 1;
                                $id = 1;
                                $name = 1;
                                $totalInterest = 0;
                                $sumMonthlybalance = 0;
                                $sumMonthsInterest = 0;
                            @endphp
                            @foreach ($members as $key => $member)
                                {{-- member loop --}}
                                @php
                                    $sumMemberInterest = 0;
                                    $memberAccounts = $closingBalance->where('memberId', $member->id)->groupBy('savingsAccId');
                                @endphp
                                @foreach ($memberAccounts as $accId => $memberAccount)
                                    @php
                                    @endphp
                                    <tr>
                                        <td class="slNo">{{ $sl++ }}</td>
                                        <td style="padding: 3px 5px;">{{ $member->code }}</td>
                                        <td style="text-align: left; padding: 3px 5px;">{{ $member->name }}</td>
                                        <td style="text-align: left; padding: 3px 5px;">{{ $member->spouseFatherSonName }}
                                        </td>
                                        <td>{{ $memberAccount[0]['savingsCode'] }}</td>
                                        @foreach ($closingBalance->where('memberId', $member->id)->where('savingsAccId', $accId) as $key => $value)
                                            {{-- balance info loop --}}

                                            @php
                                                // apply withdraw condition
                                                $memberInterestInfo = $monthAndInterest->where('memberId', $member->id)->first();
                                                $memberMonthlyInterests = $memberInterestInfo ? collect($memberInterestInfo['monthWiseInterest']) : [];
                                                // dd($memberMonthlyInterests);
                                                if ($value['withdraw'] == 0) {
                                                    if ($isSaved) {
                                                        $monthsInterest = $memberMonthlyInterests ? $memberMonthlyInterests->where('month', $value['month'])->first()->interest : 0;
                                                    } else {
                                                        $monthsInterest = 0;
                                                    }
                                                    $averageBalance = $value['averageBalance'];
                                                } else {
                                                    $monthsInterest = 0;
                                                    $averageBalance = 0;
                                                }
                                            @endphp

                                            {{-- savings average balance view  --}}
                                            @if ($route == 'viewManualInterestSavingsDetails')
                                                @if ($value['withdraw'] == 0)
                                                    @if ($isSaved)
                                                        <td class="amount">{{ number_format($averageBalance, 2) }}
                                                            <span class="interest-div">Interest:
                                                                {{ number_format($monthsInterest, 2) }}</span>
                                                        </td>
                                                    @else
                                                        <td class="amount">{{ number_format($averageBalance, 2) }}
                                                            {{-- <span class="interest-div">Interest: {{ number_format($monthsInterest, 2) }}</span> --}}
                                                        </td>
                                                    @endif
                                                @else
                                                    <td class="amount withdraw"><span> - </span>
                                                        <span class="interest-div">Due to Savings Withdraw</span>
                                                    </td>
                                                @endif

                                                {{-- savings interest view  --}}
                                            @elseif($route == 'viewManualInterestSavingsInterest')
                                                @if ($value['withdraw'] == 0)
                                                    @if ($isSaved)
                                                        {{-- Case of Update --}}
                                                        <td class="amount">
                                                            {{-- {{ number_format($monthsInterest, 2) }} --}}
                                                            {{ Form::number('interest' . $name++, $monthsInterest, ['class' => 'form-control intertest-qty', 'min' => 0, 'id' => 'interest-input-' . $id++, 'step' => '0.01', 'autocomplete' => 'off']) }}
                                                        </td>
                                                    @else
                                                        {{-- <td class="input-td"><input type="text" class="form-control"></td> --}}
                                                        <td class="input-td">
                                                            {{ Form::number('interest' . $name++, 0, ['class' => 'form-control intertest-qty', 'min' => 0, 'id' => 'interest-input-' . $id++, 'step' => '0.01', 'autocomplete' => 'off']) }}
                                                        </td>
                                                    @endif
                                                @else
                                                    @if ($isSaved)
                                                        {{-- Case of Update --}}
                                                        <td class="amount withdraw">
                                                            {{ Form::hidden('interest' . $name++, 0, ['class' => 'form-control intertest-qty', 'min' => 0, 'id' => 'interest-input-' . $id++, 'placeholder' => 0, 'readonly' => '']) }}
                                                            <span> - </span>
                                                            <span class="interest-div">Due to Savings Withdraw</span>
                                                        </td>
                                                    @else
                                                        <td class="amount withdraw">
                                                            {{ Form::number('interest' . $name++, 0, ['class' => 'form-control intertest-qty', 'min' => 0, 'id' => 'interest-input-' . $id++, 'placeholder' => 0, 'readonly' => '']) }}
                                                            {{-- <span> - </span> --}}
                                                            <span class="interest-div">Due to Savings Withdraw</span>
                                                        </td>
                                                    @endif
                                                @endif
                                            @endif
                                            @php
                                                // members total interest
                                                $sumMemberInterest += $monthsInterest;
                                            @endphp
                                        @endforeach {{-- balance info loop close --}}

                                        @if ($isSaved)
                                            <td class="amount"
                                                style="@if ($route != 'viewManualInterestSavingsInterest') display: none; @endif">
                                                {{ number_format($sumMemberInterest, 2) }}
                                            </td>
                                        @else
                                            <td class="amount member-sum-int"
                                                style="@if ($route != 'viewManualInterestSavingsInterest') display: none; @endif"></td>
                                        @endif

                                    </tr>
                                    @php
                                        // all members total interest
                                        $totalInterest += $sumMemberInterest;
                                    @endphp
                                @endforeach <!--  foreach($memberAccounts as $memberAccount) -->
                            @endforeach {{-- member loop close --}}
                        </tbody>

                        <thead @if ($route == 'viewManualInterestSavingsInterest' && !$isSaved) style="display:none;" @endif> {{-- total informations row --}}
                            <tr>
                                <th colspan="5" class="text-center">Total</th>

                                @foreach ($monthsArr as $key => $month)
                                    {{-- months loop --}}

                                    @php
                                        $sumMonthlyBalance = 0;
                                        $sumMonthlyInterest = 0;
                                        $monthsInterst = [];
                                        
                                        // interest total
                                        for ($i = 0; $i < $monthAndInterest->count(); $i++) {
                                            $monthsInterst[] = collect($monthAndInterest[$i]['monthWiseInterest'])
                                                ->where('month', $month)
                                                ->first()->interest;
                                        }
                                        // dd($monthsInterst);
                                        
                                        $sumMonthlyInterest = array_sum($monthsInterst);
                                        // dd($sumMonthlyInterest);
                                    @endphp

                                    @foreach ($closingBalance->where('month', $month) as $key => $value)
                                        {{-- balance info loop --}}
                                        @php
                                            // apply withdraw condition
                                            if ($value['withdraw'] == 0) {
                                                $averageBalance = $value['averageBalance'];
                                            } else {
                                                $averageBalance = 0;
                                            }
                                            
                                            // total Monthly balance
                                            $sumMonthlyBalance += $averageBalance;
                                            // $sumMonthlyInterest += $monthsInterest;
                                        @endphp
                                    @endforeach {{-- balance info loop close --}}

                                    {{-- checking route --}}
                                    @if ($route == 'viewManualInterestSavingsDetails')
                                        <th class="total-amount">{{ number_format($sumMonthlyBalance, 2) }}</th>
                                    @elseif ($route == 'viewManualInterestSavingsInterest')
                                        <th class="total-amount">{{ number_format($sumMonthlyInterest, 2) }}</th>
                                    @endif
                                @endforeach {{-- months loop close --}}

                                {{-- samity total interest --}}
                                @if ($isSaved)
                                    <th rowspan="2"
                                        style="text-align: right; padding-right: 5px; @if ($route != 'viewManualInterestSavingsInterest') display: none; @endif">
                                        {{ number_format($totalInterest, 2) }}
                                    </th>
                                @else
                                    <th rowspan="2"
                                        style="text-align: right; padding-right: 5px; @if ($route != 'viewManualInterestSavingsInterest') display: none; @endif">
                                    </th>
                                @endif

                            </tr>
                        </thead>
                    </table>
                </div>
                {{-- buttons --}}
                <div class="text-right btn-container">

                    @if ($route == 'viewManualInterestSavingsDetails')
                        <a href="{{ url('viewManualInterestSavingsInterest/' . $samityId . '/' . $savingsProductId) }}"
                            class="btn btn-danger previewButton">Preview</a>
                        <a href="{{ url('viewMfnSavingsSamityList') }}" class="btn btn-danger backButton">Back</a>
                    @elseif ($route == 'viewManualInterestSavingsInterest')
                        {{-- {{ Form::hidden('interestData', implode(' ', $dataForTable)) }} --}}

                        @if ($isSaved)
                            <span>
                                {!! Form::submit('Update', ['id' => 'saveInterest', 'class' => 'btn btn-danger saveButton']) !!}
                            </span>
                        @else
                            <span>
                                {!! Form::submit('Save', ['id' => 'saveInterest', 'class' => 'btn btn-danger saveButton']) !!}
                            </span>
                        @endif
                        <a href="{{ url('viewManualInterestSavingsDetails/' . $samityId . '/' . $savingsProductId) }}"
                            class="btn btn-danger backButton">Back</a>
                        <a href="{{ url('viewMfnSavingsSamityList') }}" class="btn btn-danger backButton">Back to
                            Samity</a>
                    @endif

                </div>
            </div>
        </div>
    </div>
    {!! Form::close() !!}

    <script type="text/javascript">
        $(document).ready(function() {

            $(".intertest-qty").on('input', function() {
                var nearestRows = $(this).closest('tr').find('.intertest-qty');
                var sumDisplay = $(this).closest('tr').find('.member-sum-int');
                var total = 0;

                nearestRows.each(function() {
                    var value = Number($(this).val());
                    if (!isNaN(value)) total += value;
                });
                // alert(total);
                sumDisplay.text(total.toFixed(2));
            });

            $('input').on({
                focus: function() {
                    if (this.value == '0') this.value = '';
                },
                blur: function() {
                    if (this.value === '') this.value = '0';
                }
            });

            $('#saveInterestForm').submit(function(e) {

                @if ($isSaveAllowed == 0)
                    alert('Interest can be saved only on last day of current fiscal year.');
                    return false;
                @else
                    e.preventDefault();
                    $(".saveButton").prop("disabled", true);
                    var samityId = {{ $samityId }};
                    var savingsProductId = {{ $savingsProductId }};
                    var reqData = $('form').serialize();

                    $.ajax({
                            url: '{{ url('saveManualSavingsInterest/') }}',
                            type: 'POST',
                            data: {
                                samityId: samityId,
                                savingsProductId: savingsProductId,
                                requestData: reqData
                            },
                            // data: $('form').serialize(),
                            dataType: 'json',
                        })
                        .done(function(data) {
                            if (data.responseTitle == 'Success!') {
                                toastr.success(data.responseText, data.responseTitle, opts);
                                setTimeout(function() {
                                    // alert('hello');
                                    window.location.href =
                                        '{{ url('viewMfnSavingsSamityList/') }}';

                                }, 2000);
                            } else if (data.responseTitle == 'Warning!') {
                                toastr.warning(data.responseText, data.responseTitle, opts);
                                $(".saveButton").prop("disabled", false);
                                // setTimeout(function() {
                                //     // alert('hello');
                                //     window.location.reload();

                                // }, 2000);
                            }
                            $('#myModal').modal('hide');
                        })
                        .fail(function() {
                            alert("error");
                        });
                @endif

            });
        });
    </script>

@endsection