@extends('layouts.app')
@inject('controller', 'App\Http\Controllers\Controller')
@section('sidebar')
    @include('sidebar')
@stop

@section('content')
<style>
    td,th {
         vertical-align: middle;
         text-align: center;
     }
     table.table-bordered > thead > tr > th{
         border:1px solid #57596261;
     }
 
     table.table-bordered > tbody > tr > td{
         border:1px solid #57596261;
     }
     table.table-bordered.dataTable th, table.table-bordered.dataTable td {
         border-left-width: 1px !important;
     }
     table.table-bordered.dataTable th:last-child, table.table-bordered.dataTable th:last-child, table.table-bordered.dataTable td:last-child, table.table-bordered.dataTable td:last-child {
         border-right-width: 1px !important;
     }
 </style>
    <div class="m-content">
        <div class="m-portlet m-portlet--full-height ">
            <div class="m-portlet__head">
                <div class="m-portlet__head-caption">
                    <div class="m-portlet__head-title">
                        <h3 class="m-portlet__head-text">
                            Daily Report Details
                        </h3>
                    </div>
                </div>
                <div class="m-portlet__head-caption">
                    <a class="btn btn-primary" href="/daily-report">Back</a>
                </div>
            </div>
            <div class="m-portlet__body">
                @if (Session::has('success'))
                    <div class="alert alert-success">
                        {!! Session::get('success') !!}
                    </div>
                @endif

              

                <table width="100%" class="m_datatable table table-striped- table-bordered table-checkable"
                    id="user-report">

                    <thead class="table-secondary">
                        <tr>
                            <th colspan="24"><h3>{{$date}} - {{ $bank->name }}</h3></th>
                        </tr>
                        <tr>
                            <th rowspan="3" colspan="1" style="vertical-align: middle;text-align: center;">#</th>
                            <th rowspan="3" style="vertical-align: middle;text-align: center;">Name</th>
                            <th rowspan="3" style="vertical-align: middle;text-align: center;">Dollar rate</th>
                            <th rowspan="3" style="vertical-align: middle;text-align: center;">Our Transaction id</th>
                            <th rowspan="3" style="vertical-align: middle;text-align: center;">Account / Wallet</th>
                            <th colspan="9">Deposit</th>
                            <th colspan="9">Withdraw</th>
                            <th rowspan="3" style="vertical-align: middle;text-align: center;">Action</th>
                        </tr>
                        <tr>
                            <th colspan="2">Wire</th>
                            <th rowspan="2" style="vertical-align: middle;text-align: center;">Total Wire INR</th>
                            <th colspan="2">Local</th>
                            <th rowspan="2" style="vertical-align: middle;text-align: center;">Total LA INR</th>
                            <th colspan="2">UPI</th>
                            <th rowspan="2" style="vertical-align: middle;text-align: center;">Total UPI INR</th>

                            <th colspan="2">Wire</th>
                            <th rowspan="2" style="vertical-align: middle;text-align: center;">Total Wire INR</th>
                            <th colspan="2">Local</th>
                            <th rowspan="2" style="vertical-align: middle;text-align: center;">Total LA INR</th>
                            <th colspan="2">UPI</th>
                            <th rowspan="2" style="vertical-align: middle;text-align: center;">Total UPI INR</th>
                        </tr>
                        <tr>
                            <th>MT4 Account</th>
                            <th>Wallets</th>
                            <th>MT4 Account</th>
                            <th>Wallets</th>

                            <th>Clients</th>
                            <th>IB</th>
                            <th>Clients</th>
                            <th>IB</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php
                            $deposit_wire = $deposit_upi = $deposit_local = $withdrawal_wire = $withdrawal_local =  $withdrawal_upi = 0;
                        @endphp
                        @forelse ($records as $key => $record)
                            @php
                                $amount = $record->usd != '' ? $record->usd * $record->dollar_rate : '-';
                            @endphp

                            @if ($record->request == 'deposit_wire' && $record->usd != '')
                                @php $deposit_wire +=  $record->usd * $record->dollar_rate; @endphp
                            @endif
                            
                            @if ($record->request == 'deposit_upi' && $record->usd != '')
                                @php $deposit_upi +=  $record->usd * $record->dollar_rate; @endphp
                            @endif
                            
                            @if ($record->request == 'deposit_local' && $record->usd != '')
                             @php $deposit_local +=  $record->usd * $record->dollar_rate; @endphp
                            @endif

                            @if ($record->request == 'withdrawal_wire' && $record->usd != '')
                            @php $withdrawal_wire +=  $record->usd * $record->dollar_rate; @endphp
                            @endif
                            
                            @if ($record->request == 'withdrawal_upi' && $record->usd != '')
                            @php $withdrawal_upi +=  $record->usd * $record->dollar_rate; @endphp
                            @endif

                            @if ($record->request == 'withdrawal_local' && $record->usd != '')
                            @php $withdrawal_local +=  $record->usd * $record->dollar_rate; @endphp
                            @endif
                            <tr>
                                <td>{{ $key + 1 }}</td>
                                <td>{{ $record->name }} {{ $record->last_name }}</td>
                                <td>{{ '$'.$record->dollar_rate }}</td>
                                <td>{{ $record->our_transaction_id }}</td>
                                <td>{{ $record->wallet_id }}</td>
                    
                                <td>{{ $record->request == 'deposit_wire' && $record->type == 'MT4 Account' ?  '$'.$record->usd : '-' }}</td>
                                <td>{{ $record->request == 'deposit_wire' && $record->type == 'Wallet' ? '$'.$record->usd : '-' }}</td>
                                <td>{{ $record->request == 'deposit_wire' ? '₹'.round($amount,2) : '-' }}</td>
                                
                                <td>{{ $record->request == 'deposit_local' && $record->type == 'MT4 Account' ? '$'.$record->usd : '-' }}</td>
                                <td>{{ $record->request == 'deposit_local' && $record->type == 'Wallet' ? '$'.$record->usd : '-' }}</td>
                                <td>{{ $record->request == 'deposit_local' ? '₹'.round($amount,2) : '-' }}</td>
                                
                                <td>{{ $record->request == 'deposit_upi' && $record->type == 'MT4 Account' ?  '$'.$record->usd : '-' }}</td>
                                <td>{{ $record->request == 'deposit_upi' && $record->type == 'Wallet' ? '$'.$record->usd : '-' }}</td>
                                <td>{{ $record->request == 'deposit_upi' ? '₹'.round($amount,2) : '-' }}</td>
                    
                                <td>{{ $record->request == 'withdrawal_wire' && $record->type == 'clients' ? '$'.$record->usd : '-' }}</td>
                                <td>{{ $record->request == 'withdrawal_wire' && $record->type == 'ib' ? '$'.$record->usd : '-' }}</td>
                                <td>{{ $record->request == 'withdrawal_wire' ? '₹'.round($amount,2) : '-' }}</td>
                                
                                <td>{{ $record->request == 'withdrawal_local' && $record->type == 'clients' ? '$'.$record->usd : '-' }}</td>
                                <td>{{ $record->request == 'withdrawal_local' && $record->type == 'ib' ? '$'.$record->usd : '-' }}</td>
                                <td>{{ $record->request == 'withdrawal_local' ? '₹'.round($amount,2) : '-' }}</td>
                                
                                <td>{{ $record->request == 'withdrawal_upi' && $record->type == 'clients' ? '$'.$record->usd : '-' }}</td>
                                <td>{{ $record->request == 'withdrawal_upi' && $record->type == 'ib' ? '$'.$record->usd : '-' }}</td>
                                <td>{{ $record->request == 'withdrawal_upi' ? '₹'.round($amount,2) : '-' }}</td>
                                
                                <td><input type="checkbox" name="verify_trans_checkbox" class="verify_trans_checkbox" 
                                    @if (($key = array_search($record->our_transaction_id, array_column($json_data, 0)) !== false))
                                    checked
                                    @endif   value="{{$record->our_transaction_id}}-{{$record->request}}"></td>
                            </tr>
                        @empty
                            <!-- No records available -->
                        @endforelse
                    </tbody>
                    

                    <thead class="table-secondary">

                        <tr>
                            <th colspan="5"></th>
                            <th colspan="2">Total Wire INR </th>
                            <th>₹{{round($deposit_wire ,2)}}</th>
                            <th colspan="2">Total LA INR</th>
                            <th>₹{{round($deposit_local,2)}}</th>
                            <th colspan="2">Total UPI INR</th>
                            <th>₹{{round($deposit_upi,2)}}</th>
                            <th colspan="2">Total Wire INR </th>
                            <th>₹{{round($withdrawal_wire,2)}}</th>
                            <th colspan="2">Total LA INR</th>
                            <th>₹{{ round($withdrawal_local,2) }}</th>
                            <th colspan="2">Total UPI INR</th>
                            <th>₹{{ round($withdrawal_upi,2) }}</th>
                            <th><button class="btn btn-primary btn-sm" id="checkout-btn">Save</button></th>
                        </tr>

                    </thead>
                </table>
            </div>
        </div>
    </div>
@endsection

@section('script')
    {{ Html::script('custom/eModal/eModal.js') }}
    {{ Html::script('custom/datatables/datatables.bundle.js') }}
    <!--<script>-->
    <!--    $(document).ready( function() {-->
    <!--        $('#user-report').dataTable({-->
    <!--            ordering: false-->
    <!--        });-->
    <!--    })-->
    <!--</script>-->
    
    
     <script>
        $(document).ready( function() {
            $('#user-report').dataTable({
                ordering: false,
                paging: false                
            });
        });

        // var val = [];
        // $('.verify_trans_checkbox:checkbox:checked').each(function(i){
        //     val[i] = $(this).val();
        // });
        // if (val.length > 0) {
        //     $('#checkout-btn').prop('disabled', false);
        // } else {
        //     $('#checkout-btn').prop('disabled', true);
        // }

        // $('.verify_trans_checkbox').click(function () {
        //     var checkboxVal = [];
        //     $('.verify_trans_checkbox:checkbox:checked').each(function(i){
        //         checkboxVal[i] = $(this).val();
        //     });
        //     if (checkboxVal.length > 0) {
        //         $('#checkout-btn').prop('disabled', false);
        //     } else {
        //         $('#checkout-btn').prop('disabled', true);
        //     }
        // });



        $('#checkout-btn').click(function () {
            var checkboxVal = [];
            $('.verify_trans_checkbox:checkbox:checked').each(function(i){
                checkboxVal[i] = $(this).val();
            });
            // if (checkboxVal.length <= 0) {
            //     Swal.fire({
            //         title: 'Verify Transaction ',
            //         text: 'Verify transaction must be required',
            //         type: "error"
            //     });
            //     return false;
            // }

            $.ajax({
                url: base_url + "/daily-report/verify/transaction",
                type: 'POST',
                data: {
                    'checkboxVal': checkboxVal,
                    'report_date' : '{{$date}}',
                    'bank' : '{{$bank->id}}',
                },
                dataType: 'json',
                success: function (data) {
                    if(data.status == 'success'){
                        Swal.fire({
                            title: data.title,
                            text: data.msg,
                            type: data.status
                        }).then((isOK) => {
                            if (data.status == 'success') {
                                location.reload();
                            }
                        });
                    }else{
                        swal("Oops...!", data.msg, "error")
                        .then((isOK) => {
                           location.reload();
                        });
                    }

                }
            });

        });
    </script>
@endsection