📄 delete.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";
$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" );
echo "</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -