@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 Manage
                    </h3>
                </div>
            </div>
            <div class="m-portlet__head-caption">
                <h3 class="m-portlet__head-text">{{ $bank->name }} - {{ $requestDate }}</h3>
            </div>
        </div>
        <div class="m-portlet__body">
            <div class="" style="display: flex;justify-content: flex-end;flex-direction: column;align-items: flex-end;">
                <h6 class="m-portlet__head-text">Last updated at - @if(isset($reportRecord->updated_at)) {{ $reportRecord->updated_at }} @endif</h6>
                <h6 class="m-portlet__head-text">Last updated By - @if(isset($reportRecord->updated_at)) {{ DB::table('admins')->where('id',$reportRecord->admin_id)->first()->name }} @endif </h6> 
            </div>
            @if(Session::has('success'))
            <div class="alert alert-success">
                {!! Session::get('success') !!}
            </div>
            @endif
            @if(session()->has('message_success'))
                <div class="alert alert-success">
                    {{ session()->get('message_success') }}
                </div>
            @endif
            <div class="m-form m-form--label-align-right m--margin-top-20 m--margin-bottom-30">
                <div class="align-items-center">
                   
                </div>
            </div>
            

            <table width="100%" class="m_datatable table table-striped- table-bordered table-checkable" id="user-report">
               
                <thead class="table-secondary">
                    <tr>
                        <th colspan="15"><h3>Date : {{ $requestDate != '' ? $requestDate : 'N/A' }} </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 colspan="6">Deposit</th>
                        <th colspan="6">Withdraw</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">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>
                    </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
                        $TotalWire = 0;
                        $TotalLA = 0;
                        $TotalWire_withdrawal = 0;
                        $TotalLA_withdrawal = 0;
                    @endphp
                    @if (count($records))
                        @foreach ($records as $recordKey => $record)   
                            @if (!empty($record['deposit-inr-request']['total_inr']) || !empty($record['deposit-wire-request']['total_wire']))

                            @php
                                $TotalWire += $record['deposit-wire-request']['total_wire'] ?? 0;
                                $TotalLA += $record['deposit-inr-request']['total_inr'] ?? 0;

                                $TotalWire_withdrawal += $record['withdrawal-wire-request']['total_withdrawal'] ?? 0;
                                $TotalLA_withdrawal += $record['withdrawal-inr-request']['total_withdrawal'] ?? 0;
                            @endphp
                                <tr>
                                    <td></th>
                                    <td>{{ $record['bank'] }}</th>
                                    <td>${{ round($record['deposit-wire-request']['mt4account'],2) }}</th>
                                    <td>${{ round($record['deposit-wire-request']['wallet'] ,2)}}</th>
                                    <td>₹{{ round($record['deposit-wire-request']['total_wire'] , 2) ?? 0 }}</th>
                                    <td>${{ round($record['deposit-inr-request']['mt4account'] ,2)}}</th>
                                    <td>${{ round($record['deposit-inr-request']['wallet'] ,2)}}</th>
                                    <td>₹{{ round($record['deposit-inr-request']['total_inr'],2)?? 0 }}</td>

                                    {{-- withdrawal start --}}
                                    <td>${{ round($record['withdrawal-wire-request']['client'] ,2)}}</th>
                                    <td>${{ round($record['withdrawal-wire-request']['ib'] ,2)}}</th>
                                    <td>₹{{ round($record['withdrawal-wire-request']['total_withdrawal'],2)?? 0 }}</th>

                                    <td>${{ round($record['withdrawal-inr-request']['client'] ,2)}}</th>
                                    <td>${{ round($record['withdrawal-inr-request']['ib'] ,2)}}</th>
                                    <td>₹{{ round($record['withdrawal-inr-request']['total_withdrawal'],2)?? 0 }}</td>
                                    {{-- withdrawal end --}}

                                </tr>
                            @endif                         
                        @endforeach
                    @else
                    <tr>
                        <td colspan="15">No Record found</td>
                    </tr>   
                    @endif
                </tbody>

                <thead class="table-secondary">
                    
                    <tr>
                        <th colspan="1"></th>
                        <th colspan="3">Total Wire INR </th>
                        <th>₹{{ round($TotalWire,2) ?? 0 }}</th>
                        <th colspan="2">Total LA INR</th>
                        <th>₹{{ round($TotalLA,2) ?? 0 }}</th>
                        <th colspan="2">Total Wire INR </th>
                        <th>₹{{ round($TotalWire_withdrawal,2) ?? 0 }}</th>
                        <th colspan="2">Total LA INR</th>
                        <th>₹{{ round($TotalLA_withdrawal,2) ?? 0 }}</th>
                    </tr>

                    <tr>
                        <th colspan="12" rowspan="3"></th>
                        <th>Total Deposit</th>
                        <th>{{ round($TotalWire + $TotalLA,2) }}</th>
                       
                    </tr>

                    <tr>
                        {{-- <th colspan="12"></th> --}}
                        <th>Total Withdraw :</th>
                        <th>{{ round($TotalWire_withdrawal + $TotalLA_withdrawal,2) }}</th>
                    </tr>

                    <tr>
                        {{-- <th colspan="12"></th> --}}
                        <th>Total Difference :</th>
                        <th>{{ round ( ($TotalWire + $TotalLA) - ($TotalWire_withdrawal + $TotalLA_withdrawal) , 2) }}</th>
                    </tr>

                    
                </thead>
            </table>


            @php $balancmanage =[]; @endphp
            @if (isset($reportRecord->json))
                    @php
                        $json = json_decode($reportRecord->json, TRUE);
                        $balancmanage = json_decode($reportRecord->balancmanage, TRUE);
                        if ($json === null) {
                            $json = [];
                        }

                        if ($balancmanage === null) {
                            $balancmanage = [];
                        }
                    @endphp
                @else
                    @php
                        $json = [];
                    
                    @endphp
                @endif
                @if ($errors->any())
                    <ul>
                        @foreach ($errors->all() as $error)
                            <li class="alert alert-danger">{{ $error }}</li>
                        @endforeach
                    </ul>
                @endif
            <br>

            @php $balancmanageSum = 0; $difference = isset($json['difference']) ? round($json['difference'],2) : 0; @endphp
                <form id="daily-report-form" method="post" action="/open-report-post">
                @csrf
                <input type="hidden" name="reportId" id="reportId" value="{{$reportId}}">
                <input type="hidden" name="date" id="date" value="{{$requestDate}}">
                <input type="hidden" name="id" id="id" value="{{ isset($reportRecord->id) ? $reportRecord->id : '' }}">

                @php
                    $closeBalance = isset($json['closeBalance']) ? $json['closeBalance'] : 0;
                    $openBalance = isset($json['openBalance']) ? $json['openBalance'] : 0;
                @endphp

                <div class="row">
                    <div class="col-md-4 mt-2">
                        <span>Open Balance</span>
                        <input type="text" class="form-control" placeholder="Open Balance" name="openBalance"  value="{{ isset($json['openBalance']) ? $json['openBalance'] : '' }}" id="report-openBalance">
                    </div>

                    <div class="col-md-4 mt-2">
                        <span>Close Balance</span>
                        <input type="text" class="form-control" placeholder="Close Balance" name="closeBalance" value="{{ isset($json['closeBalance']) ? $json['closeBalance'] : '' }}" id="report-closeBalance">
                    </div>

                    <div class="col-md-4 mt-2">
                        <span>Difference</span>
                        <input type="text" readonly  class="form-control" placeholder="Difference" name="difference" value="{{ ($closeBalance - $openBalance) }}" id="reportDifference">
                    </div>
                </div>
                <div class="row mt-4">
                    <div class="col-md-4">
                        <span>Amount</span>
                    </div>
                    
                    <div class="col-md-4">
                        <span>Comment</span>
                    </div>
                </div>
                
                @if (count($balancmanage) > 0)

                
                    @foreach ($balancmanage as $itemkey => $item)   
                        @php
                            $amount = isset($item['amount']) ? $item['amount'] : 0;
                            $balancmanageSum += $amount
                        @endphp 
                        <div class="row mt-2 balancmanage" id="add-content-content-{{$itemkey+1}}">
                            <div class="col-md-4">
                                <input type="text"  placeholder="Amount"  class="form-control" name="reportAmount[]" value="{{ round($amount,2) }}"   id="reportAmount-{{$itemkey}}">
                            </div>
        
                            <div class="col-md-4">
                                <input type="text"  class="form-control" name="reportComment[]" placeholder="Comment" value="{{ isset($item['comment']) ? $item['comment'] : '' }}"  id="reportComment-{{$itemkey}}">
                            </div>
        
                            <div class="col-md-4">
                                @if ($itemkey == 0)
                                    <button class="btn btn-primary" type="button" id="add-more">+</button>
                                    
                                @else
                                <button class="btn btn-danger" type="button" onclick="removeOne({{$itemkey+1}})" data-count="{{$itemkey+1}}">-</button>
                                @endif
                            </div>
                        </div>
                    @endforeach
                @else
                    <div class="row mt-2 balancmanage" id="add-content-content-1">
                        <div class="col-md-4">
                            <input type="text"  placeholder="Amount"  class="form-control reportAmount" name="reportAmount[]"   id="reportAmount">
                        </div>

                        <div class="col-md-4">
                            <input type="text"  class="form-control" name="reportComment[]" placeholder="Comment" >
                        </div>

                        <div class="col-md-4">
                            <button class="btn btn-primary" type="button" id="add-more">+</button>
                        </div>
                    </div>
                @endif

                
                <div class="row mt-2">
                    <div class="col-md-4">
                        <input type="text"  placeholder="Total Amount : {{round(($closeBalance - $openBalance) + $balancmanageSum,2) }}" disabled readonly  class="form-control">
                    </div>
                    @if (round(($closeBalance - $openBalance) + $balancmanageSum,2) >= round(($TotalWire + $TotalLA) - ($TotalWire_withdrawal + $TotalLA_withdrawal),2))
                        <div class="col-md-4">
                            <h3 style="color: green;">Transaction balance verified Thank you !!</h3>
                        </div>
                    @endif

                </div>

                <div class="row">

                    <div class="col-md-6 mt-2 center">
                        <button class="btn btn-primary" type="submit" id="submit-report">Submit</button>
                        <a class="btn btn-default" href="/daily-report" >Cancle</a>
                    </div>
                </div>
            </form>
        </div>
    </div>
