| Sr No |
Varient Name |
Roll No |
InwardQty |
UoM |
CP |
%GST |
GST amt |
Amount |
@php
$grand_total_qty = 0;
$grand_total_amount = 0;
$serial = 1;
@endphp
@foreach($inward_data as $company_name => $suppliers)
| {{ $company_name }} |
@foreach($suppliers as $supplier_data)
@php
$inward_total_qty = 0;
$inward_total_amount = 0;
@endphp
| Supplier Invoice No: {{ $supplier_data['supplier_id'] ?? 'N/A' }} |
Inward Date: {{ date('d-m-Y',strtotime($supplier_data['inward_date'])) }} |
|
Place |
{{ $supplier_data['warehouse'] ?? 'N/A' }} |
@foreach($supplier_data['purchase_orders'] as $po_id => $purchase_order)
@foreach($purchase_order['items'] as $item)
@php
$total_type_qty = 0;
$total_type_amount = 0;
@endphp
| TYPE {{ strtoupper($item['product_name'] ?? '-') }} |
@foreach($item['purchase_order_items'] as $po_item)
@php
$gst_amt = ($po_item->gst_percent * $po_item->rate) / 100;
$amount = ($po_item->rate * $po_item->no_of_rolls) + ($gst_amt);
@endphp
@foreach($po_item->rolls as $roll)
@php
// ✅ Add for each roll
$total_type_qty += $po_item->quantity;
$total_type_amount += $amount;
$inward_total_qty += $po_item->quantity;
$inward_total_amount += $amount;
$grand_total_qty += $po_item->quantity;
$grand_total_amount += $amount;
@endphp
| {{ $serial++ }} |
{{ $po_item->varient_code }}-{{ $po_item->varient_name }} |
{{ $roll->roll_no }} |
{{ number_format($po_item->quantity, 2) }} |
{{ $po_item->unit_name }} |
{{ $po_item->rate }} |
{{ $po_item->gst_percent }} |
{{ number_format($gst_amt, 2) }} |
{{ number_format($amount, 2) }} |
@endforeach
@endforeach
| Total Type Qty |
{{ number_format($total_type_qty, 2) }} |
Total Type Amount |
{{ number_format($total_type_amount, 2) }} |
@endforeach
@endforeach
{{-- ✅ Inward total row --}}
@endforeach
@endforeach
| Grand Total |
{{ number_format($grand_total_qty, 2) }} |
|
{{ number_format($grand_total_amount, 2) }} |