{:tpl head}
<script language="javascript">
function selecttables(obj,val){
  switch(val){
    case "all":
          for(var i=0;i<obj.length;i++){
              obj[i].checked=true;
          }
          document.all.checkall.checked=true;
          break;
    case "other":
          for(var i=0;i<obj.length;i++){
              if(obj[i].value.indexOf("{:$tablepre}"))obj[i].checked=true;
              else obj[i].checked=false;
          }
          document.all.checkall.checked=false;
          break;
    default:
          for(var i=0;i<obj.length;i++){
              if(obj[i].value.indexOf("{:$tablepre}"))obj[i].checked=false;
              else obj[i].checked=true;
          }
          document.all.checkall.checked=false;
          break;
 }
}
function backtype(obj){
   var flag=false;
   if(obj.checked)flag=true;
   obj.form.backjxcms.checked=false;
   obj.form.backother.checked=false;
   obj.form.backall.checked=false;
   obj.checked=flag;
   selecttables(obj.form.tables,obj.value);
}
</script>

<table cellpadding="0" cellspacing="1" class="table_list">
 <caption>数据库管理</caption>
  <tr>
   <td>
    <strong>管理选项：</strong>
    <a href="?file=data&action=export">数据库备份</a> |
    <a href="?file=data&action=import">数据库恢复</a> |
    <a href="?file=data&action=query">执行SQL语句</a>
   </td>
  </tr>
</table>
{:if $action == 'export'}
<table cellpadding="0" cellspacing="1" class="table_list">
 <caption>数据库备份</caption>
  <form method="post" name="myform" action="">
  <input type="hidden" name="selids" value="" />
  <tr align="center">
   <th width="20%"><input name="checkall" type="checkbox" onclick="checkorno(this,this.form.tables)" checked="checked" /></th>
   <th width="40%">数据库表</th>
   <th width="10%">记录条数</th>
   <th width="15%">大小 [共{:$totalsize}M]</th>
   <th width="15%">多余</th>
  </tr>
  {:loop $table $v}
  <tr>
   <td class="align_c"><input type="checkbox" id="tables" name="tables" value="{:$v['name']}" checked></td>
   <td>{:$v['name']}</td>
   <td>{:$v['row']}</td>
   <td>{:$v['size']}K</td>
   <td>{:$v['free']}</td>
  </tr>
  {:/loop}
  <tr>
    <td colspan="5" align="center">分卷备份设置</td>
  </tr>
    <tr>
   <td class="align_c">快速选择</td>
   <td colspan="4"><input type="checkbox" name="backjxcms" value="{:$tablepre}" onClick="backtype(this)">本系统数据({:$tablepre}) <input type="checkbox" name="backother" value="other" onClick="backtype(this)">其他数据(other) <input type="checkbox" name="backall" value="all" onClick="backtype(this)">全部数据(all)</td>
  </tr>
  <tr>
   <td class="align_c">分卷长度</td>
   <td colspan="4"><input type="text" name="sizelimit" value="2048" size="10"> K</td>
  </tr>
  <tr>
   <td class="align_c">文件名称</td>
   <td colspan="4"><input type="text" name="backname" value="{:$tablepre}bak" size="20"> 以名称+日期+4位随机数+分卷号保存</td>
  </tr>
  <tr>
   <td colspan="5" class="align_c">
    <button name="select1" onclick="selAll(this.form.tables)" type="button">全选</button>
    <button name="select2" onclick="noSelAll(this.form.tables)" type="button">反选</button>
    <button type="button" name="sbbf" onclick="subform(this.form,this.form.tables,'?file=data&action=_export','')">备份数据</button>
    <button type="button" name="repair" onclick="subform(this.form,this.form.tables,'?file=data&action=repair&operation=repair','')">修复数据表</button>
    <button type="button" name="optimize" onclick="subform(this.form,this.form.tables,'?file=data&action=repair&operation=optimize','')">优化数据表</button>
   </td>
  </tr>
  </form>
</table>
{:elseif $action == 'import'}
<table cellpadding="0" cellspacing="1" class="table_list">
 <caption>已备份的SQL文件</caption>
 <form method="post" name="myform" action="?file=data&action=del">
 <tr align="center">
  <th width="30%">文件名</th>
  <th width="15%">文件大小</th>
  <th width="20%">备份时间</th>
  <th width="15%">卷号</th>
  <th width="20%">操作</th>
 </tr>
 {:loop $infos $info}
 <tr align="center">
  <td>&nbsp;<a href="./data/{:$info['filename']}">{:$info['filename']}</a></td>
  <td>{:$info['filesize']}M</td>
  <td>{:$info['maketime']}</td>
  <td>{:$info['number']}</td>
  <td>
   <a href="?file=data&action=_import&pre={:$info['pre']}">导入</a> |
   <a href="?file=data&action=del&pre={:$info['pre']}">删除</a> |
   <a href="?file=data&action=down&filename={:$info['file']}">下载</a></td>
  </tr>
  {:/loop}
  </form>
</table>

<table cellpadding="0" cellspacing="1" class="table_list">
 <caption>上传数据库备份文件</caption>
 <form name="upload" method="post" action="?file=data&action=uploadsql" enctype="multipart/form-data">
 <tr>
  <td align="center">
  上传SQL文件：
  <input name="uploadfile" type="file" size="25">
  <input type="hidden" name="max_file_size" value="4096000">
  <button type="submit" name="dosubmit">上传</button>
  </td>
 </tr>
 </form>
</table>
{:elseif $action == 'query'}
<table cellpadding="0" cellspacing="1" class="table_list">
 <caption>执行SQL</caption>
 <form method="post" name="myform" action="?file=data&action=_query">
 <tr>
  <td class="align_c">请把要执行的SQL语句粘贴到下面的文本框</td>
 </tr>
 <tr> 
  <td class="align_c"><textarea name="sql" cols="90" rows="16"></textarea></td>
 </tr>
 <tr>
  <td class="align_c"><button type="submit" name="dosubmit">执行SQL</button></td>
 </tr>
 </form>
</table>

<table cellpadding="0" cellspacing="1" class="table_list">
 <caption>上传SQL文件并立即执行</caption>
 <form name="upload" method="post" action="?file=data&action=_query&&operation=file" enctype="multipart/form-data">
 <tr>
  <td class="align_c">
  上传SQL文件：
  <input name="uploadfile" type="file" size="25">
  <input type="hidden" name="max_file_size" value="4096000">
  <button type="submit" name="dosubmit">上传并执行</button>
  </td>
 </tr>
 </form>
</table>
{:/if}
{:tpl foot}