@extends('admin.layouts.app')

@section('title', 'Expense Report')

@section('content')
<h4 class="font-weight-bold py-3 mb-0">Company Expenses Report</h4>

<div class="card" style="padding-right:10px;padding-left:10px;">
  <div id="accordion2">
    <div class="card mb-2">
      <div id="accordion2-2" class="collapse show" data-parent="#accordion2">
        <div style="padding:5px;">
          <form id="validation-form" method="post" action="{{ route('admin.reports.expenses') }}">
            @csrf
            <div class="form-row">
              <div class="col-md-3">
                <label class="form-label fw-semibold">Expense Type</label>
                <select class="select2-demo form-control" id="ExpenseType" name="ExpenseType">
                  <option value="all" @selected($filters['ExpenseType'] === 'all')>All</option>
                  @foreach ($categories as $category)
                    <option value="{{ $category->id }}" @selected((string) $filters['ExpenseType'] === (string) $category->id)>
                      {{ $category->Name }}
                    </option>
                  @endforeach
                </select>
              </div>

              <div class="form-group col-md-2">
                <label class="form-label">From Date</label>
                <input type="date" name="FromDate" id="FromDate" class="form-control" value="{{ $filters['FromDate'] }}" autocomplete="off">
              </div>

              <div class="form-group col-md-2">
                <label class="form-label">To Date</label>
                <input type="date" name="ToDate" id="ToDate" class="form-control" value="{{ $filters['ToDate'] }}" autocomplete="off">
              </div>

              <input type="hidden" name="Search" value="Search">

              <div class="form-group col-md-1">
                <label class="form-label">&nbsp;</label>
                <button type="submit" name="submit" class="btn btn-primary btn-finish">Search</button>
              </div>

              @if ($searched)
              <div class="form-group col-md-1">
                <label class="form-label">&nbsp;</label>
                <a href="{{ route('admin.reports.expenses') }}" class="btn btn-info btn-block" title="Clear Filter">X</a>
              </div>
              @endif
            </div>
          </form>
        </div>
      </div>
    </div>
  </div>

  <div class="card-datatable">
    <table id="example" class="table table-striped table-bordered dt-responsive nowrap" style="width:100%">
      <thead>
        <tr>
          <th>#</th>
          <th>Date</th>
          <th>Expense Type</th>
          <th>Description</th>
          <th>Amount (₹)</th>
          <th>Payment Mode</th>
          <th>Reference No</th>
          <th>Attachment</th>
          <th>Created By</th>
        </tr>
      </thead>
      <tbody>
        @foreach ($rows as $index => $row)
          <tr>
            <td>{{ $index + 1 }}</td>
            <td>{{ $row->ExpenseDate ? date('d/m/Y', strtotime($row->ExpenseDate)) : '' }}</td>
            <td>{{ $row->ExpenseTypeName ?? 'Unknown' }}</td>
            <td>{!! nl2br(e($row->Description ?? '')) !!}</td>
            <td><b>{{ number_format((float) $row->Amount, 2) }}</b></td>
            <td>{{ $row->PaymentMode }}</td>
            <td>{{ $row->ReferenceNo }}</td>
            <td>
              @if (! empty($row->Attachment) && file_exists(public_path('uploads/expenses/'.$row->Attachment)))
                <a href="{{ asset('uploads/expenses/'.$row->Attachment) }}" target="_blank" class="btn btn-sm btn-info">View</a>
              @else
                <span class="text-muted">No File</span>
              @endif
            </td>
            <td>{{ $row->CreatedByName ?? '' }}</td>
          </tr>
        @endforeach
      </tbody>
      <tfoot>
        <tr>
          <th colspan="4" class="text-right">Total Expense:</th>
          <th colspan="5">₹ {{ number_format($total, 2) }}</th>
        </tr>
      </tfoot>
    </table>
  </div>
</div>
@endsection

@push('scripts')
<script type="text/javascript">
$(document).ready(function() {
  $('#example').DataTable({
    order: [[1, "desc"]],
    pageLength: 25,
    dom: 'Bfrtip',
    buttons: [
      {
        extend: 'excelHtml5',
        title: 'Company_Expenses_report',
        text: '<i class="fa fa-file-excel"></i> Export Excel',
        className: 'btn btn-success btn-sm'
      }
    ]
  });
});
</script>
@endpush