@extends('Reports.template')
@php
    $reportTitle = 'Pharmacy Supplier Payment Report';
@endphp

<!--Title-->
@section('title')
    {{ $reportTitle }}
@endsection
<!--Title Close-->

<!--External CSS-->
@section('ExternalCss')
    @parent
    <style>
        @media print {
            @page {
                size: A4 portrait;
            }
        }
    </style>
@endsection
<!--External CSS Close-->

@section('Content')
    @php
        if ($trnStatus === 'P') {
            $trnStatusMessage = 'Pending';
        } elseif ($trnStatus === 'C') {
            $trnStatusMessage = 'Completed';
        } else {
            $trnStatusMessage = 'ALL';
        }
    @endphp
    <!-- 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>
                    @if ($reportType === 'D')
                        <th colspan="14" class="borderNone borderBottom">
                    @else
                        <th colspan="8" class="borderNone borderBottom">
                    @endif
                    <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>
            <tr>
                <th colspan="4" class="th borderNone borderBottom reportTitle">{{ $reportTitle . ' ' }}<label
                        class="fontsize12 bold"> (Payment Status : {{ $trnStatusMessage }})</label></th>
                @if ($reportType === 'D')
                    <th colspan="8" class="txtRight th borderNone borderBottom"></th>
                @else
                    <th colspan="2" class="txtRight th borderNone borderBottom"></th>
                @endif
                <th colspan="4" class="txtRight th borderNone borderBottom">Period :
                    {{ \Helper::getDisplayDate($fromDate) }} TO {{ \Helper::getDisplayDate($toDate) }}</th>
            </tr>
            <tr>
                <th class="th noPadding alignTop borderTop borderBottomGray txtLeft">Voucher No</th>
                <th class="th noPadding alignTop borderTop borderBottomGray txtLeft">Voucher Date</th>
                <th class="th noPadding alignTop borderTop borderBottomGray txtLeft">Bill No</th>
                <th class="th noPadding alignTop borderTop borderBottomGray txtLeft">Bill Date</th>
                <th colspan="3" class="th noPadding alignTop borderTop borderBottomGray txtLeft">Supplier Name</th>
                <th class="th noPadding alignTop borderTop borderBottomGray txtRight ">Bill Amount</th>
                @if ($reportType === 'D')
                    <th class="th noPadding alignTop borderTop borderBottomGray txtLeft">&emsp;Payment Vou</th>
                    <th class="th noPadding alignTop borderTop borderBottomGray txtLeft">Payment Date</th>
                    <th class="th noPadding alignTop borderTop borderBottomGray txtLeft">Payment Mode</th>
                    <th class="th noPadding alignTop borderTop borderBottomGray txtLeft">Bank</th>
                    <th class="th noPadding alignTop borderTop borderBottomGray txtLeft">Cheque/Ref No</th>
                    <th class="th noPadding alignTop borderTop borderBottomGray txtLeft">Remarks</th>
                @endif
                <th class="th noPadding alignTop borderTop borderBottomGray txtRight ">Amount Paid</th>
                <th class="th noPadding alignTop borderTop borderBottomGray txtRight ">Outstanding</th>
            </tr>
            
        </thead>
        <tbody>
            @php
                $createdBy = '';
                $trnDetailsCount = 0;
            @endphp

                @foreach ($purchaseHeader as $purchaseHeaderKey => $purchaseHeaderData)
                   
                    @if ($trnStatus == 'C')

                        @php
                            $trnDate = explode(',', $purchaseHeaderData->TRN_DATE);
                            $purchaseBillNo = explode(',', $purchaseHeaderData->Purchase_Bill_no);
                            $purchaseBillDate = explode(',', $purchaseHeaderData->Purchase_Bill_date);
                            $billTotal = explode(',', $purchaseHeaderData->Bill_total);                          

                            $trnDetails = explode('/', $purchaseHeaderData->combined_id_year);
                            $trnType = $trnDetails[0];
                            $trnFyear = $trnDetails[1];
                            $trnId = $trnDetails[2];
                        @endphp

                                <tr>
                                    <td class="td alignTop borderTop txtLeft ">{{  $trnType . "/" . $trnFyear . "/" . $trnId }}</td>
                                    <td class="td alignTop borderTop txtLeft ">{{ $purchaseHeaderData->Bill_Amount_Date }}</td>
                                    <td class="td alignTop borderTop txtLeft ">{{ $purchaseHeaderData->purchase_bill_no }}</td>
                                    <td class="td alignTop borderTop txtLeft ">{{ $purchaseHeaderData->purchase_bill_date }}</td>
                                    <td colspan="3" class="td alignTop borderTop txtLeft">{{ $purchaseHeaderData->supplier_name }}</td>
                                    <td class="td alignTop borderTop txtRight ">{{ number_format((float)$purchaseHeaderData->total, 2, '.', ',') }}</td>
                                    
                                    @if ($reportType === 'D')
                                        @foreach ($paymentDetailsMax as $detailsKey => $detailsValue)
                                            @if($detailsKey == $trnId) 
                                                @php
                                                    $trnDetailsCount = $trnDetailsCount + 1;
                                                @endphp
                                                @foreach ($detailsValue as $detailsValueKey => $finalValue)
                                                        <td style="border-top:none; border-bottom:none;" class="td alignTop {{ $detailsValueKey == 0 ? 'borderTop' : '' }} txtLeft ">&emsp;{{ $finalValue->Payment_Vou_Fyear . '/' . $finalValue->Payment_Vou_No }}</td>
                                                        <td style="border-top:none; border-bottom:none;" class="td alignTop {{ $detailsValueKey == 0 ? 'borderTop' : '' }} txtLeft ">{{ \Helper::getDisplayDate($finalValue->Bill_Amount_Date) }}</td>
                                                        <td style="border-top:none; border-bottom:none;" class="td alignTop {{ $detailsValueKey == 0 ? 'borderTop' : '' }} txtLeft">{{ $finalValue->payment_mode }}</td>
                                                        <td style="border-top:none; border-bottom:none;" class="td alignTop {{ $detailsValueKey == 0 ? 'borderTop' : '' }} txtLeft">{{ $finalValue->bank }}</td>
                                                        <td style="border-top:none; border-bottom:none;" class="td alignTop {{ $detailsValueKey == 0 ? 'borderTop' : '' }} txtLeft">{{ $finalValue->cheque_ref_no }}</td>
                                                        <td style="border-top:none; border-bottom:none;" class="td alignTop {{ $detailsValueKey == 0 ? 'borderTop' : '' }} txtLeft">{{ $finalValue->Payment_Remark }}</td>
                                                        <td style="border-top:none; border-bottom:none;" class="td alignTop {{ $detailsValueKey == 0 ? 'borderTop' : '' }} txtRight ">{{ number_format((float)$finalValue->Bill_Amount_Paid, 2, '.', ',') }}</td>
                                                        <td style="border-top:none; border-bottom:none;" class="td alignTop {{ $detailsValueKey == 0 ? 'borderTop' : '' }} txtRight">
                                                            @if($purchaseHeaderData->outstanding == 0)
                                                                0.00
                                                            @else
                                                                {{ \Helper::customAmountFormat($purchaseHeaderData->outstanding) }}
                                                            @endif
                                                        </td>
                                                    </tr>
                                                    <tr>
                                                        <td colspan="8"  style="border-top:none; border-bottom:none;" class="td  alignTop "></td>
                                                @endforeach
                                                </tr>

                                                @if (count($detailsValue) > 1)
                                                    <tr>
                                                        <td colspan="4" style="border-top:none; border-bottom:none;" class="td borderTopGray alignTop "></td>
                                                        <td colspan="3" style="border-top:none; border-bottom:none;" class="td bold borderTopGray alignTop txtLeft ">Total</td>
                                                        <td style="border-top:none; border-bottom:none;" class="td bold borderTopGray alignTop txtRight ">{{ number_format((float)$purchaseHeaderData->total, 2, '.', ',') }}</td>
                                                        <td colspan="6" style="border-top:none; border-bottom:none;" class="td borderTopGray alignTop "></td>
                                                        <td style="border-top:none; border-bottom:none;" class="td bold borderTopGray alignTop txtRight ">{{ number_format((float)$purchaseHeaderData->total, 2, '.', ',') }}</td>
                                                        <td style="border-top:none; border-bottom:none;" class="td bold borderTopGray alignTop txtRight ">
                                                            @if($purchaseHeaderData->outstanding == 0)
                                                                0.00
                                                            @else
                                                                {{ \Helper::customAmountFormat($purchaseHeaderData->outstanding) }}
                                                            @endif
                                                        </td>
                                                    </tr>
                                                @endif
                                            @endif
                                        @endforeach
                                    @endif

                                    @if ($purchaseHeaderKey >= $trnDetailsCount || $reportType === 'S')
                                    
                                        @if($purchaseHeaderData->total != 0)
                                            <td class="td alignTop borderTopBottom txtRight ">{{ $purchaseHeaderData->total }}</td>
                                        @else
                                            <td class="td alignTop borderTopBottom txtRight ">0.00</td>
                                        @endif

                                        @if($purchaseHeaderData->outstanding != 0)
                                            <td class="td alignTop borderTopBottom txtRight ">{{ \Helper::customAmountFormat($purchaseHeaderData->outstanding) }}</td>
                                        @else
                                            <td class="td alignTop borderTopBottom txtRight ">0.00</td>
                                        @endif
                                        </tr>
                                    @endif
                    @else
                        <tr>
                            <td class="td alignTop borderTop txtLeft ">{{  $purchaseHeaderData->trn_type . "/" . $purchaseHeaderData->trn_fyear . "/" . $purchaseHeaderData->trn_id }}</td>
                            <td class="td alignTop borderTop txtLeft ">{{ \Helper::getDisplayDate($purchaseHeaderData->trn_date) }}</td>
                            <td class="td alignTop borderTop txtLeft ">{{ $purchaseHeaderData->purchase_bill_no }}</td>
                            <td class="td alignTop borderTop txtLeft ">{{ \Helper::getDisplayDate($purchaseHeaderData->purchase_bill_date) }}</td>
                            <td colspan="3" class="td alignTop borderTop txtLeft">{{ $purchaseHeaderData->supplier_name }}</td>
                            <td class="td alignTop borderTop txtRight ">{{ number_format((float)$purchaseHeaderData->total, 2, '.', ',')  }}</td>
                            
                            @if ($reportType === 'D')
                                @foreach ($paymentDetailsMax as $trnId => $trnIdDetails)
                                    @if($trnId == $purchaseHeaderData->trn_id) 
                                        @php
                                            $trnDetailsCount = $trnDetailsCount + 1;
                                        @endphp

                                        @if (count($trnIdDetails) > 0)
                                            @foreach ($trnIdDetails as $key => $value)
                                                    <td style="border-top:none; border-bottom:none;" class="td alignTop {{ $key == 0 ? 'borderTop' : '' }} txtLeft ">&emsp;{{ $value->Payment_Vou_Fyear . '/' . $value->Payment_Vou_No }}</td>
                                                    <td style="border-top:none; border-bottom:none;" class="td alignTop {{ $key == 0 ? 'borderTop' : '' }} txtLeft ">{{ \Helper::getDisplayDate($value->Bill_Amount_Date) }}</td>
                                                    <td style="border-top:none; border-bottom:none;" class="td alignTop {{ $key == 0 ? 'borderTop' : '' }} txtLeft">{{ $value->payment_mode }}</td>
                                                    <td style="border-top:none; border-bottom:none;" class="td alignTop {{ $key == 0 ? 'borderTop' : '' }} txtLeft">{{ $value->bank }}</td>
                                                    <td style="border-top:none; border-bottom:none;" class="td alignTop {{ $key == 0 ? 'borderTop' : '' }} txtLeft">{{ $value->cheque_ref_no }}</td>
                                                    <td style="border-top:none; border-bottom:none;" class="td alignTop {{ $key == 0 ? 'borderTop' : '' }} txtLeft">{{ $value->Payment_Remark }}</td>
                                                    <td style="border-top:none; border-bottom:none;" class="td alignTop {{ $key == 0 ? 'borderTop' : '' }} txtRight ">{{ number_format((float)$value->Bill_Amount_Paid, 2, '.', ',') }}</td>
                                                    <td style="border-top:none; border-bottom:none;" class="td alignTop {{ $key == 0 ? 'borderTop' : '' }} txtRight">
                                                        @if($purchaseHeaderData->outstanding == 0)
                                                            0.00
                                                        @else
                                                            {{ \Helper::customAmountFormat($purchaseHeaderData->outstanding) }}
                                                        @endif
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td colspan="8"  style="border-top:none; border-bottom:none;" class="td  alignTop "></td>
                                            @endforeach
                                            </tr>

                                            @if (count($trnIdDetails) > 1)
                                                <tr>
                                                    <td colspan="4" style="border-top:none; border-bottom:none;" class="td borderTopGray alignTop "></td>
                                                    <td colspan="3" style="border-top:none; border-bottom:none;" class="td bold borderTopGray alignTop txtLeft ">Total</td>
                                                    <td style="border-top:none; border-bottom:none;" class="td bold borderTopGray alignTop txtRight ">{{ number_format((float)$purchaseHeaderData->total, 2, '.', ',') }}</td>
                                                    <td colspan="6" style="border-top:none; border-bottom:none;" class="td borderTopGray alignTop "></td>
                                                    <td style="border-top:none; border-bottom:none;" class="td bold borderTopGray alignTop txtRight ">{{ number_format((float)$purchaseHeaderData->total_paid, 2, '.', ',') }}</td>
                                                    <td style="border-top:none; border-bottom:none;" class="td bold borderTopGray alignTop txtRight ">
                                                        @if($purchaseHeaderData->outstanding == 0)
                                                            0.00
                                                        @else
                                                            {{ \Helper::customAmountFormat($purchaseHeaderData->outstanding) }}
                                                        @endif
                                                    </td>
                                                </tr>
                                            @endif
                                        @else
                                            <td colspan="6" class="td alignTop borderTop"></td>
                                            <td class="td alignTop borderTop txtRight">
                                                @if($purchaseHeaderData->outstanding == 0)
                                                    0.00
                                                @else
                                                    {{ number_format((float)$purchaseHeaderData->total_paid, 2, '.', ',') }}
                                                @endif
                                            </td>
                                            <td class="td alignTop borderTop txtRight">
                                                @if($purchaseHeaderData->outstanding == 0)
                                                    0.00
                                                @else
                                                    {{ \Helper::customAmountFormat($purchaseHeaderData->outstanding) }}
                                                @endif
                                            </td>
                                        </tr>
                                        @endif
                                    @endif
                                @endforeach
                            @endif

                            @if ($purchaseHeaderKey >= $trnDetailsCount || $reportType === 'S')
                            
                                @if($purchaseHeaderData->total_paid != 0)
                                    <td class="td alignTop borderTopBottom txtRight ">{{ $purchaseHeaderData->total_paid }}</td>
                                @else
                                    <td class="td alignTop borderTopBottom txtRight ">0.00</td>
                                @endif
                                <td class="td alignTop borderTopBottom txtRight ">
                                    @if($purchaseHeaderData->outstanding == 0)
                                        0.00
                                    @else
                                        {{ \Helper::customAmountFormat($purchaseHeaderData->outstanding) }}
                                    @endif
                                </td>
                            </tr>
                            @endif
                    @endif
                @endforeach
        </tbody>
        @php
            $currentTime = \Carbon\Carbon::now();
        @endphp
        <tfoot>
            <td colspan="5" class="th smallFont noPadding alignTop borderTopBottom"></td>
            @if ($reportType === 'D')
                <td colspan="11" class="th smallFont noPadding alignTop borderTopBottom txtRight">
            @else
                <td colspan="5" class="th smallFont noPadding alignTop borderTopBottom txtRight">
            @endif
                {{ strtoupper(Session::get('userId')) . ' # ' . $currentTime->format('d/m/Y H:i:s ') }}</td>
        </tfoot>
    </table>

    <!--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/SupplierPaymentReportInput') }}" 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')
@endsection
<!--External JS Close-->