@extends('app')

@section('content')

    <!-- Content Header (Page header) -->
    <section class="content-header">
        <h1>
            Sales Report
            <small>Preview</small>
        </h1>
        <ol class="breadcrumb">
            <li><a href="{{url('/')}}"><i class="fa fa-dashboard"></i> Home</a></li>
            <li class="active">Sales Report</li>
        </ol>
    </section>

    <!-- Main content -->
    <section class="content">
        <!-- Custom Tabs -->

        <div class="box box-info">
            <!-- /.box-header -->
            <div class="box-body">
                <form method="GET" action="#" id="custom_search_form" class="no-print" style="padding-bottom: 10px" role="form">
                    <div class="row">
                        <div class="form-group" style="margin-top: 10px; margin-bottom: 5px;">
                            <div class="col-md-12">
                                <div class="col-md-2">
                                    <select class="form-control" name="all_category" id="all_category">
                                        <option value="">Select Category </option>
                                        @foreach ($categories as $val)
                                          <option value="{{$val->service_category_id}}"> {{$val->service_category_name}} </option>
                                        @endforeach
                                    </select>
                                </div>
                                <div class="col-md-2">
                                    <select class="form-control" name="all_user" id="all_user">
                                        <option value="">Select User </option>
                                        @foreach ($users as $val)
                                          <option value="{{$val->user_id}}"> {{$val->full_name}} </option>
                                        @endforeach
                                    </select>
                                </div>
                                <label class="col-md-1">
                                    <i class="fa fa-calendar"></i>
                                    From:
                                </label>
                                <div class="col-md-2">
                                    {{csrf_field()}}
                                    <input class="form-control datepicker" autocomplete="off" type="text"
                                           name="from" id="from">

                                </div>
                                <label class="col-md-1">
                                    <i class="fa fa-calendar"></i>
                                    To:
                                </label>
                                <div class="col-md-2">
                                    <input class="form-control datepicker" autocomplete="off" type="text" name="to"
                                           id="to">
                                </div>
                                <div class="col-md-2">
                                    <button class="btn btn-sm btn-primary" type="submit"> Submit</button>
                                </div>
                            </div>
                        </div>
                    </div>
                </form>
                @can('diagnostic-test-report-view')
                    <table id="testSaleReportDatatable"
                           class="table table-bordered table-striped">
                        <thead>
                        <tr>
                            <th>Invoice ID</th>
                            <th>Patient Name</th>
                            <th>Phone No</th>
                            <th>Discount</th>
                            <th>Total</th>
                            <th>Paid</th>
                            <th>Due</th>
                            <th>Date</th>
                            <th>Delivery Date</th>
                            <th>Status</th>
                            <th>Payment</th>
                            <th>Sale By</th>
                            <th>Action</th>
                        </tr>
                        </thead>

                        <tfoot>
                        <tr>
                            <th>Invoice IDs</th>
                            <th>Patient Names</th>
                            <th>Phone No</th>
                            <th>Discount</th>
                            <th>Total</th>
                            <th>Paid</th>
                            <th>Due</th>
                            <th>Date</th>
                            <th>Delivery Date</th>
                            <th>Status</th>
                            <th>Payment</th>
                            <th>Sale By</th>
                            <th>Action</th>
                        </tr>
                        </tfoot>
                    </table>
                @endcan
            </div>
        </div>

    </section>
    <!-- Normal Modal -->
    <div id="saleReportModal" class="modal fade" tabindex="-1" role="dialog">
        <div class="modal-dialog">
            <div class="modal-content" style="width: 800px;">
                <div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
                    <h4 class="modal-title">Diagnostic Test Sale Report</h4>
                </div>
                <!-- //Message from Ajax request// -->
                <div class="modal-body" id="saleDetailsBody">
                    Loading <img src="{{url('icons/loader.gif')}}" title="loading">
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default pull-left" data-dismiss="modal">Close</button>
                </div>
            </div><!-- /.modal-content -->
        </div><!-- /.modal-dialog -->
    </div> <!-- /.modal -->

@endsection

@section('extra-css')
    {{Html::style('assets/bower_components/datatables.net/buttons/css/buttons.dataTables.min.css')}}
@stop

@section('extra-js')
    <script src="{{ asset('assets/bower_components/datatables.net/buttons/js/dataTables.buttons.min.js') }}"></script>
    <script src="{{asset('assets/bower_components/datatables.net/buttons/js/buttons.html5.min.js')}}"></script>
    <script src="{{asset('assets/bower_components/datatables.net/buttons/js/buttons.print.min.js')}}"></script>
    <script type="text/javascript">
        $(document).ready(function () {
            var testSaleReportDatatable = $('#testSaleReportDatatable').DataTable({
                processing: true,
                serverSide: true,
                dom: 'Bfrtip',
                columnDefs: [
                    {"width": "5%", "targets": 0},
                    {"width": "10%", "targets": 1},
                    {"width": "5%", "targets": 2},
                    {"width": "5%", "targets": 3},
                    {"width": "5%", "targets": 4},
                    {"width": "5%", "targets": 5},
                    {"width": "5%", "targets": 6},
                    {"width": "2%", "targets": 7},
                    {"width": "2%", "targets": 8},
                    {"width": "1%", "targets": 9},
                    {"width": "2%", "targets": 10},
                    {"width": "1%", "targets": 11},
                    {"width": "15%", "targets": 12},
                ],
                autoWidth: false,
                buttons: [
                    {
                        extend: 'print',
                        charset: 'utf-8',
                        footer:true,
                        exportOptions: {
                            columns: [0, 1, 2, 3, 4, 5, 6, 7]
                        }
                    },
                    'pageLength'
                ],
                lengthMenu: [
                    [10, 25, 100],
                    ['10 rows', '25 rows', '100 rows']
                ],
                order: [[0, "asc"]],
                ajax: {
                    url: '{{ route("reports.getDiagnosticTestSaleReport") }}',
                    data: function (d) {
                        d.type = 'all';
                        d.from = $('input[name=from]').val();
                        d.to = $('input[name=to]').val();
                        d.all_category = $('#all_category').val();
                        d.all_user = $('#all_user').val();
                    }
                },
                columns: [
                    {data: 'sale_invoice_id', name: 'sale_invoice_id', orderable: true, searchable: true},
                    {data: 'full_name', name: 'customer.full_name', orderable: true, searchable: true},
                    {data: 'mobile_no', name: 'customer.mobile_no', orderable: true, searchable: true},
                    {data: 'discount', name: 'discount', orderable: true, searchable: true},
                    {data: 'total', name: 'total', orderable: true, searchable: true},
                    {data: 'paid', name: 'paid', orderable: true, searchable: true},
                    {data: 'due', name: 'due', orderable: true, searchable: true},
                    {data: 'date', name: 'date', orderable: true, searchable: true},
                    {data: 'delivery_date', name: 'delivery_date', orderable: false, searchable: false},
                    {data: 'status', name: 'status', orderable: true, searchable: false},
                    {data: 'payment', name: 'payment', orderable: true, searchable: false},
                    {data: 'seller_name', name: 'seller.full_name', orderable: true, searchable: false},
                    {data: 'action', name: 'action', orderable: true, searchable: false}
                ],
                footerCallback: function (row, data, start, end, display) {
                    var api = this.api(), data;

                    // Remove the formatting to get integer data for summation
                    var intVal = function (i) {
                        return typeof i === 'string' ?
                            i.replace(/[\$,]/g, '') * 1 :
                            typeof i === 'number' ?
                                i : 0;
                    };

                    //Due
                    // Total Paid over all pages
                    total = api
                        .column(6)
                        .data()
                        .reduce(function (a, b) {
                            return intVal(a) + intVal(b);
                        }, 0);

                    // Total Paid over this page
                    pageTotal = api
                        .column(6)
                        .data()
                        .reduce(function (a, b) {
                            return intVal(a) + intVal(b);
                        }, 0);

                    //Paid Update footer
                    $(api.column(6).footer()).html(
                        'Due ( ' + pageTotal + ' )'
                    );


                    // Total Paid over all pages
                    total = api
                        .column(5)
                        .data()
                        .reduce(function (a, b) {
                            return intVal(a) + intVal(b);
                        }, 0);

                    // Total Paid over this page
                    pageTotal = api
                        .column(5)
                        .data()
                        .reduce(function (a, b) {
                            return intVal(a) + intVal(b);
                        }, 0);

                    //Paid Update footer
                    $(api.column(5).footer()).html(
                        'Total Paid ( ' + pageTotal + ' )'
                    );

                    // Total over all pages
                    total = api
                        .column(4)
                        .data()
                        .reduce(function (a, b) {
                            return intVal(a) + intVal(b);
                        }, 0);

                    // Total over this page
                    pageTotal = api
                        .column(4)
                        .data()
                        .reduce(function (a, b) {
                            return intVal(a) + intVal(b);
                        }, 0);

                    // Update footer
                    $(api.column(4).footer()).html(
                        'Total ( ' + pageTotal + ' )'
                    );

                    //Discount
                    // Total over all pages
                    total = api
                        .column(2)
                        .data()
                        .reduce(function (a, b) {
                            return intVal(a) + intVal(b);
                        }, 0);

                    // Total over this page
                    pageTotal = api
                        .column(3)
                        .data()
                        .reduce(function (a, b) {
                            return intVal(a) + intVal(b);
                        }, 0);

                    // Update footer
                    $(api.column(3).footer()).html(
                        'Discount ( ' + pageTotal + ' )'
                    );
                }
            });
            $('#custom_search_form').on('submit', function (e) {
                testSaleReportDatatable.draw();
                e.preventDefault();
            });

        });

        function loadingImg() {
            $('#loading').ajaxStart(function () {
                $(this).show();
            }).ajaxComplete(function () {
                $(this).hide();
            });
        }

        function saleDetails(saleInvoiceId) {
            $(function () {
                loadingImg();
                $("#saleDetailsBody").load("{{url('reports/category-wise-sale-report')}}" + "/" + saleInvoiceId);
            });
        }

        function updateStatus(action, url, id) {
            var reference = $("#reference_" + id);
            if (action == 'delete') {
                if (!confirm('Do you want to Delete ?')) {
                    return false;
                }
            }

            $.ajax({
                url: "update-" + url + '-status/' + action + '/' + id,
                method: "GET",
                dataType: 'json',
                success: function (data) {
                    if (data.success == true) {
                        if (action == 'active') {
                            // reference.
                            reference.prev().show().prev().hide();
                            reference.parent().prev().children().next().show().prev().hide();
                        } else if (action == 'inactive') {
                            reference.prev().hide().prev().show();
                            reference.parent().prev().children().next().hide().prev().show();
                        } else if (action == 'delete') {
                            reference.parent().parent().hide(1000).remove();
                        }

                        $('.box-body-second').show();
                        $('.messageBodySuccess').slideDown(1000).delay(3000).slideUp(1000).children().next().html(data.message);
                    } else {
                        $('.box-body-second').show();
                        $('.messageBodyError').slideDown(1000).delay(3000).slideUp(1000).children().next().html(data.message);
                    }
                },
                error: function (data) {
                    $('.box-body-second').show();
                    $('.messageBodyError').slideDown(1000).delay(3000).slideUp(1000).children().next().html(data.message);
                }
            });
        }

    </script>
@stop