index.php

通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(

	{
		echo "        <input type=\"button\" value=\"取消\" class=\"BigButton\" onclick=\"location='index.php?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 "'\">\r\n";
	}
	echo "      &nbsp;&nbsp;<input type=\"button\" value=\"返回\" class=\"BigButton\" onclick=\"location='../?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";
}
echo "\r\n      </td>\r\n    </tr>\r\n  </table>\r\n</form>\r\n";
$query = "SELECT  a.LINE_ID as LINE_ID,a.PRODUCT_ID as PRODUCT_ID,b.PRODUCT_NAME as PRODUCT_NAME,\r\n                   a.PRICE as TRANS_PRICE, b.PRODUCT_CODE as PRODUCT_CODE,\r\n                   a.AMT as TRANS_QTY, (a.PRICE*a.AMT) as TOTAL_PRICE,a.DATE as TRANS_DATE,f.USER_NAME as SELLER,g.PROVIDER_NAME as PROVIDER_NAME,a.HISTORY_ID as HISTORY_ID,b.PRODUCT_TYPE as PRODUCT_TYPE\r\n                   from SUPPLY_HISTORY  a\r\n                   LEFT OUTER JOIN PRODUCT b ON a.PRODUCT_ID = b.PRODUCT_ID\r\n                   LEFT OUTER JOIN ORDER_LINE d ON a.LINE_ID = d.LINE_ID\r\n                   LEFT OUTER JOIN SUPPLY_ORDER e ON d.ORDER_ID = e.ORDER_ID\r\n                   LEFT OUTER JOIN USER f ON a.SALESMAN=f.USER_ID\r\n                   LEFT OUTER JOIN PROVIDER g ON a.PROVIDER_ID=g.PROVIDER_ID\r\n                   where a.ORDER_ID='".$ORDER_ID."' order by HISTORY_ID desc";
$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'];
	$TOTAL_PRICE = $ROW['TOTAL_PRICE'];
	$TRANS_DATE = $ROW['TRANS_DATE'];
	$PRODUCT_TYPE = $ROW['PRODUCT_TYPE'];
	$PRODUCT_CODE = $ROW['PRODUCT_CODE'];
	$SELLER = $ROW['SELLER'];
	$PROVIDER_NAME = $ROW['PROVIDER_NAME'];
	$MEMO = $ROW['MEMO'];
	$HISTORY_ID = $ROW['HISTORY_ID'];
	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\">&nbsp;订单接货记录</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  \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      <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\">";
	echo $TRANS_DATE;
	echo "</td>\r\n       <td nowrap align=\"center\">";
	echo $PROVIDER_NAME;
	echo "</td>\r\n       <td nowrap align=\"center\">";
	echo $SELLER;
	echo "</td>\r\n      <td nowrap align=\"center\">&nbsp;\r\n";
	if ( $querstr != "" )
	{
		$urlstr1 = str_replace( "%", "&", $querstr );
		echo "        <a href=\"javascript:select_value1('";
		echo $LINE_ID;
		echo "','";
		echo $PRODUCT_ID;
		echo "','";
		echo $PRODUCT_NAME;
		echo "','";
		echo $TRANS_PRICE;
		echo "','";
		echo $TRANS_QTY;
		echo "','";
		echo $HISTORY_ID;
		echo "');\">修改</a>\r\n         &nbsp;\r\n        <a href=\"javascript:delete_vote1('";
		echo $HISTORY_ID;
		echo "','";
		echo $ORDER_ID;
		echo "');\">删除</a>\r\n";
	}
	else
	{
		echo "        <a href=\"javascript:select_value1('";
		echo $LINE_ID;
		echo "','";
		echo $PRODUCT_ID;
		echo "','";
		echo $PRODUCT_NAME;
		echo "','";
		echo $TRANS_PRICE;
		echo "','";
		echo $TRANS_QTY;
		echo "','";
		echo $HISTORY_ID;
		echo "');\">修改</a>\r\n         &nbsp;\r\n        <a href=\"javascript:delete_vote('";
		echo $HISTORY_ID;
		echo "','";
		echo $ORDER_ID;
		echo "');\">删除</a>\r\n";
	}
	echo "\r\n      </td>\r\n    </tr>\r\n";
}
if ( 0 < $VOTE_COUNT )
{
	echo "</table>\r\n";
}
echo "\r\n</body>\r\n</html>";
?>