📄 add.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
include_once( "inc/utility_sms1.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\">\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
if ( $TRAINING_ID == "" )
{
$query = "select * from TRAIN_NEWCOURSE where TRAIN_ID='".$TRAIN_ID."'";
}
else
{
$query = "select * from TRAIN_NEWCOURSE where TRAINING_ID != '".$TRAINING_ID."' and TRAIN_ID='{$TRAIN_ID}'";
}
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
message( "错误", "培训课程编号 ".$TRAIN_ID." 已存在" );
echo "\r\n<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='new.php?TRAIN_ID=";
echo $TRAIN_ID;
echo "&TO_ID=";
echo $TO_ID;
echo "&TO_NAME=";
echo $TO_NAME;
echo "&TCOURSE_NO=";
echo $TCOURSE_NO;
echo "&NUMBER=";
echo $NUMBER;
echo "&ADDRESS=";
echo $ADDRESS;
echo "'\">\r\n</div>\r\n";
exit( );
}
if ( $BEGIN_TIME != "" )
{
$TIME_OK = is_date_time( $BEGIN_TIME );
if ( !$TIME_OK )
{
message( "错误", "开课时间格式不对，应形如 1999-1-2 12:12:12" );
echo "\r\n<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='new.php?TRAIN_ID=";
echo $TRAIN_ID;
echo "&TO_ID=";
echo $TO_ID;
echo "&TO_NAME=";
echo $TO_NAME;
echo "&TCOURSE_NO=";
echo $TCOURSE_NO;
echo "&NUMBER=";
echo $NUMBER;
echo "&ADDRESS=";
echo $ADDRESS;
echo "'\">\r\n</div>\r\n\r\n";
exit( );
}
}
if ( $END_TIME != "" )
{
$TIME_OK = is_date_time( $END_TIME );
if ( !$TIME_OK )
{
message( "错误", "开课时间格式不对，应形如 1999-1-2 12:12:12" );
echo "\r\n<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='new.php?TRAIN_ID=";
echo $TRAIN_ID;
echo "&TO_ID=";
echo $TO_ID;
echo "&TO_NAME=";
echo $TO_NAME;
echo "&TCOURSE_NO=";
echo $TCOURSE_NO;
echo "&NUMBER=";
echo $NUMBER;
echo "&ADDRESS=";
echo $ADDRESS;
echo "'\">\r\n</div>\r\n\r\n";
exit( );
}
}
if ( $REGB_TIME != "" )
{
$TIME_OK = is_date_time( $REGB_TIME );
if ( !$TIME_OK )
{
message( "错误", "发布时间格式不对，应形如 1999-1-2 12:12:12" );
echo "\r\n<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='new.php?TRAIN_ID=";
echo $TRAIN_ID;
echo "&TO_ID=";
echo $TO_ID;
echo "&TO_NAME=";
echo $TO_NAME;
echo "&TCOURSE_NO=";
echo $TCOURSE_NO;
echo "&NUMBER=";
echo $NUMBER;
echo "&ADDRESS=";
echo $ADDRESS;
echo "'\">\r\n</div>\r\n";
exit( );
}
}
if ( $REGE_TIME != "" )
{
$TIME_OK = is_date_time( $REGE_TIME );
if ( !$TIME_OK )
{
message( "错误", "发布时间格式不对，应形如 1999-1-2 12:12:12" );
echo "\r\n<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='new.php?TRAIN_ID=";
echo $TRAIN_ID;
echo "&TO_ID=";
echo $TO_ID;
echo "&TO_NAME=";
echo $TO_NAME;
echo "&TCOURSE_NO=";
echo $TCOURSE_NO;
echo "&NUMBER=";
echo $NUMBER;
echo "&ADDRESS=";
echo $ADDRESS;
echo "'\">\r\n</div>\r\n\r\n";
exit( );
}
}
$query_name = "select * from TRAIN_COURSES where COURSE_ID='".$TCOURSE_ID."'";
$cursor_name = exequery( $connection, $query_name );
if ( $ROW = mysql_fetch_array( $cursor_name ) )
{
$COURSE_TYPE = $ROW['COURSE_TYPE'];
$COURSE_NAME = $ROW['COURSE_NAME'];
}
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
if ( $TRAINING_ID == "" )
{
$query = "insert into TRAIN_NEWCOURSE(TRAIN_ID,TCOURSE_ID,INOUTCOURCE,NUMBER,TRAIN_TEACHER,TRAIN_TYPE,YORN,SEND_TIME,BEGIN_TIME,REGB_TIME,REGE_TIME,ADDRESS,DESCRIPTION,PREREQUISITE,RESUME,TO_ID,PRIV_ID,USER_ID,NEW_TIME,NEW_USER_ID,END_TIME,EMAIL_CONTENT,TRAIN_CTYPE,MUST_LEARNER)\r\n values ('".$TRAIN_ID."','{$TCOURSE_ID}','{$INOUTCOURCE}','{$NUMBER}','{$TRAIN_TEACHER}','{$TRAIN_TYPE}','{$YORN}','{$CUR_TIME}','{$BEGIN_TIME}','{$REGB_TIME}','{$REGE_TIME}','{$ADDRESS}','{$DESCRIPTION}','{$PREREQUISITE}','{$RESUME}','{$TO_ID}','{$PRIV_ID}','{$COPY_TO_ID}','{$CUR_TIME}','{$LOGIN_USER_ID}','{$END_TIME}','{$EMAIL_CONTENT}','{$COURSE_TYPE}','{$TO_ID3}')";
exequery( $connection, $query );
$TRAINING_ID1 = mysql_insert_id( );
save_field_data( "TRAIN_NEWCOURSE", $TRAINING_ID1, $_POST );
if ( $TO_ID3 != "" )
{
$TO_ID3_ARRAY = explode( ",", $TO_ID3 );
$TO_ID3_ARRAY_NUM = sizeof( $TO_ID3_ARRAY );
if ( $TO_ID3_ARRAY[$TO_ID3_ARRAY_NUM - 1] == "" )
{
--$TO_ID3_ARRAY_NUM;
}
$I = 0;
for ( ; do
{
$I < $TO_ID3_ARRAY_NUM; ++$I, )
{
$query = "insert into TRAIN_APPLY(APPLY_TID,APPLY_REASON,APPLY_MANAGER,APPLY_TIME,APPLYER,APPLY_STATUS,APPLY_COURSE_NAEM,APPLY_TYPE,EXEMPT_FLAG) values ('".$TRAINING_ID1."','必修','{$LOGIN_USER_ID}','{$CUR_TIME}','{$TO_ID3_ARRAY[$I]}','1','{$COURSE_NAME}','2','0')";
exequery( $connection, $query );
break;
}
} while ( 1 );
}
}
else
{
$query = "select * from TRAIN_NEWCOURSE where TRAINING_ID='".$TRAINING_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$MUST_LEARNER1 = $ROW['MUST_LEARNER'];
}
$query = "update TRAIN_NEWCOURSE set TRAIN_ID='".$TRAIN_ID."',TCOURSE_ID='{$TCOURSE_ID}',INOUTCOURCE='{$INOUTCOURCE}',TRAIN_CTYPE='{$COURSE_TYPE}',MUST_LEARNER='{$TO_ID3}',\r\n NUMBER='{$NUMBER}',TRAIN_TEACHER='{$TRAIN_TEACHER}',TRAIN_TYPE='{$TRAIN_TYPE}',YORN='{$YORN}',SEND_TIME='{$CUR_TIME}',EMAIL_CONTENT='{$EMAIL_CONTENT}',\r\n BEGIN_TIME='{$BEGIN_TIME}',REGB_TIME='{$REGB_TIME}',REGE_TIME='{$REGE_TIME}',ADDRESS='{$ADDRESS}',DESCRIPTION='{$DESCRIPTION}',END_TIME='{$END_TIME}',\r\n PREREQUISITE='{$PREREQUISITE}',RESUME='{$RESUME}',TO_ID='{$TO_ID}',PRIV_ID='{$PRIV_ID}',USER_ID='{$COPY_TO_ID}',UPDATE_TIME='{$CUR_TIME}',UPDATE_USER_ID='{$LOGIN_USER_ID}'\r\n where TRAINING_ID='{$TRAINING_ID}'";
exequery( $connection, $query );
save_field_data( "TRAIN_NEWCOURSE", $TRAINING_ID, $_POST );
$TO_ID3_ARRAY = explode( ",", $TO_ID3 );
$TO_ID3_ARRAY_NUM = sizeof( $TO_ID3_ARRAY );
if ( $TO_ID3_ARRAY[$TO_ID3_ARRAY_NUM - 1] == "" )
{
--$TO_ID3_ARRAY_NUM;
}
$I = 0;
for ( ; $I < $TO_ID3_ARRAY_NUM; ++$I )
{
if ( !find_id( $MUST_LEARNER1, $TO_ID3_ARRAY[$I] ) )
{
$query = "insert into TRAIN_APPLY(APPLY_TID,APPLY_REASON,APPLY_MANAGER,APPLY_TIME,APPLYER,APPLY_STATUS,APPLY_COURSE_NAEM,APPLY_TYPE,EXEMPT_FLAG) values ('".$TRAINING_ID."','必修','{$LOGIN_USER_ID}','{$CUR_TIME}','{$TO_ID3_ARRAY[$I]}','1','{$COURSE_NAME}','2','0')";
exequery( $connection, $query );
}
}
$MUST_ARRAY = explode( ",", $MUST_LEARNER1 );
$MUST_ARRAY_NUM = sizeof( $MUST_ARRAY );
if ( $MUST_ARRAY[$MUST_ARRAY_NUM - 1] == "" )
{
--$MUST_ARRAY_NUM;
}
$I = 0;
for ( ; $I < $MUST_ARRAY_NUM; ++$I )
{
if ( !find_id( $TO_ID3, $MUST_ARRAY[$I] ) )
{
$query = "delete from TRAIN_APPLY where APPLY_TID='".$TRAINING_ID."' and APPLYER='{$MUST_ARRAY[$I]}'";
exequery( $connection, $query );
}
}
}
$query_name = "select USER_NAME, HRMS.EMAIL from USER, HRMS where USER.USER_ID = '".$LOGIN_USER_ID."' and HRMS.USER_ID = USER.USER_ID";
$cursor_name = exequery( $connection, $query_name );
if ( $ROW = mysql_fetch_array( $cursor_name ) )
{
$USER_NAME = $ROW['USER_NAME'];
$FORM_EMAIL = $ROW['EMAIL'];
}
if ( $TO_ID == "ALL_DEPT" )
{
$query = "select HRMS.EMAIL,USER.USER_ID from HRMS,USER where HRMS.USER_ID = USER.USER_ID and USER.NOT_LOGIN!='1'";
}
else
{
$query = "select HRMS.EMAIL,USER.USER_ID from HRMS,USER where USER.NOT_LOGIN!='1' and HRMS.USER_ID = USER.USER_ID and (find_in_set(USER.DEPT_ID,'".$TO_ID."') or find_in_set(USER.USER_PRIV,'{$PRIV_ID}') or find_in_set(USER.USER_ID,'{$COPY_TO_ID}'))";
}
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
if ( $ROW['USER_ID'] != $LOGIN_USER_ID )
{
$USER_ID_STR .= $ROW['USER_ID'].",";
if ( $ROW['EMAIL'] != "" )
{
$TO_EMAIL_STR .= $ROW['EMAIL'].",";
}
}
}
if ( $TO_ID3 != "" )
{
$USER_NAME2 = "";
$TOK = strtok( $TO_ID3, "," );
while ( $TOK != "" )
{
$query1 = "SELECT HRMS.EMAIL,USER.USER_NAME from HRMS,USER where USER.USER_ID='".$TOK."' and HRMS.USER_ID = USER.USER_ID";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$TO_ID3_EMAIL .= $ROW1['EMAIL'].",";
$USER_NAME2 .= $ROW1['USER_NAME'].",";
}
$TOK = strtok( "," );
}
$USER_ID_STR .= $TO_ID3;
$TO_EMAIL_STR .= $TO_ID3_EMAIL;
}
$USER_NAME2 = substr( $USER_NAME2, 0, -1 );
if ( $USER_NAME2 != "" )
{
$USER_NAME2 = "。必修人员是：".$USER_NAME2;
}
$SMS_CONTENT = "请查看培训课程通知！\n培训课程：".$COURSE_NAME.$USER_NAME2;
if ( $SMS_REMIND == "on" )
{
send_sms( "", $LOGIN_USER_ID, $USER_ID_STR, 30, $SMS_CONTENT, $REMIND_URL );
}
$SMS_CONTENT = "培训通知,来自".$USER_NAME."，培训课程：".$COURSE_NAME.$USER_NAME2;
if ( $SMS2_REMIND == "on" )
{
send_mobile_sms_user( "", $LOGIN_USER_ID, $USER_ID_STR, $SMS_CONTENT, 30 );
}
$EMAIL_CONTENT = "培训课程:".$COURSE_NAME."。".$EMAIL_CONTENT.$USER_NAME2;
$MAIL_TITLE = "培训课程通知";
if ( $MAIL_REMIND == "on" && $FORM_EMAIL != "" && $TO_EMAIL_STR != "" )
{
$query = "SELECT * from WEBMAIL where EMAIL='".$FORM_EMAIL."' and USER_ID='{$LOGIN_USER_ID}'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$SMTP_SERVER = $ROW['SMTP_SERVER'];
}
$MYRETURN = @fsockopen( $SMTP_SERVER, 25, &$errno, &$errstr, 30 );
if ( !$MYRETURN )
{
message( "提示", "操作成功。但邮件发送失败,请检查网络" );
button_back( );
exit( );
}
fclose( $MYRETURN );
send_email( $LOGIN_USER_ID, $FORM_EMAIL, $TO_EMAIL_STR, $EMAIL_CONTENT, $MAIL_TITLE );
}
else
{
if ( $MAIL_REMIND == "on" )
{
message( "提示", "邮件发送失败。原因：发件人的“人事档案”中没有设置邮箱，并需在“Internet 邮件”中对该邮箱的进行正确配置；或者所有收件人的人事档案中没有设置邮箱" );
button_back( );
exit( );
}
}
header( "location: index1.php" );
echo "</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -