index.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 710 行 · 第 1/2 页
PHP
710 行
<?
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">
';
echo '<s';
echo 'cript Language="JavaScript">
function CheckForm()
{
if(document.all("HISTORY_ID").value=="" && document.all("TYPE").value=="")
{
alert("请选择合同明细！！");
return (false);
}
if (document.all("TYPE").value=="PRO")
{
if(document.all("TRANS_QTY").value=="")
{
alert("交付数量不能空！！");
return (false);
}
}
if (';
echo 'document.all("TYPE").value=="SER")
{
if(document.all("TOTAL_PRICE").value=="")
{
alert("本次付款额不能空！！");
return (false);
}
}
document.form1.submit();
}
function checknum(p)
{
var l = p.length;
var count=0;
for(var i=0; i<l; i++)
{
var digit = p.charAt(i);
if(digit == "." )
{
++count;
if(count>1)
{
ret';
echo 'urn 0;
}
}
else if(digit < "0" || digit > "9")
{
return 0;
}
}
return 1;
}
function select_value(LINE_ID,PRODUCT_ID,PRODUCT_NAME,SERVICE_ID,SERVICE_NAME,TRANS_PRICE,PTYPE)
{
if(PTYPE=="PRO")
{
document.all("TYPE").value="PRO";
document.all("LINE_ID").value=LINE_ID;
document.all("PRO_ID").value=PRODUCT_ID;
document.all("';
echo 'PRO_NAME").value=PRODUCT_NAME;
document.all("PRICE").value=TRANS_PRICE;
document.all("OP").value="ADD";
document.all("SER").style.display="none";
document.all("TOTALPRICE").style.display="";
if(document.all("PRO").style.display=="none")
document.all("PRO").style.display="";
if(document.all("PRI").style.display=="none")
document.all("PR';
echo 'I").style.display="";
if(document.all("QTY").style.display=="none")
document.all("QTY").style.display="";
document.all("SER_ID").value="";
document.all("SER_NAME").value="";
document.all("TOTAL_PRICE").value="";
}
else
{
document.all("TYPE").value="SER";
document.all("LINE_ID").value=LINE_ID;
document.all("SER_ID").value';
echo '=SERVICE_ID;
document.all("SER_NAME").value=SERVICE_NAME;
document.all("TOTAL_PRICE").value="";
document.all("OP").value="ADD";
if(document.all("SER").style.display=="none")
document.all("SER").style.display="";
if(document.all("TOTALPRICE").style.display=="none")
document.all("TOTALPRICE").style.display="";
document.all("PRI").style';
echo '.display="none";
document.all("QTY").style.display="none";
document.all("PRO").style.display="none";
document.all("PRO_ID").value="";
document.all("PRO_NAME").value="";
document.all("PRICE").value="";
document.all("TRANS_QTY").value="";
}
}
function select_value1(LINE_ID,PRODUCT_ID,PRODUCT_NAME,SERVICE_ID,SERVICE_NAME,TRANS_PRICE,PTYPE,TRAN';
echo 'S_QTY,TOTAL_PRICE,HISTORY_ID)
{
document.all("HISTORY_ID").value=HISTORY_ID;
if(PTYPE=="PRO")
{
document.all("TYPE").value="PRO";
document.all("LINE_ID").value=LINE_ID;
document.all("PRO_ID").value=PRODUCT_ID;
document.all("PRO_NAME").value=PRODUCT_NAME;
document.all("PRICE").value=TRANS_PRICE;
document.all("TRANS_QTY").value=TRANS_QTY;
';
echo '
document.all("OP").value="MOD";
document.all("SER").style.display="none";
document.all("TOTALPRICE").style.display="none";
if(document.all("PRO").style.display=="none")
document.all("PRO").style.display="";
if(document.all("PRI").style.display=="none")
document.all("PRI").style.display="";
if(document.all("QTY").style.display=="none")
';
echo ' document.all("QTY").style.display="";
document.all("SER_ID").value="";
document.all("SER_NAME").value="";
document.all("TOTAL_PRICE").value="";
}
else
{
document.all("TYPE").value="SER";
document.all("LINE_ID").value=LINE_ID;
document.all("SER_ID").value=SERVICE_ID;
document.all("SER_NAME").value=SERVICE_NAME;
docu';
echo 'ment.all("TOTAL_PRICE").value=TOTAL_PRICE;
document.all("OP").value="MOD";
if(document.all("SER").style.display=="none")
document.all("SER").style.display="";
if(document.all("TOTALPRICE").style.display=="none")
document.all("TOTALPRICE").style.display="";
document.all("PRI").style.display="none";
document.all("QTY").style.display="none";
';
echo ' document.all("PRO").style.display="none";
document.all("PRO_ID").value="";
document.all("PRO_NAME").value="";
document.all("PRICE").value="";
document.all("TRANS_QTY").value="";
}
}
function delete_vote(HISTORY_ID,CONTRACT_ID)
{
msg=\'确认删除该合同付款记录吗？\';
if(window.confirm(msg))
{
URL="delete.php?HISTORY_ID="+HISTORY_ID+"&CONTRACT_';
echo 'ID="+CONTRACT_ID+"&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 '";
window.location=URL;
}
}
function delete_vote1(HISTORY_ID,CONTRACT_ID)
{
msg=\'确认删除该合同付款记录吗？\';
if(window.confirm(msg))
{
URL="delete.php?HISTORY_ID="+HISTORY_ID+"&CONTRACT_ID="+CONTRACT_ID+"&querstr="+document.all("querstr").value;;
window.location=URL;
}
}
</script>
</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,a.MEMO as MEMO,a.TYPE as TYPE,d.CUSTOMER_ID as CUSTOMER_ID,SUM(e.TOTAL_PRICE) as PAYMENT,SUM(e.AMT) as PAYMENTQTY 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\'
LEFT OUTER JOIN CONTRACT d ON a.CONTRACT_ID = d.CONTRACT_ID
LEFT OUTER JOIN SALE_HISTORY e ON a.LINE_ID=e.LINE_ID
where a.CONTRACT_ID=\'').$CONTRACT_ID).'\' GROUP BY a.LINE_ID order by a.TYPE 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'];
$PAYMENT = $ROW['PAYMENT'];
$PAYMENTQTY = $ROW['PAYMENTQTY'];
$MEMO = $ROW['MEMO'];
$TYPE = $ROW['TYPE'];
$CUSTOMER_ID = $ROW['CUSTOMER_ID'];
if (($VOTE_COUNT == 1))
{
echo ' <table width="95%" border="0" cellspacing="0" cellpadding="0" height="3">
<tr>
<td background="/images/dian1.gif" width="100%"></td>
</tr>
</table>
<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>
<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 $PAYMENTQTY;
echo '</td>
<td nowrap align="center">';
echo $TOTAL_PRICE;
echo '</td>
<td nowrap align="center">';
echo $PAYMENT;
echo '</td>
<td nowrap align="center">
<a href="javascript:select_value(\'';
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 '\');"> 选择</a>
</td>
</tr>
';
}
echo '</table>
<br>
<table border="0" width="50%" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
<form enctype="multipart/form-data" action="add.php" method="post" name="form1">
<tr id="PRO">
<td nowrap class="TableData">产品名称：</td>
<td class="TableData">
<input type="hidden" name="PRO_ID">
<input type="text" name="PRO_NAME" size="20';
echo '" class="BigStatic" maxlength="20" readonly>
</td>
</tr>
<tr id="SER">
<td nowrap class="TableData">服务名称：</td>
<td class="TableData">
<input type="hidden" name="SER_ID">
<input type="text" name="SER_NAME" size="20" class="BigStatic" maxlength="20" readonly>
</td>
</tr>
<tr id="PRI">
<td nowrap class="TableData">单价：</td>
';
echo ' <td class="TableData">
<input type="text" name="PRICE" size="20" maxlength="20" class="BigStatic" class="BigInput" readonly>
</td>
</tr>
<tr id="QTY">
<td nowrap class="TableData">本次交付数量：</td>
<td class="TableData">
<input type="text" name="TRANS_QTY" size="20" maxlength="20" class="BigInput">
</td>
</tr>
<tr id="TOTALPRICE">
<td no';
echo 'wrap class="TableData">本次付款额：</td>
<td class="TableData">
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?