MIL040.php 4.21 KB
<?php 
//*****************************************************************************
//* 
//* プログラム名:Webメールアドレス帳画面
//* プログラムID:MIL040.php
//* 機能        :メール アドレス帳 新規追加/修正/削除
//* 作成者      :K.Yoshimura
//* 
//*****************************************************************************


header("Content-type: text/html; charset=EUC-JP");
include("include/session_start.inc");
include("include/SessionChk.inc");
include("inc/header.inc");
include("inc/MIL040.inc");

$strDBinc="include/dbcon.inc";
include($strDBinc);

//メニューセット
include("menu_opacity.php");

?>
<form name="e_gru">
<?php 

$strSQLad="";
$objRecad="null";
$strSQLmi="";
$objRecmi="null";


//未読メッセージ取得
$strSQLmi="Select mail_id from mail_get_tbl Where syain_cd='$PHP_SYAIN_CD' and kind_flg=0 and del_flg=0";
$objRecmi = pg_exec($strSQLmi);
if($objRecmi==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}

//個人用メールアドレス取得
$strSQLad="Select seq,view_name,view_name_kana,mail_address from mail_address_tbl".
			" Where syain_cd = '$PHP_SYAIN_CD' Order by view_name_kana";

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

?>
<table width="100%" border="0" cellspacing="0">
	<tr>
		<td class="midashi">
			<table width="100%" border="0" cellpadding="0" cellspacing="0">
				<tr>
					<th width="50%" scope="col"><div align="left"><img src="image/mail.gif" border="0"><span class="MiddleBold"><?php  echo $PHP_TITLE_NAME[13] ?></span></div></th>
					<th width="50%" scope="col"><div align="right"><a href='javascript:Disp_Help("MILHLP.htm")'><img src="image/help.gif" border="0"></a> <a href='javascript:Disp_Help("MILHLP.htm")'>ヘルプ</a></div></th>
				</tr>
			</table><div align="right"></div>
		</td>
	</tr>
</table><br>
<TABLE border=0 width=100%>
	<TR>
		<TD align="left">
			<span class="Normalfont">
				[<a href="MIL001.php">新着メールの確認</a>]
				[<a href="MIL010.php?from=&to=<?php  echo $strMailAdd ?>&strSubject=&strBody=">新規作成</a>]
				[<a href="MIL020.php">受信ボックス(未読<?php  echo pg_numrows($objRecmi) ?>件)</a>]
				[<a href="MIL030.php">送信ボックス</a>]
				[<a href="MIL040.php">個人アドレス帳</a>]
			</span>
		</TD>
		<TD align="right">
			<span class="Normalfont">
				[<a href="MIL050.php">署名設定</a>]
				[<a href="MIL002.php">アカウント設定</a>]
			</span>
		</TD>
	</TR>
</TABLE>
<BR>
<TABLE border=0>
	<TR>
		<TD align="left"><input type="button" value=" メールアドレス追加 " onClick="mail_add();"></TD>
	</TR>
</TABLE>
<BR>
<TABLE cellSpacing=1 cellPadding=1 width="802" class="mainColor" border=0>
	<TR>
		<TD>
	<TABLE cellSpacing=1 cellPadding=1 width="800" align=center class="mainColor" border=0>
		<TR class="toneDown">
			<TD width="200" align="center"><span class="Normalfont">名前</span></TD>
			<TD width="250" align="center"><span class="Normalfont">フリガナ</span></TD>
			<TD width="250" align="center"><span class="Normalfont">E-mail</span></TD>
			<TD width="50" align="center"><span class="Normalfont">修正</span></TD>
			<TD width="50" align="center"><INPUT type=button value="削除" onclick="del_chk(3);"></TD>
		</TR>

<?php 
	if (pg_numrows($objRecad)==0){
?>
		<TR bgcolor="#ffffff">
			<TD colspan="5"><span class="Normalfont"> メールアドレスは登録されていません</span></TD>
		</TR>
<?php 
	}
	for ($intCnt = 0; $intCnt < pg_numrows($objRecad); $intCnt++) {
		$objData = pg_fetch_object($objRecad, $intCnt);

?>
	<TR bgcolor="#ffffff">
		<TD width="200" align="left">
			<span class="Normalfont"><?php  echo $objData->view_name ?></span>
		</TD>
		<TD width="250">
			<span class="Normalfont"><?php  echo $objData->view_name_kana ?></span>
		</TD>
		<TD width="250">
			<span class="Normalfont"><?php  echo $objData->mail_address ?></span>
		</TD>
		<TD width="50" align="center">
			<INPUT type=button value="修正" onclick="edit_address(<?php  echo $objData->seq ?>);">
		</TD>
			<TD width="50" align="center">
				<INPUT type="checkbox" name="del_seq[]" value="<?php  echo $objData->seq ?>">
		</TD>
	</TR>
<?php 
}
?>
</TABLE>
	</TD>
	</TR>
</TABLE><BR>
</Center>
<HR width="100%">
<input type="hidden" name="seq" value="">
<input type="hidden" name="kind_flg" value="">
</form>
<?php 
//コピーライト
include("include/copyright.inc");
?>