<?php
	include_once '../tool.php';
	session_start();

	$team_id = $_POST['team_id'];
	$tournament_id = $_POST['tournament_id'];
	$home_url = HOME_URL;
	$path_parts = pathinfo($_FILES["csv"]["name"]);
	$extension = $path_parts['extension'];
	$mode = MAIN_DIR;
	if($mode == "admin"){
		$redirect_url = $home_url."organizer/tournament/player.php?id=".$team_id."&tournament_id=".$tournament_id;
		$file_name = $team_id."-".$tournament_id.".".$extension;
	}elseif($tournament_id){
		$redirect_url = $home_url."player/index.php?tournament_id=".$tournament_id;
		$file_name = $team_id."-".$tournament_id.".".$extension;
	}else{
		$redirect_url = $home_url."player/index.php";
		$file_name = $team_id.".".$extension;
	}

	if($extension != "xlsx"){
		unset($_SESSION[SESSION_NAME]);
		$_SESSION[SESSION_NAME]['ERRORMSG'][] = mb_convert_encoding("エントリーシートは「.xlsx」形式でアップしてください", "utf8", "SJIS");
		header('Location: ' . $redirect_url);
		exit;
	}
	if(is_uploaded_file($_FILES["csv"]["tmp_name"])){
		if(move_uploaded_file($_FILES["csv"]["tmp_name"], EXCEL_DIR . $file_name)){
			chmod(EXCEL_DIR . $file_name, 0644);
		}else{
			unset($_SESSION[SESSION_NAME]);
			$_SESSION[SESSION_NAME]['ERRORMSG'][] = mb_convert_encoding("何らかの理由でエントリーシート読み取りに失敗しました", "utf8", "SJIS");
			header('Location: ' . $redirect_url);
			exit;
		}
	}else{
		unset($_SESSION[SESSION_NAME]);
		$_SESSION[SESSION_NAME]['ERRORMSG'][] = mb_convert_encoding("エントリーシートが選択されていません", "utf8", "SJIS");
		header('Location: ' . $redirect_url);
		exit;
	}
	unset($_SESSION[SESSION_NAME]);

	// 連想配列でデータ受け取り
	$data = readXlsx($file_name, mb_convert_encoding("データ※禁入力", "utf8", "SJIS"), $redirect_url);
	$add_data = array();

	//申込予定部数データ
	$add_data['buy_num'] = $data['5']['I'];

	//監督データ
	$add_data['directer']['staff_lastname'] = $data['16']['C'];
	$add_data['directer']['staff_firstname'] = $data['16']['D'];
	$add_data['directer']['staff_kana_lastname'] = $data['16']['E'];
	$add_data['directer']['staff_kana_firstname'] = $data['16']['F'];
	$add_data['directer']['position_id'] = 1;
	$add_data['directer']['type'] = mb_convert_encoding("教職員", "utf-8", "sjis");
	if(!$add_data['directer']['staff_lastname']){
		$_SESSION[SESSION_NAME]['ERRORMSG'][] = mb_convert_encoding("監督姓が入力されていません", "utf8", "SJIS");
	}
	if(!$add_data['directer']['staff_firstname']){
		$_SESSION[SESSION_NAME]['ERRORMSG'][] = mb_convert_encoding("監督名が入力されていません", "utf8", "SJIS");
	}
/*
	if(!$add_data['directer']['staff_kana_lastname']){
		$_SESSION[SESSION_NAME]['ERRORMSG'][] = mb_convert_encoding("監督姓かなが入力されていません", "utf8", "SJIS");
	}
	if(!$add_data['directer']['staff_kana_firstname']){
		$_SESSION[SESSION_NAME]['ERRORMSG'][] = mb_convert_encoding("監督名かなが入力されていません", "utf8", "SJIS");
	}
*/

	//コーチ1データ
	$add_data['coach1']['staff_lastname'] = $data['17']['C'];
	$add_data['coach1']['staff_firstname'] = $data['17']['D'];
	$add_data['coach1']['staff_kana_lastname'] = $data['17']['E'];
	$add_data['coach1']['staff_kana_firstname'] = $data['17']['F'];
	$add_data['coach1']['position_id'] = 2;
	$add_data['coach1']['type'] = $data['17']['Q'];
	if(!$add_data['coach1']['staff_lastname']){
		$_SESSION[SESSION_NAME]['ERRORMSG'][] = mb_convert_encoding("コーチ1姓が入力されていません", "utf8", "SJIS");
	}
	if(!$add_data['coach1']['staff_firstname']){
		$_SESSION[SESSION_NAME]['ERRORMSG'][] = mb_convert_encoding("コーチ1名が入力されていません", "utf8", "SJIS");
	}
