account_view.php

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

                  </td>
                </tr>
                <tr> 
                  <td title="(大文本)" class="LDetail">成立时间 </td>
                  <td class="RDetail" colspan="3">
                    <? echo $row[22] ?>
                    &nbsp; </td>
                </tr>
               
              </table>
              <br>
                <table class="DetailTable" cellspacing="1" cellpadding="0">
                  <tr> 
                    <td class="DTitle" colspan="4">&gt;&gt;地址信息<a name="PostBackByCountry"></a></td>
                  </tr>
                  <tr> 
                    <td class="HL" colspan="4">&nbsp;</td>
                  </tr>
                </table>                
              <table class="DetailTable" cellspacing="0" cellpadding="5" border="1" bordercolor="#F5F1E9" width="95%">
                <colgroup> <col class="LDetail"> <col class="RDetail"> <col class="LDetail"> 
                <col class="RDetail"> </colgroup> 
                <tr bgcolor="#ede5d2"> 
                  <td>国家</td>
                    
                  <td>&nbsp; 
                    <? echo $array_crm_country[$row[24]] ?>
                  </td>
                    
                  <td>省份</td>
                    
                  <td>&nbsp; 
                    <? echo $row[25] ?>
                  </td>
                  </tr>
                  <tr> 
                    <td>城市</td>
                    <td>&nbsp; <? echo $row[26] ?></td>
                    <td>邮编</td>
                    <td>&nbsp; <? echo $row[28] ?></td>
                  </tr>
                  <tr> 
                    <td>地址</td>
                    <td class="RLDetail" colspan="3">&nbsp; <? echo $row[27] ?></td>
                  </tr>
                  <tr> 
                    <td>备注</td>
                    <td class="RLDetail" colspan="3">&nbsp; <? echo $row[29] ?></td>
                  </tr>
                </table>
                
              <br>
              <table class="DetailTable" cellspacing="1" cellpadding="0">
                <tr> 
                  <td class="DTitle" colspan="4">&gt;&gt;联系人<a name="PostBackByCountry"></a></td>
                </tr>
                <tr> 
                  <td class="HL" colspan="4">&nbsp;</td>
                </tr>
              </table>
                 
              
            <input type="button" value="添加联系人" onClick="javascript:document.location='contact_add.php'"; name="button3">
            <input type="button" value="返回联系人列表" onClick="javascript:document.location='contact_list.php'"; name="button32">
            <input type="button" value="返回客户列表" onClick="javascript:document.location='account_list.php'"; name="button323">
            <table width=95% cellpadding="5" cellspacing="0" border="1" bordercolor="#F5F1E9">
                <tr bgcolor="#ede5d2"> 
                  <td>联系人</td>
                  <td>称谓</td>
                  <td>职务</td>
                  <td>部门</td>
                  <td>生日</td>
                  <td>电子邮件</td>
                  <td>操作</td>
                </tr>
                <? 
		$tblname = $tbl_crm_contact;
		$sql="select * from $tbl_crm_contact where AccountID ='$viewid' order by ContactID desc";
		$res=mysql_query($sql);
		while($row=mysql_fetch_array($res))
		{
		?>
                <tr> 
                  <td>
                    <? echo $row[ContactName]?>
                  </td>
                  <td> 
                    <? echo $row[ChenWei]?>
                  </td>
                  <td>
                    <? echo $row[ZhiWu]?>
                  </td>
                  <td>
                    <? echo $row[Dept]?>
                  </td>
                  <td>
                    <? echo $row[Birthday]?>
                  </td>
                  <td><a href=mailto:<? echo $row[Email]?>>
                    <? echo $row[Email]?>
                    </a></td>
                  <td><a href="contact_view.php?viewid=<? echo $row[ContactID]?>">详细</a></td>
                </tr>
                <?
                }
                ?>
              </table>
              <br>
              <table class="DetailTable" cellspacing="1" cellpadding="0">
                <tr> 
                  <td class="DTitle" colspan="4">&gt;&gt;项目<a name="PostBackByCountry"></a></td>
                </tr>
                <tr> 
                  <td class="HL" colspan="4">&nbsp;</td>
                </tr>
              </table>
              
            <input type="button" value="添加项目" onClick="javascript:document.location='project_add.php'"; name="button33">
            <input type="button" value="返回项目列表" onClick="javascript:document.location='project_list.php'"; name="button322">
            <input type="button" value="返回客户列表" onClick="javascript:document.location='account_list.php'"; name="button324">
            <table width=95% cellpadding="3" cellspacing="0" align=left border="1" bordercolor="#F5F1E9">
                <tr bgcolor="#ede5d2"> 
                  <td>项目名</td>
                  <td>销售额</td>
                  <td>项目阶段</td>
                  <td>项目状态</td>
                  <td>项目来源</td>
                  <td>项目开始时间</td>
                  <td>相关客户</td>
                  <td width="40" bgcolor="#ede5d2">成功</td>
                  <td width="40">操作</td>
                </tr>
                <?

	$sql="select * from $tbl_crm_project where  AccountID='$viewid' order by ProjectID desc ";
	$res=mysql_query($sql);
	while ($row=@mysql_fetch_array($res)) {
		$pid = $row[ProjectID];
		$name = $row[ProjectName];
		$sale = $row[ProjectSale];
		$jieduan = $array_crm_jieduan[$row[JieDuan]];
		$state = $array_crm_project_state[$row[ProjectState]];
		$source = $array_crm_source[$row[ProjectSource]];
		$begintime = $row[BeginTime];
		$account = $array_crm_id2account[$row[AccountID]];
		$successful = $array_crm_project_successful[$row[Successful]];
?>
                <tr> 
                  <td> 
                    <? echo $name; ?>
                    &nbsp; </td>
                  <td> 
                    <? echo $sale; ?>
                    &nbsp; </td>
                  <td> 
                    <? echo $jieduan; ?>
                    &nbsp; </td>
                  <td> 
                    <? echo $state; ?>
                    &nbsp; </td>
                  <td> 
                    <? echo $source; ?>
                    &nbsp; </td>
                  <td> 
                    <? echo $begintime; ?>
                    &nbsp; </td>
                  <td> 
                    <? echo $account; ?>
                    &nbsp; </td>
                  <td> 
                    <? echo $successful; ?>
                    &nbsp; </td>
                  <td> <a href="project_view.php?pid=<? echo $pid; ?>">详细</a> 
                  </td>
                </tr>
                <?
	}
?>
              </table>
              <p>&nbsp;</p>
              <p>&nbsp;</p>
              <p>&nbsp;</p>
              <p>&nbsp;</p>
          </td>
        </tr>
      </table>
      <div align="right"></div>
      <div align="center"></div>
    </td>
  </tr> 
</table>
<?
	include "include/footer.inc.php";
?>