@extends('dashboard.admin.layouts.master')

@section('content')
    <div class="d-flex flex-column flex-column-fluid">
        <div id="kt_app_toolbar" class="app-toolbar py-3 py-lg-6">
            <div id="kt_app_toolbar_container" class="app-container container-xxl d-flex flex-stack">
                <div class="page-title d-flex flex-column justify-content-center flex-wrap me-3">
                    <h1 class="page-heading d-flex text-dark fw-bold fs-3 flex-column justify-content-center my-0">{{ trans('inventory.reports.valuation_title') }}</h1>
                </div>
            </div>
        </div>

        <div id="kt_app_content" class="app-content flex-column-fluid">
            <div id="kt_app_content_container" class="app-container container-xxl">

                {{-- Filters --}}
                <div class="card mb-7">
                    <div class="card-body py-4">
                        <form method="GET" class="row g-4 align-items-end">
                            <div class="col-md-4">
                                <label class="form-label">{{ trans('inventory.reports.warehouse') }}</label>
                                <select name="warehouse_id" data-control="select2" class="form-select">
                                    <option value="">{{ trans('inventory.reports.all_warehouses') }}</option>
                                    @foreach($warehouses as $wh)
                                        <option value="{{ $wh->id }}" @selected($warehouseId == $wh->id)>{{ $wh->name }}</option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="col-md-4">
                                <label class="form-label">{{ trans('inventory.reports.category') }}</label>
                                <select name="category_id" data-control="select2" class="form-select">
                                    <option value="">{{ trans('inventory.reports.all_categories') }}</option>
                                    @foreach($categories as $cat)
                                        <option value="{{ $cat->id }}" @selected($categoryId == $cat->id)>{{ $cat->name }}</option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="col-md-4">
                                <button type="submit" class="btn btn-primary">{{ trans('inventory.reports.filter') }}</button>
                            </div>
                        </form>
                    </div>
                </div>

                {{-- Totals --}}
                <div class="row g-5 mb-7">
                    <div class="col-md-4">
                        <div class="card bg-light-primary">
                            <div class="card-body py-5 text-center">
                                <div class="fs-2 fw-bolder text-primary">{{ number_format($totals['total_items']) }}</div>
                                <div class="fs-7 text-muted">{{ trans('inventory.reports.total_items') }}</div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="card bg-light-info">
                            <div class="card-body py-5 text-center">
                                <div class="fs-2 fw-bolder text-info">{{ number_format($totals['total_qty'], 2) }}</div>
                                <div class="fs-7 text-muted">{{ trans('inventory.reports.total_qty') }}</div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="card bg-light-success">
                            <div class="card-body py-5 text-center">
                                <div class="fs-2 fw-bolder text-success">{{ number_format($totals['total_value'], 2) }}</div>
                                <div class="fs-7 text-muted">{{ trans('inventory.reports.total_value') }}</div>
                            </div>
                        </div>
                    </div>
                </div>

                {{-- Report Table --}}
                <div class="card">
                    <div class="card-body py-4">
                        <div class="table-responsive">
                            <table class="table align-middle table-row-dashed fs-6 gy-5">
                                <thead>
                                <tr class="text-start text-muted fw-bold fs-7 text-uppercase gs-0">
                                    <th>{{ trans('inventory.reports.item_code') }}</th>
                                    <th>{{ trans('inventory.reports.item_name') }}</th>
                                    <th>{{ trans('inventory.reports.warehouse') }}</th>
                                    <th>{{ trans('inventory.reports.category') }}</th>
                                    <th class="text-end">{{ trans('inventory.reports.quantity') }}</th>
                                    <th class="text-end">{{ trans('inventory.reports.average_cost') }}</th>
                                    <th class="text-end">{{ trans('inventory.reports.total_value') }}</th>
                                    <th class="text-end">{{ trans('inventory.reports.reorder_level') }}</th>
                                </tr>
                                </thead>
                                <tbody class="text-gray-600 fw-semibold">
                                @forelse($report as $row)
                                    <tr @class(['table-warning' => (float)$row->quantity <= (float)$row->reorder_level && (float)$row->reorder_level > 0])>
                                        <td>{{ $row->item_code }}</td>
                                        <td>{{ is_array(json_decode($row->item_name, true)) ? json_decode($row->item_name, true)[app()->getLocale()] ?? $row->item_name : $row->item_name }}</td>
                                        <td>{{ is_array(json_decode($row->warehouse_name, true)) ? json_decode($row->warehouse_name, true)[app()->getLocale()] ?? $row->warehouse_name : $row->warehouse_name }}</td>
                                        <td>{{ $row->category_name ? (is_array(json_decode($row->category_name, true)) ? json_decode($row->category_name, true)[app()->getLocale()] ?? '-' : $row->category_name) : '-' }}</td>
                                        <td class="text-end">{{ number_format($row->quantity, 4) }}</td>
                                        <td class="text-end">{{ number_format($row->average_cost, 4) }}</td>
                                        <td class="text-end">{{ number_format($row->total_value, 2) }}</td>
                                        <td class="text-end">{{ number_format($row->reorder_level, 2) }}</td>
                                    </tr>
                                @empty
                                    <tr><td colspan="8" class="text-center py-10">{{ trans('inventory.reports.no_data') }}</td></tr>
                                @endforelse
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection