<?php
    // セッションの開始
    session_start();
    
    // 権限の設定
    $user = $_SESSION['user'];
	if($user == ''){
		header('Location:logon.html');
	}
	if(isset($_POST["insert"])){
		//日付のチェック
		if($_POST["year"] == "" || $_POST["month"] == "" || $_POST["day"] == ""){
			$error = "nengappi_nhs";
			header("Location: error.php?error=$error");
			exit;
		}
		if(!Chk_num($_POST["year"]) || !Chk_num($_POST["month"]) || !Chk_num($_POST["day"])){
			$error = "nengappi_nhs";
			header("Location: error.php?error=$error");
			exit;
		}
		//時給のチェック
		if($_POST["g_zikyu"] == ""){
			$error = "zikyu_nhs";
			header("Location: error.php?error=$error");
			exit;
		}
		if(!Chk_num($_POST["g_zikyu"])){
			$error = "zikyu_nhs";
			header("Location: error.php?error=$error");
			exit;
		}
		//勤務時間1のチェック
		if(!($_POST["k1_zi_1"] != "" && $_POST["k1_hun_1"] != "" && $_POST["k1_zi_2"] != "" && $_POST["k1_hun_2"] != "")){
			$error = "k1zikan_nhs";
			header("Location: error.php?error=$error");
			exit;
		}
		if(!Chk_num($_POST["k1_zi_1"]) || !Chk_num($_POST["k1_hun_1"]) || !Chk_num($_POST["k1_zi_2"]) || !Chk_num($_POST["k1_hun_2"])){
			$error = "k1zikan_nhs";
			header("Location: error.php?error=$error");
			exit;
		}
		if($_POST["k1_zi_1"] > $_POST["k1_zi_2"] || $_POST["k1_zi_1"] == $_POST["k1_zi_2"] && $_POST["k1_hun_1"] >= $_POST["k1_hun_2"]){
			$error = "k1zikan_incorrect";
			header("Location: error.php?error=$error");
			exit;
		}
		//勤務時間2のチェック
		if($_POST["k2_zi_1"] != "" || $_POST["k2_hun_1"] != "" || $_POST["k2_zi_2"] != "" || $_POST["k2_hun_2"] != ""){
			if($_POST["k2_zi_1"] != "" && $_POST["k2_hun_1"] != "" && $_POST["k2_zi_2"] != "" && $_POST["k2_hun_2"] != ""){
				if(!Chk_num($_POST["k2_zi_1"]) || !Chk_num($_POST["k2_hun_1"]) || !Chk_num($_POST["k2_zi_2"]) || !Chk_num($_POST["k2_hun_2"])){
					$error = "k2zikan_nhs";
					header("Location: error.php?error=$error");
					exit;
				}
				if($_POST["k2_zi_1"] > $_POST["k2_zi_2"] || $_POST["k2_zi_1"] == $_POST["k2_zi_2"] && $_POST["k2_hun_1"] >= $_POST["k2_hun_2"]){
					$error = "k2zikan_incorrect";
					header("Location: error.php?error=$error");
					exit;
				}
			}else{
				$error = "k2zikan_notfull";
				header("Location: error.php?error=$error");
				exit;
			}
		}
		//勤務時間3のチェック
		if($_POST["k3_zi_1"] != "" || $_POST["k3_hun_1"] != "" || $_POST["k3_zi_2"] != "" || $_POST["k3_hun_2"] != ""){
			if($_POST["k3_zi_1"] != "" && $_POST["k3_hun_1"] != "" && $_POST["k3_zi_2"] != "" && $_POST["k3_hun_2"] != ""){
				if(!Chk_num($_POST["k3_zi_1"]) || !Chk_num($_POST["k3_hun_1"]) || !Chk_num($_POST["k3_zi_2"]) || !Chk_num($_POST["k3_hun_2"])){
					$error = "k3zikan_nhs";
					header("Location: error.php?error=$error");
					exit;
				}
				if($_POST["k3_zi_1"] > $_POST["k3_zi_2"] || $_POST["k3_zi_1"] == $_POST["k3_zi_2"] && $_POST["k3_hun_1"] >= $_POST["k3_hun_2"]){
					$error = "k3zikan_incorrect";
					header("Location: error.php?error=$error");
					exit;
				}
			}else{
				$error = "k3zikan_notfull";
				header("Location: error.php?error=$error");
				exit;
			}
		}
	//日付を取得	
		$nen = $_POST["year"];
		$month = $_POST["month"];
		$day = $_POST["day"];
	//時給を取得
		$g_zikyu = $_POST["g_zikyu"];
	//勤務時間１を取得
		$k1_zi_1 = $_POST["k1_zi_1"];
		$k1_hun_1 = $_POST["k1_hun_1"];
		$k1_zi_2 = $_POST["k1_zi_2"];
		$k1_hun_2 = $_POST["k1_hun_2"];
	//勤務時間２を取得
		$k2_zi_1 = $_POST["k2_zi_1"];
		$k2_hun_1 = $_POST["k2_hun_1"];
		$k2_zi_2 = $_POST["k2_zi_2"];
		$k2_hun_2 = $_POST["k2_hun_2"];
	//勤務時間３を取得
		$k3_zi_1 = $_POST["k3_zi_1"];
		$k3_hun_1 = $_POST["k3_hun_1"];
		$k3_zi_2 = $_POST["k3_zi_2"];
		$k3_hun_2 = $_POST["k3_hun_2"];
	}
	$con = sqlite_open('../../SQLiteManager/kinmu');
	$sql = "select max(k_id) from kinmu";
	$result = sqlite_query($sql,$con);
	$array = sqlite_fetch_array($result);
	$i_k_id = $array[0] + 1;
	$sql = "insert into kinmu(k_id,k_nen,k_tuki,k_hi,k_zikyu,k_username) 
			values($i_k_id,$nen,$month,$day,$g_zikyu,'$user')";
	if(!(sqlite_query($sql,$con))){
		echo "クエリの実行に失敗しました。";
		exit;
	}
	$sql = "insert into kinmu_meisai(k_id,km_id,ks_hour,ks_minute,ke_hour,ke_minute)
			values($i_k_id,1,$k1_zi_1,$k1_hun_1,$k1_zi_2,$k1_hun_2)";
	if(!(sqlite_query($sql,$con))){
		echo "クエリの実行に失敗しました。";
		exit;
	}
	$i = 2;
	if($_POST["k2_zi_1"] != "" && $_POST["k2_hun_1"] != "" && $_POST["k2_zi_2"] != "" && $_POST["k2_hun_2"] != ""){
		$sql = "insert into kinmu_meisai(k_id,km_id,ks_hour,ks_minute,ke_hour,ke_minute)
				values($i_k_id,$i,$k2_zi_1,$k2_hun_1,$k2_zi_2,$k2_hun_2)";
		if(!(sqlite_query($sql,$con))){
			echo "クエリの実行に失敗しました。";
			exit;
		}
		$i = $i + 1;
	}
	if($_POST["k3_zi_1"] != "" && $_POST["k3_hun_1"] != "" && $_POST["k3_zi_2"] != "" && $_POST["k3_hun_2"] != ""){
		$sql = "insert into kinmu_meisai(k_id,km_id,ks_hour,ks_minute,ke_hour,ke_minute)
				values($i_k_id,$i,$k3_zi_1,$k3_hun_1,$k3_zi_2,$k3_hun_2)";
		if(!(sqlite_query($sql,$con))){
			echo "クエリの実行に失敗しました。";
			exit;
		}
	}
?>
<html>
<head>
<title>勤務登録確認画面</title>
</head>
<body>
<div align="center">
勤務登録確認<hr><br>
このデータで登録しました。<br><br>
<table border="1">
 <?php
 	function Chk_num($num){
 	 if (ereg("[^0-9]+",$num)){
		return false;
	 }else{
		return true;
	 }
	}
 	//確認データ出力部分
 	print("<tr>");
	print("<td align=\"center\">日付</td>");
	print("<td>$nen 年 $month 月 $day 日</td>");
	print("</tr>");
	print("<tr>");
	print("<td align=\"center\">時給</td>");
	print("<td>$g_zikyu 円</td>");
	print("</tr>");
	print("<tr>");
	print("<td align=\"center\">勤務時間1</td>");
	print("<td>$k1_zi_1 時 $k1_hun_1 分～ $k1_zi_2 時 $k1_hun_2 分</td>");
	print("</tr>");
	$i = 2;
	if($_POST["k2_zi_1"] != "" && $_POST["k2_hun_1"] != "" && $_POST["k2_zi_2"] != "" && $_POST["k2_hun_2"] != ""){
		print("<tr>");
		print("<td align=\"center\">勤務時間 $i</td>");
		print("<td>$k2_zi_1 時 $k2_hun_1 分～ $k2_zi_2 時 $k2_hun_2 分</td>");
		print("</tr>");
		$i = $i + 1;
	}
	if($_POST["k3_zi_1"] != "" && $_POST["k3_hun_1"] != "" && $_POST["k3_zi_2"] != "" && $_POST["k3_hun_2"] != ""){
		print("<tr>");
		print("<td align=\"center\">勤務時間 $i</td>");
		print("<td>$k3_zi_1 時 $k3_hun_1 分～ $k3_zi_2 時 $k3_hun_2 分</td>");
		print("</tr>");
	}
?>
</table>
<br>
<a href="kinmu_touroku.php">勤務登録画面へ戻る</a>
</div>
</body>
<?php
	sqlite_close($con);
?>
</html>