Kirin
/
xny


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295
							<!doctype html>
<html>

<head>
    <meta charset="UTF-8"/>
    <title>安装许可协议 - Powered by CRMEB </title>
    <link rel="stylesheet" href="/install/css/install.css?v=9.0"/>
    <link rel="stylesheet" href="/install/css/step3.css"/>
    <!-- 引入样式 -->
    <link rel="stylesheet" href="/install/css/theme-chalk.css">
    <!-- import Vue before Element -->
    <script src="/install/js/vue2.6.11.js"></script>
    <!-- import JavaScript -->
    <script src="/install/js/element-ui.js?v=9.0"></script>
    <script src="/install/js/jquery.js?v=9.0"></script>
    <script src="/install/js/validate.js?v=9.0"></script>
    <script src="/install/js/ajaxForm.js?v=9.0"></script>
</head>

<body>
<div class="wrap" id="step3">
    <div class="title">
        创建数据
    </div>
    <section class="section">
        <form id="J_install_form" action="/install/databases/create" method="post">
            <div class="server" ref="mianscroll">
                <table width="100%">
                    <tr>
                        <td class="td1" width="100">数据库信息</td>
                        <td class="td1" width="200">&nbsp;</td>
                        <td class="td1">&nbsp;</td>
                    </tr>

                    <tr>
                        <td class="tar">数据库用户名：</td>
                        <td><input type="text" name="dbuser" id="dbuser" value="root" class="input" @blur="TestDbPwd(0)"></td>
                        <td>
                            <div id="J_install_tip_dbuser"></div>
                        </td>
                    </tr>
                    <tr>
                        <td class="tar">数据库密码：</td>
                        <td><input type="password" name="dbpw" id="dbpw" value="" class="input" autoComplete="off" @blur="TestDbPwd(0)"></td>
                        <td>
                            <div id="J_install_tip_dbpw"></div>
                        </td>
                    </tr>
                    <tr>
                        <td class="tar">数据库名：</td>
                        <td><input type="text" name="dbname" id="dbname" value="crmeb" class="input" @blur="TestDbPwd(0)"></td>
                        <td>
                            <div id="J_install_tip_dbname"></div>
                        </td>
                    </tr>
                    <tr>
                        <td class="tar">高级设置：</td>
                        <td colspan="2">
                            <el-switch v-model="value" active-color="#37CA71" inactive-color="#575869">
                            </el-switch>
                        </td>
                        <td>
                        </td>
                    </tr>
                    <tr v-show="value">
                        <td class="tar">数据库服务器：</td>
                        <td><input type="text" name="dbhost" id="dbhost" value="127.0.0.1" class="input" @blur="TestDbPwd(0)"></td>
                        <td>
                            <div id="J_install_tip_dbhost"></div>
                        </td>
                    </tr>
                    <tr v-show="value">
                        <td class="tar">数据库端口：</td>
                        <td><input type="text" name="dbport" id="dbport" value="3306" class="input"
                                   @blur="TestDbPwd(0)"></td>
                        <td>
                            <div id="J_install_tip_dbport"></div>
                        </td>
                    </tr>

                    <tr v-show="value">
                        <td class="tar">数据库表前缀：</td>
                        <td><input type="text" name="dbprefix" id="dbprefix" value="eb_" class="input"></td>
                        <td></td>
                    </tr>
                    <tr v-show="value">
                        <td class="tar">演示数据：</td>
                        <td colspan="2"><input style="width:14px;height:14px;" type="checkbox" id="demo" name="demo"
                                               value="demo"
                                               checked></td>
                    </tr>
                </table>
                <table>
                    <tr>
                        <td class="td1" width="100">Redis设置</td>
                        <td class="td1" width="200">&nbsp;</td>
                        <td class="td1">&nbsp;</td>
                    </tr>
                    <tr>
                        <td class="tar">服务器地址：</td>
                        <td><input type="text" name="rbhost" id="rbhost" value="127.0.0.1" class="input" @blur="TestDbPwd(0)"></td>
                        <td>
                            <div id="J_install_redis_host"><span class="gray">redis服务器地址，一般为127.0.0.1</span></div>
                        </td>
                    </tr>
                    <tr>
                        <td class="tar">端口号：</td>
                        <td><input type="text" name="rbport" id="rbport" value="6379" class="input" autoComplete="off" @blur="TestDbPwd(0)">
                        </td>
                        <td>
                            <div id="J_install_redis_port"><span class="gray">redis端口,默认为6379</span></div>
                        </td>
                    </tr>
                    <tr>
                        <td class="tar">数据库：</td>
                        <td><input type="text" name="rbselect" id="rbselect" value="0" class="input" autoComplete="off" @blur="TestDbPwd(0)">
                        </td>
                        <td>
                            <div id="J_install_redis_select"><span class="gray">redis数据库，默认为0,一般不做更改</span></div>
                        </td>
                    </tr>
                    <tr id="scrollBtn">
                        <td class="tar">数据库密码：</td>
                        <td><input type="text" name="rbpw" id="rbpw" value="" class="input" autoComplete="off" @blur="TestDbPwd(0)"></td>
                        <td>
                            <div id="J_install_redis_dbpw"><span class="gray">redis数据库密码</span></div>
                        </td>
                    </tr>
                </table>
                <table width="100%">
                    <tr>
                        <td class="td1" width="100">管理员信息</td>
                        <td class="td1" width="200">&nbsp;</td>
                        <td class="td1">&nbsp;</td>
                    </tr>
                    <tr>
                        <td class="tar">管理员帐号：</td>
                        <td><input type="text" name="manager" id="manager" value="admin" class="input"
                                   @blur="checkForm(0)"></td>
                        <td>
                            <div id="J_install_tip_manager"></div>
                        </td>
                    </tr>
                    <tr>
                        <td class="tar">管理员密码：</td>
                        <td><input type="password" name="manager_pwd" id="manager_pwd" class="input" autoComplete="off"
                                   placeholder="请输入密码(至少6个字符)" placeholder-class="pl-style" @blur="checkForm(0)">
                        </td>
                        <td>
                            <div id="J_install_tip_manager_pwd"><span class="gray">请输入至少6个字符密码</span></div>
                        </td>
                    </tr>
                    <tr>
                        <td class="tar">重复密码：</td>
                        <td><input type="password" name="manager_ckpwd" id="manager_ckpwd" class="input"
                                   autoComplete="off"
                                   placeholder="请再次输入密码" @keyUp="checkForm(0)"></td>
                        <td>
                            <div id="J_install_tip_manager_ckpwd"></div>
                        </td>
                    </tr>
                </table>
            </div>
            <div class="bottom-btn">
                <div class="bottom tac up-btn">
                    <a href="/install/environment" class="btn">上一步</a>
                </div>
                <div class="bottom tac next">
                    <a @click="checkForm(1);" class="btn">下一步</a>
                </div>
            </div>
        </form>
    </section>
    <div style="width:0;height:0;overflow:hidden;"><img src="/install/images/install/pop_loading.gif"></div>

</div>
<div class="footer"> &copy; 2014-2022 <a href="http://www.crmeb.com" target="_blank">www.crmeb.com</a> 西安众邦网络科技有限公司出品
</div>

<script>
    new Vue({
        el: '#step3',
        data() {
            return {value: false}
        },
        created() {

        },
        methods: {
            checkForm(connect_db) {
                manager = $.trim($('#manager').val());				//用户名表单
                manager_pwd = $.trim($('#manager_pwd').val());		//密码表单
                manager_ckpwd = $.trim($('#manager_ckpwd').val());	//密码提示区
                if (manager.length == 0) {
                    $('#J_install_tip_manager').html('<span for="dbname" generated="true" class="tips_error" style="">请输入管理账号</span>');
                    return false;
                }
                if (!(/^[a-zA-Z0-9]{0,32}$/.test(manager))) {
                    $('#J_install_tip_manager').html('<span generated="true" class="tips_error" style="">账号必须为英文或者数字</span>');
                    return false;
                } else {
                    $('#J_install_tip_manager').html('<span generated="true" class="tips_success" style="">用户名可用</span>');
                }
                if (manager_pwd.length < 6) {
                    $('#J_install_tip_manager_pwd').html('<span for="dbname" generated="true" class="tips_error" style="">管理员密码必须5位数以上</span>');
                    return false;
                } else {
                    $('#J_install_tip_manager_pwd').html('<span generated="true" class="tips_success" style="">密码可用</span>');
                }
                if (manager_ckpwd != manager_pwd) {
                    $('#J_install_tip_manager_ckpwd').html('<span for="dbname" generated="true" class="tips_error" style="">两次密码不一致</span>');
                    return false;
                } else {
                    $('#J_install_tip_manager_ckpwd').html('<span generated="true" class="tips_success" style="">密码正确</span>');
                }
                if (connect_db === 1) {
                    this.TestDbPwd(1)
                }
            },
            TestDbPwd(connect_db) {
                var data = {
                    'dbhost': $('#dbhost').val(),
                    'dbuser': $('#dbuser').val(),
                    'dbpw': $('#dbpw').val(),
                    'dbname': $('#dbname').val(),
                    'dbport': $('#dbport').val(),
                    'demo': $('#demo').val(),
                    'rbhost': $('#rbhost').val(),
                    'rbport': $("#rbport").val(),
                    'rbselect': $("#rbselect").val(),
                    'rbpw': $('#rbpw').val(),
                    'dbprefix': $('#dbprefix').val(),
                };
                var url = "/install/databases/check";
                $.ajax({
                    type: "POST",
                    url: url,
                    data: data,
                    dataType: 'JSON',
                    beforeSend: function () {
                    },
                    success: function (msg) {
                        if (msg == 1) {

                            if (connect_db == 1) {
                                $("#J_install_form").submit(); // ajax 验证通过后再提交表单
                            }
                            $('#J_install_tip_dbpw').html('');
                            $('#J_install_tip_dbname').html('');
                            $('#J_install_redis_host').html('');
                        } else if (msg == -1) {
                            $('#J_install_redis_host').html("");
                            $('#J_install_tip_dbname').html("");
                            $('#J_install_tip_dbpw').html('<span for="dbname" generated="true" class="tips_error" style="">请在mysql配置文件修sql-mode或sql_mode为NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION</span>');
                        } else if (msg == -2) {
                            $('#J_install_redis_host').html("");
                            $('#J_install_tip_dbname').html("");
                            $('#J_install_tip_dbpw').html('<span for="dbname" generated="true" class="tips_error" style="">请在mysql配置文件修sql-mode或sql_mode为 NO_ENGINE_SUBSTITUTION </span>');
                        } else if (msg == -3) {
                            $('#J_install_redis_host').html("");
                            $('#J_install_tip_dbpw').html("");
                            $('#J_install_tip_dbname').html('<span for="dbname" generated="true" class="tips_error" style="">你的不是空数据库, 请更换一个数据库名字</span>');
                        } else if (msg == -4) {
                            $('#J_install_redis_host').html("");
                            $('#J_install_tip_dbpw').html("");
                            $('#J_install_tip_dbname').html('<span for="dbname" generated="true" class="tips_error" style="">Mysql数据库版本不的低于5.6</span>');
                        } else if (msg == -5) {
                            $('#J_install_tip_dbname').html("");
                            $('#J_install_tip_dbpw').html("");
                            $('#J_install_redis_host').html('<span for="dbname" generated="true" class="tips_error" style="">Redis数据库没有启动或者地址/端口/密码错误</span>');
                        } else if (msg == -6) {
                            $('#J_install_tip_dbname').html("");
                            $('#J_install_tip_dbpw').html("");
                            $('#J_install_tip_dbprefix').html('<span for="dbname" generated="true" class="tips_error" style="">数据库前缀必须填写</span>');
                        } else {
                            $('#J_install_tip_dbname').html("");
                            $('#J_install_rbhost').html("");
                            $('#J_install_tip_dbpw').html('<span for="dbname" generated="true" class="tips_error" style="">数据库链接配置失败</span>');
                        }
                    },
                    complete: function () {
                    },
                    error: function () {
                        $('#J_install_tip_dbpw').html('<span for="dbname" generated="true" class="tips_error" style="">数据库链接配置失败</span>');
                    }
                });
            }
        }
    });


</script>
</body>

</html>