⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 list.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％ 源码
💻 PHP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
	  else
		 $WHERE_STR.=" and d.USERDEF1 like '%".$CUSTOMERUSERDEF1."%'";
    }
 if($CUSTOMERUSERDEF2!="")
	 {
	  if($urlstr=="")$urlstr="CUSTOMERUSERDEF2=".$CUSTOMERUSERDEF2;
    else $urlstr=$urlstr."&CUSTOMERUSERDEF2=".$CUSTOMERUSERDEF2;
	 	if($WHERE_STR=="")
		 $WHERE_STR.=" where d.USERDEF2 like '%".$CUSTOMERUSERDEF2."%'";
	 else
		 $WHERE_STR.=" and d.USERDEF2 like '%".$CUSTOMERUSERDEF2."%'";
    }
  if($CUSTOMERUSERDEF3!="")
	 {
	   if($urlstr=="")$urlstr="CUSTOMERUSERDEF3=".$CUSTOMERUSERDEF3;
     else $urlstr=$urlstr."&CUSTOMERUSERDEF3=".$CUSTOMERUSERDEF3;
	 	 if($WHERE_STR=="")
		 $WHERE_STR.=" where d.USERDEF3 like '%".$CUSTOMERUSERDEF3."%'";
	   else
		 $WHERE_STR.=" and d.USERDEF3 like '%".$CUSTOMERUSERDEF3."%'";
   }
	if($CUSTOMERUSERDEF4!="")
	 {
	 	 if($urlstr=="")$urlstr="CUSTOMERUSERDEF4=".$CUSTOMERUSERDEF4;
     else $urlstr=$urlstr."&CUSTOMERUSERDEF4=".$CUSTOMERUSERDEF4;
	 	if($WHERE_STR=="")
		 $WHERE_STR.=" where d.USERDEF4 like '%".$CUSTOMERUSERDEF4."%'";
	  else
		 $WHERE_STR.=" and d.USERDEF4 like '%".$CUSTOMERUSERDEF4."%'";
    }
 if($CUSTOMERUSERDEF5!="")
	{
		if($urlstr=="")$urlstr="CUSTOMERUSERDEF5=".$CUSTOMERUSERDEF5;
     else $urlstr=$urlstr."&CUSTOMERUSERDEF5=".$CUSTOMERUSERDEF5;
	 if($WHERE_STR=="")
		 $WHERE_STR.=" where d.USERDEF5 like '%".$CUSTOMERUSERDEF5."%'";
	 else
		 $WHERE_STR.=" and d.USERDEF5 like '%".$CUSTOMERUSERDEF5."%'";
  }

    
if($DATE1!="")
    {
    	if($urlstr=="")$urlstr="DATE1=".$DATE1;
       else $urlstr=$urlstr."&DATE1=".$DATE1;
    	$WHERE_STR.="  and a.ADD_TIME>='$DATE1 00:00:00'";
    }
if($DATE2!="")
    {
    	if($urlstr=="")$urlstr="DATE2=".$DATE2;
       else $urlstr=$urlstr."&DATE2=".$DATE2;
    	$WHERE_STR.="  and a.ADD_TIME<='$DATE2 23:59:59'";
    }

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_CANCEL a
        LEFT OUTER JOIN CUSTOMER d ON a.CUSTOMER_ID=d.CUSTOMER_ID
         LEFT OUTER JOIN WIREHOUSE c ON c.WH_ID=a.WH_ID
        LEFT OUTER JOIN USER e ON a.USER_ID=e.USER_ID
          LEFT OUTER JOIN USER f ON a.ADD_USER=f.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.WH_NAME,a.TOTAL_PRICE as TOTAL_PRICE,a.TOTAL_NUM as TOTAL_NUM,a.USER_ID as USER_ID,a.ADD_TIME as ADD_TIME,f.USER_NAME as ADD_USER,e.USER_NAME as USER_NAME,d.CUSTOMER_NAME as CUSTOMER_NAME,a.CANCEL_ID as CANCEL_ID,a.BANK_NO as BANK_NO
         from SALE_CANCEL a
         LEFT OUTER JOIN CUSTOMER d ON a.CUSTOMER_ID=d.CUSTOMER_ID
         LEFT OUTER JOIN WIREHOUSE c ON c.WH_ID=a.WH_ID
         LEFT OUTER JOIN USER e ON a.USER_ID=e.USER_ID
         LEFT OUTER JOIN USER f ON a.ADD_USER=f.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?>页&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"><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=USER_ID&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=="USER_ID"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="USER_ID"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=WH_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=="WH_NAME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="WH_NAME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=TOTAL_NUM&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=="TOTAL_NUM"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="TOTAL_NUM"){?><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?>">总金额&nbsp;<? 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=BANK_NO&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=="BANK_NO"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="BANK_NO"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=ADD_TIME&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=="ADD_TIME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="ADD_TIME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=ADD_USER&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=="ADD_USER"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="ADD_USER"){?><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++;
    $CANCEL_ID=$ROW["CANCEL_ID"];
    $CUSTOMER_NAME1=$ROW["CUSTOMER_NAME"];
    $USER_NAME1=$ROW["USER_NAME"];
	$WH_NAME1=$ROW["WH_NAME"];
	$TOTAL_NUM1=$ROW["TOTAL_NUM"];
	$TOTAL_PRICE1=$ROW["TOTAL_PRICE"];
    $BANK_NO1=$ROW["BANK_NO"];
	$ADD_TIME1=$ROW["ADD_TIME"];
	$ADD_USER1=$ROW["ADD_USER"];
    $CANCEL_ID1=$ROW["CANCEL_ID"];

    if($CUSTOMER_COUNT%2==1)
       $TableLine="TableLine1";
    else
       $TableLine="TableLine2";

?>
    <tr class="<?=$TableLine?>">
       <td nowrap align="center"><?=$CUSTOMER_NAME1?></td>
       <td nowrap align="center"><?=$USER_NAME1?></td>
       <td nowrap align="center"><?=$WH_NAME1?></td>
      <td nowrap align="center"><?=$TOTAL_NUM1?></td>
      <td nowrap align="center"><?=$TOTAL_PRICE1?></td>
      <td nowrap align="center"><?=$BANK_NO1?></td>
      <td nowrap align="center"><?=$ADD_TIME1?></td>
      <td nowrap align="center"><?=$ADD_USER1?></td>
      <td nowrap align="center">
      <a href="javascript:detail('<?=$CANCEL_ID?>');">退货明细</a>
</td>
    </tr>

<?
}
  }
?>
</table>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onclick="location='index.php'">
</div>


</body>
</html>
12

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -