📄 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";
$query = "SELECT * from FLOW_TYPE where FLOW_ID=".$FLOW_ID;
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$SORT_ID = $ROW['FLOW_SORT'];
}
$query = "SELECT * from FLOW_RUN where FLOW_ID=".$FLOW_ID;
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$RUN_ID = $ROW['RUN_ID'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
if ( $ATTACHMENT_NAME != "" )
{
$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
$I = 0;
for ( ; $I < $ARRAY_COUNT; ++$I )
{
if ( $ATTACHMENT_ID_ARRAY[$I] != "" )
{
delete_attach( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
}
}
}
$query1 = "select * from FLOW_RUN_FEEDBACK where RUN_ID=".$RUN_ID;
$cursor1 = exequery( $connection, $query1 );
$ATTACHMENT_NAME = "";
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
if ( !( $ATTACHMENT_NAME != "" ) )
{
continue;
}
$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
$I = 0;
for ( ; $I < $ARRAY_COUNT; ++$I )
{
if ( $ATTACHMENT_ID_ARRAY[$I] != "" )
{
delete_attach( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
}
}
}
$query = "delete from FLOW_RUN_FEEDBACK where RUN_ID=".$RUN_ID;
exequery( $connection, $query );
$query = "delete from FLOW_RUN_DATA where RUN_ID=".$RUN_ID;
exequery( $connection, $query );
$query = "delete from FLOW_RUN_PRCS where RUN_ID=".$RUN_ID;
exequery( $connection, $query );
}
$query = "delete from FLOW_RUN where FLOW_ID=".$FLOW_ID;
exequery( $connection, $query );
$query = "delete from FLOW_TYPE where FLOW_ID=".$FLOW_ID;
exequery( $connection, $query );
$query = "delete from FLOW_PROCESS where FLOW_ID=".$FLOW_ID;
exequery( $connection, $query );
echo "\r\n<script>\r\n parent.sort.location.reload();\r\n location=\"list.php?SORT_ID=";
echo $SORT_ID;
echo "\";\r\n</script>\r\n\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -