📄 new.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.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\"><script src=\"/inc/js/module.js\"></script>\r\n<script Language=\"JavaScript\">\r\nfunction CheckForm()\r\n{\r\n if(document.form1.TRAIN_ID.value==\"\")\r\n { \r\n \t alert(\"培训课程编号不能为空！\");\r\n return (false);\r\n }\r\n \r\n if(document.form1.TRAIN_TYPE.value!=1)\r\n {\r\n \t if(document.form1.TO_ID.value==\"\"&&document.form1.PRIV_ID.value==\"\"&&document.form1.COPY_TO_ID.value==\"\"&&document.form1.TO_ID3.value==\"\")\r\n {\r\n \t alert(\"请指定发布范围！\");\r\n return (false);\r\n }\r\n }\r\n \r\n return (true);\r\n}\r\n\r\nfunction check_train_id(gotoURL)\r\n{\r\n\t var myvalue=form1.TRAIN_ID.value;\r\n if(myvalue==\"\")\r\n { \r\n \t alert(\"请填写培训课程编号！\");\r\n return (false);\r\n }\r\n else\r\n {\r\n var open_url = gotoURL + \"?TRAIN_ID=\" + myvalue;\r\n\t window.open(open_url,'','status=0,directories=0,resizable=0,toolbar=0,location=0,scrollbars=0,width=322,height=200');\r\n }\r\n}\r\n\r\nfunction sendForm()\r\n{\r\n if(CheckForm())\r\n document.form1.submit();\r\n}\r\n\r\nfunction SelChange()\r\n{\r\n if(document.form1.YORN.value==\"1\")\r\n document.getElementById(\"select_option\").style.display=\"\";\r\n else\r\n \t document.getElementById(\"select_option\").style.display=\"none\";\r\n}\r\n</script>\r\n\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\" onload=\"javascript:form1.TRAIN_ID.focus();\">\r\n";
if ( $TRAINING_ID != "" )
{
$query = "SELECT * from TRAIN_NEWCOURSE where TRAINING_ID=".$TRAINING_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$TRAINING_ID = $ROW['TRAINING_ID'];
$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'];
$MANAGER = $ROW['MANAGER'];
$EMAIL_CONTENT = $ROW['EMAIL_CONTENT'];
$MUST_LEARNER = $ROW['MUST_LEARNER'];
$BEGIN_TIME = $ROW['BEGIN_TIME'];
if ( $BEGIN_TIME == "0000-00-00 00:00:00" )
{
$BEGIN_TIME = "";
}
$REGB_TIME = $ROW['REGB_TIME'];
if ( $REGB_TIME == "0000-00-00 00:00:00" )
{
$REGB_TIME = "";
}
$REGE_TIME = $ROW['REGE_TIME'];
if ( $REGE_TIME == "0000-00-00 00:00:00" )
{
$REGE_TIME = "";
}
$END_TIME = $ROW['END_TIME'];
if ( $END_TIME == "0000-00-00 00:00:00" )
{
$END_TIME = "";
}
$TU_DEPT = $ROW['TU_DEPT'];
if ( $TU_DEPT != "" )
{
$query1 = "SELECT * from DEPARTMENT where DEPT_ID=".$TU_DEPT;
$cursor1 = exequery( $connection, $query1 );
if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$TU_DEPT_FIELD_DESC = $ROW1['DEPT_NAME'];
}
}
$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'];
}
$query = "select * from DEPARTMENT";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$DEPT_ID = $ROW['DEPT_ID'];
$DEPT_NAME = $ROW['DEPT_NAME'];
if ( find_id( $TO_ID, $DEPT_ID ) )
{
$TO_NAME .= $DEPT_NAME.",";
}
}
if ( $TO_ID == "ALL_DEPT" )
{
$TO_NAME = "全体部门";
}
$TOK = strtok( $PRIV_ID, "," );
while ( $TOK != "" )
{
$query1 = "SELECT * from USER_PRIV where USER_PRIV='".$TOK."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$PRIV_NAME .= $ROW['PRIV_NAME'].",";
}
$TOK = strtok( "," );
}
$TOK = strtok( $USER_ID, "," );
while ( $TOK != "" )
{
$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( "," );
}
$TOK = strtok( $MUST_LEARNER, "," );
while ( $TOK != "" )
{
$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 border=\"0\" width=\"90%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/notify_new.gif\" align=\"absmiddle\"><span class=\"big3\"> 新建培训课程</span>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<table class=\"TableBlock\" width=\"85%\" align=\"center\">\r\n <form enctype=\"multipart/form-data\" action=\"add.php\" method=\"post\" name=\"form1\">\r\n <tr>\r\n <td nowrap class=\"TableData\"> 培训课程编号：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"TRAIN_ID\" size=\"10\" maxlength=\"200\" class=\"BigInput\" value=\"";
echo $TRAIN_ID;
echo "\">\r\n <input type=\"button\" value=\"检查编号\" class=\"BigButton\" onclick=\"check_train_id('check_train_id.php');\"> \r\n </td>\r\n <td nowrap class=\"TableData\"> 培训课程名称：</td>\r\n <td class=\"TableData\">\r\n \t <select name=\"TCOURSE_ID\" class=\"BigSelect\">\r\n \t \t <option value=\"\" ";
if ( $TCOURSE_ID == "" )
{
echo "selected";
}
echo ">请选择</option>\r\n";
$query = "SELECT * from TRAIN_COURSES";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$COURSE_ID = $ROW['COURSE_ID'];
$COURSE_NAME = $ROW['COURSE_NAME'];
echo " <option value=\"";
echo $COURSE_ID;
echo "\" ";
if ( $TCOURSE_ID == $COURSE_ID )
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -