<?PHP 
//*****************************************************************************
//* 
//* プログラム名：ユーザー情報更新
//* プログラムID：user_updateExec.php
//* 機能        ：ユーザー情報データを更新する
//* 作成者      ：Y.Ogawa(MTC)
//* 
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
//***************************
//*　インクルードファイル
//***************************
include("../../include/session_start.inc");
include("../../include/SessionChk2.inc");
include("../../include/dbcon.inc");
include("../../include/jcode.phps");

//***************************
//*　内部変数
//***************************
$objConn			= null;	//接続オブジェクト
$strSQL				= "";	//SQL文

$strKey				= "";	//ユーザーＣＤ
$strUser_Id         = ""; 	//ユーザーＩＤ
$strUser_Pass	    = "";	//パスワード
$strUser_Nm		    = "";	//氏名
$strGroup_Id	    = "";	//上位グループID
$strMailAddress		= "";	//携帯メールアドレス
$strPcMailAddress	= "";	//ＰＣメールアドレス


//***************************
//* メイン処理
//***************************

//ユーザーＣＤ
$strKey = $key;

$strUser_Id = $user_id;
if ($strUser_Id == ""){
	$strUser_Id = "NULL";
	$strD_id = "　";
}else{
	$strD_id = $strUser_Id;
	$strUser_Id = "'" . JcodeConvert($strUser_Id, 1, 1) . "'";
}

//パスワード
$strUser_Pass = $user_pass;
if ($strUser_Pass == ""){
	$strUser_Pass = "NULL";
}else{
	$strUser_Pass = "'" . mb_convert_encoding($strUser_Pass, "EUC-JP", "ASCII,JIS,UTF-8,EUC-JP,SJIS") . "'";
}

//氏名
$strSei_Kj = "'" . JcodeConvert($sei_kj, 1, 1) . "'";
$strMei_Kj = "'" . JcodeConvert($mei_kj, 1, 1) . "'";
$strSei_Kn = "'" . JcodeConvert($sei_kn, 1, 1) . "'";
$strMei_Kn = "'" . JcodeConvert($mei_kn, 1, 1) . "'";

if ($sex == "t"){
	$strSex = "'true'";
}else{
	$strSex = "'false'";
}

//郵便１
if (($yubin_no1 == "")&&($yubin_no2 == "")){
	$strYubin_No = "NULL";
}else{
	$strYubin_No = "'" . $yubin_no1 . $yubin_no2 . "'";
}

//住所１
$strAddrPref = $address1;
if ($strAddrPref == ""){
	$strAddrPref = "NULL";
}else{
	$strAddrPref = "'" . JcodeConvert($strAddrPref, 1, 1) . "'";
}

//住所２
$strAddrCity = $address2;
if ($strAddrCity == ""){
	$strAddrCity = "NULL";
}else{
	$strAddrCity = "'" . JcodeConvert($strAddrCity, 1, 1) . "'";
}

//住所３
$strAddrBanti = $address3;
if ($strAddrBanti == ""){
	$strAddrBanti = "NULL";
}else{
	$strAddrBanti = "'" . JcodeConvert($strAddrBanti, 1, 1) . "'";
}

//住所４
$strAddrApart = $address4;
if ($strAddrApart == ""){
	$strAddrApart = "NULL";
}else{
	$strAddrApart = "'" . JcodeConvert($strAddrApart, 1, 1) . "'";
}

//自宅電話番号
$strTel_no = $tel_no1 . $tel_no2 . $tel_no3;
if ($strTel_no == ""){
	$strTel_no = "NULL";
}else{
	$strTel_no = "'" . $tel_no1 . "-" . $tel_no2 . "-" .$tel_no3 . "'";
}

//携帯電話番号
$strKeitai_no = $keitai_no1 . $keitai_no2 . $keitai_no3;
if ($strKeitai_no == ""){
	$strKeitai_no = "NULL";
}else{
	$strKeitai_no = "'" . $keitai_no1 . "-" . $keitai_no2 . "-" .$keitai_no3 . "'";
}

//携帯メールアドレス
$strMailAddress = $mail_address;
if ($strMailAddress == ""){
	$strMailAddress = "NULL";
}else{
	$strMailAddress = "'" . $strMailAddress . "'";
}

//ＰＣメールアドレス
$strPcMailAddress = $pcmail_address;
if ($strPcMailAddress == ""){
	$strPcMailAddress = "NULL";
}else{
	$strPcMailAddress = "'" . $strPcMailAddress . "'";
}

