@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;">
                <!--Image--> 
                <img class="img-responsive" alt="Pharmacy Logo" src="{{"data:image/jpeg;base64,".base64_encode( $businessEntityMasterData[0]->logo )}}"/>
            </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="3" class="txtRight th borderNone borderBottom">
                Store : {{$storeName}}
            </th>
            <th colspan="6" class="txtRight th borderNone borderBottom">
                Period : {{\Helper::getDisplayDate($fromDate)}} TO {{\Helper::getDisplayDate($toDate)}}
            </th>
        </tr>
        <tr>
            <th width="1%" class="th noPadding alignTop borderTopBottom txtRight">{{Config::get('constants.reports.TRN_NO')}}</th>
            <th width="6%" class="th noPadding alignTop borderTopBottom txtCenter">{{Config::get('constants.reports.TRN_DATE')}}</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="9%" class="th noPadding alignTop borderTopBottom txtRight">{{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="9%" 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="5%" class="th noPadding alignTop borderTopBottom txtRight">IGST Amt</th>
            <th width="7%" 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= '';

        $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;

        $strike = 'noStrike';
        $gstno ='';
        $taxableAmt = 0;
        $cgstAmt = 0;
        $sgstAmt = 0;
        $igstAmt = 0;
        @endphp
        
        @foreach ($supplierwise as $key =>$stock)
        @php
        $strike = 'noStrike';
        $gstno ='';
        @endphp

        @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);

        $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;

        $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
        <tr>
            <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->supplier_name}}</td>
            <td style="vertical-align: middle;"class="td notBold alignTop borderTop txtRight {{$strike}}">{{$stock->supplier_gstin_no}}</td>
            <td style="vertical-align: middle;"class="td notBold alignTop borderTop txtRight {{$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>

        @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="6" 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="6" 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="6" 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="15" class="th smallFont noPadding alignTop borderTopBottom txtRight">{{ strtoupper(Session::get('userId'))." # ".$currentTime->format('d/m/Y H:i:s ')}}</td>
</tfoot>
@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>
</table>
<table align="center" border="1" style="width:60%;">
    <thead>
    <h3 align="center"><b>GST Summary</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="2" 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">%</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;
    $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;
    $netTaxableTotal +=$gst->net_taxable;
    $netpurchase +=$gst->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">{{$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 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 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>
<!--Print--> 
<br/><br/>
<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-->