@extends('manager.layout.master')

@section('head')
    <style>
        .backup-tips { padding: 10px 15px; background: #FFF8E1; border: 1px solid #FFE082; border-radius: 3px; margin-bottom: 15px; color: #F57F17; line-height: 1.8; }
    </style>
@endsection

@section('body')
    <blockquote class="layui-elem-quote">数据库备份还原</blockquote>

    <div class="backup-tips">
        <i class="layui-icon" style="font-size:16px;">&#xe702;</i> 提示：还原操作会覆盖当前数据库所有数据，请谨慎操作！建议还原前先创建一个备份。
    </div>

    {{-- 工具栏 --}}
    <div class="my-btn-box">
        <span class="fl">
            <a class="layui-btn layui-btn-normal" id="btnBackup" onclick="doBackup()">
                <i class="layui-icon">&#xe67c;</i> 立即备份
            </a>
            <a class="layui-btn layui-btn-warm" id="btnRestore" onclick="doRestore()">
                <i class="layui-icon">&#xe65c;</i> 还原数据库
            </a>
            <a class="layui-btn layui-btn-normal" id="pageReload" title="刷新">
                <i class="layui-icon layui-icon-refresh-1"></i> 刷新
            </a>
        </span>
    </div>

    {{-- 表格 --}}
    <table class="layui-table" lay-skin="line">
        <thead>
            <tr>
                <th>备份文件名</th>
                <th width="120">文件大小</th>
                <th width="180">备份时间</th>
                <th width="200">操作</th>
            </tr>
        </thead>
        <tbody>
            @forelse($list as $vo)
                <tr>
                    <td>{{$vo['name']}}</td>
                    <td>{{$vo['size']}}</td>
                    <td>{{$vo['time']}}</td>
                    <td class="table-op-col">
                        <div class="btn-group">
                            <a class="layui-btn layui-btn-sm btn-icon btn-icon-view" title="下载" onclick="doDownload('{{$vo['name']}}')"><i class="layui-icon layui-icon-download-circle"></i></a>
                            <a class="layui-btn layui-btn-sm btn-icon btn-icon-toggle" title="还原" onclick="doRestoreOne('{{$vo['name']}}')"><i class="layui-icon layui-icon-refresh"></i></a>
                            <a class="layui-btn layui-btn-sm btn-icon btn-icon-del" title="删除" onclick="doDelete('{{$vo['name']}}')"><i class="layui-icon layui-icon-delete"></i></a>
                        </div>
                    </td>
                </tr>
            @empty
                <tr><td colspan="4" style="text-align:center;color:#999;">暂无备份文件</td></tr>
            @endforelse
        </tbody>
    </table>
@stop

@section('js')
    <script>
        // 创建备份
        function doBackup() {
            layer.confirm('确认备份当前数据库？', {btnAlign: 'c', icon: 3}, function () {
                var index = layer.load(2, {shade: [0.3, '#000']});
                $.ajax({
                    type: 'POST',
                    url: '{{route('dbBackupCreate')}}',
                    data: {_token: '{{csrf_token()}}'},
                    dataType: 'json',
                    success: function (data) {
                        layer.close(index);
                        if (data.status == 1) {
                            layer.msg(data.message, {icon: 1, time: 1500}, function () {
                                location.reload();
                            });
                        } else {
                            layer.msg(data.message, {icon: 0, time: 3000});
                        }
                    },
                    error: function () {
                        layer.close(index);
                        layer.msg('备份失败，请重试', {icon: 0, time: 1500});
                    }
                });
            });
        }

        // 还原指定备份
        function doRestoreOne(fileName) {
            layer.confirm('确认还原备份【' + fileName + '】？<br><span style="color:#FF5722;">⚠ 此操作会覆盖当前数据库所有数据！</span>', {
                btnAlign: 'c',
                icon: 3,
                title: '危险操作确认'
            }, function () {
                var index = layer.load(2, {shade: [0.3, '#000']});
                $.ajax({
                    type: 'POST',
                    url: '{{route('dbBackupRestore')}}',
                    data: {file: fileName, _token: '{{csrf_token()}}'},
                    dataType: 'json',
                    success: function (data) {
                        layer.close(index);
                        if (data.status == 1) {
                            layer.msg(data.message, {icon: 1, time: 2000});
                        } else {
                            layer.msg(data.message, {icon: 0, time: 4000});
                        }
                    },
                    error: function () {
                        layer.close(index);
                        layer.msg('还原失败，请重试', {icon: 0, time: 1500});
                    }
                });
            });
        }

        // 还原（选择备份文件）
        function doRestore() {
            // 如果没有备份文件，提示
            var files = [];
            $('table tbody tr').each(function () {
                var name = $(this).find('td').eq(1).text().trim();
                if (name) files.push(name);
            });
            if (files.length === 0) {
                layer.msg('暂无备份文件，请先创建备份', {icon: 0, time: 1500});
                return;
            }
            // 提示用户点击具体文件上的还原按钮
            layer.msg('请点击对应备份文件行的「还原」按钮进行操作', {icon: 0, time: 2000});
        }

        // 下载备份
        function doDownload(fileName) {
            window.location.href = '{{route('dbBackupDownload')}}?file=' + encodeURIComponent(fileName);
        }

        // 删除备份
        function doDelete(fileName) {
            layer.confirm('确认删除备份【' + fileName + '】？', {btnAlign: 'c', icon: 3}, function () {
                var index = layer.load(2);
                $.ajax({
                    type: 'POST',
                    url: '{{route('dbBackupDel')}}',
                    data: {file: fileName, _token: '{{csrf_token()}}'},
                    dataType: 'json',
                    success: function (data) {
                        layer.close(index);
                        if (data.status == 1) {
                            layer.msg(data.message, {icon: 1, time: 1500}, function () {
                                location.reload();
                            });
                        } else {
                            layer.msg(data.message, {icon: 0, time: 1500});
                        }
                    },
                    error: function () {
                        layer.close(index);
                        layer.msg('删除失败，请重试', {icon: 0, time: 1500});
                    }
                });
            });
        }
    </script>
@stop