demo_SIM0011.php 2.76 KB
<?PHP 
//*****************************************************************************
//* プログラム名:ユーザログインチェック
//* プログラムID:SIM0011.php
//* 機能        :グループログインチェック
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
include("./inc/session_start.inc");
include("./inc/dbcon.inc");
include('./inc/smarty.conf');

$errFlg = 1;

session_unregister("PHP_BUMON_SEQ");
session_unregister("PHP_BUMON_NAME");
session_unregister("PHP_BUMON_ADMIN");
session_unregister("PHP_USER_SEQ");
session_unregister("PHP_USER_NAME");
session_unregister("PHP_USER_ADMIN");
session_unregister("PHP_USER_NYUKIN");
session_unregister("PHP_USER_SHIKIN");

$useq = trim($_POST["useq"]);
$upw = trim($_POST["upw"]);

$strSQL  = "SELECT bm.bumon_seq, bm.bumon_name, bm.all_flg, us.user_seq, us.user_namekj, "; 
$strSQL .= "us.admin_flg, us.nyukin_flg, us.shikin_flg FROM user_inf AS us ";
$strSQL .= "INNER JOIN bumon_tbl AS bm ON (us.bumon_seq =  bm.bumon_seq) ";
$strSQL .= "WHERE us.user_seq = 2";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
}

if (pg_numrows($objRecSet) == 1) {
		$objData = pg_fetch_object($objRecSet, 0);
		$PHP_BUMON_SEQ=($objData->bumon_seq);
		$PHP_BUMON_NAME=($objData->bumon_name);
		$PHP_BUMON_ADMIN=($objData->all_flg);
		$PHP_USER_SEQ=($objData->user_seq);
		$PHP_USER_NAME=($objData->user_namekj);
		$PHP_USER_ADMIN=($objData->admin_flg);
		$PHP_USER_NYUKIN=($objData->nyukin_flg);
		$PHP_USER_SHIKIN=($objData->shikin_flg);

		session_register("PHP_BUMON_SEQ");
		session_register("PHP_BUMON_NAME");
		session_register("PHP_BUMON_ADMIN");
		session_register("PHP_USER_SEQ");
		session_register("PHP_USER_NAME");
		session_register("PHP_USER_ADMIN");
		session_register("PHP_USER_NYUKIN");
		session_register("PHP_USER_SHIKIN");
		setcookie("cookie_user_cd",$useq,time() + 604800);

		$errFlg = 0;
		
}else{
		$errFlg = 1;
}

if($errFlg == 0){
		header("Location:./SIM1000.php");
		exit;
}else{
?>
<html>
<head>
<meta http-equiv="content-type" content="text/html; cahrset=euc-jp">
<meta http-equiv="content-style-type" content="text/css">
<meta name="robots" content="noindex, nofollow">
<title></title>
<script language="javascript">
function trans(){
	document.frm.action = "SIM0010.php";
	document.frm.method="POST";
	document.frm.submit();
}
</script>
</head>
<body onload="trans();">
<form name="frm">

<input type="hidden" name="gid" value="<?PHP  echo trim($_POST["gid"])?>">
<input type="hidden" name="gpw" value="<?PHP  echo trim($_POST["gpw"])?>">
<input type="hidden" name="uid" value="<?PHP  echo trim($_POST["useq"])?>">
<input type="hidden" name="upw" value="<?PHP  echo trim($_POST["upw"])?>">

</form>
</body>
</html>
<?PHP 
}
?>