<?php 
//在席表示更新処理

header("Content-type: text/html; charset=EUC-JP");

include("include/session_start.inc");
include("include/SessionChk.inc");

$strDBinc="include/dbcon.inc";

include($strDBinc);

$strSQL="";
$objRec="null";

$strSQL = "delete from kojin_data_tbl where seq = 16 and syain_cd ='".$PHP_SYAIN_CD."'";
$objRec = pg_exec($strSQL);
if($objRec == false){
	echo("SQL実行に失敗しました(DELETE)");
	exit;
}

$strSQL = "delete from kojin_data_tbl where seq = 17 and syain_cd ='".$PHP_SYAIN_CD."'";
$objRec = pg_exec($strSQL);
if($objRec == false){
	echo("SQL実行に失敗しました(DELETE)");
	exit;
}


$strSQL = "insert into kojin_data_tbl (syain_cd, seq, memo) values('".$PHP_SYAIN_CD."', 16, '".$absence."')";
$objRec = pg_exec($strSQL);
if($objRec == false){
	echo("SQL実行に失敗しました(INSERT)");
	exit;
}

$strSQL = "insert into kojin_data_tbl (syain_cd, seq, memo) values('".$PHP_SYAIN_CD."', 17, '".Date("Y/m/d H:i")."')";
$objRec = pg_exec($strSQL);
if($objRec == false){
	echo("SQL実行に失敗しました(INSERT)");
	exit;
}

exit;
?>