@extends('layouts.horizontal', ['title' => 'Purchases', 'topbarTitle' => 'Purchases', 'nonav' => true]) @section('css') @vite(['node_modules/select2/dist/css/select2.min.css']) @vite(['node_modules/datatables.net-bs5/css/dataTables.bootstrap5.min.css', 'node_modules/datatables.net-responsive-bs5/css/responsive.bootstrap5.min.css', 'node_modules/datatables.net-fixedcolumns-bs5/css/fixedColumns.bootstrap5.min.css', 'node_modules/datatables.net-fixedheader-bs5/css/fixedHeader.bootstrap5.min.css', 'node_modules/datatables.net-buttons-bs5/css/buttons.bootstrap5.min.css', 'node_modules/datatables.net-select-bs5/css/select.bootstrap5.min.css',]) @endsection @section('content')

Purchase Order #{{ $purchase_order->purchase_order_number }}

For Branch: {{ $purchase_order->business_name }}
Supplier Name: {{ $purchase_order->supplier_name }}
Contact: {{ $purchase_order->contact_person }}
Supplier Address: {{ $purchase_order->ho_address }}
Email: {{ $purchase_order->email }}
Order Date: {{ $purchase_order->formatted_order_date }}
Created On: {{ \Carbon\Carbon::parse($purchase_order->created_on)->format('d-m-Y H:i') }}
Total Quantity: {{ $purchase_order->product_total_qty }}
Total Purchase Price: {{ config('constants.CURRENCY') }}{{ round($purchase_order->total_purchase_pirce, 2) }}
Created By: {{ $purchase_order->created_by }}

Purchase Order Items

Items included in this Purchase Order
@php $total_received = 0; $total_qty = 0; $total_cost=0; $total_returned = 0; $total_qty_value=0; @endphp @foreach($purchase_order_details as $item) @php $total_received += $item->total_received ?? 0; $total_cost += $item->product_purchase_price * ($item->total_received - ($item->total_returned ?? 0));; $total_qty += $item->product_qty; $total_qty_value += $item->product_purchase_price * $item->product_qty; $total_returned += $item->total_returned ?? 0; @endphp @endforeach
Product Name Brand Ordered Received Returned Final Receiving Unit Price Total Qty Value Payable
{{ $item->product_name }} {{ $item->brand_name }} {{ $item->product_qty }} {{ $item->total_received ?? 0 }} {{ $item->total_returned ?? 0 }} {{ $item->total_received - ($item->total_returned ?? 0) }} {{ config('constants.CURRENCY') }}{{ round($item->product_purchase_price, 2) }} {{ config('constants.CURRENCY') }}{{ round($item->product_purchase_price * $item->product_qty, 2) }} {{ config('constants.CURRENCY') }}{{ round($item->product_purchase_price * ($item->total_received - ($item->total_returned ?? 0)), 2) }}
Total {{ $total_qty }} {{ $total_received }} {{ $total_returned }} {{ $total_received - $total_returned }} {{ config('constants.CURRENCY') }}{{ round($total_qty_value, 2) }} {{ config('constants.CURRENCY') }}{{ round($total_cost, 2) }}

Existing Goods Received Note (GRN)

GRNs for this Purchase Order
@php $total_grn_received = 0; $total_grn_cost=0; $total_returned = 0; @endphp @foreach($goods_received_notes as $grn) @php $total_grn_received += $grn->total_received; $total_grn_cost += $grn->total_cost; $total_returned += $grn->total_returned ?? 0; @endphp @endforeach
GRN ID GRN# GRN Date Products Comment Received Qty Returned Qty
{{ $grn->grn_id }} {{ $grn->grn_number }} {{ $grn->formatted_grn_date }} {!! $grn->products_received !!} {{ $grn->grn_comment }} {{ $grn->total_received }} total_returned > 0) echo 'href="'.route('purchase.print_return_note', ['idgrn' => $grn->grn_id]).'"'; else echo "#"; @endphp>{{ $grn->total_returned ?? 0 }} Add Return Note
Total {{ $total_grn_received }} {{ $total_returned }}

Account Vouchers Linked to this Purchase Order

Account Vouchers for this Purchase Order
@php $running_total = 0; @endphp @foreach($account_vouchers as $av) @php if($av->total_debit > 0) { $running_total -= $av->total_debit; } elseif($av->total_credit > 0) { $running_total += $av->total_credit; } @endphp @endforeach
Voucher ID GRN# Voucher Date Paid Payable Running Total
{{ $av->id_account_vouchers }} {{ $av->grn_id }} {{ $av->formatted_voucher_date }} {{ config('constants.CURRENCY') }}{{ round($av->total_debit, 2) }} {{ config('constants.CURRENCY') }}{{ round($av->total_credit, 2) }} {{ config('constants.CURRENCY') }}{{ round($running_total, 2) }}
Total {{ config('constants.CURRENCY') }}{{ round($account_vouchers->sum('total_debit'), 2) }} {{ config('constants.CURRENCY') }}{{ round($running_total, 2) }}
@endsection