📄 index.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
$PAGE_SIZE=10;
$query = "select * from SALE_MANAGER where MANAGER_ID=1";
$cursor=exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$MANAGER_ID=$ROW["MANAGER_ID"];
$MANAGERS=$ROW["MANAGERS"];
}
?>
<html>
<head>
<title>销售记录快速搜索 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">
function delete_customer(HISTORY_ID)
{
msg='确认要删除该销售记录？';
if(window.confirm(msg))
{
URL="delete.php?CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&ARE=<?=$ARE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&HISTORY_ID=" + HISTORY_ID;
window.location=URL;
}
}
function set_page()
{
PAGE_START=PAGE_NUM.value;
location="index.php?CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&ARE=<?=$ARE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE="+PAGE_START;
}
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 check_one(el)
{
if(!el.checked)
document.all("allbox").checked=false;
}
function check_all()
{
for (i=0;i<document.all("email_select").length;i++)
{
if(document.all("allbox").checked)
document.all("email_select").item(i).checked=true;
else
document.all("email_select").item(i).checked=false;
}
if(i==0)
{
if(document.all("allbox").checked)
document.all("email_select").checked=true;
else
document.all("email_select").checked=false;
}
}
function delete_mail()
{
delete_str="";
for(i=0;i<document.all("email_select").length;i++)
{
el=document.all("email_select").item(i);
if(el.checked)
{ val=el.value;
delete_str+=val + ",";
}
}
if(i==0)
{
el=document.all("email_select");
if(el.checked)
{ val=el.value;
delete_str+=val + ",";
}
}
if(delete_str=="")
{
alert("请至少选择其中一条销售记录。");
return;
}
msg='确认要删除所选销售记录？';
if(window.confirm(msg))
{
URL="delete.php?CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&ARE=<?=$ARE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&delete_str=" + delete_str;
window.location=URL;
}
}
</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">
<form action="index.php" method="post" name="form1">
<tr>
<td nowrap class="TableData"> 客户名称： </td>
<td nowrap class="TableData">
<input type="text" name="CUSTOMER_NAME" class="SmallInput" size="15" maxlength="100" value="<?=$CUSTOMER_NAME?>">
</td>
<td nowrap class="TableData">客户编码： </td>
<td nowrap class="TableData">
<input type="text" name="CUSTOMER_CODE" class="SmallInput" size="15" maxlength="100" value="<?=$CUSTOMER_CODE?>">
</td>
<td nowrap class="TableData">客户简称： </td>
<td nowrap class="TableData">
<input type="text" name="CUSTOMER_SHORT" class="SmallInput" size="15" maxlength="100" value="<?=$CUSTOMER_SHORT?>">
</td>
<td nowrap class="TableData">地区： </td>
<td nowrap class="TableData" >
<select name="ARE" class="SmallSelect">
<?
GETALLDATE("AREA",$ARE);
?>
</select>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 客户类别： </td>
<td nowrap class="TableData" >
<select name="KIND" class="SmallSelect">
<?
GETALLDATE("CRM_KIND",$KIND);
?>
</select>
</td>
<td nowrap class="TableData">销售方式： </td>
<td nowrap class="TableData">
<select name="SELLMODE" class="SmallSelect">
<?
GETALLDATE("SELL_MODE",$SELLMODE);
?>
</select>
</td>
<td nowrap class="TableData">行业属性： </td>
<td nowrap class="TableData">
<select name="ATTRIBUTE" class="SmallSelect">
<?
GETALLDATE("CRM_ATTRIBUTE",$ATTRIBUTE);
?>
</select>
</td>
<td nowrap class="TableData">企业性质： </td>
<td nowrap class="TableData" >
<select name="ENTERTYPE" class="SmallSelect">
<?
GETALLDATE("CRM_TYPE",$ENTERTYPE);
?>
</select>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 产品类别：</td>
<td nowrap class="TableData">
<select name="PRODUCT_MODE" class="SmallSelect">
<?
GETALLDATE("PRODUCT_MODE",$PRODUCT_MODE);
?>
</select>
</td>
<td nowrap class="TableData">产品名称： </td>
<td nowrap class="TableData">
<input type="text" name="PRODUCT_NAME" class="SmallInput" size="15" maxlength="100">
</td>
<td nowrap class="TableData">产品型号： </td>
<td nowrap class="TableData" colspan="3">
<input type="text" name="PRODUCT_TYPE" class="SmallInput" size="15" maxlength="100">
</td>
</tr>
</tr>
<tr>
<td nowrap class="TableData"> 服务名称： </td>
<td nowrap class="TableData">
<input type="text" name="SERVICE_NAME" class="SmallInput" size="15" maxlength="100">
</td>
<td nowrap class="TableData">服务描述： </td>
<td nowrap class="TableData" colspan="5">
<textarea cols=37 rows=1 name="SERVICE_DESC" class="SmallInput" wrap="yes"><?=$MEMO?></textarea>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 记录日期： </td>
<td nowrap class="TableData" colspan="3">
<input type="text" name="DATE1" size="15" maxlength="10" class="SmallStatic" readonly value="<?=$DATE1?>">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.DATE1');">
至<input type="text" name="DATE2" size="15" maxlength="10" class="SmallStatic" readonly value="<?=$DATE2?>">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.DATE2');">
<td nowrap class="TableData" colspan="3" >
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -