📄 add_muster_submit.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_sms1.php" );
include_once( "inc/utility_all.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";
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
$query1 = "SELECT * from TRAIN_APPOINT_MUSTER where APPOINT_USER_ID='".$LOGIN_USER_ID."' and TRAINING_ID='{$APPLY_TID}'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$APPOINT_MUSTER1 = $ROW['APPOINT_MUSTER'];
$query = "update TRAIN_APPOINT_MUSTER set APPOINT_MUSTER='".$COPY_TO_ID."' where APPOINT_USER_ID='{$LOGIN_USER_ID}' and TRAINING_ID='{$APPLY_TID}'";
exequery( $connection, $query );
$COPY_TO_ID_ARRAY = explode( ",", $COPY_TO_ID );
$COPY_TO_ID_ARRAY_NUM = sizeof( $COPY_TO_ID_ARRAY );
if ( $COPY_TO_ID_ARRAY[$COPY_TO_ID_ARRAY_NUM - 1] == "" )
{
--$COPY_TO_ID_ARRAY_NUM;
}
$I = 0;
for ( ; $I < $COPY_TO_ID_ARRAY_NUM; ++$I )
{
if ( !find_id( $APPOINT_MUSTER1, $COPY_TO_ID_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 ('".$APPLY_TID."','必修','{$LOGIN_USER_ID}','{$CUR_TIME}','{$COPY_TO_ID_ARRAY[$I]}','1','{$COURSE_NAME}','2','0')";
exequery( $connection, $query );
}
}
$APPOINT_ARRAY = explode( ",", $APPOINT_MUSTER1 );
$APPOINT_ARRAY_NUM = sizeof( $APPOINT_ARRAY );
if ( $APPOINT_ARRAY[$APPOINT_ARRAY_NUM - 1] == "" )
{
--$APPOINT_ARRAY_NUM;
}
$I = 0;
for ( ; do
{
$I < $APPOINT_ARRAY_NUM; ++$I )
{
if ( !find_id( $COPY_TO_ID, $APPOINT_ARRAY[$I] ) )
{
$query = "delete from TRAIN_APPLY where APPLY_TID='".$APPLY_TID."' and APPLYER='{$APPOINT_ARRAY[$I]}'";
exequery( $connection, $query );
}
break;
}
} while ( 1 );
}
else
{
$query = "insert into TRAIN_APPOINT_MUSTER (TRAINING_ID,APPOINT_USER_ID,APPOINT_MUSTER) values ('".$APPLY_TID."','{$LOGIN_USER_ID}','{$COPY_TO_ID}')";
exequery( $connection, $query );
if ( $COPY_TO_ID != "" )
{
$COPY_TO_ID_ARRAY = explode( ",", $COPY_TO_ID );
$COPY_TO_ID_ARRAY_NUM = sizeof( $COPY_TO_ID_ARRAY );
if ( $COPY_TO_ID_ARRAY[$COPY_TO_ID_ARRAY_NUM - 1] == "" )
{
--$COPY_TO_ID_ARRAY_NUM;
}
$I = 0;
for ( ; $I < $COPY_TO_ID_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 ('".$APPLY_TID."','必修','{$LOGIN_USER_ID}','{$CUR_TIME}','{$COPY_TO_ID_ARRAY[$I]}','1','{$COURSE_NAME}','2','0')";
exequery( $connection, $query );
}
}
}
$query1 = "SELECT * from TRAIN_APPOINT_MUSTER where APPOINT_USER_ID='".$LOGIN_USER_ID."' and TRAINING_ID='{$APPLY_TID}'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$APPOINT_MUSTER = $ROW['APPOINT_MUSTER'];
}
$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'];
}
$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.USER_ID,'".$APPOINT_MUSTER."')";
$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'].",";
}
}
}
$SMS_CONTENT = $USER_NAME."要求你必须参加《".$COURSE_NAME."》培训。";
if ( $SMS_REMIND == "on" )
{
send_sms( "", $LOGIN_USER_ID, $USER_ID_STR, 30, $SMS_CONTENT, $REMIND_URL );
}
if ( $SMS2_REMIND == "on" )
{
send_mobile_sms_user( "", $LOGIN_USER_ID, $USER_ID_STR, $SMS_CONTENT, 30 );
}
$EMAIL_CONTENT = $USER_NAME."要求你必须参加《".$COURSE_NAME."》培训。".$EMAIL_CONTENT1;
$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 );
}
message( "提示", "操作成功" );
echo "<script>\r\n opener.location.reload();\r\n</script>\r\n<br>\r\n<center>\r\n\t<input type=\"button\" class=\"BigButton\" value=\"关闭\" onClick=\"window.close();\" title=\"关闭窗口\">\r\n</center>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -