📄 index.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>订单明细</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">
function LoadWindow1()
{
URL="product_select";
loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
window.showModalDialog(URL,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:320px;dialogHeight:245px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
function CheckForm()
{
if(document.form1.PRO_NAME.value=="")
{ alert("产品名称不能为空！");
return (false);
}
if(document.form1.PRO_ID.value=="")
{ alert("产品名称不能为空！");
return (false);
}
if(document.form1.PRICE.value=="")
{ alert("单价不能为空！");
return (false);
}
if(document.form1.TRANS_QTY.value=="")
{ alert("数量不能为空！");
return (false);
}
document.form1.submit();
}
function clear_dept1()
{
document.form1.PRO_ID.value="";
document.form1.PRO_NAME.value="";
document.form1.PRICE.value="";
}
function td_calendar(fieldname)
{
myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
mytop=document.body.scrollTop+event.clientY-event.offsetY+140;
window.showModalDialog("/inc/calendar.php?FIELDNAME="+fieldname,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:205px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
function delete_vote(LINE_ID,ORDER_ID)
{
msg='确认删除订单明细吗？';
if(window.confirm(msg))
{
URL="delete.php?LINE_ID="+LINE_ID+"&ORDER_ID="+ORDER_ID+"&PROVIDER_NAME=<?=$PROVIDER_NAME?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&PROVIDER_AREA=<?=$PROVIDER_AREA?>&ORDER_TYPE=<?=$ORDER_TYPE?>&ORDER_NO=<?=$ORDER_NO?>&ORDER_NAME=<?=$ORDER_NAME?>&RECIVER=<?=$RECIVER?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&CREATOR=<?=$CREATOR?>&DATE_TYPE=<?=$DATE_TYPE?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>";
window.location=URL;
}
}
function delete_vote1(LINE_ID,ORDER_ID)
{
msg='确认删除订单明细吗？';
if(window.confirm(msg))
{
URL="delete.php?LINE_ID="+LINE_ID+"&ORDER_ID="+ORDER_ID+"&querstr="+document.all("querstr").value;;
window.location=URL;
}
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<?
if($LINE_ID!="")
{
$query = "SELECT a.LINE_ID as LINE_ID,b.PRODUCT_ID as PRODUCT_ID,b.PRODUCT_NAME as PRODUCT_NAME,
a.TRANS_PRICE as TRANS_PRICE,
a.TRANS_QTY as TRANS_QTY,a.MEMO as MEMO
from ORDER_LINE a
LEFT OUTER JOIN PRODUCT b ON a.PRODUCT_ID=b.PRODUCT_ID
where a.LINE_ID=$LINE_ID";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$LINE_ID=$ROW["LINE_ID"];
$PRODUCT_ID=$ROW["PRODUCT_ID"];
$PRODUCT_NAME=$ROW["PRODUCT_NAME"];
$TRANS_PRICE=$ROW["TRANS_PRICE"];
$TRANS_QTY=$ROW["TRANS_QTY"];
$MEMO=$ROW["MEMO"];
}
}
?>
<br>
<table border="0" width="70%" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
<form enctype="multipart/form-data" action="add.php" method="post" name="form1">
<tr>
<td nowrap class="TableData">产品：</td>
<td class="TableData">
<input type="hidden" name="PRO_ID" value="<?=$PRODUCT_ID?>">
<input type="text" name="PRO_NAME" size="20" class="BigStatic" maxlength="20" value="<?=$PRODUCT_NAME?>" readonly>
<input type="button" value="选 择" class="SmallButton" onClick="LoadWindow1()" title="选择" name="button">
<input type="button" value="清 空" class="SmallButton" onClick="clear_dept1()" title="清空" name="button">
</td>
</tr>
<tr>
<td nowrap class="TableData">单价：</td>
<td class="TableData">
<?
if ($TRANS_PRICE=="")
{
?>
<input type="text" name="PRICE" size="20" maxlength="20" class="BigInput" value="0.0">
<?
}
else
{
?>
<input type="text" name="PRICE" size="20" maxlength="20" class="BigInput" value="<?=$TRANS_PRICE?>">
<?
}
?>
</td>
</tr>
<tr>
<td nowrap class="TableData">数量：</td>
<td class="TableData">
<input type="text" name="TRANS_QTY" size="20" maxlength="20" class="BigInput" value="<?=$TRANS_QTY?>">
</td>
</tr>
<tr>
<td nowrap class="TableData">备注：</td>
<td class="TableData">
<textarea name="MEMO" cols="45" rows="5" class="BigInput"><?=$MEMO?></textarea>
</td>
</tr>
<tr align="center" class="TableControl">
<?
if($querstr!="")
{
$urlstr1=str_replace("%","&",$querstr);
?>
<td colspan="2" nowrap>
<input type="hidden" name="ORDER_ID" value="<?=$ORDER_ID?>">
<input type="hidden" name="LINE_ID" value="<?=$LINE_ID?>">
<input type="hidden" name="querstr" value="<?=$querstr?>">
<input type="hidden" value="ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>" name="QUERY_LIST">
<input type="hidden" value="ad_query" name="FLAGSOURCE">
<input type="button" value="确认" class="BigButton" onclick="CheckForm();">
<?
if($LINE_ID!="")
{
?>
<input type="button" value="取消" class="BigButton" onclick="location='index.php?ORDER_ID=<?=$ORDER_ID?>&querstr=<?=$querstr?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>'">
<?
}
?>
<input type="button" value="返回" class="BigButton" onclick="location='../ad_query/list.php?<?=$urlstr1?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>'">
</td>
<?
}
else
{
?>
<td colspan="2" nowrap>
<input type="hidden" name="ORDER_ID" value="<?=$ORDER_ID?>">
<input type="hidden" name="LINE_ID" value="<?=$LINE_ID?>">
<input type="hidden" value="ORDER_ID=<?=$ORDER_ID?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&PROVIDER_AREA=<?=$PROVIDER_AREA?>&ORDER_TYPE=<?=$ORDER_TYPE?>&ORDER_NO=<?=$ORDER_NO?>&ORDER_NAME=<?=$ORDER_NAME?>&RECIVER=<?=$RECIVER?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&CREATOR=<?=$CREATOR?>&DATE_TYPE=<?=$DATE_TYPE?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>" name="QUERY_LIST">
<input type="button" value="确认" class="BigButton" onclick="CheckForm();">
<?
if($LINE_ID!="")
{
?>
<input type="button" value="取消" class="BigButton" onclick="location='index.php?ORDER_ID=<?=$ORDER_ID?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&PROVIDER_AREA=<?=$PROVIDER_AREA?>&ORDER_TYPE=<?=$ORDER_TYPE?>&ORDER_NO=<?=$ORDER_NO?>&ORDER_NAME=<?=$ORDER_NAME?>&RECIVER=<?=$RECIVER?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&CREATOR=<?=$CREATOR?>&DATE_TYPE=<?=$DATE_TYPE?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>'">
<?
}
?>
<input type="button" value="返回" class="BigButton" onclick="location='../?ORDER_ID=<?=$ORDER_ID?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&PROVIDER_AREA=<?=$PROVIDER_AREA?>&ORDER_TYPE=<?=$ORDER_TYPE?>&ORDER_NO=<?=$ORDER_NO?>&ORDER_NAME=<?=$ORDER_NAME?>&RECIVER=<?=$RECIVER?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&CREATOR=<?=$CREATOR?>&DATE_TYPE=<?=$DATE_TYPE?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>'">
</td>
<?
}
?>
</tr>
</table>
</form>
<?
//============================显示合同明细=======================================
$query = "SELECT a.LINE_ID as LINE_ID,b.PRODUCT_ID as PRODUCT_ID,b.PRODUCT_NAME as PRODUCT_NAME,
a.TRANS_PRICE as TRANS_PRICE,
a.TRANS_QTY as TRANS_QTY,a.PAYMENT as PAYMENT,a.MEMO as MEMO,
b.PRODUCT_CODE as PRODUCT_CODE,a.TRANS_PRICE*a.TRANS_QTY as TOTALPRICE,b.PRODUCT_TYPE as PRODUCT_TYPE
from ORDER_LINE a
LEFT OUTER JOIN PRODUCT b ON a.PRODUCT_ID = b.PRODUCT_ID
where a.ORDER_ID='$ORDER_ID' ";
$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"];
$TRANS_PRICE=$ROW["TRANS_PRICE"];
$TRANS_QTY=$ROW["TRANS_QTY"];
$PAYMENT=$ROW["PAYMENT"];
$MEMO=$ROW["MEMO"];
$PRODUCT_CODE=$ROW["PRODUCT_CODE"];
$PRODUCT_TYPE=$ROW["PRODUCT_TYPE"];
$TOTAL_PRICE=$ROW["TOTALPRICE"];
$SUM_TRANS_QTY=$SUM_TRANS_QTY+$TRANS_QTY;
$SUM_TOTAL_PRICE=$SUM_TOTAL_PRICE+$TOTAL_PRICE;
if($VOTE_COUNT==1)
{
?>
<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"><span 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>
<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"><?=$PRODUCT_CODE?></td>
<td align="center"><?=$PRODUCT_TYPE?></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">
<?
if($querstr!="")
{
$urlstr1=str_replace("%","&",$querstr);
?>
<a href="index.php?LINE_ID=<?=$LINE_ID?>&ORDER_ID=<?=$ORDER_ID?>&querstr=<?=$querstr?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>">修改</a>
<a href="javascript:delete_vote1('<?=$LINE_ID?>','<?=$ORDER_ID?>');">删除</a>
<?
}
else
{
?>
<a href="index.php?LINE_ID=<?=$LINE_ID?>&ORDER_ID=<?=$ORDER_ID?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&PROVIDER_AREA=<?=$PROVIDER_AREA?>&ORDER_TYPE=<?=$ORDER_TYPE?>&ORDER_NO=<?=$ORDER_NO?>&ORDER_NAME=<?=$ORDER_NAME?>&RECIVER=<?=$RECIVER?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&CREATOR=<?=$CREATOR?>&DATE_TYPE=<?=$DATE_TYPE?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>">修改</a>
<a href="javascript:delete_vote('<?=$LINE_ID?>','<?=$ORDER_ID?>');">删除</a>
<?
}
?>
</td>
</tr>
<?
}
if($VOTE_COUNT>0)
{
?>
<tr align="center" class="TableControl">
<td colspan="4" nowrap>合计：</td>
<td nowrap align="center"><?=$SUM_TRANS_QTY?></td>
<td nowrap align="center"><?=$SUM_TOTAL_PRICE?></td>
<td nowrap align="center"></td>
</tr>
</table>
<?
}
?>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -