📄 index.php
字号:
<?
include_once 'inc/auth.php';
echo '<html>
<head>
<title>客户联系人管理 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript>
function set_page()
{
PAGE_START=PAGE_NUM.value;
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="+PAGE_START;
}
function delete_linkman(LINKMAN_ID)
{
msg=\'确认要删除该联系人？\';
if(window.confirm(msg))
{
URL="delete.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 '&CUR_PAGE=';
echo $CUR_PAGE;
echo '&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&LINKMAN_ID=" + LINKMAN_ID;
window.location=URL;
}
}
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;';
echo '
}
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+=v';
echo 'al + ",";
}
}
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=';
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 '&delete_str=" + delete_str;
window.location=URL;
}
}
function mobile_sms(MOBIL_NO_STR)
{
URL="/general/mobile_sms/new/?TO_ID1="+MOBIL_NO_STR;
myleft=(screen.availWidth-650)/2;
window.open(URL,"mobile_sms","height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
</script>
</head>
<body>
<div align="lef';
echo 't">
<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';
echo '="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">
</td>
<td nowrap class="TableData">客户简称： </td>
<td nowrap class="TableData">
<input type="text" name="CUSTOMER_SHORT" class="SmallInput" size="15"';
echo ' maxlength="100">
</td>
</tr>
<tr>
<td nowrap class="TableData"> 联系人姓名： </td>
<td nowrap class="TableData">
<input type="text" name="LINKMAN_NAME" class="SmallInput" size="15" maxlength="100">
</td>
<td nowrap class="TableData">地址： </td>
<td nowrap class="TableData">
<input type="text" name="ADD_HOME" class="SmallInput" siz';
echo 'e="15" maxlength="100" >
</td>
<td nowrap class="TableData">性别： </td>
<td nowrap class="TableData">
';
echo '<s';
echo 'elect name="SEX" class="SmallSelect">
<option value="" ></option>
<option value="0" ';
if (($SEX == '0'))
{
echo 'selected';
}
echo '>男</option>
<option value="1" ';
if (($SEX == '1'))
{
echo 'selected';
}
echo '>女</option>
</select>
<input value="查询" type="submit" class="SmallButton" title="模糊查询" name="button">
</td>
</tr>
</form>
</table>
</fieldset>
</div>
<br>
';
if (($CUSTOMER_NAME != ''))
{
($WHERE_STR .= ((' and b.CUSTOMER_NAME like \'%'.$CUSTOMER_NAME).'%\''));
}
if (($CUSTOMER_CODE != ''))
{
($WHERE_STR .= ((' and b.CUSTOMER_CODE like \'%'.$CUSTOMER_CODE).'%\''));
}
if (($CUSTOMER_SHORT != ''))
{
($WHERE_STR .= ((' and b.CUSTOMER_SHORT like \'%'.$CUSTOMER_SHORT).'%\''));
}
if (($LINKMAN_NAME != ''))
{
($WHERE_STR .= ((' and a.LINKMAN_NAME like \'%'.$LINKMAN_NAME).'%\''));
}
if (($ADD_HOME != ''))
{
($WHERE_STR .= ((' and a.ADD_HOME like \'%'.$ADD_HOME).'%\''));
}
if (($SEX != ''))
{
($WHERE_STR .= ((' and a.SEX=\''.$SEX).'\''));
}
if (($ORDERFIELD != ''))
{
if (($ORDERSIGN == 'DOWN'))
{
$ORDERTYPE = 'ASC';
}
if (($ORDERSIGN == 'UP'))
{
$ORDERTYPE = 'DESC';
}
$OREDERBY = (((' ORDER BY '.$ORDERFIELD).' ').$ORDERTYPE);
}
$query = (((''.'SELECT count(*) FROM `LINKMAN` a LEFT OUTER JOIN CUSTOMER b ON a.`CUSTOMER_ID` = b.`CUSTOMER_ID` where a.SELLER=\'').$LOGIN_USER_ID).'\'');
($query .= $WHERE_STR);
$cursor = exequery ($connection, $query);
$LINKMAN_COUNT = 0;
if ($ROW = mysql_fetch_array ($cursor))
{
$LINKMAN_COUNT = $ROW[0];
}
$query = (((((''.'SELECT a.MOBILE FROM `LINKMAN` a LEFT OUTER JOIN CUSTOMER b ON a.`CUSTOMER_ID` = b.`CUSTOMER_ID` where a.SELLER=\'').$LOGIN_USER_ID).'\' ').$WHERE_STR).$OREDERBY);
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$MOBILE1 = $ROW['MOBILE'];
if (($MOBILE1 != ''))
{
($MOBIL_NO_STR .= ($MOBILE1.','));
continue;
}
}
$PER_PAGE = 10;
$PAGE_COUNT = ceil (($LINKMAN_COUNT / $PER_PAGE));
if ((($CUR_PAGE <= 0) OR ($CUR_PAGE == '')))
{
$CUR_PAGE = 1;
}
if (($PAGE_COUNT < $CUR_PAGE))
{
$CUR_PAGE = $PAGE_COUNT;
}
$query1 = (((((''.'SELECT a.LINKMAN_ID,b.CUSTOMER_ID,LINKMAN_NAME,SEX,a.TEL_NO_WORK,a.MOBILE,a.EMAIL as EMAIL,a.OICQ,a.ICQ,b.CUSTOMER_NAME FROM `LINKMAN` a LEFT OUTER JOIN CUSTOMER b ON a.`CUSTOMER_ID` = b.`CUSTOMER_ID` where a.SELLER=\'').$LOGIN_USER_ID).'\' ').$WHERE_STR).$OREDERBY);
$offest = (($CUR_PAGE - 1) * 10);
if (($offest < 0))
{
$offest = 0;
}
$query1 = (((($query1.' LIMIT ').$offest).' ,').$PER_PAGE);
$cursor1 = exequery ($connection, $query1);
if (($LINKMAN_COUNT == 0))
{
message ('<br>提示', '没有符合条件的联系人');
echo '<br>
';
exit ();
}
else
{
echo '
<table border="0" cellspacing="1" width="95%" class="small" cellpadding="3">
<tr>
<td align="left">
<a href="index.php?CUR_PAGE=1&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 '"><img src=\'/images/first02.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'首页\'></a>
<a href="index.php?CUR_PAGE=';
echo ($CUR_PAGE - 1);
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 '"><img src=\'/images/first01.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'上一页\'></a>
<a href="index.php?CUR_PAGE=';
echo ($CUR_PAGE + 1);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -