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

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


<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 {{ $fiscalyear }} ({{ ucfirst($budgetType) }}) </span>
                <br/>
                <span style="font-size:10px; float:left">Project Name : {{ $projectName }}</span>
                <span style="font-size:10px; float:right">Branch Name : {{ $branchName }}</span>
                <br/>
                <span style="font-size:10px; float:left">Project Type : {{ $projectTypeName }}</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="2">Particulars</th>

                        @if( $branchId != 1)
                            <th rowspan="2" colspan="1">{{ $prevLastFy }}</th>
                            <th rowspan="2" colspan="1">{{ $lastFy }}</th>
                        @endif

                        <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($budgets as $key => $item) 
                        @php
                            $value[1]  = (int) $item['july'];      
                            $value[2]  = (int) $item['august'];    
                            $value[3]  = (int) $item['september']; 
                            $value[4]  = (int) $item['october'];   
                            $value[5]  = (int) $item['november'];  
                            $value[6]  = (int) $item['december'];  
                            $value[7]  = (int) $item['january'];   
                            $value[8]  = (int) $item['february'];  
                            $value[9]  = (int) $item['march'];     
                            $value[10] = (int) $item['april'];     
                            $value[11] = (int) $item['may'];       
                            $value[12] = (int) $item['june'];   
                            $total     = (int) array_sum($value);        
                        @endphp

                        <tr>
                            @if( $item['hrPosGroupDisplay']  )
                                <td class="text-left" rowspan="{{ $item['rowspan'] }}">{{ $item['hrPosGroupDisplay'] }}</td>
                            @endif

                            <td class="text-left">{{ preg_replace("/[\s_]+/", " ", $item['hrPosition']) }}</td>

                            @if( $branchId != 1)
                                <td class="text-center" id="prevLastFy_{{ $item['hrPosition'] }}">{{ number_format( $item['prevOpening'] ) }}</td>                    
                                <td class="text-center" id="lastFy_{{ $item['hrPosition'] }}">{{ number_format( $item['opening'] ) }}</td>     
                            @endif
                        
                            <input type="hidden" value="{{ $key }}" name="id_{{ $item['hrPosition'] }}" /> 
                            <input type="hidden" value="{{ $item['prevOpening'] }}" name="prevLastFy_{{ $item['hrPosition'] }}" /> 
                            <input type="hidden" value="{{ $item['opening'] }}" name="lastFy_{{ $item['hrPosition'] }}" /> 

                            @for($i = 1; $i <= 12; $i++)
                                <td>                                                                    
                                    <input @if ($monthItemNo > $i) readonly @endif onclick='checkelement(this)'
                                        id="staff_{{ $item['hrPosition'] }}_{{ $i }}" 
                                        name="staff_{{ $item['hrPosition'] }}_{{ $i }}" 
                                        value="{{ $value[$i] }}" 
                                        min="0" 
                                        type="number" 
                                        class="form-control text-center"  
                                        {{ $isEdit ? '' : 'readonly' }}
                                    />                                                                         
                                </td>
                            @endfor

                            <td> 
                                <input readonly
                                    id="total_{{ $item['hrPosition'] }}" 
                                    name="total_{{ $item['hrPosition'] }}" 
                                    value="{{ $total }}" 
                                    min="0" 
                                    type="number" 
                                    class="form-control text-center"  
                                    {{-- {{ $isEdit ? '' : 'readonly' }} --}}
                                />                                                               
                            </td>

                            <td>
                                <input readonly
                                    id="totalFy_{{ $item['hrPosition'] }}" 
                                    value="{{ $total }}" 
                                    min="0" 
                                    class="form-control text-center"  
                                />                                                               
                            </td>
                            {{-- <td>
                                <input 
                                    id="totalFy_{{ $item['hrPosition'] }}" 
                                    value="{{ $total }}" 
                                    min="0" 
                                    class="form-control text-center"  
                                    {{ $isEdit ? '' : 'readonly' }}
                                />                                                               
                            </td> --}}
                        </tr>
                        
                    @endforeach

                    <tr>
                        <td colspan="2">Total</td>

                        @if( $branchId != 1)
                            <td id="total_prevLastFy" class="text-center"> plt </td>
                            <td id="total_lastFy" class="text-center"> lt </td>
                        @endif
                        
                        @for ($i = 1; $i <= 12; $i++) 
                            <td id="gTotal_{{ $i }}" class="text-center"> t </td>
                        @endfor

                        <td id="gTotal" class="text-center"> T </td>
                        <td id="gTotalFy" class="text-center"> T </td>
                    </tr>

                </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 type="text/javascript">
    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 hr_position_infos_keys = "{{ $hr_position_infos_keys }}".split(",")
        let budgetKeys = "{{ $budgetKeys }}".split(",").map( Number )       

        let lastFy = new Array(hr_position_infos_keys.length).fill(0)
        let total_staff = new Array(hr_position_infos_keys.length).fill(0)

        let total_prevLastFy = 0
        let total_lastFy     = 0

        // calculateGrandTotal()

        hr_position_infos_keys.forEach( key => {   
            calculateStaff(key)
        })
        
        hr_position_infos_keys.forEach( key => {   
            for(let monthNo=1; monthNo<=12; monthNo++) {
                $(`input#staff_${key}_${monthNo}`).on('input',function(e) {
                    
                    for(let nextMonthNo = monthNo + 1; nextMonthNo <= 12; nextMonthNo++) {
                        $(`input#staff_${key}_${nextMonthNo}`).val( $(`input#staff_${key}_${monthNo}`).val() )
                    }

                    calculateStaff(key)
                    calculateGrandTotal()
                });                        
            } // months loop end

            total_prevLastFy += ~~parseInt( $(`#prevLastFy_${key}`).text() )
            total_lastFy     += ~~parseInt( $(`#lastFy_${key}`).text() )
        }); // category loop end

        $(`#total_prevLastFy`).text( total_prevLastFy )
        $(`#total_lastFy`).text( total_lastFy )
        calculateGrandTotal()

        function calculateStaff(key){
            lastFy[key] = ~~parseInt( $(`#lastFy_${key}`).text() )
            total_staff[key] = ~~parseInt( $(`#staff_${key}_12`).val() );
            var lastFyVal = $(`#lastFy_${key}`).text(); lastFyVal = parseInt( getNumberFromCommaSeparatedString(lastFyVal) );
            $(`#total_${key}`).val(total_staff[key])
            // $(`#totalFy_${key}`).val( total_staff[key])
            $(`#totalFy_${key}`).val(lastFyVal + total_staff[key])
        }

        function calculateGrandTotal(){           
            let gTotal = 0         
            for(let i=1; i<=12; i++) {
                let total = 0             
                hr_position_infos_keys.forEach( key => {
                    let val = ~~parseInt( $(`#staff_${key}_${i}`).val() )
                    total += val;
                });                
                $(`#gTotal_${i}`).text(total)                                           
                gTotal = total
            }
            $(`#gTotal`).text(gTotal)
            // $(`#gTotalFy`).text(gTotal)
            $(`#gTotalFy`).text(gTotal+total_lastFy)
        }


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

            formData = new FormData()
            formData.append('_token', csrf)
            formData.append('serializeValue', serializeValue)           
            formData.append('branchId', branchId)            
            formData.append('typeId', budgetType)
            formData.append('categoryKeys', hr_position_infos_keys)
            // 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