@php
    use App\Models\EsimOrder;
@endphp
@extends(Auth::user()->extender())
@section('title'){{__('Report')}} {{ __('Sales and Transactions') }} @endsection
@section('content')
@include('includes.page_header',['title'=>__('Report')." ". __('Sales and Transactions'),'url'=>route(Auth::user()->user_dashboard()),'icon'
=> $icon??'','permission'=>'PriorityRoute-view'])

<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.13.7/css/jquery.dataTables.min.css">

{{-- Progress modal include --}}
@include('includes.progress_modal')

<script>
    // on page load toogle the filter section
    document.addEventListener('DOMContentLoaded', function () {
        toggleFilterSection();
    });
</script>

<div class="row">
    <div class="col-md-12">
        <div class="main-card mb-3 card">
            <div class="card-header">
                <button class="btn btn-link" type="button" onclick="toggleFilterSection()">
                    <i class="fas fa-filter"></i> Filter Recharge Transactions
                </button>
            </div>
            <div id="filterSection" style="display: none;">
                <div class="card-body">
                    <div class="container m-1">
                        <div class="row">
                            {{ Form::open(array(route('module.report.rechargereport'),'method'=>'get','id'=>'module.report.rechargereport')) }}
                            <div class="row">
                                <div class="col-md-12">
                                    @include('modules.reports.recharge.filter_fields_admin')
                                </div>
                            </div>
                            <div class="row justify-content-end p-1">
                                <div class="col-auto">
                                    <a href="#" class="btn btn-sm btn-primary"
                                        onclick="showProgressModal(); document.getElementById('module.report.rechargereport').submit(); return false;"
                                        data-bs-toggle="tooltip" title="{{__('Apply')}}"
                                        data-original-title="{{__('apply')}}">
                                        <span class="btn-inner--icon"><i class="ti ti-filter"></i>Filter</span>
                                    </a>
                                    <a href="{{route('module.report.rechargereport')}}" class="btn btn-sm btn-danger "
                                        data-bs-toggle="tooltip" title="{{ __('Reset') }}"
                                        data-original-title="{{__('Reset')}}">
                                        <span class="btn-inner--icon"><i
                                                class="ti ti-arrows-horizontal"></i>Reset</span>
                                    </a>
                                </div>
                            </div>
                            {{ Form::close() }}
                        </div>
                    </div>
                </div>
            </div>
            @include('modules.reports.includes.purchase_summery_admin_card')
        </div>
    </div>
</div>

@include('admin.others.infyomincludes.filter_index_js')

<div class="row">
    <div class="col-md-12">
        <div class="main-card mb-3 card">
            <div class="card-body">
                <div class="row">
                    <div class="col-12">
                        <div class="table-responsive">
                            <table class="display" id="recharge-table" style="width:100%">
                                <thead>
                                    <tr>
                                        <th>TrxID</th>
                                        <th>Status</th>
                                        <th>Product</th>
                                        <th>Phone</th>
                                        <th>Cost</th>
                                        <th>Profit</th>
                                        <th>Admin</th>
                                        <th>Agent</th>
                                        <th>Merchant</th>
                                        <th>Service Charge</th>
                                        <th>Time</th>
                                        <th>Paid Wallet</th>
                                        <th>API</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach ($purchase_trxs as $key=>$trx)
                                    <tr>
                                        <td>{{$trx->id}}
                                            <a href="{{route('module.report.invoice', ['id' => $trx->id])}}">Invoice</a>
                                            <a class="btn btn-sm btn-success" href="{{route('module.report.invoice.print', ['id' => $trx->id])}}">Print</a>
                                        </td>

                                        <td>
                                            {{ucwords($trx->status)}}
                                            @php
                                                $this_user_id = json_decode($trx->request)->user_id??2;
                                            @endphp
                                            @if (($trx->status!='success')&($trx->status!='initiated'))
                                            <form method="GET" action="{{ route('admin.restimate.user.balance', ['user_id' => $this_user_id]) }}">
                                                @csrf
                                                <button type="submit" class="btn btn-sm btn-link">Reset Balance</button>
                                            </form>
                                            @endif
                                        </td>
                                        @if ($trx->product)
                                        <td>{{$trx->product->title}}
                                            <hr>Received: {{json_decode($trx->parameters)->receiver_amount??0}} {{$trx->product->note??''}}
                                             <hr>{{$trx->product->operator->name??''}}<hr>{{$trx->product->country->country_name}}</td>
                                        @else
                                        <td>-</td>
                                        @endif

                                        @php
                                            $msg = 'New';
                                            $iccid = '';
                                            if(in_array($trx->api_provider,['esimgo'])){
                                                if(in_array($trx->status,['success'])){
                                                    $locate_esim_order = EsimOrder::find($trx->end_point);
                                                    if($locate_esim_order){
                                                        $esim_details = 'LPA:1$'.$locate_esim_order->esims_smdpAddress.'$'.$locate_esim_order->esims_matchingId;
                                                        $iccid = $locate_esim_order->esims_iccid;
                                                    }
                                                }else{
                                                    $msg = '';
                                                }
                                            }
                                        @endphp

                                        @if (in_array($trx->api_provider,['esimgo']))
                                            @if (json_decode($trx->request)->phone)
                                                <td>{{json_decode($trx->request)->phone}}</td>
                                            @else
                                                <td>{{$iccid}} {{$msg}}</td>
                                            @endif
                                        @else
                                            <td>{{json_decode($trx->request)->phone}}</td>
                                        @endif

                                        <td>{{json_decode($trx->parameters)->product_currency.' '.number_format(json_decode($trx->parameters)->cost,2,'.',',')}}</td>

                                        <td>{{json_decode($trx->parameters)->product_currency.' '.number_format(((json_decode($trx->parameters)->admin_price??json_decode($trx->parameters)->price)-json_decode($trx->parameters)->cost),2,'.',',')}}</td>

                                        <td>{{json_decode($trx->parameters)->product_currency.' '.number_format(json_decode($trx->parameters)->admin_price??json_decode($trx->parameters)->price,2,'.',',')}}</td>

                                        <td>{{json_decode($trx->parameters)->product_currency.' '.number_format(json_decode($trx->parameters)->agent_price,2,'.',',')}}
                                            <hr>
                                            Commission ({{json_decode($trx->parameters)->product_currency.' '.number_format((json_decode($trx->parameters)->agent_price-(json_decode($trx->parameters)->admin_price??json_decode($trx->parameters)->price)),2,'.',',')}})</td>

                                        <td>{{json_decode($trx->parameters)->product_currency.' '.number_format(json_decode($trx->parameters)->selling_price,2,'.',',')}}
                                            <hr>
                                            Commission ({{json_decode($trx->parameters)->product_currency.' '.number_format((json_decode($trx->parameters)->selling_price-json_decode($trx->parameters)->agent_price),2,'.',',')}})</td>

                                        <td>{{json_decode($trx->parameters)->product_currency.' '.json_decode($trx->parameters)->service_charge}}</td>
                                        <td>{{$trx->created_at}}</td>
                                        <td>{{$trx->wallet->name}} <br> Balance History: ({{Auth::user()->myNumberFormat(json_decode($trx->parameters)->wallet_initial_balance??0)}} to {{Auth::user()->myNumberFormat(json_decode($trx->parameters)->wallet_after_balance??0)}}) {{json_decode($trx->parameters)->wallet_currency??''}}</td>
                                        <td>{{$trx->api_provider}}</td>
                                    </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<script type="text/javascript" language="javascript" src="https://code.jquery.com/jquery-3.7.0.js"></script>
<script type="text/javascript" language="javascript" src="https://cdn.datatables.net/1.13.7/js/jquery.dataTables.min.js"></script>
<script>
    new DataTable('#recharge-table', {
        pagingType: 'full_numbers',
        order: [[0, 'desc']],
    });
</script>
@endsection