<!doctype html>
<html>
	<!-- +~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
	| 房佳（新房报备ERP管理系统）
	+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
	| © 2020-2023 http://www.kaidandashi.com/ All rights reserved.
	+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
	| 本系统由淮南市银泰软件科技有限公司提供技术支持
	+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
	| QQ号：984784483
	+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -->
	<head>
		<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
		<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
		<title>
			<?php echo $Title; ?> - <?php echo $Powered; ?>
		</title>
		<link rel="stylesheet" href="./css/install.css?v=9.0" />
	</head>
	<body>
		<div class="wrap">
			<?php require './templates/header.php';?>
			<section class="section">
				<div class="step">
					<ul>
						<li class="on">
							<em>1</em>检测环境
						</li>
						<li class="current">
							<em>2</em>创建数据
						</li>
						<li>
							<em>3</em>完成安装
						</li>
					</ul>
				</div>
				<form id="J_install_form" action="index.php?step=4" method="post">
					<input type="hidden" name="force" value="0" />
					<div class="server">
						<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="dbhost" id="dbhost" value="localhost" class="input">
								</td>
								<td></td>
								<td>
									<span class="gray">数据库服务器地址，一般为localhost</span>
								</td>
							</tr>
							<tr>
								<td class="tar">数据库端口：</td>
								<td>
									<input type="text" name="dbport" id="dbport" value="3306" class="input">
								</td>
								<td></td>
								<td>
									<span class="gray">数据库服务器端口，一般为3306</span>
								</td>
							</tr>
							<tr>
								<td class="tar">数据库用户名：</td>
								<td>
									<input type="text" name="dbuser" id="dbuser" value="root" class="input">
								</td>
								<td></td>
								<td>
									<span class="gray">默认为root，如果有其他有权限创建数据库的用户，也可输入其他用户名</span>
								</td>
							</tr>
							<tr>
								<td class="tar">数据库密码：</td>
								<td>
									<input type="password" name="dbpw" id="dbpw" value="root" class="input" autoComplete="off" onBlur="TestDbPwd(0)">
								</td>
								<td></td>
								<td>
									<span class="gray">默认未root，如果有其他有权限创建数据库的用户，也可输入对应的密码</span>
								</td>
							</tr>
							<tr>
								<td class="tar">数据库名：</td>
								<td>
									<input type="text" name="dbname" id="dbname" value="fj2.7.7" class="input" onBlur="TestDbPwd(0)">
								</td>
								<td></td>
								<td>
									<span class="gray">默认为fj2.7.7，输入已存在的数据库名将无法创建数据</span>
								</td>
							</tr>
							<tr>
								<td class="tar">数据库表前缀：</td>
								<td>
									<input type="text" value="jjrxt_" class="input" readonly>
								</td>
								<td></td>
								<td>
									<span class="gray">默认为jjrxt_，不可更改</span>
								</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_xm" value="管理员" class="input">
								</td>
								<td></td>
								<td>
									<span class="gray">默认为管理员，可以修改为您的姓名</span>
								</td>
							</tr>
							<tr>
								<td class="tar">管理员帐号：</td>
								<td>
									<input type="text" name="manager" id="manager" value="admin" class="input">
								</td>
								<td></td>
								<td>
									<span class="gray">默认admin，如需修改请修改为手机号</span>
								</td>
							</tr>
							<tr>
								<td class="tar">管理员密码：</td>
								<td>
									<input type="password" name="manager_pwd" id="manager_pwd" value="123456" class="input" autoComplete="off">
								</td>
								<td></td>
								<td>
									<span class="gray">默认为123456，如需修改请输入六位或六位以上的密码</span>
								</td>
							</tr>
							<tr>
								<td class="tar">重复密码：</td>
								<td>
									<input type="password" name="manager_ckpwd" id="manager_ckpwd" value="123456" class="input" autoComplete="off">
								</td>
								<td></td>
								<td>
									<span class="gray">默认为123456，如需修改请输入六位或六位以上的密码</span>
								</td>
							</tr>
						</table>
						<div id="J_response_tips" style="display:none;"></div>
					</div>
					<div class="bottom tac">
						<a href="./index.php?step=2" class="btn">上一步</a>
						<button type="button" onClick="checkForm();" class="btn btn_submit J_install_btn">
							创建数据
						</button>
					</div>
				</form>
			</section>
			<div  style="width:0;height:0;overflow:hidden;">
				<img src="./images/install/pop_loading.gif">
			</div>
			<script src="./js/jquery.js"></script>
			<script src="./js/validate.js"></script>
			<script src="./js/ajaxForm.js"></script>
			<script>
				function TestDbPwd(connect_db) {
					var dbHost = $('#dbhost').val();
					var dbUser = $('#dbuser').val();
					var dbPwd = $('#dbpw').val();
					var dbName = $('#dbname').val();
					var dbport = $('#dbport').val();
					data={'dbHost':dbHost,'dbUser':dbUser,'dbPwd':dbPwd,'dbName':dbName,'dbport':dbport};
					var url =  "<?php echo $_SERVER['PHP_SELF']; ?>?step=3&testdbpwd=1";
					$.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('');
							} else if(msg == -1) {
								$('#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_tip_dbname').html('<span for="dbname" generated="true" class="tips_error" style="">你的不是空数据库, 请更换一个数据库名字</span>');
							} else {
								$('#dbpw').val("");
								$('#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>');
							$('#dbpw').val("");
						}
					});
				}
				function checkForm() {
					manager = $.trim($('#manager').val()); //用户名表单
					manager_pwd = $.trim($('#manager_pwd').val()); //密码表单
					manager_ckpwd = $.trim($('#manager_ckpwd').val()); //密码提示区
					if(manager.length == 0 ) {
						alert('管理员账号不能为空');
						return false;
					}
					if(manager_pwd.length < 6 ) {
						alert('管理员密码必须6位数以上');
						return false;
					}
					if(manager_ckpwd != manager_pwd) {
						alert('两次密码不一致');
						return false;
					}
					TestDbPwd(1);
				}
			</script>
		</div>
		<?php require './templates/footer.php';?>
	</body>
</html>