@extends('layouts/microfin_layout')
@section('title', '| Savings Status')
@section('content')

<div class="row">

    <div class="col-md-12">
       <div class="panel panel-default" style="background-color:#708090;">
          <div class="panel-heading" style="padding-bottom:0px">
            <div class="panel-options">
                <a href="{{ url('viewMfnSavingsStatus/') }}" class="btn btn-info pull-right addViewBtn">
                    <i class="glyphicon glyphicon-plus-sign addIcon"></i> 
                    Savings Status List
                </a>
            </div>		
            <h1 align="center" style="font-family: Antiqua;letter-spacing: 2px"><font color="white">SAVINGS STATUS</font></h1>
        </div>
        <div class="panel-body panelBodyView">

            <table id="headerTable">
                <tbody>
                    <tr>
                        <td>Member Name: <span class="info">{{$member->name}}</span></td>
                        <td>Member Code: <span class="info">{{$member->code}}</span></td>
                        <td class="pullRight">Saving Code: <span class="info">{{$saving->savingsCode}}</span></td>
                        <td class="pullRight">Date: <span class="info">{{$dateFrom}} to {{$dateTo}}</span></td>
                    </tr>
                </tbody>
            </table>
            <table class="table table-striped table-bordered" id="dataTable">
                <thead>
                    <tr>
                        <th>SL#</th>
                        <th>Date</th>
                        <th>Deposit</th>
                        <th>Interest</th>
                        <th>Refund</th>
                        <th>Balance</th>
                    </tr>
                </thead>
                <tbody>
                    @php
                    $openingBalance = $openingPrincipal + $openingInterest - $openingWithdraw;
                    @endphp
                    <tr>
                        <td colspan="2">Opening Balance</td>
                        <td class="amount">{{number_format($openingPrincipal,2)}}</td>
                        <td class="amount">{{number_format($openingInterest,2)}}</td>
                        <td class="amount">{{number_format($openingWithdraw,2)}}</td>
                        <td class="amount">{{number_format($openingBalance,2)}}</td>
                    </tr>
                    @foreach ($dates as $key => $date)
                    @php
                    $depositAmount = $deposits->where('depositDate',$date)->sum('amount');
                    $interestAmount = $interests->where('depositDate',$date)->sum('amount');
                    // $interestAmount = $interests->where('date',$date)->sum('interestAmount');
                    $withdrawAmount = $withdraws->where('withdrawDate',$date)->sum('amount');

                    $totalDeposits = $deposits->where('depositDate','<=',$date)->sum('amount');
                    $totalInterestAmount = $interests->where('depositDate','<=',$date)->sum('amount');
                    // $totalInterestAmount = $interests->where('date','<=',$date)->sum('interestAmount');
                    $totalWithdrawAmount = $withdraws->where('withdrawDate','<=',$date)->sum('amount');
                    $balance = $openingBalance + $totalDeposits + $totalInterestAmount - $totalWithdrawAmount;
                    @endphp
                    <tr>
                        <td>{{$key+1}}</td>
                        <td>{{date('d-m-Y',strtotime($date))}}</td>
                        <td class="amount">{{number_format($depositAmount,2)}}</td>
                        <td class="amount">{{number_format($interestAmount,2)}}</td>
                        <td class="amount">{{number_format($withdrawAmount,2)}}</td>
                        <td class="amount">{{number_format($balance,2)}}</td>
                    </tr>
                    @endforeach
                    <tfoot>
                        <tr>
                            @php
                            // $totalBalance = $deposits->sum('amount') + $interests->sum('interestAmount') - $withdraws->sum('amount');
                            $totalBalance = $deposits->sum('amount') + $interests->sum('amount') - $withdraws->sum('amount');
                            @endphp
                            <td colspan="2" style="text-align: center;">Total</td>
                            <td class="amount">{{number_format($deposits->sum('amount') + $openingPrincipal,2)}}</td>
                            {{-- <td class="amount">{{number_format($interests->sum('interestAmount') + $openingInterest,2)}}</td> --}}
                            <td class="amount">{{number_format($interests->sum('amount') + $openingInterest,2)}}</td>
                            <td class="amount">{{number_format($withdraws->sum('amount') + $openingWithdraw,2)}}</td>
                            <td class="amount">{{number_format($totalBalance + $openingBalance,2)}}</td>
                        </tr>
                    </tfoot>
                </tbody>
            </table>
        </div>

    </div>


</div>

</div>

<style type="text/css">
    #dataTable{
        color: black;
    }
    #dataTable tfoot tr td.amount{
        padding-right: 5px !important;
        text-align: right;
    }
    #headerTable{
        width: 100%;
    }
    #headerTable tbody tr td.pullRight{
        text-align: right;
    }
    span.info{
        color: black;
    }
</style>

@endsection