ADR002_m.php 6.02 KB

Raw Blame History Permalink

<?php
//*****************************************************************************
//*
//* プログラム名：アドレス帳(携帯電話)
//* プログラムID：ADR002_m.php
//* 機能        ：社内アドレス詳細
//* 作成者      ：
//*
//*****************************************************************************

	header("Content-type: text/html; charset=Shift_JIS");

	//*** 広告 ***//
	include("include_m/Advertisement.inc");

	//*** 共通処理 ***//
	include("include_m/CommonProcess.inc");

	//*** アドレス情報***
	$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'ADR001.php'";
	$rsRecset = pg_exec($strMenuSQL);
	$PHP_TITLE_NAME=mb_convert_encoding(pg_result($rsRecset,0,"name"), "SJIS", "EUC-JP");

?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=Shift_JIS">
<META http-equiv="Content-Style-Type" content="text/css">
<link rel="stylesheet" type="text/css" href="basefont.css">
<TITLE>E-グルPro(<?php  echo $PHP_TITLE_NAME ?>)</TITLE>
</HEAD>
<BODY>
<form>
<center>
社内<?php  echo $PHP_TITLE_NAME ?><br>
<?php  echo $strName; ?>
<HR width="100%">
<?php  echo $koukokuTEL; ?>
</center>

<?php
	//メニュー表示
	include("include_m/CommonMenuReturn.inc");
?>

<HR width="100%">

<a href="ADR001_m.php?bumon=<?php  echo $bumon ?>&add_search=<?php  echo $add_search ?>&<?php  echo $PHP_Argument ?>"accesskey="1"><?php  echo Get_Num("1"); ?>社内アドレス帳</a>

