customer_info.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 109 行

PHP
109
字号
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title>选择客户</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  include_once 'inc/menu_button.js';
  echo '
';
  echo '<s';
  echo 'cript 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.CUSTOM';
  echo 'ER_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).',');
        continue;
      }
    }
    $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))
    {
      echo '
<table border="1" cellspacing="0" width="95%" class="small" cellpadding="3"  bordercolorlight="#000000" bordercolordark="#FFFFFF"  align="center">
';
    }
    echo '<tr class="TableControl">
  <td class="menulines" align="center" onclick="javascript:add_customer(\'';
    echo $CUSTOMER_ID;
    echo '\',\'';
    echo $CUSTOMER_NAME;
    echo '\')" style="cursor:hand">';
    echo $CUSTOMER_NAME;
    echo '</a></td>
</tr>
';
    ++$CUSTOMER_COUNT;
    if ((50 <= $CUSTOMER_COUNT))
    {
      break;
    }
  }
  if (($CUSTOMER_COUNT == 0))
  {
    message ('提示', '没有定义客户');
  }
  else
  {
    echo '<thead class="TableControl">
  <th bgcolor="#d6e7ef" align="center"><b>选择客户(最多显示50条)</b></th>
</thead>
</table>
';
  }
  echo '
</body>
</html>
';
?>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?