📄 send.php
字号:
<?php
include_once( "inc/auth.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\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'];
}
$query1 = "SELECT USER_ID,USER_NAME from USER";
$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 ) )
{
$I = 1;
for ( ; $I <= 50; ++$I )
{
$STR = "S".$I;
$$STR = format_money( $ROW["{$STR}"] );
}
$OPERATION = 2;
$query = "select * from SAL_ITEM";
$cursor = exequery( $connection, $query );
$ITEM_COUNT = 0;
while ( $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 (FROM_ID,TO_ID,TO_ID2,COPY_TO_ID,SUBJECT,CONTENT,SEND_TIME,ATTACHMENT_ID,ATTACHMENT_NAME,READ_FLAG,SEND_FLAG,DELETE_FLAG,IMPORTANT)\r\n SELECT '".$LOGIN_USER_ID."' as FROM_ID,USER_ID as TO_ID, USER_ID as TO_ID2,'' as COPY_TO_ID ,'{$SUBJECT}' as SUBJECT,'{$CONTENT}' as CONTENT,'{$SEND_TIME}' as SEND_TIME,'' as ATTACHMENT_ID,'' as ATTACHMENT_NAME,'0' as READ_FLAG,'1' as SEND_FLAG,'0' as DELETE_FLAG,'0' as IMPORTANT\r\n from USER where USER_ID='{$USERID}' and NOT_LOGIN='0'";
exequery( $connection, $query );
}
}
$query = "update SAL_FLOW set ISSEND='1' where FLOW_ID='".$FLOW_ID."'";
exequery( $connection, $query );
header( "location: index.php" );
echo "</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -