|
@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 }} | IP Bill Period : {{ \Helper::getDisplayDate($fromdate) }} TO {{ \Helper::getDisplayDate($todate) }} | ||||||||||||||
| Sr No. | Trn No | Trn Date | Bill Type | Sale Amt MRP | Sale Amt With GST | Purchase Amt With GST | Sale Amt Without GST | Purchase Amt Without GST | Gross Profit Amt | Gross Sales Margin % | Gross Profit % | ||||
| Sr No. | Product Name | Sale Qty | Sale Amt MRP | Sale Amt | Purchase Amt | Gross Profit Amt | Gross Sales Margin % | Gross Profit % | |||||||
| (A) | (B) | (C = A - B) | (D = (C / A) * 100) | (E = (C / B) * 100) | |||||||||||
| (A) | (B) | (C = A - B) | (D = (C / A) * 100) | (E = (C / B) * 100) | |||||||||||
| Total : | {{ \Helper::customAmountFormat($totalSaleMrp) }} | {{ \Helper::customAmountFormat($totalSaleAmt) }} | {{ \Helper::customAmountFormat($totalPurchaseAmt) }} | {{ \Helper::customAmountFormat($totalProfitAmt) }} | {{ \Helper::customAmountFormat(($totalProfitAmt / $totalSaleAmt) * 100) . '%' }} | {{ \Helper::customAmountFormat(($totalProfitAmt / $totalPurchaseAmt) * 100) . '%' }} | |||||||||
| Patient Total : | {{ \Helper::customAmountFormat($patienttotalSaleMrp) }} | {{ \Helper::customAmountFormat($patienttotalSaleAmt) }} | {{ \Helper::customAmountFormat($patienttotalPurchaseAmt) }} | {{ \Helper::customAmountFormat($patienttotalProfitAmt) }} | {{ \Helper::customAmountFormat(($patienttotalProfitAmt / $patienttotalSaleAmt) * 100) . '%' }} | {{ \Helper::customAmountFormat(($patienttotalProfitAmt / $patienttotalPurchaseAmt) * 100) . '%' }} | |||||||||
| Entity Total : | {{ \Helper::customAmountFormat($entitytotalSaleMrp) }} | {{ \Helper::customAmountFormat($entitytotalSaleAmt) }} | {{ \Helper::customAmountFormat($entitytotalPurchaseAmt) }} | {{ \Helper::customAmountFormat($entitytotalProfitAmt) }} | {{ \Helper::customAmountFormat(($entitytotalProfitAmt / $entitytotalSaleAmt) * 100) . '%' }} | {{ \Helper::customAmountFormat(($entitytotalProfitAmt / $entitytotalPurchaseAmt) * 100) . '%' }} | |||||||||
| Entity : {{ $entity_name }} | |||||||||||||||
| Patient : {{ $patient_id . ' / ' . $patient_name }} IP ID : {{ $ipd_reg_id }} | Discharge Date : @if ($profit->discharge_date!="0000-00-00") {{ \Helper::getDisplayDate($profit->discharge_date) }} @endif | ||||||||||||||
| {{ $headerSr++ }} | {{ $profit->trn_type. "/". $profit->trn_fyear. "/" . $profit->trn_id }} | {{ \Helper::getDisplayDate($profit->trn_date) }} | {{ $profit->is_credit_bill=="N"?'CASH':'' }} | ||||||||||||
| {{ $transactionSr++ }} | {{ $profit->product_name }} | {{ $profit->quantity }} | {{ \Helper::customAmountFormat($profit->mrp) }} | {{ \Helper::customAmountFormat($profit->sale_amt) }} | {{ \Helper::customAmountFormat($profit->pur_amt) }} | {{ \Helper::customAmountFormat($profitAmt) }} | {{ \Helper::customAmountFormat($MarginPer) . '%' }} | {{ \Helper::customAmountFormat($ProfitPer) . '%' }} | |||||||
| Total : | {{ \Helper::customAmountFormat($totalSaleMrp) }} | {{ \Helper::customAmountFormat($totalSaleAmt) }} | {{ \Helper::customAmountFormat($totalPurchaseAmt) }} | {{ \Helper::customAmountFormat($totalProfitAmt) }} | {{ \Helper::customAmountFormat(($totalProfitAmt / $totalSaleAmt) * 100) . '%' }} | {{ \Helper::customAmountFormat(($totalProfitAmt / $totalPurchaseAmt) * 100) . '%' }} | |||||||||
| Patient Total : | {{ \Helper::customAmountFormat($patienttotalSaleMrp) }} | {{ \Helper::customAmountFormat($patienttotalSaleAmt) }} | {{ \Helper::customAmountFormat($patienttotalPurchaseAmt) }} | {{ \Helper::customAmountFormat($patienttotalProfitAmt) }} | {{ \Helper::customAmountFormat(($patienttotalProfitAmt / $patienttotalSaleAmt) * 100) . '%' }} | {{ \Helper::customAmountFormat(($patienttotalProfitAmt / $patienttotalPurchaseAmt) * 100) . '%' }} | |||||||||
| Entity Total : | {{ \Helper::customAmountFormat($entitytotalSaleMrp) }} | {{ \Helper::customAmountFormat($entitytotalSaleAmt) }} | {{ \Helper::customAmountFormat($entitytotalPurchaseAmt) }} | {{ \Helper::customAmountFormat($entitytotalProfitAmt) }} | {{ \Helper::customAmountFormat(($entitytotalProfitAmt / $entitytotalSaleAmt) * 100) . '%' }} | {{ \Helper::customAmountFormat(($entitytotalProfitAmt / $entitytotalPurchaseAmt) * 100) . '%' }} | |||||||||
| Bill Total : | {{ \Helper::customAmountFormat($grossTotalSaleMrp) }} | {{ \Helper::customAmountFormat($grossTotalSaleAmt) }} | {{ \Helper::customAmountFormat($grossTotalPurchaseAmt) }} | {{ \Helper::customAmountFormat($grossTotalProfitAmt) }} | {{ \Helper::customAmountFormat(($grossTotalProfitAmt / $grossTotalSaleAmt) * 100) . '%' }} | {{ \Helper::customAmountFormat(($grossTotalProfitAmt / $grossTotalPurchaseAmt) * 100) . '%' }} | |||||||||
| {{ \Helper::customAmountFormat($totalSaleMrp) }} | {{ \Helper::customAmountFormat($totalSaleAmt) }} | {{ \Helper::customAmountFormat($totalPurchaseAmt) }} | {{ \Helper::customAmountFormat($totalProfitAmt) }} | {{ \Helper::customAmountFormat(($totalProfitAmt / $totalSaleAmt) * 100) . '%' }} | {{ \Helper::customAmountFormat(($totalProfitAmt / $totalPurchaseAmt) * 100) . '%' }} | ||||||||||
| Patient Total : | {{ \Helper::customAmountFormat($patienttotalSaleMrp) }} | {{ \Helper::customAmountFormat($patienttotalSaleAmt) }} | {{ \Helper::customAmountFormat($patienttotalPurchaseAmt) }} | {{ \Helper::customAmountFormat($patienttotalProfitAmt) }} | {{ \Helper::customAmountFormat(($patienttotalProfitAmt / $patienttotalSaleAmt) * 100) . '%' }} | {{ \Helper::customAmountFormat(($patienttotalProfitAmt / $patienttotalPurchaseAmt) * 100) . '%' }} | |||||||||
| Entity Total : | {{ \Helper::customAmountFormat($entitytotalSaleMrp) }} | {{ \Helper::customAmountFormat($entitytotalSaleAmt) }} | {{ \Helper::customAmountFormat($entitytotalPurchaseAmt) }} | {{ \Helper::customAmountFormat($entitytotalProfitAmt) }} | {{ \Helper::customAmountFormat(($entitytotalProfitAmt / $entitytotalSaleAmt) * 100) . '%' }} | {{ \Helper::customAmountFormat(($entitytotalProfitAmt / $entitytotalPurchaseAmt) * 100) . '%' }} | |||||||||
| Entity : {{ $entity_name }} | |||||||||||||||
| Patient : {{ $patient_id . ' / ' . $patient_name }} IP ID : {{ $ipd_reg_id }} | Discharge Date : @if ($profit->discharge_date!="0000-00-00") {{ \Helper::getDisplayDate($profit->discharge_date) }} @endif | ||||||||||||||
| {{ $headerSr++ }} | {{ $profit->trn_type. "/". $profit->trn_fyear. "/" . $profit->trn_id }} | {{ \Helper::getDisplayDate($profit->trn_date) }} | {{ $profit->is_credit_bill=="N"?'CASH':'' }} | {{ \Helper::customAmountFormat($totalSaleMrp) }} | {{ \Helper::customAmountFormat($totalSaleAmt) }} | {{ \Helper::customAmountFormat($totalPurchaseAmt) }} | {{ \Helper::customAmountFormat($totalProfitAmt) }} | {{ \Helper::customAmountFormat(($totalProfitAmt / $totalSaleAmt) * 100) . '%' }} | {{ \Helper::customAmountFormat(($totalProfitAmt / $totalPurchaseAmt) * 100) . '%' }} | ||||||
| Patient Total : | {{ \Helper::customAmountFormat($patienttotalSaleMrp) }} | {{ \Helper::customAmountFormat($patienttotalSaleAmt) }} | {{ \Helper::customAmountFormat($patienttotalPurchaseAmt) }} | {{ \Helper::customAmountFormat($patienttotalProfitAmt) }} | {{ \Helper::customAmountFormat(($patienttotalProfitAmt / $patienttotalSaleAmt) * 100) . '%' }} | {{ \Helper::customAmountFormat(($patienttotalProfitAmt / $patienttotalPurchaseAmt) * 100) . '%' }} | |||||||||
| Entity Total : | {{ \Helper::customAmountFormat($entitytotalSaleMrp) }} | {{ \Helper::customAmountFormat($entitytotalSaleAmt) }} | {{ \Helper::customAmountFormat($entitytotalPurchaseAmt) }} | {{ \Helper::customAmountFormat($entitytotalProfitAmt) }} | {{ \Helper::customAmountFormat(($entitytotalProfitAmt / $entitytotalSaleAmt) * 100) . '%' }} | {{ \Helper::customAmountFormat(($entitytotalProfitAmt / $entitytotalPurchaseAmt) * 100) . '%' }} | |||||||||
| Bill Total : | {{ \Helper::customAmountFormat($grossTotalSaleMrp) }} | {{ \Helper::customAmountFormat($grossTotalSaleAmt) }} | {{ \Helper::customAmountFormat($grossTotalPurchaseAmt) }} | {{ \Helper::customAmountFormat($grossTotalProfitAmt) }} | {{ \Helper::customAmountFormat(($grossTotalProfitAmt / $grossTotalSaleAmt) * 100) . '%' }} | {{ \Helper::customAmountFormat(($grossTotalProfitAmt / $grossTotalPurchaseAmt) * 100) . '%' }} | |||||||||
| {{ strtoupper(Session::get('userId')) . ' # ' . $currentTime->format('d/m/Y H:i:s ') }} | |||||||||||||||
| Entity Wise Summery | IP Bill Period : {{ \Helper::getDisplayDate($fromdate) }} TO {{ \Helper::getDisplayDate($todate) }} | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Entity Name | Sales Amt MRP | Cash Bill Total | Credit Bill Total | Sales Amt | Purchase Amt | Gross Profit Amt | Hospital Share | Pharmacy Share | Gross Sales Margin % | Gross Profit % | |||||||||
| Total : | {{ \Helper::customAmountFormat($summSelesTotal) }} | {{ \Helper::customAmountFormat($summCashBillTotal) }} | {{ \Helper::customAmountFormat($summCreditBIllTotal) }} | {{ \Helper::customAmountFormat($summATotal) }} | {{ \Helper::customAmountFormat($summBTotal) }} | {{ \Helper::customAmountFormat($summATotal-$summBTotal) }} | {{ \Helper::customAmountFormat($summDTotal) }} | {{ \Helper::customAmountFormat($summETotal) }} | {{ \Helper::customAmountFormat((($summATotal-$summBTotal)/$summATotal)*100)."%" }} | {{ \Helper::customAmountFormat((($summATotal-$summBTotal)/$summBTotal)*100).'%' }} | |||||||||
| {{$additionalInfo}} | (A) | (B) | (C = A - B) | {{$hospitalSharePercent}}% | {{$pharmacySharePercent}}% | (D= (C / A) * 100) | (E = (C / B) * 100) | ||||||||||||
| {{ $bEntityName }} | {{ \Helper::customAmountFormat($summ_mrp) }} | {{ \Helper::customAmountFormat($summ_cashbill) }} | {{ \Helper::customAmountFormat($summ_creditbill) }} | {{ \Helper::customAmountFormat($A) }} | {{ \Helper::customAmountFormat($B) }} | {{ \Helper::customAmountFormat($C) }} | {{ \Helper::customAmountFormat($D) }} | {{ \Helper::customAmountFormat($E) }} | {{ \Helper::customAmountFormat($F)."%" }} | {{ \Helper::customAmountFormat($G).'%' }} | |||||||||
| Total : | {{ \Helper::customAmountFormat($summSelesTotal) }} | {{ \Helper::customAmountFormat($summCashBillTotal) }} | {{ \Helper::customAmountFormat($summCreditBIllTotal) }} | {{ \Helper::customAmountFormat($summATotal) }} | {{ \Helper::customAmountFormat($summBTotal) }} | {{ \Helper::customAmountFormat($summATotal-$summBTotal) }} | {{ \Helper::customAmountFormat((($summATotal-$summBTotal)*$hospitalSharePercent)/100) }} | {{ \Helper::customAmountFormat((($summATotal-$summBTotal)*$pharmacySharePercent)/100) }} | {{ \Helper::customAmountFormat((($summATotal-$summBTotal)/$summATotal)*100)."%" }} | {{ \Helper::customAmountFormat((($summATotal-$summBTotal)/$summBTotal)*100).'%' }} | |||||||||
| Grand Total : | {{ \Helper::customAmountFormat($grandTotalSales) }} | {{ \Helper::customAmountFormat($grandTotalCashBill) }} | {{ \Helper::customAmountFormat($grandTotalCreditBill) }} | {{ \Helper::customAmountFormat($grandTotalA) }} | {{ \Helper::customAmountFormat($grandTotalB) }} | {{ \Helper::customAmountFormat($grandTotalC) }} | {{ \Helper::customAmountFormat($grandTotalD) }} | {{ \Helper::customAmountFormat($grandTotalE) }} | {{ \Helper::customAmountFormat((($grandTotalA-$grandTotalB)/$grandTotalA)*100)."%" }} | {{ \Helper::customAmountFormat((($grandTotalA-$grandTotalB)/$grandTotalB)*100).'%' }} | |||||||||
| {{ strtoupper(Session::get('userId')) . ' # ' . $currentTime->format('d/m/Y H:i:s ') }} | |||||||||||||||||||