<?
	########################################
	#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";
?>