user.php

来自「通达OA2007SE源代码非常好的」· PHP 代码 · 共 430 行
PHP
430 行
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  $query = (((''.'SELECT * from FLOW_PROCESS where ID=\'').$ID).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $PRCS_USER = $ROW['PRCS_USER'];
    $PRCS_DEPT = $ROW['PRCS_DEPT'];
    $PRCS_PRIV = $ROW['PRCS_PRIV'];
  }
  $QUERY_PRIV = ' and (1=2 ';
  if (($PRCS_USER != ''))
  {
    if ((substr ($PRCS_USER, -1) == ','))
    {
      $PRCS_USER = substr ($PRCS_USER, 0, -1);
    }
    $PRCS_USER = (('\''.str_replace (',', '\',\'', $PRCS_USER)).'\'');
    ($QUERY_PRIV .= (((''.' or USER.USER_ID in(').$PRCS_USER).')'));
  }
  if (($PRCS_DEPT != ''))
  {
    if ((substr ($PRCS_DEPT, -1) == ','))
    {
      $PRCS_DEPT = substr ($PRCS_DEPT, 0, -1);
    }
    ($QUERY_PRIV .= (((''.' or DEPT_ID in(').$PRCS_DEPT).')'));
  }
  if (($PRCS_PRIV != ''))
  {
    if ((substr ($PRCS_PRIV, -1) == ','))
    {
      $PRCS_PRIV = substr ($PRCS_PRIV, 0, -1);
    }
    ($QUERY_PRIV .= (((''.' or USER.USER_PRIV in(').$PRCS_PRIV).')'));
  }
  ($QUERY_PRIV .= ') ');
  echo '
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'tyle>
.menulines{}
</style>
';
  echo '<s';
  echo 'cript Language="JavaScript">
var parent_window = parent.dialogArguments;
';
  $TO_ID = 'AUTO_USER';
  $TO_NAME = 'AUTO_USER_NAME';
  echo '
