@extends('Reports.template')

<!--Title-->
@section('title')
@php
$reportTitle = "Sales Summary With GST Details";
if($billType=='B'){
    $billType = "Credit and Cash";
    $reportTitle = __($reportTitle)." / ".__($billType);
}else if($billType=='C'){
    $billType = "Cash";
    $reportTitle = __($reportTitle)." / ".__($billType);
}else if($billType=='CR'){
    $billType = "Credit";
    $reportTitle = __($reportTitle)." / ".__($billType);
}
@endphp
{{__($reportTitle)}}
@endsection
<!--Title Close-->

<!--External CSS-->
@section('ExternalCss')
@parent
@endsection
<!--External CSS Close-->

@section('Content')
<!-- Your Page Content Here -->
@if($reportType == "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 txtRight">
                <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="4" class="th borderNone borderBottom reportTitle">{{__($reportTitle)}}</th>
            <th colspan="3" class="txtRight th borderNone borderBottom">
                {{__('Store')}} : {{$storeName}}
            </th>
            <th colspan="5" class="txtRight th borderNone borderBottom">
                {{__('Period')}} : {{\Helper::getDisplayDate($fromDate)}} {{__('TO')}} {{\Helper::getDisplayDate($toDate)}}
            </th>
        </tr>
        <tr>
            <th width="5%" class="th noPadding alignTop borderTopBottom txtRight">{{__('Sr No')}}</th>
            <th class="th noPadding alignTop borderTopBottom txtCenter">{{__('Bill Date')}}</th>
            <th width="20%" class="th noPadding alignTop borderTopBottom txtCenter">{{__('Bill No')}}</th>
            <th class="th noPadding alignTop borderTopBottom txtLeft ">{{__('Patient Name')}}</th>
            <th class="th noPadding alignTop borderTopBottom txtLeft ">{{__('Bill Type')}}</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight ">{{__('Taxable Amt')}}</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">{{__('CGST Amt')}}</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">{{__('SGST Amt')}}</th>
            <th width="8%" class="th noPadding alignTop borderTopBottom txtRight ">{{__('Round Off')}}</th>
            <th width="8%" class="th noPadding alignTop borderTopBottom txtRight ">{{__('Total')}}</th>
        </tr>
    </thead>
    <tbody>
        @php

        $totalTaxableAmt = 0;
        $totalCashTaxableSaleAmt = 0;
        $totalCreditTaxableSaleAmt = 0;
        $totalTaxableSaleAmt = 0;
        $totalCashTaxableReturnAmt = 0;
        $totalCreditTaxableReturnAmt = 0;
        $totalTaxableReturnAmt = 0;
        $totalTaxable = 0;
        $netTaxableAmt = 0;

        $totalSgstAmt = 0;
        $totalCashSaleSgstAmt = 0;
        $totalCreditSaleSgstAmt = 0;
        $totalSaleSgstAmt = 0;
        $totalCashReturnSgst = 0;
        $totalCreditReturnSgst = 0;
        $totalReturnSgst = 0;
        $netSgstAmt = 0;

        $totalCgstAmt = 0;
        $totalCashSaleCgstAmt = 0;
        $totalCreditSaleCgstAmt = 0;
        $totalSaleCgstAmt = 0;
        $totalCashReturnCgst = 0;
        $totalCreditReturnCgst = 0;
        $totalReturnCgst = 0;
        $netCgstAmt = 0;

        $totalRoundoffAmt = 0;
        $totalCashRoundoffSaleAmt = 0;
        $totalCreditRoundoffSaleAmt = 0;
        $totalRoundoffSaleAmt = 0;
        $totalCashRoundoffReturnAmt = 0;
        $totalCreditRoundoffReturnAmt = 0;
        $totalRoundoffReturnAmt = 0;
        $netRoundoff = 0;

        $patientsale = '';

        $patOrCustName = 0;

        $tempPatientName ='';

        $sr = 1;

        $totalsale = 0;
        $totalCashSaleAmt = 0;
        $totalCreditSaleAmt = 0;
        $totalSaleAmt = 0;
        $totalCashSaleReturnAmt = 0;
        $totalCreditSaleReturnAmt = 0;
        $totalSaleReturnAmt = 0;
        $netSaleAmt = 0;
        @endphp

        @foreach ($patientdata as $key=>$patient)
        @if($patient->trn_date != $patientsale)
        @if($totalsale != 0)
        <tr>
            <td colspan="5" class="td bold borderTopBottom txtRight"> {{__('Total')}} </td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalTaxableAmt)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalCgstAmt)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalSgstAmt)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalRoundoffAmt)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalsale)}}</td>
        <tr>
            @php
            $patientsale ='';
            $totalsale = 0;
            $totalTaxableAmt = 0;
            $totalCgstAmt = 0;
            $totalSgstAmt = 0;
            $totalRoundoffAmt = 0;
            $totalTaxable = 0;
            @endphp
            @endif
            @endif
            @if($patient->trn_type == 'IR' || $patient->trn_type == 'GCR')
            @php
            $totalTaxableAmt -= $patient->net_taxable_amt;
            $totalSgstAmt -=$patient->sgst_amt;
            $totalCgstAmt -=$patient->cgst_amt;
            $totalRoundoffAmt -=$patient->round_off;
            $totalTaxable = $patient->net_taxable_amt *(-1);
            $totalCgst = $patient->cgst_amt *(-1);
            $totalSgst = $patient->sgst_amt *(-1);
            $totalRoundoff = $patient->round_off *(-1);
            $totalsale -= $patient->total;
            $patientsale =$patient->total * (-1);
            if($patient->is_credit_bill == "Y"){
            $totalCreditTaxableReturnAmt += $patient->net_taxable_amt;
            $totalCreditRoundoffReturnAmt += $patient->round_off;
            $totalCreditSaleReturnAmt+=$patient->total;
            $totalCreditReturnCgst +=$patient->cgst_amt;
            $totalCreditReturnSgst +=$patient->sgst_amt;
            }else{
            $totalCashTaxableReturnAmt += $patient->net_taxable_amt;
            $totalCashRoundoffReturnAmt += $patient->round_off;
            $totalCashSaleReturnAmt+=$patient->total;
            $totalCashReturnCgst +=$patient->cgst_amt;
            $totalCashReturnSgst +=$patient->sgst_amt;
            }
            $totalTaxableReturnAmt += $patient->net_taxable_amt;
            $totalRoundoffReturnAmt += $patient->round_off;
            $totalSaleReturnAmt+=$patient->total;
            $totalReturnCgst +=$patient->cgst_amt;
            $totalReturnSgst +=$patient->sgst_amt;
            @endphp
            @else
            @php
            $totalTaxableAmt += $patient->net_taxable_amt;
            $totalsale += $patient->total;
            $patientsale = $patient->total;
            $totalTaxable = $patient->net_taxable_amt;
            $totalSgst = $patient->sgst_amt;
            $totalCgst = $patient->cgst_amt;
            $totalRoundoff = $patient->round_off;
            $totalSgstAmt +=$patient->sgst_amt;
            $totalCgstAmt +=$patient->cgst_amt;
            $totalRoundoffAmt +=$patient->round_off;
            if($patient->is_credit_bill == "Y"){
            $totalCreditSaleAmt +=$patient->total;
            $totalCreditTaxableSaleAmt +=$patient->net_taxable_amt;
            $totalCreditRoundoffSaleAmt += $patient->round_off;
            $totalCreditSaleCgstAmt +=$patient->cgst_amt;
            $totalCreditSaleSgstAmt +=$patient->sgst_amt;
            }else{
            $totalCashSaleAmt +=$patient->total;
            $totalCashTaxableSaleAmt +=$patient->net_taxable_amt;
            $totalCashRoundoffSaleAmt += $patient->round_off;
            $totalCashSaleCgstAmt +=$patient->cgst_amt;
            $totalCashSaleSgstAmt +=$patient->sgst_amt;
            }
            $totalSaleAmt +=$patient->total;
            $totalTaxableSaleAmt +=$patient->net_taxable_amt;
            $totalRoundoffSaleAmt += $patient->round_off;
            $totalSaleCgstAmt +=$patient->cgst_amt;
            $totalSaleSgstAmt +=$patient->sgst_amt;
            @endphp
            @endif
            @php
            $netTaxableAmt =$totalTaxableSaleAmt-$totalTaxableReturnAmt;
            $netSaleAmt =$totalSaleAmt-$totalSaleReturnAmt;
            $netCgstAmt =$totalSaleCgstAmt-$totalReturnCgst;
            $netSgstAmt =$totalSaleSgstAmt-$totalReturnSgst;
            $netRoundoff = $totalRoundoffSaleAmt - $totalRoundoffReturnAmt;
            @endphp
            @php
            if($patient->patient_name != ''){
            $patOrCustName = $patient->patient_name;
            }else{
            $patOrCustName = '*'.$patient->ph_cust_name;
            }
            if($patient->is_credit_bill == "Y"){
            $bill = "Credit";
            }else{
            $bill = "Cash";
            }
            @endphp
        <tr>
            @if($patient->trn_date != $tempPatientName)
            <td class="td notBold alignTop borderTop txtRight">{{$sr++}}</td>
            <td class="td notBold alignTop borderTop txtCenter">{{\Helper::getDisplayDate($patient->trn_date)}}</td>
            @else
            <td class="td borderNone"></td>
            <td class="td borderNone"></td>
            @endif
            <td class="td notBold alignTop borderTop txtCenter">{{$patient->trn_type."/".$patient->trn_fyear."/".$patient->trn_id}}</td>
            <td class="td notBold alignTop borderTop txtLeft ">{{$patOrCustName}}</td>
            <td class="td notBold alignTop borderTop txtLeft ">{{__($bill)}}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{ $totalTaxable == 0 ? '0.00' : \Helper::customAmountFormat($totalTaxable) }}</td>
            <td style="vertical-align: middle;" class="td notBold alignTop borderTop txtRight">{{ $totalCgst == 0 ? '0.00' : \Helper::customAmountFormat($totalCgst) }}</td>
            <td style="vertical-align: middle;" class="td notBold alignTop borderTop txtRight">{{ $totalSgst == 0 ? '0.00' : \Helper::customAmountFormat($totalSgst) }}</td>
            <td style="vertical-align: middle;" class="td notBold alignTop borderTop txtRight">{{ $totalRoundoff == 0 ? '0.00' : \Helper::customAmountFormat($totalRoundoff) }}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{ $patientsale == 0 ? '0.00' : \Helper::customAmountFormat($patientsale) }}</td>
        </tr>
        @php

        $patientsale = $patient->trn_date;

        $tempPatientName = $patient->trn_date;
        @endphp
        @endforeach
        <tr>
            <td colspan="5" class="td bold borderTopBottom txtRight"> {{__('Total')}} </td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalTaxableAmt)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalCgstAmt)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalSgstAmt)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalRoundoffAmt)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalsale)}}</td>
        <tr>
        <tr>
            <td colspan="6" class="td bold alignTop txtRight borderTopBottom ">{{__('Total Cash Sales')}} : {{ \Helper::customAmountFormat($totalCashTaxableSaleAmt)}}</td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($totalCashSaleCgstAmt)}}</td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($totalCashSaleSgstAmt)}}</td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($totalCashRoundoffSaleAmt)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom ">{{ \Helper::customAmountFormat($totalCashSaleAmt)}}</td>
        </tr>
        <tr>
            <td colspan="6" class="td bold alignTop txtRight borderTopBottom ">{{__('Total Credit Sales')}} : {{ \Helper::customAmountFormat($totalCreditTaxableSaleAmt)}}</td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($totalCreditSaleCgstAmt)}}</td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($totalCreditSaleSgstAmt)}}</td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($totalCreditRoundoffSaleAmt)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom ">{{ \Helper::customAmountFormat($totalCreditSaleAmt)}}</td>
        </tr>
        <tr>
            <td width="5%" colspan="6" class="td bold alignTop txtRight borderTopBottom ">{{__('Total Sales')}} : {{ \Helper::customAmountFormat($totalTaxableSaleAmt)}}</td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($totalSaleCgstAmt)}}</td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($totalSaleSgstAmt)}}</td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($totalRoundoffSaleAmt)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom ">{{ \Helper::customAmountFormat($totalSaleAmt)}}</td>
        </tr>
        <tr>
            <td colspan="6" class="td bold alignTop txtRight borderTopBottom ">{{__('Total Cash Sales Return')}} : {{ \Helper::customAmountFormat($totalCashTaxableReturnAmt)}}</td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($totalCashReturnCgst)}}</td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($totalCashReturnSgst)}}</td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($totalCashRoundoffReturnAmt)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom ">{{ \Helper::customAmountFormat($totalCashSaleReturnAmt)}}</td>
        </tr>
        <tr>
            <td colspan="6" class="td bold alignTop txtRight borderTopBottom ">{{__('Total Credit Sales Return')}} : {{ \Helper::customAmountFormat($totalCreditTaxableReturnAmt)}}</td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($totalCreditReturnCgst)}}</td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($totalCreditReturnSgst)}}</td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($totalCreditRoundoffReturnAmt)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom ">{{ \Helper::customAmountFormat($totalCreditSaleReturnAmt)}}</td>
        </tr>
        <tr>
            <td width="5%" colspan="6" class="td bold alignTop txtRight borderTopBottom ">{{__('Total Sales Return')}} : {{ \Helper::customAmountFormat($totalTaxableReturnAmt)}}</td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($totalReturnCgst)}}</td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($totalReturnSgst)}}</td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($totalRoundoffReturnAmt)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom ">{{ \Helper::customAmountFormat($totalSaleReturnAmt)}}</td>
        </tr>
        <tr>
            <td width="5%" colspan="6" class="td bold alignTop txtRight borderTopBottom ">{{__('Net Total')}} : {{ \Helper::customAmountFormat($netTaxableAmt)}}</td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($netCgstAmt)}}</td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($netSgstAmt)}}</td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($netRoundoff)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom ">{{ \Helper::customAmountFormat($netSaleAmt)}}</td>
        </tr>
    </tbody>
    <tfoot>
    <th colspan="3" class="th smallFont noPadding alignTop borderTopBottom"><span class="fontsize10">&#10033;</span>{{__(Config::get('constants.asterisk.WALK_CUST'))}}</th>
    <td colspan="7" class="th smallFont noPadding alignTop borderTopBottom txtRight">{{ strtoupper(Session::get('userId'))." # ".$currentTime->format('d/m/Y H:i:s ')}}</td>
</tfoot>
</table>
@endif

@if($reportType == "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="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="4" class="th borderNone borderBottom reportTitle">{{__($reportTitle)}}</th>
            <th colspan="3" class="txtRight th borderNone borderBottom">
                {{__('Store')}} : {{$storeName}}
            </th>
            <th colspan="5" class="txtRight th borderNone borderBottom">
                {{__('Period')}} : {{\Helper::getDisplayDate($fromDate)}} {{__('TO')}} {{\Helper::getDisplayDate($toDate)}}
            </th>
        </tr>
        <tr>
            <th colspan="10" width="5%" class="th smallFont noPadding alignTop borderTopBottom txtRight">{{ strtoupper(Session::get('userId'))." # ".$currentTime->format('d/m/Y H:i:s ')}}</th>
        </tr>
    </thead>
    <tbody>
    </tbody>
</table>
@endif

<table align="center" border="1" style="width:60%;">
    <thead>
    <h3 align="center"><b>{{__('GST Summary - Sales')}} / {{__($billType)}}</b></h3>
    <tr>
        <th class="th noPadding alignTop borderTopBottom txtCenter"></th>
        <th class="th noPadding alignTop borderTopBottom txtCenter">{{__('Taxable')}}</th>
        <th colspan="2" class="th noPadding alignTop borderTopBottom txtCenter">{{__('CGST')}}</th>
        <th colspan="2" class="th noPadding alignTop borderTopBottom txtCenter">{{__('SGST')}}</th>
        <th class="th noPadding alignTop borderTopBottom txtCenter">{{__('Sale')}}</th>
    <tr>
        <th width="2%" class="th bold noPadding alignTop borderTopBottom txtCenter">%</th>
        <th width="2%" class="th bold noPadding alignTop borderTopBottom txtCenter">{{__('Amount')}}</th>
        <th width="4%" class="th bold noPadding alignTop borderTopBottom txtCenter">%</th>
        <th width="3%" class="th bold noPadding alignTop borderTopBottom txtCenter">{{__('Amount')}}</th>
        <th width="4%" class="th bold noPadding alignTop borderTopBottom txtCenter">%</th>
        <th width="3%" class="th bold noPadding alignTop borderTopBottom txtCenter">{{__('Amount')}}</th>
        <th width="3%" class="th bold noPadding alignTop borderTopBottom txtCenter"> {{__('Total Amount')}}</th>
    </tr>
</thead>
<tbody>
    @php
    $sgstAmt = 0;
    $cgstAmt = 0;
    $netTaxableTotal = 0;
    $netSale = 0;
    $total = 0;
    @endphp
    @foreach ($salegstSummary as $key => $gst)
    @if($gst->trn_type == "I")
    @php
    $gstRange = $gst->sgst_percentage + $gst->cgst_percentage;
    $sgstAmt += $gst->sgst_amt;
    $cgstAmt += $gst->cgst_amt;
    $netTaxableTotal += $gst->net_taxable;
    $total = $gst->net_taxable + $gst->sgst_amt + $gst->cgst_amt;
    $netSale += $total;
    @endphp
    <tr>
        <td class="th noPadding alignTop borderTopBottom txtCenter">{{$gstRange}}</td>
        <td class="th noPadding alignTop borderTopBottom  txtRight">{{\Helper::customAmountFormat($gst->net_taxable)}}</td>
        <td class="th noPadding alignTop borderTopBottom txtCenter">{{$gst->cgst_percentage}}</td>
        <td class="th noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($gst->cgst_amt)}}</td>
        <td class="th noPadding alignTop borderTopBottom txtCenter">{{$gst->sgst_percentage}}</td>
        <td class="th noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($gst->sgst_amt)}}</td>
        <td class="th noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($total)}}</td>
    </tr>
    @endif
    @endforeach
    <tr>
        <td class="th bold noPadding alignTop borderTopBottom txtCenter">{{__('Total')}}</td>
        <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($netTaxableTotal)}}</td>
        <td class="th bold noPadding alignTop borderTopBottom txtCenter"></td>
        <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($cgstAmt)}}</td>
        <td class="th bold noPadding alignTop borderTopBottom txtCenter"></td>
        <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($sgstAmt)}}</td>
        <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($netSale)}}</td>
    </tr>
