📄 index.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
$PAGE_SIZE=10;
?>
<html>
<head>
<title>客户服务统计 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script 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");
}
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 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+event.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:350px;dialogHeight:350px;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");
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/finance1.gif" WIDTH="22" HEIGHT="22" align="absmiddle"><span class="big3"> 客户服务统计</span><br>
</td>
</tr>
</table>
<br>
<table border="0" width="70%" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
<form action="list.php" method="post" name="form1"> <tr>
<td nowrap class="TableHeader" colspan="2">
<img src="/images/green_arrow.gif"> 统计方式
</td>
</tr>
<tr height="20">
<td nowrap class="TableData">销售部门、人员： </td>
<td class="TableData" align="left">
<input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?>1' value="h.DEPT_ID,i.DEPT_NAME,销售部门" checked><label for="SUMFIELD<?=$CUSTOMER_COUNT?>1">销售部门</label> <input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?>2' value="h.USER_ID,h.USER_NAME,销售人员"><label for="SUMFIELD<?=$CUSTOMER_COUNT?>2">销售人员</label>
</td>
</tr>
<tr height="20">
<td nowrap class="TableData" width="100">客户类型：</td>
<td class="TableData" align="left">
<input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?>3' value="a.CUSTOMER_AREA,d.CODE_NAME,地区"><label for="SUMFIELD<?=$CUSTOMER_COUNT?>3">地区</label> <input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?>4' value="a.SOURCE,e.CODE_NAME,客户来源"><label for="SUMFIELD<?=$CUSTOMER_COUNT?>4">客户来源</label> <input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?>5' value="a.KIND,c.CODE_NAME,客户类别"><label for="SUMFIELD<?=$CUSTOMER_COUNT?>5">客户类别</label> <input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?>6' value="a.SELLMODE,b.CODE_NAME,销售方式"><label for="SUMFIELD<?=$CUSTOMER_COUNT?>6">销售方式</label> <input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?>7' value="a.CUSTOMER_ID,a.CUSTOMER_NAME,客户"><label for="SUMFIELD<?=$CUSTOMER_COUNT?>7">客户</label>
</td>
</tr>
<tr height="20">
<td nowrap class="TableData" width="100">客户企业概况：</td>
<td class="TableData" align="left">
<input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?>8' value="a.ATTRIBUTE,f.CODE_NAME,行业属性"><label for="SUMFIELD<?=$CUSTOMER_COUNT?>8">行业属性</label> <input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?>9' value="a.ENTERTYPE,g.CODE_NAME,企业性质"><label for="SUMFIELD<?=$CUSTOMER_COUNT?>9">企业性质</label>
</td>
</tr>
<tr height="20">
<td nowrap class="TableData" width="100">客户服务类型：</td>
<td class="TableData" align="left">
<input type="radio" name='SUMFIELD' id='SUMFIELD<?=$CUSTOMER_COUNT?>10' value="j.CONTACT_TYPE,k.CODE_NAME,客户服务类型"><label for="SUMFIELD<?=$CUSTOMER_COUNT?>10">客户服务类型</label>
</td>
</tr>
</table>
<br>
<table border="0" width="100%" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
<tr>
<td nowrap class="TableHeader">
<img src="/images/green_arrow.gif"> 统计范围
</td>
</tr>
<tr>
<td nowrap class="TableData">
<div align="center">
<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">
<tr>
<td nowrap class="TableData"> 销售部门： </td>
<td nowrap class="TableData">
<input type="hidden" name="TO_ID">
<textarea cols=21 name=TO_NAME rows=2 class="BigStatic" wrap="yes" readonly><?=$TO_NAME?></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_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 nowrap class="TableData" colspan="6" align="right">
(*所有条件可以组合查询) <input value="确定" type="submit" class="SmallButton" name="button">
</td>
</tr>
</table>
</fieldset>
</div>
<br>
<div align="center">
<fieldset style="width:95%;padding-bottom:5px;">
<legend class="small" align="left">
<b>客户服务</b>
</legend>
<table cellspacing="1" class="small" align="left" cellpadding="3">
<tr>
<td nowrap class="TableData"> 服务类型： </td>
<td nowrap class="TableData">
<select name="CONTACT_TYPE" class="SmallSelect">
<?
GETALLDATE("CONTACT_TYPE");
?>
</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="CONTACT_DATE2" class="SmallStatic" readonly size="15" 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" >
<select 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 rows=1 name="CONTACT_CONTENT" class="BigInput" wrap="yes"></textarea>
</td>
</tr>
<?
$count=0;
$connection=OpenConnection();
$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($count>0)
{
?>
<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"];
?>
<tr>
<td nowrap class="TableData"> <?=$FIELDNAME?>：</td>
<td nowrap class="TableData" colspan="5">
<?
if($STYPE=="T")
{
?>
<input type="text" name='CONTACT<?=$FIELDNO?>' class="SmallInput" size="33" maxlength="25" value="">
<?
}
if($STYPE=="MT")
{
?>
<textarea cols=37 rows=1 name='CONTACT<?=$FIELDNO?>' class="SmallInput" wrap="yes"></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='CONTACT<?=$FIELDNO?>' class="SmallSelect">
<option value=""></option>
<?
for($I=0;$I<$TYPENAME_COUNT;$I++)
{
?>
<option value="<?=$TYPEVALUE_ARRAY[$I]?>"><?=$TYPENAME_ARRAY[$I]?></option>
<?
}
}
if($STYPE=="C")
{
$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='CONTACT<?=$FIELDNO?>'>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -