📄 index.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
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\r\n<script Language=\"JavaScript\">\r\nfunction CheckForm()\r\n{\r\n\t if(document.all(\"LINE_ID\").value==\"\" )\r\n {\r\n \t alert(\"请选择订单明细!!\");\r\n return (false);\r\n }\r\n if(document.all(\"TRANS_QTY\").value==\"\")\r\n {\r\n \t alert(\"交付数量不能空!!\");\r\n return (false);\r\n }\r\n document.form1.submit();\r\n}\r\n\r\nfunction checknum(p)\r\n{\r\n var l = p.length;\r\n var count=0;\r\n for(var i=0; i<l; i++)\r\n {\r\n var digit = p.charAt(i);\r\n if(digit == \".\" )\r\n {\r\n ++count;\r\n if(count>1)\r\n {\r\n return 0;\r\n }\r\n }\r\n else if(digit < \"0\" || digit > \"9\")\r\n {\r\n return 0;\r\n }\r\n }\r\n return 1;\r\n}\r\nfunction select_value(LINE_ID,PRODUCT_ID,PRODUCT_NAME,TRANS_PRICE,PROVIDER_ID)\r\n{\r\n\r\n document.all(\"LINE_ID\").value=LINE_ID;\r\n document.all(\"PRO_ID\").value=PRODUCT_ID;\r\n document.all(\"PRO_NAME\").value=PRODUCT_NAME;\r\n document.all(\"PRICE\").value=TRANS_PRICE;\r\n document.all(\"PROVIDER_ID\").value=PROVIDER_ID;\r\n document.all(\"OP\").value=\"ADD\";\r\n}\r\n\r\nfunction select_value1(LINE_ID,PRODUCT_ID,PRODUCT_NAME,TRANS_PRICE,TRANS_QTY,HISTORY_ID)\r\n{\r\n document.all(\"HISTORY_ID\").value=HISTORY_ID;\r\n document.all(\"LINE_ID\").value=LINE_ID;\r\n document.all(\"PRO_ID\").value=PRODUCT_ID;\r\n document.all(\"PRO_NAME\").value=PRODUCT_NAME;\r\n document.all(\"PRICE\").value=TRANS_PRICE;\r\n document.all(\"TRANS_QTY\").value=TRANS_QTY;\r\n document.all(\"OP\").value=\"MOD\";\r\n}\r\n\r\nfunction delete_vote(HISTORY_ID,ORDER_ID)\r\n{\r\n msg='确认删除该接货记录吗?';\r\n if(window.confirm(msg))\r\n {\r\n URL=\"delete.php?HISTORY_ID=\"+HISTORY_ID+\"&ORDER_ID=\"+ORDER_ID+\"&PROVIDER_NAME=";
echo $PROVIDER_NAME;
echo "&PROVIDER_CODE=";
echo $PROVIDER_CODE;
echo "&PROVIDER_SHORT=";
echo $PROVIDER_SHORT;
echo "&PROVIDER_AREA=";
echo $PROVIDER_AREA;
echo "&ORDER_TYPE=";
echo $ORDER_TYPE;
echo "&ORDER_NO=";
echo $ORDER_NO;
echo "&ORDER_NAME=";
echo $ORDER_NAME;
echo "&RECIVER=";
echo $RECIVER;
echo "&DATE1=";
echo $DATE1;
echo "&DATE2=";
echo $DATE2;
echo "&CREATOR=";
echo $CREATOR;
echo "&DATE_TYPE=";
echo $DATE_TYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\";\r\n window.location=URL;\r\n }\r\n}\r\nfunction delete_vote1(HISTORY_ID,ORDER_ID)\r\n{\r\n msg='确认删除该接货记录吗?';\r\n if(window.confirm(msg))\r\n {\r\n URL=\"delete.php?HISTORY_ID=\"+HISTORY_ID+\"&ORDER_ID=\"+ORDER_ID+\"&querstr=\"+document.all(\"querstr\").value;;\r\n window.location=URL;\r\n }\r\n}\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
$query = "SELECT a.LINE_ID as LINE_ID,b.PRODUCT_ID as PRODUCT_ID,b.PRODUCT_NAME as PRODUCT_NAME,\r\n a.TRANS_PRICE as TRANS_PRICE,\r\n a.TRANS_QTY as TRANS_QTY,a.PAYMENT as PAYMENT,a.MEMO as MEMO,c.PROVIDER_ID as PROVIDER_ID,\r\n b.PRODUCT_CODE as PRODUCT_CODE,a.TRANS_PRICE*a.TRANS_QTY as TOTALPRICE,b.PRODUCT_TYPE as PRODUCT_TYPE\r\n from ORDER_LINE a\r\n LEFT OUTER JOIN PRODUCT b ON a.PRODUCT_ID = b.PRODUCT_ID\r\n LEFT OUTER JOIN SUPPLY_ORDER c ON a.ORDER_ID = c.ORDER_ID\r\n where a.ORDER_ID='".$ORDER_ID."' ";
$cursor = exequery( $connection, $query );
$VOTE_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$VOTE_COUNT;
$LINE_ID = $ROW['LINE_ID'];
$PRODUCT_ID = $ROW['PRODUCT_ID'];
$PRODUCT_NAME = $ROW['PRODUCT_NAME'];
$TRANS_PRICE = $ROW['TRANS_PRICE'];
$TRANS_QTY = $ROW['TRANS_QTY'];
$PAYMENT = $ROW['PAYMENT'];
$MEMO = $ROW['MEMO'];
$PRODUCT_CODE = $ROW['PRODUCT_CODE'];
$PRODUCT_TYPE = $ROW['PRODUCT_TYPE'];
$PROVIDER_ID = $ROW['PROVIDER_ID'];
$TOTAL_PRICE = $ROW['TOTALPRICE'];
if ( $VOTE_COUNT == 1 )
{
echo " <table width=\"95%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" height=\"3\">\r\n <tr>\r\n <td background=\"/images/dian1.gif\" width=\"100%\"></td>\r\n </tr>\r\n </table>\r\n <table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/notify_open.gif\" WIDTH=\"22\" HEIGHT=\"22\" align=\"absmiddle\"><span class=\"big3\"> 订单明细</span>\r\n </td>\r\n </tr>\r\n </table>\r\n <br>\r\n <table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n <tr class=\"TableHeader\">\r\n \t <td nowrap align=\"center\">产品名称</td>\r\n <td nowrap align=\"center\">产品编码</td>\r\n <td nowrap align=\"center\">产品型号</td>\r\n <td nowrap align=\"center\">采购单价</td>\r\n <td nowrap align=\"center\">采购数量</td>\r\n <td nowrap align=\"center\">总价</td>\r\n <td nowrap align=\"center\">操作</td>\r\n </tr>\r\n\r\n";
}
if ( $VOTE_COUNT % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo " <tr class=\"";
echo $TableLine;
echo "\">\r\n <td nowrap align=\"center\">";
echo $PRODUCT_NAME;
echo "</td>\r\n <td align=\"center\">";
echo $PRODUCT_CODE;
echo "</td>\r\n <td align=\"center\">";
echo $PRODUCT_TYPE;
echo "</td>\r\n <td align=\"center\">";
echo $TRANS_PRICE;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $TRANS_QTY;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $TOTAL_PRICE;
echo "</td>\r\n <td nowrap align=\"center\"> \r\n <a href=\"javascript:select_value('";
echo $LINE_ID;
echo "','";
echo $PRODUCT_ID;
echo "','";
echo $PRODUCT_NAME;
echo "','";
echo $TRANS_PRICE;
echo "','";
echo $PROVIDER_ID;
echo "');\"> 选择</a>\r\n </td>\r\n </tr>\r\n";
}
echo "</table>\r\n<br>\r\n<table border=\"0\" width=\"50%\" cellpadding=\"2\" cellspacing=\"1\" align=\"center\" bgcolor=\"#000000\" class=\"small\">\r\n <form enctype=\"multipart/form-data\" action=\"add.php\" method=\"post\" name=\"form1\">\r\n <tr>\r\n <td nowrap class=\"TableData\">产品名称:</td>\r\n <td class=\"TableData\">\r\n <input type=\"hidden\" name=\"PRO_ID\">\r\n <input type=\"text\" name=\"PRO_NAME\" size=\"20\" class=\"BigStatic\" maxlength=\"20\" readonly>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">单价:</td>\r\n <td class=\"TableData\">\r\n \t<input type=\"text\" name=\"PRICE\" size=\"20\" maxlength=\"20\" class=\"BigStatic\" class=\"BigInput\" readonly>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">本次交付数量:</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"TRANS_QTY\" size=\"20\" maxlength=\"20\" class=\"BigInput\">\r\n </td>\r\n </tr>\r\n <tr align=\"center\" class=\"TableControl\">\r\n <td colspan=\"2\" nowrap>\r\n";
if ( $querstr != "" )
{
$urlstr1 = str_replace( "%", "&", $querstr );
echo " <input type=\"hidden\" name=\"ORDER_ID\" value=\"";
echo $ORDER_ID;
echo "\">\r\n <input type=\"hidden\" name=\"LINE_ID\">\r\n <input type=\"hidden\" name=\"PROVIDER_ID\" value=\"";
echo $PROVIDER_ID;
echo "\">\r\n <input type=\"hidden\" name=\"OP\">\r\n <input type=\"hidden\" name=\"HISTORY_ID\">\r\n <input type=\"hidden\" name=\"querstr\" value=\"";
echo $querstr;
echo "\">\r\n <input type=\"hidden\" value=\"ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\" name=\"QUERY_LIST\">\r\n <input type=\"hidden\" value=\"ad_query\" name=\"FLAGSOURCE\">\r\n <input type=\"button\" value=\"确认\" class=\"BigButton\" onclick=\"CheckForm();\"> \r\n";
if ( $LINE_ID != "" )
{
echo " <input type=\"button\" value=\"取消\" class=\"BigButton\" onclick=\"location='index.php?ORDER_ID=";
echo $ORDER_ID;
echo "&querstr=";
echo $querstr;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "'\">\r\n";
}
echo " <input type=\"button\" value=\"返回\" class=\"BigButton\" onclick=\"location='../ad_query/list.php?";
echo $urlstr1;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "'\">\r\n";
}
else
{
echo " <input type=\"hidden\" name=\"ORDER_ID\" value=\"";
echo $ORDER_ID;
echo "\">\r\n <input type=\"hidden\" name=\"LINE_ID\">\r\n <input type=\"hidden\" name=\"PROVIDER_ID\" value=\"";
echo $PROVIDER_ID;
echo "\">\r\n <input type=\"hidden\" name=\"OP\">\r\n <input type=\"hidden\" name=\"HISTORY_ID\">\r\n <input type=\"hidden\" value=\"ORDER_ID=";
echo $ORDER_ID;
echo "&PROVIDER_NAME=";
echo $PROVIDER_NAME;
echo "&PROVIDER_CODE=";
echo $PROVIDER_CODE;
echo "&PROVIDER_SHORT=";
echo $PROVIDER_SHORT;
echo "&PROVIDER_AREA=";
echo $PROVIDER_AREA;
echo "&ORDER_TYPE=";
echo $ORDER_TYPE;
echo "&ORDER_NO=";
echo $ORDER_NO;
echo "&ORDER_NAME=";
echo $ORDER_NAME;
echo "&RECIVER=";
echo $RECIVER;
echo "&DATE1=";
echo $DATE1;
echo "&DATE2=";
echo $DATE2;
echo "&CREATOR=";
echo $CREATOR;
echo "&DATE_TYPE=";
echo $DATE_TYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\" name=\"QUERY_LIST\">\r\n <input type=\"button\" value=\"确认\" class=\"BigButton\" onclick=\"CheckForm();\"> \r\n";
if ( $LINE_ID != "" )
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -