📄 contractlist.php
字号:
$TYPENAME_COUNT=sizeof($TYPENAME_ARRAY);
if($TYPENAME_ARRAY[$TYPENAME_COUNT-1]=="")$TYPENAME_COUNT--;
for($I=0;$I<$TYPENAME_COUNT;$I++)
{
if($$FIELDNO1==$TYPEVALUE_ARRAY[$I])
{
?>
<?=$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--;
for($I=0;$I<$TYPENAME_COUNT;$I++)
{
$flag=0;
for($T=0;$T< $temp_ARRAY_count;$T++)
{
if($temp_ARRAY[$T]==$TYPEVALUE_ARRAY[$I])
{
?>
<?=$TYPENAME_ARRAY[$I]?>,
<?
}
}
}
}
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--;
for($I=0;$I<$TYPENAME_COUNT;$I++)
{
if($$FIELDNO1==$TYPEVALUE_ARRAY[$I])
{
?>
<?=$TYPENAME_ARRAY[$I]?>
<?
}
}
}
?>
</td>
</tr>
<?
}
}
?>
<tr>
<td nowrap class="TableHeader" colspan="4" align="left">
合同明细:
</td>
</tr>
<tr>
<td nowrap class="TableData" colspan="4" align="left">
<br>
<?
//============================显示合同明细=======================================
$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)
{
?>
<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>
<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";
?>
<tr class="<?=$TableLine?>">
<td nowrap align="center"><?=$PRODUCT_NAME?></td>
<td align="center"><?=$SERVICE_NAME?></td>
<td align="center"><?=$TRANS_PRICE?></td>
<td nowrap align="center"><?=$TRANS_QTY?></td>
<td nowrap align="center"><?=$TOTAL_PRICE?></td>
<td nowrap align="center"><?=$PAYMENT?></td>
<td nowrap align="center"><?=$QIANKUAN?></td>
</tr>
<?
}
if($VOTE_COUNT>0)
{
?>
<tr align="center" class="TableControl">
<td colspan="3" nowrap>合计：</td>
<td nowrap align="center"><?=$SUM_TRANS_QTY?></td>
<td nowrap align="center"><?=$SUM_TOTAL_PRICE?></td>
<td nowrap align="center"><?=$SUM_PAYMENT?></td>
<td nowrap align="center"><?=$SUM_QIANKUAN?></td>
</tr>
</table>
<?
}
else
{
Message("<br>提示","没有定义合同明细");
}
?>
<br>
</td>
</tr>
<tr>
<td nowrap class="TableHeader" colspan="4" align="left">
付款记录:
</td>
</tr>
<tr>
<td nowrap class="TableData" colspan="4" align="left">
<br>
<?
//============================显示付款记录=======================================
$query = "SELECT a.LINE_ID as LINE_ID,a.PRODUCT_ID as PRODUCT_ID,b.PRODUCT_NAME as PRODUCT_NAME,
a.SERVICE_ID as SERVICE_ID,c.SERVICE_NAME as SERVICE_NAME,a.PRICE as TRANS_PRICE,
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
from SALE_HISTORY 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_LINE d ON a.LINE_ID = d.LINE_ID
LEFT OUTER JOIN CONTRACT e ON d.CONTRACT_ID = e.CONTRACT_ID
LEFT OUTER JOIN USER f ON a.SALESMAN=f.USER_ID
LEFT OUTER JOIN CUSTOMER g ON a.CUSTOMER_ID=g.CUSTOMER_ID
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=$SUM_TRANS_QTY+$TRANS_QTY;
$SUM_TOTAL_PRICE=$SUM_TOTAL_PRICE+$TOTAL_PRICE;
if($VOTE_COUNT==1)
{
?>
<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>
<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";
?>
<tr class="<?=$TableLine?>">
<td nowrap align="center"><?=$PRODUCT_NAME?></td>
<td align="center"><?=$SERVICE_NAME?></td>
<td align="center"><?=$TRANS_PRICE?></td>
<td nowrap align="center"><?=$TRANS_QTY?></td>
<td nowrap align="center"><?=$TOTAL_PRICE?></td>
<td nowrap align="center"><?=$TRANS_DATE?></td>
<td nowrap align="center"><?=$CUSTOMER_NAME?></td>
<td nowrap align="center"><?=$SELLER?></td>
</tr>
<?
}
if($VOTE_COUNT>0)
{
?>
<tr align="center" class="TableControl">
<td colspan="3" nowrap>合计：</td>
<td nowrap align="center"><?=$SUM_TRANS_QTY?></td>
<td nowrap align="center"><?=$SUM_TOTAL_PRICE?></td>
<td nowrap align="center"></td>
<td nowrap align="center"></td>
<td nowrap align="center"></td>
</tr>
</table>
<?
}
else
{
Message("<br>提示","没有付款记录");
}
?>
<br>
</td>
</tr>
<tr>
<td nowrap class="TableControl" colspan="4" align="center">
<input type="button" value="关闭" onclick="window.close()" class="BigButton" name="button">
</td>
</tr>
</form>
</table>
</body>
</html>
<?
function GETALLDATE($CODE,$GETVALUE)
{
global $connection;
$query = "SELECT * from SYS_CODE where PARENT_NO='$CODE'";
$connection=OpenConnection();
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$CODE_NO=$ROW["CODE_NO"];
$CODE_NAME=$ROW["CODE_NAME"];
if ($CODE_NO==$GETVALUE)
{echo $CODE_NAME;}
}
}
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -