@extends('Reports.template')

<!--Title-->
@section('title')
@php
    $title= "GST Credit Note";
@endphp
{{$title}}
@endsection
<!--Title Close-->

<!--External CSS-->
@section('ExternalCss')
@parent
<style>
    @media print {
        @page { size: {{$pageSize}} {{$pageOrientation}}}
        .smallFont{font-size:8px !important;}
    }
</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="2" class="th borderNone borderBottom col-md-3 col-xs-3" style="vertical-align:center;">
                @if(isset($businessEntityMasterData[0]->logo) )
                <!--Image-->
                <img class="img-responsive" alt="Pharmacy Logo" src="{{"data:image/jpeg;base64,".base64_encode( $businessEntityMasterData[0]->logo )}}"/>
                @endif
            </th>
            <th colspan="11" class="th borderNaone borderBottom col-md-7 col-xs-7" >
                @if(isset($businessEntityMasterData[0]->name) )
                    <div style="line-height:1.0;" class="heading">{{ $businessEntityMasterData[0]->name }}</div>
                @endif
                @if(isset($businessEntityMasterData[0]->add1) && isset($businessEntityMasterData[0]->add2) && isset($businessEntityMasterData[0]->city) && isset($businessEntityMasterData[0]->pincode))
                    <div style="line-height:1.0;">{{$businessEntityMasterData[0]->add1. " " .$businessEntityMasterData[0]->add2 ." ".$businessEntityMasterData[0]->city." : " .$businessEntityMasterData[0]->pincode }}</div>
                @endif
                @if(isset($businessEntityMasterData[0]->tel1) )
                    <div style="line-height:1.0;">{{"Phone : ".$businessEntityMasterData[0]->tel1}}</div>
                @endif
            </th>
            <th colspan="4" class="th borderNone borderBottom txtRight">
                {{'CREDIT NOTE'}}
            </th>
        </tr>
        @php
        $doctorName = '';

        if ($productHeader[0]->doctor_name != '') {
        $doctorName = $productHeader[0]->doctor_name;
        }

        if($paraDoctor != 'false'){
        $doctorName = $paraDoctor;
        }

        $patientAdress = '';
        if ($productHeader[0]->patient_village != '') {
        $patientAdress = $productHeader[0]->patient_village;
        }
        $trnDate = date("d/m/Y", strtotime(str_replace("-", "/", $productHeader[0]->trn_date)));

        $reportTitle = 'GST CREDIT NOTE ';
        $no = "GCR No : ";
        $date = "GCR Date : ";

        @endphp
        <tr>
            <th colspan="4" class="th col-md-4 col-xs-4 borderNone borderBottom">
                @php
                if($productHeader[0]->patient_id == NULL || $productHeader[0]->patient_id == '0'){
                $patOrCustDetail = "Customer : " . $productHeader[0]->ph_cust_id." / ".$productHeader[0]->ph_cust_name." / ".$productHeader[0]->ph_cust_contact_no;
                }else{
                if($productHeader[0]->is_ptr_applicable == "Y"){
                $patOrCustDetail = "Patient : " . $productHeader[0]->patient_id." / ".$productHeader[0]->patient_name." / ".$productHeader[0]->patient_contact1." (C/o $companyName)";
                }else{
                $patOrCustDetail = "Patient : " . $productHeader[0]->patient_id." / ".$productHeader[0]->patient_name." / ".$productHeader[0]->patient_contact1;
                }
                }
                @endphp
                {{$patOrCustDetail}}
                <br/>
                Address : {{$patientAdress}}
            </th>
            <th colspan="8" class="th col-md-6 col-xs-6 alignTop borderNone borderBottom">
                <span class="heading">
                    {{$reportTitle }}
                </span>
                <br/>
                Prescribed By : {{$doctorName}}
            </th>
            <th colspan="5" class="th col-md-3 col-xs-3 txtRight borderNone borderBottom">
                {{$no.$productHeader[0]->trn_type." / ".$productHeader[0]->trn_fyear." / ".$productHeader[0]->trn_id}}
                <br/>
                {{$date.$trnDate}}
            </th>
        </tr>
        <tr>
            <th colspan="4" class="th noPadding alignTop borderNone borderBottom borderRightGray"><span class="txtRight">Sr.</span> &nbsp; Item Name</th>
            <th colspan="2" width="10%" class="th noPadding alignTop borderNone borderBottom borderRightGray">&nbsp;Batch</th>
            <th width="3%" class="th noPadding alignTop borderNone borderBottom borderRightGray">Category</th>
            <th width="5%" class="th noPadding alignTop borderNone borderBottom borderRightGray">PUOM</th>
            <th width="2%" class="th noPadding alignTop borderNone borderBottom borderRightGray">Pkg</th>
            <th width="3%" class="th noPadding alignTop borderNone borderBottom borderRightGray txtRight">Qty</th>
            <th width="3%" class="th noPadding alignTop borderNone borderBottom borderRightGray txtRight">GST %</th>
            <th width="5%" class="th noPadding alignTop borderNone borderBottom borderRightGray txtCenter">Original Amt</th>
            <th width="5%" class="th noPadding alignTop borderNone borderBottom borderRightGray txtCenter">Revised Amt</th>
            <th width="5%" class="th noPadding alignTop borderNone borderBottom borderRightGray txtCenter">Difference Amt</th>
            <th width="5%" class="th noPadding alignTop borderNone borderBottom borderRightGray txtCenter">Taxable Amt</th>
            <th width="6%" class="th noPadding alignTop borderNone borderBottom borderRightGray txtCenter">CGST</th>
            <th width="6%" class="th noPadding alignTop borderNone borderBottom borderRightGray txtCenter">SGST</th>
        </tr>
    </thead>
    <tbody>
        @php
        $i = 1;
        $sgstAmount = 0;
        $cgstAmount = 0;
        $netTotal = 0;
        $totalQty = 0;
        $oldRefTrnType = '';
        $oldRefTrnId = 0;
        $totaltaxable_amt=0;
        $totalRef_taxable_amt=0;
        @endphp
        
        @foreach ($productTransactionData as $key =>$productTransaction)
        @php
        $time = strtotime($productTransaction->batch_exp);
        $month = date("m",$time);
        $year = date("y",$time);
        $batchExp = $month."/".$year;
        if($year == "70"){
        $batchExp = "";
        }
        
        $gstPercentage = (float)$productTransaction->sgst_percentage + (float)$productTransaction->cgst_percentage;
        $sgstAmount += (float)$productTransaction->sgst_value;
        $cgstAmount += (float)$productTransaction->cgst_value;
        $totalQty += $productTransaction->quantity;
        $netTotal += $productTransaction->total;
        $totaltaxable_amt += $productTransaction->taxable_amt;
        $totalRef_taxable_amt += $ref_productTransactionDetail[$key]->total;
        @endphp

        @if($productTransaction->product_hsn_code!='0' && $productTransaction->product_hsn_code!=NULL && $hsncode->value == 'Y')
              @php
                  $productHsnCode = " --- (".$productTransaction->product_hsn_code.")";
              @endphp
        @else
              @php
                  $productHsnCode = '';
              @endphp
        @endif

        <tr>
            <td colspan="4" class="td notBold borderRightGray borderTopGray"><span class="txtRight">{{ $i++ }}</span> &nbsp; {{ substr($productTransaction->product_name, 0, 35).$productHsnCode }}</td>
            <td colspan="2" class="td notBold borderRightGray borderTopGray">{{ $productTransaction->batch_no }}</td>
            <td class="td notBold borderRightGray borderTopGray">{{$productTransaction->category_abbrev }}</td>
            <td class="td notBold borderRightGray borderTopGray">{{$productTransaction->unit_abbrev}}</td>
            <td class="td notBold txtRight borderRightGray borderTopGray">{{ $productTransaction->conversion_factor }} </td>
            <td class="td notBold txtRight borderRightGray borderTopGray">{{ $productTransaction->quantity }}</td>
            <td class="td notBold txtRight borderRightGray borderTopGray">{{ $gstPercentage }}</td>
            <td class="td notBold txtRight borderRightGray borderTopGray">{{ number_format($ref_productTransactionDetail[$key]->total,2) }}</td>
            <td class="td notBold txtRight borderRightGray borderTopGray">{{ number_format($ref_productTransactionDetail[$key]->total-$productTransaction->total,2) }}</td>
            <td class="td notBold txtRight borderRightGray borderTopGray">{{ number_format($productTransaction->total,2) }}</td>
            <td class="td notBold txtRight borderRightGray borderTopGray">{{ number_format($productTransaction->taxable_amt,2) }}</td>
            <td class="td notBold txtRight borderRightGray borderTopGray">{{ number_format($productTransaction->cgst_value,2) }}</td>
            <td class="td notBold txtRight borderRightGray borderTopGray">{{ number_format($productTransaction->sgst_value,2) }}</td> 
        </tr>

        @php
            $oldRefTrnType = $productTransaction->ref_trn_type;
            $oldRefTrnId = $productTransaction->ref_trn_id;
        @endphp
        @endforeach
        @php $totalGstValue = (float)$productTransaction->sgst_value + (float)$productTransaction->cgst_value @endphp

        <tr>
            <td colspan="9" class="td bold borderTopBottom borderRightGray">
                Refrence : {{$ref_productTransactionDetail[0]->trn_type." / ".$ref_productTransactionDetail[0]->trn_fyear." / ".$ref_productTransactionDetail[0]->trn_id}}
            </td>
            <td class="td bold txtRight borderTopBottom borderRightGray">{{$totalQty }}</td>
            <td class="td bold txtRight borderTopBottom borderRightGray"></td>
            <td class="td bold txtRight borderTopBottom borderRightGray">{{\Helper::zeroValueToNbspSpace(number_format($totalRef_taxable_amt,2))}}</td>
            <td class="td bold txtRight borderTopBottom borderRightGray">{{\Helper::zeroValueToNbspSpace(number_format($totalRef_taxable_amt-$netTotal,2))}}</td>
            <td class="td bold txtRight borderTopBottom borderRightGray">{{\Helper::zeroValueToNbspSpace(number_format($netTotal,2))}}</td>
            <td class="td bold txtRight borderTopBottom borderRightGray">{{\Helper::zeroValueToNbspSpace(number_format($totaltaxable_amt,2))}}</td>
            <td class="td bold txtRight borderTopBottom borderRightGray">{{\Helper::zeroValueToNbspSpace(number_format($cgstAmount,2))}}</td>
            <td class="td bold txtRight borderTopBottom borderRightGray">{{\Helper::zeroValueToNbspSpace(number_format($sgstAmount,2))}}</td>
        </tr>

        <tr>
            <td class="td borderTopBottom" colspan="7"><b>REMARK :</b> {{strtoupper($productHeader[0]->remarks)}} </td>
        </tr>
        <tr>
            <td class="td bold borderTop"  colspan="6">
                @if($productHeader[0]->total >= 0)
                RUPEES {{ strtoupper(\Helper::convertNumber($productHeader[0]->total) . " only") }}
                @endif
            </td>
            <td class="td bold borderTop" colspan="6"></td>
            <td class="td bold txtRight borderTop" colspan="4">NET TOTAL :</td>
            <td class="td bold txtRight borderTop" colspan="1">{{\Helper::zeroValueToNbspSpace(number_format($productHeader[0]->total,2)) }}</td>
        </tr>

    </tbody>
    <tfoot>
        <tr>
            <td class="td bold txtLeft borderTopBottom" colspan="7">
                @if(isset($businessEntityMasterData[0]->dl_no) )
                    D.L NO : {{$businessEntityMasterData[0]->dl_no}}
                @endif

                <br/>
                @if(isset($businessEntityMasterData[0]->dl_no) )
                    GST NO : {{$businessEntityMasterData[0]->gsttin_no}}
                @endif
            </td>
            <td class="td bold txtRight borderTopBottom" colspan="11">
                <br/>
                @if(isset($businessEntityMasterData[0]->name) )
                    E. & O.E. &nbsp;&nbsp; For, {{ strtoupper(($businessEntityMasterData[0]->name)) }}</td>
                @endif
        </tr>
        @if(isset($businessEntityMasterData[0]->name) )
            @if(!empty($businessEntityMasterData[0]->remarks))
            <tr>
                <td class="td borderTopBottom" colspan="17">{!! $businessEntityMasterData[0]->remarks !!}</td>
            </tr>
            @endif
        @endif
        @php
        $currentTime  = \Carbon\Carbon::now();
        @endphp
        <tr>
            <td width="15%" class="td smallFont borderWhite" colspan="10"><i>Print By : </i> {{ strtoupper($userId)." # ".$currentTime->format('d/m/Y H:i:s ')}}</td>
            <td class="td smallFont borderWhite txtRight" colspan="7">
                <i>Created By :</i>
                {{strtoupper($productHeader[0]->ph_created_by.' # '.\Helper::getDisplayDateTime($productHeader[0]->ph_created_date))}}
            </td>
        </tr>
    </tfoot>
</table>

<!--Print-->
<div class="col-xs-12">
    <div class="col-xs-5 col-lg-offset-5 no-print">
        <button class="btn btn-sm btn-info" id="btnexport" data-myval="{{$title}}">
            <span class="glyphicon glyphicon-download-alt"></span> Excel
        </button>

        <button onclick="print()" accesskey="P" class="btn btn-sm btn-success no-print">
            <span class="glyphicon glyphicon-print"></span> Print
        </button>
        @if($trnType == "I" || $trnType == "IR")
            <a onclick="go_back()" accesskey="B" class="no-print btn btn-danger btn-sm">
                <span class="glyphicon glyphicon-arrow-left"></span> Back
            </a>
                {{-- <a onclick="history.back()" accesskey="B" class="no-print btn btn-danger btn-sm">
                    <span class="glyphicon glyphicon-arrow-left"></span> Back
                </a> --}}
            {{-- @if($productHeader[0]->bill_amendment > 0)
                <a href="{{ url('Item/issueBillAmendment') }}" accesskey="B" class="no-print btn btn-danger btn-sm">
                    <span class="glyphicon glyphicon-arrow-left"></span> Back
                </a>
            @else
                <a href="{{ url('Item/issue') }}" accesskey="B" class="no-print btn btn-danger btn-sm">
                    <span class="glyphicon glyphicon-arrow-left"></span> Back
                </a>
            @endif --}}
        @else
            @if($productHeader[0]->ph_is_consignment_dc == "Y")
                <a href="{{ url('Item/ConsignmentDeliveryChallan') }}" accesskey="B" class="no-print btn btn-danger btn-sm">
                    <span class="glyphicon glyphicon-arrow-left"></span> Back
                </a>
            @else
                <a href="{{ url('Item/deliveryChallan') }}" accesskey="B" class="no-print btn btn-danger btn-sm">
                    <span class="glyphicon glyphicon-arrow-left"></span> Back
                </a>
            @endif
        @endif
    </div>
</div>

@endsection

<!--Bootstrap Modals-->
@section('BootstrapModals')
@endsection
<!--Bootstrap Modals Close-->

<!--External JS-->
@section('ExternalJs')
<script>
    $(document).ready(function () {
        window.print();
    });
</script>
<script>
    function go_back()
    {
        var url=document.referrer;
        if(url.includes("Item/issue"))
        {
            window.location=url;
        }
        else
        {
            window.close();
        }
    }
</script>
@endsection
<!--External JS Close-->