@extends('master.app')
@section('title', 'Daily Stock History')

@section('body')
<main class="app-content">
    <div class="card border-0 shadow-sm" style="border-radius:18px; overflow:hidden;">
        <div class="p-3 p-md-4 border-bottom"
             style="background:linear-gradient(135deg, rgba(13,110,253,.12), rgba(102,16,242,.06));">
            <div class="d-flex flex-wrap align-items-center justify-content-between gap-2">
                <div>
                    <h5 class="mb-1 fw-bold">
                        <i class="fa fa-calendar-day me-1"></i> Daily IN / OUT History
                    </h5>
                    <div class="text-muted small">Filter by Date + Warehouse • Print ready • International UI</div>
                </div>
                <div class="d-flex gap-2">
                    <a href="{{ route('stocks.index') }}" class="btn btn-sm btn-dark" style="border-radius:10px;">
                        <i class="fa fa-arrow-left me-1"></i> Back
                    </a>
                    <button onclick="window.print()" class="btn btn-sm btn-primary" style="border-radius:10px;">
                        <i class="fa fa-print me-1"></i> Print
                    </button>
                </div>
            </div>
        </div>

        <div class="card-body p-3 p-md-4">
            @include('general.valert')

            {{-- Filters --}}
            <form method="GET" action="{{ route('stock.daily') }}" class="mb-3">
                <div class="row g-2 align-items-end">
                    <div class="col-md-4">
                        <label class="small text-muted mb-1">Date</label>
                        <input type="date" name="date" value="{{ $date }}" class="form-control" style="border-radius:12px;">
                    </div>
                    <div class="col-md-5">
                        <label class="small text-muted mb-1">Warehouse / Location</label>
                        <select name="location_id" class="form-control" style="border-radius:12px;">
                            <option value="">All Warehouses</option>
                            @foreach($locations as $loc)
                                <option value="{{ $loc->id }}" @if($location_id == $loc->id) selected @endif>
                                    {{ $loc->name_ps ?? $loc->name_en ?? ('Location #'.$loc->id) }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-md-3 d-grid">
                        <button class="btn btn-primary" style="border-radius:12px;">
                            <i class="fa fa-filter me-1"></i> Apply Filter
                        </button>
                    </div>
                </div>
            </form>

            {{-- Summary --}}
            <div class="row g-2 mb-3">
                <div class="col-md-6">
                    <div class="p-3 border bg-light" style="border-radius:14px;">
                        <div class="text-muted small"><i class="fa fa-arrow-down me-1"></i> Total IN Qty</div>
                        <div class="fw-bold fs-5">{{ number_format($totalInQty, 2) }}</div>
                        <div class="text-muted small">Rows: {{ $ins->count() }}</div>
                    </div>
                </div>
                <div class="col-md-6">
                    <div class="p-3 border bg-light" style="border-radius:14px;">
                        <div class="text-muted small"><i class="fa fa-arrow-up me-1"></i> Total OUT Qty</div>
                        <div class="fw-bold fs-5">{{ number_format($totalOutQty, 2) }}</div>
                        <div class="text-muted small">Rows: {{ $outs->count() }}</div>
                    </div>
                </div>
            </div>

            {{-- Tabs --}}
            <ul class="nav nav-pills mb-3" role="tablist">
                <li class="nav-item" role="presentation">
                    <button class="nav-link active" data-bs-toggle="pill" data-bs-target="#tab_in" type="button" role="tab"
                            style="border-radius:12px;">
                        <i class="fa fa-arrow-down me-1"></i> IN (StockHistory)
                        <span class="badge bg-dark ms-1">{{ $ins->count() }}</span>
                    </button>
                </li>
                <li class="nav-item ms-2" role="presentation">
                    <button class="nav-link" data-bs-toggle="pill" data-bs-target="#tab_out" type="button" role="tab"
                            style="border-radius:12px;">
                        <i class="fa fa-arrow-up me-1"></i> OUT (Sales)
                        <span class="badge bg-dark ms-1">{{ $outs->count() }}</span>
                    </button>
                </li>
            </ul>

            <div class="tab-content">
                {{-- IN TABLE --}}
                <div class="tab-pane fade show active" id="tab_in" role="tabpanel">
                    <div class="table-responsive">
                        <table class="table table-hover align-middle">
                            <thead class="bg-light">
                                <tr>
                                    <th style="width:60px;">#</th>
                                    <th>Category</th>
                                    <th>Sub</th>
                                    <th>Unit</th>
                                    <th>Weight</th>
                                    <th class="text-end">Qty</th>
                                    <th>Warehouse</th>
                                    <th>Date</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($ins as $row)
                                    <tr>
                                        <td class="fw-bold">{{ $loop->iteration }}</td>
                                        <td>{{ $row->category->title_ps ?? $row->category->title_en ?? '-' }}</td>
                                        <td>{{ $row->sub_category->title_ps ?? $row->sub_category->title_en ?? '-' }}</td>
                                        <td>{{ $row->unit->title_ps ?? $row->unit->title_en ?? '-' }}</td>
                                        <td><span class="badge bg-success">{{ $row->weight->title_ps ?? $row->weight->title_en ?? '-' }}</span></td>
                                        <td class="text-end fw-bold">{{ number_format((float)$row->qty, 2) }}</td>
                                        <td>{{ $row->location->name_ps ?? $row->location->name_en ?? ($row->location_id ? 'Loc#'.$row->location_id : '-') }}</td>
                                        <td>{{ $row->date ?? '-' }}</td>
                                    </tr>
                                @empty
                                    <tr><td colspan="8" class="text-center text-muted py-4">No IN records for this date</td></tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>

                {{-- OUT TABLE --}}
                <div class="tab-pane fade" id="tab_out" role="tabpanel">
                    <div class="table-responsive">
                        <table class="table table-hover align-middle">
                            <thead class="bg-light">
                                <tr>
                                    <th style="width:60px;">#</th>
                                    <th>Bill/Invoice</th>
                                    <th>Category</th>
                                    <th>Sub</th>
                                    <th>Unit</th>
                                    <th>Weight</th>
                                    <th class="text-end">Qty</th>
                                    <th>Warehouse</th>
                                    <th>Date</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($outs as $row)
                                    <tr>
                                        <td class="fw-bold">{{ $loop->iteration }}</td>

                                        {{-- bill_id safe --}}
                                        <td>
                                            <span class="badge bg-dark">
                                                {{ $row->bill_id ?? $row->invoice_number ?? ('#'.$row->id) }}
                                            </span>
                                        </td>

                                        {{-- these may not exist in your model, so we make it SAFE --}}
                                        <td>{{ $row->category->title_ps ?? $row->category->title_en ?? ($row->cat_id ?? '-') }}</td>
                                        <td>{{ $row->sub_category->title_ps ?? $row->sub_category->title_en ?? ($row->sub_cat_id ?? '-') }}</td>
                                        <td>{{ $row->unit->title_ps ?? $row->unit->title_en ?? ($row->unit_id ?? '-') }}</td>
                                        <td>
                                            <span class="badge bg-success">
                                                {{ $row->weight->title_ps ?? $row->weight->title_en ?? ($row->weight_id ?? '-') }}
                                            </span>
                                        </td>

                                        {{-- qty sometimes named quantity --}}
                                        <td class="text-end fw-bold">
                                            {{ number_format((float)($row->qty ?? $row->quantity ?? 0), 2) }}
                                        </td>

                                        <td>{{ $row->location->name_ps ?? $row->location->name_en ?? ($row->location_id ? 'Loc#'.$row->location_id : '-') }}</td>

                                        {{-- date fallback --}}
                                        <td>
                                            {{ $row->date ?? optional($row->created_at)->format('Y-m-d') ?? '-' }}
                                        </td>
                                    </tr>
                                @empty
                                    <tr><td colspan="9" class="text-center text-muted py-4">No OUT records for this date</td></tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>

            {{-- quick debug (remove later) --}}
            {{-- <div class="small text-muted mt-3">DEBUG: outs={{ $outs->count() }} | ins={{ $ins->count() }}</div> --}}
        </div>
    </div>
</main>
@endsection

@section('pageJs')
<script>
    $(".app-menu").removeClass("active");
    $("#nav_stocki").addClass("active");
    $("#stocki").addClass("is-expanded");
</script>
@endsection