@extends('layouts.app')


@section('title')
    Recovery Due
@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">
        @can('isSuperAdmin')
            @include('partial.multiproject_select')
        @endcan
        <br>
        @php
            $remain_td = 0;
        @endphp

        <div id='updatecontent'>
            <!--.row-->
            <div class="row no-print" style="margin-bottom: 1rem; margin-top: 53px;">
                <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>
                                            @foreach($project_names as $key => $project_name)
                                            {{ $project_name }}
                                            @if($key < count($project_names) - 1)
                                                , 
                                            @endif
                                        @endforeach
                                        
                                        </strong></h2>

                                        <h4><strong> Recovery Dues Till {{ date('d/m/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>Project.</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

                                         
                                        @if (isset($properties))
                                            @foreach ($properties as $statement)
                                            
                                                @if ($dueAmt[$statement->id] > 0)
                                                    @if ($color[$statement->id] == 'red')
                                                        <tr style="color:red;">
                                                        @elseif($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: 10rem;">{{ $statement->multiProject?$statement->multiProject->name:'None' }}</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($receivedAmt[$statement->id]) }} PKR
                                                                                                            </td>
                                                    <td class="text-right" style="min-width: 13rem;">
                                                        {{ number_format($dueAmt[$statement->id]) }} PKR
                                                                                                            </td>
                                                    <td style="min-width: 13rem;">
                                                        {{ $dueDate[$statement->id] ? date('d/m/Y', strtotime($dueDate[$statement->id]->due_date)) : '' }}
                                                        <br>
                                                        @foreach ($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 ($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 ($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 ($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 ($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
                                        @else
                                            <td>Null</td>
                                        @endif

                                        <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

        </div>
        <!-- /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 callItBack() {
            $(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;
            }
            $('.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();
                });
            });
        }


        // $('#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()
        //       },

        //     );



        callItBack();

        function updateStatus(value) {
            $('.preloader').fadeIn();

            if (value === 'search') {

                $('.preloader').fadeOut();
                return false;
            }
            var data = {
                'multipro_id': value,
            };
            $.get('{{ route('recovery.due') }}', data, function(data) {
                $('.preloader').fadeOut();
                $('#myTable tbody').empty();



                document.getElementById('updatecontent').innerHTML = data;
                callItBack();
                toastr.success("Search updated.");


                $('.preloader').fadeOut();
            });

        }
    </script>
@stop