@extends('report.pdf.layouts.app')
@section('pdf_content')
    <table width="100%">
        <tr>
            <td colspan="3" class="text-center">
                <span style="font-size: 16px;"><b>Opening Stock Report</b></span> <br>
                <span style="font-size: 12px;">Branch: {{ $branch->branch_name }}</span> <br>
                <span style="font-size: 12px;">Address: {{ $branch->address }}</span> <br>
            </td>
        </tr>
    </table>
    <div style="margin-top:30px;">
        <table class="table table-border" style="width: 100%;" id="purchase_table">
            <thead>
                <tr>
                    <th class="text-center table-border">Sl</th>
                    <th class="text-center table-border">Code</th>
                    <th class="text-center table-border">Product</th>
                    <th class="text-center table-border">Quanity</th>
                    <th class="text-center table-border">TP</th>
                    <th class="text-center table-border">Total TP</th>
                    <th class="text-center table-border">MRP</th>
                    <th class="text-center table-border">Total MRP</th>

                </tr>
            </thead>
            <tbody>
                @php
                    $netqty = 0;
                    $netmrp = 0;
                    $nettp = 0;
                @endphp
                @foreach ($items as $key => $item)
                    @php
                        $netqty += $item->opening_stock;
                        $total_tp = $item->purchase_price * $item->opening_stock;
                        $nettp += $total_tp;
                        $total_mrp = $item->sale_price * $item->opening_stock;
                        $netmrp += $total_mrp;
                    @endphp
                    <tr>
                        <td class="sl table-border">{{ $key + 1 }}</td>
                        <td class="table-border">{{ $item->product_code }}</td> <!-- Access product name here -->
                        <td class="table-border">{{ $item->name }}</td> <!-- Access product name here -->
                        <td class="text-end table-border">
                            {{ DecimalFormat($item->opening_stock) }}
                        </td>

                        <td class="text-end table-border">
                            {{ DecimalFormat($item->purchase_price) }}
                        </td> <!-- Access unit price here -->
                        <td class="text-end table-border">
                            {{ DecimalFormat($total_tp) }}
                        </td>
                        <td class="text-end table-border">
                            {{ DecimalFormat($item->sale_price) }}
                        </td>
                        <td class="text-end table-border">
                            {{ DecimalFormat($total_mrp) }}
                        </td>
                    </tr>
                @endforeach
            </tbody>
            <tfoot>
                <tr>
                    <td class="text-end table-border" colspan="3">Total</td>
                    <td class="text-end table-border">{{ DecimalFormat($netqty) }}</td>
                    <td class="text-end table-border"></td>
                    <td class="text-end table-border">{{ DecimalFormat($nettp) }}</td>
                    <td class="text-end table-border"></td>
                    <td class="text-end table-border">{{ DecimalFormat($netmrp) }}</td>
                </tr>
            </tfoot>
        </table>
    </div>
@endsection