@extends('main')

@section('title', 'Sales Report | Page')

@section('content')
    <div class="content">
        <div class="page-header">
            <div class="page-title">
                <h4>Sales Report</h4>
                <h6>Filter Sales Transactions</h6>
            </div>
        </div>

        {{-- {{ now()->startOfMonth()->format('Y-m-d') }} --}}
        <div class="card">
            <div class="card-body">
                <form action="{{ route('report.sales') }}" method="GET">
                    <div class="row">
                        <div class="col-lg-4 col-sm-6 col-12">
                            <div class="form-group">
                                <label>Customer Name</label>
                                <input type="text" name="customer_name" value="{{ request('customer_name') }}"
                                    placeholder="Enter Customer Name">
                            </div>



                            <div class="form-group">
                                <label>Currency Pair</label>
                                <select class="form-control form-small select2" name="currency_pair">
                                    <option value="">All</option>
                                    @foreach ($currencyPairs as $currencyPair)
                                        <option value="{{ $currencyPair->id }}"
                                            {{ request('currency_pair') == $currencyPair->id ? 'selected' : '' }}>
                                            {{ $currencyPair->currency_pair }}</option>
                                    @endforeach
                                </select>

                            </div>


                            <div class="form-group">
                                <label>Document Number</label>
                                <input type="text" name="document_number" value="{{ request('document_number') }}"
                                    placeholder="Enter Document Number">
                            </div>
                        </div>

                        <div class="col-lg-4 col-sm-6 col-12">
                            <div class="form-group">
                                <label>Transaction Date (Start)</label>
                                <div class="input-groupicon">
                                    <input type="text" name="start_date" placeholder="Choose Date" class="datetimepicker"
                                        value="{{ request('start_date') }}">
                                    <a class="addonset">
                                        <img src="{{ asset('img/icons/calendars.svg') }}" alt="calendar">
                                    </a>
                                </div>
                            </div>

                            <div class="form-group">
                                <label>Transaction Date (End)</label>
                                <div class="input-groupicon">
                                    <input type="text" name="end_date" placeholder="Choose Date" class="datetimepicker"
                                        value="{{ request('end_date') }}">
                                    <a class="addonset">
                                        <img src="{{ asset('img/icons/calendars.svg') }}" alt="calendar">
                                    </a>
                                </div>
                            </div>
                        </div>


                        <div class="col-lg-4 col-sm-6 col-12">
                            <div class="form-group">
                                <label>Status</label>
                                <select class="form-control form-small select2" name="status">
                                    <option value="">All</option>
                                    <option value="pending" {{ request('status') == 'pending' ? 'selected' : '' }}>Pending
                                    </option>
                                    <option value="completed" {{ request('status') == 'completed' ? 'selected' : '' }}>
                                        Completed</option>
                                    <option value="cancel" {{ request('status') == 'cancel' ? 'selected' : '' }}>
                                        Cancel</option>
                                    <option value="reject" {{ request('status') == 'reject' ? 'selected' : '' }}>
                                        Rejected</option>
                                </select>
                            </div>
                        </div>

                        <div class="col-lg-4 col-sm-6 col-12">
                            <div class="form-group">
                                <label>Transfer To</label>
                                <select class="form-control form-small select2" name="transfer_to">
                                    <option value="">All</option>
                                    @foreach ($TransferAccounts as $tf)
                                        <option value="{{ $tf->id }}"
                                            {{ request('transfer_to') == $tf->id ? 'selected' : '' }}>
                                            {{ $tf->bank_name . ' - ' . $tf->rekening . ' - ' . $tf->nama_rekening }}
                                        </option>
                                    @endforeach

                                </select>
                            </div>
                        </div>

                        <div class="col-lg-4 col-sm-6 col-12">
                            <div class="form-group">
                                <label>Delivery Method</label>
                                <select class="form-control form-small select" name="delivery_method">
                                    <option value="">All</option>

                                    <option value="delivery"
                                        {{ request('delivery_method') == 'delivery' ? 'selected' : '' }}> delivery
                                    </option>

                                    <option value="pickup" {{ request('delivery_method') == 'pickup' ? 'selected' : '' }}>
                                        pickup</option>

                                </select>
                            </div>
                        </div>

                        <div class="col-lg-12">
                            <button type="submit" class="btn btn-submit me-2">Search</button>
                            <a href="{{ route('report.sales') }}" class="btn btn-cancel">Reset</a>
                        </div>
                    </div>
                </form>
            </div>
        </div>

        {{-- Report Sales Table --}}
        @if (collect(request()->all())->except(['_token', 'page'])->filter(function ($value) {
                    return $value !== null;
                })->isNotEmpty())


            <div class="card">
                <div class="card-body">

                    <div class="d-flex justify-content-between">
                        <!-- Search Section -->
                        <div class="table-top">
                            <div class="search-set">
                                <form method="GET" action="{{ route('report.sales') }}"
                                    class="d-flex align-items-center">
                                    <!-- Filter Button -->
                                    <div class="search-path me-2">
                                        <a class="btn btn-filter">
                                            <img src="{{ asset('img/icons/filter.svg') }}" alt="img" />
                                            <span><img src="{{ asset('img/icons/closes.svg') }}" alt="img" /></span>
                                        </a>
                                    </div>

                                    <!-- Search Input -->
                                    <div class="search-input">
                                        <input type="text" name="search" value="{{ old('search', $search) }}"
                                            class="form-control" placeholder="Search...">
                                    </div>
                                </form>
                            </div>
                        </div>

                        <!-- Export Button (Excel) -->
                        <div class="export-btn">
                            <a href="{{ route('export.sales.report', request()->all()) }}" data-bs-toggle="tooltip"
                                data-bs-placement="top" title="Export to Excel">
                                <img src="{{ asset('img/icons/excel.svg') }}" alt="img" />
                                {{-- Export to Excel --}}
                            </a>
                        </div>
                    </div>

                    <!-- Dropdown for Entries per Page -->
                    <div class="table-top mt-3">
                        <form method="GET" action="{{ route('report.sales') }}">
                            <div class="search-set d-flex align-items-center">
                                <label for="perPage" class="form-label p-2">Show</label>
                                <select name="perPage" id="perPage" class="form-select" onchange="this.form.submit()">
                                    <option value="25" {{ $perPage == 25 ? 'selected' : '' }}>25</option>
                                    <option value="50" {{ $perPage == 50 ? 'selected' : '' }}>50</option>
                                    <option value="100" {{ $perPage == 100 ? 'selected' : '' }}>100</option>
                                    <option value="125" {{ $perPage == 10 ? 'selected' : '' }}>125</option>
                                </select>
                                <span class="p-2">entries</span>
                            </div>
                        </form>
                    </div>





                    <div class="table-responsive">
                        <table class="table datanew">
                            <thead>
                                <tr>
                                    <th>Doc Num</th>
                                    <th>Customer Name</th>
                                    <th>Phone Number</th>
                                    <th>Currency Pair</th>
                                    <th>Amount</th>
                                    <th>Kurs</th>
                                    <th>Total Received</th>
                                    <th>Transfer Time</th>
                                    <th>Transfer To</th>
                                    <th>Delivery Method</th>
                                    <th>Transaction Date</th>
                                    <th>Status</th>
                                    <th>Processed By</th>
                                    <th>Confirmed By</th>
                                    <th>Rejected By</th>
                                    <th>Cancelled By</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach ($transactions as $data)
                                    <tr>
                                        <td>{{ $data->doc_no }}</td>
                                        <td>{{ $data->customer_name }}</td>
                                        <td>{{ $data->customer_phone }}</td>
                                        <td>{{ $data->currency }}</td>
                                        <td style="text-align: right;">{{ number_format($data->amount, 2, ',', '.') }}
                                        </td>
                                        <td style="text-align: right;">{{ number_format($data->kurs, 2, ',', '.') }}</td>
                                        <td style="text-align: right;">
                                            {{ number_format($data->total_received, 2, ',', '.') }}</td>
                                        <td>{{ $data->transfer_time }}</td>
                                        <td>{{ $data->bank_name . ' - ' . $data->rekening . ' - ' . $data->account_name }}
                                        </td>
                                        <td>{{ $data->delivery_method }}</td>
                                        <td>{{ $data->created_at }}</td>
                                        <td>{{ $data->status }}</td>
                                        <td>{{ $data->processedBy->name ?? '-' }}</td>
                                        <td>{{ $data->approvedBy->name ?? '-' }}</td>
                                        <td>{{ $data->rejectedBy->name ?? '-' }}</td>
                                        <td>{{ $data->cancelledBy->name ?? '-' }}</td>
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                    <div class="pagination-container">
                        <div class="d-flex justify-content-between align-items-center">
                            <span>
                                Showing {{ $transactions->firstItem() }} to {{ $transactions->lastItem() }} of
                                {{ $transactions->total() }} entries
                            </span>
                            <div class="pagination-links">
                                {{ $transactions->appends(request()->all())->links() }}
                            </div>
                        </div>
                    </div>


                </div>
            </div>
        @endif
    </div>
@endsection
@push('scripts')
    <script>
        $(document).ready(function() {
            $('.datetimepicker').datepicker({
                format: 'yyyy-mm-dd', // Paksa format jadi YYYY-MM-DD
                autoclose: true,
                todayHighlight: true
            }).datepicker('update', new Date()); // Langsung update ke tanggal hari ini
        });
    </script>
@endpush