account_list.php

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

<?
	########################################
	#OsoonCrm
	#客户列表
	########################################
	include "include/check.inc.php";	
	include "include/db.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>
<?
	$tblname = crm_account;
	$where = " ";
	$url = "account_list.php?";

	$sql = "select count(*) from crm_account where $where_account_view";
	
	$res = @mysql_query($sql);
	$row = @mysql_fetch_array($res);
	$total = $row[0];

	include "include/function.inc.php";
	pagelink($total, $url);
	$sql="select * from crm_account where $where_account_view order by AccountID";
	$res=mysql_query($sql);
?>
	<br>
	<table width="95%" border="0" cellspacing="0" cellpadding="0" height=25>
        <tr align="right"> 
          <td> <a href="account_move.php">转移客户</a> | <a href="account_add.php">添加客户</a> 
            | <a href="account_list.php">客户列表</a> </td>
        </tr>
      </table>
      <hr>
	  <table width=95% cellpadding="5" cellspacing="0" align=center border="1" bordercolor="#F5F1E9">
        <tr bgcolor=#ede5d2> 
          <td width="11%">客户名称</td>
          <td width="10%">客户类型</td>
          <td width="22%">客户地址</td>
          <td width="11%">主要电话</td>
          <td width="10%">行业</td>
          <td width="9%">信用度</td>
          <td bgcolor="#ede5d2" width="9%">拥有者</td>
          <td bgcolor="#ede5d2" width="7%">状态</td>
          <td bgcolor="#ede5d2" width="11%">操作</td>
        </tr>
        <? while($row=@mysql_fetch_array($res)){?>
        <tr> 
          <td width="11%">&nbsp 
            <? echo $row[AccountName]?>
          </td>
          <td width="10%">&nbsp 
            <? echo $array_crm_account_type[$row[AccountType]]?>
          </td>
          <td width="22%">&nbsp 
            <? echo $row[Address]?>
          </td>
          <td width="11%">&nbsp 
            <? echo $row[Tel]?>
          </td>
          <td width="10%">&nbsp 
            <? echo $array_crm_account_industry[$row[AccountIndustry]]?>
          </td>
          <td width="9%">&nbsp 
            <? echo $row[Credit]?>
          </td>
          <td width="9%">&nbsp;<? echo $array_crm_id2user[$row[1]] ?></td>
          <td width="7%">&nbsp;<? if ($row[23]==1) echo "共享";else echo "私有"; ?></td>
          <td width="11%"><a href="account_view.php?viewid=<? echo $row[AccountID]?>">详细</a></td>
        </tr>
        <?}?>
      </table>
		<table width="95%" border="0" cellspacing="0" cellpadding="0" height=25>
        <tr align="right"> 
          <td><? echo $pagelink; ?></td>
        </tr>
      </table>

    </td>
  </tr> 

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