📄 edit.php
字号:
<?
include_once("inc/auth.php");
?>
<html>
<head>
<title>修改客户服务记录</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">
function CheckForm()
{
if(document.form1.CUSTOMER_ID.value=="")
{
alert("客户名称不能为空！");
return (false);
}
if(document.form1.CONTACT_DATE.value=="")
{
alert("服务日期不能为空！");
return (false);
}
}
function LoadWindow()
{
URL="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 LoadWindow1()
{
if(document.all("CUSTOMER_ID").value=="")
{
alert("客户名称不能空！");
}
else
{
URL="linkman_select?CUSTOMER_ID="+document.all("CUSTOMER_ID").value;
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 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 chk(input,KC,KT,count)
{
var lstr="";
if(count==1)
{
if(document.all(KC).checked)
{
document.all(KT).value=document.all(KC).value;
}
else
{
document.all(KT).value="";
}
}
else
{
for(i=0;i<document.all(KC).length;i++)
{
el=document.all(KC).item(i);
if(el.checked)
{
val=el.value;
lstr+=val+",";
}
}
document.all(KT).value=lstr;
}
}
function LoadWindow2(kname,codeid)
{
URL="../new/codedefine.php?kname="+kname+"&codeid="+codeid;
myleft=(screen.availWidth-650)/2;
window.open(URL,"formul_edit","height=300,width=550,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<?
$query = "SELECT * from CONTACT where CONTACT_ID=$CONTACT_ID";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$CONTACT_TYPE1=$ROW["CONTACT_TYPE"];
$CUSTOMER_ID1=$ROW["CUSTOMER_ID"];
$CONTACT_CONTENT1=$ROW["CONTACT_CONTENT"];
$TIME_COST1=$ROW["TIME_COST"];
$MONEY_COST1=$ROW["MONEY_COST"];
$CONTACT_DATE1=$ROW["CONTACT_DATE"];
$LINKMAN_ID1=$ROW["LINKMAN_ID"];
$MEMO11=$ROW["MEMO"];
$MEMO12=$ROW["MEMO1"];
$SATISFY1=$ROW["SATISFY"];
$FEEDBACK1=$ROW["FEEDBACK"];
$USERDEF11=$ROW["USERDEF1"];
$USERDEF21=$ROW["USERDEF2"];
$USERDEF31=$ROW["USERDEF3"];
$USERDEF41=$ROW["USERDEF4"];
$USERDEF51=$ROW["USERDEF5"];
}
$query="SELECT CUSTOMER_NAME from CUSTOMER where CUSTOMER_ID='$CUSTOMER_ID1'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$CUSTOMER_NAME1=$ROW["CUSTOMER_NAME"];
}
$query="SELECT LINKMAN_NAME from LINKMAN where LINKMAN_ID='$LINKMAN_ID1'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$LINKMAN_NAME1=$ROW["LINKMAN_NAME"];
}
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_new.gif" align="absmiddle"><span class="big3"> 修改客户服务记录</span>
</td>
</tr>
</table>
<br>
<table border="0" cellspacing="1" width="450" class="small" bgcolor="#000000" cellpadding="3" align="center" >
<form action="update.php" method="post" name="form1" onsubmit="return CheckForm();">
<tr>
<td nowrap class="TableHeader" colspan="4" align="left">
客户服务基本信息：
</td>
</tr>
<tr>
<td nowrap class="TableData">服务类型： </td>
<td class="TableData">
<select name="CONTACT_TYPE" class="BigSelect">
<?
GETALLDATE("CONTACT_TYPE",$CONTACT_TYPE1);
?>
</select>
<a href="javascript:LoadWindow2('CONTACT_TYPE','CONTACT_TYPE');"><img src="/images/edit1.gif" align="absmiddle" border=0 title="客户来源定义"></a>
</td>
<td nowrap class="TableData">服务日期： </td>
<td nowrap class="TableData">
<input type="text" name="CONTACT_DATE" class="BigInput" size="15" maxlength="10" value="<?=$CONTACT_DATE1?>">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.CONTACT_DATE');">
</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="LoadWindow()" title="选择客户" name="button">
</td>
<td nowrap class="TableData">联系人： </td>
<td nowrap class="TableData">
<input type="hidden" name="LINKMAN_ID" value="<?=$LINKMAN_ID1?>">
<input type="text" name="LINKMAN_NAME" class="BigStatic" size="15" maxlength="100" value="<?=$LINKMAN_NAME1?>">
<input type="button" value="选 择" class="SmallButton" onClick="LoadWindow1()" title="选择联系人" name="button">
</td>
</tr>
<tr>
<td nowrap class="TableData">服务预估成本： </td>
<td class="TableData">
<input type="text" name="MONEY_COST" class="BigInput" size="15" maxlength="100" value="<?=$MONEY_COST1?>">元
</td>
<td nowrap class="TableData">时间成本： </td>
<td nowrap class="TableData">
<input type="text" name="TIME_COST" class="BigInput" size="15" maxlength="100" value="<?=$TIME_COST1?>">小时
</td>
</tr>
<tr>
<td nowrap class="TableData">服务内容描述：</td>
<td nowrap class="TableData" colspan="3">
<textarea cols=57 rows=3 name="CONTACT_CONTENT" class="BigInput" wrap="yes"><?=$CONTACT_CONTENT1?></textarea>
</td>
</tr>
<tr>
<td nowrap class="TableHeader" colspan="4" align="left">
客户反馈：
</td>
</tr>
<tr>
<td nowrap class="TableData">客户满意度： </td>
<td nowrap class="TableData" colspan="3">
<select name="SATISFY" class="BigSelect">
<option value="" <? if($SATISFY1=="") echo "selected";?>></option>
<option value=01 <? if($SATISFY1=="01") echo "selected";?>>很满意</option>
<option value=02 <? if($SATISFY1=="02") echo "selected";?>>比较满意</option>
<option value=3 <? if($SATISFY1=="3") echo "selected";?>>不满意</option>
<option value=05 <? if($SATISFY1=="05") echo "selected";?>>很不满意</option>
</select>
</td>
</tr>
<tr>
<td nowrap class="TableData">客户反馈意见： </td>
<td nowrap class="TableData" colspan="3">
<textarea cols=57 rows=3 name="FEEDBACK" class="BigInput" wrap="yes"><?=$FEEDBACK1?></textarea>
</td>
</tr>
<tr>
<td nowrap class="TableHeader" colspan="4" align="left">
描述：
</td>
</tr>
<tr>
<td nowrap class="TableData">备注1： </td>
<td nowrap class="TableData" colspan="3">
<textarea cols=57 rows=3 name="MEMO" class="BigInput" wrap="yes"><?=$MEMO11?></textarea>
</td>
</tr>
<tr>
<td nowrap class="TableData">备注2： </td>
<td nowrap class="TableData" colspan="3">
<textarea cols=57 rows=3 name="MEMO1" class="BigInput" wrap="yes"><?=$MEMO12?></textarea>
</td>
</tr>
<?
$count=0;
$connection=OpenConnection();
$query = "select count(*) from FIELDSETTING where TABLENAME='CUSTOMER'";
$cursor=exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$count=$ROW[0];
}
if($count>0)
{
?>
<tr>
<td nowrap class="TableHeader" colspan="4" align="left">
用户自定义字段：
</td>
</tr>
<?
$query = "select * from FIELDSETTING where TABLENAME='CONTACT' ORDER BY ORDERNO ASC ";
$cursor=exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$FIELDNAME=$ROW["FIELDNAME"];
$ORDERNO=$ROW["ORDERNO"];
$STYPE=$ROW["STYPE"];
$TYPENAME=$ROW["TYPENAME"];
$TYPEVALUE=$ROW["TYPEVALUE"];
$TYPECODE=$ROW["TYPECODE"];
$ISQUERY=$ROW["ISQUERY"];
$ISGROUY=$ROW["ISGROUY"];
$FIELDNAME=$ROW["FIELDNAME"];
$FIELDNO=$ROW["FIELDNO"];
$FIELDNO1=$FIELDNO."1";
?>
<tr>
<td nowrap class="TableData"><?=$FIELDNAME?>：</td>
<td nowrap class="TableData" colspan="3">
<?
if($STYPE=="T")
{
?>
<input type="text" name='<?=$FIELDNO?>' class="BigInput" size="33" maxlength="25" value="<?=$$FIELDNO1?>">
<?
}
if($STYPE=="MT")
{
?>
<textarea cols=37 rows=3 name='<?=$FIELDNO?>' class="BigInput" wrap="yes"><?=$$FIELDNO1?></textarea>
<?
}
if($STYPE=="D")
{
$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--;
?>
<select name='<?=$FIELDNO?>' class="BigSelect">
<?
for($I=0;$I<$TYPENAME_COUNT;$I++)
{
?>
<option value="<?=$TYPEVALUE_ARRAY[$I]?>" <?if($$FIELDNO1==$TYPEVALUE_ARRAY[$I]) echo "selected";?>><?=$TYPENAME_ARRAY[$I]?></option>
<?
}
}
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--;
?>
<input type="hidden" name='<?=$FIELDNO?>' value="<?=$temp?>">
<?
for($I=0;$I<$TYPENAME_COUNT;$I++)
{
$flag=0;
for($T=0;$T< $temp_ARRAY_count;$T++)
{
if($temp_ARRAY[$T]==$TYPEVALUE_ARRAY[$I])$flag=1;
}
?>
<input type="checkbox" name='C<?=$FIELDNO?>' id='C<?=$FIELDNO?><?=$I?>' value="<?=$TYPEVALUE_ARRAY[$I]?>" <? if($flag==1) echo "checked";?> onclick="return chk(this,'C<?=$FIELDNO?>','<?=$FIELDNO?>','<?=$TYPENAME_COUNT?>');"><label for="C<?=$FIELDNO?><?=$I?>"><?=$TYPENAME_ARRAY[$I]?></label>
<?
}
}
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++)
{
?>
<input type="radio" name='<?=$FIELDNO?>' id='<?=$FIELDNO?><?=$I?>' value="<?=$TYPEVALUE_ARRAY[$I]?>" <? if($$FIELDNO1==$TYPEVALUE_ARRAY[$I]) echo "checked";?> ><label for="<?=$FIELDNO?><?=$I?>"><?=$TYPENAME_ARRAY[$I]?></label>
<?
}
}
?>
</td>
</tr>
<?
}
}
?>
<tr>
<td nowrap class="TableControl" colspan="4" align="center">
<?
if($querstr!="")
{
$urlstr1=str_replace("%","&",$querstr);
?>
<input type="hidden" value="<?=$CONTACT_ID?>" name="CONTACT_ID">
<input type="hidden" value="<?=$querstr?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>" name="QUERY_LIST">
<input type="hidden" value="ad_query" name="FLAGSOURCE">
<input type="submit" value="确定" class="BigButton" title="修改客户服务记录" name="button">
<input type="button" value="返回" class="BigButton" onclick="location='ad_query/list.php?<?=$urlstr1?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>'">
<?
}
else
{
?>
<input type="hidden" value="<?=$CONTACT_ID?>" name="CONTACT_ID">
<input type="hidden" value="YEAR=<?=$YEAR?>&MONTH=<?=$MONTH?>&BEGIN_DAY=<?=$BEGIN_DAY?>&END_DAY=<?=$END_DAY?>&CONTACT_TYPE=<?=$CONTACT_TYPE?>&KIND=<?=$KIND?>&CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&CONTACT_CONTENT=<?=$CONTACT_CONTENT?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>" name="QUERY_LIST">
<input type="submit" value="确定" class="BigButton" title="修改客户服务记录" name="button">
<input type="button" value="返回" class="BigButton" onclick="location='index.php?YEAR=<?=$YEAR?>&MONTH=<?=$MONTH?>&BEGIN_DAY=<?=$BEGIN_DAY?>&END_DAY=<?=$END_DAY?>&CONTACT_TYPE=<?=$CONTACT_TYPE?>&KIND=<?=$KIND?>&CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&CONTACT_CONTENT=<?=$CONTACT_CONTENT?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>'">
<?
}
?>
</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 "<option value=".$CODE_NO." selected>".$CODE_NAME."</option>";}
else
{echo "<option value=".$CODE_NO." >".$CODE_NAME."</option>";}
}
}
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -