@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')
                                </div>
                            </div>
                            <div class="row justify-content-end p-1">
                                <div class="col-auto">
                                    {{-- <a href="#" class="btn btn-sm btn-primary"
                                        onclick="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="#" 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-search"></i> Search</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>
            {{-- <div class="card-footer d-flex justify-content-end">
                <p>Total Wallet Transactions Count: {{$purchase_trxs->count()}}</p>
            </div> --}}

            <div class="card-footer">
                <div class="row">

                    @php
                        $totalCost = 0;
                        $totalPrice = 0;
                        $totalServiceCharge = 0;
                        $totalCommission = 0;
                        foreach ($purchase_trxs as $key=>$trx) {
                            $totalCost += json_decode($trx->parameters)->agent_price;
                            $totalPrice += json_decode($trx->parameters)->selling_price;
                            $totalServiceCharge += json_decode($trx->parameters)->service_charge;
                        }
                    @endphp

                    <div class="col-md-3 mb-3">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <i class="fas fa-user fa-2x mr-3"></i>
                                    <div>
                                        <h5 class="card-title font-weight-bold">Total Cost</h5>
                                        <p class="card-text">{{Auth::user()->country_currency->code}} {{number_format(Auth::user()->toMyCurrency($totalCost),2,'.',',')}}</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <div class="col-md-3 mb-3">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <i class="fas fa-store fa-2x mr-3"></i>
                                    <div>
                                        <h5 class="card-title font-weight-bold">Commission</h5>
                                        <p class="card-text">{{Auth::user()->country_currency->code}} {{number_format(Auth::user()->toMyCurrency($totalPrice-$totalCost),2,'.',',')}}</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3 mb-3">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <i class="fas fa-store fa-2x mr-3"></i>
                                    <div>
                                        <h5 class="card-title font-weight-bold">Price</h5>
                                        <p class="card-text">{{Auth::user()->country_currency->code}} {{number_format(Auth::user()->toMyCurrency($totalPrice),2,'.',',')}}</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3 mb-3">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <i class="fas fa-store fa-2x mr-3"></i>
                                    <div>
                                        <h5 class="card-title font-weight-bold">Service Charge</h5>
                                        <p class="card-text">{{Auth::user()->country_currency->code}} {{number_format(Auth::user()->toMyCurrency($totalServiceCharge),2,'.',',')}}</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>



                    <div class="col-md-3 mb-3">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <i class="fas fa-exchange-alt fa-2x mr-3"></i>
                                    <div>
                                        <h5 class="card-title font-weight-bold">Transactions</h5>
                                        <p class="card-text">Total {{$purchase_trxs->count()}}</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

        </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>Comission</th>
                                        <th>Price</th>
                                        <th>Service Charge</th>
                                        <th>Paid Wallet</th>
                                        <th>Time</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('module.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
                                            $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;
                                                    }
                                                }
                                            }
                                        @endphp

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

                                        <td>{{json_decode($trx->parameters)->wallet_currency.' '.number_format(Auth::user()->toMyCurrency(json_decode($trx->parameters)->agent_price),2,'.',',')}}</td>

                                        <td>{{json_decode($trx->parameters)->wallet_currency.' '.number_format((Auth::user()->toMyCurrency(json_decode($trx->parameters)->selling_price)-Auth::user()->toMyCurrency(json_decode($trx->parameters)->agent_price)),2,'.',',')}}</td>

                                        <td>{{json_decode($trx->parameters)->wallet_currency.' '.number_format(Auth::user()->toMyCurrency(json_decode($trx->parameters)->selling_price),2,'.',',')}}</td>



                                        <td>{{json_decode($trx->parameters)->wallet_currency.' '.(json_decode($trx->parameters)->service_charge)}}</td>
                                        <td>{{$trx->wallet->name}} <hr> 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->created_at}}</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