project_search.php

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

<?
	########################################
	#OsoonCrm
	#项目列表
	########################################
		
	include "include/db.inc.php";
	include "include/check.inc.php";
	include "include/header.inc.php";
	include "include/array.inc.php";
?> 
<?
	$where = " where $where_account_view ";
	// 开始日期
	if ($BeginTime == "0000-00-00") $BeginTime = "";
	if ($BeginTime != "") 
	{
		$where .= " and BeginTime>='$BeginTime' ";
	}
	
	// 项目创建者
	if ($CreateID) $where .= " and CreateID='$CreateID' ";
	
	// 项目名
	if ($ProjectName != "") $where .= " and ProjectName like '%$ProjectName%' ";
	$url = "project_search.php?BeginTime=$BeginTime&CreateID=$CreateID&ProjectName=$ProjectName&";
?>
<?
	// 翻页
	$tblname = $tbl_crm_project;
	//$where = " where $where_account_view ";
	//$url = "project_search.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"; ?>