@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="4" class="th borderNone borderBottom reportTitle">{{__('Pharmacy User Wise Collection Report')}}</th>
            <th colspan="4" 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')}}&nbsp;&nbsp;</th>
            <th width="4%" class="th noPadding alignTop borderTopBottom txtRight">{{__('Bill/Receipt No')}} &emsp;</th>
            <th width="8%" class="th noPadding alignTop borderTopBottom">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{{__('Bill/Receipt Date Time')}}</th>
            <th width="20%" class="th noPadding alignTop borderTopBottom">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{{__('Patient / Supplier Name')}}</th>
            <th width="15%" class="th noPadding alignTop borderTopBottom">{{__('Payment Remark')}}&emsp;</th>
            <th width="15%" class="th noPadding alignTop borderTopBottom">{{__('Payment Mode')}}&emsp;</th>
            <th width="15%" class="th noPadding alignTop borderTopBottom">{{__('Amount')}}&emsp;</th>
            <th width="8%" class="th noPadding alignTop borderTopBottom">&emsp;&emsp;{{__('User Id')}}</th>
        </tr>  
    </thead>
    <tbody>
        @php
        $sr = 1;
        $grandTotalAmount = 0;
        $maxLength = 0;
        $billTotals = [];

         /* Find maximum formatted length */
         foreach($billData as $bill){
             $amount = ($bill->trn_type == 'I' || $bill->trn_type == 'PR')
                         ? $bill->amount_received_b
                         : $bill->amount_received_b * (-1);

             $formatted = \Helper::customAmountFormat($amount);
             $maxLength = max($maxLength, strlen($formatted));
         }

         foreach($receiptData as $receipt){
             $formatted = \Helper::customAmountFormat($receipt->receipt_amount);
             $maxLength = max($maxLength, strlen($formatted));
         }

         /* Calculate totals per bill */
          foreach($billData as $bill){

              $billKey = $bill->trn_type.'/'.$bill->trn_fyear.'/'.$bill->trn_id;

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

              if(!isset($billTotals[$billKey])){
                  $billTotals[$billKey] = 0;
              }

              $billTotals[$billKey] += $amount;
          }
        @endphp

        @foreach($billData as $index => $bill)

        @php

        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 . " )";
        }

        $amount = ($bill->trn_type == 'I' || $bill->trn_type == 'PR')
                    ? $bill->amount_received_b
                    : $bill->amount_received_b * (-1);
        
        $billKey = $bill->trn_type.'/'.$bill->trn_fyear.'/'.$bill->trn_id;

$nextBillKey = isset($billData[$index+1])
    ? $billData[$index+1]->trn_type.'/'.$billData[$index+1]->trn_fyear.'/'.$billData[$index+1]->trn_id
    : null;

$isLastRow = ($billKey != $nextBillKey);

        $grandTotalAmount += $amount;

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

        @endphp

        <tr>
        <td class="td noPadding alignTop borderTopGray txtRight">{{ $sr++ }}</td>
        <td class="td noPadding alignTop borderTopGray txtRight">{{ $bill->trn_type }}/{{ $bill->trn_fyear }}/{{ $bill->trn_id }}</td>
        <td class="td noPadding alignTop borderTopGray">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{{ \Helper::getDisplayDateTime($bill->trn_date ." ". $bill->ph_created_time) }}</td>
        <td class="td noPadding alignTop borderTopGray txtLeft">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{{ $patOrCustName }}</td>
        <td class="td noPadding alignTop borderTopGray txtLeft">{{ $message }}</td>
        <td class="td noPadding alignTop borderTopGray txtLeft">{{ $bill->gm_description }}</td>
        <td class="td noPadding alignTop borderTopGray txtLeft">
                 @php
                 $val = \Helper::customAmountFormat($amount);
                 $spaces = $maxLength - strlen($val);
                 @endphp
                 {!! str_repeat('&nbsp;', $spaces) !!}{{ $val }}
                 
                 @if($isLastRow && $billTotals[$billKey] != $amount)
                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b> Total - {{ \Helper::customAmountFormat($billTotals[$billKey]) }}</b>
                 @endif
        </td>
        <td class="td noPadding alignTop borderTopGray">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{{ $bill->created_by }}</td>
        </tr>

        @endforeach
        @foreach($receiptData as $receipt)
        @php

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

        $receiptAmount = $receipt->receipt_amount;

        $totalReceiptAmount = $receiptAmount;
        $grandTotalAmount += $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">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{{ \Helper::getDisplayDateTime($receipt->trn_receipt_date ." ". $receipt->created_time) }}</td>
            <td class="td noPadding alignTop borderTopGray txtLeft">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{{ $patOrCustName }}</td>
            <td class="td noPadding alignTop borderTopGray txtLeft">{{ $message }}&emsp;</td>
            <td class="td noPadding alignTop borderTopGray txtLeft">{{ $receipt->gm_description }}</td>
            <td class="td noPadding alignTop borderTopGray txtLeft">  
                  @php
                  $val = \Helper::customAmountFormat($totalReceiptAmount);
                  $spaces = $maxLength - strlen($val);
                  @endphp
                  {!! str_repeat('&nbsp;', $spaces) !!}{{ $val }}
            </td>
            <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"></td>
            <td class="td bold noPadding alignTop borderTop txtLeft">{{__('Grand Total')}} :</td>
            <td class="td bold noPadding alignTop borderTop txtLeft">
            {{ \Helper::customAmountFormat($grandTotalAmount) }}
            </td>
            <td class="td bold noPadding alignTop borderTop txtRight"></td>
        </tr>
    </tbody>
    <tfoot>
        <th colspan="4" class="th smallFont noPadding alignTop borderTopBottom"><span class="fontsize10">&#10033;</span> {{__(Config::get('constants.asterisk.WALK_CUST'))}}</th>
        <td colspan="4" class="th smallFont noPadding alignTop borderTopBottom txtRight">{{ strtoupper(Session::get('userId'))." # ".$currentTime->format('d/m/Y H:i:s ')}}</td>    
    </tfoot>
</table>
<br/><br/>


@php
$paymentModeSummary = [];
$grandSummaryTotal = 0;

/* Bill Data */
foreach($billData as $bill){

    $mode = $bill->gm_description;

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

    if(!isset($paymentModeSummary[$mode])){
        $paymentModeSummary[$mode] = 0;
    }

    $paymentModeSummary[$mode] += $amount;
}

/* Receipt Data */
foreach($receiptData as $receipt){

    $mode = $receipt->gm_description;

    if(!isset($paymentModeSummary[$mode])){
        $paymentModeSummary[$mode] = 0;
    }

    $paymentModeSummary[$mode] += $receipt->receipt_amount;
}

/* Calculate Grand Total */
foreach($paymentModeSummary as $amt){
    $grandSummaryTotal += $amt;
}
@endphp

<center>
<table class="table table-responsive" style="border:1px solid #000; font-size:12px; width:35%; margin-top:0px;">
    
    <thead>
        <tr>
            <th colspan="2" class="th borderBottom reportTitle txtCenter">
                {{__('Payment Mode Wise Summary')}}
            </th>
        </tr>

        <tr>
            <th width="60%" class="th noPadding alignTop borderTopBottom txtLeft">
                {{__('Payment Mode')}}
            </th>

            <th width="40%" class="th noPadding alignTop borderTopBottom txtRight">
                {{__('Amount')}}
            </th>
        </tr>
    </thead>

    <tbody>

        @foreach($paymentModeSummary as $mode => $amount)
        <tr>
            <td class="td noPadding alignTop borderTopGray txtLeft">
                {{ $mode }}
            </td>

            <td class="td noPadding alignTop borderTopGray txtRight">
                {{ \Helper::customAmountFormat($amount) }}
            </td>
        </tr>
        @endforeach

        <!-- Grand Total Row -->
        <tr>
            <td class="td bold noPadding alignTop borderTop txtLeft">
                {{__('Grand Total')}} :
            </td>

            <td class="td bold noPadding alignTop borderTop txtRight">
                {{ \Helper::customAmountFormat($grandSummaryTotal) }}
            </td>
        </tr>

    </tbody>

</table>
</center>


<!--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-->