📄 email_result.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/utility_sms1.php" );
include_once( "inc/utility_sms2.php" );
if ( $fld_str == "" )
{
$query = "SELECT ITEM_ID from SAL_ITEM";
$cursor = exequery( $connection, $query );
$FLOW_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$STYLE = $STYLE.$ROW['ITEM_ID'].",";
}
}
else
{
$STYLE = $fld_str;
}
$query = "SELECT CONTENT from SAL_FLOW where FLOW_ID='".$FLOW_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$CONTENT = $ROW['CONTENT'];
}
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";
$SEND_TIME = date( "Y-m-d H:i:s", time( ) );
$query = "select CONTENT from SAL_FLOW where FLOW_ID=".$FLOW_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$SUBJECT = $ROW['CONTENT'];
}
if ( $COPY_TO_ID != "" )
{
$COPY_TO_ID = "'".str_replace( ",", "','", substr( $COPY_TO_ID, 0, -1 ) )."'";
$WHERE_STR .= " where USER_ID in (".$COPY_TO_ID.")";
}
$query1 = "SELECT USER_ID,USER_NAME from USER ".$WHERE_STR;
$cursor1 = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$USERID = $ROW['USER_ID'];
$USERNAME = $ROW['USER_NAME'];
$query = "select * from SAL_DATA where FLOW_ID=".$FLOW_ID." and USER_ID='{$USERID}'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$STYLE_ARRAY = explode( ",", $STYLE );
$ARRAY_COUNT = sizeof( $STYLE_ARRAY );
$COUNT = 0;
if ( $STYLE_ARRAY[$ARRAY_COUNT - 1] == "" )
{
--$ARRAY_COUNT;
}
$I = 0;
for ( ; $I < $ARRAY_COUNT; ++$I )
{
$STR = "S".$STYLE_ARRAY[$I];
$$STR = format_money( $ROW["{$STR}"] );
}
$OPERATION = 2;
$STYLE_ARRAY = explode( ",", $STYLE );
$ARRAY_COUNT = sizeof( $STYLE_ARRAY );
$COUNT = 0;
if ( $STYLE_ARRAY[$ARRAY_COUNT - 1] == "" )
{
--$ARRAY_COUNT;
}
$ITEM_COUNT = 0;
$I = 0;
for ( ; $I < $ARRAY_COUNT; ++$I )
{
$query = "select ITEM_ID,ITEM_NAME from SAL_ITEM where ITEM_ID='".$STYLE_ARRAY[$I]."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
++$ITEM_COUNT;
$ITEM_ID = $ROW['ITEM_ID'];
$ITEM_NAME = $ROW['ITEM_NAME'];
$S_ID = "S".$ITEM_ID;
$S_NAME = $S_ID."_NAME";
if ( $ITEM_COUNT == 1 )
{
$CONTENT = "<br><div align=center><table border=0 cellspacing=1 width=250 class=small bgcolor=#000000 cellpadding=3>";
}
$CONTENT .= "<tr class=TableData><td nowrap align=center width=110>".$ITEM_NAME."</td><td nowrap align=center>".$$S_ID."</td></tr>";
}
}
if ( 0 < $ITEM_COUNT )
{
$CONTENT .= "<thead class=TableHeader><td nowrap align=center>工资项目</td><td nowrap align=center>金额</td></thead></table></div>";
}
$query = "INSERT\r\n INTO EMAIL_BODY (FROM_ID,TO_ID2,COPY_TO_ID,SUBJECT,CONTENT,SEND_TIME,ATTACHMENT_ID,ATTACHMENT_NAME,SEND_FLAG,IMPORTANT)\r\n SELECT '".$LOGIN_USER_ID."' as FROM_ID,'{$USERID},' as TO_ID2,'' as COPY_TO_ID ,'{$SUBJECT}' as SUBJECT,'{$CONTENT}' as CONTENT,'{$SEND_TIME}' as SEND_TIME,'' as ATTACHMENT_ID,'' as ATTACHMENT_NAME,'1' as SEND_FLAG,'0' as IMPORTANT\r\n from USER where USER_ID='{$USERID}' and NOT_LOGIN='0'";
exequery( $connection, $query );
$BODY_ID = mysql_insert_id( );
$query = "INSERT INTO EMAIL(TO_ID,READ_FLAG,DELETE_FLAG,BOX_ID,BODY_ID) values('".$USERID."','0','0','0','{$BODY_ID}')";
exequery( $connection, $query );
$ROW_ID = mysql_insert_id( );
$SMS_CONTENT = "请查收邮件！\n主题：".csubstr( $SUBJECT, 0, 100 );
send_sms( "", $LOGIN_USER_ID, $USERID, 2, $SMS_CONTENT, $REMIND_URL );
}
}
header( "location: index.php" );
echo "</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -