@extends('layouts.app')
@section('title', 'Flood Report')
@section('content')
    <div class="container-fluid">
        <div class="row px-3">
            <div class="col-md-12">
                <div class="card">
                    <div class="card-body">
                        <div class="row" style="justify-content:end;">
                            <div class="col-md-2 p-0 reports_date_filter_section">
                                <input required type="text" id="reports_date_filter" name="reports_date_filter"
                                    class="form-control datepick reports_date_filter" value=""
                                    onkeydown="return false">
                            </div>
                            <div class="col-md-2 pe-0 vendor_section">
                                <select class="form-select reports_vendor_id" name="reports_vendor_id"
                                    id="reports_vendor_id">
                                    <option value="0" selected> Select Vendor </option>
                                                                    </select>
                            </div>
                            <div class="col-md-2 pe-0 lender_section">
                                <select class="form-select reports_lender_id" name="reports_lender_id"
                                    id="reports_lender_id">
                                                                        <option value="">Select Vendor First</option>
                                                                    </select>
                            </div>
                        </div>
                        <div class="row">
                            <table id="flood_report_table" class="table table-bordered nowrap table-striped"
                                style="border-collapse: collapse; border-spacing: 0; width: 100%;">
                                <thead>
                                    <tr>
                                        <th> SI.No. </th>
                                        <th> Service Order ID</th>
                                        <th> Property </th>
                                        <th> Service Type </th>
                                        <th> Document </th>
                                        <th> Flood Hazard Area </th>
                                        <th> State </th>
                                        <th> County </th>
                                        <th> NFIP Community Number </th>
                                        <th> NFIP Community Name </th>
                                        <th> Case No </th>
                                        <th> Date </th>
                                        <th> NFIP Map Panel </th>
                                        <th> No NFIP Map </th>
                                        <th> NFIP Map Number </th>
                                        <th> Flood Zone </th>
                                        <th> Map Change(LOMC) </th>
                                        <th> Regular Program </th>
                                        <th> Designation Date </th>
                                        <th> Emergency Program </th>
                                        <th> Insurance Available </th>
                                        <th> Flood Insurance </th>
                                        <th> Insurance Not Available </th>
                                        <th> Loan Amount </th>
                                        <th> Lender/Servicer ID </th>
                                        <th> Lender/Servicer Name </th>
                                        <th> Lender/Servicer Address </th>
                                        <th> Collateral Description </th>
                                        <th> Loan Identifier </th>
                                        <th> Preparer's Name </th>
                                        <th> Preparer's Contact </th>
                                        <th> Preparer's Address </th>
                                        <th> Preparer's Date of Determination </th>
                                        <th> Added Datetime</th>
                                        <th> Completed Date </th>
                                    </tr>
                                </thead>
                                <tbody>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

@endsection

@section('page_css')
    <link href="{{ asset('/plugins/daterangepicker/daterangepicker.css') }}" rel="stylesheet" type="text/css" />
    <style>
        .dataTables_info {
            margin-top: 5px !important;
        }

        div.dt-buttons {
            float: right;
        }

        .show-ranges {
            top: 107.6px !important;
            /* margin-top: -45px !important; */
        }
    </style>
@endsection

@section('page_script')
    <script src="{{ asset('/plugins/moment/moment.js') }}"></script>
    <script src="{{ asset('/plugins/daterangepicker/daterangepicker.js') }}"></script>
    <script>
        var vendorpaymentstatusTbl = '';
        $(document).ready(function() {
            function flood_report_data() {
                if ($.fn.dataTable.isDataTable('#flood_report_table') && vendorpaymentstatusTbl != '') {
                    vendorpaymentstatusTbl.draw(false);
                } else {
                    load_flood_report_data();
                }
            }

            function load_flood_report_data() {
                vendorpaymentstatusTbl = $('#flood_report_table').DataTable({
                    scrollX: true,
                    "order": [],
                    "processing": true,
                    "serverSide": true,
                    "ajax": {
                        url: "{{ url('/fetch-floodreport') }}",
                        method: "POST",
                        data: {
                            _token: '{!! csrf_token() !!}',
                        },
                        dataSrc: function(json) {
                            if (json.floodRptCount > 0) {
                                $('.floodRpt').attr('disabled', false);
                            } else {
                                $('.floodRpt').attr('disabled', true);
                            }
                            return json.data;
                        },
                    },
                    columns: [{
                            data: 'id',
                            render: function(data, type, row, meta) {
                                return meta.row + meta.settings._iDisplayStart + 1;
                            }
                        },
                        {
                            data: 'service_order_id',
                            name: 'service_order_id',
                            defaultContent: "--"
                        },
                        {
                            data: 'address',
                            name: 'address',
                            defaultContent: '--',
                        },
                        {
                            data: 'vendor_services_data.vendor_service_name',
                            name: 'vendor_services_data.vendor_service_name',
                            defaultContent: "--"
                        },
                        {
                            data: 'document',
                            name: 'document',
                            defaultContent: '--',
                        },
                        {
                            data: 'flood_hazard_area',
                            name: 'flood_hazard_area',
                            defaultContent: "--"
                        },
                        {
                            data: 'state',
                            name: 'state',
                            defaultContent: "--"
                        },
                        {
                            data: 'county',
                            name: 'county',
                            defaultContent: "--"
                        },
                        {
                            data: 'community',
                            name: 'community',
                            defaultContent: "--"
                        },
                        {
                            data: 'community_name',
                            name: 'community_name',
                            defaultContent: "--"
                        },
                        {
                            data: 'case_no',
                            name: 'case_no',
                            defaultContent: "--"
                        },
                        {
                            data: 'date',
                            name: 'date',
                            defaultContent: "--"
                        },
                        {
                            data: 'map_panel',
                            name: 'map_panel',
                            defaultContent: "--"
                        },
                        {
                            data: 'map',
                            name: 'map',
                            defaultContent: "--"
                        },
                        {
                            data: 'map_num',
                            name: 'map_num',
                            defaultContent: "--"
                        },
                        {
                            data: 'zone',
                            name: 'zone',
                            defaultContent: "--"
                        },
                        {
                            data: 'map_change',
                            name: 'map_change',
                            defaultContent: "--"
                        },
                        {
                            data: 'regular_program',
                            name: 'regular_program',
                            defaultContent: "--"
                        },
                        {
                            data: 'designation_date',
                            name: 'designation_date',
                            defaultContent: "--"
                        },
                        {
                            data: 'emergency_program',
                            name: 'emergency_program',
                            defaultContent: "--"
                        },
                        {
                            data: 'insurance_available',
                            name: 'insurance_available',
                            defaultContent: "--"
                        },
                        {
                            data: 'federal_flood_insurance',
                            name: 'federal_flood_insurance',
                            defaultContent: "--"
                        },
                        {
                            data: 'insurance_not_available',
                            name: 'insurance_not_available',
                            defaultContent: "--"
                        },
                        {
                            data: 'amount_of_flood_insurance',
                            name: 'amount_of_flood_insurance',
                            defaultContent: "--"
                        },
                        {
                            data: 'lender_id',
                            name: 'lender_id',
                            defaultContent: "--"
                        },
                        {
                            data: 'lender_name',
                            name: 'lender_name',
                            defaultContent: "--"
                        },
                        {
                            data: 'lender_address',
                            name: 'lender_address',
                            defaultContent: "--"
                        },
                        {
                            data: 'collateral_desc',
                            name: 'collateral_desc',
                            defaultContent: "--"
                        },
                        {
                            data: 'loan_identifier',
                            name: 'loan_identifier',
                            defaultContent: "--"
                        },
                        {
                            data: 'name',
                            name: 'name',
                            defaultContent: "--"
                        },
                        {
                            data: 'number',
                            name: 'number',
                            defaultContent: "--"
                        },
                        {
                            data: 'street_address',
                            name: 'street_address',
                            defaultContent: "--"
                        },
                        {
                            data: 'date_of_determination',
                            name: 'date_of_determination',
                            defaultContent: "--"
                        },
                        {
                            data: 'created_at',
                            name: 'created_at',
                            defaultContent: "--"
                        },
                        {
                            data: 'updated_at',
                            name: 'updated_at',
                            defaultContent: "--"
                        },
                    ],
                    dom: '<"mt-2"<"row"<"col-md-6"l><"col-md-6"<B><"float-end"f>>><"mb-1"<t>><"row"<"col"i><"col"p>>>',
                    buttons: [{
                        text: '<em class="mdi mdi-file-excel"></em> Export',
                        className: 'reportsbtn btn-color btn-sm ms-1 floodRpt',
                        attr: {
                            disabled: true,
                        },
                        action: function(e, dt, node, config) {
                            download_flood_report_report();
                        }
                    }],
                });
            }

            load_flood_report_data();

            $('.datepick').daterangepicker({
                singleDatePicker: false,
                showDropdowns: true,
                startDate: moment().subtract(1, 'weeks').startOf('isoWeek'),
                endDate: moment().subtract(1, 'weeks').endOf('isoWeek'),
                ranges: {
                    'Last Week': [moment().subtract(1, 'weeks').startOf('isoWeek'), moment().subtract(1,
                        'weeks').endOf('isoWeek')],
                    'Current Week': [moment().startOf('isoWeek'), moment()],
                    'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1,
                        'month').endOf('month')], // Working Fine
                    'Current Month': [moment().startOf('month'), moment().endOf('month')], // Working Fine
                    'Yearly': [moment().startOf('year'), moment().endOf('year')],
                }
            });

            $('.reports_date_filter').on('change', function(e) {
                $('.multiSelectButton').addClass('d-none');
                $('.selectedCount').text('');
                $('.selectedCount').addClass('d-none');
                $('#check_all').prop('checked', false);
                $('.order_check').prop('checked', false);
                var value = $(this).val();
                e.preventDefault();
                $.ajax({
                    url: '/sessionReportsDateRange/',
                    type: "GET",
                    data: {
                        "_token": "{{ csrf_token() }}",
                        "timeframe": value
                    },
                    success: function(response) {
                        flood_report_data();
                    }
                });
            });

            $('.reports_vendor_id').on('change', function() {
                $('.multiSelectButton').addClass('d-none');
                $('.selectedCount').text('');
                $('.selectedCount').addClass('d-none');
                $('#check_all').prop('checked', false);
                $('.order_check').prop('checked', false);
                $('.reports_lender_id').empty();
                var vendorLenderID = $(this).val();
                if (vendorLenderID) {
                    $.ajax({
                        url: '/vendor/lendername/' + vendorLenderID,
                        type: "GET",
                        dataType: "json",
                        success: function(data) {
                            $('.reports_lender_id').empty();
                            if (data[0] == undefined) {
                                $('.reports_lender_id').html(
                                    '<option value="0">Select Vendor first</option>');
                                $.ajax({
                                    url: '/sessionInvoiceVendorId/',
                                    type: "GET",
                                    data: {
                                        "_token": "{{ csrf_token() }}",
                                        "vendorId": vendorLenderID
                                    },
                                    success: function(response) {
                                        flood_report_data();
                                    }
                                });
                            } else {
                                if (data[0].length == 0) {
                                    $('.reports_lender_id').append(
                                        '<option value="0">Lender Unavailable</option>');
                                } else {
                                    $('.reports_lender_id').append(
                                        '<option value="0" selected>Select Lender</option>');
                                    $.each(data[0], function(key, value) {
                                        $('.reports_lender_id').append(
                                            '<option value="' + value['id'] + '">' +
                                            value[
                                                'lender_name'] + '</option>');
                                    });
                                }
                                $.ajax({
                                    url: '/sessionInvoiceVendorId/',
                                    type: "GET",
                                    data: {
                                        "_token": "{{ csrf_token() }}",
                                        "vendorId": vendorLenderID
                                    },
                                    success: function(response) {
                                        flood_report_data();
                                    }
                                });
                            }
                        }
                    });
                } else {
                    $('.reports_lender_id').html('<option value="0">Select Vendor first</option>');
                }
            });

            $('select.reports_lender_id').on('change', function(e) {
                $('.multiSelectButton').addClass('d-none');
                $('.selectedCount').text('');
                $('.selectedCount').addClass('d-none');
                $('#check_all').prop('checked', false);
                $('.order_check').prop('checked', false);
                var value = $(this).val();
                e.preventDefault();
                $.ajax({
                    url: '/sessionInvoiceLenderId/',
                    type: "GET",
                    data: {
                        "_token": "{{ csrf_token() }}",
                        "lenderId": value
                    },
                    success: function(response) {
                        if (value == 0) {
                            flood_report_data();
                        } else {
                            flood_report_data();
                        }
                    }
                });
            });

            $('#flood_report_table_paginate').on('click', function() {
                $('.multiSelectButton').addClass('d-none');
                $('.selectedCount').text('');
                $('.selectedCount').addClass('d-none');
                $('#check_all').prop('checked', false);
                $('.order_check').prop('checked', false);
            });

            $('select[name=flood_report_table_length]').on('change', function() {
                $('.multiSelectButton').addClass('d-none');
                $('.selectedCount').text('');
                $('.selectedCount').addClass('d-none');
                $('#check_all').prop('checked', false);
                $('.order_check').prop('checked', false);
            });
        });

        function togglebutton(serviceOrderId) {
            var checkboxData = new Array();
            $("input[class='order_check checked']:checked").each(function() {
                checkboxData.push($(this).val());
            });
            var checkboxLength = checkboxData.length;
            if (checkboxLength >= 1) {
                $('.multiSelectButton').removeClass('d-none');
                $('.selectedCount').removeClass('d-none');
                $('.selectedCount').text(checkboxLength);
            } else if (checkboxLength == 0) {
                $('.multiSelectButton').addClass('d-none');
                $('.selectedCount').addClass('d-none');
            }
        }

        function download_flood_report_report() {
            $('.multiSelectButton').addClass('d-none');
            $('.selectedCount').text('');
            $('.selectedCount').addClass('d-none');
            $('#check_all').prop('checked', false);
            $('.order_check').prop('checked', false);

            event.preventDefault();
            var loader = $('#ajaxloader');
            $('.loader_text').text('Generating Flood Report...');
            loader.show();
            setTimeout(function() {
                $.ajax({
                    url: "/flood_internal_report_generate",
                    type: "POST",
                    data: {
                        _token: '{!! csrf_token() !!}',
                    },
                    success: function(response) {
                        loader.hide();
                        var result = response.split('@#!');
                        if (result[1] == 'warning') {
                            Swal.fire({
                                position: 'middle',
                                icon: result[1],
                                title: result[2],
                                showConfirmButton: false,
                                timer: 1000
                            });
                        } else {
                            window.location = "flood_internal_generate_report";
                        }

                    }
                });
            }, 1000);
        }
    </script>
@endsection