📄 index.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( "inc/td_core.php" );
if ( $PROJ_ID )
{
	$query = "select * from PROJ_PROJECT WHERE PROJ_ID='".$PROJ_ID."'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$PROJ_NUM = $ROW['PROJ_NUM'];
		$PROJ_NAME = $ROW['PROJ_NAME'];
		$PROJ_TYPE = $ROW['PROJ_TYPE'];
		$PROJ_DEPT = $ROW['PROJ_DEPT'];
		$PROJ_DESCRIPTION = $ROW['PROJ_DESCRIPTION'];
		$PROJ_OWNER = $ROW['PROJ_OWNER'];
		$PROJ_VIWER = $ROW['PROJ_VIWER'];
		$PROJ_MANAGER = $ROW['PROJ_MANAGER'];
		$PROJ_START_TIME = $ROW['PROJ_START_TIME'];
		$PROJ_END_TIME = $ROW['PROJ_END_TIME'];
		$PROJ_USER = $ROW['PROJ_USER'];
		$PROJ_STATUS = $ROW['PROJ_STATUS'];
	}
	$query = "select USER_NAME from USER WHERE USER_ID='".$PROJ_OWNER."'";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$PROJ_OWNER_NAME .= $ROW['USER_NAME'];
	}
	if ( $PROJ_VIWER )
	{
		$query = "select USER_NAME from USER WHERE FIND_IN_SET(USER_ID,'".$PROJ_VIWER."')";
		$cursor = exequery( $connection, $query );
		while ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$PROJ_VIWER_NAME .= $ROW['USER_NAME'].",";
		}
	}
	else if ( $PROJ_MANAGER )
	{
		$query = "select USER_NAME from USER WHERE USER_ID='".$PROJ_MANAGER."'";
		$cursor = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$PROJ_MANAGER_NAME = $ROW['USER_NAME'];
		}
	}
	$query = "select COUNT(*) from PROJ_TASK WHERE PROJ_ID='".$PROJ_ID."'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$TASK_COUNT = $ROW[0];
	}
	if ( $PROJ_DEPT )
	{
		if ( $PROJ_DEPT == "ALL_DEPT" )
		{
			$PROJ_DEPT_NAME = "全体部门";
		}
		else
		{
			$query = "select DEPT_NAME from DEPARTMENT WHERE FIND_IN_SET(DEPT_ID,'".$PROJ_DEPT."')";
			$cursor = exequery( $connection, $query );
			while ( $ROW = mysql_fetch_array( $cursor ) )
			{
				$PROJ_DEPT_NAME .= $ROW['DEPT_NAME'].",";
			}
		}
	}
}
$IS_OK = 0;
if ( !$PROJ_ID )
{
	$MSG = "尚未保存项目信息，不能提交立项审批";
}
else if ( !$PROJ_USER )
{
	$MSG = "尚未定义项目成员，不能提交立项审批";
}
else if ( !$PROJ_MANAGER )
{
	$MSG = "尚未定义审批人员，不能提交立项审批";
}
else if ( $TASK_COUNT == 0 )
{
	$MSG = "尚未定义项目任务，不能提交立项审批";
}
else
{
	$IS_OK = 1;
}
$IMPORTANT_INFO = "<span style=\"color:red\">(*)</span>";
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<script src=\"/inc/js/module.js\"></script>\r\n<script src=\"/inc/js/attach.js\"></script>\r\n<script>\r\nfunction check()\r\n{\r\n";
if ( $IS_OK == 0 )
{
	echo "    alert(\"";
	echo $MSG;
	echo "\");\r\n    return(false);\r\n";
}
else
{
	echo "   msg='确认要提交项目申请么？\\n提交后将不能修改项目配置信息';\r\n   if(window.confirm(msg))\r\n   {\r\n  \tdocument.form1.action=\"approve.php\";\r\n  \tdocument.form1.submit();\r\n   }\r\n";
}
echo " \r\n}\r\nfunction check_form()\r\n{\r\n\tif(document.form1.PROJ_NUM.value==\"\" || document.form1.PROJ_NAME.value==\"\" || document.form1.PROJ_START_TIME.value==\"\" || document.form1.PROJ_END_TIME.value==\"\")\r\n\t{\r\n\t   alert(\"必填项目不能为空！\");\r\n\t   return(false);\r\n\t}\r\n  return(true)\r\n}\r\n</script>\r\n</head>\r\n<body class=\"bodycolor\">\r\n<form name=\"form1\" method=\"post\" action=\"submit.php\" name=\"form1\" onsubmit=\"return check_form();\">\r\n <table class=\"TableList\" border=\"0\" width=\"80%\" align=\"center\">\r\n    <tr>\r\n  \t\t<td nowrap class=\"TableContent\">项目创建人：</td>\r\n  \t  <td class=\"TableData\">\r\n  \t  \t";
echo $PROJ_OWNER_NAME != "" ? $PROJ_OWNER_NAME : $LOGIN_USER_NAME;
echo "  \t  </td>\r\n  \t</tr>\r\n  \t<tr>\r\n  \t\t<td nowrap class=\"TableContent\">项目编号：";
echo $IMPORTANT_INFO;
echo "</td>\r\n  \t  <td class=\"TableData\">\r\n  \t  \t<input type=\"text\" class=\"BigInput\" name=\"PROJ_NUM\" value=\"";
echo $PROJ_NUM;
echo "\" size=20>\r\n  \t  </td>  \t  \t\r\n  \t</tr>\r\n  \t<tr>\r\n  \t\t<td nowrap class=\"TableContent\">项目名称：";
echo $IMPORTANT_INFO;
echo "</td>\r\n  \t  <td class=\"TableData\"><input type=\"text\" class=\"BigInput\" name=\"PROJ_NAME\" value=\"";
echo $PROJ_NAME;
echo "\" size=20></td>  \t  \t\r\n  \t</tr>\r\n  \t<tr>\r\n  \t\t<td nowrap class=\"TableContent\">项目类别：</td>\r\n  \t  <td class=\"TableData\">\r\n  \t  \t<select name=\"PROJ_TYPE\" class=\"BigSelect\">\r\n  \t  \t ";
echo code_list( "PROJ_TYPE", $PROJ_TYPE );
echo "  \t  \t</select>\r\n  \t  </td>\t  \t\r\n  \t</tr>\r\n  \t<tr>\r\n  \t\t<td nowrap class=\"TableContent\">参与部门：</td>\r\n  \t  <td class=\"TableData\">\r\n  \t  \t<input type=\"hidden\" name=\"PROJ_DEPT\" value=\"";
echo $PROJ_DEPT;
echo "\">\r\n        <textarea cols=\"40\" name=\"PROJ_DEPT_NAME\" rows=\"2\" style=\"overflow-y:auto;\" class=\"BigStatic\" wrap=\"yes\" readonly>";
echo $PROJ_DEPT_NAME;
echo "</textarea>\r\n        <a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectDept('','PROJ_DEPT', 'PROJ_DEPT_NAME')\">添加</a>\r\n        <a href=\"javascript:;\" class=\"orgClear\" onClick=\"ClearUser('PROJ_DEPT', 'PROJ_DEPT_NAME')\">清空</a>\r\n     </td>\r\n  \t</tr>\r\n  \t<tr>\r\n  \t\t<td nowrap class=\"TableContent\">项目计划周期：";
echo $IMPORTANT_INFO;
echo "</td>\r\n  \t  <td class=\"TableData\"> \r\n  \t    <INPUT type=\"text\" readonly name=\"PROJ_START_TIME\" class=BigInput size=\"10\" value=\"";
echo $PROJ_START_TIME;
echo "\">\r\n        <img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.PROJ_START_TIME');\"> 至\r\n        <INPUT type=\"text\" readonly name=\"PROJ_END_TIME\" class=BigInput size=\"10\" value=\"";
echo $PROJ_END_TIME;
echo "\">\r\n        <img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.PROJ_END_TIME');\">\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n  \t\t<td nowrap class=\"TableContent\">项目描述：</td>\r\n  \t  <td class=\"TableData\">\r\n  \t  \t<textarea cols=\"60\" name=\"PROJ_DESCRIPTION\" rows=\"5\" style=\"overflow-y:auto;\" class=\"BigInput\" wrap=\"yes\">";
echo $PROJ_DESCRIPTION;
echo "</textarea>\r\n  \t  </td>\r\n  \t</tr>\r\n  \t<tr>\r\n     <td nowrap class=\"TableContent\">项目查看者：</td>\r\n     <td nowrap class=\"TableData\">\r\n     \t<INPUT type=\"hidden\" name=\"PROJ_VIWER\" value=\"";
echo $PROJ_VIWER;
echo "\">\r\n     \t<textarea name=\"PROJ_VIWER_NAME\" cols=\"40\" rows=\"2\" style=\"overflow-y:auto;\" class=\"BigStatic\" wrap=\"yes\" readonly>";
echo $PROJ_VIWER_NAME;
echo "</textarea>\r\n     \t<a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectUser('','PROJ_VIWER', 'PROJ_VIWER_NAME')\">选择</a>\r\n      <a href=\"javascript:;\" class=\"orgClear\" onClick=\"ClearUser('PROJ_VIWER', 'PROJ_VIWER_NAME')\">清空</a>\r\n     </td>\r\n   </tr>\r\n  \t<tr>\r\n     <td nowrap class=\"TableContent\">项目审批人：</td>\r\n     <td nowrap class=\"TableData\">\r\n";
if ( $EDIT_FLAG == 1 )
{
	echo $PROJ_MANAGER_NAME;
}
else
{
	echo "     \t <select name=\"PROJ_MANAGER\" class=\"BigSelect\">\r\n";
	$query = "SELECT * from PROJ_PRIV WHERE PRIV_CODE='APPROVE'";
	$cursor = exequery( $connection, $query );
	$MANAGER_COUNT = 0;
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$PRIV_USER = $ROW['PRIV_USER'];
		list( $APPROVE_USER, $MANAGE_DEPT ) = explode( "|", $PRIV_USER );
		if ( !find_id( $MANAGE_DEPT, $LOGIN_DEPT_ID ) || !( $MANAGE_DEPT == "ALL_DEPT" ) )
		{
			continue;
		}
		$query1 = "select USER_ID,USER_NAME from USER where find_in_set(USER_ID,'".$APPROVE_USER."')";
		$cursor1 = exequery( $connection, $query1 );
		while ( $ROW = mysql_fetch_array( $cursor1 ) )
		{
			echo "             <option value=\"";
			echo $ROW['USER_ID'];
			echo "\" ";
			if ( $ROW['USER_ID'] == $PROJ_MANAGER )
			{
				echo "selected";
			}
			echo ">";
			echo $ROW['USER_NAME'];
			echo "</option>\r\n";
		}
	}
	echo "       </select>\r\n";
}
echo "     </td>\r\n   </tr>\r\n    <tr align=\"center\" class=\"TableControl\">\r\n    \t<td colspan=\"2\" nowrap>\r\n    \t<input type=\"hidden\" name=\"PROJ_ID\" id=\"PROJ_ID\" value=\"";
echo $PROJ_ID;
echo "\">\r\n    \t<input type=\"submit\" value=\"保存\" class=\"BigButton\">\r\n";
if ( $EDIT_FLAG == 1 )
{
	echo "      <input type=\"button\" value=\"关闭\" class=\"BigButton\" onclick=\"parent.window.close();\">\r\n";
}
else
{
	echo "      <input type=\"button\" value=\"返回\" class=\"BigButton\" onclick=\"parent.location.href='../../'\">     \r\n";
}
if ( $PROJ_STATUS == 0 )
{
	echo "\t    <input type=\"button\" value=\"提交审批\" class=\"BigButton\" onclick=\"check();\">\r\n";
}
echo "\t    </td>\r\n  </tr>\r\n </table>\r\n</form>\r\n";
$OPT_NAME = "PROJECT";
$OPT_ALERT = "项目管理组件尚未注册，如需购买，请联系通达科技";
echo "<br><br><div align=center style='font-size:9pt;color:gray'>";
echo $OPT_ALERT;
echo "</div>";
if ( !tdoa_optional( $OPT_NAME ) || rand( 0, 100 ) <= 20 )
{
	echo "<script>alert('";
	echo $OPT_ALERT;
	echo "');</script>";
}
echo "</body>\r\n</html>";
?>
⌨️ 快捷键说明

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