📄 index.php
字号:
<?
function getalldate ($CODE)
{
global $connection;
$query = (((''.'SELECT * from SYS_CODE where PARENT_NO=\'').$CODE).'\'');
$cursor = exequery ($connection, $query);
echo '<option value= ></option>';
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';
$PAGE_SIZE = 10;
echo '
<html>
<head>
<title>客户服务记录查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript Language="JavaScript">
function LoadWindow()
{
URL="/module/dept_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:1;status:0;help:0;resizable:1;dialogWidth:400px;dialogHeight:330px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
functio';
echo 'n 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,';
echo '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;
';
echo ' lstr+=val+",";
}
}
document.all(KT).value=lstr;
}
}
function clear_user2()
{
document.form1.COPY_TO_NAME.value="";
document.form1.COPY_TO_ID.value="";
}
function clear_dept()
{
document.form1.TO_NAME.value="";
document.form1.TO_ID.value="";
}
function LoadWindow2()
{
URL="/module/user_select?ID=2";
loc_x=document.body.scrollLeft+even';
echo 't.clientX-event.offsetX-100;
loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
//window.open(URL,"read_notify","height=400,width=550,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=150,resizable=yes");
window.showModalDialog(URL,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:400px;dialogHeight:350px;dialogTop:"+loc_y+"px;dialogLeft:"';
echo '+loc_x+"px");
}
</script>
</head>
<div align="left">
<fieldset style="width:95%;padding-bottom:5px;">
<legend class="small" align=left>
<b>销售部门、人员</b>
</legend>
<table cellspacing="1" class="small" align="left" cellpadding="3" border="0">
<form action="list.php" method="post" name="form1">
<tr>
<td nowrap class="TableData"> 销售部门： </td>
<td nowrap class=';
echo '"TableData">
<input type="hidden" name="TO_ID">
<textarea cols=21 name=TO_NAME rows=2 class="BigStatic" wrap="yes" readonly>';
echo $TO_NAME;
echo '</textarea>
<input value="选择" type="button" class="SmallButton" title="选择销售部门" name="button" onClick="LoadWindow()">
<input type="button" value="清空" class="SmallButton" onClick="clear_dept()" title="清空部门" name="button">
</td>
<td nowrap class="TableData"> 销售人员： </td>
<td nowrap class="TableData">
<input type="hidden" name="COPY_';
echo 'TO_ID" value="">
<textarea cols=21 name="COPY_TO_NAME" rows=2 class="BigStatic" wrap="yes" readonly></textarea>
<input value="选择" type="button" onClick="LoadWindow2()" class="SmallButton" title="选择销售人员" name="button">
<input type="button" value="清空" class="SmallButton" onClick="clear_user2()" title="清空人员" name="button">
</td>
</tr>
<tr>
<td now';
echo 'rap class="TableData" colspan="6" align="right">
(*所有条件可以组合查询) <input value="查询" type="submit" class="SmallButton" title="快速查询" name="button">
</td>
</tr>
</table>
</fieldset>
</div>
<br>
<div align="left">
<fieldset style="width:95%;padding-bottom:5px;">
<legend class="small" align=left>
<b>客户服务</b>
</legend>
<table cellspacing="1" class="small';
echo '" align="left" cellpadding="3">
<tr>
<td nowrap class="TableData"> 服务类型： </td>
<td nowrap class="TableData">
';
echo '<s';
echo 'elect name="CONTACT_TYPE" class="SmallSelect">
';
getalldate ('CONTACT_TYPE');
echo ' </select>
</td>
<td nowrap class="TableData">服务日期： </td>
<td nowrap class="TableData" colspan="3">
<input type="text" name="CONTACT_DATE1" class="SmallStatic" readonly size="15" maxlength="100">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar(\'form1.CONTACT_DATE1\');">
至
<input type="text" name="CON';
echo 'TACT_DATE2" class="SmallStatic" size="15" readonly maxlength="100" >
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar(\'form1.CONTACT_DATE2\');">
</td>
</tr>
<tr>
<td nowrap class="TableData"> 客户满意度： </td>
<td nowrap class="TableData" >
';
echo '<s';
echo 'elect name="SATISFY" class="SmallSelect">
<option value=""></option>
<option value=01>很满意</option>
<option value=02>比较满意</option>
<option value=3>不满意</option>
<option value=05>很不满意</option>
</select>
</td>
<td nowrap class="TableData">服务内容： </td>
<td nowrap class="TableData" colspan="3">
<textarea cols=37 ro';
echo 'ws=1 name="CONTACT_CONTENT" class="BigInput" wrap="yes"></textarea>
</td>
</tr>
';
$count = 0;
$query = 'select count(*) from FIELDSETTING where TABLENAME=\'CONTACT\' and ISQUERY=\'1\'';
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$count = $ROW[0];
}
if ((0 < $count))
{
echo ' <tr>
<td nowrap class="TableHeader" colspan="6" align="left">
用户自定义字段：
</td>
</tr>
';
$query = 'select * from FIELDSETTING where TABLENAME=\'CONTACT\' AND ISQUERY=\'1\' 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'];
echo ' <tr>
<td nowrap class="TableData"> ';
echo $FIELDNAME;
echo '：</td>
<td nowrap class="TableData" colspan="5">
';
if (($STYPE == 'T'))
{
echo ' <input type="text" name=\'CONTACT';
echo $FIELDNO;
echo '\' class="SmallInput" size="33" maxlength="25" value="">
';
}
if (($STYPE == 'MT'))
{
echo ' <textarea cols=37 rows=1 name=\'CONTACT';
echo $FIELDNO;
echo '\' class="SmallInput" wrap="yes"></textarea>
';
}
if (($STYPE == 'D'))
{
if (($TYPECODE != ''))
{
$query2 = (((''.'select * from SYS_CODE where PARENT_NO=\'').$TYPECODE).'\' order by CODE_ORDER');
$cursor2 = exequery ($connection, $query2);
while ($ROW = mysql_fetch_array ($cursor2))
{
$CODE_NO = $ROW['CODE_NO'];
$CODE_NAME = $ROW['CODE_NAME'];
$TYPEVALUE = (($TYPEVALUE.$CODE_NO).',');
$TYPENAME = (($TYPENAME.$CODE_NAME).',');
}
}
$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;
}
echo ' ';
echo '<s';
echo 'elect name=\'CONTACT';
echo $FIELDNO;
echo '\' class="SmallSelect">
<option value=""></option>
';
for ($I = 0; ($I < $TYPENAME_COUNT); ++$I)
{
echo '
<option value="';
echo $TYPEVALUE_ARRAY[$I];
echo '">';
echo $TYPENAME_ARRAY[$I];
echo '</option>
';
}
}
if (($STYPE == 'C'))
{
if (($TYPECODE != ''))
{
$query2 = (((''.'select * from SYS_CODE where PARENT_NO=\'').$TYPECODE).'\' order by CODE_ORDER');
$cursor2 = exequery ($connection, $query2);
while ($ROW = mysql_fetch_array ($cursor2))
{
$CODE_NO = $ROW['CODE_NO'];
$CODE_NAME = $ROW['CODE_NAME'];
$TYPEVALUE = (($TYPEVALUE.$CODE_NO).',');
$TYPENAME = (($TYPENAME.$CODE_NAME).',');
}
}
$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;
}
echo ' <input type="hidden" name=\'CONTACT';
echo $FIELDNO;
echo '\'>
';
for ($I = 0; ($I < $TYPENAME_COUNT); ++$I)
{
echo ' <input type="checkbox" name=\'CCONTACT';
echo $FIELDNO;
echo '\' id=\'CCONTACT';
echo $FIELDNO;
echo $I;
echo '\' value="';
echo $TYPEVALUE_ARRAY[$I];
echo '" onclick="return chk(this,\'CCONTACT';
echo $FIELDNO;
echo '\',\'CONTACT';
echo $FIELDNO;
echo '\',\'';
echo $TYPENAME_COUNT;
echo '\');"><label for="CCONTACT';
echo $FIELDNO;
echo $I;
echo '">';
echo $TYPENAME_ARRAY[$I];
echo '</label>
';
}
}
if (($STYPE == 'R'))
{
if (($TYPECODE != ''))
{
$query2 = (((''.'select * from SYS_CODE where PARENT_NO=\'').$TYPECODE).'\' order by CODE_ORDER');
$cursor2 = exequery ($connection, $query2);
while ($ROW = mysql_fetch_array ($cursor2))
{
$CODE_NO = $ROW['CODE_NO'];
$CODE_NAME = $ROW['CODE_NAME'];
$TYPEVALUE = (($TYPEVALUE.$CODE_NO).',');
$TYPENAME = (($TYPENAME.$CODE_NAME).',');
}
}
$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)
{
echo ' <input type="radio" name=\'CONTACT';
echo $FIELDNO;
echo '\' id=\'CONTACT';
echo $FIELDNO;
echo $I;
echo '\' value="';
echo $TYPEVALUE_ARRAY[$I];
echo '"><label for="CONTACT';
echo $FIELDNO;
echo $I;
echo '">';
echo $TYPENAME_ARRAY[$I];
echo '</label>
';
}
}
echo '
</td>
</tr>
';
}
}
echo ' <tr>
<td nowrap class="TableData" colspan="6" align="right" width="650">
<input value="查询" type="submit" class="SmallButton" title="查询" name="button">
</td>
</tr>
</table>
</fieldset>
</div>
<br>
<div align="left">
<fieldset style="width:95%;padding-bottom:5px;">
<legend class="small" align=left>
<b>客户信息</b>
</legend>
<table cellspacing="1" class="s';
echo 'mall" align="left" cellpadding="3">
<tr>
<td nowrap class="TableData"> 客户名称： </td>
<td nowrap class="TableData">
<input type="text" name="CUSTOMER_NAME" class="SmallInput" size="15" maxlength="100">
</td>
<td nowrap class="TableData">客户编码： </td>
<td nowrap class="TableData">
<input type="text" name="CUSTOMER_CODE" class="SmallInput" size="15"';
echo ' maxlength="100">
</td>
<td nowrap class="TableData">客户简称： </td>
<td nowrap class="TableData">
<input type="text" name="CUSTOMER_SHORT" class="SmallInput" size="15" maxlength="100">
</td>
</tr>
<tr>
<td nowrap class="TableData"> 地区： </td>
<td nowrap class="TableData">
<input type="text" name="CUSTOMER_AREA" class="SmallInput" size';
echo '="15" maxlength="100">
</td>
<td nowrap class="TableData">地址： </td>
<td nowrap class="TableData" colspan="3">
<input type="text" name="CUSTOMER_ADD" class="SmallInput" size="43" maxlength="100">
</td>
</tr>
<tr>
<td nowrap class="TableData"> 客户来源： </td>
<td nowrap class="TableData" >
';
echo '<s';
echo 'elect name="SOURCE" class="SmallSelect">
';
getalldate ('CRM_SOURCE');
echo ' </select>
</td>
<td nowrap class="TableData">客户类别： </td>
<td nowrap class="TableData" >
';
echo '<s';
echo 'elect name="KIND" class="SmallSelect">
';
getalldate ('CRM_KIND');
echo ' </select>
</td>
<td nowrap class="TableData">销售方式： </td>
<td nowrap class="TableData">
';
echo '<s';
echo 'elect name="SELLMODE" class="SmallSelect">
';
getalldate ('SELL_MODE');
echo ' </select>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 行业属性： </td>
<td nowrap class="TableData">
';
echo '<s';
echo 'elect name="ATTRIBUTE" class="SmallSelect">
';
getalldate ('CRM_ATTRIBUTE');
echo ' </select>
</td>
<td nowrap class="TableData">企业性质： </td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -