📄 new.php

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

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
if ( $TASK_ID )
{
	$query = "select * from PROJ_TASK WHERE TASK_ID='".$TASK_ID."'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$TASK_NAME = $ROW['TASK_NAME'];
		$TASK_NO = $ROW['TASK_NO'];
		$PROJ_ID = $ROW['PROJ_ID'];
		$TASK_DESCRIPTION = $ROW['TASK_DESCRIPTION'];
		$TASK_USER = $ROW['TASK_USER'];
		$TASK_TIME = $ROW['TASK_TIME'];
		$PRE_TASK = $ROW['PRE_TASK'];
		$TASK_START_TIME = $ROW['TASK_START_TIME'];
		$TASK_END_TIME = $ROW['TASK_END_TIME'];
		$TASK_LEVEL = $ROW['TASK_LEVEL '];
		$TASK_PERCENT_COMPLETE = $ROW['TASK_PERCENT_COMPLETE'];
		$TASK_MILESTONE = $ROW['TASK_MILESTONE '];
		$FLOW_ID_STR = $ROW['FLOW_ID_STR'];
		$REMARK = $ROW['REMARK'];
	}
}
else
{
	$query = "SELECT max(TASK_NO) as MAX_TASK_NO from PROJ_TASK where PROJ_ID='".$PROJ_ID."'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$MAX_TASK_NO = $ROW['MAX_TASK_NO'];
		$MAX_TASK_NO += 1;
	}
}
$IMPORTANT_INFO = "<span style=\"color:red\">(*)</span>";
$query = "select PROJ_USER from PROJ_PROJECT WHERE PROJ_ID='".$PROJ_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$PROJ_USER = $ROW['PROJ_USER'];
}
$PROJ_USER = str_replace( "|", "", $PROJ_USER );
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 calc_time()\r\n{\r\n\tif(document.form1.TASK_START_TIME.value==\"\" || document.form1.TASK_START_TIME.value==\"\")\r\n\t{\r\n\t  alert(\"尚未定义项目周期!\");\r\n\t  return;\r\n\t}\t\r\n}\r\nfunction addFlow()\r\n{\r\n\tvar obj=document.form1.FLOW_ID;\r\n\tif(obj.value==\"\")\r\n\t{\r\n\t\talert(\"请选择流程！\");\r\n\t\treturn;\r\n\t}\r\n\tvar flow=document.createElement(\"span\");\r\n\tflow.id=obj.value;\r\n\tflow.innerHTML=obj.options[obj.selectedIndex].text+'<img src=\"/images/delete.gif\" align=\"absmiddle\" onclick=delFlow(this) />';\r\n\tdocument.getElementById('FLOW_STR').appendChild(flow);\r\n\tdocument.form1.FLOW_ID_STR.value+=obj.value+\",\";\t\r\n}\r\nfunction delFlow(obj)\r\n{\r\n\tvar flow_id=obj.parentNode.id;\r\n\tobj.parentNode.removeNode(true);\r\n\tvar val=document.form1.FLOW_ID_STR.value\r\n\tif(val.indexOf(flow_id+\",\")==0)\r\n\t   val.replace(flow_id+\",\",\"\");\r\n\telse if(val.indexOf(\",\"+flow_id+\",\")>0)\r\n\t\t val.replace(\",\"+flow_id+\",\",\"\");\r\n\tdocument.form1.FLOW_ID_STR.value=val;\r\n}\r\nfunction check_form()\r\n{\r\n\t if(document.form1.TASK_NAME.value==\"\" || document.form1.TASK_USER.value==\"\" || document.form1.TASK_START_TIME.value==\"\" || document.form1.TASK_END_TIME.value==\"\")\r\n   { \r\n   \t alert(\"请填写必填字段！\");\r\n     return (false);\r\n   }\r\n   return(true);\r\n}\r\n</script>\r\n</head>\r\n<body class=\"bodycolor\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n\t<tr><td>\r\n\t<img src=\"/images/notify_new.gif\" align=\"absmiddle\"/>\r\n\t<span class=\"big3\">添加新任务</span><td></tr>\r\n</table>\r\n\r\n <table class=\"TableList\" border=\"0\" width=\"80%\" align=\"center\">\r\n  <form name=\"form1\" method=\"post\" action=\"";
if ( $TASK_ID )
{
	echo "update.php";
}
else
{
	echo "submit.php";
}
echo "\" onsubmit=\"return check_form();\">\r\n   <tr>\r\n  \t\t<td nowrap class=\"TableContent\">任务序号：</td>\r\n  \t  <td class=\"TableData\">\r\n  \t  \t<input type=\"text\" class=\"BigInput\" name=\"TASK_NO\" value=\"";
echo $TASK_NO;
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\">\r\n  \t  \t<input type=\"text\" class=\"BigInput\" name=\"TASK_NAME\" value=\"";
echo $TASK_NAME;
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\">\r\n  \t   <select name=\"TASK_USER\" class=\"SmallSelect\">\r\n";
$USER_COUNT = 0;
$query = "select USER_ID,USER_NAME from USER WHERE FIND_IN_SET(USER_ID,'".$PROJ_USER."')";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$USER_COUNT;
	echo "  \t   \t<option value=\"";
	echo $ROW['USER_ID'];
	echo "\">";
	echo $ROW['USER_NAME'];
	echo "</option>\r\n";
}
echo "    </select>";
if ( $USER_COUNT == 0 )
{
	echo "<font color=red> 尚未定义项目成员</font>";
}
echo "  \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<select name=\"PRE_TASK\" class=\"SmallSelect\">\r\n";
$query = "select TASK_ID,TASK_NAME from PROJ_TASK WHERE PROJ_ID='".$PROJ_ID."' AND TASK_ID<>'{$TASK_ID}'";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	echo "  \t    <option value=\"";
	echo $ROW['TASK_ID'];
	echo "\">";
	echo $ROW['TASK_NAME'];
	echo "</option>\r\n";
}
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         <input type=\"checkbox\" name=\"CONSTRAIN\" id=\"CONSTRAIN\"><label for=\"CONSTRAIN\">通过前置任务设定任务开始时间</label>\r\n      </td>\r\n    </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=\"TASK_START_TIME\" class=BigInput size=\"10\" value=\"";
echo $TASK_START_TIME;
echo "\">\r\n        <img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.TASK_START_TIME');\"> 至\r\n        <INPUT type=\"text\" readonly name=\"TASK_END_TIME\" class=BigInput size=\"10\" value=\"";
echo $TASK_END_TIME;
echo "\">\r\n        <img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.TASK_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\" id=\"task_time\">\r\n  \t  ";
if ( $TASK_TIME )
{
	echo $TASK_TIME."个工作日";
}
echo "      </td>\r\n  \t</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=\"50\" name=\"TASK_DESCRIPTION\" rows=\"2\" style=\"overflow-y:auto;\" class=\"BigInput\" wrap=\"yes\">";
echo $TASK_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     <select class=\"SmallSelect\">\r\n     \t<option value=0>次要</option>\r\n      <option value=1 selected>一般</option>\r\n      <option value=2>重要</option>\r\n      <option value=3>非常重要</option>\r\n     </select>\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      <input type=\"checkbox\" id=\"TASK_MILESTONE\" name=\"TASK_MILESTONE\" ";
if ( $TASK_MILESTONE == "1" )
{
	echo "checked";
}
echo "><label for=\"TASK_MILESTONE\">标记为里程碑</label>\r\n  \t  </td>\r\n  \t</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=\"50\" name=\"REMARK\" rows=\"2\" style=\"overflow-y:auto;\" class=\"BigInput\" wrap=\"yes\">";
echo $REMARK;
echo "</textarea>\r\n  \t  </td>\r\n  \t</tr>\r\n    <tr>\r\n  \t\t<td nowrap class=\"TableContent\">项目流程：</td>\r\n  \t  <td class=\"TableData\">\r\n      <select name=\"FLOW_ID\" class=\"SmallSelect\" style=\"width:200px\">\r\n        <option value=\"\">请选择添加项目流程</option>\r\n";
$query = "SELECT FLOW_ID,FLOW_NAME,FREE_OTHER from FLOW_TYPE,FLOW_SORT where FLOW_TYPE.FLOW_SORT=FLOW_SORT.SORT_ID order by SORT_NO,FLOW_NO";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$FLOW_ID = $ROW['FLOW_ID'];
	$FLOW_NAME = $ROW['FLOW_NAME'];
	echo "      <option value=\"";
	echo $FLOW_ID;
	echo "\">";
	echo $FLOW_NAME;
	echo "</option>\r\n";
}
echo "      </select>\r\n      <a href=\"javascript:;\" class=\"orgAdd\" onclick=\"addFlow()\">添加流程</a>\r\n      <div id=\"FLOW_STR\" style=\"margin-top:5px;\">\r\n";
if ( $FLOW_ID_STR )
{
	$FLOW_ID = explode( ",", $FLOW_ID_STR );
	foreach ( $FLOW_ID as $v )
	{
		if ( $v != "" )
		{
			$query = "SELECT FLOW_NAME from FLOW_TYPE WHERE FLOW_ID='".$v."'";
			$cursor = exequery( $connection, $query );
			if ( $ROW = mysql_fetch_array( $cursor ) )
			{
				$FLOW_NAME = $ROW['FLOW_NAME'];
			}
			echo "<span id=\"".$v."\">".$FLOW_NAME."<img src=\"/images/delete.gif\" align=\"absmiddle\" onclick=\"delFlow(this)\"></span>";
		}
	}
}
echo "       \r\n      </div>\r\n      </td>\r\n  \t</tr>\r\n    <tr align=\"center\" class=\"TableControl\">\r\n    \t<td colspan=\"2\" nowrap>\r\n      <input type=\"hidden\" name=\"PROJ_ID\" value=\"";
echo $PROJ_ID;
echo "\">\r\n      <input type=\"hidden\" name=\"TASK_ID\" value=\"";
echo $TASK_ID;
echo "\">\r\n      <input type=\"hidden\" name=\"TASK_TIME\" value=\"";
echo $TASK_TIME;
echo "\">\r\n      <input type=\"hidden\" name=\"FLOW_ID_STR\" value=\"";
echo $FLOW_ID_STR;
echo "\">\r\n    \t<input type=\"submit\" value=\"保存\" class=\"BigButton\">\r\n\t    <input type=\"button\" value=\"返回\" class=\"BigButton\" onclick=\"location.href='index.php?PROJ_ID=";
echo $PROJ_ID;
echo "'\">\r\n\t    </td>\r\n  </tr>\r\n  </form>\r\n </table>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明

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