@extends('Reports.template')

<!--Title-->
@section('title')
@if($rateType == "W")
@php
$reportTitle = "Gross Profit & Sales Margin Details - With GST";
@endphp
@else
@php
$reportTitle = "Gross Profit & Sales Margin Details - Without GST";
@endphp
@endif
{{$reportTitle}}
@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="4" class="th borderNone borderBottom reportTitle">{{$reportTitle . " (Category : " . $categoryName . ")"}}</th>
            <th colspan="2" class="txtRight th borderNone borderBottom">Store : {{$storeName}}</th>
            <th colspan="3" class="txtRight th borderNone borderBottom">As on : {{$currentTime}}</th>
        </tr>
        <tr>
            <th colspan="9" class="txtleft th borderNone borderBottom">
                Period : {{\Helper::getDisplayDate($fromDate)}} TO {{\Helper::getDisplayDate($toDate)}}
            </th>
        </tr>
        <tr>
            <th rowspan="2" width="4%" class="th noPadding alignTop borderTopBottom txtRight">Sr No.</th>
            <th rowspan="2" width="10%" class="th noPadding alignTop borderTopBottom">&nbsp;Product Name</th>
            <th rowspan="2" width="10%" class="th noPadding alignTop borderTopBottom txtRight">Sale Qty</th>
            <th rowspan="2" width="10%" class="th noPadding alignTop borderTopBottom txtRight">SUOM</th>
            <th width="10%" class="th noPadding alignTop borderTopBottomGray txtRight">Sale Amt</th>
            <th width="10%" class="th noPadding alignTop borderTopBottomGray txtRight">Purchase Amt</th>
            <th width="10%" class="th noPadding alignTop borderTopBottomGray txtRight">Gross Profit Amt</th>
            <th width="10%" class="th noPadding alignTop borderTopBottomGray txtRight">Gross Sales Margin %</th>
            <th width="10%" class="th noPadding alignTop borderTopBottomGray txtRight">Gross Profit %</th>
        </tr>
        <tr>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">(A)</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">(B)</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">(C = A - B)</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">(D = (C / A) * 100)</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">(E = (C / B) * 100)</th>
        </tr>
    </thead>
    <tbody>
        @php
        $sr = 1;
        $totalSaleAmt = 0;
        $totalPurchaseAmt =0;
        $totalProfitAmt =0;
        $negativeBold =0;
        @endphp
        @foreach ($productProfit as $key =>$profit)
        @php
        $profitAmt = $profit->sale_amt-$profit->pur_amt;
        if($profit->pur_amt!=0)
        $ProfitPer = ($profitAmt/$profit->pur_amt)*100;
        if($profit->sale_amt!=0)
        $MarginPer = ($profitAmt/$profit->sale_amt)*100;

        if($profitAmt < '0'){
        $negativeBold = 'td bold alignTop borderTopBottom txtRight';
        }else{
        $negativeBold = 'td notBold alignTop borderTopBottom txtRight';
        }
        if($ProfitPer < '0'){
        $negativeBoldPer = 'td bold alignTop borderTopBottom txtRight';
        }else{
        $negativeBoldPer = 'td notBold alignTop borderTopBottom txtRight';
        }
        if($MarginPer < '0'){
        $negativeBoldMargin = 'td bold alignTop borderTopBottom txtRight';
        }else{
        $negativeBoldMargin = 'td notBold alignTop borderTopBottom txtRight';
        }
        @endphp
        <tr>
            <td style="vertical-align: middle;" class="td notBold alignTop borderTop txtRight">{{$sr++}}</td>
            <td style="vertical-align: middle;"class="td notBold alignTop borderTop">&nbsp;{{$profit->product_name}}</td>
            <td class="td notBold alignTop borderTop txtRight">{{$profit->quantity}}</td>
            <td class="td notBold alignTop borderTop txtRight">{{$profit->stock_unit}}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($profit->sale_amt)}}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($profit->pur_amt)}}</td>
            <td class="{{$negativeBold}}">{{\Helper::customAmountFormat($profitAmt)}}</td>
            <td class="{{$negativeBoldMargin}}">{{\Helper::customAmountFormat($MarginPer).'%'}}</td>
            <td class="{{$negativeBoldPer}}">{{\Helper::customAmountFormat($ProfitPer).'%'}}</td>
        </tr>
        @php

        $totalSaleAmt +=$profit->sale_amt;
        $totalPurchaseAmt +=$profit->pur_amt;
        $totalProfitAmt +=$profitAmt;
        @endphp

        @endforeach

        <tr>
            <td colspan="4" class="td bold borderTopBottom txtRight"> Total </td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalSaleAmt)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalPurchaseAmt)}}</td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalProfitAmt)}}</td>
            @if($totalSaleAmt!=0)
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat(($totalProfitAmt/$totalSaleAmt)*100).'%'}}</td>
            @endif
            @if($totalPurchaseAmt!=0)
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat(($totalProfitAmt/$totalPurchaseAmt)*100).'%'}}</td>
            @endif
        <tr>

    </tbody>
    <tfoot>
    <td colspan="14" 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/profitReportInput') }}" 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-->