@extends('layouts.app')

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

@section('transaction_history')
    active
@endsection

@section('section.header')
    <section class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                    <h1>{{ __('transaction_history') }}</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">{{ __('transaction_history') }}</li>
                    </ol>
                </div>
            </div>
        </div><!-- /.container-fluid -->
    </section>
@endsection

@section('section.content')
    <section class="content">
        <div class="card">
            <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>
            @php
                $tableBodyStyle = $isDemoAccount ? 'display: none;' : '';
            @endphp
            <div class="card-body">
            <form class="row" id="search-transaction-history">
                    @csrf
                    <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="bank_type" class="form-control">
                                    <option value="">{{ __('select') }}</option>
                                    @foreach (\App\Models\Bank\Bank::all() as $item)
                                        <option value="{{ $item->display_name }}">{{ $item->display_name }}</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">{{ __('account') }}</span>
                                </div>
                                <input type="text" class="form-control" name="bank_account" value=""
                                    placeholder="{{ __('Search accounts') }}">
                            </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 class="form-control" name="io">
                                    <option value="">{{ __('select') }}</option>
                                    <option value="1">{{ __('Receive money') }}</option>
                                    <option value="-1">{{ __('Transfer money') }}</option>
                                </select>
                            </div>
                        </div>
                    </div>
                    <div class="col-lg-5">
                        <div class="row">
                            <div class="col-sm-6 mb-3">
                                <div class="form-group">
                                    <div class="input-group mb-3">
                                        <div class="input-group-prepend">
                                            <span class="input-group-text">{{ __('from_date') }}</span>
                                        </div>
                                        <input type="datetime-local" class="form-control" name="from_date" id="from_create_date" value="{{ session('search-transaction-history.from_date', now()->format('Y-m-d') . 'T00:00') }}">
                                    </div>
                                </div>
                            </div>
                            <div class="col-sm-6 mb-3">
                                <div class="form-group">
                                    <div class="input-group mb-3">
                                        <div class="input-group-prepend">
                                            <span class="input-group-text">{{ __('to_date') }}</span>
                                        </div>
                                        <input type="datetime-local" class="form-control" name="to_date" id="to_create_date" value="{{ session('search-transaction-history.to_date', now()->format('Y-m-d', strtotime('+1 day')) . 'T23:59:59') }}">
                                    </div>
                                </div>
                            </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">{{ __('CashIn') }}</span>
                                </div>
                                <select class="form-control" name="cash_in_id">
                                    <option value="">{{ __('select') }}</option>
                                    <option value="1">{{ __('Order matching') }}</option>
                                    <option value="-1">{{ __('Order not matched') }}</option>
                                </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">{{ __('content') }}</span>
                                </div>
                                <input type="text" class="form-control" name="content"
                                    placeholder="{{ __('Find content') }}">
                            </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 code') }}</span>
                                </div>
                                <input type="text" class="form-control" name="transaction_id" value="{{ session('search-transaction-history.transaction_id')}}"
                                    placeholder="{{ __('Enter transaction code') }}">
                            </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-report-total-amount">{{ __('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">{{ __('transaction_history') }}</h3>
                <div class="card-tools">
                    <a class="btn btn-sm btn-primary" id="btn-statistics">{{ __('Report today') }}</a>
                    <a class="btn btn-sm btn-primary" id="export-transaction-history" href="javascript:void(0)"><i
                            class="fas fa-file-excel"></i>{{ __('Export files') }}</a>
                </div>
            </div>
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table table-bordered table-striped" id="listTransactionHistories">
                        <thead style="text-align: center">
                            <tr>
                                <th>{{ __('ID') }}</th>
                                <th>{{ __('type') }}</th>
                                <th>{{ __('account') }}</th>
                                <th>{{ __('amount') }}</th>
                                <th>{{ __('Sending/receiving account') }}</th>
                                <th>{{ __('fee') }}</th>
                                <th>{{ __('Số dư trước GD') }}</th>
                                <th>{{ __('Số dư sau GD') }}</th>
                                <th>{{ __('Transaction code') }}</th>
                                <th>{{ __('transaction_type') }}</th>
                                <th>{{ __('status') }}</th>
                                <th>{{ __('content') }}</th>
                                <th>{{ __('CashIn') }}</th>
                                <th>{{ __('CashOut') }}</th>
                                <th>{{ __('time') }}</th>
                                <th>{{ __('Creation time') }}</th>
                                <th>{{ __('operation') }}</th>
                            </tr>
                        </thead>
                        <tbody></tbody>
            </table>
                </div>
            </div>

            <div class="modal fade" id="transactionHistoryStatisticsModal" tabindex="-1"
                aria-labelledby="transactionHistoryStatisticsModalLabel" aria-hidden="true">
                <div class="modal-dialog">
                    <div class="modal-content">
                        <div class="modal-header">
                            <h5 class="modal-title text-center" id="transactionHistoryStatisticsModalLabel">
                                {{ __('Báo cáo số liệu hôm nay') }}</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>
                                                <td>{{ __('Số giao dịch') }}</td>
                                                <td><span id="countTransactionsToday"></span></td>
                                            </tr>
                                            <tr>
                                                <td>{{ __('Tổng tiền gửi') }}</td>
                                                <td><span id="totalAmountSent"></span></td>
                                            </tr>
                                            <tr>
                                                <td>{{ __('Tổng tiền nhận') }}</td>
                                                <td><span id="totalAmountReceived"></span></td>
                                            </tr>
                                            <tr>
                                                <td>{{ __('Tổng tiền phí') }}</td>
                                                <td><span id="totalAmountFee"></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 class="modal fade" id="reportTotalAmountModal" tabindex="-1"
                aria-labelledby="reportTotalAmountModalLabel" aria-hidden="true">
                <div class="modal-dialog">
                    <div class="modal-content">
                        <div class="modal-header">
                            <h5 class="modal-title text-center" id="reportTotalAmountModalLabel">
                                {{ __('Báo cáo') }}</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>
                                                <td>{{ __('Số giao dịch') }}</td>
                                                <td><span id="countTotalTransaction"></span></td>
                                            </tr>
                                            <tr id="momoSection" style="display: none;">
                                                <td>{{ __('Tổng tiền đã chuyển ngân hàng') }}</td>
                                                <td><span id="totalTransferred"></span></td>
                                            </tr>
                                            <tr id="momoSection2" style="display: none;">
                                                <td>{{ __('Tổng tiền đã dồn tiền') }}</td>
                                                <td><span id="totalAmountAutoCombined"></span></td>
                                            </tr>
                                            <tr id="momoSection3" style="display: none;">
                                                <td>{{ __('Tổng phí') }}</td>
                                                <td><span id="totalFee"></span></td>
                                            </tr>
                                            <tr style="background-color: #cad2db">
                                                <td>{{ __('Tổng tiền') }}</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 class="modal fade" id="add-data-modal">
                <div class="modal-dialog">
                    <div class="modal-content">
                        <div class="modal-header">
                            <h4 class="modal-title">{{ __('Nhập dữ liệu') }}</h4>
                            <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="col-lg-12">
                                <form class="row" method="POST" action="" id="add-data-form">
                                    @csrf
                                    <div class="input-group mb-3">
                                        <input type="text" name="cashout_id" class="form-control"
                                            placeholder="Nhập Cashout ID">
                                        <div class="input-group-append">
                                            <div class="input-group-text">
                                                <i class="fa-solid fa-id-card"></i>
                                            </div>
                                        </div>
                                        @error('secret_code')
                                            <span class="text-danger">* {{ $message }}</span>
                                        @enderror
                                    </div>
                                </form>
                            </div>
                        </div>
                        <div class="modal-footer justify-content-between">
                            <button type="button" class="btn btn-outline-danger" data-bs-dismiss="modal">Close</button>
                            <button type="submit" class="btn btn-outline-success"
                                id="confirmFormData">{{ __('Xác nhận') }}</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-history').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.exportTransactionHistory') }}",
                data: $('#search-transaction-history').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>
        jQuery(document).ready(function($) {
            var dataTable;
            dataTable = $('#listTransactionHistories').DataTable({
                dom: 'lifrtp',
                processing: true,
                serverSide: true,
                'pageLength': 50,
                'pagingType': 'input',
                'aLengthMenu': [
                    [50, 100, 200, -1],
                    [50, 100, 200, 'All']
                ],
                ajax: {
                    url: '{{ route('app.transaction_history.transactionHistoryData') }}',
                    type: 'GET',
                    data: function(d) {
                        d.bank_type = $('#search-transaction-history [name="bank_type"]').val();
                        d.bank_account = $('#search-transaction-history [name="bank_account"]').val();
                        d.from_date = $('#search-transaction-history [name="from_date"]').val();
                        d.to_date = $('#search-transaction-history [name="to_date"]').val();
                        d.io = $('#search-transaction-history [name="io"]').val();
                        d.cash_in_id = $('#search-transaction-history [name="cash_in_id"]').val();
                        d.content = $('#search-transaction-history [name="content"]').val();
                        d.transaction_id = $('#search-transaction-history [name="transaction_id"]').val();
                    },
                    error: function(xhr, status, error) {
                        if(status == "parsererror") {
                            window.location.href = '/auth/login';
                        }
                    }
                },
                columns: [{
                        data: 'id',
                        searchable: false
                    },
                    {
                        data: 'bank_type',
                        searchable: false
                    },
                    {
                        data: 'acc_no',
                        searchable: false
                    },
                    {
                        data: 'amount',
                        name: 'amount',
                        render: function(data, type, row) {
                            return numberFormat(data);
                        }
                    },
                    {
                        data: 'bank_account_target',
                        searchable: false
                    },
                    {
                        data: 'fee',
                        name: 'fee',
                        render: function(data, type, row) {
                            return numberFormat(data);
                        },
                        searchable: false
                    },
                    {
                        data: 'balance_before',
                        name: 'balance_before',
                        render: function(data, type, row) {
                            return numberFormat(data);
                        },
                        searchable: false
                    },
                    {
                        data: 'balance_after',
                        name: 'balance_after',
                        render: function(data, type, row) {
                            return numberFormat(data);
                        },
                        searchable: false
                    },
                    {
                        data: 'transaction_id',
                        className: 'text-center'
                    },
                    {
                        data: 'io',
                        className: 'text-center',
                        searchable: false
                    },
                    {
                        data: 'status',
                        className: 'text-center',
                        searchable: false
                    },
                    {
                        data: 'content',
                        className: 'text-center'
                    },
                    {
                        data: 'cash_in_id'
                    },
                    {
                        data: 'cash_out_id'
                    },
                    {
                        data: 'trans_time',
                        searchable: false
                    },
                    {
                        data: 'created_at',
                        searchable: false,
                        render: function(data, type, row) {
                            return formatTime(data);
                        },
                    },
                    {
                        data: 'actions',
                        orderable: false,
                        searchable: false,
                        className: 'text-center',
                    }
                ],
                order: [
                    [14, 'desc']
                ],
            });

            $(document).on('submit', '#search-transaction-history', 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 > 3) {
                    document.getElementById('date-error').textContent =
                        'Khoảng thời gian không được lớn hơn 3 ngày.';
                    return;
                }
                document.getElementById('date-error').textContent = '';
                dataTable.ajax.reload();
            });

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

            $('#btn-statistics').click(function(e) {
                $.ajax({
                    url: '{{ route('app.transaction_history.statistics') }}',
                    type: 'GET',
                    success: function(response) {
                        $('#countTransactionsToday').text(numberFormat(response
                            .countTransactionsToday));
                        $('#totalAmountSent').text(numberFormat(response
                            .totalAmountSent));
                        $('#totalAmountReceived').text(numberFormat(response
                            .totalAmountReceived));
                        $('#totalAmountFee').text(numberFormat(response.totalAmountFee));
                        $('#transactionHistoryStatisticsModal').modal('show');
                    },
                    error: function() {
                        toastr.error('Đã xảy ra lỗi khi thống kê dữ liệu.');
                    }
                });
            });


            $('#btn-report-total-amount').click(function(e) {
                e.preventDefault();
                $('#loading-overlay').removeClass('d-none');
                var account = $('#search-transaction-history [name="bank_account"]').val();
                var io = $('#search-transaction-history [name="io"]').val();
                var from_date = $('#search-transaction-history [name="from_date"]').val();
                var to_date = $('#search-transaction-history [name="to_date"]').val();
                var bank_type = $('#search-transaction-history [name="bank_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_history.reportTotalAmount') }}',
                    type: 'GET',
                    data: {
                        account: account,
                        io: io,
                        from_date: from_date,
                        to_date: to_date,
                        bank_type: bank_type,
                    },
                    success: function(response) {
                        $('#countTotalTransaction').text(response.countTotalTransaction);
                        $('#totalAmount').text(numberFormat(response.totalAmount));
                        if(bank_type && bank_type == 'Momo') {
                            $('#totalTransferred').text(numberFormat(response.totalTransferred));
                            $('#totalAmountAutoCombined').text(numberFormat(response.totalAmountAutoCombined));
                            $('#totalFee').text(numberFormat(response.totalFee));
                            document.getElementById("momoSection").style.display = "table-row";
                            document.getElementById("momoSection2").style.display = "table-row";
                            document.getElementById("momoSection3").style.display = "table-row";
                        }
                        else {
                            document.getElementById("momoSection").style.display = "none";
                            document.getElementById("momoSection2").style.display = "none";
                            document.getElementById("momoSection3").style.display = "none";
                        }
                        $('#reportTotalAmountModal').modal('show');
                        $('#loading-overlay').addClass('d-none');
                    },
                    error: function() {
                        toastr.error('Đã xảy ra lỗi khi lấy dữ liệu.');
                        $('#loading-overlay').addClass('d-none');
                    }
                });
            });

            $(document).on('click', '.showAddDataModalBtn', function() {
                var accountId = $(this).data("account-id");
                $('#add-data-modal').data("account-id", accountId);
                $('#add-data-modal').modal('show');
            });

            $('#add-data-modal').on('toggle.bs.modal', function() {
                $('.showAddDataModalBtn').prop('')
            });

            $(document).on('click', 'button#confirmFormData', function() {
                var formData = $("#add-data-form").serialize();
                var accountId = $('#add-data-modal').data("account-id");
                $.ajax({
                    url: "/transaction-history/update-cashout-id/" + accountId,
                    type: "POST",
                    data: formData,
                    success: function(response) {
                        if (response.code == 1) {
                            $("#add-data-modal").modal("hide");
                            toastr.success(response.message);
                            $('#listTransactionHistories').DataTable().ajax.reload(null,
                                true);
                        } else {
                            toastr.error(response.message);
                        }
                    },
                    error: function() {
                        toastr.error('Thất bại',
                            'Có lỗi xảy ra trong quá trình gửi dữ liệu.');
                    }
                });
            });
        });

        function numberFormat(number) {
            return new Intl.NumberFormat('en-US').format(number);
        }

        function formatTime(isoTime) {
            try {
                const date = new Date(isoTime);
                const hours = date.getHours().toString().padStart(2, '0');
                const minutes = date.getMinutes().toString().padStart(2, '0');
                const seconds = date.getSeconds().toString().padStart(2, '0');
                const day = date.getDate().toString().padStart(2, '0');
                const month = (date.getMonth() + 1).toString().padStart(2, '0');
                const year = date.getFullYear();

                return ` ${hours}:${minutes}:${seconds} ${day}/${month}/${year}`;
            } catch (e) {}
            return null;
        }
    </script>
@endsection

@section('styles')
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/toastr.js/latest/toastr.min.css">
    <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>
        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