📄 showdetail.php
字号:
<?
include_once("inc/auth.php");
?>
<html>
<head>
<title>联系人详细资料</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<?
$query = "SELECT * from PROVIDER_LINKMAN where LINKMAN_ID=$LINKMAN_ID";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$PROVIDER_ID1=$ROW["PROVIDER_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"];
$MEMO11=$ROW["MEMO"];
$MEMO12=$ROW["MEMO1"];
$USERDEF11=$ROW["USERDEF1"];
$USERDEF21=$ROW["USERDEF2"];
$USERDEF31=$ROW["USERDEF3"];
$USERDEF41=$ROW["USERDEF4"];
$USERDEF51=$ROW["USERDEF5"];
}
$query="SELECT PROVIDER_NAME from PROVIDER where PROVIDER_ID='$PROVIDER_ID1'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$PROVIDER_NAME1=$ROW["PROVIDER_NAME"];
}
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/customerdetail.gif" align="absmiddle"><span class="big3"> 联系人详细资料</span>
</td>
</tr>
</table>
<br>
<table border="0" cellspacing="1" width="450" class="small" bgcolor="#000000" cellpadding="3" align="center" >
<form action="update.php" method="post" name="form1">
<tr>
<td nowrap class="TableHeader" colspan="4" align="left">
联系人基本信息
</td>
</tr>
<tr>
<td nowrap class="TableData">供应商名称： </td>
<td class="TableData">
<?=$PROVIDER_NAME1?>
</td>
<td nowrap class="TableData">联系人职位： </td>
<td nowrap class="TableData">
<?=$POST_PRIV1?>
</td>
</tr>
<tr>
<td nowrap class="TableData">联系人姓名： </td>
<td nowrap class="TableData">
<?=$LINKMAN_NAME1?>
</td>
<td nowrap class="TableData"> 性别：</td>
<td class="TableData">
<?
if($SEX1=="0") echo "男";
if($SEX1=="1") echo "女";
?>
</td>
</tr>
<tr>
<td nowrap class="TableData">生日： </td>
<td nowrap class="TableData">
<?=$BIRTHDAY1?>
</td>
<td nowrap class="TableData">爱好： </td>
<td nowrap class="TableData">
<?=$HOBBY1?>
</td>
</tr>
<tr>
<td nowrap class="TableHeader" colspan="4" align="left">
联系方式
</td>
</tr>
<tr>
<td nowrap class="TableData">家庭邮编： </td>
<td nowrap class="TableData" colspan="3">
<?=$POSTALCODE_HOME1?>
</td>
</tr>
<tr>
<td nowrap class="TableData">家庭住址： </td>
<td nowrap class="TableData" colspan="3">
<?=$ADD_HOME1?>
</td>
</tr>
<tr>
<td nowrap class="TableData">工作电话： </td>
<td nowrap class="TableData">
<?=$TEL_NO_WORK1?>
</td>
<td nowrap class="TableData">家庭电话： </td>
<td nowrap class="TableData">
<?=$TEL_NO_HOME1?>
</td>
</tr>
<tr>
<td nowrap class="TableData">手机： </td>
<td nowrap class="TableData">
<?=$MOBILE1?>
</td>
<td nowrap class="TableData">EMAIL： </td>
<td nowrap class="TableData">
<?=$EMAIL1?>
</td>
</tr>
<tr>
<td nowrap class="TableData">QQ号码： </td>
<td nowrap class="TableData">
<?=$OICQ1?>
</td>
<td nowrap class="TableData">MSN： </td>
<td nowrap class="TableData">
<?=$ICQ1?>
</td>
</tr>
<tr>
<td nowrap class="TableHeader" colspan="4" align="left">
备注
</td>
</tr>
<tr>
<td nowrap class="TableData" width="120">备注1：</td>
<td nowrap class="TableData" colspan="3">
<?=$MEMO11?>
</td>
</tr>
<tr>
<td nowrap class="TableData" width="120">备注2：</td>
<td nowrap class="TableData" colspan="3">
<?=$MEMO12?>
</td>
</tr>
<?
$count=0;
$connection=OpenConnection();
$query = "select count(*) from FIELDSETTING where TABLENAME='PROVIDER_LINKMAN'";
$cursor=exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$count=$ROW[0];
}
if($count>0)
{
?>
<tr>
<td nowrap class="TableHeader" colspan="8" align="left">
用户自定义信息：
</td>
</tr>
<?
$query = "select * from FIELDSETTING where TABLENAME='PROVIDER_LINKMAN' ORDER BY ORDERNO ASC ";
$cursor=exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$FIELDNAME=$ROW["FIELDNAME"];
$ORDERNO=$ROW["ORDERNO"];
$STYPE=$ROW["STYPE"];
$TYPENAME=$ROW["TYPENAME"];
$TYPEVALUE=$ROW["TYPEVALUE"];
$TYPECODE=$ROW["TYPECODE"];
$ISQUERY=$ROW["ISQUERY"];
$ISGROUY=$ROW["ISGROUY"];
$FIELDNAME=$ROW["FIELDNAME"];
$FIELDNO=$ROW["FIELDNO"];
$FIELDNO1=$FIELDNO."1";
?>
<tr>
<td nowrap class="TableData"><?=$FIELDNAME?>：</td>
<td nowrap class="TableData" colspan="7">
<?
if($STYPE=="T")
{
?>
<?=$$FIELDNO1?>
<?
}
if($STYPE=="MT")
{
?>
<?=$$FIELDNO1?>
<?
}
if($STYPE=="D")
{
$TYPEVALUE=str_replace("，",",",$TYPEVALUE);
$TYPEVALUE_ARRAY=explode(",",$TYPEVALUE);
$TYPENAME=str_replace("，",",",$TYPENAME);
$TYPENAME_ARRAY=explode(",",$TYPENAME);
$TYPENAME_COUNT=sizeof($TYPENAME_ARRAY);
if($TYPENAME_ARRAY[$TYPENAME_COUNT-1]=="")$TYPENAME_COUNT--;
for($I=0;$I<$TYPENAME_COUNT;$I++)
{
if($$FIELDNO1==$TYPEVALUE_ARRAY[$I])
{
?>
<?=$TYPENAME_ARRAY[$I]?>
<?
}
}
}
if($STYPE=="C")
{
$temp=str_replace("，",",",$$FIELDNO1);
$temp_ARRAY=explode(",",$temp);
$temp_ARRAY_count=sizeof($temp_ARRAY);
$TYPEVALUE=str_replace("，",",",$TYPEVALUE);
$TYPEVALUE_ARRAY=explode(",",$TYPEVALUE);
$TYPENAME=str_replace("，",",",$TYPENAME);
$TYPENAME_ARRAY=explode(",",$TYPENAME);
$TYPENAME_COUNT=sizeof($TYPENAME_ARRAY);
if($TYPENAME_ARRAY[$TYPENAME_COUNT-1]=="")$TYPENAME_COUNT--;
for($I=0;$I<$TYPENAME_COUNT;$I++)
{
$flag=0;
for($T=0;$T< $temp_ARRAY_count;$T++)
{
if($temp_ARRAY[$T]==$TYPEVALUE_ARRAY[$I])
{
?>
<?=$TYPENAME_ARRAY[$I]?>,
<?
}
}
}
}
if($STYPE=="R")
{
$TYPEVALUE=str_replace("，",",",$TYPEVALUE);
$TYPEVALUE_ARRAY=explode(",",$TYPEVALUE);
$TYPENAME=str_replace("，",",",$TYPENAME);
$TYPENAME_ARRAY=explode(",",$TYPENAME);
$TYPENAME_COUNT=sizeof($TYPENAME_ARRAY);
if($TYPENAME_ARRAY[$TYPENAME_COUNT-1]=="")$TYPENAME_COUNT--;
for($I=0;$I<$TYPENAME_COUNT;$I++)
{
if($$FIELDNO1==$TYPEVALUE_ARRAY[$I])
{
?>
<?=$TYPENAME_ARRAY[$I]?>
<?
}
}
}
?>
</td>
</tr>
<?
}
}
?>
<tr>
<td nowrap class="TableControl" colspan="8" align="center">
<input type="button" value="关闭" class="SmallButton" onclick="window.close()">
</td>
</tr>
</form>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -