email_result.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 120 行
PHP
120 行
<?
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 '
<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'];
}
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;
}
for ($I = 0; ($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;
for ($I = 0; ($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>'));
continue;
}
}
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_BODY (FROM_ID,TO_ID2,COPY_TO_ID,SUBJECT,CONTENT,SEND_TIME,ATTACHMENT_ID,ATTACHMENT_NAME,SEND_FLAG,IMPORTANT)
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
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 = ('请查收邮件！
主题：'.csubstr ($SUBJECT, 0, 100));
send_sms ('', $LOGIN_USER_ID, $USERID, 2, $SMS_CONTENT, $REMIND_URL);
continue;
}
}
header ('location: index.php');
echo '</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?