@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 method="GET" action="{{route('module.report.optimized.optimized_sale_report_merchant')}}">
                                
                                <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=" 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>

                                        -->
     
                                        <button class='btn btn-primary'>Filter</button>
                                        <a href="{{route('module.report.optimized.optimized_sale_report_merchant')}}" 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>
                        </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 = $purchase_trxs->sum('agent_price_pyrwlt');
                        $totalPrice = $purchase_trxs->sum('selling_price_pyrwlt');
                        $totalServiceCharge = $purchase_trxs->sum('service_charge');
                        $totalCommission = $purchase_trxs->sum('commission');
                        // $totalPrice = 0;
                        // $totalServiceCharge = 0;
                        // $totalCommission = 0;
                        // foreach ($purchase_trxs as $key=>$trx) {
                        //     $totalCost += $trx->agent_price_pyrwlt;
                        //     $totalPrice += $trx->selling_price_pyrwlt;
                        //     $totalServiceCharge += $trx->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(($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(($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(($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(($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->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('module.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->wallet_currency.' '.number_format($trx->agent_price_pyrwlt,2,'.',',')}}</td>

                                        <td>{{$trx->wallet_currency.' '.number_format(($trx->selling_price_pyrwlt-$trx->agent_price_pyrwlt),2,'.',',')}}</td>

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



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