database.html
4.42 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
{include file="common/head"/}
<div class="admin-main layui-anim layui-anim-upbit">
<fieldset class="layui-elem-field layui-field-title">
<legend>数据{:lang('list')}</legend>
</fieldset>
<blockquote class="layui-elem-quote">
数据库中共有<i class="count"></i>张表，共计<i class="size"></i>
<a href="javascript:void(0)" id="backUp" class="layui-btn layui-btn-sm pull-right">备份</a>
<a href="javascript:void(0)" id="optimize" class="layui-btn layui-btn-sm pull-right layui-btn-normal">优化</a>
<a href="javascript:void(0)" id="repair" class="layui-btn layui-btn-sm pull-right layui-btn-warm">修复</a>
</blockquote>
<table class="layui-table" id="list" lay-filter="list"></table>
</div>
{include file="common/foot"/}
<script type="text/html" id="size">
{{d.size}}
</script>
<script>
layui.use(['table','util'], function() {
var table = layui.table, $ = layui.jquery,util = layui.util;
util.fixbar();
var tableIn = table.render({
id: 'database',
elem: '#list',
url: '{:url("database")}',
method: 'post',
cols: [[
{checkbox:true,fixed: true},
{field: 'name', title: '数据库表', width: 150, fixed: true,sort: true},
{field: 'rows', title: '记录条数', width: 150,sort: true},
{field: 'size', title: '占用空间', width: 150,templet:'#size',sort: true},
{field: 'engine', title: '类型', width: 110,sort: true},
{field: 'collation', title: '编码', width: 150,sort: true},
{field: 'create_time', title: '创建时间', width: 180,sort: true},
{field: 'comment', title: '说明', width: 180},
]],
done: function(res, curr, count){
$('.count').html(res.tableNum);
$('.size').html(res.total);
}
});
$('#backUp').click(function(){
var obj = $(this);
var checkStatus = table.checkStatus('database'); //test即为参数id设定的值
var a = [];
$(checkStatus.data).each(function(i,o){
a.push(o.name);
});
obj.addClass('layui-btn-disabled');
obj.html('备份进行中...');
$.post("{:url('database/backup')}",{tables:a},function(data){
if(data.code==1){
layer.msg(data.msg,{time:1000,icon:1},function(){
tableIn.reload();
});
}else{
layer.msg(data.msg,{time:1000,icon:2});
}
obj.removeClass('layui-btn-disabled');
obj.html('备份');
});
});
$('#optimize').click(function(){
var obj = $(this);
var checkStatus = table.checkStatus('database'); //test即为参数id设定的值
var a = [];
$(checkStatus.data).each(function(i,o){
a.push(o.name);
});
obj.addClass('layui-btn-disabled');
obj.html('优化进行中...');
$.post("{:url('database/optimize')}",{tables:a},function(data){
if(data.code==1){
layer.msg(data.msg,{time:1000,icon:1},function(){
tableIn.reload();
});
}else{
layer.msg(data.msg,{time:1000,icon:2});
}
obj.removeClass('layui-btn-disabled');
obj.html('优化');
});
});
$('#repair').click(function(){
var obj = $(this);
var checkStatus = table.checkStatus('database'); //test即为参数id设定的值
var a = [];
$(checkStatus.data).each(function(i,o){
a.push(o.name);
});
obj.addClass('layui-btn-disabled');
obj.html('修复进行中...');
$.post("{:url('database/repair')}",{tables:a},function(data){
if(data.code==1){
layer.msg(data.msg,{time:1000,icon:1},function(){
tableIn.reload();
});
}else{
layer.msg(data.msg,{time:1000,icon:2});
}
obj.removeClass('layui-btn-disabled');
obj.html('修复');
});
})
});
</script>