insert.php

泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。

<?php

function getfuncidofsysmenu( )
{
	global $connection;
	$sql = "\r\n\t\t\tSELECT MAX(FUNC_ID) as cnt FROM sys_function \r\n\t\t\t\tWHERE  FUNC_ID>=1000 \r\n\t\t\t";
	$rs = exequery( $connection, $sql );
	$row = mysql_fetch_array( $rs );
	$func_id = $row['cnt'];
	if ( $func_id < 1000 )
	{
		$func_id = 1000;
	}
	else if ( 2000 < $func_id )
	{
		$sql = "\r\n\t\t        SELECT MENU_ID \r\n\t\t           FROM sys_function  \r\n\t\t\t\t\tWHERE LENGTH(MENU_ID)=2\r\n\t\t\t\t";
		$rs = exequery( $connection, $sql );
		while ( $row = mysql_fetch_array( $rs ) )
		{
			$needle[] = $row['MENU_ID'];
		}
		if ( is_array( $needle ) )
		{
			$i = 1000;
			for ( ;	$i < 2000;	++$i	)
			{
				if ( !( in_array( $i, $needle ) == false ) )
				{
					continue;
				}
				$func_id = $i;
			}
		}
	}
	else
	{
		$func_id = $func_id + 1;
	}
	return $func_id;
}

function getmenuidofsysmenu( $parent_menuid = "" )
{
	global $connection;
	$menu_length = strlen( $parent_menuid );
	$menu_pos = strlen( $parent_menuid ) + 1;
	$sql = ( " \r\n\t          SELECT MAX(SUBSTRING(MENU_ID,{$menu_pos},2)) AS cnt FROM sys_function \r\n\t\t\t\t  WHERE LENGTH(MENU_ID)=".( $menu_length + 2 ) )."\r\n\t\t\t  ";
	if ( 0 < $parent_menuid )
	{
		$sql .= " AND LEFT(MENU_ID,{$menu_length})={$parent_menuid}";
	}
	$rs = exequery( $connection, $sql );
	$row = mysql_fetch_array( $rs );
	$max_menu_id = $row['cnt'];
	if ( $max_menu_id == "" )
	{
		$part_menu_id = 1;
	}
	else
	{
		$part_menu_id = abs( substr( $max_menu_id, -2 ) ) + 1;
	}
	if ( 99 < $part_menu_id )
	{
		$sql = ( "\r\n\t\t        SELECT SUBSTRING(MENU_ID,{$menu_pos},2) as cnt \r\n\t\t           FROM sys_function \r\n\t\t\t\t\tWHERE LENGTH(MENU_ID)=".( $menu_length + 2 ) )."\r\n\t\t\t\t\r\n\t\t\t\t";
		if ( 0 < $parent_menuid )
		{
			$sql .= " AND LEFT(MENU_ID,{$menu_length})={$parent_menuid}";
		}
		$rs = exequery( $connection, $sql );
		while ( $row = mysql_fetch_array( $rs ) )
		{
			$needle[] = $row['cnt'];
		}
		if ( is_array( $needle ) )
		{
			$i = 0;
			for ( ;	$i < 100;	++$i	)
			{
				if ( in_array( $i, $needle ) == false )
				{
					$part_menu_id = $i;
				}
			}
		}
	}
	if ( $parent_menuid == "" && ( $part_menu_id < 80 || 89 < $part_menu_id ) )
	{
		$sql = "\r\n\t\tSELECT LEFT(MENU_ID,2) as cnt \r\n\t\t   FROM sys_function \r\n\t\t\tWHERE  LENGTH(MENU_ID)=2\r\n\t\t";
		$rs = exequery( $connection, $sql );
		unset( $needle );
		while ( $row = mysql_fetch_array( $rs ) )
		{
			$needle[] = $row['cnt'];
		}
		if ( is_array( $needle ) )
		{
			$i = 80;
			for ( ;	$i < 89;	++$i	)
			{
				if ( in_array( $i, $needle ) == false )
				{
					$part_menu_id = $i;
				}
			}
		}
		else
		{
			$part_menu_id = 80;
		}
		if ( $part_menu_id < 80 || 89 < $part_menu_id )
		{
			return false;
		}
	}
	if ( $part_menu_id <= 0 || 99 < $part_menu_id )
	{
		return false;
	}
	else
	{
		$part_menu_id = formatnumt( $part_menu_id );
		$menu_id = $parent_menuid.$part_menu_id;
		return $menu_id;
	}
}

function getorderidofusermenu( $parent_menuid )
{
	global $connection;
	$menu_length = strlen( $parent_menuid );
	$menu_pos = strlen( $parent_menuid ) + 1;
	$sql = ( "\r\n\t\t\tSELECT MAX(ORDER_ID) as cnt \r\n\t\t\t   FROM user_menu \r\n\t\t\t\tWHERE USER_ID='".$_SESSION['LOGIN_USER_ID']."' \r\n\t\t\t\tAND LENGTH(MENU_ID)=".( $menu_length + 2 ) )."\r\n\t\t\t\r\n\t\t\t";
	if ( 0 < $parent_menuid )
	{
		$sql .= " AND LEFT(MENU_ID,{$menu_length})={$parent_menuid}";
	}
	$rs = exequery( $connection, $sql );
	$row = mysql_fetch_array( $rs );
	$order_id = $row['cnt'] + 1;
	return $order_id;
}

function formatnumt( $n )
{
	$length = strlen( $n );
	if ( $length == 1 )
	{
		$n = "0".$n;
	}
	return $n;
}

function htmlview( $title, $text )
{
	$html = "<link rel=\"stylesheet\" type=\"text/css\" href=\"/theme/1/style.css\">\r\n\r\n<script language=\"javascript\">\r\nfunction highlight(obj){\r\n\tvar hightlightBgColor = '#d6d6d6';\r\n\t\tobj.onmouseover = function(){\r\n\t\tvar o = event.srcElement;\r\n\r\n\t\tif(o.tagName==\"TD\"){\r\n\t\t\twith(o.parentElement){\r\n\t\t\t\tstyle.backgroundColor = hightlightBgColor;\r\n\t\t\t}\r\n\t\t}\r\n\t}\r\n\t\r\n\tobj.onmouseout = function(){\r\n\t\tvar o = event.srcElement;\r\n\t\tif(o.tagName==\"TD\"){o.parentElement.style.backgroundColor = '';}\r\n\t}\r\n}\r\n\r\n</script>\r\n\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<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"0\">\r\n  <tr class=\"tablehead1\">\r\n    <td><img src=\"/images/workflow.gif\"  align=\"absmiddle\"> 自定义菜单</td>\r\n  </tr>\r\n  <tr class=\"tablehead2\">\r\n    <td><a href=\"#\" onClick=\"location='blank.php'\"> <img src=\"/images/button/return.gif\" border=\"0\"></a> </td>\r\n  </tr>\r\n</table>\r\n<br>\r\n";
	echo $html;
	message( $title, $text );
	$html = "</body>\r\n</html>\r\n\r\n";
	echo $html;
}

include_once( "inc/auth.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";
$connection = openconnection( );
$query = "SELECT * from SYS_FUNCTION where MENU_ID='{$MENU_ID}'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	message( "提示", "菜单ID已存在！" );
	button_back( );
	exit( );
}
$FUNC_ID1 = getfuncidofsysmenu( );
$MENU_ID = getmenuidofsysmenu( );
if ( $FUNC_ID1 == false || $MENU_ID == false )
{
	htmlview( "注意", "您已不能再添加菜单！" );
	exit( );
}
$query = "insert into SYS_FUNCTION (FUNC_ID,MENU_ID,FUNC_NAME,FUNC_CODE,FUNC_FOLLOW,FUNC_SISSHOW ,FUNC_ISEOFFICE) values (".$FUNC_ID1.",'{$MENU_ID}','{$MENU_NAME}','".$FUNC_CODE1."',0,0,0)";
exequery( $connection, $query );
$sql = "SELECT USER_ID FROM user";
$rs = exequery( $connection, $sql );
while ( $row = mysql_fetch_array( $rs ) )
{
	$user_id = $row['USER_ID'];
	$func_id = $FUNC_ID1;
	$menu_id = $MENU_ID;
	$order_id = 0;
	$func_isshow = 1;
	$func_issys = 1;
	$func_name = $MENU_NAME;
	$func_code = $FUNC_CODE1;
	$func_follow = 0;
	$func_type = 0;
	$func_type_id = 0;
	$sql_u = "INSERT INTO user_menu VALUES (\r\n\t\t\t'{$user_id}',\r\n\t\t\t{$func_id},\r\n\t\t\t'{$menu_id}',\r\n\t\t\t{$order_id},\r\n\t\t\t{$func_isshow},\r\n\t\t\t{$func_issys},\r\n\t\t\t'{$func_name}',\r\n\t\t\t'{$func_code}',\r\n\t\t\t{$func_follow},\r\n\t\t\t\t{$func_type},\r\n\t\t\t\t'{$func_type_id}'\r\n\t\t\t)";
	exequery( $connection, $sql_u );
}
echo "\r\n";
echo "<s";
echo "cript>\r\nlocation.href = \"blank.php\";\r\nparent.menu_list.location.reload();\r\n</script>\r\n\r\n\r\n</body>\r\n</html>\r\n";
?>