<?
	########################################
	#OsoonCrm
	#項目列表
	########################################
		
	include "include/db.inc.php";
	include "include/check.inc.php";
	include "include/header.inc.php";
	include "include/array.inc.php";
?> 
<?
	// 翻頁
	$tblname = $tbl_crm_project;
	$where = " where $where_account_view ";
	$url = "project_list.php?";

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

	include "include/function.inc.php";
	pagelink($total, $url);
?>
<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>
      <table width="95%" border="0" cellspacing="0" cellpadding="0" height=25>
        <tr align="right"> 
          <td>
          	<a href="project_add.php">添加新項目</a>
          	|
          	<a href="project_list.php">項目列表</a>
          </td>
        </tr>
      </table>
      <hr>
      <table width=95% cellpadding="3" cellspacing="0" align=center border="1" bordercolor="#F5F1E9">
        <tr bgcolor="#ede5d2"> 
          <td>項目名</td>
          <td>銷售額</td>
          <td>項目階段</td>
          <td>項目狀態</td>
          <td>項目來源</td>
          <td>項目開始時間</td>
          <td>相關客戶</td>
          <td>創建者</td>
          <td width="40">成功</td>
          <td width="40">操作</td>
        </tr>
<?
	$limitstart = ($page-1)*$perpage;
	$sql="select * from $tbl_crm_project $where order by ProjectID desc limit $limitstart,$perpage";
	$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]];
		$creater = $array_crm_id2user[$row[CreateID]];
		$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 $creater; ?>&nbsp;
          </td>
          <td>
            <? echo $successful; ?>&nbsp;
          </td>
          <td>
          	<a href="project_view.php?pid=<? echo $pid; ?>">詳細</a>
          </td>
        </tr>
<?
	}
?>
      </table>
      <table width="95%" border="0" cellspacing="0" cellpadding="0" height=25>
        <tr align="right"> 
          <td><? echo $pagelink; ?></td>
        </tr>
      </table>

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