</tbody>
</table>
<br />

<table align="center" border="1" style="width:60%;">
    <thead>
    <h3 align="center"><b>{{__('GST Summary - Sales Return')}} / {{__($billType)}}</b></h3>
    <tr>
        <th class="th noPadding alignTop borderTopBottom txtCenter"></th>
        <th class="th noPadding alignTop borderTopBottom txtCenter">{{__('Taxable')}}</th>
        <th colspan="2" class="th noPadding alignTop borderTopBottom txtCenter">{{__('CGST')}}</th>
        <th colspan="2" class="th noPadding alignTop borderTopBottom txtCenter">{{__('SGST')}}</th>
        <th class="th noPadding alignTop borderTopBottom txtCenter">{{__('Sale')}}</th>
    <tr>
        <th width="2%" class="th bold noPadding alignTop borderTopBottom txtCenter">%</th>
        <th width="2%" class="th bold noPadding alignTop borderTopBottom txtCenter">{{__('Amount')}}</th>
        <th width="4%" class="th bold noPadding alignTop borderTopBottom txtCenter">%</th>
        <th width="3%" class="th bold noPadding alignTop borderTopBottom txtCenter">{{__('Amount')}}</th>
        <th width="4%" class="th bold noPadding alignTop borderTopBottom txtCenter">%</th>
        <th width="3%" class="th bold noPadding alignTop borderTopBottom txtCenter">{{__('Amount')}}</th>
        <th width="3%" class="th bold noPadding alignTop borderTopBottom txtCenter"> {{__('Total Amount')}}</th>
    </tr>
</thead>
<tbody>
    @php
    $sgstAmt = 0;
    $cgstAmt = 0;
    $netTaxableTotal = 0;
    $netSale = 0;
    $total = 0;
    @endphp
    @foreach ($salegstSummary as $key => $gst)
    @if($gst->trn_type == "IR" || $gst->trn_type == 'GCR')
    @php
    $gstRange = $gst->sgst_percentage + $gst->cgst_percentage;
    $sgstAmt += $gst->sgst_amt;
    $cgstAmt += $gst->cgst_amt;
    $netTaxableTotal += $gst->net_taxable;
    $total = $gst->net_taxable + $gst->sgst_amt + $gst->cgst_amt;
    $netSale += $total;
    @endphp
    <tr>
        <td class="th noPadding alignTop borderTopBottom txtCenter">{{$gstRange}}</td>
        <td class="th noPadding alignTop borderTopBottom  txtRight">{{\Helper::customAmountFormat((-1)*$gst->net_taxable)}}</td>
        <td class="th noPadding alignTop borderTopBottom txtCenter">{{$gst->cgst_percentage}}</td>
        <td class="th noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat((-1)*$gst->cgst_amt)}}</td>
        <td class="th noPadding alignTop borderTopBottom txtCenter">{{$gst->sgst_percentage}}</td>
        <td class="th noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat((-1)*$gst->sgst_amt)}}</td>
        <td class="th noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat((-1)*$total)}}</td>
    </tr>
    @endif
    @endforeach
    <tr>
        <td class="th bold noPadding alignTop borderTopBottom txtCenter">{{__('Total')}}</td>
        <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat((-1)*$netTaxableTotal)}}</td>
        <td class="th bold noPadding alignTop borderTopBottom txtCenter"></td>
        <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat((-1)*$cgstAmt)}}</td>
        <td class="th bold noPadding alignTop borderTopBottom txtCenter"></td>
        <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat((-1)*$sgstAmt)}}</td>
        <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat((-1)*$netSale)}}</td>
    </tr>
</tbody>
</table>
<br />

<table align="center" border="1" style="width:60%;">
    <thead>
    <h3 align="center"><b>{{__('GST Summary - Total')}} / {{__($billType)}}</b></h3>
    <tr>
        <th class="th noPadding alignTop borderTopBottom txtCenter"></th>
        <th class="th noPadding alignTop borderTopBottom txtCenter">{{__('Taxable')}}</th>
        <th colspan="2" class="th noPadding alignTop borderTopBottom txtCenter">{{__('CGST')}}</th>
        <th colspan="2" class="th noPadding alignTop borderTopBottom txtCenter">{{__('SGST')}}</th>
        <th class="th noPadding alignTop borderTopBottom txtCenter">{{__('Sale')}}</th>
    <tr>
        <th width="2%" class="th bold noPadding alignTop borderTopBottom txtCenter">%</th>
        <th width="2%" class="th bold noPadding alignTop borderTopBottom txtCenter">{{__('Amount')}}</th>
        <th width="4%" class="th bold noPadding alignTop borderTopBottom txtCenter">%</th>
        <th width="3%" class="th bold noPadding alignTop borderTopBottom txtCenter">{{__('Amount')}}</th>
        <th width="4%" class="th bold noPadding alignTop borderTopBottom txtCenter">%</th>
        <th width="3%" class="th bold noPadding alignTop borderTopBottom txtCenter">{{__('Amount')}}</th>
        <th width="3%" class="th bold noPadding alignTop borderTopBottom txtCenter"> {{__('Total Amount')}}</th>
    </tr>
