@extends('layouts.master')

@section('titel', 'Daily Payment Report | ')

@section('content')
@include('partials.header')
@include('partials.sidebar')

<main class="app-content">
  <div class="container">
    <h3>Daily Payment Report</h3>

    <form method="GET" action="{{ route('pvdailyreport.index') }}" class="mb-4">
        <div class="row">
            <div class="col-md-3">
                <label>From Date</label>
                <input type="date" name="fromDate" value="{{ request('fromDate') }}" class="form-control">
            </div>
            <div class="col-md-3">
                <label>To Date</label>
                <input type="date" name="toDate" value="{{ request('toDate') }}" class="form-control">
            </div>
            <div class="col-md-2 mt-4">
                <button type="submit" class="btn btn-primary">Show</button>
            </div>
            @if(request('fromDate') && request('toDate'))
            <div class="col-md-4 mt-4 text-end">
                <a href="{{ route('pvdailyreport.print', ['fromDate' => request('fromDate'), 'toDate' => request('toDate')]) }}" class="btn btn-secondary">Print</a>
                <a href="{{ route('pvdailyreport.export.pdf', ['fromDate' => request('fromDate'), 'toDate' => request('toDate')]) }}" class="btn btn-danger">Export PDF</a>
                <a href="{{ route('pvdailyreport.export.excel', ['fromDate' => request('fromDate'), 'toDate' => request('toDate')]) }}" class="btn btn-success">Export Excel</a>
            </div>
            @endif
        </div>
    </form>

    <div class="table-responsive">
        <table class="table table-bordered table-striped">
            <thead>
                <tr>
                    <th>Date</th>
                    <th>Payee A/c.</th>
                    <th>Paid From</th>
                    <th>Voucher No</th>
                    <th>Remarks</th>
                    <th style="text-align:right">Amount</th>
                </tr>
            </thead>
            <tbody>
                @php $grandTotal = 0; @endphp
                @forelse($reportData as $row)
                @php $grandTotal += $row->Amount; @endphp
                <tr>
                    <td>{{ \Carbon\Carbon::parse($row->VoucherDate)->format('d-m-Y') }}</td>
                    <td>{{ $row->PayeeAccount }}</td>
                    <td>{{ $row->PaidFromAccount }}</td>
                    <td>{{ $row->VoucherNo }}</td>
                    <td>{{ $row->Remarks }}</td>
                    <td style="text-align:right">{{ number_format($row->Amount, 0) }}</td>
                </tr>
                @empty
                <tr>
                    <td colspan="6" class="text-center">No data found for selected date range.</td>
                </tr>
                @endforelse
            </tbody>
            @if(count($reportData) > 0)
            <tfoot>
                <tr>
                    <th colspan="5" class="text-end">Grand Total</th>
                    <th style="text-align:right">{{ number_format($grandTotal, 0) }}</th>
                </tr>
            </tfoot>
            @endif
        </table>
    </div>
</div>
@endsection