📄 customer_info.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>选择客户</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<? include_once("inc/menu_button.js");?>
<script Language="JavaScript">
var parent_window = parent.dialogArguments;
function add_customer(customer_id,customer_name)
{
parent_window.form1.CUSTOMER_ID.value="";
parent_window.form1.CUSTOMER_NAME.value="";
CUSTOMER_VAL=parent_window.form1.CUSTOMER_ID.value;
if(CUSTOMER_VAL.indexOf(","+customer_id+",")<0 && CUSTOMER_VAL.indexOf(customer_id+",")!=0 && (parent_window.form1.CUSTOMER_ID.value!="ALL_CUSTOMER"))
{
parent_window.form1.CUSTOMER_ID.value+=customer_id;
parent_window.form1.CUSTOMER_NAME.value+=customer_name;
}
parent.close();
}
</script>
</head>
<body class="bodycolor" onMouseover="borderize_on(event)" onMouseout="borderize_off(event)" onclick="borderize_on1(event)" topmargin="5">
<?
$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"];
}
//============================ 显示客户信息 =======================================
if(find_id($MANAGERS,$LOGIN_USER_ID))
{
$query1 = "select DEPT_ID from DEPARTMENT";
$cursor1= exequery($connection,$query1);
while($ROW=mysql_fetch_array($cursor1))
{
$DEPT_ID=$ROW["DEPT_ID"];
if (is_dept_priv($DEPT_ID)==1)
{
$TO_ID=$TO_ID.$DEPT_ID.",";
}
}
$TO_ID="'".str_replace(",","','",substr($TO_ID,0,-1))."'";
$FLAG=1;
$query = "SELECT * from CUSTOMER a LEFT OUTER JOIN USER b ON a.SELLER = b.USER_ID where ((SELLER='$LOGIN_USER_ID') or (find_in_set( '$LOGIN_USER_ID',SHAREUSER) and SHARE='1') or (SHAREUSER='' and SHARE='1') or (b.DEPT_ID in ($TO_ID) and SHARE='0')) and CUSTOMER_NAME like '%$CUSTOMER_NAME%' order by CUSTOMER_NAME";
}
else
$query = "SELECT * from CUSTOMER where ((SELLER='$LOGIN_USER_ID') or (find_in_set( '$LOGIN_USER_ID',SHAREUSER) and SHARE='1') or (SHAREUSER='' and SHARE='1')) and CUSTOMER_NAME like '%$CUSTOMER_NAME%' order by CUSTOMER_NAME";
$cursor= exequery($connection,$query);
$CUSTOMER_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
$CUSTOMER_ID=$ROW["CUSTOMER_ID"];
$CUSTOMER_NAME=$ROW["CUSTOMER_NAME"];
$SELLER1=$ROW["SELLER"];
$SHARE1=$ROW["SHARE"];
$CUSTOMER_COUNT++;
if($CUSTOMER_COUNT==1)
{
?>
<table border="1" cellspacing="0" width="95%" class="small" cellpadding="3" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<?
}
?>
<tr class="TableControl">
<td class="menulines" align="center" onclick="javascript:add_customer('<?=$CUSTOMER_ID?>','<?=$CUSTOMER_NAME?>')" style="cursor:hand"><?=$CUSTOMER_NAME?></a></td>
</tr>
<?
$CUSTOMER_COUNT++;
if($CUSTOMER_COUNT>=50)
break;
}
if($CUSTOMER_COUNT==0)
Message("提示","没有定义客户");
else
{
?>
<thead class="TableControl">
<th bgcolor="#d6e7ef" align="center"><b>选择客户（最多显示50条）</b></th>
</thead>
</table>
<?
}
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -