📄 train_detail.php

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

include_once( "inc/auth.php" );
include_once( "inc/utility_field.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<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n  <tr>\r\n    <td class=\"Big\"><img src=\"/images/menu/training.gif\" width=\"17\" height=\"17\"><span class=\"big3\"> 培训课程详细信息</span><br>\r\n    </td>\r\n  </tr>\r\n</table>\r\n\r\n";
$query = "SELECT * from TRAIN_NEWCOURSE where TRAINING_ID='".$TRAINING_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$TRAIN_ID = $ROW['TRAIN_ID'];
	$TCOURSE_ID = $ROW['TCOURSE_ID'];
	$INOUTCOURCE = $ROW['INOUTCOURCE'];
	$NUMBER = $ROW['NUMBER'];
	$TRAIN_TEACHER = $ROW['TRAIN_TEACHER'];
	$TRAIN_TYPE = $ROW['TRAIN_TYPE'];
	$YORN = $ROW['YORN'];
	$SEND_TIME = $ROW['SEND_TIME'];
	$BEGIN_TIME = $ROW['BEGIN_TIME'];
	$REGB_TIME = $ROW['REGB_TIME'];
	$REGE_TIME = $ROW['REGE_TIME'];
	$NEW_TIME = $ROW['NEW_TIME'];
	$UPDATE_TIME = $ROW['UPDATE_TIME'];
	$NEW_USER_ID = $ROW['NEW_USER_ID'];
	$ADDRESS = $ROW['ADDRESS'];
	$DESCRIPTION = $ROW['DESCRIPTION'];
	$PREREQUISITE = $ROW['PREREQUISITE'];
	$RESUME = $ROW['RESUME'];
	$TO_ID = $ROW['TO_ID'];
	$PRIV_ID = $ROW['PRIV_ID'];
	$USER_ID = $ROW['USER_ID'];
	$END_TIME = $ROW['END_TIME'];
	$MUST_LEARNER = $ROW['MUST_LEARNER'];
	$query1 = "SELECT * from TRAIN_COURSES where COURSE_ID='".$TCOURSE_ID."'";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
	{
		$COURSE_NAME = $ROW1['COURSE_NAME'];
	}
	$query1 = "SELECT * from TRAIN_TTYPE where TYPE_ID='".$TRAIN_TYPE."'";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
	{
		$TYPE_NAME = $ROW1['TYPE_NAME'];
	}
	$query1 = "SELECT * from TRAIN_TEACHERS where TEACHER_ID='".$TRAIN_TEACHER."'";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
	{
		$TEACHER_NAME = $ROW1['TEACHER_NAME'];
	}
	$TO_DEPT = "";
	if ( $TO_ID == "ALL_DEPT" )
	{
		$TO_DEPT = "全体部门";
	}
	else
	{
		$TO_DEPT = "";
		$TOK = strtok( $TO_ID, "," );
		while ( $TOK != "" )
		{
			if ( $TO_DEPT != "" )
			{
				$TO_DEPT .= "，";
			}
			$query1 = "select * from DEPARTMENT where DEPT_ID='".$TOK."'";
			$cursor1 = exequery( $connection, $query1 );
			if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
			{
				$TO_DEPT .= $ROW1['DEPT_NAME'];
			}
			$TOK = strtok( "," );
		}
	}
	$PRIV_NAME = "";
	$TOK = strtok( $PRIV_ID, "," );
	while ( $TOK != "" )
	{
		if ( $PRIV_NAME != "" )
		{
			$PRIV_NAME .= "，";
		}
		$query1 = "SELECT * from USER_PRIV where USER_PRIV='".$TOK."'";
		$cursor1 = exequery( $connection, $query1 );
		if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
		{
			$PRIV_NAME .= $ROW1['PRIV_NAME'];
		}
		$TOK = strtok( "," );
	}
	$USER_NAME = "";
	$TOK = strtok( $USER_ID, "," );
	while ( $TOK != "" )
	{
		if ( $USER_NAME != "" )
		{
			$USER_NAME .= "，";
		}
		$query1 = "SELECT * from USER where USER_ID='".$TOK."'";
		$cursor1 = exequery( $connection, $query1 );
		if ( $ROW = mysql_fetch_array( $cursor1 ) )
		{
			$USER_NAME .= $ROW['USER_NAME'];
		}
		$TOK = strtok( "," );
	}
	$USER_NAME1 = "";
	$TOK = strtok( $MUST_LEARNER, "," );
	while ( $TOK != "" )
	{
		if ( $USER_NAME1 != "" )
		{
			$USER_NAME1 .= "，";
		}
		$query1 = "SELECT * from USER where USER_ID='".$TOK."'";
		$cursor1 = exequery( $connection, $query1 );
		if ( $ROW = mysql_fetch_array( $cursor1 ) )
		{
			$USER_NAME1 .= $ROW['USER_NAME'];
		}
		$TOK = strtok( "," );
	}
	echo "<table class=\"TableBlock\" width=\"100%\">\r\n  <tr class=\"TableLine1\">\r\n      <td nowrap align=\"left\" width=\"110\" class=\"TableContent\">培训课程编号：</td>\r\n      <td nowrap align=\"left\" class=\"TableData\">";
	echo $TRAIN_ID;
	echo "</td>\r\n      <td nowrap align=\"left\" width=\"110\" class=\"TableContent\">培训课程名称：</td>\r\n      <td nowrap align=\"left\" class=\"TableData\">";
	echo $COURSE_NAME;
	echo "</td>\r\n  </tr>\r\n  <tr class=\"TableLine2\">\r\n      <td nowrap align=\"left\" width=\"110\" class=\"TableContent\">内(外)部课程：</td>\r\n      <td nowrap align=\"left\" class=\"TableData\">";
	if ( $INOUTCOURCE == "0" )
	{
		echo "内部课程";
	}
	else if ( $INOUTCOURCE == "1" )
	{
		echo "外部课程";
	}
	echo "</td>\r\n      <td nowrap align=\"left\" width=\"110\" class=\"TableContent\">是否审批：</td>\r\n      <td nowrap align=\"left\" class=\"TableData\">";
	if ( $YORN == "0" )
	{
		echo "不需要审批";
	}
	else if ( $YORN == "1" )
	{
		echo "需要审批";
	}
	echo "</td>\r\n  </tr>\r\n  <tr class=\"TableLine1\">\r\n      <td nowrap align=\"left\" width=\"110\" class=\"TableContent\">培训类别：</td>\r\n      <td nowrap align=\"left\" class=\"TableData\">";
	echo $TYPE_NAME;
	echo "</td>\r\n      <td nowrap align=\"left\" width=\"110\" class=\"TableContent\">培训讲师：</td>\r\n      <td nowrap align=\"left\" class=\"TableData\">";
	echo $TEACHER_NAME;
	echo "</td>\r\n  </tr>\r\n  <tr class=\"TableLine2\">\r\n      <td nowrap align=\"left\" width=\"110\" class=\"TableContent\">限额人数：</td>\r\n      <td align=\"left\" class=\"TableData\">";
	echo $NUMBER;
	echo "</td>\r\n      <td nowrap align=\"left\" width=\"110\" class=\"TableContent\">发布时间：</td>\r\n      <td nowrap align=\"left\" class=\"TableData\">";
	echo $SEND_TIME;
	echo "</td>\r\n  </tr>\r\n  <tr class=\"TableLine1\">\r\n      <td nowrap align=\"left\" width=\"110\" class=\"TableContent\">开课时间：</td>\r\n      <td nowrap align=\"left\" class=\"TableData\">";
	echo $BEGIN_TIME;
	echo "</td>\r\n      <td nowrap align=\"left\" width=\"110\" class=\"TableContent\">结课时间：</td>\r\n      <td nowrap align=\"left\" class=\"TableData\">";
	echo $END_TIME;
	echo "</td>\r\n  </tr>\r\n  <tr class=\"TableLine2\">\r\n      <td nowrap align=\"left\" width=\"110\" class=\"TableContent\">开始报名时间：</td>\r\n      <td nowrap align=\"left\" class=\"TableData\">";
	echo $REGB_TIME;
	echo "</td>\r\n      <td nowrap align=\"left\" width=\"110\" class=\"TableContent\">结束报名时间：</td>\r\n      <td nowrap align=\"left\" class=\"TableData\">";
	echo $REGE_TIME;
	echo "</td>\r\n  </tr>\r\n  <tr class=\"TableLine2\">\r\n      <td nowrap align=\"left\" width=\"110\" class=\"TableContent\">发布范围（部门）：</td>\r\n      <td align=\"left\" class=\"TableData\" colspan=\"3\">";
	echo $TO_DEPT;
	echo "</td>\r\n  </tr>\r\n  <tr class=\"TableLine2\">\r\n      <td nowrap align=\"left\" width=\"110\" class=\"TableContent\">发布范围（角色）：</td>\r\n      <td align=\"left\" class=\"TableData\"  colspan=\"3\">";
	echo $PRIV_NAME;
	echo "</td>\r\n  </tr>\r\n  <tr class=\"TableLine2\">\r\n      <td nowrap align=\"left\" width=\"110\" class=\"TableContent\">发布范围（人员)：</td>\r\n      <td align=\"left\" class=\"TableData\"  colspan=\"3\">";
	echo $USER_NAME;
	echo "</td>\r\n  </tr>\r\n  <tr class=\"TableLine2\">\r\n      <td nowrap align=\"left\" width=\"110\" class=\"TableContent\">必修人员(为新建培训课程时指定)：</td>\r\n      <td align=\"left\" class=\"TableData\"  colspan=\"3\">";
	echo $USER_NAME1;
	echo "</td>\r\n  </tr>\r\n  <tr class=\"TableLine1\">\r\n      <td nowrap align=\"left\" width=\"110\" class=\"TableContent\">授课地点：</td>\r\n      <td nowrap align=\"left\" class=\"TableData\" colspan=\"3\">";
	echo $ADDRESS;
	echo "</td>\r\n  </tr>\r\n  <tr class=\"TableLine2\">\r\n      <td nowrap align=\"left\" width=\"110\" class=\"TableContent\">课程描述：</td>\r\n      <td align=\"left\" class=\"TableData\"  colspan=\"3\">";
	echo $DESCRIPTION;
	echo "</td>\r\n  </tr>\r\n  <tr class=\"TableLine2\">\r\n      <td nowrap align=\"left\" width=\"110\" class=\"TableContent\">培训条件：</td>\r\n      <td nowrap align=\"left\" class=\"TableData\" colspan=\"3\">";
	echo $PREREQUISITE;
	echo "</td>\r\n  </tr>\r\n  <tr class=\"TableLine2\">\r\n      <td nowrap align=\"left\" width=\"110\" class=\"TableContent\">备注：</td>\r\n      <td nowrap align=\"left\" class=\"TableData\" colspan=\"3\">";
	echo $RESUME;
	echo "</td>\r\n  </tr>\r\n  <tr>\r\n      <td class=\"TableData\" colspan=\"4\">\r\n        ";
	echo get_field_table( get_field_text( "TRAIN_NEWCOURSE", $TRAINING_ID ) );
	echo "      </td>\r\n  </tr>\r\n  <tr align=\"center\" class=\"TableControl\">\r\n      <td colspan=\"4\">\r\n        <input type=\"button\" value=\"打印\" class=\"BigButton\" onclick=\"document.execCommand('Print');\" title=\"直接打印表格页面\">&nbsp;&nbsp;&nbsp;&nbsp;\r\n        <input type=\"button\" value=\"关闭\" class=\"BigButton\" onClick=\"window.close();\" title=\"关闭窗口\">\r\n      </td>\r\n  </tr>\r\n</table>\r\n";
}
else
{
	message( "", "未找到相应记录！" );
}
echo "</body>\r\n\r\n</html>\r\n";
?>
💿 文件大小 17584 K
👤 上传用户 Rosa_
📂 所属分类 OA系统
🏷️ 相关标签

#2008 #Anywhere #20081216 #Office
⌨️ 快捷键说明

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