@extends('Reports.template')

<!--Title-->
@section('title')
Pharmacy User Wise Collection 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="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">Pharmacy User Wise Collection Report</th>
            <th colspan="6" class="txtRight th borderNone borderBottom">
                Date : {{\Helper::getDisplayDate($date)}}
            </th>
        </tr>
        <tr>
            <th width="4%"  class="th noPadding alignTop borderTopBottom txtRight">Sr No</th>
            <th width="7%" class="th noPadding alignTop borderTopBottom txtRight">Bill No &nbsp;&nbsp;</th>
            <th width="7%" class="th noPadding alignTop borderTopBottom txtRight">Bill Date &nbsp;&nbsp;</th>
            <th colspan="2" class="th noPadding alignTop borderTopBottom">Patient Name</th>
            <th class="th noPadding alignTop borderTopBottom">Payment Details</th>
            <th width="8%" class="th noPadding alignTop borderTopBottom txtRight ">&nbsp;&nbsp;NEFT / RTGS</th>
            <th width="8%" class="th noPadding alignTop borderTopBottom txtRight ">Wallet</th>
            <th width="6%" class="th noPadding alignTop borderTopBottom txtRight ">Cheque</th>
            <th width="6%" class="th noPadding alignTop borderTopBottom txtRight ">Credit Card</th>
            <th width="6%" class="th noPadding alignTop borderTopBottom txtRight ">Debit Card</th>
            <th width="6%" class="th noPadding alignTop borderTopBottom txtRight ">Cash</th>
            <th width="8%" class="th noPadding alignTop borderTopBottom">&emsp;&emsp;User Id</th>
        </tr>  
    </thead>
    <tbody>
        @php
        $sr = 1;
        $totalBillAmount = 0;
        $totalCreditBillAmount = 0;
        $totalReceiptAmount = 0;
        $totalCshAmount = 0;
        $totalCrdAmount = 0;
        $totalDbtAmount = 0;
        $totalChqAmount = 0;
        $totalNeftAmount = 0;
        $totalWalletAmount = 0;
        @endphp
        @foreach($billData as $bill)
        @php
        $cshAmount = 0;
        $crdAmount = 0;
        $dbtAmount = 0;
        $chqAmount = 0;
        $neftAmount = 0;
        $walletAmount = 0;
        $patOrCustName = ($bill->patient_name != '') ? $bill->patient_id." / ".$bill->patient_name : '*'.$bill->ph_cust_id." / ".$bill->ph_cust_name; 
        $headerBillAmount = ($bill->trn_type == 'I') ? $bill->total : $bill->total  * (-1);
        $paymentMode = $bill->payment_mode;

        if($bill->is_credit_bill == 'Y'){
        $creditBillAmount = $headerBillAmount;
        $billAmount = '';
        }else{
        $creditBillAmount = '';
        $billAmount = $headerBillAmount;
        if($paymentMode == 'CSH'){
        $cshAmount += $headerBillAmount;
        $totalCshAmount += $cshAmount;
        }else if($paymentMode == 'CRD'){
        $crdAmount += $headerBillAmount;
        $totalCrdAmount += $crdAmount;
        }else if($paymentMode == '2'){
        $dbtAmount += $headerBillAmount;
        $totalDbtAmount += $dbtAmount;
        }else if($paymentMode == '3'){
        $walletAmount += $headerBillAmount;
        $totalWalletAmount += $walletAmount;
        }else if ($paymentMode == 'CHQ'){
        $chqAmount += $headerBillAmount;
        $totalChqAmount += $chqAmount;
        }else if($paymentMode == '1'){
        $neftAmount += $headerBillAmount;
        $totalNeftAmount += $neftAmount;
        }
        }
        $totalCreditBillAmount = $totalCreditBillAmount + $creditBillAmount;
        $totalBillAmount = $totalBillAmount + $billAmount;


        if(strtoupper($bill->payment_agency != '')){
        $message = $bill->gm_description.",".strtoupper($bill->payment_agency).",".strtoupper($bill->payment_number);
        }else{
        $message = $bill->gm_description;
        }


        @endphp
        <tr>
            <td class="td noPadding alignTop borderTopGray txtRight">{{$sr++}}</td>
            <td class="td noPadding alignTop borderTopGray txtRight">{{$bill->trn_type."".$bill->trn_id}}&nbsp;&nbsp;</td>
            <td class="td noPadding alignTop borderTopGray txtRight">{{\Helper::getDisplayDate($bill->bill_date)}}&nbsp;&nbsp;</td>
            <td class="td noPadding alignTop borderTopGray txtLeft">{{$patOrCustName}}</td>
            <td colspan="2" class="td noPadding alignTop borderTopGray txtLeft ">{{$message}}</td>
            <td class="td noPadding alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat($neftAmount) }}</td>
            <td class="td noPadding alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat($walletAmount) }}</td>
            <td class="td noPadding alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat($chqAmount) }}</td>
            <td class="td noPadding alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat($crdAmount) }}</td>
            <td class="td noPadding alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat($dbtAmount) }}</td>
            <td class="td noPadding alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat($cshAmount) }}</td>
            <td class="td noPadding alignTop borderTopGray">&emsp;&emsp;{{ $bill->created_by }}</td>
        </tr>  
        @endforeach

        @foreach($receiptData as $receipt)
        @php
        $receiptCash = 0;
        $receiptCheque = 0;
        $receiptCredit = 0;
        $receiptDebit = 0;
        $receiptNeft = 0;
        $receiptWallet = 0;
        $receiptAmount = $receipt->receipt_amount;
        if(strtoupper($receipt->payment_agency != '')){
        $message = $receipt->gm_description.", ".strtoupper($receipt->payment_agency).", ".strtoupper($receipt->payment_number)." towards Bills ".$receipt->bill_no ;
        }else{
        $message = $receipt->gm_description." towards Bills ".$receipt->bill_no;
        }

        $totalBillAmount += $receiptAmount;
        $totalReceiptAmount += $receiptAmount;
        $patOrCustName = ($receipt->patient_name != '') ? $receipt->patient_id." / ".$receipt->patient_name : '*'.$receipt->ph_cust_id." / ".$receipt->ph_cust_name; 

        if($receipt->payment_mode == 'CSH'){
        $receiptCash = $receiptAmount;
        $totalCshAmount += $receiptAmount;
        }else if($receipt->payment_mode == 'CHQ'){
        $receiptCheque = $receiptAmount;
        $totalChqAmount += $receiptAmount;
        }else if($receipt->payment_mode == 'CRD'){
        $receiptCredit = $receiptAmount;
        $totalCrdAmount += $receiptAmount;
        }else if($receipt->payment_mode == '2'){
        $receiptDebit = $receiptAmount;
        $totalDbtAmount += $receiptAmount;
        }else if($receipt->payment_mode == '3'){
        $receiptWallet = $receiptAmount;
        $totalWalletAmount += $receiptAmount;
        }else if($receipt->payment_mode == '1'){
        $receiptNeft = $receiptAmount;
        $totalNeftAmount += $receiptAmount;
        }

        @endphp

        <tr>
            <td class="td noPadding alignTop borderTopGray txtRight">{{$sr++}}</td>
            <td class="td noPadding alignTop borderTopGray txtRight">{{$receipt->trn_receipt_no}}&nbsp;&nbsp;</td>
            <td class="td noPadding alignTop borderTopGray txtLeft ">{{$patOrCustName}}</td>
            <td colspan="2" class="td noPadding alignTop borderTopGray txtLeft ">{{$message}}</td>
            <td class="td noPadding alignTop borderTopGray txtRight ">{{ \Helper::customAmountFormat($receiptNeft) }}</td>
            <td class="td noPadding alignTop borderTopGray txtRight ">{{ \Helper::customAmountFormat($receiptWallet) }}</td>
            <td class="td noPadding alignTop borderTopGray txtRight ">{{ \Helper::customAmountFormat($receiptCheque) }}</td>
            <td class="td noPadding alignTop borderTopGray txtRight ">{{ \Helper::customAmountFormat($receiptCredit) }}</td>
            <td class="td noPadding alignTop borderTopGray txtRight ">{{ \Helper::customAmountFormat($receiptDebit) }}</td>
            <td class="td noPadding alignTop borderTopGray txtRight ">{{ \Helper::customAmountFormat($receiptCash) }}</td>
            <td class="td noPadding alignTop borderTopGray ">&emsp;&emsp;{{ $receipt->created_by }}</td>
        </tr>
        @endforeach
        <tr>
            <td colspan="6" class="td bold noPadding alignTop borderTop txtRight">Total :</td>
            <td class="td bold noPadding alignTop borderTop txtRight">{{ \Helper::customAmountFormat($totalNeftAmount) }}</td>
            <td class="td bold noPadding alignTop borderTop txtRight">{{ \Helper::customAmountFormat($totalWalletAmount) }}</td>
            <td class="td bold noPadding alignTop borderTop txtRight">{{ \Helper::customAmountFormat($totalChqAmount) }}</td>
            <td class="td bold noPadding alignTop borderTop txtRight">{{ \Helper::customAmountFormat($totalCrdAmount) }}</td>
            <td class="td bold noPadding alignTop borderTop txtRight">{{ \Helper::customAmountFormat($totalDbtAmount) }}</td>
            <td class="td bold noPadding alignTop borderTop txtRight">{{ \Helper::customAmountFormat($totalCshAmount) }}</td>
            <td class="td bold noPadding alignTop borderTop txtRight"></td>
            <td class="td bold noPadding alignTop borderTop txtRight"></td>
        </tr>
    </tbody>
    <tfoot>
    <th colspan="3" class="th smallFont noPadding alignTop borderTopBottom"><span class="fontsize10">&#10033;</span> {{Config::get('constants.asterisk.WALK_CUST')}}</th>
    <td colspan="9" 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('Item/patientwisedataInputCredit') }}" 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-->