@extends('layouts/acc_layout')
@section('title', '| Fund Transfer DDI Register')
@section('content')
@include('successMsg')


<div class="row add-data-form">
    <div class="col-md-1"></div>
    <div class="col-md-10 fullbody">
        <div class="viewTitle" style="border-bottom: 1px solid white;">
            <a href="{{url('fundTransferDdiRegisterListFiltering/')}}" class="btn btn-info pull-right addViewBtn"><i class="glyphicon glyphicon-th-list viewIcon">
            </i>View Fund Transfer DDI Advice List</a>
        </div>

        <div class="panel panel-default panel-border">
            <div class="panel-heading">
                <div class="panel-title">Edit Fund Transfer DDI Request</div>
            </div>
            
            <div class="row" style=" margin: 15px 0px;">

                {!! Form::open(array('url' => '','id'=>'entryForm', 'role' => 'form', 'class'=>'form-horizontal form-groups')) !!}

           
                <input type="hidden" name="fillDateTo" value="{{ $transferInAccInfo->generateDate }}">
                <input type="hidden" name="transactionType" value="{{ $transferInAccInfo->transactionTypeId }}">
                <input type="hidden" name="accountNumber" value="{{ $transferInAccInfo->inBankAcIdFk }}">
                <input type="hidden" name="transactionId" value="{{ $transferInAccInfo->transactionId }}">


                <div class="table-responsive">

                    <div class="panel-title">Transfer To:</div>
                    
                    <table class="table table-striped table-bordered" id="vaultReport" style="color:black;">
                        <thead>
                            <tr>
                                <th colspan="2">Org. Branch</th>
                                
                                <th rowspan="2">Generate Date</th>
                                <th rowspan="2">Project Name</th>
                                
                                <th rowspan="2">Project Type</th>
                                
                                <th colspan="3">Debit Account</th>
                                <th rowspan="2">Transaction Type</th>
                            </tr>
                            <tr>
                                <th>Branch Name</th>
                                <th>Code</th>
                                <th>Bank Name</th>
                                <th>A/C Number</th>
                                <th>Branch Name</th>
                            </tr>
                        </thead>
                        <tbody>
                            <tr >
                                <td style="text-align: left; padding-left: 1em;"> {{ $transferInAccInfo->branchName }} </td>
                                <td style="text-align: middle;"> {{ $transferInAccInfo->branchCodeWith0 }} </td>
                                <td style="text-align: middle;"> {{ date ('d-m-Y', strtotime( ($transferInAccInfo->generateDate) )) }} </td>
                                <td style="text-align: left; padding-left: 1em;"> {{ $transferInAccInfo->projectName }} </td>
                                <td style="text-align: left; padding-left: 1em;"> {{ $transferInAccInfo->projectType }} </td>
    
                                <td style="text-align: left; padding-left: 1em;"> {{ $transferInAccInfo->bankName }} </td>
                                <td style="text-align: middle;"> {{ $transferInAccInfo->bankAcNumber }} </td>
                                <td style="text-align: left; padding-left: 1em;"> {{ $transferInAccInfo->bankBranchName }}, {{ $transferInAccInfo->districtName }} </td>
    
                                <td style="text-align: middle;"> {{ $transferInAccInfo->transactionType }} </td>
                
                            </tr>
                        </tbody>
                    </table><br>

        
                    <div class="panel-title">Transfer From:</div>
                                
                    <table class="table table-striped table-bordered" id="vaultReport" style="color:black;">
                        <thead>
                            <tr>
                                <tr>
                                    <th rowspan="2">SL#</th>
            
                                    <th colspan="2">Org. Branch</th>
        
                                    <th colspan="4">Bank Account Information</th>
                                    {{-- <th width="100" colspan="5">Component Amount</th> --}}

                                    @if($components->count() > 1)
                                        <th colspan="{{ $components->count() + 1 }}">Component Wise Amount</th>
                                    @else
                                        <th>Component Wise Amount</th>
                                    @endif

                                </tr>
                                <tr>
                                    <th>Name</th>
                                    <th>Code</th>
            
                                    <th>Bank Name</th>
                                    <th>A/C Number</th>
                                    <th>Routing Number</th>
                                    <th>Branch Name</th>
        
        
                                    @foreach ($components as $component)
                                        <th>{{ $component->name }}</th>
                                    @endforeach
        
                                    @if($components->count() > 1)
                                        <th>Total</th>
                                    @endif
            
                                </tr>
                            </tr>
                        </thead>
                        <tbody>

                            
                            @foreach ($BankAcRegisters as $BankAcRegister)
        
                                <tr class="item{{ ($no + 1) }}">
                                    <td class="text-center slNo">{{ ++$no }}</td>
        
                                    <td style="text-align: left; padding-left: 1em;"> {{ $BankAcRegister->branchName }} </td>
                                    <td style="text-align: middle;"> {{ $BankAcRegister->branchCodeWith0 }} </td>
                       
                                    <td style="text-align: left; padding-left: 1em;"> {{ $BankAcRegister->bankName }} </td>
                                    <td style="text-align: middle;"> {{ $BankAcRegister->bankAcNumber }} </td>
                                    <td style="text-align: middle;"> {{ $BankAcRegister->acRoutingNumber }} </td>
                                    <td style="text-align: left; padding-left: 1em;"> {{ $BankAcRegister->bankBranchName }}, {{ $BankAcRegister->district }} </td>
        
                                    @foreach ($components as $component)

                                        @php
                                            $key = $BankAcRegister->id . '.' . $BankAcRegister->ledgerIdFk . '.' . $BankAcRegister->projectId . '.' . $BankAcRegister->projectTypeId . '.' . $BankAcRegister->branchId . '.' . $component->id . '.' . $component->ledgerIdFk;
                                            //dd($FundTransferDdiRegisters);
                                        @endphp

                                        <td style="padding: 5px;"> 
                                            {!! Form::text('componentAmount['.$BankAcRegister->id.']['.$BankAcRegister->ledgerIdFk.']['.$BankAcRegister->projectId.']['.$BankAcRegister->projectTypeId.']['.$BankAcRegister->branchId.']['.$component->id.']['.$component->ledgerIdFk.']', $FundTransferDdiRegisters[$key]->amount ?? '', ['class'=>'form-control text-right amount component-amount', 'placeholder' => '-', 'data-id' => $component->id]) !!}
                                        </td>

                                    @endforeach
        
                                    @if($components->count() > 1)
                                        <td style="padding: 5px;"> 
                                            {!! Form::text('componentRowTotal', $value = null, ['class' => 'form-control text-right amount component-row-total', 'style' => 'font-weight: bold', 'readonly', 'type' => 'text', 'placeholder' => '-', 'autocomplete' => 'off']) !!}
                                        </td>
                                    @endif
            
                                </tr>

                            @endforeach
                        </tbody>
        
                        <tbody>
                            <tr>
                                <td colspan="7" style= "text-align: right;  padding-right: 1em; font-weight: bold;">Total Amount</td>
        
                                @foreach ($components as $component)
                                    <th>{!! Form::text('componentColGrandTotal['.$component->id.']', $value = null, ['class'=>'form-control text-right amount component-col-grand-total', 'readonly', 'type' => 'text', 'placeholder' => '-', 'autocomplete' => 'off']) !!}</th>
                                @endforeach
        
                                @if($components->count() > 1)
                                    <td style="padding: 5px;"> 
                                        {!! Form::text('totalColGrandTotal', $value = null, ['class' => 'form-control text-right amount total-col-grand-total', 'style' => 'font-weight: bold', 'readonly', 'type' => 'text', 'placeholder' => '-', 'autocomplete' => 'off']) !!}
                                    </td>
                                @endif
                                
                            </tr>
                        </tbody>
                        
                    </table>
                </div>

                <div class="form-group">
                    {!! Form::label('submit', ' ', ['class' => 'col-sm-5 control-label']) !!}
                    <div class="col-sm-5">
                        {!! Form::submit('Submit', ['id' => 'fundTransferSubmit', 'class' => 'btn btn-success']) !!}
                        <a href="{{ url('fundTransferDdiRegisterListFiltering/') }}"
                            class="btn btn-danger closeBtn">Close</a>
                        <span id="success" style="color:green; font-size:20px;" class="pull-right"></span>
                    </div>
                </div>

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

    </div>
    <div class="col-md-1"></div>


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

            $(document).on("input",".amount",function() {
                this.value = this.value.replace(/[^0-9]/g, '').replace(/(\..*)\./g, '$1'); 
            });

            initializeCalculations();

            // Function to initialize calculations
            function initializeCalculations() {
                $('.component-amount').each(function() {
                    // Check if the input field has a value
                    if ($(this).val()) {
                        formatNumber($(this));
                    }
                });

                $('.component-amount').trigger('keyup');
            }

            $('.component-amount').each(function () {
                var row = $(this).closest('tr');
                totalSum(row);
            });

            $('.component-row').each(function () {
                var row = $(this);
                updateComponentTotal(row);
            });

            $('.component-row').each(function () {
                var row = $(this);
                updateComponentRowTotal(row);
            });

            updateComponentGrandTotal();
            

            // Listen for input changes in the amount fields
            $(document).on('keyup', '.component-amount', function () {
                var row = $(this).closest('tr');
                formatNumber($(this));
                totalSum(row);
                updateComponentTotal(row);
                updateComponentRowTotal(row);
                updateComponentGrandTotal();
            });

            // Format number with commas
            function formatNumber(inputField) {
                var amount = +inputField.val().replaceAll(",", "");
                inputField.val(amount.toLocaleString("en-IN"));
            }

            // Addition function for each row
            function totalSum(row) {
                var total = 0;
                row.find('.component-amount').each(function () {
                    total += +$(this).val().replaceAll(",", "");
                });
                row.find('.component-row-total').val(total.toLocaleString("en-IN"));
            }

            // Update component total
            function updateComponentTotal(row) {
                var componentTotal = 0;
                row.find('.component-amount').each(function () {
                    componentTotal += +$(this).val().replaceAll(",", "");
                });
                row.find('.component-row-total').val(componentTotal.toLocaleString("en-IN"));
            }

            // Update component row total
            function updateComponentRowTotal(row) {
                var rowTotal = 0;
                row.find('.component-row-total').each(function () {
                    rowTotal += +$(this).val().replaceAll(",", "");
                });
                $('#componentColGrandTotal').val(rowTotal.toLocaleString("en-IN"));
            }
            

            // Update component grand total and totalColGrandTotal
            function updateComponentGrandTotal() {
                var totalColGrandTotal = 0;

                $('.component-col-grand-total').each(function () {
                    var identifier = $(this).attr('name').split('[')[1].split(']')[0];
                    var grandTotal = 0;

                    if (identifier) {
                        $('.component-amount[data-id="' + identifier + '"]').each(function () {
                            var amountValue = $(this).val().replaceAll(",", "");
                            grandTotal += isNaN(amountValue) ? 0 : +amountValue;
                        });

                        $(this).val(grandTotal.toLocaleString("en-IN"));
                        totalColGrandTotal += grandTotal;
                    } else {
                        console.error('Error: Unable to extract identifier for component-col-grand-total');
                    }
                });

                // Update the totalColGrandTotal field
                $('input[name="totalColGrandTotal"]').val(totalColGrandTotal.toLocaleString("en-IN"));
            }



            
            $('form').submit(function( event ) {
                event.preventDefault();
                $.ajax({
                    type: 'post',
                    url: "{{url('editFundTransferDdiItem/')}}",
                    data: $('form').serialize(),
                    dataType: 'json',
                    success: function( _response ){
                        if (_response.errors) {
                            
                        } 
                        else {
                            $('#success').text(_response.responseText);
                            window.location.href = "{{url('fundTransferDdiRegisterListFiltering/')}}";     
                        }
                    },
                    error: function( _response ){
                        // Handle error
                        alert(_response.errors);
                    }
                });
            });


        });


    </script>

@endsection