index.php

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

	echo "&CONTRACT_TYPE=";
	echo $CONTRACT_TYPE;
	echo "&CONTRACT_NO=";
	echo $CONTRACT_NO;
	echo "&CONTRACT_NAME=";
	echo $CONTRACT_NAME;
	echo "&DATE_TYPE=";
	echo $DATE_TYPE;
	echo "&CONTRACT_LINKMAN1=";
	echo $CONTRACT_LINKMAN1;
	echo "&DATE1=";
	echo $DATE1;
	echo "&DATE2=";
	echo $DATE2;
	echo "&CONTRACT_LINKMAN2=";
	echo $CONTRACT_LINKMAN2;
	echo "&SIGN=";
	echo $SIGN;
	echo "&CUR_PAGE=";
	echo $CUR_PAGE;
	echo "&ORDERFIELD=";
	echo $ORDERFIELD;
	echo "&ORDERTYPE=";
	echo $ORDERTYPE;
	echo "\" name=\"QUERY_LIST\">\r\n        <input type=\"button\" value=\"";
	if ( $LINE_ID != "" )
	{
		echo "修改";
	}
	else
	{
		echo "新建";
	}
	echo "\" class=\"BigButton\" onclick=\"CheckForm();\">&nbsp;&nbsp;\r\n";
	if ( $LINE_ID != "" )
	{
		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 "&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 "      &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 "&CONTRACT_LINKMAN2=";
	echo $CONTRACT_LINKMAN2;
	echo "&DATE1=";
	echo $DATE1;
	echo "&DATE2=";
	echo $DATE2;
	echo "&SIGN=";
	echo $SIGN;
	echo "&CUR_PAGE=";
	echo $CUR_PAGE;
	echo "&ORDERFIELD=";
	echo $ORDERFIELD;
	echo "&ORDERTYPE=";
	echo $ORDERTYPE;
	echo "'\">\r\n      </td>\r\n\r\n\r\n";
}
echo "    </tr>\r\n  </table>\r\n</form>\r\n";
$query = "SELECT a.LINE_ID as LINE_ID,b.PRODUCT_ID as PRODUCT_ID,b.PRODUCT_NAME as PRODUCT_NAME,\r\n                   c.SERVICE_ID as SERVICE_ID,c.SERVICE_NAME as SERVICE_NAME,a.TRANS_PRICE as TRANS_PRICE,\r\n                   a.TRANS_QTY as TRANS_QTY,a.TOTAL_PRICE as TOTAL_PRICE,a.PAYMENT as PAYMENT,IF(a.TOTAL_PRICE-a.PAYMENT<0,0,a.TOTAL_PRICE-a.PAYMENT) as QIANKUAN,a.MEMO as MEMO,a.TYPE as TYPE from CONTRACT_LINE 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           where CONTRACT_ID='".$CONTRACT_ID."' ";
$cursor = exequery( $connection, $query );
$VOTE_COUNT = 0;
$SUM_TRANS_QTY = 0;
$SUM_TOTAL_PRICE = 0;
$SUM_PAYMENT = 0;
$SUM_QIANKUAN = 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'];
	$PAYMENT = $ROW['PAYMENT'];
	$QIANKUAN = $ROW['QIANKUAN'];
	$MEMO = $ROW['MEMO'];
	$SUM_TRANS_QTY += $TRANS_QTY;
	$SUM_TOTAL_PRICE += $TOTAL_PRICE;
	$SUM_PAYMENT += $PAYMENT;
	$SUM_QIANKUAN += $QIANKUAN;
	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    </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 $PAYMENT;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $QIANKUAN;
	echo "</td>\r\n      <td nowrap align=\"center\">&nbsp;\r\n";
	if ( $querstr != "" )
	{
		$urlstr1 = str_replace( "%", "&", $querstr );
		echo "      <a href=\"index.php?LINE_ID=";
		echo $LINE_ID;
		echo "&CONTRACT_ID=";
		echo $CONTRACT_ID;
		echo "&querstr=";
		echo $querstr;
		echo "&CUR_PAGE=";
		echo $CUR_PAGE;
		echo "&ORDERFIELD=";
		echo $ORDERFIELD;
		echo "&ORDERTYPE=";
		echo $ORDERTYPE;
		echo "\">修改</a>\r\n      &nbsp;\r\n      <a href=\"javascript:delete_vote1('";
		echo $LINE_ID;
		echo "','";
		echo $CONTRACT_ID;
		echo "');\">删除</a>\r\n";
	}
	else
	{
		echo "    <a href=\"index.php?LINE_ID=";
		echo $LINE_ID;
		echo "&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 "&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 "\">修改</a>\r\n      &nbsp;\r\n    <a href=\"javascript:delete_vote('";
		echo $LINE_ID;
		echo "','";
		echo $CONTRACT_ID;
		echo "');\">删除</a>\r\n";
	}
	echo "\r\n      </td>\r\n    </tr>\r\n";
}
if ( 0 < $VOTE_COUNT )
{
	echo " <tr align=\"center\" class=\"TableControl\">\r\n  <td colspan=\"3\" nowrap>合计：</td>\r\n  <td nowrap align=\"center\">";
	echo $SUM_TRANS_QTY;
	echo "</td>\r\n  <td nowrap align=\"center\">";
	echo $SUM_TOTAL_PRICE;
	echo "</td>\r\n  <td nowrap align=\"center\">";
	echo $SUM_PAYMENT;
	echo "</td>\r\n  <td nowrap align=\"center\">";
	echo $SUM_QIANKUAN;
	echo "</td>\r\n  <td nowrap align=\"center\"></td>\r\n </tr>\r\n</table>\r\n";
}
echo "\r\n</body>\r\n</html>";
?>