📄 mytable.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％源码
💻 PHP
字号:
<?php
 

$pagestarttime = microtime( );
$MYTABLE_CSS = 1;
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/reg_check.php" );
if ( $OA_REG_ON != 2 )
{
	exit( );
}
echo "\r\n<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml10-transitional.dtd\">\r\n<html lang=\"zh-cn\" xml:lang=\"zh-cn\" xmlns=\"http://www.w3.org/1999/xhtml\">\r\n<html>\r\n<head>\r\n<title>我的办公桌</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<link rel=\"stylesheet\" type=\"text/css\" href=\"/theme/";
echo $LOGIN_THEME;
echo "/style.css\">\r\n<link rel=\"stylesheet\" type=\"text/css\" href=\"/theme/";
echo $LOGIN_THEME;
echo "/mytable.css\">\r\n<script src=\"/inc/mytable.js\"></script>\r\n<script Language=JavaScript>\r\nwindow.setTimeout('this.location.reload();',1200000);\r\nvar lines_per_page=";
if ( isset( $my_nums_1 ) )
{
	echo $my_nums_1;
}
else
{
	echo "5";
}
echo ";\r\nvar my_scroll=";
if ( isset( $_COOKIE[my_scroll_1] ) )
{
	echo $_COOKIE[my_scroll_1];
}
else
{
	echo "false";
}
echo ";\r\nvar my_width=";
if ( isset( $my_width_1 ) )
{
	echo $my_width_1;
}
else
{
	echo "65";
}
echo ";\r\nfunction _edit()\r\n{\r\n\t show_msg(\"optionBlock\");\r\n\t \$('display_lines').focus();\r\n\t \$('display_lines').value=lines_per_page;\r\n\t \$('scroll').checked=my_scroll;\r\n\t \$('col_width').value=my_width;\r\n}\r\nfunction SetNums()\r\n{\r\n\t var today_lines=\$('display_lines').value;\r\n\t var col_width=\$('col_width').value;\r\n   if(today_lines==\"\" || checkNum(today_lines) || col_width==\"\" || checkNum(col_width))\r\n   {\r\n      alert(\"显示条数和栏目宽度必须是数字\");\r\n      return;\r\n   }\r\n\r\n   if(parseInt(today_lines)<=0 || parseInt(today_lines)>=1000)\r\n   {\r\n      alert(\"显示条数必须在1-1000之间\");\r\n      return;\r\n   }\r\n   if(parseInt(col_width)<=0 || parseInt(col_width)>100)\r\n   {\r\n      alert(\"栏目宽度必须在1-100之间\");\r\n      return;\r\n   }\r\n   setCookie(\"my_nums_1\", today_lines);\r\n   setCookie(\"my_scroll_1\", \$('scroll').checked);\r\n   setCookie(\"my_width_1\", col_width);\r\n\r\n   lines_per_page=today_lines;\r\n   my_scroll=\$('scroll').checked;\r\n   my_width=col_width;\r\n\r\n   \$(\"msgBody\").style.display = \"none\";\r\n   \$(\"msgCommand\").style.display = \"none\";\r\n   \$(\"msgSuccess\").style.display = \"block\";\r\n   \r\n   window.location.reload();\r\n}\r\n</script>\r\n</head>\r\n\r\n";
$query = "SELECT MYTABLE_LEFT,MYTABLE_RIGHT,NOT_VIEW_TABLE,BKGROUND from USER where USER_ID='".$LOGIN_USER_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$USER_MODULE_LEFT = $ROW['MYTABLE_LEFT'];
	$USER_MODULE_RIGHT = $ROW['MYTABLE_RIGHT'];
	$NOT_VIEW_TABLE = $ROW['NOT_VIEW_TABLE'];
	$BKGROUND = $ROW['BKGROUND'];
}
echo "\r\n<body ";
if ( $BKGROUND == "" )
{
	echo "class=timebar";
}
else
{
	echo "bgcolor=#CEDFF1";
}
echo " background=\"";
echo $BKGROUND;
echo "\" topmargin=\"5\" leftmargin=\"5\">\r\n\r\n<table width=\"100%\" height=\"100%\" border=\"0\" cellpadding=\"1\" cellspacing=\"0\">\r\n <tr>\r\n  <td id=\"col_l\" width=\"65%\" valign=\"top\">\r\n\r\n";
$query = "SELECT * from MYTABLE where VIEW_TYPE='2' and (DEPT_ID='ALL_DEPT' or find_in_set('".$LOGIN_DEPT_ID."',DEPT_ID) or find_in_set('{$LOGIN_USER_PRIV}',PRIV_ID) or find_in_set('{$LOGIN_USER_ID}',USER_ID)) order by MODULE_NO";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$MODULE_ID = $ROW['MODULE_ID'];
	$MODULE_POS = $ROW['MODULE_POS'];
	if ( find_id( $USER_MODULE_LEFT, $MODULE_ID ) || find_id( $USER_MODULE_RIGHT, $MODULE_ID ) )
	{
		if ( $MODULE_POS == "l" && $USER_MODULE_LEFT != "ALL" )
		{
			$USER_MODULE_LEFT .= $MODULE_ID.",";
		}
		else if ( !( $MODULE_POS == "r" ) && !( $USER_MODULE_RIGHT != "ALL" ) )
		{
			$USER_MODULE_RIGHT .= $MODULE_ID.",";
		}
	}
}
$query = "SELECT * from MYTABLE where VIEW_TYPE='3' and (DEPT_ID='ALL_DEPT' or find_in_set('".$LOGIN_DEPT_ID."',DEPT_ID) or find_in_set('{$LOGIN_USER_PRIV}',PRIV_ID) or find_in_set('{$LOGIN_USER_ID}',USER_ID)) order by MODULE_NO";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$MODULE_STR_HIDDEN .= $ROW['MODULE_ID'].",";
}
if ( $NOT_VIEW_TABLE )
{
	echo "   <br><br><br>\r\n   <div align=center style=\"color:#000000;filter:dropshadow(color=#FFFFFF,offx=1,offy=1,positive=1); WIDTH: 100%; FONT-SIZE: 30pt;\"><i>欢迎使用本系统</i></div>\r\n";
	exit( );
}
if ( $USER_MODULE_LEFT == "ALL" )
{
	$query = "SELECT * from MYTABLE where MODULE_POS='l' and VIEW_TYPE!='3' and (DEPT_ID='ALL_DEPT' or find_in_set('".$LOGIN_DEPT_ID."',DEPT_ID) or find_in_set('{$LOGIN_USER_PRIV}',PRIV_ID) or find_in_set('{$LOGIN_USER_ID}',USER_ID)) order by MODULE_NO";
	$cursor_module = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor_module ) )
	{
		$MODULE_LEFT_STR .= $ROW['MODULE_ID'].",";
	}
}
else
{
	$MODULE_LEFT_STR = $USER_MODULE_LEFT;
}
$MODULE_ARRAY = explode( ",", $MODULE_LEFT_STR );
$MODULE_ARRAY_COUNT = sizeof( $MODULE_ARRAY );
if ( $MODULE_ARRAY[$MODULE_ARRAY_COUNT - 1] == "" )
{
	--$MODULE_ARRAY_COUNT;
}
$MODULE_I = 0;
for ( ;	$MODULE_I < $MODULE_ARRAY_COUNT;	++$MODULE_I	)
{
	if ( !find_id( $MODULE_STR_HIDDEN, $MODULE_ARRAY[$MODULE_I] ) )
	{
		$query = "SELECT * from MYTABLE where MODULE_ID='".$MODULE_ARRAY[$MODULE_I]."' and (DEPT_ID='ALL_DEPT' or find_in_set('{$LOGIN_DEPT_ID}',DEPT_ID) or find_in_set('{$LOGIN_USER_PRIV}',PRIV_ID) or find_in_set('{$LOGIN_USER_ID}',USER_ID))";
		$cursor_module = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor_module ) )
		{
			$MODULE_ID = $ROW['MODULE_ID'];
			$VIEW_TYPE = $ROW['VIEW_TYPE'];
			$MODULE_FILE = $ROW['MODULE_FILE'];
			if ( file_exists( "../../general/mytable/".$MODULE_FILE ) )
			{
				include( "../../general/mytable/".$MODULE_FILE );
			}
		}
	}
}
echo "  <div></div>\r\n  </td>\r\n  <td width=\"10\"></td>\r\n\r\n\r\n  <td id=\"col_r\" align=\"left\" valign=\"top\">\r\n";
if ( $USER_MODULE_RIGHT == "ALL" )
{
	$query = "SELECT * from MYTABLE where MODULE_POS='r' and VIEW_TYPE!='3' and (DEPT_ID='ALL_DEPT' or find_in_set('".$LOGIN_DEPT_ID."',DEPT_ID) or find_in_set('{$LOGIN_USER_PRIV}',PRIV_ID) or find_in_set('{$LOGIN_USER_ID}',USER_ID)) order by MODULE_NO";
	$cursor_module = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor_module ) )
	{
		$MODULE_RIGHT_STR .= $ROW['MODULE_ID'].",";
	}
}
else
{
	$MODULE_RIGHT_STR = $USER_MODULE_RIGHT;
}
$MODULE_ARRAY = explode( ",", $MODULE_RIGHT_STR );
$MODULE_ARRAY_COUNT = sizeof( $MODULE_ARRAY );
if ( $MODULE_ARRAY[$MODULE_ARRAY_COUNT - 1] == "" )
{
	--$MODULE_ARRAY_COUNT;
}
$MODULE_I = 0;
for ( ;	$MODULE_I < $MODULE_ARRAY_COUNT;	++$MODULE_I	)
{
	if ( !find_id( $MODULE_STR_HIDDEN, $MODULE_ARRAY[$MODULE_I] ) )
	{
		$query = "SELECT * from MYTABLE where MODULE_ID='".$MODULE_ARRAY[$MODULE_I]."' and (DEPT_ID='ALL_DEPT' or find_in_set('{$LOGIN_DEPT_ID}',DEPT_ID) or find_in_set('{$LOGIN_USER_PRIV}',PRIV_ID) or find_in_set('{$LOGIN_USER_ID}',USER_ID))";
		$cursor_module = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor_module ) )
		{
			$MODULE_ID = $ROW['MODULE_ID'];
			$VIEW_TYPE = $ROW['VIEW_TYPE'];
			$MODULE_FILE = $ROW['MODULE_FILE'];
			if ( file_exists( "../../general/mytable/".$MODULE_FILE ) )
			{
				include( "../../general/mytable/".$MODULE_FILE );
			}
		}
	}
}
echo "<div align=center class=small>\r\n<a href=\"/general/person_info/mytable/image.php?OPEN_FLAG=1\">设置桌面背景</a>\r\n</div>\r\n<div></div>\r\n  </td>\r\n </tr>\r\n</table>\r\n<script>\r\n<!--\r\n_upc(2);\r\n//-->\r\n</script>\r\n<div id=\"overlay\"></div>\r\n<div id=\"optionBlock\" class=\"dialogBlock module\" style=\"display: none;width:300px;\">\r\n  <h4 class=\"moduleHeader\"><span class=\"title\">桌面全局选项</span><a class=\"option\" href=\"javascript:hide_msg('optionBlock');\"><img src=\"/images/close.png\"/></a></h4>\r\n  <div id=\"msgBody\" class=\"module_body\">\r\n    <br/>&nbsp;&nbsp;每个模块显示的行数：<input type=\"text\" id=\"display_lines\" class=\"SmallInput\" size=\"5\" value=\"5\"/>\r\n    <br/>&nbsp;&nbsp;<label for=\"scroll\">列表上下滚动显示</label><input type=\"checkbox\" id=\"scroll\"/>\r\n    <br/>&nbsp;&nbsp;左侧栏目宽度：<input type=\"text\" id=\"col_width\" class=\"SmallInput\" size=\"5\" value=\"65\"/>%\r\n  </div>\r\n  <div id=\"msgCommand\" class=\"moduleFooter\">\r\n    <input class=\"BigButton\" onclick=\"SetNums()\" type=\"button\" value=\"确定\"/>&nbsp;&nbsp;\r\n    <input class=\"BigButton\" onclick=\"hide_msg('optionBlock')\" type=\"button\" value=\"取消\"/>\r\n  </div>\r\n  <div id=\"msgSuccess\" style=\"display:none;\" class=\"moduleFooter\">\r\n     <h2>保存成功！</h2><input type=\"button\" class=\"BigButton\" onclick=\"hide_msg('optionBlock')\" value=\"关闭\"/>\r\n  </div>\r\n</div>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明

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