index.php

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

		echo "        <input type=\"button\" value=\"取消\" class=\"BigButton\" onclick=\"location='index.php?CONTRACT_ID=";
		echo $CONTRACT_ID;
		echo "&CUSTOMER_NAME=";
		echo $CUSTOMER_NAME;
		echo "&KIND=";
		echo $KIND;
		echo "&SELLMODE=";
		echo $SELLMODE;
		echo "&CONTRACT_TYPE=";
		echo $CONTRACT_TYPE;
		echo "&DATE_TYPE=";
		echo $DATE_TYPE;
		echo "&CONTRACT_NO=";
		echo $CONTRACT_NO;
		echo "&CONTRACT_NAME=";
		echo $CONTRACT_NAME;
		echo "&SIGN=";
		echo $SIGN;
		echo "&CONTRACT_LINKMAN1=";
		echo $CONTRACT_LINKMAN1;
		echo "&CONTRACT_LINKMAN2=";
		echo $CONTRACT_LINKMAN2;
		echo "&DATE1=";
		echo $DATE1;
		echo "&DATE2=";
		echo $DATE2;
		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='../?CUSTOMER_NAME=";
	echo $CUSTOMER_NAME;
	echo "&KIND=";
	echo $KIND;
	echo "&SELLMODE=";
	echo $SELLMODE;
	echo "&CONTRACT_TYPE=";
	echo $CONTRACT_TYPE;
	echo "&DATE_TYPE=";
	echo $DATE_TYPE;
	echo "&CONTRACT_NO=";
	echo $CONTRACT_NO;
	echo "&CONTRACT_NAME=";
	echo $CONTRACT_NAME;
	echo "&CONTRACT_LINKMAN1=";
	echo $CONTRACT_LINKMAN1;
	echo "&SIGN=";
	echo $SIGN;
	echo "&CONTRACT_LINKMAN2=";
	echo $CONTRACT_LINKMAN2;
	echo "&DATE1=";
	echo $DATE1;
	echo "&DATE2=";
	echo $DATE2;
	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.SERVICE_ID as SERVICE_ID,c.SERVICE_NAME as SERVICE_NAME,a.PRICE as TRANS_PRICE,\r\n                   a.AMT as TRANS_QTY,a.TOTAL_PRICE as TOTAL_PRICE,a.TYPE as TYPE,a.DATE as TRANS_DATE,f.USER_NAME as SELLER,g.CUSTOMER_NAME as CUSTOMER_NAME,a.HISTORY_ID as HISTORY_ID\r\n                   from SALE_HISTORY a\r\n                   LEFT OUTER JOIN PRODUCT b ON a.PRODUCT_ID = b.PRODUCT_ID AND a.TYPE='PRO'\r\n                   LEFT OUTER JOIN SERVICE c ON a.SERVICE_ID = c.SERVICE_ID AND a.TYPE='SER'\r\n                   LEFT OUTER JOIN CONTRACT_LINE d ON a.LINE_ID = d.LINE_ID\r\n                   LEFT OUTER JOIN CONTRACT e ON d.CONTRACT_ID = e.CONTRACT_ID\r\n                   LEFT OUTER JOIN USER f ON a.SALESMAN=f.USER_ID\r\n                   LEFT OUTER JOIN CUSTOMER  g ON a.CUSTOMER_ID=g.CUSTOMER_ID\r\n                   where a.CONTRACT_ID='".$CONTRACT_ID."' order by TYPE,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'];
	$SERVICE_ID = $ROW['SERVICE_ID'];
	$SERVICE_NAME = $ROW['SERVICE_NAME'];
	$TRANS_PRICE = $ROW['TRANS_PRICE'];
	$TRANS_QTY = $ROW['TRANS_QTY'];
	$TOTAL_PRICE = $ROW['TOTAL_PRICE'];
	$TRANS_DATE = $ROW['TRANS_DATE'];
	$SELLER = $ROW['SELLER'];
	$CUSTOMER_NAME = $ROW['CUSTOMER_NAME'];
	$TYPE = $ROW['TYPE'];
	$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 class=\"TableList\" width=\"95%\">\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      <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 $SERVICE_NAME;
	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 $CUSTOMER_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 $SERVICE_ID;
		echo "','";
		echo $SERVICE_NAME;
		echo "','";
		echo $TRANS_PRICE;
		echo "','";
		echo $TYPE;
		echo "','";
		echo $TRANS_QTY;
		echo "','";
		echo $TOTAL_PRICE;
		echo "','";
		echo $HISTORY_ID;
		echo "');\">修改</a>\r\n         &nbsp;\r\n        <a href=\"javascript:delete_vote1('";
		echo $HISTORY_ID;
		echo "','";
		echo $CONTRACT_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 $SERVICE_ID;
		echo "','";
		echo $SERVICE_NAME;
		echo "','";
		echo $TRANS_PRICE;
		echo "','";
		echo $TYPE;
		echo "','";
		echo $TRANS_QTY;
		echo "','";
		echo $TOTAL_PRICE;
		echo "','";
		echo $HISTORY_ID;
		echo "');\">修改</a>\r\n         &nbsp;\r\n        <a href=\"javascript:delete_vote('";
		echo $HISTORY_ID;
		echo "','";
		echo $CONTRACT_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>";
?>