@extends("layouts.pg")
@section("content")

    <section role="main" class="content-body">

        <header class="page-header">
            <h2>Invoice Tracking</h2>
        </header>
        <div class="panel">
            <div class="panel-body panel-bg">
                <table class="table table-bordered table-striped" id="invoiceTable">
                    <thead>
                        <th>Site</th>
                        <th>Year</th>
                        <th>Due Date</th>
                        <th>Amount</th>
                        <th>Invoice Sent</th>
                        <th>Invoice Paid</th>
                    </thead>
                    <tbody>
                        @foreach($invoiceData as $invoice)
                            <tr>
                                <td>{{$invoice->dis}}</td>
                                <td>{{$invoice->year}}</td>
                                <td>{{$invoice->due_date}}</td>
                                <td class="text-weight-bold"> ${{number_format($invoice->amount, 0, '.', ',')}}</td>
                                <td>
                                    @if($invoice->is_invoice_sent==1)
                                        <span class="text-success">Yes</span>
                                    @elseif($invoice->is_invoice_sent==0)
                                        <span class="text-danger">No</span>
                                    @endif
                                </td>
                                <td>
                                    @if($invoice->is_paid==1)
                                        <span class="text-success">Yes</span>
                                    @elseif($invoice->is_paid==0)
                                        <span class="text-danger">No</span>
                                    @endif
                                </td>

                            </tr>

                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>

    </section>
    <script>
        setTimeout(function(){
            $("#invoiceTable").DataTable({
                dom: "<'pull-right'B><'row'<'col-sm-12'<'pull-right'f><'pull-left'l>r<'clearfix'>>>t<'row'<'col-sm-12'<'pull-left'i><'pull-right'p><'clearfix'>>>",
                order: [[5,"asc"],[1,"asc"],[ 2, "asc" ]],
                buttons: [
                    {
                        extend: 'excel',
                        text: 'Export to Excel',
                        className: 'btn btn-default'
                    }
                ]

            });
        },1000);
    </script>
@endsection