@extends('layouts.app')

@push('css')
<link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
@endpush
@section('content')
<div class="container">
    <h2>Supplier Payment Report</h2>

    <form method="POST" action="{{ route('supplier.report.filter') }}">
        @csrf
        <div class="row mb-3">
            <div class="col">
                <label>From Date:</label>

                <input type="date" name="fromDate" class="form-control" value="{{ request('fromDate') }}" required>
            </div>
            <div class="col">
                <label>To Date:</label>
                <input type="date" name="toDate" class="form-control" value="{{ request('toDate') }}" required>
            </div>

            <div class="col">
                <label>Account:</label>
                <select name="account_id" class="form-control select2 border" required>
                    <option value="">Select Account</option>
                    @foreach($accounts as $acc)
                        <option value="{{ $acc->Account_ID }}" {{ request('account_id') == $acc->Account_ID ? 'selected' : '' }}>
                            {{ $acc->Account_Title }}
                        </option>
                    @endforeach
                </select>
            </div>
            <div class="col">
                <label>Site:</label>
                <select name="site" class="form-control" required>
                    <option value="">Select Site</option>
                    @foreach($sites as $s)
                        <option value="{{ $s }}" {{ request('site') == $s ? 'selected' : '' }}>{{ $s }}</option>
                    @endforeach
                </select>
            </div>
            <div class="col">
                <label>&nbsp;</label>
                <button type="submit" class="btn btn-primary form-control">Generate</button>
            </div>
        </div>
    </form>

    @isset($data)
    <div class="mb-3 text-end">
        <a href="{{ route('supplier.report') }}" class="btn btn-secondary">Back</a>
        <button onclick="window.print()" class="btn btn-dark">Print</button>

        <a href="{{ route('supplier.report.export.pdf', [
            'fromDate'   => request('fromDate'),
            'toDate'     => request('toDate'),
            'account_id' => request('account_id'),
            'site'       => request('site')
        ]) }}" class="btn btn-danger">Export PDF</a>

        <a href="{{ route('supplier.report.export.excel', [
            'fromDate'   => request('fromDate'),
            'toDate'     => request('toDate'),
            'account_id' => request('account_id'),
            'site'       => request('site')
        ]) }}" class="btn btn-success">Export To Excel</a>

        <a href="#" class="btn btn-info">Crystal Report</a> <!-- Placeholder -->
    </div>

    <div class="table-responsive printableArea">
        <table class="table table-bordered table-striped">
            <thead class="thead-dark">
                <tr>
                    <th>Account Title</th>
                    <th>Voucher</th>
                    <th>Type</th>
                    <th>Debit</th>
                    <th>Credit</th>
<th>Balance</th>
                    <th>Voucher Date</th>
                    <th>Remarks</th>
                    <th>Site</th>
                    <th>Company</th>
                </tr>
            </thead>
            <tbody>
                @forelse($data as $row)
 @php
        $running += $row->Debit - $row->Credit;
        $totalDebit += $row->Debit;
        $totalCredit += $row->Credit;
    @endphp
                <tr>
                    <td>{{ $row->Account_Title }}</td>
                    <td>{{ $row->Voucher_ID }}</td>
                    <td>{{ $row->VoucherType }}</td>
                    <td>{{ number_format($row->Debit, 2) }}</td>
                    <td>{{ number_format($row->Credit, 2) }}</td>
 <td>{{ number_format($running, 2) }}</td> <!-- Closing balance -->
                    <td>{{ $row->Voucher_Date }}</td>
                    <td>{{ $row->Remarks }}</td>
                    <td>{{ $row->Site }}</td>
                    <td>{{ $row->Company }}</td>
                </tr>
                @empty
                <tr>
                    <td colspan="10" class="text-center">No data found for the selected filters.</td>
                </tr>
                @endforelse

   @php
    $totalDebit = 0;
    $totalCredit = 0;
    foreach ($data as $row) {
        $totalDebit += $row->Debit;
        $totalCredit += $row->Credit;
    }
@endphp
<tr style="font-weight: bold;">
    <td colspan="3" class="text-end">Total:</td>
    <td>{{ number_format($totalDebit, 2) }}</td>
    <td>{{ number_format($totalCredit, 2) }}</td>
    <td>{{ number_format($totalCredit-$totalDebit, 2) }}</td>
    <td colspan="4"></td>
</tr>
            </tbody>
        </table>
    </div>
    @endisset
</div>
@push('js')
<script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
<script>
    $(document).ready(function () {
        $('.select2').select2({ width: '100%' });
    });
</script>
@endpush
<style>
@media print {
    body * {
        visibility: hidden;
    }
    .printableArea, .printableArea * {
        visibility: visible;
    }
    .printableArea {
        position: absolute;
        left: 0;
        top: 0;
        width: 100%;
    }
}

/* ✅ Set font-size to 9pt for headings and detail rows */
.table thead tr,
.table tbody tr {
    font-size: 9pt;
}
</style>
@endsection