@extends('admin.layouts.app')

@section('title', 'View Company Expenses')

@section('content')
<h4 class="font-weight-bold py-3 mb-0">
  View Company Expenses
  <span style="float: right;">
    <a href="{{ route('admin.expenses.create') }}" class="btn btn-secondary btn-round">
      <i class="ion ion-md-add mr-2"></i> Add Expense
    </a>
  </span>
</h4>

<div class="card">
<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>
      <th>Action</th>
    </tr>
  </thead>
  <tbody>
    @foreach ($expenses as $index => $row)
    <tr>
      <td>{{ $index + 1 }}</td>
      <td>{{ $row->ExpenseDate ? $row->ExpenseDate->format('d/m/Y') : '' }}</td>
      <td>{{ $row->category->Name ?? '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 ($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->creator->Name ?? '' }}</td>
      <td>
        <a href="{{ route('admin.expenses.edit', $row) }}" data-toggle="tooltip" title="Edit"><i class="lnr lnr-pencil mr-2"></i></a>
        <form method="POST" action="{{ route('admin.expenses.destroy', $row) }}" class="d-inline" onsubmit="return confirm('Are you sure you want to delete this expense?');">
          @csrf
          @method('DELETE')
          <button type="submit" class="btn btn-link p-0 align-baseline"><i class="lnr lnr-trash text-danger"></i></button>
        </form>
      </td>
    </tr>
    @endforeach
  </tbody>
  <tfoot>
    <tr>
      <th colspan="4" class="text-right">Total Expense:</th>
      <th colspan="6">₹ {{ number_format((float) $total, 2) }}</th>
    </tr>
  </tfoot>
</table>
</div>
</div>
@endsection

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