lyfz_repos/铂金版源码/LYFZ.NationalMarketing/wzyx1364845147/app/admin/view/sql.html

<!-- inc:header -->
<div class="notice"><div class="p">
	<table width="100%" cellpadding="0" cellspacing="0">
	<tr>
		<td width="130px"><span class="lead">&nbsp;&raquo; 数据库管理</span></td>
		<td align="right"><!-- if($set_popedom) --><a href="{:site_url('phpoksql,baklist')}" class="button">已备份列表</a><!-- end -->&nbsp;</td>
	</tr>
	</table>
</div></div>

<div class="main">
<table width="100%" style="layout:fixed;" cellpadding="0" cellspacing="0">
<tr>
	<td class="t_sub" width="36px">&nbsp;</td>
	<td class="t_sub" width="100px">引挈</td>
	<td class="t_sub">数据表</td>
    <td class="t_sub" width="140px">更新时间</td>
	<td class="t_sub" width="80px">文件大小</td>
	<td class="t_sub" width="60px">碎片</td>
</tr>
<!-- run:$total_size = $data_fee = 0 -->
<!-- $rslist AS $key=>$value -->
<!-- run:$length = $value[Avg_row_length] + $value[Data_length] + $value[Index_length] + $value[Data_free] -->
<!-- run:$total_size += $length -->
<!-- run:$data_fee += $value[Data_free] -->
<tr class="tr_out" onMouseOver="over_tr(this)" onMouseOut="out_tr(this)">
	<td align="center" class="tc_left"><input type="checkbox" value="{:$value[Name]}" /></td>
	<td align="center" class="tc_right">{:$value[Engine]}</td>
	<td class="tc_right">&nbsp;{:$value[Name]} <!-- if($value[Comment]) --><span class="clue_on">{:$value[Comment]}</span><!-- end --></td>
	<td align="center" class="tc_right">&nbsp;{:$value[Update_time]}</td>
	<td align="center" class="tc_right">{:$length ? sys_numformat($length) : '0'}</td>
	<td align="center" class="tc_right">{:$value[Data_free] ? sys_numformat($value[Data_free]) : '0'}</td>
</tr>
<!-- end -->
<!-- if($set_popedom) -->
<tr class="tr_out">
	<td colspan="3" class="tc_left" height="26px">&nbsp;
		<input type="button" value="全选" onclick="select_all();" class="btn2">
		<input type="button" value="全不选" onclick="select_none();" class="btn3">
		<input type="button" value="反选" onclick="select_anti();" class="btn2">
		<select name="sql_option" id="sql_option">
			<option value="optimize_sql()">优化数据表</option>
			<option value="repair_sql()">修复数据表</option>
			<option value="backup_sql()">备份数据表</option>
		</select>
		<input type="button" value="执行" onclick="eval($('#sql_option').attr('value'));" class="btn2">
	</td>
	<td class="tc_right" colspan="3">&nbsp;总计：{:$total_size ? sys_numformat($total_size) : '0'} <!-- if($data_fee) --> 碎片：{:sys_numformat($data_fee)}<!-- end --></td>
</tr>
<!-- end -->
</table>
</div>

<!-- if($set_popedom) -->
<script type="text/javascript">
function optimize_sql()
{
	var id = join_checkbox();
	if(!id)
	{
		alert("请选择要操作的数据表");
		return false;
	}
	var url = base_url + base_func + "=optimize&id="+encode_utf8(id);
	direct(url);
}

function repair_sql()
{
	var id = join_checkbox();
	if(!id)
	{
		alert("请选择要操作的数据表");
		return false;
	}
	var url = base_url + base_func + "=repair&id="+encode_utf8(id);
	direct(url);
}

function backup_sql()
{
	var qu = confirm("确定要备份数据表吗？不选择要操作的表，系统将备份全部！");
	if(qu == "0")
	{
		return false;
	}
	var id = join_checkbox();
	if(!id)
	{
		id = "all";
	}
	var url = base_url + base_func + "=backup&id="+encode_utf8(id);
	direct(url);
}
</script>
<!-- end -->

<!-- inc:footer -->