@if (!empty($emb_items)) @php $BillType = $bill['BillType']; @endphp @foreach ($emb_items as $bill) @php $tendQuantity = DB::table('tbl_projects_schedule_b') ->where('DSRItemCodeRef', $bill->DSRItemCodeRef) ->where('ProjectIDRef', $bill->ProjectIDRef) ->first(); $prevQuantity = DB::table('tbl_emb_bills') ->select(DB::raw('sum(ItemQuanitity) as PrevQuantity')) ->where('DSRItemCodeRef', $bill->DSRItemCodeRef) ->where('ProjectIDRef', $bill->ProjectIDRef) ->where('BillNo', '<', $bill->BillNo) ->first(); $prevQuantity->PrevQuantity = $prevQuantity->PrevQuantity ?? 0.00; @endphp @php $bills = DB::table('tbl_emb_bills_billing_entry')->where('EmbBillIDRef', $bill->EmbBillID)->get(); $non_bills = DB::table('tbl_emb_bills_non_billing_entry')->where('EmbBillIDRef', $bill->EmbBillID)->get(); @endphp @if (!empty($bills[0])) @foreach ($bills as $r) @endforeach @else @endif @if (!empty($non_bills[0])) @foreach ($non_bills as $r) @endforeach @else @endif @endforeach

No	Date	Particular	Number	Length	Breadth	Depth	Item Qty	Quantity	Unit
{{ $bill->EmbBillSequenceNo }}	{{ $bill->DSRItemCodeRef }}: {{ $bill->ItemOfWork }}							{{ $bill->ItemQuanitity }}	{{ $bill->ItemUnit }}
Billing Non Billing Billing Non Billing								@if ($bill->IsTaxable == "yes" && $BillType == "RA Bill") formula == "normal" ? 'selected' : '' }}>Normal Record formula == "earth" ? 'selected' : '' }}>Earth Work formula == "rcc" ? 'selected' : '' }}>RCC Steel formula == "structural" ? 'selected' : '' }}>Structural Steel rate_type == "PR" ? 'checked' : '' }}>PR rate_type == "RR" ? 'checked' : '' }}>RR rate_type == "FR" ? 'checked' : '' }}>FR @endif

@endif