@extends('Reports.template')

<!--Title-->
@section('title')
@if($reportType == "D")
@php
$reportTitle = "Pharmacy Outstanding Report ( Detail ) ";
@endphp
@else
@php
$reportTitle = "Pharmacy Outstanding 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();
        if ($reportFor == "U") {
        $reportForTitle = "Unsettled Bill / Receipt";
        } else {
        $reportForTitle = "All Bill / Receipt";
        }
        @endphp
        <tr>
            <th colspan="6" class="th borderNone borderBottom reportTitle">{{$reportTitle}} ( Report For : {{$reportForTitle}} )</th>
            @if($reportFor == "U")
            <th colspan="4" class="txtRight th borderNone borderBottom">As On : {{\Helper::getDisplayDate($toDate)}}</th>
            @else
            <th colspan="4" class="txtRight th borderNone borderBottom">Period : {{\Helper::getDisplayDate($fromDate)}} TO {{\Helper::getDisplayDate($toDate)}}</th>
            @endif
        </tr>
        @if($reportType == "D")
        <tr>
            <th width="4%" class="th noPadding alignTop borderTop borderBottomGray txtRight">Sr.&nbsp;&nbsp;</th>
            <th colspan="4" class="th noPadding alignTop borderTop borderBottomGray">&nbsp;Patient / Customer Details</th>
            <th colspan="3" class="th noPadding alignTop borderTop borderBottomGray">Patient Type</th>
            <th colspan="2" class="th noPadding alignTop borderTop borderBottomGray"></th>
        </tr>
        @else
        <tr>
            <th width="4%" class="th noPadding alignTop borderTopBottom txtRight">Sr.&nbsp;&nbsp;</th>
            <th colspan="3" class="th noPadding alignTop borderTopBottom">&nbsp;Patient / Customer Details</th>
            <th colspan="2" class="noPadding alignTop borderTopBottom">Patient Type</th>
            <th class="th noPadding alignTop borderTopBottom"></th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">Receipt Amount</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">Bill Amount</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">Balance</th>
        </tr>
        @endif
        @if($reportType == "D")
        <tr>
            <th colspan="2" class="th noPadding alignTop borderTopBottom txtRight">Sr.&nbsp;&nbsp;</th>
            <th class="th noPadding alignTop borderTopBottom">&nbsp;Receipt / Bill No</th>
            <th class="th noPadding alignTop borderTopBottom">&nbsp;Receipt / Bill Date</th>
            <th class="th noPadding alignTop borderTopBottom ">&nbsp;IP / OP ID</th>
            <th class="th noPadding alignTop borderTopBottom ">Remarks</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Created By</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">Receipt Amount</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">Bill Amount</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">Balance</th>
        </tr>
        @endif
    </thead>
    <tbody>
        @php
        $lastPatOrCustName = '';
        $lastPatRateCard = 0;
        $lastPtrApplicable = '';
        $srHeader = 1;
        $checkPatOrCustID = '';
        $oldPatOrCustID = '';
        $balance = 0;
        $totalBillAmount = 0;
        $totalReceiptAmount = 0;
        $totalOutstanding = 0;
        @endphp
        @foreach($billData as $bill)
        @php
        $opOrIpID = '';
        if($bill->patient_name != ''){
        $patOrCustName = " ".$bill->patient_id." / ".$bill->patient_name;
        if($bill->visit_type == "O"){
        $opOrIpID = "OP - ".$bill->opd_reg_id;
        }else{
        $opOrIpID = "IP - ".$bill->ipd_reg_id;
        }
        $patOrCustID = $bill->patient_id;
        $checkPatOrCustID = "P" . $bill->patient_id;
        }else{
        $patOrCustName = '*'.$bill->ph_cust_id." / ".$bill->ph_cust_name;
        $patOrCustID = $bill->ph_cust_id;
        $checkPatOrCustID = "C" . $bill->ph_cust_id;
        }
        @endphp
        @if(array_key_exists($checkPatOrCustID, $patientWiseBalance))
        @if($checkPatOrCustID != $oldPatOrCustID)
        @if($balance != 0 || ($balance == 0 && $oldPatOrCustID != ''))
        @if($reportType == "D")
        <tr>
            <td colspan="7" class="td bold noPadding alignTop borderTopBottom txtRight">Total : </td>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalReceiptAmount)}}</td>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalBillAmount)}}</td>
            <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($balance)}}</td>
        </tr>
        @else
        <tr>
            <td width="4%" class="td bold noPadding alignTop borderTopBottom txtRight">{{$srHeader++}}&nbsp;&nbsp;</td>
            <td colspan="3" class="td bold noPadding alignTop borderTopBottom">&nbsp;{{$lastPatOrCustName}}</td>
            @if($lastPatRateCard > 0)
            <td colspan="2" class="td bold noPadding alignTop borderTopBottom">{{$rate[$lastPatRateCard]}}</td>
            @else
            <td colspan="2" class="td bold noPadding alignTop borderTopBottom"></td>
            @endif
            @if($lastPtrApplicable == 'Y')
            <td class="td bold noPadding alignTop borderTopBottom">{{$companyName}}</td>
            @else
            <td class="td bold noPadding alignTop borderTopBottom"></td>
            @endif
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalReceiptAmount)}}</td>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalBillAmount)}}</td>
            <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($balance)}}</td>
        </tr>
        @endif
        @endif
        @php
        $sr = 1;
        $balance = 0;
        $totalBillAmount = 0;
        $totalReceiptAmount = 0;
        @endphp
        @if($reportType == "D")
        <tr>
            <td width="4%" class="td bold noPadding alignTop borderTopBottom txtRight">{{$srHeader++}}&nbsp;&nbsp;</td>
            <td colspan="4" class="td bold noPadding alignTop borderTopBottom">&nbsp;{{$patOrCustName}}</td>
            @if($bill->patient_rate_card > 0)
            <td colspan="3" class="td bold noPadding alignTop borderTopBottom">{{$rate[$bill->patient_rate_card]}}</td>
            @else
            <td colspan="3" class="td bold noPadding alignTop borderTopBottom"></td>
            @endif
            @if($bill->is_ptr_applicable == 'Y')
            <td colspan="2" class="td bold noPadding alignTop borderTopBottom">{{$companyName}}</td>
            @else
            <td colspan="2" class="td bold noPadding alignTop borderTopBottom"></td>
            @endif
        </tr>
        @endif
        @if($bill->patient_id != '')
        @foreach ($receiptData as $receipt)
        @if($receipt->patient_id == $bill->patient_id)
        @php
        if($receipt->patient_id != ''){
        if($receipt->visit_type == "O"){
        $opOrIpID = "OP - ".$receipt->opd_reg_id;
        }else{
        $opOrIpID = "IP - ".$receipt->ipd_reg_id;
        }
        }
        if($receipt->balance_type == "C"){
        $amount = $receipt->amount_received;
        $balance += $receipt->amount_received;
        $totalReceiptAmount += $receipt->amount_received;
        $totalOutstanding += $receipt->amount_received;
        }else{
        $amount = -1 * $receipt->amount_received;
        $balance -= $receipt->amount_received;
        $totalReceiptAmount -= $receipt->amount_received;
        $totalOutstanding -= $receipt->amount_received;
        }
        @endphp
        @if($reportType == "D")
        <tr>
            <td colspan="2" class="td noPadding alignTop borderBottomGray txtRight">{{$sr++}}&nbsp;&nbsp;</td>
            <td class="th noPadding alignTop borderBottomGray">&nbsp;{{$receipt->trn_receipt_type.$receipt->trn_receipt_no}}</td>
            <td class="th noPadding alignTop borderBottomGray">&nbsp;{{\Helper::getDisplayDate($receipt->trn_receipt_date)}}</td>
            <td class="th noPadding alignTop borderBottomGray ">&nbsp;{{$opOrIpID}}</td>
            <td class="th noPadding alignTop borderBottomGray ">{{$receipt->remarks}}</td>
            <td class="th noPadding alignTop borderBottomGray txtRight">{{$receipt->created_by}}</td>
            <td class="th noPadding alignTop borderBottomGray txtRight">{{\Helper::customAmountFormat($amount)}}</td>
            <td class="th noPadding alignTop borderBottomGray txtRight"></td>
            <td class="th noPadding alignTop borderBottomGray txtRight">{{\Helper::customAmountFormat($balance)}}</td>
        </tr>  
        @endif  
        @endif
        @endforeach
        @elseif($bill->ph_cust_id != '')
        @foreach ($receiptData as $receipt)
        @if($receipt->ph_cust_id == $bill->ph_cust_id)
        @php
        $opOrIpID = '';
        if($receipt->balance_type == "C"){
        $amount = $receipt->amount_received;
        $balance += $receipt->amount_received;
        $totalReceiptAmount += $receipt->amount_received;
        $totalOutstanding += $receipt->amount_received;
        }else{
        $amount = -1 * $receipt->amount_received;
        $balance -= $receipt->amount_received;
        $totalReceiptAmount -= $receipt->amount_received;
        $totalOutstanding -= $receipt->amount_received;
        }
        @endphp
        @if($reportType == "D")
        <tr>
            <td colspan="2" class="td noPadding alignTop borderBottomGray txtRight">{{$sr++}}&nbsp;&nbsp;</td>
            <td class="th noPadding alignTop borderBottomGray">&nbsp;{{$receipt->trn_receipt_type.$receipt->trn_receipt_no}}</td>
            <td class="th noPadding alignTop borderBottomGray">&nbsp;{{\Helper::getDisplayDate($receipt->trn_receipt_date)}}</td>
            <td class="th noPadding alignTop borderBottomGray ">&nbsp;{{$opOrIpID}}</td>
            <td class="th noPadding alignTop borderBottomGray ">{{$receipt->remarks}}</td>
            <td class="th noPadding alignTop borderBottomGray txtRight">{{$receipt->created_by}}</td>
            <td class="th noPadding alignTop borderBottomGray txtRight">{{\Helper::customAmountFormat($amount)}}</td>
            <td class="th noPadding alignTop borderBottomGray txtRight"></td>
            <td class="th noPadding alignTop borderBottomGray txtRight">{{\Helper::customAmountFormat($balance)}}</td>
        </tr>  
        @endif  
        @endif
        @endforeach
        @endif
        @endif
        @php
        if($bill->trn_type == "I"){
        $amount = $bill->total;
        $balance += (-1 * $bill->total);
        $totalBillAmount += $bill->total;
        $totalOutstanding += (-1 * $bill->total);
        }else{
        $amount = -1 * $bill->total;
        $balance += $bill->total;
        $totalBillAmount -= $bill->total;
        $totalOutstanding += $bill->total;
        }
        $opOrIpID = '';
        if($bill->ph_cust_id == ''){
            if($bill->visit_type == "O"){
                $opOrIpID = "OP - ".$bill->opd_reg_id;
            }else{
                $opOrIpID = "IP - ".$bill->ipd_reg_id;
            }
        }
        @endphp
        @if($reportType == "D")
        <tr>
            <td colspan="2" class="td noPadding alignTop borderBottomGray txtRight">{{$sr++}}&nbsp;&nbsp;</td>
            <td class="td noPadding alignTop borderBottomGray">&nbsp;{{$bill->trn_type."/".$bill->trn_fyear."/".$bill->trn_id}}</td>
            <td class="td noPadding alignTop borderBottomGray">&nbsp;{{\Helper::getDisplayDate($bill->trn_date)}}</td>
            <td class="td noPadding alignTop borderBottomGray ">&nbsp;{{$opOrIpID}}</td>
            <td class="td noPadding alignTop borderBottomGray ">{{$bill->remarks}}</td>
            <td class="td noPadding alignTop borderBottomGray txtRight">{{$bill->created_by}}</td>
            <td class="td noPadding alignTop borderBottomGray txtRight"></td>
            <td class="td noPadding alignTop borderBottomGray txtRight">{{\Helper::customAmountFormat($amount)}}</td>
            <td class="td noPadding alignTop borderBottomGray txtRight">{{\Helper::customAmountFormat($balance)}}</td>
        </tr>
        @endif
        @php
        $oldPatOrCustID = $checkPatOrCustID; 
        $lastPatOrCustName = $patOrCustName;
        $lastPatRateCard = $bill->patient_rate_card;
        $lastPtrApplicable = $bill->is_ptr_applicable;
        @endphp
        @endif
        @endforeach

        @if(!empty($onlyReceiptData))

        @if($reportType == "D")
        <tr>
            <td colspan="7" class="td bold noPadding alignTop borderTopBottom txtRight">Total : </td>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalReceiptAmount)}}</td>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalBillAmount)}}</td>
            <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($balance)}}</td>
        </tr>
        @else
        <tr>
            <td width="4%" class="td bold noPadding alignTop borderTopBottom txtRight">{{$srHeader++}}&nbsp;&nbsp;</td>
            <td colspan="3" class="td bold noPadding alignTop borderTopBottom">&nbsp;{{$lastPatOrCustName}}</td>
            @if($lastPatRateCard > 0)
            <td colspan="2" class="td bold noPadding alignTop borderTopBottom">{{$rate[$lastPatRateCard]}}</td>
            @else
            <td colspan="2" class="td bold noPadding alignTop borderTopBottom"></td>
            @endif
            @if($lastPtrApplicable == 'Y')
            <td class="td bold noPadding alignTop borderTopBottom">{{$companyName}}</td>
            @else
            <td class="td bold noPadding alignTop borderTopBottom"></td>
            @endif
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalReceiptAmount)}}</td>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalBillAmount)}}</td>
            <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($balance)}}</td>
        </tr>
        @endif
        <tr>
            <td colspan="9" class="td bold alignTop borderTopBottom txtRight">Total Outstanding : </td>
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalOutstanding)}}</td>
        </tr>
        <tr>
            <th colspan="10" class="th borderNone borderTopBottom reportTitle">List of Patient / Customer having Only Receipt</th>
        </tr>
        @if($reportType == "D")
        <tr>
            <th width="4%" class="th noPadding alignTop borderTop borderBottomGray txtRight">Sr.&nbsp;&nbsp;</th>
            <th colspan="4" class="th noPadding alignTop borderTop borderBottomGray">&nbsp;Patient / Customer Details</th>
            <th colspan="3" class="th noPadding alignTop borderTop borderBottomGray">Patient Type</th>
            <th colspan="2" class="th noPadding alignTop borderTop borderBottomGray"></th>
        </tr>
        @else
        <tr>
            <th width="4%" class="th noPadding alignTop borderTopBottom txtRight">Sr.&nbsp;&nbsp;</th>
            <th colspan="3" class="th noPadding alignTop borderTopBottom">&nbsp;Patient / Customer Details</th>
            <th colspan="2" class="noPadding alignTop borderTopBottom">Patient Type</th>
            <th class="th noPadding alignTop borderTopBottom"></th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">Receipt Amount</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">Bill Amount</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">Balance</th>
        </tr>
        @endif
        @if($reportType == "D")
        <tr>
            <th colspan="2" class="th noPadding alignTop borderTopBottom txtRight">Sr.&nbsp;&nbsp;</th>
            <th class="th noPadding alignTop borderTopBottom">&nbsp;Receipt / Bill No</th>
            <th class="th noPadding alignTop borderTopBottom">&nbsp;Receipt / Bill Date</th>
            <th class="th noPadding alignTop borderTopBottom ">&nbsp;IP / OP ID</th>
            <th class="th noPadding alignTop borderTopBottom ">Remarks</th>
            <th class="th noPadding alignTop borderTopBottom txtRight">Created By</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">Receipt Amount</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">Bill Amount</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom txtRight">Balance</th>
        </tr>
        @endif

        @php
        $srHeader = 1;
        $totalOutstanding = 0;
        $lastPatOrCustName = '';
        $lastPatRateCard = 0;
        $lastPtrApplicable = '';
        $checkPatOrCustID = '';
        $oldPatOrCustID = '';
        $balance = 0;
        $totalBillAmount = 0;
        $totalReceiptAmount = 0;
        @endphp

        @foreach($onlyReceiptData as $onlyReceipt)
        @php
        $checkPatOrCustID = $onlyReceipt;
        $patOrCustID = substr($onlyReceipt, 1);
        $opOrIpID = '';
        @endphp
        @if(array_key_exists($checkPatOrCustID, $patientWiseBalance))
        @if(substr($onlyReceipt, 0, 1) == "P")
        @foreach ($receiptData as $receipt)

        @if($patOrCustID != $oldPatOrCustID)
        @if($balance != 0 || ($balance == 0 && $oldPatOrCustID != ''))
        @if($reportType == "D")
        <tr>
            <td colspan="7" class="td bold noPadding alignTop borderTopBottom txtRight">Total : </td>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalReceiptAmount)}}</td>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalBillAmount)}}</td>
            <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($balance)}}</td>
        </tr>
        @else
        <tr>
            <td width="4%" class="td bold noPadding alignTop borderTopBottom txtRight">{{$srHeader++}}&nbsp;&nbsp;</td>
            <td colspan="3" class="td bold noPadding alignTop borderTopBottom">&nbsp;{{$lastPatOrCustName}}</td>
            @if($lastPatRateCard > 0)
            <td colspan="2" class="td bold noPadding alignTop borderTopBottom">{{$rate[$lastPatRateCard]}}</td>
            @else
            <td colspan="2" class="td bold noPadding alignTop borderTopBottom"></td>
            @endif
            @if($lastPtrApplicable == 'Y')
            <td class="td bold noPadding alignTop borderTopBottom">{{$companyName}}</td>
            @else
            <td class="td bold noPadding alignTop borderTopBottom"></td>
            @endif
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalReceiptAmount)}}</td>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalBillAmount)}}</td>
            <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($balance)}}</td>
        </tr>
        @endif
        @endif

        @php
        $sr = 1;
        $balance = 0;
        $totalBillAmount = 0;
        $totalReceiptAmount = 0;
        $patOrCustName = '';
        @endphp

        @endif
        @if($receipt->patient_id == $patOrCustID)
        @php
        $patOrCustName = " ".$receipt->patient_id." / ".$receipt->patient_name;
        if($receipt->patient_id != ''){
        if($receipt->visit_type == "O"){
        $opOrIpID = "OP - ".$receipt->opd_reg_id;
        }else{
        $opOrIpID = "IP - ".$receipt->ipd_reg_id;
        }
        }
        if($receipt->balance_type == "C"){
        $amount = $receipt->amount_received;
        $balance += $receipt->amount_received;
        $totalReceiptAmount += $receipt->amount_received;
        $totalOutstanding += $receipt->amount_received;
        }else{
        $amount = -1 * $receipt->amount_received;
        $balance -= $receipt->amount_received;
        $totalReceiptAmount -= $receipt->amount_received;
        $totalOutstanding -= $receipt->amount_received;
        }
        @endphp
        @if($reportType == "D" && $sr == 1)
        <tr>
            <td width="4%" class="td bold noPadding alignTop borderTopBottom txtRight">{{$srHeader++}}&nbsp;&nbsp;</td>
            <td colspan="4" class="td bold noPadding alignTop borderTopBottom">&nbsp;{{$patOrCustName}}</td>
            @if($receipt->patient_rate_card > 0)
            <td colspan="3" class="td bold noPadding alignTop borderTopBottom">{{$rate[$receipt->patient_rate_card]}}</td>
            @else
            <td colspan="3" class="td bold noPadding alignTop borderTopBottom"></td>
            @endif
            <td colspan="2" class="td bold noPadding alignTop borderTopBottom"></td>
        </tr>
        @endif
        @if($reportType == "D")
        <tr>
            <td colspan="2" class="td noPadding alignTop borderBottomGray txtRight">{{$sr++}}&nbsp;&nbsp;</td>
            <td class="th noPadding alignTop borderBottomGray">&nbsp;{{$receipt->trn_receipt_type.$receipt->trn_receipt_no}}</td>
            <td class="th noPadding alignTop borderBottomGray">&nbsp;{{\Helper::getDisplayDate($receipt->trn_receipt_date)}}</td>
            <td class="th noPadding alignTop borderBottomGray ">&nbsp;{{$opOrIpID}}</td>
            <td class="th noPadding alignTop borderBottomGray ">{{$receipt->remarks}}</td>
            <td class="th noPadding alignTop borderBottomGray txtRight">{{$receipt->created_by}}</td>
            <td class="th noPadding alignTop borderBottomGray txtRight">{{\Helper::customAmountFormat($amount)}}</td>
            <td class="th noPadding alignTop borderBottomGray txtRight"></td>
            <td class="th noPadding alignTop borderBottomGray txtRight">{{\Helper::customAmountFormat($balance)}}</td>
        </tr>  
        @endif
        @endif

        @php
        $oldPatOrCustID = $patOrCustID; 
        $lastPatOrCustName = $patOrCustName;
        $lastPatRateCard = $receipt->patient_rate_card;
        $lastPtrApplicable = "N";
        @endphp
        @endforeach
        @else
        @foreach ($receiptData as $receipt)

        @if($patOrCustID != $oldPatOrCustID)
        @if($balance != 0 || ($balance == 0 && $oldPatOrCustID != ''))
        @if($reportType == "D")
        <tr>
            <td colspan="7" class="td bold noPadding alignTop borderTopBottom txtRight">Total : </td>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalReceiptAmount)}}</td>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalBillAmount)}}</td>
            <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($balance)}}</td>
        </tr>
        @else
        <tr>
            <td width="4%" class="td bold noPadding alignTop borderTopBottom txtRight">{{$srHeader++}}&nbsp;&nbsp;</td>
            <td colspan="3" class="td bold noPadding alignTop borderTopBottom">&nbsp;{{$lastPatOrCustName}}</td>
            @if($lastPatRateCard > 0)
            <td colspan="2" class="td bold noPadding alignTop borderTopBottom">{{$rate[$lastPatRateCard]}}</td>
            @else
            <td colspan="2" class="td bold noPadding alignTop borderTopBottom"></td>
            @endif
            @if($lastPtrApplicable == 'Y')
            <td class="td bold noPadding alignTop borderTopBottom">{{$companyName}}</td>
            @else
            <td class="td bold noPadding alignTop borderTopBottom"></td>
            @endif
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalReceiptAmount)}}</td>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalBillAmount)}}</td>
            <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($balance)}}</td>
        </tr>
        @endif
        @endif

        @php
        $sr = 1;
        $balance = 0;
        $totalBillAmount = 0;
        $totalReceiptAmount = 0;
        $patOrCustName = '';
        @endphp
        @endif

        @if($receipt->ph_cust_id == $patOrCustID)
        @php
        $opOrIpID = '';
        $patOrCustName = '*'.$receipt->ph_cust_id." / ".$receipt->ph_cust_name;
        if($receipt->balance_type == "C"){
        $amount = $receipt->amount_received;
        $balance += $receipt->amount_received;
        $totalReceiptAmount += $receipt->amount_received;
        $totalOutstanding += $receipt->amount_received;
        }else{
        $amount = -1 * $receipt->amount_received;
        $balance -= $receipt->amount_received;
        $totalReceiptAmount -= $receipt->amount_received;
        $totalOutstanding -= $receipt->amount_received;
        }
        @endphp
        @if($reportType == "D" && $sr == 1)
        <tr>
            <td width="4%" class="td bold noPadding alignTop borderTopBottom txtRight">{{$srHeader++}}&nbsp;&nbsp;</td>
            <td colspan="4" class="td bold noPadding alignTop borderTopBottom">&nbsp;{{$patOrCustName}}</td>
            @if($receipt->patient_rate_card > 0)
            <td colspan="3" class="td bold noPadding alignTop borderTopBottom">{{$rate[$receipt->patient_rate_card]}}</td>
            @else
            <td colspan="3" class="td bold noPadding alignTop borderTopBottom"></td>
            @endif
            <td colspan="2" class="td bold noPadding alignTop borderTopBottom"></td>
        </tr>
        @endif
        @if($reportType == "D")
        <tr>
            <td colspan="2" class="td noPadding alignTop borderBottomGray txtRight">{{$sr++}}&nbsp;&nbsp;</td>
            <td class="th noPadding alignTop borderBottomGray">&nbsp;{{$receipt->trn_receipt_type.$receipt->trn_receipt_no}}</td>
            <td class="th noPadding alignTop borderBottomGray">&nbsp;{{\Helper::getDisplayDate($receipt->trn_receipt_date)}}</td>
            <td class="th noPadding alignTop borderBottomGray ">&nbsp;{{$opOrIpID}}</td>
            <td class="th noPadding alignTop borderBottomGray ">{{$receipt->remarks}}</td>
            <td class="th noPadding alignTop borderBottomGray txtRight">{{$receipt->created_by}}</td>
            <td class="th noPadding alignTop borderBottomGray txtRight">{{\Helper::customAmountFormat($amount)}}</td>
            <td class="th noPadding alignTop borderBottomGray txtRight"></td>
            <td class="th noPadding alignTop borderBottomGray txtRight">{{\Helper::customAmountFormat($balance)}}</td>
        </tr>  
        @endif
        @endif

        @php
        $oldPatOrCustID = $patOrCustID; 
        $lastPatOrCustName = $patOrCustName;
        $lastPatRateCard = 0;
        $lastPtrApplicable = "N";
        @endphp
        @endforeach
        @endif

        @endif
        @endforeach
        @endif

        @if($reportType == "D")
        <tr>
            <td colspan="7" class="td bold noPadding alignTop borderTopBottom txtRight">Total : </td>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalReceiptAmount)}}</td>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalBillAmount)}}</td>
            <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($balance)}}</td>
        </tr>
        @else
        <tr>
            <td width="4%" class="td bold noPadding alignTop borderTopBottom txtRight">{{$srHeader++}}&nbsp;&nbsp;</td>
            <td colspan="3" class="td bold noPadding alignTop borderTopBottom">&nbsp;{{$lastPatOrCustName}}</td>
            @if($lastPatRateCard > 0)
            <td colspan="2" class="td bold noPadding alignTop borderTopBottom">{{$rate[$lastPatRateCard]}}</td>
            @else
            <td colspan="2" class="td bold noPadding alignTop borderTopBottom"></td>
            @endif
            @if($lastPtrApplicable == 'Y')
            <td class="td bold noPadding alignTop borderTopBottom">{{$companyName}}</td>
            @else
            <td class="td bold noPadding alignTop borderTopBottom"></td>
            @endif
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalReceiptAmount)}}</td>
            <td class="td bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalBillAmount)}}</td>
            <td class="th bold noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($balance)}}</td>
        </tr>
        @endif
        <tr>
            @if(!empty($onlyReceiptData))
            <td colspan="9" class="td bold alignTop borderTopBottom txtRight">Total Receipt Amount : </td>
            @else
            <td colspan="9" class="td bold alignTop borderTopBottom txtRight">Total Outstanding : </td>
            @endif
            <td class="td bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalOutstanding)}}</td>
        </tr>
    </tbody>
    <tfoot>
    <th colspan="5" 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>    
</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="{{$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/OutstandingInput') }}" 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-->