📄 submit_exempt.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<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\" align=\"center\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/notify_new.gif\" HEIGHT=\"20\" align=\"absmiddle\"><span class=\"big3\"> 免修申请</span>\r\n </td>\r\n </tr>\r\n</table>\r\n<br>\r\n";
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
$query = "update TRAIN_APPLY set EXEMPT_FLAG='2' where APPLY_ID='".$APPLY_ID."'";
exequery( $connection, $query );
$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."','{$APPLY_REASON}','{$APPLY_MANAGER}','{$CUR_TIME}','{$LOGIN_USER_ID}','0','{$COURSE_NAME}','0','1')";
exequery( $connection, $query );
$ROW_ID = mysql_insert_id( );
$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_name = "select EMAIL from HRMS where USER_ID = '".$APPLY_MANAGER."'";
$cursor_name = exequery( $connection, $query_name );
if ( $ROW = mysql_fetch_array( $cursor_name ) )
{
$TO_EMAIL_STR = $ROW['EMAIL'];
}
$SMS_CONTENT = $USER_NAME."向您提交《".$COURSE_NAME."》的免修申请，请批示";
if ( $SMS_REMIND == "on" && $APPLY_MANAGER != "" )
{
send_sms( "", $LOGIN_USER_ID, $APPLY_MANAGER, 31, $SMS_CONTENT, $REMIND_URL );
}
if ( $SMS2_REMIND == "on" && $APPLY_MANAGER != "" )
{
send_mobile_sms_user( "", $LOGIN_USER_ID, $APPLY_MANAGER, $SMS_CONTENT, 31 );
}
$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, $SMS_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 + -