@extends('layouts.app')

@section('title')
    {{ __('balance_fluctuation') }}
@endsection

@section('transaction')
    active
@endsection

@section('section.header')
    <section class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                    <h1>{{ __('balance_fluctuation') }}</h1>
                </div>
                <div class="col-sm-6">
                    <ol class="breadcrumb float-sm-right">
                        <li class="breadcrumb-item"><a href="{{ route('app.index') }}">{{ __('home') }}</a></li>
                        <li class="breadcrumb-item active">{{ __('balance_fluctuation') }}</li>
                    </ol>
                </div>
            </div>
            <hr>
        </div><!-- /.container-fluid -->
    </section>
@endsection

@section('section.content')
    <section class="content">
        <div class="card">
            @php
                $tableBodyStyle = $isDemoAccount ? 'display: none;' : '';
            @endphp
            <div id="loading-overlay" class="overlay d-none">
                <div class="spinner-border text-primary" role="status">
                    <span class="sr-only">Loading...</span>
                </div>
                <div class="loading-text">{{ __('calculating_please_wait') }}</div>
            </div>
            <div class="card-body" style="background-color: #9fb69f">
                <form class="row" id="search-transaction">
                    @csrf
                    @role('admin|support')
                        <div class="col-lg-2">
                            <div class="form-group">
                                <div class="input-group mb-3">
                                    <div class="input-group-prepend">
                                        <span class="input-group-text">{{ __('partner') }}</span>
                                    </div>
                                    <select name="partner" class="form-control">
                                        <option value="">{{ __('select') }}</option>
                                        @foreach (\App\Models\User\User::getPartners() as $partner)
                                            <option value="{{ $partner->id }}">{{ $partner->username }}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                        </div>
                    @endrole
                    @role('accountant')
                        <div class="col-lg-2">
                            <div class="form-group">
                                <div class="input-group mb-3">
                                    <div class="input-group-prepend">
                                        <span class="input-group-text">{{ __('partner') }}</span>
                                    </div>
                                    <select name="partner" class="form-control">
                                        <option value="">{{ __('select') }}</option>
                                        @foreach (\App\Models\User\User::getPartnerAccountantCanView() as $partner)
                                            <option value="{{ $partner->id }}">{{ $partner->username }}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                        </div>
                    @endrole

                    <div class="col-lg-2">
                        <div class="form-group">
                            <div class="input-group mb-3">
                                <div class="input-group-prepend">
                                    <span class="input-group-text">{{ __('transaction') }}</span>
                                </div>
                                <select name="type" class="form-control">
                                    <option value="">{{ __('select') }}</option>
                                    @foreach (TRANSACTION_IO as $key => $value)
                                        <option value="{{ $key }}">{{ $value }}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                    </div>

                    <div class="col-lg-2">
                        <div class="form-group">
                            <div class="input-group mb-3">
                                <div class="input-group-prepend">
                                    <span class="input-group-text">{{ __('transaction_type') }}</span>
                                </div>
                                <select name="transaction_type" class="form-control">
                                    <option value="">{{ __('select') }}</option>
                                    @foreach (TRANSACTION_TYPE as $key => $value)
                                        <option value="{{ $key }}">{{ $value }}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                    </div>

                    <div class="col-lg-4">
                        <div class="form-group">
                            <div class="input-group mb-3">
                                <div class="input-group-prepend">
                                    <span class="input-group-text">{{ __('time') }}</span>
                                </div>
                                <input type="datetime-local" class="form-control" name="from_date" id="from_create_date"
                                    value="{{ now()->format('Y-m-d') }}T00:00">
                                <input type="datetime-local" class="form-control" name="to_date" id="to_create_date"
                                    value="{{ now()->format('Y-m-d', strtotime('+1 day')) }}T23:59:59">
                            </div>
                        </div>
                    </div>

                    <div class="col-lg-2">
                        <div class="form-group">
                            <div class="input-group mb-3">
                                <div class="input-group-prepend">
                                    <span class="input-group-text">{{ __('request_id') }}</span>
                                </div>
                                <input type="text" class="form-control" name="request_id"
                                    placeholder="{{ __('request_id') }}">
                            </div>
                        </div>
                    </div>

                    <div class="col-lg-2">
                        <button type="submit" class="btn btn-primary" id="btn-search"><i
                                class="fa fa-search"></i>{{ __('search') }}</button>
                        <button type="submit" class="btn btn-primary"
                            id="btn-total-transaction">{{ __('report') }}</button>
                    </div>
                    <span id="date-error" class="text-danger"></span>
                </form>
            </div>
        </div>

        <div class="card">
            <div class="card-header">
                <h3 class="card-title">{{ __('List') }}</h3>
                <div class="card-tools">
                    <a class="btn btn-sm btn-primary" id="export-transaction" href="javascript:void(0)"><i
                            class="fas fa-file-excel"></i>{{ __('export_excel') }}</a>
                </div>
            </div>
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table table-bordered table-striped" id="listTransactions">
                        <thead style="text-align: center; background-color: #b6b9b6">
                            <tr>
                                <th>{{ __('ID') }}</th>
                                <th>{{ __('partner') }}</th>
                                <th>{{ __('handler') }}</th>
                                <th>{{ __('transaction') }}</th>
                                <th>{{ __('transaction_type') }}</th>
                                <th>{{ __('amount') }}</th>
                                <th>{{ __('before_balance') }}</th>
                                <th>{{ __('after_balance') }}</th>
                                <th>{{ __('order_id') }}</th>
                                <th>{{ __('request_id') }}</th>
                                <th>{{ __('content') }}</th>
                                <th>{{ __('time') }}</th>
                            </tr>
                        </thead>
                        <tbody style="text-align: center">
                        </tbody>
                    </table>
                </div>
            </div>

            <div class="modal fade" id="transactionTotalModal" tabindex="-1" aria-labelledby="transactionTotalModalLabel"
                aria-hidden="true">
                <div class="modal-dialog">
                    <div class="modal-content">
                        <div class="modal-header">
                            <h5 class="modal-title text-center" id="transactionTotalModalLabel">
                                {{ __('report') }}</h5>
                            <button type="button" class="close" data-bs-dismiss="modal" aria-label="Close">
                                <span aria-hidden="true">&times;</span>
                            </button>
                        </div>
                        <div class="modal-body">
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table class="table table-bordered table-striped">
                                        <tbody>
                                            <tr style="background-color: #83ee7f">
                                                <td>{{ __('total_amount') }}</td>
                                                <td><span id="totalAmount"></span></td>
                                            </tr>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                        <div class="modal-footer">
                            <button type="button" class="btn btn-secondary"
                                data-bs-dismiss="modal">{{ __('close') }}</button>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
@endsection

@section('scripts')
    <!-- DataTables  & Plugins -->
    <script src="{{ asset('plugins/datatables/jquery.dataTables.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables-bs4/js/dataTables.bootstrap4.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables-responsive/js/dataTables.responsive.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables-responsive/js/responsive.bootstrap4.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables-buttons/js/dataTables.buttons.min.js') }}"></script>
    <script type='text/javascript' src='https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js'></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/toastr.js/latest/toastr.min.js"></script>
    <script type="text/javascript" src="https://cdn.datatables.net/plug-ins/2.0.1/pagination/input.js"></script>
    <script>
        $('#export-transaction').click(function(e) {
            e.preventDefault();
            var fromCreatedDate = document.getElementById('from_create_date').value;
            var toCreatedDate = document.getElementById('to_create_date').value;

            if (fromCreatedDate > toCreatedDate) {
                document.getElementById('date-error').textContent =
                    'Ngày bắt đầu phải nhỏ hơn hoặc bằng ngày kết thúc.';
                return;
            }
            fromCreatedDate = new Date(fromCreatedDate);
            toCreatedDate = new Date(toCreatedDate);
            var diffInTime = toCreatedDate.getTime() - fromCreatedDate.getTime();
            var diffInDays = diffInTime / (1000 * 3600 * 24);

            if (diffInDays > 1) {
                document.getElementById('date-error').textContent =
                    'Khoảng thời gian không được lớn hơn 1 ngày.';
                return;
            }
            document.getElementById('date-error').textContent = '';
            $.ajax({
                type: 'POST',
                url: "{{ route('app.exportTransaction') }}",
                data: $('#search-transaction').serialize(),
                dataType: 'JSON',
                success: function(response) {
                    if (response.success) {
                        toastr.success(response.message);
                        setTimeout(function() {
                            window.open('/file-managers', '_blank');
                        }, 3000);
                    }
                },
                error: function(error) {
                    toastr.error(error);
                },
                complete: () => {
                    $('#loading-overlay').addClass('d-none');
                }
            });
        });
    </script>
    <script>
        function numberFormat(number) {
            return new Intl.NumberFormat('en-US').format(number);
        }
        const dataTables = $('#listTransactions').DataTable({
            // Bỏ chữ 'f' để xóa ô search mặc định của DataTables (tránh slow query LIKE %%)
            dom: 'lirtp',
            processing: true,
            serverSide: true,
            searching: false,
            'pageLength': 20,
            'pagingType': 'input',
            'aLengthMenu': [
                [20, 50, 100, 500, -1],
                [20, 50, 100, 500, 'All']
            ],
            ajax: {
                url: '{{ route('app.transaction.index') }}',
                type: 'GET',
                data: function(d) {
                    d.partner = $('#search-transaction [name="partner"]').val();
                    d.from_date = $('#search-transaction [name="from_date"]').val();
                    d.to_date = $('#search-transaction [name="to_date"]').val();
                    d.type = $('#search-transaction [name="type"]').val();
                    d.transaction_type = $('#search-transaction [name="transaction_type"]').val();
                    d.request_id = $('#search-transaction [name="request_id"]').val();
                    // Xóa global search payload phòng khi DataTables vẫn còn gửi
                    if (d.search) d.search.value = '';
                },
                error: function(xhr, status, error) {
                    if (status == "parsererror") {
                        window.location.href = '/auth/login';
                    }
                }
            },
            // Mọi cột tắt searchable + orderable (chỉ sort theo id) để tránh server LIKE/ORDER BY trên cột không index
            columnDefs: [
                { targets: '_all', searchable: false, orderable: false }
            ],
            columns: [
                { data: 'id' },
                { data: 'user_id' },
                { data: 'handler' },
                {
                    data: 'io',
                    render: (data) => {
                        if (data === 'minus') {
                            return `<span class="badge bg-danger p-2">Trừ tiền</span>`;
                        } else if (data === 'plus') {
                            return `<span class="badge bg-warning p-2">Cộng tiền</span>`;
                        }
                    }
                },
                { data: 'type' },
                {
                    data: 'amount',
                    render: (data, type, row) => {
                        if (row.io === 'minus') {
                            return `<span class="badge bg-danger p-2">-${numberFormat(data)}</span>`;
                        } else if (row.io === 'plus') {
                            return `<span class="badge bg-warning p-2">+${numberFormat(data)}</span>`;
                        }
                    }
                },
                { data: 'balance_before', render: (data) => numberFormat(data) },
                { data: 'balance_after',  render: (data) => numberFormat(data) },
                { data: 'order_id' },
                { data: 'request_id' },
                { data: 'content' },
                { data: 'created_at' },
            ],
            order: [
                [0, 'desc']
            ],
        });

        $('#listTransactions').css('width', '100%');

        $(document).on('submit', '#search-transaction', function(event) {
            event.preventDefault();
            var fromCreatedDate = document.getElementById('from_create_date').value;
            var toCreatedDate = document.getElementById('to_create_date').value;

            if (fromCreatedDate > toCreatedDate) {
                document.getElementById('date-error').textContent =
                    'Ngày bắt đầu phải nhỏ hơn hoặc bằng ngày kết thúc.';
                return;
            }
            fromCreatedDate = new Date(fromCreatedDate);
            toCreatedDate = new Date(toCreatedDate);
            var diffInTime = toCreatedDate.getTime() - fromCreatedDate.getTime();
            var diffInDays = diffInTime / (1000 * 3600 * 24);

            if (diffInDays > 15) {
                document.getElementById('date-error').textContent =
                    'Khoảng thời gian không được lớn hơn 15 ngày.';
                return;
            }
                document.getElementById('date-error').textContent = '';
            dataTables.ajax.reload();
        });

        $('#btn-total-transaction').click(function(e) {
            e.preventDefault();
            $('#loading-overlay').removeClass('d-none');
            var partner = $('#search-transaction [name="partner"]').val();
            var from_date = $('#search-transaction [name="from_date"]').val();
            var to_date = $('#search-transaction [name="to_date"]').val();
            var type = $('#search-transaction [name="type"]').val();
            var transaction_type = $('#search-transaction [name="transaction_type"]').val();
            if (from_date > to_date) {
                    document.getElementById('date-error').textContent =
                        'Ngày bắt đầu phải nhỏ hơn hoặc bằng ngày kết thúc.';
                        $('#loading-overlay').addClass('d-none');
                    return;
                }
                var fromCreatedDate = new Date(from_date);
                var toCreatedDate = new Date(to_date);
                var diffInTime = toCreatedDate.getTime() - fromCreatedDate.getTime();
                var diffInDays = diffInTime / (1000 * 3600 * 24);

                if (diffInDays > 1) {
                    document.getElementById('date-error').textContent =
                        'Khoảng thời gian không được lớn hơn 1 ngày.';
                        $('#loading-overlay').addClass('d-none');
                    return;
                }
                document.getElementById('date-error').textContent = '';
            $.ajax({
                url: '{{ route('app.transaction.totalAmountTransaction') }}',
                type: 'GET',
                data: {
                    partner: partner,
                    from_date: from_date,
                    to_date: to_date,
                    type: type,
                    transaction_type: transaction_type
                },
                success: function(response) {
                    $('#loading-overlay').addClass('d-none');
                    $('#totalAmount').text(numberFormat(response.totalAmount));
                    $('#transactionTotalModal').modal('show');
                },
                error: function() {
                    toastr.error('Đã xảy ra lỗi khi lấy dữ liệu tổng tiền giao dịch.');
                }
            });
        });
    </script>
@endsection

@section('styles')
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.7/css/jquery.dataTables.min.css">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/toastr.js/latest/toastr.min.css">
    <style>
        td {
            word-wrap: break-word;
            overflow: hidden;
            white-space: nowrap;
        }

        table tbody {
            {{ $tableBodyStyle }}
        }
        #loading-overlay {
            display: flex;
            align-items: center;
            justify-content: center;
            position: fixed;
            top: 0;
            left: 0;
            width: 100%;
            height: 100%;
            background-color: rgba(0, 0, 0, 0.5);
            z-index: 9999;
        }
        #loading-overlay .spinner-border {
            width: 4rem;
            height: 4rem;
            margin-bottom: 10px;
        }

        #loading-overlay .loading-text {
            font-size: 18px;
            color: #fff;
        }

    </style>
@endsection