📄 delete.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">
<?
$connection=OpenConnection();
$query="select * from SAL_FLOW where FLOW_ID=$FLOW_ID";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$BEGIN_DATE=$ROW["BEGIN_DATE"];
$CONTENT=$ROW["CONTENT"];
$SMS_CONTENT="请进行工资上报！\n备注：".csubstr($CONTENT,0,100);
}
$query="delete from SAL_FLOW where FLOW_ID=$FLOW_ID";
exequery($connection,$query);
$query="delete from SAL_DATA where FLOW_ID=$FLOW_ID";
exequery($connection,$query);
$query="delete from SMS where FROM_ID='$LOGIN_USER_ID' and to_days(SEND_TIME)=to_days('$BEGIN_DATE') and CONTENT='$SMS_CONTENT' and SMS_TYPE='4'";
exequery($connection,$query);
header("location: index.php");
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -