📄 user.php

📁 通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含通达OA2008增強版接近完美破解补丁20081216集及最新通达OA2008ADV(
💻 PHP
字号:
<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "general/workflow/prcs_role.php" );
include_once( "inc/user_online.php" );
if ( $INTEL != 2 )
{
	$PRCS_ID_I = 1;
	for ( ;	$PRCS_ID_I <= $PRCS_ID;	++$PRCS_ID_I	)
	{
		$query = "SELECT USER_ID from FLOW_RUN_PRCS where RUN_ID=".$RUN_ID." and PRCS_ID={$PRCS_ID_I}";
		$cursor = exequery( $connection, $query );
		$USER_NAME_STR = "";
		while ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$USER_ID = $ROW['USER_ID'];
			if ( !find_id( $HISTORY_USER_ID, $USER_ID ) )
			{
				$HISTORY_USER_ID .= $USER_ID.",";
			}
		}
	}
}
if ( $PRCS_ID_NEXT == "" )
{
	$QUERY_PRIV = "";
}
else
{
	$query = "SELECT PRCS_USER,PRCS_DEPT,PRCS_PRIV,USER_FILTER from FLOW_PROCESS where FLOW_ID=".$FLOW_ID." and PRCS_ID={$PRCS_ID_NEXT}";
	$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'];
		$USER_FILTER = $ROW['USER_FILTER'];
	}
	$QUERY_PRIV = " and (1=2 ";
	if ( $PRCS_USER != "" )
	{
		$QUERY_PRIV .= " or FIND_IN_SET(USER.USER_ID,'".$PRCS_USER."')";
	}
	if ( $PRCS_DEPT != "" )
	{
		if ( $PRCS_DEPT == "ALL_DEPT" )
		{
			$QUERY_PRIV .= " or 1=1";
		}
		else
		{
			if ( substr( $PRCS_DEPT, -1, 1 ) == "," )
			{
				$PRCS_DEPT = substr( $PRCS_DEPT, 0, -1 );
			}
			$QUERY_PRIV .= " or DEPT_ID in(".$PRCS_DEPT.")";
		}
	}
	if ( $PRCS_PRIV != "" )
	{
		if ( substr( $PRCS_PRIV, -1, 1 ) == "," )
		{
			$PRCS_PRIV = substr( $PRCS_PRIV, 0, -1 );
		}
		$QUERY_PRIV .= " or USER.USER_PRIV in(".$PRCS_PRIV.")".flow_other_sql( $PRCS_PRIV );
	}
	$QUERY_PRIV .= ") ";
	if ( $USER_FILTER == "1" )
	{
		$QUERY_PRIV .= " and USER.DEPT_ID='".$LOGIN_DEPT_ID."'";
	}
	else if ( $USER_FILTER == "2" )
	{
		$QUERY_PRIV .= " and USER.USER_PRIV='".$LOGIN_USER_PRIV."'";
	}
}
echo "<html>\r\n<head>\r\n<title></title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<style>\r\n.menulines{}\r\n</style>\r\n<script src=\"/inc/js/utility.js\"></script>\r\n<script src=\"./user_select.js\"></script>\r\n<script>\r\nvar parent_window = getOpenner();\r\nvar top_flag = parent_window.form1.TOP_FLAG";
echo $LINE_COUNT;
echo ".value;\r\nvar op_user = parent_window.getElementById('PRCS_OP_USER";
echo $LINE_COUNT;
echo "');\r\nvar op_user_name = parent_window.getElementById('PRCS_OP_USER_NAME";
echo $LINE_COUNT;
echo "');\r\nvar prcs_user = parent_window.getElementById('PRCS_USER";
echo $LINE_COUNT;
echo "');\r\nvar prcs_user_name = parent_window.getElementById('PRCS_USER_NAME";
echo $LINE_COUNT;
echo "');\r\n\r\nvar DEL_IMG0='<img src=\"/images/remove.png\" align=\"absmiddle\" onclick=cancel_user(this,0,\"";
echo $LINE_COUNT;
echo "\")>';\r\nvar DEL_IMG1='<img src=\"/images/remove.png\" align=\"absmiddle\" onclick=cancel_user(this,1,\"";
echo $LINE_COUNT;
echo "\")>';\r\n\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"1\" leftmargin=\"0\" onload=\"begin_set();\">\r\n";
if ( $INTEL == "2" )
{
	echo "<table width=\"100%\" class=\"TableBlock\">\r\n<tr class=\"TableHeader\">\r\n  <td colspan=\"2\" align=\"center\"><b>按流程选择</b></td>\r\n</tr>\r\n";
	$USER_COUNT = 0;
	$PRCS_ID_I = 1;
	for ( ;	$PRCS_ID_I <= $PRCS_ID;	++$PRCS_ID_I	)
	{
		$query = "SELECT USER.UID,USER.USER_ID,USER_NAME,DEPT_ID,FLOW_PRCS,SEX from FLOW_RUN_PRCS,USER where FLOW_RUN_PRCS.USER_ID=USER.USER_ID and RUN_ID=".$RUN_ID." and PRCS_ID={$PRCS_ID_I} ";
		$query .= " and DEPT_ID!=0 and NOT_LOGIN!='1' ".$QUERY_PRIV." order by PRCS_FLAG desc,PRCS_TIME";
		$cursor = exequery( $connection, $query );
		$PRCS_COUNT = 0;
		while ( $ROW = mysql_fetch_array( $cursor ) )
		{
			++$USER_COUNT;
			++$PRCS_COUNT;
			$UID = $ROW['UID'];
			$USER_ID = $ROW['USER_ID'];
			$USER_NAME = $ROW['USER_NAME'];
			$FLOW_PRCS = $ROW['FLOW_PRCS'];
			$DEPT_ID = $ROW['DEPT_ID'];
			$DEPT_LONG_NAME = dept_long_name( $DEPT_ID );
			$SEX = $ROW['SEX'];
			if ( $SEX == "" )
			{
				$SEX = "0";
			}
			if ( $USER_COUNT == 1 )
			{
				echo "<tr class=\"TableData\">\r\n  <td onclick=\"javascript:add_all();\" style=\"cursor:pointer\" align=\"center\" colspan=\"2\">全部添加</td>\r\n</tr>\r\n<tr class=\"TableData\">\r\n  <td onclick=\"javascript:del_all();\" style=\"cursor:pointer\" align=\"center\" colspan=\"2\">全部删除</td>\r\n</tr>\r\n";
			}
			if ( $PRCS_COUNT == 1 )
			{
				$query1 = "SELECT PRCS_NAME from FLOW_PROCESS where FLOW_ID=".$FLOW_ID." and PRCS_ID={$FLOW_PRCS}";
				$cursor1 = exequery( $connection, $query1 );
				if ( $ROW = mysql_fetch_array( $cursor1 ) )
				{
					$PRCS_NAME = $ROW['PRCS_NAME'];
				}
				echo "          <tr class=\"TableHeader\">\r\n             <td colspan=\"2\" align=\"center\"><b>第";
				echo $PRCS_ID_I;
				echo "步:";
				echo $PRCS_NAME;
				echo "</b></td>\r\n          </tr>\r\n";
			}
			echo "<tr class=\"TableData\">\r\n  <td title=\"设为主办人\" nowrap class=\"menulines_op\" id=\"";
			echo $USER_ID;
			echo "_op\" name=\"";
			echo $USER_NAME;
			echo "\" width=\"55\" align=\"center\" onclick=\"javascript:click_op('";
			echo $USER_ID;
			echo "_op')\" style=\"cursor:pointer\">\r\n  <input type=\"checkbox\" id=\"opbox_";
			echo $USER_ID;
			echo "\">主办\r\n  </td>\r\n  <td title=\"";
			echo $DEPT_LONG_NAME;
			echo "\" class=\"menulines\" id=\"";
			echo $USER_ID;
			echo "\" name=\"";
			echo $USER_NAME;
			echo "\" width=\"90%\" align=\"center\" onclick=\"javascript:click_user('";
			echo $USER_ID;
			echo "')\" style=\"cursor:pointer\">\r\n  <font color=red>";
			echo $USER_NAME;
			echo " </font>";
			if ( array_key_exists( $UID, $SYS_ONLINE_USER ) )
			{
				echo "<img align=\"absmiddle\" src=\"/images/".$SEX."-1.gif\" title=\"在线\">";
			}
			echo "  </td>\r\n</tr>\r\n";
		}
	}
	if ( $USER_COUNT == 0 )
	{
		echo "<tr class=\"TableControl\">\r\n  <td align=\"center\">无符合条件的用户</td>\r\n</tr>\r\n";
	}
	exit( );
}
if ( $INTEL == "1" )
{
	$query = "SELECT UID,USER_ID,USER_NAME,DEPT_ID,SEX 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 UID,USER_ID,USER_NAME,DEPT_ID,SEX 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 DEPT_NAME 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 UID,USER_ID,USER_NAME,DEPT_ID,SEX 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 PRIV_NAME from USER_PRIV where USER_PRIV='".$USER_PRIV."'";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$TITLE = $ROW['PRIV_NAME'];
	}
}
echo "\r\n<table width=\"100%\" class=\"TableBlock\">\r\n<tr class=\"TableHeader\">\r\n  <td colspan=\"2\" align=\"center\"><b>";
echo $TITLE;
echo "</b></td>\r\n</tr>\r\n\r\n";
$cursor = exequery( $connection, $query );
$USER_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$USER_COUNT;
	if ( $INTEL == "1" && $LIST_ALL != 1 && 20 < $USER_COUNT )
	{
		echo "   \t<tr class=\"TableData\">\r\n     <td onclick=\"location='user.php?INTEL=1&LIST_ALL=1&FLOW_ID=";
		echo $FLOW_ID;
		echo "&RUN_ID=";
		echo $RUN_ID;
		echo "&PRCS_ID=";
		echo $PRCS_ID;
		echo "&PRCS_ID_NEXT=";
		echo $PRCS_ID_NEXT;
		echo "&LINE_COUNT=";
		echo $LINE_COUNT;
		echo "'\" style=\"cursor:pointer\" align=\"center\" colspan=\"2\">显示更多...</td>\r\n    </tr>\r\n";
	}
	else
	{
		$UID = $ROW['UID'];
		$USER_ID = $ROW['USER_ID'];
		$USER_NAME = $ROW['USER_NAME'];
		$DEPT_ID = $ROW['DEPT_ID'];
		$DEPT_LONG_NAME = dept_long_name( $DEPT_ID );
		$SEX = $ROW['SEX'];
		if ( $SEX == "" )
		{
			$SEX = "0";
		}
		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=\"TableData\">\r\n <td onclick=\"javascript:add_all();\" style=\"cursor:pointer\" align=\"center\" colspan=\"2\">全部添加</td>\r\n</tr>\r\n<tr class=\"TableData\">\r\n <td onclick=\"javascript:del_all();\" style=\"cursor:pointer\" align=\"center\" colspan=\"2\">全部删除</td>\r\n</tr>\r\n";
		}
		echo "\r\n<tr class=\"TableData\">\r\n  <td title=\"设为主办人\" nowrap class=\"menulines_op\" id=\"";
		echo $USER_ID;
		echo "_op\" name=\"";
		echo $USER_NAME;
		echo "\" width=\"55\" align=\"center\" onclick=\"javascript:click_op('";
		echo $USER_ID;
		echo "_op')\" style=\"cursor:pointer\">\r\n  <input type=\"checkbox\" id=\"opbox_";
		echo $USER_ID;
		echo "\">主办\r\n  </td>\r\n  <td title=\"";
		echo $DEPT_LONG_NAME;
		echo "\" class=\"menulines\" id=\"";
		echo $USER_ID;
		echo "\" name=\"";
		echo $USER_NAME;
		echo "\" width=\"90%\" align=\"center\" onclick=\"javascript:click_user('";
		echo $USER_ID;
		echo "')\" style=\"cursor:pointer\">\r\n  ";
		echo $USER_NAME_DESC;
		echo " ";
		if ( array_key_exists( $UID, $SYS_ONLINE_USER ) )
		{
			echo "<img align=\"absmiddle\" src=\"/images/".$SEX."-1.gif\" title=\"在线\">";
		}
		echo "  </td>\r\n</tr>\r\n\r\n";
	}
}
if ( $USER_PRIV != "" )
{
	$query = "SELECT UID,USER_ID,USER_NAME,SEX 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;
		$UID = $ROW['UID'];
		$USER_ID = $ROW['USER_ID'];
		$USER_NAME = $ROW['USER_NAME'];
		$SEX = $ROW['SEX'];
		if ( $SEX == "" )
		{
			$SEX = "0";
		}
		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\">\r\n  <td colspan=\"2\" align=\"center\"><b>辅助角色</b></td>\r\n</tr>\r\n";
		}
		echo "\r\n<tr class=\"TableData\">\r\n  <td title=\"设为主办人\" nowrap class=\"menulines_op\" id=\"";
		echo $USER_ID;
		echo "_op\" name=\"";
		echo $USER_NAME;
		echo "\" width=\"55\" align=\"center\" onclick=\"javascript:click_op('";
		echo $USER_ID;
		echo "_op')\" style=\"cursor:pointer\">\r\n  <input type=\"checkbox\" id=\"opbox_";
		echo $USER_ID;
		echo "\">主办\r\n  </td>\r\n  <td title=\"";
		echo $DEPT_LONG_NAME;
		echo "\" class=\"menulines\" id=\"";
		echo $USER_ID;
		echo "\" name=\"";
		echo $USER_NAME;
		echo "\" width=\"90%\" align=\"center\" onclick=\"javascript:click_user('";
		echo $USER_ID;
		echo "')\" style=\"cursor:pointer\">\r\n  ";
		echo $USER_NAME_DESC;
		echo " ";
		if ( array_key_exists( $UID, $SYS_ONLINE_USER ) )
		{
			echo "<img align=\"absmiddle\" src=\"/images/".$SEX."-1.gif\" title=\"在线\">";
		}
		echo "  </td>\r\n</tr>\r\n\r\n";
	}
}
if ( $USER_COUNT == 0 )
{
	echo "<tr class=\"TableControl\">\r\n  <td align=\"center\">无符合条件的用户</td>\r\n</tr>\r\n";
}
echo "\r\n</table>\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明

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