<br><br>
<?php
//個人情報取得
	$strSQL="SELECT syain_cd,name_kj_sei,name_kj_mei,name_kn_sei,name_kn_mei,syugyo_type,sex,birthday,nyusya_date, " .
							"yubin_no,mail_addr,extension_no,addr_pref,addr_city,addr_banti,addr_apart,tel_no,keitai_no FROM syain_tbl ".
							"Where syain_cd='$syain_cd' ";

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

	$strAddres=$objData->addr_pref;

	//個人情報取得
	$strSQL="SELECT * FROM syain_dat_tbl Where syain_cd='$syain_cd'";
	$objRec2 = pg_exec($strSQL);
	if($objRec2==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}

	//データ存在時
	if (pg_numrows($objRec2) > 0){
		$objData2 = pg_fetch_object($objRec2,0);
		$mail_addr_kei = mb_convert_encoding($objData2->mail_addr_kei, "SJIS", "EUC-JP" );
	}else{
		$mail_addr_kei = "";
	}

	echo "【社員番号】".mb_convert_encoding($objData->syain_cd, "SJIS", "EUC-JP" )."<br>";

	echo "【氏名(漢字)】<br>　".mb_convert_encoding($objData->name_kj_sei.$objData->name_kj_mei, "SJIS", "EUC-JP" )."<br>";

	echo "【氏名(カナ)】<br>　".mb_convert_encoding($objData->name_kn_sei.$objData->name_kn_mei, "SJIS", "EUC-JP" )."<br>";

	echo "【就業形態】<br>　";
	if($objData->syugyo_type !=0){
		//就業タイプ取得
		$strSQLtype="SELECT type_name FROM mst_syuugyou_type ".
								"Where syuugyou_type=$objData->syugyo_type ";

		$objRectype = pg_exec($strSQLtype);
		if($objRectype==false){
			echo("SQL実行に失敗しました(SELECT)");
			exit;
		}
		$objSyugyo = pg_fetch_object($objRectype,0);
		$strSyugyoName=mb_convert_encoding($objSyugyo->type_name, "SJIS", "EUC-JP" );
	}else{
		$strSyugyoName="";
	}
	echo $strSyugyoName."<br>";

	echo "【所属部門】<br>　";
	$strSQLSyozoku="SELECT syozoku_cd FROM syozoku_tbl Where syain_cd='$syain_cd' ";
	$objRecSyozoku = pg_exec($strSQLSyozoku);
	if($objRecSyozoku==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	for ($intCnt = 0; $intCnt < pg_numrows($objRecSyozoku) ; $intCnt++) {
			$objSyozoku = pg_fetch_object($objRecSyozoku, $intCnt);
			//部門名取得
			$strSQLbumon="SELECT bumon_name FROM mst_bumon Where syozoku_cd=$objSyozoku->syozoku_cd ";
			$objRecbumon = pg_exec($strSQLbumon);
			if($objRecbumon==false){
				echo("SQL実行に失敗しました(SELECT)");
				exit;
			}
			$objBumon = pg_fetch_object($objRecbumon,0);
			echo mb_convert_encoding($objBumon->bumon_name, "SJIS", "EUC-JP" )."&nbsp;";
	}
	echo "<br>";

	echo "【性別】";
	if(mb_convert_encoding($objData->sex, "SJIS", "EUC-JP" ) == 't'){
			$strSex = "男";
	}else{
			$strSex = "女";
	}
	echo $strSex."<br>";

	echo "【生年月日】<br>　".mb_convert_encoding($objData->birthday, "SJIS", "EUC-JP" )."<br>";

	echo "【入社日】<br>　".mb_convert_encoding($objData->nyusya_date, "SJIS", "EUC-JP" )."<br>";

	echo "【mail】<br>　";
	if (mb_convert_encoding($objData->mail_addr, "SJIS", "EUC-JP" ) != "@"){
			echo '<a href="mailto:'.mb_convert_encoding($objData->mail_addr, "SJIS", "EUC-JP" ).'">'.
						mb_convert_encoding($objData->mail_addr, "SJIS", "EUC-JP" )."</a>";
	}
	echo "<br>";

	echo "【mail(携帯)】<br>　";
	if ($mail_addr_kei != ""){
			echo '<a href="mailto:'.$mail_addr_kei.'">'.$mail_addr_kei."</a>";
	}
	echo "<br>";

	echo "【内線番号】<br>　".mb_convert_encoding($objData->extension_no, "SJIS", "EUC-JP" )."<br>";
	echo "【住所】<br>";
	echo "　〒".mb_convert_encoding($objData->yubin_no, "SJIS", "EUC-JP" )."<br>";
	echo "　".mb_convert_encoding($objData->addr_pref, "SJIS", "EUC-JP" )."<br>";
	echo "　".mb_convert_encoding($objData->addr_city, "SJIS", "EUC-JP" )."<br>";
	echo "　".mb_convert_encoding($objData->addr_banti, "SJIS", "EUC-JP" )."<br>";
	echo "　".mb_convert_encoding($objData->addr_apart, "SJIS", "EUC-JP" )."<br>";
	echo "【TEL】<br>　";
	if (mb_convert_encoding($objData->tel_no, "SJIS", "EUC-JP" )!="--"){
			echo '<a href="tel:'.str_replace("-","",mb_convert_encoding($objData->tel_no, "SJIS", "EUC-JP" )).'">'.
						mb_convert_encoding($objData->tel_no, "SJIS", "EUC-JP" )."</a>";
	}
	echo "<br>";

	echo "【TEL(携帯)】<br>　";
	if(mb_convert_encoding($objData->keitai_no, "SJIS", "EUC-JP" )!="--"){
			echo '<a href="tel:'.str_replace("-","",mb_convert_encoding($objData->keitai_no, "SJIS", "EUC-JP" )).'">'.
						mb_convert_encoding($objData->keitai_no, "SJIS", "EUC-JP" )."</a><br>";
	}
	echo "<br>";
?>
<a href="ADR001_m.php?bumon=<?php  echo $bumon ?>&add_search=<?php  echo $add_search ?>&<?php  echo $PHP_Argument ?>"accesskey="1"><?php  echo Get_Num("1"); ?>社内アドレス帳</a>
<HR width="100%">
<?php
	//メニュー表示
	include("include_m/CommonMenuReturn.inc");
	//*** 共通変数取得 ***//
	include("include_m/CommonHidden.inc");

?>
</form>
</BODY>
</HTML>