@extends('owner.layouts.app')

@section('content')
<style>
    .hide-datatable {
    display: none;
}
.toggle-button{
    width:100%;
}


/* Style the tab */
.report_tab {
  overflow: hidden;
  border: 1px solid #ccc;
  background-color: #f1f1f1;
}

/* Style the buttons inside the tab */
.report_tab button {
  background-color: inherit;
  float: left;
  border: none;
  outline: none;
  cursor: pointer;
  padding: 14px 16px;
  transition: 0.3s;
  font-size: 17px;
  text-align:center;
}

/* Change background color of buttons on hover */
.report_tab button:hover {
  background-color: #ddd;
}

/* Create an active/current tablink class */
.report_tab button.active {
  background-color: #ccc;
}

/* Style the tab content */
.report_tabcontent {
  display: none;
  padding: 6px 12px;
  
}
</style>
    <div class="main-content">
        <div class="page-content">
            <div class="container-fluid">
                <div class="page-content-wrapper bg-white p-30 radius-20">
                    <div class="row">
                        <div class="col-12">
                            <div
                                class="page-title-box d-sm-flex align-items-center justify-content-between border-bottom mb-20">
                                <div class="page-title-left">
                                    <h3 class="mb-sm-0">{{ $pageTitle }}</h3>
                                </div>
                                <div class="page-title-right">
                                    <ol class="breadcrumb mb-0">
                                        <li class="breadcrumb-item"><a href="{{ route('owner.dashboard') }}"
                                                title="Dashboard">{{ __('Dashboard') }}</a></li>
                                        <li class="breadcrumb-item" aria-current="page">{{ __('Report') }}</li>
                                        <li class="breadcrumb-item active" aria-current="page">{{ $pageTitle }}</li>
                                    </ol>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="row">
                        <div class="tenants-top-bar">
                            <div class="property-search-inner-bg bg-off-white theme-border radius-4 p-25 pb-0 mb-25">
                                <form action="">
                                    <div class="row">
                                        
                                        <div class="col-md-3 mb-25">
                                            <label class="label-text-title color-heading font-medium mb-2">{{ __('Month') }}</label>
                                            <select class="form-select flex-shrink-0" name="month" id="month">
                                                <option value="" selected>--{{ __('Select Month') }}--</option>
                                                @foreach($months as $month)
                                                    <option value="{{$month}}">{{ date('F', strtotime('2023-' . $month . '-01')) }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                        <div class="col-md-3 mb-25">
                                            <label class="label-text-title color-heading font-medium mb-2">{{ __('Year') }}</label>
                                            <select class="form-select flex-shrink-0" name="year" id="year">
                                                <option value="" selected>--{{ __('Select Year') }}--</option>
                                                @foreach($years as $year)
                                                    <option value="{{$year}}">{{$year}}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                        
                                        <div class="col-auto mb-25">
                                            <button type="button" class="theme-btn w-auto"
                                                id="searchBtn" title="{{ __('Search') }}">{{ __('Search') }}</button>
                                            <a  href="{{ route('owner.reports.allReport') }}" class="default-btn theme-btn-purple w-auto"
                                                 title="{{ __('Search') }}">{{ __('Reset') }}</a>
                                                 
                                        </div>
                                    </div>
                                </form>
                                <button id="download-pdf" class="theme-btn w-auto mb-25">Download All PDF</button>
                                <button id="download-excel" class="theme-btn w-auto mb-25">Download All Excel</button>
                            </div>
                        </div>
                         
                        <div class="report_tab">
                            <button class="report_tablinks" onclick="openReport(event, 'earningReportDataTableRow')">Earning Report</button>
                            <button class="report_tablinks" onclick="openReport(event, 'lossProfitReportDataTableRow')">Loss / Profit Report</button>
                            <button class="report_tablinks" onclick="openReport(event, 'expenseReportDataTableRow')">Expense Report</button>
                            <button class="report_tablinks" onclick="openReport(event, 'occupancyReportDataTableRow')">Occupancy Report</button>
                            <button class="report_tablinks" onclick="openReport(event, 'maintenanceReportDataTableRow')">Maintenance Report</button>
                            <button class="report_tablinks" onclick="openReport(event, 'tenantReportDataTableRow')">Tenant Report</button>
                        </div>
                        
                        <div class="row  mb-25 report_tabcontent" id="earningReportDataTableRow">
                            <div class="notice-board-table-area">
                                
                                <div class="table-responsive bg-off-white theme-border radius-4 p-25">
                                    <h4>Earning Report</h4>
                                    <table id="earningReportDataTable" class="table bg-off-white aaa theme-border p-20 dt-responsive">
                                        <thead>
                                            <tr>
                                                <th>{{ __('SL') }}</th>
                                                <th class="text-center">{{ __('Invoice') }}</th>
                                                <th class="text-center">{{ __('Property') }}</th>
                                                <th class="text-center">{{ __('Unit') }}</th>
                                                <th class="text-center">{{ __('Date') }}</th>
                                                <th class="text-center">{{ __('Amount Due') }}</th>
                                                <th class="text-end">{{ __('Amount') }}</th>
                                            </tr>
                                        </thead>
                                        <tfoot>
                                            <tr>
                                                <th colspan="5"></th>
                                                <th></th>
                                                <th></th>
                                            </tr>
                                        </tfoot>
                                    </table>
                                </div>
                            </div>
                        </div>
                        
                        <div class="row  mb-25 report_tabcontent" id="lossProfitReportDataTableRow">
                            
                            <div class="notice-board-table-area">
                                <div class="table-responsive bg-off-white theme-border radius-4 p-25">
                                    <h4>Loss / Profit By Month Report</h4>
                                    <table id="lossProfitReportDataTable"
                                        class="table bg-off-white aaa theme-border p-20 dt-responsive">
                                        <thead>
                                            <tr>
                                                <th>{{ __('SL') }}</th>
                                                <th class="text-center">{{ __('Month') }}</th>
                                                <th class="text-center">{{ __('Income') }}</th>
                                                <th class="text-center">{{ __('Expense') }}</th>
                                                <th class="text-center">{{ __('Profit / Loss') }}</th>
                                                
                                            </tr>
                                        </thead>
                                    </table>
                                </div>
                            </div>
                        </div>
                        
                        <div class="row  mb-25 report_tabcontent" id="expenseReportDataTableRow">
                            <div class="notice-board-table-area">
                                <div class="table-responsive bg-off-white theme-border radius-4 p-25">
                                    <h4>Expenses Report</h4>
                                    <table id="expenseReportDataTable" class="table bg-off-white aaa theme-border p-20 dt-responsive">
                                        <thead>
                                            <tr>
                                                <th>{{ __('SL') }}</th>
                                                <th class="text-center">{{ __('Name') }}</th>
                                                <th class="text-center">{{ __('Property') }}</th>
                                                <th class="text-center">{{ __('Unit') }}</th>
                                                <th class="text-center">{{ __('Date') }}</th>
                                                <th class="text-end">{{ __('Amount') }}</th>
                                            </tr>
                                        </thead>
                                        <tfoot>
                                            <tr>
                                                <th colspan="4"></th>
                                                <th></th>
                                                <th></th>
                                            </tr>
                                        </tfoot>
                                    </table>
                                </div>
                            </div>
                        </div>
                        
                        <div class="row  mb-25 report_tabcontent" id="occupancyReportDataTableRow">
                            <div class="notice-board-table-area">
                                <div class="table-responsive bg-off-white theme-border radius-4 p-25">
                                    <h4>Occupancy</h4>
                                    <table id="occupancyReportDataTable"
                                        class="table bg-off-white aaa theme-border p-20 dt-responsive">
                                        <thead>
                                            <tr>
                                                <th>{{ __('SL') }}</th>
                                                <th class="text-center">{{ __('Property Name') }}</th>
                                                <th class="text-center">{{ __('Address') }}</th>
                                                <th class="text-center">{{ __('Total Unit') }}</th>
                                                <th class="text-end">{{ __('Available Unit') }}</th>
                                                {{-- <th class="text-end">{{ __('Turnover Rate') }}</th> --}}
                                            </tr>
                                        </thead>
                                    </table>
                                </div>
                            </div>
                        </div>
                        
                        <div class="row  mb-25 report_tabcontent" id="maintenanceReportDataTableRow">
                            <div class="notice-board-table-area">
                                <div class="table-responsive bg-off-white theme-border radius-4 p-25">
                                    <h4>Maintenance</h4>
                                    <table id="maintenanceReportDataTable"
                                        class="table bg-off-white aaa theme-border p-20 dt-responsive">
                                        <thead>
                                            <tr>
                                                <th>{{ __('SL') }}</th>
                                                <th class="text-center">{{ __('Property Name') }}</th>
                                                <th class="text-center">{{ __('Unit') }}</th>
                                                <th class="text-center">{{ __('Tenant Name') }}</th>
                                                <th class="text-center">{{ __('Issue') }}</th>
                                                <th class="text-center">{{ __('Status') }}</th>
                                            </tr>
                                        </thead>
                                    </table>
                                </div>
                            </div>
                        </div>
                           
                        <div class="row  mb-25 report_tabcontent" id="tenantReportDataTableRow">
                            <div class="notice-board-table-area">
                                
                                <div class="table-responsive bg-off-white theme-border radius-4 p-25">
                                    <h4>Tenant</h4>
                                    <table id="tenantReportDataTable"
                                        class="table bg-off-white aaa theme-border p-20 dt-responsive ">
                                        <thead>
                                            <tr>
                                                <th>{{ __('SL') }}</th>
                                                <th class="text-center">{{ __('Name') }}</th>
                                                <th class="text-center">{{ __('Unit') }}</th>
                                                <th class="text-center">{{ __('Contact') }}</th>
                                                <th class="text-center">{{ __('Property') }}</th>
                                                <th class="text-center">{{ __('Unit') }}</th>
                                                <th class="text-end">{{ __('Paid') }}</th>
                                                <th class="text-end">{{ __('Due') }}</th>
                                                <th class="text-center">{{ __('Status') }}</th>
                                            </tr>
                                        </thead>
                                    </table>
                                </div>
                            </div>
                        </div>
                            
                        
                    </div>
                </div>
            </div>
        </div>
    </div>
    <input type="hidden" id="allReportRoute" value="{{ route('owner.reports.allReport') }}">
    
@endsection
@push('style')
    @include('common.layouts.datatable-style')
@endpush
@push('script')
    @include('common.layouts.datatable-script')
    

    

    <!--<script src="{{ asset('assets/js/custom/report-tenant.js') }}"></script>-->
    <script>
    function openReport(evt, reportName) {
      var i, report_tabcontent, report_tablinks;
      report_tabcontent = document.getElementsByClassName("report_tabcontent");
      for (i = 0; i < report_tabcontent.length; i++) {
        report_tabcontent[i].style.display = "none";
      }
      report_tablinks = document.getElementsByClassName("report_tablinks");
      for (i = 0; i < report_tablinks.length; i++) {
        report_tablinks[i].className = report_tablinks[i].className.replace(" active", "");
      }
      document.getElementById(reportName).style.display = "block";
      evt.currentTarget.className += " active";
    }
    
    
    var monthValue = '';
    var yearValue = '';
    
    // Default values for month and year
    var defaultMonth = 'All Months';
    var defaultYear = 'All Years';
    
    // file names
    var fileNameTenant = 'Tenant Report (All Time)';
    var fileNameEarning = 'Earning Report (All Time)';
    var fileNameExpense = 'Expense Report (All Time)';
    var fileNameOccupancy = 'Occupancy Report (All Time)';
    var fileNameMaintenance = 'Maintenance Report (All Time)';
    var fileNameLossProfit = 'Loss / Profit Report (All Time)';
    
    
    $(document).on('click', '#searchBtn', function () {
        
        var url_earning = $('#allReportRoute').val() + '?reportType=earning&start_date=&end_date=&due_start_date=&due_end_date=&month=' + $('#month').val() + '&year=' + $('#year').val()
        + '&due_month=&due_year=&property_id=&unit_id=&status=';
        
        var url_lossProfit = $('#allReportRoute').val() + '?reportType=lossProfit&month=' + $('#month').val() + '&year=' + $('#year').val();
        
        var url_expense = $('#allReportRoute').val() + '?reportType=expense&start_date=&end_date=&property_id=&unit_id=&month=' + $('#month').val() + '&year=' + $('#year').val();
        
        var url_occupancy = $('#allReportRoute').val() + '?reportType=occupancy';
        
        var url_maintenance = $('#allReportRoute').val() + '?reportType=maintenance&start_date=&end_date=&property_id=&unit_id=&month=' + $('#month').val() + '&year=' + $('#year').val();
        
        dt_earning.ajax.url(url_earning).load();
        dt_lossProfit.ajax.url(url_lossProfit).load();
        dt_expense.ajax.url(url_expense).load();
        dt_occupancy.ajax.url(url_occupancy).load();
        dt_maintenance.ajax.url(url_maintenance).load();
        //dt_tenant.ajax.url(url_tenant).load();
        
         monthValue = $('#month').val();
         yearValue = $('#year').val();
         
         const numericMonth = parseInt(monthValue, 10);

        // Create the Date object
        const dateObject = new Date(2023, numericMonth - 1, 1);
        
        // Check if the dateObject is a valid date
        const monthName = dateObject.toString() === 'Invalid Date' ? null : dateObject.toLocaleString('en-US', { month: 'long' });

        
        // Construct file names based on input values
         fileNameTenant = (monthName || yearValue) ?
            'Tenant Report ( for ' + (monthName || defaultMonth) + ' in ' + (yearValue || defaultYear) + ' )' :
            'Tenant Report (All Time)';
        
         fileNameEarning = (monthName || yearValue) ?
            'Earning Report ( for ' + (monthName || defaultMonth) + ' in ' + (yearValue || defaultYear) + ' )' :
            'Earning Report (All Time)';
            
         fileNameExpense = (monthName || yearValue) ?
            'Expense Report ( for ' + (monthName || defaultMonth) + ' in ' + (yearValue || defaultYear) + ' )' :
            'Expense Report (All Time)';
            
         fileNameOccupancy = 'Occupancy Report (All Time)';
        
         fileNameMaintenance = (monthName || yearValue) ?
            'Maintenance Report ( for ' + (monthName || defaultMonth) + ' in ' + (yearValue || defaultYear) + ' )' :
            'Maintenance Report (All Time)';
            
            
        
         fileNameLossProfit = (monthName || yearValue) ?
            'Loss / Profit Report ( for ' + (monthName || defaultMonth) + ' in ' + (yearValue || defaultYear) + ' )' :
            'Loss / Profit Report (All Time)';
        
        
        
        
    });
    
    
    
    
    
    /*=============================== earning datatable part ==============================*/
    var dt_earning = $('#earningReportDataTable').DataTable({
        
        processing: true,
        serverSide: true,
        responsive: true,
        ajax: $('#allReportRoute').val() + '?reportType=earning&start_date=&end_date=&due_start_date=&due_end_date=&month=&year=&due_month=&due_year=&property_id=&unit_id=&status=',
        order: [1, 'desc'],
        ordering: false,
        autoWidth: false,
        pageLength: -1,
        lengthMenu: [
            [10, 25, 50, 100, -1],
            [10, 25, 50, 100, 'All'],
        ],
        drawCallback: function () {
            $(".dataTables_length select").addClass("form-select form-select-sm");
        },
        language: {
            'paginate': {
                'previous': '<span class="iconify" data-icon="icons8:angle-left"></span>',
                'next': '<span class="iconify" data-icon="icons8:angle-right"></span>'
            }
        },
        dom: '<"row"<"col-sm-4"l><"col-sm-4"B><"col-sm-4"f>>tr<"bottom"<"row"<"col-sm-6"i><"col-sm-6"p>>><"clear">',
        buttons: [
            {
                extend: 'excel',
                className: 'theme-btn theme-button1 default-hover-btn',
                text: 'Excel',
                filename: function () {
                    return fileNameEarning;
                },
                title: function () {
                    return fileNameEarning;
                },
            },
        {
            extend: 'pdf',
            className: 'theme-btn theme-button1 default-hover-btn',
            text: 'PDF',
            title: function () {
                return fileNameEarning;
            },
            customize: function (doc) {
                doc.content[0].text = fileNameEarning; 
            }
        },
        {
            extend: 'copy',
            className: 'theme-btn theme-button1 default-hover-btn'
            
        }
        ],
        columnDefs: [
            { className: "text-center", targets: [1, 2, 3, 4, 5] },
            { className: "text-end", targets: [6] }
        ],
        footerCallback: function (row, data, start, end, display) {
            var api = this.api();
            // Remove the formatting to get integer data for summation
            var intVal = function (num) {
                var val = 0;
                if (!!num[0].trim() && !isNaN(+num[0])) {
                    val = num.split(' ')[0];
                } else {
                    val = num.split(' ')[1];
                }
                return Number(val.replace(',', ''));
            };
            
            var totalPaidPerPage = 0.00;
            var totalDue = 0.00;
            var totalOverduePerPage = 0.00;
            var totalTaxPerPage = 0.00;
            var totalDuePerPage = 0.00;
            var totalPerPage = 0.00;
            
            for (var i = 0; i < data.length; i++) {
                
                totalDue += parseFloat(intVal(data[i]['due']));
                
                totalOverduePerPage += parseFloat(data[i]['total_overdue']);
                
                totalDuePerPage += parseFloat(data[i]['total_due']);
                
                totalTaxPerPage += parseFloat(data[i]['total_tax_amount']);
                
                totalPerPage += parseFloat(data[i]['totalPerPage']);
            }
            
            totalPaidPerPage = parseFloat(api.ajax.json().total) - totalDue;
    
            $(api.column(4).footer()).html('All Page Total : <br>' + currencyPrice(api.ajax.json().total) + ' (Amount), '
            + currencyPrice(api.ajax.json().tax_amount) + ' (Tax), '
            + currencyPrice(api.ajax.json().total_paid_all) + ' (Paid), ' 
            + currencyPrice(api.ajax.json().total_due_all) + ' (Unpaid / Due), '
            + currencyPrice(api.ajax.json().total_overdue_all) + ' (Overdue)'
            );
           
            $(api.column(6).footer()).html('This Page Only Total: <br>'
            + currencyPrice(totalPerPage) + ' (Amount), '
            + currencyPrice(totalTaxPerPage) + ' (Tax), '
            + currencyPrice(totalPaidPerPage) + ' (Paid), ' 
            + currencyPrice(totalDuePerPage) + ' (Unpaid / Due), ' 
            + currencyPrice(totalOverduePerPage) + ' (Overdue)');
            
        },
        columns: [{
            "data": 'DT_RowIndex',
            "name": 'DT_RowIndex',
            orderable: false,
            searchable: false,
        },
        {
            "data": "invoice",
            "name": "invoices.invoice_no"
        },
        {
            "data": "property",
            "name": "properties.name"
        },
        {
            "data": "unit",
            "name": "property_units.unit_name"
        },
        {
            "data": "date",
            "name": "invoices.created_at"
        },
        {
            "data": "due",
        },
        {
            "data": "amount",
            "name": "invoices.amount"
        }
        ]
    });
    /*=============================== end earning datatable part ==============================*/
    
    
     /*=============================== Loss / Profit By Month datatable part ==============================*/
     var dt_lossProfit = $('#lossProfitReportDataTable').DataTable({
        processing: true,
        serverSide: true,
        responsive: true,
        ajax: $('#allReportRoute').val() + '?reportType=lossProfit&month=&year=',
        order: [1, 'desc'],
        ordering: false,
        autoWidth: false,
        lengthMenu: [
            [10, 25, 50, 100, -1],
            [10, 25, 50, 100, 'All'],
        ],
        drawCallback: function () {
            $(".dataTables_length select").addClass("form-select form-select-sm");
        },
        language: {
            'paginate':
            {
                'previous': '<span class="iconify" data-icon="icons8:angle-left"></span>',
                'next': '<span class="iconify" data-icon="icons8:angle-right"></span>'
            }
        },
        dom: '<"row"<"col-sm-4"l><"col-sm-4"B><"col-sm-4"f>>tr<"bottom"<"row"<"col-sm-6"i><"col-sm-6"p>>><"clear">',
        buttons: [
            {
                extend: 'excel',
                className: 'theme-btn theme-button1 default-hover-btn',
                text: 'Excel',
                filename: function () {
                    return fileNameLossProfit;
                },
                title: function () {
                    return fileNameLossProfit;
                },
            },
            {
                extend: 'pdf',
                className: 'theme-btn theme-button1 default-hover-btn',
                text: 'PDF',
                title: function () {
                    return fileNameLossProfit;
                },
                customize: function (doc) {
                    doc.content[0].text = fileNameLossProfit; 
                }
            },
            { extend: 'copy', className: 'theme-btn theme-button1 default-hover-btn' }
        ],
        columnDefs: [
            
        ],
        columns: [
            { "data": 'DT_RowIndex', "name": 'DT_RowIndex', orderable: false, searchable: false, },
            { "data": "month" },
            { "data": "income" },
            { "data": "expense" },
            { "data": "profit_loss" },
        ]
    });
      /*=============================== end Loss / Profit By Month datatable part ==============================*/
      
    
     /*=============================== expenses datatable part ==============================*/
     var dt_expense = $('#expenseReportDataTable').DataTable({
        processing: true,
        serverSide: true,
        responsive: true,
        ajax: $('#allReportRoute').val() + '?reportType=expense&start_date=&end_date=&month=&year=&property_id=&unit_id=',
        order: [1, 'desc'],
        ordering: false,
        autoWidth: false,
        pageLength: -1,
        lengthMenu: [
            [10, 25, 50, 100, -1],
            [10, 25, 50, 100, 'All'],
        ],
        drawCallback: function () {
            $(".dataTables_length select").addClass("form-select form-select-sm");
        },
        language: {
            'paginate': {
                'previous': '<span class="iconify" data-icon="icons8:angle-left"></span>',
                'next': '<span class="iconify" data-icon="icons8:angle-right"></span>'
            }
        },
        dom: '<"row"<"col-sm-4"l><"col-sm-4"B><"col-sm-4"f>>tr<"bottom"<"row"<"col-sm-6"i><"col-sm-6"p>>><"clear">',
        buttons: [{
                extend: 'excel',
                className: 'theme-btn theme-button1 default-hover-btn',
                text: 'Excel',
                filename: function () {
                    return fileNameExpense;
                },
                title: function () {
                    return fileNameExpense;
                },
            },
        {
            extend: 'pdf',
            className: 'theme-btn theme-button1 default-hover-btn',
            text: 'PDF',
            title: function () {
                return fileNameExpense;
            },
            customize: function (doc) {
                doc.content[0].text = fileNameExpense; 
            }
        },
        {
            extend: 'copy',
            className: 'theme-btn theme-button1 default-hover-btn'
        }
        ],
        columnDefs: [
            { className: "text-center", targets: [1, 2, 3, 4] },
            { className: "text-end", targets: [5] }
        ],
        footerCallback: function (row, data, start, end, display) {
            var api = this.api();
            // Remove the formatting to get integer data for summation
            var intVal = function (num) {
                var val = 0;
                if (!!num[0].trim() && !isNaN(+num[0])) {
                    val = num.split(' ')[0];
                } else {
                    val = num.split(' ')[1];
                }
                return Number(val.replace(',', ''));
            };
            var totalAmount = 0;
            for (var i = 0; i < data.length; i++) {
                totalAmount += parseFloat(intVal(data[i]['amount']));
            }
            $(api.column(4).footer()).html('All Total : ' + currencyPrice(api.ajax.json().total));
            $(api.column(5).footer()).html('Page Total : ' + currencyPrice(totalAmount));
        },
        columns: [{
            "data": 'DT_RowIndex',
            "name": 'DT_RowIndex',
            orderable: false,
            searchable: false,
        },
        {
            "data": "name",
            "name": "expenses.name"
        },
        {
            "data": "property",
            "name": "properties.name"
        },
        {
            "data": "unit",
            "name": "property_units.unit_name"
        },
        {
            "data": "date",
            "name": "expenses.created_at"
        },
        {
            "data": "amount",
            "name": "expenses.total_amount"
        }
        ]
    });
      /*=============================== end expenses datatable part ==============================*/
      
      
    
     /*=============================== occupancy datatable part ==============================*/
     var dt_occupancy = $('#occupancyReportDataTable').DataTable({
        processing: true,
        serverSide: true,
        responsive: true,
        ajax: $('#allReportRoute').val() + '?reportType=occupancy',
        order: [1, 'desc'],
        ordering: false,
        autoWidth: false,
        pageLength: -1,
        lengthMenu: [
            [10, 25, 50, 100, -1],
            [10, 25, 50, 100, 'All'],
        ],
        drawCallback: function () {
            $(".dataTables_length select").addClass("form-select form-select-sm");
        },
        language: {
            'paginate':
            {
                'previous': '<span class="iconify" data-icon="icons8:angle-left"></span>',
                'next': '<span class="iconify" data-icon="icons8:angle-right"></span>'
            }
        },
        dom: '<"row"<"col-sm-4"l><"col-sm-4"B><"col-sm-4"f>>tr<"bottom"<"row"<"col-sm-6"i><"col-sm-6"p>>><"clear">',
        buttons: [
            {
                extend: 'excel',
                className: 'theme-btn theme-button1 default-hover-btn',
                text: 'Excel',
                filename: function () {
                    return fileNameOccupancy;
                },
                title: function () {
                    return fileNameOccupancy;
                },
            },
            {
                extend: 'pdf',
                className: 'theme-btn theme-button1 default-hover-btn',
                text: 'PDF',
                title: function () {
                    return fileNameOccupancy;
                },
                customize: function (doc) {
                    doc.content[0].text = fileNameOccupancy; 
                }
            },
            { extend: 'copy', className: 'theme-btn theme-button1 default-hover-btn' }
        ],
        columnDefs: [
            { className: "text-center", targets: [1, 2, 3] },
            { className: "text-end", targets: [4] }
        ],
        columns: [
            { "data": 'DT_RowIndex', "name": 'DT_RowIndex', orderable: false, searchable: false, },
            { "data": "property_name", "name": "properties.name" },
            { "data": "address" },
            { "data": "unit" },
            { "data": "available" },
            // { "data": "turn_over" },
        ]
    });

      /*=============================== end occupancy datatable part ==============================*/
      
      
    
     /*=============================== maintenance datatable part ==============================*/
     var dt_maintenance = $('#maintenanceReportDataTable').DataTable({
        processing: true,
        serverSide: true,
        responsive: true,
        ajax: $('#allReportRoute').val() + '?reportType=maintenance&start_date=&end_date=&month=&year=&property_id=&unit_id=',
        order: [1, 'desc'],
        ordering: false,
        autoWidth: false,
        lengthMenu: [
            [10, 25, 50, 100, -1],
            [10, 25, 50, 100, 'All'],
        ],
        drawCallback: function () {
            $(".dataTables_length select").addClass("form-select form-select-sm");
        },
        language: {
            'paginate':
            {
                'previous': '<span class="iconify" data-icon="icons8:angle-left"></span>',
                'next': '<span class="iconify" data-icon="icons8:angle-right"></span>'
            }
        },
        dom: '<"row"<"col-sm-4"l><"col-sm-4"B><"col-sm-4"f>>tr<"bottom"<"row"<"col-sm-6"i><"col-sm-6"p>>><"clear">',
        buttons: [
            {
                extend: 'excel',
                className: 'theme-btn theme-button1 default-hover-btn',
                text: 'Excel',
                filename: function () {
                    return fileNameMaintenance;
                },
                title: function () {
                    return fileNameMaintenance;
                },
            },
            {
                extend: 'pdf',
                className: 'theme-btn theme-button1 default-hover-btn',
                text: 'PDF',
                title: function () {
                    return fileNameMaintenance;
                },
                customize: function (doc) {
                    doc.content[0].text = fileNameMaintenance; 
                }
            },
            { extend: 'copy', className: 'theme-btn theme-button1 default-hover-btn' }
        ],
        columnDefs: [
            { className: "text-center", targets: [1, 2, 3, 4, 5] },
        ],
        columns: [
            { "data": 'DT_RowIndex', "name": 'DT_RowIndex', orderable: false, searchable: false, },
            { "data": "property_name", "name": "properties.name" },
            { "data": "unit_name", "name": "property_units.unit_name" },
            { "data": "tenant_name", "name": "users.first_name" },
            { "data": "issue_name", "name": "maintenance_issues.name" },
            { "data": "status", },
        ]
    });

      /*=============================== end maintenance datatable part ==============================*/
      
      
      
      
    /*=============================== tenant datatable part ==============================*/
    var dt_tenant = $('#tenantReportDataTable').DataTable({
        
        processing: true,
        serverSide: true,
        responsive: true,
        ajax: $('#allReportRoute').val() + '?reportType=tenant&start_date=&end_date=&due_start_date=&due_end_date=&month=&year=&due_month=&due_year=&property_id=&unit_id=&status=',
        order: [1, 'desc'],
        ordering: false,
        autoWidth: false,
        pageLength: -1,
        lengthMenu: [
            [10, 25, 50, 100, -1],
            [10, 25, 50, 100, 'All'],
        ],
        drawCallback: function () {
            $(".dataTables_length select").addClass("form-select form-select-sm");
        },
        language: {
            'paginate':
            {
                'previous': '<span class="iconify" data-icon="icons8:angle-left"></span>',
                'next': '<span class="iconify" data-icon="icons8:angle-right"></span>'
            }
        },
        dom: '<"row"<"col-sm-4"l><"col-sm-4"B><"col-sm-4"f>>tr<"bottom"<"row"<"col-sm-6"i><"col-sm-6"p>>><"clear">',
        buttons: [
            {
                extend: 'excel',
                className: 'theme-btn theme-button1 default-hover-btn',
                text: 'Excel',
                filename: function () {
                    return fileNameTenant;
                },
                title: function () {
                    return fileNameTenant;
                },
            },
            {
                extend: 'pdf',
                className: 'theme-btn theme-button1 default-hover-btn',
                text: 'PDF',
                title: function () {
                    return fileNameTenant;
                },
                customize: function (doc) {
                    doc.content[0].text = fileNameTenant; 
                }
            },
            
            { extend: 'copy', className: 'theme-btn theme-button1 default-hover-btn' }
        ],
        columnDefs: [
            { className: "text-center", targets: [1, 2, 3, 4, 5, 8] },
            { className: "text-end", targets: [6, 7] },
        ],
        columns: [
            { "data": 'DT_RowIndex', "name": 'DT_RowIndex', orderable: false, searchable: false, },
            { "data": "name", "name": "users.first_name" },
            { "data": "email", "name": "users.email" },
            { "data": "contact", "name": "users.contact_number" },
            { "data": "property", "name": "properties.name" },
            { "data": "unit", "name": "property_units.unit_name" },
            { "data": "paid" },
            { "data": "due" },
            { "data": "status", },
        ]
    });
    
    
    /*=============================== end tenant datatable part ==============================*/

$('#download-pdf').on('click', function () {
                // Trigger the 'pdf' button click
                $('.buttons-pdf').trigger('click');
            });

            // Custom Excel button click event
            $('#download-excel').on('click', function () {
                // Trigger the 'excel' button click
                $('.buttons-excel').trigger('click');
            });

    </script>
@endpush