📄 detail.php

📁 通达OA28 部分程序源码
💻 PHP
字号:
<?
include_once("inc/auth.php");
?>

<html>
<head>
<title>联系人详细资料 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

</head>

<?
 

 $query = "SELECT * from LINKMAN where LINKMAN_ID=$LINKMAN_ID";
 $cursor= exequery($connection,$query);
 if($ROW=mysql_fetch_array($cursor))
 {
    $CUSTOMER_ID1=$ROW["CUSTOMER_ID"];
    $LINKMAN_NAME1=$ROW["LINKMAN_NAME"];
    $SEX1=$ROW["SEX"];
    $BIRTHDAY1=$ROW["BIRTHDAY"];
    $BIRTHDAY1=strtok($BIRTHDAY1," ");
    $POST_PRIV1=$ROW["POST_PRIV"];
    $HOBBY1=$ROW["HOBBY"];
    $ADD_HOME1=$ROW["ADD_HOME"];
    $POSTALCODE_HOME1=$ROW["POSTALCODE_HOME"];
    $TEL_NO_WORK1=$ROW["TEL_NO_WORK"];
    $TEL_NO_HOME1=$ROW["TEL_NO_HOME"];
    $MOBILE1=$ROW["MOBILE"];
    $EMAIL1=$ROW["EMAIL"];
    $OICQ1=$ROW["OICQ"];
    $ICQ1=$ROW["ICQ"];
    $MEMO1=$ROW["MEMO"];

		if($SEX1=="0")
			$SEX_DESC="男";
		else
			$SEX_DESC="女";

		$query = "SELECT CUSTOMER_NAME from CUSTOMER where CUSTOMER_ID='$CUSTOMER_ID1'";
	  $cursor= exequery($connection,$query);
    if($ROW=mysql_fetch_array($cursor))
		  $CUSTOMER_NAME=$ROW["CUSTOMER_NAME"];	

    $CUSTOMER_NAME=str_replace("<","&lt",$CUSTOMER_NAME);$CUSTOMER_NAME=str_replace(">","&gt",$CUSTOMER_NAME);$CUSTOMER_NAME=stripslashes($CUSTOMER_NAME);
    $LINKMAN_NAME1=str_replace("<","&lt",$LINKMAN_NAME1);$LINKMAN_NAME1=str_replace(">","&gt",$LINKMAN_NAME1);$LINKMAN_NAME1=stripslashes($LINKMAN_NAME1);
    $BIRTHDAY1=str_replace("<","&lt",$BIRTHDAY1);$BIRTHDAY1=str_replace(">","&gt",$BIRTHDAY1);$BIRTHDAY1=stripslashes($BIRTHDAY1);
    $POST_PRIV1=str_replace("<","&lt",$POST_PRIV1);$POST_PRIV1=str_replace(">","&gt",$POST_PRIV1);$POST_PRIV1=stripslashes($POST_PRIV1);
    $HOBBY1=str_replace("<","&lt",$HOBBY1);$HOBBY1=str_replace(">","&gt",$HOBBY1);$HOBBY1=stripslashes($HOBBY1);
    $ADD_HOME1=str_replace("<","&lt",$ADD_HOME1);$ADD_HOME1=str_replace(">","&gt",$ADD_HOME1);$ADD_HOME1=stripslashes($ADD_HOME1);
    $POSTALCODE_HOME1=str_replace("<","&lt",$POSTALCODE_HOME1);$POSTALCODE_HOME1=str_replace(">","&gt",$POSTALCODE_HOME1);$POSTALCODE_HOME1=stripslashes($POSTALCODE_HOME1);
    $TEL_NO_WORK1=str_replace("<","&lt",$TEL_NO_WORK1);$TEL_NO_WORK1=str_replace(">","&gt",$TEL_NO_WORK1);$TEL_NO_WORK1=stripslashes($TEL_NO_WORK1);
    $TEL_NO_HOME1=str_replace("<","&lt",$TEL_NO_HOME1);$TEL_NO_HOME1=str_replace(">","&gt",$TEL_NO_HOME1);$TEL_NO_HOME1=stripslashes($TEL_NO_HOME1);
    $MOBILE1=str_replace("<","&lt",$MOBILE1);$MOBILE1=str_replace(">","&gt",$MOBILE1);$MOBILE1=stripslashes($MOBILE1);
    $EMAIL1=str_replace("<","&lt",$EMAIL1);$EMAIL1=str_replace(">","&gt",$EMAIL1);$EMAIL1=stripslashes($EMAIL1);
    $OICQ1=str_replace("<","&lt",$OICQ1);$OICQ1=str_replace(">","&gt",$OICQ1);$OICQ1=stripslashes($OICQ1);
    $ICQ1=str_replace("<","&lt",$ICQ1);$ICQ1=str_replace(">","&gt",$ICQ1);$ICQ1=stripslashes($ICQ1);
    $MEMO1=str_replace("<","&lt",$MEMO1);$MEMO1=str_replace(">","&gt",$MEMO1);$MEMO1=stripslashes($MEMO1);
    
 }

?>

<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/edit.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><span class="big3"> 联系人详细信息</span>
    </td>
  </tr>
</table>

<table border="0" cellspacing="1" width="450" class="small" bgcolor="#000000" cellpadding="3" align="center" >
  <form name="form1">
   <tr>
    <td nowrap class="TableData">客户单位： </td>
    <td class="TableData">
      <?=$CUSTOMER_NAME?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">姓名： </td>
    <td nowrap class="TableData">
      <?=$LINKMAN_NAME1?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData"> 性别：</td>
    <td class="TableData">
      <?=$SEX_DESC?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">生日： </td>
    <td nowrap class="TableData">
      <?=$BIRTHDAY1?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">职位： </td>
    <td nowrap class="TableData">
      <?=$POST_PRIV1?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">爱好： </td>
    <td nowrap class="TableData">
      <?=$HOBBY1?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">家庭住址： </td>
    <td nowrap class="TableData">
      <?=$ADD_HOME1?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">家庭邮编： </td>
    <td nowrap class="TableData">
      <?=$POSTALCODE_HOME1?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">工作电话： </td>
    <td nowrap class="TableData">
      <?=$TEL_NO_WORK1?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">家庭电话： </td>
    <td nowrap class="TableData">
      <?=$TEL_NO_HOME1?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">手机： </td>
    <td nowrap class="TableData">
      <?=$MOBILE1?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">EMAIL： </td>
    <td nowrap class="TableData">
      <?=$EMAIL1?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">OICQ号码： </td>
    <td nowrap class="TableData">
      <?=$OICQ1?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">ICQ号码： </td>
    <td nowrap class="TableData">
      <?=$ICQ1?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">备注：</td>
    <td nowrap class="TableData">
      <?=$MEMO1?>&nbsp;
    </td>
   </tr>
   <tr align="center" class="TableControl">
     <td colspan="2">
       <input type="button" value="关闭" class="BigButton" onClick="javascript:window.close();">
     </td>
   </tr>
  </form>
</table>

</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -