<!DOCTYPE html>
<html>
	<head>
		<meta charset="utf-8">
		<meta http-equiv="X-UA-Compatible" content="IE=Edge,chrome=1">
		<title>数据还原</title>
		<link rel="stylesheet" href="../static/web/font/css/font-awesome.min.css">
		<link rel="stylesheet" href="../static/web/css/bootstrap.min.css">
		<link rel="stylesheet" href="../static/web/css/admin.css">
	</head>
	<body>
		<table align="center" class="table maintable my-3">
			<tr>
				<td>
					<a href="sys_data.php" class="btn btn-success btn-sm">数据备份</a>
					<a href="sys_sql_query.php" class="btn btn-success btn-sm">SQL命令工具</a>
				</td>
			</tr>
		</table>
		<form name="form1" onSubmit="checkSubmit()" action="sys_data_done.php" method="post" target="stafrm">
			<input type="hidden" name="dopost" value="redat">
			<input type="hidden" name="bakfiles" value="">
			<table align="center" class="table maintable my-3">
				<tr>
					<td bgcolor="#f5f5f5" colspan="4">数据还原</td>
				</tr>
				<tr>
					<td colspan="4">发现的备份文件：<?php if (count($filelists)==0) echo " 没找到任何备份文件 ";?></td>
				</tr>
				<?php
				for ($i=0;$i<count($filelists);$i++)
				{
					echo "<tr align='center'>";
					$mtd = "<td width='10%'><input name='bakfile' id='bakfile' type='checkbox' value='".$filelists[$i]."' checked='1'></td><td width='40%'>{$filelists[$i]}</td>";
					echo $mtd;
					if (isset($filelists[$i+1])) {
						$i++;
						$mtd = "<td width='10%'><input name='bakfile' id='bakfile' type='checkbox' value='".$filelists[$i]."' checked='1'></td><td width='40%'>{$filelists[$i]}</td>";
						echo $mtd;
					} else {
						echo "<td></td><td></td>";
					}
					echo "</tr>";
				}
				?>
				<tr>
					<td colspan="4">
						<label><input name="structfile" type="checkbox" id="structfile" value="<?php echo $structfile?>" checked="1"> 还原表结构信息（<?php echo $structfile?>）</label>
						<label><input name="delfile" type="checkbox" id="delfile" value="1"> 还原后删除备份文件</label>
						<button name="b1" type="button" id="b1" onclick="SelAll()" class="btn btn-success btn-sm">全选</button>
						<button name="b2" type="button" id="b2" onclick="ReSel()" class="btn btn-success btn-sm">反选</button>
						<button name="b3" type="button" id="b3" onclick="NoneSel()" class="btn btn-success btn-sm">取消</button>
						<button type="submit" name="Submit" class="btn btn-success btn-sm">还原</button>
					</td>
				</tr>
				<tr>
					<td colspan="4">
						<div class="admin-win-iframe"><iframe name="stafrm" frameborder="0" id="stafrm" width="100%" height="100%"></iframe></div>
					</td>
				</tr>
			</table>
		</form>
		<script>
			//获得选中文件的数据表
			function getCheckboxItem() {
				var myform = document.form1;
				var allSel = "";
				if (myform.bakfile.value) return myform.bakfile.value;
				for (i = 0; i < myform.bakfile.length; i++) {
					if (myform.bakfile[i].checked) {
						if (allSel == "")
							allSel = myform.bakfile[i].value;
						else
							allSel = allSel + "," + myform.bakfile[i].value;
					}
				}
				return allSel;
			}
			//反选
			function ReSel() {
				var myform = document.form1;
				for (i = 0; i < myform.bakfile.length; i++) {
					if (myform.bakfile[i].checked) myform.bakfile[i].checked = false;
					else myform.bakfile[i].checked = true;
				}
			}
			//全选
			function SelAll() {
				var myform = document.form1;
				for (i = 0; i < myform.bakfile.length; i++) {
					myform.bakfile[i].checked = true;
				}
			}
			//取消
			function NoneSel() {
				var myform = document.form1;
				for (i = 0; i < myform.bakfile.length; i++) {
					myform.bakfile[i].checked = false;
				}
			}
			function checkSubmit() {
				var myform = document.form1;
				myform.bakfiles.value = getCheckboxItem();
				return true;
			}
		</script>
	</body>
</html>