📄 list.php
字号:
else $urlstr=$urlstr."&LINKMANUSERDEF4=".$LINKMANUSERDEF4;
if($WHERE_STR=="")
$WHERE_STR.=" where i.USERDEF4 like '%".$LINKMANUSERDEF4."%'";
else
$WHERE_STR.=" and i.USERDEF4 like '%".$LINKMANUSERDEF4."%'";
}
if($LINKMANUSERDEF5!="")
{
if($urlstr=="")$urlstr="LINKMANUSERDEF5=".$LINKMANUSERDEF5;
else $urlstr=$urlstr."&LINKMANUSERDEF5=".$LINKMANUSERDEF5;
if($WHERE_STR=="")
$WHERE_STR.=" where i.USERDEF5 like '%".$LINKMANUSERDEF5."%'";
else
$WHERE_STR.=" and i.USERDEF5 like '%".$LINKMANUSERDEF5."%'";
}
if($CONTACT_TYPE!="")
{
if($urlstr=="")$urlstr="CONTACT_TYPE=".$CONTACT_TYPE;
else $urlstr=$urlstr."&CONTACT_TYPE=".$CONTACT_TYPE;
if($WHERE_STR=="")
$WHERE_STR.=" where j.CONTACT_TYPE ='$CONTACT_TYPE'";
else
$WHERE_STR.=" and j.CONTACT_TYPE ='$CONTACT_TYPE'";
}
if($CONTACT_DATE1!="")
{
if($urlstr=="")$urlstr="CONTACT_DATE1=".$CONTACT_DATE1;
else $urlstr=$urlstr."&CONTACT_DATE1=".$CONTACT_DATE1;
if($WHERE_STR=="")
$WHERE_STR.=" where j.CONTACT_DATE>='$CONTACT_DATE1'";
else
$WHERE_STR.=" and j.CONTACT_DATE>='$CONTACT_DATE1'";
}
if($CONTACT_DATE2!="")
{
if($urlstr=="")$urlstr="CONTACT_DATE2=".$CONTACT_DATE2;
else $urlstr=$urlstr."&CONTACT_DATE2=".$CONTACT_DATE2;
if($WHERE_STR=="")
$WHERE_STR.=" where j.CONTACT_DATE<='$CONTACT_DATE2'";
else
$WHERE_STR.=" and j.CONTACT_DATE<='$CONTACT_DATE2'";
}
if($SATISFY!="")
{
if($urlstr=="")$urlstr="SATISFY=".$SATISFY;
else $urlstr=$urlstr."&SATISFY=".$SATISFY;
if($WHERE_STR=="")
$WHERE_STR.=" where j.SATISFY ='$SATISFY'";
else
$WHERE_STR.=" and j.SATISFY ='$SATISFY'";
}
if($CONTACT_CONTENT!="")
{
if($urlstr=="")$urlstr="CONTACT_CONTENT=".$CONTACT_CONTENT;
else $urlstr=$urlstr."&CONTACT_CONTENT=".$CONTACT_CONTENT;
if($WHERE_STR=="")
$WHERE_STR.=" where j.CONTACT_CONTENT like '%".$CONTACT_CONTENT."%'";
else
$WHERE_STR.=" and j.CONTACT_CONTENT like '%".$CONTACT_CONTENT."%'";
}
if($CONTACTUSERDEF1!="")
{
if($urlstr=="")$urlstr="CONTACTUSERDEF1=".$CONTACTUSERDEF1;
else $urlstr=$urlstr."&CONTACTUSERDEF1=".$CONTACTUSERDEF1;
if($WHERE_STR=="")
$WHERE_STR.=" where j.USERDEF1 like '%".$CONTACTUSERDEF1."%'";
else
$WHERE_STR.=" and j.USERDEF1 like '%".$CONTACTUSERDEF1."%'";
}
if($CONTACTUSERDEF2!="")
{
if($urlstr=="")$urlstr="CONTACTUSERDEF2=".$CONTACTUSERDEF2;
else $urlstr=$urlstr."&CONTACTUSERDEF2=".$CONTACTUSERDEF2;
if($WHERE_STR=="")
$WHERE_STR.=" where j.USERDEF2 like '%".$CONTACTUSERDEF2."%'";
else
$WHERE_STR.=" and j.USERDEF2 like '%".$CONTACTUSERDEF2."%'";
}
if($CONTACTUSERDEF3!="")
{
if($urlstr=="")$urlstr="CONTACTUSERDEF3=".$CONTACTUSERDEF3;
else $urlstr=$urlstr."&CONTACTUSERDEF3=".$CONTACTUSERDEF3;
if($WHERE_STR=="")
$WHERE_STR.=" where j.USERDEF3 like '%".$CONTACTUSERDEF3."%'";
else
$WHERE_STR.=" and j.USERDEF3 like '%".$CONTACTUSERDEF3."%'";
}
if($CONTACTUSERDEF4!="")
{
if($urlstr=="")$urlstr="CONTACTUSERDEF4=".$CONTACTUSERDEF4;
else $urlstr=$urlstr."&CONTACTUSERDEF4=".$CONTACTUSERDEF4;
if($WHERE_STR=="")
$WHERE_STR.=" where j.USERDEF4 like '%".$CONTACTUSERDEF4."%'";
else
$WHERE_STR.=" and j.USERDEF4 like '%".$CONTACTUSERDEF4."%'";
}
if($CONTACTUSERDEF5!="")
{
if($urlstr=="")$urlstr="CONTACTUSERDEF5=".$CONTACTUSERDEF5;
else $urlstr=$urlstr."&CONTACTUSERDEF5=".$CONTACTUSERDEF5;
if($WHERE_STR=="")
$WHERE_STR.=" where j.USERDEF5 like '%".$CONTACTUSERDEF5."%'";
else
$WHERE_STR.=" and j.USERDEF5 like '%".$CONTACTUSERDEF5."%'";
}
if($ORDERFIELD!="")
{
if($ORDERSIGN=="DOWN")
{
$ORDERTYPE="ASC";
}
if($ORDERSIGN=="UP")
{
$ORDERTYPE="DESC";
}
$OREDERBY=" ORDER BY ".$ORDERFIELD." ".$ORDERTYPE;
}
$CUSTOMER_COUNT=0;
$query="SELECT count(*) from CONTACT j LEFT OUTER JOIN CUSTOMER a ON a.CUSTOMER_ID = j.CUSTOMER_ID
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 j.SELLER = h.USER_ID
LEFT OUTER JOIN LINKMAN i ON j.LINKMAN_ID = i.LINKMAN_ID
LEFT OUTER JOIN SYS_CODE k
ON j.CONTACT_TYPE = k.CODE_NO AND k.PARENT_NO = 'CONTACT_TYPE'
".$WHERE_STR;
$cursor= exequery($connection, $query);
if($ROW=mysql_fetch_array($cursor))
{
$CUSTOMER_COUNT=$ROW[0];
}
$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 j.CONTACT_ID as CONTACT_ID ,j.MONEY_COST as MONEY_COST,j.TIME_COST as TIME_COST ,a.CUSTOMER_NAME as CUSTOMER_NAME,c.CODE_NAME as KIND,b.CODE_NAME as SELLMODE,k.CODE_NAME as CONTACT_TYPE,j.CONTACT_DATE as CONTACT_DATE,j.CONTACT_CONTENT as CONTACT_CONTENT,h.USER_NAME as SELLER
from CONTACT j LEFT OUTER JOIN CUSTOMER a ON a.CUSTOMER_ID = j.CUSTOMER_ID
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 j.SELLER = h.USER_ID
LEFT OUTER JOIN LINKMAN i ON j.LINKMAN_ID = i.LINKMAN_ID
LEFT OUTER JOIN SYS_CODE k
ON j.CONTACT_TYPE = k.CODE_NO AND k.PARENT_NO = 'CONTACT_TYPE'
".$WHERE_STR.$OREDERBY;
$offest=($CUR_PAGE-1)*10;
$query1=$query1." LIMIT ". $offest." ,".$PER_PAGE;
$cursor1 = exequery($connection, $query1);
if($CUSTOMER_COUNT==0)
{
Message("<br>提示","没有符合条件的服务记录");
exit;
}
else
{
?>
<table border="0" cellspacing="1" width="95%" class="small" cellpadding="3">
<tr>
<td align="left">
<a href="list.php?<?=$urlstr?>&CUR_PAGE=1&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/first02.gif' width='24' border='0' height='15' alt='首页'></a>
<a href="list.php?<?=$urlstr?>&CUR_PAGE=<?=$CUR_PAGE-1?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/first01.gif' width='24' border='0' height='15' alt='上一页'></a>
<a href="list.php?<?=$urlstr?>&CUR_PAGE=<?=$CUR_PAGE+1?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/last01.gif' width='24' border='0' height='15' alt='下一页' style="cursor:hand"></a>
<a href="list.php?<?=$urlstr?>&CUR_PAGE=<?=$PAGE_COUNT?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><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?>页 共 <?=$CUSTOMER_COUNT?> 条
</td>
</tr>
</table>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader">
<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?>">客户名称 <? 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=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?>">客户类别 <? 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?>">销售方式 <? 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=CONTACT_TYPE&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?>">服务类型 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="CONTACT_TYPE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="CONTACT_TYPE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=CONTACT_DATE&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?>">服务日期 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="CONTACT_DATE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="CONTACT_DATE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center" width="150">服务内容</td>
<td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=MONEY_COST&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?>">服务成本 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="MONEY_COST"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="MONEY_COST"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=TIME_COST&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?>">服务成本（时间） <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="TIME_COST"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="TIME_COST"){?><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?>">销售员 <? 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>
</tr>
<?
$CUSTOMER_COUNT=0;
while($ROW=mysql_fetch_array($cursor1))
{
$CUSTOMER_COUNT++;
$CONTACT_ID1=$ROW["CONTACT_ID"];
$CUSTOMER_NAME1=$ROW["CUSTOMER_NAME"];
$KIND1=$ROW["KIND"];
$SELLMODE1=$ROW["SELLMODE"];
$CONTACT_TYPE1=$ROW["CONTACT_TYPE"];
$CONTACT_DATE1=$ROW["CONTACT_DATE"];
$CONTACT_CONTENT1=$ROW["CONTACT_CONTENT"];
$SELLER1=$ROW["SELLER"];
$MONEY_COST1=$ROW["MONEY_COST"];
$TIME_COST1=$ROW["TIME_COST"];
if($CUSTOMER_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>">
<td nowrap align="center"><?=$CUSTOMER_NAME1?></td>
<td nowrap align="center"><?=$KIND1?></td>
<td nowrap align="center"><?=$SELLMODE1?></td>
<td nowrap align="center"><?=$CONTACT_TYPE1?></td>
<td nowrap align="center"><?=$CONTACT_DATE1?></td>
<td align="left" width="150"><?=$CONTACT_CONTENT1?></td>
<td nowrap align="center"><?=$MONEY_COST1?></td>
<td nowrap align="center"><?=$TIME_COST1?>小时</td>
<td nowrap align="center"><?=$SELLER1?></td>
</tr>
<?
}
}
?>
</table>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onclick="location='index.php'">
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -