@extends('Reports.template')

<!--Title-->
@section('title')
@php
$reportTitle = "Sales Summary - Product Wise";  
@endphp
{{__($reportTitle)}}
@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="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="16" 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>
            @if($reportType == "S")
            @php
            $reportTypeDisplay = "(Summary)";    
            @endphp
            @else
            @php
            $reportTypeDisplay = "(With Transactions)";    
            @endphp
            @endif
            <th colspan="3" class="th borderNone borderBottom reportTitle">{{__($reportTitle).__($reportTypeDisplay)}}</th>
            <th colspan="2" class="txtRight th borderNone borderBottom">
                {{__('Store')}} : {{$storeName}}
            </th>
            <th colspan="2" class="txtRight th borderNone borderBottom">
                {{__('Period')}} : {{\Helper::getDisplayDate($fromDate)}} {{__('TO')}} {{\Helper::getDisplayDate($toDate)}}
            </th>
        </tr>

        @if($reportType != 'S')
        <tr>
            <th class="th noPadding alignTop borderTop borderBottomGray txtLeft">{{__('Sr No')}}</th>
            <th class="th noPadding alignTop borderTop borderBottomGray txtLeft">{{__('Product Name')}}</th>
            <th class="th noPadding alignTop borderTop borderBottomGray txtLeft">{{__('Generic Drug Name')}}</th>
            <th class="th noPadding alignTop borderTop borderBottomGray">{{__('Category')}}</th>
            <th class="th noPadding alignTop borderTop borderBottomGray txtRight"></th>
            <th class="th noPadding alignTop borderTop borderBottomGray txtRight"></th>
            <th class="th noPadding alignTop borderTop borderBottomGray txtRight"></th>
        </tr>
        <tr>
            <th class="th noPadding alignTop borderTopBottom">&emsp;{{__('Trn No')}}</th>
            <th class="th noPadding alignTop borderTopBottom txtLeft">&emsp;{{__('Trn Date')}}</th>
            <th colspan="2" class="th noPadding alignTop borderTopBottom txtLeft">&emsp;{{__('Patient / Customer Name')}}</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">&emsp;{{__('Qty')}}</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">&emsp;{{__('MRP')}}</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">&emsp;{{__('Amount')}}</th>
        </tr>
        @else
        <tr>
            <th class="th noPadding alignTop borderTopBottom txtLeft">{{__('Sr No')}}</th>
            <th class="th noPadding alignTop borderTopBottom txtLeft">{{__('Product Name')}}</th>
            <th class="th noPadding alignTop borderTopBottom txtLeft">{{__('Generic Drug Name')}}</th>
            <th class="th noPadding alignTop borderTopBottom">{{__('Category')}}</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">{{__('Total Qty')}}</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">{{__('Total MRP')}}</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">{{__('Total Amount')}}</th>
        </tr>
        @endif

    </thead>
    <tbody>
        @php
        $srheader = 1;
        $sr = 1 ;
        $totalIssueQty = 0;
        $totalIssueAmount = 0;
        $totalAmount = 0;
        $productId = '';
        $patOrCustName = '';

        $finalAmount = 0;
        @endphp

        @foreach ($productData as $product)
        @php
        $finalAmount += $product->total;
        @endphp
        @if($product->product_id != $productId && $product->quantity != 0)

        @if($srheader != 1)
        @if($reportType != 'S')
        <tr>
            <td colspan="4" class="td bold borderTopBottom txtRight"> {{__('Total')}} </td>
            <td class="td bold alignTop borderTopBottom txtRight">{{$totalIssueQty}}</td>
            @if($totalIssueQty != 0)
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat(round($totalIssueAmount/$totalIssueQty,2))}}</td>
            @else
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat(0)}}</td>
            @endif
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalIssueAmount)}}</td>
        <tr>
            @endif
            @endif
            @endif

            @php
            $totalIssueQty = 0;
            $totalIssueAmount = 0;
            $totalSaleProduct = 0;
            $productId = $product->product_id;
            @endphp

            @if($reportType != 'S')
        <tr>
            <td class="td notBold alignTop borderTopBottom txtLeft">{{$srheader++}}</td>
            <td class="td notBold alignTop borderTopBottom">{{$product->product_name}}</td>
            <td class="td notBold alignTop borderTopBottom">{{$product->generic_drug_name}}</td>
            <td class="td notBold alignTop borderTopBottom">{{$product->category_abbrev }}</td>
            <td class="td notBold alignTop borderTopBottom txtRight"></td>
            <td class="td notBold alignTop borderTopBottom txtRight"></td>
            <td class="td notBold alignTop borderTopBottom txtRight"></td>
        </tr>  
        @else
        <tr>
            <td class="td notBold alignTop borderTopBottom txtLeft">{{$srheader++}}</td>
            <td class="td notBold alignTop borderTopBottom">{{$product->product_name}}</td>
            <td class="td notBold alignTop borderTopBottom">{{$product->generic_drug_name}}</td>
            <td class="td notBold alignTop borderTopBottom">{{$product->category_abbrev }}</td>
            <td class="td notBold alignTop borderTopBottom txtRight">{{$product->quantity}}</td>
            @if($product->quantity != 0)
            <td class="td notBold alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat(round($product->total/$product->quantity,2)) }}</td>
            @else
            <td class="td notBold alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat(0) }}</td>
            @endif            
            <td class="td notBold alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($product->total) }}</td>
        </tr> 
        @endif 

        @if($reportType != 'S')
        @foreach ($productTransactionData as $transaction)

        @if($transaction->product_id == $product->product_id)
        @php
        $patOrCustName = ($transaction->patient_name != '')  ? $transaction->patient_name  :  '*'.$transaction->ph_cust_name  ;
        @endphp

        <tr>
            <td class="td notBold alignTop borderTopBottomGray txtRight">&emsp;{{ $transaction->trn_type."/".$transaction->trn_fyear."/".$transaction->trn_id }}</td>
            <td class="td notBold alignTop borderTopBottomGray">&emsp;{{\Helper::getDisplayDate($transaction->trn_date)}}</td>
            <td colspan="2" class="td notBold alignTop borderTopBottomGray txtleft">&emsp;{{$patOrCustName}}</td>
            <td class="td notBold alignTop borderTopBottomGray txtRight">&emsp;{{$transaction->calc_quantity}}</td>
            @if($transaction->calc_quantity != 0)
            <td class="td notBold alignTop borderTopBottomGray txtRight">&emsp;{{ \Helper::customAmountFormat(round($transaction->sold_amt/$transaction->calc_quantity,2))}}</td>
            @else
            <td class="td notBold alignTop borderTopBottomGray txtRight">&emsp;{{ \Helper::customAmountFormat(0)}}</td>
            @endif
            <td class="td notBold alignTop borderTopBottomGray txtRight">&emsp;{{ \Helper::customAmountFormat($transaction->sold_amt)}}</td>
        </tr>

        @php
        $totalIssueQty += $transaction->calc_quantity;
        $totalIssueAmount += $transaction->sold_amt;
        $productId = $product->product_id;
        @endphp
        @endif

        @endforeach
        @endif

        @endforeach

        @if($reportType != 'S')
        <tr>
            <td colspan="4" class="td bold borderTopBottom txtRight"> {{__('Total')}} </td>
            <td class="td bold alignTop txtRight borderTopBottom">{{$totalIssueQty}}</td>
            @if($totalIssueQty != 0)
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat(round($totalIssueAmount/$totalIssueQty,2))}}</td>
            @else
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat(0)}}</td>
            @endif
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($totalIssueAmount)}}</td>
        <tr>
        <tr>
            <td colspan="6" class="td bold alignTop txtRight borderTopBottom">{{__('Grand Total')}}</td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($finalAmount)}}</td>
        </tr> 
        @else
        <tr>
            <td colspan="6" class="td bold alignTop txtRight borderTopBottom">{{__('Grand Total')}}</td>
            <td class="td bold alignTop txtRight borderTopBottom">{{\Helper::customAmountFormat($finalAmount)}}</td>
        </tr>    
        @endif
    </tbody>
    @php 
    $currentTime  = \Carbon\Carbon::now(); 
    @endphp
    <tfoot>
        @if($reportType != 'S')
    <th colspan="2" class="th smallFont noPadding alignTop borderTopBottom"><span class="fontsize10">&#10033;</span> {{__(Config::get('constants.asterisk.WALK_CUST'))}}</th>
    <td colspan="5" class="th smallFont noPadding alignTop borderTopBottom txtRight">{{ strtoupper(Session::get('userId'))." # ".$currentTime->format('d/m/Y H:i:s ')}}</td>    
    @else
    <td colspan="7" class="th smallFont noPadding alignTop borderTopBottom txtRight">{{ strtoupper(Session::get('userId'))." # ".$currentTime->format('d/m/Y H:i:s ')}}</td>    
    @endif
</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/medicineSaleInput') }}" 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-->