backups.php 3.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118
  1. <div class="row content-nav">
  2. <div class="col-xs-12">
  3. <ul>
  4. <li><a href="javascript:;"><i></i>&nbsp;数据管理</a></li>
  5. <li><a href="javascript:;">数据备份</a></li>
  6. </ul>
  7. </div>
  8. </div>
  9. <section class="content clearfix">
  10. <div class="layui-list-box">
  11. <table class="layui-hide" id="list-box" lay-filter="list-box"></table>
  12. </div>
  13. </section>
  14. <script type="text/html" id="list-toolbar">
  15. <div class="layui-btn-container">
  16. <button lay-event="backup" type="button" class="layui-btn layui-btn-sm layui-bg-red"><i class="layui-icon">&#xe631;</i> 备份数据</button>
  17. </div>
  18. </script>
  19. <script type="text/html" id="list-bar">
  20. <a class="layui-btn layui-btn-xs" lay-event="import">导入</a>
  21. <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">删除</a>
  22. </script>
  23. <script>
  24. layui.use(['table','form'], function () {
  25. var table = layui.table;
  26. var form = layui.form;
  27. table.render({
  28. elem: '#list-box'
  29. , url: '{:createUrl("backups")}'
  30. , toolbar: '#list-toolbar'
  31. , defaultToolbar: []
  32. , title: '数据表'
  33. , cols: [[
  34. {type: 'checkbox'}
  35. , {field: 'name', title: '名称'}
  36. , {field: 'time', title: '创建时间',width:180,align:'center'}
  37. , {fixed: 'right', align: 'center', title: '操作', toolbar: '#list-bar', width: 130}
  38. ]]
  39. , text: {
  40. none: '<div><i class="layui-icon">&#xe702;</i>暂无相关数据</div>'
  41. }
  42. , page: false
  43. , height: 'full-200'
  44. // ,limit:30
  45. });
  46. //头工具栏事件
  47. table.on('toolbar(list-box)', function (obj) {
  48. switch (obj.event) {
  49. case 'backup':
  50. layer.confirm('你确定要备份数据库吗?', function (index) {
  51. layer.close(index);
  52. var llll = layer.load(1, {
  53. shade: [0.3,'#000']
  54. });
  55. $.get('{:createUrl("backups")}',{
  56. type: "backup"
  57. },function(result){
  58. layer.close(llll);
  59. if(result.code){
  60. window.location.reload();
  61. }else{
  62. layer.msg(result.msg,{ icon : 2 });
  63. }
  64. },"json");
  65. });
  66. break;
  67. }
  68. });
  69. //监听行工具事件
  70. table.on('tool(list-box)', function (obj) {
  71. var data = obj.data;
  72. if (obj.event === 'del') {
  73. layer.confirm('你确定要删除吗?', function (index) {
  74. $.get('{:createUrl("delete")}',{
  75. file : data.name
  76. },function(result){
  77. layer.close(index);
  78. if(result.code){
  79. obj.del();
  80. }else{
  81. layer.msg(result.msg,{ icon : 2 });
  82. }
  83. },"json");
  84. });
  85. } else if (obj.event === 'import') {
  86. layer.confirm('你确定要还原数据吗,此操作将会删除现有数据?', function (index) {
  87. layer.close(index);
  88. var llll = layer.load(1, {
  89. shade: [0.3,'#000']
  90. });
  91. $.get('{:createUrl("import")}',{
  92. file : data.name
  93. },function(result){
  94. layer.close(llll);
  95. if(result.code){
  96. layer.msg(result.msg,{ icon : 1 });
  97. }else{
  98. layer.msg(result.msg,{ icon : 2 });
  99. }
  100. },"json");
  101. });
  102. }
  103. });
  104. });
  105. </script>