@extends('layouts.master')
@section('title')
    {{translate('collection sheet')}}
@endsection
@section('content')
    <div class="panel panel-white">
        <div class="panel-heading">
            <h6 class="panel-title">
                {{translate('collection sheet')}}
                @if(!empty($start_date))
                    for period: <b>{{$start_date}} to {{$end_date}}</b>
                @endif
            </h6>

            <div class="heading-elements">

            </div>
        </div>
        <div class="panel-body hidden-print">
            {!! Form::open(array('url' => Request::url(), 'method' => 'GET','class'=>'form-horizontal', 'name' => 'form')) !!}
            <div class="row">
                <div class="col-md-4">
                    <x-forms.date-range-picker
                        name="date_range"
                        :start-date="$start_date"
                        :end-date="$end_date"
                    />
                </div>
                <div class="col-md-4">
                    {!! Form::label('user_id',translate('loan_officer'),array('class'=>'')) !!}
                    {!! Form::select('user_id',$users,$user_id, array('class' => 'form-control select2')) !!}
                </div>
            </div>
            <div class="panel-body">
                <div class="row">
                    <div class="col-xs-12">
                        <button type="submit" class="btn btn-success">{{translate('search')}}!
                        </button>
                        <a href="{{Request::url()}}"
                           class="btn btn-danger">{{translate('reset')}}!</a>

                        <div class="btn-group">
                            <button type="button" class="btn bg-blue dropdown-toggle legitRipple"
                                    data-toggle="dropdown">{{translate('download report')}}
                                <span class="caret"></span></button>
                            <ul class="dropdown-menu dropdown-menu-right">
                                <li>
                                    <a href="{{url('report/loan_report/collection_sheet/print?start_date='.$start_date.'&end_date='.$end_date."&user_id=".$user_id)}}"
                                       target="_blank"><i
                                            class="icon-file-pdf"></i> {{translate('print')}}
                                    </a></li>
                                <li>
                                <li>
                                    <a href="{{url('report/loan_report/collection_sheet/pdf?start_date='.$start_date.'&end_date='.$end_date."&user_id=".$user_id)}}"
                                       target="_blank"><i
                                            class="icon-file-pdf"></i> {{translate('download to pdf')}}
                                    </a></li>
                                <li>
                                    <a href="{{url('report/loan_report/collection_sheet/excel?start_date='.$start_date.'&end_date='.$end_date."&user_id=".$user_id)}}"
                                       target="_blank"><i
                                            class="icon-file-excel"></i> {{translate('download to excel')}}
                                    </a></li>
                                <li>
                                    <a href="{{url('report/loan_report/collection_sheet/csv?start_date='.$start_date.'&end_date='.$end_date."&user_id=".$user_id)}}"
                                       target="_blank"><i
                                            class="icon-download"></i> {{translate('download to csv')}}
                                    </a></li>
                            </ul>
                        </div>

                    </div>
                </div>
            </div>
            {!! Form::close() !!}

        </div>
        <!-- /.panel-body -->

    </div>

    <!-- /.box -->
    @if(!empty($start_date))
        <div class="panel panel-white">
            <div class="panel-body table-responsive no-padding">

                <table class="table table-bordered table-condensed table-hover">
                    <thead>
                    <tr class="bg-green">
                        <th>#</th>
                        <th>{{translate('loan_officer')}}</th>
                        <th>{{translate('borrower')}}</th>
                        <th>{{translate('phone')}}</th>
                        <th>{{translate('loan id')}}</th>
                        <th>{{translate('product')}}</th>
                        <th>{{translate('expected repayment date')}}</th>
                        <th>{{translate('maturity date')}}</th>
                        <th>{{translate('expected amount')}}</th>
                        <th>{{translate('due')}}</th>
                        <th>{{translate('outstanding')}}</th>
                    </tr>
                    </thead>
                    <tbody>
                        

                    @foreach($data as $index=> $key)
                            
                        @if(!empty($key->latest_schedule))
                            <tr class="@if($key->latest_schedule->loan_transactions_count > 0) danger @endif">
                                <td>
                                    {{ $row_count }}
                                </td>
                                <td>
                                    @if(!empty($key->loan_officer))
                                        <a href="{{url('user/'.$key->loan_officer_id.'/show')}}">{{$key->loan_officer->first_name}} {{$key->loan_officer->last_name}}</a>
                                    @endif
                                </td>
                                <td>
                                    @if(!empty($key->borrower))
                                        <a href="{{url('borrower/'.$key->borrower_id.'/show')}}">{{$key->borrower->first_name}} {{$key->borrower->last_name}}</a>
                                    @endif
                                </td>
                                <td>
                                    @if(!empty($key->borrower))
                                        {{$key->borrower->mobile}}
                                    @endif
                                </td>
                                <td><a href="{{url('loan/'.$key->id.'/show')}}">{{$key->id}}</a></td>
                                <td>
                                    @if(!empty($key->loan_product))
                                        {{$key->loan_product->name}}
                                    @endif
                                </td>
                                <td>{{$key->latest_schedule->due_date}}</td>
                                <td>{{$key->maturity_date}}</td>
                                <td class="credit">{{currency_converter($expected)}}</td>
                                <td class="credit">{{currency_converter($due)}}</td>
                                <td class="credit">{{currency_converter($balance)}}</td>
                            </tr>
                        @endif
                    @endforeach

                    </tbody>
                    <tfoot>
                    <tr>
                        <td colspan="8"></td>
                        <td class="credit"><b>{{currency_converter($total_expected)}}</b></td>
                        <td class="credit"><b>{{currency_converter($total_due)}} </b></td>
                        <td class="credit"><b>{{currency_converter($total_outstanding)}} </b></td>

                    </tr>
                    </tfoot>
                </table>
            </div>
        </div>
        <script>
            $(document).ready(function () {
                // $("body").addClass('sidebar-xs');
            });
        </script>
    @endif
@endsection
@section('footer-scripts')

@endsection