📄 delete_attach.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。

💻 PHP

字号:

<?php

function get_url( $f_id )
{
	global $connection;
	$sql = "select SORT_PARENT, SORT_NAME from file_sort where SORT_ID=".$f_id;
	$cursor = exequery( $connection, $sql );
	if ( $row = mysql_fetch_row( $cursor ) )
	{
		$sort_parent = $row[0];
		$sort_name = $row[1];
	}
	if ( $sort_parent != "" )
	{
		$file_url .= get_url( $sort_parent )."/".$sort_name;
	}
	return $file_url;
}

include_once( "inc/auth.php" );
include_once( "inc/conn.php" );
include_once( "inc/utility_all.php" );
ob_start( );
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";
if ( $_REQUEST['FILE_SORT'] == "2" )
{
	$type = "个人文件柜";
}
if ( $_REQUEST['FILE_SORT'] == "1" )
{
	$type = "公共文件柜";
}
$CONTENT_ID = $_REQUEST['CONTENT_ID'];
$ATTACHMENT_ID = $_REQUEST['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $_REQUEST['ATTACHMENT_NAME'];
$ATTACHMENT_NAME = iconv( "UTF-8", "GB2312", $ATTACHMENT_NAME );
$s_id = $_REQUEST['SORT_ID'];
$connection = openconnection( );
$query = "select * from FILE_CONTENT where CONTENT_ID={$CONTENT_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$ATTACHMENT_ID_OLD = ",".$ROW['ATTACHMENT_ID'];
	$ATTACHMENT_NAME_OLD = "*".$ROW['ATTACHMENT_NAME'];
}
if ( $ATTACHMENT_ID != "" )
{
	delete_attach( $ATTACHMENT_ID, $ATTACHMENT_NAME );
	$ATTACHMENT_ID = ",".$ATTACHMENT_ID.",";
	$ATTACHMENT_ID = str_replace( $ATTACHMENT_ID, ",", $ATTACHMENT_ID_OLD );
	$ATTACHMENT_ID = substr( $ATTACHMENT_ID, 1 );
	$a_name = $ATTACHMENT_NAME;
	$ATTACHMENT_NAME = "*".$ATTACHMENT_NAME."*";
	$ATTACHMENT_NAME = str_replace( $ATTACHMENT_NAME, "*", $ATTACHMENT_NAME_OLD );
	$ATTACHMENT_NAME = substr( $ATTACHMENT_NAME, 1 );
	$query = "update FILE_CONTENT set ATTACHMENT_ID='{$ATTACHMENT_ID}',ATTACHMENT_NAME='{$ATTACHMENT_NAME}' where CONTENT_ID={$CONTENT_ID}";
	exequery( $connection, $query );
}
$query2 = "select SUBJECT from file_content where CONTENT_ID=".$CONTENT_ID;
$cursor2 = exequery( $connection, $query2 );
if ( $row2 = mysql_fetch_row( $cursor2 ) )
{
	$subject = $row2[0];
}
$attachment_url = get_url( $s_id )."/".$subject;
$sql_u = "select USER_NAME from user where USER_ID='".$_SESSION['LOGIN_USER_ID']."'";
$cursor_u = exequery( $connection, $sql_u );
if ( $row_u = mysql_fetch_row( $cursor_u ) )
{
	$user_name_u = $row_u[0];
}
$handle = fopen( "../../../../logs/document_all_log.txt", "a" );
fwrite( $handle, "[".date( "Y-m-d H:i:s" )."]  用户名:".$_SESSION['LOGIN_USER_ID']."(".$user_name_u.")  附件名:".$a_name."     归属文件名路径:".$type."/".$attachment_url."  \r\n" );
echo "\r\n</body>\r\n</html>";
?>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -