@extends('Reports.template')

<!--Title-->
@section('title')
@if($reportType == "D")
@php
$reportTitle = "Doctor Wise Sales Report (Day Wise)";    
@endphp
@else
@php
$reportTitle = "Doctor Wise Sales Report (Summary)";    
@endphp
@endif
{{$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="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 . " " . $patType}}</th>
            <th colspan="4" class="txtRight th borderNone borderBottom">Store : {{$storeName}}</th>
            <th colspan="4" class="txtRight th borderNone borderBottom">Period : {{\Helper::getDisplayDate($fromDate)}} TO {{\Helper::getDisplayDate($toDate)}}</th>
        </tr>
        <tr>
            @if($reportType == "D")
            <th class="th noPadding alignTop borderTop borderTopBottom">Doctor Name</th>
            <th class="th noPadding alignTop borderTop borderTopBottom">Bill Date</th>
            @else
            <th colspan="2" class="th noPadding alignTop borderTop borderTopBottom">Doctor Name</th>
            @endif
            @if($patientFilter != '')
            <th class="th noPadding alignTop borderTop borderTopBottom">Patient</th>
            @else
            <th class="th noPadding alignTop borderTop borderTopBottom"></th>
            @endif
            <th class="th noPadding alignTop borderTop borderTopBottom">Product Name</th>
            <th class="th noPadding alignTop borderTop borderTopBottom">Mfg</th>
            <th class="th noPadding alignTop borderTop borderTopBottom txtRight">Category</th>
            <th class="th noPadding alignTop borderTop borderTopBottom txtRight">SUOM</th>
            <th class="th noPadding alignTop borderTop borderTopBottom txtRight">Sales Qty</th>
            <th class="th noPadding alignTop borderTop borderTopBottom txtRight">PTR as per Stock Unit</th>
            <th class="th noPadding alignTop borderTop borderTopBottom txtRight">Total as per PTR</th>
            <!--<th class="th noPadding alignTop borderTop borderTopBottom txtRight">Sales Rate</th>-->
            <th class="th noPadding alignTop borderTop borderTopBottom txtRight">Sales Amt</th>
            <th class="th noPadding alignTop borderTop borderTopBottom txtRight">Diff Amt</th>
        </tr>
    </thead>
    <tbody>
        @php
        $oldDoctorID = '';
        $totalSalesAmt = 0;
        $totalPtrAsPerStock = 0;
        $finalTotalAsPerStock = 0;
        $totalPtrPerQty = 0;
        $finalTotalPtrPerQty = 0;
        $totalDiffAmt = 0;
        $finalTotalDiffAmt = 0;
        $finalTotalSalesAmt = 0;
        @endphp
        @foreach($salesData as $sales)
        @if($sales->total_quantity != 0)
        @php
        $doctorID = $sales->doctor_id;
        @endphp
        @if($doctorID != $oldDoctorID)
        @if($totalSalesAmt != 0 && $oldDoctorID != '')
        <tr>
            <td colspan="9" class="td bold noPadding alignTop borderTopGray borderBottom txtRight">Total : </td>
            <!--<td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalPtrAsPerStock)}}</th>-->
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalPtrPerQty)}}</th>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalSalesAmt)}}</th>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalDiffAmt)}}</th>
        </tr>
        @endif
        @php
        $trnDate = ''; 
        $totalSalesAmt = $sales->total_amt;   
        $finalTotalSalesAmt += $sales->total_amt; 
        
        $ptrAmount = $sales->ptr;
        $totalPtrAmount = $sales->ptr * $sales->total_quantity;
        $diffAmt = $sales->total_amt - $totalPtrAmount;
        
        $totalPtrAsPerStock = $ptrAmount;
        $finalTotalAsPerStock += $ptrAmount;
        
        $totalPtrPerQty = $totalPtrAmount;
        $finalTotalPtrPerQty += $totalPtrAmount;
        
        $totalDiffAmt = $diffAmt;
        $finalTotalDiffAmt += $diffAmt;
        
        if($sales->patient_id != NULL){
            $patientDetail = $sales->patient_id . ' / '. $sales->patient_name;
        } else {
            $patientDetail = $sales->ph_cust_id . ' / '. $sales->ph_cust_name;
        }
        if($patientFilter == ''){
            $patientDetail = '';
        }
        @endphp
        <tr>
            @if($reportType == "D")
            <td class="td bold noPadding alignTop borderTop borderTop borderBottomGray">{{$sales->doctor_name}}</td>
            <td class="td bold noPadding alignTop borderTop borderTop borderBottomGray">{{\Helper::getDisplayDate($sales->trn_date)}}</td>
            @else
            <td colspan="2" class="td bold noPadding alignTop borderTop borderBottomGray">{{$sales->doctor_name}}</th>
                @endif
            <td class="td noPadding alignTop borderTop borderBottomGray">{{$patientDetail}}</th>
            <td class="td noPadding alignTop borderTop borderBottomGray">{{$sales->product_name}}</th>
            <td class="td noPadding alignTop borderTop borderBottomGray">{{$sales->manufacturer_name}}</th>
            <td class="td noPadding alignTop borderTop borderBottomGray txtRight">{{ $sales->category_abbrev }}</th>
            <td class="td noPadding alignTop borderTop borderBottomGray txtRight">{{ $sales->SUOM }}</th>
            <td class="td noPadding alignTop borderTop borderBottomGray txtRight">{{ $sales->total_quantity }}</th>
            <td class="td noPadding alignTop borderTop borderBottomGray txtRight">{{ \Helper::customAmountFormat($ptrAmount) }}</th>
            <td class="td noPadding alignTop borderTop borderBottomGray txtRight">{{ \Helper::customAmountFormat($totalPtrAmount) }}</th>
            <!--<td class="td noPadding alignTop borderTop borderBottomGray txtRight">{{\Helper::customAmountFormat($sales->sales_rate)}}</th>-->
            <td class="td noPadding alignTop borderTop borderBottomGray txtRight">{{\Helper::customAmountFormat($sales->total_amt)}}</th>
            <td class="td noPadding alignTop borderTop borderBottomGray txtRight">{{ \Helper::customAmountFormat($diffAmt) }}</th>
        </tr>
        @else
        @php
        
        $ptrAmount = $sales->ptr;
        $totalPtrAmount = $sales->ptr * $sales->total_quantity;
        $diffAmt = $sales->total_amt - $totalPtrAmount;
        
        $totalSalesAmt += $sales->total_amt;   
        $finalTotalSalesAmt += $sales->total_amt;
        
        $totalPtrAsPerStock += $ptrAmount;
        $finalTotalAsPerStock += $ptrAmount;
        
        $totalPtrPerQty += $totalPtrAmount;
        $finalTotalPtrPerQty += $totalPtrAmount;
        
        $totalDiffAmt += $diffAmt;
        $finalTotalDiffAmt += $diffAmt;
        
        @endphp
        <tr>
            @if($reportType == "D")
            <td class="td noPadding alignTop borderNone"></td>
            @if(\Helper::getDisplayDate($sales->trn_date) != $trnDate)
            <td class="td bold noPadding alignTop borderTopBottomGray">{{\Helper::getDisplayDate($sales->trn_date)}}</td>
            @else
            <td class="td noPadding alignTop borderNone"></td>
            @endif
            @else
            <td colspan="2" class="td noPadding alignTop borderNone"></th>
            @endif
            @if(\Helper::getDisplayDate($sales->trn_date) != $trnDate)
            <td class="td noPadding alignTop borderTopBottomGray">{{ $patientDetail }}</th>
            @else
            <td class="td noPadding alignTop borderNone"></td>
            @endif
            <td class="td noPadding alignTop borderTopBottomGray">{{$sales->product_name}}</th>
            <td class="td noPadding alignTop borderTopBottomGray">{{$sales->manufacturer_name}}</th>
            <td class="td noPadding alignTop borderTopBottomGray txtRight">{{$sales->category_abbrev}}</th>
            <td class="td noPadding alignTop borderTopBottomGray txtRight">{{$sales->SUOM}}</th>
            <td class="td noPadding alignTop borderTopBottomGray txtRight">{{$sales->total_quantity}}</th>
            <td class="td noPadding alignTop borderTopBottomGray txtRight">{{\Helper::customAmountFormat($ptrAmount)}}</th>
            <td class="td noPadding alignTop borderTopBottomGray txtRight">{{\Helper::customAmountFormat($totalPtrAmount)}}</th>
            <td class="td noPadding alignTop borderTopBottomGray txtRight">{{\Helper::customAmountFormat($sales->total_amt)}}</th>
            <td class="td noPadding alignTop borderTopBottomGray txtRight">{{\Helper::customAmountFormat($diffAmt)}}</th>
        </tr>
        @endif
        @php
        $oldDoctorID = $doctorID; 
        $trnDate = \Helper::getDisplayDate($sales->trn_date);   
        @endphp
        @endif
        @endforeach
        @if($totalSalesAmt != 0)
        <tr>
            <td colspan="9" class="td bold noPadding alignTop borderTopGray borderBottom txtRight">Total : </td>
            <!--<td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalPtrAsPerStock)}}</th>-->
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalPtrPerQty)}}</th>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalSalesAmt)}}</th>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalDiffAmt)}}</th>
        </tr>
        @endif
        <tr>
            <td colspan="9" class="td bold noPadding alignTop borderTopBottom txtRight">Total Sales : </td>
            <!--<td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($finalTotalAsPerStock)}}</th>-->
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($finalTotalPtrPerQty)}}</th>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($finalTotalSalesAmt)}}</th>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($finalTotalDiffAmt)}}</th>
        </tr>
    </tbody>
    <tfoot>
    <td colspan="12" class="th smallFont noPadding alignTop borderTopBottom txtRight">{{ strtoupper(Session::get('userId'))." # ".$currentTime->format('d/m/Y H:i:s ')}}</td>
</tfoot>
</table>
<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="{{$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/DoctorWiseSalesReportInput') }}" 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-->