📄 send.php
字号:
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
echo '
<html>
<head>
<title>终止工资上报流程</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
$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))
{
for ($I = 1; ($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
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)
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
from USER where USER_ID=\'').$USERID).'\' and NOT_LOGIN=\'0\'');
exequery ($connection, $query);
continue;
}
}
$query = (((''.'update SAL_FLOW set ISSEND=\'1\' where FLOW_ID=\'').$FLOW_ID).'\'');
exequery ($connection, $query);
header ('location: index.php');
echo '</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -