@extends('layouts.app' )


@section('title')
Recovery Due Till {{date('d-F-Y')}}
@stop

@section('css')
    <link href="{{asset('plugins/components/chartist-js/dist/chartist.min.css')}}" rel="stylesheet">

    <link href="{{asset('plugins/components/bootstrap-daterangepicker/daterangepicker.css')}}" rel="stylesheet">

<link rel="stylesheet" type="text/css" href="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.css" />

<style type="text/css">
    .prev
    {
        cursor: pointer;
    }

     .next
    {
        cursor: pointer;
    }
table.dataTable thead .sorting:after {
display: none;
}

hr {
    border-color: #eee;
}

</style>
@stop


@section('content')

<div class=" container-fluid">
<br>


<!--.row-->
                <div class="row no-print" style="margin-bottom: 1rem;">
                <div class="col-md-12">
                <div class="panel panel-info">
                <div class="panel-heading">Report</div>
                <div class="panel-wrapper collapse in" aria-expanded="true">
                <div class="panel-body">
               
               
                <div class="col-sm-12 text-center">
               
                        <div>
                        <h2><strong>{{env('APP_NAME')}}</strong></h2>
                        
                       <h4><strong> Recovery Dues Till {{date('d-F-Y')}}</strong></h4>
                        </div>
                </div>

               
                </div>
                </div>
                </div>
                </div>
                </div>

                <!--./row-->



