@extends('layouts.cs.main')

@section('reports', 'active')

@section('main-content')
    <style>
        table {
            border-collapse: separate;
            border-spacing: 0 5px;
        }

        table.dataTable tbody tr {
            border-radius: 10px;
        }
    </style>

    <div class="container container-fluid container-def p-3 mt-3">
        <div class="card">
            <div class="card-body">
                <div class="form-row">
                    {{-- <div class="form-group col-lg-3">
                        <label for="">Search</label>
                        <input type="text" class="form-control" id="search_like" placeholder="Looking for Something?">
                    </div> --}}
                    <div class="form-group col-lg-3">
                        <label for="">Transaction Type</label>
                        <select id="type" class="form-control">
                            <option value="-">-- Select All</option>
                            <option value="sold">Sold</option>
                            <option value="borrowed">Borrowed</option>
                            <option value="returned">Returned</option>
                        </select>
                    </div>
                    <div class="form-group col-lg-3">
                        <label for="">Brands</label>
                        <select id="brands" class="form-control">
                            <option value="-">-- Select All</option>
                            @foreach ($brands as $brand)
                                <option value="{{ $brand->brand }}">{{ $brand->brand }}</option>
                            @endforeach
                        </select>
                    </div>
                    {{-- <div class="form-group col-lg-3">
                        <label for="">Member Class</label>
                        <select id="member" class="form-control">
                            <option value="-">-- Select All</option>
                            @foreach ($memberClasses as $member)
                                <option value="{{ $member->description }}">{{ $member->description }}</option>
                            @endforeach
                        </select>
                    </div> --}}
                    <div class="form-group col-lg-3">
                        <label for="">Start Date</label>
                        <input id="start" type="date" class="form-control"
                            value="{{ date('Y-m-d', strtotime($start)) }}">
                    </div>
                    <div class="form-group col-lg-3">
                        <label for="">End Date</label>
                        <input id="end" type="date" class="form-control"
                            value="{{ date('Y-m-d', strtotime($end)) }}">
                    </div>
                </div>
            </div>
            <div class="card-footer">
                <button class="btn btn-success border mr-2 pl-4 pr-4 pt-3 pb-3" id="generateReport">
                    <div class="d-flex align-items-center">
                        <ion-icon class="mr-2" name="checkmark-outline"></ion-icon>
                        <span>Generate</span>
                    </div>
                </button>
                <button class="btn btn-light border mr-2  pl-4 pr-4 pt-3 pb-3" id="downloadReport">
                    <div class="d-flex align-items-center">
                        <ion-icon class="mr-2" name="download-outline"></ion-icon>
                        <span>Download</span>
                    </div>
                </button>
            </div>
        </div>

        <div class="mt-3">
            <table class="table text-nowrap table-borderless" id="datatable" style="width: 100%">
                <thead class="text-sm text-muted">
                    <tr>
                        <th scope="col">
                            <ion-icon name="key-outline"></ion-icon> Invoice
                        </th>
                        <th scope="col">Product Details</th>
                        <th scope="col">Qty</th>
                        <th scope="col">Price</th>
                        <th scope="col">Total</th>
                        <th scope="col">Type</th>
                        <th scope="col">Member Name</th>
                        <th scope="col">Date</th>
                    </tr>
                </thead>
                <tbody>
                </tbody>
            </table>
        </div>
    </div>
@endsection

@section('scripts')
    <script>
        let tableView;
        let search_like = $("#search_like").val();
        let type = $("#type").val();
        let brands = $("#brands").val();
        let member = $("#member").val();
        let start = $("#start").val();
        let end = $("#end").val();

        let params = ""

        const report = {
            init() {
                this.getData();
                this.setupEvents();
            },

            setupEvents() {
                $('#generateReport').on('click', () => {
                    this.getData(this.getUrlParams());
                });

                $('#downloadReport').on('click', () => {
                    let urlParam = this.getUrlParams();
                    window.location.href = `/data/report/csv?${urlParam}`;
                });
            },

            getData() {
                if (tableView) {
                    tableView.destroy();
                }

                tableView = $('#datatable').DataTable({
                    ajax: `/data/report?${this.getUrlParams()}`,
                    order: [
                        [0, 'asc']
                    ],
                    dom: 'tp',
                    columns: this.getColumns(),
                    initComplete: this.initCompleteCallback,
                    rowCallback: this.rowCallbackFunction,
                    drawCallback: this.drawCallbackFunction
                });
            },

            getUrlParams() {
                return new URLSearchParams({
                    search_like: $("#search_like").val(),
                    type: $("#type").val(),
                    brands: $("#brands").val(),
                    member: $("#member").val(),
                    start: $("#start").val(),
                    end: $("#end").val()
                }).toString();
            },

            getColumns() {
                return [{
                        data: 'invoice_ref',
                        name: 'invoice_ref'
                    },
                    {
                        data: 'desc',
                        name: 'desc'
                    },
                    {
                        data: 'qty',
                        name: 'qty'
                    },
                    {
                        data: 'price',
                        name: 'price'
                    },
                    {
                        data: null,
                        name: 'total',
                        render: (data, type, row) => row.price * row.qty
                    },
                    {
                        data: 'transaction_type',
                        name: 'transaction_type'
                    },
                    {
                        data: null,
                        name: 'full_name',
                        render: (data, type, row) => `${row.firstname} ${row.middlename} ${row.lastname}`
                    },
                    {
                        data: 'created_at',
                        name: 'created_at'
                    },
                ];
            },

            initCompleteCallback(settings, json) {
                $(".table").wrap("<div style='overflow:auto; width:100%;position:relative;'></div>");
            },

            rowCallbackFunction(row, data, index) {
                $(row).css({
                    'background-color': '#FFFFFF',
                    'padding': '20px',
                    'border-radius': '10px',
                    'box-shadow': '0 1px 4px rgba(0, 0, 0, 0.1)'
                });
            },
        };

        report.init();
    </script>
@endsection