<!DOCTYPE html>
<html>
	<head>
		<meta charset="<?php echo $cfg_soft_lang; ?>">
		<meta http-equiv="X-UA-Compatible" content="IE=Edge,chrome=1">
		<title>数据库维护</title>
		<link rel="stylesheet" href="../static/web/css/bootstrap.min.css">
		<link rel="stylesheet" href="../static/web/font/css/font-awesome.min.css">
		<link rel="stylesheet" href="../static/web/css/admin.css">
		<script src="../static/web/js/jquery.min.js"></script>
		<script src="../static/web/js/bootstrap.bundle.min.js"></script>
		<script src="js/main.js"></script>
		<script src="../static/web/js/webajax.js"></script>
		<script>
			var posLeft = 200;
			var posTop = 150;
			function LoadUrl(surl) {
				fetch("sys_data.php?" + surl).then(resp => {
					if (resp.ok) {
						return resp.text()
					}
					throw new Error('x');
				}).then((d) => {
					ShowMsg(d, {
						size: "modal-lg"
					});
				}).catch((error) => {
					ShowMsg("操作失败");
				});
			}
			//获得选中文件的数据表
			function getCheckboxItem() {
				var myform = document.form1;
				var allSel = "";
				if (myform.tables.value) return myform.tables.value;
				for (i = 0; i < myform.tables.length; i++) {
					if (myform.tables[i].checked) {
						if (allSel == "")
							allSel = myform.tables[i].value;
						else
							allSel = allSel + "," + myform.tables[i].value;
					}
				}
				return allSel;
			}
			//反选
			function ReSel() {
				var myform = document.form1;
				for (i = 0; i < myform.tables.length; i++) {
					if (myform.tables[i].checked) myform.tables[i].checked = false;
					else myform.tables[i].checked = true;
				}
			}
			//全选
			function SelAll() {
				var myform = document.form1;
				for (i = 0; i < myform.tables.length; i++) {
					myform.tables[i].checked = true;
				}
			}
			//取消
			function NoneSel() {
				var myform = document.form1;
				for (i = 0; i < myform.tables.length; i++) {
					myform.tables[i].checked = false;
				}
			}
			function checkSubmit() {
				var myform = document.form1;
				myform.tablearr.value = getCheckboxItem();
				return true;
			}
		</script>
	</head>
	<body>
		<table width="99%" align="center" cellpadding="3" cellspacing="1" class="table maintable mt-3 mb-3">
			<tr>
				<td height="26" colspan="8" background="../static/web/img/tbg.gif">
					<table width="96%" cellspacing="1" cellpadding="1" class="table table-borderless">
						<tr>
							<td width="30%" style="padding-left:10px">数据库管理</td>
							<td width="70%" align="right">
								<a href="sys_data_revert.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>
				</td>
			</tr>
			<form name="form1" onSubmit="checkSubmit()" action="sys_data_done.php?dopost=bak" method="post" target="stafrm">
				<input type="hidden" name="tablearr" value="">
				<tr>
					<td height="26" colspan="8">系统默认表：</td>
				</tr>
				<tr bgcolor="#F8FCF1" align="center">
					<td width="5%" height="26">选择</td>
					<td width="20%">表名</td>
					<td width="8%">记录数</td>
					<td width="17%">操作</td>
					<td width="5%">选择</td>
					<td width="20%">表名</td>
					<td width="8%">记录数</td>
					<td width="17%">操作</td>
				</tr>
				<?php  
				for($i=0; isset($dedeSysTables[$i]); $i++)
				{ 
					$t = $dedeSysTables[$i];
					echo "<tr align='center' >";
				?>
				<td height="26"><input type="checkbox" name="tables" value="<?php echo $t; ?>" class="np" checked />
				</td>
				<td><?php echo $t; ?></td>
				<td><?php echo TjCount($t,$dsql); ?></td>
				<td>
					<a href="javascript:;" onClick="LoadUrl('dopost=opimize&tablename=<?php echo $t; ?>');" class="btn btn-success btn-sm">优化</a>
					<a href="javascript:;" onClick="LoadUrl('dopost=repair&tablename=<?php echo $t; ?>');" class="btn btn-success btn-sm">修复</a>
					<a href="javascript:;" onClick="LoadUrl('dopost=viewinfo&tablename=<?php echo $t; ?>');" class="btn btn-success btn-sm">结构</a>
				</td>
				<?php
				$i++;
				if(isset($dedeSysTables[$i])) {
					$t = $dedeSysTables[$i];
				?>
				<td><input type="checkbox" name="tables" value="<?php echo $t; ?>" class="np" checked /></td>
				<td><?php echo $t; ?></td>
				<td><?php echo TjCount($t,$dsql); ?></td>
				<td>
					<a href="javascript:;" onClick="LoadUrl('dopost=opimize&tablename=<?php echo $t; ?>');" class="btn btn-success btn-sm">优化</a>
					<a href="javascript:;" onClick="LoadUrl('dopost=repair&tablename=<?php echo $t; ?>');"  class="btn btn-success btn-sm">修复</a>
					<a href="javascript:;" onClick="LoadUrl('dopost=viewinfo&tablename=<?php echo $t; ?>');" class="btn btn-success btn-sm">结构</a>
				</td>
				<?php
				} else {
					echo "<td></td><td></td><td></td><td></td>";
				}
				echo "</tr>";
				}
				?>
				<tr>
					<td height="26" colspan="8">其它数据表：</td>
				</tr>
				<tr bgcolor="#F8FCF1" align="center">
					<td width="5%" height="26">选择</td>
					<td width="20%">表名</td>
					<td width="8%">记录数</td>
					<td width="17%">操作</td>
					<td width="5%">选择</td>
					<td width="20%">表名</td>
					<td width="8%">记录数</td>
					<td width="17%">操作</td>
				</tr>
				<?php  
				for($i=0; isset($otherTables[$i]); $i++)
				{ 
					$t = $otherTables[$i];
					echo "<tr align='center'>";
				?>
				<td height="26"><input type="checkbox" name="tables" value="<?php echo $t; ?>" class="np"></td>
				<td><?php echo $t; ?></td>
				<td><?php echo TjCount($t,$dsql); ?></td>
				<td>
					<a href="javascript:;" onClick="LoadUrl('dopost=opimize&tablename=<?php echo $t; ?>');" class="btn btn-success btn-sm">优化</a>
					<a href="javascript:;" onClick="LoadUrl('dopost=repair&tablename=<?php echo $t; ?>');" class="btn btn-success btn-sm">修复</a>
					<a href="javascript:;" onClick="LoadUrl('dopost=viewinfo&tablename=<?php echo $t; ?>');" class="btn btn-success btn-sm">结构</a>
				</td>
				<?php
				$i++;
				if(isset($otherTables[$i])) {
					$t = $otherTables[$i];
				?>
				<td><input type="checkbox" name="tables" value="<?php echo $t; ?>" class="np"></td>
				<td><?php echo $t; ?></td>
				<td><?php echo TjCount($t,$dsql); ?></td>
				<td>
					<a href="javascript:;" onClick="LoadUrl('dopost=opimize&tablename=<?php echo $t; ?>');" class="btn btn-success btn-sm">优化</a>
					<a href="javascript:;" onClick="LoadUrl('dopost=repair&tablename=<?php echo $t; ?>');" class="btn btn-success btn-sm">修复</a>
					<a href="javascript:;" onClick="LoadUrl('dopost=viewinfo&tablename=<?php echo $t; ?>');" class="btn btn-success btn-sm">结构</a>
				</td>
				<?php
				} else {
					echo "<td></td><td></td><td></td><td></td>";
				}
				echo "</tr>";
				}
				?>
				<tr>
					<td height="26" colspan="8">
						分卷大小：<input name="fsize" type="text" id="fsize" value="2048" style="width:60px"> K
						<input name="isstruct" type="checkbox" class="np" id="isstruct" value="1" checked="1"> 备份结构
						<?php if(@function_exists('gzcompress') && false) { ?>
						<input name="iszip" type="checkbox" class="np" id="iszip" value="1" checked="1"> 完成后压缩成ZIP
						<?php } ?>
						<button name="b1" type="button" id="b1" class="btn btn-success btn-sm" onClick="SelAll()">全选</button>
						<button name="b2" type="button" id="b2" class="btn btn-success btn-sm"  onClick="ReSel()">反选</button>
						<button name="b3" type="button" id="b3" class="btn btn-success btn-sm"  onClick="NoneSel()">取消</button>
						<button type="submit" name="Submit" class="btn btn-success btn-sm">提交</button>
					</td>
				</tr>
			</form>
			<tr>
				<td height="26" colspan="8">结果：</td>
			</tr>
			<tr>
				<td height="360" colspan="8">
					<iframe name="stafrm" frameborder="0" id="stafrm" width="100%" height="100%"></iframe>
				</td>
			</tr>
		</table>
	</body>
</html>