{include file='common/head.html'}
<div class="layui-body">
    <div class="layui-tab layui-tab-brief" lay-filter="tab">
        <ul class="layui-tab-title">
            <li class="layui-this" lay-id="t1">数据转换</li>
            <li lay-id="t2">标签转换</li>
            <button type="submit" style="float:right;" name="" value="" onclick="return trunCateArchive('*','所有表');" class="layui-btn layui-btn-sm layui-btn-danger">全部重置</button>
        </ul>
        <div class="layui-tab-content">
            <div class="layui-tab-item layui-show">
                <div class="layui-form">
                    <input type="hidden" name="formcheck" value="{$formcheck}">
                    <blockquote class="layui-elem-quote">
                        <p>支持将织梦数据库转换导入到本程序数据库中，扩展字段为二次开发中新增的字段，正常情况下不需要填写。</p>
                    </blockquote>

                    <div class="layui-form-item">
                        <label class="layui-form-label">连接地址</label>
                        <div class="layui-input-inline">
                            <input type="text" name="host" id="host" placeholder="请输入数据库连接地址" value="localhost" autocomplete="off" class="layui-input">
                        </div>
                        <div class="layui-input-inline" style="width: 94px;">
                            <input type="text" name="port" id="port" placeholder="端口" value="3306" autocomplete="off" class="layui-input">
                        </div>
                        <span class="layui-icon layui-icon-about tips" data-content="地址通常为 127.0.0.1 或 localhost<br>端口默认为3306"></span>
                    </div>
                    <div class="layui-form-item">
                        <label class="layui-form-label">数据库用户名</label>
                        <div class="layui-input-inline">
                            <input type="text" name="username" id="username" placeholder="请输入数据库用户名" value="root" autocomplete="off" class="layui-input">
                        </div>
                    </div>
                    <div class="layui-form-item">
                        <label class="layui-form-label">数据库密码</label>
                        <div class="layui-input-inline">
                            <input type="text" name="password" id="password" placeholder="请输入数据库密码" value="" autocomplete="off" class="layui-input">
                        </div>
                    </div>
                    <div class="layui-form-item">
                        <label class="layui-form-label">数据库名称</label>
                        <div class="layui-input-inline">
                            <input type="text" name="dbname" id="dbname" placeholder="请输入数据库名称" value="" autocomplete="off" class="layui-input">
                        </div>
                    </div>
                    <div class="layui-form-item">
                        <label class="layui-form-label">数据表前缀</label>
                        <div class="layui-input-inline">
                            <input type="text" name="dbprefix" id="dbprefix" placeholder="请输入数据库密码" value="dede_" autocomplete="off" class="layui-input">
                        </div>
                        <button class="layui-btn layui-btn-primary" onclick="return checkingAction();" lay-submit>测试连接</button>
                    </div>
                    <div class="layui-form-item">
                        <label class="layui-form-label">导入选项</label>
                        <div class="layui-input-block">
                            <input type="checkbox" name="column" title="栏目分类" checked>
                            <input type="checkbox" name="content" title="内容文档" checked>
                            <input type="checkbox" name="useless" title="回收站文档">
                            <input type="checkbox" name="sorting" title="文档排序" checked>
                        </div>
                    </div>
                    <div class="layui-form-item">
                        <div class="layui-inline">
                            <label class="layui-form-label">栏目扩展字段</label>
                            <div class="layui-input-inline" style="width: 260px;">
                                <textarea name="columns1" id="columns1" placeholder="左边输入织梦栏目表字段，每行一个！例如：typenameen" class="layui-textarea"></textarea>
                            </div>
                            <div class="layui-input-inline" style="width: 260px;">
                                <textarea name="columns2" id="columns2" placeholder="右边输入当前程序栏目表字段，每行一个！例如：subname" class="layui-textarea"></textarea>
                            </div>
                        </div>
                    </div>
                    <div class="layui-form-item">
                        <div class="layui-inline">
                            <label class="layui-form-label">内容扩展字段</label>
                            <div class="layui-input-inline" style="width: 260px;">
                                <textarea name="contents1" id="contents1" placeholder="左边输入织梦内容表字段，每行一个！例如：typenameen" class="layui-textarea"></textarea>
                            </div>
                            <div class="layui-input-inline" style="width: 260px;">
                                <textarea name="contents2" id="contents2" placeholder="右边输入当前程序内容表字段，每行一个！例如：subname" class="layui-textarea"></textarea>
                            </div>
                        </div>
                    </div>
                    <div class="layui-form-item">
                        <div class="layui-input-block layui-btn-group">
                            <button type="submit" name="" value="" onclick="return trunCateArchive('ay_content_sort','栏目表');" class="layui-btn layui-btn-sm layui-btn-warm">清空栏目</button>
                            <button type="submit" name="" value="" onclick="return trunCateArchive('ay_content','内容表');" class="layui-btn layui-btn-sm layui-btn-warm">清空内容</button>
                            <button type="submit" name="" value="" onclick="return trunCateArchive('ay_content_ext','内容扩展表');" class="layui-btn layui-btn-sm layui-btn-warm">清空扩展</button>
                            <button type="submit" name="" value="" onclick="return preViewArchive('arctype');" class="layui-btn layui-btn-sm layui-btn-normal">预览栏目</button>
                            <button type="submit" name="" value="" onclick="return preViewArchive('archives');" class="layui-btn layui-btn-sm layui-btn-normal">预览内容</button>
                            <button type="submit" name="" value="" onclick="return implementArchive();" class="layui-btn layui-btn-sm">立即提交</button>
                        </div>
                    </div>
                </div>
            </div>
            <div class="layui-tab-item">
                <div class="layui-form">
                    <input type="hidden" name="formcheck" value="{$formcheck}">
                    <blockquote class="layui-elem-quote">
                        <p>支持将模板标签前缀转换为自定义模板标签前缀，转换前建议先备份一次模板（仅备份html格式文件）</p>
                    </blockquote>
                    <div class="layui-form-item">
                        <label class="layui-form-label">模板标签前缀</label>
                        <div class="layui-input-inline">
                            <input type="text" name="labelprefix" id="labelprefix" placeholder="请输入模板标签前缀" value="{$labelprefix}" autocomplete="off" class="layui-input">
                        </div>
                    </div>
                    <div class="layui-form-item">
                        <div class="layui-input-block layui-btn-group">
                            <button type="submit" name="" value="" onclick="return templatebak();" class="layui-btn layui-btn-sm layui-btn-normal">模板备份</button>
                            <button type="submit" name="" value="" onclick="return templaterec();" class="layui-btn layui-btn-sm layui-btn-warm">模板还原</button>
                            <button type="submit" name="" value="" onclick="return labelPrefix();" class="layui-btn layui-btn-sm">立即转换</button>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
{include file='common/foot.html'}
<script type="text/javascript">
    //测试连接
    function checkingAction() {
        $.post('{url./admin/dedetopb/checking}', {
            formcheck: '{$formcheck}',
            host: $("#host").val(),
            username: $("#username").val(),
            password: $("#password").val(),
            dbname: $("#dbname").val(),
            dbprefix: $("#dbprefix").val(),
            port: $("#port").val(),
        }, function(data) {
            if (data.code == 0) {
                layer.msg(data.data, {
                    icon: 5
                });
            } else {
                layer.msg(data.data, {
                    icon: 1
                });
            }
        }, 'json');
    };

    //重置数据表
    function trunCateArchive(obj, table_name) {
        layer.confirm('确定要重置' + table_name + '吗？', {
            icon: 3,
            btn: ['确定', '取消'] //按钮
        }, function() {
            $.post('{url./admin/dedetopb/truncate}', {
                formcheck: '{$formcheck}',
                table_name: obj
            }, function(data) {
                if (data.code == 0) {
                    layer.msg(data.data, {
                        icon: 5
                    });
                } else {
                    layer.msg(table_name + data.data, {
                        icon: 1
                    });
                }
            }, 'json');
        });

    };

    //预览数据
    function preViewArchive(obj) {
        $.post('{url./admin/dedetopb/preview}', {
            formcheck: '{$formcheck}',
            table_name: obj,
            host: $("#host").val(),
            username: $("#username").val(),
            password: $("#password").val(),
            dbname: $("#dbname").val(),
            dbprefix: $("#dbprefix").val(),
            port: $("#port").val()
        }, function(data) {
            if (data.code == 0) {
                layer.msg(data.data, {
                    icon: 5
                });
            } else {
                layer.open({
                    type: 1,
                    title: '数据预览',
                    skin: 'layui-layer-rim', //加上边框
                    area: ['80%', '75%'], //宽高
                    content: '<div style = "padding:20px">' + data.data + '</div>'
                });
            }
        }, 'json');
    };

    //提交转换
    function implementArchive() {
        $.post('{url./admin/dedetopb/implement}', {
            formcheck: '{$formcheck}',
            host: $("#host").val(),
            username: $("#username").val(),
            password: $("#password").val(),
            dbname: $("#dbname").val(),
            dbprefix: $("#dbprefix").val(),
            port: $("#port").val(),
            column: $("input[name='column']:checked").is(':checked'),
            content: $("input[name='content']:checked").is(':checked'),
            useless: $("input[name='useless']:checked").is(':checked'),
            sorting: $("input[name='sorting']:checked").is(':checked'),
            columns1: $("#columns1").val().replace(/\n/g, ","),
            columns2: $("#columns2").val().replace(/\n/g, ","),
            contents1: $("#contents1").val().replace(/\n/g, ","),
            contents2: $("#contents2").val().replace(/\n/g, ",")
        }, function(data) {
            var index = layer.load(0, {
                shade: [0.5, '#fff']
            });
            if (data.code == 0) {
                layer.closeAll('loading');
                layer.msg(data.data, {
                    icon: 5
                });
            } else {
                layer.closeAll('loading');
                layer.msg(data.data, {
                    icon: 1
                });
            }
        }, 'json');
    };
    
    //模板标签前缀转换
    function labelPrefix() {
        layer.confirm('确定要转换模板标签前缀吗？', {
            icon: 3,
            btn: ['确定', '取消'] //按钮
        }, function() {
            $.post('{url./admin/dedetopb/labelPrefix}', {
                formcheck: '{$formcheck}',
                labelprefix: $("#labelprefix").val()
            }, function(data) {
                if (data.code == 1) {
                    layer.msg(data.data, {
                        icon: 1
                    });
                } else {
                    layer.msg(data.data, {
                        icon: 2
                    });
                }
            }, 'json');
        });
        
    };
    
    //模板备份
    function templatebak(){
        $.post('{url./admin/dedetopb/templatebak}', {
            formcheck: '{$formcheck}',
        }, function(data) {
            if (data.code == 1) {
                layer.msg(data.data, {
                    icon: 1
                });
            } else {
                layer.msg(data.data, {
                    icon: 2
                });
            }
        }, 'json');
    };
    
    //模板还原
    function templaterec(){
        layer.confirm('确定要还原为上一次备份吗？', {
            icon: 3,
            btn: ['确定', '取消'] //按钮
        }, function() {
            $.post('{url./admin/dedetopb/templaterec}', {
                formcheck: '{$formcheck}',
            }, function(data) {
                if (data.code == 1) {
                    layer.msg(data.data, {
                        icon: 1
                    });
                } else {
                    layer.msg(data.data, {
                        icon: 2
                    });
                }
            }, 'json');
        });
    };
</script>
{if(!session('rd_unlock'))}
<script>
$(document).ready(function(){
    layui.use("layer",function(){
        var layer = layui.layer;
        layer.ready(function () {
            layer.prompt({
                title:'开发者密码验证',
                formType: 1,
                closeBtn: 0,
                btnAlign: 'c',
                btn: ['验证']
            },function(value, index){
                $.post('{url./admin/index/developerCheck}', {
                    fm_pwd:value,
                    formcheck:'{$formcheck}'
                },function(data) {
                    if(data.code=='1'){
                        layer.msg(data.data, {icon: 1});
                        layer.close(index);
                    }else{
                        layer.msg(data.data, {icon: 2});
                    }
                }, 'json');
            });
        })
    })
}); 
</script>
{/if}