@extends('layouts.app') {{-- Include the layout --}}

@section('content')

@include('loader')

<style>
    .small-swal {
        width: 300px;
        font-size: 16px; 
    }
</style>

<div class="container">
    <div class="row justify-content-center">
        <input type='hidden' value="{{ $databaseName }}" id='databaseName'>
        <div class="col-md-8">
            <div class="card">
                <div class="card-header">Database Tables</div>
                <div class="card-body" style="overflow-y: auto; max-height: 70vh">
                    <table class="table table-bordered text-center table-sm">
                        <thead>
                            <tr>
                                <th>Sr.</th>
                                <th>Tables</th>
                                <th>Data Rows</th>
                                <td style="display:none">Reset</td>
                            </tr>
                        </thead>
                        <tbody>
                            @php
                            $i=0;
                            @endphp
                            @foreach($tablelist as $table)
                                <tr>
                                    <td>{{ ++$i }}</td>
                                    <td style="text-align:left !important">{{ $table['name'] }}</td>
                                    <td>{{ $table['rows'] }}</td>
                                    <td style="display:none"><button type="button" class="btn" title="Reset Table" onClick=""><i class="fa fa-refresh text-danger" aria-hidden="true"></i></button></td>
                                </tr>
                                
                            @endforeach
                        </tbody>
                        
                    </table>        
                </div>
                <div class="card-footer d-flex justify-content-end">
                    <button type="button" class="btn btn-danger" title="Reset All Tables" id="resetbtn">Reset All <i class="fa fa-refresh" aria-hidden="true"></i></button>
                </div>
            </div>    
            
        </div>
    </div>
</div>    


<script>



$('#resetbtn').on('click', function(event) {
    ResetTable();
});
    
function ResetTable_oldest()
{    
    var databaseName=$('#databaseName').val();
    var message='Are you sure to Reset '+databaseName+' Database?';


    Swal.fire({
        text: message,
        icon: 'warning',
        width: '300px',
        showCancelButton: true,
        confirmButtonColor: '#3085d6',
        cancelButtonColor: '#d33',
        confirmButtonText: 'Yes, reset it!'
    }).then((result) => {
        if (result.isConfirmed) {
            LoadingStart();
            
            $.ajax({
                type: 'PUT',
                url: 'resetTables',
                data: {},
                success: function(response) {
                    
                    LoadingStop();  
                    
                    Swal.fire({
                        icon: 'success',
                        title: 'Success',
                        text: response.message,
                        timer: 3000,
                        timerProgressBar: true,
                        customClass: {
                            popup: 'small-swal'
                        }
                    }).then(() => {
                        // Reload the page
                        window.location.reload();
                    });
                    
                },
                error: function(error) {
                    console.error('Error reseting the Tables', error);
                    LoadingStop();  
                }
            });
            
        } else {
       
        }
    });
    
    
}


function ResetTable() {
    var databaseName = $('#databaseName').val();
    var message = 'Are you sure to Reset ' + databaseName + ' Database?';

    Swal.fire({
        text: message,
        icon: 'warning',
        width: '300px',
        showCancelButton: true,
        confirmButtonColor: '#3085d6',
        cancelButtonColor: '#d33',
        confirmButtonText: 'Yes, reset it!'
    }).then((result) => {
        if (result.isConfirmed) {
            LoadingStart();

            // Create the backup
            $.ajax({
                type: 'GET',
                url: '{{ route("create-backup") }}', // Use named route
                success: function(data) {
                    if (data.success) {

                        // Proceed to download after backup creation
                        var fileName = data.fileName;

                        // Use the download route to fetch the file
                        //window.location.href = '{{ route("download-backup", ":fileName") }}'.replace(':fileName', fileName); // Use named route
                        
                        var iframe = document.createElement('iframe');
                        iframe.style.display = 'none'; // Hide the iframe
                        iframe.src = '{{ route("download-backup", ":fileName") }}'.replace(':fileName', fileName);
                        document.body.appendChild(iframe);

                        // After successful download, reset the tables
                        $.ajax({
                            type: 'PUT',
                            url: 'resetTables', // The URL for resetting tables
                            data: {},
                            success: function(response) {
                                LoadingStop();
                                
                                Swal.fire({
                                    icon: 'success',
                                    title: 'Success',
                                    text: response.message,
                                    timer: 3000,
                                    timerProgressBar: true,
                                    customClass: {
                                        popup: 'small-swal'
                                    }
                                }).then(() => {
                                    // Reload the page after resetting tables
                                    window.location.reload();
                                });
                            },
                            error: function(error) {
                                console.error('Error resetting the Tables', error);
                                LoadingStop();  
                            }
                        });
                    } else {
                        Swal.fire({
                            icon: 'error',
                            title: 'Error',
                            text: 'Failed to create backup.',
                            timer: 3000,
                            timerProgressBar: true,
                            customClass: {
                                popup: 'small-swal'
                            }
                        });
                    }
                },
                error: function(error) {
                    console.error('Error creating the backup', error);
                    LoadingStop();
                }
            });
        }
    });
}





</script>

@endsection