Name Of Work :-	{{ $row->ProjectName }}
Agency :-	{{ $contractor->UserFirm ?? '' }}, {{ $contractor->UserFirmAddress ?? '' }}
Work Order ID :-	{{ $row->ProjectWorkOrderID }}
Major Head :-	{{ $majorHead->MajorHeadName }}

@if ($bill['BillNo'] != 1) @endif @if ($bill['BillNo'] != 1) @endif @if (!empty($abstracts)) @php $rate_repl_array = ['reduced_rate' => 'RR', 'part_rate' => 'PR']; $i = 1; $total_amount = $total_royalty = 0; $work_portion_amount = 0; $quality_control_amount = 0; $grand_total_amount = 0; $prev_total_amount = 0; $prev_work_portion_amount = 0; $prev_quality_control_amount = 0; $added_dsr_codes = []; $present = false; // Query for previous work portion and quality control amounts $prev_work_portion = DB::table('tbl_emb_abstracts') ->where('ProjectIDRef', $row->ProjectID) ->where('BillNo', '<', $bill['BillNo']) ->where('IsTaxable', 'yes') ->sum('TotalAmount'); $prev_quality_control = DB::table('tbl_emb_abstracts') ->where('ProjectIDRef', $row->ProjectID) ->where('BillNo', '<', $bill['BillNo']) ->where('IsTaxable', 'no') ->sum('TotalAmount'); $grand_total_amount = $prev_work_portion + $prev_quality_control; $prev_total_amount = $grand_total_amount; @endphp @foreach ($abstracts as $s) @php if ($s['IsTaxable'] == 'yes') { $work_portion_amount += $s['TotalAmount']; } else { $quality_control_amount += $s['TotalAmount']; } $total_amount += $s['TotalAmount']; $grand_total_amount += $s['TotalAmount']; $present = in_array($s['DSRItemCodeRef'] . $s['Year'], $added_dsr_codes); if (!$present) { $added_dsr_codes[] = $s['DSRItemCodeRef'] . $s['Year']; $prev_paid = DB::table('tbl_emb_abstracts') ->where('ProjectIDRef', $row->ProjectID) ->where('DSRItemCodeRef', $s['DSRItemCodeRef']) ->where('BillNo', '<', $bill['BillNo']) ->groupBy('DSRItemCodeRef') ->selectRaw('SUM(TotalAmount) as prev_total_amount, SUM(TotalQuantity) as prev_total_quantity') ->first(); $prev_paid_qauntity = $prev_paid->prev_total_quantity ?? 0; $prev_paid_amount = $prev_paid->prev_total_amount ?? 0; } @endphp @if (!$present) @if ($bill['BillNo'] != 1) @endif @else @endif @endforeach @endif

Item No	Description	Up To Date		Previously Paid		Now To be Paid			Unit
		Qty	Amount	Qty	Amount	Qty	Rate	Amount
{{ $s['EmbAbstractSequenceNo'] }}	{{ $s['ItemOfWork'] }}	{{ number_format($prev_paid_qauntity + $s['TotalQuantity'], 2) }}	{{ number_format($prev_paid_amount + $s['TotalAmount'], 2) }}	{{ number_format($prev_paid_qauntity, 2) }}	{{ number_format($prev_paid_amount, 2) }}					{{ $s['TotalQuantity'] }}	{{ $s['Rate'] }} @if ($s['RateType'] != 'full_rate') ({{ $rate_repl_array[$s['RateType']] }}) {{ $s['ActualRate'] }} @endif	{{ $s['TotalAmount'] }}	{{ $s['Unit'] }}