📄 index.php
字号:
<?php
function GETALLDATE( $CODE, $GETVALUE )
{
global $connection;
$query = "SELECT * from SYS_CODE where PARENT_NO='".$CODE."'";
$cursor = exequery( $connection, $query );
echo "<option value= ></option>";
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$CODE_NO = $ROW['CODE_NO'];
$CODE_NAME = $ROW['CODE_NAME'];
if ( $CODE_NO == $GETVALUE )
{
echo "<option value=".$CODE_NO." selected>".$CODE_NAME."</option>";
}
else
{
echo "<option value=".$CODE_NO." >".$CODE_NAME."</option>";
}
}
}
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'];
}
echo "\r\n<html>\r\n<head>\r\n<title>销售记录快速搜索 </title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\"><script src=\"/inc/js/module.js\"></script>\r\n<script Language=\"JavaScript\">\r\n function delete_customer(HISTORY_ID)\r\n{\r\n msg='确认要删除该销售记录?';\r\n if(window.confirm(msg))\r\n {\r\n URL=\"delete.php?CUSTOMER_NAME=";
echo $CUSTOMER_NAME;
echo "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_SHORT=";
echo $CUSTOMER_SHORT;
echo "&ARE=";
echo $ARE;
echo "&KIND=";
echo $KIND;
echo "&SELLMODE=";
echo $SELLMODE;
echo "&ATTRIBUTE=";
echo $ATTRIBUTE;
echo "&ENTERTYPE=";
echo $ENTERTYPE;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&SERVICE_NAME=";
echo $SERVICE_NAME;
echo "&SERVICE_DESC=";
echo $SERVICE_DESC;
echo "&DATE1=";
echo $DATE1;
echo "&DATE2=";
echo $DATE2;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&HISTORY_ID=\" + HISTORY_ID;\r\n window.location=URL;\r\n }\r\n}\r\n\r\nfunction set_page()\r\n{\r\n PAGE_START=PAGE_NUM.value;\r\n location=\"index.php?CUSTOMER_NAME=";
echo $CUSTOMER_NAME;
echo "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_SHORT=";
echo $CUSTOMER_SHORT;
echo "&ARE=";
echo $ARE;
echo "&KIND=";
echo $KIND;
echo "&SELLMODE=";
echo $SELLMODE;
echo "&ATTRIBUTE=";
echo $ATTRIBUTE;
echo "&ENTERTYPE=";
echo $ENTERTYPE;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&SERVICE_NAME=";
echo $SERVICE_NAME;
echo "&SERVICE_DESC=";
echo $SERVICE_DESC;
echo "&DATE1=";
echo $DATE1;
echo "&DATE2=";
echo $DATE2;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=\"+PAGE_START;\r\n}\r\nfunction check_one(el)\r\n{\r\n if(!el.checked)\r\n document.all(\"allbox\").checked=false;\r\n}\r\nfunction check_all()\r\n{\r\n for (i=0;i<document.all(\"email_select\").length;i++)\r\n {\r\n if(document.all(\"allbox\").checked)\r\n document.all(\"email_select\").item(i).checked=true;\r\n else\r\n document.all(\"email_select\").item(i).checked=false;\r\n }\r\n\r\n if(i==0)\r\n {\r\n if(document.all(\"allbox\").checked)\r\n document.all(\"email_select\").checked=true;\r\n else\r\n document.all(\"email_select\").checked=false;\r\n }\r\n}\r\nfunction delete_mail()\r\n{\r\n delete_str=\"\";\r\n for(i=0;i<document.all(\"email_select\").length;i++)\r\n {\r\n\r\n el=document.all(\"email_select\").item(i);\r\n if(el.checked)\r\n { val=el.value;\r\n delete_str+=val + \",\";\r\n }\r\n }\r\n\r\n if(i==0)\r\n {\r\n el=document.all(\"email_select\");\r\n if(el.checked)\r\n { val=el.value;\r\n delete_str+=val + \",\";\r\n }\r\n }\r\n\r\n if(delete_str==\"\")\r\n {\r\n alert(\"请至少选择其中一条销售记录。\");\r\n return;\r\n }\r\n\r\n msg='确认要删除所选销售记录?';\r\n if(window.confirm(msg))\r\n {\r\n URL=\"delete.php?CUSTOMER_NAME=";
echo $CUSTOMER_NAME;
echo "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_SHORT=";
echo $CUSTOMER_SHORT;
echo "&ARE=";
echo $ARE;
echo "&KIND=";
echo $KIND;
echo "&SELLMODE=";
echo $SELLMODE;
echo "&ATTRIBUTE=";
echo $ATTRIBUTE;
echo "&ENTERTYPE=";
echo $ENTERTYPE;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&SERVICE_NAME=";
echo $SERVICE_NAME;
echo "&SERVICE_DESC=";
echo $SERVICE_DESC;
echo "&DATE1=";
echo $DATE1;
echo "&DATE2=";
echo $DATE2;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&delete_str=\" + delete_str;\r\n window.location=URL;\r\n }\r\n}\r\n\r\nfunction excel_export()\r\n{\r\n document.form1.action=\"export.php\";\r\n document.form1.submit();\r\n document.form1.action=\"index.php\"; //有用?\r\n}\r\n</script>\r\n</head>\r\n<body class=\"bodycolor\">\r\n<div align=\"left\">\r\n<fieldset style=\"width:95%;padding-bottom:5px;\">\r\n\t <legend class=\"small\" align=left>\r\n <b>快速查询</b>\r\n </legend>\r\n<table cellspacing=\"1\" class=\"small\" align=\"left\" cellpadding=\"3\" width=\"100%\">\r\n <form action=\"index.php\" method=\"post\" name=\"form1\">\r\n <tr>\r\n <td nowrap class=\"TableData\"> 客户名称: </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"CUSTOMER_NAME\" class=\"SmallInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $CUSTOMER_NAME;
echo "\">\r\n </td>\r\n <td nowrap class=\"TableData\">客户编码: </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"CUSTOMER_CODE\" class=\"SmallInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $CUSTOMER_CODE;
echo "\">\r\n </td>\r\n\r\n <td nowrap class=\"TableData\">客户简称: </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"CUSTOMER_SHORT\" class=\"SmallInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $CUSTOMER_SHORT;
echo "\">\r\n </td>\r\n <td nowrap class=\"TableData\">地区: </td>\r\n <td nowrap class=\"TableData\" >\r\n <select name=\"ARE\" class=\"SmallSelect\">\r\n";
getalldate( "AREA", $ARE );
echo " </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\"> 客户类别: </td>\r\n <td nowrap class=\"TableData\" >\r\n <select name=\"KIND\" class=\"SmallSelect\">\r\n";
getalldate( "CRM_KIND", $KIND );
echo " </select>\r\n </td>\r\n <td nowrap class=\"TableData\">销售方式: </td>\r\n <td nowrap class=\"TableData\">\r\n <select name=\"SELLMODE\" class=\"SmallSelect\">\r\n";
getalldate( "SELL_MODE", $SELLMODE );
echo " </select>\r\n </td>\r\n <td nowrap class=\"TableData\">行业属性: </td>\r\n <td nowrap class=\"TableData\">\r\n <select name=\"ATTRIBUTE\" class=\"SmallSelect\">\r\n";
getalldate( "CRM_ATTRIBUTE", $ATTRIBUTE );
echo " </select>\r\n </td>\r\n\r\n <td nowrap class=\"TableData\">企业性质: </td>\r\n <td nowrap class=\"TableData\" >\r\n <select name=\"ENTERTYPE\" class=\"SmallSelect\">\r\n";
getalldate( "CRM_TYPE", $ENTERTYPE );
echo " </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n \t<td nowrap class=\"TableData\"> 产品类别:</td>\r\n <td nowrap class=\"TableData\">\r\n <select name=\"PRODUCT_MODE\" class=\"SmallSelect\">\r\n";
getalldate( "PRODUCT_MODE", $PRODUCT_MODE );
echo " </select>\r\n </td>\r\n <td nowrap class=\"TableData\">产品名称: </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"PRODUCT_NAME\" class=\"SmallInput\" size=\"15\" maxlength=\"100\">\r\n </td>\r\n <td nowrap class=\"TableData\">产品型号: </td>\r\n <td nowrap class=\"TableData\" colspan=\"3\">\r\n <input type=\"text\" name=\"PRODUCT_TYPE\" class=\"SmallInput\" size=\"15\" maxlength=\"100\">\r\n </td>\r\n </tr>\r\n </tr>\r\n <tr>\r\n \t <td nowrap class=\"TableData\"> 服务名称: </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"SERVICE_NAME\" class=\"SmallInput\" size=\"15\" maxlength=\"100\">\r\n </td>\r\n <td nowrap class=\"TableData\">服务描述: </td>\r\n <td nowrap class=\"TableData\" colspan=\"3\">\r\n <textarea cols=37 rows=1 name=\"SERVICE_DESC\" class=\"SmallInput\" wrap=\"yes\">";
echo $MEMO;
echo "</textarea>\r\n </td>\r\n <td nowrap class=\"TableData\">销售记录号: </td>\r\n <td nowrap class=\"TableData\" >\r\n <input type=\"text\" name=\"HISTORY_CODE\" class=\"SmallInput\" size=\"20\" maxlength=\"100\">\r\n </td>\r\n </tr>\r\n <tr>\r\n \t<td nowrap class=\"TableData\"> 记录日期: </td>\r\n \t<td nowrap class=\"TableData\" colspan=\"3\">\r\n <input type=\"text\" name=\"DATE1\" size=\"15\" maxlength=\"10\" class=\"SmallStatic\" readonly value=\"";
echo $DATE1;
echo "\">\r\n <img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" border=\"0\" style=\"cursor:hand\" onClick=\"td_calendar('form1.DATE1');\">\r\n 至<input type=\"text\" name=\"DATE2\" size=\"15\" maxlength=\"10\" class=\"SmallStatic\" readonly value=\"";
echo $DATE2;
echo "\">\r\n <img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" border=\"0\" style=\"cursor:hand\" onClick=\"td_calendar('form1.DATE2');\">\r\n \t<td nowrap class=\"TableData\" colspan=\"4\" >\r\n \t <input value=\"快速查询\" type=\"submit\" class=\"SmallButton\" title=\"快速查询\" name=\"button\">\r\n \t <input type=\"button\" value=\"导出\" class=\"SmallButton\" title=\"导出销售记录\" name=\"button\" onClick=\"excel_export()\"> \r\n\r\n </td>\r\n </tr>\r\n</form>\r\n</table>\r\n</fieldset>\r\n</div>\r\n<br>\r\n";
$WHERE_STR .= " where (a.SALESMAN='".$LOGIN_USER_ID."' or a.CREATOR='{$LOGIN_USER_ID}') and a.CONTRACT_ID='-1' and a.LINE_ID='-1' ";
if ( $HISTORY_CODE != "" )
{
$WHERE_STR .= " and a.HISTORY_CODE like '%".$HISTORY_CODE."%'";
}
if ( $CUSTOMER_NAME != "" )
{
$WHERE_STR .= " and b.CUSTOMER_NAME like '%".$CUSTOMER_NAME."%'";
}
if ( $CUSTOMER_CODE != "" )
{
$WHERE_STR .= " and b.CUSTOMER_CODE like '%".$CUSTOMER_CODE."%'";
}
if ( $CUSTOMER_SHORT != "" )
{
$WHERE_STR .= " and b.CUSTOMER_SHORT like '%".$CUSTOMER_SHORT."%'";
}
if ( $ARE != "" )
{
$WHERE_STR .= " and b.CUSTOMER_AREA= '".$ARE."'";
}
if ( $KIND != "" )
{
$WHERE_STR .= " and b.KIND= '".$KIND."'";
}
if ( $SELLMODE != "" )
{
$WHERE_STR .= " and b.SELLMODE= '".$SELLMODE."'";
}
if ( $ATTRIBUTE != "" )
{
$WHERE_STR .= " and b.ATTRIBUTE= '".$ATTRIBUTE."'";
}
if ( $ENTERTYPE != "" )
{
$WHERE_STR .= " and b.ENTERTYPE= '".$ENTERTYPE."'";
}
if ( $PRODUCT_NAME != "" )
{
$WHERE_STR .= " and c.PRODUCT_NAME like '%".$PRODUCT_NAME."%'";
}
if ( $PRODUCT_MODE != "" )
{
$WHERE_STR .= " and c.PRODUCT_MODE ='".$PRODUCT_MODE."'";
}
if ( $PRODUCT_TYPE != "" )
{
$WHERE_STR .= " and c.PRODUCT_TYPE like '%".$PRODUCT_TYPE."%'";
}
if ( $SERVICE_NAME != "" )
{
$WHERE_STR .= " and d.SERVICE_NAME like '%".$SERVICE_NAME."%'";
}
if ( $SERVICE_DESC != "" )
{
$WHERE_STR .= " and d.SERVICE_DESC like '%".$SERVICE_DESC."%'";
}
if ( $DATE1 != "" )
{
$WHERE_STR .= " and a.DATE>='".$DATE1."'";
}
if ( $DATE2 != "" )
{
$WHERE_STR .= " and a.DATE<='".$DATE2."'";
}
if ( $ORDERFIELD != "" )
{
if ( $ORDERSIGN == "DOWN" )
{
$ORDERTYPE = "ASC";
}
if ( $ORDERSIGN == "UP" )
{
$ORDERTYPE = "DESC";
}
$OREDERBY = " ORDER BY ".$ORDERFIELD." ".$ORDERTYPE;
}
$CUSTOMER_COUNT = 0;
$SUM_TOTAL_AMT = 0;
$SUM_TOTAL_PRICE = 0;
$query = "SELECT count(*),sum(AMT),sum(TOTAL_PRICE) from SALE_HISTORY a\r\n LEFT OUTER JOIN CUSTOMER b ON a.CUSTOMER_ID=b.CUSTOMER_ID\r\n LEFT OUTER JOIN PRODUCT c ON a.PRODUCT_ID=c.PRODUCT_ID and a.TYPE='PRO'\r\n LEFT OUTER JOIN SERVICE d ON a.SERVICE_ID=d.SERVICE_ID and a.TYPE='SER'\r\n LEFT OUTER JOIN USER e ON a.SALESMAN=e.USER_ID\r\n ".$WHERE_STR;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$CUSTOMER_COUNT = $ROW[0];
$SUM_TOTAL_AMT = $ROW[1];
$SUM_TOTAL_PRICE = $ROW[2];
}
$PER_PAGE = 10;
$PAGE_COUNT = ceil( $CUSTOMER_COUNT / $PER_PAGE );
if ( $CUR_PAGE <= 0 || $CUR_PAGE == "" )
{
$CUR_PAGE = 1;
}
if ( $PAGE_COUNT < $CUR_PAGE )
{
$CUR_PAGE = $PAGE_COUNT;
}
$query1 = "SELECT c.PRODUCT_NAME as PRODUCT_NAME,d.SERVICE_NAME as SERVICE_NAME,a.PRICE as PRICE,a.AMT as AMT,a.TOTAL_PRICE as TOTAL_PRICE,a.DATE as DATE,e.USER_NAME as SELLER,b.CUSTOMER_NAME as CUSTOMER_NAME,a.HISTORY_ID as HISTORY_ID,a.TYPE as TYPE,f.USER_NAME as CREATOR\r\n from SALE_HISTORY a\r\n LEFT OUTER JOIN CUSTOMER b ON a.CUSTOMER_ID=b.CUSTOMER_ID\r\n LEFT OUTER JOIN PRODUCT c ON a.PRODUCT_ID=c.PRODUCT_ID and a.TYPE='PRO'\r\n LEFT OUTER JOIN SERVICE d ON a.SERVICE_ID=d.SERVICE_ID and a.TYPE='SER'\r\n LEFT OUTER JOIN USER e ON a.SALESMAN=e.USER_ID\r\n LEFT OUTER JOIN USER f ON a.CREATOR=f.USER_ID\r\n ".$WHERE_STR.$OREDERBY;
$offest = ( $CUR_PAGE - 1 ) * 10;
if ( $offest < 0 )
{
$offest = 0;
}
$query1 = $query1." LIMIT ".$offest." ,".$PER_PAGE;
$cursor1 = exequery( $connection, $query1 );
if ( $CUSTOMER_COUNT == 0 )
{
message( "<br>提示", "没有符合条件的销售记录" );
exit( );
}
echo "\r\n<table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\" cellpadding=\"3\">\r\n <tr>\r\n <td align=\"left\">\r\n <a href=\"index.php?CUR_PAGE=1&CUSTOMER_NAME=";
echo $CUSTOMER_NAME;
echo "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_SHORT=";
echo $CUSTOMER_SHORT;
echo "&ARE=";
echo $ARE;
echo "&KIND=";
echo $KIND;
echo "&SELLMODE=";
echo $SELLMODE;
echo "&ATTRIBUTE=";
echo $ATTRIBUTE;
echo "&ENTERTYPE=";
echo $ENTERTYPE;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&SERVICE_NAME=";
echo $SERVICE_NAME;
echo "&SERVICE_DESC=";
echo $SERVICE_DESC;
echo "&DATE1=";
echo $DATE1;
echo "&DATE2=";
echo $DATE2;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\"><img src='/images/first02.gif' width='24' border='0' height='15' alt='首页'></a>\r\n <a href=\"index.php?CUR_PAGE=";
echo $CUR_PAGE - 1;
echo "&CUSTOMER_NAME=";
echo $CUSTOMER_NAME;
echo "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_SHORT=";
echo $CUSTOMER_SHORT;
echo "&ARE=";
echo $ARE;
echo "&KIND=";
echo $KIND;
echo "&SELLMODE=";
echo $SELLMODE;
echo "&ATTRIBUTE=";
echo $ATTRIBUTE;
echo "&ENTERTYPE=";
echo $ENTERTYPE;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&SERVICE_NAME=";
echo $SERVICE_NAME;
echo "&SERVICE_DESC=";
echo $SERVICE_DESC;
echo "&DATE1=";
echo $DATE1;
echo "&DATE2=";
echo $DATE2;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\"><img src='/images/first01.gif' width='24' border='0' height='15' alt='上一页'></a>\r\n <a href=\"index.php?CUR_PAGE=";
echo $CUR_PAGE + 1;
echo "&CUSTOMER_NAME=";
echo $CUSTOMER_NAME;
echo "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_SHORT=";
echo $CUSTOMER_SHORT;
echo "&ARE=";
echo $ARE;
echo "&KIND=";
echo $KIND;
echo "&SELLMODE=";
echo $SELLMODE;
echo "&ATTRIBUTE=";
echo $ATTRIBUTE;
echo "&ENTERTYPE=";
echo $ENTERTYPE;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&SERVICE_NAME=";
echo $SERVICE_NAME;
echo "&SERVICE_DESC=";
echo $SERVICE_DESC;
echo "&DATE1=";
echo $DATE1;
echo "&DATE2=";
echo $DATE2;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\"><img src='/images/last01.gif' width='24' border='0' height='15' alt='下一页' style=\"cursor:hand\"></a>\r\n <a href=\"index.php?CUR_PAGE=";
echo $PAGE_COUNT;
echo "&CUSTOMER_NAME=";
echo $CUSTOMER_NAME;
echo "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_SHORT=";
echo $CUSTOMER_SHORT;
echo "&ARE=";
echo $ARE;
echo "&KIND=";
echo $KIND;
echo "&SELLMODE=";
echo $SELLMODE;
echo "&ATTRIBUTE=";
echo $ATTRIBUTE;
echo "&ENTERTYPE=";
echo $ENTERTYPE;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&SERVICE_NAME=";
echo $SERVICE_NAME;
echo "&SERVICE_DESC=";
echo $SERVICE_DESC;
echo "&DATE1=";
echo $DATE1;
echo "&DATE2=";
echo $DATE2;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\"><img src='/images/last02.gif' width='24' border='0' height='15' alt='末页' style=\"cursor:hand\"></a>\r\n\r\n 到\r\n <input type=\"text\" name=\"PAGE_NUM\" size=\"3\" maxlength=\"4\" class=\"SmallInput\">\r\n 页\r\n <img id=\"btnGotoPage\" src=\"/images/menu/book.gif\" onClick=\"set_page()\" border=\"0\" WIDTH=\"19\" HEIGHT=\"17\" style=\"cursor:hand\" alt=\"转到相应页面\">\r\n </td>\r\n <td align=\"right\">\r\n ";
echo $CUR_PAGE;
echo "/";
echo $PAGE_COUNT;
echo "页 共 ";
echo $CUSTOMER_COUNT;
echo " 条\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<table class=\"TableList\" width=\"95%\">\r\n <tr class=\"TableHeader\">\r\n \t <td nowrap align=\"center\">选择</td>\r\n <td nowrap align=\"center\"><a href=\"index.php?CUSTOMER_NAME=";
echo $CUSTOMER_NAME;
echo "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_SHORT=";
echo $CUSTOMER_SHORT;
echo "&ARE=";
echo $ARE;
echo "&KIND=";
echo $KIND;
echo "&SELLMODE=";
echo $SELLMODE;
echo "&ATTRIBUTE=";
echo $ATTRIBUTE;
echo "&ENTERTYPE=";
echo $ENTERTYPE;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&SERVICE_NAME=";
echo $SERVICE_NAME;
echo "&SERVICE_DESC=";
echo $SERVICE_DESC;
echo "&DATE1=";
echo $DATE1;
echo "&DATE2=";
echo $DATE2;
echo "&ORDERFIELD=PRODUCT_NAME&ORDERSIGN=";
if ( $ORDERSIGN == "DOWN" )
{
echo "UP";
}
if ( $ORDERSIGN == "UP" )
{
echo "DOWN";
}
if ( $ORDERSIGN == "" )
{
if ( $ORDERTYPE == "ASC" )
{
echo "UP";
}
else
{
echo "DOWN";
}
}
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\">产品名称 ";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "PRODUCT_NAME" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -