@foreach($transfers as $index => $transfer) @php $buying_price = round($transfer->buying_price * $transfer->punit->base_quantity,2); @endphp @endforeach

INTERNAL STOCK TRANSFER REPORT ({{ \Carbon\Carbon::parse($dateFrom)->format('M d, Y') }} - {{ \Carbon\Carbon::parse($dateTo)->format('M d, Y') }})
S/N	PRODUCT	SOURCE	DESTINATION	QUANTITY TRANSFERRED	UNIT	UNIT PRICE	STOCK VALUE	TRANSFERRED ON	TRANSFERRED BY
{{ $index + 1 }}	{{ $transfer->product->product_name }}	{{ $transfer->transfer->source == 0 ? "Shop" : ($transfer->transfer->source == 1 ? "Store" :$transfer->storeitem->store->name) }}	{{ $transfer->transfer->destination == 0 ? "Shop" : ($transfer->transfer->destination == 1 ? "Store" : $transfer->storeitem->store->name) }}	{{ $transfer->quantity_sent ?? 0 }}	{{ $transfer->punit->unit->symbol }}	{{ number_format($buying_price) }}	{{ number_format($buying_price * ($transfer->quantity_sent ?? 0)) }}	{{ $transfer->transfer->sentOn ?? 'N/A' }}	{{ $transfer->user->name ?? 'N/A' }}
Total Stock Value: {{ number_format($totalStockValue) }}