@extends('layouts.main')

@section('content')
    <h5>{{$title}}</h5>
    @if(Auth::user()->canDo(['post_transactions']))
      <a class="btn btn-dark" href="{{route('bank_deposite.create')}}">Add Bank Transaction</a>
    @endif

    @if(Auth::user()->canDo(['view_banks']))
      <a class="btn btn-dark" href="{{route('bank.index')}}">Bank</a>
    @endif

    @if(Auth::user()->canDo(['create_banks']))
      <a class="btn btn-dark" href="{{route('bank.create')}}">Add Bank</a>
    @endif

    @if(Auth::user()->canDo(['view_transactions']))
      <a href="/bankreport" class="btn btn-dark">Generate Report</a>
    @endif      
    
    <hr>
         <div class="table-responsive">   
      <table class="table table-hover table-striped" id="expenses_table">
          <thead>
            <th>#</th> 
            <th>Date</th>
            <th>by</th>
            <th>Bank</th>
            <th>Reciept Number</th>
            <th>Type</th>
            <th>Deposit</th>
            <th>Withdraw</th>
            <th>Recorded by</th>
            <th>Action</th>
          </thead>

          <tbody>
            @foreach($deposits as $deposit)
              <tr>
                <td>{{$deposit->id}}</td>
                <td>{{$deposit->date}}</td>
                <td>{{App\User::find($deposit->deposited_by)->name}}</td>
                <td>{{$deposit->bank->account_number}}</td>
                <td>{{$deposit->voucher_number}}</td>
                <td>{{$deposit->transaction_type}}</td>
                <td>
                  @if($deposit->transaction_type == "Deposit")
                    {{number_format($deposit->amount)}}
                                      @endif
                </td>
                <td>
                  @if($deposit->transaction_type == "Withdraw")
                    {{number_format($deposit->amount)}}
                                      @endif
                </td>
                  <td>{{$deposit->user->name}}</td>
                  <td>

                    <form action="/bank_deposite/{{ $deposit->id }}" method="POST" onsubmit = 'return confirm("Are you sure you want to proceed?"); return false;'>

                      {{method_field('DELETE')}}

                      {{ csrf_field() }}
                      @if(Auth::user()->canDo(['edit_transactions']))
                        <a href="{{route('bank_deposite.edit',$deposit->id)}}" class="btn btn-info btn-sm">Edit</a>
                      @endif

                      @if(Auth::user()->canDo(['delete_transactions']))
                        <input type="submit" class="btn btn-danger btn-sm" value="Delete"/>
                      @endif
                  </form>
                  </td>
              </tr>
              
            @endforeach
            <tr>
                <th>Total</th> <th></th> <th></th><th></th><th></th> <th></th> <th>{{number_format($total_deposit)}}</th> <th>{{number_format($total_withdraw)}}</th> <th></th> <th></th>
            </tr>                                                
          </tbody>                      
      </table>
    </div>
<hr>
<div class="table-resposive">  
    <table class="table table-hover table-striped" id="example">
        <thead>
          <th>#</th>  <th>Bank name</th>  <th>Total Deposit</th> <th>Total withdraw</th>
            @if(!empty($from))
              <th></th>
            @endif
        </thead>               


        <tbody>
          @foreach($banks as $bank)
            <tr>
              <td>{{$bank->id}}</td>
              <td>{{$bank->account_number}}</td>
              @if(empty($from))
                  <td>{{number_format(  App\BankDeposit::where('bank_id',$bank->id)->where('transaction_type','Deposit')->sum('amount'))}}
                  </td>

                  <td>{{number_format(  App\BankDeposit::where('bank_id',$bank->id)->where('transaction_type','Withdraw')->sum('amount'))}}
                  </td>
                @else
                  <td>{{number_format(App\BankDeposit::where('bank_id',$bank->id)->where('transaction_type','Deposit')->whereBetween('date', [$from,$to])->sum('amount'))}}</td>

                  <td>{{number_format(App\BankDeposit::where('bank_id',$bank->id)->where('transaction_type','Withdraw')->whereBetween('date', [$from,$to])->sum('amount'))}}</td>

                  
                  <td>
                    @if(Auth::user()->canDo(['view_transactions']))
                      <a href="{{route('bank.edit',$id)}}">Show Details</a>
                    @endif
                  </td>
                @endif

            </tr>
            
          @endforeach
                                                        
        </tbody>                      
    </table>
</div>
@endsection