📄 list.php
字号:
<?
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 show_detail(CONTRACT_ID)
{
URL="linelist.php?CONTRACT_ID="+CONTRACT_ID;
myleft=(screen.availWidth-650)/2;
window.open(URL,"formul_edit","height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
function show_detail1(CONTRACT_ID)
{
URL="historylist.php?CONTRACT_ID="+CONTRACT_ID;
myleft=(screen.availWidth-650)/2;
window.open(URL,"formul_edit","height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
function show_detail2(CONTRACT_ID)
{
URL="contractlist.php?CONTRACT_ID="+CONTRACT_ID;
myleft=(screen.availWidth-650)/2;
window.open(URL,"formul_edit","height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
</script>
</head>
<?
//-----------先组织SQL语句-----------
if($COPY_TO_ID!="")
{
if($urlstr=="")$urlstr="COPY_TO_ID=".$COPY_TO_ID;
else $urlstr=$urlstr."©_TO_ID=".$COPY_TO_ID;
$COPY_TO_ID="'".str_replace(",","','",substr($COPY_TO_ID,0,-1))."'";
if($WHERE_STR=="")
$WHERE_STR.=" where a.".$SELLER_TYPE." in ($COPY_TO_ID)";
else
$WHERE_STR.=" and a.".$SELLER_TYPE." in ($COPY_TO_ID)";
}
if($TO_ID!="")
{
if($urlstr=="")$urlstr="TO_ID=".$TO_ID;
else $urlstr=$urlstr."&TO_ID=".$TO_ID;
$TO_ID="'".str_replace(",","','",substr($TO_ID,0,-1))."'";
if($WHERE_STR=="")
$WHERE_STR.=" where g.DEPT_ID in ($TO_ID)";
else
$WHERE_STR.=" and g.DEPT_ID in ($TO_ID)";
}
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."%'";
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($CONTRACT_TYPE!="")
{
if($urlstr=="")$urlstr="CONTRACT_TYPE=".$CONTRACT_TYPE;
else $urlstr=$urlstr."&CONTRACT_TYPE=".$CONTRACT_TYPE;
if($WHERE_STR=="")
$WHERE_STR.=" where a.CONTRACT_TYPE ='$CONTRACT_TYPE'";
else
$WHERE_STR.=" and a.CONTRACT_TYPE ='$CONTRACT_TYPE'";
}
if($CONTRACT_NO!="")
{
if($urlstr=="")$urlstr="CONTRACT_NO=".$CONTRACT_NO;
else $urlstr=$urlstr."&CONTRACT_NO=".$CONTRACT_NO;
if($WHERE_STR=="")
$WHERE_STR.=" where a.CONTRACT_NO like '%".$CONTRACT_NO."%'";
else
$WHERE_STR.=" and a.CONTRACT_NO like '%".$CONTRACT_NO."%'";
}
if($CONTRACT_NAME!="")
{
if($urlstr=="")$urlstr="CONTRACT_NAME=".$CONTRACT_NAME;
else $urlstr=$urlstr."&CONTRACT_NAME=".$CONTRACT_NAME;
if($WHERE_STR=="")
$WHERE_STR.=" where a.CONTRACT_NAME like '%".$CONTRACT_NAME."%'";
else
$WHERE_STR.=" and a.CONTRACT_NAME like '%".$CONTRACT_NAME."%'";
}
if($CONTRACT_LINKMAN1!="")
{
if($urlstr=="")$urlstr="CONTRACT_LINKMAN1=".$CONTRACT_LINKMAN1;
else $urlstr=$urlstr."&CONTRACT_LINKMAN1=".$CONTRACT_LINKMAN1;
if($WHERE_STR=="")
$WHERE_STR.=" where a.CONTRACT_LINKMAN1 like '%".$CONTRACT_LINKMAN1."%'";
else
$WHERE_STR.=" and a.CONTRACT_LINKMAN1 like '%".$CONTRACT_LINKMAN1."%'";
}
if($CONTRACT_LINKMANNAME2!="")
{
if($urlstr=="")$urlstr="CONTRACT_LINKMANNAME2=".$CONTRACT_LINKMANNAME2;
else $urlstr=$urlstr."&CONTRACT_LINKMANNAME2=".$CONTRACT_LINKMANNAME2;
if($WHERE_STR=="")
$WHERE_STR.=" where h.USER_NAME like '%".$CONTRACT_LINKMANNAME2."%'";
else
$WHERE_STR.=" and h.USER_NAME like '%".$CONTRACT_LINKMANNAME2."%'";
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -