⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 customer_info.php

📁 通达OA28 部分程序源码
💻 PHP
字号:
<?
include_once("inc/auth.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))
    $query = "SELECT * from CUSTOMER where CUSTOMER_NAME like '%$CUSTOMER_NAME%' order by CUSTOMER_NAME";
 else
    $query = "SELECT * from CUSTOMER where SELLER='$LOGIN_USER_ID' and CUSTOMER_NAME like '%$CUSTOMER_NAME%' order by CUSTOMER_NAME";

 $cursor= exequery($connection,$query);
 $CUSTOMER_COUNT=0;
 while($ROW=mysql_fetch_array($cursor))
 {
    $CUSTOMER_COUNT++;
    $CUSTOMER_ID=$ROW["CUSTOMER_ID"];
    $CUSTOMER_NAME=$ROW["CUSTOMER_NAME"];


    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 + -