@extends('layouts.layout')
@section('body_class', 'nav-md')
@section('body_content')
<div class="container body">
    <div class="main_container">
        @include('includes.sidebar')
        <div class="right_col" role="main">
            <div class="page-title">
                <div class="title_left">
                    <h3>Laku Simpan Distribution</h3>
                </div>
                <div class="clearfix"></div>
            </div>

            <div class="row">                
                <div class="col-xs-12">
                    <div class="x_panel">                       
                        <div class="x_content">
                            <div style="margin-bottom:16px;">
                                <form class="form-horizontal" method="get">   
                                    <div class="row">
                                        <div class="col-xs-12 col-sm-6">
                                            <div class="form-group">
                                                <label class="col-xs-12 col-sm-4 control-label">Start Opening :</label>
                                                <div class="col-xs-12 col-sm-8">
                                                    <input name="start_opening" type="date" class="form-control" value="{{ $request['start_opening'] }}">
                                                </div>
                                            </div>
                                            <div class="form-group">
                                                <label class="col-xs-12 col-sm-4 control-label">End Opening :</label>
                                                <div class="col-xs-12 col-sm-8">
                                                    <input name="end_opening" type="date" class="form-control" value="{{ $request['end_opening'] }}">
                                                </div>
                                            </div>
                                        </div>                                        
                                    </div>                                 
                                    <div class="form-group text-center">
                                        <button type="submit" class="btn btn-default"><i class="fa fa-search" aria-hidden="true"></i> Search</button>
                                    </div>
                                </form>
                            </div>

                            <div class="text-right">
                                <a href="{{ route('account/lakusimpan/distribution/export', [
                                    'start_opening' => $request['start_opening'],
                                    'end_opening' => $request['end_opening'],
                                    ]) }}" class="btn btn-default" target="_blank"><i class="fa fa-download" aria-hidden="true"></i> Export Data</a>
                            </div>
                            <table class="table table-condensed table-bordered" style="margin-top:16px;">
                                <thead>
                                    <tr>                                  
                                        <th class="text-center">Opening Date</th>      
                                        <th class="text-center">Lending Batch</th>
                                        <th class="text-center">Agreement No.</th>
                                        <th class="text-right">Interest</th>
                                        <th class="text-right">Tenor</th>
                                        <th class="text-center">Maturity Date</th>
                                        <th class="text-right">Amount</th>     
                                        <th class="text-center">Status</th>
                                        <th class="text-right">Prorate Interest</th>
                                        <th></th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php $carbon_today = \Carbon\Carbon::today(); @endphp
                                    @forelse($distributions as $distribution)
                                        <tr>
                                            <td class="text-center">{{ $distribution->opening_date }}</td>
                                            <td class="text-center">{{ $distribution->lending_name }}</td>
                                            <td class="text-center">{{ $distribution->lending_agreement_no }}</td>
                                            <td class="text-right">{{ $distribution->interest_rate }}</td>
                                            <td class="text-right">{{ $distribution->tenor }}</td>
                                            <td class="text-center">{{ $distribution->maturity_date }}</td>
                                            <td class="text-right">{{ number_format($distribution->amount) }}</td>
                                            <td class="text-center">{{ $distribution->status }}</td>
                                            <td class="text-right">
                                                @php 
                                                    $carbon_opening = \Carbon\Carbon::parse(date("Y-m-d", strtotime($distribution->opening_date)));
                                                    $carbon_maturity = \Carbon\Carbon::parse(date("Y-m-d", strtotime($distribution->maturity_date)));

                                                    $diff_opening = $carbon_opening->diffInDays($carbon_today);
                                                    $diff_maturity = $carbon_maturity->diffInDays($carbon_opening);
                                                @endphp

                                                {{ number_format(ceil($distribution->interest_rate/100*$distribution->amount*$diff_opening/$diff_maturity)) }}
                                            </td>
                                            <td class="text-center"><a class="btn btn-sm btn-default" href="{{ route('account/lakusimpan/distribution/detail', ['id'=>$distribution->id]) }}"><i class="fa fa-search" aria-hidden="true"></i></a></td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="10" class="text-center">No Data</td>
                                        </tr>
                                    @endforelse
                                </tbody>
                            </table>

                            <div class="text-center">{{ $distributions->links() }}</div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        @include('includes.footer')
    </div>
</div>
@endsection