list.php

极限网络智能办公系统 Office Automation V3.0官方100％源代码.

    $urlstr=$urlstr."&CONTACTUSERDEF2=".$CONTACTUSERDEF2;
		 $WHERE_STR.=" and j.USERDEF2 like '%".$CONTACTUSERDEF2."%'";
		}
if($CONTACTUSERDEF3!="")
	{
      $urlstr=$urlstr."&CONTACTUSERDEF3=".$CONTACTUSERDEF3;
		 $WHERE_STR.=" and j.USERDEF3 like '%".$CONTACTUSERDEF3."%'";
	}


if($CONTACTUSERDEF4!="")
{
  $urlstr=$urlstr."&CONTACTUSERDEF4=".$CONTACTUSERDEF4;
  $WHERE_STR.=" and j.USERDEF4 like '%".$CONTACTUSERDEF4."%'";
}
if($CONTACTUSERDEF5!="")
{
  $urlstr=$urlstr."&CONTACTUSERDEF5=".$CONTACTUSERDEF5;
	$WHERE_STR.=" and j.USERDEF5 like '%".$CONTACTUSERDEF5."%'";
}
$urlstr1=str_replace("&", "%", $urlstr);
if($ORDERFIELD!="")
   {
   	 if($ORDERSIGN=="DOWN")
   	  {
   	  	$ORDERTYPE="ASC";
   	  }
     if($ORDERSIGN=="UP")
   	  {
   	  	$ORDERTYPE="DESC";
   	  }
    $OREDERBY=" ORDER BY ".$ORDERFIELD." ".$ORDERTYPE;
   }
$CUSTOMER_COUNT=0;
$query="SELECT a.CUSTOMER_ID from CUSTOMER a LEFT OUTER JOIN SYS_CODE b
        ON a.SELLMODE = b.CODE_NO AND b.PARENT_NO = 'SELL_MODE'
        LEFT OUTER JOIN SYS_CODE c
        ON a.KIND = c.CODE_NO AND c.PARENT_NO = 'CRM_KIND'
        LEFT OUTER JOIN SYS_CODE d
        ON a.CUSTOMER_AREA = d.CODE_NO AND d.PARENT_NO = 'AREA'
        LEFT OUTER JOIN SYS_CODE e
        ON a.SOURCE = e.CODE_NO AND e.PARENT_NO = 'CRM_SOURCE'
        LEFT OUTER JOIN SYS_CODE f
        ON a.ATTRIBUTE = f.CODE_NO AND f.PARENT_NO = 'CRM_ATTRIBUTE'
        LEFT OUTER JOIN SYS_CODE g
        ON a.ENTERTYPE = g.CODE_NO AND g.PARENT_NO = 'CRM_TYPE'
        LEFT OUTER JOIN USER h ON a.SELLER = h.USER_ID
        LEFT OUTER JOIN LINKMAN i ON a.CUSTOMER_ID = i.CUSTOMER_ID
        LEFT OUTER JOIN CONTACT j ON a.CUSTOMER_ID = j.CUSTOMER_ID
        LEFT OUTER JOIN SYS_CODE k
        ON j.CONTACT_TYPE = k.CODE_NO AND k.PARENT_NO = 'CONTACT_TYPE'
        ".$WHERE_STR." GROUP BY a.CUSTOMER_ID";

$cursor= exequery($connection, $query);
while($ROW=mysql_fetch_array($cursor))
{
	$CUSTOMER_COUNT++;
}

 $PER_PAGE=10;
 $PAGE_COUNT=ceil($CUSTOMER_COUNT/$PER_PAGE);
 if($CUR_PAGE<=0 || $CUR_PAGE=="")
    $CUR_PAGE=1;
 if($CUR_PAGE>$PAGE_COUNT)
    $CUR_PAGE=$PAGE_COUNT;
$query1="SELECT  a.CUSTOMER_ID, a.`CUSTOMER_NAME` , b.CODE_NAME AS 'SELLMODE', c.CODE_NAME AS KIND, d.CODE_NAME AS CUSTOMER_AREA, e.CODE_NAME AS `SOURCE` , f.CODE_NAME AS `ATTRIBUTE` , g.CODE_NAME AS `ENTERTYPE` , a.SELLER as SELLERID,h.USER_NAME AS SELLER, count(DISTINCT i.LINKMAN_ID) AS LINKMANCOUNT, count(DISTINCT j.CONTACT_ID) AS CONTACTCOUNT
        from CUSTOMER a LEFT OUTER JOIN SYS_CODE b
        ON a.SELLMODE = b.CODE_NO AND b.PARENT_NO = 'SELL_MODE'
        LEFT OUTER JOIN SYS_CODE c
        ON a.KIND = c.CODE_NO AND c.PARENT_NO = 'CRM_KIND'
        LEFT OUTER JOIN SYS_CODE d
        ON a.CUSTOMER_AREA = d.CODE_NO AND d.PARENT_NO = 'AREA'
        LEFT OUTER JOIN SYS_CODE e
        ON a.SOURCE = e.CODE_NO AND e.PARENT_NO = 'CRM_SOURCE'
        LEFT OUTER JOIN SYS_CODE f
        ON a.ATTRIBUTE = f.CODE_NO AND f.PARENT_NO = 'CRM_ATTRIBUTE'
        LEFT OUTER JOIN SYS_CODE g
        ON a.ENTERTYPE = g.CODE_NO AND g.PARENT_NO = 'CRM_TYPE'
        LEFT OUTER JOIN USER h ON a.SELLER = h.USER_ID
        LEFT OUTER JOIN LINKMAN i ON a.CUSTOMER_ID = i.CUSTOMER_ID
        LEFT OUTER JOIN CONTACT j ON a.CUSTOMER_ID = j.CUSTOMER_ID
        LEFT OUTER JOIN SYS_CODE k
        ON j.CONTACT_TYPE = k.CODE_NO AND k.PARENT_NO = 'CONTACT_TYPE'
        ".$WHERE_STR." GROUP BY a.CUSTOMER_ID".$OREDERBY;
$offest=($CUR_PAGE-1)*10;
$query1=$query1." LIMIT ". $offest." ,".$PER_PAGE;
$cursor1 = exequery($connection, $query1);
  if($CUSTOMER_COUNT==0)
  {
     Message("<br>提示","没有符合条件的客户");
     Button_Back();
     exit;
  }
  else
  {
?>

<table border="0" cellspacing="1" width="95%" class="small"  cellpadding="3">
  <tr>
    <td align="left">
        <a href="list.php?<?=$urlstr?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=1"><img src='/images/first02.gif' width='24' border='0' height='15' alt='首页'></a>
        <a href="list.php?<?=$urlstr?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE-1?>"><img src='/images/first01.gif' width='24' border='0' height='15' alt='上一页'></a>
        <a href="list.php?<?=$urlstr?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE+1?>"><img src='/images/last01.gif' width='24' border='0' height='15' alt='下一页' style="cursor:hand"></a>
        <a href="list.php?<?=$urlstr?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$PAGE_COUNT?>"><img src='/images/last02.gif'  width='24' border='0' height='15' alt='末页' style="cursor:hand"></a>

      到
      <input type="text" name="PAGE_NUM" size="3" maxlength="4"  class="SmallInput">
      页
      <img id="btnGotoPage" src="/images/menu/book.gif" onclick="set_page('<?=$urlstr?>')" border="0" WIDTH="19" HEIGHT="17" style="cursor:hand" alt="转到相应页面">
    </td>
    <td align="right">
      <?=$CUR_PAGE?>/<?=$PAGE_COUNT?>页&nbsp;共&nbsp;<?=$CUSTOMER_COUNT?>&nbsp;条
    </td>
  </tr>
</table>

<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
  <tr class="TableHeader">
  	   <td nowrap align="center">选择</td>
      <td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=CUSTOMER_NAME&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">客户名称&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="CUSTOMER_NAME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="CUSTOMER_NAME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=CUSTOMER_AREA&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">地区&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="CUSTOMER_AREA"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="CUSTOMER_AREA"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
       <td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=KIND&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">客户类别&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="KIND"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="KIND"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=SELLMODE&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">销售方式&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="SELLMODE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="SELLMODE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=SOURCE&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">客户来源&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="SOURCE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="SOURCE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=ATTRIBUTE&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">行业属性&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="ATTRIBUTE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="ATTRIBUTE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=ENTERTYPE&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">企业性质&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="ENTERTYPE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="ENTERTYPE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=SELLER&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">销售员&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="SELLER"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="SELLER"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center">操作</td>
      </tr>

<?
  $CUSTOMER_COUNT=0;
  while($ROW=mysql_fetch_array($cursor1))
  {
    $CUSTOMER_COUNT++;
    $CUSTOMER_ID=$ROW["CUSTOMER_ID"];
    $CUSTOMER_NAME1=$ROW["CUSTOMER_NAME"];
    $CUSTOMER_AREA1=$ROW["CUSTOMER_AREA"];
    $SELLER1=$ROW["SELLER"];
    $SOURCE1=$ROW["SOURCE"];
    $ATTRIBUTE1=$ROW["ATTRIBUTE"];
    $ENTERTYPE1=$ROW["ENTERTYPE"];
    $SELLMODE1=$ROW["SELLMODE"];
    $KIND1=$ROW["KIND"];
    $LINKMANCOUNT1=$ROW["LINKMANCOUNT"];
    $CONTACTCOUNT1=$ROW["CONTACTCOUNT"];
     if($ROW["SELLERID"]!=$LOGIN_USER_ID)$SIGN="1";
    if($CUSTOMER_COUNT%2==1)
       $TableLine="TableLine1";
    else
       $TableLine="TableLine2";

?>
    <tr class="<?=$TableLine?>">
    	<td>&nbsp;<input type="checkbox" name="email_select" value="<?=$CUSTOMER_ID?>" <? if($SIGN=="1")  echo "disabled"; ?> onClick="check_one(self);"></td>
      <td nowrap align="center"><?=$CUSTOMER_NAME1?></td>
      <td nowrap align="center"><?=$CUSTOMER_AREA1?></td>
      <td nowrap align="center"><?=$KIND1?></td>
      <td nowrap align="center"><?=$SELLMODE1?></td>
      <td nowrap align="center"><?=$SOURCE1?></td>
      <td nowrap align="center"><?=$ATTRIBUTE1?></td>
      <td nowrap align="center"><?=$ENTERTYPE1?></td>
      <td nowrap align="center"><?=$SELLER1?></td>
      <td nowrap align="center">
<?
     if($SIGN=="1")
       {
?>
   <a href="javascript:show_detail(<?=$CUSTOMER_ID?>);"> 详细信息 </a>
<?
      }
      else
      {
?>
 <a href="javascript:show_detail(<?=$CUSTOMER_ID?>);"> 详细信息 </a>
 <a href="../edit.php?CUSTOMER_ID=<?=$CUSTOMER_ID?>&querstr=<?=$urlstr1?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>"> 编辑</a>&nbsp;&nbsp;
 <a href="javascript:delete_customer(<?=$CUSTOMER_ID?>,'<?=$urlstr1?>');"> 删除 </a>

<?
      }
?>
      </td>
    </tr>

<?
}
  }
?>
 <tr class="TableControl">
 <td colspan="10">
 	   &nbsp;<input type="checkbox" name="allbox" id="allbox_for"  <? if($SIGN=="1")  echo "disabled"; ?> onClick="check_all();">
      <label for="allbox_for">全选</label> &nbsp;
      <input type="button"  value="批量删除" class="SmallButton" onClick="delete_mail('<?=$urlstr1?>');" title="删除所选客户"> &nbsp;
 </td>
</tr>
</table>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onclick="location='index.php'">
</div>
</body>
</html>
<script Language="JavaScript">
	function delete_mail(querstr)
{
  delete_str="";
  for(i=0;i<document.all("email_select").length;i++)
  {

      el=document.all("email_select").item(i);
      if(el.checked)
      {  val=el.value;
         delete_str+=val + ",";
      }
  }

  if(i==0)
  {
      el=document.all("email_select");
      if(el.checked)
      {  val=el.value;
         delete_str+=val + ",";
      }
  }

  if(delete_str=="")
  {
     alert("请至少选择其中一个客户。");
     return;
  }

  msg='确认要删除所选客户？';
  if(window.confirm(msg))
  {
    URL="../delete.php?querstr="+querstr+"&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&delete_str=" + delete_str;
    window.location=URL;
  }
}  
</script>