contact_search.php

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

<?
	########################################
	#OsoonCrm
	#联系人检索
	########################################
		
	include "include/db.inc.php";
	include "include/check.inc.php";
	include "include/header.inc.php";
	include "include/array.inc.php";

	// 翻页
	$tblname = $tbl_crm_contact;
	$where = " where ContactName like '%$contactname%' AND AddID='$G_uid' ";
	$url = "contact_search.php?";

	$sql_count = "select count(*) from $tblname $where";
	$res_count = mysql_query($sql_count);
	$row_count = @mysql_fetch_array($res_count);
	$total = $row_count[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_contact $where order by ContactID 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="contact_add.php">添加联系人</a>
          	|
          	<a href="contact_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[ContactName]?></td>
				<td><? echo $row[ChenWei]?></td>
				<td><? echo $row[ZhiWu]?></td>
				<td><? echo $row[Dept]?></td>
				<td><? echo $row[OfficeTel]?></td>
				<td><a href=mailto:<? echo $row[Email]?>><? echo $row[Email]?></a></td>
				<td><A HREF="contact_view.php?viewid=<? echo $row[ContactID]?>">详细</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"; ?>