@extends('Reports.template')

<!--Title-->
@section('title')
{{"Store Purchse Return Summary"}}
@endsection
<!--Title Close-->

<!--External CSS-->
@section('ExternalCss')
@parent
@endsection
@section('Content')
<table class="table table-responsive" style="border-top:none; border-bottom:1px solid #000; font-size:12px;">
    <thead>
        <tr>
            <th colspan="2" class="borderNone borderBottom" style="vertical-align:center;">
                @if($businessEntityMasterData[0]->logo != null)
                <!--Image--> 
                <img class="img-responsive" alt="Pharmacy Logo" src="{{"data:image/jpeg;base64,".base64_encode( $businessEntityMasterData[0]->logo )}}"/>
                @endif
            </th>
            <th colspan="14" class="borderNone borderBottom txtLeft">
                <div style="line-height:1.0;" class="heading">{{ $businessEntityMasterData[0]->name }}</div>
                <div style="line-height:1.0;">{{$businessEntityMasterData[0]->add1. " " .$businessEntityMasterData[0]->add2 ." ".$businessEntityMasterData[0]->city." : " .$businessEntityMasterData[0]->pincode }}</div>
                <div style="line-height:1.0;">{{"Phone : ".$businessEntityMasterData[0]->tel1}}</div>
            </th>
        </tr>
        @php 
        $currentTime  = \Carbon\Carbon::now(); 
        @endphp
        <tr>
            <th colspan="5" class="th borderNone borderBottom reportTitle">{{Config::get('constants.reports.PURCHASE_SUMMARY')}} <label class="fontsize12 bold">(Order By : {{$orderBy}}) (Voucher Type : {{$trnType}})</label> </th>
            <th colspan="7" 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="9%" class="th noPadding alignTop borderTopBottom txtCenter">{{Config::get('constants.reports.TRN_DATE')}}</th>
            <th width="6%" 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="10%" class="th noPadding alignTop borderTopBottom txtRight">CGST Amt</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">SGST Amt</th>
            <th width="9%" class="th noPadding alignTop borderTopBottom txtRight">Bill Amount</th>
        </tr>

    </thead>
    <tbody>
        @php
        $sr = 1;
        $tempSupplierName = '';
        $supplier_old= '';
        $totalsupplier = 0;
        $totalPurchase = 0;
        $totalReturnCgst =0;
        $totalReturnSgst =0;
        $totalCgstAmt =0;
        $totalSgstAmt =0;
        $totalReturnAmt =0;
        $netPurchaseAmt =0;
        $netCgstAmt = 0;
        $netSgstAmt = 0;
        $totalNetAmt =0;
        $taxableAmt =0;
        $totalTaxableAmt =0;
        $totalTaxableReturn=0;
        $netTaxableAmt =0;
        $strike = 'noStrike';
        $totalSupp = 0;
        $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="th bold noPadding alignTop borderTopBottom txtCenter"></td>
            <td class="th bold noPadding alignTop borderTopBottom txtCenter"></td>
            <td class="td bold alignTop txtRight borderTopBottom "> {{ \Helper::customAmountFormat($totalsupplier)}}</td>
        </tr>
        @endif
        <tr>
            @php

            $supplier_old= '';
            $totalsupplier = 0;
            $totalNetAmt =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->ph_trn_status == 'T')
            @php
            $strike = 'strike';
            $totalsupplier -= $stock->total;
            @endphp
            @else
            @php
            $strike = 'noStrike';
            @endphp
            @endif
            @if($stock->trn_type == 'PR')
            @php
            $totalTaxableReturn +=$stock->net_taxable_amt;
            $totalSupp = $stock->total * (-1);
            $totalReturnAmt+=$stock->total;
            $totalsupplier -= $stock->total;
            $totalNetAmt -=$stock->net_taxable_amt;
            $totalReturnCgst +=$stock->cgst_amt;
            $totalReturnSgst +=$stock->sgst_amt;
            $taxableAmt =$stock->net_taxable_amt * (-1);
            @endphp
            @else 
            @php
            $totalSupp = $stock->total;
            $totalPurchase +=$stock->total;
            $totalCgstAmt +=$stock->cgst_amt;
            $totalSgstAmt +=$stock->sgst_amt;
            $totalTaxableAmt+=$stock->net_taxable_amt;
            $netCgstAmt=$totalCgstAmt-$totalReturnCgst;
            $netSgstAmt=$totalSgstAmt-$totalReturnSgst;
            $taxableAmt =$stock->net_taxable_amt;
            @endphp
            @endif

            @php
            $netTaxableAmt =$totalTaxableAmt-$totalTaxableReturn;
            $netPurchaseAmt=$totalPurchase-$totalReturnAmt;
            $netCgstAmt=$totalCgstAmt-$totalReturnCgst;
            $netSgstAmt=$totalSgstAmt-$totalReturnSgst;
            @endphp

            <td style="vertical-align: middle;"class="td notBold alignTop borderTop txtRight {{$strike}}">{{$stock->trn_type.$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 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($stock->cgst_amt)}}</td>
            <td style="vertical-align: middle;"class="td notBold alignTop borderTop txtRight {{$strike}}">{{\Helper::customAmountFormat($stock->sgst_amt)}}</td>
            <td style="vertical-align: middle;"class="td notBold alignTop borderTop txtRight {{$strike}}">{{\Helper::customAmountFormat($totalSupp)}}</td>
        </tr>

        @php
        $tempSupplierName = $stock->supplier_name;
        $supplier_old=$stock->supplier_name;
        $totalsupplier += $stock->total;
        $totalNetAmt +=$stock->net_taxable_amt;
        $gstno = $stock->supplier_gstin_no
        @endphp

        @endforeach
        <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 noPadding alignTop borderTopBottom txtCenter"></td>
            <td class="th bold noPadding alignTop borderTopBottom txtCenter"></td>
            <td class="td bold alignTop txtRight borderTopBottom "> {{ \Helper::customAmountFormat($totalsupplier)}}</td>
        </tr>
        <tr>
            <td width="7%" colspan="8" class="td bold alignTop txtRight borderTopBottom ">Total Taxable Amt : {{ \Helper::customAmountFormat($totalTaxableAmt)}}</td>
            <td class="td bold borderTopBottom txtRight">Total CGST : {{ \Helper::customAmountFormat($totalCgstAmt)}}</td>
            <td class="td bold borderTopBottom txtRight">Total SGST : {{ \Helper::customAmountFormat($totalSgstAmt)}}</td>
            <td class="td bold txtRight borderTopBottom ">Total Purchase : {{ \Helper::customAmountFormat($totalPurchase)}}</td>
        </tr>

        <tr>
            <td width="7%" colspan="8" class="td bold alignTop txtRight borderTopBottom ">Total Taxable Return : {{ \Helper::customAmountFormat($totalTaxableReturn)}}</td>
            <td class="td bold borderTopBottom txtRight">Return CGST : {{ \Helper::customAmountFormat($totalReturnCgst)}}</td>
            <td class="td bold borderTopBottom txtRight">Return SGST : {{ \Helper::customAmountFormat($totalReturnSgst)}}</td>
            <td class="td bold txtRight borderTopBottom ">Total Purchase Return : {{ \Helper::customAmountFormat($totalReturnAmt)}}</td>

        </tr>
        <tr>
            <td width="7%" colspan="8" class="td bold alignTop txtRight borderTopBottom ">Net Taxable : {{ \Helper::customAmountFormat($netTaxableAmt)}}</td>
            <td class="td bold borderTopBottom txtRight">Net CGST : {{ \Helper::customAmountFormat($netCgstAmt)}}</td>
            <td class="td bold borderTopBottom txtRight">Net SGST : {{ \Helper::customAmountFormat($netSgstAmt)}}</td>
            <td class="td bold txtRight borderTopBottom ">Net Purchase : {{ \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>

<!--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="{{Config::get('constants.reports.PURCHASE_SUMMARY')}}">
            <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('StoreItem/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-->