contact_adview.php

来自「CRM 不仅仅是一个管理名词和管理概念」· PHP 代码 · 共 134 行

<?
	########################################
	#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_activity="select * from $tbl_crm_activity where AccountID='$row[AccountID]' order by ActivityID";
	$res_activity=mysql_query($sql_activity);

	$sql_project="select * from $tbl_crm_project where CreateID='$G_uid' AND ContactID='$row[ContactID]' order by ProjectID";
	$res_project=mysql_query($sql_project);

?>
		<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> 
			<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 width=80%> <b>行动</b></td>
          <td width=20% align=right>
            <input type="button" value="新建行动" onclick="javascript:document.location='activity_add.php'";>
          </td>
        </tr>
      </table>
      <table width="95%" border="1" cellspacing="0" cellpadding="5" align="center" bgcolor="#F5F1E9" bordercolor="#FFFFFF">
        <tr> 
          <td width="12%"><b>主题</b></td>
          <td width="12%"><b>地点</b></td>
          <td width="12%"><b>行动方式</b></td>
          <td width="12%"><b>实行者</b></td>
          <td width="12%"><b>开始时间</b></td>
          <td width="12%"><b>结束时间</b></td>
          <td width="12%"><b>预计费用</b></td>
          <td width="12%"><b>结果</b></td>
        </tr>
<?
	while($row_activity=mysql_fetch_array($res_activity)){
?> 
        <tr> 
          <td width="12%"><a href="activity_view.php?activityid=<? echo $row_activity[ActivityID];?>"><? echo $row_activity[ActivityName];?></a></td>
          <td width="12%"><? echo $row_activity[ActivityLocation];?></td>
          <td width="12%"><? echo $row_activity[ActivityMode];?></td>
          <td width="12%"><? echo $row_activity[ActivityExecuteID];?></td>
          <td width="12%"><? echo $row_activity[BeginTime];?></td>
          <td width="12%"><? echo $row_activity[EndTime];?></td>
          <td width="12%"><? echo $row_activity[YuJianSale];?></td>
          <td width="12%"><? echo $row_activity[Result];?></td>
		</tr>
<?
	}
?> 
      </table>
      <br>
      <table width="95%" border="1" cellspacing="0" cellpadding="5" align="center" bgcolor="#ede5d2" bordercolor="#FFFFFF">
        <tr> 
          <td width=80%> <b>项目</b></td>
          <td width=20% align=right> 
            <input type="button" value="新建项目" onclick="javascript:document.location='project_add.php'";>
          </td>
        </tr>
      </table>
      <table width="95%" border="1" cellspacing="0" cellpadding="5" align="center" bgcolor="#F5F1E9" bordercolor="#FFFFFF">
        <tr> 
          <td width="12%"><b>项目名</b></td>
          <td width="12%"><b>销售额</b></td>
          <td width="12%"><b>项目阶段</b></td>
          <td width="12%"><b>项目状态</b></td>
          <td width="12%"><b>项目来源</b></td>
          <td width="12%"><b>项目开始时间</b></td>
          <td width="12%"><b>相关客户</b></td>
        </tr>
<?
	while($row_project=mysql_fetch_array($res_project)){
?> 
        <tr> 
          <td width="12%"><A HREF="project_view.php?pid=<? echo $row_project[ProjectID];?>"><? echo $row_project[ProjectName];?></A>&nbsp;</td>
          <td width="12%"><? echo $row_project[ProjectSale];?>&nbsp;</td>
          <td width="12%"><? echo $array_crm_jieduan[$row_project[JieDuan]];?>&nbsp;</td>
          <td width="12%"><? echo $array_crm_project_state[$row_project[ProjectState]];?>&nbsp;</td>
          <td width="12%"><? echo $array_crm_source[$row_project[ProjectSource]];?>&nbsp;</td>
          <td width="12%"><? echo $row_project[BeginTime];?>&nbsp;</td>
          <td width="12%"><? echo $array_crm_id2account[$row_project[AccountID]];?>&nbsp;</td>
        </tr>
<?
	}
?> 
     </table>
     <br>
<?
	$Column = "contact";
	$ColumnID = $viewid;
	include "attach.inc.php";
?>

     <p></p>
    </td>
  </tr> 
</table>
<?
	include "include/footer.inc.php";
?>