⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 contractlist.php

📁 通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(
💻 PHP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
			if ( $TYPENAME_ARRAY[$TYPENAME_COUNT - 1] == "" )
			{
				--$TYPENAME_COUNT;
			}
			$I = 0;
			for ( ;	$I < $TYPENAME_COUNT;	++$I	)
			{
				if ( $$FIELDNO1 == $TYPEVALUE_ARRAY[$I] )
				{
					echo "         ";
					echo $TYPENAME_ARRAY[$I];
				}
			}
		}
		if ( $STYPE == "C" )
		{
			$temp = str_replace( "，", ",", $$FIELDNO1 );
			$temp_ARRAY = explode( ",", $temp );
			$temp_ARRAY_count = sizeof( $temp_ARRAY );
			$TYPEVALUE = str_replace( "，", ",", $TYPEVALUE );
			$TYPEVALUE_ARRAY = explode( ",", $TYPEVALUE );
			$TYPENAME = str_replace( "，", ",", $TYPENAME );
			$TYPENAME_ARRAY = explode( ",", $TYPENAME );
			$TYPENAME_COUNT = sizeof( $TYPENAME_ARRAY );
			if ( $TYPENAME_ARRAY[$TYPENAME_COUNT - 1] == "" )
			{
				--$TYPENAME_COUNT;
			}
			$I = 0;
			for ( ;	$I < $TYPENAME_COUNT;	++$I	)
			{
				$flag = 0;
				$T = 0;
				for ( ;	$T < $temp_ARRAY_count;	++$T	)
				{
					if ( $temp_ARRAY[$T] == $TYPEVALUE_ARRAY[$I] )
					{
						echo "        ";
						echo $TYPENAME_ARRAY[$I];
						echo ",\r\n";
					}
				}
			}
		}
		if ( $STYPE == "R" )
		{
			$TYPEVALUE = str_replace( "，", ",", $TYPEVALUE );
			$TYPEVALUE_ARRAY = explode( ",", $TYPEVALUE );
			$TYPENAME = str_replace( "，", ",", $TYPENAME );
			$TYPENAME_ARRAY = explode( ",", $TYPENAME );
			$TYPENAME_COUNT = sizeof( $TYPENAME_ARRAY );
			if ( $TYPENAME_ARRAY[$TYPENAME_COUNT - 1] == "" )
			{
				--$TYPENAME_COUNT;
			}
			$I = 0;
			for ( ;	$I < $TYPENAME_COUNT;	++$I	)
			{
				if ( $$FIELDNO1 == $TYPEVALUE_ARRAY[$I] )
				{
					echo "        ";
					echo $TYPENAME_ARRAY[$I];
				}
			}
		}
		echo "\r\n    </td>\r\n </tr>\r\n";
	}
}
echo " <tr>\r\n    <td nowrap  class=\"TableHeader\" colspan=\"4\" align=\"left\">\r\n      合同明细: \r\n    </td>\r\n </tr>\r\n <tr>\r\n    <td nowrap  class=\"TableData\" colspan=\"4\" align=\"left\">\r\n    \t<br>\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 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    </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    </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 </tr>\r\n</table>\r\n";
}
else
{
	message( "<br>提示", "没有定义合同明细" );
}
echo "<br>\r\n    </td>\r\n </tr>\r\n <tr>\r\n    <td nowrap  class=\"TableHeader\" colspan=\"4\" align=\"left\">\r\n      付款记录: \r\n    </td>\r\n </tr>\r\n <tr>\r\n    <td nowrap  class=\"TableData\" colspan=\"4\" align=\"left\">\r\n    \t<br>\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;
$SUM_TRANS_QTY = 0;
$SUM_TOTAL_PRICE = 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'];
	$SUM_TRANS_QTY += $TRANS_QTY;
	$SUM_TOTAL_PRICE += $TOTAL_PRICE;
	if ( $VOTE_COUNT == 1 )
	{
		echo "<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";
	}
	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    </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\"></td>\r\n  <td nowrap align=\"center\"></td>\r\n  <td nowrap align=\"center\"></td>\r\n </tr>\r\n</table>\r\n";
}
else
{
	message( "<br>提示", "没有付款记录" );
}
echo "    \r\n    \t<br>\r\n    </td>\r\n </tr>\r\n <tr>\r\n    <td nowrap  class=\"TableControl\" colspan=\"4\" align=\"center\">\r\n        <input type=\"button\" value=\"关闭\"  onclick=\"window.close()\" class=\"BigButton\"  name=\"button\">&nbsp;\r\n    </td>\r\n </tr>\r\n </form>\r\n</table>\r\n\r\n</body>\r\n</html>\r\n";
?>
12

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -