@extends('layouts/gnr_layout')
@section('title', '| Bank')
@section('content')


    @php
        $bankIdsFromLoanRegisterTable = DB::table('acc_loan_register_account')
            ->distinct()
            ->pluck('bankId_fk')
            ->toArray();
        $bankIdsFromBankBranchTable = DB::table('gnr_bank_branch')->distinct()->pluck('bankId_fk')->toArray();

        $foreignBankIds = array_merge($bankIdsFromLoanRegisterTable, $bankIdsFromBankBranchTable);
        $foreignBankIds = array_unique($foreignBankIds);
    @endphp



    <div class="row">
        <div class="col-md-2"></div>
        <div class="col-md-8">
            <div class="" style="">
                <div class="">
                    <div class="panel panel-default" style="background-color:#708090;">
                        <div class="panel-heading" style="padding-bottom:0px">
                            <div class="panel-options">
                                {{-- <a href="{{ url('addBank/') }}" class="btn btn-info pull-right addViewBtn"><i
                                        class="glyphicon glyphicon-plus-sign addIcon"></i>Add Bank/Donor</a> --}}
                                <button href="javascript:;" class="btn btn-info pull-right add-modal" >
                                    <i class="glyphicon glyphicon-plus-sign addIcon"></i>Add Bank Routing
                                </button>
                            </div>
                            <h1 align="center" style="font-family: Antiqua;letter-spacing: 2px">
                                <font color="white">Bank Routing List</font>
                            </h1>
                        </div>

                        <div class="panel-body panelBodyView">
                            <div>
                                <script type="text/javascript">
                                    jQuery(document).ready(function($) {
                                        /*$("#bankTable").dataTable().yadcf([

                                        ]);*/
                                        $("#bankTable").dataTable({

                                            "oLanguage": {
                                                "sEmptyTable": "No Records Available",
                                                "sLengthMenu": "Show _MENU_ "
                                            }
                                        });


                                    });
                                </script>
                            </div>
                            <table class="table table-striped table-bordered" id="bankTable" style="color:black;">
                                <thead>
                                    <tr>
                                        <th width="30">SL#</th>
                                        <th>Bank Name</th>
                                        <th>Short Code</th>
                                        <th>Branch Name</th>
                                        <th>Routing Number</th>
                                        @if ($actionVisible == true) <th>Action</th> @endif
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach ($bankRoutings as $index => $bankRouting)
                                        <tr>
                                            <td>{{ $loop->iteration }}</td>
                                            <td class="name">{{ optional($bankRouting->bankInfo)->name }}</td>
                                            <td class="name">{{ $bankRouting->bank_id }}</td>
                                            <td class="name">{{ $bankRouting->branch_name }}</td>
                                            <td class="name">{{ $bankRouting->routing_number }}</td>
                                            <td width="80">
                                                @if ($actionVisible == true)
                                                    <a href="javascript:;" class="edit-modal" routingId="{{ $bankRouting->id }}">
                                                        <span class="glyphicon glyphicon-edit"></span>
                                                    </a>&nbsp;

                                                    <a href="javascript:;" class="delete-modal" routingId="{{ $bankRouting->id }}">
                                                        <span class="glyphicon glyphicon-trash"></span>
                                                    </a>
                                                @endif
                                            </td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-2"></div>
    </div>
    

    {{-- add Modal --}}
    <div id="addModal" class="modal fade" style="margin-top:3%">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <h4 class="modal-title"style="clear:both;background-color:black;color:white; padding:10px;text-align:center">Add Bank Routing</h4>
                </div>
                <div class="modal-body">

                    <div class="row" style="padding-bottom: 20px;">

                        <div class="col-md-12">
                            <div class="col-md-12" style="padding-right:2%;">{{-- 1st col-md-6 --}}
                                <div class="form-horizontal form-groups">
                                    <form id="addForm">
                                        <div class="form-group">
                                            <label for="exampleFormControlSelect1">Bank Name</label>
                                            <select class="form-control bankName" id="exampleFormControlSelect1" name="bankName">
                                              <option value="">Select Bank</option>
                                              @foreach ($grnBanks as $grnBank)
                                                <option value="{{$grnBank->id}}">{{$grnBank->name_code}}</option>
                                              @endforeach
                                            </select>
                                        </div>
                                        <div class="form-group">
                                            <label for="exampleFormControlInput1">Branch Name</label>
                                            <input type="text" class="form-control branchName" name="branchName" placeholder="Branch Name">
                                        </div>
                                        <div class="form-group">
                                            <label for="exampleFormControlInput1">Routing Number</label>
                                            <input type="number" class="form-control routingNumber" name="routingNumber" placeholder="Routing Number" min="9" max="9" >
                                        </div>
                                    </form>
                                </div>
                            </div>
                        </div>

                    </div>{{-- row --}}

                    {{-- add ModalFooter --}}
                    <div class="modal-footer">
                        <button id="addButton" class="btn actionBtn glyphicon glyphicon-check btn-success edit"
                            paymentId="0" type="button"> Add</button>
                        <button class="btn btn-danger glyphicon glyphicon-remove" data-dismiss="modal"
                            id="footer_action_button_dismis" type="button"><span> Close</span></button>
                    </div>


                </div> {{-- End add Modal Body --}}

            </div>
        </div>
    </div>
    {{-- End add Modal --}}

    {{-- Edit Modal --}}
    <div id="editModal" class="modal fade" style="margin-top:3%">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <h4 class="modal-title"
                        style="clear:both;background-color:black;color:white; padding:10px;text-align:center">Update Bank Routing
                    </h4>
                </div>
                <div class="modal-body">

                    <div class="row" style="padding-bottom: 20px;">

                        <div class="col-md-12">
                            <div class="col-md-12" style="padding-right:2%;">{{-- 1st col-md-6 --}}
                                <div class="form-horizontal form-groups">
                                    <form>
                                        <input type="hidden" class="form-control" id="routingId" >
                                        <div class="form-group">
                                            <label for="exampleFormControlInput1">Bank Name</label>
                                            <input type="text" class="form-control" id="bankName" placeholder="Bank Name" readonly>
                                        </div>
                                        <div class="form-group">
                                            <label for="exampleFormControlInput1">Short Code</label>
                                            <input type="text" class="form-control" id="shortCode" placeholder="Short Code" readonly>
                                        </div>
                                        <div class="form-group">
                                            <label for="exampleFormControlInput1">Branch Name</label>
                                            <input type="text" class="form-control" id="branchName" placeholder="Branch Name">
                                        </div>
                                        <div class="form-group">
                                            <label for="exampleFormControlInput1">Routing Number</label>
                                            <input type="number" class="form-control" id="routingNumber" placeholder="Routing Number">
                                        </div>
                                    </form>
                                </div>
                            </div>
                        </div>

                    </div>{{-- row --}}

                    {{-- Edit ModalFooter --}}
                    <div class="modal-footer">
                        <button id="updateButton" class="btn actionBtn glyphicon glyphicon-check btn-success edit"
                            paymentId="0" type="button"> Update</button>
                        <button class="btn btn-danger glyphicon glyphicon-remove" data-dismiss="modal"
                            id="footer_action_button_dismis" type="button"><span> Close</span></button>
                    </div>


                </div> {{-- End Edit Modal Body --}}

            </div>
        </div>
    </div>
    {{-- End Edit Modal --}}

    {{-- Delete Modal --}}
    <div id="deleteModal" class="modal fade" style="margin-top:3%">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <h4 class="modal-title" style="clear:both;background-color:black;color:white; padding:10px">Delete!</h4>
                </div>
                <div class="modal-body">
                    <h2>Are You Confirm to Delete This Record?</h2>

                    <div class="modal-footer">
                        <input id="routingId" type="hidden" name="routingId" value="">
                        <button id="DMconfirmButton" type="button" class="btn btn-danger"> Confirm</button>
                        <button class="btn btn-warning glyphicon glyphicon-remove" data-dismiss="modal" type="button">
                            Close</button>

                    </div>

                </div>
            </div>
        </div>
    </div>
    {{-- End Delete Modal --}}

    <script type="text/javascript">
        $(document).ready(function() {
            //
            /*Add Modal*/
                $(document).on('click', '.add-modal', function() {
                    $("#addModal").modal('show');
                }); 
            
            $("#addButton").on('click',function(){
                let bankName        = $(".bankName").val();
                let branchName      = $(".branchName").val();
                let routingNumber   = $(".routingNumber").val();
                var csrf = "{{ csrf_token() }}";
                $.ajax({
                    url: '{{route("gnr.bankRouting.add")}}',
                    type: 'POST',
                    dataType: 'json',
                    data: {
                        bankName        : bankName,
                        branchName      : branchName,
                        routingNumber   : routingNumber,
                        _token: csrf
                    },
                    success: function(data) {
                        if (data.errors) {
                        } else {
                            if(data.responseTitle == "Success!"){
                                toastr.success(data.responseText, data.responseTitle, opts);
                                setTimeout(function(){
                                    window.location.href = "{{ route('gnr.bankRouting.list') }}";
                                }, 2000);
                            }else{
                                toastr.warning(data.responseText, data.responseTitle, opts);
                            }
                        }
                    },
                    error: function(_response) {
                        alert(_response.errors);
                    }
                });
            });
            /*End Add Modal*/

            /*Edit Modal*/
                $(document).on('click', '.edit-modal', function() {
                    var routingId = $(this).attr('routingId');
                    var csrf = "{{ csrf_token() }}";

                    // $("#bankId").val(bankId);

                    $.ajax({
                        url: '{{route("gnr.bankRouting.edit")}}',
                        type: 'get',
                        dataType: 'json',
                        data: {
                            routingId: routingId,
                            _token: csrf
                        },
                    })

                    .done(function(routingInfo) {
                        $("#routingId").val(routingInfo.id);
                        $("#bankName").val(routingInfo.bank_name);
                        $("#shortCode").val(routingInfo.bank_id);
                        $("#branchName").val(routingInfo.branch_name);
                        $("#routingNumber").val(routingInfo.routing_number);
                        $("#editModal").modal('show');
                    })

                    .fail(function() {
                        console.log("error");
                    })
                    .always(function() {
                        console.log("complete");
                    });
                }); 
            /*End Edit Modal*/

            /*Update Data*/
            $("#updateButton").on('click', function() {
                let routingId       = $("#routingId").val();
                let bankName        = $("#bankName").val();
                let shortCode       = $("#shortCode").val();
                let branchName      = $("#branchName").val();
                let routingNumber   = $("#routingNumber").val();
                var csrf = "{{ csrf_token() }}";
                $(".error").remove();
                $.ajax({
                    url: '{{route("gnr.bankRouting.update")}}',
                    type: 'POST',
                    dataType: 'json',
                    data: {
                        routingId : routingId,
                        bankName : bankName,
                        shortCode : shortCode,
                        branchName : branchName,
                        routingNumber : routingNumber,
                        _token: csrf
                    },
                    success: function(data) {
                        if (data.errors) {
                        } else {
                            if(data.responseTitle == "Success!"){
                                toastr.success(data.responseText, data.responseTitle, opts);
                                setTimeout(function(){
                                    window.location.href = "{{ route('gnr.bankRouting.list') }}";
                                }, 2000);
                            }else{
                                toastr.warning(data.responseText, data.responseTitle, opts);
                            }
                        }
                    },
                    error: function(_response) {
                        alert(_response.errors);
                    }
                });
            });
            /*End Update Data*/

            /*Delete Modal*/
            $(document).on('click', '.delete-modal', function() {
                var routingId = $(this).attr('routingId');
                $("#routingId").val(routingId);
                $("#deleteModal").modal('show');
            });
            /*End Delete Modal*/

            /*Delete Data*/
            $("#DMconfirmButton").on('click', function() {
                var routingId = $("#routingId").val();
                var csrf = "{{ csrf_token() }}";

                $.ajax({
                    url: '{{route("gnr.bankRouting.delete")}}',
                    type: 'POST',
                    dataType: 'json',
                    data: {
                        routingId: routingId,
                        _token: csrf
                    },

                    success: function(data) {
                        if (data.errors) {
                        } else {
                            if(data.responseTitle == "Success!"){
                                toastr.success(data.responseText, data.responseTitle, opts);
                                setTimeout(function(){
                                    window.location.href = "{{ route('gnr.bankRouting.list') }}";
                                }, 2000);
                            }else{
                                toastr.warning(data.responseText, data.responseTitle, opts);
                            }
                        }
                    },
                    error: function(_response) {
                        alert(_response.errors);
                    }
                })
            });
            /*End Delete Data*/

        }); /*Ready*/
    </script>

    @include('dataTableScript')

    <style type="text/css">
        #bankTable thead tr th {
            border-bottom: 1px solid white !important;
        }

        #bankTable tbody tr td.name {
            text-align: left;
            padding-left: 5px;
        }
    </style>

@endsection