{{ $return->company->company_address ?? '' }}, {{ $return->company->area->area_name ?? '' }}, {{ $return->company->city->city_name ?? '' }}, {{ $return->company->state->state_name ?? '' }}, {{ $return->company->country->country_name ?? '' }}, {{ $return->company->company_pincode ?? '' }}

GST No: {{ $return->company->company_gstin ?? '' }}, Email: {{ $return->company->company_email ?? '' }}, Phone No: {{ $return->company->company_phone_no_1 ?? '' }}

TOOLS RETURN

From,

{{ $return->customer_address->customer_address ?? 'Vendor Address' }}, {{ $return->customer_address->customer_pincode ?? 'Vendor Pincode' }}, {{ $return->customer_address->area->area_name ?? 'Vendor Area' }}, {{ $return->customer_address->city->city_name ?? 'Vendor City' }}, {{ $return->customer_address->state->state_name ?? 'Vendor State' }}, {{ $return->customer_address->country->country_name ?? 'Vendor Country' }},

Request No	{{ $return->materialIssue->materialRequest->material_request_prefix }}/{{ $return->materialIssue->materialRequest->material_request_financial_year }}/{{ $return->materialIssue->materialRequest->material_request_number }}
Issue No	{{ $return->materialIssue->material_issue_prefix }}/{{ $return->materialIssue->material_issue_financial_year }}/{{ $return->materialIssue->material_issue_number }}
Return No	{{ $return->material_return_prefix }}/{{ $return->material_return_financial_year }}/{{ $return->material_return_number }}
Return Date	{{ \Carbon\Carbon::parse($return->material_return_date)->format('d/m/Y') ?? '' }}
Return Person	{{ $return->employee->employee_first_name ?? '' }} {{ $return->employee->employee_last_name ?? '' }}

@php // Group items by their product category and include sort order $groupedItems = $return->items->groupBy(function($item) { return $item->products->product_categories->product_category_name ?? 'Uncategorized'; }); // Prepare a sortable array with category names and sort orders $categoriesWithSortOrder = $groupedItems->map(function ($items, $categoryName) { $sortOrder = $items->first()->products->product_categories->product_category_sort_order ?? 0; return [ 'category_name' => $categoryName, 'sort_order' => $sortOrder, 'items' => $items ]; })->sortBy('sort_order'); @endphp @foreach ($categoriesWithSortOrder as $category)

{{-- --}} {{-- --}} {{-- --}} @foreach ($category['items'] as $index => $item) {{-- --}} {{-- --}} {{-- --}} @endforeach

Sr No	Item	Model No	Size	HSN Code	Description	Issued Qty	Return Qty	Stock Qty	UOM
{{ $index + 1 }}	{{ $item->products->product_name ?? '' }}	{{ $item->products->product_model_no ?? '' }}	{{ $item->products->product_size ?? '' }}	{{ $item->products->product_hsn_code ?? '' }}	{{ $item->material_return_item_description ?? '' }}	{{ $item->material_issue_qty ?? '' }}	{{ $item->material_return_qty }}	{{ $item->productStock->qty ?? 0 }}	{{ $item->products->product_unit_measurement ?? '' }}

@endforeach

{{--

--}}

From,

{{--

--}}

{{ $return->company->company_name ?? '' }}

TOOLS RETURN

From,

{{ $return->customer->customer_name ?? 'Customer Name' }}

{{ $category['category_name'] }}

From,

{{ $return->company->company_name ?? '' }}