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

📄 index.php

📁 通达OA官方提供的30源代码,感觉很实在
💻 PHP
字号:
🔍 
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
include_once("inc/utility_org.php");
?>

<html>
<head>
<title>部门/成员单位信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body class="bodycolor" topmargin="5">

<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/infofind.gif" align="absmiddle"><span class="big3"> 部门/成员单位信息</span>
    </td>
  </tr>
</table>

<br>

<?
//------ 递归显示部门列表，支持按管理范围显示 --------
function dept_tree_list($DEPT_ID,$PRIV_OP)
{
  global $DEEP_COUNT,$connection;

  $query = "SELECT * from DEPARTMENT where DEPT_PARENT='$DEPT_ID' order by DEPT_NO";
  $cursor= exequery($connection,$query);
  $OPTION_TEXT="";
  $DEEP_COUNT1=$DEEP_COUNT;
  $DEEP_COUNT.="　";
  while($ROW=mysql_fetch_array($cursor))
  {
      $COUNT++;
      $DEPT_ID=$ROW["DEPT_ID"];
      $DEPT_NAME=$ROW["DEPT_NAME"];
      $DEPT_PARENT=$ROW["DEPT_PARENT"];
      $TEL_NO=$ROW["TEL_NO"];
      $FAX_NO=$ROW["FAX_NO"];
      $TO_ID=$ROW["MANAGER"];
      $TO_ID3=$ROW["LEADER1"];
      $TO_ID4=$ROW["LEADER2"];
      $DEPT_FUNC=$ROW["DEPT_FUNC"];

      $DEPT_NAME=htmlspecialchars($DEPT_NAME);
      $DEPT_FUNC=htmlspecialchars($DEPT_FUNC);

      if($PRIV_OP==1)
         $DEPT_PRIV=is_dept_priv($DEPT_ID);
      else
         $DEPT_PRIV=1;

      $OPTION_TEXT_CHILD=dept_tree_list($DEPT_ID,$PRIV_OP);
      
      $TO_ARRAY=array();
      $query1 = "SELECT USER_ID,USER_NAME from USER where find_in_set(USER_ID,'$TO_ID')";
      $cursor1= exequery($connection,$query1);
      while($ROW=mysql_fetch_array($cursor1))
         $TO_ARRAY[$ROW["USER_ID"]]["USER_NAME"]=$ROW["USER_NAME"];
      
      $MANAGER_NAME="";
      $TOK=strtok($TO_ID,",");
      while($TOK!="")
      {
         $MANAGER_NAME.=$TO_ARRAY[$TOK]["USER_NAME"].",";
         $TOK=strtok(",");
      }
      $MANAGER_NAME=trim($MANAGER_NAME,",");
      
      $query1 = "SELECT USER_ID,USER_NAME from USER where find_in_set(USER_ID,'$TO_ID3')";
      $cursor1= exequery($connection,$query1);
      while($ROW=mysql_fetch_array($cursor1))
         $TO_ARRAY[$ROW["USER_ID"]]["USER_NAME"]=$ROW["USER_NAME"];
      
      $LEADER1_NAME="";
      $TOK=strtok($TO_ID3,",");
      while($TOK!="")
      {
         $LEADER1_NAME.=$TO_ARRAY[$TOK]["USER_NAME"].",";
         $TOK=strtok(",");
      }
      $LEADER1_NAME=trim($LEADER1_NAME,",");
      
      $query1 = "SELECT USER_ID,USER_NAME from USER where find_in_set(USER_ID,'$TO_ID4')";
      $cursor1= exequery($connection,$query1);
      while($ROW=mysql_fetch_array($cursor1))
         $TO_ARRAY[$ROW["USER_ID"]]["USER_NAME"]=$ROW["USER_NAME"];
      
      $LEADER2_NAME="";
      $TOK=strtok($TO_ID4,",");
      while($TOK!="")
      {
         $LEADER2_NAME.=$TO_ARRAY[$TOK]["USER_NAME"].",";
         $TOK=strtok(",");
      }
      $LEADER2_NAME=trim($LEADER2_NAME,",");

      if($DEPT_PRIV==1)
      {
      	 $OPTION_TEXT.="
  <tr class=TableData>
    <td>".$DEEP_COUNT1."├".$DEPT_NAME."</td>
    <td>".$MANAGER_NAME."</td>
    <td>".$LEADER1_NAME."</td>
    <td>".$LEADER2_NAME."</td>
    <td>".$TEL_NO."</td>
    <td>".$FAX_NO."</td>
    <td style=\"cursor:hand\" title=\"$DEPT_FUNC\">".csubstr(strip_tags($DEPT_FUNC),0,30).(strlen($DEPT_FUNC)>30?"...":"")."</td>
  </tr>";
      }

      if($OPTION_TEXT_CHILD!="")
         $OPTION_TEXT.=$OPTION_TEXT_CHILD;

  }//while

  $DEEP_COUNT=$DEEP_COUNT1;
  return $OPTION_TEXT;
}

$OPTION_TEXT=dept_tree_list(0,0);

if($OPTION_TEXT=="")
   Message("提示","尚未定义部门");
else
 {
?>
  <table class="TableList" width="90%" align="center">
    <tr class="TableHeader">
      <td nowrap align="center">部门/成员单位</td>
      <td nowrap align="center">部门主管</td>
      <td nowrap align="center">上级主管领导</td>
      <td nowrap align="center">上级分管领导</td>
      <td nowrap align="center">电话</td>
      <td nowrap align="center">传真</td>
      <td align="center">职能</td>
    </tr>
    <?=$OPTION_TEXT?>
  </table>
<?
 }
?>

</body>
</html>

⌨️ 快捷键说明

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