@extends('Reports.template')
@php
    $reportTitle = 'GST Credit Note Register';
@endphp

<!--Title-->
@section('title')
    {{ __($reportTitle) }}
@endsection
<!--Title Close-->

<!--External CSS-->
@section('ExternalCss')
    @parent
    <style>
        @media print {
            @page {
                size: A4 landscape;
            }
        }
    </style>
@endsection
<!--External CSS Close-->

@section('Content')
    <!-- Your Page Content Here -->
    <table class="table table-responsive"
        style="border-top:none; border-bottom:1px solid #000; font-size:12px;">
        <thead>
            <tr>
                <th colspan="5" 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="17" class="borderNone borderBottom">
                    <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>
            <tr>
                <th colspan="12" class="th borderNone borderBottom reportTitle">{{ __($reportTitle) . ' ' }}</th>
                <th colspan="10" class="txtRight th borderNone borderBottom">{{__('Period')}} :
                    {{ \Helper::getDisplayDate($fromDate) }} {{__('TO')}} {{ \Helper::getDisplayDate($toDate) }}</th>
            </tr>
            <tr>
                <th width="4%" class="th noPadding alignTop borderTop borderBottomGray txtCenter">{{__('Bill No')}}</th>
                <th class="th noPadding alignTop borderTop borderBottomGray txtLeft">{{__('Bill Date')}}</th>
                <th colspan="10" class="th noPadding alignTop borderTop borderBottomGray txtLeft">{{__('Ref No.')}}</th>
                <th class="th noPadding alignTop borderTop borderBottomGray txtRight">{{__('Net Amount')}}</th>
                <th class="th noPadding alignTop borderTop borderBottomGray txtRight">{{__('Net Taxable')}}</th>
                <th class="th noPadding alignTop borderTop borderBottomGray txtRight">{{__('CGST')}}</th>
                <th class="th noPadding alignTop borderTop borderBottomGray txtRight">{{__('SGST')}}</th>
            </tr>
            @if ($reportType === 'B')
                <tr>
                    <th class="th notBold noPadding alignTop borderTopBottom txtRight">{{__('Sr')}}</th>
                    <th class="th notBold noPadding alignTop borderTopBottom">&nbsp;{{__('Name')}}</th>
                    <th class="th notBold noPadding alignTop borderTopBottom">{{__('HSN Code')}}</th>
                    <th class="th notBold noPadding alignTop borderTopBottom">&nbsp;&nbsp;{{__('Batch')}}</th>
                    <th class="th notBold noPadding alignTop borderTopBottom">{{__('Exp')}}</th>
                    <th class="th notBold noPadding alignTop borderTopBottom">{{__('Category')}}</th>
                    <th class="th notBold noPadding alignTop borderTopBottom">{{__('S Unit')}}</th>
                    <th class="th notBold noPadding alignTop borderTopBottom">{{__('P Size')}}</th>
                    <th class="th notBold noPadding alignTop borderTopBottom txtRight">{{__('Qty')}}</th>
                    <th class="th notBold noPadding alignTop borderTopBottom txtRight">{{__('GST')}}%</th>
                    <th class="th notBold noPadding alignTop borderTopBottom txtRight">{{__('Original Amt')}}</th>
                    <th class="th notBold noPadding alignTop borderTopBottom txtRight">{{__('Revised Amt')}}</th>
                    <th class="th notBold noPadding alignTop borderTopBottom txtRight">{{__('Difference Amt')}}</th>
                    <th class="th notBold noPadding alignTop borderTopBottom txtRight">{{__('Taxable')}}</th>
                    <th class="th notBold noPadding alignTop borderTopBottom txtRight">{{__('CGST')}}</th>
                    <th class="th notBold noPadding alignTop borderTopBottom txtRight">{{__('SGST')}}</th>
                </tr>
            @endif
        </thead>
        <tbody>
            @php
                $oldPhTrnType = '';
                $oldPhTrnId = '';
                $createdBy = '';
                
                $headerSr = 1;
                $transactionSr = 1;
                $datetime = 0;
                $totalQty = 0;
                $totalAmount = 0;
                $totalRevisedAmount=0;
                $totalOriginalQty=0;
                $grosstotalQty=0;
                $totalTaxable=0;
                $totalSGST=0;
                $totalCGST=0;
                $Original_Amt=0;

                $grossphNetTaxableAmt =0;
                $grossphCgstAmt =0;
                $grossphSgstAmt =0;
                $grossphTotal =0;

                $bill=0;
            @endphp
            @foreach ($productTransactionData as $key => $productTransaction)
            @if ($productTransaction->ph_trn_id != $oldPhTrnId || $productTransaction->ph_trn_type != $oldPhTrnType)
                    @php $bill++; @endphp
                    @if ($totalQty != 0)
                        @if ($reportType === 'B')
                            <tr>
                                <td colspan="8" class="td bold alignTop txtRight ">
                                    {{__('Total Qty')}} : </td>
                                <td colspan="1" class="td bold alignTop txtRight borderTopBottom ">
                                    {{ \Helper::zeroValueToNbspSpace($totalQty) }}</td>
                                <td colspan="13"
                                    class="td notBold alignTop borderTopBottom smallFont txtRight ">
                                    <i>{{ __('Created By') }}:</i>
                                    @if ($createdBy)
                                        {{ $createdBy . '  ' . Carbon\Carbon::parse($datetime)->format('d-m-Y h:i:s') }}
                                    @endif
                                </td>
                            </tr>
                        @endif
                    @endif

                    @php
                        $transactionSr = 1;
                        $totalQty = 0;
                        $datetime = 0;
                    
                        $phGrossTotal = $productTransaction->ph_gross_total;
                        $phNetTaxableAmt = $productTransaction->ph_net_taxable_amt;
                        $phCgstAmt = $productTransaction->ph_cgst_amt;
                        $phSgstAmt = $productTransaction->ph_sgst_amt;
                        $phTotal = $productTransaction->ph_total;
                        $refTrnNo = 'I' . $productTransaction->ref_trn_id;
                    @endphp

                    <tr>
                        <td width="4%" class="td bold alignTop borderTopBottom txtRight ">{{ $productTransaction->trn_type."/".$productTransaction->trn_fyear."/" . $productTransaction->ph_trn_id }}</td>
                        <td class="td bold alignTop borderTopBottom ">{{ \Helper::getDisplayDate($productTransaction->ph_trn_date) }}</td>
                        <td colspan="10" class="td bold alignTop borderTopBottom ">{{ \Helper::zeroValueToNbspSpace($refTrnNo) }}</td>
                        <td class="td bold alignTop borderTopBottom txtRight ">{{ \Helper::customAmountFormat($phTotal) }}</td>
                        <td class="td bold alignTop borderTopBottom txtRight ">{{ \Helper::customAmountFormat($phNetTaxableAmt) }}</td>
                        <td class="td bold alignTop borderTopBottom txtRight ">{{ \Helper::customAmountFormat($phCgstAmt) }}</td>
                        <td class="td bold alignTop borderTopBottom txtRight ">{{ \Helper::customAmountFormat($phSgstAmt) }}</td>
                    </tr>
                @endif
                @if ($reportType === 'B')
                    @php
                        $Original_Amt=\app\Http\Controllers\GSTCreditNoteController::get_ref_trn_data($productTransaction->trn_type, $productTransaction->ph_trn_id, $productTransaction->trn_sr_no);
                    @endphp
                    <tr>
                        <td class="td notBold alignTop borderTopGray txtRight ">{{ $transactionSr++ }}</td>
                        <td class="td notBold alignTop borderTopGray ">{{ \Helper::zeroValueToNbspSpace($productTransaction->product_name) }}</td>
                        <td class="td notBold alignTop borderTopGray ">{{ \Helper::zeroValueToNbspSpace($productTransaction->product_hsn_code) }}</td>
                        <td class="td notBold alignTop borderTopGray ">{{ \Helper::zeroValueToNbspSpace($productTransaction->batch_no) }}</td>
                        <td class="td notBold alignTop borderTopGray ">{{ \Helper::getMonthYearFromDate($productTransaction->batch_exp) }}</td>
                        <td class="td notBold alignTop borderTopGray ">{{ \Helper::zeroValueToNbspSpace($productTransaction->category_abbrev) }}</td>
                        <td class="td notBold alignTop borderTopGray ">{{ \Helper::zeroValueToDash($productTransaction->suom) }}</td>
                        <td class="td notBold alignTop borderTopGray ">{{ \Helper::zeroValueToDash($productTransaction->conversion_factor) }}</td>
                        <td class="td notBold alignTop borderTopGray txtRight ">{{ \Helper::zeroValueToNbspSpace($productTransaction->quantity) }}</td>
                        <td class="td notBold alignTop borderTopGray txtRight ">{{ \Helper::zeroValueToNbspSpace(floatval($productTransaction->sgst_percentage) + floatval($productTransaction->cgst_percentage) + floatval($productTransaction->igst_percentage)) }}</td>
                        <td class="td notBold alignTop borderTopGray txtRight ">{{ number_format($Original_Amt,2) }}</td>
                        <td class="td notBold alignTop borderTopGray txtRight ">{{ number_format($Original_Amt-$productTransaction->total,2) }}</td>
                        <td class="td notBold alignTop borderTopGray txtRight ">{{ \Helper::customAmountFormat($productTransaction->total) }}</td>
                        <td class="td notBold alignTop borderTopGray txtRight ">{{ \Helper::customAmountFormat($productTransaction->taxable_amt) }}</td>
                        <td class="td notBold alignTop borderTopGray txtRight ">{{ \Helper::customAmountFormat( floatval($productTransaction->cgst_value)) }}</td>
                        <td class="td notBold alignTop borderTopGray txtRight ">{{ \Helper::customAmountFormat(floatval($productTransaction->sgst_value)) }}</td>
                    </tr>
                @endif
                @php
                    $createdBy = strtoupper($productTransaction->ph_created_by);
                    $totalQty += $productTransaction->quantity;
                    $grosstotalQty += $productTransaction->quantity;
                    $totalAmount += $productTransaction->total;
                    $totalRevisedAmount += $Original_Amt-$productTransaction->total;
                    $totalOriginalQty += $Original_Amt;
                    $totalTaxable+=$productTransaction->taxable_amt;
                    $totalCGST+=$productTransaction->cgst_value;
                    $totalSGST+=$productTransaction->sgst_value;

                    $datetime = $productTransaction->created_date;
                    $oldPhTrnType = $productTransaction->ph_trn_type;
                    $oldPhTrnId = $productTransaction->ph_trn_id;

                    $grossphNetTaxableAmt += $productTransaction->ph_net_taxable_amt;
                    $grossphCgstAmt += $productTransaction->ph_cgst_amt;
                    $grossphSgstAmt += $productTransaction->ph_sgst_amt;
                    $grossphTotal += $productTransaction->ph_total;
                    
                @endphp
            @endforeach
            @if ($reportType === 'B')
                <tr>
                    <td colspan="8" class="td bold alignTop txtRight ">{{__('Total Qty')}} :
                    </td>
                    <td colspan="1" class="td bold alignTop txtRight borderTopBottom ">
                        {{ \Helper::zeroValueToNbspSpace($totalQty) }}</td>
                    <td colspan="13" class="td smallFont notBold alignTop borderTopBottom txtRight ">
                        <i>{{ __('Created By') }}:</i>
                        @if ($createdBy)
                            {{ $createdBy . '  ' . Carbon\Carbon::parse($datetime)->format('d-m-Y h:i:s') }}
                        @endif
                    </td>
                </tr>
            @endif
        </tbody>
        @php
            $currentTime = \Carbon\Carbon::now();
        @endphp
        <tfoot>
            @if ($reportType === 'B')
                <tr>
                    <td colspan="8" class="td bold alignTop txtRight ">
                        {{__('Total Credit Note')}} : </td>
                    <td colspan="1" class="td bold alignTop txtRight borderTopBottom ">{{ \Helper::zeroValueToNbspSpace($bill) }}</td>
                    <td colspan="1" class="td bold alignTop txtRight borderTopBottom "></td>
                    <td colspan="1" class="td bold alignTop txtRight borderTopBottom ">{{ \Helper::customAmountFormat($totalOriginalQty) }}</td>
                    <td colspan="1" class="td bold alignTop txtRight borderTopBottom ">{{ \Helper::customAmountFormat($totalRevisedAmount) }}</td>
                    <td colspan="1" class="td bold alignTop txtRight borderTopBottom ">{{ \Helper::customAmountFormat($totalAmount) }}</td>
                    <td colspan="1" class="td bold alignTop txtRight borderTopBottom ">{{ \Helper::customAmountFormat($totalTaxable) }}</td>
                    <td colspan="1" class="td bold alignTop txtRight borderTopBottom ">{{ \Helper::customAmountFormat($totalCGST) }}</td>
                    <td colspan="1" class="td bold alignTop txtRight borderTopBottom ">{{ \Helper::customAmountFormat($totalSGST) }}</td>   
                    <td colspan="13" class="td notBold alignTop borderTopBottom smallFont txtRight ">
                    </td>
                </tr>
            @else
                <tr>
                    <td colspan="12" class="td bold alignTop txtRight ">{{__('Total Credit Note')}} : </td>
                    <td colspan="1" class="td bold alignTop txtRight borderTopBottom ">{{ \Helper::customAmountFormat($grossphTotal) }}</td>
                    <td colspan="1" class="td bold alignTop txtRight borderTopBottom ">{{ \Helper::customAmountFormat($grossphNetTaxableAmt) }}</td>
                    <td colspan="1" class="td bold alignTop txtRight borderTopBottom ">{{ \Helper::customAmountFormat($grossphCgstAmt) }}</td>
                    <td colspan="1" class="td bold alignTop txtRight borderTopBottom ">{{ \Helper::customAmountFormat($grossphSgstAmt) }}</td> 
                    <td colspan="13" class="td notBold alignTop borderTopBottom smallFont txtRight ">
                    </td>
                </tr>
            @endif
            <tr>
                <td colspan="16" class="th smallFont noPadding alignTop borderTopBottom txtRight">{{ strtoupper(Session::get('userId')) . ' # ' . $currentTime->format('d/m/Y H:i:s ') }}</td>
            </tr>
        </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="{{ $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/RegisterInput') }}" 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-->