@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">
                                            <select class="form-select flex-shrink-0" name="property_id" id="property_id">
                                                <option value="" selected>--{{ __('Select Property') }}--</option>
                                                @foreach ($properties as $property)
                                                    <option value="{{ $property->id }}">{{ $property->name }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                        <div class="col-md-3 mb-25">
                                            <select class="form-select flex-shrink-0" name="unit_id" id="unit_id">
                                                <option value="" selected>--{{ __('Select Option') }}--</option>
                                            </select>
                                        </div>
                                        <div class="col-md-5 mb-25">
                                            <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">{{ __('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">{{ __('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 class="col-auto mb-25">
                                            <button type="button" class="theme-btn w-auto"
                                                id="searchBtn" title="{{ __('Search') }}">{{ __('Search') }}</button>
                                                
                                            <a href="{{ route('owner.reports.expenses') }}" 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">{{ __('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>
            </div>
        </div>
    </div>
    <input type="hidden" id="expenseReportRoute" value="{{ route('owner.reports.expenses') }}">
    <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-expense.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 = $('#expenseReportRoute').val() + '?start_date=' + $('#start_date').val() + '&end_date=' + $('#end_date').val() + '&property_id=' + $('#property_id').val() + '&unit_id=' + $('#unit_id').val()+ '&month=' + $('#month').val() + '&year=' + $('#year').val();
    dt.ajax.url(url).load();
});

var dt = $('#allDatatable').DataTable({
    processing: true,
    serverSide: true,
    responsive: true,
    ajax: $('#expenseReportRoute').val() + '?start_date=&end_date=&property_id=&unit_id=&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'
    },
    {
        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] },
        { 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"
    }
    ]
});

       */

    </script>
@endpush