@extends('layouts.admin')
@push('title')
    {{ $user->name }} - {{ $user->user_id }} |
@endpush
@section('content')

<div class="container-fluid">
    <div class="row">
        <div class="col-md-12">
            <div class="card">
                <div class="card-header d-print-none">
                    <div class="row">
                        <div class="col-md-6">
                            <h5>Deposit Details</h5>
                        </div>
                        <div class="col-md-6 text-right">
                            <a href="javascript:window.print()" class="btn btn-info btn-sm"><i class="fa fa-print"></i></a>
                        </div>
                    </div>

                </div>
                <div class="card-body">
                    <form class="d-print-none" method="GET" action="{{ url()->current() }}">
                        <div class="row mb-3">

                            <div class="col-md-3">
                                <div class="form-group ">
                                    <label for="startDate" class="col-form-label pt-0">Date From</label>
                                    <input class="form-control" readonly type="text" name="start_date" id="startDate" placeholder="Search Date"  value="{{ old('start_date')}}" autocomplete="off">
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="form-group ">
                                    <label for="endDate" class="col-form-label pt-0">Date To</label>
                                    <input class="form-control" readonly type="text" name="end_date" id="endDate" placeholder="End Date"  value="{{ old('end_date')}}" autocomplete="off">
                                </div>
                            </div>

                            <div class="col-md-3">
                                <div class="form-group ">
                                    <label  class="col-form-label pt-0">Search Package</label>
                                    <select name="package_id" class="select2 form-control mb-3 custom-selec">
                                        <option disabled="" selected value="">Select One</option>
                                        @foreach ($packages as $package)
                                            <option @if( request()->get('package_id') == $package->id) selected @endif value="{{ $package->id }}" >{{ $package->package_name }}</option>
                                        @endforeach
                                    </select>

                                </div>
                            </div>



                            <div class="col-md-3 mt-4">
                            <button class="btn btn-primary">Search</button>
                                <a href="{{url('account/deposit/list')}}" class="btn btn-danger">Clear</a>
                            </div>
                        </div>
                    </form>
                    <div class="dropdown-divider d-print-none"></div>
                    <div class="row">
                        <div class="col-lg-12">
                            <div class="text-center mt-2">
                                <address class="font-10 address-details">
                                    <h3>{{get_option('app_name')}}</h3>
                                    <p>{{get_option('email')}}</p>
                                    <p><b>Deposit Details</b></p>
                                </address>
                            </div>
                        </div>
                        <hr>
                        <div class="col-md-12">
                            <div class="float-left mt-2">
                                <address class="font-13">
                                     <small class="font-size-14">User Name : <strong>{{$user->name}}</strong></small><br>
                                     <small class="font-size-14">User Id : <strong>{{$user->user_id}}</strong></small>
                                </address>
                            </div>
                        </div>
                        <div class="col-md-12">
                            <div class="table-responsive">
                                <table id="datatable-buttons-alllist" class="table table-striped table-bordered w-100">
                                    <thead>
                                        <tr>
                                            <th>SL.</th>
                                            <th>Invest Date</th>
                                            <th>Package Type</th>
                                            <th>Amount</th>
                                            <th>Profit Ratio</th>
                                            <th>Class</th>
                                            <th>Start Date</th>
                                            <th>End Date</th>
                                            <th>Total Return</th>
                                            <th>Total Due</th>
                                            <th>Status</th>
                                            <th>Action</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @php
                                            $total_amount = 0;
                                            $total_return = 0;
                                            $total_due = 0;
                                        @endphp
                                        @foreach($deposits as $deposit)
                                        <tr>
                                            
                                            <td>{{ $loop->iteration }}</td>
                                            <td>{{ date('d-M-Y',strtotime($deposit->invest_date)) }}</td>
                                            <td>{{ cn($deposit, 'package.package_name', '')   }}</td>
                                            <td>{{ number_format($deposit->amount) }}</td>
                                            <td>{{ $deposit->profit_ratio }}</td>
                                            <td>{{ $deposit->class_name }}</td>
                                            <td>{{ \Carbon\Carbon::parse($deposit->invest_start_date)->format('d-M-Y')  }}</td>
                                            <td>{{ \Carbon\Carbon::parse($deposit->invest_end_date)->format('d-M-Y')  }}</td>
                                            <td>{{ number_format(package_total_return($deposit->id) ,2)  }} </td>
                                            <td>{{ number_format(total_monthly_amount($deposit->id) ,2)  }} </td>
                                            <td>@if ($deposit->status == 4) <span class="text-danger">Close</span> @elseif($deposit->status == 3) Running @endif</td>
                                            <td>
                                                @if($deposit->closing_request != 1 && $deposit->status == 3)
                                                    <a href="{{ route('deposit.closing.agree', $deposit->id) }}" onclick="return confirm('Are you sure you want to close this?')" class="btn btn-sm btn-danger">Agree</a>
                                                @endif
                                                    <a style="cursor:pointer; color:#fff" class="btn btn-purple btn-sm open_modal_page dropdown-toggle" data-url="{{ route('deposit.pay',$deposit->id) }}" data-title="Payment Form">
                                                        <i class="fas fa-credit-card"></i>
                                                    </a>
                                                    <a style="cursor:pointer; color:#fff" class="btn btn-primary btn-sm open_modal_page dropdown-toggle" data-url="{{ route('account.dsp_collection',$deposit->id) }}" data-title="DPS Collection">
                                                        DPS Collection
                                                    </a>
                                            </td>
                                        </tr>

                                         @php
                                             $total_amount += $deposit->amount;
                                             $total_return += (package_total_return($deposit->id) + total_monthly_amount($deposit->id));
                                             $total_due += (total_monthly_amount($deposit->id));
                                         @endphp
                                        @endforeach

                                    </tbody>
                                    <tfoot>
                                    <tr>
                                        <td></td>
                                        <td></td>
                                        <td class="font-size-14">Total Amount</td>
                                        <td class="font-size-14">{{ $total_amount }}</td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                        <td class="font-size-14">Total Return</td>
                                        <td class="font-size-14">{{number_format($total_return, 2) }}</td>
                                        <td class="font-size-14">{{number_format($total_due, 2) }}</td>
                                        <td></td>
                                    </tr>
                                    </tfoot>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div> <!-- end col -->
    </div><!--end row-->

</div> <!-- container-fluid -->

@push('alljs')
<script src="{{asset('assets/libs/bootstrap-datepicker/js/bootstrap-datepicker.min.js')}}"></script>

<script type="text/javascript">
        $('#startDate').datepicker({
            format: 'dd-mm-yyyy',
            autoclose:!0,
            todayHighlight:!0
        });
        $('#endDate').datepicker({
            format: 'dd-mm-yyyy',
            autoclose:!0,
            todayHighlight:!0
        });
    </script>
@endpush
@endsection