@extends('layouts/microfin_layout')
@section('title', 'MIS Yearly Plan Details')
@section('content')

@include('microfin.AopBudget.misYearlyPlan.entry.style')

<style>
    .stRowStyle td { background-color: #cfe2f3 }
    .gtRowStyle td { background-color: #9fc5e8 }
</style>

@php
    $catCount = count($mfnSamityCategories);
    // $catCount = 1; // for testing only
    $catCount > 1 ? $colspan = 2 : $colspan = 1;
@endphp

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

        <div class="panel-options">

            <a href="{{url('/misYearlyBudget/view')}}" class="btn btn-info pull-right addViewBtn" style="margin: 10px"><i class="glyphicon glyphicon-th-list viewIcon"></i>MIS Yearly Plans</a>

        </div>

        <div>
            <h3 style="margin: .5em 10em; text-align: center; font-family: Antiqua; letter-spacing: 2px; color: white;">Edit Plan</h3>
        </div>

    </div>


    <div class="panel-body panelBodyView">

        <div id="printDivUpper">
            <div class="row" style="padding-bottom: 10px; text-align: center; vertical-align: middle; color: black; font-weight: bold; margin: 0 .5em;">
                <span style="font-size:14px;">{{ $companyInfo->name }}</span>
                <br/>
                <span style="font-size:13px;">{{ $companyInfo->address }}</span>
                <br/>
                <span style="font-size:12px;">Annual Operation Plan {{ $fiscalYears[$fiscalYearId] }} ({{ ucfirst($budgetTypes[$typeId]) }}) </span>
                <br/>
                <span style="font-size:10px; float:left">Project Name : {{ $projects[$projectId] }}</span>
                <span style="font-size:10px; float:right">Branch Name : {{ $branches[$branchId] }}</span>
                <br/>
                <span style="font-size:10px; float:left">Project Type : {{ $projectTypes[$projectTypeIdFk] }}</span>
                <span style="font-size:10px; float:right">Print Date : {{ date("d-m-Y") }}</span>                                    
            </div>                          
        </div>


        <div class="table-responsive" id="printDiv1">
        {!! Form::open(array('url' => '', 'id' => 'budget-form', 'role' => 'form')) !!}

            <table id="budgetTable" class="table table-hover table-sm table-bordered" style="color:black; border-collapse: collapse; border:1px solid ash;">
                <thead>
                    <tr>
                        <th rowspan="2" colspan="{{$colspan+1}}">Components</th>

                        <th rowspan="2" colspan="1">{{ $prevLastFy }}</th>
                        <th rowspan="2" colspan="1">{{ $lastFy }}</th>

                        <th rowspan="1" colspan="13">{{ $fiscalyear }}</th>                
                        <th class="w80" rowspan="2" colspan="1">{{ $fiscalyear }}</th>
                    </tr>
                    <tr>
                        <th>Jul, {{ $partOfyear[0] }}</th>
                        <th>Aug, {{ $partOfyear[0] }}</th>
                        <th>Sep, {{ $partOfyear[0] }}</th>
                        <th>Oct, {{ $partOfyear[0] }}</th>
                        <th>Nov, {{ $partOfyear[0] }}</th>
                        <th>Dec, {{ $partOfyear[0] }}</th>

                        <th>Jan, {{ $partOfyear[1] }}</th>
                        <th>Feb, {{ $partOfyear[1] }}</th>
                        <th>Mar, {{ $partOfyear[1] }}</th>
                        <th>Apr, {{ $partOfyear[1] }}</th>
                        <th>May, {{ $partOfyear[1] }}</th>
                        <th>Jun, {{ $partOfyear[1] }}</th>
                        <th>Total</th>
                    </tr>
                </thead>        
                
                <tbody>

                    @foreach($mfnSamityCategories as $sCatId => $sCatVal)
                    @foreach($sCatVal->productCategories as $key => $item)
                        @php
                            $loanee         = $item['loanee']; 
                            $collection     = $item['collection']; 
                            $outstanding    = $item['outstanding']; 
                            $firstProductCat = key($sCatVal->productCategories);
                            // $firstProductCat = array_key_first($sCatVal->productCategories);
                        @endphp

                        <tr>

                            @if ($catCount > 1)
                                @if($firstProductCat == $key) <td class="w80 text-center" rowspan="{{ $samityCatWiseProductCount[$sCatVal->samityCategoryId] * 3 }}">{{$samityCategories[$sCatVal->samityCategoryId]->categoryName}}</td>    
                                @elseif($firstProductCat == $key) <td class="w80 text-center" rowspan="{{ $samityCatWiseProductCount[$sCatVal->samityCategoryId] * 3 }}">{{$samityCategories[$sCatVal->samityCategoryId]->categoryName}}</td>
                                @endif
                            @endif
                            

                            <td class="w80 text-left" rowspan="3" id="{{ $key }}">{{ $item['category'] }}</td>                  
                            <td class="w120 text-left"> {{ $particularsName['loanee'] }} </td>
                            <td class="w100 text-center" id="loanee_prevOpening_{{ $key }}"> {{  $item['prevLastFyDueLoanee'] }} </td>
                            <td class="w100 text-center" id="loanee_opening_{{ $key }}"> {{ $item['lastFyDueLoanee'] }} </td>

                            <input type="hidden" value="{{ $loanee['id'] }}" name="id_{{ $loanee['id'] }}" /> 
                            <input type="hidden" value="{{ $loanee['id'] }}" name="id_loanee_{{ $key }}" /> 
                            <input type="hidden" value="{{  $item['prevLastFyDueLoanee'] }}" id="prevLastFy_loanee_{{ $key }}" name="prevLastFy_loanee_{{ $key }}" /> 
                            <input type="hidden" value="{{ $item['lastFyDueLoanee'] }}" id="lastFy_loanee_{{ $key }}" name="lastFy_loanee_{{ $key }}" /> 
                            <input type="hidden" value="{{ $loanee['total'] }}" id="totalform_loanee_{{ $key }}" name="total_loanee_{{ $key }}" /> 

                            @foreach($fyMonths as $monthNo => $monthName) 
                                <td> 
                                    <input @if ($monthItemNo > $monthNo) readonly @endif onclick='checkelement(this)'
                                        id="loanee_{{ $key }}_{{ $monthNo }}" 
                                        name="loanee_{{ $key }}_{{ $monthNo }}" 
                                        value="{{ $loanee[$monthName] }}" 
                                        class="form-control text-center" 
                                        type="text" 
                                        {{ $isEdit ? '' : 'readonly' }} 
                                    /> 
                                </td>
                            @endforeach

                            <td class="text-center w80" id="total_loanee_{{ $key }}"> {{  number_format( $loanee['total'] ) }} </td>
                            <td class="text-center w80" id="closing_loanee_{{ $key }}"> {{  number_format( $loanee['opening'] + $loanee['total'] ) }} </td>
                        </tr>

                        <tr>                            
                            <td class="text-left"> {{ $particularsName['collection'] }} </td>
                            <td class="text-right" id="collection_prevOpening_{{ $key }}"> {{ $item['prevLastFyDueCollection'] }} </td>
                            <td class="text-right" id="collection_opening_{{ $key }}"> {{ $item['lastFyDueCollection'] }} </td>
                                                
                            <input type="hidden" value="{{ $collection['id'] }}" name="id_{{ $collection['id'] }}" /> 
                            <input type="hidden" value="{{ $collection['id'] }}" name="id_collection_{{ $key }}" /> 
                            <input type="hidden" value="{{ $item['prevLastFyDueCollection'] }}" id="prevLastFy_collection_{{ $key }}" name="prevLastFy_collection_{{ $key }}" /> 
                            <input type="hidden" value="{{ $item['lastFyDueCollection'] }}" id="lastFy_collection_{{ $key }}" name="lastFy_collection_{{ $key }}" />
                            <input type="hidden" value="{{ $collection['total'] }}" id="totalform_collection_{{ $key }}" name="total_collection_{{ $key }}" />  

                            @foreach($fyMonths as $monthNo => $monthName) 
                                <td> 
                                    <input @if ($monthItemNo > $monthNo) readonly @endif onclick='checkelement(this)'
                                        id="collection_{{ $key }}_{{ $monthNo }}" 
                                        name="collection_{{ $key }}_{{ $monthNo }}" 
                                        value="{{ $collection[$monthName] }}"                                        
                                        class="form-control text-right" 
                                        type="text" 
                                        {{ $isEdit ? '' : 'readonly' }} 
                                    /> 
                                </td>
                            @endforeach

                            <td class="text-right" id="total_collection_{{ $key }}"> {{  number_format( $collection['total'] ) }} </td>
                            <td class="text-right" id="closing_collection_{{ $key }}"> {{  number_format( $collection['opening'] + $collection['total'] ) }} </td>
                        </tr>
                        
                        <tr>                            
                            <td class="text-left"> {{ $particularsName['outstanding'] }} </td>
                            <td class="text-right" id="outstanding_prevOpening_{{ $key }}"> {{  $item['prevLastFyDueOutstanding'] }} </td>
                            <td class="text-right" id="outstanding_opening_{{ $key }}"> {{ $item['lastFyDueOutstanding'] }} </td>
                                                
                            <input type="hidden" value="{{ $outstanding['id'] }}" name="id_{{ $outstanding['id'] }}" /> 
                            <input type="hidden" value="{{ $outstanding['id'] }}" name="id_outstanding_{{ $key }}" /> 
                            <input type="hidden" value="{{  $item['prevLastFyDueOutstanding'] }}" id="prevLastFy_outstanding_{{ $key }}" name="prevLastFy_outstanding_{{ $key }}" /> 
                            <input type="hidden" value="{{ $item['lastFyDueOutstanding'] }}" id="lastFy_outstanding_{{ $key }}" name="lastFy_outstanding_{{ $key }}" /> 
                            <input type="hidden" value="{{ $outstanding['total'] }}" id="totalform_outstanding_{{ $key }}" name="total_outstanding_{{ $key }}" />  

                            @foreach($fyMonths as $monthNo => $monthName) 
                                <td> 
                                    <input 
                                        id="outstanding_{{ $key }}_{{ $monthNo }}" 
                                        name="outstanding_{{ $key }}_{{ $monthNo }}" 
                                        value="{{ $outstanding[$monthName] }}"                                         
                                        class="form-control text-right" 
                                        type="text" 
                                        readonly
                                    /> 
                                </td>
                            @endforeach

                            <td class="text-right" id="total_outstanding_{{ $key }}"> {{  number_format( $outstanding['total'] ) }} </td>
                            <td class="text-right" id="closing_outstanding_{{ $key }}"> {{  number_format( $outstanding['opening'] + $outstanding['total'] ) }} </td>
                        </tr> 
                        
                        @endforeach

                            {{-- SUB TOTAL --}}
                            @if ($catCount > 1)
                                <tr class="level-constant stRowStyle">
                                    <td rowspan="3" colspan="2">Sub Total</td>
                                    <td class="text-left"> {{ $particularsName['loanee'] }} </td>
                                    <td class="text-center" id="s_{{$sCatId}}_total_prevLastFyDueLoanee"> {{ $mfnSamityCategories[$sCatId]->prevLastFyDueLoanee }} </td>
                                    <td class="text-center" id="s_{{$sCatId}}_total_lastFyDueLoanee"> {{ $mfnSamityCategories[$sCatId]->lastFyDueLoanee }} </td>
                                    @for ($i = 1; $i <= 12; $i++) 
                                        <td id="s_{{$sCatId}}_Total_loanee_{{ $i }}" class="text-center"> l </td>
                                    @endfor
                                    <td id="s_{{$sCatId}}_TotalLoanee" class="text-center"> L </td>
                                    <td id="s_{{$sCatId}}_TotalLoaneeFy" class="text-center"> L </td>
                                </tr>
                                <tr class="level-constant stRowStyle">
                                    <td class="text-left">{{ $particularsName['collection'] }}</td>
                                    <td class="text-right" id="s_{{$sCatId}}_total_prevLastFyDueCollection"> {{ $mfnSamityCategories[$sCatId]->prevLastFyDueCollection }} </td>
                                    <td class="text-right" id="s_{{$sCatId}}_total_lastFyDueCollection"> {{ $mfnSamityCategories[$sCatId]->lastFyDueCollection }} </td>
                                    @for ($i = 1; $i <= 12; $i++) 
                                        <td id="s_{{$sCatId}}_Total_collection_{{ $i }}" class="text-right"> c </td>
                                    @endfor
                                    <td id="s_{{$sCatId}}_TotalCollection" class="text-right"> C </td>
                                    <td id="s_{{$sCatId}}_TotalCollectionFy" class="text-right"> C </td>
                                </tr>                    
                                <tr class="level-constant stRowStyle">
                                    <td class="text-left">{{ $particularsName['outstanding'] }}</td>
                                    <td class="text-right" id="s_{{$sCatId}}_total_prevLastFyDueOutstanding"> {{ $mfnSamityCategories[$sCatId]->prevLastFyDueOutstanding }} </td>
                                    <td class="text-right" id="s_{{$sCatId}}_total_lastFyDueOutstanding"> {{ $mfnSamityCategories[$sCatId]->lastFyDueOutstanding }} </td>
                                    @for ($i = 1; $i <= 12; $i++) 
                                        <td id="s_{{$sCatId}}_Total_outstanding_{{ $i }}" class="text-right"> o </td>
                                    @endfor
                                    <td id="s_{{$sCatId}}_TotalOutstanding" class="text-right"> O </td>
                                    <td id="s_{{$sCatId}}_TotalOutstandingFy" class="text-right"> O </td>
                                </tr>    
                            @endif
                                   
                            {{-- SUB TOTAL END --}}

                    @endforeach

                    <tr class="level-constant gtRowStyle">
                        <td rowspan="3" colspan="{{$colspan}}">Grand Total</td>
                        <td class="text-left"> {{ $particularsName['loanee'] }} </td>
                        <td class="text-center" id="total_prevLastFyDueLoanee"> {{ number_format($total_prevLastFyDueLoanee) }} </td>
                        <td class="text-center" id="total_lastFyDueLoanee"> {{ number_format($total_lastFyDueLoanee) }} </td>

                        @for ($i = 1; $i <= 12; $i++) 
                            <td id="gTotal_loanee_{{ $i }}" class="text-center"> l </td>
                        @endfor

                        <td id="gTotalLoanee" class="text-center"> L </td>
                        <td id="gClosingLoanee" class="text-center"> L </td>
                    </tr>

                    <tr class="level-constant gtRowStyle">
                        <td class="text-left">{{ $particularsName['collection'] }}</td>
                        <td class="text-right" id="total_prevLastFyDueCollection"> {{ number_format($total_prevLastFyDueCollection) }} </td>
                        <td class="text-right" id="total_lastFyDueCollection"> {{ number_format($total_lastFyDueCollection) }} </td>

                        @for ($i = 1; $i <= 12; $i++) 
                            <td id="gTotal_collection_{{ $i }}" class="text-right"> c </td>
                        @endfor

                        <td id="gTotalCollection" class="text-right"> C </td>
                        <td id="gClosingCollection" class="text-right"> C </td>
                    </tr>
                    
                    <tr class="level-constant gtRowStyle">
                        <td class="text-left">{{ $particularsName['outstanding'] }}</td>
                        <td class="text-right" id="total_prevLastFyDueOutstanding"> {{ number_format($total_prevLastFyDueOutstanding) }} </td>
                        <td class="text-right" id="total_lastFyDueOutstanding"> {{ number_format($total_lastFyDueOutstanding) }} </td>

                        @for ($i = 1; $i <= 12; $i++) 
                            <td id="gTotal_outstanding_{{ $i }}" class="text-right"> o </td>
                        @endfor

                        <td id="gTotalOutstanding" class="text-right"> O </td>
                        <td id="gClosingOutstanding" class="text-right"> O </td>
                    </tr>            

                </tbody>

                <tfoot>
                    <td colspan="19" class="text-right">
                        {!! Form::submit('Save', ['id' => 'budgetSubmit', 'class' => 'btn btn-primary btn-md', 'style'=>'font-size:12px']); !!}
                    </td>
                </tfoot>

            </table>

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

</div>
</div>
</div>


<script>

    function checkelement(el)
    {
    	if(el.readOnly == true)
    	{
    		alert("You can not enter value to this! ");
    	}
    }

    $(document).ready(function() {

        // const getNumberFromCommaSeparatedString = (str) => {
        //     return (str || 0).toString().replace(/[^0-9]/g, '').replace(/(\..*)\./g, '$1').toLocaleString("en-IN")            
        // }

        // const convertNumberToCommaSeparetedString = (number) => {
        //     number = ( number || 0 ).toString().replace(/[^0-9]/g, '').replace(/(\..*)\./g, '$1')
        //     return number.replace(/\B(?=(?:(\d\d)+(\d)(?!\d))+(?!\d))/g, ',')  
        // }

        const getNumberFromCommaSeparatedString = (str) => {
            if(str == '-') return 0

            return (str || 0).toString()
            // .replace(/[^0-9]/g, '')
            .replace(/[^-0-9]/g, '')
            .replace(/(\..*)\./g, '$1').toLocaleString("en-IN")            
        }

        const convertNumberToCommaSeparetedString = (number) => {
            number = ( number || 0 ).toString()
            // .replace(/[^0-9]/g, '')
            .replace(/[^-0-9]/g, '')
            .replace(/(\..*)\./g, '$1')
            return number.replace(/\B(?=(?:(\d\d)+(\d)(?!\d))+(?!\d))/g, ',')  
        }
        
        let productCategoryKeys = "{{ $productCategoryKeys }}".split(",").map( Number )
        let total_loanee      = new Array(productCategoryKeys.length).fill(0)
        let total_collection  = new Array(productCategoryKeys.length).fill(0)
        let total_outstanding = new Array(productCategoryKeys.length).fill(0)


        $(`#s_1_total_prevLastFyDueLoanee`).text( convertNumberToCommaSeparetedString( $(`#s_1_total_prevLastFyDueLoanee`).text() ) )
        $(`#s_1_total_prevLastFyDueCollection`).text( convertNumberToCommaSeparetedString( $(`#s_1_total_prevLastFyDueCollection`).text() ) )
        $(`#s_1_total_prevLastFyDueOutstanding`).text( convertNumberToCommaSeparetedString( $(`#s_1_total_prevLastFyDueOutstanding`).text() ) )
        $(`#s_1_total_lastFyDueLoanee`).text( convertNumberToCommaSeparetedString( $(`#s_1_total_lastFyDueLoanee`).text() ) )
        $(`#s_1_total_lastFyDueCollection`).text( convertNumberToCommaSeparetedString( $(`#s_1_total_lastFyDueCollection`).text() ) )
        $(`#s_1_total_lastFyDueOutstanding`).text( convertNumberToCommaSeparetedString( $(`#s_1_total_lastFyDueOutstanding`).text() ) )

        $(`#s_2_total_prevLastFyDueLoanee`).text( convertNumberToCommaSeparetedString( $(`#s_2_total_prevLastFyDueLoanee`).text() ) )
        $(`#s_2_total_prevLastFyDueCollection`).text( convertNumberToCommaSeparetedString( $(`#s_2_total_prevLastFyDueCollection`).text() ) )
        $(`#s_2_total_prevLastFyDueOutstanding`).text( convertNumberToCommaSeparetedString( $(`#s_2_total_prevLastFyDueOutstanding`).text() ) )
        $(`#s_2_total_lastFyDueLoanee`).text( convertNumberToCommaSeparetedString( $(`#s_2_total_lastFyDueLoanee`).text() ) )
        $(`#s_2_total_lastFyDueCollection`).text( convertNumberToCommaSeparetedString( $(`#s_2_total_lastFyDueCollection`).text() ) )
        $(`#s_2_total_lastFyDueOutstanding`).text( convertNumberToCommaSeparetedString( $(`#s_2_total_lastFyDueOutstanding`).text() ) )
        
        $(`#total_prevLastFyDueLoanee`).text( convertNumberToCommaSeparetedString( $(`#total_prevLastFyDueLoanee`).text() ) )
        $(`#total_lastFyDueLoanee`).text( convertNumberToCommaSeparetedString( $(`#total_lastFyDueLoanee`).text() ) )
        $(`#total_prevLastFyDueCollection`).text( convertNumberToCommaSeparetedString( $(`#total_prevLastFyDueCollection`).text() ) )
        $(`#total_lastFyDueCollection`).text( convertNumberToCommaSeparetedString( $(`#total_lastFyDueCollection`).text() ) )
        $(`#total_prevLastFyDueOutstanding`).text( convertNumberToCommaSeparetedString( $(`#total_prevLastFyDueOutstanding`).text() ) )
        $(`#total_lastFyDueOutstanding`).text( convertNumberToCommaSeparetedString( $(`#total_lastFyDueOutstanding`).text() ) )

        calculateGrandTotal()
      

        productCategoryKeys.forEach( (catId, index) => {

            calculateLoanee(catId)
            calculateCollection(catId)  
            calculateOutstanding(catId)

            $(`#loanee_prevOpening_${catId}`).text( convertNumberToCommaSeparetedString( $(`#loanee_prevOpening_${catId}`).text() ) )
            $(`#loanee_opening_${catId}`).text( convertNumberToCommaSeparetedString( $(`#loanee_opening_${catId}`).text() ) )
            $(`#collection_prevOpening_${catId}`).text( convertNumberToCommaSeparetedString( $(`#collection_prevOpening_${catId}`).text() ) )
            $(`#collection_opening_${catId}`).text( convertNumberToCommaSeparetedString( $(`#collection_opening_${catId}`).text() ) )
            $(`#outstanding_prevOpening_${catId}`).text( convertNumberToCommaSeparetedString( $(`#outstanding_prevOpening_${catId}`).text() ) )
            $(`#outstanding_opening_${catId}`).text( convertNumberToCommaSeparetedString( $(`#outstanding_opening_${catId}`).text() ) )
                    
            for(let monthNo=1; monthNo<=12; monthNo++) {

                $(`#loanee_${catId}_${monthNo}`).val( convertNumberToCommaSeparetedString( $(`#loanee_${catId}_${monthNo}`).val() ) )
                $(`#collection_${catId}_${monthNo}`).val( convertNumberToCommaSeparetedString( $(`#collection_${catId}_${monthNo}`).val() ) )
                $(`#outstanding_${catId}_${monthNo}`).val( convertNumberToCommaSeparetedString( $(`#outstanding_${catId}_${monthNo}`).val() ) )

                let collection = $(`#collection_${catId}_${monthNo}`).val()
                let outstanding = $(`#outstanding_${catId}_${monthNo-1}`).val()
                if( monthNo == 1 ) outstanding = $(`#lastFy_outstanding_${catId}`).val() 
                 
                outstanding = parseFloat(getNumberFromCommaSeparatedString(outstanding)) - parseFloat(getNumberFromCommaSeparatedString(collection))
                outstanding = convertNumberToCommaSeparetedString( outstanding )
                for(let i=monthNo; i<=12; i++) $(`#outstanding_${catId}_${i}`).val( outstanding )

                calculateLoanee(catId)
                calculateCollection(catId)   
                calculateOutstanding(catId)
                calculateGrandTotal()

                $(`input#loanee_${catId}_${monthNo}`).on('input',function(e){     
                    this.value = convertNumberToCommaSeparetedString( this.value )            
                    calculateLoanee(catId)
                    calculateGrandTotal()
                }); // on loanee input change

                $(`input#collection_${catId}_${monthNo}`).on('input',function(e){
                    this.value = convertNumberToCommaSeparetedString( this.value )
                    calculateCollection(catId)     
                                        
                    let outstanding = $(`#outstanding_${catId}_${monthNo-1}`).val()
                    if( monthNo == 1 ) outstanding = $(`#lastFy_outstanding_${catId}`).val()  
                    outstanding = parseFloat(getNumberFromCommaSeparatedString(outstanding)) - parseFloat(getNumberFromCommaSeparatedString(this.value ))
                    outstanding = convertNumberToCommaSeparetedString( outstanding )
                    for(let i=monthNo; i<=12; i++) $(`#outstanding_${catId}_${i}`).val( outstanding )

                    calculateOutstanding(catId)
                    calculateGrandTotal()
                }); // on collection input change            
                
                // $(`input#outstanding_${catId}_${monthNo}`).on('input',function(e){
                //     this.value = convertNumberToCommaSeparetedString( this.value )
                //     calculateOutstanding(catId);                    
                //     calculateGrandTotal();
                // }); // on outstanding input change            
                        
                
            } // months loop end

        }); // category loop end

        
        function calculateLoanee(catId){
            total_loanee[catId] = 0;
            for(let i=1; i<=12; i++) {
                let val = $(`#loanee_${catId}_${i}`).val()
                total_loanee[catId] += parseInt( getNumberFromCommaSeparatedString(val) )
            }
            $(`#total_loanee_${catId}`).text( convertNumberToCommaSeparetedString( total_loanee[catId] ) )
            $(`#totalform_loanee_${catId}`).val( convertNumberToCommaSeparetedString( total_loanee[catId] ) )

            let lastFy_loanee = getNumberFromCommaSeparatedString( $(`#lastFy_loanee_${catId}`).val() )
            $(`#closing_loanee_${catId}`).text( convertNumberToCommaSeparetedString( parseInt(total_loanee[catId]) + parseInt(lastFy_loanee) ) )
        }
        
        function calculateCollection(catId){
            total_collection[catId] = 0
            for(let i=1; i<=12; i++) {
                let val = $(`#collection_${catId}_${i}`).val()
                total_collection[catId] += parseFloat( getNumberFromCommaSeparatedString(val) )
            }
            $(`#total_collection_${catId}`).text( convertNumberToCommaSeparetedString( total_collection[catId] ) )
            $(`#totalform_collection_${catId}`).val( convertNumberToCommaSeparetedString( total_collection[catId] ) )

            let lastFy_collection = getNumberFromCommaSeparatedString( $(`#lastFy_collection_${catId}`).val() )
            $(`#closing_collection_${catId}`).text( convertNumberToCommaSeparetedString( parseFloat(total_collection[catId]) - parseFloat(lastFy_collection) ) )
        }
        
        function calculateOutstanding(catId){
            total_outstanding[catId] = 0
            for(let i=1; i<=12; i++) {
                let val = $(`#outstanding_${catId}_${i}`).val()
                total_outstanding[catId] = parseFloat( getNumberFromCommaSeparatedString(val) )
            }
            $(`#total_outstanding_${catId}`).text( convertNumberToCommaSeparetedString( total_outstanding[catId] ) )
            $(`#totalform_outstanding_${catId}`).val( convertNumberToCommaSeparetedString( total_outstanding[catId] ) )

            let lastFy_outstanding = getNumberFromCommaSeparatedString( $(`#lastFy_outstanding_${catId}`).val() )
            $(`#closing_outstanding_${catId}`).text( convertNumberToCommaSeparetedString( parseFloat(total_outstanding[catId]) ) )
        }
        
        function calculateGrandTotal() {           

            let gTotalLoanee = 0 
            let gTotalCollection = 0 
            let gTotalOutstanding = 0 

            let gClosingLoanee = 0 
            let gClosingCollection = 0 
            let gClosingOutstanding = 0 

            let S2TotalLoanee = 0 
            let S2TotalCollection = 0 
            let S2TotalOutstanding = 0

            let total_lastFyDueLoanee = getNumberFromCommaSeparatedString( $(`#total_lastFyDueLoanee`).text() )
            let total_lastFyDueCollection = getNumberFromCommaSeparatedString( $(`#total_lastFyDueCollection`).text() )
            let total_lastFyDueOutstanding = getNumberFromCommaSeparatedString( $(`#total_lastFyDueOutstanding`).text() )
            
            for(let i=1; i<=12; i++) 
            {
                let totalLoanee = 0
                let totalCollection = 0
                let totalOutstanding = 0

                let s2totalLoanee = 0
                let s2totalCollection = 0
                let s2totalOutstanding = 0
                
                productCategoryKeys.forEach( (catId, index) => {
                    let l_val = $(`#loanee_${catId}_${i}`).val()
                    totalLoanee += parseInt( getNumberFromCommaSeparatedString(l_val) )

                    let c_val = $(`#collection_${catId}_${i}`).val()
                    totalCollection += parseFloat( getNumberFromCommaSeparatedString(c_val) )
                    
                    let o_val = $(`#outstanding_${catId}_${i}`).val()
                    totalOutstanding += parseFloat( getNumberFromCommaSeparatedString(o_val) )

                    // Sub total Calculation
                    if( catId == 2 || catId == 17 ) {
                        s2totalLoanee += parseInt( getNumberFromCommaSeparatedString(l_val) )
                        s2totalCollection += parseFloat( getNumberFromCommaSeparatedString(c_val) )
                        s2totalOutstanding += parseFloat( getNumberFromCommaSeparatedString(o_val) )                        
                    }
                });
                
                // Sub total Calculation
                $(`#s_1_Total_loanee_${i}`).text( convertNumberToCommaSeparetedString( totalLoanee - s2totalLoanee ) )
                $(`#s_1_Total_collection_${i}`).text( convertNumberToCommaSeparetedString( totalCollection - s2totalCollection ) )
                $(`#s_1_Total_outstanding_${i}`).text( convertNumberToCommaSeparetedString( totalOutstanding - s2totalOutstanding ) )
                $(`#s_2_Total_loanee_${i}`).text( convertNumberToCommaSeparetedString( s2totalLoanee ) )
                $(`#s_2_Total_collection_${i}`).text( convertNumberToCommaSeparetedString( s2totalCollection ) )
                $(`#s_2_Total_outstanding_${i}`).text( convertNumberToCommaSeparetedString( s2totalOutstanding ) )

                S2TotalLoanee += s2totalLoanee
                S2TotalCollection += s2totalCollection
                S2TotalOutstanding = s2totalOutstanding
                
                // Grand total Calculation 
                $(`#gTotal_loanee_${i}`).text( convertNumberToCommaSeparetedString( totalLoanee ) )
                $(`#gTotal_collection_${i}`).text( convertNumberToCommaSeparetedString( totalCollection ) )
                $(`#gTotal_outstanding_${i}`).text( convertNumberToCommaSeparetedString( totalOutstanding ) )
                            
                gTotalLoanee        += totalLoanee
                gTotalCollection    += totalCollection
                gTotalOutstanding   = totalOutstanding
                
                gClosingLoanee = parseInt( total_lastFyDueLoanee ) - parseInt( gTotalLoanee );
                gClosingCollection = parseFloat( gTotalCollection ) + parseFloat( total_lastFyDueCollection )
                gClosingOutstanding = parseFloat( gTotalOutstanding ) 
                // gClosingOutstanding = parseFloat( gTotalOutstanding ) + parseFloat( total_lastFyDueOutstanding )
            }

            // Sub Total Calculation
            $(`#s_1_TotalLoanee`).text( convertNumberToCommaSeparetedString( gTotalLoanee - S2TotalLoanee ) )
            $(`#s_1_TotalCollection`).text( convertNumberToCommaSeparetedString( gTotalCollection - S2TotalCollection ) )
            $(`#s_1_TotalOutstanding`).text( convertNumberToCommaSeparetedString( gTotalOutstanding - S2TotalOutstanding ) )
            $(`#s_2_TotalLoanee`).text( convertNumberToCommaSeparetedString( S2TotalLoanee ) )
            $(`#s_2_TotalCollection`).text( convertNumberToCommaSeparetedString( S2TotalCollection ) )
            $(`#s_2_TotalOutstanding`).text( convertNumberToCommaSeparetedString( S2TotalOutstanding ) )

            // Grand Total Calculation            
            $(`#gTotalLoanee`).text( convertNumberToCommaSeparetedString( gTotalLoanee ) )
            $(`#gTotalCollection`).text( convertNumberToCommaSeparetedString( gTotalCollection ) )
            $(`#gTotalOutstanding`).text( convertNumberToCommaSeparetedString( gTotalOutstanding ) )
            
            $(`#gClosingLoanee`).text( convertNumberToCommaSeparetedString( gClosingLoanee ) )
            $(`#gClosingCollection`).text( convertNumberToCommaSeparetedString( gClosingCollection ) )
            // $(`#gClosingCollection`).text( convertNumberToCommaSeparetedString( gTotalCollection ) )
            $(`#gClosingOutstanding`).text( convertNumberToCommaSeparetedString( gClosingOutstanding ) )

            // Sub Total Fy Calculation
            let opening_loanee1 = parseInt( getNumberFromCommaSeparatedString( $(`#s_1_total_lastFyDueLoanee`).text() ));
            let opening_collection1 = parseInt( getNumberFromCommaSeparatedString( $(`#s_1_total_lastFyDueCollection`).text() ));
            let total_outstanding1 = parseInt( getNumberFromCommaSeparatedString( $(`#s_1_TotalOutstanding`).text() ));
            $(`#s_1_TotalLoaneeFy`).text( convertNumberToCommaSeparetedString( (gTotalLoanee - S2TotalLoanee)+opening_loanee1 ) )
            $(`#s_1_TotalCollectionFy`).text( convertNumberToCommaSeparetedString( (gTotalCollection - S2TotalCollection) - opening_collection1 ) )
            $(`#s_1_TotalOutstandingFy`).text( convertNumberToCommaSeparetedString( total_outstanding1 ) )

            let opening_loanee2 = parseInt( getNumberFromCommaSeparatedString( $(`#s_2_total_lastFyDueLoanee`).text() ));
            let opening_collection2 = parseInt( getNumberFromCommaSeparatedString( $(`#s_2_total_lastFyDueCollection`).text() ));
            let total_outstanding2 = parseInt( getNumberFromCommaSeparatedString( $(`#s_2_TotalOutstanding`).text() ));
            $(`#s_2_TotalLoaneeFy`).text( convertNumberToCommaSeparetedString( S2TotalLoanee + opening_loanee2 ) )
            $(`#s_2_TotalCollectionFy`).text( convertNumberToCommaSeparetedString( S2TotalCollection - opening_collection2 ) )
            $(`#s_2_TotalOutstandingFy`).text( convertNumberToCommaSeparetedString( total_outstanding2 ) )

            // dueCollectionNotMoreThenOutstanding();
        }

        $('input:enabled').on('keyup', dueCollectionNotMoreThenOutstanding);
        
        function dueCollectionNotMoreThenOutstanding() {
            let totalDueCollection = parseFloat( getNumberFromCommaSeparatedString($(`#gTotalCollection`).text()));
            let openingDueOutstanding = parseFloat( getNumberFromCommaSeparatedString($(`#total_lastFyDueOutstanding`).text()));
            if (totalDueCollection > openingDueOutstanding) {
                $(`#budget-form`).find(':submit').attr('disabled','disabled') ;
                toastr.error("Total Due Collection can not be more than Opening Due Outstanding", 'Error');
            }else{
                $(`#budget-form`).find(':submit').attr('disabled', false) ;
            }
        }

        function cleanValuesBeforeSubmit()
        {
            productCategoryKeys.forEach( (catId, index) => {                       
                for(let monthNo=1; monthNo<=12; monthNo++) {
                    $(`#loanee_${catId}_${monthNo}`).val( getNumberFromCommaSeparatedString( $(`#loanee_${catId}_${monthNo}`).val() ) )
                    $(`#collection_${catId}_${monthNo}`).val( getNumberFromCommaSeparatedString( $(`#collection_${catId}_${monthNo}`).val() ) )
                    $(`#outstanding_${catId}_${monthNo}`).val( getNumberFromCommaSeparatedString( $(`#outstanding_${catId}_${monthNo}`).val() ) )                                                        
                } // months loop end

                $(`#prevLastFy_loanee_${catId}`).val( getNumberFromCommaSeparatedString( $(`#prevLastFy_loanee_${catId}`).val() ) )  
                $(`#lastFy_loanee_${catId}`).val( getNumberFromCommaSeparatedString( $(`#lastFy_loanee_${catId}`).val() ) )  
                $(`#totalform_loanee_${catId}`).val( getNumberFromCommaSeparatedString( $(`#totalform_loanee_${catId}`).val() ) )  
                $(`#prevLastFy_collection_${catId}`).val( getNumberFromCommaSeparatedString( $(`#prevLastFy_collection_${catId}`).val() ) )  
                $(`#lastFy_collection_${catId}`).val( getNumberFromCommaSeparatedString( $(`#lastFy_collection_${catId}`).val() ) )  
                $(`#totalform_collection_${catId}`).val( getNumberFromCommaSeparatedString( $(`#totalform_collection_${catId}`).val() ) )  
                $(`#prevLastFy_outstanding_${catId}`).val( getNumberFromCommaSeparatedString( $(`#prevLastFy_outstanding_${catId}`).val() ) )  
                $(`#lastFy_outstanding_${catId}`).val( getNumberFromCommaSeparatedString( $(`#lastFy_outstanding_${catId}`).val() ) )  
                $(`#totalform_outstanding_${catId}`).val( getNumberFromCommaSeparatedString( $(`#totalform_outstanding_${catId}`).val() ) )                  
            }); // category loop end
        }

        // SUBMIT
        $('#budget-form').submit(function( event ) {
            event.preventDefault()        
            $(this).find(':submit').attr('disabled','disabled')  
            cleanValuesBeforeSubmit()
            let csrf = "{{csrf_token()}}"
            let serializeValue=$(this).serialize()

            let projectId = "{{ $projectId }}"
            let projectTypeIdFk = "{{ $projectTypeIdFk }}"
            let branchId = "{{ $branchId }}"
            let fiscalYearId = "{{ $fiscalYearId }}"
            let typeId = "{{ $typeId }}"
            let productCategoryKeys = "{{ $productCategoryKeys }}"

            formData = new FormData();
            formData.append('_token', csrf)
            formData.append('serializeValue', serializeValue)
            formData.append('projectId', projectId)
            formData.append('projectTypeIdFk', projectTypeIdFk)
            formData.append('branchId', branchId)
            formData.append('fiscalYearId', fiscalYearId)
            formData.append('typeId', typeId)
            formData.append('productCategoryKeys', productCategoryKeys)
                                   
            
            $.ajax({
                processData: false,
                contentType: false,
                type: 'post',
                url: '{{url("misYearlyBudget/update")}}',
                data: formData,
                dataType: 'json',
                success: function( data ){
                    if (data.responseTitle=='Success!') { 
                        toastr.success(data.responseText, data.responseTitle, opts);
                        setTimeout(() => { window.location.href = '{{url('misYearlyBudget/view')}}' }, 1000)
                    }
                    if (data.responseTitle=='Warning!') toastr.warning(data.responseText, data.responseTitle, opts)
                },
                error: function( data ){
                    console.log(data)
                }
            });

        });
        // END OF SUBMIT

    });

</script>
    
@endsection