@extends('owner.layouts.app')

@section('content')
    <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">{{ __('Property') }}</label>
                                            <select class="form-select flex-shrink-0" name="property_id" id="property_id">
                                                <option value="" selected>{{ __('All Property') }}</option>
                                                @foreach ($properties as $property)
                                                    <option value="{{ $property->id }}">{{ $property->name }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                        <div class="col-md-3 mb-25">
                                            <label class="label-text-title color-heading font-medium mb-2">{{ __('Unit') }}</label>
                                            <select class="form-select flex-shrink-0" name="unit_id" id="unit_id">
                                                <option value="" selected>{{ __('All Unit') }}</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="row">
                                        <div class="col-md-5 mb-25">
                                            <label class="label-text-title color-heading font-medium mb-2">{{ __('Invoice created Date Range') }}</label>
                                            <div class="input-group">
                                                <span class="input-group-text">{{ __('From') }}</span>
                                                <input type="date" class="form-control" placeholder="Start Date"
                                                    id="start_date" name="start_date" aria-label="Start Date">
                                                <span class="input-group-text">{{ __('to') }}</span>
                                                <input type="date" class="form-control" placeholder="End Date"
                                                    id="end_date" name="end_date" aria-label="End Date">
                                            </div>
                                        </div>
                                        <div class="col-md-3 mb-25">
                                            <label class="label-text-title color-heading font-medium mb-2">{{ __('Invoice Created Month') }}</label>
                                            <select class="form-select flex-shrink-0" name="month" id="month">
                                                <option value="" selected>{{ __('All 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">{{ __('Invoice Created Year') }}</label>
                                            <select class="form-select flex-shrink-0" name="year" id="year">
                                                <option value="" selected>{{ __('All Year') }}</option>
                                                @foreach($years as $year)
                                                    <option value="{{$year}}">{{$year}}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    <div class="row">
                                        <div class="col-md-5 mb-25">
                                            <label class="label-text-title color-heading font-medium mb-2">{{ __('Invoice Due Date Range') }}</label>
                                            <div class="input-group">
                                                <span class="input-group-text">{{ __('From') }}</span>
                                                <input type="date" class="form-control" placeholder="Start Date"
                                                    id="due_start_date" name="due_start_date" aria-label="Start Date">
                                                <span class="input-group-text">{{ __('to') }}</span>
                                                <input type="date" class="form-control" placeholder="End Date"
                                                    id="due_end_date" name="due_end_date" aria-label="End Date">
                                            </div>
                                        </div>
                                        <div class="col-md-3 mb-25">
                                            <label class="label-text-title color-heading font-medium mb-2">{{ __('Invoice Due Month') }}</label>
                                            <select class="form-select flex-shrink-0" name="due_month" id="due_month">
                                                <option value="" selected>{{ __('All Month') }}</option>
                                                @foreach($due_months as $due_month)
                                                    <option value="{{$due_month}}">{{ date('F', strtotime('2023-' . $due_month . '-01')) }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                        <div class="col-md-3 mb-25">
                                            <label class="label-text-title color-heading font-medium mb-2">{{ __('Invoice Due Year') }}</label>
                                            <select class="form-select flex-shrink-0" name="due_year" id="due_year">
                                                <option value="" selected>{{ __('All Year') }}</option>
                                                @foreach($due_years as $due_year)
                                                    <option value="{{$due_year}}">{{$due_year}}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    <div class="row">
                                        <div class="col-md-3 mb-25">
                                            <label class="label-text-title color-heading font-medium mb-2">{{ __('Invoice Status') }}</label>
                                            <select class="form-select flex-shrink-0" name="status" id="status">
                                                <option value="" selected>{{ __('All Status') }}</option>
                                                <option value="Paid" >Paid</option>
                                                <option value="Unpaid" >Unpaid (Due)</option>
                                                <option value="Overdue" >Overdue</option>
                                            </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.earning') }}" type="button" class="default-btn theme-btn-purple w-auto"
                                                 title="{{ __('Reset') }}">{{ __('Reset') }}</a>
                                        </div>
                                    </div>
                                </form>
                            </div>
                        </div>
                        <div class="notice-board-table-area">
                            <div class="table-responsive bg-off-white theme-border radius-4 p-25">
                                <table id="allDatatable" 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>
            </div>
        </div>
    </div>
    <input type="hidden" id="earningReportRoute" value="{{ route('owner.reports.earning') }}">
    <input type="hidden" id="getPropertyUnitsRoute" value="{{ route('owner.property.getPropertyUnits') }}">
@endsection
@push('style')
    @include('common.layouts.datatable-style')
@endpush
@push('script')
    @include('common.layouts.datatable-script')
    <script src="{{ asset('assets/js/custom/report-earning.js') }}"></script>
    
    <!--
    <script>
        $(document).on('change', '#property_id', function () {
    var property_id = $(this).val()
    commonAjax('GET', $('#getPropertyUnitsRoute').val(), getUnitsRes, getUnitsRes, { 'property_id': property_id });
});

function getUnitsRes(response) {
    var html = '<option value="">--Select Option--</option>';
    Object.entries(response.data).forEach((unit) => {
        html += '<option value="' + unit[1].id + '">' + unit[1].unit_name + '</option>';
    });
    $('#unit_id').html(html);
}

$(document).on('click', '#searchBtn', function () {
    console.log('in');
    var url = $('#earningReportRoute').val() + '?start_date=' + $('#start_date').val() + '&end_date=' + $('#end_date').val() 
    + '&due_start_date=' + $('#due_start_date').val() + '&due_end_date=' + $('#due_end_date').val()
    + '&month=' + $('#month').val() + '&year=' + $('#year').val()
    + '&due_month=' + $('#due_month').val() + '&due_year=' + $('#due_year').val()
    + '&property_id=' + $('#property_id').val() + '&unit_id=' + $('#unit_id').val()
    + '&status=' + $('#status').val();
    dt.ajax.url(url).load();
});

var dt = $('#allDatatable').DataTable({
    processing: true,
    serverSide: true,
    responsive: true,
    ajax: $('#earningReportRoute').val() + '?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,
    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'
    },
    {
        extend: 'pdf',
        className: 'theme-btn theme-button1 default-hover-btn'
    },
    {
        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"
    }
    ]
});
    </script>-->
@endpush