<?php
	$page_settings = array(
		'formid'     => 'Approval', // for permission
		'section'    => 'Master', // parent/page title
		'subsection' => 'Public Holiday', // page title
		'domain'     => 'public_holiday', // table/model name
		'access'     => 'GNr', // for permission
	);
	require_once "check_login.php";

	if ($_REQUEST["action"] == "ADD" || $_REQUEST["action"] == "MODIFY") {

		$message = "";

		if (empty($_POST["date"])) {
			$message .= _lang("Please enter Date.") . "\\n\\n";
		} else {
			if (!validateDate($_POST["date"], "Y-m-d")) {
				$message .= _lang("Please enter correct Date.") . "\\n\\n";
			}
		}

		if (empty($_POST["remark"])) {
			$message .= _lang("Please enter Remark.") . "\\n\\n";
		}

		if (!empty($message)) {
			echo "<script>alert('" . $message . "'); history.back();</script>";
			exit;
		}
	}

	if ($_REQUEST["action"] == "ADD") {
		$sql        = "insert into public_holiday (`date`, remark, createby, createdate, lastupby, lastupdate) value (?, ?, ?, ?, ?, ?)";
		$parameters = array($_POST["date"], $_POST["remark"], $_SESSION["cmsloginid"], date("Y-m-d H:i:s"), $_SESSION["cmsloginid"], date("Y-m-d H:i:s"));

		bind_pdo($sql, $parameters);

		header("Location: " . $page_settings["domain"] . "_index.php?msg=1");
	} else if ($_REQUEST["action"] == "MODIFY") {

		$sql        = "update public_holiday set `date`=?, remark=?, lastupby=?, lastupdate=?";
		$parameters = array($_POST["date"], $_POST["remark"], $_SESSION['cmsloginid'], $nowdate);
		$sql .= " where id = ?";
		$parameters[] = (int)$_POST["id"];

		bind_pdo($sql, $parameters);

		header("Location: " . $page_settings["domain"] . "_index.php?msg=2");
	} else if ($_REQUEST["action"] == "DELETE") {
		$id = (int)$_GET["id"];

		$sql        = "update public_holiday set deleted = ?, lastupdate=?, lastupby=? where id = ?";
		$parameters = array(1, date("Y-m-d H:i:s"), $_SESSION['cmsloginid'], $id);
		bind_pdo($sql, $parameters);

		header("Location: " . $page_settings["domain"] . "_index.php?msg=2");
	}