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

    <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>{{ __('sitelabel.ItemCode') }}</strong></td>
                        <td class="text-left">{{ $products[0]->ItemCode }}</td>
                        <td class="text-left"><strong>{{ __('sitelabel.ItemName') }}</strong></td>
                        <td class="text-left">{{ $products[0]->ItemName }}</td>
                    </tr>
                    <tr style="line-height:5px;">
                        <td class="text-left"><strong>{{ __('sitelabel.BarCode') }}</strong></td>
                        <td class="text-left">{{ $data['ItemBarCode'] }}</td>
                        <td class="text-left"><strong>{{ __('sitelabel.SalePrice') }}</strong></td>
                        <td class="text-left">{{ number_format($products[0]->ItemSalePrice, 2) }}</td>
                    </tr>
                    <tr style="line-height:5px;">
                        <td class="text-left"><strong>{{ __('sitelabel.PurchasePrice') }}</strong></td>
                        <td class="text-left">{{ number_format($products[0]->PurchasePrice, 2) }}</td>
                        <td class="text-left"><strong>{{ __('sitelabel.TaxValue') }}</strong></td>
                        <td class="text-left">{{ number_format($data['TaxValue'], 2) }}</td>
                    </tr>
                    <tr style="line-height:5px;">
                        <td class="text-left"><strong>{{ __('sitelabel.Category') }}</strong></td>
                        <td class="text-left">{{ $products[0]->ItemCategory }}</td>
                        <td class="text-left"><strong>{{ __('sitelabel.Brand') }}</strong></td>
                        <td class="text-left">{{ $products[0]->ItemBrand }}</td>
                    </tr>
                @endforeach
            </table>
        </div>
    </div>

    <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">
                        {{ __('sitelabel.SerialNumber') }}</th>
                    <th style="background-color: #0C133A; color: white">{{ __('sitelabel.StoreCode') }}</th>
                    <th style="background-color: #0C133A; color: white">{{ __('sitelabel.StoreName') }}</th>
                    <th style="background-color: #0C133A; color: white">{{ __('sitelabel.RackNo') }}</th>
                    <th style="background-color: #0C133A; color: white">{{ __('sitelabel.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>

    <div class="col-12">
        <table class="table table-bordered table-striped table-responsive">
            <thead>
                <tr>
                    <th style="background-color: #0C133A; color: white">
                        {{ __('sitelabel.TransactionType') }}</th>
                    <th style="background-color: #0C133A; color: white">{{ __('sitelabel.Contact') }}</th>
                    <th class="text-right" style="background-color: #0C133A; color: white">{{ __('sitelabel.Debit') }}</th>
                    <th class="text-right" style="background-color: #0C133A; color: white">{{ __('sitelabel.Credit') }}</th>
                    <th class="text-right" style="background-color: #0C133A; color: white">{{ __('sitelabel.Balance') }}</th>
                    <th style="background-color: #0C133A; color: white">{{ __('sitelabel.Date') }}</th>
                </tr>
            </thead>
            <tbody>
                @foreach ($table2Data as $row)
                    <tr>
                        @php
                            $runningBalance = $runningBalance + $row['Debit'] - $row['Credit'];
                        @endphp
                        <td>{{ $row['Tr_type'] }}</td>
                        <td>{{ $row['Contact'] }}</td>
                        <td class="text-right">{{ number_format($row['Debit'], 2) }}</td>
                        <td class="text-right">{{ number_format($row['Credit'], 2) }}</td>
                        <td class="text-right">{{ number_format($runningBalance, 2) }}</td>
                        <td>{{ $row['Date'] }}</td>
                    </tr>
                @endforeach
            </tbody>
        </table>
    </div>

    <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>{{ __('sitelabel.ClosingBalance') }}</strong></td>
                            <td class="text-right">{{ number_format($row['Closing Balance'], 2) }}</td>
                        </tr>
                        <tr>
                            <td><strong>{{ __('sitelabel.PurchasePrice') }}</strong></td>
                            <td class="text-right">{{ number_format($row['Purchase Price'], 2) }}</td>
                        </tr>
                        <tr>
                            <td><strong>{{ __('sitelabel.StockValue') }}</strong></td>
                            <td class="text-right">{{ number_format($row['Stock Value'], 2) }}</td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    </div>

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