@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 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();



    $stockHistory = [];

    $closing_stock = 0;

    $started = false; // ✅ track start point



    foreach ($sortedTransactions as $t) {

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

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



        // ✅ Skip invalid starting sales

        if (!$started) {

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

                $started = true;

                $closing_stock += $qty;

            } else {

                continue; // ❌ skip early sales

            }

        } else {

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

                $closing_stock += $qty;

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

                $closing_stock -= $qty;

            }

        }



        $closing_stock = max(0, $closing_stock);



        $stockHistory[] = [

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

            'type'          => $type,

            'quantity'      => $qty,

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

            'closing_stock' => $closing_stock,

        ];

    }



    $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://code.jquery.com/jquery-3.6.0.min.js"></script>

<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


{{-- 

<tbody> @php $sortedTransactions = $transactions ?? collect(); $calculated_stock_from_history = 0; $stockHistory = []; // STEP 1: Calculate total stock from history foreach ($sortedTransactions as $t) { $qty = (int) $t['quantity']; if ($t['type'] === 'Purchase' || $t['type'] === 'Admin Add') { $calculated_stock_from_history += $qty; } elseif ($t['type'] === 'Sale' || $t['type'] === 'Admin Reduce') { $calculated_stock_from_history -= $qty; } } // STEP 2: Offset (Old Stock logic) $initial_stock_offset = $product->stock - $calculated_stock_from_history; $closing_stock = $initial_stock_offset; // STEP 3: Add Old Stock entry if ($initial_stock_offset > 0) { $firstTransactionDate = $sortedTransactions->first() ? \Carbon\Carbon::parse($sortedTransactions->first()['date'])->subSecond() : now(); $stockHistory[] = [ 'date' => $firstTransactionDate->format('Y-m-d H:i:s'), 'type' => 'Initial Stock', 'quantity' => $initial_stock_offset, 'ref' => 'Old Stock', // ✅ changed here 'closing_stock' => $initial_stock_offset, ]; } // STEP 4: Process all transactions foreach ($sortedTransactions as $t) { $qty = (int) $t['quantity']; if ($t['type'] === 'Purchase' || $t['type'] === 'Admin Add') { $closing_stock += $qty; } elseif ($t['type'] === 'Sale' || $t['type'] === 'Admin Reduce') { $closing_stock -= $qty; } $closing_stock = max(0, $closing_stock); $stockHistory[] = array_merge($t, [ 'closing_stock' => $closing_stock, ]); } // STEP 5: Sort 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> @elseif ($transaction['type'] == 'Initial Stock') <span class="badge bg-primary">Initial Stock</span> @endif </td> <td> @if (in_array($transaction['type'], ['Purchase','Admin Add','Initial Stock'])) <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> --}}