📄 index.php
字号:
<?php
function GETALLDATE( $CODE, $GETVALUE )
{
global $connection;
$query = "SELECT * from SYS_CODE where PARENT_NO='".$CODE."'";
$connection = openconnection( );
$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" );
include_once( "inc/check_type.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'];
}
echo "<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\n function delete_customer(CUSTOMER_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_AREA=";
echo $CUSTOMER_AREA;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CP_ID=\" + CUSTOMER_ID;\r\n window.location=URL;\r\n }\r\n}\r\n\r\nfunction ad_query()\r\n{\r\n URL=\"ad_query\";\r\n window.location=URL;\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 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_AREA=";
echo $CUSTOMER_AREA;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=\"+PAGE_START;\r\n}\r\n\r\nfunction show_detail(CP_ID)\r\n {\r\n URL=\"showdetail.php?CP_ID=\"+CP_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 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_AREA=";
echo $CUSTOMER_AREA;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
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_import()\r\n{\r\n URL=\"../imp_exp/\";\r\n window.location=URL;\r\n}\r\n\r\nfunction excel_export()\r\n{\r\n URL=\"../excel\";\r\n window.location=URL;\r\n}\r\n\r\n</script>\r\n</head>\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\">\r\n <form action=\"list.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=\"CUSTOMER_AREA\" class=\"SmallSelect\">\r\n";
getalldate( "AREA", $CUSTOMER_AREA );
echo " </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n \t <td nowrap class=\"TableData\" colspan=\"8\" align=\"right\">\r\n \t \t<input value=\"查询\" type=\"submit\" class=\"SmallButton\" title=\"模糊查询\" name=\"button\">\r\n \t </td>\t\r\n </tr>\r\n</form>\r\n</table>\r\n</fieldset>\r\n</div>\r\n<br>\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\">\r\n <form action=\"list.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=\"PRODUCT_NAME\" class=\"SmallInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $PRODUCT_NAME;
echo "\">\r\n </td>\r\n <td nowrap class=\"TableData\">产品型号： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"PRODUCT_TYPE\" class=\"SmallInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $PRODUCT_TYPE;
echo "\">\r\n </td>\r\n <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=\"PRICE1\" class=\"SmallInput\" size=\"5\" maxlength=\"20\" value=\"";
echo $PRICE1;
echo "\">\r\n -\r\n\t\t<input type=\"text\" name=\"PRICE2\" class=\"SmallInput\" size=\"5\" maxlength=\"20\" value=\"";
echo $PRICE2;
echo "\">\r\n </td>\r\n </tr>\r\n <tr>\r\n \t <td nowrap class=\"TableData\" colspan=\"8\" align=\"right\">\r\n \t \t<input value=\"查询\" type=\"submit\" class=\"SmallButton\" title=\"模糊查询\" name=\"button\">\r\n \t </td>\t\r\n </tr>\r\n</form>\r\n</table>\r\n</fieldset>\r\n</div>\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -