@extends('admin.layouts')

@section('title', 'Stock Details')

@section('head')

    <link rel="stylesheet" href="https://cdn.datatables.net/1.11.5/css/dataTables.bootstrap5.min.css">

    <link rel="stylesheet" href="https://cdn.datatables.net/responsive/2.2.9/css/responsive.bootstrap.min.css">

    <link rel="stylesheet" href="https://cdn.datatables.net/buttons/2.2.2/css/buttons.dataTables.min.css">

    <link href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.10.5/font/bootstrap-icons.css" rel="stylesheet">

@endsection

@section('content')

    {{-- <div class="container-fluid page-wrapper category-container">

        <div class="d-flex justify-content-between align-items-center mb-4">

            <h2 class="page-title">Stock Details</h2>

        </div>

        <div class="d-flex justify-content-between align-items-center mb-3">

        </div>

        <div class="card shadow-sm">

            <div class="card-body">

           <table id="stock-details-table" class="table table-hover responsive nowrap" style="width:100%">

   <thead>

        <tr>

            <th>S.No</th>

            <th>Date</th>

            <th>Transaction Type</th>

            <th>Quantity</th>

            <th>Invoice / Order</th>

            <th>Closing Stock</th>

        </tr>

    </thead>

       <tbody>

    @php $closing_stock = 0; @endphp

    @foreach ($transactions as $transaction)

        @if ($transaction['type'] == 'Purchase')

            @if ($closing_stock <= 0)

                @php $closing_stock = $transaction['quantity']; @endphp

            @else

                @php $closing_stock += $transaction['quantity']; @endphp

            @endif

        @else

            @php $closing_stock -= $transaction['quantity']; @endphp

        @endif

        @php

            $display_stock = $closing_stock < 0 ? 0 : $closing_stock;

        @endphp

        <tr>

            <td>{{ $loop->iteration }}</td>

            <td>{{ \Carbon\Carbon::parse($transaction['date'])->format('Y-m-d') }}</td>

            <td>

                @if ($transaction['type'] == 'Purchase')

                    <span class="badge bg-success">Purchase</span>

                @else

                    <span class="badge bg-danger">Sale</span>

                @endif

            </td>

            <td>{{ $transaction['quantity'] }}</td>

            <td>{{ $transaction['ref'] }}</td>

            <td>{{ $display_stock }}</td>

        </tr>

    @endforeach

</tbody>

</table>

            </div>

        </div>

    </div> --}}

<div class="container-fluid page-wrapper category-container">

    <div class="d-flex justify-content-between align-items-center mb-4">

        <h2 class="page-title">Stock Details for {{ $product->title ?? 'Product' }}</h2>

    </div>

    <div class="card shadow-sm">

        <div class="card-body">

            <table id="stock-details-table" class="table table-hover responsive nowrap" style="width:100%">

                <thead>

                    <tr>

                        <th>S.No</th>

                        <th>Date & Time</th>

                        <th>Transaction Type</th>

                        <th>Quantity</th>

                        <th>Invoice / Order</th>

                        <th>Closing Stock</th>

                    </tr>

                </thead>

               <tbody>

@php

    $sortedTransactions = collect($transactions ?? [])

        ->sortBy(fn($t) => \Carbon\Carbon::parse($t['date']))

        ->values();

    // ✅ STEP 1: Calculate history total

    $history_total = 0;

    foreach ($sortedTransactions as $t) {

        $qty = (int) ($t['quantity'] ?? 0);

        $type = $t['type'] ?? '';

        if (in_array($type, ['Purchase','Admin Add'])) {

            $history_total += $qty;

        } elseif (in_array($type, ['Sale','Admin Reduce'])) {

            $history_total -= $qty;

        }

    }

    // ✅ STEP 2: Hidden Offset (NOT DISPLAYED)

    $offset = ($product->stock ?? 0) - $history_total;

    // ✅ STEP 3: Start closing from offset

    $closing_stock = $offset;

    $stockHistory = [];

    foreach ($sortedTransactions as $t) {

        $qty = (int) ($t['quantity'] ?? 0);

        $type = $t['type'] ?? '';

        if (in_array($type, ['Purchase','Admin Add'])) {

            $closing_stock += $qty;

        } elseif (in_array($type, ['Sale','Admin Reduce'])) {

            $closing_stock -= $qty;

        }

        $stockHistory[] = [

            'date'          => $t['date'],

            'type'          => $type,

            'quantity'      => $qty,

            'ref'           => $t['ref'] ?? '-',

            'closing_stock' => $closing_stock,

        ];

    }

    // Latest first

    $stockHistory = collect($stockHistory)

        ->sortByDesc(fn($t) => \Carbon\Carbon::parse($t['date'])->timestamp)

        ->values();

@endphp

@foreach ($stockHistory as $transaction)

<tr>

    <td>{{ $loop->iteration }}</td>

    <td>{{ \Carbon\Carbon::parse($transaction['date'])->format('Y-m-d H:i:s') }}</td>

    <td>

        @if ($transaction['type'] == 'Purchase')

            <span class="badge bg-success">Purchase</span>

        @elseif ($transaction['type'] == 'Sale')

            <span class="badge bg-danger">Sale</span>

        @elseif ($transaction['type'] == 'Admin Add')

            <span class="badge bg-warning text-dark">Admin Add</span>

        @elseif ($transaction['type'] == 'Admin Reduce')

            <span class="badge bg-warning text-dark">Admin Reduce</span>

        @endif

    </td>

    <td>

        @if (in_array($transaction['type'], ['Purchase','Admin Add']))

            <span class="text-success">+{{ $transaction['quantity'] }}</span>

        @else

            <span class="text-danger">-{{ $transaction['quantity'] }}</span>

        @endif

    </td>

    <td>{{ $transaction['ref'] }}</td>

    <td>{{ $transaction['closing_stock'] }}</td>

</tr>

@endforeach

</tbody>

            </table>

        </div>

    </div>

</div>

@endsection

@section('footer')

    <script src="https://cdn.datatables.net/1.11.5/js/jquery.dataTables.min.js"></script>

    <script src="https://cdn.datatables.net/1.11.5/js/dataTables.bootstrap5.min.js"></script>

    <script src="https://cdn.datatables.net/responsive/2.2.9/js/dataTables.responsive.min.js"></script>

    <script src="https://cdn.datatables.net/responsive/2.2.9/js/responsive.bootstrap.min.js"></script>

    <script>

        $(document).ready(function() {

            $('#stock-details-table').DataTable({

                responsive: true,

                searching: false,

                paging: false,

                info: false

            });

        });

    </script>

@endsection