@extends('Reports.template')

@section('title', __('Supplier Ledger'))

@section('ExternalCss')
@parent
<style>
    .supplier-ledger-page { padding-top: 15px; }
    .supplier-ledger { width: 100%; border-collapse: collapse; }
    .supplier-ledger th, .supplier-ledger td { padding: 2px 4px; vertical-align: top; }
    .supplier-ledger thead th { border-top: 1px solid #000; border-bottom: 1px solid #aaa; }
    .supplier-ledger .amount { text-align: right; white-space: nowrap; font-variant-numeric: tabular-nums; }
    .supplier-ledger .document { white-space: nowrap; }
    .supplier-ledger .supplier-heading { background: #eee; font-weight: bold; border-top: 1px solid #000; border-bottom: 1px solid #aaa; }
    .supplier-ledger .supplier-total, .supplier-ledger .overall-total { font-weight: bold; border-top: 1px solid #000; border-bottom: 1px solid #000; }
    .supplier-ledger .spacer td { height: 12px; border: 0; }
    .ledger-logo { max-height: 90px; max-width: 160px; }
    .ledger-actions { margin-bottom: 15px; }
    .table>tbody>tr>td, .table>tbody>tr>th, .table>tfoot>tr>td, .table>tfoot>tr>th, .table>thead>tr>td, .table>thead>tr>th {
        padding: 2px;
        line-height: 1.42857143;
        vertical-align: top;
        border-top: 1px solid #ddd;
    }
    .opBalance { width: 12%; }
    @media print {
        @page { size: A4 landscape; margin: 10mm; }
        .supplier-ledger-page { padding: 0; }
        .table-responsive { overflow: visible; border: 0; }
        .supplier-ledger thead { display: table-header-group; }
        .supplier-ledger tfoot { display: table-footer-group; }
        .supplier-ledger tr { break-inside: avoid; }
        .supplier-heading { break-after: avoid; }
    }
</style>
@endsection

@section('Content')
@php
    $formatLedgerAmount = function ($minor) {
        return $minor == 0 ? '0,00' : \Helper::customAmountFormat($minor / 100);
    };
@endphp
<div class="supplier-ledger-page">
    @if (session('supplierLedgerFreezeMessage'))
        <div class="alert alert-success">{{ session('supplierLedgerFreezeMessage') }}</div>
    @endif
    <div class="table-responsive">
<table id="supplierLedgerTable" class="table commonFontSize supplier-ledger">
                <thead>
                    <tr>
                        <th colspan="2" class="borderNone borderBottom">
                            @if ($businessEntity && $businessEntity->logo)
                                <img class="img-responsive ledger-logo" alt="{{ __('Hospital Logo') }}" src="{{ 'data:image/jpeg;base64,' . base64_encode($businessEntity->logo) }}">
                            @endif
                        </th>
                        <th colspan="9" class="borderNone borderBottom">
                            @if ($businessEntity)
                                <div class="heading">{{ $businessEntity->name }}</div>
                                <div>{{ trim($businessEntity->add1 . ' ' . $businessEntity->add2 . ' ' . $businessEntity->city . ' ' . $businessEntity->pincode) }}</div>
                                <div>{{ __('Phone') }} : {{ $businessEntity->tel1 }}</div>
                            @endif
                        </th>
                    </tr>
                    <tr>
                        <th colspan="7" class="th borderNone borderBottom reportTitle">{{ __('Supplier Ledger') }}</th>
                        <th colspan="4" class="th borderNone borderBottom txtRight">
                            {{ __('Period') }} : {{ \Carbon\Carbon::parse($fromDate)->format('d/m/Y') }} {{ __('TO') }} {{ \Carbon\Carbon::parse($toDate)->format('d/m/Y') }}
                        </th>
                    </tr>
                    <tr>
                        <th scope="col">{{ __('Doc. Date / Time') }}</th>
                        <th scope="col">{{ __('Due Date') }}</th>
                        <th scope="col">{{ __('T. Doc') }}</th>
                        <th scope="col">{{ __('Series') }}</th>
                        <th scope="col">{{ __('Doc No') }}</th>
                        <th scope="col">{{ __('Ext. No') }}</th>
                        <th scope="col">{{ __('Account') }}</th>
                        <th scope="col">{{ __('Status') }}</th>
                        <th scope="col" class="amount">{{ __('Credit') }}</th>
                        <th scope="col" class="amount">{{ __('Debit') }}</th>
                        <th scope="col" class="amount opBalance">{{ __('Balance') }}</th>
                    </tr>
                </thead>
                @forelse ($report['groups'] as $group)
                    <tbody>
                        <tr class="supplier-heading">
                            <th colspan="8" scope="rowgroup">{{ ($group['supplier']->supplier_code ?: $group['supplier']->supplier_id) . ' / ' . $group['supplier']->supplier_name }}</th>
                            <th scope="col" class="amount">{{ __('Credit') }}</th>
                            <th scope="col" class="amount">{{ __('Debit') }}</th>
                            <td class="amount"><span class="pull-left">&emsp;{{ __('Op Bal') }} :</span> {{ $formatLedgerAmount($group['opening_minor']) }}</td>
                        </tr>
                        @forelse ($group['entries'] as $entry)
                            <tr>
                                @php
                                    $documentDate = $entry->bill_date && substr($entry->bill_date, 0, 10) !== '0000-00-00'
                                        ? \Carbon\Carbon::parse($entry->bill_date) : null;
                                @endphp
                                <td class="document">{{ $documentDate ? $documentDate->format('d/m/Y') : '-' }} {{ $entry->event_time }}</td>
                                <td class="document">{{ $documentDate ? $documentDate->copy()->addDays(30)->format('d/m/Y') : '-' }}</td>
                                <td>{{ __(['P' => 'Purchase', 'GRN' => 'Purchase', 'PR' => 'Purchase return', 'GRNR' => 'Purchase return', 'PAYMENT' => 'Payment'][$entry->document_type]) }}</td>
                                <td>1</td>
                                <td class="document">{{ $entry->purchase_trn_no }}</td>
                                <td>{{ $entry->bill_no }}</td>
                                <td>CCO</td>
                                <td>{{ $entry->document_type === 'PAYMENT' ? 'LIQ' : 'PND' }}</td>
                                <td class="amount">{{ $formatLedgerAmount($entry->credit_minor) }}</td>
                                <td class="amount">{{ $formatLedgerAmount($entry->debit_minor) }}</td>
                                <td class="amount">{{ $formatLedgerAmount($entry->balance_minor) }}</td>
                            </tr>
                        @empty
                            <tr><td colspan="11">{{ __('No transactions in this period.') }}</td></tr>
                        @endforelse
                        <tr class="supplier-total">
                            <th colspan="8" scope="row" class="text-right">{{ __('Supplier total / Closing balance') }}</th>
                            <td class="amount">{{ $formatLedgerAmount($group['credit_minor']) }}</td>
                            <td class="amount">{{ $formatLedgerAmount($group['debit_minor']) }}</td>
                            <td class="amount">{{ $formatLedgerAmount($group['closing_minor']) }}</td>
                        </tr>
                        <tr class="spacer" aria-hidden="true"><td colspan="11"></td></tr>
                    </tbody>
                @empty
                    <tbody><tr><td colspan="11">{{ __('No supplier balances or transactions found for the selected period and supplier.') }}</td></tr></tbody>
                @endforelse
                @if (count($report['groups']) > 0)
                <tbody>
                    <tr class="overall-total">
                        <th colspan="8" scope="row">{{ __('Overall total / Closing balance') }} ({{ __('Opening') }}: {{ $formatLedgerAmount($report['totals']['opening_minor']) }})</th>
                        <td class="amount">{{ $formatLedgerAmount($report['totals']['credit_minor']) }}</td>
                        <td class="amount">{{ $formatLedgerAmount($report['totals']['debit_minor']) }}</td>
                        <td class="amount">{{ $formatLedgerAmount($report['totals']['closing_minor']) }}</td>
                    </tr>
                </tbody>
                @endif
                            <tfoot>
                    <tr>
                        <td colspan="7" class="th smallFont borderTopBottom">{{ __('Balance = opening + credit - debit. Negative balance is payable to supplier.') }}</td>
                        <td colspan="4" class="th smallFont borderTopBottom txtRight">{{ strtoupper(session('userId')) . ' # ' . $printedAt->format('d/m/Y H:i:s') }}</td>
                    </tr>
                </tfoot>
            </table>
    </div>
    <div class="col-xs-12 txtCenter ledger-actions no-print">
        <button type="button" class="btn btn-sm btn-info" id="btnexport" data-myval="{{ __('Supplier Ledger') }}">
            <span class="glyphicon glyphicon-download-alt"></span> {{ __('Excel') }}
        </button>
        <button type="button" onclick="window.print()" class="btn btn-sm btn-success">
            <span class="glyphicon glyphicon-print"></span> {{ __('Print') }}
        </button>
        <a href="{{ $backUrl }}" class="btn btn-danger btn-sm">
            <span class="glyphicon glyphicon-arrow-left"></span> {{ __('Back') }}
        </a>
    </div>
</div>
@endsection

@section('ExternalJs')
<script>
    $(function () {
        // Use the shared Excel exporter, with only the report table (no action buttons).
        $('#btnexport').off('click').on('click', function (event) {
            toExcel(event, 'supplierLedgerTable');
        });
    });
</script>
@endsection