project_adview.php

CRM 不仅仅是一个管理名词和管理概念

<?
	########################################
	#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 align=center> 
      <br>
<?
	// 项目详细信息
	$sql="select * from $tbl_crm_project where ProjectID='$pid'";
	$sql.=" and $where_account_view ";// 添加检查
	$res=mysql_query($sql);
	$row=@mysql_fetch_array($res);
	$AccountID = $row[AccountID];
	$ContactID = $row[ContactID];
?>
<?
	// 功能按钮
	$btn_list = " <input type=button value=\"返回列表\" style=\"width:60\" onclick=\"javascript:document.location='project_list.php'\"> ";
	
	$btn_display = $btn_list;
?>
      <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="project_view.php?pid=<? echo $pid; ?>">详细信息 - 普通</A> | 
		  	<A HREF="project_adview.php?pid=<? echo $pid; ?>">详细信息 - 高级</A>
          </td>
          <td width="50%" align=right> 
            <? echo $btn_display; ?>
          </td>
        </tr>
      </table>

      <hr width=95% align=center>

      <table width="95%" border="0" 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="#ede5d2">
        <tr> 
          <td><b>客户名称</b></td>
          <td><b>电话</b></td>
          <td><b>类型</b></td>
          <td><b>网站</b></td>
          <td><b>行业</b></td>
          <td><b>地址</b></td>
          <td width=60><b>操作</b></td>
        </tr>
<?
	// 客户信息
	$sql="select * from $tbl_crm_account where AccountID='$AccountID'";
	$res=mysql_query($sql);
	if ($row_a=@mysql_fetch_array($res)) {
?>
        <tr> 
          <td><? echo $row_a[AccountName]; ?>&nbsp;</td>
          <td><? echo $row_a[Tel]; ?>&nbsp;</td>
          <td><? echo $array_crm_account_type[$row_a[AccountType]]; ?>&nbsp;</td>
          <td><? echo $row_a[WebSite]; ?>&nbsp;</td>
          <td><? echo $array_crm_account_industry[$row_a[AccountIndustry]]; ?>&nbsp;</td>
          <td><? echo $row_a[Address]; ?>&nbsp;</td>
          <td><a href="account_view.php?viewid=<? echo $AccountID ?>">详细</a>&nbsp;</td>
        </tr>
<?
	}
?>
      </table>
      <br>

      <table width="95%" border="0" 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="#ede5d2">
        <tr> 
          <td><b>联系人姓名</b></td>
          <td><b>称谓</b></td>
          <td><b>公司电话</b></td>
          <td><b>手机号码</b></td>
          <td width=60><b>操作</b></td>
        </tr>
<?
	// 项目联系人信息
	$sql="select * from $tbl_crm_contact where ContactID='$ContactID'";
	$res=mysql_query($sql);
	if ($row_c=@mysql_fetch_array($res)) {
?>
        <tr> 
          <td><? echo $row_c[ContactName]; ?>&nbsp;</td>
          <td><? echo $row_c[ChenWei]; ?>&nbsp;</td>
          <td><? echo $row_c[OfficeTel]; ?>&nbsp;</td>
          <td><? echo $row_c[Mobile]; ?>&nbsp;</td>
          <td><a href="contact_view.php?viewid=<? echo $ContactID ?>">详细</a>&nbsp;</td>
        </tr>
<?
	}
?>
      </table>
      <br>
<?
	$Column = "project";
	$ColumnID = $pid;
	include "attach.inc.php";
?>

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