@extends('layouts.admin')

@section('content')
    @push('css')
        <style>
            .top-manue{
                margin-top:-20px;
            }
            .fsize{
                font-size:15px;
            }
        </style>
    @endpush
    
    
        
    
    <div class="container-fluid">
        <div class="row">
            <div class="col-md-12">

                <div class="card top-manue">
                    <div class="col-md-12">
                        @php
                            $t_list = model('Investment')::whereNotNull('closing_request_date')->count();
                            $d_list = model('Investment')::whereNotNull('closing_request_date')->where('capital_return_status', 'Due')->count();
                        @endphp
                        <nav class="navbar navbar-expand-lg navbar-light">
                            <div class="navbar-nav ">
                                <a class="nav-item fsize nav-link" href="{{ route('closing_request_report', $type='Due')}}">Due List ({{ $d_list }})</a>
                                <a class="nav-item fsize nav-link " href="{{ route('closing_request_report') }}">Total List ({{ $t_list }})</a>
                            </div>
                        </nav>
                    </div>
                </div>

                <div class="card">
                    <div class="card-header">
                        <div class="row">
                            <div class="col-md-6">
                                <h5>Closing Payment Report</h5>
                            </div>

                        </div>

                    </div>
                    <div class="card-body">
                        <form method="GET" action="{{ url()->current() }}">

                            <div class="row mb-3">
                                <div class="col-md-3">
                                    <div class="form-group ">
                                        <label for="packageType" class="col-form-label pt-0">Package Type<span class="text-danger">*</span></label>
                                        <select class="select2 form-control mb-3 custom-select {{ $errors->has('package_id') ? 'is-invalid' : '' }}" name="package_id" >
                                            <option disabled="" selected="" value="">Select Package Type</option>
                                            {{ create_option("packages","id","package_name",old('package_id')) }}
                                        </select>
                                    </div>
                                </div>
                                <div class="col-md-3">
                                    <div class="form-group ">
                                        <label  class="col-form-label pt-0">Search Member</label>
                                        <select name="user_id" class="select2 form-control mb-3 custom-selec">
                                            <option disabled="" selected value="">Select One</option>
                                            @foreach ($members as $member)
                                                <option {{ old('user_id') == $member->id ? 'selected' : '' }} value="{{ $member->id }}" >{{ $member->name }}-{{$member->user_id}}</option>
                                            @endforeach
                                        </select>

                                    </div>
                                </div>
                                <div class="col-md-3">
                                    <div class="form-group ">
                                        <label  class="col-form-label pt-0">Team</label>
                                        <select name="team_id" class="select2 form-control mb-3 custom-selec">
                                            <option selected value="">Select One</option>
                                            @foreach ($teams as $team)
                                                <option {{ old('team_id') == $team->id ? 'selected' : '' }} value="{{ $team->id }}" >{{ $team->name }}</option>
                                            @endforeach
                                        </select>

                                    </div>
                                </div>
                                <div class="col-md-2">
                                    <div class="form-group ">
                                        <label for="name" class="col-form-label pt-0">Search Date</label>
                                        <input class="form-control" readonly type="text" value="{{ old('invest_date_start') }}" name="invest_date_start" id="invest_date_start" placeholder="Search Date" >
                                    </div>
                                </div>
                                <div class="col-md-2">
                                    <div class="form-group ">
                                        <label for="name" class="col-form-label pt-0">End Date</label>
                                        <input class="form-control" readonly type="text" value="{{ old('invest_date_end') }}" name="invest_date_end" id="invest_date_end" placeholder="End Date" >
                                    </div>
                                </div>

                                <div class="col-md-2" style="margin-top: 26px;">
                                    <button class="btn btn-primary" type="submit">Search</button>
                                    <a  href="{{ url()->current() }}" class="btn btn-danger">Clear</a>
                                </div>
                            </div>
                        </form>
                        <div class="table-responsive">
                            <table id="datatable-buttons-alllist" class="table table-striped table-bordered w-100">
                                <thead>
                                <tr>
                                    <th>Sl.</th>
                                    <th>Member Name</th>
                                    <th>GA Name</th>
                                    <th>Deed No.</th>
                                    <th>Package Name</th>
                                    <th>Bank Name</th>
                                    <th>Branch Name</th>
                                    <th>A/C No</th>
                                    <th>Check No.</th>
                                    <th>Close Date</th>
                                    <th>Payment Date</th>
                                    <th>Capital</th>
                                    
                                    <th>Profit</th>
                                    
                                    <th>Due Amount</th>
                                    <th>Paid Amount</th>
                                    <th>Action</th>
                                </tr>
                                </thead>


                                <tbody>
                                @php
                                    $total_amount = 0;
                                    $due_amount = 0;
                                    $paid_amount = 0;
                                    $profit_amount = 0;
                                    
                                    
                                @endphp
                                @foreach ($investments as  $investment)
                                    <tr>
                                        <td>{{$loop->iteration}}</td>
                                        <td>{{ cn($investment, 'member.name', '') }} ({{ cn($investment, 'member.user_id', '') }})</td>
                                        <td>{{ cn($investment, 'ga.name', '') }} ({{ cn($investment, 'ga.user_id', '') }})</td>
                                        <td>{{ $investment->deed_no }}</td>
                                        <td>{{ cn($investment, 'package.package_name', '') }}</td>
                                        <td>{{ $investment->banck_name }}</td>
                                        <td>{{ $investment->br_name }}</td>
                                        <td>{{ $investment->ac_number }}</td>
                                        <td>{{ $investment->chk_no }}</td>
                                         <td>{{ \Carbon\Carbon::parse($investment->closing_request_date)->format('d-M-Y')  }}</td>
                                        <td>{{ $investment->payment_date ? \Carbon\Carbon::parse($investment->payment_date)->format('d-M-Y') : '' }}</td>
                                        <td>{{ number_format($investment->amount) }}</td>
                                        
                                        
                                        
                                                                                
                                        
                                        
                                         
                                          <td align='center'> - </td>
                                        
                                                                                  
                                        
                                        <td>
                                            @if($investment->capital_return_status =='Due')
                                                {{ number_format($investment->amount) }}
                                                @php
                                                    $due_amount +=$investment->amount;
                                                @endphp
                                            @endif
                                        </td>
                                        <td>
                                            @if($investment->capital_return_status =='Paid')
                                                {{ number_format($investment->amount) }}
                                                @php
                                                    $paid_amount +=$investment->amount;
                                                @endphp
                                            @endif
                                        </td>
                                        <td>
                                            <a  href="javascript:void(0)" data-url="{{ route('closing_request_report_status', $investment->id) }}" class="btn btn-sm @if($investment->capital_return_status =='Paid') btn-success @else btn-primary @endif open_phone_modal_page">{{ $investment->capital_return_status }}</a>
                                        </td>
                                    </tr>
                                    @php
                                        $total_amount += $investment->amount;
                                    @endphp

                                @endforeach
                                </tbody>
                                <tfoot>
                                    <tr>
                                        <td></td>
                                        <td class="text-right font-size-16 right subtoal">Sub Total : </td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                        
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                        <td class="mbcom font-size-16">{{ number_format($total_amount) }}</td>
                                        
                                        
                                        
                                        <td align='right' class='mbcom font-size-16'>  0 </td>
                                                                                
                                        <td class="mbcom font-size-16">{{ number_format($due_amount) }}</td>
                                        
                                        
                                        
                                        <td class="mbcom font-size-16">{{ number_format($paid_amount) }}</td>
                                        <td></td>

                                    </tr>
                                </tfoot>

                            </table>
                            <div class="float-right">
                                {{$investments->appends(request()->all())->links()}}
                            </div>
                        </div>
                    </div>
                </div>
            </div>

        </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">
            $('#invest_date_start').datepicker({
                format: 'dd-mm-yyyy',
                autoclose:!0,
                todayHighlight:!0
            });
            $('#invest_date_end').datepicker({
                format: 'dd-mm-yyyy',
                autoclose:!0,
                todayHighlight:!0
            });
        </script>
    @endpush
@endsection