📄 contact_view.php
字号:
<?
########################################
#OsoonCrm
#联系人详细-普通
########################################
include "include/db.inc.php";
include "include/check.inc.php";
include "include/header.inc.php";
include "include/array.inc.php";
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="90%">
<tr valign=top>
<td width="201">
<?
include "include/left.inc.php";
?>
</td>
<td>
<?
$sql="select * from $tbl_crm_contact where ContactID='$viewid'";
$res=mysql_query($sql);
$row=mysql_fetch_array($res);
$sql_account="select * from $tbl_crm_account where AccountID='$row[AccountID]'";
$res_account=mysql_query($sql_account);
$row_account=mysql_fetch_array($res_account);
$sql_Relation="select RelationshipName from $tbl_crm_account_relationship where RelationshipID='$row[Relation]'";
$res_Relation=mysql_query($sql_Relation);
$row_Relation=mysql_fetch_array($res_Relation);
$sql_folk="select * from $tbl_crm_contact_folk where ContactID='$row[ContactID]' order by FolkID";
$res_folk=mysql_query($sql_folk);
// 客户信息
$sql="select * from $tbl_crm_account where AccountID='$aid'";
$res=mysql_query($sql);
$row_a=@mysql_fetch_array($res);
$AccountOwnerID = $row_a[AccountOwnerID];// 客户所有人的ID
?>
<br>
<table width="95%" border="0" cellspacing="0" cellpadding="5" align="center">
<tr>
<td><b>联系人详细信息</b></td>
</tr>
</table>
<table width="95%" border="0" cellspacing="0" cellpadding="5" align="center">
<tr>
<td width="50%">
<A HREF="contact_view.php?viewid=<? echo $row[ContactID]?>">基本信息 - 普通</A> |
<A HREF="contact_adview.php?viewid=<? echo $row[ContactID]?>">详细信息 - 高级</A>
</td>
<td width="50%" align=right>
<?
// 如果不是自己的联系人
if ($row[AddID] != $G_uid)
{
?>
<input type="button" value="编辑" disabled onClick="javascript:document.location='contact_edit.php?ContactID=<? echo $viewid ?>'";>
<input type="button" value="复制" disabled onclick="javascript:document.location='contact_add.php?viewid=<? echo $viewid ?>'">
<input type="button" value="删除" disabled onclick="javascript:document.location='contact_man.php?action=delete&delid=<? echo $viewid ?>'">
<input type="button" value="返回列表" onClick="javascript:document.location='contact_list.php'"; name="button">
<?
}
else
{
?>
<input type="button" value="编辑" onClick="javascript:document.location='contact_edit.php?ContactID=<? echo $viewid ?>'";>
<input type="button" value="复制" onclick="javascript:document.location='contact_add.php?viewid=<? echo $viewid ?>'">
<input type="button" value="删除" onclick="javascript:document.location='contact_man.php?action=delete&delid=<? echo $viewid ?>'">
<input type="button" value="返回列表" onClick="javascript:document.location='contact_list.php'"; name="button">
<?
}
?>
</td>
</tr>
</table>
<hr width=95% align=center>
<table width="95%" border="1" cellspacing="0" cellpadding="5" align="center" bgcolor="#ede5d2" bordercolor="#FFFFFF">
<tr>
<td colspan="2"> <b>基本信息</b></td>
</tr>
</table>
<table width="95%" border="1" cellspacing="0" cellpadding="5" align="center" bgcolor="#F5F1E9" bordercolor="#FFFFFF">
<tr>
<td width="25%">联系人姓名</td>
<td width="25%"><? echo $row[ContactName]?></td>
<td width="25%">职务</td>
<td width="25%"><? echo $row[ZhiWu]?></td>
</tr>
<tr>
<td width="25%">电子邮件</td>
<td width="25%"><? echo $row[Email]?></td>
<td width="25%">部门</td>
<td width="25%"><? echo $row[Dept]?></td>
</tr>
<tr>
<td width="25%">工作电话</td>
<td width="25%"><? echo $row[OfficeTel]?></td>
<td width="25%">称谓</td>
<td width="25%"><? echo $row[ChenWei]?></td>
</tr>
<tr>
<td width="25%">移动电话</td>
<td width="25%"><? echo $row[Mobile]?></td>
<td width="25%">来源</td>
<td width="25%"><? echo $array_crm_source[$row[Source]]?></td>
</tr>
<tr>
<td width="25%">家庭电话</td>
<td width="25%"><? echo $row[HomeTel]?></td>
<td width="25%">生日</td>
<td width="25%"><? echo $row[Birthday]?></td>
</tr>
<tr>
<td width="25%">工作传真</td>
<td width="25%"><? echo $row[OfficeFax]?></td>
<td width="25%">与联系人的关系</td>
<td width="25%"><? echo $row_Relation[RelationshipName]?></td>
</tr>
</table>
<br>
<table width="95%" border="1" cellspacing="0" cellpadding="5" align="center" bgcolor="#ede5d2" bordercolor="#FFFFFF">
<tr>
<td width="50%"> <b>家庭主要成员</b></td>
<td width="50%" align=right>
<?
// 如果不是自己的联系人
if ($row[AddID] != $G_uid)
{
?>
<input type="button" value="新建成员" disabled onclick="document.location='contact_folk_add.php?addid=<? echo $viewid ?>'";>
<?
}else
{
?>
<input type="button" value="新建成员" onclick="document.location='contact_folk_add.php?addid=<? echo $viewid ?>'";>
<?
}
?>
</td>
</tr>
</table>
<table width="95%" border="1" cellspacing="0" cellpadding="5" align="center" bgcolor="#F5F1E9" bordercolor="#FFFFFF">
<?
while($row_folk=mysql_fetch_array($res_folk)){
?>
<tr>
<td width="20%">成员姓名</td>
<td width="20%"><? echo $row_folk[Name];?></td>
<td width="20%">与联系人的关系</td>
<td width="20%"><? echo $row_folk[Relation];?></td>
<td width="10%"><A HREF="contact_folk_view.php?ContactID=<? echo $row[ContactID];?>&FolkID=<? echo $row_folk[FolkID];?>">详细</A></td>
</tr>
<?
}
?>
</table>
<br>
<table width="95%" border="1" cellspacing="0" cellpadding="5" align="center" bgcolor="#ede5d2" bordercolor="#FFFFFF">
<tr>
<td width="50%">
<p><b>所属客户</b></p>
</td>
<td width="50%" align=right>
<input type="button" name="Button2" value="新建客户" onclick="javascript:document.location='account_add.php'";>
</td>
</tr>
</table>
<table width="95%" border="1" cellspacing="0" cellpadding="5" align="center" bgcolor="#F5F1E9" bordercolor="#FFFFFF">
<tr>
<td width="25%">客户名称</td>
<td width="25%"><? echo $row_account[AccountName]; ?></td>
<td width="25%">类型</td>
<td width="25%"><? echo $array_crm_account_type[$row_account[AccountType]]; ?></td>
</tr>
<tr>
<td width="25%">行业</td>
<td width="25%"><? echo $array_crm_account_industry[$row_account[AccountIndustry]]; ?></td>
<td width="25%">地址</td>
<td width="25%"><? echo $row_account[Address]; ?></td>
</tr>
<tr>
<td width="25%">网站</td>
<td width="25%"><A HREF="<? echo $row_account[WebSite]; ?>" target=_blank><? echo $row_account[WebSite]; ?></A></td>
<td width="25%"><b></b></td>
<td width="25%"> </td>
</tr>
</table>
<br>
<table width="95%" border="1" cellspacing="0" cellpadding="5" align="center" bgcolor="#ede5d2" bordercolor="#FFFFFF">
<tr>
<td colspan="2"> <b>创建者/修改者</b></td>
</tr>
</table>
<table width="95%" border="1" cellspacing="0" cellpadding="5" align="center" bgcolor="#F5F1E9" bordercolor="#FFFFFF">
<tr>
<td width="25%" height="21">创建者</td>
<td width="25%" height="21"><? echo $array_crm_id2user[$row[AddID]] ?></td>
<td width="25%" height="21">创建时间</td>
<td width="25%" height="21"><? echo $row[CreateTime]?></td>
</tr>
</table>
<p> </p></td>
</tr>
</table>
<?
include "include/footer.inc.php";
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -