@extends('layouts.app')

@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" 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') }}" class="btn btn-danger">Export PDF</a>-->
<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') }}" class="btn btn-success">Export Excel</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 ID</th>
                    <th>Voucher Type</th>
             
                    <th>Debit</th>
                    <th>Credit</th>
                    <th>Voucher Date</th>
                    <th>Remarks</th>
                    <th>Site</th>
                    <th>Company</th>
                </tr>
            </thead>
            <tbody>
                @forelse($data as $row)
                <tr>
                    <td>{{ $row->Account_Title }}</td>
                    <td>{{ $row->Voucher_ID }}</td>
                    <td>{{ $row->VoucherType }}</td>
              
                    <td>{{ $row->Debit }}</td>
                    <td>{{ $row->Credit }}</td>
                    <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
            </tbody>
        </table>
    </div>
    @endisset
</div>

<style>
@media print {
    body * {
        visibility: hidden;
    }
    .printableArea, .printableArea * {
        visibility: visible;
    }
    .printableArea {
        position: absolute;
        left: 0;
        top: 0;
        width: 100%;
    }
}
</style>
@endsection