@extends('layouts.master')

@section('title', __('accounting.expense_transaction'))

@section('content_title', __('accounting.expense_transaction'))

@section('content_summary', __('accounting.expense_transaction'))

@section('content_taskbar')
    <li class="nav-item">
        <a href="{{ route('accounting.expense_transactions.create') }}" class="nav-link">
            <i class="nav-link-icon pe-7s-plus"></i>
            <span>{{ __('core.add') }}</span>
        </a>
    </li>
@endsection
@push('style')
<link rel="stylesheet" href="https://cdn.datatables.net/buttons/2.4.1/css/buttons.dataTables.min.css">
@endpush

@section('main_content')

{{-- Filter form start --}}
<div class="main-card mb-3">
    <div class="card mb-3">
        <div class="card-body">
            <h5 class="card-title">{{ __('core.filter') }}</h5>
            <form id="user-search-form" action="{{ route('expense_transactions.search') }}" method="POST">
            @csrf
            <div class="row">
                @if (auth()->user()->hasRole('Super Admin'))
                    <div class="col col-md-3">
                        <label for="business_id">{{ __('core.business_name') }}: *</label>
                        <select class="form-select filter-dropdown" name="business_id" id="business_id" required>
                            <option value="">{{ __('core.please_select') }}</option>
                            @foreach ($data['businesses'] as $value)
                                <option value="{{ $value->id }}">{{ $value->business_name }}</option>
                            @endforeach
                        </select>
                    </div>
                @else
                    <input type="hidden" name="business_id" value="{{ auth()->user()->business_id }}">
                @endif


                <div class="col-md-3">
                    <label for="academic_year">{{ __('accounting.payment_account') }}</label>
                    <select name="payment_account_id" id="payment_account_id" class="form-control filter-dropdown">
                        <option value="">{{ __('core.please_select') }}</option>
                        @if (!auth()->user()->hasRole('Super Admin'))
                            @foreach ($payment_account as $key => $value)
                                <option value="{{ $value->id }}">{{ $value->account_name }}</option>
                            @endforeach
                        @endif
                    </select>
                </div>

                <div class="col-md-3">
                    <label for="academic_year">{{ __('accounting.expense_category') }}</label>
                    <select name="expense_category_id" id="expense_category_id" class="form-control filter-dropdown">
                        <option value="">{{ __('core.please_select') }}</option>
                        
                    </select>
                </div>

            </div><br>
        </form>
        </div>
    </div>
</div>

{{-- Filter form end --}}

    <div class="main-card mb-3 card">
        <div class="card-body">
            <ul class="nav nav-tabs">
                <li class="nav-item">
                    <a data-bs-toggle="tab" href="#tab-eg10-0" class="active nav-link">{{__('core.home')}}</a>
                </li>
                <li class="nav-item">
                    <a data-bs-toggle="tab" href="#tab-eg10-1" class="nav-link">
                        <span>{{__('core.trash')}}</span>
                        {{-- <span class="badge rounded-pill bg-danger">{{ $trashedCount }}</span> --}}
                    </a>
                </li>
            </ul>
            <div class="tab-content">
                <div class="tab-pane active" id="tab-eg10-0" role="tabpanel">

                    @include('accounting::expense_transactions.partials.expense_transaction_list')
                </div>
                <div class="tab-pane" id="tab-eg10-1" role="tabpanel">
                    @include('accounting::expense_transactions.partials.trash_list')
                </div>
            </div>
        </div>
    </div>
@endsection
@push('script')
<script src="https://cdn.datatables.net/buttons/2.4.1/js/dataTables.buttons.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.4.1/js/buttons.colVis.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.4.1/js/buttons.print.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.4.1/js/buttons.html5.min.js"></script>

    <script type="text/javascript">
        $(document).ready(function() {

            $(document).on("click", ".modal-triger", function() {
                let modal_selector = $(this).attr("data-bs-target");
                $(modal_selector).css("visibility", "hidden")
                $.ajax({
                    method: 'GET',
                    url: $(this).attr('href'),
                    success: function(response) {
                        $(modal_selector).modal().hide();
                        $(modal_selector).css("visibility", "")
                        $(modal_selector).html(response)
                        $(modal_selector).modal().show();

                    },
                    error: function(response) {
                        // console.log(response);
                        $(modal_selector).html(
                            'Something Wrong, Please Try Again Later.');
                    }
                });
            })

            $('#expense_transaction_table').DataTable({
                responsive: true
            });

            $('#expense_transaction_trash_table').DataTable({
                responsive: true
            });

            $(document).on('submit', 'form#expense_transaction_form', function(e) {
                e.preventDefault();
                $(this).find('button[type="submit"]').attr('disabled', false);
                var data = $(this).serialize();

                $.ajax({
                    method: $(this).attr('method'),
                    url: $(this).attr("action"),
                    dataType: "json",
                    data: data,
                    success: function(result) {
                        if (result.success == true) {
                            $("#expense_transaction_form").parent().closest('.modal').modal(
                                "hide");
                            toastr.success(result.msg);
                            loadData();
                        } else {
                            toastr.error(result.msg);
                        }
                    },
                    error: function(response) {
                        // Clear previous error messages
                        $("#expense_transaction_form").find('.text-danger').remove();

                        if (response.status === 422) {
                            // Validation errors
                            var errors = response.responseJSON.errors;
                            for (var field in errors) {
                                // Find the input field and add the error message
                                let key = field;
                                let parts = key.split('.');
                                let input_name = parts[0]; // "input field name value"
                                let index = parts[1];
                                if (index) {
                                    var $input = $('[name="' + input_name + '[]"]')[index];
                                    let span = document.createElement("span");
                                    span.classList.add("text-danger");
                                    span.innerText = errors[field][0];
                                    $input.parentElement.appendChild(span);
                                } else {
                                    var $input = $('[name="' + field + '"]');
                                    let span = document.createElement("span");
                                    span.classList.add("text-danger");
                                    span.innerText = errors[field][0];
                                    $input[0].parentElement.appendChild(span);
                                }
                                toastr.error(errors[field][0]);

                            }
                        } else {
                            toastr.error('An unexpected error occurred.');
                        }

                        // Re-enable submit button
                    }
                });
            });

            $(document).on('click', 'button.toggle_expense_transaction_button', function(e) {
                e.preventDefault();
                var data = $(this).serialize();
                Swal.fire({
                    // type: "warning",
                    title: "{{ __('common.sure') }}",
                    text: "{{ __('common.confirm_update_status') }}",
                    icon: "warning"
                }).then((willUpdate) => {
                    console.log(willUpdate)
                    if (willUpdate.isConfirmed) {
                        $.ajax({
                            url: $(this).attr("data-href"),
                            method: "PUT",
                            dataType: "json",
                            data: data,
                            success: function(result) {
                                console.log(result)
                                if (result.success == true) {
                                    toastr.success(result.msg);
                                    loadData();
                                } else {
                                    toastr.error(result.msg);
                                }
                            }
                        });
                    }
                })
            });

            // expense_transactions delete
            $(document).on('click', '.delete_expense_transaction_button', function() {
                var url = $(this).data('href');
                Swal.fire({
                    title: "{{ __('common.sure') }}",
                    text: "{{ __('accounting.confirm_delete_expense_transaction') }}",
                    icon: 'warning',
                    buttons: true,
                    dangerMode: true,
                }).then((willDelete) => {
                    if (willDelete.isConfirmed) {
                        var href = url;
                        var data = $(this).serialize();
                        data = {
                            "_token": "{{ csrf_token() }}"
                        }
                        $.ajax({
                            method: 'DELETE',
                            url: href,
                            dataType: 'json',
                            data: data,
                            success: function(result) {
                                if (result.success == true) {
                                    toastr.success(result.msg);
                                    loadData();
                                } else {
                                    swal({
                                        title: "{{ __('core.sure') }}",
                                        text: "Some error occured",
                                        icon: 'warning',
                                        buttons: true,
                                        dangerMode: true,
                                    }).then((willDelete) => {
                                        if (willDelete.isConfirmed) {
                                            var href = url;
                                            var data = {
                                                delete: 'all'
                                            };

                                            $.ajax({
                                                method: 'DELETE',
                                                url: href,
                                                dataType: 'json',
                                                data: data,
                                                success: function(
                                                    result) {
                                                    if (result
                                                        .success ==
                                                        true) {
                                                        toastr
                                                            .success(
                                                                result
                                                                .msg
                                                            );
                                                        loadData();
                                                    } else {
                                                        toastr
                                                            .error(
                                                                result
                                                                .msg
                                                            );
                                                    }
                                                },
                                            });
                                        }
                                    })
                                }
                            },
                        });
                    }
                });
            });

            // delete trash
            $(document).on('click', '.force_delete_expense_transaction_button', function() {
                Swal.fire({
                    title: "{{ __('common.sure') }}",
                    text: "{{ __('common.confirm_force_delete') }}",
                    icon: 'warning',
                    buttons: true,
                    dangerMode: true,
                }).then((willDelete) => {
                    if (willDelete.isConfirmed) {
                        var href = $(this).data('href');
                        var data = $(this).serialize();
                        data = {
                            "_token": "{{ csrf_token() }}"
                        }
                        $.ajax({
                            method: 'DELETE',
                            url: href,
                            dataType: 'json',
                            data: data,
                            success: function(result) {
                                if (result.success == true) {
                                    toastr.success(result.msg);
                                    loadData();
                                } else {
                                    toastr.error(result.msg);
                                }
                            },
                        });
                    }
                });
            });

            // restore
            $(document).on('click', '.restore_expense_transaction_button', function() {
                Swal.fire({
                    title: "{{ __('common.sure') }}",
                    text: "{{ __('common.confirm_restore') }}",
                    icon: 'warning',
                    buttons: true,
                    dangerMode: false,
                }).then((willRestore) => {
                    if (willRestore.isConfirmed) {
                        var href = $(this).data('href');
                        var data = $(this).serialize();
                        data = {
                            "_token": "{{ csrf_token() }}"
                        }
                        $.ajax({
                            method: 'POST',
                            url: href,
                            dataType: 'json',
                            data: data,
                            success: function(result) {
                                if (result.success == true) {
                                    toastr.success(result.msg);
                                    loadData();
                                } else {
                                    toastr.error(result.msg);
                                }
                            },
                        });
                    }
                });
            });


        /*------load filter field-------*/
        $(document).ready(function () {
            const isSuperAdmin = @json(auth()->user()->hasRole('Super Admin'));

            // Only load payment account on business_id change if Super Admin
            if (isSuperAdmin) {
                $(document).on("change", "#business_id", function () {
                    let business_id = $(this).val();
                    if (!business_id) {
                        updateDropdown($("#payment_account_id"), {}, true);
                        updateDropdown($("#expense_category_id"), {}, true);
                        return;
                    }

                    $.post("{{ route('payment_account.load') }}", {
                        business_id: business_id,
                        _token: "{{ csrf_token() }}"
                    }, function (response) {
                        updateDropdown($("#payment_account_id"), response, true);
                        updateDropdown($("#expense_category_id"), {}, true); // clear on business change
                    });
                });
            }

            $(document).on('change', '#payment_account_id', function () {
                let payment_account_id = $(this).val();
                let business_id = isSuperAdmin ? $("#business_id").val() : "{{ auth()->user()->business_id }}";

                if (!payment_account_id) {
                    updateDropdown($("#expense_category_id"), {}, true); // clear dropdown
                    return;
                }

                $.post("{{ route('expense_category.load') }}", {
                    business_id: business_id,
                    payment_account_id: payment_account_id,
                    _token: "{{ csrf_token() }}"
                }, function (result) {
                    updateDropdown($("#expense_category_id"), result.expense_category_id, true);
                });
            });

            function updateDropdown($select, data, reset = true) {
                $select.empty();
                $select.append($('<option>').val('').text("{{ __('core.please_select') }}"));
                $.each(data, function (key, value) {
                    $select.append($('<option>').val(key).text(value));
                });
                if (reset) {
                    $select.find('option:first').prop('selected', true);
                }
            }
        });

    /*------end load filter field-------*/


            // Load data
            function loadData() {
                $.ajax({
                    method: 'GET',
                    url: "{{ route('accounting.expense_transactions.index') }}",
                    success: function(response) {
                        // Destroy the existing DataTable instance
                        if ($.fn.DataTable.isDataTable('#expense_transaction_table')) {
                            $('#expense_transaction_table').DataTable().destroy();
                        }
                        if ($.fn.DataTable.isDataTable('#expense_transaction_trash_table')) {
                            $('#expense_transaction_trash_table').DataTable().destroy();
                        }

                        // Replace the table body with the new data
                        $('#expense-transaction-table-data').html(response.homeData);
                        $('#expense-transaction-trash-table-data').html(response.trashData);

                        // Reinitialize the DataTable
                        $('#expense_transaction_table').DataTable({
                            processing: true
                            , dom: 'Bfrtip', // Enables buttons above the table
                            buttons: [{
                                    extend: 'colvis'
                                    , text: 'Column Visibility', // Text for the column visibility button
                                    columns: ':gt(0)', // Enable visibility toggle for columns except the first one
                                    action: function(e, dt, button, config) {
                                        // Perform the default colvis action
                                        $.fn.dataTable.ext.buttons.collection.action
                                            .call(this, e, dt, button, config);

                                        // Find and style the dt-button-background div
                                        $('div.dt-button-background').css({
                                            'background': 'rgba(0, 0, 0, 0)', // Light red with transparency
                                            'z-index': '2000' // Higher z-index
                                        });
                                    }
                                }
                                , {
                                    extend: 'print'
                                    , text: 'Print Table', // Text for the print button
                                    exportOptions: {
                                        columns: ':visible:not(:last-child)',
                                        format: {
                                           body: function (data, row, column, node) {
                                               const exportText = $(node).find('.export-status').text().trim();
                                               return exportText || $(node).text().trim();
                                           }
                                       }
                                    }
                                    , customize: function(win) {
                                        $(win.document.body).css('font-size'
                                            , '10pt'
                                        ); // Custom font size for the print view
                                        $(win.document.body).find('table')
                                            .addClass('compact')
                                            .css('font-size', 'inherit');
                                    }
                                }, 
                                    {
                                        extend: 'csv',
                                        text: 'Export',
                                        exportOptions: {
                                            columns: ':visible:not(:last-child)',
                                            format: {
                                               body: function (data, row, column, node) {
                                                   const exportText = $(node).find('.export-status').text().trim();
                                                   return exportText || $(node).text().trim();
                                               }
                                           }
                                        }
                                    }
                            ]
                        });
                        $('#expense_transaction_trash_table').DataTable({
                            responsive: true,
                            processing: true,
                        });
                    },
                    error: function(response) {
                        console.log(response);
                    }
                });
            }

            // Initial load
            loadData();
        });
    </script>

    {{-- filter index form start --}}
    <script>
        $(document).ready(function () {
            $(".filter-dropdown").on("change", function () {
                loadFilteredData();
            });

            function loadFilteredData() {
                let filters = {
                    business_id: $("#business_id").val(),
                    payment_account_id: $("#payment_account_id").val(),
                    expense_category_id: $("#expense_category_id").val(),
                    _token: $('meta[name="csrf-token"]').attr('content'),
                };

                $.ajax({
                    method: "POST",
                    url: "{{ route('expense_transactions.search') }}",
                    data: filters,
                    success: function(response) {
                        if ($.fn.DataTable.isDataTable('#expense_transaction_table')) {
                            $('#expense_transaction_table').DataTable().destroy();
                        }
                        if ($.fn.DataTable.isDataTable('#expense_transaction_trash_table')) {
                            $('#expense_transaction_trash_table').DataTable().destroy();
                        }

                        $('#expense-transaction-table-data').html(response.homeData);
                        $('#expense-transaction-trash-table-data').html(response.trashData);

                        $('#expense_transaction_table').DataTable({
                            processing: true,
                            responsive: true,
                            dom: 'Bfrtip',
                            buttons: [
                                {
                                    extend: 'colvis',
                                    text: 'Column Visibility',
                                    columns: ':gt(0)',
                                    action: function(e, dt, button, config) {
                                        $.fn.dataTable.ext.buttons.collection.action
                                            .call(this, e, dt, button, config);
                                        $('div.dt-button-background').css({
                                            'background': 'rgba(0, 0, 0, 0)',
                                            'z-index': '2000'
                                        });
                                    }
                                },
                                {
                                    extend: 'print',
                                    text: 'Print Table',
                                    exportOptions: {
                                        columns: ':visible:not(:last-child)',
                                        format: {
                                               body: function (data, row, column, node) {
                                                   const exportText = $(node).find('.export-status').text().trim();
                                                   return exportText || $(node).text().trim();
                                               }
                                           }
                                    },
                                    customize: function(win) {
                                        $(win.document.body).css('font-size', '10pt');
                                        $(win.document.body).find('table')
                                            .addClass('compact')
                                            .css('font-size', 'inherit');
                                    }
                                },
                                {
                                    extend: 'csv',
                                    text: 'Export',
                                    exportOptions: {
                                        columns: ':visible:not(:last-child)',
                                        format: {
                                               body: function (data, row, column, node) {
                                                   const exportText = $(node).find('.export-status').text().trim();
                                                   return exportText || $(node).text().trim();
                                               }
                                           }
                                    }
                                }
                            ]
                        });

                        $('#expense_transaction_trash_table').DataTable({
                            responsive: true,
                            processing: true,
                        });
                    },
                    error: function(error) {
                        console.error("Filter failed", error);
                    }
                }
                );
            }
        });
</script>

    {{-- filter form end --}}

@endpush