?? 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 + -