activity_list.php

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

<?
	########################################
	#OsoonCrm
	#行动列表
	########################################
		
	include "include/db.inc.php";
	include "include/check.inc.php";
	include "include/header.inc.php";

	// 翻页
	$tblname = $tbl_crm_activity;
	$where = " ";
	$url = "activity_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>
<?
	$limitstart = ($page-1)*$perpage;
	$sql="select * from $tbl_crm_activity where ActivityExecuteID='$uid' order by ActivityID desc limit $limitstart,$perpage";
	$res=mysql_query($sql);
?>
	<br>
	<table width="95%" border="0" cellspacing="0" cellpadding="0" height=25>
        <tr align="right"> 
          <td>
          	<a href="activity_add.php">创建新行动</a>
          	|
          	<a href="activity_list.php">行动列表</a>
          </td>
        </tr>
      </table>
      <hr>
	  <table width=95% cellpadding="5" cellspacing="0" align=center border="1" bordercolor="#F5F1E9">
			<tr bgcolor=#ede5d2>
				<td>行动主题</td>
				<td>行动地点</td>
				<td>执行者</td>
				<td>开始时间</td>
				<td>完成时间</td>
				<td>客户名称</td>
		    	<td bgcolor="#ede5d2">操作</td>
			</tr>
			<? while($row=mysql_fetch_array($res)){?>
			<tr>
				<td><? echo $row[ActivityName]?></td>
				<td><? echo $row[ActivityLocation]?></td>
				<td><? echo $array_crm_id2user[$row[ActivityExecuteID]]?></td>
				<td><? echo $row[BeginTime]?></td>
				<td><? echo $row[EndTime]?></td>
				<td><? echo $array_crm_id2account[$row[AccountID]]?></td>
				<td><A HREF="activity_view.php?actid=<? echo $row[ActivityID]?>">详细</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";
?>