@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 Report</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">
                                            <div class="form-group">
                                                <label class="col-xs-12 col-sm-2 control-label">Start Opening :</label>
                                                <div class="col-xs-12 col-sm-10">
                                                    <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-2 control-label">End Opening :</label>
                                                <div class="col-xs-12 col-sm-10">
                                                    <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/report/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">Amount</th>    
                                        <th class="text-right">Interest Income</th>
                                        <th class="text-right">Tax Income</th>
                                        <th class="text-right">Interest Customer</th>
                                        <th class="text-right">Tax Customer</th>
                                        <th class="text-right">Service Fee</th>
                                        <th class="text-right">Service Fee LEI</th>
                                        <th class="text-right">Tax LEI</th>
                                        <th class="text-right">Tax PPh23 LEI</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @forelse($distributions as $distribution)
                                        @php
                                            $interest_income = ceil($distribution->interest_rate/100*$distribution->amount);
                                            $interest_customer = ceil($distribution->amount*1.3/100);
                                            $tax_income = ceil(15/100*$interest_income);
                                            $tax_customer = ceil(15/100*$interest_customer);
                                            $service_fee = ceil($distribution->amount*0.30/100);
                                            $service_fee_lei = $interest_income-$interest_customer-$service_fee-$tax_income;
                                        @endphp
                                        <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">{{ number_format($distribution->amount) }}</td>
                                            <td class="text-right">{{ number_format($interest_income) }}</td>
                                            <td class="text-right">{{ number_format($tax_income) }}</td>
                                            <td class="text-right">{{ number_format($interest_customer) }}</td>
                                            <td class="text-right">{{ number_format($tax_customer) }}</td>
                                            <td class="text-right">{{ number_format($service_fee) }}</td>
                                            <td class="text-right">{{ number_format($service_fee_lei) }}</td>
                                            <td class="text-right">{{ number_format(ceil($service_fee_lei*10/100)) }}</td>
                                            <td class="text-right">{{ number_format(ceil($service_fee_lei*2/100)) }}</td>                                            
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="11" 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