📄 index.php
字号:
<?
function getalldate ($CODE)
{
global $connection;
$query = (((''.'SELECT * from SYS_CODE where PARENT_NO=\'').$CODE).'\'');
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$CODE_NO = $ROW['CODE_NO'];
$CODE_NAME = $ROW['CODE_NAME'];
echo (((('<option value='.$CODE_NO).'>').$CODE_NAME).'</option>');
}
}
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
echo '<html>
<head>
<title>新建客户服务记录</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript Language="JavaScript">
function show_detail(CONTACT_ID)
{
URL="showdetail.php?CONTACT_ID="+CONTACT_ID;
myleft=(screen.availWidth-650)/2;
window.open(URL,"formul_edit","height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
function CheckForm()
{
if(document.form1.CUSTOMER_ID.value=="")
{
alert("客户';
echo '名称不能为空！");
return (false);
}
if(document.form1.CONTACT_DATE.value=="")
{
alert("客户服务日期不能为空！");
return (false);
}
}
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="+';
echo '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
';
echo ' {
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="/module/crm/codedefine.php?kname="+kname+"&codeid="+codeid;
myleft=(screen.availWidth-650)/2;
window.open(URL,"fo';
echo 'rmul_edit","height=300,width=550,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
function delete_customer(CONTACT_ID)
{
msg=\'确认要删除该服务记录吗？\';
if(window.confirm(msg))
{
URL="delete.php?LINKMAN_ID=';
echo $LINKMAN_ID;
echo '&CUSTOMER_NAME=';
echo $CUSTOMER_NAME;
echo '&CUSTOMER_CODE=';
echo $CUSTOMER_CODE;
echo '&CUSTOMER_SHORT=';
echo $CUSTOMER_SHORT;
echo '&LINKMAN_NAME=';
echo $LINKMAN_NAME;
echo '&ADD_HOME=';
echo $ADD_HOME;
echo '&SEX=';
echo $SEX;
echo '&CUR_PAGE=';
echo $CUR_PAGE;
echo '&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&CONTACT_ID=" + CONTACT_ID;
window.location=URL;
}
}
</script>
</head>
<body class="bodycolor" topmargin="5">
';
$query = (((''.'select LINKMAN_ID,CUSTOMER_ID,LINKMAN_NAME from LINKMAN where LINKMAN_ID=\'').$LINKMAN_ID).'\'');
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$LINKMAN_ID1 = $ROW['LINKMAN_ID'];
$CUSTOMER_ID1 = $ROW['CUSTOMER_ID'];
$LINKMAN_NAME1 = $ROW['LINKMAN_NAME'];
}
$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'];
}
echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_new.gif" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 客户服务历史记录</span>
</td>
</tr>
</table>
';
$CUSTOMER_COUNT = 0;
$query = (((''.'SELECT count(*) from CONTACT a LEFT OUTER JOIN SYS_CODE b
ON a.CONTACT_TYPE=b.CODE_NO AND b.PARENT_NO = \'CONTACT_TYPE\'
LEFT OUTER JOIN CUSTOMER c ON a.CUSTOMER_ID = c.CUSTOMER_ID
LEFT OUTER JOIN SYS_CODE d ON c.KIND=d.CODE_NO AND d.PARENT_NO=\'CRM_KIND\'
LEFT OUTER JOIN SYS_CODE e ON c.SELLMODE=e.CODE_NO AND e.PARENT_NO=\'SELL_MODE\'
LEFT OUTER JOIN LINKMAN f ON a.LINKMAN_ID = f.LINKMAN_ID where a.LINKMAN_ID=\'').$LINKMAN_ID).'\'');
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$CUSTOMER_COUNT = $ROW[0];
}
$query1 = (((''.'SELECT a.CONTACT_ID as CONTACT_ID,c.CUSTOMER_ID as CUSTOMER_ID,f.LINKMAN_NAME as LINKMAN_NAME,f.LINKMAN_ID as LINKMAN_ID,c.CUSTOMER_NAME as CUSTOMER_NAME,d.CODE_NAME as KIND,e.CODE_NAME as SELLMODE,b.CODE_NAME as CONTACT_TYPE,a.CONTACT_DATE as CONTACT_DATE,a.CONTACT_CONTENT as CONTACT_CONTENT,a.SELLER as SELLER from CONTACT a LEFT OUTER JOIN SYS_CODE b
ON a.CONTACT_TYPE=b.CODE_NO AND b.PARENT_NO = \'CONTACT_TYPE\'
LEFT OUTER JOIN CUSTOMER c ON a.CUSTOMER_ID = c.CUSTOMER_ID
LEFT OUTER JOIN SYS_CODE d ON c.KIND=d.CODE_NO AND d.PARENT_NO=\'CRM_KIND\'
LEFT OUTER JOIN SYS_CODE e ON c.SELLMODE=e.CODE_NO AND e.PARENT_NO=\'SELL_MODE\'
LEFT OUTER JOIN LINKMAN f ON a.LINKMAN_ID = f.LINKMAN_ID where a.LINKMAN_ID=\'').$LINKMAN_ID).'\' order by a.CONTACT_DATE desc');
$cursor1 = exequery ($connection, $query1);
if (($CUSTOMER_COUNT == 0))
{
message ('<br>提示', '没有客户服务记录');
}
else
{
echo '<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 now';
echo 'rap align="center">操作</td>
</tr>
';
$CUSTOMER_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor1))
{
++$CUSTOMER_COUNT;
$SIGN = '0';
$CONTACT_ID1 = $ROW['CONTACT_ID'];
$CUSTOMER_NAME1 = $ROW['CUSTOMER_NAME'];
$CUSTOMER_ID1 = $ROW['CUSTOMER_ID'];
$LINKMAN_ID1 = $ROW['LINKMAN_ID'];
$LINKMAN_NAME1 = $ROW['LINKMAN_NAME'];
$KIND1 = $ROW['KIND'];
$SELLMODE1 = $ROW['SELLMODE'];
$CONTACT_TYPE1 = $ROW['CONTACT_TYPE'];
$CONTACT_DATE1 = $ROW['CONTACT_DATE'];
$CONTACT_CONTENT1 = $ROW['CONTACT_CONTENT'];
$SELLER1 = $ROW['SELLER'];
if (($SELLER1 != $LOGIN_USER_ID))
{
$SIGN = '1';
}
$query2 = (((''.'select * from USER where USER_ID=\'').$SELLER1).'\'');
$cursor2 = exequery ($connection, $query2);
if ($ROW = mysql_fetch_array ($cursor2))
{
$SELLER1 = $ROW['USER_NAME'];
}
if ((($CUSTOMER_COUNT % 2) == 1))
{
$TableLine = 'TableLine1';
}
else
{
$TableLine = 'TableLine2';
}
echo ' <tr class="';
echo $TableLine;
echo '">
<td nowrap align="center">';
echo $CUSTOMER_NAME1;
echo '</td>
<td nowrap align="center">';
echo $LINKMAN_NAME1;
echo '</td>
<td nowrap align="center">';
echo $CONTACT_TYPE1;
echo '</td>
<td nowrap align="center">';
echo $CONTACT_DATE1;
echo '</td>
<td align="left" width="200">';
echo $CONTACT_CONTENT1;
echo '</td>
<td nowrap align="center">';
echo $SELLER1;
echo '</td>
<td nowrap align="center">
';
if (($SIGN == '1'))
{
echo ' <a href="javascript:show_detail(';
echo $CONTACT_ID1;
echo ');"> 详细信息 </a>
';
}
else
{
echo ' <a href="javascript:show_detail(';
echo $CONTACT_ID1;
echo ');"> 详细信息 </a>
<a href="edit.php?CONTACT_ID=';
echo $CONTACT_ID1;
echo '&LINKMAN_ID=';
echo $LINKMAN_ID;
echo '&CUSTOMER_NAME=';
echo $CUSTOMER_NAME;
echo '&CUSTOMER_CODE =';
echo $CUSTOMER_CODE;
echo '&CUSTOMER_SHORT=';
echo $CUSTOMER_SHORT;
echo '&LINKMAN_NAME=';
echo $LINKMAN_NAME;
echo '&ADD_HOME=';
echo $ADD_HOME;
echo '&SEX=';
echo $SEX;
echo '&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&CUR_PAGE=';
echo $CUR_PAGE;
echo '"> 编辑</a>
<a href="javascript:delete_customer(\'';
echo $CONTACT_ID1;
echo '\');">删除</a>
';
}
echo ' </td>
</tr>
';
}
}
echo '</table>
<br>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_new.gif" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 新建客户服务记录</span>
</td>
</tr>
</table>
<br>
<table border="0" cellspacing="1" width="450" class="small" bgcolor="#000000" cellpadding="3" align="center" >
<form action="add.php" method="post" name="form1" onsubmit="return CheckForm();">
<tr>
<td nowrap class="TableHeader" colspan="4" align="left">
客户服务基本信息：
</td>
</tr>
<tr>
<td';
echo ' nowrap class="TableData">服务类型： </td>
<td class="TableData">
';
echo '<s';
echo 'elect name="CONTACT_TYPE" class="BigSelect">
';
getalldate ('CONTACT_TYPE');
echo ' </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="BigStatic" readonly size="15" maxlength="10" value="';
echo $CONTACT_DATE;
echo '">
<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="';
echo $CUSTOMER_ID1;
echo '">
<input type="text" name="CUSTOMER_NAME" class="BigStatic" size="15" maxlength="100" readonly value="';
echo $CUSTOMER_NAME1;
echo '">
</td>
<td nowrap class="TableData">联系人： </td>
<td nowrap class="TableData">
<input type="hidden" name="LINKMAN_ID" value="';
echo $LINKMAN_ID1;
echo '">
<input type="text" name="LINKMAN_NAME" class="BigStatic" size="15" maxlength="100" value="';
echo $LINKMAN_NAME1;
echo '">
</td>
</tr>
<tr>
<td nowrap class="TableData">服务预估成本： </td>
<td class="TableData">
<input type="text" name="MONEY_COST" class="BigInput" size="15" maxlength="100" >元
</td>
<td nowrap class="TableData">时间成本： </td>
<td nowrap class="TableData">
<input type="text" name="TIME_COST" class="BigInput" size="15" maxlength="100" >小时
</';
echo '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">';
echo $CONTACT_CONTENT;
echo '</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">
';
echo '<s';
echo 'elect name="SATISFY" class="BigSelect">
<option value=""></option>
<option value=01>很满意</option>
<option value=02>比较满意</option>
<option value=3>不满意</option>
<option value=05>很不满意</option>
</select>
</td>
</tr>
<tr>
<td nowrap class="TableData">客户反馈意见： </td>
<td nowrap class="TableData" colspan="3">
<textarea ';
echo 'cols=57 rows=3 name="FEEDBACK" class="BigInput" wrap="yes">';
echo $MEMO1;
echo '</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">';
echo $MEMO;
echo '</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">';
echo $MEMO1;
echo '</textarea>
</td>
</tr>
<tr>
<td class="TableData" colspan="4">
';
echo get_field_table (get_field_html ('CONTACT', $CONTACT_ID));
echo ' </td>
</tr>
<tr>
<td nowrap class="TableControl" colspan="4" align="center">
<input type="hidden" value="LINKMAN_ID=';
echo $LINKMAN_ID;
echo '&CUSTOMER_NAME=';
echo $CUSTOMER_NAME;
echo '&CUSTOMER_CODE =';
echo $CUSTOMER_CODE;
echo '&CUSTOMER_SHORT=';
echo $CUSTOMER_SHORT;
echo '&LINKMAN_NAME=';
echo $LINKMAN_NAME;
echo '&ADD_HOME=';
echo $ADD_HOME;
echo '&SEX=';
echo $SEX;
echo '&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&CUR_PAGE=';
echo $CUR_PAGE;
echo '" name="QUERY_LIST">
<input type="submit" value="确定" class="BigButton" title="新建客户服务记录" name="button">
<input type="button" value="返回" class="BigButton" onclick="location=\'../index.php?CUSTOMER_NAME=';
echo $CUSTOMER_NAME;
echo '&CUSTOMER_CODE =';
echo $CUSTOMER_CODE;
echo '&CUSTOMER_SHORT=';
echo $CUSTOMER_SHORT;
echo '&LINKMAN_NAME=';
echo $LINKMAN_NAME;
echo '&ADD_HOME=';
echo $ADD_HOME;
echo '&SEX=';
echo $SEX;
echo '&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&CUR_PAGE=';
echo $CUR_PAGE;
echo '\'">
</td>
</tr>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -