@extends('Reports.template')

<!--Title-->
@section('title')
    @php
        $reportTitle = 'Patient Wise Sales Report - With GST';
    @endphp
    {{ $reportTitle }}
@endsection
<!--Title Close-->

<!--External CSS-->
@section('ExternalCss')
    @parent
@endsection
@section('Content')
    @if ($Report_Type=='D')
        <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="7" class="th borderNone borderBottom reportTitle">{{ $reportTitle }}</th>
                    <th colspan="6" 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 width="5%" 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>
                    <th colspan="9" class="th noPadding alignTop borderTopBottomGray txtRight"></th>
                </tr>
                <tr>
                    <th width="4%" class="th notBold noPadding alignTop borderTopBottom txtRight">Sr No.</th>
                    <th width="15%" class="th notBold noPadding alignTop borderTopBottom">&emsp;Product Name</th>
                    <th width="8%" class="th notBold noPadding alignTop borderTopBottom">Category</th>
                    <th width="5%" class="th notBold noPadding alignTop borderTopBottom">Batch</th>
                    <th width="5%" class="th notBold noPadding alignTop borderTopBottom txtRight">Qty</th>
                    <th width="5%" class="th notBold noPadding alignTop borderTopBottom txtRight">MRP</th>
                    <th width="5%" class="th notBold noPadding alignTop borderTopBottom txtRight">Gross Total</th>
                    <th width="5%" class="th notBold noPadding alignTop borderTopBottom txtRight">Disc%</th>
                    <th width="5%" class="th notBold noPadding alignTop borderTopBottom txtRight">Disc</th>
                    <th width="5%" class="th notBold noPadding alignTop borderTopBottom txtRight">Taxable</th>
                    <th width="5%" class="th notBold noPadding alignTop borderTopBottom txtRight">GST%</th>
                    <th width="5%" class="th notBold noPadding alignTop borderTopBottom txtRight">GST</th>
                    <th width="5%" class="th notBold noPadding alignTop borderTopBottom txtRight">Net Total</th>
                </tr>
            </thead>
            <tbody>
                @php
                    $oldTrnType = '';
                    $oldTrnId = '';
                    $oldEntity = '';
                    $oldPatient = '';
                    $headerSr = 1;
                    $transactionSr = 1;
                    $patient_id = '';
                    $patient_name = '';
                    $ipd_reg_id = '';
                    $entity_name = '';
                    $totalMrp = 0;
                    $totalquantity = 0;
                    $totaldiscount_amt = 0;
                    $totaltaxable_amt = 0;
                    $totalgst=0;
                    $totalAmt=0;
                    $NetTotal=0;
                    $grosstotalSaleMrp=0;
                    $grosstotalquantity=0;
                    $grosstotaldiscount_amt=0;
                    $grosstotaltaxable_amt=0;
                    $grosstotalgst=0;
                    $grosstotalAmt=0;
                    $grossNetTotal=0;
                    $entitytotalquantity=0;
                    $entitytotaldiscount_amt=0;
                    $entitytotaltaxable_amt=0;
                    $entitytotalgst=0;
                    $entitytotalAmt=0;
                    $entityNetTotal=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;
                                }
                                
                                if($profit->trn_type=="I")
                                {
                                    $mrp=$profit->mrp;
                                    $discount=$profit->discount;
                                    $discount_amt=$profit->discount_amt;
                                    $taxable_amt=$profit->taxable_amt;
                                    $gst=floatval($profit->sgst_value) + floatval($profit->cgst_value);
                                    $total=$profit->total;
                                }
                                else
                                {
                                    $mrp=$profit->mrp*-1;
                                    $discount=$profit->discount*-1;
                                    $discount_amt=$profit->discount_amt*-1;
                                    $taxable_amt=$profit->taxable_amt*-1;
                                    $gst= -1 * (floatval($profit->sgst_value) + floatval($profit->cgst_value));
                                    $total=-1 * $profit->total;
                                }

                            @endphp
                            @if ($profit->trn_type != $oldTrnType || $profit->trn_id != $oldTrnId)
                                @if ($headerSr > 1)
                                    <tr>
                                        <td colspan="4" class="td bold borderNone txtRight"> Total : </td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ $totalquantity }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totalAmt) }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totaldiscount_amt) }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totaltaxable_amt) }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totalgst) }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($NetTotal) }}</td>
                                        </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">{{ $patienttotalquantity }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($patienttotalAmt) }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($patienttotaldiscount_amt) }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($patienttotaltaxable_amt) }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($patienttotalgst) }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($patientNetTotal) }}</td>
                                    </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">{{ $entitytotalquantity }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($entitytotalAmt) }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($entitytotaldiscount_amt) }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($entitytotaltaxable_amt) }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($entitytotalgst) }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($entityNetTotal) }}</td>
                                    </tr>
                                @endif
                                @php
                                    $transactionSr = 1;
                                    $totalMrp = 0;
                                    $totalquantity = 0;
                                    
                                    $totaldiscount_amt = 0;
                                    $totaltaxable_amt = 0;
                                    $totalgst=0;
                                    $totalAmt=0;
                                    $NetTotal=0;
                                @endphp
                                @if ($entity_name != '' && $entity_name != $oldEntity && $ipId=='')
                                    @php
                                        $entitytotalquantity=0;
                                        $entitytotaldiscount_amt=0;
                                        $entitytotaltaxable_amt=0;
                                        $entitytotalgst=0;
                                        $entitytotalAmt=0;
                                        $entityNetTotal=0;
                                    @endphp
                                    <tr>
                                        <th colspan="13" class="txtleft th borderNone borderBottom">
                                            Entity :
                                            {{ $entity_name }}
                                        </th>
                                    </tr>
                                @endif
                                @if ($patient_id != '' && $patient_id != $oldPatient)
                                    @php
                                        $patienttotalSaleMrp=0;
                                        $patienttotalquantity=0;
                                        $patienttotaldiscount_amt=0;
                                        $patienttotaltaxable_amt=0;
                                        $patienttotalgst=0;
                                        $patienttotalAmt=0;
                                        $patientNetTotal=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="6" 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 width="5%" 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="9" class="td bold alignTop borderTopBottom txtRight"></td>
                                </tr>
                            @endif
                            <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">{{ $profit->category_abbrev }}</td>
                                <td class="td notBold alignTop borderTopGray">{{ $profit->batch_no }}</td>
                                <td class="td notBold alignTop borderTopGray txtRight">{{ $profit->quantity }}</td>
                                <td class="td notBold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat($mrp) }}</td>
                                <td class="td notBold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat($total)  }}</td>
                                <td class="td notBold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat($discount) }}</td>
                                <td class="td notBold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat($discount_amt) }}</td>
                                <td class="td notBold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat($taxable_amt) }}</td>
                                <td class="td notBold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat(floatval($profit->sgst_percentage) + floatval($profit->cgst_percentage)) }}</td>
                                <td class="td notBold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat($gst) }}</td>
                                <td class="td notBold alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat($taxable_amt+$gst) }}</td>
                            </tr>
                            @php
                                $totalquantity += $profit->quantity;
                                $totalMrp += $mrp;
                                $totaldiscount_amt += $discount_amt;
                                $totaltaxable_amt += $taxable_amt;
                                $totalgst += ($gst);
                                $totalAmt+= $total;
                                $NetTotal += ($gst+$taxable_amt);

                                
                                if ($patient_id != '') {
                                    $patienttotalSaleMrp += $mrp;
                                    $patienttotalquantity += $profit->quantity;
                                    $patienttotaldiscount_amt += $discount_amt;
                                    $patienttotaltaxable_amt += $taxable_amt;
                                    $patienttotalgst += ($gst);
                                    $patienttotalAmt+= $total;
                                    $patientNetTotal += ($gst+$taxable_amt);
                                }

                                $entitytotalquantity += $profit->quantity;
                                $entitytotaldiscount_amt += $discount_amt;
                                $entitytotaltaxable_amt += $taxable_amt;
                                $entitytotalgst += ($gst);
                                $entitytotalAmt+= $total;
                                $entityNetTotal += ($gst+$taxable_amt);
                                
                                $grosstotalSaleMrp += $mrp;
                                $grosstotalquantity += $profit->quantity;
                                $grosstotaldiscount_amt += $discount_amt;
                                $grosstotaltaxable_amt += $taxable_amt;
                                $grosstotalgst += ($gst);
                                $grosstotalAmt+= $total;
                                $grossNetTotal += ($gst+$taxable_amt);

                                $oldTrnType = $profit->trn_type;
                                $oldTrnId = $profit->trn_id;
                                if ($patient_id != '') {
                                    $oldPatient = $patient_id;
                                    $oldEntity = $entity_name;
                                }
                            @endphp
                        @endforeach
                    @endif
                    <tr>
                        <td colspan="4" class="td bold borderNone txtRight"> Total : </td>
                        <td class="td bold alignTop txtRight borderTopBottom">{{ $totalquantity }}</td>
                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totalAmt) }}</td>
                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totaldiscount_amt) }}</td>
                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totaltaxable_amt) }}</td>
                        <td class="td bold alignTop txtRight borderTopBottom"></td>
                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totalgst) }}</td>
                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($NetTotal) }}</td>
                    <tr>
                    @if ($patient_id != '')
                        <tr>
                            <td colspan="4" class="td bold borderTopBottom txtRight"> Patient Total : </td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ $patienttotalquantity }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom"></td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($patienttotalAmt) }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom"></td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($patienttotaldiscount_amt) }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($patienttotaltaxable_amt) }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom"></td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($patienttotalgst) }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($patientNetTotal) }}</td>
                        <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">{{ $entitytotalquantity }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom"></td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($entitytotalAmt) }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom"></td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($entitytotaldiscount_amt) }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($entitytotaltaxable_amt) }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom"></td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($entitytotalgst) }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($entityNetTotal) }}</td>
                        </tr>
                    @endif
                    <tr>
                        <td colspan="4" class="td bold borderTopBottom txtRight"> Bill Total : </td>
                        <td class="td bold alignTop txtRight borderTopBottom">{{ $grosstotalquantity }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom"></td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($grosstotalAmt) }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom"></td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($grosstotaldiscount_amt) }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($grosstotaltaxable_amt) }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom"></td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($grosstotalgst) }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($grossNetTotal) }}</td>
                    <tr>
            </tbody>
            <tfoot>
                <td colspan="13" class="th smallFont noPadding alignTop borderTopBottom txtRight">
                    {{ strtoupper(Session::get('userId')) . ' # ' . $currentTime->format('d/m/Y H:i:s ') }}</td>
            </tfoot>
        </table>
    @elseif ($Report_Type=='S')
        <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="7" 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="5" 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 width="5%" class="th noPadding alignTop borderTopBottomGray">&emsp;Trn No</th>
                    <th width="5%" class="th noPadding alignTop borderTopBottomGray">Trn Date</th>
                    <th width="5%" class="th noPadding alignTop borderTopBottomGray">Bill Type</th>
                    <th width="5%" class="th notBold noPadding alignTop borderTopBottomGray txtRight">Gross Total</th>
                    <th width="5%" class="th notBold noPadding alignTop borderTopBottomGray txtRight">Disc Amt</th>
                    <th width="5%" class="th notBold noPadding alignTop borderTopBottomGray txtRight">Taxable</th>
                    <th width="5%" class="th notBold noPadding alignTop borderTopBottomGray txtRight">GST</th>
                    <th width="5%" class="th notBold noPadding alignTop borderTopBottomGray txtRight">Net Total</th>
                </tr>
            </thead>
            <tbody>
                @php
                    $oldTrnType = '';
                    $oldTrnId = '';
                    $oldEntity = '';
                    $oldPatient = '';
                    $headerSr = 1;
                    $transactionSr = 1;
                    $patient_id = '';
                    $patient_name = '';
                    $ipd_reg_id = '';
                    $entity_name = '';
                    $totalMrp = 0;
                    $totalquantity = 0;
                    $totaldiscount_amt = 0;
                    $totaltaxable_amt = 0;
                    $totalgst=0;
                    $totalAmt=0;
                    $NetTotal=0;
                    $grosstotalSaleMrp=0;
                    $grosstotalquantity=0;
                    $grosstotaldiscount_amt=0;
                    $grosstotaltaxable_amt=0;
                    $grosstotalgst=0;
                    $grosstotalAmt=0;
                    $grossNetTotal=0;
                    $entitytotalquantity=0;
                    $entitytotaldiscount_amt=0;
                    $entitytotaltaxable_amt=0;
                    $entitytotalgst=0;
                    $entitytotalAmt=0;
                    $entityNetTotal=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;
                                }
                                
                                if($profit->trn_type=="I")
                                {
                                    $mrp=$profit->mrp;
                                    $discount=$profit->discount;
                                    $discount_amt=$profit->discount_amt;
                                    $taxable_amt=$profit->taxable_amt;
                                    $gst=floatval($profit->sgst_value) + floatval($profit->cgst_value);
                                    $total=$profit->total;
                                }
                                else
                                {
                                    $mrp=$profit->mrp*-1;
                                    $discount=$profit->discount*-1;
                                    $discount_amt=$profit->discount_amt*-1;
                                    $taxable_amt=$profit->taxable_amt*-1;
                                    $gst= -1 * (floatval($profit->sgst_value) + floatval($profit->cgst_value));
                                    $total=-1 * $profit->total;
                                }

                            @endphp
                            @if ($profit->trn_type != $oldTrnType || $profit->trn_id != $oldTrnId)
                                @if ($headerSr > 1)
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totalAmt) }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totaldiscount_amt) }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totaltaxable_amt) }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totalgst) }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($NetTotal) }}</td>
                                        </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($patienttotalAmt) }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($patienttotaldiscount_amt) }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($patienttotaltaxable_amt) }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($patienttotalgst) }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($patientNetTotal) }}</td>
                                    </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($entitytotalAmt) }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($entitytotaldiscount_amt) }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($entitytotaltaxable_amt) }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($entitytotalgst) }}</td>
                                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($entityNetTotal) }}</td>
                                    </tr>
                                @endif
                                @php
                                    $transactionSr = 1;
                                    $totalMrp = 0;
                                    $totalquantity = 0;
                                    
                                    $totaldiscount_amt = 0;
                                    $totaltaxable_amt = 0;
                                    $totalgst=0;
                                    $totalAmt=0;
                                    $NetTotal=0;
                                @endphp
                                @if ($entity_name != '' && $entity_name != $oldEntity && $ipId=='')
                                    @php
                                        $entitytotalquantity=0;
                                        $entitytotaldiscount_amt=0;
                                        $entitytotaltaxable_amt=0;
                                        $entitytotalgst=0;
                                        $entitytotalAmt=0;
                                        $entityNetTotal=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;
                                        $patienttotalquantity=0;
                                        $patienttotaldiscount_amt=0;
                                        $patienttotaltaxable_amt=0;
                                        $patienttotalgst=0;
                                        $patienttotalAmt=0;
                                        $patientNetTotal=0;
                                    @endphp
                                    <tr>
                                        <th colspan="4" class="txtleft th borderNone borderBottom">
                                            Patient :
                                            {{ $patient_id . ' / ' . $patient_name }} &emsp; IP ID :
                                            {{ $ipd_reg_id }}
                                        </th>
                                        @if($ipId=='')
                                        <th colspan="5" 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
                                $totalquantity += $profit->quantity;
                                $totalMrp += $mrp;
                                $totaldiscount_amt += $discount_amt;
                                $totaltaxable_amt += $taxable_amt;
                                $totalgst += ($gst);
                                $totalAmt+= $total;
                                $NetTotal += ($gst+$taxable_amt);

                                
                                if ($patient_id != '') {
                                    $patienttotalSaleMrp += $mrp;
                                    $patienttotalquantity += $profit->quantity;
                                    $patienttotaldiscount_amt += $discount_amt;
                                    $patienttotaltaxable_amt += $taxable_amt;
                                    $patienttotalgst += ($gst);
                                    $patienttotalAmt+= $total;
                                    $patientNetTotal += ($gst+$taxable_amt);
                                }

                                $entitytotalquantity += $profit->quantity;
                                $entitytotaldiscount_amt += $discount_amt;
                                $entitytotaltaxable_amt += $taxable_amt;
                                $entitytotalgst += ($gst);
                                $entitytotalAmt+= $total;
                                $entityNetTotal += ($gst+$taxable_amt);
                                
                                $grosstotalSaleMrp += $mrp;
                                $grosstotalquantity += $profit->quantity;
                                $grosstotaldiscount_amt += $discount_amt;
                                $grosstotaltaxable_amt += $taxable_amt;
                                $grosstotalgst += ($gst);
                                $grosstotalAmt+= $total;
                                $grossNetTotal += ($gst+$taxable_amt);

                                $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($totalAmt) }}</td>
                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totaldiscount_amt) }}</td>
                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totaltaxable_amt) }}</td>
                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($totalgst) }}</td>
                        <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($NetTotal) }}</td>
                    <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($patienttotalAmt) }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($patienttotaldiscount_amt) }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($patienttotaltaxable_amt) }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($patienttotalgst) }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($patientNetTotal) }}</td>
                        <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($entitytotalAmt) }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($entitytotaldiscount_amt) }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($entitytotaltaxable_amt) }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($entitytotalgst) }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($entityNetTotal) }}</td>
                        </tr>
                    @endif
                        <tr>
                            <td colspan="4" class="td bold borderTopBottom txtRight"> Bill Total : </td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($grosstotalAmt) }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($grosstotaldiscount_amt) }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($grosstotaltaxable_amt) }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($grosstotalgst) }}</td>
                            <td class="td bold alignTop txtRight borderTopBottom">{{ \Helper::customAmountFormat($grossNetTotal) }}</td>
                        <tr>
            </tbody>
            <tfoot>
                <td colspan="9" class="th smallFont noPadding alignTop borderTopBottom txtRight">
                    {{ strtoupper(Session::get('userId')) . ' # ' . $currentTime->format('d/m/Y H:i:s ') }}</td>
            </tfoot>
        </table>
    @endif
    <br>
    @if ($ipId=='')
        <table class="table table-responsive" style="border-top:none; border-bottom:1px solid #000; font-size:12px;">
            <thead>
                <tr>
                    <th colspan="8" class="th borderNone borderBottom reportTitle">Entity Wise Summery</th>
                    <th colspan="8" 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 borderTopBottom txtLeft">Entity Name</th>
                    <th width="5%" class="th noPadding alignTop borderTopBottom txtRight">Gross Total</th>
                    <th width="2%" class="th noPadding alignTop borderTopBottom txtLeft "></th>
                    <th width="5%" class="th noPadding alignTop borderTopBottom txtRight">Cash Bill Total</th>
                    <th width="2%" class="th noPadding alignTop borderTopBottom txtLeft "></th>
                    <th width="5%" class="th noPadding alignTop borderTopBottom txtRight">Credit Bill Total</th>
                    <th width="2%" class="th noPadding alignTop borderTopBottom txtLeft "></th>
                    <th width="5%" class="th noPadding alignTop borderTopBottom txtRight ">Disc</th>
                    <th width="2%" class="th noPadding alignTop borderTopBottom txtLeft "></th>
                    <th width="5%" class="th noPadding alignTop borderTopBottom txtRight ">Taxable</th>
                    <th width="2%" class="th noPadding alignTop borderTopBottom txtLeft "></th>
                    <th width="5%" class="th noPadding alignTop borderTopBottom txtRight ">GST</th>
                    <th width="2%" class="th noPadding alignTop borderTopBottom txtLeft "></th>
                    <th width="5%" class="th noPadding alignTop borderTopBottom txtRight ">Net Total</th>
                </tr>
            </thead>
            <tbody>
                @if (!empty($productProfit))
                    @php
                        $qty=0;
                        $old_sr=0;
                        $old_mrp = 0;
                        $old_discount_amt = 0;
                        $old_taxable_amt = 0;
                        $old_gst = 0;
                        $old_total= 0;

                        $vdiscount_amt=0;
                        $vtaxable_amt=0;
                        $vgst=0;
                        $vtotal=0;
                        $cash_bill=0;
                        $credit_bill=0;
                        
                        $totaldiscount_amt=0;
                        $totaltaxable_amt=0;
                        $totalgst=0;
                        $nettotal=0;
                        $netcash_bill=0;
                        $netcredit_bill=0;

                        $next=-1;
                    @endphp
                    @foreach ($productProfit as $profit)
                        @php
                            if($profit->trn_type=="I")
                            {
                                $discount_amt=$profit->discount_amt;
                                $taxable_amt=$profit->taxable_amt;
                                $gst=floatval($profit->sgst_value) + floatval($profit->cgst_value);
                                $total=$profit->total;
                            }
                            else
                            {
                                $discount_amt=$profit->discount_amt*-1;
                                $taxable_amt=$profit->taxable_amt*-1;
                                $gst=(floatval($profit->sgst_value) + floatval($profit->cgst_value))*-1;
                                $total=$profit->total*-1;
                            }

                            if($next==-1)
                            {
                                $oldEntity=$productProfit[0]->entity_name;
                            }

                            $old_discount_amt = $discount_amt;
                            $old_taxable_amt = $taxable_amt;
                            $old_gst = ($gst);
                            $old_total= $total;
                            
                        @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($vtotal) }}</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($vdiscount_amt) }}</th>
                                <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                                <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($vtaxable_amt) }}</th>
                                <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                                <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($vgst) }}</th>
                                <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                                <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($vgst+$vtaxable_amt) }}</th>
                            </tr>
                            @php
                                $vdiscount_amt=0;
                                $vtotal=0;
                                $cash_bill=0;
                                $credit_bill=0;
                                $vtaxable_amt=0;
                                $vgst=0;
                            @endphp
                        @endif
                        @php

                            $vdiscount_amt += $old_discount_amt;
                            $vtaxable_amt += $old_taxable_amt;
                            $vgst += $old_gst;
                            $vtotal+= $old_total;
                            if($profit->is_credit_bill=="N")
                            {
                                $cash_bill += $old_total;
                            }
                            else 
                            {
                                $credit_bill += $old_total;
                            }

                            $totaldiscount_amt += $old_discount_amt;
                            $totaltaxable_amt += $old_taxable_amt;
                            $totalgst += $old_gst;
                            $nettotal += $old_total;
                            if($profit->is_credit_bill=="N")
                            {
                                $netcash_bill += $old_total;
                            }
                            else
                            {
                                $netcredit_bill += $old_total;
                            }

                            $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 borderBottomGray">{{ \Helper::customAmountFormat($vtotal) }}</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($vdiscount_amt) }}</th>
                            <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($vtaxable_amt) }}</th>
                            <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($vgst) }}</th>
                            <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($vtaxable_amt+$vgst) }}</th>
                        </tr>
                        <tr>
                            <th class="th alignTop borderTop txtRight borderBottomGray">Total : </th>
                            <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($nettotal) }}</th>
                            <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($netcash_bill) }}</th>
                            <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($netcredit_bill) }}</th>
                            <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($totaldiscount_amt) }}</th>
                            <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($totaltaxable_amt) }}</th>
                            <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($totalgst) }}</th>
                            <th class="th  alignTop borderTop txtLeft borderBottomGray"></th>
                            <th class="th  alignTop borderTop txtRight borderBottomGray">{{ \Helper::customAmountFormat($totaltaxable_amt+$totalgst) }}</th>
                        </tr>
                    @endif
                @endif
            <tfoot>
                <td colspan="16" 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/PatientWiseSaleReportForIPBillInput') }}" 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-->