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


<style>

.checkbox-label {
    display: inline-block;
    width: 20px; /* Adjust the size as needed */
    height: 20px; /* Adjust the size as needed */
    background-color: #fff; /* Set the background color as needed */
    border: 1px solid #ccc; /* Set the border color as needed */
    cursor: pointer;
}

.checkbox-label i {
    display: none;
    color: red; /* Set the color of the cross mark as needed */
}

.isReturnTransaction:checked + .checkbox-label i {
    display: inline-block;
}

</style>

<div class="row add-data-form">
    <div class="col-md-1"></div>
    <div class="col-md-12 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-options">
                    <button id="printIcon" class="btn btn-info pull-right print-icon" style="margin-left: 5px">
                        <i class="fa fa-print fa-lg" aria-hidden="true"> Print </i>
                    </button>
                    <button id="btnExportExcel" class="btn btn-info pull-center print-icon"  target="_blank" style="">
                        <i class="fa-file-excel-o fa-lg" aria-hidden="true"> Excel </i>
                    </button>
               </div>

                <div class="panel-title">View 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> --}}

                                    <th width="85" rowspan="2">Voucher <br> Date</th>
                                    <th width="85" rowspan="2">Reverse <br> Voucher <br> Date</th>

                                    <th colspan="2">Status</th>
                                    
                                    @if ($transferInAccInfo->emailStatus == 1)
                                        @if (!$transferInAccInfo->approveBy)
                                            <th rowspan="2">Faild <br> Trx.</th>
                                        @else
                                            <th width="55" rowspan="2">Ret. <br> Trx.</th>
                                        @endif
                                    @endif

                                    @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>
        
                                    <th width="65">Email</th>

                                    <th width="60">Trx.</th>

                                    @foreach ($components as $component)
                                        <th width="160">{{ $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>


                                    @if($outTransactionInfo[$BankAcRegister->id]->voucherDate != null)
                                        <td style="text-align: center;"> {{  date ('d-m-Y', strtotime( $outTransactionInfo[$BankAcRegister->id]->voucherDate)) }} </td>
                                    @else
                                        <td> - </td>
                                    @endif

                                    @if($outTransactionInfo[$BankAcRegister->id]->reverseVoucherDate != null)
                                        <td style="text-align: center;"> {{  date ('d-m-Y', strtotime($outTransactionInfo[$BankAcRegister->id]->reverseVoucherDate)) }} </td>
                                    @else
                                        <td> - </td>
                                    @endif
                                    
                                    @php
                                        if ($outTransactionInfo[$BankAcRegister->id]->emailStatus == 0) {
                                            $emailStatus = 'Pending';
                                        } elseif ($outTransactionInfo[$BankAcRegister->id]->emailStatus == 1){
                                            $emailStatus = 'Delivered';
                                        }elseif ($outTransactionInfo[$BankAcRegister->id]->emailStatus == 2){
                                            $emailStatus = 'Faild';
                                        }

                                        if ($outTransactionInfo[$BankAcRegister->id]->transactionStatus == 0) {
                                            $transactionStatus = 'Pending';
                                        } elseif ($outTransactionInfo[$BankAcRegister->id]->transactionStatus == 1){
                                            $transactionStatus = 'Honoured';
                                        }elseif ($outTransactionInfo[$BankAcRegister->id]->transactionStatus == 2){
                                            $transactionStatus = 'Returned';
                                        }
                                        
                                    @endphp

                                    
                                    <td style="text-align: middle; color: {{ $emailStatus === 'Delivered' ? 'green' : ($emailStatus === 'Pending' ? 'black' : 'red') }}">
                                        {{ $emailStatus }}
                                    </td>

                                    <td style="text-align: middle; color: {{ $transactionStatus === 'Honoured' ? 'green' : ($transactionStatus === 'Pending' ? 'black' : 'red') }}">
                                        {{ $transactionStatus }}
                                    </td>


                                    @if($transferInAccInfo->emailStatus == 1)

             
                                        @if($outTransactionInfo[$BankAcRegister->id]->transactionStatus == 1 && $outTransactionInfo[$BankAcRegister->id]->reverseVoucherDate == null)
                                            <td style="text-align: middle;">
                                                {{ Form::checkbox('outBankAcIds[]', $BankAcRegister->id, null, ['class' => 'isReturnTransaction', 'id' => 'checkbox_' . $BankAcRegister->id, 'hidden']) }}
                                                <label for="checkbox_{{ $BankAcRegister->id }}" class="checkbox-label">
                                                    <i class="fas fa-times"></i>
                                                </label>
                                            </td>
                                        @else
                                            <td></td>
                                        @endif
                                     

                                    @endif


                                    @foreach ($components as $component)

                                        @php
                                            $key = $BankAcRegister->id . '.' . $BankAcRegister->ledgerIdFk . '.' . $BankAcRegister->projectId . '.' . $BankAcRegister->projectTypeId . '.' . $BankAcRegister->branchId . '.' . $component->id . '.' . $component->ledgerIdFk;
                                
                                        @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', 'readonly', '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>
                                
    
                                
                                @if($transferInAccInfo->emailStatus == 1)
                                    <td colspan="12" style= "text-align: right;  padding-right: 1em; font-weight: bold;">Total Amount</td>
                                @else
                                    <td colspan="11" style= "text-align: right;  padding-right: 1em; font-weight: bold;">Total Amount</td>
                                @endif
                                
                                @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">
                        @if(Auth::user()->branchId == 1)
                            @if($transferInAccInfo->approveBy == null)
                                {!! Form::submit('Approve', ['id' => 'add', 'class' => 'btn btn-info']) !!}
                            @else
                                {!! Form::submit('Make Reverse Voucher', ['id' => 'add', 'class' => 'btn btn-info']) !!}
                            @endif
                        @endif    
                        <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 class="footerTitle" style="border-top:1px solid white"></div>
    </div>
    <div class="col-md-1"></div>


    <div id="printView" hidden>
        <div class="table-responsive">
            <table id="fundTransferAdvice" width="100%" class="table table-striped table-bordered pomisOne" border="1pt" style="color:black; border-collapse: collapse;">
                <thead>
                    <tr>
                        <th>Recv Branch Code (9)</th>
                        <th>Tx Code</th>
                        <th>Recv A/C (17)</th>
                        <th>Debit</th>
                        <th>Credit</th>
                        <th>Recv ID (15)</th>
                        <th>Recv Name (CCD=22,CIE=15,CTX=16,PPD=22)</th>
                        <th>Payment Info (80 optional)</th>
                        <th>Receiver Email</th>
                    </tr>
                </thead>
                <tbody>
                                        @foreach ($BankAcRegisters as $BankAcRegister)

                        <br />
<b>Warning</b>:  Undefined variable $BankAcRegister in <b>/home/shikkhaplus/public_html/guk_bk/resources/views/accounting/bankAc/fundTransferDdiRegister/viewItem.blade.php</b> on line <b>359</b><br />
<br />
<b>Warning</b>:  Attempt to read property "id" on null in <b>/home/shikkhaplus/public_html/guk_bk/resources/views/accounting/bankAc/fundTransferDdiRegister/viewItem.blade.php</b> on line <b>359</b><br />
<br />
<b>Warning</b>:  Undefined variable $outTransactionInfo in <b>/home/shikkhaplus/public_html/guk_bk/resources/views/accounting/bankAc/fundTransferDdiRegister/viewItem.blade.php</b> on line <b>359</b><br />
<br />
<b>Warning</b>:  Trying to access array offset on value of type null in <b>/home/shikkhaplus/public_html/guk_bk/resources/views/accounting/bankAc/fundTransferDdiRegister/viewItem.blade.php</b> on line <b>359</b><br />
<br />
<b>Warning</b>:  Attempt to read property "totalAmount" on null in <b>/home/shikkhaplus/public_html/guk_bk/resources/views/accounting/bankAc/fundTransferDdiRegister/viewItem.blade.php</b> on line <b>359</b><br />
            
                        <tr class="item{{ ($no + 1) }}">

                            <td class="custom-format" style="text-align: left;"> {{ $BankAcRegister->acRoutingNumber }} </td>
                            <td style="text-align: right;"> 27 </td> 
                            <td class="custom-format" style="text-align: center;"> {{ $BankAcRegister->bankAcNumber }} </td>
                            <td style="text-align: right;"> {{  number_format($outTransactionInfo[$BankAcRegister->id]->totalAmount) }} </td>
                            <td style="text-align: right;"> 0 </td> 
                            <td class="custom-format" style="text-align: left;"> {{ $BankAcRegister->branchCodeWith0 }} </td>
                            <td style="text-align: left;"> {{ $BankAcRegister->acTitle }} </td>
                            <td style="text-align: left;"> Fund Transcer </td>
                            <td style="text-align: left;"></td>
                        </tr>

                    @endforeach

                </tbody>
            </table>
        </div>


        <div class="table-responsive">
            <table id="fundTransferAdvice" width="100%" class="table table-striped table-bordered pomisOne" border="1pt" style="color:black; border-collapse: collapse;">
                <thead>
                    <tr>
                        <th>Payment Type</th>
                        <th>Service Class</th>
                        <th>Company ID (10)</th>
                        <th>Company Name (16)</th>
                        <th>Entry Desc (10)</th>
                        <th>Discretionary Date (20)</th>
                        <th>Sender Name</th>
                        <th>Sender A/C</th>
                        <th>Sender Email</th>
                    </tr>
                </thead>
                <tbody>
                    
                    <tr>

                        <td class="custom-format" style="text-align: left;"> PPD </td>
                        <td style="text-align: left;"> Credit </td> 
                        <td style="text-align: left;"> C321 </td> 
                        <td style="text-align: left;"> Ambala Foundation </td> 
                        <td style="text-align: center;"> excel desc </td>
                        <td style="text-align: left;"> excel disectionary </td> 
                        <td style="text-align: left;"> Ambala Foundation </td> 
                        <td class="custom-format" style="text-align: center;"> {{ $transferInAccInfo->bankAcNumber }} </td>
                        <td style="text-align: left;"> alim@ambalafoundation.org </td> 

                    </tr>

                </tbody>
            </table>
        </div>
        
    </div>

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

        var selectedBankAcIds = [];

        $('.isReturnTransaction').change(function () {
            var checkboxId = $(this).attr('id');
            
            if ($(this).is(':checked')) {
                // Checkbox is checked, add to the array
                selectedBankAcIds.push(checkboxId);
            } else {
                // Checkbox is unchecked, remove from the array
                var index = selectedBankAcIds.indexOf(checkboxId);
                if (index !== -1) {
                    selectedBankAcIds.splice(index, 1);
                }
            }

        });

        $(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"));
        }

        

        $("#printIcon").click(function(event) {

            var mainContents = document.getElementById("printView").innerHTML;
            var win = window.open('','printwindow');
            win.document.write(mainContents);
            win.print();
            win.close();

        });


        $("#btnExportExcel").click(function (e) {
            var today = new Date().toLocaleDateString('en-GB');

            // Add a style tag with a class for preventing scientific notation and leading zeros
            let style = "<style>table, th, td { border: none; } .custom-format { mso-number-format:'\\@'; }</style>";

            // Concatenate the style tag with the HTML content
            let content = style + $('#printView').html();

            let file = new Blob([content], { type: "text/html" }); // Change type to "text/html"
            let url = URL.createObjectURL(file);

            // Specify the file format as .xls, but it will be saved as .html
            let a = $("<a />", {
                href: url,
                download: "DDI_" + today + ".xls"
            }).appendTo("body").get(0).click();

            e.preventDefault();
        });


       
        $('form').submit(function(event) {

            var approvalStatus = {!! json_encode($transferInAccInfo->approveBy) !!};

            if(approvalStatus === null){
                var url = "{{url('approveFundTransferDdiItem/')}}";
            }else{
                var url = "{{url('storeFundTransferDdiReverseVoucherItem/')}}";
            }

            event.preventDefault();

            $.ajax({
                type: 'post',
                url:   url,
                data: $('form').serialize(),
                dataType: 'json',
                success: function(_response) {
                    if (_response.errors) {

                    } else {

                        if(_response.responseTitle == "Success!"){
                            toastr.success(_response.responseText, _response.responseTitle, opts);
                            setTimeout(function(){
                                window.location.href =
                                "{{ url('fundTransferDdiRegisterListFiltering/') }}";
                            }, 2000);
                        }else{
                            toastr.warning(_response.responseText, _response.responseTitle, opts);
                        }

                    }
                },
                error: function(_response) {
                    // Handle error
                    alert(_response.errors);
                }
            });

        });


    
    }); 

</script>   

@endsection