📄 list.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％源码
💻 PHP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<?
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?>";
}

function detail(CANCEL_ID)
{
 URL="item/?CANCEL_ID="+CANCEL_ID;
 myleft=(screen.availWidth-500)/2;
 window.open(URL,"read_notify","height=300,width=500,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}

</script>
</head>

<?
//-----------先组织SQL语句-----------
$WHERE_STR.=" where 1=1 ";

if($COPY_TO_ID!="")
   {
   	if($urlstr=="")$urlstr="COPY_TO_ID=".$COPY_TO_ID;
    else $urlstr=$urlstr."&COPY_TO_ID=".$COPY_TO_ID;
   	$COPY_TO_ID="'".str_replace(",","','",substr($COPY_TO_ID,0,-1))."'";
    $WHERE_STR.=" and a.USER_ID in ($COPY_TO_ID)";
   }
if($WH_ID!="")
   {
   	if($urlstr=="")$urlstr="WH_ID=".$WH_ID;
    else $urlstr=$urlstr."&WH_ID=".$WH_ID;
    $WHERE_STR.=" and a.WH_ID='".$WH_ID."'";
   }
if($BANK_NO!="")
   {
   	if($urlstr=="")$urlstr="BANK_NO=".$BANK_NO;
    else $urlstr=$urlstr."&BANK_NO=".$BANK_NO;
    $WHERE_STR.=" and a.BANK_NO='".$BANK_NO."'";
   }
    
if($TOTAL_NUM1!="")
    {
    	if($urlstr=="")$urlstr="TOTAL_NUM1=".$TOTAL_NUM1;
       else $urlstr=$urlstr."&TOTAL_NUM1=".$TOTAL_NUM1;
    	$WHERE_STR.="  and a.TOTAL_NUM>='$TOTAL_NUM1'";
    }
if($TOTAL_NUM2!="")
    {
    	if($urlstr=="")$urlstr="TOTAL_NUM2=".$TOTAL_NUM2;
       else $urlstr=$urlstr."&TOTAL_NUM2=".$TOTAL_NUM2;
    	$WHERE_STR.="  and a.TOTAL_NUM<='$TOTAL_NUM2'";
    }
    
if($TOTAL_PRICE1!="")
    {
    	if($urlstr=="")$urlstr="TOTAL_PRICE1=".$TOTAL_PRICE1;
       else $urlstr=$urlstr."&TOTAL_PRICE1=".$TOTAL_PRICE1;
    	$WHERE_STR.="  and a.TOTAL_PRICE>='$TOTAL_PRICE1'";
    }
if($TOTAL_PRICE2!="")
    {
    	if($urlstr=="")$urlstr="TOTAL_PRICE2=".$TOTAL_PRICE2;
       else $urlstr=$urlstr."&TOTAL_PRICE2=".$TOTAL_PRICE2;
    	$WHERE_STR.="  and a.TOTAL_PRICE<='$TOTAL_PRICE2'";
    }
if($CUSTOMER_NAME!="")
 {
     if($urlstr=="")$urlstr="CUSTOMER_NAME=".$CUSTOMER_NAME;
     else $urlstr=$urlstr."&CUSTOMER_NAME=".$CUSTOMER_NAME;
     if($WHERE_STR=="")
         $WHERE_STR.=" where d.CUSTOMER_NAME like '%".$CUSTOMER_NAME."%'";
     else
         $WHERE_STR.=" and d.CUSTOMER_NAME like '%".$CUSTOMER_NAME."%'";
 }
if($CUSTOMER_CODE!="")
   {
     if($urlstr=="")$urlstr="CUSTOMER_CODE=".$CUSTOMER_CODE;
     else $urlstr=$urlstr."&CUSTOMER_CODE=".$CUSTOMER_CODE;
     if($WHERE_STR=="")
         $WHERE_STR.=" where d.CUSTOMER_CODE like '%".$CUSTOMER_CODE."%'";
     else
         $WHERE_STR.=" and d.CUSTOMER_CODE like '%".$CUSTOMER_CODE."%'";
   }

if($CUSTOMER_SHORT!="")
   {
   	 if($urlstr=="")$urlstr="CUSTOMER_SHORT=".$CUSTOMER_SHORT;
     else $urlstr=$urlstr."&CUSTOMER_SHORT=".$CUSTOMER_SHORT;
     if($WHERE_STR=="")
         $WHERE_STR.=" where d.CUSTOMER_SHORT like '%".$CUSTOMER_SHORT."%'";
     else
         $WHERE_STR.=" and d.CUSTOMER_SHORT like '%".$CUSTOMER_SHORT."%'";
   }

if($CUSTOMER_AREA!="")
   {
    	if($urlstr=="")$urlstr="CUSTOMER_AREA=".$CUSTOMER_AREA;
     else $urlstr=$urlstr."&CUSTOMER_AREA=".$CUSTOMER_AREA;
     if($WHERE_STR=="")
         $WHERE_STR.=" where d.CUSTOMER_AREA='$CUSTOMER_AREA'";
     else
         $WHERE_STR.=" and d.CUSTOMER_AREA='$CUSTOMER_AREA'";
   }

if($CUSTOMER_ADD!="")
   {
   	 if($urlstr=="")$urlstr="CUSTOMER_ADD=".$CUSTOMER_AREA;
     else $urlstr=$urlstr."&CUSTOMER_ADD=".$CUSTOMER_AREA;
     if($WHERE_STR=="")
         $WHERE_STR.=" where d.CUSTOMER_ADD like '%".$CUSTOMER_ADD."%'";
     else
         $WHERE_STR.=" and d.CUSTOMER_ADD like '%".$CUSTOMER_ADD."%'";
   }

if($SOURCE!="")
   {
   	 if($urlstr=="")$urlstr="SOURCE=".$SOURCE;
     else $urlstr=$urlstr."&SOURCE=".$SOURCE;
     if($WHERE_STR=="")
         $WHERE_STR.=" where d.SOURCE ='$SOURCE'";
     else
         $WHERE_STR.=" and d.SOURCE ='$SOURCE'";
   }
if($KIND!="")
   {
   	 if($urlstr=="")$urlstr="KIND=".$KIND;
     else $urlstr=$urlstr."&KIND=".$KIND;
     if($WHERE_STR=="")
         $WHERE_STR.=" where d.KIND ='$KIND'";
     else
         $WHERE_STR.=" and d.KIND ='$KIND'";
   }
if($SELLMODE!="")
   {
   	 if($urlstr=="")$urlstr="SELLMODE=".$SELLMODE;
     else $urlstr=$urlstr."&SELLMODE=".$SELLMODE;
     if($WHERE_STR=="")
         $WHERE_STR.=" where d.SELLMODE ='$SELLMODE'";
     else
         $WHERE_STR.=" and d.SELLMODE ='$SELLMODE'";
   }
if($ATTRIBUTE!="")
   {
   	 if($urlstr=="")$urlstr="ATTRIBUTE=".$ATTRIBUTE;
     else $urlstr=$urlstr."&ATTRIBUTE=".$SELLMODE;
     if($WHERE_STR=="")
         $WHERE_STR.=" where d.ATTRIBUTE ='$ATTRIBUTE'";
     else
         $WHERE_STR.=" and d.ATTRIBUTE ='$ATTRIBUTE'";
   }
if($ENTERTYPE!="")
   {
   	 if($urlstr=="")$urlstr="ENTERTYPE=".$ENTERTYPE;
     else $urlstr=$urlstr."&ENTERTYPE=".$ENTERTYPE;
     if($WHERE_STR=="")
         $WHERE_STR.=" where d.ENTERTYPE ='$ENTERTYPE'";
     else
         $WHERE_STR.=" and d.ENTERTYPE ='$ENTERTYPE'";
   }
if($ENTERMEMO!="")
   {
   	 if($urlstr=="")$urlstr="ENTERMEMO=".$ENTERMEMO;
     else $urlstr=$urlstr."&ENTERMEMO=".$ENTERMEMO;
     if($WHERE_STR=="")
         $WHERE_STR.=" where d.ENTERMEMO like '%".$ENTERMEMO."%'";
     else
         $WHERE_STR.=" and d.ENTERMEMO like '%".$ENTERMEMO."%'";
   }

if($CUSTOMERUSERDEF1!="")
	 {
	 	if($urlstr=="")$urlstr="CUSTOMERUSERDEF1=".$CUSTOMERUSERDEF1;
    else $urlstr=$urlstr."&CUSTOMERUSERDEF1=".$CUSTOMERUSERDEF1;
	 	if($WHERE_STR=="")
		 $WHERE_STR.=" where d.USERDEF1 like '%".$CUSTOMERUSERDEF1."%'";
12 下一页
⌨️ 快捷键说明

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