Material Requests Report

Total Requests

{{ number_format($requests->count()) }}

Total Requested Qty

{{ number_format($total_requested, 2) }}

Total Released Qty

{{ number_format($total_released, 2) }}

Pending Balance

{{ number_format($total_requested - $total_released, 2) }}

@forelse($requests as $request) @php $divisionName = $request->division?->division_name ?? $request->project?->projectDivision?->division_name ?? '-'; @endphp @empty @endforelse

MR Number	Date	Project	Division	Type of Goods	Requested By	Requested	Released	Balance	Fulfillment	Status
{{ $request->material_request_number ?? '-' }}	{{ $request->transaction_date ? \Carbon\Carbon::parse($request->transaction_date)->format('d M Y') : '-' }}	{{ Str::limit($request->project?->project_name ?? '-', 20) }}	{{ Str::limit($divisionName, 12) }}	{{ Str::limit($request->type_of_goods ?? '-', 12) }}	{{ Str::limit($request->requester?->name ?? '-', 12) }}	{{ number_format($request->total_requested ?? 0, 2) }}	{{ number_format($request->total_released ?? 0, 2) }}	{{ number_format($request->total_balance ?? 0, 2) }}	{{ ucfirst($request->fulfillment_status ?? 'pending') }}	{{ ucfirst($request->status ?? 'pending') }}
No material requests found