<?PHP 
//*****************************************************************************
//* 
//* プログラム名：め〜るNiポン！V2
//* プログラムID：MST1167.php
//* 機能        ：配布用ユーザ登録処理（携帯）
//* 
//*****************************************************************************
header("Content-type: text/html; charset=Shift_JIS");
//***************************
//*　インクルードファイル
//***************************
include("./include/jcode.phps");
include("./include/dbcon.inc");
//***************************
//*　初期処理
//***************************
$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);
}

if($syamei == ""){
	 $strSyamei = "　";
}else{
	 $strSyamei = $syamei;
}

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

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

$Cnt = count($r1);
$bumon_num = count($r1);
$chkCnt = 0;
$strpras = "";
if ($Cnt==0){
	$strpras = $r1;
}else{
  	for ($i=0; $i< count($r1);$i++){
  			$strpras = $strpras.$r1[$i]."/";
  			$chkCnt++;
  	}
}

//グループＩＤ
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, 0, 2);
	}else{
		$strGroup_Name = $strGroup_Name . "<BR>" . JcodeConvert($objData->group_name, 0, 2);
	}
}

//表示名称を取得
$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);

?>

<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=Shift_JIS">

<TITLE>ユーザー情報登録</TITLE>
</HEAD>
<BODY>


<CENTER>
<HR>
<BR>
<br>

<?PHP  if ($strSet_Flg == 1){ ?>
<B><FONT color=blue size=5>ユーザー情報登録</FONT></B>
<?PHP  }elseif ($strSet_Flg == 2){ ?>
<B><FONT color=blue size=5>ユーザー情報更新</FONT></B>
<?PHP  } ?>


<?PHP 
	$ErrFlg=0;
	if (trim($sei_kj)==""){
		echo "<BR>エラー：氏名が入力されていません<BR>";
		$ErrFlg=1;
	}
	if ($sex==""){
		echo "<BR>エラー：性別が入力されていません<BR>";
		$ErrFlg=1;
	}
	if ($strGroup_Name==""){
		echo "<BR>エラー：".JcodeConvert($strDisp_Name,1,2)."が入力されていません<BR>";
		$ErrFlg=1;
	}
	if (trim($strMailaddress)=="　" && trim($strPcMailaddress)=="　"){
		echo "<BR>エラー：メールアドレスが入力されていません<BR>";
		$ErrFlg=1;
	}
	if (($email2=="etc") && ($email2_2=="")){
			echo "<BR>エラー：携帯電話アドレス「その他」選択時は、ドメインを入力してください<BR>";
			$ErrFlg=1;
	}
	//echo "<hr>";
	//echo $email2."<hr>";
	//echo $email2_2."<hr>";
	//echo "<hr>";

?>	 

<?PHP  if($ErrFlg==0){ ?>
</CENTER>
<FORM METHOD="get" NAME="Frm" action="MST1168.php">
<CENTER>
<?PHP  } ?>

