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

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

@php
    $productCatCount = count($productCategories);
    // $productCatCount = 1;
    $productCatCount > 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>

            <!-- <button id="printIcon" class="btn btn-info pull-right print-icon" style="">
                <i class="fa fa-print fa-lg" aria-hidden="true"> Print </i>
            </button> -->

        </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 class="w240" rowspan="2" colspan="{{$colSpan}}">Components</th>

                        <th class="w80" rowspan="2" colspan="1">{{ $prevLastFy }}</th>
                        <th class="w80" 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($productCategories as $key => $item)                        
                    @foreach($particularsName as $opKey => $opName)
                        <tr>                               
                            <input type="hidden" value="{{ $item[$opKey]['id'] }}" name="id_{{ $item[$opKey]['id'] }}" /> 
                            <input type="hidden" value="{{ $item[$opKey]['id'] }}" name="id_{{ $opKey }}_{{ $key }}" />

                            @if ($productCatCount > 1)
                                @if($opKey == 'add') <td class="text-left" rowspan="4" id="{{ $key }}">{{ $item['category'] }}</td> @endif
                            @endif
                            
                            <td class="text-left"> {{ $particularsName[$opKey] }} </td>
                            @if($opKey == 'add') <td rowspan="3"></td> @endif
                            
                            @php
                                if($opKey == 'add') { 
                                    $prevLastFyClosing = 0;
                                    $lastFyClosing = $openingData[$key]['lastFyAdd'];
                                }
                                if($opKey == 'cancellation') { 
                                    $prevLastFyClosing = 0;
                                    $lastFyClosing = $openingData[$key]['lastFyCancellation'];
                                }
                                if($opKey == 'net') { 
                                    $prevLastFyClosing = 0;
                                    $lastFyClosing = $openingData[$key]['lastFyNet'];
                                }
                                if($opKey == 'closing') { 
                                    $prevLastFyClosing = $openingData[$key]['prevLastFyClosing'];
                                    $lastFyClosing = $openingData[$key]['lastFyClosing'];
                                }
                            @endphp
                                
                            @if($opKey == 'closing')
                                <td>                        
                                    <input readonly
                                        value="{{ number_format($prevLastFyClosing) }}" 
                                        id="prevLastFy_{{ $opKey }}_{{ $key }}" 
                                        name="prevLastFy_{{ $opKey }}_{{ $key }}"                                 
                                        class="form-control {{ $textStyle }}" 
                                    />
                                </td>
                            @else
                                <input readonly
                                    value="{{ number_format($prevLastFyClosing) }}" 
                                    id="prevLastFy_{{ $opKey }}_{{ $key }}" 
                                    name="prevLastFy_{{ $opKey }}_{{ $key }}" 
                                    type="hidden"
                                    class="form-control {{ $textStyle }}" 
                                />
                            @endif

                            <td>
                                <input readonly                             
                                    value="{{ number_format($lastFyClosing) }}" 
                                    id="lastFy_{{ $opKey }}_{{ $key }}" 
                                    name="lastFy_{{ $opKey }}_{{ $key }}"     
                                    class="form-control {{ $textStyle }}"                         
                                /> 
                            </td>

                            @foreach($fyMonths as $i => $month) 
                                <td> 
                                    <input @if ($monthItemNo > $i) readonly @endif onclick='checkelement(this)'
                                        value="{{ $item[$opKey][$month] }}"
                                        id="{{ $opKey }}_{{ $key }}_{{ $i }}" 
                                        name="{{ $opKey }}_{{ $key }}_{{ $i }}" 
                                        class="form-control {{ $textStyle }}" 
                                        {{ $isEdit && ($opKey == 'add' || $opKey == 'cancellation') ? '' : 'readonly' }}                                        
                                    /> 
                                </td>
                            @endforeach

                            <td> 
                                <input readonly
                                    id="total_{{ $opKey }}_{{ $key }}" 
                                    name="total_{{ $opKey }}_{{ $key }}" 
                                    class="form-control {{ $textStyle }}" 
                                /> 
                            </td>

                            <td>
                                <input readonly
                                id="totalFy_{{ $opKey }}_{{ $key }}" 
                                name="totalFy_{{ $opKey }}_{{ $key }}"  
                                class="form-control {{ $textStyle }}" 
                                />
                            </td>
                             
                            
                        </tr>

                    @endforeach
                    @endforeach

                    @if ($productCatCount > 1)
                        @foreach($particularsName as $opKey => $opName)
                            <tr class="level-constant">
                                @if($opKey == 'add') <td rowspan="4">Total</td> @endif
                                <td class="text-left"> {{ $particularsName[$opKey] }} </td>
                                @if($opKey == 'add') <td rowspan="3"></td> @endif
                                
                                @php
                                    if($opKey == 'add')           $totalLastFy = $total_lastFy_add;                        
                                    if($opKey == 'cancellation')  $totalLastFy = $total_lastFy_cancellation;                        
                                    if($opKey == 'net')           $totalLastFy = $total_lastFy_net;                        
                                    if($opKey == 'closing')       $totalLastFy = $total_lastFy_closing;                        
                                @endphp
                                
                                @if($opKey == 'closing') <td id="totalPrevLastFy_{{ $opKey }}" class="{{ $textStyle }}">{{ number_format($total_prevLastFy_closing) }}</td> @endif
                                <td id="totalLastFy_{{ $opKey }}" class="{{ $textStyle }}">{{ number_format($totalLastFy) }}</td>

                                @for ($i = 1; $i <= 12; $i++) 
                                    <td id="gTotal_{{ $opKey }}_{{ $i }}" class="{{ $textStyle }}">0</td>
                                @endfor

                                <td id="gTotal_{{ $opKey }}" class="{{ $textStyle }}">0</td>
                                <td id="gTotalFy_{{ $opKey }}" class="{{ $textStyle }}">0</td>
                            </tr>
                        @endforeach
                    @endif
                    
                </tbody>

                <tfoot>
                    <td colspan="18" 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(/[^-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 particularsKeys = "{{ $particularsKeys }}".split(",")
        let productCategoryKeys = "{{ $productCategoryKeys }}".split(",").map( Number )
        
        let total_add           = new Array(productCategoryKeys.length).fill(0)
        let total_cancellation  = new Array(productCategoryKeys.length).fill(0)
        let total_net           = new Array(productCategoryKeys.length).fill(0)
        let total_closing       = new Array(productCategoryKeys.length).fill(0)

        particularsKeys.forEach( opKey => {
            $(`#totalPrevLastFy_${opKey}`).text( convertNumberToCommaSeparetedString( $(`#totalPrevLastFy_${opKey}`).text() ) )                
            $(`#totalLastFy_${opKey}`).text( convertNumberToCommaSeparetedString( $(`#totalLastFy_${opKey}`).text() ) )                
            $(`#gTotal_${opKey}`).text( convertNumberToCommaSeparetedString( $(`#gTotal_${opKey}`).text() ) )                
            $(`#gTotalFy_${opKey}`).text( convertNumberToCommaSeparetedString( $(`#gTotalFy_${opKey}`).text() ) )       
            
            productCategoryKeys.forEach( (catId, index) => {
                $(`#prevLastFy_${opKey}_${catId}`).text( convertNumberToCommaSeparetedString( $(`#prevLastFy_${opKey}_${catId}`).text() ) )                
                $(`#lastFy_${opKey}_${catId}`).val( convertNumberToCommaSeparetedString( $(`#lastFy_${opKey}_${catId}`).val() ) )                
            })

            for(let i = 1; i <= 12; i++) {
                $(`#gTotal_${opKey}_${i}`).text( convertNumberToCommaSeparetedString( $(`#gTotal_${opKey}_${i}`).text() ) ) 
            }            
        })

        // calculateGrandTotal()
        
        productCategoryKeys.forEach( (catId, index) => {
            
            calculateAdd(catId)
            calculateCancellation(catId)  
            calculateNet(catId)
            calculateClosing(catId)

            for(let monthNo=1; monthNo<=12; monthNo++) {

                $(`#add_${catId}_${monthNo}`).val( convertNumberToCommaSeparetedString( $(`#add_${catId}_${monthNo}`).val() ) )
                $(`#cancellation_${catId}_${monthNo}`).val( convertNumberToCommaSeparetedString( $(`#cancellation_${catId}_${monthNo}`).val() ) )
                $(`#net_${catId}_${monthNo}`).val( convertNumberToCommaSeparetedString( $(`#net_${catId}_${monthNo}`).val() ) )
                $(`#closing_${catId}_${monthNo}`).val( convertNumberToCommaSeparetedString( $(`#closing_${catId}_${monthNo}`).val() ) )
                
                $(`input#add_${catId}_${monthNo}`).on('input',function(e) {   
                    this.value = convertNumberToCommaSeparetedString( this.value )                 
                    calculateAdd(catId)
                    calculateNet(catId)
                    calculateClosing(catId)
                    calculateGrandTotal()
                }); // on add input change

                $(`input#cancellation_${catId}_${monthNo}`).on('input',function(e) {
                    this.value = convertNumberToCommaSeparetedString( this.value )
                    calculateCancellation(catId)                  
                    calculateNet(catId)
                    calculateClosing(catId)
                    calculateGrandTotal()
                }); // on cancellation input change            
                         
                
            } // months loop end

        }); // category loop end

        function calculateAdd(catId){
            total_add[catId] = 0
            for(let i=1; i<=12; i++) {
                let val = $(`#add_${catId}_${i}`).val()
                total_add[catId] += ~~parseInt( getNumberFromCommaSeparatedString(val) )
            }
            $(`#total_add_${catId}`).val( convertNumberToCommaSeparetedString(total_add[catId]) )
            let lastFyVal = $(`#lastFy_add_${catId}`).val()
            let totalFyVal = ~~parseInt(total_add[catId]);
            // let totalFyVal = ~~parseInt(total_add[catId]) + ~~parseInt( getNumberFromCommaSeparatedString(lastFyVal) )
            $(`#totalFy_add_${catId}`).val( convertNumberToCommaSeparetedString(totalFyVal) )
        }

        function calculateCancellation(catId){
            total_cancellation[catId] = 0
            for(let i=1; i<=12; i++) {
                let val = $(`#cancellation_${catId}_${i}`).val()
                total_cancellation[catId] += ~~parseInt( getNumberFromCommaSeparatedString(val) )
            }
            $(`#total_cancellation_${catId}`).val( convertNumberToCommaSeparetedString(total_cancellation[catId]) )
            let lastFyVal = $(`#lastFy_cancellation_${catId}`).val()
            let totalFyVal = ~~parseInt(total_cancellation[catId]);
            // let totalFyVal = ~~parseInt(total_cancellation[catId]) + ~~parseInt( getNumberFromCommaSeparatedString(lastFyVal) )
            $(`#totalFy_cancellation_${catId}`).val( convertNumberToCommaSeparetedString(totalFyVal) )
        }
        
        function calculateNet(catId){
            total_net[catId] = 0
            for(let i=1; i<=12; i++) {
                let addVal = $(`#add_${catId}_${i}`).val()
                addVal = ~~parseInt( getNumberFromCommaSeparatedString(addVal) )
                let cancellationVal = $(`#cancellation_${catId}_${i}`).val()
                cancellationVal = ~~parseInt( getNumberFromCommaSeparatedString(cancellationVal) )
                let netVal = addVal - cancellationVal                
                total_net[catId] += ~~parseInt( netVal )               
                $(`#net_${catId}_${i}`).val( convertNumberToCommaSeparetedString(netVal) )
            }
            $(`#total_net_${catId}`).val( convertNumberToCommaSeparetedString(total_net[catId]) )
            let lastFyVal = $(`#lastFy_net_${catId}`).val()
            let totalFyVal = ~~parseInt(total_net[catId]) ;
            // let totalFyVal = ~~parseInt(total_net[catId]) + ~~parseInt( getNumberFromCommaSeparatedString(lastFyVal) )
            $(`#totalFy_net_${catId}`).val( convertNumberToCommaSeparetedString(totalFyVal) )
        }
        
        function calculateClosing(catId){
            let lastFyVal = $(`#lastFy_closing_${catId}`).val()
            lastFyVal = ~~parseInt( getNumberFromCommaSeparatedString(lastFyVal) )
            total_closing[catId] = 0
            for(let i=1; i<=12; i++) {
                let netVal = $(`#net_${catId}_${i}`).val()
                netVal = ~~parseInt( getNumberFromCommaSeparatedString(netVal) )

                let closingVal = $(`#lastFy_closing_${catId}`).val()
                if(i > 1) closingVal = $(`#closing_${catId}_${i-1}`).val()
                
                closingVal = ~~parseInt( getNumberFromCommaSeparatedString(closingVal) )
                closingVal = closingVal + netVal
                total_closing[catId] = closingVal             
                $(`#closing_${catId}_${i}`).val( convertNumberToCommaSeparetedString(closingVal) )
            }            
            $(`#total_closing_${catId}`).val( convertNumberToCommaSeparetedString(total_closing[catId]) )
            // lastFyVal = $(`#lastFy_closing_${catId}`).val()
            // let totalFyVal = ~~parseInt(total_closing[catId]) + ~~parseInt( getNumberFromCommaSeparatedString(lastFyVal) )
            // $(`#totalFy_closing_${catId}`).val( convertNumberToCommaSeparetedString(totalFyVal) )
            $(`#totalFy_closing_${catId}`).val( convertNumberToCommaSeparetedString(total_closing[catId]) )

            calculateGrandTotal()
        }        

        
        function calculateGrandTotal() {                        
            let GTotalAdd = 0 
            let GTotalCancellation = 0
            let GTotalNet = 0
            let GTotalClosing = 0

            for(let i=1; i<=12; i++) {

                let gTotalAdd = 0 
                let gTotalCancellation = 0
                let gTotalNet = 0
                let gTotalClosing = 0

                productCategoryKeys.forEach( (catId, index) => {
                    let addVal = $(`#add_${catId}_${i}`).val()
                    addVal     = ~~parseInt( getNumberFromCommaSeparatedString(addVal) )
                    gTotalAdd  += addVal
                    GTotalAdd  += addVal

                    let cancellationVal = $(`#cancellation_${catId}_${i}`).val()
                    cancellationVal     = ~~parseInt( getNumberFromCommaSeparatedString(cancellationVal) )
                    gTotalCancellation  += cancellationVal
                    GTotalCancellation  += cancellationVal
                    
                    let netVal = $(`#net_${catId}_${i}`).val()
                    netVal     = ~~parseInt( getNumberFromCommaSeparatedString(netVal) )
                    gTotalNet  += netVal
                    GTotalNet  += netVal
                    
                    let closingVal = $(`#closing_${catId}_${i}`).val()
                    closingVal     = ~~parseInt( getNumberFromCommaSeparatedString(closingVal) )
                    gTotalClosing  += closingVal
                    GTotalClosing  = gTotalClosing
                })

                $(`#gTotal_add_${i}`).text( convertNumberToCommaSeparetedString( gTotalAdd ) )
                $(`#gTotal_cancellation_${i}`).text( convertNumberToCommaSeparetedString( gTotalCancellation ) )
                $(`#gTotal_net_${i}`).text( convertNumberToCommaSeparetedString( gTotalNet ) )
                $(`#gTotal_closing_${i}`).text( convertNumberToCommaSeparetedString( gTotalClosing ) )
            }
            
            $(`#gTotal_add`).text( convertNumberToCommaSeparetedString( GTotalAdd ) )
            $(`#gTotal_cancellation`).text( convertNumberToCommaSeparetedString( GTotalCancellation ) )
            $(`#gTotal_net`).text( convertNumberToCommaSeparetedString( GTotalNet ) )
            $(`#gTotal_closing`).text( convertNumberToCommaSeparetedString( GTotalClosing ) )

            let totalLastFy_add = $(`#totalLastFy_add`).text()
            totalLastFy_add = ~~parseInt( getNumberFromCommaSeparatedString(totalLastFy_add) )

            let totalLastFy_cancellation = $(`#totalLastFy_cancellation`).text()
            totalLastFy_cancellation = ~~parseInt( getNumberFromCommaSeparatedString(totalLastFy_cancellation) )

            let totalLastFy_net = $(`#totalLastFy_net`).text()
            totalLastFy_net = ~~parseInt( getNumberFromCommaSeparatedString(totalLastFy_net) )

            let totalLastFy_closing = $(`#totalLastFy_closing`).text()
            totalLastFy_closing = ~~parseInt( getNumberFromCommaSeparatedString(totalLastFy_closing) )

            $(`#gTotalFy_add`).text( convertNumberToCommaSeparetedString( GTotalAdd ) )
            $(`#gTotalFy_cancellation`).text( convertNumberToCommaSeparetedString( GTotalCancellation ) )
            $(`#gTotalFy_net`).text( convertNumberToCommaSeparetedString( GTotalNet ) )
            $(`#gTotalFy_closing`).text( convertNumberToCommaSeparetedString( GTotalClosing ) )                        
        }


        function cleanValuesBeforeSubmit()
        {
            particularsKeys.forEach( opKey => {
                productCategoryKeys.forEach( (catId, index) => {     

                    $(`#prevLastFy_${opKey}_${catId}`).val( getNumberFromCommaSeparatedString( $(`#prevLastFy_${opKey}_${catId}`).val() ) )                                     
                    $(`#lastFy_${opKey}_${catId}`).val( getNumberFromCommaSeparatedString( $(`#lastFy_${opKey}_${catId}`).val() ) )                                     

                    for(let monthNo=1; monthNo<=12; monthNo++) {
                        $(`#${opKey}_${catId}_${monthNo}`).val( getNumberFromCommaSeparatedString( $(`#${opKey}_${catId}_${monthNo}`).val() ) )                                                                               
                    } // months loop end

                    $(`#total_${opKey}_${catId}`).val( getNumberFromCommaSeparatedString( $(`#total_${opKey}_${catId}`).val() ) )                                     
                }); // category loop end

            }); // particulars 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)
            // console.log(serializeValue);
            
            $.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
        
    }); // ready function end
</script>


@endsection