@permission('due-payments')



      <div class="row">

                    <div class="col-sm-12">
                        <div class="white-box">

                            <h3 class="box-title"> Due Amounts <a href="{{route('properties.due')}}" style="float: right;font-size: 12px"><u>View All</u></a></h3>


                            <div class="table-responsive">
                                <table id="myTable1" class="table table-bordered">
                                    <thead>
                                        <tr>
                                            <th>Sr No.</th>
                                            <th>Unit No.</th>
                                            <th>Member Name</th>
                                            <th>Dealer</th>
                                            <th>Net Amount</th>
                                            <th class="text-center">Received Amount</th>
                                            <th class="text-center">Due Amount</th>
                                            <th>Due Date</th>
                                            <th>Action</th>

                                            <th style="border-right: none;">Installments</th>


                                             
                                        </tr>
                                    </thead>
                                    <tbody>
                                                                                @permission('view-membership')
                                                                                @else
                                                                                @endpermission

                                        @foreach($due['properties'] as $statement)

                                      @if($due['dueAmt'][$statement->id] > 0)
                                          @if($due['color'][$statement->id] == 'red')
                                              <tr style="color:red;">
                                          @elseif($due['color'][$statement->id] == 'orange')
                                              <tr style="color:orange;">
                                          @else
                                              <tr style="color:black;">
                                                  @endif
                                            <td style="min-width: 10rem;">{{$count++}}</td>
                                            
                                            <td style="min-width: 13rem;">
                                            {{$statement->inventory ? $statement->inventory->unit_number : ''}}</td>

                                            
                                            

                                            <td style="min-width: 13rem;">{{$statement->customer ? $statement->customer->name: ''}}</td>
                                            <td style="min-width: 13rem;">
                                                @if($statement->dealer)
                                            {{$statement->dealer->name}}
                                        @endif</td>

                                            <td class="text-right" style="min-width: 13rem;">{{number_format($statement->net_pay)}} PKR
                                                                                            </td>


                                            <td class="text-right" style="min-width: 13rem;">{{number_format($due['receivedAmt'][$statement->id])}} PKR
                                                                                        </td>

                                             <td class="text-right" style="min-width: 13rem;">{{number_format($due['dueAmt'][$statement->id])}} PKR
                                                                                             </td>



                                            <td style="min-width: 13rem;">
                                                {{$due['dueDate'][$statement->id] ? date('d-m-Y', strtotime($due['dueDate'][$statement->id]->due_date)) : '' }}
                                             <br>
                                             @foreach($due['dueMonth'][$statement->id] as $s) 
                                             @if($loop->last)

                                             {{date('M', strtotime($s->due_date))}} 
                                             @else

                                             {{date('M', strtotime($s->due_date))}}  - 

                                             @endif 

                                             @endforeach

                                        </td>
                                     
                                        <td >
                                            @if($view_membership)
                                               <center> <a href="{{route('statement.detail',['id'=>$statement->id])}}" data-toggle="tooltip" data-original-title="View"> <i class="fa fa-eye text-inverse m-r-10"></i>&nbsp;&nbsp;</a></center>
                                            @endif
                                        </td>
                                                                                       
                                        @foreach($due['dueMonth'][$statement->id] as $key => $s) 
                              
                                        
                                            @if($s->payment_head == $payment_head[$j])

                                            @if($statement->customer->is_filer == 1)
                                                                                                @else
                                                                                             @endif

                                        <td class="printFV text-center id_{{$counter++}}"  data-amount="{{round($s->due+$tax_total )}}"  style="min-width: 13rem; ">

                                        @if($payment_head[$j] == \App\CustomerStatement::down_payment)
                                        Down Payment 
                                        @elseif($payment_head[$j] == \App\CustomerStatement::possession)
                                        Possession Fee 
                                        @elseif($payment_head[$j] == \App\CustomerStatement::installment)
                                        Installment - {{$s->inst_no}} 
                                        @elseif($payment_head[$j]  == \App\CustomerStatement::other)
                                        Other
                                        @endif 

                                        <br> {{number_format($s->due)}} 
                                        <hr>
                                        Tax
                                        <br>
                                        
                                        {{ number_format($tax_total) }}
                                        </td>
                                    
                                        @endif


                                        @endforeach

                                                                                           
                                        @foreach($due['dueMonth'][$statement->id] as $key => $s) 
                              
                                        
                                            @if($s->payment_head == $payment_head[$j])

                                            @if($statement->customer->is_filer == 1)
                                                                                                @else
                                                                                             @endif

                                        <td class="printFV text-center id_{{$counter++}}"  data-amount="{{round($s->due+$tax_total )}}"  style="min-width: 13rem; ">

                                        @if($payment_head[$j] == \App\CustomerStatement::down_payment)
                                        Down Payment 
                                        @elseif($payment_head[$j] == \App\CustomerStatement::possession)
                                        Possession Fee 
                                        @elseif($payment_head[$j] == \App\CustomerStatement::installment)
                                        Installment - {{$s->inst_no}} 
                                        @elseif($payment_head[$j]  == \App\CustomerStatement::other)
                                        Other
                                        @endif 

                                        <br> {{number_format($s->due)}} 
                                        <hr>
                                        Tax
                                        <br>
                                        
                                        {{ number_format($tax_total) }}
                                        </td>
                                    
                                        @endif


                                        @endforeach

                                                                                           
                                        @foreach($due['dueMonth'][$statement->id] as $key => $s) 
                              
                                        
                                            @if($s->payment_head == $payment_head[$j])

                                            @if($statement->customer->is_filer == 1)
                                                                                                @else
                                                                                             @endif

                                        <td class="printFV text-center id_{{$counter++}}"  data-amount="{{round($s->due+$tax_total )}}"  style="min-width: 13rem; ">

                                        @if($payment_head[$j] == \App\CustomerStatement::down_payment)
                                        Down Payment 
                                        @elseif($payment_head[$j] == \App\CustomerStatement::possession)
                                        Possession Fee 
                                        @elseif($payment_head[$j] == \App\CustomerStatement::installment)
                                        Installment - {{$s->inst_no}} 
                                        @elseif($payment_head[$j]  == \App\CustomerStatement::other)
                                        Other
                                        @endif 

                                        <br> {{number_format($s->due)}} 
                                        <hr>
                                        Tax
                                        <br>
                                        
                                        {{ number_format($tax_total) }}
                                        </td>
                                    
                                        @endif


                                        @endforeach

                                                                                           
                                        @foreach($due['dueMonth'][$statement->id] as $key => $s) 
                              
                                        
                                            @if($s->payment_head == $payment_head[$j])

                                            @if($statement->customer->is_filer == 1)
                                                                                                @else
                                                                                             @endif

                                        <td class="printFV text-center id_{{$counter++}}"  data-amount="{{round($s->due+$tax_total )}}"  style="min-width: 13rem; ">

                                        @if($payment_head[$j] == \App\CustomerStatement::down_payment)
                                        Down Payment 
                                        @elseif($payment_head[$j] == \App\CustomerStatement::possession)
                                        Possession Fee 
                                        @elseif($payment_head[$j] == \App\CustomerStatement::installment)
                                        Installment - {{$s->inst_no}} 
                                        @elseif($payment_head[$j]  == \App\CustomerStatement::other)
                                        Other
                                        @endif 

                                        <br> {{number_format($s->due)}} 
                                        <hr>
                                        Tax
                                        <br>
                                        
                                        {{ number_format($tax_total) }}
                                        </td>
                                    
                                        @endif


                                        @endforeach

                                            
                                      
                                        </tr>
                                       @endif

                                        @endforeach

                                        <tr>
                                            <td><strong>Total:</strong></td>
                                            <td></td>
                                            <td></td>
                                            <td></td>

                                            <td class="text-right">{{number_format($net_amount)}} PKR</td>
                                            <td class="text-right">{{number_format($receive_amount)}} PKR</td>
                                            <td class="text-right">{{number_format($due_amount)}} PKR</td>

                                            <td></td>
                                            <td></td>
                                          

                                            <td class="printFV text-center" id="grand_total_0"></td>

                                        </tr>

                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
@endpermission


                <!-- /row -->

               
             
            <!-- /.container-fluid -->

</div>
@stop

@section('js')
<script type="text/javascript" src="https://cdn.jsdelivr.net/momentjs/latest/moment.min.js"></script>
<script type="text/javascript" src="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.min.js"></script>


<script src="{{asset('plugins/components/chartist-js/dist/chartist.min.js')}}"></script>
<script src="{{asset('plugins/components/chartist-plugin-tooltip-master/dist/chartist-plugin-tooltip.min.js')}}"></script>
<script src="{{asset('plugins/components/knob/jquery.knob.js')}}"></script>
<script src="{{asset('plugins/components/custom-chart/chart.js')}}"></script>
<script src="{{asset('js/db3.js')}}"></script>
 <script src="https://cdn.datatables.net/buttons/1.7.0/js/dataTables.buttons.min.js"></script>
 <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
 <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
 <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
 <script src="https://cdn.datatables.net/buttons/1.7.0/js/buttons.html5.min.js"></script>
  <script src="https://cdn.datatables.net/buttons/1.7.0/js/buttons.print.min.js"></script>
<script>


    $( function() {

    var substr = '{{$remain_td}}';

    for(var i=0; i<= substr; i++) 
    {
        var total = 0

        $( ".id_"+i ).each(function() 
        {
            var amount = parseFloat($( this ).data( "amount" ));
            total += amount;
        });

       $('#grand_total_'+i).html(addCommas(total)+ ' PKR')
    }


    $( "#daterange-btn" ).datepicker();

  } );


    $(function() {
        $('#myTable1').DataTable({
            'pageLength':25,
            'paging':false,
            'info':false,
            'searching':false,
             'ordering':false,
            'sorting':false,
             dom: 'Bfrtip',
        buttons: [
             'copy', 'csv', 'excel', 'print',
             {
            extend : 'pdfHtml5',
            title : function() {
                return "{{env('APP_NAME')}}\nRecovery Dues Till {{date('d-F-Y')}}";
            },
            orientation : 'landscape',
            pageSize : 'A0', // You can also use "A1","A2" or "A3", most of the time "A3" works the best.
            text : '<i class=""> PDF</i>',
            titleAttr : 'PDF'
        }
        ]
        });
        });


function addCommas(nStr)
{
    nStr += '';
    x = nStr.split('.');
    x1 = x[0];
    x2 = x.length > 1 ? '.' + x[1] : '';
    var rgx = /(\d+)(\d{3})/;
    while (rgx.test(x1)) {
        x1 = x1.replace(rgx, '$1' + ',' + '$2');
    }
    return x1 + x2;
}

    // $('#daterange-btn').daterangepicker(
    //     {
          

    //         ranges: {
    //             'Today': [moment(), moment()],
    //             'Last 7 Days': [moment().subtract(6, 'days'), moment()],
    //             'This Month': [moment().startOf('month'), moment().endOf('month')],
    //             'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')],
    //             'This Year': [moment().startOf('year'), moment().endOf('year')],
    //             'Last Year': [moment().subtract(1, 'year').startOf('year'), moment().subtract(1, 'year').endOf('year')]
    //             },
    //             startDate: moment().subtract(29, 'days'),
    //             endDate: moment()
    //       },
        
    //     );


            $('.search-customer').on('click',function(){
            $('.preloader').fadeIn();
            unit = $('#unit').val();
            
            customer = $('#customer').val();
            dealer = $('#dealer').val();
            status = $('#status').val();

            if(unit == 0 && customer== 0 && status == 0 && dealer == 0) {
                toastr.warning("please select any option.");
				 $('.preloader').fadeOut();
                return false;
            }

            var data = {'unit':unit,'customer':customer,'dealer':dealer,'status':status};
            $.get('/statement/updateTable',data,function(data){
                document.getElementById('update-table').innerHTML = data;

                $('#myTable').DataTable({
                    'pageLength':50,
                    'paging':false,
                    'searching':false,
                    'info':true
                });
                toastr.success("Search updated.");

                
                $('.preloader').fadeOut();
            });
        });
</script>
@stop