@extends('Reports.template')

@php
$reportTitle = 'Product Sale Details with HSN';
@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="3" 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="8" class="th borderNone borderBottom reportTitle">{{$reportTitle." "}}</th>
            <th colspan="8" 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">Case Type</th>
            <th width="8%" class="th noPadding alignTop borderTop borderBottomGray">Bill No</th>
            <th width="15%" class="th noPadding alignTop borderTop borderBottomGray">Medicine Name</th>
            <th width="8%" class="th noPadding alignTop borderTop borderBottomGray">HSN Code</th>
            <th width="8%" class="th noPadding alignTop borderTop borderBottomGray txtRight">Quantity</th>
            <th width="8%" class="th noPadding alignTop borderTop borderBottomGray txtRight">Net Value</th>
            <th width="8%" class="th noPadding alignTop borderTop borderBottomGray txtRight">Taxable Value</th>
            <th width="8%" class="th noPadding alignTop borderTop borderBottomGray txtRight">GST %  </th>
            <th width="10%" class="th noPadding alignTop borderTop borderBottomGray txtRight">Integrated Tax Amount</th>
            <th width="10%" class="th noPadding alignTop borderTop borderBottomGray txtRight">Central Tax Amount</th>
            <th width="10%" class="th noPadding alignTop borderTop borderBottomGray txtRight">State/UT Tax Amount</th>
        </tr>
    </thead>
    <tbody>
        @php
            $net_value=0;
            $taxable_value=0;
            $igst=0;
            $cgst=0;
            $sgst=0;

            $Rnet_value=0;
            $Rtaxable_value=0;
            $Rigst=0;
            $Rcgst=0;
            $Rsgst=0;
        @endphp
        @foreach ($productTransactionData as $ptd)
            <tr>
                @php

                    if($ptd->trn_type=="I")
                    {
                        $net_value+=$ptd->total-$ptd->discount_amt;
                        $taxable_value+=$ptd->taxable_amt;

                        $igst+=$ptd->igst_value;
                        $cgst+=$ptd->cgst_value;
                        $sgst+=$ptd->sgst_value;
                    }
                    else {
                        $Rnet_value+=$ptd->total-$ptd->discount_amt;
                        $Rtaxable_value+=$ptd->taxable_amt;

                        $Rigst+=$ptd->igst_value;
                        $Rcgst+=$ptd->cgst_value;
                        $Rsgst+=$ptd->sgst_value;
                    }


                    if($ptd->visit_type=="O")
                    {
                     $visit_type="OPD";
                    }
                    else if($ptd->visit_type=="I") 
                    {
                        $visit_type="IPD";
                    }
                    else
                    {
                        $visit_type=$ptd->visit_type;
                    }
                @endphp
                <td class="td bold alignTop borderTopBottom">{{ $visit_type }}</td>
                <td width="8%" class="td bold alignTop borderTopBottom">{{$ptd->trn_type .' / '.$ptd->trn_fyear.' / '. $ptd->trn_id}} </td>
                <td class="td bold alignTop borderTopBottom">{{$ptd->product_name}} </td>
                <td class="td bold alignTop borderTopBottom">{{ $ptd->product_hsn_code }}</td>
                <td class="td bold alignTop borderTopBottom txtRight">{{ $ptd->quantity}}</td>
                <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($ptd->total-$ptd->discount_amt)}}</td>
                <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($ptd->taxable_amt)}}</td>
                <td class="td bold alignTop borderTopBottom txtRight">{{ ($ptd->sgst_percentage+$ptd->cgst_percentage+$ptd->igst_percentage ) }}</td>
                <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($ptd->igst_value)}}</td>
                <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($ptd->cgst_value)}}</td>
                <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($ptd->sgst_value)}}</td>
            </tr>
        @endforeach
        <tr>
            <td colspan="5" class="td bold alignTop txtRight borderTopBottom ">Total Sale: </td>
            <td class="td bold alignTop txtRight borderTopBottom ">{{$net_value}}</td>
            <td class="td bold alignTop txtRight borderTopBottom ">{{$taxable_value}}</td>
            <td class="td bold alignTop txtRight borderTopBottom "></td>
            <td class="td bold alignTop txtRight borderTopBottom ">{{$igst!=0 ? $igst : '' }}</td>
            <td class="td bold alignTop txtRight borderTopBottom ">{{$cgst}}</td>
            <td class="td bold alignTop txtRight borderTopBottom ">{{$sgst}}</td>
        </tr>
        <tr>
            <td colspan="5" class="td bold alignTop txtRight borderTopBottom ">Total Sale Return: </td>
            <td class="td bold alignTop txtRight borderTopBottom ">{{$Rnet_value}}</td>
            <td class="td bold alignTop txtRight borderTopBottom ">{{$Rtaxable_value}}</td>
            <td class="td bold alignTop txtRight borderTopBottom "></td>
            <td class="td bold alignTop txtRight borderTopBottom ">{{$Rigst!=0 ? $igst : '' }}</td>
            <td class="td bold alignTop txtRight borderTopBottom ">{{$Rcgst}}</td>
            <td class="td bold alignTop txtRight borderTopBottom ">{{$Rsgst}}</td>
        </tr>
        <tr>
            <td colspan="5" class="td bold alignTop txtRight borderTopBottom ">Total: </td>
            <td class="td bold alignTop txtRight borderTopBottom ">{{$net_value-$Rnet_value}}</td>
            <td class="td bold alignTop txtRight borderTopBottom ">{{$taxable_value-$Rtaxable_value}}</td>
            <td class="td bold alignTop txtRight borderTopBottom "></td>
            <td class="td bold alignTop txtRight borderTopBottom ">{{($igst-$Rigst)!=0 ? $igst : '' }}</td>
            <td class="td bold alignTop txtRight borderTopBottom ">{{$cgst-$Rcgst}}</td>
            <td class="td bold alignTop txtRight borderTopBottom ">{{$sgst-$Rsgst}}</td>
        </tr>
    </tbody>
    @php 
    $currentTime  = \Carbon\Carbon::now(); 
    @endphp
    <tfoot>
    <td colspan="8" class="th smallFont noPadding alignTop borderTopBottom"><span class="fontsize10">&#10033;</span> Partially save</td>
    <td colspan="8" 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="{{$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/HSNReport') }}" 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-->