📄 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(CONTRACT_ID,querstr)
{
msg='确认要删除该合同？';
if(window.confirm(msg))
{
URL="../delete.php?querstr="+querstr+"&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CONTRACT_ID=" + CONTRACT_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;
$WHERE_STR.=" where (a.SELLER ='$LOGIN_USER_ID' or a.CONTRACT_LINKMAN2='$LOGIN_USER_ID')";
if($CUSTOMER_NAME!="")
{
$urlstr=$urlstr."&CUSTOMER_NAME=".$CUSTOMER_NAME;
$WHERE_STR.=" and d.CUSTOMER_NAME like '%".$CUSTOMER_NAME."%'";
}
if($CUSTOMER_CODE!="")
{
$urlstr=$urlstr."&CUSTOMER_CODE=".$CUSTOMER_CODE;
$WHERE_STR.=" and d.CUSTOMER_CODE like '%".$CUSTOMER_CODE."%'";
}
if($CUSTOMER_SHORT!="")
{
$urlstr=$urlstr."&CUSTOMER_SHORT=".$CUSTOMER_SHORT;
$WHERE_STR.=" and d.CUSTOMER_SHORT like '%".$CUSTOMER_SHORT."%'";
}
if($CUSTOMER_AREA!="")
{
$urlstr=$urlstr."&CUSTOMER_AREA=".$CUSTOMER_AREA;
$WHERE_STR.=" and d.CUSTOMER_AREA='$CUSTOMER_AREA'";
}
if($CUSTOMER_ADD!="")
{
$urlstr=$urlstr."&CUSTOMER_ADD=".$CUSTOMER_AREA;
$WHERE_STR.=" and d.CUSTOMER_ADD like '%".$CUSTOMER_ADD."%'";
}
if($SOURCE!="")
{
$urlstr=$urlstr."&SOURCE=".$SOURCE;
$WHERE_STR.=" and d.SOURCE ='$SOURCE'";
}
if($KIND!="")
{
$urlstr=$urlstr."&KIND=".$KIND;
$WHERE_STR.=" and d.KIND ='$KIND'";
}
if($SELLMODE!="")
{
$urlstr=$urlstr."&SELLMODE=".$SELLMODE;
$WHERE_STR.=" and d.SELLMODE ='$SELLMODE'";
}
if($ATTRIBUTE!="")
{
$urlstr=$urlstr."&ATTRIBUTE=".$SELLMODE;
$WHERE_STR.=" and d.ATTRIBUTE ='$ATTRIBUTE'";
}
if($ENTERTYPE!="")
{
$urlstr=$urlstr."&ENTERTYPE=".$ENTERTYPE;
$WHERE_STR.=" and d.ENTERTYPE ='$ENTERTYPE'";
}
if($ENTERMEMO!="")
{
$urlstr=$urlstr."&ENTERMEMO=".$ENTERMEMO;
$WHERE_STR.=" and d.ENTERMEMO like '%".$ENTERMEMO."%'";
}
if($CONTRACT_TYPE!="")
{
$urlstr=$urlstr."&CONTRACT_TYPE=".$CONTRACT_TYPE;
$WHERE_STR.=" and a.CONTRACT_TYPE ='$CONTRACT_TYPE'";
}
if($CONTRACT_NO!="")
{
$urlstr=$urlstr."&CONTRACT_NO=".$CONTRACT_NO;
$WHERE_STR.=" and a.CONTRACT_NO like '%".$CONTRACT_NO."%'";
}
if($CONTRACT_NAME!="")
{
$urlstr=$urlstr."&CONTRACT_NAME=".$CONTRACT_NAME;
$WHERE_STR.=" and a.CONTRACT_NAME like '%".$CONTRACT_NAME."%'";
}
if($CONTRACT_LINKMAN1!="")
{
$urlstr=$urlstr."&CONTRACT_LINKMAN1=".$CONTRACT_LINKMAN1;
$WHERE_STR.=" and a.CONTRACT_LINKMAN1 like '%".$CONTRACT_LINKMAN1."%'";
}
if($CONTRACT_LINKMANNAME2!="")
{
$urlstr=$urlstr."&CONTRACT_LINKMANNAME2=".$CONTRACT_LINKMANNAME2;
$WHERE_STR.=" and h.USER_NAME like '%".$CONTRACT_LINKMANNAME2."%'";
}
if($SELLER_NAME!="")
{
$urlstr=$urlstr."&SELLER_NAME=".$SELLER_NAME;
$WHERE_STR.=" and g.USER_NAME like '%".$SELLER_NAME."%'";
}
if($CONTRACT_MEMO!="")
{
$urlstr=$urlstr."&CONTRACT_MEMO=".$CONTRACT_MEMO;
$WHERE_STR.=" and a.CONTRACT_MEMO like '%".$CONTRACT_MEMO."%'";
}
if($CONTRACT_ARTICLE!="")
{
$urlstr=$urlstr."&CONTRACT_ARTICLE=".$CONTRACT_ARTICLE;
$WHERE_STR.=" and a.CONTRACT_ARTICLE like '%".$CONTRACT_ARTICLE."%'";
}
if($CONTRACT_CONTENT!="")
{
$urlstr=$urlstr."&CONTRACT_CONTENT=".$CONTRACT_CONTENT;
$WHERE_STR.=" and a.CONTRACT_CONTENT like '%".$CONTRACT_CONTENT."%'";
}
if($LDATE1!="")
{
$urlstr=$urlstr."&LDATE1=".$LDATE1;
$WHERE_STR.=" and a.".$DATE_TYPE."_DATE>='$LDATE1'";
}
if($LDATE2!="")
{
$urlstr=$urlstr."&LDATE2=".$LDATE2;
$WHERE_STR.=" and a.".$DATE_TYPE."_DATE<='$LDATE2'";
}
if($SIGN=="0")
{
$urlstr=$urlstr."&SIGN=".$SIGN;
$HAVING=" HAVING PAYMENT<TOTALPRICE";
}
if($SIGN=="1")
{
$urlstr=$urlstr."&SIGN=".$SIGN;
$HAVING=" HAVING PAYMENT>=TOTALPRICE";
}
//------------自定义字段查找---------------
$query = "SELECT FIELDNO from FIELDSETTING where TABLENAME='CUSTOMER'";
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$FIELDNO="CUSTOMER".$ROW["FIELDNO"];
if($$FIELDNO!="")
{
$CUSTOMERID_STR="";
$urlstr=$urlstr."&".$FIELDNO."=".$$FIELDNO;
$WHERE_STR1=" where TABLENAME='CUSTOMER' 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))."'";
$WHERE_STR.=" and d.CUSTOMER_ID in ($CUSTOMERID_STR)";
}
}
$query = "SELECT FIELDNO from FIELDSETTING where TABLENAME='CONTRACT'";
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$FIELDNO="CONTRACT".$ROW["FIELDNO"];
if($$FIELDNO!="")
{
$CONTACTID_STR="";
$urlstr=$urlstr."&".$FIELDNO."=".$$FIELDNO;
$WHERE_STR1=" where TABLENAME='CONTRACT' and (FIELDNO='".$ROW["FIELDNO"]."' and ITEM_DATE like '%".$$FIELDNO."%')";
$query1="SELECT IDENTY_ID FROM `FIELD_DATE`".$WHERE_STR1;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -