@extends('Reports.template')

<!--Title-->
@section('title')
@php
$reportTitle = "Purchase Summary With GST Details";    
@endphp
{{$reportTitle}}
@endsection
<!--Title Close-->

<!--External CSS-->
@section('ExternalCss')
@parent
@endsection
@section('Content')
@if($reporttype == "detail")
<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}} <label class="fontsize12 bold">(Order By : {{$orderBy}}) (Voucher Type : {{$trnType}})</label> </th>
            <th colspan="5" 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="2%" class="th noPadding alignTop borderTopBottom">Sr No.</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtLeft">{{Config::get('constants.reports.SUPPLIER_NAME')}}</th>
            <th width="2%" class="th noPadding alignTop borderTopBottom txtCenter">GST No</th>
            <th width="5%" class="th noPadding alignTop borderTopBottom txtRight">{{Config::get('constants.reports.TRN_NO')}}</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtCenter">{{Config::get('constants.reports.TRN_DATE')}}</th>
            <th width="6%" class="th noPadding alignTop borderTopBottom txtLeft">{{Config::get('constants.reports.SUPPLIER_BILL_NO')}}</th>
            <th width="8%" class="th noPadding alignTop borderTopBottom txtRight">{{Config::get('constants.reports.SUPPLIER_BILL_DATE')}}</th>
            <th width="7%" class="th noPadding alignTop borderTopBottom txtRight">Taxable Amt</th>
            <th width="5%" class="th noPadding alignTop borderTopBottom txtRight">CGST Amt</th>
            <th width="5%" class="th noPadding alignTop borderTopBottom txtRight">SGST Amt</th>
            <th width="4%" class="th noPadding alignTop borderTopBottom txtRight">IGST Amt</th>
            <th width="6%" class="th noPadding alignTop borderTopBottom txtRight">Taxable + Tax</th>
            <th width="5%" class="th noPadding alignTop borderTopBottom txtRight">Sch Amt</th>
            <th width="5%" class="th noPadding alignTop borderTopBottom txtRight">TCS Amt</th>
            <th width="5%" class="th noPadding alignTop borderTopBottom txtRight">R. off</th>
            <th width="6%" class="th noPadding alignTop borderTopBottom txtRight">Net Amt</th>
        </tr>

    </thead>
    <tbody>
        @php
        $sr = 1;
        $tempSupplierName = '';
        $supplier_old= '';
        $totalNetAmt = 0;
        $totalNetCgst = 0;
        $totalNetSgst = 0;
        $totalNetIgst = 0;
        $totalsupplier = 0;

        $totalTaxableReturn = 0;
        $totalReturnCgst = 0;
        $totalReturnSgst = 0;
        $totalReturnIgst = 0;
        $totalReturnTaxablePlsTax = 0;
        $totalReturnSchAmount = 0;
        $totalReturnTcsAmt = 0;
        $totalReturnROundOff = 0;
        $totalReturnAmt = 0;

        $totalTaxableAmt = 0;
        $totalCgstAmt = 0;
        $totalSgstAmt = 0;
        $totalIgstAmt = 0;
        $totalTaxablePlsTax = 0;
        $totalSchAmount = 0;
        $totalTcsAmount = 0;
        $totalROundOffAmt = 0;
        $totalPurchase = 0;

        $netTaxableAmt = 0;
        $netCgstAmt = 0;
        $netSgstAmt = 0;
        $netIgstAmt = 0;
        $netTaxablePlsTax = 0;
        $netSchAmount = 0;
        $netTcsAmount = 0;
        $netRoundOffAmt = 0;
        $netPurchaseAmt = 0;

        $taxableAmt = 0;
        $cgstAmt = 0;
        $sgstAmt = 0;
        $igstAmt = 0;

        $strike = 'noStrike';
        $gstno ='';
        @endphp

        @foreach ($supplierwise as $key =>$stock)

        @if($stock->supplier_name !=  $supplier_old)

        @if($totalsupplier != 0)
        <tr>
            <td colspan="7" class="td bold borderTopBottom txtRight"> Total </td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalNetAmt)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalNetCgst)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalNetSgst)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalNetIgst)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalNetTaxablePlsTax)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalNetSchAmount)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalNetTcsAmount)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalNetRoundOffAmt)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalsupplier)}}</td>
        </tr>
        @endif
        <tr>
            @php
            $supplier_old = '';
            $totalNetAmt = 0;
            $totalNetSgst = 0;
            $totalNetCgst = 0;
            $totalNetIgst = 0;
            $totalsupplier = 0;
            $totalNetTaxablePlsTax = 0; $totalNetSchAmount = 0; $totalNetTcsAmount = 0; $totalNetRoundOffAmt = 0;
            $strike = 'noStrike';
            $gstno ='';
            @endphp

            @endif

            @if($stock->supplier_name != $tempSupplierName)
            <td style="vertical-align: middle;" class="td notBold alignTop borderTop txtRight{{$strike}}">{{$sr++}}</td>
            <td style="vertical-align: middle;"class="td notBold alignTop borderTop txtLeft{{$strike}} ">{{$stock->supplier_name}}</td>
            @else
            <td class="td borderNone"></td>
            <td class="td borderNone"></td>
            @endif

            @if(($stock->supplier_name != $tempSupplierName)||($gstno != $stock->supplier_gstin_no))
            <td style="vertical-align: middle;"class="td notBold alignTop borderTop txtRight {{$strike}}">{{$stock->supplier_gstin_no}}</td>
            @else
            <td class="td borderNone"></td>
            @endif

            @if($stock->trn_type == 'PR')
            @php
            $taxableAmt = $stock->net_taxable_amt * (-1);
            $cgstAmt = $stock->cgst_amt * (-1);
            $sgstAmt = $stock->sgst_amt * (-1);
            $igstAmt = $stock->igst_amt * (-1);
            $taxablePlsTax = $stock->ph_invoice_amt * (-1);
            $schAmount = $stock->ph_sch_amount * (-1);
            $tcsAmount = $stock->ph_tcs_amount * (-1);
            $roundOffAmt = $stock->ph_round_off * (-1);
            $netAmount = $stock->ph_total * (-1);

            $totalNetAmt -= $stock->net_taxable_amt;
            $totalNetCgst -= $stock->cgst_amt;
            $totalNetSgst -= $stock->sgst_amt;
            $totalNetIgst -= $stock->igst_amt;
            $totalNetTaxablePlsTax -= $stock->ph_invoice_amt;
            $totalNetSchAmount -= $stock->ph_sch_amount;
            $totalNetTcsAmount -= $stock->ph_tcs_amount;
            $totalNetRoundOffAmt -= $stock->ph_round_off;
            $totalsupplier -= $stock->ph_total;

            $totalTaxableReturn += $stock->net_taxable_amt;
            $totalReturnCgst += $stock->cgst_amt;
            $totalReturnSgst += $stock->sgst_amt;
            $totalReturnIgst += $stock->igst_amt;
            $totalReturnTaxablePlsTax += $stock->ph_invoice_amt;
            $totalReturnSchAmount += $stock->ph_sch_amount;
            $totalReturnTcsAmt += $stock->ph_tcs_amount;
            $totalReturnROundOff += $stock->ph_round_off;
            $totalReturnAmt += $stock->ph_total;
            @endphp

            @else 
            @php
            $taxableAmt = $stock->net_taxable_amt;
            $cgstAmt = $stock->cgst_amt;
            $sgstAmt = $stock->sgst_amt;
            $igstAmt = $stock->igst_amt;
            $taxablePlsTax = $stock->ph_invoice_amt;
            $schAmount = $stock->ph_sch_amount;
            $tcsAmount = $stock->ph_tcs_amount;
            $roundOffAmt = $stock->ph_round_off;
            $netAmount = $stock->ph_total;
            

            $totalNetAmt += $stock->net_taxable_amt;
            $totalNetCgst += $stock->cgst_amt;
            $totalNetSgst += $stock->sgst_amt;
            $totalNetIgst += $stock->igst_amt;
            $totalNetTaxablePlsTax += $taxablePlsTax;
            $totalNetSchAmount += $schAmount;
            $totalNetTcsAmount += $tcsAmount;
            $totalNetRoundOffAmt += $roundOffAmt;
            $totalsupplier += $netAmount;

            $totalTaxableAmt += $stock->net_taxable_amt;
            $totalCgstAmt += $stock->cgst_amt;
            $totalSgstAmt += $stock->sgst_amt;
            $totalIgstAmt += $stock->igst_amt;
            $totalTaxablePlsTax += $taxablePlsTax;
            $totalSchAmount += $schAmount;
            $totalTcsAmount += $tcsAmount;
            $totalROundOffAmt += $roundOffAmt;
            $totalPurchase += $stock->ph_total;
            @endphp
            @endif

            <td style="vertical-align: middle;"class="td notBold alignTop borderTop txtRight {{$strike}}">{{$stock->trn_type."/".$stock->trn_fyear."/".$stock->trn_id}}</td>
            <td style="vertical-align: middle;"class="td notBold alignTop borderTop txtCenter {{$strike}}">{{\Helper::getDisplayDate($stock->trn_date)}}</td>
            <td style="vertical-align: middle;"class="td notBold alignTop borderTop txtLeft {{$strike}}">{{($stock->ph_purchase_bill_no)}}</td>
            <td style="vertical-align: middle;"class="td notBold alignTop borderTop txtRight {{$strike}}">{{\Helper::getDisplayDate($stock->ph_purchase_bill_date)}}</td>
            <td style="vertical-align: middle;"class="td notBold alignTop borderTop txtRight {{$strike}}">{{\Helper::customAmountFormat($taxableAmt)}}</td>
            <td style="vertical-align: middle;"class="td notBold alignTop borderTop txtRight {{$strike}}">{{\Helper::customAmountFormat($cgstAmt)}}</td>
            <td style="vertical-align: middle;"class="td notBold alignTop borderTop txtRight {{$strike}}">{{\Helper::customAmountFormat($sgstAmt)}}</td>
            <td style="vertical-align: middle;"class="td notBold alignTop borderTop txtRight {{$strike}}">{{\Helper::customAmountFormat($igstAmt)}}</td>
            <td style="vertical-align: middle;"class="td notBold alignTop borderTop txtRight {{$strike}}">{{\Helper::customAmountFormat($taxablePlsTax)}}</td>
            <td style="vertical-align: middle;"class="td notBold alignTop borderTop txtRight {{$strike}}">{{\Helper::customAmountFormat($schAmount)}}</td>
            <td style="vertical-align: middle;"class="td notBold alignTop borderTop txtRight {{$strike}}">{{\Helper::customAmountFormat($tcsAmount)}}</td>
            <td style="vertical-align: middle;"class="td notBold alignTop borderTop txtRight {{$strike}}">{{\Helper::customAmountFormat($roundOffAmt)}}</td>
            <td style="vertical-align: middle;"class="td notBold alignTop borderTop txtRight {{$strike}}">{{\Helper::customAmountFormat($netAmount)}}</td>
        </tr>

        @php
        $tempSupplierName = $stock->supplier_name;
        $supplier_old = $stock->supplier_name;
        $gstno = $stock->supplier_gstin_no;
        @endphp

        @endforeach

        @php
        $netTaxableAmt = $totalTaxableAmt - $totalTaxableReturn;
        $netCgstAmt = $totalCgstAmt - $totalReturnCgst;
        $netSgstAmt = $totalSgstAmt - $totalReturnSgst;
        $netIgstAmt = $totalIgstAmt - $totalReturnIgst;
        $netTaxablePlsTax = $totalTaxablePlsTax - $totalReturnTaxablePlsTax;
        $netSchAmount = $totalSchAmount - $totalReturnSchAmount;
        $netTcsAmount = $totalTcsAmount - $totalReturnTcsAmt;
        $netRoundOffAmt = $totalROundOffAmt - $totalReturnROundOff;
        $netPurchaseAmt = $totalPurchase - $totalReturnAmt;
        @endphp

        <tr>
            <td colspan="7" class="td bold borderTopBottom txtRight"> Total </td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalNetAmt)}}</td>
            <td class="th bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalNetCgst)}}</td>
            <td class="th bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalNetSgst)}}</td>
            <td class="th bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalNetIgst)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom"> {{ \Helper::customAmountFormat($totalNetTaxablePlsTax ?? '')}}</td>
            <td class="td bold alignTop txtRight borderTopBottom"> {{ \Helper::customAmountFormat($totalNetSchAmount ?? '')}}</td>
            <td class="td bold alignTop txtRight borderTopBottom"> {{ \Helper::customAmountFormat($totalNetTcsAmount ?? '')}}</td>
            <td class="td bold alignTop txtRight borderTopBottom"> {{ \Helper::customAmountFormat($totalNetRoundOffAmt ?? '')}}</td>
            <td class="td bold alignTop txtRight borderTopBottom"> {{ \Helper::customAmountFormat($totalsupplier ?? '')}}</td>
        </tr>
        <tr>
            <td colspan="7" class="td bold alignTop txtRight borderTopBottom ">Total Purchase </td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($totalTaxableAmt)}}</td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($totalCgstAmt)}}</td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($totalSgstAmt)}}</td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($totalIgstAmt)}}</td>
            <td class="td bold txtRight borderTopBottom ">{{ \Helper::customAmountFormat($totalTaxablePlsTax)}}</td>
            <td class="td bold txtRight borderTopBottom ">{{ \Helper::customAmountFormat($totalSchAmount)}}</td>
            <td class="td bold txtRight borderTopBottom ">{{ \Helper::customAmountFormat($totalTcsAmount)}}</td>
            <td class="td bold txtRight borderTopBottom ">{{ \Helper::customAmountFormat($totalROundOffAmt)}}</td>
            <td class="td bold txtRight borderTopBottom ">{{ \Helper::customAmountFormat($totalPurchase)}}</td>
        </tr>

        <tr>
            <td colspan="7" class="td bold alignTop txtRight borderTopBottom ">Total Purchase Return </td>
            <td class="td bold borderTopBottom txtRight">{{ \Helper::customAmountFormat($totalTaxableReturn)}}</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($totalReturnIgst)}}</td>
            <td class="td bold txtRight borderTopBottom ">{{ \Helper::customAmountFormat($totalReturnTaxablePlsTax)}}</td>
            <td class="td bold txtRight borderTopBottom ">{{ \Helper::customAmountFormat($totalReturnSchAmount)}}</td>
            <td class="td bold txtRight borderTopBottom ">{{ \Helper::customAmountFormat($totalReturnTcsAmt)}}</td>
            <td class="td bold txtRight borderTopBottom ">{{ \Helper::customAmountFormat($totalReturnROundOff)}}</td>
            <td class="td bold txtRight borderTopBottom ">{{ \Helper::customAmountFormat($totalReturnAmt)}}</td>
        </tr>

        <tr>
            <td colspan="7" class="td bold alignTop txtRight borderTopBottom ">Net Purchase </td>
            <td class="td bold borderTopBottom txtRight">{{ \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($netIgstAmt)}}</td>
            <td class="td bold txtRight borderTopBottom ">{{ \Helper::customAmountFormat($netTaxablePlsTax)}}</td>
            <td class="td bold txtRight borderTopBottom ">{{ \Helper::customAmountFormat($netSchAmount)}}</td>
            <td class="td bold txtRight borderTopBottom ">{{ \Helper::customAmountFormat($netTcsAmount)}}</td>
            <td class="td bold txtRight borderTopBottom ">{{ \Helper::customAmountFormat($netRoundOffAmt)}}</td>
            <td class="td bold txtRight borderTopBottom ">{{ \Helper::customAmountFormat($netPurchaseAmt)}}</td>
        </tr>

    </tbody>
    <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

@if($reporttype == "summary")
<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 - Purchase</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 colspan="3" class="th noPadding alignTop borderTopBottom txtCenter">IGST</th>
        <th class="th noPadding alignTop borderTopBottom txtCenter">Purchase</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">Tax Amt</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 ($OnlyPurchasegstSummary as $key => $gst)
    @if($gst->trn_type == "P")
    @php
    $gstRange = $gst->sgst_percentage + $gst->cgst_percentage+ $gst->igst_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 txtCenter">{{$gst->igst_net_taxable}}</td>
        <td class="th noPadding alignTop borderTopBottom txtCenter">{{($gstRange)}}</td>
        <td class="th noPadding alignTop borderTopBottom txtRight">{{$gst->igst_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 txtCenter"></td>
        <td class="th bold noPadding alignTop borderTopBottom txtCenter"></td>
        
        <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($igstAmt ?? '')}}</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 - Purchase Return</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 colspan="3" class="th noPadding alignTop borderTopBottom txtCenter">IGST</th>
        <th class="th noPadding alignTop borderTopBottom txtCenter">Purchase</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">Tax Amt</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 ($OnlyPurchaseReturngstSummary as $key => $gst)
    @if($gst->trn_type == "PR")
    @php
    $gstRange = $gst->sgst_percentage + $gst->cgst_percentage+ $gst->igst_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 txtCenter">{{$gst->igst_net_taxable}}</td>
        <td class="th noPadding alignTop borderTopBottom txtCenter">{{($gstRange)}}</td>
        <td class="th noPadding alignTop borderTopBottom txtRight">{{$gst->igst_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 txtCenter"></td>
        <td class="th bold noPadding alignTop borderTopBottom txtCenter"></td>
        
        <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($igstAmt ?? '')}}</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 - Total</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 colspan="3" class="th noPadding alignTop borderTopBottom txtCenter">IGST</th>
        <th  class="th noPadding alignTop borderTopBottom txtCenter">Purchase</th>
    </tr>
    <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="4%"  class="th bold noPadding alignTop borderTopBottom txtCenter">Tax Amt</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;
    $igstAmt =0;
    $netTaxableTotal =0;
    $netIgstTaxableTotal = 0;
    $netpurchase =0;
    @endphp
    @foreach ($purchasegstSummary as $key =>$gst)

    @php
    $gstRange =$gst->sgst_percentage + $gst->cgst_percentage + $gst->igst_percentage;
    $sgstAmt+=$gst->sgst_amt;
    $cgstAmt+=$gst->cgst_amt;
    $igstAmt+=$gst->igst_amt;
    $netpurchase +=$gst->total;
    $netTaxableAmt = $gst->net_taxable - $gst->igst_net_taxable;
    $netTaxableTotal += $netTaxableAmt;
    $netIgstTaxableTotal += $gst->igst_net_taxable;
    @endphp

    <tr>
        <td class="th noPadding alignTop borderTopBottom txtCenter">{{$gstRange}}</td>
        <td class="th noPadding alignTop borderTopBottom  txtRight">{{\Helper::customAmountFormat($netTaxableAmt)}}</td>
        <td class="th noPadding alignTop borderTopBottom txtCenter">{{$gstRange/2}}</td>
        <td class="th noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($gst->cgst_amt)}}</td>
        <td class="th noPadding alignTop borderTopBottom txtCenter">{{$gstRange/2}}</td>
        <td class="th noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($gst->sgst_amt)}}</td>
        <td class="th noPadding alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($gst->igst_net_taxable) }}</td>
        <td class="th noPadding alignTop borderTopBottom txtCenter">{{$gstRange}}</td>
        <td class="th noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($gst->igst_amt)}}</td>
        <td class="th noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($gst->total)}}</td>
    </tr>

    @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($netIgstTaxableTotal) }}</td>
        <td class="th bold noPadding alignTop borderTopBottom txtCenter"></td>
        <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($igstAmt)}}</td>
        <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($netpurchase)}}</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/supplierwisesaleInput') }}" 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-->