@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="15" 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(); 
        $columnCount = count($paymentModeData);
        @endphp
        <tr>
            <th colspan="5" class="th borderNone borderBottom reportTitle">Pharmacy User Wise Collection Report</th>
            <th colspan="{{ $columnCount + 1 }}" class="txtRight th borderNone borderBottom">
                @if($fromTime != "" && $toTime != "")
                Period : {{\Helper::getDisplayDateTime($fromDate." ".$fromTime)}} TO {{\Helper::getDisplayDateTime($toDate." ".$toTime)}}
                @else
                Period : {{\Helper::getDisplayDate($fromDate)}} TO {{\Helper::getDisplayDate($toDate)}}
                @endif
            </th>
        </tr>
        <tr>
            <th width="3%"  class="th noPadding alignTop borderTopBottom txtRight">Sr No</th>
            <th width="5%" class="th noPadding alignTop borderTopBottom txtRight">Bill No &emsp;</th>
            <th width="10%" class="th noPadding alignTop borderTopBottom">Bill Date Time</th>
            <th width="20%" class="th noPadding alignTop borderTopBottom">Patient / Supplier Name</th>
            <th width="15%" class="th noPadding alignTop borderTopBottom">Payment Details&emsp;</th>
            @foreach ($paymentModeData as $paymentMode)
            <th class="th noPadding alignTop borderTopBottom txtRight">{{ strtoupper($paymentMode) }}</th>    
            @endforeach
            <th width="8%" class="th noPadding alignTop borderTopBottom">&emsp;&emsp;User Id</th>
        </tr>  
    </thead>
    <tbody>
        @php
        $sr = 1;
        $grandTotalAmount = array();
        @endphp
        @foreach ($paymentModeData as $paymentMode)
        @php
        $grandTotalAmount[$paymentMode] = 0;
        @endphp
        @endforeach
       

       @php
$groupedBills = []; // Initialize the array to group bills
$sr = 1; // Reset counter if needed
@endphp

@foreach($billData as $bill)
@php
$totalAmount = array();

foreach ($paymentModeData as $paymentMode) {
    $totalAmount[$paymentMode] = 0;
}

if ($bill->patient_name != '') {
    $patOrCustName = $bill->patient_id . " / " . $bill->patient_name;
} else if ($bill->ph_cust_name != '') {
    $patOrCustName = '*' . $bill->ph_cust_id . " / " . $bill->ph_cust_name;
} else {
    $patOrCustName = $bill->supplier_name . "( " . $bill->purchase_bill_no . " )";
}

$headerBillAmount = ($bill->trn_type == 'I' || $bill->trn_type == 'PR') ? $bill->amount_received_b : $bill->amount_received_b * (-1);

$totalAmount[$bill->gm_description] = $headerBillAmount;
$grandTotalAmount[$bill->gm_description] += $headerBillAmount;

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

// Group payments by bill
if (!isset($groupedBills[$bill->trn_id])) {
    $groupedBills[$bill->trn_id] = [
        'sr' => $sr++,
        'bill_no' => $bill->trn_type ."/". $bill->trn_fyear. "/". $bill->trn_id,
        'date_time' => \Helper::getDisplayDateTime($bill->trn_date ." ". $bill->ph_created_time),
        'name' => $patOrCustName,
        'payments' => [],
        'user_id' => $bill->created_by,
        'message' => []
    ];
}
$groupedBills[$bill->trn_id]['payments'][$bill->gm_description] = $headerBillAmount;
$groupedBills[$bill->trn_id]['message'][] = $message;
@endphp
@endforeach


@foreach($groupedBills as $bill)
<tr>
    <td class="td noPadding alignTop borderTopGray txtRight">{{ $bill['sr'] }}</td>
    <td class="td noPadding alignTop borderTopGray txtRight">{{ $bill['bill_no'] }}&emsp;</td>
    <td class="td noPadding alignTop borderTopGray">{{ $bill['date_time'] }}</td>
    <td class="td noPadding alignTop borderTopGray txtLeft">{{ $bill['name'] }}</td>
    <td class="td noPadding alignTop borderTopGray txtLeft">
        @foreach($bill['message'] as $msg)
        {{ $msg }}<br>
        @endforeach
        &emsp;
    </td>
    @foreach ($paymentModeData as $paymentMode)
    <td class="td noPadding alignTop borderTopGray txtRight">
        {{ isset($bill['payments'][$paymentMode]) ? \Helper::customAmountFormat($bill['payments'][$paymentMode]) : '' }}
    </td>
    @endforeach
    <td class="td noPadding alignTop borderTopGray">&emsp;&emsp;{{ $bill['user_id'] }}</td>
</tr>  
@endforeach
        @foreach($receiptData as $receipt)
        @php
        $totalReceiptAmount = array();
        foreach ($paymentModeData as $paymentMode) {
            $totalReceiptAmount[$paymentMode] = 0;
        }

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

        $receiptAmount = $receipt->receipt_amount;

        $totalReceiptAmount[$receipt->gm_description] = $receiptAmount;
        $grandTotalAmount[$receipt->gm_description] += $receiptAmount;

        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;
        }
        @endphp

        <tr>
            <td class="td noPadding alignTop borderTopGray txtRight">{{ $sr++ }}</td>
            <td class="td noPadding alignTop borderTopGray txtRight">{{ $receipt->trn_receipt_no }}&emsp;</td>
            <td class="td noPadding alignTop borderTopGray">{{ \Helper::getDisplayDateTime($receipt->trn_receipt_date ." ". $receipt->created_time) }}</td>
            <td class="td noPadding alignTop borderTopGray txtLeft">{{ $patOrCustName }}</td>
            <td class="td noPadding alignTop borderTopGray txtLeft">{{ $message }}&emsp;</td>
            @foreach ($paymentModeData as $paymentMode)
            <td class="td noPadding alignTop borderTopGray txtRight">{{ \Helper::customAmountFormat($totalReceiptAmount[$paymentMode]) }}</td>
            @endforeach
            <td class="td noPadding alignTop borderTopGray">&emsp;&emsp;{{ $receipt->created_by }}</td>
        </tr>
        @endforeach

        <tr>
            <td colspan="5" class="td bold noPadding alignTop borderTop txtRight">Total :</td>
            @foreach ($paymentModeData as $paymentMode)
            <td class="td bold noPadding alignTop borderTop txtRight">{{ \Helper::customAmountFormat($grandTotalAmount[$paymentMode]) }}</td>
            @endforeach
            <td class="td bold noPadding alignTop borderTop txtRight"></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="{{ $columnCount + 1 }}" 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-->