better-staridc-MNBT
1<?php mnbt_theme_include('head'); ?>
2<div class="container-fluid p-t-15">
3
4 <div class="row">
5 <div class="col-lg-12">
6 <div class="card">
7 <div class="card-toolbar d-flex flex-column flex-md-row">
8 <div class="toolbar-btn-action">
9 <i class="mdi mdi-plus btn btn-primary m-r-5" onclick="databaseadd(id='<?php echo $hxd; ?>')">备份数据库</i>
10 <i class="mdi mdi-block-helper btn btn-warning m-r-5" onclick="Delalldatabase()">删除数据库所有数据</i>
11 </div>
12 </div>
13 <div class="card-body">
14
15 <div class="table-responsive">
16 <table class="table table-bordered">
17 <thead>
18 <tr>
19 <th>
20 <div class="custom-control custom-checkbox">
21 <input type="checkbox" class="custom-control-input" id="check-all">
22 <label class="custom-control-label" for="check-all"></label>
23 </div>
24 </th>
25 <th>备份名称</th>
26 <th>备份时间</th>
27 <th>备份大小</th>
28 <th>操作对象</th>
29 <th>操作</th>
30 </tr>
31 </thead>
32 <tbody>
33 <?php
34 foreach ($bf_data as $item) {
35 $backupFilenameJson = htmlspecialchars(json_encode((string)$item['filename'], JSON_UNESCAPED_UNICODE | JSON_HEX_APOS | JSON_HEX_QUOT), ENT_QUOTES, 'UTF-8');
36 // 在这里处理每个数组元素
37 //echo "ID: " . $item['id'] . "<br>";
38 //echo "备份名称: " . $item['name'] . "<br>";
39 //echo "备份时间：" .$item['addtime']."<br>";
40 //echo "备份大小：" .$item['size'] / (1024 * 1024)."MB<br>";
41 //echo "备份大小：" .$item['ps'] ."<br>";
42 ?>
43 <tr>
44 <td>
45 <div class="custom-control custom-checkbox">
46 <input type="checkbox" class="custom-control-input ids" name="ids[]" value="1" id="ids-1">
47 <label class="custom-control-label" for="ids-1"></label>
48 </div>
49 </td>
50 <td><?php echo $item['name']; ?></td>
51 <td><?php echo $item['addtime']; ?></td>
52 <td><?php echo $item['size'] / (1024 * 1024); ?>MB</td>
53
54 <td><?php echo $item['ps']; ?></td>
55 <td>
56 <div class="btn-group">
57 <a class="btn btn-xs btn-default" title="恢复数据" data-toggle="tooltip" onclick="databaserestore(user='<?php echo $user; ?>',filename='<?php echo $item['filename']; ?>')" data-original-title="恢复数据"><i class="mdi mdi-cloud-check"></i></a>
58 <a class="btn btn-xs btn-default" title="下载备份" data-toggle="tooltip" onclick="databasedownload(<?php echo $backupFilenameJson; ?>)" data-original-title="下载备份"><i class="mdi mdi-cloud-download-outline"></i></a>
59 <a class="btn btn-xs btn-default ajax-get confirm" title="点我就删除了" onclick="databasedel(id='<?php echo $item['id']; ?>')" data-toggle="tooltip" data-original-title="删除"><i class="mdi mdi-window-close"></i></a>
60 </div>
61 </td>
62 </tr>
63 <?php
64 }
65 ?>
66 </tbody>
67 </table>
68 </div>
69 <ul class="pagination">
70 <li class="page-item disabled"><span class="text-success">共<?php echo $count; ?>条数据</span></li>
71 <li class="page-item disabled"><span class="text-success">用户总备份次数</span></li>
72 <li class="page-item disabled"><span class="text-success">用户使用备份次数</span></li>
73 <li class="page-item disabled"><span class="text-success">用户剩余备份次数 </span></li>
74 </ul>
75
76 </div>
77 </div>
78 </div>
79</div>
80<script type="text/javascript">
81function databasedel(id)
82{
83 msloading('正在处理中，请稍后...'); // 加载显示
84 let data = {};
85 data["gn"] = "databasedel";
86 data["id"] = id;
87 $.post('./ajax.php', data, function (date) {
88 var jsoe= JSON.parse(date);
89 var qk= jsoe.code
90 if(qk == "删除成功")
91 {
92 msalert(1,'删除成功！将在两秒后刷新页面！',2000);
93 setTimeout(function()
94 {
95 window.location.href="./sqlgl.php";
96 },2000);
97 }
98 else
99 {
100 msalert(4, qk,2000);
101 setTimeout(function()
102 {
103 window.location.href="./sqlgl.php";
104 },2000);
105
106 }
107
108 })
109}
110function databaseadd(id)
111{
112 msloading('正在处理中，请稍后...'); // 加载显示
113 let data = {};
114 data["gn"] = "databaseadd";
115 data["id"] = id;
116 $.post('./ajax.php', data, function (date) {
117 var jsoe= JSON.parse(date);
118 var qk= jsoe.code
119 if(qk == "备份成功!")
120 {
121 msalert(1,'备份成功！将在两秒后刷新页面！',2000);
122 setTimeout(function()
123 {
124 window.location.href="./sqlgl.php";
125 },2000);
126 }
127 else
128 {
129 msalert(4, qk,2000);
130 setTimeout(function()
131 {
132 window.location.href="./sqlgl.php";
133 },2000);
134
135 }
136
137 })
138}
139function databasedownload(filename)
140{
141 msloading('正在获取下载链接，请稍候...');
142 let data = {};
143 data["gn"] = "databasedownload";
144 data["filename"] = filename;
145 $.post('./ajax.php', data, function (date) {
146 var jsoe;
147 try {
148 jsoe = JSON.parse(date);
149 } catch (e) {
150 if (typeof msloadingde === 'function') msloadingde();
151 msalert(4, '获取下载链接失败', 2000);
152 return;
153 }
154 if (typeof msloadingde === 'function') msloadingde();
155 if (jsoe.url) {
156 window.open(jsoe.url, '_blank');
157 } else {
158 msalert(4, jsoe.msg || jsoe.code || '获取下载链接失败', 2000);
159 }
160 })
161}
162function databaserestore(user,filename)
163{
164 msloading('正在处理中，请稍后...'); // 加载显示
165 let data = {};
166 data["gn"] = "databaserestore";
167 data["user"] = user;
168 data['filename'] = filename;
169 $.post('./ajax.php', data, function (date) {
170 var jsoe= JSON.parse(date);
171 var qk= jsoe.code
172 if(qk == "导入数据库成功!")
173 {
174 msalert(1,'导入数据库成功！将在两秒后刷新页面！',2000);
175 setTimeout(function()
176 {
177 window.location.href="./sqlgl.php";
178 },2000);
179 }
180 else
181 {
182 msalert(4, qk,2000);
183 setTimeout(function()
184 {
185 window.location.href="./sqlgl.php";
186 },2000);
187
188 }
189
190 })
191}
192function Delalldatabase()
193{
194 msloading('正在处理中，请稍后...'); // 加载显示
195 let data = {};
196 data["gn"] = "Delalldatabase";
197 $.post('./ajax.php', data, function (date) {
198 var jsoe= JSON.parse(date);
199 var qk= jsoe.code
200 if(qk == "删除成功")
201 {
202 msalert(1,'全部数据库都删除成功！将在两秒后刷新页面！',2000);
203 setTimeout(function()
204 {
205 window.location.href="./sqlgl.php";
206 },2000);
207 }
208 else
209 {
210 msalert(4, qk,2000);
211 setTimeout(function()
212 {
213 window.location.href="./sqlgl.php";
214 },2000);
215
216 }
217
218 })
219}
220</script>