@extends('admin.layouts.master')
@section('title', 'Customer Report')
@section('content')

    <section class="content">
        <div class="container-fluid">
            <div class="row">
                <div class="col-md-12">
                    <div class="card card-primary card-outline mt-3">
                        <div class="card-header">
                            <h3 class="card-title mt-1"><b>{{ __('Customer Report') }}</b></h3>
                            <div class="card-tools d-flex">

                            </div>
                        </div>
                        <div class="card-body">
                            <div class="tableContent">
                                <table class="table table-striped table-bordered table-sm" id="">
                                    <thead>
                                        <tr>
                                            <th>{{ __('#') }}</th>
                                            <th>{{ __('Company Name') }}</th>
                                            <th>{{ __('Customer Name') }}</th>
                                            <th>{{ __('Invoices Amount') }}</th>
                                            <th>{{ __('Paid') }}</th>
                                            <th>{{ __('Pending') }}</th>
                                        </tr>
                                    </thead>
                                    <tbody id="tbody">
                                        @php
                                            $total = 0;
                                        @endphp
                                        @forelse ($users as $id => $user)
                                        @php
                                            $total = $user->total_paid + $user->total_pending;
                                        @endphp

                                            <tr >
                                                <td >{{ ++$id }}</td>
                                                <td>{{ $user->company }}</td>
                                                 <td>{{ $user->first_name }} {{ $user->last_name }}</td>
                                                
                                                <td>{{ $total}}</td>
                                                <td>{{$user->total_paid }}</td>
                                                <td>{{ $user->total_pending }}</td>
                                                
                                            </tr>
                                        @empty
                                            <tr>
                                                <td colspan="9" class="text-center text-muted">No products available.</td>
                                            </tr>
                                        @endforelse
                                    </tbody>
                                </table>
                            </div>
                        </div>
                        <div class="loader text-center" id="loader" style="display: none">
                            <div class="spinner-border" role="status">
                                <span class="visually-hidden"></span>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
@endsection
@section('js')
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <link rel="stylesheet" href="https://cdn.datatables.net/1.13.6/css/jquery.dataTables.min.css">

    <!-- jQuery (Make sure it's included before DataTables) -->
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>

    <!-- DataTables JS -->
    <script src="https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js"></script>
    <script>
        $(document).ready(function () {
            $('.table').DataTable({
                "paging": true,
                "lengthChange": true,
                "searching": true,
                "ordering": true,
                "info": true,
                "autoWidth": false,
                "responsive": true,
                "order": [],
                "pageLength": 50,
                "lengthMenu": [
                    [10, 25, 50, 100],
                    [10, 25, 50, 100]
                ],
                "columnDefs": [{
                    "orderable": false,
                    "targets": [0, -1]
                }],
                "dom": 'lfrtip',
                "buttons": [{
                    extend: 'excelHtml5',
                    text: 'Export to Excel',
                    title: 'Data Export',
                    className: 'btn btn-success btn-sm'
                }]
            }).buttons().container().appendTo('.card-header .card-tools');
        });
    </script>
@endsection