@extends('layouts/acc_layout')
@section('title', '| OTS Payment (MIS)')
@section('content')

    <div class="row">
        <div class="col-md-12">

            <div class="viewTitle" style="border-bottom: 1px solid white;">
                <a href="{{ url('acc/savingsBankPayment/') }}" class="btn btn-info pull-right addViewBtn"><i
                        class="glyphicon glyphicon-th-list viewIcon">
                    </i>OTS Bank Payment List (MIS)</a>
            </div>
            <div class="panel panel-default">
               
                <div class="panel-heading">
                    @if($action_type == 'details')
                    <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>
                    @endif
                    <div class="panel-title">{{$title}}</div>
                </div>
               

                <div class="">
                    <div class="table-responsive">
                        {!! Form::open(['url' => '#']) !!}
                            <table class="table table-striped table-bordered" style="color:black; border-collapse: collapse;">
                                <thead>
                                    <tr>
                                        <th rowspan="2">SL NO</th>
                                        <th rowspan="2">Branch Name</th>
                                        <th width="130" colspan="2">Member</th>
                                        <th width="170" rowspan="2">Savings Code</th>
                                        <th colspan="4">Member Bank</th>
                                        <th rowspan="2">Amount</th>
                                        @if ($action_type == "return")
                                        <th rowspan="2">RET. TRX.</th>
                                        @endif
                                        {{-- <th rowspan="2">Application Date</th> --}}
                                        {{-- <th style="width: 10%" rowspan="2">@if($isBulkPayment) <input type="checkbox" onClick="toggle(this)" class="form-control" style="height: 15px;"/><br/> @else Action @endif</th> --}}
                                    </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>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php 
                                    $sl = 1;
                                    @endphp
                                    @foreach ($applications as $i => $application)
                                        <tr>
                                            <td class="text-center">{{$sl++}}</td>
                                            <td class="name">{{sprintf('%03d',$application->branchCode)}} - {{$application->gnrBranchName}}</td>
                                            <td class="name">{{$application->holderName}}</td>
                                            <td class="name">{{$application->employeeId}}</td>
                                            <td>{{$application->savingsCode}}</td>
                                            <td class="name">{{$application->bankName}}</td>
                                            <td class="text-center">{{$application->accountNumber}}</td>
                                            <td class="text-center">{{$application->routingNumber}}</td>
                                            <td>{{$application->branchName}}</td>
                                            <td class="amount">{{number_format($application->amount)}}</td>
                                            @if ($action_type == "return")<td><input name="returns[]" type="checkbox" value="{{$application->id}}" @if (!empty($application->returnDate)) checked @endif /></td>@endif
                                        </tr>
                                    @endforeach
                                    @php
                                        $action_type == "return" ? $colspan = 8 : $colspan = 7;
                                    @endphp
                                    <tr class="grandTotal">
                                        <td colspan="9" style="text-align: right">Grand Total &nbsp;</td>
                                        <td class="amount">{{number_format($total_amount)}}</td>
                                        @if ($action_type == "return")
                                            <td></td>
                                        @endif
                                        
                                    </tr>
                                    @if($action_type == 'approve')
                                        <tr>
                                            <td colspan="9" style="text-align: right;" class="required"><strong> Batch Number</strong></td>
                                            <td>{!! Form::text('batchNumber', null, [ 'class' => 'form-control', 'placeholder' => 'Enter batch number', 'id' => 'batchNumber']) !!}</td>
                                        </tr>
                                    @endif
                                </tbody>
                            </table>
                            @if($action_type == 'approve')
                                {!! Form::hidden('paymentId', $payment->id) !!}
                                <ul class="pager wizard pull-right">
                                    {!! Form::button('Click here to Approve & Generate Voucher', ['id' => 'storeApprove', 'class' => 'btn btn-info', 'type' => 'submit']) !!}
                                </ul>
                            @endif
                            @if ($action_type == "return")
                                <ul class="pager wizard pull-right">
                                    {!! Form::button('Click here to Return', ['id' => 'returnApplication', 'class' => 'btn btn-info', 'type' => 'button']) !!}
                                </ul>
                            @endif
                        {!! Form::close() !!}
                    </div>
                    {{-- <div class="table-responsive">
                        {!! Form::open(['url' => '#']) !!}
                            <table class="table table-striped table-bordered" style="color:black; border-collapse: collapse;">
                                <thead>
                                    <tr>
                                    <th rowspan="2">SL#</th>
                                    <th colspan="5">Bank Account Information</th>
                                    <th rowspan="2">Savings Code</th>
                                    <th rowspan="2">Amount</th>
                                    @if ($action_type == "return")
                                        <th rowspan="2">RET. TRX.</th>
                                    @endif
                                    </tr>
                                    <tr>
                                        <th>Holder Name</th>
                                        <th>Bank Name</th>
                                        <th>A/C Number</th>
                                        <th>Routing Number</th>
                                        <th>Branch Name</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php 
                                    $sl = 1;
                                    @endphp
                                    @foreach ($applications as $i => $application)
                                        <tr>
                                            <td class="text-center">{{$sl++}}</td>
                                            <td class="name">{{$application->holderName}}</td>
                                            <td class="name">{{$application->bankName}}</td>
                                            <td class="text-center">{{$application->accountNumber}}</td>
                                            <td class="text-center">{{$application->routingNumber}}</td>
                                            <td>{{$application->branchName}}</td>
                                            <td>{{$application->savingsCode}}</td>
                                            <td class="amount">{{number_format($application->amount)}}</td>
                                            @if ($action_type == "return")<td><input name="returns[]" type="checkbox" value="{{$application->id}}" @if (!empty($application->returnDate)) checked @endif /></td>@endif
                                        </tr>
                                    @endforeach
                                    @php
                                        $action_type == "return" ? $colspan = 8 : $colspan = 7;
                                    @endphp
                                    <tr class="grandTotal">
                                        <td colspan="7" style="text-align: right">Grand Total &nbsp;</td>
                                        <td class="amount">{{number_format($total_amount)}}</td>
                                        @if ($action_type == "return")
                                            <td></td>
                                        @endif
                                        
                                    </tr>
                                    @if($action_type == 'approve')
                                        <tr>
                                            <td colspan="7" style="text-align: right;" class="required"><strong> Batch Number</strong></td>
                                            <td>{!! Form::text('batchNumber', null, [ 'class' => 'form-control', 'placeholder' => 'Enter batch number', 'id' => 'batchNumber']) !!}</td>
                                        </tr>
                                    @endif
                                </tbody>
                            </table>
                            @if($action_type == 'approve')
                                {!! Form::hidden('paymentId', $payment->id) !!}
                                <ul class="pager wizard pull-right">
                                    {!! Form::button('Click here to Approve & Generate Voucher', ['id' => 'storeApprove', 'class' => 'btn btn-info', 'type' => 'submit']) !!}
                                </ul>
                            @endif
                            @if ($action_type == "return")
                                <ul class="pager wizard pull-right">
                                    {!! Form::button('Click here to Return', ['id' => 'returnApplication', 'class' => 'btn btn-info', 'type' => 'button']) !!}
                                </ul>
                            @endif
                        {!! Form::close() !!}
                    </div> --}}
                    
                </div>
            </div>
        </div>
    </div>

    <div id="printView" hidden>
        @if ($transactionType->slug == "rtgs")
            <table  width="100%" class="table table-striped table-bordered" style="color:black; border-collapse: collapse;">
                <thead>
                    <tr>
                        <th>Beneficiary Bank Account No</th>
                        <th>Receiver Name</th>
                        <th>Amount</th>
                        <th>Routing Number</th>
                        <th>Bank Code</th>
                        <th>Narration</th>
                        <th>Email 01</th>
                        <th>Email 02</th>
                        <th>Payment Execution Date (DD-MM-YYYY)</th>
                        <th>Employee Id</th>
                    </tr>
                </thead>

                <tbody>
                    @foreach ($applicationsExport as $i => $application)
                        <tr>
                            <td class="number-format">{{$application->accountNumber}}</td>
                            <td class="name">{{$application->holderName}}</td>
                            <td class="amount">{{number_format($application->amount)}}</td>
                            <td class="number-format">{{$application->routingNumber}}</td>
                            <td class="number-format">{{$application->bankCode}}</td>
                            <td class="name">OTS Payment</td>
                            <td class="name">{{$application->branchEmail}}</td>
                            <td></td>
                            <td class="text-center"></td>
                            <td class="text-center">{{$application->employeeId}}</td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        @elseif($transactionType->slug == "beftn")
            <table  width="100%" class="table table-striped table-bordered" style="color:black; border-collapse: collapse;">
                <thead>
                    <tr>
                        <th>Beneficiary Bank Account No</th>
                        <th>Receiver Name</th>
                        <th>Amount</th>
                        <th>Routing Number</th>
                        <th>Bank Code</th>
                        <th>Narration</th>
                        <th>Mobile Number</th>
                        <th>Email 01</th>
                        <th>Email 02</th>
                        <th>Payment Execution Date (DD-MM-YYYY)</th>
                        <th>Employee Id</th>
                    </tr>
                </thead>

                <tbody>
                    @foreach ($applicationsExport as $i => $application)
                        <tr>
                            <td class="number-format">{{$application->accountNumber}}</td>
                            <td class="name">{{$application->holderName}}</td>
                            <td class="amount">{{number_format($application->amount)}}</td>
                            <td class="number-format">{{$application->routingNumber}}</td>
                            <td class="number-format">{{$application->bankCode}}</td>
                            <td class="name">OTS Payment</td>
                            <td class="number-format">{{"+88".$application->mobileNo}}</td>
                            <td class="name">{{$application->branchEmail}}</td>
                            <td></td>
                            <td></td>
                            <td class="text-center">{{$application->employeeId}}</td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        @elseif($transactionType->slug == "ft")
            <table  width="100%" class="table table-striped table-bordered" style="color:black; border-collapse: collapse;">
                <thead>
                    <tr>
                        <th>Beneficiary Bank Account No</th>
                        <th>Beneficiary Name</th>
                        <th>Amount</th>
                        <th>Narration</th>
                        <th>Mobile Number</th>
                        <th>Email 01</th>
                        <th>Email 02</th>
                        <th>Payment Execution Date (DD-MM-YYYY)</th>
                        <th>Employee Id</th>
                    </tr>
                </thead>

                <tbody>
                    @foreach ($applicationsExport as $i => $application)
                        <tr>
                            <td class="number-format">{{$application->accountNumber}}</td>
                            <td class="name">{{$application->holderName}}</td>
                            <td class="amount">{{number_format($application->amount)}}</td>
                            <td class="name">OTS Payment</td>
                            <td class="number-format">{{"+88".$application->mobileNo}}</td>
                            <td class="name">{{$application->branchEmail}}</td>
                            <td></td>
                            <td class="text-center"></td>
                            <td class="text-center">{{$application->employeeId}}</td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        @else
            <table  width="100%" class="table table-striped table-bordered" 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>
                    </tr>
                </thead>

                <tbody>
                    @foreach ($applications as $i => $application)
                        <tr>
                            <td class="text-center">{{$application->routingNumber}}</td>
                            <td></td>
                            <td class="text-center">{{$application->accountNumber}}</td>
                            <td>0</td>
                            <td class="amount">{{number_format($application->amount)}}</td>
                            <td></td>
                            <td class="name">{{$application->holderName}}</td>
                            <td class="name">OTS Payment</td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        @endif
        
    </div>


    <script type="text/javascript">
    
        $(document).ready(function(){ 
            $("#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 transactionType = "<br />
<b>Warning</b>:  Undefined variable $transactionType in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/accounting/savings/bankPayment/details.blade.php</b> on line <b>338</b><br />
<br />
<b>Warning</b>:  Attempt to read property "type" on null in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/accounting/savings/bankPayment/details.blade.php</b> on line <b>338</b><br />
";
            var today = new Date().toLocaleDateString('en-GB');
            let style = "<style>table, th, td { border: 0px; } .number-format { mso-number-format:'\\@'; text-align:center; } .text-center { text-align:center; }</style>";
            let content = style + $('#printView').html();
            let file = new Blob([content], { type: "text/html" }); // Change type to "text/html"
            let url = URL.createObjectURL(file);
            let a = $("<a />", {
                href: url,
                download: "OTS_Bank_Payment("+transactionType+")_"+ today + ".xls"
            }).appendTo("body").get(0).click();
            e.preventDefault();
        });


         /*Approve*/
            $('form').submit(function(event) {
                event.preventDefault();
                x = confirm('Are you sure to approve this?');
                if (x === false) return false;
                $("button").prop('disabled', true);
                $("#loadingModal").show();
                $.ajax({
                    type: 'post',
                    data: $('form').serialize(),
                    url: "{{ url('acc/savingsBankPayment/storeApprove') }}",
                    dataType: 'json',
                    success: function(_response) {
                        $("#loadingModal").hide();
                        $("button").prop('disabled', false);
                        $(".error").remove();
                            if (_response.errors) {
                                $.each(_response.errors, function(name, error) {
                                    $("#" + name).after("<p class='error'>* " + _response
                                        .errors[name] + "</p>");
                                });
                            } else {
                                if (_response.errors) {
                                $.each(_response.errors, function(name, error) {
                                    $("#" + name).after("<p class='error'>* " + _response
                                        .errors[name] + "</p>");
                                });
                            }else{
                                if (_response.responseTitle == 'Warning!') {
                                    toastr.warning(_response.responseText, _response.responseTitle,
                                        opts);
                                } else {
                                    toastr.success(_response.responseText, _response.responseTitle,
                                        opts);
                                    setTimeout(function() {
                                        // location.reload();
                                        window.location.href =
                                            "{{ url('acc/savingsBankPayment') }}";
                                    }, 3000);
                                }
                            }
                        }
                    },
                    error: function(_response) {
                        $("#loadingModal").hide();
                        $("button").prop('disabled', false);
                        alert('Response Error');
                    }
                });

            });
            /* End Approve*/

        // return
        $('#returnApplication').click(function(e){
            var val = [];
            $('input[name="returns[]"]:checked').each(function (i) {
                val[i] = $(this).val();
            });
            // console.log(val);
            var paymentId = <br />
<b>Warning</b>:  Undefined variable $payment in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/accounting/savings/bankPayment/details.blade.php</b> on line <b>412</b><br />
<br />
<b>Warning</b>:  Attempt to read property "id" on null in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/accounting/savings/bankPayment/details.blade.php</b> on line <b>412</b><br />
null;
            $.ajax({
                type: 'get',
                data: {
                    returnIds: val,
                    paymentId: paymentId,
                },
                url: "{{ url('acc/savingsBankPayment/returnStore') }}",
                dataType: 'json',
                success: function(_response) {
                    $(".error").remove();
                        if (_response.errors) {
                            $("submit").prop('disabled', false);
                            $.each(_response.errors, function(name, error) {
                                $("#" + name).after("<p class='error'>* " + _response
                                    .errors[name] + "</p>");
                            });
                        } else {
                            if (_response.errors) {
                            $.each(_response.errors, function(name, error) {
                                $("#" + name).after("<p class='error'>* " + _response
                                    .errors[name] + "</p>");
                            });
                        }else{
                            if (_response.responseTitle == 'Warning!') {
                                toastr.warning(_response.responseText, _response.responseTitle,
                                    opts);
                                $("submit").prop('disabled', false);
                            } else {
                                toastr.success(_response.responseText, _response.responseTitle,
                                    opts);
                                setTimeout(function() {
                                    // location.reload();
                                    window.location.href =
                                        "{{ url('acc/savingsBankPayment') }}";
                                }, 3000);
                            }
                        }
                    }
                },
                error: function(_response) {
                    $("submit").prop('disabled', false);
                    alert('Response Error');
                }
            });
        });
        // return end
    </script>   
@endsection