@extends('Reports.template')

@php
    $reportTitle = 'Doctor Wise - Sales Report';
@endphp


<!--Title-->
@section('title')
    {{ $reportTitle }}
@endsection
<!--Title Close-->

<!--External CSS-->
@section('ExternalCss')
    @parent
    <style>
        @media print {
            @page {
                size: A4 portrait;
            }
        }
    </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="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="10" 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>
            @if ($reportType != 'PMS')
                @php
                    if ($billType === 'P') {
                        $billTypeTitle = 'Cash';
                    } elseif ($billType === 'C') {
                        $billTypeTitle = 'Credit';
                    } elseif ($billType === 'B') {
                        $billTypeTitle = 'Both';
                    }
                    if ($trnStatus === 'P') {
                        $trnStatusMessage = 'Partial';
                    } elseif ($trnStatus === 'T') {
                        $trnStatusMessage = 'Cancelled';
                    } elseif ($trnStatus === 'C') {
                        $trnStatusMessage = 'Completed';
                    } else {
                        $trnStatusMessage = 'ALL';
                    }
                @endphp
                <tr>
                    <th colspan="4" class="th borderNone borderBottom reportTitle">{{ $reportTitle . ' ' }} <label
                            class="fontsize12 bold">{{ ' ( Bill Type : ' . $billTypeTitle . ' ) (Status : ' . $trnStatusMessage . ' )' }}</label>
                    </th>
                    <th colspan="4" class="th borderNone borderBottom">Store : {{ $storeName }}</th>
                    <th colspan="4" class="txtRight th borderNone borderBottom">Period :
                        {{ \Helper::getDisplayDate($fromDate) }} TO {{ \Helper::getDisplayDate($toDate) }}</th>
                </tr>
                @if(!is_null($rateCard))
                    <tr>
                        <th colspan="12" class="th borderNone borderBottom">
                            Patient Category :
                            @php
                                    $cat="";
                                    foreach ($rateCard as $item)
                                        $cat.= $item->rate_card .'-'. $item->rate_type .', ';
                            @endphp
                            {{ rtrim($cat,', ') }}
                        </th>
                    </tr>
                @endif
                <tr>
                    <th width="8%" class="th noPadding alignTop borderTop borderTopBottom txtRight">UH ID / Cust ID&emsp;&emsp;</th>
                    <th class="th noPadding alignTop borderTop borderTopBottom">Patient / Customer Name</th>
                    <th class="th noPadding alignTop borderTop borderTopBottom">Patient Category</th>
                    <th width="7%" class="th noPadding alignTop borderTop borderTopBottom">OP ID</th>
                    <th width="7%" class="th noPadding alignTop borderTop borderTopBottom">IP ID</th>
                    @if($doctorwiseorpatient == "P")
                    <th class="th noPadding alignTop borderTop borderTopBottom">Doctor</th>
                    <th class="th noPadding alignTop borderTop borderTopBottom">Bill No&emsp;</th>
                    @else
                    <th colspan="2" class="th noPadding alignTop borderTop borderTopBottom">Bill No&emsp;</th>
                    @endif
                    <th class="th noPadding alignTop borderTop borderTopBottom">Bill Date</th>
                    <th width="8%" class="th noPadding alignTop borderTop borderTopBottom txtRight">Invoice</th>
                    <th width="8%" class="th noPadding alignTop borderTop borderTopBottom txtRight">R.Off</th>
                    <th class="th noPadding alignTop borderTop borderTopBottom txtRight">Net Amount</th>
                    <th class="th noPadding alignTop borderTop borderTopBottom txtRight">Created By</th>
                </tr>
        </thead>
        <tbody>
            @php
                $patOrCustName = 0;
                $strike = 'noStrike';
                $oldDoctorID = ""; $oldPatOrCustName = "";
                $invoiceTotal = 0; $roundOffTotal = 0; $netAmtTotal = 0;
                $patInvoiceTotal = 0; $patRoundTotal = 0; $patNetAmtTotal = 0;
            @endphp
            
            @foreach ($productTransactionData as $key => $productTransaction)
                @php
                    $strike = 'noStrike';
                    if ($productTransaction->patient_name != '') {
                        $patORCustID = $productTransaction->patient_id;
                        $patOrCustName =  $productTransaction->patient_name;
                    } else {
                        $patORCustID =  '*' . $productTransaction->ph_cust_id;
                        $patOrCustName = $productTransaction->ph_cust_name;
                    }
                
                    $doctorID = $productTransaction->doctor_id;
                @endphp
                
                @if($oldPatOrCustName != "" && $patOrCustName != $oldPatOrCustName)
                    <tr>
                        <td colspan="8" class="td bold noPadding alignTop borderTopBottom txtRight">Patient Total</td>
                        <td class="td bold noPadding alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($patInvoiceTotal) }}</td>
                        <td class="td bold noPadding alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($patRoundTotal) }}</td>
                        <td class="td bold noPadding alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($patNetAmtTotal) }}</td>
                        <td class="td bold noPadding alignTop borderTopBottom"></td>
                    </tr>
                        @php
                            $patInvoiceTotal = 0; $patRoundTotal = 0; $patNetAmtTotal = 0;
                        @endphp
                @endif
            
                @if($doctorID != $oldDoctorID && $doctorwiseorpatient == "D")
                    @if($oldDoctorID)
                        <tr>
                            <td colspan="7" class="td bold noPadding alignTop borderTopBottom txtRight">Doctor Total</td>
                            <td class="td bold noPadding alignTop borderTopBottom"></td>
                            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($invoiceTotal) }}</td>
                            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($roundOffTotal) }}</td>
                            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($netAmtTotal) }}</td>
                            <td class="td bold noPadding alignTop borderTopBottom"></td>
                        </tr>
                        @php
                            $invoiceTotal = 0; $roundOffTotal = 0; $netAmtTotal = 0;
                            $patInvoiceTotal = 0; $patRoundTotal = 0; $patNetAmtTotal = 0; $oldPatOrCustName = "";
                        @endphp
                    @endif
                <tr>
                    <td colspan="12" class="td bold noPadding alignTop borderTopBottom">
                        {{ $productTransaction->doctor_name }}
                    </td>
                </tr>
                @endif

                @if ($productTransaction->ph_trn_status == 'T')
                    @php
                        $strike = 'strike';
                    @endphp
                @endif

                @if ($productTransaction->ph_trn_type == 'I' || $productTransaction->ph_trn_type == 'DC')
                    @php
                        $phInvoiceAmt = $productTransaction->ph_invoice_amt;
                        $phRoundOff = $productTransaction->ph_round_off;
                        $phTotal = $productTransaction->ph_total;
                    @endphp
                @else
                    @php
                        $phInvoiceAmt = -1 * $productTransaction->ph_invoice_amt;
                        $phRoundOff = -1 * $productTransaction->ph_round_off;
                        $phTotal = -1 * $productTransaction->ph_total;
                    @endphp
                @endif

                @php
                    $paymentMode = '';
                @endphp
                
                @if ($productTransaction->is_credit_bill == 'N')
                    @php
                        $paymentMode = $productTransaction->paymentMode;
                    @endphp
                @endif

                    <tr>
                        <td class="td alignTop borderTopBottomGray txtRight {{ $strike }}">{{ $patORCustID }}&emsp;&emsp;</td>
                        <td class="td alignTop borderTopBottomGray {{ $strike }}">{{ $patOrCustName }}</td>
                        <td class="td alignTop borderTopBottomGray {{ $strike }}">{{ $productTransaction->rate_card.' - '.$productTransaction->rate_type }}</td>
                        <td class="td alignTop borderTopBottomGray {{ $strike }}">{{ $productTransaction->opd_reg_id }}</td>
                        <td class="td alignTop borderTopBottomGray {{ $strike }}">{{ \Helper::zeroValueToDash($productTransaction->ipd_reg_id) }}</td>
                        @if($doctorwiseorpatient == "P")
                        <td class="td alignTop borderTopBottomGray {{ $strike }}">
                            {{ $productTransaction->doctor_name }}
                        </td>
                        <td class="td alignTop borderTopBottomGray {{ $strike }}">
                            @if ($productTransaction->is_credit_bill == 'Y')
                                <span class="fontsize10">&#10033;</span>
                            @endif {{ $productTransaction->ph_trn_type . "/" . $productTransaction->trn_fyear . "/" . $productTransaction->ph_trn_id }}                                 &emsp;
                        </td>
                        @else 
                        <td colspan="2" class="td alignTop borderTopBottomGray {{ $strike }}">
                            @if ($productTransaction->is_credit_bill == 'Y')
                                <span class="fontsize10">&#10033;</span>
                            @endif {{ $productTransaction->ph_trn_type . "/" . $productTransaction->trn_fyear . "/" . $productTransaction->ph_trn_id }}                                 &emsp;
                        </td>
                        @endif
                        <td class="td alignTop borderTopBottomGray {{ $strike }}">{{ \Helper::getDisplayDate($productTransaction->trn_date) }}</td>
                        <td class="td alignTop borderTopBottomGray txtRight {{ $strike }}">{{ \Helper::customAmountFormat($phInvoiceAmt) }}</td>
                        <td class="td alignTop borderTopBottomGray txtRight {{ $strike }}">{{ \Helper::customAmountFormat($phRoundOff) }}</td>
                        <td class="td alignTop borderTopBottomGray txtRight {{ $strike }}">{{ \Helper::customAmountFormat($phTotal) }}</td>
                        <td class="td alignTop borderTopBottomGray txtRight {{ $strike }}">{{ $productTransaction->ph_created_by }}</td>
                    </tr>
                @php
                    $oldDoctorID = $productTransaction->doctor_id;
                    $oldPatOrCustName = $patOrCustName;
                    
                    $invoiceTotal += $phInvoiceAmt;
                    $roundOffTotal += $phRoundOff; 
                    $netAmtTotal += $phTotal;
                    
                    $patInvoiceTotal += $phInvoiceAmt;
                    $patRoundTotal += $phRoundOff;
                    $patNetAmtTotal += $phTotal;
                    
                @endphp
            @endforeach
            
            
            @if(($patInvoiceTotal != 0 || $patRoundTotal != 0 || $patNetAmtTotal != 0))
                <tr>
                    <td colspan="8" class="td bold noPadding alignTop borderTopBottom txtRight">Patient Total</td>
                    <td class="td bold noPadding alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($patInvoiceTotal) }}</td>
                    <td class="td bold noPadding alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($patRoundTotal) }}</td>
                    <td class="td bold noPadding alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($patNetAmtTotal) }}</td>
                    <td class="td bold noPadding alignTop borderTopBottom"></td>
                </tr>
            @endif
            
            @if(($invoiceTotal != 0 || $roundOffTotal != 0 || $netAmtTotal != 0) && $doctorwiseorpatient == "D")
                <tr>
                    <td colspan="7" class="td bold noPadding alignTop borderTopBottom txtRight">Doctor Total</td>
                    <td class="td bold noPadding alignTop borderTopBottom"></td>
                    <td class="td bold noPadding alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($invoiceTotal) }}</td>
                    <td class="td bold noPadding alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($roundOffTotal) }}</td>
                    <td class="td bold noPadding alignTop borderTopBottom txtRight">{{ \Helper::customAmountFormat($netAmtTotal) }}</td>
                    <td class="td bold noPadding alignTop borderTopBottom"></td>
                </tr>
            @endif

        </tbody>
        @php
            $currentTime = \Carbon\Carbon::now();
        @endphp
        <tfoot>
            <th colspan="6" class="th smallFont noPadding alignTop borderTopBottom"><span
                    class="fontsize10">&#10033;</span> {{ Config::get('constants.asterisk.WALK_CUST') }},&nbsp;<span
                    class="fontsize10">&#10033;{{ 'Credit Bill' }}</span></th>
            <td colspan="6" class="th smallFont noPadding alignTop borderTopBottom txtRight">
                {{ strtoupper(Session::get('userId')) . ' # ' . $currentTime->format('d/m/Y H:i:s ') }}</td>
        </tfoot>
        @endif
    </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('doctorWise/patientSalesReportInput') }}" 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-->