@extends('master.app')
@section('title', 'Row Materials Stock')

@section('body')
    <main class="app-content">
        <div class="card">
            <div class="card-body">

                <div class="row align-items-center">
                    <div class="col-md-6">
                        <h4 class="mb-0">Row Materials Stock</h4>
                        <small class="text-muted">Raw inventory with average cost (moving average)</small>
                    </div>
                    <div class="col-md-6">
                        <div class="btn-group" role="group" style="float:right">

                            <a href="{{ route('row_stock.create') }}"
                                class="btn btn-primary btn-rounded btn-sm text-light">Add</a>
                        </div>
                    </div>
                </div>

                {{-- Filters --}}
                <div class="mt-3">
                    <form method="GET" class="row g-2">
                        <div class="col-md-2">
                            <label class="small text-muted">Category</label>
                            <select name="cat_id" class="form-control form-control-sm">
                                <option value="all">All</option>
                                @foreach ($category as $c)
                                    <option value="{{ $c->id }}" {{ request('cat_id') == $c->id ? 'selected' : '' }}>
                                        {{ $c->title_ps ?? ($c->title_en ?? $c->id) }}
                                    </option>
                                @endforeach
                            </select>
                        </div>

                        <div class="col-md-2">
                            <label class="small text-muted">Unit</label>
                            <select name="unit_id" class="form-control form-control-sm">
                                <option value="all">All</option>
                                @foreach ($units as $u)
                                    <option value="{{ $u->id }}" {{ request('unit_id') == $u->id ? 'selected' : '' }}>
                                        {{ $u->title_ps ?? ($u->title_en ?? $u->id) }}
                                    </option>
                                @endforeach
                            </select>
                        </div>

                        <div class="col-md-2">
                            <label class="small text-muted">Currency</label>
                            <select name="currency_id" class="form-control form-control-sm">
                                <option value="all">All</option>
                                @foreach ($currencies as $cu)
                                    <option value="{{ $cu->id }}"
                                        {{ request('currency_id') == $cu->id ? 'selected' : '' }}>
                                        {{ $cu->title_ps ?? ($cu->title_en ?? $cu->id) }}
                                    </option>
                                @endforeach
                            </select>
                        </div>

                        <div class="col-md-2">
                            <label class="small text-muted">Location</label>
                            <select name="location_id" class="form-control form-control-sm">
                                <option value="all">All</option>
                                <option value="null" {{ request('location_id') == 'null' ? 'selected' : '' }}>No Location
                                </option>
                                @php
                                    $locations = $stock
                                        ->pluck('location_id')
                                        ->unique()
                                        ->filter(fn($v) => $v !== null)
                                        ->values();
                                @endphp
                                @foreach ($locations as $loc)
                                    <option value="{{ $loc }}" {{ request('location_id') == $loc ? 'selected' : '' }}>
                                        Loc #{{ $loc }}</option>
                                @endforeach
                            </select>
                        </div>

                        <div class="col-md-2">
                            <label class="small text-muted">Min Qty (<=)< /label>
                                    <input type="number" step="0.01" name="min_qty" value="{{ request('min_qty') }}"
                                        class="form-control form-control-sm" placeholder="e.g 10">
                        </div>

                        <div class="col-md-2 d-flex align-items-end gap-1">
                            <button class="btn btn-sm btn-primary w-100">Filter</button>
                            <a href="{{ route('row_stock.index') }}" class="btn btn-sm btn-light w-100">Reset</a>
                        </div>
                    </form>
                </div>

                <div class="row mt-3">
                    <div class="col-md-12">
                        <div class="table-responsive">
                            <table class="table table-striped dt-responsive"
                                style="border-collapse: collapse; border-spacing: 0;">
                                <thead>
                                    <tr>
                                        <th>#</th>
                                        <th>Cat</th>
                                        <th>Sub Category</th>
                                        <th>Unit</th>
                                        <th>Currency</th>
                                        <th>Location</th>
                                        <th class="text-end">Qty</th>
                                        <th class="text-end">Avg CPI</th>
                                        <th class="text-end">Total Cost</th>
                                        <th class="text-end">SPI</th>
                                        <th>Actions</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                        $sumQty = 0;
                                        $sumCost = 0;
                                    @endphp

                                    @foreach ($stock as $row)
                                        @php
                                            $qty = (float) ($row->qty ?? 0);
                                            $avg = property_exists($row, 'avg_cpi')
                                                ? (float) ($row->avg_cpi ?? $row->cpi)
                                                : (float) ($row->cpi ?? 0);
                                            $total = property_exists($row, 'total_cost')
                                                ? (float) ($row->total_cost ?? $qty * $avg)
                                                : (float) ($qty * $avg);
                                            $sumQty += $qty;
                                            $sumCost += $total;
                                        @endphp
                                        <tr class="fw-normal">
                                            <td>{{ $loop->iteration }}</td>
                                            <td>{{ $row->category->title_ps ?? ($row->category->title_en ?? $row->cat_id) }}
                                            </td>
                                            <td>
                                                @if ($row->scat_id == null)
                                                    {{ 'No Sub Cat' }}
                                                @else
                                                    {{ $row->sub_category->title_ps ?? ($row->sub_category->title_en ?? $row->scat_id) }}
                                                @endif
                                            </td>
                                            <td>{{ $row->unit->title_ps ?? ($row->unit->title_en ?? $row->unit_id) }}</td>
                                            <td>{{ $row->currency->title_ps ?? ($row->currency->title_en ?? $row->currency_id) }}
                                            </td>
                                            <td>{{ $row->location_id ?? '-' }}</td>

                                            <td class="text-end">{{ number_format($qty, 2) }}</td>
                                            <td class="text-end">{{ number_format($avg, 4) }}</td>
                                            <td class="text-end">{{ number_format($total, 2) }}</td>
                                            <td class="text-end">{{ number_format((float) ($row->spi ?? 0), 2) }}</td>

                                            <td>
                                                <a href="{{ route('row_stock.edit', $row->id) }}" data-mdb-toggle="tooltip"
                                                    title="Edit">
                                                    <i class="fas fa-pencil fa-lg text-success me-3"></i>
                                                </a>
                                            </td>
                                        </tr>
                                    @endforeach

                                    @if ($stock->count() == 0)
                                        <tr>
                                            <td colspan="11" class="text-center text-muted">No data found</td>
                                        </tr>
                                    @endif
                                </tbody>

                                <tfoot>
                                    <tr>
                                        <th colspan="6" class="text-end">Page Total</th>
                                        <th class="text-end">{{ number_format($sumQty, 2) }}</th>
                                        <th></th>
                                        <th class="text-end">{{ number_format($sumCost, 2) }}</th>
                                        <th></th>
                                        <th></th>
                                    </tr>
                                </tfoot>
                            </table>
                        </div>
                    </div>
                </div>

                <div class="row mt-3">
                    <div class="card">
                        <div class="card-body">
                            {{ $stock->links('pagination::bootstrap-4') }}
                        </div>
                    </div>
                </div>

            </div>
        </div>
    </main>
@endsection

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