@extends('printlayout')
@section('content')
    <div class="row invoice-box">
        <div class="col-lg-12 col-md-12 col-xs-12 col-sm-12">
            <div class="col-lg-12 col-md-12 col-xs-12 col-sm-12 text-center">
                <h1 style="font-size:26px;">
                    {{ __('sitelabel.StockReport') }} Of {{ $currentYear->YearNo }}
                </h1>
            </div>
        </div>
    </div>

    <div class="col-12">
        <table class="table table-bordered table-striped table-responsive">
            <thead>
                <tr>
                    <th style="background-color: #0C133A; color: white">{{ __('sitelabel.SerialNumber') }}</th>
                    <th style="background-color: #0C133A; color: white">{{ __('sitelabel.ItemCode') }}</th>
                    <th style="background-color: #0C133A; color: white">{{ __('sitelabel.Description') }}</th>
                    <th class="text-right" style="background-color: #0C133A; color: white">{{ __('sitelabel.OpenStock') }}</th>
                    <th class="text-right" style="background-color: #0C133A; color: white">{{ __('sitelabel.Purchase') }}</th>
                    <th class="text-right" style="background-color: #0C133A; color: white">{{ __('sitelabel.Sales') }}</th>
                    <th class="text-right" style="background-color: #0C133A; color: white">{{ __('sitelabel.ReturnSales') }}</th>
                    <th class="text-right" style="background-color: #0C133A; color: white">{{ __('sitelabel.Adjustment') }}</th>
                    <th class="text-right" style="background-color: #0C133A; color: white">{{ __('sitelabel.Balance') }}</th>
                    <th class="text-right" style="background-color: #0C133A; color: white">{{ __('sitelabel.Booked') }}</th>
                </tr>
            </thead>
            <tbody>
                @foreach ($reportData as $index => $row)
                    <tr>
                        @php
        $gTotalOpeningBalance += $row['OpeningBalance'];
        $gTotalPurchases += $row['Purchases'];
        $gTotalSales += $row['Sales'];
        $gTotalReturnSales += $row['ReturnSales'];
        $gTotalAdjustment += $row['Adjustment'];
        $gTotalBalance += $row['Balance'];
        $gTotalBooked += $row['Booked'];
    @endphp
                        <td>{{ $index + 1 }}</td>
                        <td>{{ $row['ItemCode'] }}</td>
                        <td>{{ $row['Description'] }}</td>
                        <td class="text-right">{{ number_format($row['OpeningBalance'], 2) }}</td>
                        <td class="text-right">{{ number_format($row['Purchases'], 2) }}</td>
                        <td class="text-right">{{ number_format($row['Sales'], 2) }}</td>
                        <td class="text-right">{{ number_format($row['ReturnSales'], 2) }}</td>
                        <td class="text-right">{{ number_format($row['Adjustment'], 2) }}</td>
                        <td class="text-right">{{ number_format($row['Balance'], 2) }}</td>
                        <td class="text-right">{{ number_format($row['Booked'], 2) }}</td>
                    </tr>
                @endforeach
                <tr style="font-weight: bold; background-color: #f2f2f2;">
                    <td colspan="3" class="text-right">Grand Total:</td>
                    <td class="text-right">{{ number_format($gTotalOpeningBalance, 2) }}</td>
                    <td class="text-right">{{ number_format($gTotalPurchases, 2) }}</td>
                    <td class="text-right">{{ number_format($gTotalSales, 2) }}</td>
                    <td class="text-right">{{ number_format($gTotalReturnSales, 2) }}</td>
                    <td class="text-right">{{ number_format($gTotalAdjustment, 2) }}</td>
                    <td class="text-right">{{ number_format($gTotalBalance, 2) }}</td>
                    <td class="text-right">{{ number_format($gTotalBooked, 2) }}</td>
                </tr>
            </tbody>
        </table>
    </div>

    @include('sign-subview.signandbuttons')
@endsection