<?PHP  if ($strSet_Flg == 1){ ?>
	<?PHP  if($ErrFlg==1){ ?>
		</CENTER>
		<FORM METHOD="get" NAME="Frm" action="MST1166.php">
		<CENTER>

		<INPUT type="submit" name="exec" value="戻　る">
	<?PHP  }else{ ?>
		<INPUT type="submit" name="exec" value="登　録">
	<?PHP  	} ?>
<?PHP  }elseif ($strSet_Flg == 2){?>

	<?PHP  if($ErrFlg==1){ ?>
		</CENTER>
		<FORM METHOD="get" NAME="Frm" action="MST1166.php">
		<CENTER>
		<INPUT type="submit" name="exec" value="戻　る">
	<?PHP  }else{ ?>
		<INPUT type="submit" name="exec" value="更　新">
	<?PHP  } ?>
<?PHP  } ?>
<BR></CENTER>
<INPUT TYPE="hidden" NAME="key" VALUE="<?PHP  echo $key ?>">
    <B><FONT size="2">■氏名（漢字）</FONT></B><BR>
      <FONT size="2"><?PHP  echo $sei_kj ?> <?PHP  echo $mei_kj ?></FONT><BR>
    <B><FONT size="2">■氏名（フリガナ）</FONT></B><BR>
	  <?PHP  if (($sei_kn=="") && ($mei_kn=="")){	?>
      <FONT size="2">　</FONT><BR>
	  <?PHP  }else{	?>
      <FONT size="2"><?PHP  echo $sei_kn ?> <?PHP  echo $mei_kn ?></FONT><BR>
	  <?PHP  }	?>
    <B><FONT size="2">■性別</FONT></B><BR>
      <FONT size="2"><?PHP  echo $strSex1 ?></FONT><BR>
    <B><FONT size="2">■<?PHP  echo JcodeConvert($strDisp_Name,1,2) ?></FONT></B><BR>
      <FONT size="2"><?PHP  echo $strGroup_Name ?></FONT><BR>
    <B><FONT size="2">■住所</FONT></B><BR>
      <FONT size="2"><?PHP  echo $strYubin_no ?></FONT><BR>
    <FONT size="2"><?PHP  echo $strAddr_Pref ?></FONT><BR>
    <FONT size="2"><?PHP  echo $strAddr_City ?></FONT><BR>
    <FONT size="2"><?PHP  echo $strAddr_Banti ?></FONT><BR>
    <FONT size="2"><?PHP  echo $strAddr_Apart ?></FONT><BR>
    <B><FONT size="2">■自宅電話番号</FONT></B><BR>
      <FONT size="2"><?PHP  echo $strTel_no ?></FONT><BR>
    <B><FONT size="2">■携帯電話番号</FONT></B><BR>
      <TD><FONT size="2"><?PHP  echo $strKeitai_no ?></FONT><BR>
    <B><FONT size="2">■メモ</FONT></B><BR>
      <FONT size="2"><?PHP  echo $strBiko ?></FONT><BR>
    <B><FONT size="2">■会社名</FONT></B><BR>
      <FONT size="2"><?PHP  echo $strSyamei ?></FONT><BR>
    <B><FONT size="2">■携帯メールアドレス</FONT></B><BR>
     <FONT size="2"><?PHP  echo $strMailaddress ?></FONT><BR>
    <B><FONT size="2">■ＰＣメールアドレス</FONT></B><BR>
      <FONT size="2"><?PHP  echo $strPcMailaddress ?></FONT><BR>
    <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="syamei" value="<?PHP  echo $syamei ?>">
	<INPUT type="hidden" name="email1" value="<?PHP  echo $email1 ?>">
	<INPUT type="hidden" name="email2" value="<?PHP  echo $email2 ?>">
	<INPUT type="hidden" name="email2_2" value="<?PHP  echo $email2_2 ?>">
	<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 ?>">
<TR>

<!-- キー情報 -->
<INPUT type="hidden" NAME="i" VALUE="<?PHP  echo $PHP_POST_SYAIN_ID ?>">
<INPUT type="hidden" name="PHP_POST_DB_NAME" value="<?PHP  echo $PHP_POST_DB_NAME ?>">
<INPUT type="hidden" name="PHP_POST_SYAIN_ID" value="<?PHP  echo $PHP_POST_SYAIN_ID ?>">
<INPUT type="hidden" name="PHP_POST_DB_FLG" value="<?PHP  echo $PHP_POST_DB_FLG ?>">
<INPUT type="hidden" name="PHP_POST_DB_USER_NAME" value="<?PHP  echo $PHP_POST_DB_USER_NAME ?>">

<INPUT type="hidden" name="key" value="<?PHP  echo $key ?>">
<INPUT type="hidden" name="lngSyainCd" value="<?PHP  echo $lngSyainCd ?>">
<INPUT type="hidden" name="strSet_Flg" value="<?PHP  echo $strSet_Flg ?>">

</FORM>

</BODY>
</HTML>