@extends('Reports.template')

<!--Title-->
@section('title')
    @if ($rateType == 'W')
        @php
            $reportTitle = 'Patient Wise Gross Profit & Sales Margin Details - With GST';
        @endphp
    @else
        @php
            $reportTitle = 'Patient Wise Gross Profit & Sales Margin Details - Without GST';
        @endphp
    @endif
    {{ $reportTitle }}
@endsection
<!--Title Close-->

<!--External CSS-->
@section('ExternalCss')
    @parent
@endsection
@section('Content')
    <table class="table table-responsive" style="border-top:none; border-bottom:1px solid #000; font-size:12px;">
        <thead>
            <tr>
                <th colspan="2" class="borderNone borderBottom" style="vertical-align:center;">
                    @if ($businessEntityMasterData[0]->logo != null)
                        <!--Image-->
                        <img class="img-responsive" alt="Pharmacy Logo"
                            src="{{ 'data:image/jpeg;base64,' . base64_encode($businessEntityMasterData[0]->logo) }}" />
                    @endif
                </th>
                <th colspan="14" class="borderNone borderBottom txtLeft">
                    <div style="line-height:1.0;" class="heading">{{ $businessEntityMasterData[0]->name }}</div>
                    <div style="line-height:1.0;">
                        {{ $businessEntityMasterData[0]->add1 . ' ' . $businessEntityMasterData[0]->add2 . ' ' . $businessEntityMasterData[0]->city . ' : ' . $businessEntityMasterData[0]->pincode }}
                    </div>
                    <div style="line-height:1.0;">{{ 'Phone : ' . $businessEntityMasterData[0]->tel1 }}</div>
                </th>
            </tr>
            @php
                $currentTime = \Carbon\Carbon::now();
            @endphp
            <tr>
                <th colspan="6" class="th borderNone borderBottom reportTitle">{{ $reportTitle }}</th>
                <th colspan="4" class="txtRight th borderNone borderBottom">IP Bill Period :
                    {{ \Helper::getDisplayDate($fromdate) }} TO {{ \Helper::getDisplayDate($todate) }}</th>
            </tr>
            <tr>
                <th width="4%" class="th noPadding alignTop borderTopBottomGray txtLeft">&emsp;Sr No.</th>
                <th class="th noPadding alignTop borderTopBottomGray">&emsp;Trn No</th>
                <th class="th noPadding alignTop borderTopBottomGray">Trn Date</th>
                <th class="th noPadding alignTop borderTopBottomGray">Bill Type</th>
                @if ($Report_Type == 'D')
                    <th colspan="4" class="th noPadding alignTop borderTopBottomGray txtRight"></th>
                @else
                    <th width="10%" class="th notBold noPadding alignTop borderTopBottomGray txtRight">Sale Amt MRP</th>
                    @if ($rateType == 'W')
                        <th width="10%" class="th notBold noPadding alignTop borderTopBottomGray txtRight">Sale Amt With GST</th>
                        <th width="10%" class="th notBold noPadding alignTop borderTopBottomGray txtRight">Purchase Amt With GST</th>
                    @else
                        <th width="10%" class="th notBold noPadding alignTop borderTopBottomGray txtRight">Sale Amt Without GST</th>
                        <th width="10%" class="th notBold noPadding alignTop borderTopBottomGray txtRight">Purchase Amt Without GST</th>
                    @endif
                    <th width="10%" class="th notBold noPadding alignTop borderTopBottomGray txtRight">Gross Profit Amt</th>
                    <th width="10%" class="th notBold noPadding alignTop borderTopBottomGray txtRight">Gross Sales Margin %
                    </th>
                    <th width="10%" class="th notBold noPadding alignTop borderTopBottomGray txtRight">Gross Profit %</th>
                @endif
            </tr>
            @if ($Report_Type == 'D')
                <tr>
                    <th rowspan="2" width="4%" class="th notBold noPadding alignTop borderTopBottom txtRight">Sr No.</th>
                    <th rowspan="2" width="10%" class="th notBold noPadding alignTop borderTopBottom">&emsp;Product Name
                    </th>
                    <th rowspan="2" width="10%" class="th notBold noPadding alignTop borderTopBottom txtRight">Sale Qty
                    </th>
                    <th rowspan="2" width="10%" class="th notBold noPadding alignTop borderTopBottom txtRight">Sale Amt MRP</th>
                    <th width="10%" class="th notBold noPadding alignTop borderTopBottomGray txtRight">Sale Amt</th>
                    <th width="10%" class="th notBold noPadding alignTop borderTopBottomGray txtRight">Purchase Amt</th>
                    <th width="10%" class="th notBold noPadding alignTop borderTopBottomGray txtRight">Gross Profit Amt</th>
                    <th width="10%" class="th notBold noPadding alignTop borderTopBottomGray txtRight">Gross Sales Margin %
                    </th>
                    <th width="10%" class="th notBold noPadding alignTop borderTopBottomGray txtRight">Gross Profit %</th>
                </tr>
                <tr>
                    <th width="10%" class="th notBold noPadding alignTop borderTopBottom txtRight">(A)</th>
                    <th width="10%" class="th notBold noPadding alignTop borderTopBottom txtRight">(B)</th>
                    <th width="10%" class="th notBold noPadding alignTop borderTopBottom txtRight">(C = A - B)</th>
                    <th width="10%" class="th notBold noPadding alignTop borderTopBottom txtRight">(D = (C / A) * 100)</th>
                    <th width="10%" class="th notBold noPadding alignTop borderTopBottom txtRight">(E = (C / B) * 100)</th>
                </tr>
            @else
                <tr>
                    <th rowspan="2" width="4%" class="th notBold noPadding alignTop borderTopBottom txtRight"></th>
                    <th rowspan="2" width="10%" class="th notBold noPadding alignTop borderTopBottom"></th>
                    <th rowspan="2" width="10%" class="th notBold noPadding alignTop borderTopBottom txtRight"></th>
                    <th rowspan="2" width="10%" class="th notBold noPadding alignTop borderTopBottom txtRight"></th>
                    <th width="10%" class="th notBold noPadding alignTop borderTopBottomGray txtRight"></th>
                    <th width="10%" class="th notBold noPadding alignTop borderTopBottomGray txtRight"></th>
                    <th width="10%" class="th notBold noPadding alignTop borderTopBottomGray txtRight"></th>
                    <th width="10%" class="th notBold noPadding alignTop borderTopBottomGray txtRight"></th>
                    <th width="10%" class="th notBold noPadding alignTop borderTopBottomGray txtRight"></th>
                </tr>
                <tr>
                    <td class="td bold alignTop txtRight borderTopBottom"></td>
                    <th width="10%" class="th notBold noPadding alignTop borderTopBottom txtRight">(A)</th>
                    <th width="10%" class="th notBold noPadding alignTop borderTopBottom txtRight">(B)</th>
                    <th width="10%" class="th notBold noPadding alignTop borderTopBottom txtRight">(C = A - B)</th>
                    <th width="10%" class="th notBold noPadding alignTop borderTopBottom txtRight">(D = (C / A) * 100)</th>
                    <th width="10%" class="th notBold noPadding alignTop borderTopBottom txtRight">(E = (C / B) * 100)</th>
                </tr>
            @endif
        </thead>
        <tbody>
            @php
                $oldTrnType = '';
                $oldTrnId = '';
                $oldEntity = '';
                $oldPatient = '';
                $headerSr = 1;
                $transactionSr = 1;
                $totalSaleMrp = 0;
                $totalSaleAmt = 0;
                $totalPurchaseAmt = 0;
                $totalProfitAmt = 0;
                $grossTotalSaleMrp = 0;
                $grossTotalSaleAmt = 0;
                $grossTotalPurchaseAmt = 0;
                $grossTotalProfitAmt = 0;
                $negativeBold = 0;
                $patient_id = '';
                $patient_name = '';
                $ipd_reg_id = '';
                $entity_name = '';
                $patienttotalSaleMrp=0;
                $patienttotalSaleAmt = 0;
                $patienttotalPurchaseAmt = 0;
                $patienttotalProfitAmt = 0;
                $entitytotalSaleMrp=0;
                $entitytotalSaleAmt = 0;
                $entitytotalPurchaseAmt = 0;
                $entitytotalProfitAmt = 0;
            @endphp
            @if ($Report_Type == 'D')
                @if (!empty($productProfit))
                    @foreach ($productProfit as $profit)
                        @php
                            if (!empty($fromdate)) {
                                $patient_id = $profit->patient_id;
                                $patient_name = $profit->patient_name;
                                $ipd_reg_id = $profit->ipd_reg_id;
                                $entity_name = $profit->entity_name;
                            } elseif (!empty($patientData)) {
                                $patient_id = $patientData->patient_id;
                                $patient_name = $patientData->patient_name;
                                $ipd_reg_id = $patientData->ipd_reg_id;
                                $entity_name = $patientData->entity_name;
                            }
                        @endphp
                        @if ($profit->trn_type != $oldTrnType || $profit->trn_id != $oldTrnId)
                            @if ($headerSr > 1)
                                <tr>
                                    <td colspan="3" class="td bold borderNone txtRight"> Total : </td>
                                    <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totalSaleMrp) }}</td>
                                    <td class="td bold alignTop txtRight borderTopBottom">
                                        {{ \Helper::customAmountFormat($totalSaleAmt) }}</td>
                                    <td class="td bold alignTop txtRight borderTopBottom">
                                        {{ \Helper::customAmountFormat($totalPurchaseAmt) }}</td>
                                    <td class="td bold alignTop txtRight borderTopBottom">
                                        {{ \Helper::customAmountFormat($totalProfitAmt) }}</td>
                                    @if ($totalSaleAmt != 0)
                                        <td class="td bold alignTop txtRight borderTopBottom">
                                            {{ \Helper::customAmountFormat(($totalProfitAmt / $totalSaleAmt) * 100) . '%' }}
                                        </td>
                                    @else
                                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                                    @endif

                                    @if ($totalPurchaseAmt != 0)
                                        <td class="td bold alignTop txtRight borderTopBottom">
                                            {{ \Helper::customAmountFormat(($totalProfitAmt / $totalPurchaseAmt) * 100) . '%' }}
                                        </td>
                                    @else
                                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                                    @endif
                                </tr>
                            @endif
                            @if ($headerSr > 1 && $patient_id != $oldPatient)
                                <tr>
                                    <td colspan="3" class="td bold borderNone txtRight"> Patient Total : </td>
                                    <td class="td bold alignTop txtRight borderTopBottom">
                                        {{ \Helper::customAmountFormat($patienttotalSaleMrp) }}</td>
                                    <td class="td bold alignTop txtRight borderTopBottom">
                                        {{ \Helper::customAmountFormat($patienttotalSaleAmt) }}</td>
                                    <td class="td bold alignTop txtRight borderTopBottom">
                                        {{ \Helper::customAmountFormat($patienttotalPurchaseAmt) }}</td>
                                    <td class="td bold alignTop txtRight borderTopBottom">
                                        {{ \Helper::customAmountFormat($patienttotalProfitAmt) }}</td>
                                    @if ($patienttotalSaleAmt != 0)
                                        <td class="td bold alignTop txtRight borderTopBottom">
                                            {{ \Helper::customAmountFormat(($patienttotalProfitAmt / $patienttotalSaleAmt) * 100) . '%' }}
                                        </td>
                                    @else
                                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                                    @endif

                                    @if ($patienttotalPurchaseAmt != 0)
                                        <td class="td bold alignTop txtRight borderTopBottom">
                                            {{ \Helper::customAmountFormat(($patienttotalProfitAmt / $patienttotalPurchaseAmt) * 100) . '%' }}
                                        </td>
                                    @else
                                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                                    @endif
                                </tr>
                            @endif
                            @if ($headerSr > 1 && $entity_name != $oldEntity && $ipId=='')
                                <tr>
                                    <td colspan="3" class="td bold borderNone txtRight"> Entity Total : </td>
                                    <td class="td bold alignTop txtRight borderTopBottom">
                                        {{ \Helper::customAmountFormat($entitytotalSaleMrp) }}</td>
                                    <td class="td bold alignTop txtRight borderTopBottom">
                                        {{ \Helper::customAmountFormat($entitytotalSaleAmt) }}</td>
                                    <td class="td bold alignTop txtRight borderTopBottom">
                                        {{ \Helper::customAmountFormat($entitytotalPurchaseAmt) }}</td>
                                    <td class="td bold alignTop txtRight borderTopBottom">
                                        {{ \Helper::customAmountFormat($entitytotalProfitAmt) }}</td>
                                    @if ($entitytotalSaleAmt != 0)
                                        <td class="td bold alignTop txtRight borderTopBottom">
                                            {{ \Helper::customAmountFormat(($entitytotalProfitAmt / $entitytotalSaleAmt) * 100) . '%' }}
                                        </td>
                                    @else
                                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                                    @endif

                                    @if ($entitytotalPurchaseAmt != 0)
                                        <td class="td bold alignTop txtRight borderTopBottom">
                                            {{ \Helper::customAmountFormat(($entitytotalProfitAmt / $entitytotalPurchaseAmt) * 100) . '%' }}
                                        </td>
                                    @else
                                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                                    @endif
                                </tr>
                            @endif
                            @php
                                $transactionSr = 1;
                                $totalSaleAmt = 0;
                                $totalSaleMrp = 0;
                                $totalPurchaseAmt = 0;
                                $totalProfitAmt = 0;
                                $negativeBold = 0;
                            @endphp
                            @if ($entity_name != '' && $entity_name != $oldEntity && $ipId=='')
                                @php
                                    $entitytotalSaleMrp = 0;
                                    $entitytotalSaleAmt = 0;
                                    $entitytotalPurchaseAmt = 0;
                                    $entitytotalProfitAmt = 0;
                                @endphp
                                <tr>
                                    <th colspan="9" class="txtleft th borderNone borderBottom">
                                        Entity :
                                        {{ $entity_name }}
                                    </th>
                                </tr>
                            @endif
                            @if ($patient_id != '' && $patient_id != $oldPatient)
                                @php
                                    $patienttotalSaleMrp=0;
                                    $patienttotalSaleAmt = 0;
                                    $patienttotalPurchaseAmt = 0;
                                    $patienttotalProfitAmt = 0;
                                @endphp
                                <tr>
                                    <th colspan="7" class="txtleft th borderNone borderBottom">
                                        Patient :
                                        {{ $patient_id . ' / ' . $patient_name }} &emsp; IP ID :
                                        {{ $ipd_reg_id }}
                                    </th>
                                    @if($ipId=='')
                                    <th colspan="2" class="txtRight th borderNone borderBottom">
                                        Discharge Date :
                                        @if ($profit->discharge_date!="0000-00-00")
                                            {{ \Helper::getDisplayDate($profit->discharge_date) }}
                                        @endif
                                    </th>
                                    @endif
                                </tr>
                            @endif
                            <tr>
                                <td class="td bold alignTop borderTopBottom txtLeft">&emsp;{{ $headerSr++ }}</td>
                                <td class="td bold alignTop borderTopBottom">&emsp;{{ $profit->trn_type. "/". $profit->trn_fyear. "/" . $profit->trn_id }}
                                </td>
                                <td class="td bold alignTop borderTopBottom">{{ \Helper::getDisplayDate($profit->trn_date) }}
                                </td>
                                <td class="td bold alignTop borderTopBottom">{{ $profit->is_credit_bill=="N"?'CASH':'' }}</td>
                                <td colspan="5" class="td bold alignTop borderTopBottom txtRight"></td>
                            </tr>
                        @endif

                        @php
                            $profitAmt = $profit->sale_amt - $profit->pur_amt;
                            if ($profit->pur_amt != 0) {
                                $ProfitPer = ($profitAmt / $profit->pur_amt) * 100;
                            }
                            if ($profit->sale_amt != 0) {
                                $MarginPer = ($profitAmt / $profit->sale_amt) * 100;
                            }
                            if ($profitAmt < '0') {
                                $negativeBold = 'td bold alignTop borderTopGray txtRight';
                            } else {
                                $negativeBold = 'td notBold alignTop borderTopGray txtRight';
                            }
                            if ($ProfitPer < '0') {
                                $negativeBoldPer = 'td bold alignTop borderTopGray txtRight';
                            } else {
                                $negativeBoldPer = 'td notBold alignTop borderTopGray txtRight';
                            }
                            if ($MarginPer < '0') {
                                $negativeBoldMargin = 'td bold alignTop borderTopGray txtRight';
                            } else {
                                $negativeBoldMargin = 'td notBold alignTop borderTopGray txtRight';
                            }
                        @endphp
                        <tr>
                            <td class="td notBold alignTop borderTopGray txtRight">{{ $transactionSr++ }}</td>
                            <td class="td notBold alignTop borderTopGray">&emsp;{{ $profit->product_name }}</td>
                            <td class="td notBold alignTop borderTopGray txtRight">{{ $profit->quantity }}</td>
                            <td class="td notBold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat($profit->mrp) }}</td>
                            <td class="td notBold alignTop borderTopGray txtRight">
                                {{ \Helper::customAmountFormat($profit->sale_amt) }}</td>
                            <td class="td notBold alignTop borderTopGray txtRight">
                                {{ \Helper::customAmountFormat($profit->pur_amt) }}</td>
                            <td class="{{ $negativeBold }}">{{ \Helper::customAmountFormat($profitAmt) }}</td>
                            <td class="{{ $negativeBoldMargin }}">{{ \Helper::customAmountFormat($MarginPer) . '%' }}</td>
                            <td class="{{ $negativeBoldPer }}">{{ \Helper::customAmountFormat($ProfitPer) . '%' }}</td>
                        </tr>
                        @php
                            $totalSaleMrp += $profit->mrp;
                            $totalSaleAmt += $profit->sale_amt;
                            $totalPurchaseAmt += $profit->pur_amt;
                            $totalProfitAmt += $profitAmt;
                            
                            if ($patient_id != '') {
                                $patienttotalSaleMrp += $profit->mrp;
                                $patienttotalSaleAmt += $profit->sale_amt;
                                $patienttotalPurchaseAmt += $profit->pur_amt;
                                $patienttotalProfitAmt += $profitAmt;
                            }
                            $entitytotalSaleMrp += $profit->mrp;
                            $entitytotalSaleAmt += $profit->sale_amt;
                            $entitytotalPurchaseAmt += $profit->pur_amt;
                            $entitytotalProfitAmt += $profitAmt;
                            $grossTotalSaleMrp += $profit->mrp;
                            $grossTotalSaleAmt += $profit->sale_amt;
                            $grossTotalPurchaseAmt += $profit->pur_amt;
                            $grossTotalProfitAmt += $profitAmt;
                            $oldTrnType = $profit->trn_type;
                            $oldTrnId = $profit->trn_id;
                            if ($patient_id != '') {
                                $oldPatient = $patient_id;
                                $oldEntity = $entity_name;
                            }
                        @endphp
                    @endforeach
                @endif
                <tr>
                    <td class="td bold alignTop txtRight borderNone"></td>
                    <td colspan="2" class="td bold borderNone txtRight"> Total : </td>
                    <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totalSaleMrp) }}</td>
                    <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totalSaleAmt) }}</td>
                    <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totalPurchaseAmt) }}
                    </td>
                    <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totalProfitAmt) }}
                    </td>
                    @if ($totalSaleAmt != 0)
                        <td class="td bold alignTop txtRight borderTopBottom">
                            {{ \Helper::customAmountFormat(($totalProfitAmt / $totalSaleAmt) * 100) . '%' }}</td>
                    @else
                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                    @endif
                    @if ($totalPurchaseAmt != 0)
                        <td class="td bold alignTop txtRight borderTopBottom">
                            {{ \Helper::customAmountFormat(($totalProfitAmt / $totalPurchaseAmt) * 100) . '%' }}</td>
                    @else
                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                    @endif
                <tr>
                @if ($patient_id != '')
                    <tr>
                        <td colspan="3" class="td bold borderTopBottom txtRight"> Patient Total : </td>
                        <td class="td bold alignTop txtRight borderTopBottom">
                            {{ \Helper::customAmountFormat($patienttotalSaleMrp) }}
                        </td>
                        <td class="td bold alignTop txtRight borderTopBottom">
                            {{ \Helper::customAmountFormat($patienttotalSaleAmt) }}
                        </td>
                        <td class="td bold alignTop txtRight borderTopBottom">
                            {{ \Helper::customAmountFormat($patienttotalPurchaseAmt) }}</td>
                        <td class="td bold alignTop txtRight borderTopBottom">
                            {{ \Helper::customAmountFormat($patienttotalProfitAmt) }}</td>
                        @if ($patienttotalSaleAmt != 0)
                            <td class="td bold alignTop txtRight borderTopBottom">
                                {{ \Helper::customAmountFormat(($patienttotalProfitAmt / $patienttotalSaleAmt) * 100) . '%' }}</td>
                        @else
                            <td class="td bold alignTop txtRight borderTopBottom"></td>
                        @endif
                        @if ($patienttotalPurchaseAmt != 0)
                            <td class="td bold alignTop txtRight borderTopBottom">
                                {{ \Helper::customAmountFormat(($patienttotalProfitAmt / $patienttotalPurchaseAmt) * 100) . '%' }}
                            </td>
                        @else
                            <td class="td bold alignTop txtRight borderTopBottom"></td>
                        @endif
                    <tr>
                @endif
                @if ($entity_name != '' && $ipId=='')
                    <tr>
                        <td colspan="3" class="td bold borderNone txtRight"> Entity Total : </td>
                        <td class="td bold alignTop txtRight borderTopBottom">
                            {{ \Helper::customAmountFormat($entitytotalSaleMrp) }}</td>
                        <td class="td bold alignTop txtRight borderTopBottom">
                            {{ \Helper::customAmountFormat($entitytotalSaleAmt) }}</td>
                        <td class="td bold alignTop txtRight borderTopBottom">
                            {{ \Helper::customAmountFormat($entitytotalPurchaseAmt) }}</td>
                        <td class="td bold alignTop txtRight borderTopBottom">
                            {{ \Helper::customAmountFormat($entitytotalProfitAmt) }}</td>
                        @if ($entitytotalSaleAmt != 0)
                            <td class="td bold alignTop txtRight borderTopBottom">
                                {{ \Helper::customAmountFormat(($entitytotalProfitAmt / $entitytotalSaleAmt) * 100) . '%' }}
                            </td>
                        @else
                            <td class="td bold alignTop txtRight borderTopBottom"></td>
                        @endif

                        @if ($entitytotalPurchaseAmt != 0)
                            <td class="td bold alignTop txtRight borderTopBottom">
                                {{ \Helper::customAmountFormat(($entitytotalProfitAmt / $entitytotalPurchaseAmt) * 100) . '%' }}
                            </td>
                        @else
                            <td class="td bold alignTop txtRight borderTopBottom"></td>
                        @endif
                    </tr>
                @endif
                <tr>
                    <td colspan="3" class="td bold borderTopBottom txtRight"> Bill Total : </td>
                    <td class="td bold alignTop txtRight borderTopBottom">
                        {{ \Helper::customAmountFormat($grossTotalSaleMrp) }}
                    </td>
                    <td class="td bold alignTop txtRight borderTopBottom">
                        {{ \Helper::customAmountFormat($grossTotalSaleAmt) }}
                    </td>
                    <td class="td bold alignTop txtRight borderTopBottom">
                        {{ \Helper::customAmountFormat($grossTotalPurchaseAmt) }}</td>
                    <td class="td bold alignTop txtRight borderTopBottom">
                        {{ \Helper::customAmountFormat($grossTotalProfitAmt) }}</td>
                    @if ($grossTotalSaleAmt != 0)
                        <td class="td bold alignTop txtRight borderTopBottom">
                            {{ \Helper::customAmountFormat(($grossTotalProfitAmt / $grossTotalSaleAmt) * 100) . '%' }}</td>
                    @else
                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                    @endif
                    @if ($grossTotalPurchaseAmt != 0)
                        <td class="td bold alignTop txtRight borderTopBottom">
                            {{ \Helper::customAmountFormat(($grossTotalProfitAmt / $grossTotalPurchaseAmt) * 100) . '%' }}</td>
                    @else
                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                    @endif
                <tr>
            @else
                @if (!empty($productProfit))
                    @foreach ($productProfit as $profit)
                        @php
                            if (!empty($fromdate)) {
                                $patient_id = $profit->patient_id;
                                $patient_name = $profit->patient_name;
                                $ipd_reg_id = $profit->ipd_reg_id;
                                $entity_name = $profit->entity_name;
                            } elseif (!empty($patientData)) {
                                $patient_id = $patientData->patient_id;
                                $patient_name = $patientData->patient_name;
                                $ipd_reg_id = $patientData->ipd_reg_id;
                                $entity_name = $patientData->entity_name;
                            }
                        @endphp
                        @if ($profit->trn_type != $oldTrnType || $profit->trn_id != $oldTrnId)
                            @if ($headerSr > 1)
                                    <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totalSaleMrp) }}</td>
                                    <td class="td bold alignTop txtRight borderTopBottom">
                                        {{ \Helper::customAmountFormat($totalSaleAmt) }}</td>
                                    <td class="td bold alignTop txtRight borderTopBottom">
                                        {{ \Helper::customAmountFormat($totalPurchaseAmt) }}</td>
                                    <td class="td bold alignTop txtRight borderTopBottom">
                                        {{ \Helper::customAmountFormat($totalProfitAmt) }}</td>
                                    @if ($totalSaleAmt != 0)
                                        <td class="td bold alignTop txtRight borderTopBottom">
                                            {{ \Helper::customAmountFormat(($totalProfitAmt / $totalSaleAmt) * 100) . '%' }}
                                        </td>
                                    @else
                                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                                    @endif

                                    @if ($totalPurchaseAmt != 0)
                                        <td class="td bold alignTop txtRight borderTopBottom">
                                            {{ \Helper::customAmountFormat(($totalProfitAmt / $totalPurchaseAmt) * 100) . '%' }}
                                        </td>
                                    @else
                                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                                    @endif
                                </tr>
                            @endif
                            @if ($headerSr > 1 && $patient_id != $oldPatient)
                                <tr>
                                    <td colspan="4" class="td bold borderNone txtRight"> Patient Total : </td>
                                    <td class="td bold alignTop txtRight borderTopBottom">
                                        {{ \Helper::customAmountFormat($patienttotalSaleMrp) }}</td>
                                    <td class="td bold alignTop txtRight borderTopBottom">
                                        {{ \Helper::customAmountFormat($patienttotalSaleAmt) }}</td>
                                    <td class="td bold alignTop txtRight borderTopBottom">
                                        {{ \Helper::customAmountFormat($patienttotalPurchaseAmt) }}</td>
                                    <td class="td bold alignTop txtRight borderTopBottom">
                                        {{ \Helper::customAmountFormat($patienttotalProfitAmt) }}</td>
                                    @if ($patienttotalSaleAmt != 0)
                                        <td class="td bold alignTop txtRight borderTopBottom">
                                            {{ \Helper::customAmountFormat(($patienttotalProfitAmt / $patienttotalSaleAmt) * 100) . '%' }}
                                        </td>
                                    @else
                                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                                    @endif

                                    @if ($patienttotalPurchaseAmt != 0)
                                        <td class="td bold alignTop txtRight borderTopBottom">
                                            {{ \Helper::customAmountFormat(($patienttotalProfitAmt / $patienttotalPurchaseAmt) * 100) . '%' }}
                                        </td>
                                    @else
                                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                                    @endif
                                </tr>
                            @endif
                            @if ($headerSr > 1 && $entity_name != $oldEntity && $ipId=='')
                                <tr>
                                    <td colspan="4" class="td bold borderNone txtRight"> Entity Total : </td>
                                    <td class="td bold alignTop txtRight borderTopBottom">
                                        {{ \Helper::customAmountFormat($entitytotalSaleMrp) }}</td>
                                    <td class="td bold alignTop txtRight borderTopBottom">
                                        {{ \Helper::customAmountFormat($entitytotalSaleAmt) }}</td>
                                    <td class="td bold alignTop txtRight borderTopBottom">
                                        {{ \Helper::customAmountFormat($entitytotalPurchaseAmt) }}</td>
                                    <td class="td bold alignTop txtRight borderTopBottom">
                                        {{ \Helper::customAmountFormat($entitytotalProfitAmt) }}</td>
                                    @if ($entitytotalSaleAmt != 0)
                                        <td class="td bold alignTop txtRight borderTopBottom">
                                            {{ \Helper::customAmountFormat(($entitytotalProfitAmt / $entitytotalSaleAmt) * 100) . '%' }}
                                        </td>
                                    @else
                                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                                    @endif

                                    @if ($entitytotalPurchaseAmt != 0)
                                        <td class="td bold alignTop txtRight borderTopBottom">
                                            {{ \Helper::customAmountFormat(($entitytotalProfitAmt / $entitytotalPurchaseAmt) * 100) . '%' }}
                                        </td>
                                    @else
                                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                                    @endif
                                </tr>
                            @endif
                            @php
                                $totalQty=0;
                                $transactionSr = 1;
                                $totalSaleAmt = 0;
                                $totalSaleMrp=0;
                                $totalPurchaseAmt = 0;
                                $totalProfitAmt = 0;
                                $negativeBold = 0;
                            @endphp
                            @if ($entity_name != '' && $entity_name != $oldEntity && $ipId=='')
                                @php
                                    $entitytotalSaleMrp=0;
                                    $entitytotalSaleAmt = 0;
                                    $entitytotalPurchaseAmt = 0;
                                    $entitytotalProfitAmt = 0;
                                @endphp
                                <tr>
                                    <th colspan="10" class="txtleft th borderNone borderBottom">
                                        Entity :
                                        {{ $entity_name }}
                                    </th>
                                </tr>
                            @endif
                            @if ($patient_id != '' && $patient_id != $oldPatient)
                                @php
                                    $patienttotalSaleMrp = 0;
                                    $patienttotalSaleAmt = 0;
                                    $patienttotalPurchaseAmt = 0;
                                    $patienttotalProfitAmt = 0;
                                @endphp
                                <tr>
                                    <th colspan="8" class="txtleft th borderNone borderBottom">
                                        Patient :
                                        {{ $patient_id . ' / ' . $patient_name }} &emsp; IP ID :
                                        {{ $ipd_reg_id }}
                                    </th>
                                    @if($ipId=='')
                                    <th colspan="2" class="txtRight th borderNone borderBottom">
                                        Discharge Date :
                                        @if ($profit->discharge_date!="0000-00-00")
                                            {{ \Helper::getDisplayDate($profit->discharge_date) }}
                                        @endif
                                    </th>
                                    @endif
                                </tr>
                            @endif
                            <tr>
                                <td class="td bold alignTop borderTopBottom txtLeft">&emsp;{{ $headerSr++ }}</td>
                                <td class="td bold alignTop borderTopBottom">&emsp;{{ $profit->trn_type. "/". $profit->trn_fyear. "/" . $profit->trn_id }}</td>
                                <td class="td bold alignTop borderTopBottom">{{ \Helper::getDisplayDate($profit->trn_date) }}</td>
                                <td class="td bold alignTop borderTopBottom">{{ $profit->is_credit_bill=="N"?'CASH':'' }}</td>
                        @endif

                        @php
                            $profitAmt = $profit->sale_amt - $profit->pur_amt;
                            if ($profit->pur_amt != 0) {
                                $ProfitPer = ($profitAmt / $profit->pur_amt) * 100;
                            }
                            if ($profit->sale_amt != 0) {
                                $MarginPer = ($profitAmt / $profit->sale_amt) * 100;
                            }
                            if ($profitAmt < '0') {
                                $negativeBold = 'td bold alignTop borderTopGray txtRight';
                            } else {
                                $negativeBold = 'td notBold alignTop borderTopGray txtRight';
                            }
                            if ($ProfitPer < '0') {
                                $negativeBoldPer = 'td bold alignTop borderTopGray txtRight';
                            } else {
                                $negativeBoldPer = 'td notBold alignTop borderTopGray txtRight';
                            }
                            if ($MarginPer < '0') {
                                $negativeBoldMargin = 'td bold alignTop borderTopGray txtRight';
                            } else {
                                $negativeBoldMargin = 'td notBold alignTop borderTopGray txtRight';
                            }
                            $totalSaleMrp += $profit->mrp;
                            $totalSaleAmt += $profit->sale_amt;
                            $totalPurchaseAmt += $profit->pur_amt;
                            $totalProfitAmt += $profitAmt;
                            
                            if ($patient_id != '') {
                                $patienttotalSaleMrp += $profit->mrp;
                                $patienttotalSaleAmt += $profit->sale_amt;
                                $patienttotalPurchaseAmt += $profit->pur_amt;
                                $patienttotalProfitAmt += $profitAmt;
                            }
                            $entitytotalSaleMrp += $profit->mrp;
                            $entitytotalSaleAmt += $profit->sale_amt;
                            $entitytotalPurchaseAmt += $profit->pur_amt;
                            $entitytotalProfitAmt += $profitAmt;
                            $grossTotalSaleMrp += $profit->mrp;
                            $grossTotalSaleAmt += $profit->sale_amt;
                            $grossTotalPurchaseAmt += $profit->pur_amt;
                            $grossTotalProfitAmt += $profitAmt;
                            $oldTrnType = $profit->trn_type;
                            $oldTrnId = $profit->trn_id;
                            if ($patient_id != '') {
                                $oldPatient = $patient_id;
                                $oldEntity = $entity_name;
                            }
                        @endphp
                    @endforeach
                @endif
                    <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totalSaleMrp) }}</td>
                    <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totalSaleAmt) }}</td>
                    <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totalPurchaseAmt) }}
                    </td>
                    <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totalProfitAmt) }}
                    </td>
                    @if ($totalSaleAmt != 0)
                        <td class="td bold alignTop txtRight borderTopBottom">
                            {{ \Helper::customAmountFormat(($totalProfitAmt / $totalSaleAmt) * 100) . '%' }}</td>
                    @else
                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                    @endif
                    @if ($totalPurchaseAmt != 0)
                        <td class="td bold alignTop txtRight borderTopBottom">
                            {{ \Helper::customAmountFormat(($totalProfitAmt / $totalPurchaseAmt) * 100) . '%' }}</td>
                    @else
                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                    @endif
                <tr>
                @if ($patient_id != '')
                    <tr>
                        <td colspan="4" class="td bold borderTopBottom txtRight"> Patient Total : </td>
                        <td class="td bold alignTop txtRight borderTopBottom">
                            {{ \Helper::customAmountFormat($patienttotalSaleMrp) }}
                        </td>
                        <td class="td bold alignTop txtRight borderTopBottom">
                            {{ \Helper::customAmountFormat($patienttotalSaleAmt) }}
                        </td>
                        <td class="td bold alignTop txtRight borderTopBottom">
                            {{ \Helper::customAmountFormat($patienttotalPurchaseAmt) }}</td>
                        <td class="td bold alignTop txtRight borderTopBottom">
                            {{ \Helper::customAmountFormat($patienttotalProfitAmt) }}</td>
                        @if ($patienttotalSaleAmt != 0)
                            <td class="td bold alignTop txtRight borderTopBottom">
                                {{ \Helper::customAmountFormat(($patienttotalProfitAmt / $patienttotalSaleAmt) * 100) . '%' }}</td>
                        @else
                            <td class="td bold alignTop txtRight borderTopBottom"></td>
                        @endif
                        @if ($patienttotalPurchaseAmt != 0)
                            <td class="td bold alignTop txtRight borderTopBottom">
                                {{ \Helper::customAmountFormat(($patienttotalProfitAmt / $patienttotalPurchaseAmt) * 100) . '%' }}
                            </td>
                        @else
                            <td class="td bold alignTop txtRight borderTopBottom"></td>
                        @endif
                    <tr>
                @endif
                @if ($entity_name != '' && $ipId=='')
                    <tr>
                        <td colspan="4" class="td bold borderNone txtRight"> Entity Total : </td>
                        <td class="td bold alignTop txtRight borderTopBottom">
                            {{ \Helper::customAmountFormat($entitytotalSaleMrp) }}</td>
                        <td class="td bold alignTop txtRight borderTopBottom">
                            {{ \Helper::customAmountFormat($entitytotalSaleAmt) }}</td>
                        <td class="td bold alignTop txtRight borderTopBottom">
                            {{ \Helper::customAmountFormat($entitytotalPurchaseAmt) }}</td>
                        <td class="td bold alignTop txtRight borderTopBottom">
                            {{ \Helper::customAmountFormat($entitytotalProfitAmt) }}</td>
                        @if ($entitytotalSaleAmt != 0)
                            <td class="td bold alignTop txtRight borderTopBottom">
                                {{ \Helper::customAmountFormat(($entitytotalProfitAmt / $entitytotalSaleAmt) * 100) . '%' }}
                            </td>
                        @else
                            <td class="td bold alignTop txtRight borderTopBottom"></td>
                        @endif

                        @if ($entitytotalPurchaseAmt != 0)
                            <td class="td bold alignTop txtRight borderTopBottom">
                                {{ \Helper::customAmountFormat(($entitytotalProfitAmt / $entitytotalPurchaseAmt) * 100) . '%' }}
                            </td>
                        @else
                            <td class="td bold alignTop txtRight borderTopBottom"></td>
                        @endif
                    </tr>
                @endif
                <tr>
                    <td colspan="4" class="td bold borderTopBottom txtRight"> Bill Total : </td>
                    <td class="td bold alignTop txtRight borderTopBottom">
                        {{ \Helper::customAmountFormat($grossTotalSaleMrp) }}
                    </td>
                    <td class="td bold alignTop txtRight borderTopBottom">
                        {{ \Helper::customAmountFormat($grossTotalSaleAmt) }}
                    </td>
                    <td class="td bold alignTop txtRight borderTopBottom">
                        {{ \Helper::customAmountFormat($grossTotalPurchaseAmt) }}</td>
                    <td class="td bold alignTop txtRight borderTopBottom">
                        {{ \Helper::customAmountFormat($grossTotalProfitAmt) }}</td>
                    @if ($grossTotalSaleAmt != 0)
                        <td class="td bold alignTop txtRight borderTopBottom">
                            {{ \Helper::customAmountFormat(($grossTotalProfitAmt / $grossTotalSaleAmt) * 100) . '%' }}</td>
                    @else
                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                    @endif
                    @if ($grossTotalPurchaseAmt != 0)
                        <td class="td bold alignTop txtRight borderTopBottom">
                            {{ \Helper::customAmountFormat(($grossTotalProfitAmt / $grossTotalPurchaseAmt) * 100) . '%' }}</td>
                    @else
                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                    @endif
                <tr>
            @endif
        </tbody>
        <tfoot>
            <td colspan="10" class="th smallFont noPadding alignTop borderTopBottom txtRight">
                {{ strtoupper(Session::get('userId')) . ' # ' . $currentTime->format('d/m/Y H:i:s ') }}</td>
        </tfoot>
    </table>
    
    <br>
    @if ($ipId=='')
        <table class="table table-responsive" style="border-top:none; border-bottom:1px solid #000; font-size:12px;">
            <thead>
                <tr>
                    <th colspan="10" class="th borderNone borderBottom reportTitle">Entity Wise Summery</th>
                    <th colspan="10" class="txtRight th borderNone borderBottom">IP Bill Period :
                        {{ \Helper::getDisplayDate($fromdate) }} TO {{ \Helper::getDisplayDate($todate) }}</th>
                </tr>
                <tr>
                    <th width="10%" class="th noPadding alignTop borderTop txtLeft">Entity Name</th>
                    <th width="5%" class="th noPadding alignTop borderTop txtRight">Sales Amt MRP</th>
                    <th width="2%" class="th noPadding alignTop borderTop txtLeft "></th>
                    <th width="5%" class="th noPadding alignTop borderTop txtRight">Cash Bill Total</th>
                    <th width="2%" class="th noPadding alignTop borderTop txtLeft "></th>
                    <th width="5%" class="th noPadding alignTop borderTop txtRight">Credit Bill Total</th>
                    <th width="2%" class="th noPadding alignTop borderTop txtLeft "></th>
                    <th width="5%" class="th noPadding alignTop borderTop txtRight ">Sales Amt</th>
                    <th width="2%" class="th noPadding alignTop borderTop txtLeft "></th>
                    <th width="5%" class="th noPadding alignTop borderTop txtRight ">Purchase Amt</th>
                    <th width="2%" class="th noPadding alignTop borderTop txtLeft "></th>
                    <th width="5%" class="th noPadding alignTop borderTop txtRight ">Gross Profit Amt</th>
                    <th width="2%" class="th noPadding alignTop borderTop txtLeft "></th>
                    <th width="5%" class="th noPadding alignTop borderTop txtRight ">Hospital Share</th>
                    <th width="2%" class="th noPadding alignTop borderTop txtLeft "></th>
                    <th width="5%" class="th noPadding alignTop borderTop txtRight ">Pharmacy Share</th>
                    <th width="2%" class="th noPadding alignTop borderTop txtLeft "></th>
                    <th width="7%" class="th noPadding alignTop borderTop txtRight ">Gross Sales Margin %	</th>
                    <th width="2%" class="th noPadding alignTop borderTop txtLeft "></th>
                    <th width="7%" class="th noPadding alignTop borderTop txtRight ">Gross Profit % </th>
                </tr>
                <tr>
                    <th colspan="7" class="th noPadding alignTop borderTop txtRight borderBottom"></th>
                    <th class="th noPadding alignTop borderTop txtRight borderBottom">(A)</th>
                    <th class="th noPadding alignTop borderTop txtLeft borderBottom"></th>
                    <th class="th noPadding alignTop borderTop txtRight borderBottom">(B)</th>
                    <th class="th noPadding alignTop borderTop txtLeft borderBottom"></th>
                    <th class="th noPadding alignTop borderTop txtRight borderBottom">(C = A - B)</th>
                    <th class="th noPadding alignTop borderTop txtLeft borderBottom"></th>
                    <th class="th noPadding alignTop borderTop txtRight borderBottom">85%</th>
                    <th class="th noPadding alignTop borderTop txtLeft borderBottom"></th>
                    <th class="th noPadding alignTop borderTop txtRight borderBottom">15%</th>
                    <th class="th noPadding alignTop borderTop txtLeft borderBottom"></th>
                    <th class="th noPadding alignTop borderTop txtRight borderBottom">(D= (C / A) * 100)</th>
                    <th class="th noPadding alignTop borderTop txtLeft borderBottom"></th>
                    <th class="th noPadding alignTop borderTop txtRight borderBottom">(E = (C / B) * 100)</th>
                </tr>
            </thead>
            <tbody>
                @if (!empty($productProfit))
                    @php
                        $qty=0;
                        $old_sr=0;
                        $mrp=0;
                        $cash_bill=0;
                        $credit_bill=0;
                        $totalcash_bill=0;
                        $totalcredit_bill=0;
                        $A=0;
                        $B=0;
                        
                        $totalmrp=0;
                        $totalA=0;
                        $totalB=0;

                        $next=-1;
                    @endphp
                    @foreach ($productProfit as $profit)
                        @php
                            if($next==-1)
                            {
                                $oldEntity=$productProfit[0]->entity_name;
                            }
                        @endphp
                        @php
                            $old_mrp=$profit->mrp;
                            $old_sale_amt=$profit->sale_amt;
                            $old_pur_amt=$profit->pur_amt;
                        @endphp
                        @if($profit->entity_name  == $oldEntity)
                            @php
                                $next=0;
                            @endphp
                        @else
                            @php
                                $next=1;
                            @endphp
                        @endif
                        @if($next==1)
                            <tr>
                                <th class="th  alignTop borderTop txtLeft borderBottomGray">{{ $oldEntity }}</th>
                                <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($mrp) }}</th>
                                <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                                <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($cash_bill) }}</th>
                                <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                                <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($credit_bill) }}</th>
                                <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                                <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($A) }}</th>
                                <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                                <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($B) }}</th>
                                <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                                <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($A-$B) }}</th>
                                <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                                <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat((($A-$B)*85)/100) }}</th>
                                <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                                <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat((($A-$B)*15)/100) }}</th>
                                <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                                <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat((($A-$B)/$A)*100)."%" }}</th>
                                <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                                <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat((($A-$B)/$B)*100).'%' }}</th>
                            </tr>
                            @php
                                $qty=0;
                                $mrp=0;
                                $cash_bill=0;
                                $credit_bill=0;
                                $A=0;
                                $B=0;
                            @endphp
                        @endif
                        @php
                            $mrp+=$old_mrp;
                            if($profit->is_credit_bill=="N")
                            {
                                $cash_bill+=$old_mrp;
                            }
                            else
                            {
                                $credit_bill+=$old_mrp;
                            }
                            $A += $old_sale_amt;
                            $B += $old_pur_amt;

                            $totalmrp+=$old_mrp;
                            if($profit->is_credit_bill=="N")
                            {
                                $totalcash_bill+=$old_mrp;
                            }
                            else
                            {
                                $totalcredit_bill+=$old_mrp;
                            }
                            $totalA+= $old_sale_amt;
                            $totalB+= $old_pur_amt;
                        
                            $oldEntity = $profit->entity_name;
                        @endphp
                    @endforeach
                    @if($next==0)
                        <tr>
                            <th class="th alignTop borderTop txtLeft borderBottom">{{ $oldEntity }}</th>
                            <th class="th alignTop borderTop txtRight borderBottom">{{ \Helper::customAmountFormat($mrp) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottom"></th>
                            <th class="th  alignTop borderTop txtRight borderBottom">{{ \Helper::customAmountFormat($cash_bill) }}</th>
                            <th class="th  alignTop borderTop txtLeft borderBottom"></th>
                            <th class="th  alignTop borderTop txtRight borderBottom">{{ \Helper::customAmountFormat($credit_bill) }}</th>
                            <th class="th  alignTop borderTop txtLeft borderBottom"></th>
                            <th class="th alignTop borderTop txtRight borderBottom">{{ \Helper::customAmountFormat($A) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottom"></th>
                            <th class="th alignTop borderTop txtRight borderBottom">{{ \Helper::customAmountFormat($B) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottom"></th>
                            <th class="th alignTop borderTop txtRight borderBottom">{{ \Helper::customAmountFormat($A-$B) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottom"></th>
                            <th class="th  alignTop borderTop txtRight borderBottom">{{ \Helper::customAmountFormat((($A-$B)*85)/100) }}</th>
                            <th class="th  alignTop borderTop txtLeft borderBottom"></th>
                            <th class="th  alignTop borderTop txtRight borderBottom">{{ \Helper::customAmountFormat((($A-$B)*15)/100) }}</th>
                            <th class="th  alignTop borderTop txtLeft borderBottom"></th>
                            <th class="th alignTop borderTop txtRight borderBottom">{{ \Helper::customAmountFormat((($A-$B)/$A)*100)."%" }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottom"></th>
                            <th class="th alignTop borderTop txtRight borderBottom">{{ \Helper::customAmountFormat((($A-$B)/$B)*100).'%' }}</th>
                        </tr>
                        <tr>
                            <th class="th alignTop borderTop txtRight borderBottomGray">Total : </th>
                            <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($totalmrp) }}</th>
                            <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($totalcash_bill) }}</th>
                            <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($totalcredit_bill) }}</th>
                            <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($totalA) }}</th>
                            <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($totalB) }}</th>
                            <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($totalA-$totalB) }}</th>
                            <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat((($totalA-$totalB)*85)/100) }}</th>
                            <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat((($totalA-$totalB)*15)/100) }}</th>
                            <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat((($totalA-$totalB)/$totalA)*100)."%" }}</th>
                            <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat((($totalA-$totalB)/$totalB)*100).'%' }}</th>
                        </tr>
                    @endif
                @endif
            <tfoot>
                <td colspan="20" class="th smallFont noPadding alignTop borderTopBottom txtRight">
                    {{ strtoupper(Session::get('userId')) . ' # ' . $currentTime->format('d/m/Y H:i:s ') }}</td>
            </tfoot>
        </table>
    @endif

    <!--Print-->
    <div class="col-xs-12" style="margin-bottom:15px;">
        <div class="col-xs-5 col-lg-offset-5 no-print">
            <button class="btn btn-sm btn-info" id="btnexport" data-myval="{{ $reportTitle }}">
                <span class="glyphicon glyphicon-download-alt"></span> Excel
            </button>
            <button onclick="print()" class="btn btn-sm btn-success no-print">
                <span class="glyphicon glyphicon-print"></span> Print
            </button>
            <a href="{{ url('Item/PatientWiseProfitReportInput') }}" class="no-print btn btn-danger btn-sm">
                <span class="glyphicon glyphicon-arrow-left"></span> Back
            </a>
        </div>
    </div>

@endsection

<!--Bootstrap Modals-->
@section('BootstrapModals')
@endsection
<!--Bootstrap Modals Close-->

<!--External JS-->
@section('ExternalJs')
@endsection
<!--External JS Close-->