📄 index.php
字号:
$WHERE_STR.=" and a.ORDER_TYPE ='$ORDER_TYPE'";
}
if($ORDER_NO!="")
{
if($urlstr=="")$urlstr="ORDER_NO=".$ORDER_NO;
else $urlstr=$urlstr."&ORDER_NO=".$ORDER_NO;
if($WHERE_STR=="")
$WHERE_STR.=" where a.ORDER_NO like '%".$ORDER_NO."%'";
else
$WHERE_STR.=" and a.ORDER_NO like '%".$ORDER_NO."%'";
}
if($ORDER_NAME!="")
{
if($urlstr=="")$urlstr="ORDER_NAME=".$ORDER_NAME;
else $urlstr=$urlstr."&ORDER_NAME=".$ORDER_NAME;
if($WHERE_STR=="")
$WHERE_STR.=" where a.ORDER_NAME like '%".$ORDER_NAME."%'";
else
$WHERE_STR.=" and a.ORDER_NAME like '%".$ORDER_NAME."%'";
}
if($RECIVER!="")
{
if($urlstr=="")$urlstr="RECIVER=".$RECIVER;
else $urlstr=$urlstr."&RECIVER=".$RECIVER;
if($WHERE_STR=="")
$WHERE_STR.=" where a.RECIVER like '%".$RECIVER."%'";
else
$WHERE_STR.=" and a.RECIVER like '%".$RECIVER."%'";
}
if($DATE1!="")
{
if($urlstr=="")$urlstr="DATE1=".$DATE1;
else $urlstr=$urlstr."&DATE1=".$DATE1;
if($WHERE_STR=="")
{
$WHERE_STR.=" where a.".$DATE_TYPE."_DATE>='$DATE1'";
}
else
$WHERE_STR.=" and a.".$DATE_TYPE."_DATE>='$DATE1'";
}
if($DATE2!="")
{
if($urlstr=="")$urlstr="DATE2=".$DATE2;
else $urlstr=$urlstr."&DATE2=".$DATE2;
if($WHERE_STR=="")
$WHERE_STR.=" where a.".$DATE_TYPE."_DATE<='$DATE2'";
else
$WHERE_STR.=" and a.".$DATE_TYPE."_DATE<='$DATE2'";
}
if($CREATOR!="")
{
if($urlstr=="")$urlstr="CREATOR=".$CREATOR;
else $urlstr=$urlstr."&CREATOR=".$CREATOR;
if($WHERE_STR=="")
$WHERE_STR.=" where a.CREATOR like '%".$CREATOR."%'";
else
$WHERE_STR.=" and a.CREATOR like '%".$CREATOR."%'";
}
if($urlstr=="")$urlstr="DATE_TYPE=".$DATE_TYPE;
else $urlstr=$urlstr."&DATE_TYPE=".$DATE_TYPE;
if($ORDERFIELD!="")
{
if($ORDERSIGN=="DOWN")
{
$ORDERTYPE="ASC";
}
if($ORDERSIGN=="UP")
{
$ORDERTYPE="DESC";
}
$OREDERBY=" ORDER BY ".$ORDERFIELD." ".$ORDERTYPE;
}
if($OREDERBY=="") $OREDERBY=" ORDER BY CREATE_DATE DESC";
$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;
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))$CUSTOMER_COUNT=$ROW[0];
//echo $query;
$PER_PAGE=5;
$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,a.ORDER_PRINT
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".$OREDERBY;
$offest=($CUR_PAGE-1)*$PER_PAGE;
$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="index.php?CUR_PAGE=1&<?=$urlstr?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/first02.gif' width='24' border='0' height='15' alt='首页'></a>
<a href="index.php?CUR_PAGE=<?=$CUR_PAGE-1?>&<?=$urlstr?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/first01.gif' width='24' border='0' height='15' alt='上一页'></a>
<a href="index.php?CUR_PAGE=<?=$CUR_PAGE+1?>&<?=$urlstr?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/last01.gif' width='24' border='0' height='15' alt='下一页' style="cursor:hand"></a>
<a href="index.php?CUR_PAGE=<?=$PAGE_COUNT?>&<?=$urlstr?>&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">
<?
if($DELETE_FLAG==0 || find_id($MANAGERS,$LOGIN_USER_ID))
{
?>
<td nowrap align="center">选择</td>
<?
}
?>
<td nowrap align="center"><a href="index.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?>">订单编号 <? 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="index.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?>">订单名称 <? 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="index.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?>">订单类型 <? 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="index.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?>">供应商 <? 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="index.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?>">总价 <? 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="index.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?>">创建日期 <? 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="index.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?>">创建员 <? 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="index.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?>">负责人 <? 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"];
$ORDER_PRINT1=$ROW["ORDER_PRINT"];
if($PROVIDER_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>">
<?
if($DELETE_FLAG==0 || find_id($MANAGERS,$LOGIN_USER_ID))
{
?>
<td> <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?>&<?=$urlstr?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>">编辑</a>
<a href="javascript:delete_customer('<?=$ORDER_ID1?>','<?=$urlstr?>');">删除</a><br>
<a href="order_line?ORDER_ID=<?=$ORDER_ID1?>&<?=$urlstr?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>">订单明细</a><br>
<a href="order_history?ORDER_ID=<?=$ORDER_ID1?>&<?=$urlstr?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>">接货记录</a><br>
<a href="javascript:show_detail(<?=$ORDER_ID1?>);"> 详细信息 </a>
</td>
</tr>
<?
}
}
?>
<?
if($DELETE_FLAG==0 || find_id($MANAGERS,$LOGIN_USER_ID))
{
?>
<tr class="TableControl">
<td colspan="10">
<input type="checkbox" name="allbox" id="allbox_for" <? if($SIGN=="1") echo "disabled"; ?> onClick="check_all();">
<label for="allbox_for">全选</label>
<input type="button" value="批量删除" class="SmallButton" onClick="delete_mail('<?=$urlstr?>');" title="删除所选订单">
</td>
</tr>
<?
}
?>
</table>
</body>
</html>
<?
function GETALLDATE($CODE)
{
global $connection;
$query = "SELECT * from SYS_CODE where PARENT_NO='$CODE'";
$connection=OpenConnection();
$cursor= exequery($connection,$query);
echo "<option value= ".">".""."</option>";
while($ROW=mysql_fetch_array($cursor))
{
$CODE_NO=$ROW["CODE_NO"];
$CODE_NAME=$ROW["CODE_NAME"];
echo "<option value=".$CODE_NO.">".$CODE_NAME."</option>";
}
}
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -