@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.ProductLedgerReport') }}
                </h1>
            </div>
        </div>
    </div>

    <!-- Product Information -->
    <div class="row table-row">
        <div class="col-12 col-sm-12 col-md-12 col-xl-12 col-lg-12">
            <table class="table table-bordered">
                @foreach ($table3Data as $data)
                    <tr style="line-height:5px;">
                        <td class="text-left"><strong>Date:</strong></td>
                        <td class="text-left">{{ $data['Date'] ? \Carbon\Carbon::parse($data['Date'])->format('d-F-Y') : 'N/A' }}</td>
                        <td class="text-left"><strong>Opening Balance:</strong></td>
                        <td class="text-left">{{ number_format($data['Opening Balance'], 2) }}</td>
                    </tr>
                    <tr style="line-height:5px;">
                        <td class="text-left"><strong>Item Code:</strong></td>
                        <td class="text-left">{{ $products[0]->ItemCode }}</td>
                        <td class="text-left"><strong>Item Name:</strong></td>
                        <td class="text-left">{{ $products[0]->ItemName }}</td>
                    </tr>
                    <tr style="line-height:5px;">
                        <td class="text-left"><strong>Product Bar Code:</strong></td>
                        <td class="text-left">{{ $data['ItemBarCode'] }}</td>
                        <td class="text-left"><strong>Item Sale Price:</strong></td>
                        <td class="text-left">{{ number_format($products[0]->ItemSalePrice, 2) }}</td>
                    </tr>
                    <tr style="line-height:5px;">
                        <td class="text-left"><strong>Purchase Price:</strong></td>
                        <td class="text-left">{{ number_format($products[0]->PurchasePrice, 2) }}</td>
                        <td class="text-left"><strong>Tax Value:</strong></td>
                        <td class="text-left">{{ number_format($data['TaxValue'], 2) }}</td>
                    </tr>
                    <tr style="line-height:5px;">
                        <td class="text-left"><strong>Item Category:</strong></td>
                        <td class="text-left">{{ $products[0]->ItemCategory }}</td>
                        <td class="text-left"><strong>Item Brand:</strong></td>
                        <td class="text-left">{{ $products[0]->ItemBrand }}</td>
                    </tr>
                @endforeach
            </table>
        </div>
    </div>

    <!-- Store and Rack Details -->
    <div class="col-12">
        <table class="table table-bordered table-striped table-responsive">
            <thead>
                <tr>
                    <th class="text-center" style="width:5%; background-color: #0C133A; color: white">Sr#</th>
                    <th style="background-color: #0C133A; color: white">Store Code</th>
                    <th style="background-color: #0C133A; color: white">Store Name</th>
                    <th style="background-color: #0C133A; color: white">Rack No</th>
                    <th style="background-color: #0C133A; color: white">Location</th>
                </tr>
            </thead>
            <tbody>
                @foreach ($table1Data as $row)
                    <tr>
                        <td class="text-center">{{ $row['Sr#'] }}</td>
                        <td>{{ $row['Store Code'] }}</td>
                        <td>{{ $row['Store Name'] }}</td>
                        <td>{{ $row['Rack No'] }}</td>
                        <td>{{ $row['Location'] }}</td>
                    </tr>
                @endforeach
            </tbody>
        </table>
    </div>

    <!-- Transaction Details -->
    <div class="col-12">
        <table class="table table-bordered table-striped table-responsive">
            <thead>
                <tr>
                    <th class="text-center" style="width:5%; background-color: #0C133A; color: white">Sr#</th>
                    <th class="text-right" style="background-color: #0C133A; color: white">GRN Qty</th>
                    <th class="text-right" style="background-color: #0C133A; color: white">Adjustment Qty</th>
                    <th class="text-right" style="background-color: #0C133A; color: white">Issue Qty</th>
                    <th class="text-right" style="background-color: #0C133A; color: white">Sale Qty</th>
                    <th class="text-right" style="background-color: #0C133A; color: white">Return Sale Qty</th>
                    <th class="text-right" style="background-color: #0C133A; color: white">Balance</th>
                </tr>
            </thead>
            <tbody> 
                @foreach ($table2Data as $row)
                                        <tr>
                        <td class="text-center">{{ $row['Sr#'] }}</td>
                        <td class="text-right">{{ number_format($row['GRN Qty'], 2) }}</td>
                        <td class="text-right">{{ number_format($row['Adjustment Qty'], 2) }}</td>
                        <td class="text-right">{{ number_format($row['Issue Qty'], 2) }}</td>
                        <td class="text-right">{{ number_format($row['Sale Qty'], 2) }}</td>
                        <td class="text-right">{{ number_format($row['Return Sale Qty'], 2) }}</td>
                        <td class="text-right">{{ number_format($row['Balance'], 2) }}</td>
                    </tr>
                @endforeach
            </tbody>
            <tfoot>
                <tr>
                    <td colspan="6" style="text-align: right"><strong>Total Balance</strong></td>
                    <td style="text-align: right"><strong>{{ number_format($gTotalBalance, 2) }}</strong></td>
                </tr>
            </tfoot>
        </table>
    </div>

    <!-- Closing Balance and Stock Value -->
    <div class="col-12 d-flex justify-content-end">
        <div class="col-6 ml-auto" style="max-width: 50%;">
            <table class="table table-bordered table-responsive">
                <tbody>
                    @foreach ($table3Data as $row)
                        <tr>
                            <td><strong>Closing Balance</strong></td>
                            <td class="text-right">{{ number_format($row['Closing Balance'], 2) }}</td>
                        </tr>
                        <tr>
                            <td><strong>Purchase Price</strong></td>
                            <td class="text-right">{{ number_format($row['Purchase Price'], 2) }}</td>
                        </tr>
                        <tr>
                            <td><strong>Stock Value</strong></td>
                            <td class="text-right">{{ number_format($row['Stock Value'], 2) }}</td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    </div>

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