/*
	if(!$add_data['coach1']['staff_kana_lastname']){
		$_SESSION[SESSION_NAME]['ERRORMSG'][] = mb_convert_encoding("コーチ1姓かなが入力されていません", "utf8", "SJIS");
	}
	if(!$add_data['coach1']['staff_kana_firstname']){
		$_SESSION[SESSION_NAME]['ERRORMSG'][] = mb_convert_encoding("コーチ1名かなが入力されていません", "utf8", "SJIS");
	}
*/

	//コーチ2データ
	$add_data['coach2']['staff_lastname'] = $data['18']['C'];
	$add_data['coach2']['staff_firstname'] = $data['18']['D'];
	$add_data['coach2']['staff_kana_lastname'] = $data['18']['E'];
	$add_data['coach2']['staff_kana_firstname'] = $data['18']['F'];
	$add_data['coach2']['position_id'] = 3;
	$add_data['coach2']['type'] = $data['18']['Q'];

	//トレーナーデータ
	$add_data['trainer']['staff_lastname'] = $data['19']['C'];
	$add_data['trainer']['staff_firstname'] = $data['19']['D'];
	$add_data['trainer']['staff_kana_lastname'] = $data['19']['E'];
	$add_data['trainer']['staff_kana_firstname'] = $data['19']['F'];
	$add_data['trainer']['position_id'] = 4;
	$add_data['trainer']['type'] = $data['19']['Q'];

	//マネージャーデータ
	$add_data['manager']['staff_lastname'] = $data['20']['C'];
	$add_data['manager']['staff_firstname'] = $data['20']['D'];
	$add_data['manager']['staff_kana_lastname'] = $data['20']['E'];
	$add_data['manager']['staff_kana_firstname'] = $data['20']['F'];
	$add_data['manager']['position_id'] = 5;
	$add_data['manager']['type'] = mb_convert_encoding("教職員", "utf-8", "sjis");

	//部長データ
	$add_data['chief']['staff_lastname'] = $data['21']['C'];
	$add_data['chief']['staff_firstname'] = $data['21']['D'];
	$add_data['chief']['staff_kana_lastname'] = $data['21']['E'];
	$add_data['chief']['staff_kana_firstname'] = $data['21']['F'];
	$add_data['chief']['position_id'] = 6;
	$add_data['chief']['type'] = $data['21']['Q'];

	//連絡・申込責任者データ
	$add_data['person']['staff_lastname'] = $data['22']['C'];
	$add_data['person']['staff_firstname'] = $data['22']['D'];
	$add_data['person']['staff_kana_lastname'] = $data['22']['E'];
	$add_data['person']['staff_kana_firstname'] = $data['22']['F'];
	$add_data['person']['position_id'] = 7;
	$add_data['person']['type'] = $data['22']['Q'];

	//帯同員データ
	$add_data['along']['staff_lastname'] = $data['23']['C'];
	$add_data['along']['staff_firstname'] = $data['23']['D'];
	$add_data['along']['staff_kana_lastname'] = $data['23']['E'];
	$add_data['along']['staff_kana_firstname'] = $data['23']['F'];
	$add_data['along']['position_id'] = 8;
	$add_data['along']['type'] = $data['23']['Q'];

	//キャプテンデータ
	$add_data['captain']['staff_lastname'] = $data['24']['C'];
	$add_data['captain']['staff_firstname'] = $data['24']['D'];
	$add_data['captain']['staff_kana_lastname'] = $data['24']['E'];
	$add_data['captain']['staff_kana_firstname'] = $data['24']['F'];
	$add_data['captain']['position_id'] = 9;
	$add_data['captain']['type'] = mb_convert_encoding("教職員", "utf-8", "sjis");
	if(!$add_data['captain']['staff_lastname']){
		$_SESSION[SESSION_NAME]['ERRORMSG'][] = mb_convert_encoding("キャプテン姓が入力されていません", "utf8", "SJIS");
	}
	if(!$add_data['captain']['staff_firstname']){
		$_SESSION[SESSION_NAME]['ERRORMSG'][] = mb_convert_encoding("キャプテン名が入力されていません", "utf8", "SJIS");
	}
