index.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 489 行 · 第 1/2 页
PHP
489 行
<?
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 '<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 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)
{
';
echo '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.bo';
echo 'dy.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:400px;dialogHeight:350px;dialogTop:"+loc_';
echo 'y+"px;dialogLeft:"+loc_x+"px");
}
</script>
<html>
<head>
<title>客户统计</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</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">';
echo '<s';
echo 'pan 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 heig';
echo 'ht="20">
<td nowrap class="TableData">销售部门、人员： </td>
<td class="TableData" align="left">
<input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
echo $CUSTOMER_COUNT;
echo '1\' value="h.DEPT_ID,i.DEPT_NAME,销售部门" checked><label for="SUMFIELD';
echo $CUSTOMER_COUNT;
echo '1">销售部门</label> <input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
echo $CUSTOMER_COUNT;
echo '2\' value="h.USER_ID,h.USER_NAME,销售人员"><label for="SUMFIELD';
echo $CUSTOMER_COUNT;
echo '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';
echo $CUSTOMER_COUNT;
echo '3\' value="a.CUSTOMER_AREA,d.CODE_NAME,地区"><label for="SUMFIELD';
echo $CUSTOMER_COUNT;
echo '3">地区</label> <input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
echo $CUSTOMER_COUNT;
echo '4\' value="a.SOURCE,e.CODE_NAME,客户来源"><label for="SUMFIELD';
echo $CUSTOMER_COUNT;
echo '4">客户来源</label> <input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
echo $CUSTOMER_COUNT;
echo '5\' value="a.KIND,c.CODE_NAME,客户类别"><label for="SUMFIELD';
echo $CUSTOMER_COUNT;
echo '5">客户类别</label> <input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
echo $CUSTOMER_COUNT;
echo '6\' value="a.SELLMODE,b.CODE_NAME,销售方式"><label for="SUMFIELD';
echo $CUSTOMER_COUNT;
echo '6">销售方式</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';
echo $CUSTOMER_COUNT;
echo '7\' value="a.ATTRIBUTE,f.CODE_NAME,行业属性"><label for="SUMFIELD';
echo $CUSTOMER_COUNT;
echo '7">行业属性</label> <input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
echo $CUSTOMER_COUNT;
echo '8\' value="a.ENTERTYPE,g.CODE_NAME,企业性质"><label for="SUMFIELD';
echo $CUSTOMER_COUNT;
echo '8">企业性质</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%;pad';
echo 'ding-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" re';
echo 'adonly>';
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" 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" c';
echo 'ellpadding="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" maxlength="100">
';
echo ' </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">
';
echo '<s';
echo 'elect name="CUSTOMER_AREA" class="SmallSelect">
';
getalldate ('AREA');
echo ' </select>
</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" >
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?