<?PHP 
//*****************************************************************************
//* 
//* プログラム名：ユーザー情報
//* プログラムID：user_reg_chk.asp
//* 機能        ：ユーザー情報を登録する
//* 作成者      ：t.sugiyama(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;	//接続オブジェクト
$objRecSet			= null;	//レコードセットオブジェクト

$strSQL				= "";	//SQL文
$intIdx				= 0;

$strGroup2_id		= array();	//上位グループ
$strSex				= array();	//性別
$strYubin_no   		= array();	//郵便番号
$strAddr_Pref  		= array();	//住所１
$strAddr_City  		= array();	//住所２
$strAddr_Banti		= array();	//住所３
$strAddr_Apart 		= array();	//住所４
$strTel_no  		= array();	//自宅電話番号
$strKeitai_no   	= array();	//携帯電話番号
$strMailaddress		= array();	//携帯メールアドレス
$strPcMailaddress	= array();	//ＰＣメールアドレス
$intDataCount		= 0;
//***************************
//*　メイン処理
//***************************

if($user_id==""){
	$strUsr_id = "　";
}else{
	$strUsr_id = $user_id;
}

$strSex1 = $sex;
if ($sex == "t"){
	$strSex1 = "男";
}else{
	$strSex1 = "女";
}

$strYubin_no = $yubin_no1;
if ($strYubin_no == ""){
	$strYubin_no = "　";
}else{
	$strYubin_no = $yubin_no1 . "-" . $yubin_no2 ;
}

$strAddr_Pref = $address1;
if ($strAddr_Pref == ""){
	$strAddr_Pref = "　";
}

$strAddr_City = $address2;
if ($strAddr_City == ""){
	$strAddr_City = "　";
}

$strAddr_Banti = $address3;
if ($strAddr_Banti == ""){
	$strAddr_Banti = "　";
}

$strAddr_Apart = $address4;
if ($strAddr_Apart == ""){
	$strAddr_Apart = "　";
}

$strTel_no = $telno1 . $telno2 . $telno3;
if ($strTel_no == ""){
	$strTel_no = "　";
	$strTel_no1 = "NULL";
}else{
	$strTel_no = $telno1 . "-" . $telno2 . "-" . $telno3;
	$strTel_no1 = $telno1 . $telno2 . $telno3;
}

$strKeitai_no = $keitaiNo1 . $keitaiNo2 . $keitaiNo3;
if ($strKeitai_no == ""){
	$strKeitai_no = "　";
	$strKeitai_no1 = "NULL";
}else{
	$strKeitai_no = $keitaiNo1 . "-" . $keitaiNo2 . "-" . $keitaiNo3;
	$strKeitai_no1 = $keitaiNo1 . $keitaiNo2 . $keitaiNo3;
}

if ($biko == ""){
	$strBiko = "　";
}else{
	$strBiko = str_replace ("\n", "<BR>", $biko);
}

$strMailaddress = $email1;
if ($strMailaddress == ""){
	$strMailaddress = "　";
	$strMailaddress1="";
}else{
	$strMailaddress = $email1 . "@" . $email2;
	$strMailaddress1 = $email1 . "@" . $email2;
}

$strPcMailaddress = $pcemail1 . $pcemail2;
if ($strPcMailaddress == ""){
	$strPcMailaddress = "　";
	$strPcMailaddress1="";
}else{
	$strPcMailaddress = $pcemail1 . "@" . $pcemail2;
	$strPcMailaddress1 = $pcemail1 . "@" . $pcemail2;
}

//グループＩＤ
if ($bumon_num==0){
	$Jyouken = " group_id ='" . $strpras . "'";
}else{
	$strBumonArray=split("/",$strpras);
    for ($i = 0 ; $i <= $bumon_num-1 ; $i++) {
    	if($i==0){
    		$Jyouken = " group_id ='" . $strBumonArray[$i] . "'";
    	}else{
    		if ($strBumonArray[$i]!=""){
    			$Jyouken = $Jyouken . " OR " . "group_id ='" . $strBumonArray[$i] . "'";
    		}
    	}
    }
}
$WHERE = "WHERE" . $Jyouken;

