@extends('user.layouts')
@section('title', 'Subscription Transaction')
@section('header')

    <!-- DataTable CSS -->
    <link rel="stylesheet" type="text/css" href="{{ asset('/assets') }}/css/datatable/dataTables.bootstrap5.min.css">
    <link rel="stylesheet" type="text/css" href="{{ asset('/assets') }}/css/datatable/responsive.bootstrap.min.css">
    <link rel="stylesheet" type="text/css" href="{{ asset('/assets') }}/css/datatable/buttons.dataTables.min.css">

@endsection
@section('content')




    <div class="container-fluid page-wrapper">


        <div class="row">
            <div class="d-flex justify-content-between align-items-center">
                <h3 class="page-top-heading">Subscription Transaction</h3>
                {{-- <button class="btn btn-primary feature-btn"><i class="fa-solid fa-arrow-up-from-bracket me-2"></i>Export
                    Data</button> --}}
              <button class="btn btn-primary excel-btn"><i class="fa-solid fa-arrow-up-from-bracket me-3"></i>Export Data</button>
            </div>
        </div>

       

        <!-- Table Row -->
        <div class="row mt-4">
            <div class="col-lg-12">
                <div class="card datatable-card">
                    <div class="card-body">
                        <table id="data-table" class="table nowrap align-middle" style="width:100%">
                            <thead>
                                <tr>
                                    <th>SN</th>
                                    <th>NAME</th>
                                    <th>TRANSACTION ID</th>
                                    <th>PHONE NO</th>
                                    <th>PLAN</th>
                                    {{-- <th>AGENT</th> --}}
                                    <th>DATE</th>
                                    <th>STATUS</th>
                                </tr>
                            </thead>
                            @php
                                $sn = 1; 
                            @endphp
                            
                            <tbody>
                                @foreach ($subscription as $sub)
                                    <tr>
                                        <td>{{ $loop->iteration }}</td>
                                        <td>{{ $sub->user->name ?? 'N/A' }}</td> 
                                        <td>{{ $sub->transaction_id ?? 'N/A' }}</td> 
                                        <td>{{ $sub->user->phone_number?? 'N/A' }}</td> 
                                        <td>{{ $sub->amount ?? 'N/A' }}</td> 
                                        {{-- <td>{{ $sub->user->agent_code ?? 'N/A' }}</td>  --}}
                                        <td>{{ $sub->created_at->format('Y-m-d') ?? 'N/A' }}</td> 

                                        <td>
                                            @if ($sub->status == 'success')
                                                <span class="badge success-badge">Completed</span>
                                            @else
                                                <span class="badge danger-badge">Failed</span>
                                            @endif
                                        </td>
                                    </tr>
                                @endforeach
                            </tbody>

                        </table>

                    </div>
                </div>
            </div>
        </div>






    </div>
    <!-- end container fluid -->




@endsection
@section('footer')


    <!-- JQuery CDN -->
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"
        integrity="sha256-/xUj+3OJU5yExlq6GSYGSHk7tPXikynS7ogEvDej/m4=" crossorigin="anonymous"></script>

    <!-- Datatable JS -->
    <script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/dataTables.bootstrap5.min.js"></script>
    <script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/datatables.init.js"></script>
    <script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/dataTables.responsive.min.js"></script>
    <script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/jquery.dataTables.min.js"></script>
    <script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/dataTables.buttons.min.js"></script>
    <script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/buttons.html5.min.js"></script>
    <script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/buttons.print.min.js"></script>
    <script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/jszip.min.js"></script>
    <script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/pdfmake.min.js"></script>
    <script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/vfs_fonts.js"></script>

    <script>
     
    $(document).ready(function() {
    $('#data-table').DataTable().destroy(); // Destroy if already initialized
    var table1 = $('#data-table').DataTable({
        dom: 'Bfrtip',
        buttons: [{
            extend: 'excelHtml5',
            text: 'Export to Excel',
            className: 'd-none',
            filename: 'Financial Track'
        }],
        responsive: true
    });

    $('.excel-btn').on('click', function() {
        table1.button('.buttons-excel').trigger();
    });
});

    
    </script>   

@endsection