📄 list.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$PAGE_SIZE = 10;
echo "\r\n<html>\r\n<head>\r\n<title>合同查询结果</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<script Language=\"JavaScript\">\r\nfunction set_page(urlstr)\r\n{\r\n PAGE_START=PAGE_NUM.value;\r\n location=\"list.php?\"+urlstr+\"&CUR_PAGE=\"+PAGE_START+\"&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\";\r\n}\r\nfunction show_detail(CONTRACT_ID)\r\n {\r\n URL=\"linelist.php?CONTRACT_ID=\"+CONTRACT_ID;\r\n myleft=(screen.availWidth-650)/2;\r\n 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\");\r\n }\r\nfunction show_detail1(CONTRACT_ID)\r\n {\r\n URL=\"historylist.php?CONTRACT_ID=\"+CONTRACT_ID;\r\n myleft=(screen.availWidth-650)/2;\r\n 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\");\r\n }\r\nfunction show_detail2(CONTRACT_ID)\r\n {\r\n URL=\"contractlist.php?CONTRACT_ID=\"+CONTRACT_ID;\r\n myleft=(screen.availWidth-650)/2;\r\n 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\");\r\n } \r\n</script>\r\n</head>\r\n";
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 ( $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."%'";
}
}
if ( $SELLER_NAME != "" )
{
if ( $urlstr == "" )
{
$urlstr = "SELLER_NAME=".$SELLER_NAME;
}
else
{
$urlstr = $urlstr."&SELLER_NAME=".$SELLER_NAME;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where g.USER_NAME like '%".$SELLER_NAME."%'";
}
else
{
$WHERE_STR .= " and g.USER_NAME like '%".$SELLER_NAME."%'";
}
}
if ( $CONTRACT_MEMO != "" )
{
if ( $urlstr == "" )
{
$urlstr = "CONTRACT_MEMO=".$CONTRACT_MEMO;
}
else
{
$urlstr = $urlstr."&CONTRACT_MEMO=".$CONTRACT_MEMO;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.CONTRACT_MEMO like '%".$CONTRACT_MEMO."%'";
}
else
{
$WHERE_STR .= " and a.CONTRACT_MEMO like '%".$CONTRACT_MEMO."%'";
}
}
if ( $CONTRACT_ARTICLE != "" )
{
if ( $urlstr == "" )
{
$urlstr = "CONTRACT_ARTICLE=".$CONTRACT_ARTICLE;
}
else
{
$urlstr = $urlstr."&CONTRACT_ARTICLE=".$CONTRACT_ARTICLE;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.CONTRACT_ARTICLE like '%".$CONTRACT_ARTICLE."%'";
}
else
{
$WHERE_STR .= " and a.CONTRACT_ARTICLE like '%".$CONTRACT_ARTICLE."%'";
}
}
if ( $CONTRACT_CONTENT != "" )
{
if ( $urlstr == "" )
{
$urlstr = "CONTRACT_CONTENT=".$CONTRACT_CONTENT;
}
else
{
$urlstr = $urlstr."&CONTRACT_CONTENT=".$CONTRACT_CONTENT;
}
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.CONTRACT_CONTENT like '%".$CONTRACT_CONTENT."%'";
}
else
{
$WHERE_STR .= " and a.CONTRACT_CONTENT like '%".$CONTRACT_CONTENT."%'";
}
}
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 ( $SIGN == "0" )
{
if ( $urlstr == "" )
{
$urlstr = "SIGN=".$SIGN;
}
else
{
$urlstr = $urlstr."&SIGN=".$SIGN;
}
$HAVING = " HAVING PAYMENT<TOTALPRICE";
}
if ( $SIGN == "1" )
{
if ( $urlstr == "" )
{
$urlstr = "SIGN=".$SIGN;
}
else
{
$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 = "";
if ( $urlstr == "" )
{
$urlstr = $FIELDNO."=".$$FIELDNO;
}
else
{
$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 ) )."'";
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where d.CUSTOMER_ID in (".$CUSTOMERID_STR.")";
}
else
{
$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 != "" )
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -