@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>
            </thead>
            <tbody>
                @if (!empty($productProfitSummary))
                    @php
                        $summSelesTotal = $summCashBillTotal = $summCreditBIllTotal = $summATotal = $summBTotal = $summDTotal = $summETotal = 0;
                        $grandTotalSales = $grandTotalCashBill = $grandTotalCreditBill = $grandTotalA = $grandTotalB = 0;
                        $grandTotalC = $grandTotalD = $grandTotalE = 0;
                        $normalMarginHospital = 85;
                        $normalMarginPharmacy = 15;
                        $ptrMarginHospital = 75;
                        $ptrMarginPharmacy = 25;
                        $counter = 0;
                        $lastPtr = "";
                    @endphp
                    @foreach ($productProfitSummary as $productSummary)
                        @php 
                            $bEntityName = $productSummary->entity_name;
                            $ptrApplicable = $productSummary->is_ph_ptr_applicable;
                            $hospitalSharePercent = $ptrApplicable == "Y" ? $ptrMarginHospital : $normalMarginHospital;
                            $pharmacySharePercent = $ptrApplicable == "Y" ? $ptrMarginPharmacy : $normalMarginPharmacy;
                            
                            $summ_mrp = $productSummary->mrp;
                            $summ_cashbill =  0;
                            $summ_creditbill = $summ_mrp;
                            $A = $productSummary->sale_amt;
                            $B = $productSummary->pur_amt;
                            $C = $A-$B;
                            $D = (($A-$B)*$hospitalSharePercent)/100;
                            $E = (($A-$B)*$pharmacySharePercent)/100;
                            $F = (($A-$B)/$A)*100;
                            $G = (($A-$B)/$B)*100;
                            
                            $additionalInfo = $ptrApplicable == "N" ? "Non PM-JAY Patient" : "PM-JAY Patient";
                         @endphp
                         @if($ptrApplicable != $lastPtr)
                            @if($counter != 0)
                            <tr>
                                <th class="th alignTop borderTop txtRight borderBottomGray">Total : </th>
                                <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($summSelesTotal) }}</th>
                                <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                                <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($summCashBillTotal) }}</th>
                                <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                                <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($summCreditBIllTotal) }}</th>
                                <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                                <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($summATotal) }}</th>
                                <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                                <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($summBTotal) }}</th>
                                <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                                <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($summATotal-$summBTotal) }}</th>
                                <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                                <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($summDTotal) }}</th>
                                <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                                <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($summETotal) }}</th>
                                <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                                <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat((($summATotal-$summBTotal)/$summATotal)*100)."%" }}</th>
                                <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                                <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat((($summATotal-$summBTotal)/$summBTotal)*100).'%' }}</th>
                            </tr>
                            @endif
                            <tr>
                                <th colspan="7" class="th noPadding alignTop borderTop borderBottom" style="font-size:14px;">{{$additionalInfo}}</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">{{$hospitalSharePercent}}%</th>
                                <th class="th noPadding alignTop borderTop txtLeft borderBottom"></th>
                                <th class="th noPadding alignTop borderTop txtRight borderBottom">{{$pharmacySharePercent}}%</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>
                            @php
                                $summSelesTotal = $summCashBillTotal = $summCreditBIllTotal = $summATotal = $summBTotal = $summDTotal = $summETotal = 0;
                            @endphp
                         @endif
                        <tr>
                            <th class="th alignTop borderTop txtLeft borderBottom">{{ $bEntityName }}</th>
                            <th class="th alignTop borderTop txtRight borderBottom">{{ \Helper::customAmountFormat($summ_mrp) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottom"></th>
                            <th class="th alignTop borderTop txtRight borderBottom">{{ \Helper::customAmountFormat($summ_cashbill) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottom"></th>
                            <th class="th alignTop borderTop txtRight borderBottom">{{ \Helper::customAmountFormat($summ_creditbill) }}</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($C) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottom"></th>
                            <th class="th alignTop borderTop txtRight borderBottom">{{ \Helper::customAmountFormat($D) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottom"></th>
                            <th class="th alignTop borderTop txtRight borderBottom">{{ \Helper::customAmountFormat($E) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottom"></th>
                            <th class="th alignTop borderTop txtRight borderBottom">{{ \Helper::customAmountFormat($F)."%" }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottom"></th>
                            <th class="th alignTop borderTop txtRight borderBottom">{{ \Helper::customAmountFormat($G).'%' }}</th>
                        </tr>
                        @php
                            $counter++;
                            $lastPtr = $ptrApplicable;
                            $summSelesTotal += $summ_mrp;
                            $summCashBillTotal += $summ_cashbill;
                            $summCreditBIllTotal += $summ_mrp;
                            $summATotal += $A;
                            $summBTotal += $B;
                            $summDTotal += $D; $summETotal += $E;
                            
                            $grandTotalSales += $summ_mrp;
                            $grandTotalCashBill += $summ_cashbill;
                            $grandTotalCreditBill += $summ_mrp;
                            $grandTotalA += $A;
                            $grandTotalB += $B;
                            $grandTotalC += $C;
                            $grandTotalD += $D;
                            $grandTotalE += $E;
                        @endphp
                    @endforeach
                        <tr>
                            <th class="th alignTop borderTop txtRight borderBottomGray">Total : </th>
                            <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($summSelesTotal) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($summCashBillTotal) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($summCreditBIllTotal) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($summATotal) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($summBTotal) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($summATotal-$summBTotal) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat((($summATotal-$summBTotal)*$hospitalSharePercent)/100) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat((($summATotal-$summBTotal)*$pharmacySharePercent)/100) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat((($summATotal-$summBTotal)/$summATotal)*100)."%" }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat((($summATotal-$summBTotal)/$summBTotal)*100).'%' }}</th>
                        </tr>
                        <tr>
                            <th class="th alignTop borderTop txtRight borderBottomGray">Grand Total : </th>
                            <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($grandTotalSales) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($grandTotalCashBill) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($grandTotalCreditBill) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($grandTotalA) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($grandTotalB) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($grandTotalC) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($grandTotalD) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($grandTotalE) }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat((($grandTotalA-$grandTotalB)/$grandTotalA)*100)."%" }}</th>
                            <th class="th alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat((($grandTotalA-$grandTotalB)/$grandTotalB)*100).'%' }}</th>
                        </tr>
                @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-->