/*
	if(!$add_data['captain']['staff_kana_lastname']){
		$_SESSION[SESSION_NAME]['ERRORMSG'][] = mb_convert_encoding("キャプテン姓かなが入力されていません", "utf8", "SJIS");
	}
	if(!$add_data['captain']['staff_kana_firstname']){
		$_SESSION[SESSION_NAME]['ERRORMSG'][] = mb_convert_encoding("キャプテン名かなが入力されていません", "utf8", "SJIS");
	}
*/

	$last_key = get_last_key($data);
	//選手データ
	$key = 0;
	for($i=53;$i<=$last_key; $i++){
		if($data[$i]['C'] && $data[$i]['D']){
			$add_data['player'][$key]['uniform_number'] = conv_special_char($data[$i]['B'], "utf-8", "sjis");
			$add_data['player'][$key]['player_lastname'] = $data[$i]['C'];
			$add_data['player'][$key]['player_firstname'] = $data[$i]['D'];
			$add_data['player'][$key]['player_kana_lastname'] = $data[$i]['E'];
			$add_data['player'][$key]['player_kana_firstname'] = $data[$i]['F'];
			$add_data['player'][$key]['school_year'] = $data[$i]['I'];
			$add_data['player'][$key]['tall'] = $data[$i]['J'];
			if(!$data[$i]['L']){
				$add_data['player'][$key]['published_flag'] = mb_convert_encoding("可", "utf-8", "sjis");
			}elseif($data[$i]['L'] == mb_convert_encoding("○", "utf-8", "sjis")){
				$add_data['player'][$key]['published_flag'] = mb_convert_encoding("可", "utf-8", "sjis");
			}elseif($data[$i]['L'] == mb_convert_encoding("×", "utf-8", "sjis")){
				$add_data['player'][$key]['published_flag'] = mb_convert_encoding("否", "utf-8", "sjis");
			}
			if(!$add_data['player'][$key]['uniform_number']){
				$_SESSION[SESSION_NAME]['ERRORMSG'][] = mb_convert_encoding("選手No.".$data[$i]['A']."の選手の背番号が入力されていません", "utf8", "SJIS");
			}
/*
			if(!$add_data['player'][$key]['player_kana_lastname']){
				$_SESSION[SESSION_NAME]['ERRORMSG'][] = mb_convert_encoding("選手No.".$data[$i]['A']."の選手の姓かなが入力されていません", "utf8", "SJIS");
			}
			if(!$add_data['player'][$key]['player_kana_firstname']){
				$_SESSION[SESSION_NAME]['ERRORMSG'][] = mb_convert_encoding("選手No.".$data[$i]['A']."の選手の名かなが入力されていません", "utf8", "SJIS");
			}
*/
		}else{
			if(!$data[$i]['C'] && $data[$i]['D']){
				$_SESSION[SESSION_NAME]['ERRORMSG'][] = mb_convert_encoding("選手No.".$data[$i]['A']."の選手の姓が入力されていません", "utf8", "SJIS");
			}
			if($data[$i]['C'] && !$data[$i]['D']){
				$_SESSION[SESSION_NAME]['ERRORMSG'][] = mb_convert_encoding("選手No.".$data[$i]['A']."の選手の名が入力されていません", "utf8", "SJIS");
			}
		}
		$key++;
	}
	if($_SESSION[SESSION_NAME]['ERRORMSG']){
		header('Location: ' . $redirect_url);
		exit;
	}

	foreach($add_data['player'] as $key => $row){
		$foo[$key] = $row["uniform_number"];
	}
	array_multisort($foo,SORT_ASC,$add_data['player']);
	//mb_convert_variables("UTF-8", "sjis,sjis-win", $add_data);

	$dbobj = new CMyDBWrapper();
	//申込予定部数登録・ステータス変更
	if($tournament_id){
		$tournament_teamsInsert = array(
			"buy_num" => $add_data['buy_num']
		);
		$tournament_teamsInsert = array(
			"buy_num" => $add_data['buy_num'],
			"status_id" => 2
		);
		$tournament_teams = get_tournament_teams($tournament_id, $team_id);
		if($tournament_teams){
			$ret = $dbobj->updateTable("tournament_teams", $tournament_teamsInsert, array("tournament_teams_id" => $tournament_teams['tournament_teams_id']));
		}
	}

	//監督登録
	if($add_data['directer']['staff_lastname'] && $add_data['directer']['staff_lastname']){
		$directer = get_staff_list4name($team_id, $add_data['directer']['position_id'], $add_data['directer']['staff_lastname'], $add_data['directer']['staff_firstname'], $add_data['directer']['staff_kana_lastname'], $add_data['directer']['staff_kana_firstname']);
		$staffInsert = array(
			"position_id" => $add_data['directer']['position_id'],
			"staff_lastname" => $add_data['directer']['staff_lastname'],
			"staff_firstname" => $add_data['directer']['staff_firstname'],
			"staff_kana_lastname" => $add_data['directer']['staff_kana_lastname'],
			"staff_kana_firstname" => $add_data['directer']['staff_kana_firstname'],
			"type" => $add_data['directer']['type'],
			"team_id" => $team_id
		);
		if($directer){
			$staff_id = $directer['staff_id'];
			$ret = $dbobj->updateTable("staff", $staffInsert, array("staff_id" => $staff_id));
		}else{
			$ret = $dbobj->queryInsertPrepare("staff", $staffInsert);
			$staff_id = $ret;
		}
		if($tournament_id){
			$tournament_staff = get_tournament_staff($tournament_id, $staff_id);
			if(!$tournament_staff){
				$tournament_staffInsert = array(
					"tournament_id" => $tournament_id,
					"staff_id" => $staff_id
				);
				$ret = $dbobj->queryInsertPrepare("tournament_staff", $tournament_staffInsert);
			}
		}
	}

	//コーチ1登録
	if($add_data['coach1']['staff_lastname'] && $add_data['coach1']['staff_firstname']){
		$coach = get_staff_list4name($team_id, $add_data['coach1']['position_id'], $add_data['coach1']['staff_lastname'], $add_data['coach1']['staff_firstname'], $add_data['coach1']['staff_kana_lastname'], $add_data['coach1']['staff_kana_firstname']);
		$staffInsert = array(
			"position_id" => $add_data['coach1']['position_id'],
			"staff_lastname" => $add_data['coach1']['staff_lastname'],
			"staff_firstname" => $add_data['coach1']['staff_firstname'],
			"staff_kana_lastname" => $add_data['coach1']['staff_kana_lastname'],
			"staff_kana_firstname" => $add_data['coach1']['staff_kana_firstname'],
			"type" => $add_data['coach1']['type'],
			"team_id" => $team_id
		);
		if($coach){
			$staff_id = $coach['staff_id'];
			$ret = $dbobj->updateTable("staff", $staffInsert, array("staff_id" => $staff_id));
		}else{
			$ret = $dbobj->queryInsertPrepare("staff", $staffInsert);
			$staff_id = $ret;
		}
		if($tournament_id){
			$tournament_staff = get_tournament_staff($tournament_id, $staff_id);
			if(!$tournament_staff){
				$tournament_staffInsert = array(
					"tournament_id" => $tournament_id,
					"staff_id" => $staff_id
				);
				$ret = $dbobj->queryInsertPrepare("tournament_staff", $tournament_staffInsert);
			}
		}
	}

	//コーチ2登録
	if($add_data['coach2']['staff_lastname'] && $add_data['coach2']['staff_firstname']){
		$coach = get_staff_list4name($team_id, $add_data['coach2']['position_id'], $add_data['coach2']['staff_lastname'], $add_data['coach2']['staff_firstname'], $add_data['coach2']['staff_kana_lastname'], $add_data['coach2']['staff_kana_firstname']);
		$staffInsert = array(
			"position_id" => $add_data['coach2']['position_id'],
			"staff_lastname" => $add_data['coach2']['staff_lastname'],
			"staff_firstname" => $add_data['coach2']['staff_firstname'],
			"staff_kana_lastname" => $add_data['coach2']['staff_kana_lastname'],
			"staff_kana_firstname" => $add_data['coach2']['staff_kana_firstname'],
			"type" => $add_data['coach2']['type'],
			"team_id" => $team_id
		);
		if($coach){
			$staff_id = $coach['staff_id'];
			$ret = $dbobj->updateTable("staff", $staffInsert, array("staff_id" => $staff_id));
		}else{
			$ret = $dbobj->queryInsertPrepare("staff", $staffInsert);
			$staff_id = $ret;
		}
		if($tournament_id){
			$tournament_staff = get_tournament_staff($tournament_id, $staff_id);
			if(!$tournament_staff){
				$tournament_staffInsert = array(
					"tournament_id" => $tournament_id,
					"staff_id" => $staff_id
				);
				$ret = $dbobj->queryInsertPrepare("tournament_staff", $tournament_staffInsert);
			}
		}
	}

	//トレーナー登録
	if($add_data['trainer']['staff_lastname'] && $add_data['trainer']['staff_firstname']){
		$trainer = get_staff_list4name($team_id, $add_data['trainer']['position_id'], $add_data['trainer']['staff_lastname'], $add_data['trainer']['staff_firstname'], $add_data['trainer']['staff_kana_lastname'], $add_data['trainer']['staff_kana_firstname']);
		$staffInsert = array(
			"position_id" => $add_data['trainer']['position_id'],
			"staff_lastname" => $add_data['trainer']['staff_lastname'],
			"staff_firstname" => $add_data['trainer']['staff_firstname'],
			"staff_kana_lastname" => $add_data['trainer']['staff_kana_lastname'],
			"staff_kana_firstname" => $add_data['trainer']['staff_kana_firstname'],
			"type" => $add_data['trainer']['type'],
			"team_id" => $team_id
		);
		if($trainer){
			$staff_id = $trainer['staff_id'];
			$ret = $dbobj->updateTable("staff", $staffInsert, array("staff_id" => $staff_id));
		}else{
			$ret = $dbobj->queryInsertPrepare("staff", $staffInsert);
			$staff_id = $ret;
		}
		if($tournament_id){
			$tournament_staff = get_tournament_staff($tournament_id, $staff_id);
			if(!$tournament_staff){
				$tournament_staffInsert = array(
					"tournament_id" => $tournament_id,
					"staff_id" => $staff_id
				);
				$ret = $dbobj->queryInsertPrepare("tournament_staff", $tournament_staffInsert);
			}
		}
	}

	//マネージャー登録
	if($add_data['manager']['staff_lastname'] && $add_data['manager']['staff_firstname']){
		$manager = get_staff_list4name($team_id, $add_data['manager']['position_id'], $add_data['manager']['staff_lastname'], $add_data['manager']['staff_firstname'], $add_data['manager']['staff_kana_lastname'], $add_data['manager']['staff_kana_firstname']);
		$staffInsert = array(
			"position_id" => $add_data['manager']['position_id'],
			"staff_lastname" => $add_data['manager']['staff_lastname'],
			"staff_firstname" => $add_data['manager']['staff_firstname'],
			"staff_kana_lastname" => $add_data['manager']['staff_kana_lastname'],
			"staff_kana_firstname" => $add_data['manager']['staff_kana_firstname'],
			"type" => $add_data['manager']['type'],
			"team_id" => $team_id
		);
		if($manager){
			$staff_id = $manager['staff_id'];
			$ret = $dbobj->updateTable("staff", $staffInsert, array("staff_id" => $staff_id));
		}else{
			$ret = $dbobj->queryInsertPrepare("staff", $staffInsert);
			$staff_id = $ret;
		}
		if($tournament_id){
			$tournament_staff = get_tournament_staff($tournament_id, $staff_id);
			if(!$tournament_staff){
				$tournament_staffInsert = array(
					"tournament_id" => $tournament_id,
					"staff_id" => $staff_id
				);
				$ret = $dbobj->queryInsertPrepare("tournament_staff", $tournament_staffInsert);
			}
		}
	}

	//部長登録
	if($add_data['chief']['staff_lastname'] && $add_data['chief']['staff_firstname']){
		$chief = get_staff_list4name($team_id, $add_data['chief']['position_id'], $add_data['chief']['staff_lastname'], $add_data['chief']['staff_firstname'], $add_data['chief']['staff_kana_lastname'], $add_data['chief']['staff_kana_firstname']);
		$staffInsert = array(
			"position_id" => $add_data['chief']['position_id'],
			"staff_lastname" => $add_data['chief']['staff_lastname'],
			"staff_firstname" => $add_data['chief']['staff_firstname'],
			"staff_kana_lastname" => $add_data['chief']['staff_kana_lastname'],
			"staff_kana_firstname" => $add_data['chief']['staff_kana_firstname'],
			"type" => $add_data['chief']['type'],
			"team_id" => $team_id
		);
		if($chief){
			$staff_id = $chief['staff_id'];
			$ret = $dbobj->updateTable("staff", $staffInsert, array("staff_id" => $staff_id));
		}else{
			$ret = $dbobj->queryInsertPrepare("staff", $staffInsert);
			$staff_id = $ret;
		}
		if($tournament_id){
			$tournament_staff = get_tournament_staff($tournament_id, $staff_id);
			if(!$tournament_staff){
				$tournament_staffInsert = array(
					"tournament_id" => $tournament_id,
					"staff_id" => $staff_id
				);
				$ret = $dbobj->queryInsertPrepare("tournament_staff", $tournament_staffInsert);
			}
		}
	}

	//連絡・申込責任者登録
	if($add_data['person']['staff_lastname'] && $add_data['person']['staff_firstname']){
		$person = get_staff_list4name($team_id, $add_data['person']['position_id'], $add_data['person']['staff_lastname'], $add_data['person']['staff_firstname'], $add_data['person']['staff_kana_lastname'], $add_data['person']['staff_kana_firstname']);
		$staffInsert = array(
			"position_id" => $add_data['person']['position_id'],
			"staff_lastname" => $add_data['person']['staff_lastname'],
			"staff_firstname" => $add_data['person']['staff_firstname'],
			"staff_kana_lastname" => $add_data['person']['staff_kana_lastname'],
			"staff_kana_firstname" => $add_data['person']['staff_kana_firstname'],
			"type" => $add_data['person']['type'],
			"team_id" => $team_id
		);
		if($person){
			$staff_id = $person['staff_id'];
			$ret = $dbobj->updateTable("staff", $staffInsert, array("staff_id" => $staff_id));
		}else{
			$ret = $dbobj->queryInsertPrepare("staff", $staffInsert);
			$staff_id = $ret;
		}
		if($tournament_id){
			$tournament_staff = get_tournament_staff($tournament_id, $staff_id);
			if(!$tournament_staff){
				$tournament_staffInsert = array(
					"tournament_id" => $tournament_id,
					"staff_id" => $staff_id
				);
				$ret = $dbobj->queryInsertPrepare("tournament_staff", $tournament_staffInsert);
			}
		}
	}

	//帯同員登録
	if($add_data['along']['staff_lastname'] && $add_data['along']['staff_firstname']){
		$along = get_staff_list4name($team_id, $add_data['along']['position_id'], $add_data['along']['staff_lastname'], $add_data['along']['staff_firstname'], $add_data['along']['staff_kana_lastname'], $add_data['along']['staff_kana_firstname']);
		$staffInsert = array(
			"position_id" => $add_data['along']['position_id'],
			"staff_lastname" => $add_data['along']['staff_lastname'],
			"staff_firstname" => $add_data['along']['staff_firstname'],
			"staff_kana_lastname" => $add_data['along']['staff_kana_lastname'],
			"staff_kana_firstname" => $add_data['along']['staff_kana_firstname'],
			"type" => $add_data['along']['type'],
			"team_id" => $team_id
		);
		if($along){
			$staff_id = $along['staff_id'];
			$ret = $dbobj->updateTable("staff", $staffInsert, array("staff_id" => $staff_id));
		}else{
			$ret = $dbobj->queryInsertPrepare("staff", $staffInsert);
			$staff_id = $ret;
		}
		if($tournament_id){
			$tournament_staff = get_tournament_staff($tournament_id, $staff_id);
			if(!$tournament_staff){
				$tournament_staffInsert = array(
					"tournament_id" => $tournament_id,
					"staff_id" => $staff_id
				);
				$ret = $dbobj->queryInsertPrepare("tournament_staff", $tournament_staffInsert);
			}
		}
	}

	//キャプテン登録
	if($add_data['captain']['staff_lastname'] && $add_data['captain']['staff_firstname']){
		$captain = get_staff_list4name($team_id, $add_data['captain']['position_id'], $add_data['captain']['staff_lastname'], $add_data['captain']['staff_firstname'], $add_data['captain']['staff_kana_lastname'], $add_data['captain']['staff_kana_firstname']);
		$staffInsert = array(
			"position_id" => $add_data['captain']['position_id'],
			"staff_lastname" => $add_data['captain']['staff_lastname'],
			"staff_firstname" => $add_data['captain']['staff_firstname'],
			"staff_kana_lastname" => $add_data['captain']['staff_kana_lastname'],
			"staff_kana_firstname" => $add_data['captain']['staff_kana_firstname'],
			"type" => $add_data['captain']['type'],
			"team_id" => $team_id
		);
		if($captain){
			$staff_id = $captain['staff_id'];
			$ret = $dbobj->updateTable("staff", $staffInsert, array("staff_id" => $staff_id));
		}else{
			$ret = $dbobj->queryInsertPrepare("staff", $staffInsert);
			$staff_id = $ret;
		}
		if($tournament_id){
			$tournament_staff = get_tournament_staff($tournament_id, $staff_id);
			if(!$tournament_staff){
				$tournament_staffInsert = array(
					"tournament_id" => $tournament_id,
					"staff_id" => $staff_id
				);
				$ret = $dbobj->queryInsertPrepare("tournament_staff", $tournament_staffInsert);
			}
		}
	}

	//選手登録
	foreach($add_data['player'] as $key => $value){
		$player = get_player_list4name($team_id, $value['player_lastname'], $value['player_firstname'], $value['player_kana_lastname'], $value['player_kana_firstname']);
		$playerInsert = array(
			"uniform_number" => $value['uniform_number'],
			"player_lastname" => $value['player_lastname'],
			"player_firstname" => $value['player_firstname'],
			"player_kana_lastname" => $value['player_kana_lastname'],
			"player_kana_firstname" => $value['player_kana_firstname'],
			"school_year" => $value['school_year'],
			"tall" => $value['tall'],
			"team_id" => $team_id,
			"published_flag" => $value['published_flag']
		);
		if($player){
			$player_id = $player['player_id'];
			$ret = $dbobj->updateTable("player", $playerInsert, array("player_id" => $player_id));
		}else{
			$ret = $dbobj->queryInsertPrepare("player", $playerInsert);
			$player_id = $ret;
		}
		if($tournament_id){
			$tournament_player = get_tournament_player($tournament_id, $player_id);
			if(!$tournament_player){
				$tournament_playerInsert = array(
					"tournament_id" => $tournament_id,
					"player_id" => $player_id
				);
				$ret = $dbobj->queryInsertPrepare("tournament_player", $tournament_playerInsert);
			}
		}
	}

	//unlink(EXCEL_DIR . $file_name);
	if(!$ret){
		unset($_SESSION[SESSION_NAME]);
		$_SESSION[SESSION_NAME]['ERRORMSG'][] = mb_convert_encoding("何らかの理由でエントリーシート登録に失敗しました", "utf8", "SJIS");
		header('Location: ' . $redirect_url);
		exit;
	}else{
		unset($_SESSION[SESSION_NAME]);
		$_SESSION[SESSION_NAME]['SUCCESSMSG'][] = mb_convert_encoding("エントリーシート登録が完了しました", "utf8", "SJIS");
		header('Location: ' . $redirect_url);
		exit;
	}
?>