@extends('admin.layouts.app')

@section('title', 'Payment Ledger')

@section('content')
<h4 class="font-weight-bold py-3 mb-0">Customer Payment Ledger</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.payment-ledger') }}">
            @csrf
            <div class="form-row">
              <div class="form-group col-md-3">
                <label class="form-label">Customers </label>
                <select class="select2-demo form-control" id="UserId" name="UserId">
                  <option value="all" @selected($filters['UserId'] === 'all')>All</option>
                  @foreach ($customers as $customer)
                    <option value="{{ $customer->id }}" @selected((string) $filters['UserId'] === (string) $customer->id)>
                      {{ $customer->Fname }} {{ $customer->Lname }}
                    </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.payment-ledger') }}" 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" style="width:100%">
      <thead>
        <tr>
          <th>Sr No</th>
          <th>Date</th>
          <th>Type</th>
          <th>Invoice / Code</th>
          <th>Payment Mode</th>
          <th>Narration</th>
          <th class="text-right">Debit (₹)</th>
          <th class="text-right">Credit (₹)</th>
          <th class="text-right">Balance (₹)</th>
        </tr>
      </thead>
      <tbody>
        @foreach ($rows as $index => $row)
          <tr>
            <td>{{ $index + 1 }}</td>
            <td>{{ $row->PaymentDate ? date('d/m/Y', strtotime($row->PaymentDate)) : '' }}</td>
            <td>{{ $row->Type }}</td>
            <td>{{ $row->Code }}</td>
            <td>{{ $row->PayMode }}</td>
            <td>{{ $row->Narration }}</td>
            <td class="text-right">{{ $row->debit > 0 ? number_format($row->debit, 2) : '-' }}</td>
            <td class="text-right">{{ $row->credit > 0 ? number_format($row->credit, 2) : '-' }}</td>
            <td class="text-right"><b>{{ number_format($row->balance, 2) }}</b></td>
          </tr>
        @endforeach
      </tbody>
      <tfoot>
        <tr>
          <th colspan="6" class="text-right">Total :</th>
          <th class="text-right text-primary">₹ {{ number_format($totalDebit, 2) }}</th>
          <th class="text-right text-success">₹ {{ number_format($totalCredit, 2) }}</th>
          <th class="text-right text-danger"><b>₹ {{ number_format($balance, 2) }}</b></th>
        </tr>
      </tfoot>
    </table>
  </div>
</div>
@endsection

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