</thead>
<tbody>
    @php
    $oldGstRange = 0;
    $oldGstPercentage = '';
    $sgstAmt = 0;
    $cgstAmt = 0;
    $netTaxableTotal = 0;
    $netSale = 0;
    $total = 0;

    $totalTaxable = 0;
    $totalSgstAmt = 0;
    $totalCgstAmt = 0;
    $totalAmt = 0;
    @endphp
    @foreach ($salegstSummary as $key => $gst)
    @php
    $gstRange = $gst->sgst_percentage + $gst->cgst_percentage;
    @endphp
    @if($gstRange != $oldGstRange) 
    <tr>
        <td class="th noPadding alignTop borderTopBottom txtCenter">{{$oldGstRange}}</td>
        <td class="th noPadding alignTop borderTopBottom  txtRight">{{\Helper::customAmountFormat($totalTaxable)}}</td>
        <td class="th noPadding alignTop borderTopBottom txtCenter">{{$oldGstPercentage}}</td>
        <td class="th noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalCgstAmt)}}</td>
        <td class="th noPadding alignTop borderTopBottom txtCenter">{{$oldGstPercentage}}</td>
        <td class="th noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalSgstAmt)}}</td>
        <td class="th noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalAmt)}}</td>
    </tr>
    @php
    $totalTaxable = 0;
    $totalSgstAmt = 0;
    $totalCgstAmt = 0;
    $totalAmt = 0;
    @endphp
    @endif
    @php
    $sgstAmt += $gst->sgst_amt;
    $totalSgstAmt += $gst->sgst_amt;
    $cgstAmt += $gst->cgst_amt;
    $totalCgstAmt += $gst->cgst_amt;
    $netTaxableTotal += $gst->net_taxable;
    $totalTaxable += $gst->net_taxable;
    $total = $gst->net_taxable + $gst->sgst_amt + $gst->cgst_amt;
    $netSale += $total;
    $totalAmt += $total;
    @endphp
    @php
    $oldGstRange = $gstRange;
    $oldGstPercentage = $gst->cgst_percentage;
    @endphp
    @endforeach
    <tr>
        <td class="th noPadding alignTop borderTopBottom txtCenter">{{$oldGstRange}}</td>
        <td class="th noPadding alignTop borderTopBottom  txtRight">{{\Helper::customAmountFormat($totalTaxable)}}</td>
        <td class="th noPadding alignTop borderTopBottom txtCenter">{{$oldGstPercentage}}</td>
        <td class="th noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalCgstAmt)}}</td>
        <td class="th noPadding alignTop borderTopBottom txtCenter">{{$oldGstPercentage}}</td>
        <td class="th noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalSgstAmt)}}</td>
        <td class="th noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalAmt)}}</td>
    </tr>
    <tr>
        <td class="th bold noPadding alignTop borderTopBottom txtCenter">{{__('Total')}}</td>
        <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($netTaxableTotal)}}</td>
        <td class="th bold noPadding alignTop borderTopBottom txtCenter"></td>
        <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($cgstAmt)}}</td>
        <td class="th bold noPadding alignTop borderTopBottom txtCenter"></td>
        <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($sgstAmt)}}</td>
        <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($netSale)}}</td>
    </tr>
</tbody>
</table>
<br /><br />

<!--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/patientwisedataInput') }}" 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')
<script src="{{ asset ("/js/export_to_excel.js?$releaseVersion") }}"></script>
@endsection
<!--External JS Close-->