@extends('Reports.template')

<!--Title-->
@section('title')
Pharmacy Outstanding 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 Outstading Report</th>
            <th colspan="3" class="txtRight th borderNone borderBottom">Store : {{$storeName}}</th>
            <th colspan="2" class="txtRight th borderNone borderBottom">As On : {{\Helper::getDisplayDate($toDate)}}</th>
        </tr>
        <tr>
            <th width="5%"  class="th noPadding alignTop borderTopBottom txtRight">Sr No</th>
            <th width="5%" class="th noPadding alignTop borderTopBottom">&nbsp;&nbsp;Bill No</th>
            <th width="5%" class="th noPadding alignTop borderTopBottom">Bill Date</th>
            <th width="25%" class="th noPadding alignTop borderTopBottom">Patient / Customer Details</th>
            <th width="20%" class="th noPadding alignTop borderTopBottom">Patient Type</th>
            <th width="15%" class="th noPadding alignTop borderTopBottom"></th>
            <th width="5%" class="th noPadding alignTop borderTopBottom txtRight">Age Day</th>
            <th width="12%" class="th noPadding alignTop borderTopBottom txtRight">Outstanding Bill Amount</th>
            <th width="8%" class="th noPadding alignTop borderTopBottom txtRight">Created By</th>
        </tr>  
    </thead>
    <tbody>
        @php
        $sr = 1;
        $total = 0;
        $aging = array();
        $agingAmount = array();
        $customerAging = array();
        $customerAgingAmount = array();
        $totalRange1 = 0; 
        $totalRange2 = 0; 
        $totalRange3 = 0; 
        $totalRange4 = 0; 
        $totalAmount1 = 0; 
        $totalAmount2 = 0; 
        $totalAmount3 = 0; 
        $totalAmount4 = 0;
        foreach($rate as $key=>$value){
        $aging[$key] = array(0=>0,1=>0,2=>0,3=>0);
        $agingAmount[$key] = array(0=>0,1=>0,2=>0,3=>0);
        }
        $customerAging[0] = 0;
        $customerAging[1] = 0;
        $customerAging[2] = 0;
        $customerAging[3] = 0;
        $customerAgingAmount[0] = 0;
        $customerAgingAmount[1] = 0;
        $customerAgingAmount[2] = 0;
        $customerAgingAmount[3] = 0;
        @endphp
        @foreach($billData as $bill)
        @php
        if($bill->patient_name != ''){
        $patOrCustName = " ".$bill->patient_id." / ".$bill->patient_name;
        }else{
        $patOrCustName = '*'.$bill->ph_cust_id." / ".$bill->ph_cust_name;
        }
        $amount = 0;
        if($bill->trn_type === 'I'){
        $total += $bill->total;
        $amount = $bill->total;
        }else{
        $total -= $bill->total;
        $amount = -1*($bill->total);
        }
        $ageDay = abs(round((strtotime($toDate) - strtotime($bill->trn_date)) / 86400));
        if($bill->patient_rate_card > 0 ){
        if($ageDay > 30){
        $aging[$bill->patient_rate_card][3]++;
        if($bill->trn_type === 'I'){
        $agingAmount[$bill->patient_rate_card][3] += $bill->total;
        }else{
        $agingAmount[$bill->patient_rate_card][3] -= $bill->total;
        }
        }elseif($ageDay <= 30 && $ageDay >= 16){
        $aging[$bill->patient_rate_card][2]++;
        if($bill->trn_type === 'I'){
        $agingAmount[$bill->patient_rate_card][2] += $bill->total;
        }else{
        $agingAmount[$bill->patient_rate_card][2] -= $bill->total;
        }
        }elseif($ageDay <= 15 && $ageDay >= 8){
        $aging[$bill->patient_rate_card][1]++;
        if($bill->trn_type === 'I'){
        $agingAmount[$bill->patient_rate_card][1] += $bill->total;
        }else{
        $agingAmount[$bill->patient_rate_card][1] -= $bill->total;
        }
        }elseif($ageDay <= 7 && $ageDay >= 0){
        $aging[$bill->patient_rate_card][0]++;
        if($bill->trn_type === 'I'){
        $agingAmount[$bill->patient_rate_card][0] += $bill->total;
        }else{
        $agingAmount[$bill->patient_rate_card][0] -= $bill->total;
        }
        }
        }else{
        if($ageDay > 30){
        $customerAging[3]++;
        if($bill->trn_type === 'I'){
        $customerAgingAmount[3] += $bill->total;
        }else{
        $customerAgingAmount[3] -= $bill->total;
        }
        }elseif($ageDay <= 30 && $ageDay >= 16){
        $customerAging[2]++;
        if($bill->trn_type === 'I'){
        $customerAgingAmount[2] += $bill->total;
        }else{
        $customerAgingAmount[2] -= $bill->total;
        }
        }elseif($ageDay <= 15 && $ageDay >= 8){
        $customerAging[1]++;
        if($bill->trn_type === 'I'){
        $customerAgingAmount[1] += $bill->total;
        }else{
        $customerAgingAmount[1] -= $bill->total;
        }
        }elseif($ageDay <= 7 && $ageDay >= 0){
        $customerAging[0]++;
        if($bill->trn_type === 'I'){
        $customerAgingAmount[0] += $bill->total;
        }else{
        $customerAgingAmount[0] -= $bill->total;
        }
        }
        }
        @endphp
        <tr>
            <td class="td notBold alignTop borderTopBottomGray txtRight">{{$sr++}}</td>
            <td class="td notBold alignTop borderTopBottomGray">&nbsp;&nbsp;{{$bill->trn_type."/".$bill->trn_fyear."/".$bill->trn_id}}</td>
            <td class="td notBold alignTop borderTopBottomGray">{{\Helper::getDisplayDate($bill->trn_date)}}</td>
            <td class="td notBold alignTop borderTopBottomGray">{{$patOrCustName}}</td>
            @if($bill->patient_rate_card > 0)
            <td class="td notBold alignTop borderTopBottomGray">{{$rate[$bill->patient_rate_card]}}</td>
            @else
            <td class="td notBold alignTop borderTopBottomGray"></td>
            @endif
            @if($bill->is_ptr_applicable == 'Y')
            <td class="td bold alignTop borderTopBottomGray">{{$companyName}}</td>
            @else
            <td class="td notBold alignTop borderTopBottomGray"></td>
            @endif
            <td class="td notBold alignTop borderTopBottomGray txtRight">{{$ageDay}}</td>
            <td class="td notBold alignTop borderTopBottomGray txtRight">{{\Helper::customAmountFormat($amount)}}</td>
            <td class="td notBold alignTop borderTopBottomGray txtRight">{{$bill->created_by}}</td>
        </tr>   
        @endforeach
        <tr>
            <td colspan="7" class="td notBold alignTop borderTopBottomGray txtRight"></td>
            <td class="td bold alignTop borderTopBottomGray txtRight">{{\Helper::customAmountFormat($total)}}</td>
            <td colspan="1" class="td notBold alignTop borderTopBottomGray 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="8" class="th smallFont noPadding alignTop borderTopBottom txtRight">{{ strtoupper(Session::get('userId'))." # ".$currentTime->format('d/m/Y H:i:s ')}}</td>    
</tfoot>
</table>

<table align="center" border="1" style="width:80%;">
    <thead>
    <h3 align="center"><b>Outstanding Report Summary</b></h3>
    <tr>
        <th rowspan="2" class="th noPadding borderTopBottom txtCenter">Patient Category</th>
        <th colspan="2" class="th noPadding alignTop borderTopBottom txtCenter">0-7 day</th>
        <th colspan="2" class="th noPadding alignTop borderTopBottom txtCenter">8-15 day</th>
        <th colspan="2" class="th noPadding alignTop borderTopBottom txtCenter">16-30 day</th>
        <th colspan="2" class="th noPadding alignTop borderTopBottom txtCenter">>30 day</th>
        <th colspan="2" class="th noPadding alignTop borderTopBottom txtCenter">Total</th>
    </tr>
    <tr>
        <th class="th noPadding alignTop borderTopBottom txtCenter">Count</th>
        <th class="th noPadding alignTop borderTopBottom txtCenter">Amount</th>
        <th class="th noPadding alignTop borderTopBottom txtCenter">Count</th>
        <th class="th noPadding alignTop borderTopBottom txtCenter">Amount</th>
        <th class="th noPadding alignTop borderTopBottom txtCenter">Count</th>
        <th class="th noPadding alignTop borderTopBottom txtCenter">Amount</th>
        <th class="th noPadding alignTop borderTopBottom txtCenter">Count</th>
        <th class="th noPadding alignTop borderTopBottom txtCenter">Amount</th>
        <th class="th noPadding alignTop borderTopBottom txtCenter">Total Count</th>
        <th class="th noPadding alignTop borderTopBottom txtCenter">Total Amount</th>
    </tr>
</thead>
<tbody>
    @foreach($aging as $key=>$value)
    @php
    $totalRange1 += $value[0]; 
    $totalRange2 += $value[1]; 
    $totalRange3 += $value[2]; 
    $totalRange4 += $value[3]; 
    $totalAmount1 += $agingAmount[$key][0]; 
    $totalAmount2 += $agingAmount[$key][1]; 
    $totalAmount3 += $agingAmount[$key][2]; 
    $totalAmount4 += $agingAmount[$key][3]; 
    @endphp
    <tr>
        <td class="td noPadding alignTop borderTopBottom">{{$rate[$key]}}</td>
        <td class="td noPadding alignTop borderTopBottom txtCenter">{{\Helper::zeroValueToNbspSpace($value[0])}}</td>
        <td class="td noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($agingAmount[$key][0])}}</td>
        <td class="td noPadding alignTop borderTopBottom txtCenter">{{\Helper::zeroValueToNbspSpace($value[1])}}</td>
        <td class="td noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($agingAmount[$key][1])}}</td>
        <td class="td noPadding alignTop borderTopBottom txtCenter">{{\Helper::zeroValueToNbspSpace($value[2])}}</td>
        <td class="td noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($agingAmount[$key][2])}}</td>
        <td class="td noPadding alignTop borderTopBottom txtCenter">{{\Helper::zeroValueToNbspSpace($value[3])}}</td>
        <td class="td noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($agingAmount[$key][3])}}</td>
        <td class="td noPadding alignTop borderTopBottom txtCenter">{{\Helper::zeroValueToNbspSpace($value[0]+$value[1]+$value[2]+$value[3])}}</td>
        <td class="td noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($agingAmount[$key][0]+$agingAmount[$key][1]+$agingAmount[$key][2]+$agingAmount[$key][3])}}</td>
    </tr>
    @endforeach
    <tr>
        <td class="td noPadding bold alignTop borderTopBottom">Patient / Customer</td>
        <td class="td noPadding alignTop borderTopBottom txtCenter">{{\Helper::zeroValueToNbspSpace($customerAging[0])}}</td>
        <td class="td noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($customerAgingAmount[0])}}</td>
        <td class="td noPadding alignTop borderTopBottom txtCenter">{{\Helper::zeroValueToNbspSpace($customerAging[1])}}</td>
        <td class="td noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($customerAgingAmount[1])}}</td>
        <td class="td noPadding alignTop borderTopBottom txtCenter">{{\Helper::zeroValueToNbspSpace($customerAging[2])}}</td>
        <td class="td noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($customerAgingAmount[2])}}</td>
        <td class="td noPadding alignTop borderTopBottom txtCenter">{{\Helper::zeroValueToNbspSpace($customerAging[3])}}</td>
        <td class="td noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($customerAgingAmount[3])}}</td>
        <td class="td noPadding alignTop borderTopBottom txtCenter">{{\Helper::zeroValueToNbspSpace($customerAging[0]+$customerAging[1]+$customerAging[2]+$customerAging[3])}}</td>
        <td class="td noPadding alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($customerAgingAmount[0]+$customerAgingAmount[1]+$customerAgingAmount[2]+$customerAgingAmount[3])}}</td>
    </tr>
    @php
    $totalRange1 += $customerAging[0];
    $totalRange2 += $customerAging[1];
    $totalRange3 += $customerAging[2];
    $totalRange4 += $customerAging[3];
    $totalAmount1 += $customerAgingAmount[0];
    $totalAmount2 += $customerAgingAmount[1];
    $totalAmount3 += $customerAgingAmount[2];
    $totalAmount4 += $customerAgingAmount[3];
    @endphp
    <tr>
        <td class="td noPadding bold alignTop borderTopBottom">Total</td>
        <td class="td noPadding bold alignTop borderTopBottom txtCenter">{{\Helper::zeroValueToNbspSpace($totalRange1)}}</td>
        <td class="td noPadding bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalAmount1)}}</td>
        <td class="td noPadding bold alignTop borderTopBottom txtCenter">{{\Helper::zeroValueToNbspSpace($totalRange2)}}</td>
        <td class="td noPadding bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalAmount2)}}</td>
        <td class="td noPadding bold alignTop borderTopBottom txtCenter">{{\Helper::zeroValueToNbspSpace($totalRange3)}}</td>
        <td class="td noPadding bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalAmount3)}}</td>
        <td class="td noPadding bold alignTop borderTopBottom txtCenter">{{\Helper::zeroValueToNbspSpace($totalRange4)}}</td>
        <td class="td noPadding bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalAmount4)}}</td>
        <td class="td noPadding bold alignTop borderTopBottom txtCenter">{{\Helper::zeroValueToNbspSpace($totalRange1+$totalRange2+$totalRange3+$totalRange4)}}</td>
        <td class="td noPadding bold alignTop borderTopBottom txtRight">{{\Helper::customAmountFormat($totalAmount1+$totalAmount2+$totalAmount3+$totalAmount4)}}</td>
    </tr>
</tbody>
</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="PharmacyOutstanding">
            <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/OutstandingInputOld') }}" 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-->