@extends('layouts.app')

@section('content')
<div class="container mt-4 mb-5">
    <div class="row">
        <!-- Left Panel: Stock Update Form -->
        <div class="col-lg-5 col-sm-12 mb-4">
            <div class="card p-4 shadow-sm">
                <div class="mb-3">
                    <h5 class="font-semibold">Update Stock</h5>
                </div>

                <!-- Action Buttons -->
                <div class="mb-3">
                    <a href="{{ route('pos.stock.index', ['type' => 1]) }}" class="btn btn-success btn-sm mr-1">Stock In</a>
                    <a href="{{ route('pos.stock.index', ['type' => 0]) }}" class="btn btn-danger btn-sm mr-1">Stock Out</a>
                    <a href="{{ route('pos.stock.transfer') }}" class="btn btn-info btn-sm mr-1">Stock Transfer</a>
                    <a href="{{ route('pos.stock.count.index') }}" class="btn btn-dark btn-sm">Stock Count</a>
                </div>

                <!-- Barcode Scanner -->
                <div class="bg-light rounded p-3 mb-3">
                    <form method="get" action="{{ route('pos.stock.index') }}" autocomplete="off" class="mb-3">
                        <input type="hidden" name="type" value="{{ $type }}">
                        <input type="text" 
                               name="product_barcode" 
                               required 
                               class="form-control w-100 mb-2" 
                               placeholder="Scan Barcode or Enter Product Code, Name" 
                               list="pro_list"
                               @if(request()->has('bar_select')) autofocus @endif>
                    </form>

                    @if($product)
                    <form method="post" action="{{ route('pos.stock.store') }}">
                        @csrf
                        <input type="hidden" name="product_systemid" value="{{ $product->product_systemid }}">
                        <input type="hidden" name="product_barcode" value="{{ $product->product_barcode }}">
                        <input type="hidden" name="stock_type" value="{{ $type }}">

                        <hr>
                        
                        <!-- Product Details -->
                        <table class="table-sm mb-3 w-100" style="text-transform: capitalize;">
                            <tbody>
                                <tr>
                                    <td class="py-1">Barcode</td>
                                    <td class="py-1">{{ $product->product_barcode }}</td>
                                </tr>
                                <tr>
                                    <td class="py-1">Product ID</td>
                                    <td class="py-1">{{ $product->product_productid }}</td>
                                </tr>
                                <tr>
                                    <td class="py-1">Name</td>
                                    <td class="py-1">
                                        {{ $product->product_name }}
                                        @if($product->product_name != $product->product_name_sinhala)
                                        , {{ $product->product_name_sinhala }}
                                        @endif
                                    </td>
                                </tr>
                                <tr><td colspan="2" class="p-0"><hr></td></tr>
                                <tr>
                                    <td class="py-1">Total In</td>
                                    <td class="py-1" id="total-in">{{ number_format(\App\Models\StockDetail::totalIn($product->product_systemid), 3) }}</td>
                                </tr>
                                <tr>
                                    <td class="py-1">Total Out</td>
                                    <td class="py-1" id="total-out">{{ number_format(\App\Models\StockDetail::totalOut($product->product_systemid), 3) }}</td>
                                </tr>
                                <tr>
                                    <td class="py-1">Balance QTY</td>
                                    <td class="py-1"><b id="balance-qty">{{ number_format(\App\Models\StockDetail::availableQty($product->product_systemid), 3) }}</b></td>
                                </tr>
                            </tbody>
                        </table>

                        <hr>

                        <!-- Stock Update Form -->
                        @if($type == 0)
                        <div class="mb-3">
                            <textarea name="stock_return_remark" rows="4" class="form-control form-control-sm" placeholder="Remark (required for stock out)"></textarea>
                        </div>
                        @endif

                        <div class="row">
                            <div class="col-4">
                                <select name="stock_location_id" required class="form-control form-control-sm">
                                    @foreach($locations as $location)
                                    <option value="{{ $location->ld_id }}" @if(session('location_id') == $location->ld_id) selected @endif>
                                        {{ $location->ld_name }}
                                    </option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="col-4">
                                <select name="stock_badge_id" required class="form-control form-control-sm">
                                    @php
                                        $badges = \App\Models\PriceDetail::where('price_systemid', $product->product_systemid)
                                            ->orderBy('price_id', 'desc')->get();
                                    @endphp
                                    @foreach($badges as $badge)
                                    <option value="{{ $badge->price_id }}">
                                        {{ $badge->price_name }} | MRP: {{ number_format($badge->price_sale, 2) }} | {{ $badge->price_addtime->format('Y-m-d h:i A') }}
                                    </option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="col-2">
                                <input name="stock_qty" type="number" required class="form-control form-control-sm" placeholder="Qty" step="0.001">
                            </div>
                            <div class="col-2">
                                <button type="submit" class="btn btn-dark btn-sm w-100">Update</button>
                            </div>
                        </div>

                        <!-- Location-wise Stock -->
                        <div class="mt-3">
                            <table class="table table-sm table-bordered bg-white mb-0">
                                <tbody>
                                    @foreach($locations as $location)
                                    <tr>
                                        <td>{{ $location->ld_name }}</td>
                                        <td class="font-weight-bold">
                                            {{ number_format(\App\Models\StockDetail::availableQtyByLocation($product->product_systemid, $location->ld_id), 3) }}
                                        </td>
                                    </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    </form>
                    @endif
                </div>
            </div>
        </div>

        <!-- Right Panel: Stock Summary -->
        <div class="col-lg-7 col-sm-12">
            <div class="card p-4 shadow-sm mb-4">
                <div class="mb-3">
                    <h5 class="font-semibold">Last 50 record stock summary</h5>
                </div>

                @if($product)
                <div class="row mb-3">
                    <div class="col-6 pr-1">
                        <a href="{{ route('pos.stock.full-summary', ['product_systemid' => $product->product_systemid]) }}" 
                           target="_blank" 
                           class="btn btn-light btn-sm w-100">Full Stock Summary</a>
                    </div>
                    <div class="col-6 pl-1">
                        <a href="#" class="btn btn-light btn-sm w-100">Transfer Badge</a>
                    </div>
                </div>

                <!-- Last 50 Movements -->
                <div class="border rounded mb-3" style="height: 300px; overflow-y: scroll;">
                    <table class="table table-bordered table-hover mb-0">
                        <thead class="bg-light">
                            <tr>
                                <th>Time</th>
                                <th>Info</th>
                                <th>QTY</th>
                                <th>Type</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php
                                $movements = \App\Models\StockDetail::where('stock_systemid', $product->product_systemid)
                                    ->with(['badge', 'location'])
                                    ->orderBy('stock_id', 'desc')
                                    ->limit(50)
                                    ->get();
                            @endphp
                            @forelse($movements as $movement)
                            <tr>
                                <td>{{ $movement->stock_addtime->format('Y-m-d h:i A') }}</td>
                                <td>
                                    {{ $movement->stock_info }}<br>
                                    <em class="text-secondary">
                                        @if($movement->badge)
                                        {{ $movement->badge->price_name }}
                                        @endif
                                        @if($movement->location)
                                        ({{ $movement->location->ld_name }})
                                        @endif
                                    </em>
                                    @if($movement->stock_type == 0 && $movement->stock_return_remark)
                                    <br><em class="text-primary">{{ $movement->stock_return_remark }}</em>
                                    @endif
                                </td>
                                <td>{{ number_format($movement->stock_qty, 3) }}</td>
                                <td class="text-center">
                                    @if($movement->stock_type == 1)
                                    <span class="badge badge-success">Stock In</span>
                                    @else
                                    <span class="badge badge-danger">Stock Out</span>
                                    @endif
                                </td>
                            </tr>
                            @empty
                            <tr><td colspan="4" class="text-center">Record Not Found</td></tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>

                <!-- Badge-wise Available Qty -->
                <h6 class="font-semibold">Badge wise available Qty</h6>
                <div class="border rounded" style="height: 300px; overflow-y: scroll;">
                    <table class="table table-bordered table-hover mb-0">
                        <thead class="bg-light">
                            <tr>
                                <th>Badge</th>
                                <th>Create Time</th>
                                <th>MRP</th>
                                <th>Qty</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php
                                $badges = \App\Models\PriceDetail::where('price_systemid', $product->product_systemid)
                                    ->orderBy('price_id', 'desc')
                                    ->get();
                            @endphp
                            @foreach($badges as $badge)
                            <tr @if($badge->price_remove == 1) style="text-decoration: line-through;" @endif>
                                <td>{{ $badge->price_name }}</td>
                                <td>{{ $badge->price_addtime->format('Y-m-d h:i A') }}</td>
                                <td>{{ number_format($badge->price_sale, 2) }}</td>
                                <td class="font-weight-bold">
                                    {{ number_format(\App\Models\StockDetail::availableQtyByBadge($product->product_systemid, $badge->price_id), 3) }}
                                </td>
                            </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
                @endif
            </div>
        </div>
    </div>
</div>

<!-- Product Datalist -->
<datalist id="pro_list">
    @foreach($products as $prod)
    <option value="{{ $prod->product_barcode }}">{{ $prod->product_name }} - {{ $prod->product_name_sinhala }}</option>
    @endforeach
</datalist>

@if($notFound)
<script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>
<script>
Swal.fire({
    title: 'Error',
    html: '<br> Product not found, Please try again.',
    icon: 'error',
    confirmButtonText: 'OK',
    confirmButtonClass: 'btn btn-primary',
});
</script>
@endif

@if(session('success'))
<script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>
<script>
Swal.fire({
    title: 'Success',
    text: '{{ session('success') }}',
    icon: 'success',
    confirmButtonText: 'OK'
});
</script>
@endif
@endsection