$strSQL = "UPDATE syain_tbl SET " .
		  "syain_id = " . $strUser_Id . ", " .
	      "password = " . $strUser_Pass . ", " .
	      "name_kj_sei = " . $strSei_Kj . ", " .
	      "name_kj_mei = " . $strMei_Kj . ", " .
	      "name_kn_sei = " . $strSei_Kn . ", " .
	      "name_kn_mei = " . $strMei_Kn . ", " .
	      "sex = " . $strSex . ", " .
	      "mail_addr = " . $strMailAddress . ", " .
	      "pc_mail_addr = " . $strPcMailAddress . ", " .
	      "yubin_no = " . $strYubin_No . ", " .
	      "addr_pref = " . $strAddrPref . ", " .
	      "addr_city = " . $strAddrCity . ", " .
	      "addr_banti = " . $strAddrBanti . ", " .
	      "addr_apart = " . $strAddrApart . ", " .
	      "tel_no = " . $strTel_no . ", " .
	      "keitai_no = " . $strKeitai_no . " " .
          "WHERE syain_cd = '" . $strKey . "'";
          
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
    echo("SQL実行に失敗しました(UPDATE)");
    exit;
}

//GROUP_INFO書込み
$strSQL = "DELETE FROM group_info WHERE syain_cd = '" . $strKey . "'";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
    echo("SQL実行に失敗しました(DELETE)");
    exit;
}

if ($bumon_num==0){
	$strSQL = "INSERT INTO group_info (" .
	          "syain_cd," .
	          "group_id )" .
			  "VALUES (" .
	          "'" . $strKey . "'," .
	          "'" . $strpras . "')";
	
	$objRecSet = pg_exec($strSQL);
	if($objRecSet==false){
	    echo("SQL実行に失敗しました(INSERT)");
	    exit;
	}
}else{
	$strBumonArray=split("/",$strpras);
    for ($i = 0 ; $i <= $bumon_num-1 ; $i++) {
    
    	$strSQL = "INSERT INTO group_info (" .
    	          "syain_cd," .
    	          "group_id )" .
    			  "VALUES (" .
    	          "'" . $strKey . "'," .
    	          "'" . $strBumonArray[$i] . "')";
    	
    	$objRecSet = pg_exec($strSQL);
    	if($objRecSet==false){
    	    echo("SQL実行に失敗しました(INSERT)");
    	    exit;
    	}
    }
}


//メモ欄書き込み
$strSQL = "DELETE FROM syain_biko_tbl WHERE syain_cd = '" . $strKey . "'";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
    echo("SQL実行に失敗しました(DELETE)");
    exit;
}

$strSQL="INSERT INTO syain_biko_tbl ( syain_cd,biko ) VALUES ".
		"(".$strKey . ","."'".$biko."')";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
    echo("SQL実行に失敗しました(INSERT)");
    exit;
}


?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=EUC-JP">
<META http-equiv="Content-Style-Type" content="text/css">
<CENTER>
<TITLE>更新結果</TITLE>
</HEAD>
<BODY bgcolor="White">
<TABLE border=1 bordercolor="#008080" width="544">
<TBODY>
  <!--<TR>
    <TD bgcolor="#FFCC99" Width="50%"><B><FONT size="2">ユーザーＩＤ</FONT></B></TD>
    <TD><FONT size="2"><?PHP  echo $strD_id ?></FONT></TD>
  </TR>-->
  <TR>
    <TD bgcolor="#FFCC99"><B><FONT size="2">氏名</FONT></B></TD>
    <TD><FONT size="2"><?PHP  echo JcodeConvert($sei_kj, 1, 1) ?> <?PHP  echo JcodeConvert($mei_kj, 1, 1) ?></FONT></TD>
  </TR>
  <TR>
    <TD bgcolor="#FFCC99" ALIGN="CENTER" COLSPAN="2"><B><FONT size="2">上記のユーザー情報を更新しました</FONT></B></TD>
  </TR>
</TBODY>
</TABLE>
<BR>
<BR>
<BR>
<TABLE border=0 cellspacing="0" cellpadding="3" width="544">
<TBODY>
  <TR>
    <TD ALIGN="CENTER">
    <FONT size="2"><A href="./user_ichiran.php">ユーザー情報一覧に戻る</A></FONT>
    </TD>
  </TR>
</TBODY>
</TABLE>
</BODY>
</CENTER>
</HTML>