@extends('layouts.admin-simple')

@section('title', 'Site Return Report')

@section('breadcrumb')
    <li class="breadcrumb-item">Warehouse</li>
    <li class="breadcrumb-item"><a href="{{ route('warehouse.reports.index') }}">Reports</a></li>
    <li class="breadcrumb-item active">Site Return</li>
@endsection

@section('page-title')
    <div class="page-title-left">
        <h3 class="mb-1">Site Return Report</h3>
        <p class="text-muted mb-0" style="font-size: 13px;">Site returns and material return tracking</p>
    </div>
@endsection

@section('content')
    <!-- Statistics Cards -->
    <div class="row mb-4 warehouse-stats-row">
        <div class="col-xl-3 col-md-6 mb-3">
            <x-warehouse.stats-card
                title="Total Returns"
                :value="$returnItems->total()"
                icon="assignment_return"
                color="warning"
                subtitle="All returned items"
            />
        </div>

        <div class="col-xl-3 col-md-6 mb-3">
            <x-warehouse.stats-card
                title="Total Quantity"
                :value="number_format($returnItems->getCollection()->sum('quantity'), 2)"
                icon="inventory_2"
                color="info"
                subtitle="Total quantity returned"
            />
        </div>

        <div class="col-xl-3 col-md-6 mb-3">
            <x-warehouse.stats-card
                title="Total Value"
                :value="'AED ' . number_format($returnItems->getCollection()->sum('total_price'), 2)"
                icon="attach_money"
                color="danger"
                subtitle="Total value of returns"
                :showDirham="true"
            />
        </div>

        <div class="col-xl-3 col-md-6 mb-3">
            <x-warehouse.stats-card
                title="Quality Passed"
                :value="collect($returnItems->getCollection())->where('quality_status', 'passed')->count()"
                icon="verified"
                color="success"
                subtitle="Items passed quality check"
            />
        </div>
    </div>

    <!-- Filters Panel -->
    <div class="card mb-4 warehouse-filters-panel">
        <div class="card-header">
            <h5 class="mb-0">
                <i class="material-icons align-middle mr-2">filter_list</i>
                Filters
            </h5>
        </div>
        <div class="card-body">
            <form id="filterForm" class="warehouse-filter-form" method="GET" action="{{ route('warehouse.reports.returns') }}">
                <div class="row">
                    <div class="col-md-2 mb-3">
                        <label class="form-label">Search</label>
                        <input type="text" name="search" value="{{ request('search') }}" class="form-control" 
                               placeholder="Item code, description">
                    </div>

                    <div class="col-md-2 mb-3">
                        <label class="form-label">Project</label>
                        <select name="project_id" class="form-control warehouse-select2">
                            <option value="">All Projects</option>
                            @foreach($projects as $project)
                                <option value="{{ $project->id }}" {{ request('project_id') == $project->id ? 'selected' : '' }}>
                                    {{ $project->project_name }}
                                </option>
                            @endforeach
                        </select>
                    </div>

                    <div class="col-md-2 mb-3">
                        <label class="form-label">Division</label>
                        <select name="division_id" class="form-control warehouse-select2">
                            <option value="">All Divisions</option>
                            @foreach($divisions as $division)
                                <option value="{{ $division->id }}" {{ request('division_id') == $division->id ? 'selected' : '' }}>
                                    {{ $division->name }}
                                </option>
                            @endforeach
                        </select>
                    </div>

                    <div class="col-md-2 mb-3">
                        <label class="form-label">Category</label>
                        <select name="category_id" class="form-control warehouse-select2">
                            <option value="">All Categories</option>
                            @foreach($categories as $category)
                                <option value="{{ $category->id }}" {{ request('category_id') == $category->id ? 'selected' : '' }}>
                                    {{ $category->category_name }}
                                </option>
                            @endforeach
                        </select>
                    </div>

                    <div class="col-md-2 mb-3">
                        <label class="form-label">Quality Status</label>
                        <select name="quality_status" class="form-control warehouse-select2">
                            <option value="">All Quality Status</option>
                            @foreach($qualityStatuses as $status)
                                <option value="{{ $status }}" {{ request('quality_status') == $status ? 'selected' : '' }}>
                                    {{ ucfirst($status) }}
                                </option>
                            @endforeach
                        </select>
                    </div>

                    <div class="col-md-2 mb-3">
                        <label class="form-label">&nbsp;</label>
                        <button type="submit" class="btn btn-primary btn-block">
                            <i class="material-icons" style="font-size: 18px; vertical-align: middle;">search</i>
                            Apply
                        </button>
                    </div>
                </div>
                
                <div class="row">
                    <div class="col-md-2 mb-3">
                        <label class="form-label">Date From</label>
                        <input type="date" name="date_from" value="{{ request('date_from') }}" class="form-control warehouse-datepicker">
                    </div>

                    <div class="col-md-2 mb-3">
                        <label class="form-label">Date To</label>
                        <input type="date" name="date_to" value="{{ request('date_to') }}" class="form-control warehouse-datepicker">
                    </div>
                </div>
            </form>
        </div>
    </div>

    <!-- Export Buttons -->
    <div class="row warehouse-export-buttons">
        <div class="col-12 text-right">
            <button class="btn btn-success warehouse-export-btn" data-export="excel">
                <i class="material-icons" style="font-size: 18px; vertical-align: middle;">download</i>
                Export Excel
            </button>
            <button class="btn btn-info warehouse-export-btn" data-export="pdf">
                <i class="material-icons" style="font-size: 18px; vertical-align: middle;">picture_as_pdf</i>
                Export PDF
            </button>
            <button class="btn btn-secondary warehouse-export-btn" data-action="print">
                <i class="material-icons" style="font-size: 18px; vertical-align: middle;">print</i>
                Print
            </button>
        </div>
    </div>

    <!-- Site Return Report Table -->
    <div class="card">
        <div class="card-header warehouse-report-header">
            <h5 class="mb-0 warehouse-report-title">
                <i class="material-icons align-middle mr-2">assignment_return</i>
                Site Return Report ({{ $returnItems->total() }} total returns)
            </h5>
        </div>
        <div class="card-body p-0">
            <div class="warehouse-table-container">
                <!-- Loading Overlay -->
                <div class="warehouse-loading-overlay" id="tableLoadingOverlay">
                    <div class="warehouse-loading-content">
                        <div class="text-center">
                            <div class="spinner-border text-primary" role="status">
                                <span class="sr-only">Loading...</span>
                            </div>
                            <div class="mt-2">Loading return data...</div>
                        </div>
                    </div>
                </div>

                <!-- Table -->
                <div class="warehouse-table-wrapper">
                    <table class="table table-hover mb-0 warehouse-table">
                        <thead class="thead-light">
                            <tr>
                                <th style="min-width: 150px;">Reference Number</th>
                                <th style="min-width: 120px;">Reference Type</th>
                                <th style="min-width: 180px;">Project</th>
                                <th style="min-width: 120px;">Division</th>
                                <th style="min-width: 120px;">Item Code</th>
                                <th style="min-width: 200px;">Description</th>
                                <th style="min-width: 100px;">Category</th>
                                <th style="min-width: 80px;" class="text-right">Quantity</th>
                                <th style="min-width: 100px;" class="text-right">Unit Price</th>
                                <th style="min-width: 100px;" class="text-right">Total Price</th>
                                <th style="min-width: 100px;" class="text-center">Quality Status</th>
                                <th style="min-width: 100px;" class="text-center">Return Date</th>
                                <th style="min-width: 80px;" class="text-center">Actions</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($returnItems as $item)
                                <tr>
                                    <td class="warehouse-cell-nowrap">{{ $item->reference_number ?? '-' }}</td>
                                    <td>
                                        @if($item->reference_type == 'Material Request')
                                            <span class="badge warehouse-badge warehouse-status-success">{{ $item->reference_type }}</span>
                                        @elseif($item->reference_type == 'Direct Delivery')
                                            <span class="badge warehouse-badge warehouse-status-info">{{ $item->reference_type }}</span>
                                        @elseif($item->reference_type == 'Material Transfer')
                                            <span class="badge warehouse-badge warehouse-status-warning">{{ $item->reference_type }}</span>
                                        @else
                                            <span class="badge warehouse-badge warehouse-status-secondary">{{ $item->reference_type }}</span>
                                        @endif
                                    </td>
                                    <td>{{ Str::limit($item->project_name ?? '-', 25) }}</td>
                                    <td>{{ $item->division ?? '-' }}</td>
                                    <td class="warehouse-cell-nowrap">{{ $item->item_code }}</td>
                                    <td>{{ Str::limit($item->item_description, 30) }}</td>
                                    <td>
                                        <span class="badge warehouse-badge warehouse-status-secondary">
                                            {{ $item->type_of_goods ?? 'No Category' }}
                                        </span>
                                    </td>
                                    <td class="text-right warehouse-cell-number">
                                        <strong>{{ number_format($item->quantity, 2) }}</strong>
                                    </td>
                                    <td class="text-right warehouse-cell-currency">
                                        AED {{ number_format($item->unit_price, 2) }}
                                    </td>
                                    <td class="text-right warehouse-cell-currency">
                                        <strong class="text-danger">AED {{ number_format($item->total_price, 2) }}</strong>
                                    </td>
                                    <td class="warehouse-cell-status">
                                        <span class="badge warehouse-badge warehouse-status-{{
                                            $item->quality_status === 'passed' ? 'success' :
                                            ($item->quality_status === 'failed' ? 'danger' : 
                                            ($item->quality_status === 'conditional' ? 'warning' : 'info'))
                                        }}">
                                            {{ ucfirst($item->quality_status ?? 'pending') }}
                                        </span>
                                    </td>
                                    <td class="text-center warehouse-cell-date">
                                        {{ $item->operation_date ? \Carbon\Carbon::parse($item->operation_date)->format('d M Y') : '-' }}
                                    </td>
                                    <td class="text-center">
                                        <a href="#" class="btn btn-sm btn-outline-primary warehouse-action-btn">
                                            <i class="material-icons">visibility</i>
                                        </a>
                                    </td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="13" class="warehouse-empty-state">
                                        <i class="material-icons">assignment_return</i>
                                        <h5>No Return Records Found</h5>
                                        <p class="text-muted">No returns match your current filters.</p>
                                    </td>
                                </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
        
        @if($returnItems->hasPages())
            <div class="card-footer">
                <div class="d-flex justify-content-between align-items-center">
                    <div>
                        Showing {{ $returnItems->firstItem() }} to {{ $returnItems->lastItem() }} 
                        of {{ $returnItems->total() }} returns
                    </div>
                    <div>
                        <nav class="warehouse-pagination">
                            {{ $returnItems->links('pagination::bootstrap-4') }}
                        </nav>
                    </div>
                </div>
            </div>
        @endif
    </div>
@endsection

@push('styles')
    <link href="{{ asset('admin-assets/css/warehouse-reports.css') }}" rel="stylesheet" />
    <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
@endpush

@push('scripts')
    <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
    <script src="{{ asset('admin-assets/js/warehouse-reports.js') }}"></script>
@endpush