📄 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 LoadWindow2()
{
URL="service_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.all("TYPE").value=="PRO")
{
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);
}
}
if (document.all("TYPE").value=="SER")
{
if(document.form1.SER_NAME.value=="")
{ alert("服务名称不能为空！");
return (false);
}
if(document.form1.SER_ID.value=="")
{ alert("服务名称不能为空！");
return (false);
}
if(document.form1.TOTAL_PRICE.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 clear_dept2()
{
document.form1.SER_ID.value="";
document.form1.SER_NAME.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:215px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
function sel_change()
{
for(i=0;i<document.all("SERVICE_TYPE").length;i++)
{
el=document.all("SERVICE_TYPE").item(i);
if(el.checked)
{
val=el.value;
}
}
if(val=="0")
{
document.all("TYPE").value="PRO";
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")
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";
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";
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(LINE_ID,CONTRACT_ID)
{
msg='确认删除合同明细吗？';
if(window.confirm(msg))
{
URL="delete.php?LINE_ID="+LINE_ID+"&CONTRACT_ID="+CONTRACT_ID+"&CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&CONTRACT_TYPE=<?=$CONTRACT_TYPE?>&DATE_TYPE=<?=$DATE_TYPE?>&CONTRACT_NO=<?=$CONTRACT_NO?>&CONTRACT_NAME=<?=$CONTRACT_NAME?>&CONTRACT_LINKMAN1=<?=$CONTRACT_LINKMAN1?>&CONTRACT_LINKMAN2=<?=$CONTRACT_LINKMAN2?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&SIGN=<?=$SIGN?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>";
window.location=URL;
}
}
function delete_vote1(LINE_ID,CONTRACT_ID)
{
msg='确认删除合同明细吗？';
if(window.confirm(msg))
{
URL="delete.php?LINE_ID="+LINE_ID+"&CONTRACT_ID="+CONTRACT_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,
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
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 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"];
$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"];
$MEMO=$ROW["MEMO"];
$TYPE=$ROW["TYPE"];
}
}
else
{
$TYPE="PRO";
}
?>
<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 class="TableData" colspan="2" align="left">
<input type="radio" value="0" name='SERVICE_TYPE' id='SERVICE_TYPE1' <? if($LINE_ID==""){ echo "checked";}
else{ if($TYPE=="PRO") echo "checked";} ?> onclick="sel_change()"><label for="SERVICE_TYPE1">产 品</label>
<input type="radio" value="1" name='SERVICE_TYPE' id='SERVICE_TYPE2' <? if($TYPE=="SER" and $LINE_ID!=""){ echo "checked";}?> onclick="sel_change()"><label for="SERVICE_TYPE2">服 务</label>
</td>
</tr>
<tr id="PRO" style=<? if($LINE_ID==""){ echo "";}
else{ if($TYPE=="PRO") echo ""; else echo "display:none";} ?>>
<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 id="SER" style=<? if($LINE_ID==""){ echo "display:none";}
else{ if($TYPE=="SER") echo ""; else echo "display:none";} ?>>
<td nowrap class="TableData">服务：</td>
<td class="TableData">
<input type="hidden" name="SER_ID" value="<?=$SERVICE_ID?>">
<input type="text" name="SER_NAME" size="20" class="BigStatic" maxlength="20" value="<?=$SERVICE_NAME?>" readonly>
<input type="button" value="选 择" class="SmallButton" onClick="LoadWindow2()" title="选择" name="button">
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -