@php $sno = 1; @endphp @foreach($orders as $key => $row) @php $order_id = $row['order_id']; $remarks = str_replace(["\n", "\r"],"",$row['comment']); $invoice_id = $row['invoice_prefix'] . $order_id; $creditNote = 'N/A'; $redeemCreditNote = 'N/A'; $issueCreditNote = 'N/A'; $discountTot = 0; $giftVoucherTotal = 'N/A'; $redeemPoints = 'N/A'; $roundOff = 'N/A'; $taxTot = 0; $cgstAmt = $sgstAmt = 0; $saleAfterDiscount = 0; $mrp = 0; @endphp @endforeach

From	{{ !empty($startdate) ? $startdate : ''}}						To	{{ !empty($enddate) ? $enddate : ''}}
DSR INVOICE WISE
S.No.	store	BILL#	Date	Pcs.	Credit Note	Cash	Card	UPI	Wallet	Cnote	Gift Voucher	Redeem Credit Note	Issue Credit Note	Discount	Gift Voucher	Redeem Points.	Round Off.	CGST Amt	SGST Amt	Tax Amt.	Total Sale After Discount
{{ $sno }}	{{ $row->warehouse->name }}	{{ $invoice_id }}	{{ $row['date_added'] }}	{{ $row->orderProducts->count() }}	{{ $creditNote }}	{{ number_format($row->orderTotalByCash->sum('pmt'),2) }}	{{ number_format($row->orderTotalByCard->sum('pmt'),2) }}	{{ number_format($row->orderTotalByUPI->sum('pmt'),2) }}	{{ number_format($row->orderTotalByWallet->sum('pmt'),2) }}	{{ number_format($row->orderTotalByCreditNote->sum('pmt'),2) }}	{{ number_format($row->orderTotalByGiftVoucher->sum('pmt'),2) }}	{{ $redeemCreditNote }}	{{ $issueCreditNote }}	{{ !empty($row->orderByDiscountCode->value) ? number_format($row->orderByDiscountCode->value,2) : 0 }}	{{ $giftVoucherTotal }}	{{ $redeemPoints }}	{{ $roundOff }}	{{ !empty($row->orderByTaxCode->value) ? number_format(($row->orderByTaxCode->value/2),2) : 0 }}	{{ !empty($row->orderByTaxCode->value) ? number_format(($row->orderByTaxCode->value/2),2) : 0 }}	{{ !empty($row->orderByTaxCode->value) ? number_format($row->orderByTaxCode->value,2) : 0 }}	{{ !empty($row->orderByTotalCode->value) ? number_format($row->orderByTotalCode->value,2) : 0 }}