linelist.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 132 行
PHP
132 行
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
echo '
<html>
<head>
<title>合同明细</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
$query = (((''.'SELECT a.LINE_ID as LINE_ID,b.PRODUCT_ID as PRODUCT_ID,b.PRODUCT_NAME as PRODUCT_NAME,
c.SERVICE_ID as SERVICE_ID,c.SERVICE_NAME as SERVICE_NAME,a.TRANS_PRICE as TRANS_PRICE,
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
LEFT OUTER JOIN PRODUCT b ON a.PRODUCT_ID = b.PRODUCT_ID AND a.TYPE=\'PRO\'
LEFT OUTER JOIN SERVICE c ON a.SERVICE_ID = c.SERVICE_ID AND a.TYPE=\'SER\'
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 = ($SUM_TRANS_QTY + $TRANS_QTY);
$SUM_TOTAL_PRICE = ($SUM_TOTAL_PRICE + $TOTAL_PRICE);
$SUM_PAYMENT = ($SUM_PAYMENT + $PAYMENT);
$SUM_QIANKUAN = ($SUM_QIANKUAN + $QIANKUAN);
if (($VOTE_COUNT == 1))
{
echo ' <table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_open.gif" WIDTH="22" HEIGHT="22" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 合同明细</span>
</td>
</tr>
</table>
<br>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader">
<td nowrap align="center">产品名称</td>
<td nowrap align="center">服务名称</td>
<td nowrap align="center">交易单价</td>
<td nowrap align="center">交易数量</td>
';
echo ' <td nowrap align="center">总价</td>
<td nowrap align="center">已付款数</td>
<td nowrap align="center">欠款数</td>
</tr>
';
}
if ((($VOTE_COUNT % 2) == 1))
{
$TableLine = 'TableLine1';
}
else
{
$TableLine = 'TableLine2';
}
echo ' <tr class="';
echo $TableLine;
echo '">
<td nowrap align="center">';
echo $PRODUCT_NAME;
echo '</td>
<td align="center">';
echo $SERVICE_NAME;
echo '</td>
<td align="center">';
echo $TRANS_PRICE;
echo '</td>
<td nowrap align="center">';
echo $TRANS_QTY;
echo '</td>
<td nowrap align="center">';
echo $TOTAL_PRICE;
echo '</td>
<td nowrap align="center">';
echo $PAYMENT;
echo '</td>
<td nowrap align="center">';
echo $QIANKUAN;
echo '</td>
</tr>
';
}
if ((0 < $VOTE_COUNT))
{
echo ' <tr align="center" class="TableControl">
<td colspan="3" nowrap>合计：</td>
<td nowrap align="center">';
echo $SUM_TRANS_QTY;
echo '</td>
<td nowrap align="center">';
echo $SUM_TOTAL_PRICE;
echo '</td>
<td nowrap align="center">';
echo $SUM_PAYMENT;
echo '</td>
<td nowrap align="center">';
echo $SUM_QIANKUAN;
echo '</td>
</tr>
</table>
';
}
else
{
message ('<br>提示', '没有定义合同明细');
}
echo '<br>
<div align="center">
<input type="button" value="关闭" class="BigButton" onclick="window.close()">
</div>
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?