@extends('layout.app')

@section('title', 'Stock Item Report')

@push('header_script')
<link rel="stylesheet" href="{{ asset('theme/assets/vendor/daterange/daterange.css') }}">
<style>
    .tally-table {
        border-collapse: collapse;
        width: 100%;
        font-family: 'Courier New', monospace;
        font-size: 13px;
        color: #000;
        border: 1px solid #4472C4;
    }

    .tally-table thead th {
        background: #36506b !important;
        color: #fff !important;
        font-weight: bold;
        text-align: center;
        padding: 5px 6px;
        border: 1px solid #4472C4 !important;
        vertical-align: middle;
    }

    .tally-table tbody td {
        padding: 4px 6px;
        vertical-align: middle;
        border: 1px solid #c8d4ee !important;
    }

    .tally-table tbody tr:hover td {
        background: #E6EEF9 !important;
    }

    .tally-total-row td {
        background: #B4C6E7 !important;
        font-weight: bold;
        font-size: 14px;
        border-top: 2px solid #4472C4 !important;
    }

    .tally-title {
        text-align: center;
        font-size: 18px;
        font-weight: bold;
        padding: 10px 0 4px;
        color: #1a3a8f;
        border-bottom: 2px solid #4472C4;
        margin-bottom: 8px;
        font-family: Arial, sans-serif;
    }

    .tally-subtitle {
        text-align: center;
        font-size: 13px;
        color: #555;
        margin-bottom: 15px;
        font-family: Arial, sans-serif;
    }

    .tally-link {
        color: #1a3a8f;
        text-decoration: none;
    }

    .tally-link:hover {
        text-decoration: underline;
        color: #0056b3;
    }
</style>
@endpush

@section('content')
<div class="app-hero-header d-flex align-items-center">
    <ol class="breadcrumb mb-0">
        <li class="breadcrumb-item">
            <a href="{{ route('stock-valuation.index') }}">Stock Summary</a>
        </li>
        <li class="breadcrumb-item active" aria-current="page">Stock Item Report</li>
    </ol>
</div>

<div class="app-body">
    {{-- FILTER FORM --}}
    <form action="{{ route('stock-item-ledger.index') }}" method="GET" class="card p-3 mb-3" id="ledgerFilterForm">
        <div class="row gx-3 align-items-end">
            <div class="col-md-4">
                <label class="form-label" for="product_id">Select Stock Item</label>
                <select name="product_id" id="product_id" class="form-select">
                    <option value="">-- All Items (Summary) --</option>
                    @foreach($products as $p)
                        <option value="{{ $p->id }}" {{ $selectedProductId == $p->id ? 'selected' : '' }}>
                            {{ $p->product_name }}
                        </option>
                    @endforeach
                </select>
            </div>
            <div class="col-md-4">
                <label class="form-label" for="from_date">From Date</label>
                <input type="text" id="from_date" name="from_date" class="form-control datepicker" value="{{ date('d-m-Y', strtotime($fromDate)) }}">
            </div>
            <div class="col-md-4">
                <label class="form-label" for="to_date">To Date</label>
                <input type="text" id="to_date" name="to_date" class="form-control datepicker" value="{{ date('d-m-Y', strtotime($toDate)) }}">
            </div>
        </div>
    </form>

    @if($product)
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-body">
                    <div class="tally-title">Stock Item Register</div>
                    <div class="tally-subtitle" style="font-weight: bold; font-size:15px; color:#000;">
                        {{ $product->product_name }}
                    </div>
                    <div class="tally-subtitle">
                        Period: {{ date('d-M-Y', strtotime($fromDate)) }} to {{ date('d-M-Y', strtotime($toDate)) }}
                    </div>

                    <table class="tally-table">
                        <thead>
                            <tr>
                                <th rowspan="2" style="text-align: left; vertical-align: middle;">Date</th>
                                <th rowspan="2" style="text-align: left; vertical-align: middle;">Particulars</th>
                                <th rowspan="2" style="text-align: center; vertical-align: middle;">Vch Type</th>
                                <th rowspan="2" style="text-align: center; vertical-align: middle;">Vch No.</th>
                                <th colspan="4" style="text-align: center;">Inwards</th>
                                <th colspan="4" style="text-align: center;">Outwards</th>
                                <th colspan="4" style="text-align: center;">Closing</th>
                            </tr>
                            <tr>
                                <th style="text-align: right;">Quantity</th>
                                <th style="text-align: center;">Unit</th>
                                <th style="text-align: right;">Rate</th>
                                <th style="text-align: right;">Value</th>
                                <th style="text-align: right;">Quantity</th>
                                <th style="text-align: center;">Unit</th>
                                <th style="text-align: right;">Rate</th>
                                <th style="text-align: right;">Value</th>
                                <th style="text-align: right;">Quantity</th>
                                <th style="text-align: center;">Unit</th>
                                <th style="text-align: right;">Rate</th>
                                <th style="text-align: right;">Value</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php 
                                $totalInQty = 0;
                                $totalInValue = 0;
                                $totalOutQty = 0;
                                $totalOutValue = 0;
                                $lastRow = null;
                            @endphp

                            @forelse($ledgerData as $row)
                                @php
                                    $totalInQty += $row['inward_qty'] ?? 0;
                                    $totalInValue += $row['inward_value'] ?? 0;
                                    $totalOutQty += $row['outward_qty'] ?? 0;
                                    $totalOutValue += $row['outward_value'] ?? 0;
                                    $lastRow = $row;
                                @endphp
                                <tr>
                                    <td>{{ $row['date'] ? date('d-M-y', strtotime($row['date'])) : '' }}</td>
                                    <td>
                                        @if($row['voucher_type'] == 'Purchase' && $row['voucher_id'])
                                            <a href="{{ route('purchase-voucher.show', $row['voucher_id']) }}" class="tally-link" target="_blank">
                                                {{ $row['particulars'] }}
                                            </a>
                                        @elseif($row['voucher_type'] == 'Sale' && $row['voucher_id'])
                                            <a href="{{ route('sale-voucher.show', $row['voucher_id']) }}" class="tally-link" target="_blank">
                                                {{ $row['particulars'] }}
                                            </a>
                                        @else
                                            {{ $row['particulars'] }}
                                        @endif
                                    </td>
                                    <td class="text-center">{{ $row['voucher_type'] ?? '' }}</td>
                                    <td class="text-center">{{ $row['voucher_no'] ?? '' }}</td>
                                    
                                    {{-- Inwards --}}
                                    <td class="text-end">{{ $row['inward_qty'] ? number_format($row['inward_qty'], 2) : '' }}</td>
                                    <td class="text-center">{{ $row['inward_qty'] ? $product->units : '' }}</td>
                                    <td class="text-end">{{ $row['inward_rate'] ? number_format($row['inward_rate'], 2) : '' }}</td>
                                    <td class="text-end" style="font-weight: bold;">{{ $row['inward_value'] ? number_format($row['inward_value'], 2) : '' }}</td>
                                    
                                    {{-- Outwards --}}
                                    <td class="text-end">{{ $row['outward_qty'] ? number_format($row['outward_qty'], 2) : '' }}</td>
                                    <td class="text-center">{{ $row['outward_qty'] ? $product->units : '' }}</td>
                                    <td class="text-end">{{ $row['outward_rate'] ? number_format($row['outward_rate'], 2) : '' }}</td>
                                    <td class="text-end" style="font-weight: bold;">{{ $row['outward_value'] ? number_format($row['outward_value'], 2) : '' }}</td>
                                    
                                    {{-- Balance --}}
                                    <td class="text-end">{{ number_format($row['closing_qty'], 2) }}</td>
                                    <td class="text-center">{{ $product->units }}</td>
                                    @php
                                        $closingRate = $row['closing_qty'] > 0 ? $row['closing_value'] / $row['closing_qty'] : 0;
                                    @endphp
                                    <td class="text-end">{{ $closingRate > 0 ? number_format($closingRate, 2) : '' }}</td>
                                    <td class="text-end" style="font-weight: bold;">{{ number_format($row['closing_value'], 2) }}</td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="16" class="text-center">No transactions found for this period.</td>
                                </tr>
                            @endforelse
                        </tbody>
                        <tfoot>
                            <tr class="tally-total-row">
                                <td colspan="4" style="text-align: right;">Totals:</td>
                                <td class="text-end">{{ $totalInQty > 0 ? number_format($totalInQty, 2) : '' }}</td>
                                <td class="text-center"></td>
                                <td class="text-end">{{ $totalInQty > 0 ? number_format($totalInValue / $totalInQty, 2) : '' }}</td>
                                <td class="text-end">{{ $totalInValue > 0 ? number_format($totalInValue, 2) : '' }}</td>
                                
                                <td class="text-end">{{ $totalOutQty > 0 ? number_format($totalOutQty, 2) : '' }}</td>
                                <td class="text-center"></td>
                                <td class="text-end">{{ $totalOutQty > 0 ? number_format($totalOutValue / $totalOutQty, 2) : '' }}</td>
                                <td class="text-end">{{ $totalOutValue > 0 ? number_format($totalOutValue, 2) : '' }}</td>
                                
                                <td class="text-end">{{ $lastRow ? number_format($lastRow['closing_qty'], 2) : '' }}</td>
                                <td class="text-center"></td>
                                @php
                                    $finalRate = ($lastRow && $lastRow['closing_qty'] != 0) ? $lastRow['closing_value'] / $lastRow['closing_qty'] : 0;
                                @endphp
                                <td class="text-end">{{ $finalRate > 0 ? number_format($finalRate, 2) : '' }}</td>
                                <td class="text-end">{{ $lastRow ? number_format($lastRow['closing_value'], 2) : '' }}</td>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            </div>
        </div>
    </div>
    @else
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-body">
                    <div class="tally-title">Stock Item Summary</div>
                    <div class="tally-subtitle">
                        Period: {{ date('d-M-Y', strtotime($fromDate)) }} to {{ date('d-M-Y', strtotime($toDate)) }}
                    </div>

                    <table class="tally-table">
                        <thead>
                            <tr>
                                <th style="width: 50px;">Sr. No.</th>
                                <th style="text-align: left;">Item Name</th>
                                <th>Unit</th>
                                <th style="text-align: right;">Opening Qty</th>
                                <th style="text-align: right;">Opening Value</th>
                                <th style="text-align: right;">Inward Qty</th>
                                <th style="text-align: right;">Inward Value</th>
                                <th style="text-align: right;">Outward Qty</th>
                                <th style="text-align: right;">Outward Value</th>
                                <th style="text-align: right;">Closing Qty</th>
                                <th style="text-align: right;">Closing Value</th>
                                <th style="width: 80px;">Action</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php
                                $totalOpQty = 0;
                                $totalOpVal = 0;
                                $totalInQtySum = 0;
                                $totalInValSum = 0;
                                $totalOutQtySum = 0;
                                $totalOutValSum = 0;
                                $totalClQtySum = 0;
                                $totalClValSum = 0;
                            @endphp
                            @forelse($summaryData as $index => $row)
                                @php
                                    $totalOpQty += $row['opening_qty'];
                                    $totalOpVal += $row['opening_value'];
                                    $totalInQtySum += $row['inward_qty'];
                                    $totalInValSum += $row['inward_value'];
                                    $totalOutQtySum += $row['outward_qty'];
                                    $totalOutValSum += $row['outward_value'];
                                    $totalClQtySum += $row['closing_qty'];
                                    $totalClValSum += $row['closing_value'];

                                    $drilldownUrl = route('stock-item-ledger.index') . '?product_id=' . $row['product_id'] . '&from_date=' . date('d-m-Y', strtotime($fromDate)) . '&to_date=' . date('d-m-Y', strtotime($toDate));
                                @endphp
                                <tr style="cursor: pointer;" onclick="window.location.href='{{ $drilldownUrl }}'">
                                    <td class="text-center">{{ $index + 1 }}</td>
                                    <td>
                                        <a href="{{ $drilldownUrl }}" class="tally-link" onclick="event.stopPropagation();">
                                            {{ $row['product_name'] }}
                                        </a>
                                    </td>
                                    <td class="text-center">{{ $row['units'] }}</td>
                                    <td class="text-end">{{ number_format($row['opening_qty'], 2) }}</td>
                                    <td class="text-end" style="font-weight: bold;">{{ number_format($row['opening_value'], 2) }}</td>
                                    <td class="text-end">{{ number_format($row['inward_qty'], 2) }}</td>
                                    <td class="text-end" style="font-weight: bold;">{{ number_format($row['inward_value'], 2) }}</td>
                                    <td class="text-end">{{ number_format($row['outward_qty'], 2) }}</td>
                                    <td class="text-end" style="font-weight: bold;">{{ number_format($row['outward_value'], 2) }}</td>
                                    <td class="text-end">{{ number_format($row['closing_qty'], 2) }}</td>
                                    <td class="text-end" style="font-weight: bold;">{{ number_format($row['closing_value'], 2) }}</td>
                                    <td class="text-center">
                                        <a href="{{ $drilldownUrl }}" class="btn btn-sm btn-primary py-0 px-2" style="font-size: 11px;" onclick="event.stopPropagation();">
                                            Next <i class="fa fa-chevron-right" style="font-size: 8px;"></i>
                                        </a>
                                    </td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="12" class="text-center">No items found.</td>
                                </tr>
                            @endforelse
                        </tbody>
                        <tfoot>
                            <tr class="tally-total-row">
                                <td colspan="3">Total:</td>
                                <td class="text-end">{{ number_format($totalOpQty, 2) }}</td>
                                <td class="text-end">{{ number_format($totalOpVal, 2) }}</td>
                                <td class="text-end">{{ number_format($totalInQtySum, 2) }}</td>
                                <td class="text-end">{{ number_format($totalInValSum, 2) }}</td>
                                <td class="text-end">{{ number_format($totalOutQtySum, 2) }}</td>
                                <td class="text-end">{{ number_format($totalOutValSum, 2) }}</td>
                                <td class="text-end">{{ number_format($totalClQtySum, 2) }}</td>
                                <td class="text-end">{{ number_format($totalClValSum, 2) }}</td>
                                <td></td>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            </div>
        </div>
    </div>
    @endif
</div>
@endsection

@push('footer_script')
<script src="{{ asset('theme/assets/vendor/daterange/daterange.js') }}"></script>
<script>
    $(document).ready(function() {
        $('#from_date, #to_date').daterangepicker({
            singleDatePicker: true,
            autoUpdateInput: true,
            locale: {
                format: 'DD-MM-YYYY'
            }
        });

        // Auto-submit when select product changes
        $('#product_id').on('change', function() {
            $('#ledgerFilterForm').submit();
        });

        // Auto-submit when date range picker is applied
        $('#from_date, #to_date').on('apply.daterangepicker', function(ev, picker) {
            $(this).val(picker.startDate.format('DD-MM-YYYY'));
            $('#ledgerFilterForm').submit();
        });
    });
</script>
@endpush