@extends('employee.layouts')
@section('title', 'User Management')
@section('header')
    <!-- DataTable CSS -->
    <link rel="stylesheet" type="text/css" href="{{ asset('/assets') }}/css/datatable/dataTables.bootstrap5.min.css">
    <link rel="stylesheet" type="text/css" href="{{ asset('/assets') }}/css/datatable/responsive.bootstrap.min.css">
    <link rel="stylesheet" type="text/css" href="{{ asset('/assets') }}/css/datatable/buttons.dataTables.min.css">
    <link rel="stylesheet" type="text/css" href="{{ asset('/assets') }}/css/formILY.css">
    <style>
        #totalAmountDisplay {
            font-size: 20px !important;
            font-weight: 600 !important;
        }
    </style>
@endsection
@section('content')
<div class="container-fluid page-wrapper category-container">
    <div class="row">
        <div class="d-flex justify-content-between align-items-center">
            <h3 class="page-top-heading">Store Sales History</h3>
        </div>
    </div>
    <div class="row mt-4">
        <div class="col-md-12 d-flex justify-content-end">
            <button class="btn btn-success excel-btn mb-3">Export to Excel</button>
        </div>
        <div class="row mt-3">
            {{-- <div class="col-md-3">
                <label for="fromDate">From Date:</label>
                <input type="date" class="form-control" id="fromDate">
            </div>
            <div class="col-md-3">
                <label for="toDate">To Date:</label>
                <input type="date" class="form-control" id="toDate">
            </div>
            <div class="col-md-3">
                <label for="phoneSearch">Search Phone No:</label>
                <input type="text" id="phoneSearch" class="form-control" placeholder="Enter phone number">
            </div>
            <div class="col-md-12 d-flex justify-content-end mt-3">
                <button class="btn btn-primary mr-2" id="filterBtn">Filter</button>
                <button class="btn btn-secondary" id="resetBtn">Reset</button>
            </div> --}}
        </div>
        <div class="row mt-4">
            {{-- <div class="col-md-12">
                <div id="totalAmountDisplay" class="total-amount-display"></div>
            </div> --}}
        </div>
        <div class="row mt-4">
            <div class="col-lg-12">
                <div class="card datatable-card">
                    <div class="card-body">
                        <table id="data-table" class="table nowrap align-middle" style="width:100%">
                            <thead>
                                <tr>
                                    <th>SN</th>
                                    <th>ORDER ID</th>
                                    <th>NAME</th>
                                    <th>USER ID</th>
                                    <th>PHONE No</th>
                                    <th>DATE</th>
                                    <th>MEMBERSHIP</th>
                                    <th>PAYMENT MODE</th>
                                    <th>REMARK</th>
                                    <th>AMOUNT</th>
                                    <th>ACTION</th>
                                </tr>
                            </thead>
                            <tbody>
                                @if ($offlineSales->isEmpty())
                                    <tr>
                                        <td colspan="11" class="text-center">No offline sales records found.</td>
                                    </tr>
                                @else
                                    @foreach ($offlineSales as $index => $sale)
                                        <tr>
                                            <td>{{ $index + 1 }}</td>
                                            <td>{{ $sale->order_id }}</td>
                                            <td>{{ $sale->user->name ?? 'N/A' }}</td>
                                            <td>{{ $sale->user_id }}</td>
                                            <td>
                                                @php
                                                    $phone = preg_replace('/\D/', '', $sale->user->phone_number ?? '');
                                                @endphp
                                                {{ $phone }}
                                            </td>
                                            <td>{{ $sale->created_at->format('Y-m-d') }}</td>
                                            <td>{{ $sale->user->membership ?? 'N/A' }}</td>
                                            <td>{{ $sale->payment_mode }}</td>
                                            <td>{{ $sale->status }}</td>
                                            <td>{{ $sale->amount_payable }}</td>
                                            <td>
                                                <a href="{{ url('employee/invoice_a4/' . $sale->order_id) }}" target="_blank"
                                                    class="btn btn-info btn-sm">View Invoice</a>
                                                <a href="{{ route('employeeedit_invoice', ['id' => $sale->order_id]) }}"
                                                    class="btn btn-warning btn-sm">Edit</a>
                                            </td>
                                        </tr>
                                    @endforeach
                                @endif
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection
@section('footer')
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script>
<script src="https://code.jquery.com/jquery-3.6.0.min.js" crossorigin="anonymous"></script>
<!-- DataTables JS -->
<script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/jquery.dataTables.min.js"></script>
<script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/dataTables.bootstrap5.min.js"></script>
<script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/dataTables.responsive.min.js"></script>
<script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/dataTables.buttons.min.js"></script>
<script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/buttons.html5.min.js"></script>
<script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/buttons.print.min.js"></script>
<script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/jszip.min.js"></script>
<script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/pdfmake.min.js"></script>
<script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/vfs_fonts.js"></script>
<!-- Moment JS -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.29.1/moment.min.js"></script>
<script>
    $(document).ready(function () {
        $.fn.dataTable.ext.search.push(function (settings, data, dataIndex) {
            let fromDate = $('#fromDate').val();
            let toDate = $('#toDate').val();
            let date = data[5];
            if (!fromDate && !toDate) return true;
            let momentDate = moment(date, 'YYYY-MM-DD');
            let fromMoment = fromDate ? moment(fromDate) : null;
            let toMoment = toDate ? moment(toDate) : null;
            if (fromMoment && !toMoment && momentDate.isSameOrAfter(fromMoment)) return true;
            if (!fromMoment && toMoment && momentDate.isSameOrBefore(toMoment)) return true;
            if (fromMoment && toMoment && momentDate.isBetween(fromMoment.clone().subtract(1, 'days'), toMoment.clone().add(1, 'days'))) return true;
            return false;
        });
        let table = $('#data-table').DataTable({
            dom: 'Bfrtip',
            buttons: [{
                extend: 'excelHtml5',
                text: 'Export to Excel',
                filename: 'offline_sales',
                title: null,
                className: 'd-none',
                exportOptions: { columns: ':visible' }
            }],
            order: [[5, 'desc']],
            responsive: true
        });
        function calculateTotalAmount() {
            let total = 0;
            table.rows({ search: 'applied' }).every(function () {
                let row = this.node();
                let amount = parseFloat($(row).find('td').eq(9).text().replace(/,/g, ''));
                if (!isNaN(amount)) total += amount;
            });
            $('#totalAmountDisplay').text('Total Amount: ' + total.toFixed(2));
        }
        table.on('draw', function () {
            calculateTotalAmount();
        });
        calculateTotalAmount();
        // Phone Number Search
        $('#phoneSearch').on('keyup', function () {
            let val = this.value.replace(/\D/g, ''); // Remove non-digits
            console.log('Searching for phone number:', val);
            table.column(4).search(val).draw();
        });
        $('#filterBtn').on('click', function () {
            table.draw();
        });
        $('#resetBtn').on('click', function () {
            $('#fromDate').val('');
            $('#toDate').val('');
            $('#phoneSearch').val('');
            table.search('').columns().search('').draw();
        });
        $('.excel-btn').on('click', function () {
            table.button('.buttons-excel').trigger();
        });
    });
</script>
@endsection