@extends('layouts.backend_app')
@section('content')
    <div>
        <x-slot name="title">
            Purchase Report
        </x-slot>
        <div class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-body">
                        <div class="row">
                            <div class="col-sm-12">
                                <div class="search-box mr-2 mb-2 d-inline-block">
                                    <div class="position-relative">
                                        <h4 class="card-title design_title">Purchase Report</h4>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <hr>
                        <div class="row">
                            <div class="col-lg-6">
                                <div class="row">
                                    <div class="col-md-6">
                                        <div class="form-group">
                                            <label for="basicpill-firstname-input">From Date</label>
                                            <input type="date" class="form-control updateTable prevDate" id="from_date"
                                                name="from_date" />
                                        </div>
                                    </div>

                                    <div class="col-md-6">
                                        <div class="form-group">
                                            <label for="basicpill-firstname-input">To Date</label>
                                            <input type="date" class="form-control updateTable currentDate"
                                                id="to_date" name="to_date" />
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="col-lg-3">
                                <div wire:ignore class="form-group">
                                    <label for="basicpill-firstname-input">Select Supplier</label>

                                    <select class="form-control form-select select2 updateTable" placeholder="Customer"
                                        name="contact_id" id="contact_id">
                                        <option value="">Select Supplier</option>
                                        @foreach ($ContactLists as $supplier)
                                            <option value="{{ $supplier->id }}">{{ $supplier->first_name }}
                                                {{ $supplier->last_name }}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                            <div class="col-lg-3">
                                <div wire:ignore class="form-group">
                                    <label for="basicpill-firstname-input">Select Branch</label>
                                    <select class="form-control form-select select2 updateTable" placeholder="Branch"
                                        name="branch_id" id="branch_id">
                                        <option value="">Select Branch</option>
                                        @foreach ($branches as $branch)
                                            <option value="{{ $branch->id }}">{{ $branch->name }}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <div class="col-xl-12">
                <div class="card">
                    <div class="card-body">
                        <div class="table-responsive">
                            <table id="purchase_report_table" class="table table-striped table-bordered nowrap"
                                style="border-collapse: collapse; border-spacing: 0; width: 100%;">
                                <tfoot>
                                    <th colspan="4"></th>
                                    <th></th>
                                    <th></th>
                                    <th></th>
                                    <th></th>
                                    <th></th>
                                    <th></th>
                                    <th></th>
                                    <th></th>
                                </tfoot>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection
@section('script')
    <script>
        $(document).ready(function() {
            $('#contact_id').select2({
                theme: "classic"
            });
            $('.currentDate').val(getDateFormat());

            $('#purchase_report_table').DataTable({
                processing: true,
                responsive: true,
                serverSide: true,
                ajax: {
                    url: "{{ route('report.purchase-report-data') }}",
                    type: 'GET',
                    cache: false,
                    data: function(d) {
                        d.from_date = $('#from_date').val();
                        d.to_date = $('#to_date').val();
                        d.contact_id = $('#contact_id').val();
                        d.branch_id = $('#branch_id').val();
                    }
                },
                columns: [{
                        title: 'SL',
                        data: 'id',
                        name: 'id'
                    },
                    {
                        title: 'Date',
                        data: 'purchase_date',
                        name: 'purchase_date'
                    },
                    {
                        title: 'Supplier Name',
                        data: 'contact_id',
                        name: 'contact_id'
                    },
                    {
                        title: 'Purchase Code',
                        data: 'code',
                        name: 'code'
                    },
                    {
                        title: 'Sub Total',
                        data: 'total_amount',
                        class: "total_amount",
                        name: 'total_amount'
                    },
                    {
                        title: 'Discount',
                        data: 'discount',
                        class: "discount",
                        name: 'discount'
                    },
                    {
                        title: 'Shipping Charge',
                        data: 'shipping_charge',
                        class: "shipping_charge",
                        name: 'shipping_charge'
                    },
                    {
                        title: 'Vat',
                        data: 'vat',
                        class: "vat",
                        name: 'vat'
                    },
                    {
                        title: 'Payable Amount',
                        data: 'payable_amount',
                        class: "payable_amount",
                        name: 'payable_amount'
                    },
                    {
                        title: 'Paid',
                        data: 'paid_amount',
                        class: "paid_amount",
                        name: 'paid_amount'
                    },
                    {
                        title: 'Due',
                        data: 'due',
                        class: "due",
                        name: 'due'
                    },
                    {
                        title: 'Branch',
                        data: 'branch_id',
                        name: 'branch_id'
                    }
                ],
                dom: '<"html5buttons"B>lTfgitp',
                buttons: [
                    'copyHtml5',
                    'csvHtml5',
                    // 'excel',
                    {
                        extend: 'excelHtml5',
                        title: '{{ $companyInfo->name }} \n {{ $companyInfo->address }} \n Purchase Report',
                        footer: true,
                        exportOptions: {
                            columns: ":not(.not-show)"
                        },
                    },
                    {
                        extend: 'pdfHtml5',
                        title: '{{ $companyInfo->business_name }} \n {{ $companyInfo->address }} \n Purchase Report',
                        orientation: 'landscape',
                        pageSize: 'LEGAL',
                        footer: true,
                        exportOptions: {
                            charset: "utf-8",
                            columns: ":not(.not-show)"
                        },
                        customize: function(doc) {
                            doc.content[1].table.widths =
                                Array(doc.content[1].table.body[0].length + 1).join('*').split('');
                            doc.styles.tableFooter.alignment = 'center';
                            doc.styles.tableBodyEven.alignment = 'center';
                            doc.styles.tableBodyOdd.alignment = 'center';
                        }
                    }
                ],
                footerCallback: function(row, data, start, end, display) {
                    var api = this.api();
                    $.each(['total_amount', 'discount', 'shipping_charge', 'vat', 'payable_amount',
                        'paid_amount', 'due'
                    ], function(index, value) {

                        // var total = api
                        // .column('.amount_to_pay', {
                        // page: 'all'
                        // })
                        // .data()
                        // .reduce( function (a, b) {
                        // return parseFloat(a) + parseFloat(b);
                        // }, 0 );

                        api.columns('.' + value, {
                            page: 'all'
                        }).every(function() {
                            var sum = this
                                .data()
                                .reduce(function(a, b) {

                                    if (!Number(a) && a != 0) {
                                        a = a.replace(/\,/g, '');
                                    }

                                    if (!Number(b) && b != 0) {
                                        b = b.replace(/\,/g, '');
                                    }
                                    var x = parseFloat(a) || 0;
                                    var y = parseFloat(b) || 0;
                                    return x + y;
                                }, 0);

                            $(this.footer()).html(parseFloat(sum).toFixed(2));
                        });



                    });

                },
                lengthMenu: [
                    [10, 25, 50, 100],
                    [10, 25, 50, 100]
                ]
            });

            $(document).on('change', '.updateTable', function() {
                $('#purchase_report_table').DataTable().draw(true);
            });
        });
    </script>
@endsection