📄 list.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
$PAGE_SIZE=10;
?>
<html>
<head>
<title>销售记录查询结果 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">
function set_page(urlstr)
{
PAGE_START=PAGE_NUM.value;
location="list.php?"+urlstr+"&CUR_PAGE="+PAGE_START+"&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>";
}
</script>
</head>
<?
//-----------先组织SQL语句-----------
$WHERE_STR.=" where a.CONTRACT_ID='-1' and a.LINE_ID='-1' ";
if($COPY_TO_ID!="")
{
if($urlstr=="")$urlstr="COPY_TO_ID=".$COPY_TO_ID;
else $urlstr=$urlstr."©_TO_ID=".$COPY_TO_ID;
$COPY_TO_ID="'".str_replace(",","','",substr($COPY_TO_ID,0,-1))."'";
$WHERE_STR.=" and a.SALESMAN in ($COPY_TO_ID)";
}
if($TO_ID!="")
{
if($urlstr=="")$urlstr="TO_ID=".$TO_ID;
else $urlstr=$urlstr."&TO_ID=".$TO_ID;
$TO_ID="'".str_replace(",","','",substr($TO_ID,0,-1))."'";
$WHERE_STR.=" and e.DEPT_ID in ($TO_ID)";
}
if($CUSTOMER_NAME!="")
{
if($urlstr=="")$urlstr="CUSTOMER_NAME=".$CUSTOMER_NAME;
else $urlstr=$urlstr."&CUSTOMER_NAME=".$CUSTOMER_NAME;
$WHERE_STR.=" and b.CUSTOMER_NAME like '%".$CUSTOMER_NAME."%'";
}
if($CUSTOMER_CODE!="")
{
if($urlstr=="")$urlstr="CUSTOMER_CODE=".$CUSTOMER_CODE;
else $urlstr=$urlstr."&CUSTOMER_CODE=".$CUSTOMER_CODE;
$WHERE_STR.=" and b.CUSTOMER_CODE like '%".$CUSTOMER_CODE."%'";
}
if($CUSTOMER_SHORT!="")
{
if($urlstr=="")$urlstr="CUSTOMER_SHORT=".$CUSTOMER_SHORT;
else $urlstr=$urlstr."&CUSTOMER_SHORT=".$CUSTOMER_SHORT;
$WHERE_STR.=" and b.CUSTOMER_SHORT like '%".$CUSTOMER_SHORT."%'";
}
if($CUSTOMER_AREA!="")
{
if($urlstr=="")$urlstr="CUSTOMER_AREA=".$CUSTOMER_AREA;
else $urlstr=$urlstr."&CUSTOMER_AREA=".$CUSTOMER_AREA;
$WHERE_STR.=" and b.CUSTOMER_AREA like '%".$CUSTOMER_AREA."%'";
}
if($CUSTOMER_ADD!="")
{
if($urlstr=="")$urlstr="CUSTOMER_ADD=".$CUSTOMER_ADD;
else $urlstr=$urlstr."&CUSTOMER_ADD=".$CUSTOMER_ADD;
$WHERE_STR.=" and b.CUSTOMER_ADD like '%".$CUSTOMER_ADD."%'";
}
if($SOURCE!="")
{
if($urlstr=="")$urlstr="SOURCE=".$SOURCE;
else $urlstr=$urlstr."&SOURCE=".$SOURCE;
$WHERE_STR.=" and b.SOURCE ='$SOURCE'";
}
if($KIND!="")
{
if($urlstr=="")$urlstr="KIND=".$KIND;
else $urlstr=$urlstr."&KIND=".$KIND;
$WHERE_STR.=" and b.KIND ='$KIND'";
}
if($SELLMODE!="")
{
if($urlstr=="")$urlstr="SELLMODE=".$SELLMODE;
else $urlstr=$urlstr."&SELLMODE=".$SELLMODE;
$WHERE_STR.=" and b.SELLMODE ='$SELLMODE'";
}
if($ATTRIBUTE!="")
{
if($urlstr=="")$urlstr="ATTRIBUTE=".$ATTRIBUTE;
else $urlstr=$urlstr."&ATTRIBUTE=".$ATTRIBUTE;
$WHERE_STR.=" and b.ATTRIBUTE ='$ATTRIBUTE'";
}
if($ENTERTYPE!="")
{
if($urlstr=="")$urlstr="ENTERTYPE=".$ENTERTYPE;
else $urlstr=$urlstr."&ENTERTYPE=".$ENTERTYPE;
$WHERE_STR.=" and b.ENTERTYPE ='$ENTERTYPE'";
}
if($ENTERMEMO!="")
{
if($urlstr=="")$urlstr="ENTERMEMO=".$ENTERMEMO;
else $urlstr=$urlstr."&ENTERMEMO=".$ENTERMEMO;
$WHERE_STR.=" and b.ENTERMEMO like '%".$ENTERMEMO."%'";
}
if($CUSTOMERUSERDEF1!="")
{
if($urlstr=="")$urlstr="CUSTOMERUSERDEF1=".$CUSTOMERUSERDEF1;
else $urlstr=$urlstr."&CUSTOMERUSERDEF1=".$CUSTOMERUSERDEF1;
$WHERE_STR.=" and b.USERDEF1 like '%".$CUSTOMERUSERDEF1."%'";
}
if($CUSTOMERUSERDEF2!="")
{
if($urlstr=="")$urlstr="CUSTOMERUSERDEF2=".$CUSTOMERUSERDEF2;
else $urlstr=$urlstr."&CUSTOMERUSERDEF2=".$CUSTOMERUSERDEF2;
$WHERE_STR.=" and b.USERDEF2 like '%".$CUSTOMERUSERDEF2."%'";
}
if($CUSTOMERUSERDEF3!="")
{
if($urlstr=="")$urlstr="CUSTOMERUSERDEF3=".$CUSTOMERUSERDEF3;
else $urlstr=$urlstr."&CUSTOMERUSERDEF3=".$CUSTOMERUSERDEF3;
$WHERE_STR.=" and b.USERDEF3 like '%".$CUSTOMERUSERDEF3."%'";
}
if($CUSTOMERUSERDEF4!="")
{
if($urlstr=="")$urlstr="CUSTOMERUSERDEF4=".$CUSTOMERUSERDEF4;
else $urlstr=$urlstr."&CUSTOMERUSERDEF4=".$CUSTOMERUSERDEF4;
$WHERE_STR.=" and b.USERDEF4 like '%".$CUSTOMERUSERDEF4."%'";
}
if($CUSTOMERUSERDEF5!="")
{
if($urlstr=="")$urlstr="CUSTOMERUSERDEF5=".$CUSTOMERUSERDEF5;
else $urlstr=$urlstr."&CUSTOMERUSERDEF5=".$CUSTOMERUSERDEF5;
$WHERE_STR.=" and b.USERDEF5 like '%".$CUSTOMERUSERDEF5."%'";
}
if($PRODUCT_NAME!="")
{
if($urlstr=="")$urlstr="PRODUCT_NAME=".$PRODUCT_NAME;
else $urlstr=$urlstr."&PRODUCT_NAME=".$PRODUCT_NAME;
$WHERE_STR.=" and c.PRODUCT_NAME like '%".$PRODUCT_NAME."%'";
}
if($PRODUCT_MODE!="")
{
if($urlstr=="")$urlstr="PRODUCT_MODE=".$PRODUCT_MODE;
else $urlstr=$urlstr."&PRODUCT_MODE=".$PRODUCT_MODE;
$WHERE_STR.=" and c.PRODUCT_MODE ='$PRODUCT_MODE'";
}
if($PRODUCT_TYPE!="")
{
if($urlstr=="")$urlstr="PRODUCT_TYPE=".$PRODUCT_TYPE;
else $urlstr=$urlstr."&PRODUCT_TYPE=".$PRODUCT_TYPE;
$WHERE_STR.=" and c.PRODUCT_TYPE like '%".$PRODUCT_TYPE."%'";
}
if($SERVICE_NAME!="")
{
if($urlstr=="")$urlstr="SERVICE_NAME=".$SERVICE_NAME;
else $urlstr=$urlstr."&SERVICE_NAME=".$SERVICE_NAME;
$WHERE_STR.=" and d.SERVICE_NAME like '%".$SERVICE_NAME."%'";
}
if($SERVICE_DESC!="")
{
if($urlstr=="")$urlstr="SERVICE_DESC=".$SERVICE_DESC;
else $urlstr=$urlstr."&SERVICE_DESC=".$SERVICE_DESC;
$WHERE_STR.=" and d.SERVICE_DESC like '%".$SERVICE_DESC."%'";
}
if($DATE1!="")
{
if($urlstr=="")$urlstr="DATE1=".$DATE1;
else $urlstr=$urlstr."&DATE1=".$DATE1;
$WHERE_STR.=" and a.DATE>='$DATE1'";
}
if($DATE2!="")
{
if($urlstr=="")$urlstr="DATE2=".$DATE2;
else $urlstr=$urlstr."&DATE2=".$DATE2;
$WHERE_STR.=" and a.DATE<='$DATE2'";
}
if($ORDERFIELD!="")
{
if($ORDERSIGN=="DOWN")
{
$ORDERTYPE="ASC";
}
if($ORDERSIGN=="UP")
{
$ORDERTYPE="DESC";
}
$OREDERBY=" ORDER BY ".$ORDERFIELD." ".$ORDERTYPE;
}
$CUSTOMER_COUNT=0;
$query="SELECT count(*) from SALE_HISTORY a
LEFT OUTER JOIN CUSTOMER b ON a.CUSTOMER_ID=b.CUSTOMER_ID
LEFT OUTER JOIN PRODUCT c ON a.PRODUCT_ID=c.PRODUCT_ID and a.TYPE='PRO'
LEFT OUTER JOIN SERVICE d ON a.SERVICE_ID=d.SERVICE_ID and a.TYPE='SER'
LEFT OUTER JOIN USER e ON a.SALESMAN=e.USER_ID
".$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 c.PRODUCT_NAME as PRODUCT_NAME,d.SERVICE_NAME as SERVICE_NAME,a.PRICE as PRICE,a.AMT as AMT,a.TOTAL_PRICE as TOTAL_PRICE,a.DATE as DATE,e.USER_NAME as SELLER,b.CUSTOMER_NAME as CUSTOMER_NAME,a.HISTORY_ID as HISTORY_ID,a.TYPE as TYPE
from SALE_HISTORY a
LEFT OUTER JOIN CUSTOMER b ON a.CUSTOMER_ID=b.CUSTOMER_ID
LEFT OUTER JOIN PRODUCT c ON a.PRODUCT_ID=c.PRODUCT_ID and a.TYPE='PRO'
LEFT OUTER JOIN SERVICE d ON a.SERVICE_ID=d.SERVICE_ID and a.TYPE='SER'
LEFT OUTER JOIN USER e ON a.SALESMAN=e.USER_ID
".$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=PRODUCT_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=="PRODUCT_NAME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="PRODUCT_NAME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=SERVICE_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=="SERVICE_NAME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="SERVICE_NAME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=PRICE&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=="PRICE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="PRICE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=AMT&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=="AMT"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="AMT"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=TOTAL_PRICE&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=="TOTAL_PRICE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="TOTAL_PRICE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=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=="DATE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="DATE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></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?>">客户名称 <? 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=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++;
$PRODUCT_NAME1=$ROW["PRODUCT_NAME"];
$SERVICE_NAME1=$ROW["SERVICE_NAME"];
$PRICE1=$ROW["PRICE"];
$AMT1=$ROW["AMT"];
$TOTAL_PRICE1=$ROW["TOTAL_PRICE"];
$CREAT_DATE=$ROW["DATE"];
$SELLER1=$ROW["SELLER"];
$CUSTOMER_NAME1=$ROW["CUSTOMER_NAME"];
$TYPE1=$ROW["TYPE"];
$HISTORY_ID1=$ROW["HISTORY_ID"];
if($CUSTOMER_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>">
<td nowrap align="center"><?=$PRODUCT_NAME1?></td>
<td nowrap align="center"><?=$SERVICE_NAME1?></td>
<td nowrap align="center"><?=$PRICE1?></td>
<td nowrap align="center"><?=$AMT1?></td>
<td nowrap align="center"><?=$TOTAL_PRICE1?></td>
<td nowrap align="center"><?=$CREAT_DATE?></td>
<td nowrap align="center"><?=$CUSTOMER_NAME1?></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 + -