@extends('Reports.template')

<!--Title-->
@section('title')
PTR Comparison Report
@endsection
<!--Title Close-->

<!--External CSS-->
@section('ExternalCss')
@parent
@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="1" 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="12" 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>
        <tr>
            <th colspan="3" class="th noPadding alignTop borderTopBottom reportTitle">PTR Comparison Report</th>
            <th colspan="10" class="th noPadding alignTop borderTopBottom">Note : &nbsp;1) For a product, last Purchase Voucer  is considered for each supplier for given date range.<br/> &emsp;&emsp;&emsp;2) Net PTR is net off discount, free quanity and scheme amout. It is final landed rate.
            </th>
        </tr>
        <tr>
            <th class="th noPadding alignTop borderTopBottom">Product Name</th>
            <th class="th noPadding alignTop borderTopBottom">Unit</th>
            <th class="th noPadding alignTop borderTopBottom" width="12%">Generic Name</th>
            <th class="th noPadding alignTop borderTopBottom">Supplier Name</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">MRP</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">MRP Per Unit</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">PTR</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Disc %</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Disc Amt</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Net PTR</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Net PTR Per Unit</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Net PTR Per Unit With GST</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Margin %</th>
        </tr>
    </thead>
    <tbody>
        @php
        $sr = 1;
        $productid1 = "";
        $productid2 = "";
        $displayProductName = "";
        @endphp
        @foreach($reportData as $key => $productDetail)
        @php
            $productid1 = $productDetail->product_id;
            if($productid1 != $productid2){
                $borderClass = 'borderTop';
                $displayProductName = $productDetail->product_name;
            } else {
                $borderClass = 'borderTopGray';
                $displayProductName = "";
            }
            
            if($productDetail->mrp <= 0){
                $margin = 0;
            } else {
                $margin = (($productDetail->mrp - $productDetail->price) / $productDetail->mrp) * 100;
            }
            
            $discountPercent = $productDetail->discount_type == "P" ? $productDetail->discount : 0;
            $discountAmt = $productDetail->price * ($discountPercent/100);
        @endphp
        <tr>
            <td class="td noPadding alignTop {{ $borderClass }}">{{ $displayProductName }}</td>
            <td class="td noPadding alignTop {{ $borderClass }}">1X{{ $productDetail->conversion_factor }}</td>
            <td class="td noPadding alignTop {{ $borderClass }}">{{ $productDetail->generic_drug_name }}</td>
            <td class="td noPadding alignTop {{ $borderClass }}">{{ $productDetail->supplier_name }}</td>
            <td class="td noPadding alignTop {{ $borderClass }} txtRight">{{ \Helper::customAmountFormat($productDetail->mrp) }}</td>
            <td class="td noPadding alignTop {{ $borderClass }} txtRight">{{ \Helper::customAmountFormat($productDetail->mrp / $productDetail->conversion_factor) }}</td>
            <td class="td noPadding alignTop {{ $borderClass }} txtRight">{{ \Helper::customAmountFormat($productDetail->price) }}</td>
            <td class="td noPadding alignTop {{ $borderClass }} txtRight">{{ \Helper::customAmountFormat($discountPercent) }}</td>
            <td class="td noPadding alignTop {{ $borderClass }} txtRight">{{ \Helper::customAmountFormat($discountAmt) }}</td>
            <td class="td noPadding alignTop {{ $borderClass }} txtRight">{{ \Helper::customAmountFormat($productDetail->net_rate) }}</td>
            <td class="td noPadding alignTop {{ $borderClass }} txtRight">{{ \Helper::customAmountFormat($productDetail->price_per_unit_suom_wo_gst) }}</td>
            <td class="td noPadding alignTop {{ $borderClass }} txtRight">{{ \Helper::customAmountFormat($productDetail->price_per_unit_suom) }}</td>
            <td class="td noPadding alignTop {{ $borderClass }} txtRight">{{ \Helper::customAmountFormat($margin) }}</td>
        </tr>
        @php
            $productid2 = $productDetail->product_id;
        @endphp
        @endforeach
<!--        <tr>
            <td colspan="5" class="td bold noPadding alignTop borderTop txtRight">Total :</td>
            <td colspan="3" class="td bold noPadding alignTop borderTop txtRight"></td>
        </tr>-->
    </tbody>
    @php 
    $currentTime  = \Carbon\Carbon::now(); 
    @endphp
    <tfoot>
        <td colspan="13" class="th smallFont noPadding alignTop borderTopBottom txtRight">{{ strtoupper(Session::get('userId'))." # ".$currentTime->format('d/m/Y H:i:s ')}}</td>
    </tfoot>
</table>
<br/><br/>

<!--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="PharmacyUserWiseCollection">
            <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('report/priceCompairInput') }}" 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')
<script src="{{ asset ("/js/export_to_excel.js?$releaseVersion") }}"></script>
@endsection
<!--External JS Close-->