//グループを取得
$strSQL = "SELECT group_id, group_name " .
          "FROM mst_group " . $WHERE .
          " ORDER BY group_id";
         
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
    echo("SQL実行に失敗しました(SELECT)");
    exit;
}
$intGroup_Count = pg_numrows($objRecSet);

for($intIdx = 0; $intIdx < $intGroup_Count ; $intIdx++) {
	$objData = pg_fetch_object($objRecSet, $intIdx);
	//$intGroup_Id[$intIdx] = $objData->group_id;
	if($intIdx==0){
		$strGroup_Name = JcodeConvert($objData->group_name, 1, 1);
	}else{
		$strGroup_Name = $strGroup_Name . "<BR>" . JcodeConvert($objData->group_name, 1, 1);
	}
}

//表示名称を取得
$strSQL = "SELECT disp_id,disp_name " .
          "FROM mst_disp " .
          "WHERE disp_id = '2' " .
          "ORDER BY disp_id DESC";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
    echo("SQL実行に失敗しました(SELECT)");
    exit;
}
$intDisp_Count = pg_numrows($objRecSet);
$objData = pg_fetch_object($objRecSet, 0);
$strDisp_Name = JcodeConvert($objData->disp_name, 1, 1);

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META name="GENERATOR" content="IBM WebSphere Homepage Builder V6.0.1 for Windows">
<META http-equiv="Content-Type" content="text/html; charset=EUC-JP">
<META http-equiv="Content-Style-Type" content="text/css">
<TITLE>ユーザー情報登録</TITLE>
<SCRIPT LANGUAGE="JavaScript">
<!--
function ichiranBack(){
	
	if (confirm("入力内容は破棄してユーザー情報一覧画面に戻ります\nよろしいですか？")){
		document.forms[0].action="./user_ichiran.php";
		document.forms[0].submit();
	}
}

function ichiranBack2(){
	
		document.forms[0].action="./user_reg.php";
		document.forms[0].submit();
}

function ichiranBack3(){
	
		document.forms[0].action="./user_reg.php";
		document.forms[0].submit();
}

function ichiranBack4(){
	
		document.forms[0].action="./user_info.php";
		document.forms[0].submit();
}

function insertCheck(){

	if (confirm("この内容で情報を登録しますか？")){
		document.forms[0].action="./user_insertExec.php";
		document.forms[0].submit();
	}
}

function updateCheck(){

	if (confirm("この内容で情報を更新しますか？")){
		document.forms[0].action="./user_updateExec.php";
		document.forms[0].submit();
	}
}
//-->
</SCRIPT>
</HEAD>
<?PHP 
if ($strSet_Flg == 1){
	
$strSQL = "SELECT * FROM syain_tbl WHERE syain_id = '" . $user_id . "'";
}else{
//キーの受け渡し
$lngSyainCd = $key;
$strSQL = "SELECT * FROM syain_tbl WHERE ( syain_cd <> '" . $lngSyainCd . "' AND " . "syain_id = '" . $user_id . "')";
}

$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
    echo("SQL実行に失敗しました(INSERT)");
    exit;
}

$intDataCount = pg_numrows($objRecSet);

if ($intDataCount > 0){
?>
<BODY bgcolor="White">
<CENTER>
<TABLE border=0 WIDTH="544">
<TR><TD>
<CENTER>
<B><FONT color=blue size=25>同一ユーザーＩＤが</FONT></B><BR><B><FONT color=blue size=25>既に存在します</FONT></B>
<HR>
<BR>
<INPUT type="button" name="back" value="一覧に戻る" onClick="location='./user_ichiran.php'">
<INPUT type="button" name="back" value="登録画面へ戻る" onClick="JavaScript:ichiranBack3();">
<FORM METHOD="POST" NAME="Frm">
    <INPUT type="hidden" name="user_id" value="<?PHP  echo $user_id ?>">
    <INPUT type="hidden" name="user_pass" value="<?PHP  echo $user_pass ?>">
    <INPUT type="hidden" name="sei_kj" value="<?PHP  echo $sei_kj ?>">
	<INPUT type="hidden" name="mei_kj" value="<?PHP  echo $mei_kj ?>">
	<INPUT type="hidden" name="sei_kn" value="<?PHP  echo $sei_kn ?>">
	<INPUT type="hidden" name="mei_kn" value="<?PHP  echo $mei_kn ?>">
	<INPUT type="hidden" name="sex" value="<?PHP  echo $sex ?>">
    <INPUT type="hidden" name="group2_id" value="<?PHP  echo $group2_id ?>">
    <INPUT type="hidden" name="group1_id" value="<?PHP  echo $group1_id ?>">
	<INPUT type="hidden" name="yubin_no1" value="<?PHP  echo $yubin_no1 ?>">
	<INPUT type="hidden" name="yubin_no2" value="<?PHP  echo $yubin_no2 ?>">
	<INPUT type="hidden" name="address1" value="<?PHP  echo $address1 ?>">
	<INPUT type="hidden" name="address2" value="<?PHP  echo $address2 ?>">
	<INPUT type="hidden" name="address3" value="<?PHP  echo $address3 ?>">
	<INPUT type="hidden" name="address4" value="<?PHP  echo $address4 ?>">
	<INPUT type="hidden" name="tel_no1" value="<?PHP  echo $telno1 ?>">
	<INPUT type="hidden" name="tel_no2" value="<?PHP  echo $telno2 ?>">
	<INPUT type="hidden" name="tel_no3" value="<?PHP  echo $telno3 ?>">
	<INPUT type="hidden" name="keitai_no1" value="<?PHP  echo $keitaiNo1 ?>">
	<INPUT type="hidden" name="keitai_no2" value="<?PHP  echo $keitaiNo2 ?>">
	<INPUT type="hidden" name="keitai_no3" value="<?PHP  echo $keitaiNo3 ?>">
	<INPUT type="hidden" name="biko" value="<?PHP  echo $biko ?>">
	<INPUT type="hidden" name="email1" value="<?PHP  echo $email1 ?>">
	<INPUT type="hidden" name="email2" value="<?PHP  echo $email2 ?>">
    <INPUT type="hidden" name="mail_address" value="<?PHP  echo $strMailaddress1 ?>">
	<INPUT type="hidden" name="pcemail1" value="<?PHP  echo $pcemail1 ?>">
	<INPUT type="hidden" name="pcemail2" value="<?PHP  echo $pcemail2 ?>">
	<INPUT type="hidden" name="pcmail_address" value="<?PHP  echo $strPcMailaddress1 ?>">
	<INPUT type="hidden" name="strpras" value="<?PHP  echo $strpras ?>">
	<INPUT type="hidden" name="bumon_num" value="<?PHP  echo $bumon_num ?>">
</FORM>
</CENTER>
</TD></TR>
</TABLE>

</CENTER>
</TBODY>
<?PHP 
}else{
?>

<BODY bgcolor="White">
<CENTER>
<TABLE border=0 WIDTH="544">
<TR><TD>
<CENTER>
<B><FONT color=blue size=5>ユーザー情報登録</FONT></B>
<HR>
<BR>
<INPUT type="button" name="back" value="一覧に戻る" onClick="JavaScript:ichiranBack();">
<?PHP 
if ($strSet_Flg == 1){
?>
<INPUT type="button" name="back" value="登録画面へ戻る" onClick="JavaScript:ichiranBack2();">
<?PHP 
}elseif ($strSet_Flg == 2){
?>
<INPUT type="button" name="back" value="更新画面へ戻る" onClick="JavaScript:ichiranBack4();">
<?PHP 
}
?>
</CENTER>
</TD></TR>
<TR><TD>
<FORM METHOD="POST" NAME="Frm">
<INPUT TYPE="hidden" NAME="key" VALUE="<?PHP  echo $key ?>">
<TABLE border=1 bordercolor="#008080" width="544">
  <TBODY>
<!--    <TR>
      <TD bgcolor="#FFCC99"><B><FONT size="2">ユーザーＩＤ</FONT></B></TD>
      <TD><FONT size="2"><?PHP  echo $strUsr_id ?></FONT></TD>
    </TR>
-->
    <TR>
      <TD bgcolor="#FFCC99"><B><FONT size="2">氏名（漢字）</FONT></B></TD>
      <TD><FONT size="2"><?PHP  echo $sei_kj ?> <?PHP  echo $mei_kj ?></FONT></TD>
    </TR>
	<TR>
      <TD bgcolor="#FFCC99"><B><FONT size="2">氏名（フリガナ）</FONT></B></TD>
	  <?PHP  if (($sei_kn=="") && ($mei_kn=="")){	?>
      <TD><FONT size="2">　</FONT></TD>
	  <?PHP  }else{	?>
      <TD><FONT size="2"><?PHP  echo $sei_kn ?> <?PHP  echo $mei_kn ?></FONT></TD>
	  <?PHP  }	?>
    </TR>
	<TR>
      <TD bgcolor="#FFCC99"><B><FONT size="2">性別</FONT></B></TD>
      <TD><FONT size="2"><?PHP  echo $strSex1 ?></FONT></TD>
    </TR>
    <TR>
      <TD bgcolor="#FFCC99"><B><FONT size="2"><?PHP  echo $strDisp_Name ?></FONT></B></TD>
      <TD><FONT size="2"><?PHP  echo $strGroup_Name ?></FONT></TD>
    </TR>
	<TR>
      <td valign="top" bgcolor="#FFCC99" rowspan="5"><B><FONT size="2">住所</FONT></B></TD>
      <TD><FONT size="2"><?PHP  echo $strYubin_no ?></FONT></TD>
    </TR>
	<TR>
      <TD><FONT size="2"><?PHP  echo $strAddr_Pref ?></FONT></TD>
    </TR>
	<TR>
	  <TD><FONT size="2"><?PHP  echo $strAddr_City ?></FONT></TD>	
    </TR>
	<TR>
	  <TD><FONT size="2"><?PHP  echo $strAddr_Banti ?></FONT></TD>	
    </TR>
	<TR>
	  <TD><FONT size="2"><?PHP  echo $strAddr_Apart ?></FONT></TD>	
    </TR>
	<TR>
      <TD bgcolor="#FFCC99"><B><FONT size="2">自宅電話番号</FONT></B></TD>
      <TD><FONT size="2"><?PHP  echo $strTel_no ?></FONT></TD>
    </TR>
	<TR>
      <TD bgcolor="#FFCC99"><B><FONT size="2">携帯電話番号</FONT></B></TD>
      <TD><FONT size="2"><?PHP  echo $strKeitai_no ?></FONT></TD>
    </TR>
	<TR>
      <TD valign="top" bgcolor="#FFCC99"><B><FONT size="2">メモ</FONT></B></TD>
      <TD><FONT size="2"><?PHP  echo $strBiko ?></FONT></TD>
    </TR>
    <TR>
      <TD bgcolor="#FFCC99"><B><FONT size="2">携帯メールアドレス</FONT></B></TD>
      <TD><FONT size="2"><?PHP  echo $strMailaddress ?></FONT></TD>
    </TR>
	<TR>
      <TD bgcolor="#FFCC99"><B><FONT size="2">ＰＣメールアドレス</FONT></B></TD>
      <TD><FONT size="2"><?PHP  echo $strPcMailaddress ?></FONT></TD>
    </TR>
    <INPUT type="hidden" name="user_id" value="<?PHP  echo $user_id ?>">
    <INPUT type="hidden" name="user_pass" value="<?PHP  echo $user_pass ?>">
    <INPUT type="hidden" name="sei_kj" value="<?PHP  echo $sei_kj ?>">
	<INPUT type="hidden" name="mei_kj" value="<?PHP  echo $mei_kj ?>">
	<INPUT type="hidden" name="sei_kn" value="<?PHP  echo $sei_kn ?>">
	<INPUT type="hidden" name="mei_kn" value="<?PHP  echo $mei_kn ?>">
	<INPUT type="hidden" name="sex" value="<?PHP  echo $sex ?>">
    <INPUT type="hidden" name="group2_id" value="<?PHP  echo $group2_id ?>">
    <INPUT type="hidden" name="group1_id" value="<?PHP  echo $group1_id ?>">
	<INPUT type="hidden" name="yubin_no1" value="<?PHP  echo $yubin_no1 ?>">
	<INPUT type="hidden" name="yubin_no2" value="<?PHP  echo $yubin_no2 ?>">
	<INPUT type="hidden" name="address1" value="<?PHP  echo $address1 ?>">
	<INPUT type="hidden" name="address2" value="<?PHP  echo $address2 ?>">
	<INPUT type="hidden" name="address3" value="<?PHP  echo $address3 ?>">
	<INPUT type="hidden" name="address4" value="<?PHP  echo $address4 ?>">
	<INPUT type="hidden" name="tel_no1" value="<?PHP  echo $telno1 ?>">
	<INPUT type="hidden" name="tel_no2" value="<?PHP  echo $telno2 ?>">
	<INPUT type="hidden" name="tel_no3" value="<?PHP  echo $telno3 ?>">
	<INPUT type="hidden" name="keitai_no1" value="<?PHP  echo $keitaiNo1 ?>">
	<INPUT type="hidden" name="keitai_no2" value="<?PHP  echo $keitaiNo2 ?>">
	<INPUT type="hidden" name="keitai_no3" value="<?PHP  echo $keitaiNo3 ?>">
	<INPUT type="hidden" name="biko" value="<?PHP  echo $biko ?>">
	<INPUT type="hidden" name="email1" value="<?PHP  echo $email1 ?>">
	<INPUT type="hidden" name="email2" value="<?PHP  echo $email2 ?>">
    <INPUT type="hidden" name="mail_address" value="<?PHP  echo $strMailaddress1 ?>">
	<INPUT type="hidden" name="pcemail1" value="<?PHP  echo $pcemail1 ?>">
	<INPUT type="hidden" name="pcemail2" value="<?PHP  echo $pcemail2 ?>">
	<INPUT type="hidden" name="pcmail_address" value="<?PHP  echo $strPcMailaddress1 ?>">
	<INPUT type="hidden" name="strpras" value="<?PHP  echo $strpras ?>">
	<INPUT type="hidden" name="bumon_num" value="<?PHP  echo $bumon_num ?>">
  </TBODY>
</TABLE>
</FORM>
<TABLE border="0" width="544">
<TR>
<?PHP 
if ($strSet_Flg == 1){
?>
	<TD ALIGN="CENTER"><INPUT type="button" name="insert" value="登　録" onClick="JavaScript:insertCheck();"></TD>
<?PHP 
}elseif ($strSet_Flg == 2){
	$strKey = $key;
?>
	<INPUT TYPE="hidden" NAME="key" VALUE="<?PHP  echo $strKey ?>">
    <TD ALIGN="CENTER"><INPUT type="button" name="update" value="更　新" onClick="JavaScript:updateCheck();"></TD>
<?PHP 
	}
}
?>

</TR>
</TABLE>
</TABLE>
</CENTER>

</BODY>
</HTML>