<?php
	require_once('../inc/configure.php');
	session_start();
	if(!empty($_SESSION['webadmin'])){
		$nowdate = date("Y-m-d H:i:s");

			$holiday_ids = $_POST["holiday_id"];
			$remarks= $_POST["remarks"];
			$holiday_dates= $_POST["holiday_date"];

			foreach($holiday_ids as $holiday_id){
				$sql = "update sup_public_holiday set holiday_date=?, remarks=?, lastupdate=?, lastupby=? where id=?";

				$parameters = array($holiday_dates[$holiday_id],$remarks[$holiday_id],$nowdate,$_SESSION['webadmin']['id'],$holiday_id);
				if (!($sth = $dbh->prepare($sql))) {
					throw new Exception("sql prepare statement failure: $sql");
				}
				$sth->setFetchMode(PDO::FETCH_ASSOC);
				if (!$sth->execute($parameters)) {
					throw new Exception("sql execute statement failure: $sql");
				}
			}


			//delete this holiday
			if(isset($_GET["delete_holiday"]) && $_GET["delete_holiday"] == 1){
				$holiday_id = (int)$_GET["holiday_id"];
				$sql = "delete from sup_public_holiday where id = ?";

				$parameters = array($holiday_id);
				if (!($sth = $dbh->prepare($sql))) {
					throw new Exception("sql prepare statement failure: $sql");
				}
				$sth->setFetchMode(PDO::FETCH_ASSOC);
				if (!$sth->execute($parameters)) {
					throw new Exception("sql execute statement failure: $sql");
				}
				header("Location: holiday_index.php" );

			}

		header("Location: holiday_index.php" );



	}
?>