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

📄 list.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％ 源码
💻 PHP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
  }
}
//----------------------------------------
   
$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 count(*)
        from SUPPLY_ORDER a
        LEFT OUTER JOIN SYS_CODE b ON a.ORDER_TYPE=b.CODE_NO AND b.PARENT_NO = 'ORDER_TYPE'
        LEFT OUTER JOIN PROVIDER d ON a.PROVIDER_ID = d.PROVIDER_ID
        LEFT OUTER JOIN SYS_CODE e ON d.PROVIDER_AREA= e.CODE_NO AND e.PARENT_NO = 'AREACODE'
        ".$WHERE_STR." group by a.ORDER_ID";
$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 a.ORDER_ID ,a.ORDER_NO,a.ORDER_NAME,b.CODE_NAME as ORDER_TYPE,d.PROVIDER_NAME as PROVIDER_NAME,a.CREATE_DATE,a.BEGIN_DATE,f.USER_NAME as CREATOR,g.USER_NAME as RECIVER,sum((h.TRANS_PRICE*h.TRANS_QTY)) as TOTALPRICE
        from SUPPLY_ORDER a
        LEFT OUTER JOIN SYS_CODE b ON a.ORDER_TYPE=b.CODE_NO AND b.PARENT_NO = 'ORDER_TYPE'
        LEFT OUTER JOIN PROVIDER d ON a.PROVIDER_ID = d.PROVIDER_ID
        LEFT OUTER JOIN SYS_CODE e ON d.PROVIDER_AREA= e.CODE_NO AND e.PARENT_NO = 'AREACODE'
        LEFT OUTER JOIN USER f ON a.CREATOR = f.USER_ID
        LEFT OUTER JOIN USER g ON a.RECIVER = g.USER_ID
        LEFT OUTER JOIN ORDER_LINE  h ON a.ORDER_ID = h.ORDER_ID
         ".$WHERE_STR." group by a.ORDER_ID".$HAVING.$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?>&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">
<?
	if($DELETE_FLAG==0 || find_id($MANAGERS,$LOGIN_USER_ID))
    {
?>     
  	 <td nowrap align="center">选择</td>
<?
	}
?>
  	 <td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=ORDER_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=="ORDER_NO"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="ORDER_NO"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=ORDER_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=="ORDER_NAME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="ORDER_NAME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=ORDER_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?>">订单类型&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="ORDER_TYPE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="ORDER_TYPE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=PROVIDER_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=="PROVIDER_NAME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="PROVIDER_NAME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=TOTALPRICE&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=="TOTALPRICE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="TOTALPRICE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=CREATE_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?>">创建日期&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="CREATE_DATE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="CREATE_DATE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=CREATOR&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=="CREATOR"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="CREATOR"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=RECIVER&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=="RECIVER"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="RECIVER"){?><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++;
    $ORDER_ID1=$ROW["ORDER_ID"];
    $ORDER_NO1=$ROW["ORDER_NO"];
    $ORDER_NAME1=$ROW["ORDER_NAME"];
    $ORDER_TYPE1=$ROW["ORDER_TYPE"];
    $PROVIDER_NAME1=$ROW["PROVIDER_NAME"];
    $TOTALPRICE1=$ROW["TOTALPRICE"];
    $PAYMENT=$ROW["PAYMENT"];
    $BEGIN_DATE1=$ROW["BEGIN_DATE"];
    $END_DATE1=$ROW["END_DATE"];
    $CREATE_DATE1=$ROW["CREATE_DATE"];
    $RECIVER1=$ROW["RECIVER"];
    $CREATOR1=$ROW["CREATOR"];
    if($CUSTOMER_COUNT%2==1)
       $TableLine="TableLine1";
    else
       $TableLine="TableLine2";

?>
    <tr class="<?=$TableLine?>">
<?
	if($DELETE_FLAG==0 || find_id($MANAGERS,$LOGIN_USER_ID))
    {
?>     
    	<td>&nbsp;<input type="checkbox" name="email_select" value="<?=$ORDER_ID1?>" <? if($SIGN=="1")  echo "disabled"; ?> onClick="check_one(self);"></td>
<?
	}
?>
       <td nowrap align="center"><?=$ORDER_NO1?></td>
       <td nowrap align="center"><?=$ORDER_NAME1?></td>
       <td nowrap align="center"><?=$ORDER_TYPE1?></td>
       <td nowrap align="center"><?=$PROVIDER_NAME1?></td>
       <td nowrap align="center"><?=$TOTALPRICE1?></td>
       <td nowrap align="center"><?=$CREATE_DATE1?></td>
       <td nowrap align="center"><?=$CREATOR1?></td>
       <td nowrap align="center"><?=$RECIVER1?></td>
       <td nowrap align="center">
	      <a href="../../new/?ORDER_ID=<?=$ORDER_ID1?>&querstr=<?=$urlstr1?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"> 编辑</a>&nbsp;&nbsp;&nbsp;
        <a href="javascript:delete_customer('<?=$ORDER_ID1?>','<?=$urlstr1?>');"> 删除 </a><br>
        <a href="../order_line?ORDER_ID=<?=$ORDER_ID1?>&querstr=<?=$urlstr1?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>">订 单 明 细</a><br>
        <a href="../order_history?ORDER_ID=<?=$ORDER_ID1?>&querstr=<?=$urlstr1?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>">接 货 记 录</a>
       </td>
    </tr>

<?
}
  }
?>
<?
	if($DELETE_FLAG==0 || find_id($MANAGERS,$LOGIN_USER_ID))
    {
?>     
<tr class="TableControl">
 <td colspan="11">
 	   &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>
12

⌨️ 快捷键说明

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