@php
use App\Models\EsimOrder;
@endphp
@extends(Auth::user()->extender())
@section('title'){{__('Report')}} {{ __('Sales Report') }} @endsection
@section('content')
@include('includes.page_header',['title'=>__('Report')." ". __('Sales
Report'),'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="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-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.optimized_purchase_summery_admin_card2')


        </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->purchase_id}}
                                            <a class="btn btn-sm btn-info" href="{{route('module.report.invoice', ['id' => $trx->purchase_id])}}">Invoice</a>
                                            <a class="btn btn-sm btn-success" href="{{route('module.optimized.report.invoice', ['id' => $trx->id])}}">Print</a>
                                        </td>
                                        <td>{{ucwords($trx->status)}}
                                            @php
                                            $this_user_id = $trx->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 --}}
                                            {{$trx->manualTransactionPasses->first()->details??''}}
                                        </td>
                                        @if ($trx->product)
                                        <td>{{$trx->product->title}}
                                            <hr>Received: {{$trx->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->purchase_transaction->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 ($trx->phone_number)
                                        <td>{{$trx->phone_number}}</td>
                                        @else
                                        <td>{{$iccid}} (New eSim)</td>
                                        @endif
                                        @else
                                        <td>{{$trx->phone_number}}</td>
                                        @endif

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

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

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

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

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

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



                                        <td>{{$trx->product_currency.'
                                            '.$trx->service_charge}}</td>
                                        <td>{{$trx->created_at}}</td>
                                        <td>{{$trx->wallet->name}} <br> Balance History:
                                            ({{Auth::user()->myNumberFormat($trx->wallet_initial_balance??0)}}
                                            to
                                            {{Auth::user()->myNumberFormat($trx->wallet_after_balance??0)}})
                                            {{$trx->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