function click_user(user_id)
{
  TO_VAL=parent_window.form1.';
  echo $TO_ID;
  echo '.value;
  OP_VAL=parent_window.form1.AUTO_USER_OP.value;
  targetelement=document.getElementById(user_id);
  user_name=targetelement.name;
  if(TO_VAL=="")
  {
    parent_window.form1.AUTO_USER_OP.value=user_id;
    parent_window.form1.AUTO_USER_OP_NAME.value=user_name;
  }
  if(TO_VAL.indexOf(","+user_id+",")>0 || TO_VAL.indexOf(user_id+",")==0)
  {
    if(TO_VAL.indexOf(user_id+';
  echo '",")==0)
    {
       parent_window.form1.';
  echo $TO_ID;
  echo '.value=parent_window.form1.';
  echo $TO_ID;
  echo '.value.replace(user_id+",","");
       parent_window.form1.';
  echo $TO_NAME;
  echo '.value=parent_window.form1.';
  echo $TO_NAME;
  echo '.value.replace(user_name+",","");
    }
    if(TO_VAL.indexOf(","+user_id+",")>0)
    {
       parent_window.form1.';
  echo $TO_ID;
  echo '.value=parent_window.form1.';
  echo $TO_ID;
  echo '.value.replace(","+user_id+",",",");
       parent_window.form1.';
  echo $TO_NAME;
  echo '.value=parent_window.form1.';
  echo $TO_NAME;
  echo '.value.replace(","+user_name+",",",");
    }
    if(OP_VAL==user_id)
    {
    	 parent_window.form1.AUTO_USER_OP.value="";
       parent_window.form1.AUTO_USER_OP_NAME.value="";
       targetelement=document.getElementById(user_id+"_op");
    }
  }
  else
  {
    parent_window.form1.';
  echo $TO_ID;
  echo '.value+=user_id+",";
    parent_window.form1.';
  echo $TO_NAME;
  echo '.value+=user_name+",";
  }
  begin_set();
}
function click_op(op_id)
{
  TO_VAL=parent_window.form1.';
  echo $TO_ID;
  echo '.value;
  OP_VAL=parent_window.form1.AUTO_USER_OP.value;
  targetelement=document.getElementById(op_id);
  user_id=op_id.substr(0,op_id.length-3);
  user_name=targetelement.name;
  if(OP_VAL==user_id)
  {
     parent_window.form1.AUTO_USER_OP.value="";
     parent_window.form1.AUTO_USER_OP_NAME.value="";
  }
  else
  {
    parent_window.form1.AUTO_USER_OP.value=user_id;
    parent_w';
  echo 'indow.form1.AUTO_USER_OP_NAME.value=user_name;
    if(!(TO_VAL.indexOf(","+user_id+",")>0 || TO_VAL.indexOf(user_id+",")==0))
      click_user(user_id);
  }
  begin_set();
}
function borderize_on(targetelement)
{
 color="#003FBF";
 targetelement.style.borderColor="black";
 targetelement.style.backgroundColor=color;
 targetelement.style.color="white";
 targetelement.style.fontWeight="';
  echo 'bold";
}
function borderize_off(targetelement)
{
  targetelement.style.backgroundColor="";
  targetelement.style.borderColor="";
  targetelement.style.color="";
  targetelement.style.fontWeight="";
}
function begin_set()
{
  TO_VAL=parent_window.form1.';
  echo $TO_ID;
  echo '.value;
  OP_VAL=parent_window.form1.AUTO_USER_OP.value;
  for (step_i=0; step_i<document.all.length; step_i++)
  {
    if(document.all(step_i).className=="menulines")
    {
       user_id=document.all(step_i).id;
       if(TO_VAL.indexOf(","+user_id+",")>0 || TO_VAL.indexOf(user_id+",")==0)
          borderize_on(document.all(step_i));
       else
       	  borderize_off(document.all(s';
  echo 'tep_i));
    }
    else if(document.all(step_i).className=="menulines_op")
    {
       user_id=document.all(step_i).id.substr(0,document.all(step_i).id.length-3);
       if(OP_VAL==user_id)
          borderize_on(document.all(step_i));
       else
       	  borderize_off(document.all(step_i));
    }
  }
}
function add_all()
{
  TO_VAL=parent_window.form1.';
  echo $TO_ID;
  echo '.value;
  for (step_i=0; step_i<document.all.length; step_i++)
  {
    if(document.all(step_i).className=="menulines")
    {
       user_id=document.all(step_i).id;
       user_name=document.all(step_i).name;
       if(TO_VAL.indexOf(","+user_id+",")<0 && TO_VAL.indexOf(user_id+",")!=0)
       {
         parent_window.form1.';
  echo $TO_ID;
  echo '.value+=user_id+",";
         parent_window.form1.';
  echo $TO_NAME;
  echo '.value+=user_name+",";
         borderize_on(document.all(step_i));
       }
    }
  }
}
function del_all()
{
  OP_VAL=parent_window.form1.AUTO_USER_OP.value;
  for (step_i=0; step_i<document.all.length; step_i++)
  {
    TO_VAL=parent_window.form1.';
  echo $TO_ID;
  echo '.value;
    if(document.all(step_i).className=="menulines")
    {
       user_id=document.all(step_i).id;
       user_name=document.all(step_i).name;
       if(user_id==OP_VAL)
       {
          parent_window.form1.AUTO_USER_OP.value="";
          parent_window.form1.AUTO_USER_OP_NAME.value="";
       }
       if(TO_VAL.indexOf(user_id+",")==0)
       {
          parent_window.form1';
  echo '.';
  echo $TO_ID;
  echo '.value=parent_window.form1.';
  echo $TO_ID;
  echo '.value.replace(user_id+",","");
          parent_window.form1.';
  echo $TO_NAME;
  echo '.value=parent_window.form1.';
  echo $TO_NAME;
  echo '.value.replace(user_name+",","");
          borderize_off(document.all(step_i));
       }
       if(TO_VAL.indexOf(","+user_id+",")>0)
       {
          parent_window.form1.';
  echo $TO_ID;
  echo '.value=parent_window.form1.';
  echo $TO_ID;
  echo '.value.replace(","+user_id+",",",");
          parent_window.form1.';
  echo $TO_NAME;
  echo '.value=parent_window.form1.';
  echo $TO_NAME;
  echo '.value.replace(","+user_name+",",",");
          borderize_off(document.all(step_i));
       }
    }
  }
  begin_set();
}
</script>
</head>
<body class="bodycolor" topmargin="1" leftmargin="0" onload="begin_set()">
';
  if (($INTEL == '1'))
  {
    $query = (('SELECT * from USER,USER_PRIV where DEPT_ID!=0 and NOT_LOGIN!=\'1\' and USER.USER_PRIV=USER_PRIV.USER_PRIV '.$QUERY_PRIV).' order by PRIV_NO,USER_NO,USER_NAME');
    $TITLE = '全部经办人';
  }
  else
  {
    if (($DEPT_ID != ''))
    {
      $query = (((((''.'SELECT * from USER,USER_PRIV where DEPT_ID=').$DEPT_ID).' and NOT_LOGIN!=\'1\' and USER.USER_PRIV=USER_PRIV.USER_PRIV ').$QUERY_PRIV).' order by PRIV_NO,USER_NO,USER_NAME');
      $query1 = ((''.'select * from DEPARTMENT where DEPT_ID=').$DEPT_ID);
      $cursor1 = exequery ($connection, $query1);
      if ($ROW = mysql_fetch_array ($cursor1))
      {
        $TITLE = $ROW['DEPT_NAME'];
      }
    }
    else
    {
      if (($USER_PRIV != ''))
      {
        $query = (((((''.'SELECT * from USER where USER_PRIV=\'').$USER_PRIV).'\' and DEPT_ID!=0 and NOT_LOGIN!=\'1\' ').$QUERY_PRIV).' order by USER_NO,USER_NAME');
        $query1 = (((''.'select * from USER_PRIV where USER_PRIV=\'').$USER_PRIV).'\'');
        $cursor1 = exequery ($connection, $query1);
        if ($ROW = mysql_fetch_array ($cursor1))
        {
          $TITLE = $ROW['PRIV_NAME'];
        }
      }
    }
  }
  echo '
<table border="1" cellspacing="0" width="100%" class="small" cellpadding="3"  bordercolorlight="#000000" bordercolordark="#FFFFFF">
<tr class="TableHeader">
  <td colspan="2" align="center"><b>';
  echo $TITLE;
  echo '</b></td>
</tr>
';
  $cursor = exequery ($connection, $query);
  $USER_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$USER_COUNT;
    if (((($INTEL == '1') AND ($LIST_ALL != 1)) AND (20 < $USER_COUNT)))
    {
      echo '   	<tr class="TableContent">
     <td onclick="location=\'user.php?INTEL=1&LIST_ALL=1&ID=';
      echo $ID;
      echo '\'" style="cursor:hand" align="center" colspan="2">显示更多...</td>
    </tr>
';
      break;
    }
    $USER_ID = $ROW['USER_ID'];
    $DEPT_ID = $ROW['DEPT_ID'];
    $USER_NAME = $ROW['USER_NAME'];
    $DEPT_LONG_NAME = dept_long_name ($DEPT_ID);
    if (find_id ($HISTORY_USER_ID, $USER_ID))
    {
      $USER_NAME_DESC = (('<font color=red>'.$USER_NAME).'</font>');
    }
    else
    {
      $USER_NAME_DESC = $USER_NAME;
    }
    if (($USER_COUNT == 1))
    {
      echo '<tr class="TableContent">
 <td onclick="javascript:add_all();" style="cursor:hand" align="center" colspan="2">全部添加</td>
</tr>
<tr class="TableContent">
 <td onclick="javascript:del_all();" style="cursor:hand" align="center" colspan="2">全部删除</td>
</tr>
';
    }
    echo '
<tr class="TableControl" title="设为主办人">
  <td class="menulines_op" id="';
    echo $USER_ID;
    echo '_op" name="';
    echo $USER_NAME;
    echo '" width="50" align="center" onclick="javascript:click_op(\'';
    echo $USER_ID;
    echo '_op\')" style="cursor:hand">
  主办人
  </td>
  <td title="';
    echo $DEPT_LONG_NAME;
    echo '" class="menulines" id="';
    echo $USER_ID;
    echo '" name="';
    echo $USER_NAME;
    echo '"   align="center" onclick="javascript:click_user(\'';
    echo $USER_ID;
    echo '\')" style="cursor:hand">
  ';
    echo $USER_NAME_DESC;
    echo '  </td>
</tr>
';
  }
  if (($USER_PRIV != ''))
  {
    $query = (((((((((''.'SELECT * from USER where (USER_PRIV_OTHER like \'').$USER_PRIV).',%\' or USER_PRIV_OTHER like \'%,').$USER_PRIV).',%\') and USER_PRIV!=\'').$USER_PRIV).'\' and DEPT_ID!=0 and NOT_LOGIN!=\'1\' ').$QUERY_PRIV).' order by USER_NO,USER_NAME');
    $cursor = exequery ($connection, $query);
    $USER_COUNT1 = 0;
    while ($ROW = mysql_fetch_array ($cursor))
    {
      ++$USER_COUNT;
      ++$USER_COUNT1;
      $USER_ID = $ROW['USER_ID'];
      $USER_NAME = $ROW['USER_NAME'];
      if (find_id ($HISTORY_USER_ID, $USER_ID))
      {
        $USER_NAME_DESC = (('<font color=red>'.$USER_NAME).'</font>');
      }
      else
      {
        $USER_NAME_DESC = $USER_NAME;
      }
      if (($USER_COUNT1 == 1))
      {
        echo '<tr class="TableHeader">
  <td colspan="2" align="center"><b>辅助角色</b></td>
</tr>
';
      }
      echo '
<tr class="TableControl" title="设为主办人">
  <td class="menulines_op" id="';
      echo $USER_ID;
      echo '_op" name="';
      echo $USER_NAME;
      echo '" width="50" align="center" onclick="javascript:click_op(\'';
      echo $USER_ID;
      echo '_op\')" style="cursor:hand">
  主办人
  </td>
  <td title="';
      echo $DEPT_LONG_NAME;
      echo '" class="menulines" id="';
      echo $USER_ID;
      echo '" name="';
      echo $USER_NAME;
      echo '"   align="center" onclick="javascript:click_user(\'';
      echo $USER_ID;
      echo '\')" style="cursor:hand">
  ';
      echo $USER_NAME_DESC;
      echo '  </td>
</tr>
';
    }
  }
  if (($USER_COUNT == 0))
  {
    echo '<tr class="TableControl">
  <td align="center"><b>无符合条件的用户</b><br><br>请首先设置好本步骤经办人或经办部门或经办角色</td>
</tr>
';
  }
  echo '
</table>
</body>
</html>
';
?>
user.php - 源码说明

本页面展示了「通达OA2007SE源代码非常好的」中的 user.php 源码文件，采用 PHP 编程语言编写，共 430 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。
虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。
⌨️ 快捷键说明

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