@extends('layouts.app')

@section('title')
    {{ __('Billings') }}
@endsection

@section('breadcrumb')
    <div class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                    <h1 class="m-0 text-dark">
                        <i class="nav-icon fas fa-credit-card"></i>
                        {{ __('Billings') }}
                    </h1>
                </div><!-- /.col -->
                <div class="col-sm-6">
                    <ol class="breadcrumb float-sm-right">
                        <li class="breadcrumb-item"><a href="{{ route('admin.index') }}">{{ __('Home') }}</a></li>
                        <li class="breadcrumb-item active">{{ __('Billings') }}</li>
                    </ol>
                </div><!-- /.col -->
            </div><!-- /.row -->
        </div><!-- /.container-fluid -->
    </div>
@endsection

@section('content')
    <div class="card card-primary card-outline">
        <div class="card-header">
            <!-- <h3 class="card-title">{{ __('Payment methods table') }}</h3> -->
            {{-- @can('create_payment_method')
                <a href="{{ route('admin.payment_methods.create') }}" class="btn btn-primary btn-sm float-right">
                    <i class="fa fa-plus"></i> {{ __('Create') }}
                </a>
            @endcan --}}
        </div>
        <!-- /.card-header -->
        <div class="card-body">
            <!-- filter -->
            <div id="accordion">
                <div class="card card-info">
                    <a data-toggle="collapse" data-parent="#accordion" href="#collapseOne" class="btn btn-primary collapsed" aria-expanded="false">
                        <i class="fas fa-filter"></i> {{ __('Filters') }}
                    </a>
                    <div id="collapseOne" class="panel-collapse in collapse">
                        <div class="card-body">
                            <div class="row">
                                <div class="col-lg-3">
                                    <div class="form-group">
                                        <label for="filter_date">{{ __('Date') }}</label>
                                        <div class="input-group">
                                            <input type="text" class="form-control" id="filter_date" autocomplete="off" value="{{ isset($_GET['date']) ? $_GET['date'] : '' }}" placeholder="{{ __('Date') }}">
                                            <div class="input-group-append">
                                                <button class="btn btn-outline-secondary clear_date" type="button">Clear</button>
                                            </div>
                                        </div>
                                    </div>
                                </div>

                                <div class="col-lg-3">
                                    <div class="form-group">
                                        <label for="filter_sign">{{ __('For Signing') }}</label>
                                        <select name="filter_sign" id="filter_sign" class="form-control select2">
                                            <option value="" selected>{{ __('All') }}</option>
                                            <option value="Generated" {{ isset($_GET['filter_generated']) ? ($_GET['filter_generated'] == 0 ? 'selected' : '') : '' }}>{{ __('Generated') }}</option>
                                            <option value="Approver" {{ isset($_GET['filter_approver']) ? ($_GET['filter_approver'] == 0 ? 'selected' : '') : '' }}>{{ __('Approver') }}</option>
                                            <option value="Reviewer" {{ isset($_GET['filter_reviewer']) ? ($_GET['filter_reviewer'] == 0 ? 'selected' : '') : '' }}>{{ __('Reviewer') }}</option>
                                            <option value="Generate" >{{ __('Generate') }}</option>
                                        </select>
                                    </div>
                                </div>

                                <div class="col-lg-3">
                                    <div class="form-group">
                                        <label for="filter_test">{{ __('Laboratory') }}</label>
                                        <select name="filter_lab" id="filter_lab" class="form-control select2" multiple>
                                            <option value="">-- SELECT LABORATORY</option>
                                            @foreach (auth()->guard('admin')->user()->branches as $ub)
                                                <option value="{{ $ub->branch_id }}">{{ $ub->branch->name }}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <!-- \filter -->

                <div class="row">
                    <div class="col-lg-12 table-responsive">
                        <table id="billing_table" class=" table table table-striped table-bordered" width="100%">
                            <thead>
                                <tr>
                                    <th width="10px">
                                        <input type="checkbox" class="check_all" name="" id="">
                                    </th>
                                    <th width="10px">#</th>
                                    <th>{{ __('Billing No.') }}</th>
                                    <th>{{ __('Requisitions') }}</th>
                                    <th>{{ __('Billing Month') }}</th>
                                    <th>{{ __('Due') }}</th>
                                    <th>{{ __('Total Due') }}</th>
                                    <th>{{ __('Finalized') }}</th>
                                    <th>{{ __('Date Created') }}</th>
                                    <th>{{ __('Signed') }}</th>
                                    <th>{{ __('Signed By') }}</th>
                                    <th>{{ __('Date Signed') }}</th>
                                    <th width="100px">{{ __('Action') }}</th>
                                </tr>
                            </thead>
                            <tbody>

                            </tbody>
                        </table>

                        <!-- Modal -->
                        <div class="modal fade" id="billing_modal" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true">
                            <div class="modal-dialog">
                                <div class="modal-content">
                                    <div class="modal-header">
                                        <h5 class="modal-title" id="exampleModalLabel">Add Billing Payment</h5>
                                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                            <span aria-hidden="true">&times;</span>
                                        </button>
                                    </div>
                                    <form action="{{ route('admin.add_billing_payment') }}" method="post">
                                        @csrf
                                        <input type="hidden" name="billing_id" id="billing_id">
                                        <div class="modal-body">
                                            <div class="form-group">
                                                <label for="amount">Amount</label>
                                                <input type="text" name="amount" id="amount" placeholder="0.00" class="form-control">
                                            </div>

                                            <div class="form-group">
                                                <label for="payment_date">Date</label>
                                                <input type="date" name="payment_date" id="payment_date" class="form-control">
                                            </div>

                                            <div class="form-group">
                                                <label for="payment_method">Payment Method</label>
                                                <select name="payment_method" id="payment_method" class="form-control select2">
                                                    <option value="">Select Payment Method</option>
                                                    @foreach ($payment_methods as $pm)
                                                        <option value="{{ $pm->id }}">{{ $pm->name }}</option>
                                                    @endforeach
                                                </select>
                                            </div>
                                        </div>
                                        <div class="modal-footer">
                                            <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                                            <button type="submit" class="btn btn-primary">Add Payment</button>
                                        </div>
                                    </form>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <!-- /.card-body -->
        </div>
    @endsection
    @section('scripts')
        <script>
            var can_delete =
                @can('delete_payment_method')
                    true
                @else
                    false
                @endcan
        </script>
        <script src="{{ url('js/admin/billing.js') }}"></script>
        <script>
            //datatable
            table = $('#billing_table').DataTable({
                "lengthMenu": [
                    [10, 25, 50, 100, 500, 1000, -1],
                    [10, 25, 50, 100, 500, 1000, "All"]
                ],
                dom: "<'row'<'col-sm-4'l><'col-sm-4'B><'col-sm-4'f>>" +
                    "<'row'<'col-sm-12'tr>>" +
                    "<'row'<'col-sm-4'i><'col-sm-8'p>>",
                buttons: [{
                        extend: 'copyHtml5',
                        text: '<i class="fas fa-copy"></i> ' + trans("Copy"),
                        titleAttr: 'Copy'
                    },
                    {
                        extend: 'excelHtml5',
                        text: '<i class="fas fa-file-excel"></i> ' + trans("Excel"),
                        titleAttr: 'Excel'
                    },
                    {
                        extend: 'csvHtml5',
                        text: '<i class="fas fa-file-csv"></i> ' + trans("CSV"),
                        titleAttr: 'CSV'
                    },
                    // {
                    //     extend: 'pdfHtml5',
                    //     text: '<i class="fas fa-file-pdf"></i> ' + trans("PDF"),
                    //     titleAttr: 'PDF'
                    // },
                    {
                        extend: 'colvis',
                        text: '<i class="fas fa-eye"></i>',
                        titleAttr: 'View'
                    }
                ],
                "processing": true,
                "serverSide": true,
                "order": [
                    [8, "desc"]
                ],
                "ajax": {
                    url: url("admin/billing"),
                    data: function(data) {
                        data.filter_date = $('#filter_date').val();
                        data.filter_lab = $('#filter_lab').val();
                        data.filter_sign = $('#filter_sign').val();
                        
                    }
                },
                // orderCellsTop: true,
                fixedHeader: true,
                "columns": [{
                        data: "bulk_checkbox",
                        searchable: false,
                        sortable: false,
                        orderable: false
                    },
                    {
                        data: "DT_RowIndex",
                        name: "DT_RowIndex",
                        orderable: false,
                        searchable: false
                    },
                    {
                        data: "billing_no",
                        searchable: true,
                        sortable: true,
                        orderable: false
                    },
                    {
                        data: "invoices",
                        searchable: true,
                        sortable: true,
                        orderable: false
                    },
                    {
                        data: "billing_month",
                        searchable: true,
                        sortable: true,
                        orderable: false
                    },
                    {
                        data: "due",
                        searchable: true,
                        sortable: true,
                        orderable: false
                    },
                    {
                        data: "total_due",
                        searchable: true,
                        sortable: true,
                        orderable: false
                    },
                    {
                        data: "_finalized",
                        searchable: false,
                        sortable: false,
                        orderable: false
                    },
                    {
                        data: "created_at",
                        searchable: true,
                        sortable: true,
                        orderable: false
                    },
                    {
                        data: "signatories",
                        searchable: false,
                        sortable: false,
                        orderable: false
                    },
                    {
                        data: "signed_users",
                        searchable: false,
                        sortable: false,
                        orderable: false,
                        visible: false
                    },
                    {
                        data: "signed_date",
                        searchable: false,
                        sortable: false,
                        orderable: false,
                        visible: false
                    },
                    {
                        data: "action",
                        sortable: false,
                        searchable: false,
                        orderable: false
                    }
                ],
                "language": {
                    "sEmptyTable": trans("No data available in table"),
                    "sInfo": trans("Showing") + " _START_ " + trans("to") + " _END_ " + trans("of") + " _TOTAL_ " + trans("records"),
                    "sInfoEmpty": trans("Showing") + " 0 " + trans("to") + " 0 " + trans("of") + " 0 " + trans("records"),
                    "sInfoFiltered": "(" + trans("filtered") + " " + trans("from") + " _MAX_ " + trans("total") + " " + trans("records") + ")",
                    "sInfoPostFix": "",
                    "sInfoThousands": ",",
                    "sLengthMenu": trans("Show") + " _MENU_ " + trans("records"),
                    "sLoadingRecords": trans("Loading..."),
                    "sProcessing": trans("Processing..."),
                    "sSearch": trans("Search") + ":",
                    "sZeroRecords": trans("No matching records found"),
                    "oPaginate": {
                        "sFirst": trans("First"),
                        "sLast": trans("Last"),
                        "sNext": trans("Next"),
                        "sPrevious": trans("Previous")
                    },
                }
            });

            $('#filter_lab').on('change', function() {
                table.draw();
            });

            // filter date
            var ranges = {};
            ranges[trans('Today')] = [moment(), moment()];
            ranges[trans('Yesterday')] = [moment().subtract('days', 1), moment().subtract('days', 1)];
            ranges[trans('Last 7 Days')] = [moment().subtract('days', 6), moment()];
            ranges[trans('Last 30 Days')] = [moment().subtract('days', 29), moment()];
            ranges[trans('This Month')] = [moment().startOf('month'), moment().endOf('month')];
            ranges[trans('Last Month')] = [moment().subtract('month', 1).startOf('month'), moment().subtract('month', 1).endOf('month')];
            ranges[trans('This Year')] = [moment().startOf('year'), moment().endOf('year')];
            ranges[trans('Last Year')] = [moment().subtract(1, 'year').startOf('year'), moment().subtract(1, 'year').endOf('year')];

            $('#filter_date').daterangepicker({
                    locale: {
                        format: 'YYYY/MM/DD',
                        "applyLabel": trans("Save"),
                        "cancelLabel": trans("Cancel"),
                    },
                    ranges,
                },
                function(start, end) {
                    $('#dateRange span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'));
                });

            $('#filter_date').on('cancel.daterangepicker', function() {
                $(this).val('');
                table.draw();
            });

            $('#filter_date').on('apply.daterangepicker', function() {
                table.draw();
                $('#exp_date').val($(this).val())
            });
            $('#filter_sign').on('change', function() {
                table.draw();
              
            });

            $('#filter_date').val('');
        </script>
    @endsection