Employee Requisition List

{{--

Bill No	:	{{'EREQ'.$data->employee_requisition_no}}	Bill Date	:	{{date('d-m-Y', strtotime($data->employee_requisition_date))}}	Total Quantity	:	{{$data->total_quantity}}	Total Amount	:	{{number_format($data->total_amount, 2)}}
Discount Amount	:	{{$data->discount_amount}}	T/A with discount	:	{{number_format($data->total_amount_after_discount, 2)}}	Gross Toal	:	{{number_format($data->gross_total, 2)}}	Pay Total	:	{{number_format($data->pay_amount, 2)}}

--}}

Bill No	:	{{'ER'.$data->employee_requisition_no}}		Bill Date	:	{{date('d-m-Y', strtotime($data->employee_requisition_date))}}		Branch	:	{{$data->inv_branch->name}}
Total Quantity	:	{{$data->total_quantity}}		To Employee	:	{{$data->inv_employee->emp_name_english}}

{{-- @php $no= $t_d_qty = $t_qty = $t_amount = $iRow = $current_stock = 0;@endphp @foreach($data->inv_employee_requisition_details as $details) @php $purchaseBarcodeQuantity = 0; $purchaseBarcodeQuantity = $details->quantity; @endphp @php $t_qty += $purchaseBarcodeQuantity; $t_amount += ($purchaseBarcodeQuantity * $details->inv_product->cost_price); @endphp @endforeach --}} @php $no= $t_d_qty = $t_qty = $t_amount = $iRow = $current_stock = 0;@endphp @foreach($data->inv_employee_requisition_details as $details) @php $iRow++; $purchaseBarcodeQuantity = 0; // $purchaseBarcodeQuantity = $details->quantity; $purchaseBarcodeQuantity = \App\Models\inventory\transaction\use\InvTraUseDetails::where('requisition_id',$details->id)->where('branch_id',$details->branch_id)->where('product_id',$details->product_id)->sum('quantity'); $requestedQuantity = $details->requested_qty; @endphp @php $t_d_qty += $details->quantity; $t_qty += $purchaseBarcodeQuantity; $t_amount += ($purchaseBarcodeQuantity * $details->inv_product->cost_price); @endphp @endforeach

SL No.	Product Name	Uom Name	Demand	Received
{{++$no}}	{{$details->inv_product->name}}	{{$details->inv_product->inv_model->name}}	{{$details->inv_product->barcode}}	{{$purchaseBarcodeQuantity}}	{{number_format($details->inv_product->cost_price, 2)}}	{{number_format($purchaseBarcodeQuantity * $details->inv_product->cost_price, 2)}}
{{++$no}}	{{$details->inv_product->name}}	{{$details->inv_product->inv_uom->name}}	{{ $details->quantity }}	{{$purchaseBarcodeQuantity}}
Total			{{$t_d_qty}}	{{$t_qty}}

@php $logo = DB::table('gnr_company')->select('image')->first(); @endphp

MATERIAL RECIVING REPORT (MRR)
Bill No	:	{{'EREQ'.$data->employee_requisition_no}}	Bill Date	:	{{$data->employee_requisition_date}}
Order No	:	{{isset($data->employee_requisition_no) ? $data->employee_requisition_no : 'N/A'}}	Requisition	:	{{isset($data->requisition_no) ? $data->requisition_no : 'N/A'}}
Total Quantity	:	{{$data->total_quantity}}	Total Amount	:	{{number_format($data->total_amount, 2)}}
Supplier Name	:	{{$data->inv_supplier->company_name}}	Mobile	:	{{$data->inv_supplier->phone}}
Address: {{isset($data->inv_supplier->address) ? $data->inv_supplier->address: 'N/A' }}
T/A with discount	:	{{number_format($data->total_amount_after_discount, 2)}}	Gross Toal	:	{{number_format($data->gross_total, 2)}}

{{-- --}} @php $no=0; $t_qty = $t_amount = 0; @endphp @foreach($data->inv_employee_requisition_details as $details) {{-- --}} @php $t_qty += 1; $t_amount += $details->inv_product->cost_price; @endphp @endforeach

SL No.	Product Name	Model Name	Barcode	Purchase Order Information
SL No.	Product Name	Model Name	Barcode	Qty	Unit Price	Total Price	PID No.
{{++$no}}	{{$details->inv_product->name}}	{{$details->product->model->name}}	{{$details->inv_product->barcode}}	{{$details->quantity}}	{{number_format($details->inv_product->cost_price, 2)}}	{{number_format(1*$details->inv_product->cost_price, 2)}}	{{$details->barcode_serial}}
Total			{{$t_qty}}	Total	{{number_format($t_amount, 2)}}

Receive By :

Designation:

Emp.Id :HR & Adminitration