<?PHP 
//*****************************************************************************
//* 
//* プログラム名：め〜るNiポン！V2
//* プログラムID：LIST1760.php
//* 機能        ：ユーザー情報を閲覧する
//* 
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");

//***************************
//*　インクルードファイル
//***************************
include("./include/smarty.conf");
include("./include/session_start.inc");
include("./include/SessionChk2.inc");
include("./include/jcode.phps");

//********** ヘッダー処理 **********//
include("./include/headr_data.inc");

//********** メイン処理 **********//
include("./include/dbcon.inc");


//***************************
//*　初期処理
//***************************
$objConn			= null;	//接続オブジェクト
$objRecSet			= null;	//レコードセットオブジェクト

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

$strYubin_no1			="";
$strYubin_no2			="";
$intGroup_Count	= 0;
$intGroup_Id		= array();	//上位グループID
$strGroup_Name		= array();	//上位グループ名
$strAdmin			="f";		//管理者フラグ		
$lngSyainCd	= 0;

//キーの受け渡し
$lngSyainCd = $usr_key;
$o_smarty->assign('mail_id'      , $_POST["mail_id"]);

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

$o_smarty->assign('strDisp_Name'      , $strDisp_Name);


//上位グループを取得
$strSQL = "SELECT group_id, group_name " .
         "FROM mst_group " .
         "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;
	$strGroup_Name[$intIdx] = JcodeConvert($objData->group_name, 1, 1);
}

//GROUP_INFO
$strSQL = "SELECT group_info.* " .
          "FROM group_info " .
          "WHERE group_info.syain_cd = '" . $lngSyainCd . "' " .
          "ORDER BY group_info.group_id";

$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
    echo("SQL実行に失敗しました(SELECT)");
    exit;
}
$intInfo_Count = pg_numrows($objRecSet);
for($intIdx = 0; $intIdx < $intInfo_Count ; $intIdx++) {
	$objData = pg_fetch_object($objRecSet, $intIdx);
	$intG_Info_Cd[$intIdx] = $objData->group_id;
}
//グループ名
$intJ = 0;
for($intCount = 0; $intCount < $intGroup_Count; $intCount++){
	for($intIdx = 0; $intIdx < $intInfo_Count; $intIdx++){
		if ($intG_Info_Cd[$intIdx]==$intGroup_Id[$intCount]){
			$Group_Name[$intJ] = $strGroup_Name[$intCount]."<BR>" ;
			$intJ = $intJ + 1;
			break;
		}
	} 
}
$o_smarty->assign('Group_Name'      , $Group_Name);


//管理者フラグ取得
$strSQL = "SELECT COUNT(*) FROM mail_admin WHERE syain_cd = '" . $lngSyainCd . "'";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
    echo("SQL実行に失敗しました(INSERT)");
    exit;
}

$intDataCount = pg_fetch_array($objRecSet, 0);
if ($intDataCount[0] > 0){
	$strAdmin = "t";
}

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

$strYear		= "";
$strMonth		= "";

//ユーザー情報
$strSQL = "SELECT syain_tbl.* " .
          "FROM syain_tbl " .
          "WHERE syain_tbl.syain_cd = '" . $lngSyainCd . "'";

$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
    echo("SQL実行に失敗しました(SELECT)");
    exit;
}
$objData = pg_fetch_object($objRecSet, 0);
$strJyusyoPref=$objData->addr_pref;

$name_kj_sei =$objData->name_kj_sei;
$name_kj_mei =$objData->name_kj_mei;
$name_kn_sei =$objData->name_kn_sei;
$name_kn_mei =$objData->name_kn_mei;
$sei =$objData->sex;
if($sei == "t"){
	$sei = "男";
}else{
	$sei = "女";
}
$yubin_no = ($objData->yubin_no);
if ($yubin_no == "NULL"){
	$strYubin_no1 = "";
	$strYubin_no2 = "";
}else{
	$strYubin_no1=substr($objData->yubin_no, 0 , 3);
	$strYubin_no2=substr($objData->yubin_no, 3 , 4);
}

$addr_city = $objData->addr_city;
$addr_banti = $objData->addr_banti;
$addr_apart =$objData->addr_apart;
$tel_no =$objData->tel_no;
$keitai_no =$objData->keitai_no;
$mail_addr =$objData->mail_addr;
$pc_mail_addr =$objData->pc_mail_addr;

$o_smarty->assign('strJyusyoPref'      , $strJyusyoPref);
$o_smarty->assign('name_kj_sei'      , $name_kj_sei);
$o_smarty->assign('name_kj_mei'      , $name_kj_mei);
$o_smarty->assign('name_kn_sei'      , $name_kn_sei);
$o_smarty->assign('name_kn_mei'      , $name_kn_mei);
$o_smarty->assign('sei'      , $sei);
$o_smarty->assign('strYubin_no1'      , $strYubin_no1);
$o_smarty->assign('strYubin_no2'      , $strYubin_no2);
$o_smarty->assign('addr_city'      , $addr_city);
$o_smarty->assign('addr_banti'      , $addr_banti);
$o_smarty->assign('addr_apart'      , $addr_apart);
$o_smarty->assign('tel_no'      , $tel_no);
$o_smarty->assign('keitai_no'      , $keitai_no);
$o_smarty->assign('mail_addr'      , $mail_addr);
$o_smarty->assign('pc_mail_addr'      , $pc_mail_addr);


//メモ情報取得
$strSQL = "SELECT syain_biko_tbl.biko " .
          "FROM syain_biko_tbl " .
          "WHERE syain_biko_tbl.syain_cd = '" . $lngSyainCd . "'";

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

if (pg_numrows($objRecSet)>0){
	$objBiko = pg_fetch_object($objRecSet, 0);
	$biko=nl2br($objBiko->biko);
}else{
	$biko="";
}
$o_smarty->assign('biko'      , $biko);

$o_smarty->display('LIST1760.tpl');

?>