<?php 
//*****************************************************************************
//* 
//* プログラム名：祝日一括登録
//* プログラムID：CON011_3_1
//* 機能        ：祝日一括登録する
//* 作成者      ：荒内
//* 
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");

//***************************
//*　インクルードファイル
//***************************
include("include/session_start.inc");							//セッション開始
include("include/SessionChk.inc");								//セッションチェック
include("include/dbcon.inc");											//DB接続

//seq番号取得
$strSql = "SELECT MAX(seq) as a FROM holiday_tbl";
$rsResult = pg_exec($pg_con,$strSql);
$intSeq = pg_result($rsResult,0,"a");

//元日(1月1日)
$holiday_name="元旦";
$strHoliday=date("Y/m/d", mktime(0,0,0,"01","01",$holiday_year));
$intYobi=date("w", mktime(0,0,0,"01","01",$holiday_year));
$intSeq=$intSeq+1;
$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
$rsResult = pg_exec($pg_con,$strSql);
if ($intYobi==0){
	$strHoliday=date("Y/m/d", mktime(0,0,0,"01","02",$holiday_year));
	$holiday_name="振替休日";
	$intSeq=$intSeq+1;
	$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
	$rsResult = pg_exec($pg_con,$strSql);
}

//成人の日(1月第2月曜日)
$intSetCnt=0;
$holiday_mon="01";
$holiday_day="01";
$holiday_name="成人の日";
$intSeq=$intSeq+1;
$intMax=date("t", mktime(0,0,0,$holiday_mon,$holiday_day,$holiday_year));
for ($intCnt = 0; $intCnt < $intMax; $intCnt++) {
	$intYobi=date("w", mktime(0,0,0,$holiday_mon,$holiday_day+$intCnt,$holiday_year));
	$strHoliday=date("Y/m/d", mktime(0,0,0,$holiday_mon,$holiday_day+$intCnt,$holiday_year));
	if ($intYobi==1){
		$intSetCnt=$intSetCnt+1;
		if ($intSetCnt==2){
			$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
			$rsResult = pg_exec($pg_con,$strSql);
			break;
		}
	}
}

//建国記念の日(2月11日)
$holiday_name="建国記念日";
$strHoliday=date("Y/m/d", mktime(0,0,0,"02","11",$holiday_year));
$intYobi=date("w", mktime(0,0,0,"02","11",$holiday_year));
$intSeq=$intSeq+1;
$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
$rsResult = pg_exec($pg_con,$strSql);
if ($intYobi==0){
	$strHoliday=date("Y/m/d", mktime(0,0,0,"02","12",$holiday_year));
	$holiday_name="振替休日";
	$intSeq=$intSeq+1;
	$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
	$rsResult = pg_exec($pg_con,$strSql);
}

//春分の日(3月21日)
$holiday_mon="03";
/*
if (($holiday_year=="2003") || ($holiday_year=="2004") || ($holiday_year=="2005") || 
	($holiday_year=="2008") || ($holiday_year=="2009") || ($holiday_year=="2012") || 
	($holiday_year=="2014") || ($holiday_year=="2015") || ($holiday_year=="2018") || 
	($holiday_year=="2019") || ($holiday_year=="2022") || ($holiday_year=="2023") || 
	($holiday_year=="2027") ){
	$holiday_day="20";
}
else {
	$holiday_day="21";
}
*/
switch($holiday_year){	//2000〜2030
	case "2000";
	case "2001";
	case "2004";
	case "2005";
	case "2008";
	case "2009";
	case "2012";
	case "2013";
	case "2016";
	case "2017";
	case "2020";
	case "2021";
	case "2024";
	case "2025";
	case "2026";
	case "2028";
	case "2029";
	case "2030";
		$holiday_day="20";
		break;
	default;
		$holiday_day="21";
		break;
}

$holiday_name="春分の日";
$strHoliday=date("Y/m/d", mktime(0,0,0,$holiday_mon,$holiday_day,$holiday_year));
$intYobi=date("w", mktime(0,0,0,$holiday_mon,$holiday_day,$holiday_year));
$intSeq=$intSeq+1;
$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
$rsResult = pg_exec($pg_con,$strSql);
if ($intYobi==0){
	$strHoliday=date("Y/m/d", mktime(0,0,0,$holiday_mon,$holiday_day+1,$holiday_year));
	$holiday_name="振替休日";
	$intSeq=$intSeq+1;
	$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
	$rsResult = pg_exec($pg_con,$strSql);
}

//みどりの日(4月29日)
//$holiday_name="みどりの日";
$holiday_name="昭和の日";
$strHoliday=date("Y/m/d", mktime(0,0,0,"04","29",$holiday_year));
$intYobi=date("w", mktime(0,0,0,"04","29",$holiday_year));
$intSeq=$intSeq+1;
$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
$rsResult = pg_exec($pg_con,$strSql);
if ($intYobi==0){
	$strHoliday=date("Y/m/d", mktime(0,0,0,"04","30",$holiday_year));
	$holiday_name="振替休日";
	$intSeq=$intSeq+1;
	$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
	$rsResult = pg_exec($pg_con,$strSql);
}

//憲法記念日(5月3日)
$holiday_name="憲法記念日";
$strHoliday=date("Y/m/d", mktime(0,0,0,"05","03",$holiday_year));
$intYobi=date("w", mktime(0,0,0,"05","03",$holiday_year));
$intSeq=$intSeq+1;
$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
$rsResult = pg_exec($pg_con,$strSql);
if ($intYobi==0){
	$strHoliday=date("Y/m/d", mktime(0,0,0,"05","04",$holiday_year));
	$holiday_name="振替休日";
	$intSeq=$intSeq+1;
	$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
	$rsResult = pg_exec($pg_con,$strSql);
}

//国民の休日(5月4日)
//$holiday_name="国民の休日";
$holiday_name="みどりの日";
$strHoliday=date("Y/m/d", mktime(0,0,0,"05","04",$holiday_year));
$intYobi=date("w", mktime(0,0,0,"05","04",$holiday_year));
$intSeq=$intSeq+1;
$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
$rsResult = pg_exec($pg_con,$strSql);
if ($intYobi==0){
	$strHoliday=date("Y/m/d", mktime(0,0,0,"05","05",$holiday_year));
	$holiday_name="振替休日";
	$intSeq=$intSeq+1;
	$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
	$rsResult = pg_exec($pg_con,$strSql);
}

//こどもの日(5月5日)
$holiday_name="こどもの日";
$strHoliday=date("Y/m/d", mktime(0,0,0,"05","05",$holiday_year));
$intYobi=date("w", mktime(0,0,0,"05","05",$holiday_year));
$intSeq=$intSeq+1;
$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
$rsResult = pg_exec($pg_con,$strSql);
if ($intYobi==0){
	$strHoliday=date("Y/m/d", mktime(0,0,0,"05","06",$holiday_year));
	$holiday_name="振替休日";
	$intSeq=$intSeq+1;
	$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
	$rsResult = pg_exec($pg_con,$strSql);
}

//海の日(7月第3月曜日)
$intSetCnt=0;
$holiday_mon="07";
$holiday_day="01";
$holiday_name="海の日";
$intSeq=$intSeq+1;
$intMax=date("t", mktime(0,0,0,$holiday_mon,$holiday_day,$holiday_year));
for ($intCnt = 0; $intCnt < $intMax; $intCnt++) {
	$intYobi=date("w", mktime(0,0,0,$holiday_mon,$holiday_day+$intCnt,$holiday_year));
	$strHoliday=date("Y/m/d", mktime(0,0,0,$holiday_mon,$holiday_day+$intCnt,$holiday_year));
	if ($intYobi==1){
		$intSetCnt=$intSetCnt+1;
		if ($intSetCnt==3){
			$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
			$rsResult = pg_exec($pg_con,$strSql);
			break;
		}
	}
}

//山の日(8月11日)
$holiday_name="山の日";
$strHoliday=date("Y/m/d", mktime(0,0,0,"08","11",$holiday_year));
$intYobi=date("w", mktime(0,0,0,"08","11",$holiday_year));
$intSeq=$intSeq+1;
$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
$rsResult = pg_exec($pg_con,$strSql);
if ($intYobi==0){
	$strHoliday=date("Y/m/d", mktime(0,0,0,"08","12",$holiday_year));
	$holiday_name="振替休日";
	$intSeq=$intSeq+1;
	$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
	$rsResult = pg_exec($pg_con,$strSql);
}

//敬老の日(9月第3月曜日)
$intSetCnt=0;
$holiday_mon="09";
$holiday_day="01";
$holiday_name="敬老の日";
$intSeq=$intSeq+1;
$intMax=date("t", mktime(0,0,0,$holiday_mon,$holiday_day,$holiday_year));
for ($intCnt = 0; $intCnt < $intMax; $intCnt++) {
	$intYobi=date("w", mktime(0,0,0,$holiday_mon,$holiday_day+$intCnt,$holiday_year));
	$strHoliday=date("Y/m/d", mktime(0,0,0,$holiday_mon,$holiday_day+$intCnt,$holiday_year));
	if ($intYobi==1){
		$intSetCnt=$intSetCnt+1;
		if ($intSetCnt==3){
			$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
			$rsResult = pg_exec($pg_con,$strSql);
			break;
		}
	}
}

//秋分の日(9月23日)
/*	$holiday_name="秋分の日";
$strHoliday=date("Y/m/d", mktime(0,0,0,"09","23",$holiday_year));
$intYobi=date("w", mktime(0,0,0,"09","23",$holiday_year));
$intSeq=$intSeq+1;
$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
$rsResult = pg_exec($pg_con,$strSql);
if ($intYobi==0){
	$strHoliday=date("Y/m/d", mktime(0,0,0,"09","24",$holiday_year));
	$holiday_name="振替休日";
	$intSeq=$intSeq+1;
	$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
	$rsResult = pg_exec($pg_con,$strSql);
}
*/

$holiday_mon="09";
if (($holiday_year=="2012") || ($holiday_year=="2016") || ($holiday_year=="2020") || 
	($holiday_year=="2024") || ($holiday_year=="2028")) {
	$holiday_day="22";
}
else {
	$holiday_day="23";
}
$holiday_name="秋分の日";
$strHoliday=date("Y/m/d", mktime(0,0,0,$holiday_mon,$holiday_day,$holiday_year));
$intYobi=date("w", mktime(0,0,0,$holiday_mon,$holiday_day,$holiday_year));
$intSeq=$intSeq+1;
$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
$rsResult = pg_exec($pg_con,$strSql);
if ($intYobi==0){
	$strHoliday=date("Y/m/d", mktime(0,0,0,$holiday_mon,$holiday_day+1,$holiday_year));
	$holiday_name="振替休日";
	$intSeq=$intSeq+1;
	$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
	$rsResult = pg_exec($pg_con,$strSql);
}

//体育の日(10月第2月曜日)
$intSetCnt=0;
$holiday_mon="10";
$holiday_day="01";
$holiday_name="体育の日";
$intSeq=$intSeq+1;
$intMax=date("t", mktime(0,0,0,$holiday_mon,$holiday_day,$holiday_year));
for ($intCnt = 0; $intCnt < $intMax; $intCnt++) {
	$intYobi=date("w", mktime(0,0,0,$holiday_mon,$holiday_day+$intCnt,$holiday_year));
	$strHoliday=date("Y/m/d", mktime(0,0,0,$holiday_mon,$holiday_day+$intCnt,$holiday_year));
	if ($intYobi==1){
		$intSetCnt=$intSetCnt+1;
		if ($intSetCnt==2){
			$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
			$rsResult = pg_exec($pg_con,$strSql);
			break;
		}
	}
}

//文化の日(11月3日)
$holiday_name="文化の日";
$strHoliday=date("Y/m/d", mktime(0,0,0,"11","03",$holiday_year));
$intYobi=date("w", mktime(0,0,0,"11","03",$holiday_year));
$intSeq=$intSeq+1;
$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
$rsResult = pg_exec($pg_con,$strSql);
if ($intYobi==0){
	$strHoliday=date("Y/m/d", mktime(0,0,0,"11","04",$holiday_year));
	$holiday_name="振替休日";
	$intSeq=$intSeq+1;
	$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
	$rsResult = pg_exec($pg_con,$strSql);
}

//勤労感謝の日(11月23日)
$holiday_name="勤労感謝の日";
$strHoliday=date("Y/m/d", mktime(0,0,0,"11","23",$holiday_year));
$intYobi=date("w", mktime(0,0,0,"11","23",$holiday_year));
$intSeq=$intSeq+1;
$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
$rsResult = pg_exec($pg_con,$strSql);
if ($intYobi==0){
	$strHoliday=date("Y/m/d", mktime(0,0,0,"11","24",$holiday_year));
	$holiday_name="振替休日";
	$intSeq=$intSeq+1;
	$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
	$rsResult = pg_exec($pg_con,$strSql);
}

//天皇誕生日(12月23日)
$holiday_name="天皇誕生日";
$strHoliday=date("Y/m/d", mktime(0,0,0,"12","23",$holiday_year));
$intYobi=date("w", mktime(0,0,0,"12","23",$holiday_year));
$intSeq=$intSeq+1;
$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
$rsResult = pg_exec($pg_con,$strSql);
if ($intYobi==0){
	$strHoliday=date("Y/m/d", mktime(0,0,0,"12","24",$holiday_year));
	$holiday_name="振替休日";
	$intSeq=$intSeq+1;
	$strSql="INSERT INTO holiday_tbl VALUES($intSeq,'$strHoliday','$holiday_name')";
	$rsResult = pg_exec($pg_con,$strSql);
}

header("Location: CON011.php");

?>