📄 edit.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
?>
<html>
<head>
<title>销售记录编辑 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">
function LoadWindow1()
{
URL="../new/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="../new/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.form1.CUSTOMER_ID.value=="")
{ alert("客户名称不能为空！");
return (false);
}
if(document.form1.CUSTOMER_NAME.value=="")
{ alert("客户名称不能为空！");
return (false);
}
if(document.form1.CREATE_DATE.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);
}
if(document.form1.CUSTOMER_ID.value=="")
{ alert("客户名称不能为空！");
return (false);
}
if(document.form1.CUSTOMER_NAME.value=="")
{ alert("客户名称不能为空！");
return (false);
}
if(document.form1.CREATE_DATE.value=="")
{ alert("记录日期不能为空！");
return (false);
}
}
document.form1.submit();
}
function LoadWindow3()
{
URL="/general/sale_manage/crm/linkman/customer_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 clear_dept1()
{
document.form1.PRO_ID.value="";
document.form1.PRO_NAME.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="";
document.all("TOTAL_PRICE").value="";
}
}
</script>
</head>
<?
$query = "SELECT a.CUSTOMER_ID as CUSTOMER_ID,a.PRODUCT_ID as PRODUCT_ID,c.PRODUCT_NAME as PRODUCT_NAME,a.SERVICE_ID as SERVICE_ID,
d.SERVICE_NAME as SERVICE_NAME,a.TYPE as TYPE,a.DATE as DATE,a.PRICE as PRICE,a.AMT as AMT,a.TOTAL_PRICE as TOTAL_PRICE,a.SALESMAN as SELLER,
e.USER_NAME as SELLER_NAME,b.CUSTOMER_NAME as CUSTOMER_NAME,a.MEMO as MEMO,a.MEMO1 as MEMO1 from SALE_HISTORY a
LEFT OUTER JOIN CUSTOMER b ON a.CUSTOMER_ID=b.CUSTOMER_ID
LEFT OUTER JOIN PRODUCT c ON a.PRODUCT_ID=c.PRODUCT_ID and a.TYPE='PRO'
LEFT OUTER JOIN SERVICE d ON a.SERVICE_ID=d.SERVICE_ID and a.TYPE='SER'
LEFT OUTER JOIN USER e ON a.SALESMAN=e.USER_ID"." where HISTORY_ID='$HISTORY_ID'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$CUSTOMER_ID1=$ROW["CUSTOMER_ID"];
$PRODUCT_ID1=$ROW["PRODUCT_ID"];
$PRODUCT_NAME1=$ROW["PRODUCT_NAME"];
$SERVICE_ID1=$ROW["SERVICE_ID"];
$SERVICE_NAME1=$ROW["SERVICE_NAME"];
$TYPE1=$ROW["TYPE"];
$CREATE_DATE=$ROW["DATE"];
$PRICE1=$ROW["PRICE"];
$AMT1=$ROW["AMT"];
$TOTAL_PRICE1=$ROW["TOTAL_PRICE"];
$SELLER1=$ROW["SELLER"];
$SELLER_NAME1=$ROW["SELLER_NAME"];
$CUSTOMER_NAME1=$ROW["CUSTOMER_NAME"];
$MEMO1=$ROW["MEMO"];
$MEMO2=$ROW["MEMO1"];
}
?>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/histroy.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><span class="big3"> 销售记录信息编辑 </span>
</td>
</tr>
</table>
<br>
<table border="0" width="70%" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
<form enctype="multipart/form-data" action="update.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($TYPE1=="PRO") echo "checked"?> checked onclick="sel_change()"><label for="SERVICE_TYPE1">产 品</label>
<input type="radio" value="1" name='SERVICE_TYPE' id='SERVICE_TYPE2' <? if($TYPE1=="SER") echo "checked"?> onclick="sel_change()"><label for="SERVICE_TYPE2">服 务</label>
</td>
</tr>
<tr id="PRO" style=<? if($TYPE1=="PRO"){ echo "";}
else{echo "display:none";}?> >
<td nowrap class="TableData">产品：</td>
<td class="TableData">
<input type="hidden" name="PRO_ID" value="<?=$PRODUCT_ID1?>">
<input type="text" name="PRO_NAME" size="20" class="BigStatic" maxlength="20" readonly value="<?=$PRODUCT_NAME1?>">
<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($TYPE1=="SER"){ echo "";}
else{echo "display:none";}?>>
<td nowrap class="TableData">服务：</td>
<td class="TableData">
<input type="hidden" name="SER_ID" value="<?=$SERVICE_ID1?>">
<input type="text" name="SER_NAME" size="20" class="BigStatic" maxlength="20" readonly value="<?=$SERVICE_NAME1?>">
<input type="button" value="选 择" class="SmallButton" onClick="LoadWindow2()" title="选择" name="button">
<input type="button" value="清 空" class="SmallButton" onClick="clear_dept2()" title="清空" name="button">
</td>
</tr>
<tr id="PRI" style=<? if($TYPE1=="PRO"){ echo "";}
else{echo "display:none";}?>>
<td nowrap class="TableData">单价：</td>
<td class="TableData">
<input type="text" name="PRICE" size="20" maxlength="20" class="BigInput" value="<?=$PRICE1?>">
</td>
</tr>
<tr id="QTY" style=<? if($TYPE1=="PRO"){ echo "";}
else{echo "display:none";}?>>
<td nowrap class="TableData">数量：</td>
<td class="TableData">
<input type="text" name="TRANS_QTY" size="20" maxlength="20" class="BigInput" value="<?=$AMT1?>">
</td>
</tr>
<tr id="TOTALPRICE" style=<? if($TYPE1=="SER"){ echo "";}
else{echo "display:none";}?> >
<td nowrap class="TableData">总价：</td>
<td class="TableData">
<input type="text" name="TOTAL_PRICE" size="20" maxlength="20" class="BigInput" value="<?=$TOTAL_PRICE1?>">
</td>
</tr>
<tr>
<td nowrap class="TableData">客户名称： </td>
<td class="TableData">
<input type="hidden" name="CUSTOMER_ID" value="<?=$CUSTOMER_ID1?>">
<input type="text" name="CUSTOMER_NAME" class="BigStatic" size="15" maxlength="100" readonly value="<?=$CUSTOMER_NAME1?>">
<input type="button" value="选 择" class="SmallButton" onClick="LoadWindow3()" title="选择客户" name="button">
</td>
</tr>
<tr>
<td nowrap class="TableData">记录日期：</td>
<td class="TableData">
<input type="text" name="CREATE_DATE" class="BigStatic" readonly size="20" maxlength="20" class="BigInput" value="<?=$CREATE_DATE?>">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.CREATE_DATE');">
</td>
</tr>
<tr>
<td nowrap class="TableData">销售员：</td>
<td class="TableData">
<input type="hidden" name="SELLER" value="<?=$SELLER1?>" >
<input type="text" name="SELLER_NAME" class="BigStatic" readonly size="15" maxlength="100" value="<?=$SELLER_NAME1?>">
</td>
</tr>
<tr>
<td nowrap class="TableData">备注：</td>
<td class="TableData">
<textarea name="MEMO" cols="45" rows="5" class="BigInput"><?=$MEMO1?></textarea>
</td>
</tr>
<tr>
<td nowrap class="TableControl" colspan="2" align="center">
<input type="hidden" value="<?=$HISTORY_ID?>" name="HISTORY_ID">
<input type="hidden" name="TYPE" value="<?=$TYPE1?>">
<input type="hidden" value="CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&CUSTOMER_CODE =<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&ARE=<?=$ARE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&PAGE_START=<?=$PAGE_START?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>" name="QUERY_LIST">
<input type="button" value="确定" class="BigButton" onclick="CheckForm();">
<input type="button" value="返回" class="BigButton" onclick="location='index.php?CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&CUSTOMER_CODE =<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&ARE=<?=$ARE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&PAGE_START=<?=$PAGE_START?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>'">
</td>
</form>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -