@push('title')
    Price Adjustment Report
@endpush

<x-app-layout>
    <div class="row mb-4">
        <div class="col-12">
            <div class="card shadow-sm border-0">
                <div class="card-header bg-white d-flex justify-content-between align-items-center py-3">
                    <h5 class="mb-0 fw-bold">Price Adjustment Report</h5>
                    <div class="dropdown">
                        <button class="btn btn-outline-secondary dropdown-toggle btn-sm" type="button" id="exportDropdown"
                            data-bs-toggle="dropdown" aria-expanded="false">
                            <i class="bx bx-export me-1"></i> Export
                        </button>
                        <ul class="dropdown-menu shadow-sm" aria-labelledby="exportDropdown">
                            <li><a class="dropdown-item"
                                    href="{{ request()->fullUrlWithQuery(['export' => 'csv']) }}"><i
                                        class="bx bx-file me-2 text-info"></i>Export as CSV</a></li>
                            <li><a class="dropdown-item"
                                    href="{{ request()->fullUrlWithQuery(['export' => 'excel']) }}"><i
                                        class="bx bx-spreadsheet me-2 text-success"></i>Export as Excel</a></li>
                        </ul>
                    </div>
                </div>
                <div class="card-body">
                    <form action="{{ route('reports.price_adjustment') }}" method="GET" class="row g-3">
                        <div class="col-md-3">
                            <label class="form-label fw-semibold">Date Range</label>
                            <div class="input-group input-group-merge">
                                <input type="date" name="start_date" class="form-control" value="{{ request('start_date') }}">
                                <span class="input-group-text">to</span>
                                <input type="date" name="end_date" class="form-control" value="{{ request('end_date') }}">
                            </div>
                        </div>
                        <div class="col-md-3">
                            <label class="form-label fw-semibold">Search Product</label>
                            <input type="text" name="search" class="form-control" placeholder="Name or Code..."
                                value="{{ request('search') }}">
                        </div>
                        <div class="col-md-2">
                            <label class="form-label fw-semibold">Adjusted By</label>
                            <select name="user_id" class="form-select">
                                <option value="">All Users</option>
                                @foreach($users as $user)
                                    <option value="{{ $user->id }}" {{ request('user_id') == $user->id ? 'selected' : '' }}>
                                        {{ $user->name }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-2">
                            <label class="form-label fw-semibold">Warehouse</label>
                            <select name="warehouse_id" class="form-select">
                                <option value="">All Warehouses</option>
                                @foreach($warehouses as $warehouse)
                                    <option value="{{ $warehouse->id }}" {{ request('warehouse_id') == $warehouse->id ? 'selected' : '' }}>
                                        {{ $warehouse->name }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-2 d-flex align-items-end">
                            <button type="submit" class="btn btn-primary me-2 flex-grow-1"><i class="bx bx-filter-alt me-1"></i>Filter</button>
                            <a href="{{ route('reports.price_adjustment') }}" class="btn btn-label-secondary"><i class="bx bx-refresh"></i></a>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>

    <!-- Summary Stats -->
    <div class="row mb-4">
        <div class="col-md-4">
            <div class="card border-0 shadow-sm">
                <div class="card-body d-flex align-items-center">
                    <div class="avatar flex-shrink-0 me-3">
                        <span class="avatar-initial rounded bg-label-primary p-2"><i class="bx bx-list-ul fs-4"></i></span>
                    </div>
                    <div>
                        <h5 class="mb-0 fw-bold">{{ number_format($logs->total()) }}</h5>
                        <small class="text-muted text-uppercase fw-semibold">Total Adjustments</small>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card border-0 shadow-sm">
                <div class="card-body d-flex align-items-center">
                    <div class="avatar flex-shrink-0 me-3">
                        <span class="avatar-initial rounded bg-label-success p-2"><i class="bx bx-dollar-circle fs-4"></i></span>
                    </div>
                    <div>
                        <h5 class="mb-0 fw-bold text-success">{{ number_format($logs->count() ? $logs->sum('new_retail_price') / $logs->count() : 0, 2) }}</h5>
                        <small class="text-muted text-uppercase fw-semibold">Avg. New Retail Price</small>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card border-0 shadow-sm">
                <div class="card-body d-flex align-items-center">
                    <div class="avatar flex-shrink-0 me-3">
                        <span class="avatar-initial rounded bg-label-info p-2"><i class="bx bx-sync fs-4"></i></span>
                    </div>
                    <div>
                        @php
                            $increasedCount = $logs->filter(function($log) { return $log->new_retail_price > $log->old_retail_price; })->count();
                            $decreasedCount = $logs->filter(function($log) { return $log->new_retail_price < $log->old_retail_price; })->count();
                        @endphp
                        <h5 class="mb-0 fw-bold">
                            <span class="text-success" style="padding-right: 10px;"><i class="bx bx-up-arrow-alt"></i> {{ number_format($increasedCount) }}</span> | 
                            <span class="text-danger" ><i class="bx bx-down-arrow-alt"></i> {{ number_format($decreasedCount) }}</span>
                        </h5>
                        <small class="text-muted text-uppercase fw-semibold">Retail Price Changes</small>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Logs Table -->
    <div class="card border-0 shadow-sm overflow-hidden">
        <div class="table-responsive text-nowrap">
            <table class="table table-hover align-middle mb-0">
                <thead class="table-light">
                    <tr>
                        <th class="py-3">Date & Time</th>
                        <th class="py-3">Adjusted By</th>
                        <th class="py-3">Product Info</th>
                        <th class="py-3">Batch & Warehouse</th>
                        <th class="text-end py-3">Cost Price</th>
                        <th class="text-end py-3">Wholesale Price</th>
                        <th class="text-end py-3">Retail Price</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($logs as $log)
                        <tr>
                            <td>
                                <div class="d-flex flex-column">
                                    <span class="fw-semibold">{{ $log->created_at->format('M d, Y') }}</span>
                                    <small class="text-muted">{{ $log->created_at->format('h:i A') }}</small>
                                </div>
                            </td>
                            <td>
                                <div class="d-flex align-items-center">
                                    <div class="avatar avatar-sm me-2">
                                        <span class="avatar-initial rounded-circle bg-label-secondary">{{ substr($log->user->name ?? '?', 0, 1) }}</span>
                                    </div>
                                    <span class="fw-medium">{{ $log->user->name ?? 'N/A' }}</span>
                                </div>
                            </td>
                            <td>
                                <div class="d-flex flex-column">
                                    <span class="fw-bold text-dark">{{ $log->product->name ?? 'N/A' }}</span>
                                    <small class="text-muted">
                                        {{ $log->product->code ?? '' }}
                                        @if($log->productVariation && $log->productVariation->variationType)
                                            | <span class="text-info">{{ $log->productVariation->variationType->name }}</span>
                                        @endif
                                    </small>
                                </div>
                            </td>
                            <td>
                                <div class="d-flex flex-column">
                                    <span class="badge bg-label-dark mb-1" style="width: fit-content">{{ $log->productBatch->batch_no ?? 'N/A' }}</span>
                                    <small class="text-muted">{{ $log->productBatch->warehouse->name ?? 'N/A' }}</small>
                                </div>
                            </td>
                            <td class="text-end">
                                <div class="d-flex flex-column align-items-end">
                                    <span class="text-muted text-decoration-line-through small">{{ number_format($log->old_cost_price, 2) }}</span>
                                    <span class="fw-semibold {{ $log->new_cost_price != $log->old_cost_price ? 'text-primary' : 'text-dark' }}">{{ number_format($log->new_cost_price, 2) }}</span>
                                </div>
                            </td>
                            <td class="text-end">
                                <div class="d-flex flex-column align-items-end">
                                    <span class="text-muted text-decoration-line-through small">{{ number_format($log->old_wholesale_price, 2) }}</span>
                                    <span class="fw-semibold {{ $log->new_wholesale_price != $log->old_wholesale_price ? 'text-primary' : 'text-dark' }}">{{ number_format($log->new_wholesale_price, 2) }}</span>
                                </div>
                            </td>
                            <td class="text-end">
                                <div class="d-flex flex-column align-items-end">
                                    <span class="text-muted text-decoration-line-through small">{{ number_format($log->old_retail_price, 2) }}</span>
                                    <span class="fw-semibold {{ $log->new_retail_price != $log->old_retail_price ? 'text-primary' : 'text-dark' }}">{{ number_format($log->new_retail_price, 2) }}</span>
                                </div>
                            </td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="7" class="text-center py-5">
                                <div class="d-flex flex-column align-items-center">
                                    <i class="bx bx-file-blank fs-1 text-muted mb-2"></i>
                                    <p class="text-muted mb-0">No price adjustment logs found for the selected criteria.</p>
                                </div>
                            </td>
                        </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
        
    </div>
    <div class="">
            {{ $logs->links() }}
        </div>
</x-app-layout>