📄 send.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<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;
}
else
{
continue;
}
$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($ITEM_COUNT>0)
$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);
}
$query="update SAL_FLOW set ISSEND='1' where FLOW_ID='$FLOW_ID'";
exequery($connection,$query);
header("location: index.php");
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -