📄 list.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
$PAGE_SIZE=10;
$query = "select * from SALE_MANAGER where MANAGER_ID=1";
$cursor=exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$MANAGER_ID=$ROW["MANAGER_ID"];
$MANAGERS=$ROW["MANAGERS"];
$DELETE_FLAG=$ROW["DELETE_FLAG"];
}
?>
<html>
<head>
<title>订单查询结果</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">
function delete_customer(ORDER_ID,querstr)
{
msg='确认要删除该订单？';
if(window.confirm(msg))
{
URL="../delete.php?querstr="+querstr+"&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&ORDER_ID=" + ORDER_ID;
window.location=URL;
}
}
function set_page(urlstr)
{
PAGE_START=PAGE_NUM.value;
location="list.php?"+urlstr+"&CUR_PAGE="+PAGE_START+"&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>";
}
function check_one(el)
{
if(!el.checked)
document.all("allbox").checked=false;
}
function check_all()
{
for (i=0;i<document.all("email_select").length;i++)
{
if(document.all("allbox").checked)
document.all("email_select").item(i).checked=true;
else
document.all("email_select").item(i).checked=false;
}
if(i==0)
{
if(document.all("allbox").checked)
document.all("email_select").checked=true;
else
document.all("email_select").checked=false;
}
}
</script>
</head>
<?
//-----------先组织SQL语句-----------
$urlstr="DATE_TYPE=".$DATE_TYPE;
if($PROVIDER_NAME!="")
{
$urlstr=$urlstr."&PROVIDER_NAME=".$PROVIDER_NAME;
if($WHERE_STR=="")
$WHERE_STR.=" where d.PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
else
$WHERE_STR.=" and d.PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
}
if($PROVIDER_CODE!="")
{
$urlstr=$urlstr."&PROVIDER_CODE=".$PROVIDER_CODE;
if($WHERE_STR=="")
$WHERE_STR.=" where d.PROVIDER_CODE like '%".$PROVIDER_CODE."%'";
else
$WHERE_STR.=" and d.PROVIDER_CODE like '%".$PROVIDER_CODE."%'";
}
if($PROVIDER_SHORT!="")
{
$urlstr=$urlstr."&PROVIDER_SHORT=".$PROVIDER_SHORT;
if($WHERE_STR=="")
$WHERE_STR.=" where d.PROVIDER_SHORT like '%".$PROVIDER_SHORT."%'";
else
$WHERE_STR.=" and d.PROVIDER_SHORT like '%".$PROVIDER_SHORT."%'";
}
if($PROVIDER_AREA!="")
{
$urlstr=$urlstr."&PROVIDER_AREA=".$PROVIDER_AREA;
if($WHERE_STR=="")
$WHERE_STR.=" where d.PROVIDER_AREA='$PROVIDER_AREA'";
else
$WHERE_STR.=" and d.PROVIDER_AREA='$PROVIDER_AREA'";
}
if($PROVIDER_ADD!="")
{
$urlstr=$urlstr."&PROVIDER_ADD=".$PROVIDER_AREA;
if($WHERE_STR=="")
$WHERE_STR.=" where d.PROVIDER_ADD like '%".$PROVIDER_ADD."%'";
else
$WHERE_STR.=" and d.PROVIDER_ADD like '%".$PROVIDER_ADD."%'";
}
if($ORDER_TYPE!="")
{
$urlstr=$urlstr."&ORDER_TYPE=".$ORDER_TYPE;
if($WHERE_STR=="")
$WHERE_STR.=" where a.ORDER_TYPE ='$ORDER_TYPE'";
else
$WHERE_STR.=" and a.ORDER_TYPE ='$ORDER_TYPE'";
}
if($ORDER_NO!="")
{
$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!="")
{
$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($ORDER_MEMO!="")
{
$urlstr=$urlstr."&ORDER_MEMO=".$ORDER_MEMO;
if($WHERE_STR=="")
$WHERE_STR.=" where a.ORDER_MEMO like '%".$ORDER_MEMO."%'";
else
$WHERE_STR.=" and a.ORDER_MEMO like '%".$ORDER_MEMO."%'";
}
if($REMARK!="")
{
$urlstr=$urlstr."&REMARK=".$REMARK;
if($WHERE_STR=="")
$WHERE_STR.=" where a.REMARK like '%".$REMARK."%'";
else
$WHERE_STR.=" and a.REMARK like '%".$REMARK."%'";
}
if($LDATE1!="")
{
$urlstr=$urlstr."&LDATE1=".$LDATE1;
if($WHERE_STR=="")
$WHERE_STR.=" where a.".$DATE_TYPE."_DATE>='$LDATE1'";
else
$WHERE_STR.=" and a.".$DATE_TYPE."_DATE>='$LDATE1'";
}
if($LDATE2!="")
{
$urlstr=$urlstr."&LDATE2=".$LDATE2;
if($WHERE_STR=="")
$WHERE_STR.=" where a.".$DATE_TYPE."_DATE<='$LDATE2'";
else
$WHERE_STR.=" and a.".$DATE_TYPE."_DATE<='$LDATE2'";
}
//------------自定义字段查找---------------
$query = "SELECT FIELDNO from FIELDSETTING where TABLENAME='SUPPLY_ORDER'";
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$FIELDNO="SUPPLY_ORDER".$ROW["FIELDNO"];
if($$FIELDNO!="")
{
$CUSTOMERID_STR="";
$urlstr=$urlstr."&".$FIELDNO."=".$$FIELDNO;
$WHERE_STR1=" where TABLENAME='SUPPLY_ORDER' and (FIELDNO='".$ROW["FIELDNO"]."' and ITEM_DATE like '%".$$FIELDNO."%')";
$query1="SELECT IDENTY_ID FROM `FIELD_DATE`".$WHERE_STR1;
$cursor1= exequery($connection,$query1);
while($ROW1=mysql_fetch_array($cursor1))
{
$CUSTOMERID_STR=$CUSTOMERID_STR.$ROW1["IDENTY_ID"].",";
}
$CUSTOMERID_STR="'".str_replace(",","','",substr($CUSTOMERID_STR,0,-1))."'";
if($WHERE_STR=="")
$WHERE_STR.=" where a.ORDER_ID in ($CUSTOMERID_STR)";
else
$WHERE_STR.=" and a.ORDER_ID in ($CUSTOMERID_STR)";
}
}
$query = "SELECT FIELDNO from FIELDSETTING where TABLENAME='PROVIDER'";
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$FIELDNO="PROVIDER".$ROW["FIELDNO"];
if($$FIELDNO!="")
{
$CONTACTID_STR="";
$urlstr=$urlstr."&".$FIELDNO."=".$$FIELDNO;
$WHERE_STR1=" where TABLENAME='PROVIDER' and (FIELDNO='".$ROW["FIELDNO"]."' and ITEM_DATE like '%".$$FIELDNO."%')";
$query1="SELECT IDENTY_ID FROM `FIELD_DATE`".$WHERE_STR1;
$cursor1= exequery($connection,$query1);
while($ROW1=mysql_fetch_array($cursor1))
{
$CONTACTID_STR=$CONTACTID_STR.$ROW1["IDENTY_ID"].",";
}
$CONTACTID_STR="'".str_replace(",","','",substr($CONTACTID_STR,0,-1))."'";
if($WHERE_STR=="")
$WHERE_STR.=" where d.PROVIDER_ID in ($CONTACTID_STR)";
else
$WHERE_STR.=" and d.PROVIDER_ID in ($CONTACTID_STR)";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -