@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)
|
{{ $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')}} | {{__('Pmt Received')}} | {{__('Pmt Mode')}} | {{__('UH ID')}} | {{__('Patient Name')}} | {{__('Remarks')}} | {{__('Gross')}} | {{__('Disc')}} | {{__('Net Taxable')}} | {{__('CGST')}} | {{__('SGST')}} | {{__('Invoice')}} | {{__('R.Off')}} | {{__('Net Amount')}} | {{__('Created By')}} | ||||||
| {{__('Sr')}} | {{__('Medicine Name')}} | {{__('HSN Code')}} | {{__('Mfg')}}/th> | {{__('Category')}} | {{__('P Unit')}} | {{__('S Unit')}} | {{__('P Size')}} | {{__('Ref No.')}} | {{__('Batch')}} | {{__('Exp')}} | {{__('Qty')}} | {{__('MRP')}} | {{__('Disc')}}% | {{__('Disc')}} | {{__('Taxable')}} | {{__('GST')}}% | {{__('GST')}} | {{__('Amount')}} | |||
| {{__('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 }} | {{ $patOrCustID }} | {{ $patOrCustName }} | {{ $productTransaction->ph_remarks }} | {{ \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) }} | |||
| {{__('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')}} | {{__('No. of Txn.')}}' | {{__('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) }} | @else{{__('Total')}} : | 0 | 0.00 | 0 | 0.00 | 0.00 | @endif||||||||
| {{__('In Case of Multiple Mode of Payment, Total No. of Transactions may not be the Same as Total No. of Sales Bill')}} | ✱ {{ __(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) }} | @else{{__('Total')}} : | 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 ') }} | ||||||