{extend name="light/public" /}
{block name="title"}数据库备份{/block}
{block name="content"}
<div class="row">
    <div class="col-md-12">
        <div class="card">
            <div class="card-body">
                <div id="main">
                    <div class="table-responsive">
                        <form action="" method="post">
                            <table class="table">
                                <thead>
                                    <tr>
                                        <th colspan="2" style="border:0">
                                            备份列表
                                        </th>
                                    </tr>
                                    <tr>
                                        <th>
                                            文件名称
                                        </th>
                                        <th>
                                            文件大小
                                        </th>
                                        <th>
                                            备份时间
                                        </th>
                                        <th>
                                            操作
                                        </th>
                                    </tr>
                                </thead>
                                <tbody>
                                    {volist name="WebBackupList.data" id="sql"}
                                    <tr>
                                        <td>
                                            {$sql.name}
                                        </td>
                                        <td>
                                            {$sql.size}
                                        </td>
                                        <td>
                                            {$sql.addtime}
                                        </td>
                                        <td>
                                            <a href="{:url('vhost/index/Sqlback')}?down_back_sql={$sql.name}">
                                                下载
                                            </a>
                                            /
                                            <a href="javascript:sqlInputSql('{$sql.name}')">
                                                导入
                                            </a>
                                            /
                                            <a href="javascript:sqlBackDel({$sql.id})">
                                                删除
                                            </a>
                                        </td>
                                    </tr>
                                    {/volist}
                                    {if $countback<5}
                                    <tr>
                                        <td colspan="4">
                                            <a class="btn btn-warning" href="javascript:sqlBackInc()">
                                                备份
                                            </a>
                                        </td>
                                    </tr>
                                    {/if}
                                </tbody>
                            </table>
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
{/block}
{block name="publicjs"}
<script type="text/javascript" src="__STATIC__/vhost/js/artDialog.js"></script>
{/block}
{block name="script"}
<script type="text/javascript">
    function sqlBackInc(){
        layer.confirm('备份时间依照数据大小而定', {
          btn: ['备份','取消']
      }, function(){
          lightyear.loading('show');
          $.post('{:url("vhost/index/sqlBackInc")}',{to:'back'},function(res){
            lightyear.loading('hide');
            EchoMsg(res.msg,1);
        })
      }, function(index){
          layer.close(index);
      });
		
	}
	function sqlBackDel(id){
        layer.confirm('确定删除？', {
              btn: ['确定','取消']
            }, function(){
              lightyear.loading('show');
              $.post('{:url("vhost/index/sqlBackDel")}',{del:id},function(res){
                lightyear.loading('hide');
                EchoMsg(res.msg,1);
            })
            }, function(index){
              layer.close(index);
        });
		
	}
	function sqlBackDown(id){
		$.post('{:url("vhost/index/sqlBackDown")}',{down:id},function(res){
			EchoMsg(res.msg,1);
		})
	}
	function sqlInputSql(file){
        layer.confirm('数据库将被覆盖，继续吗?', {
          btn: ['确定','取消']
      }, function(){
          lightyear.loading('show');
          $.post('{:url("vhost/index/sqlInputSql")}',{file:file},function(res){
            lightyear.loading('hide');
            EchoMsg(res.msg,1);
        })
      }, function(index){
          layer.close(index);
      });
	}
</script>
{/block}