add_detail.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 221 行
PHP
221 行
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
echo '
<html>
<head>
<title>联系人详情</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
';
$query = ((''.'SELECT * from ADDRESS where ADD_ID=').$ADD_ID);
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$PSN_NAME = $ROW['PSN_NAME'];
$SEX = $ROW['SEX'];
$BIRTHDAY = $ROW['BIRTHDAY'];
$NICK_NAME = $ROW['NICK_NAME'];
$MINISTRATION = $ROW['MINISTRATION'];
$MATE = $ROW['MATE'];
$CHILD = $ROW['CHILD'];
$DEPT_NAME = $ROW['DEPT_NAME'];
$ADD_DEPT = $ROW['ADD_DEPT'];
$POST_NO_DEPT = $ROW['POST_NO_DEPT'];
$TEL_NO_DEPT = $ROW['TEL_NO_DEPT'];
$FAX_NO_DEPT = $ROW['FAX_NO_DEPT'];
$ADD_HOME = $ROW['ADD_HOME'];
$POST_NO_HOME = $ROW['POST_NO_HOME'];
$TEL_NO_HOME = $ROW['TEL_NO_HOME'];
$MOBIL_NO = $ROW['MOBIL_NO'];
$BP_NO = $ROW['BP_NO'];
$EMAIL = $ROW['EMAIL'];
$OICQ_NO = $ROW['OICQ_NO'];
$ICQ_NO = $ROW['ICQ_NO'];
$NOTES = $ROW['NOTES'];
if (($SEX == '0'))
{
$SEX = '男';
}
else
{
if (($SEX == '1'))
{
$SEX = '女';
}
else
{
$SEX = '';
}
}
echo '<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/address.gif" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 联系人详情 - ';
echo $PSN_NAME;
echo '</span><br>
</td>
</tr>
</table>
<table border="0" width="100%" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
<tr>
<td nowrap class="TableHeader" colspan="2"><b> 个人信息</b></td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 姓名：</td>
<td class="TableData">';
echo $PSN_NAME;
echo '</td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 性别：</td>
<td class="TableData">';
echo $SEX;
echo '</td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80">生日：</td>
<td class="TableData">';
echo $BIRTHDAY;
echo '</td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 昵称：</td>
<td class="TableData">';
echo $NICK_NAME;
echo '</td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 职务：</td>
<td class="TableData">';
echo $MINISTRATION;
echo '</td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 配偶：</td>
<td class="TableData">';
echo $MATE;
echo '</td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 子女：</td>
<td class="TableData">';
echo $CHILD;
echo '</td>
</tr>
<tr>
<td nowrap class="TableHeader" colspan="2"><b> 联系方式（单位）</b></td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 单位名称：</td>
<td class="TableData">';
echo $DEPT_NAME;
echo '</td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80">单位地址：</td>
<td class="TableData">';
echo $ADD_DEPT;
echo '</td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 单位邮编：</td>
<td class="TableData">';
echo $POST_NO_DEPT;
echo '</td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 单位电话：</td>
<td class="TableData">';
echo $TEL_NO_DEPT;
echo '</td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 单位传真：</td>
<td class="TableData">';
echo $FAX_NO_DEPT;
echo '</td>
</tr>
<tr>
<td nowrap class="TableHeader" colspan="2"><b> 联系方式（家庭）</b></td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 家庭住址：</td>
<td class="TableData">';
echo $ADD_HOME;
echo '</td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 家庭邮编：</td>
<td class="TableData">';
echo $POST_NO_HOME;
echo '</td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 家庭电话：</td>
<td class="TableData">';
echo $TEL_NO_HOME;
echo '</td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 手机：</td>
<td class="TableData">';
echo $MOBIL_NO;
echo '</td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 小灵通：</td>
<td class="TableData">';
echo $BP_NO;
echo '</td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 电子邮件：</td>
<td class="TableData">';
echo $EMAIL;
echo '</td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> QQ号码：</td>
<td class="TableData">';
echo $OICQ_NO;
echo '</td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> MSN：</td>
<td class="TableData">';
echo $ICQ_NO;
echo '</td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 备 注：</td>
<td class="TableData">';
echo $NOTES;
echo '</td>
</tr>
<tr>
<td class="TableData" colspan="4">
';
echo get_field_table (get_field_text ('ADDRESS', $ADD_ID));
echo ' </td>
</tr>
<tr align="center" class="TableControl">
<td colspan="2" nowrap>
<input type="button" value="打印" class="BigButton" onclick="document.execCommand(\'Print\');" title="直接打印表格页面">
<input type="button" value="关闭" class="BigButton" onClick="window.close();" title="关闭窗口">
</td>
</tr>
</table>
';
}
else
{
message ('', '无未找到相应记录！');
}
echo '
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?