index.php
来自「通达网络办公 - Office Anywhere 2008 增强版100％源码(」· PHP 代码 · 共 108 行
PHP
108 行
<?php
function dept_tree_list( $DEPT_ID, $PRIV_OP )
{
global $DEEP_COUNT;
global $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 .= "\r\n <tr class=TableData>\r\n <td>".$DEEP_COUNT1."├".$DEPT_NAME."</td>\r\n <td>".$MANAGER_NAME."</td>\r\n <td>".$LEADER1_NAME."</td>\r\n <td>".$LEADER2_NAME."</td>\r\n <td>".$TEL_NO."</td>\r\n <td>".$FAX_NO.( "</td>\r\n <td style=\"cursor:hand\" title=\"".$DEPT_FUNC."\">" ).csubstr( strip_tags( $DEPT_FUNC ), 0, 30 ).( 30 < strlen( $DEPT_FUNC ) ? "..." : "" )."</td>\r\n </tr>";
}
if ( $OPTION_TEXT_CHILD != "" )
{
$OPTION_TEXT .= $OPTION_TEXT_CHILD;
}
}
$DEEP_COUNT = $DEEP_COUNT1;
return $OPTION_TEXT;
}
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/utility_org.php" );
echo "\r\n<html>\r\n<head>\r\n<title>部门/成员单位信息</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/menu/infofind.gif\" align=\"absmiddle\"><span class=\"big3\"> 部门/成员单位信息</span>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<br>\r\n\r\n";
$OPTION_TEXT = dept_tree_list( 0, 0 );
if ( $OPTION_TEXT == "" )
{
message( "提示", "尚未定义部门" );
}
else
{
echo " <table class=\"TableList\" width=\"90%\" align=\"center\">\r\n <tr class=\"TableHeader\">\r\n <td nowrap align=\"center\">部门/成员单位</td>\r\n <td nowrap align=\"center\">部门主管</td>\r\n <td nowrap align=\"center\">上级主管领导</td>\r\n <td nowrap align=\"center\">上级分管领导</td>\r\n <td nowrap align=\"center\">电话</td>\r\n <td nowrap align=\"center\">传真</td>\r\n <td align=\"center\">职能</td>\r\n </tr>\r\n ";
echo $OPTION_TEXT;
echo " </table>\r\n";
}
echo "\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?