@extends('index')
@section('content')
<section class="section">
  <div class="section-body">
    <div class="row">
      <div class="col-12">
        <div class="card">
          <div class="card-header">
            <h4>Cash Balance Table</h4>
            <div class="card-header-action">
              <div class="btn-group">
                <a href="{{ route('transaction.addBRS') }}" class="btn btn-primary">Balance Adjustment</a>
                <a href="{{ route('transaction.addTransfer') }}" class="btn btn-success">Bank/Cash Transfer</a>
              </div>
            </div>
          </div>
          <div class="card-body">
            <form action="{{ route('cashBalance.filter') }}" method="POST" class="needs-validation col-md-12" novalidate="">@csrf
              <div class="row">
                <div class="form-group col-md-5">                    
                  <label>Date From</label>
                  <input type="text" class="form-control datepicker" name="dfrom" value="{{$dfrom}}" required>
                  <div class="valid-feedback">Good job!</div>
                </div>
                <div class="form-group col-md-5">                    
                  <label>Date To</label>
                  <input type="text" class="form-control datepicker" name="dto" value="{{$dto}}" required>
                  <div class="valid-feedback">Good job!</div>
                </div>
                <div class="form-group col-md-2 mt-4">     
                  <button class="btn btn-primary mt-2" type="submit">Filter</button>
                </div>
              </div>
            </form>
            <div class="row">
              <div class="col-md-12">
                <div class="table-responsive">
                  <table class="table table-striped table-hover" id="tableExport" style="width:100%;">
                    <thead>
                      @if(!empty($dfrom) && !empty($dto))
                      <tr>
                        <th colspan="2"></th>
                        <th colspan="3"><b>Date From:</b> {{date("d-m-Y", strtotime($dfrom))}}</th>
                        <th colspan="3"><b>Date To:</b> {{date("d-m-Y", strtotime($dto))}}</th>
                      </tr>
                      @endif
                      <tr>
                        <th colspan="8"><h6 class="text-center">Available Cash: Rs. {{number_format($cashBalance)}}</h6></th>
                      </tr>
                      <tr>
                        <th>Sr.</th>
                        <th>Date</th>
                        <th>Transaction</th>
                        <th>Transaction Type</th>
                        <th>Debit</th>
                        <th>Credit</th>
                        <th>Balance</th>
                        <th>Action</th>
                      </tr>
                    </thead>
                    <tbody>
                      @php $index = 1; $balance = $oBalance; @endphp
                      @if($oBalance != 0)
                        <tr>
                          <td>{{$index++}}</td>
                          <td>{{\Carbon\Carbon::parse($dfrom)->format('d-m-Y')}}</td>
                          <td>Opening Balance</td>
                          <td>Opening Balance</td>
                          <td>{{ $oBalance < 0 ? number_format(abs($oBalance)) : '' }}</td>
                          <td>{{ $oBalance > 0 ? number_format(abs($oBalance)) : '' }}</td>
                          <td>{{ number_format($oBalance) }}</td>
                          <td></td>
                        </tr>
                      @endif
                      @if($transaction->count())
                        @foreach($transaction as $item)
                        @php
                          $balance += $item->debit;
                          $balance -= $item->credit;
                          // For cash ledger, display as-is (debit=inflow, credit=outflow)
                          $displayDebit = $item->debit;
                          $displayCredit = $item->credit;
                        @endphp
                        <tr>
                          <td>{{$index++}}</td>
                          <td>{{\Carbon\Carbon::parse($item->transaction_date)->format('d-m-Y')}}</td>
                          <td>{{ucfirst($item->transaction_to)}}</td>
                          <td>{{ucfirst($item->transaction_type)}}</td>
                          <td>{{isset($displayDebit) ? number_format($displayDebit) : ''}}</td>
                          <td>{{isset($displayCredit) ? number_format($displayCredit) : ''}}</td>
                          <td>{{number_format($balance)}}</td>
                          <td>
                            @if($item->transaction_to == 'employee')
                              <a href="{{ route('transaction.showEPayment', $item->transaction_id) }}" class="btn btn-info btn-sm">View</a>
                            @elseif($item->transaction_to == 'vendor')
                              <a href="{{ route('transaction.showVPayment', $item->transaction_id) }}" class="btn btn-info btn-sm">View</a>
                            @elseif($item->transaction_to == 'expense')
                              <a href="{{ route('transaction.showExpense', $item->transaction_id) }}" class="btn btn-info btn-sm">View</a>
                              @elseif($item->transaction_to == 'customer')
                              <a href="{{ route('transaction.showOPayment', $item->transaction_id) }}" class="btn btn-info btn-sm">View</a>
                            @else
                              <a href="{{ route('transaction.showBRS', $item->transaction_id) }}" class="btn btn-info btn-sm">View</a>
                            @endif
                          </td>
                        </tr>
                        @endforeach
                      @endif
                      @if($cBalance != 0)
                        <tr>
                          <td>{{$index++}}</td>
                          <td>{{\Carbon\Carbon::parse($dto)->format('d-m-Y')}}</td>
                          <td>Closing Balance</td>
                          <td>Closing Balance</td>
                          <td>{{ $cBalance < 0 ? number_format(abs($cBalance)) : '' }}</td>
                          <td>{{ $cBalance > 0 ? number_format(abs($cBalance)) : '' }}</td>
                          <td>{{ $balance ? number_format($balance += $cBalance) : number_format($oBalance + $cBalance) }}</td>
                          <td></td>
                        </tr>
                      @endif
                    </tbody>
                    <tfoot>
                      <tr>
                        <th>Sr.</th>
                        <th>Date</th>
                        <th>Transaction</th>
                        <th>Transaction Type</th>
                        <th>Debit</th>
                        <th>Credit</th>
                        <th>Balance</th>
                        <th>Action</th>
                      </tr>
                    </tfoot>
                  </table>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
    </div>
  </div>
</section>
@endsection