@extends('Reports.template') @if ($trnType == 'I') @php $reportTitle = 'Sale Register Report'; @endphp @elseif($trnType == 'IR') @php $reportTitle = 'Sale Return Register Report'; @endphp @else @php $reportTitle = 'Sale & Sale Return Register Report'; @endphp @endif @section('title') {{ $reportTitle }} @endsection @section('ExternalCss') @parent @endsection @section('Content')
@if ($businessEntityMasterData[0]->logo != null) @endif |
{{ $businessEntityMasterData[0]->name }}
{{ $businessEntityMasterData[0]->add1 . ' ' . $businessEntityMasterData[0]->add2 . ' ' . $businessEntityMasterData[0]->city . ' : ' . $businessEntityMasterData[0]->pincode }}
{{ 'Phone : ' . $businessEntityMasterData[0]->tel1 }}
|
|||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
{{ $reportTitle . ' ' }} | Store : {{ $storeName }} | Period : {{ \Helper::getDisplayDate($fromDate) }} TO {{ \Helper::getDisplayDate($toDate) }} | ||||||||||||||||||
Patient Category : @php $cat=""; foreach ($rateCard as $item) $cat.= $item->rate_card .'-'. $item->rate_type .', '; @endphp {{ rtrim($cat,', ') }} | ||||||||||||||||||||
Bill No | Bill Date | Payment Received | Payment Mode | Patient / Customer Name | Gross | Disc | Net Taxable | CGST | SGST | Invoice | R.Off | Net Amount | Created By | |||||||
Sr | Medicine Name | HSN Code | Mfg | Category | P Unit | S Unit | P Size | Ref No. | Batch | Exp | Qty | MRP | Disc% | Disc | Taxable | GST% | GST | Amount | ||
@if ($remark != '') Remarks : {{ $remark }} @endif | Total Qty : {{ \Helper::zeroValueToDash($totalQty) }} | |||||||||||||||||||
D.L NO : {{ $businessEntityMasterData[0]->dl_no }} | GST NO : {{ $businessEntityMasterData[0]->gsttin_no }} | {{ 'Created By : ' }} @if ($createdBy) {{ $createdBy . ' ' . Carbon\Carbon::parse($datetime)->format('d-m-Y h:i:s') }} @endif | ||||||||||||||||||
@if ($productTransaction->is_credit_bill == 'Y') ✱ @endif {{ $productTransaction->trn_type . "/" . $productTransaction->trn_fyear . "/" . $productTransaction->ph_trn_id }} | {{ \Helper::getDisplayDate($productTransaction->trn_date) }} | {{ $productTransaction->is_fully_paid == 'Y' ? 'Yes' : 'No' }} | {{ $paymentMode }} | {{ $patOrCustName }} | {{ \Helper::customAmountFormat($phGrossTotal) }} | {{ \Helper::customAmountFormat($phDiscountAmt) }} | {{ \Helper::customAmountFormat($phNetTaxableAmt) }} | {{ \Helper::customAmountFormat($phCgstAmt) }} | {{ \Helper::customAmountFormat($phSgstAmt) }} | {{ \Helper::customAmountFormat($phInvoiceAmt) }} | {{ \Helper::customAmountFormat($phRoundOff) }} | {{ \Helper::customAmountFormat($phTotal) }} | {{ $productTransaction->ph_created_by }} | |||||||
{{ $transactionSr++ }} | {{ \Helper::zeroValueToDash($productTransaction->product_name) }} | {{ \Helper::zeroValueToDash($productTransaction->product_hsn_code) }} | {{ \Helper::zeroValueToDash($productTransaction->manufacturer_name) }} | {{ \Helper::zeroValueToDash($productTransaction->category_abbrev) }} | {{ \Helper::zeroValueToDash($productTransaction->unit_abbrev) }} | {{ \Helper::zeroValueToDash($productTransaction->suom) }} | {{ \Helper::zeroValueToDash($productTransaction->conversion_factor) }} | {{ \Helper::zeroValueToDash($refTrnNo) }} | {{ $productTransaction->batch_no }} | {{ \Helper::getMonthYearFromDate($productTransaction->batch_exp) }} | {{ $productTransaction->quantity }} | {{ \Helper::customAmountFormat($productTransaction->mrp) }} | {{ \Helper::customAmountFormat($productTransaction->discount) }} | {{ \Helper::customAmountFormat($productTransaction->discount_amt) }} | {{ \Helper::customAmountFormat($productTransaction->taxable_amt) }} | {{ \Helper::customAmountFormat(floatval($productTransaction->sgst_percentage) + floatval($productTransaction->cgst_percentage)) }} | {{ \Helper::customAmountFormat(floatval($productTransaction->sgst_value) + floatval($productTransaction->cgst_value)) }} | {{ \Helper::customAmountFormat($productTransaction->total) }} | ||
@if ($remark != '') Remarks : {{ $remark }} @endif | Total Qty : {{ \Helper::zeroValueToDash($totalQty) }} | |||||||||||||||||||
D.L NO : {{ $businessEntityMasterData[0]->dl_no }} | GST NO : {{ $businessEntityMasterData[0]->gsttin_no }} | {{ 'Created By : ' }} @if ($createdBy) {{ $createdBy . ' ' . Carbon\Carbon::parse($datetime)->format('d-m-Y h:i:s') }} @endif | ||||||||||||||||||
{{ $footerHeading . ' ' . \Helper::zeroValueToNbspSpace($summary->Bills) }} | {{ \Helper::customAmountFormat($summary->gross_total) }} | {{ \Helper::customAmountFormat($summary->discount) }} | {{ \Helper::customAmountFormat($summary->netTaxable) }} | {{ \Helper::customAmountFormat($summary->cgst) }} | {{ \Helper::customAmountFormat($summary->sgst) }} | {{ \Helper::customAmountFormat($summary->invoice_amt) }} | {{ \Helper::customAmountFormat($summary->round_off) }} | {{ \Helper::customAmountFormat($summary->total) }} | ||||||||||||
Total Bills : {{ \Helper::zeroValueToNbspSpace($summaryBills) }} | {{ \Helper::customAmountFormat($summaryGrossTotal) }} | {{ \Helper::customAmountFormat($summaryDiscount) }} | {{ \Helper::customAmountFormat($summaryNetTaxable) }} | {{ \Helper::customAmountFormat($summaryCgst) }} | {{ \Helper::customAmountFormat($summarySgst) }} | {{ \Helper::customAmountFormat($summaryInvoiceAmt) }} | {{ \Helper::customAmountFormat($summaryRoundOff) }} | {{ \Helper::customAmountFormat($summaryTotal) }} | ✱ {{ Config::get('constants.asterisk.WALK_CUST') }}, ✱{{ 'Credit Bill' }} | {{ strtoupper(Session::get('userId')) . ' # ' . $currentTime->format('d/m/Y H:i:s ') }} | @endif
Sales Summery Payment Mode Wise | Store : {{ $storeName }} | Period : {{ \Helper::getDisplayDate($fromDate) }} TO {{ \Helper::getDisplayDate($toDate) }} | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Payment Mode | Sales Bill Count | Sales | Sales Return Bill Count | Sales Return | Total | ||||||||||||||
{{ $summary[0]->CODE }} | {{ $summary[0]->SaleBill }} | {{ number_format((float) $sale, 2) }} | {{ $summary[0]->SaleReturnBill }} | {{ number_format((float) $saleReturn, 2) }} | {{ number_format((float) $sale - $saleReturn, 2) }} | @else{{ $summary[0]->CODE }} | 0 | 0.00 | 0 | 0.00 | 0.00 | @endif||||||||
Credit Bill | {{ $summary[0]->CreditSaleBill }} | {{ number_format((float) $summary[0]->CreditSale, 2) }} | {{ $summary[0]->CreditSaleReturnBill }} | {{ number_format((float) $summary[0]->CreditSaleReturn, 2) }} | {{ number_format((float) $summary[0]->CreditSale - $summary[0]->CreditSaleReturn, 2) }} | ||||||||||||||
Total : | {{ $total_sale_bill }} | {{ number_format((float) $total_sale, 2) }} | {{ $total_sale_return_bill }} | {{ number_format((float) $total_sale_return, 2) }} | {{ number_format((float) $total_amount, 2) }} | @elseTotal : | 0 | 0.00 | 0 | 0.00 | 0.00 | @endif✱ {{ Config::get('constants.asterisk.WALK_CUST') }}, ✱{{ 'Credit Bill' }} | {{ strtoupper(Session::get('userId')) . ' # ' . $currentTime->format('d/m/Y H:i:s ') }} |
Receipt Payment Mode Wise - Only for Credit Bill | Store : {{ $storeName }} | Period : {{ \Helper::getDisplayDate($fromDate) }} TO {{ \Helper::getDisplayDate($toDate) }} | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Payment Mode | Receipt Count | Receipt Amount | Refund Receipt Count | Refund Amount | Total | ||||||||||||||
{{ $summary[0]->CODE }} | {{ $summary[0]->SaleBill }} | {{ number_format((float) $sale, 2) }} | {{ $summary[0]->SaleReturnBill }} | {{ number_format((float) $saleReturn, 2) }} | {{ number_format((float) $sale - $saleReturn, 2) }} | @else{{ $summary[0]->CODE }} | 0 | 0.00 | 0 | 0.00 | 0.00 | @endif||||||||
Total : | {{ $total_sale_bill }} | {{ number_format((float) $total_sale, 2) }} | {{ $total_sale_return_bill }} | {{ number_format((float) $total_sale_return, 2) }} | {{ number_format((float) $total_amount, 2) }} | @elseTotal : | 0 | 0.00 | 0 | 0.00 | 0.00 | @endif✱ {{ Config::get('constants.asterisk.WALK_CUST') }}, ✱{{ 'Credit Bill' }} | {{ strtoupper(Session::get('userId')) . ' # ' . $currentTime->format('d/m/Y H:i:s ') }} |