{{-- pi Table goes here --}} @php $sl=0 @endphp @foreach ($sces as $projection_order_id_value) {{-- @dd($projection_order_id_value); @die --}} @php $projection_order_id = App\Models\ProjectionOrder::where( 'id', $projection_order_id_value, )->first(); $poc = App\Models\ProjectionOrderConfirm::where( 'projection_order_id', $projection_order_id->id, )->first(); $pis = DB::table('p_i_s') ->where('projection_order_id', $projection_order_id->id) ->select('pi_no', 'pi_date') ->groupBy('pi_no', 'pi_date') ->get(); @endphp @endforeach

Sl#	Buyer Name	Job No	SC/ LC No	Quantity	Value	PI (Date)	Accounts Details	Actions
{{ ++$sl }}	{{ Carbon\Carbon::parse($projection_order_id->date)->format('d-m-Y') }}	{{ $projection_order_id->buyer_name }}	{{ $projection_order_id->season }}	{{ $projection_order_id->job_no }}	@php $pi = App\Models\PI::where( 'projection_order_id', $poc->projection_order_id, )->first(); @endphp @if ($pi != null) {{ $pi->buyer_export_lc_no }} @endif	@foreach ($pis as $pi) {{ $pi->pi_no ?? old('pi_no') }} ({{ $pi->pi_date }})     @endforeach	Accounts Details Accounts Details @php $accs = App\Models\Accountancy::where( 'projection_order_id', $projection_order_id_value, )->get(); @endphp @foreach ($accs as $acc) @endforeach BANK SUB DT. LDBC BILL NO. LDBC BILL DATE MATURITY DATE LC or Contract Payment terms Realized Date REALISED VALUE Short Value BANK Remarks Action {{ $acc->bank_sub_date }} {{ $acc->ldbc_bill_no }} {{ $acc->ldbc_bill_date }} {{ $acc->maturity_date }} {{ $acc->lc_contract }} {{ $acc->payment_terms }} {{ $acc->realized_date }} {{ $acc->realized_value }} {{ $acc->short_value }} {{ $acc->bank_name }} {{ $acc->remarks }} @can('access-accounts-admin') Edit Delete @endcan Comments Close	@can('access-accounts-admin') Account Entry @endcan Comments {{-- @csrf @method('delete') Delete Delete --}}