@extends('admin.layout.master')
@section('content')
    <section class="section">
        <div class="section-body">
            <div class="row">
                <div class="col-md-12 text-right mb-3">
                    {{--                <a href="{{ route('products.export') }}" class="btn btn-sm btn-danger ml-3">Export Inventory</a>--}}
                    <a href="{{route('subs.add.product')}}" class="btn btn-primary ">
                        + Add Product
                    </a>
                </div>
                <div class="col-md-12">
                    <div class="card">
                        <div class="card-body table-responsive">
                            <table class="table" id="inventorytable">
                                <thead>
                                <tr>
                                    <th>#</th>
                                    <th>Customer Name</th>
                                    <th>Email</th>
                                    <th>Plan</th>
                                    <th>Interval</th>
                                    <th>Amount</th>
                                    <th>Start At</th>
                                    <th>End At</th>
                                    <th>Days Left</th>

                                </tr>
                                </thead>
                                <tbody>

                                @for($i=0; $i<count($products); $i++)

                                    <tr>
                                        <th>{{ $i+1 }}</th>
                                        <th>{{$data['customers'][$i]->name }}</th>
                                        <td>{{$data['customers'][$i]->email }}</td>
                                        <td>{{$data['products'][$i]->name}}</td>
                                        <td>{{$data['subscription'][$i]->plan->interval}}</td>
                                        <td>{{$data['subscription'][$i]->plan->amount}}</td>
                                        @php
                                           $st= \Carbon\Carbon::createFromTimestampUTC($data['subscription'][$i]->start_date);
                                         $et= \Carbon\Carbon::createFromTimestampUTC($data['subscription'][$i]->current_period_end);
                                         $to = \Carbon\Carbon::parse($data['subscription'][$i]->start_date);
                                            $from = \Carbon\Carbon::parse($data['subscription'][$i]->current_period_end);

                                            $days = $to->diffInDays($from);

                                        @endphp

                                        <td>{{$st}}</td>
                                        <td>{{$et}}</td>
                                        <td>{{$days}}</td>

                                    </tr>

                                @endfor
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
@endsection
@push('scripts')

        <script>
            $(document).ready(function() {
                $('#inventorytable').dataTable();
            });
        </script>



    {{--    <script>--}}
    {{--        $(document).ready(function() {--}}
    {{--            document.title = 'Inventory';--}}
    {{--            $('#inventorytable').DataTable( {--}}
    {{--                dom: 'Bfrtip',--}}
    {{--                buttons: [--}}
    {{--                    {--}}
    {{--                        extend:'excelHtml5',--}}
    {{--                        orientation: 'landscape',--}}
    {{--                        pageSize: 'LEGAL',--}}
    {{--                        exportOptions: {--}}
    {{--                            columns: [ 0,1, 2,3,4,5,6 ]--}}
    {{--                        }--}}
    {{--                    },--}}



    {{--                ]--}}

    {{--            } );--}}
    {{--        } );--}}
    {{--    </script>--}}

@endpush