</div>
@endsection

@section('script')

{{ Html::script('custom/eModal/eModal.js') }}
{{ Html::script('custom/datatables/datatables.bundle.js') }}



<script>






    var th=['','Thousand','Million','Billion','Trillion'];
    var dg=['Zero','One','Two','Three','Four','Five','Six','Seven','Eight','Nine'];
    var tn=['Ten','Eleven','Twelve','Thirteen','Fourteen','Fifteen','Sixteen','Seventeen','Eighteen','Nineteen'];
    var tw=['Twenty','Thirty','Forty','Fifty','Sixty','Seventy','Eighty','Ninety'];
    function toWords(s){s=s.toString();s=s.replace(/[\, ]/g,'');if(s!=parseFloat(s))return 'not a number';var x=s.indexOf('.');if(x==-1)x=s.length;if(x>15)return 'too big';var n=s.split('');var str='';var sk=0;for(var i=0;i<x;i++){if((x-i)%3==2){if(n[i]=='1'){str+=tn[Number(n[i+1])]+' ';i++;sk=1;}else if(n[i]!=0){str+=tw[n[i]-2]+' ';sk=1;}}else if(n[i]!=0){str+=dg[n[i]]+' ';if((x-i)%3==0)str+='Hundred ';sk=1;}if((x-i)%3==1){if(sk)str+=th[(x-i-1)/3]+' ';sk=0;}}if(x!=s.length){var y=s.length;str+='point ';for(var i=x+1;i<y;i++)str+=dg[n[i]]+' ';}return str.replace(/\s+/g,' ');}

    $('#report-openBalance, #report-closeBalance').on('input', function() {
        cal();
    });

    $('#add-more').on('click', function () {
        var count =  $('.balancmanage').length+1;
        var words = toWords(count);
        var html = '<div class="row mt-2 balancmanage" id="add-content-content-'+count+'">';
            html += '<div class="col-md-4">';
                html += '<input type="text"  placeholder="Amount"  class="form-control reportAmount" name="reportAmount[]"  id="reportAmount-'+count+'">';
            html += '</div>';

            html += '<div class="col-md-4">';
                html += '<input type="text"  class="form-control reportComment" name="reportComment[]" placeholder="Comment"  id="reportComment-'+count+'">';
            html += '</div>';

            html += '<div class="col-md-4">';
                html += '<button class="btn btn-danger" type="button" onclick="removeOne('+count+')" data-count="'+count+'">-</button>';
            html += '</div>';
        html += '</div>';

        $('#add-content-content-'+$('.balancmanage').length).after(html);
    });


    function cal() {
    
        var openBal = parseFloat($('#report-openBalance').val());    
        var closeBal = parseFloat($('#report-closeBalance').val()); 
        var total = closeBal - openBal;
        var reportTotal = parseFloat($('#difference').val());
        if(isNaN(total)) {
            total = 0;
        }
        $('#reportDifference').val(total);
    
    }

    function removeOne(param) {
        $('#add-content-content-'+param+'').remove();
    }


    $(document).ready(function() {
        // Initialize form validation
        $("#daily-report-form").validate({
            rules: {
                openBalance: {
                    required: true,
                    number: true
                },
                closeBalance: {
                    required: true,
                    number: true
                },

                'reportAmount[]': {
                    number: true
                },
            },
            submitHandler: function(form) {
                form.submit();
            }
        });
    });
$(document).on("change keyup input", 'input.reportAmount', function() {
    var position = this.selectionStart - 1;
    var fixed = this.value.replace(/[^-0-9\.]/g, "");
    if (fixed.charAt(0) === ".")
      fixed = fixed.slice(1);
    var pos = fixed.indexOf(".") + 1;
    if (pos >= 0)
      fixed = fixed.substr(0, pos) + fixed.slice(pos).replace(".", "");
    if (this.value !== fixed) {
      this.value = fixed;
      this.selectionStart = position;
      this.selectionEnd = position;
    }
});

</script>
@endsection